2844Untitled Query
Updated 2022-06-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with SumBalance as
(select DISTINCT user_address,non_adjusted_balance/1e18 as Balance_oSQTH
from flipside_prod_db.ethereum.erc20_balances
where contract_address = lower ('0xf1B99e3E573A1a9C5E6B2Ce818b617F0E664E86B')
and balance_date= CURRENT_DATE -1
and Balance_oSQTH > 1e-3
ORDER by Balance_oSQTH DESC)
select sum( Balance_oSQTH) as oSQTH_TVL,
(select avg(price)
from flipside_prod_db.ethereum.token_prices_hourly
where token_address= lower ('0xf1B99e3E573A1a9C5E6B2Ce818b617F0E664E86B')
and hour= CURRENT_DATE) *oSQTH_TVL as TVL_IN_USD
from sumBalance
Run a query to Download Data