SELECT
platform_name as marketplace,
-- sum(price_usd) as total_volume,
-- avg(price_usd) as avg_volume
-- count(distinct(tx_hash)) as total_sales,
-- count(distinct(buyer_address)) as total_users,
-- sum(creator_fee_usd) as total_creator_fee,
avg(creator_fee_usd) as avg_creator_fee
-- div0(total_volume,total_creator_fee) *100 as pct_creator_fee,
-- count(distinct(NFT_ADDRESS)) as project_count
FROM ethereum.core.ez_nft_sales
WHERE block_timestamp > '2021-01-01'
GROUP BY 1