alirsUntitled Query
Updated 2022-08-25
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 lp as (select
tx_hash
from ethereum.core.fact_event_logs
where ORIGIN_TO_ADDRESS = '0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f'
and ORIGIN_FUNCTION_SIGNATURE in ('0xf305d719', '0xded9382a','0xe8e33700')
),
r_lp as (select
tx_hash
from ethereum.core.fact_event_logs
where ORIGIN_TO_ADDRESS = '0xef0881ec094552b2e128cf945ef17a6752b4ec5d'
and origin_function_signature in ('0x0ad58d2f' )
),
t1 as (select
ORIGIN_FROM_ADDRESS,
min(BLOCK_TIMESTAMP) as dt_add,
sum(AMOUNT_USD) as add_LP
from ethereum.core.ez_token_transfers where tx_hash in (select tx_hash from lp)
group by 1),
t2 as (select
ORIGIN_FROM_ADDRESS,
max(BLOCK_TIMESTAMP) as dt_removal,
sum(AMOUNT_USD) as removal_LP
from ethereum.core.ez_token_transfers where tx_hash in (select tx_hash from r_lp)
group by 1),
t3 as (select
t1.ORIGIN_FROM_ADDRESS as u1,
dt_removal,
removal_LP-add_LP as profit_lost
from t1 left join t2 on t1.ORIGIN_FROM_ADDRESS=t2.ORIGIN_FROM_ADDRESS)
select
Run a query to Download Data