count(DISTINCT seller) as sellers2 , sum(volume) over (order by date) as cum_vol, sum(buyers) over (order by date) as cum_buyers, sum(sellers2) over (order by date) as cum_sellers,

sum(txs) over (order by date) as cum_tx

from flow.core.ez_nft_sales

WHERE NFT_COLLECTION = 'A.329feb3ab062d289.RaceDay_NFT'

and currency in ('A.ead892083b3e2c6c.DapperUtilityCoin', 'A.3c5959b568896393.FUSD')

and BLOCK_TIMESTAMP::date >= '2022-05-01'

GROUP by 1

order by 1 )

SELECT datediff('day', min(date) , max(date) ) as days, datediff('week', min(date) , max(date) ) as weeks,

datediff('month', min(date) , max(date) ) as months, sum(txs)/days, sum(buyers)/days, sum(sellers2)/days, sum(volume)/days,

sum(volume)/weeks, sum(volume)/months

from datas