maybeyonasthor_net_lp_add
Updated 2021-12-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with events as (
select
block_timestamp,
lp_action,
split(pool_name,'-')[0]::string as pool_name,
from_address,
-- to_address,
rune_amount_usd+asset_amount_usd as usd_moved
from thorchain.liquidity_actions
)
-- limit 100
select
date(block_timestamp) as date,
-- pool_name,
sum(usd_moved) as liq_added,
count(distinct from_address) as lp_adders
from events
where lp_action = 'add_liquidity'
group by 1--,2
-- limit 100
Run a query to Download Data