SajjadiiiOpyn 1
    Updated 2022-06-30
    with oSTH_pools as (
    select * from flipside_prod_db.ethereum.dex_liquidity_pools
    where POOL_NAME like '%oSQTH%'
    )
    select sum(amount_usd) as "TVL in USD" ,
    balance_date as "balance date"
    from ethereum.erc20_balances ,oSTH_pools
    where user_address = POOL_ADDRESS
    and (contract_address =token0 or contract_address =token1 )
    group by balance_date





    Run a query to Download Data