BLOCK_TIMESTAMP | TX_HASH | FROM_ADDRESS | TO_ADDRESS | AMOUNT | AMOUNT_USD | CONTRACT_ADDRESS | SYMBOL | TRANSFER_TYPE | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2025-04-12 15:39:35.000 | 0xe113cae86d4a1b080ba2e90817cf354c74c8b27b636bace8536de61812f50401 | 0x268aa4b2b8d1f7aaf1e32895ae386a75d9a4b911 | 0xd44e79974839ad9420824bdaedb9d2deb9af3c88 | 4.5 | 3.06 | 0x4200000000000000000000000000000000000042 | OP | ERC20 |
flipperjo0Optimism Check
Updated 9 hours ago
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 initial_addresses AS (
SELECT DISTINCT to_address
FROM optimism.core.ez_token_transfers
WHERE LOWER(contract_address) IN (
LOWER('0xefb79d04aae9c1619aeea423f2685230a1d8d200'),
LOWER('0x1C6B975e8AfBb39Dac6E3270819695507D725A4D'),
LOWER('0x085712b410c637edc85ecf631857c74f5cdcd91e'),
LOWER('0xcc2212fd511b5e13b52e0a89026adfb72114436a'),
LOWER('0x0d1832243d3ecf4cad3028d32f3fcd26a7f1a96f')
)
AND to_address IS NOT NULL
),
token_transfers AS (
SELECT
block_timestamp,
tx_hash,
from_address,
to_address,
amount,
amount_usd,
contract_address,
symbol,
'ERC20' AS transfer_type
FROM optimism.core.ez_token_transfers
WHERE to_address IN (SELECT to_address FROM initial_addresses)
AND amount_usd > 0
),
native_transfers AS (
SELECT
block_timestamp,
tx_hash,
from_address,
to_address,
amount,
Last run: about 9 hours ago
1
255B
74s