date_trunc('day', block_timestamp) as day,

CASE WHEN CREATOR_FEE_USD = 0 THEN '0% creator fee'

ELSE 'creator fee' END as sales_type,

count(DISTINCT tx_hash) as sales,

sum(price_usd) as volume

FROM ethereum.core.ez_nft_sales

WHERE block_timestamp > '2022-01-01'

GROUP BY 1,2