nft.block_timestamp::date as tx_date,

nft.tx_hash as transaction,

nft.from_address as seller,

nft.to_address as buyers,

nft.contract_address as nft_contract,

nft.token_id as token_id,

nft.name as nft_name,

nft.origin_function_signature as nft_signature,

tr.value_precise as nft_price,

tr.tx_fee_precise as tx_fee

FROM core.nft.ez_nft_transfers nft

JOIN core.core.fact_transactions tr

on transaction = tr.tx_hash

and nft_signature = tr.origin_function_signature

ORDER by 1 DESC

date_trunc('day',tx_date) as tx_date,

count(DISTINCT transaction) as nft_transactions,

count(DISTINCT seller) as sellers,

count(DISTINCT buyers) as buyer,

count(DISTINCT nft_contract) as n_nft_contracts,

avg(nft_price) as avg_nft_price,

sum(nft_price) as nft_volume,

sum(count(DISTINCT transaction)) over (order by date_trunc('day',tx_date)) as cum_nft_transaction,

sum(count(DISTINCT seller)) over (order by date_trunc('day',tx_date)) as cum_sellers,

sum(count(DISTINCT buyers)) over (order by date_trunc('day',tx_date)) as cum_buyers,

sum(sum(nft_price)) over (ORDER BY date_trunc('day',tx_date)) as cum_nft_volume

FROM nft_table

where tx_date >= '2024-01-01'

group by 1

order by 1 DESC