0xaimanadd liquidity thorchain, who are users
Updated 2022-05-23
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
26
27
28
›
⌄
select date(t) as date, count(distinct asset_address) as n_new_unique_lp_address, sum(n_new_unique_lp_address) OVER(ORDER BY date asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_new_unique_lp_address from (
with a as( select block_timestamp as t, tx_id, from_address
from thorchain.liquidity_actions
where pool_name like 'ETH.%' and lp_action='add_liquidity'
),
b as (select rune_tx_id,pool_name,asset_address , asset_tx_id, min(block_timestamp) as fd from (
select * --block_timestamp,rune_tx_id, pool_name , asset_address, asset_tx_id, asset_e8, _asset_in_rune_e8
from thorchain.stake_events
)
where asset_e8>0 --or _asset_in_rune_e8>0
group by 1,2,3,4 --order by 5
)
select t,a.tx_id, b.pool_name,asset_address,asset_tx_id
from a
inner join b on a.tx_id=b.rune_tx_id
)where t>'2022-05-01'
group by 1 order by 1
limit 100
Run a query to Download Data