Hello,
First timer here. I apologize if i am not asking question the right way.

I am trying to build a scan query such to compare close price of two different AggregationPeriod. For example, compare 61.8 of 3 year weekly and 1 year daily. I want to select stocks that closed within 1% price difference.

When I try my query, i get "Secondary period not allowed: " error.

sqlcode 

Hello, First timer here. I apologize if i am not asking question the right way. I am trying to build a scan query such to compare close price of two different AggregationPeriod. For example, compare 61.8 of 3 year weekly and 1 year daily. I want to select stocks that closed within 1% price difference. When I try my query, i get "Secondary period not allowed: " error.

You can't use secondary aggregations in scans.