Trader JoeJoe bridging by wallet 1
Updated 2024-05-25
999
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
-- BNB Chain 102, Avalanche 106, Arbitrum 110, mantle 181
arb_tx as (
select
*,
decoded_log:_amount as amount,
decoded_log:_dstChainId as dstChainId,
decoded_log:_srcChainId as srcChainId,
decoded_log:_from as from_address,
decoded_log:_toAddress
from
arbitrum.core.ez_decoded_event_logs
where
contract_address='0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07'
and event_name in ('SendToChain','ReceiveFromChain')
),
avax_tx as (
select
*,
decoded_log:_amount as amount,
decoded_log:_dstChainId as dstChainId,
decoded_log:_srcChainId as srcChainId,
decoded_log:_from as from_address,
decoded_log:_toAddress
from
avalanche.core.ez_decoded_event_logs
where
contract_address='0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07'
and event_name in ('SendToChain','ReceiveFromChain')
),
bsc_tx as (
select
*,
decoded_log:_amount as amount,
QueryRunArchived: QueryRun has been archived