date_trunc('day', block_timestamp) as day,

platform_name,

count(DISTINCT tx_hash) as sales,

sum(PRICE_USD) as sales_volume

FROM ethereum.core.ez_nft_sales

WHERE block_timestamp > '2021-01-01'

GROUP BY 1,2