flipside

    General view
    Flipside TeamGeneral view
    Updated 2024-09-12
    -- forked from MLDZMN / General view @ https://flipsidecrypto.xyz/MLDZMN/q/cLC01cdAnvS4/general-view

    --- First recorded date 2017-06-23 21:05:06.000
    --- First recorded block for NFT sale 3919706
    --- First recorded price 2020-05-05 aacording to price tables: before than "Price USD" is null


    select
    count(distinct tx_hash) as "Sales",
    count(distinct BUYER_ADDRESS) as "Buyers",
    count(distinct SELLER_ADDRESS) as "Sellers",
    count(distinct PROJECT_NAME) as "Collections",
    count(distinct TOKENID) as "Sold NFTs",
    round(sum(price_usd), 3) as "Volume USD",
    round(sum(CREATOR_FEE_USD), 3) as "Royalty fee USD",
    round(sum(PLATFORM_FEE_USD), 3) as "Platform fee USD",
    round(avg(price_usd), 3) as "Avg price USD",
    round(Median(price_usd), 3) as "Median price USD",
    ("Royalty fee USD" / "Volume USD") * 100 as "Share of Royalty fee %",
    round(
    "Volume USD" / count(distinct date_trunc(day, block_timestamp)),
    3
    ) as "Avg volume per day (USD)"
    from
    ethereum.nft.ez_nft_sales
    where BLOCK_TIMESTAMP>= '{{Start_date}}'


    QueryRunArchived: QueryRun has been archived