flipside

    tether gold pools
    Abbas_ra21tether gold pools
    Updated 2022-11-04
    with tb AS (select distinct POOL_ADDRESS AS pools from ethereum.uniswapv3.ez_pools where TOKEN0_ADDRESS='0x68749665ff8d2d112fa859aa293f07a622782f38' or TOKEN1_ADDRESS='0x68749665ff8d2d112fa859aa293f07a622782f38')
    select BLOCK_TIMESTAMP,TOKEN0_BALANCE_USD+TOKEN1_BALANCE_USD AS TVL from ethereum.uniswapv3.ez_pool_stats
    where POOL_ADDRESS='0x6546055f46e866a4b9a4a13e81273e3152bae5da'
    and BLOCK_TIMESTAMP >= dateadd('month',-3,CURRENT_DATE)
    order by BLOCK_TIMESTAMP desc
    Run a query to Download Data