0xtoshifindconnection
    Updated 2023-09-01
    WITH suspectSybil as (
    SELECT * FROM (
    VALUES
    ('0x008b34d620493319c94d9e2e8ebeb3b602024f15'),
    ('0x297f97548e3e7a6c3054c8c36989a3fe7d037e5e'),
    ('0x37250ed5683476d32bac83a4b337f34adbe080bf'),
    ('0x5d2f3617de2997a29669a8dcc2caa42f6a08e2a1'),
    ('0x7c7982808cf12832ce17086930877bbc52ebad25'),
    ('0x867439daa8bdd72d65633c5e61870e6eae471f80'),
    ('0x8931144be611df4435626b2ae65a6d4588a66247'),
    ('0x953bad06ebbb361113a99bbc37ad9548ded518f1'),
    ('0xa40dbad86d0c09ce492307827ef25bd7f71a6e41'),
    ('0xd5c16df4258daa25ebec0ff74adf1a65e0b3c9c0'),
    ('0xd8703641e95d2cca7113062246610cf930b9721c')
    ) t (address)
    ), PolygonDepositor as (
    SELECT MATIC_FROM_ADDRESS as FROM_ADDRESS, MATIC_TO_ADDRESS as TO_ADDRESS, AMOUNT, BLOCK_TIMESTAMP, TX_HASH, 'POLYGON' as BLOCKCHAIN
    FROM polygon.core.ez_matic_transfers
    WHERE MATIC_TO_ADDRESS IN (SELECT address FROM suspectSybil)
    AND MATIC_FROM_ADDRESS IN (SELECT address FROM suspectSybil)
    ),
    EthereumDepositor as (
    SELECT ETH_FROM_ADDRESS as FROM_ADDRESS, ETH_TO_ADDRESS as TO_ADDRESS, AMOUNT, BLOCK_TIMESTAMP, TX_HASH, 'ETHEREUM' as BLOCKCHAIN
    FROM ethereum.core.ez_eth_transfers
    WHERE ETH_TO_ADDRESS IN (SELECT address FROM suspectSybil)
    AND ETH_FROM_ADDRESS IN (SELECT address FROM suspectSybil)
    ),
    ArbitrumDepositor as (
    SELECT ETH_FROM_ADDRESS as FROM_ADDRESS, ETH_TO_ADDRESS as TO_ADDRESS, AMOUNT, BLOCK_TIMESTAMP, TX_HASH, 'ARBITRUM' as BLOCKCHAIN
    FROM arbitrum.core.ez_eth_transfers
    WHERE ETH_TO_ADDRESS IN (SELECT address FROM suspectSybil)
    AND ETH_FROM_ADDRESS IN (SELECT address FROM suspectSybil)
    ),
    OptimismDepositor as (
    SELECT ETH_FROM_ADDRESS as FROM_ADDRESS, ETH_TO_ADDRESS as TO_ADDRESS, AMOUNT, BLOCK_TIMESTAMP, TX_HASH, 'OPTIMISM' as BLOCKCHAIN
    FROM optimism.core.ez_eth_transfers
    Run a query to Download Data