freemartianBridge From Aptos User Activity per token and chain copy
Updated 2024-05-05
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
arbitrum AS(
SELECT
block_timestamp,
tx_hash,
to_address,
'WETH' AS symbol,
amount_usd,
'Arbitrum' AS chain
FROM arbitrum.core.ez_native_transfers
WHERE
origin_from_address = '0xe93685f3bba03016f02bd1828badd6195988d950'
AND origin_to_address = '0x177d36dbe2271a4ddb2ad8304d82628eb921d790'
AND from_address = '0x1bacc2205312534375c8d1801c27d28370656cff'
-- AND origin_function_signature = '0x252f7b01'
AND to_address = '{{EVM_Wallet}}'
UNION
SELECT
block_timestamp,
tx_hash,
to_address,
symbol,
amount_usd,
'Arbitrum' AS chain
FROM arbitrum.core.ez_token_transfers
WHERE
origin_from_address = '0xe93685f3bba03016f02bd1828badd6195988d950'
AND origin_to_address = '0x177d36dbe2271a4ddb2ad8304d82628eb921d790'
AND from_address = '0x1bacc2205312534375c8d1801c27d28370656cff'
-- AND origin_function_signature = '0x252f7b01'
AND to_address <> '0x0000000000000000000000000000000000000000'
AND to_address = '{{EVM_Wallet}}'
),
QueryRunArchived: QueryRun has been archived