Ranjit-YadavNFT royalty comparission 3
    Updated 2022-10-06
    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
    Run a query to Download Data