badboyUntitled Query
    Updated 2022-10-20
    SELECT

    count(DISTINCT seller_address)

    as
    seller_count,

    count(DISTINCT buyer_address)
    as
    buyer_count,

    count(DISTINCT tx_hash)
    as
    sales_count,

    sum(price_usd) as sales_volume,

    platform_name,

    date_trunc(day,block_timestamp) as days

    from (ethereum.core.ez_nft_sales)

    where event_type='sale'

    and block_timestamp between '2022-09-1' and '2022-09-30'
    group by 5,6
    Run a query to Download Data