0xaimanSwap to, by Terra LP-ers
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select to_asset, count(from_address) as n_address
from (with terralp as (select from_address
from thorchain.liquidity_actions
where lp_action='add_liquidity' and asset_amount>0 and pool_name like 'TERRA.%'),
swap as (select block_timestamp, from_address, to_asset, to_amount
from thorchain.swaps
where from_asset='THOR.RUNE')
select block_timestamp, terralp.from_address, to_asset, to_amount
from terralp inner join swap on terralp.from_address=swap.from_address
where block_timestamp>='2022-05-09')
group by 1 order by 1
Run a query to Download Data