strawbetty top 10 pools
Updated 2022-04-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with top_pools as (
select contract_address, symbol from ethereum.erc20_balances
WHERE balance_date::date = CURRENT_DATE - 2
and symbol like 'km%' and ( symbol like '%USDC%' or symbol like '%DAI%' or symbol like '%UST%' or symbol like '%USDT%' )
group by 1, 2
)
select symbol, sum(balance) as t_value from ethereum.erc20_balances
where balance_date::date = CURRENT_DATE - 1
and contract_address in (select contract_address from top_pools)
group by 1
order by 2 desc
limit 10
Run a query to Download Data