MLDZMNfbba18
    Updated 2023-02-22
    select --2022-10-19 launch of blur
    date_trunc('day',BLOCK_TIMESTAMP) as date,
    PLATFORM_NAME as marketplaces,
    count(distinct tx_hash) as sale_no,
    count(distinct BUYER_ADDRESS) as buyer_no,
    count(distinct seller_ADDRESS) as seller_no,
    count(distinct TOKENID) as no_NFTs,
    count(distinct PROJECT_NAME) as no_collections,
    sum(PRICE_USD) as volume_usd,
    sum(CREATOR_FEE_USD) as volume_royalty,
    avg(CREATOR_FEE_USD) as avg_royalty,
    avg(PRICE_USD) as average_volume,
    Median(PRICE_USD) as median_volume,
    avg(average_volume) OVER (ORDER BY date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days,
    sum(buyer_no) over (order by date) as cum_buyers,
    sum(sale_no) over (order by date) as cum_sale,
    sum(volume_usd) over (order by date) as cum_volume
    from ethereum.core.ez_nft_sales
    where PRICE_USD::float > 0
    and date>='2023-02-14' --after airdrop
    and price>0
    group by 1,2

    Run a query to Download Data