select event_contract, contract_name from flow.core.dim_contract_labels

select date(block_timestamp) as day, count(distinct nft_id) as nfts_count, count(distinct buyer) as total_wallets, sum(price) as total_sales_volume

from flow.core.fact_nft_sales a join symbol b on a.currency = b.event_contract

where tx_succeeded = True and nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

group by day order by day desc