Updated 2025-02-26
    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
    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
    69
    3KB
    70s