flipperjo0Arbitrum Check
    Updated 2 hours ago
    WITH initial_addresses AS (
    SELECT DISTINCT to_address
    FROM arbitrum.core.ez_token_transfers
    WHERE LOWER(contract_address) IN (
    -- My Tokens --
    LOWER('0xb1f6078fc1bc983f0ef549a44cfdf3d562b87e87'),
    LOWER('0xcc2212fd511b5e13b52e0a89026adfb72114436a'),
    LOWER('0x085712b410c637edc85ecf631857c74f5cdcd91e'),
    LOWER('0xefb79d04aae9c1619aeea423f2685230a1d8d200'),
    LOWER('0x72781516934b14ba8437e706b8b6e8c1bf81e840'),
    LOWER('0xa6f061037b1a51ec3d805cc3754f78d73507f57b'),
    LOWER('0xed0055e681cd14dbe5e55d2421c8a9570c366cff'),
    LOWER('0x7df5fa4290ffd07b158ea3e53cb234cd8cf3f4a3'),
    LOWER('0xa32c0e1d600392a8e75d1eea08285bbadbe8b0c8')
    -- Competitors --
    -- LOWER('0x5cbbd16a3ec33fbdbf7c000bd3eac377560b0adc'),
    -- LOWER('0xd01a2c474f998ff7b402e81041576592d879577c'),
    -- LOWER('0x06d81db8464bc020051acfea2d734e90da611e1a'),
    -- LOWER('0xde7169fe7285aeb4a4a8aa6b4a33f425c1e843f9')
    )
    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 arbitrum.core.ez_token_transfers
    WHERE to_address IN (SELECT to_address FROM initial_addresses)
    Last run: about 2 hours ago
    BLOCK_TIMESTAMP
    TX_HASH
    FROM_ADDRESS
    TO_ADDRESS
    AMOUNT
    AMOUNT_USD
    CONTRACT_ADDRESS
    SYMBOL
    TRANSFER_TYPE
    1
    2025-05-05 12:11:13.0000x6795a52d654a8980f6e573b685a99a5d9395d8b5ada2e307a78a2bbdbb0fc35b0xbc5ec5fb75dd4cf5bd489d549600cdffd6363e720x95f0a722460e2ed7ba3b437042d7e270eaf642d2550xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9USDTERC20
    2
    2025-04-30 04:56:28.0000x2699b885d0a17350458fee2d958b6bb124ebb61b58a53d60ae3392153c740a1d0xec206e47b71065b5101d1dc9c4747aad66e3140d0xa02d96d2a3b6b06e9d74915880437846b8615ba812.912.90xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9USDTERC20
    3
    2025-04-28 16:37:36.0000x4fb5d6aacada4168190e388f235b6d5643a0a0a14d60621e3e8ca0367e988ec30x030ff16484c350d8be04ed88c9a2527dd09083b00xc86202013ff1474fa1506a75e948e3b0b85bc3f73010.150x912ce59144191c1204e64559fe8253a0e49e6548ARBERC20
    4
    2025-04-26 22:17:04.0000x6426c60aca19da82bb0e41b566c08e7641539e933200a0abb30b0c48c4a8ea120xb5f1c22a10fc0e40a43c9f7d4d14dee4e1130ca80xf3007556c8a54888b5c61d6d881e3ce298314f0e880xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9USDTERC20
    5
    2025-04-25 19:17:39.0000xfda714d6a36466735f1be02a230a37dcd8d750dee34150fd69faa9f2f58f6e930x237747d3f5d81abf42ebd0bc8a0306642ed17b9a0xf49159491ea43b5cd15b37323f42d5134a5d273b10100xaf88d065e77c8cc2239327c5edb3a432268e5831USDCERC20
    6
    2025-04-22 12:10:28.0000x120ba07c5c418e1a387d8849f60095c5020e2b342523a11eadc374215a4899de0xa358c9da7055b0134148dc2d3767fc4bc8915f550x1ef1e20ea48d31559760b1e32ab694a77a7c5462990xaf88d065e77c8cc2239327c5edb3a432268e5831USDCERC20
    6
    1KB
    174s