select

date_trunc('{{date_range}}',timestamp) as date,

token_contract,

symbol,

avg(price_usd) as price_usd

from flow.core.fact_prices

where timestamp >= {{start_date}} and timestamp <= {{end_date}}

and symbol = 'FLOW'

group by 1,2,3

select * from flow_prices