aor67nft 6 eth 1
    Updated 2022-09-15
    select BLOCK_TIMESTAMP::date date ,count(DISTINCT TX_HASH) as "total sale",
    count (DISTINCT BUYER_ADDRESS) as "total buyer",
    count (DISTINCT SELLER_ADDRESS) as "total seller",
    sum(PRICE_USD) as "total volume (USD)",
    avg(PRICE_USD) "average price (USD)"
    from ethereum.core.ez_nft_sales

    where EVENT_TYPE = 'sale'
    and date BETWEEN '2022-03-11' and '2022-09-11'
    group by 1
    Run a query to Download Data