mehrancrypto-dxoepqUntitled Query
    Updated 2022-10-06
    select
    date_trunc('day',block_timestamp) as date,
    platform_name,
    count (distinct tx_hash) as Sales,
    count (distinct buyer_address) as Buyers,
    count (distinct seller_address) as Sellers,
    sum (price_usd) as Sales_Volume,
    sum (creator_fee_usd) as Royalty_Fee,
    sum (creator_fee_usd) / sum(price_usd) * 100 as Average_Creator_Fee_Ratio,
    sum (Royalty_Fee) over (partition by platform_name order by date) as cumulative_royalty_fee
    from ethereum.core.ez_nft_sales
    where platform_name in ('opensea','looksrare','x2y2','rarible')
    and creator_fee_usd >0
    and date >= '2022-01-01'
    group by 1,2
    order by Royalty_Fee desc
    Run a query to Download Data