binhachon22. [Elite] Network Shutdown - Ethereum holder
Updated 2021-11-27
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
29
30
31
32
33
34
35
36
›
⌄
with exit_transactions as(
select
tx_id
from
(
select
tx_id,
count(tx_id) as count
from
thorchain.swap_events
where
block_timestamp > '2021-11-17T00:00:00Z'
and block_timestamp < '2021-11-25T00:00:00Z'
group by
tx_id
)
where
count = 1
),
liquidity_remover as(
select
distinct from_address
from
thorchain.liquidity_actions
where
block_timestamp > '2021-11-17T00:00:00Z'
and block_timestamp < '2021-11-25T00:00:00Z'
and lp_action = 'remove_liquidity'
and from_address not like '%thor%'
),
crosschain_address as(
select
distinct crosschain_address
from
(
select
Run a query to Download Data