barbodsale
    Updated 2022-06-14
    with tx_ids as (
    select
    TX_HASH,
    BLOCK_TIMESTAMP::date as date ,
    EVENT_TYPE ,
    SELLER_ADDRESS,
    BUYER_ADDRESS,
    sum (zeroifnull(PRICE_USD)) as volume
    from flipside_prod_db.ethereum_core.ez_nft_sales
    WHERe platform_name = 'nftx'
    group by 1,2,3,4,5
    )
    select date as date , count (TX_HASH) as num_sales ,
    count (DISTINCT SELLER_ADDRESS) as num_sellers,
    count (DISTINCT BUYER_ADDRESS ) as num_buyers,
    sum (volume) as sale_volume
    from tx_ids
    where date >=CURRENT_DATE -60
    group by 1
    Run a query to Download Data