maybeyonasthordrop_eth_first_action
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
›
⌄
WITH
eth_removers as (
select distinct from_address from thorchain.liquidity_actions
where
lp_action = 'remove_liquidity'
-- and split(pool_name,'.')[0]::string = 'ETH'
and split(from_address,'x')[0]::string = '0'
and block_timestamp >= '2021-11-17'
and block_timestamp <= '2021-11-27'
),
events as (
select *
from ethereum.udm_events
where origin_address in (select from_address from eth_removers)
and contract_address in (
'0x69fa0fee221ad11012bab0fdb45d444d3d2ce71c',
'0xebcd3922a199cd1358277c6458439c13a93531ed',
'0xa5f2211b9b8170f694421f2046281775e8468044'
)
)
select distinct * from (
select
origin_address,
last_value(block_timestamp) over (partition by origin_address order by block_timestamp desc) as first_interaction
from events
)
Run a query to Download Data