barbodsale3
    Updated 2022-06-14
    with tx_ids as (
    select
    PROJECT_NAME,
    -- SELLER_ADDRESS,
    -- BUYER_ADDRESS,
    sum (zeroifnull(PRICE_USD)) as volume
    from flipside_prod_db.ethereum_core.ez_nft_sales
    WHERe platform_name = 'nftx'
    and EVENT_TYPE = 'redeem'
    and BLOCK_TIMESTAMP::date >=CURRENT_DATE -60
    group by 1 order by volume desc limit 3
    )
    select * from tx_ids
    Run a query to Download Data