maybeyonasthorchain_daily_remove
Updated 2021-11-11
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
›
⌄
with lp_actions as (
select
date(block_timestamp) as date,
lp_action,
count(distinct from_address) as users
from thorchain.liquidity_actions
group by 1,2
),
add_liq as (
select * from lp_actions
where lp_action = 'add_liquidity'
),
remove_liq as (
select * from lp_actions
where lp_action = 'remove_liquidity'
)
select
a.date,
a.users as add_users,
-r.users as rem_users,
r.users*100/a.users as remove_percent
from add_liq a join remove_liq r on a.date=r.date
Run a query to Download Data