HessishArb bridges
Updated 2024-07-15
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 crossx as (SELECT BLOCK_TIMESTAMP::date as time_a,
TX_HASH as tx_a,
ORIGIN_FROM_ADDRESS as swapper_a,
symbol as from_token,
case when AMOUNT_USD is null then 0 else AMOUNT_USD end as amount_a,
'Socket' as gateway
from arbitrum.core.ez_token_transfers
where tx_hash not in (SELECT DISTINCT tx_hash from arbitrum.defi.ez_dex_swaps) and
ORIGIN_TO_ADDRESS = '0xd2667072a2a30e8c21fa276b474fd047ab5ff0f7'
and FROM_ADDRESS = '0xd2667072a2a30e8c21fa276b474fd047ab5ff0f7'
and TO_ADDRESS = '0x3a23f943181408eac424116af7b7790c94cb97a5'
and origin_from_address != '0x1e2c53ba467f6c4aa9325a7767a401b1999b2bf7'
union
SELECT BLOCK_TIMESTAMP::date as time_a,
TX_HASH as tx_a,
ORIGIN_FROM_ADDRESS as swapper_a,
'ETH' as from_token,
case when AMOUNT_USD is null then 0 else AMOUNT_USD end as amount_a,
'Socket' as gateway
from arbitrum.core.ez_native_transfers
where tx_hash not in (SELECT DISTINCT tx_hash from arbitrum.defi.ez_dex_swaps) and
ORIGIN_TO_ADDRESS = '0xd2667072a2a30e8c21fa276b474fd047ab5ff0f7'
and FROM_ADDRESS = '0xd2667072a2a30e8c21fa276b474fd047ab5ff0f7'
and TO_ADDRESS = '0x3a23f943181408eac424116af7b7790c94cb97a5'
and origin_from_address != '0x1e2c53ba467f6c4aa9325a7767a401b1999b2bf7'
union
SELECT BLOCK_TIMESTAMP::date as time_a,
TX_HASH as tx_a,
ORIGIN_FROM_ADDRESS as swapper_a,
symbol as from_token,
case when AMOUNT_USD is null then 0 else AMOUNT_USD end as amount_a,
QueryRunArchived: QueryRun has been archived