date(block_timestamp) as date,

count(DISTINCT tx_id) as total_transaction,

sum(total_transaction) over (order by date asc) as cumulative_transaction,

count(DISTINCT buyer) as total_buyer,

sum(total_buyer) over (order by date asc) as cumulative_buyer,

count(DISTINCT seller) as total_seller,

sum(total_seller) over (order by date asc) as cumulative_seller,

sum(price) as volume,

sum(volume) over (order by date asc) as cumulative_volume,

avg(price) as avg_price,

sum(avg_price) over (order by date asc) as cumulative_avg_price

FROM flow.nft.ez_nft_sales

WHERE NFT_COLLECTION LIKE '%RaceDay%'

and date >= '2024-01-01'

GROUP BY date