flipside

    Untitled Query
    mahdir007Untitled Query
    Updated 2022-09-30
    select table1.NF_TOKEN_ID, table1.BLOCK_TIMESTAMP, table2.TOKEN0_BALANCE_USD, table2.TOKEN1_BALANCE_USD
    FROM ethereum.uniswapv3.ez_position_collected_fees table1
    INNER JOIN ethereum.uniswapv3.ez_pool_stats table2
    ON table1.BLOCK_TIMESTAMP = table2.BLOCK_TIMESTAMP AND table1.POOL_ADDRESS = table2.POOL_ADDRESS
    WHERE table1.BLOCK_TIMESTAMP > '2022-07-11 06:05:28'
    ORDER BY table1.BLOCK_TIMESTAMP

    -- 7/11/2022 6:05:27 AM
    Run a query to Download Data