SELECT date(TIMESTAMP) as date, avg(PRICE_USD) as p

from flow.core.fact_prices

where SYMBOL = 'FLOW'

and date(TIMESTAMP) >= '2022-05-09'

GROUP BY date

SELECT date(s.BLOCK_TIMESTAMP) as date,

sum(case when CURRENCY = 'A.1654653399040a61.FlowToken' then PRICE * fp.p else PRICE end) as vol

FROM flow.core.fact_nft_sales s

left join flow_price fp on fp.date = date(s.BLOCK_TIMESTAMP)

where date(s.BLOCK_TIMESTAMP) >= '2022-05-09'

and TX_SUCCEEDED = TRUE

GROUP BY date(s.BLOCK_TIMESTAMP)