date(block_timestamp) as date,

count(*) as sales,

count(DISTINCT buyer_address) as buyers,

sum(price_usd) as volume_usd,

median(price) as median_price_eth,

median(price_usd) as median_price_usd

FROM ethereum.nft.ez_nft_sales

where nft_address like lower('0xed5af388653567af2f388e6224dc7c4b3241c544')

and block_timestamp > '2024-01-01'

and price_usd > 100

GROUP BY 1

ORDER by 1 DESC