date_trunc('day', block_timestamp) as days,

player,

count(DISTINCT seller) as sales,

count(DISTINCT buyer) as buyers,

sum(price) as volume,

sum(volume) over (ORDER BY days) as total_volume

FROM flow.core.ez_nft_sales a

JOIN flow.core.dim_topshot_metadata b on a.nft_id=b.nft_id

WHERE block_timestamp>=current_date-30

GROUP BY 1,2