2844Untitled Query
    Updated 2022-06-30
    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