0xaimanTop 10 Liquidity Providers by Blockchains
Updated 2022-06-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with a as (select from_address,asset_blockchain, sum(asset_amount_usd) as adl -- date_trunc('week',block_timestamp) as dt, pool_name, lp_action, sum(rune_amount_usd+asset_amount_usd) as volume_capital
from thorchain.liquidity_actions
where lp_action='add_liquidity' and from_address is not null
-- group by 1,2,3 order by 1
group by 1,2 order by 3 desc),
b as (select from_address,asset_blockchain, sum(asset_amount_usd) as rml -- date_trunc('week',block_timestamp) as dt, pool_name, lp_action, sum(rune_amount_usd+asset_amount_usd) as volume_capital
from thorchain.liquidity_actions
where lp_action='remove_liquidity' and from_address is not null
-- group by 1,2,3 order by 1
group by 1,2 order by 3 desc)
select a.from_address, a.asset_blockchain, adl-rml as current_liquidity_usd
from a inner join b on a.from_address=b.from_address
order by 3 desc--and a.asset_blockchain=b.asset_blockchain
limit 10
Run a query to Download Data