shadil"Small" LP Actions - all
Updated 2022-04-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with all_lp as (
SELECT
pool_name,
count(DISTINCT tx_id) as count_trxs
from thorchain.liquidity_actions
where lp_action = 'add_liquidity'
group by pool_name
),
small_lp as (
SELECT
pool_name,
count(DISTINCT tx_id) as count_trxs
from thorchain.liquidity_actions
where lp_action = 'add_liquidity'
and rune_amount_usd <= 1000
group by pool_name
)
SELECT al.pool_name,
case when al.count_trxs = 0 then 0 else (sl.count_trxs/al.count_trxs) * 100 end as portion --divide zero error solved
from all_lp al
join small_lp sl on sl.pool_name = al.pool_name
Run a query to Download Data