SELECT block_timestamp::DATE AS date

, SUM(CASE

WHEN currency = 'A.ead892083b3e2c6c.DapperUtilityCoin' THEN price

WHEN currency = 'A.1654653399040a61.FlowToken'

THEN price * (SELECT AVG(p.price_usd)

FROM flow.core.fact_prices p

WHERE p.timestamp::date = n.block_timestamp::date

AND asset_id = '4558')

END) AS vol_usd

FROM flow.core.fact_nft_sales n

WHERE nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

GROUP BY 1

SELECT s1.date, s1.vol_usd, SUM(s2.vol_usd) AS cumulative

FROM sales s1 JOIN sales s2 ON s1.date >= s2.date

GROUP BY 1, 2