CryptoLionuni v2 top pools
Updated 2021-09-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with p as (
select
platform,
pool_address,
pool_name
from ethereum.dex_liquidity_pools
where platform = 'uniswap-v2'
)
select
address_name,
symbol,
last_value(amount_usd) over (partition by address_name, symbol order by balance_date) as am
from ethereum.erc20_balances e
inner join p on e.address_name = p.pool_address
order by 3 desc
Run a query to Download Data