binhachonSymmetric vs Asymmetric LPs - #2
Updated 2022-05-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with liquidity_actions as (
select
block_timestamp,
case when position('-', pool_name, 1) = 0 then pool_name else substr(pool_name, 1, position('-', pool_name, 1) - 1) end as pool_name1,
pool_name,
case
when rune_amount = 0 then 'Asset only'
when asset_amount = 0 then 'Rune only'
else 'Symmetric' end
as category,
lp_action
from flipside_prod_db.thorchain.liquidity_actions
)
select
date_trunc('month', block_timestamp) as time,
category,
pool_name1,
count(*) as number_of_transactions
from liquidity_actions
where block_timestamp >= getdate() - interval'6 months'
group by 1, 2, 3
qualify row_number() over (partition by time order by number_of_transactions desc) < 10
Run a query to Download Data