adambalaloops pools
    Updated 2022-02-09
    with
    pool_addresses as (
    select address as address ,address_name
    from terra.labels
    where LABEL ilike 'loop'
    and LABEL_SUBTYPE ilike 'pool'
    group by 1,2),

    pool_tvl as (
    select address as address ,sum(balance_usd) as tvl ,balance_type
    from terra.daily_balances where date::date > current_date-10
    group by 1,3 having tvl is not null )
    select distinct pa.address_name , pt.tvl
    from pool_addresses as pa inner join pool_tvl as pt
    on lower(pa.address) =lower(pt.address)
    group by 1,2 having 2 >0






    Run a query to Download Data