freemartianReya
Updated 2024-04-23
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
›
⌄
-- optimism tx: 0x9b2bae89dc9aaa3c44d72ea1ce52bb6e060af7dbf68ac5a6c3b60b8b24328d60
-- Ethereum Contract: 0xdff78a949e47c1e90f3dd6dd7fe2fa72b42a75f7
-- optimism contract: 0x9239609eed7c40c6ddcec25d247ef205103590b6
-- polygon contract: 0xC0acBb471465FCf848746D1837d8358aB891546c
-- Arbitrum contract: 0xa0e9b6da89bd0303a8163b81b8702388be0fde77
WITH
-- ==== Ethereum =====
ethereum AS (
SELECT
block_timestamp,
tx_hash,
origin_function_signature,
origin_from_address,
origin_to_address,
raw_amount/pow(10,6) AS amount,
'Ethereum' AS network
FROM ethereum.core.ez_token_transfers
WHERE origin_function_signature = '0x405e720a'
AND origin_to_address = '0xdff78a949e47c1e90f3dd6dd7fe2fa72b42a75f7'
block_timestamp
),
-- ==== Optimism ====
optimism AS (
SELECT
block_timestamp,
tx_hash,
origin_function_signature,
origin_from_address,
origin_to_address,
raw_amount/pow(10,6) AS amount,
'Optimism' AS network
FROM optimism.core.fact_token_transfers
QueryRunArchived: QueryRun has been archived