freemartian2024-04-01 01:26 AM
Updated 2024-04-01
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 from_op AS (
-- SELECT
-- block_timestamp,
-- tx_hash,
-- from_address AS bridger,
-- amount,
-- amount_usd,
-- 'ETH' AS symbol,
-- 'inbound' AS direction,
-- '1' AS rank
-- FROM optimism.core.ez_native_transfers
-- WHERE to_address = '0x1572d48a52906b834fb236aa77831d669f6d87a1'
-- AND from_address <> '0x4200000000000000000000000000000000000006'
-- UNION
SELECT
block_timestamp,
tx_hash,
origin_from_address AS bridger,
amount,
amount_usd,
symbol,
'outbound' AS direction,
rank() over (partition BY tx_hash ORDER BY event_index ASC) AS rank
FROM optimism.core.ez_token_transfers
WHERE to_address = '0x1572d48a52906b834fb236aa77831d669f6d87a1'
AND symbol <> 'Visit blast2l.com to claim rewards'
-- AND tx_hash NOT IN (
-- SELECT tx_hash FROM optimism.core.ez_native_transfers
-- WHERE to_address = '0x1572d48a52906b834fb236aa77831d669f6d87a1'
-- AND from_address <> '0x4200000000000000000000000000000000000006'
-- )
qualify rank = 1
ORDER BY block_timestamp ASC
),
QueryRunArchived: QueryRun has been archived