adambalaloops pools
Updated 2022-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
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