Crazy_Kid Small LP Actions
Updated 2022-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
WITH total AS (SELECT pool_name, COUNT(block_timestamp) as total_lps
FROM thorchain.liquidity_actions
WHERE lp_action = 'add_liquidity'
GROUP BY pool_name),
small_lp AS (SELECT pool_name, COUNT(block_timestamp) as small_lps
FROM thorchain.liquidity_actions
WHERE asset_amount_usd < 1000 AND lp_action = 'add_liquidity'
GROUP BY pool_name)
SELECT total.pool_name, total_lps, small_lps, (small_lps/total_lps)*100 as percentage_of_small_lps
FROM total JOIN small_lp ON total.pool_name = small_lp.pool_name
Run a query to Download Data