count(distinct case when x.event_resource='Mint' then x.event_data:index:value end) as nft_mints,

count(distinct case when xx.event_resource='TransferEvent' then xx.event_data:to end) as minter,

SUM(case when y.event_resource='DepositEvent' then y.event_data:amount/pow(10,8) end) AS sales_volume

FROM aptos.core.fact_events x

join aptos.core.fact_events xx on x.tx_hash=xx.tx_hash

join aptos.core.fact_events y on x.tx_hash=y.tx_hash

where date_trunc('day',x.block_timestamp)>'2025-01-01' and x.event_resource='Mint' and x.event_module='collection' and xx.event_resource='TransferEvent' and y.event_resource='DepositEvent'

and x.event_data:collection='0x7b4cd01cc85280139fbf2a11dd929a073febeba767d74904d0c691d68b74f321'