MrftiSuspicious of Sybil activity wallets list copy
    Updated 2024-05-19
    -- forked from Suspicious of Sybil activity wallets list @ https://flipsidecrypto.xyz/edit/queries/8cafc47d-2c43-4787-b1d9-72f9c2648c21
    with alll as (
    WITH layerzero_addresses AS (
    SELECT DISTINCT sender_wallet AS address
    FROM external.layerzero.fact_transactions_snapshot
    WHERE sender_wallet IS NOT NULL
    ),

    combined_txs AS (
    SELECT 'Polygon' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    FROM polygon.core.fact_transactions
    WHERE FROM_ADDRESS IN (SELECT address FROM layerzero_addresses)
    AND TO_ADDRESS IN (SELECT address FROM layerzero_addresses)
    AND TO_ADDRESS != FROM_ADDRESS
    UNION ALL
    SELECT 'Optimism' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    FROM optimism.core.fact_transactions
    WHERE FROM_ADDRESS IN (SELECT address FROM layerzero_addresses)
    AND TO_ADDRESS IN (SELECT address FROM layerzero_addresses)
    AND TO_ADDRESS != FROM_ADDRESS
    UNION ALL
    SELECT 'Arbitrum' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    FROM arbitrum.core.fact_transactions
    WHERE FROM_ADDRESS IN (SELECT address FROM layerzero_addresses)
    AND TO_ADDRESS IN (SELECT address FROM layerzero_addresses)
    AND TO_ADDRESS != FROM_ADDRESS
    UNION ALL
    SELECT 'Ethereum' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    FROM ethereum.core.fact_transactions
    WHERE FROM_ADDRESS IN (SELECT address FROM layerzero_addresses)
    AND TO_ADDRESS IN (SELECT address FROM layerzero_addresses)
    AND TO_ADDRESS != FROM_ADDRESS
    UNION ALL
    SELECT 'Avalanche' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    FROM avalanche.core.fact_transactions
    WHERE FROM_ADDRESS IN (SELECT address FROM layerzero_addresses)
    QueryRunArchived: QueryRun has been archived