date_trunc('day', block_timestamp) as day,

PLATFORM_NAME,

count(DISTINCT tx_hash) as sales,

COUNT(DISTINCT BUYER_ADDRESS) as buyers,

sum(PRICE_USD) as sales_volume,

median(PRICE_USD) as median_price

FROM ethereum.core.ez_nft_sales

WHERE nft_address LIKE lower('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')

GROUP BY 1,2