tx_hash,

block_timestamp,

seller_address,

buyer_address,

platform_name,

nft_address,

token_id,

price,

price_usd,

platform_name as marketplace

from near.nft.ez_nft_sales

where block_timestamp::date >= '2025-01-01'

marketplace,

count(distinct tx_hash) as transactions,

count(distinct seller_address) as sellers,

count(distinct buyer_address) as buyers,

count(distinct nft_address) as collections,

sum(price) as volume,

avg(price) as avg_volume,

sum(price_usd) as volume_usd,

avg(price_usd) as avg_price_usd,

transactions / count(distinct block_timestamp::date) as daily_average_transactions,

sellers / count(distinct block_timestamp::date) as daily_average_sellers,

buyers / count(distinct block_timestamp::date) as daily_average_buyers,

transactions / buyers as txns_per_buyer

from t

group by 1