date_trunc('day', block_timestamp) as day,

count(DISTINCT tx_id) as events,

count(DISTINCT PURCHASER) as buyers,

sum(SALES_AMOUNT) as volume_sol,

median(SALES_AMOUNT) as median_price

FROM solana.nft.fact_nft_sales

WHERE tree_authority LIKE 'Fzz2B5ULu26Yxy1pdqhtTs2VoCxZq6zU1F8AY4cMnDQj'

GROUP BY 1