trunc(y.block_timestamp,'month') as date,

y.event_data:type as asset,

count(distinct y.tx_id) as nft_sales,

sum(y.event_data:amount) as volume,

sum(volume) over (order by date) as total_volume,

avg(y.event_data:amount) as avg_nft_price

from flow.core.fact_events x join flow.core.fact_events y on x.tx_id=y.tx_id

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

and x.event_data:name='NBAsage Yes' and y.event_type='Deposited' and y.event_data:to<>'0xf919ee77447b7497' and y.event_data:amount is not null

group by 1,2 order by 1 desc