drone-mostafaEasy 2 NFT
    Updated 2023-05-06
    SELECT
    PROJECT_NAME as PLATFORM_NAME,
    --date_trunc ('week',BLOCK_TIMESTAMP) as date,

    count (DISTINCT TX_HASH) as TXN,
    count (DISTINCT BUYER_ADDRESS) as Buyer,
    count (DISTINCT SELLER_ADDRESS) as Seller,

    sum (PRICE_USD) as USD,
    avg (PRICE_USD) as AVG_USD,
    Median (PRICE_USD) as Median_USD,

    sum (TOTAL_FEES_USD) as Total_fee,
    sum (CREATOR_FEE_USD) as Creator_fee,
    sum (PLATFORM_FEE_USD) as Platform_fee

    FROM ethereum.core.ez_nft_sales
    WHERE EVENT_TYPE = 'sale'
    and BLOCK_TIMESTAMP >= current_date -30
    and PROJECT_NAME IS NOT NULL
    GROUP BY 1 ORDER BY TXN DESC limit 5


    Run a query to Download Data