SajjadiiiOpyn 1
Updated 2022-06-30Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
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