trunc(block_timestamp,'month') as date,

count(distinct tx_id) as nft_sales,

sum(nft_sales) over (order by date) as total_nft_sales,

count(distinct event_data:nftID) as distinct_nfts_purchased,

sum(distinct_nfts_purchased) over (order by date) as total_unique_nft_purchased,

count(distinct event_data:NFTReceiver) as nft_buyers

from flow.core.fact_events

where block_timestamp>'2024-01-01' and tx_succeeded='TRUE' and event_contract='A.7d09be7121e058eb.NBAsageNFT' and event_type='NFTPurchased'

and event_data:name='NBAsage Yes'

group by 1 order by 1 desc