sarathLP size distribution
Updated 2022-05-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH add_liq AS (SELECT pool_name as pool_add, sum(asset_amount_usd) as liq_added
FROM thorchain.liquidity_actions
WHERE lp_action = 'add_liquidity'
GROUP BY pool_name),
remove_liq AS (SELECT pool_name as pool_remove, sum(asset_amount_usd) as liq_removed
FROM thorchain.liquidity_actions
WHERE lp_action = 'remove_liquidity'
GROUP BY pool_name),
data1 AS (SELECT * FROM add_liq LEFT JOIN remove_liq ON pool_add = pool_remove),
pool_data AS (SELECT pool_add AS pool_name, liq_added, zeroifnull(liq_removed) as liq_removed FROM data1)
SELECT pool_name, liq_added - liq_removed as lp_size
FROM pool_data
ORDER BY lp_size DESC
Run a query to Download Data