TO_ADDRESS | |
---|---|
1 | 0x0654874eb7f59c6f5b39931fc45dc45337c967c3 |
2 | 0x4c4af8dbc524681930a27b2f1af5bcc8062e6fb7 |
3 | 0x46a8095f42774cdb0f43874140ec5367a4bd15de |
4 | 0x3335733c454805df6a77f825f266e136fb4a3333 |
5 | 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 |
6 | 0x00000070ee937917c1d9bd91729ce1dd9a77d8e3 |
7 | 0xed306e38bb930ec9646ff3d917b2e513a97530b1 |
8 | 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae |
9 | 0x63dfa7c09dc2ff4030d6b8dc2ce6262bf898c8a4 |
10 | 0x16626473d50528db38c1834c29f7cb1acba2d56c |
11 | 0xcf446713ddf0e83f7527a260047f8ae89efae3e5 |
12 | 0xc456398d5ee3b93828252e48bededbc39e03368e |
13 | 0x7251febeabb01ec9de53ece7a96f1c951f886dd2 |
14 | 0x41300ba2f09d5e8ff6a82f6056516ca1bdd41ce6 |
15 | 0xeb8b76f647df9475c1175969df68d52316100068 |
16 | 0x4fda0599b78a49d289577a8df2046459abc04d82 |
17 | 0xe4a0b241d8345d86fb140d40c87c5fbdd685b9dd |
18 | 0x3c2cfe57330cb580f6a5bb579de5c917316502de |
19 | 0x69460570c93f9de5e2edbc3052bf10125f0ca22d |
20 | 0x5598bbfa2f4fe8151f45bba0a3ede1b54b51a0a9 |
Updated 2025-02-26
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
›
⌄
SELECT
distinct a.to_address
FROM
arbitrum.core.fact_transactions as a,
arbitrum.core.fact_traces as b,
arbitrum.core.fact_token_transfers as c
WHERE
DATE(a.BLOCK_TIMESTAMP) = '2025-02-25'
and DATE(b.BLOCK_TIMESTAMP) = '2025-02-25'
and a.TX_HASH = b.TX_HASH
and b.TX_HASH = c.TX_HASH
and substring(b.input, 3, 8) != substring(a.INPUT_DATA, 3, 8)
and substring(b.input, 3, 8) != '00000000'
and substring(a.INPUT_DATA, 3, 8) != 'b7d5e564'
and substring(a.INPUT_DATA, 3, 8) != '5e935362'
and substring(a.INPUT_DATA, 3, 8) != '3bc33417'
and substring(a.INPUT_DATA, 3, 8) != '9d55b53f'
and substring(a.INPUT_DATA, 3, 8) != '6a761202'
and substring(a.INPUT_DATA, 3, 8) != '7a9a1628'
and substring(a.INPUT_DATA, 3, 8) != 'b88d4fde'
and substring(a.INPUT_DATA, 3, 8) != '1cff79cd'
and substring(a.INPUT_DATA, 3, 8) != '3f801f91'
and substring(a.INPUT_DATA, 3, 8) != 'f242432a'
and substring(a.INPUT_DATA, 3, 8) != '59a4c24e'
and substring(a.INPUT_DATA, 3, 8) != '91aeeedc'
and substring(a.INPUT_DATA, 3, 8) != '26aa4655'
and substring(a.INPUT_DATA, 3, 8) != 'd1e30025'
and substring(a.INPUT_DATA, 3, 8) != '59a4c24e'
and substring(a.INPUT_DATA, 3, 8) != 'ab4ed83e'
and substring(a.INPUT_DATA, 3, 8) != 'dfec09e1'
and substring(a.INPUT_DATA, 3, 8) != '8fd8d1bb'
and substring(a.INPUT_DATA, 3, 8) != '0ceff6f1'
and substring(a.INPUT_DATA, 3, 8) != '47e1da2a'
and a.INPUT_DATA like concat('%', substring(b.input, 3), '%')
and a.INPUT_DATA like concat('%', substring(b.TO_ADDRESS, 3), '%')
and b.from_address = a.to_address
Last run: 23 days ago
69
3KB
70s