flipside

    Preliminar List of Sybil Wallets on Avalanche
    adriaparcerisasPreliminar List of Sybil Wallets on Avalanche
    Updated 2025-04-02
    -- forked from layerzero sybils 4 @ https://flipsidecrypto.xyz/edit/queries/166dd8e3-cd31-48b1-993a-dd4b7023d272

    WITH Transactions AS (
    SELECT
    SENDER_WALLET,
    SOURCE_CHAIN,
    DESTINATION_CHAIN,
    COUNT(*) AS tx_count,
    SUM(STARGATE_SWAP_USD) AS total_volume_usd,
    MIN(SOURCE_TIMESTAMP_UTC) AS first_tx,
    MAX(SOURCE_TIMESTAMP_UTC) AS last_tx,
    COUNT(DISTINCT SOURCE_CONTRACT) AS distinct_source_contracts
    FROM
    external.layerzero.fact_transactions_snapshot
    GROUP BY
    SENDER_WALLET,SOURCE_CHAIN,DESTINATION_CHAIN
    ),
    criteria as (
    SELECT
    *
    FROM
    Transactions
    WHERE
    tx_count > 5 -- minimo de 5 transacciones
    AND total_volume_usd < 100 -- menso de 100 USD de volumen
    AND datediff(hour,first_tx,last_tx) < 24 -- Transacciones en menos de un día
    AND distinct_source_contracts < 3 -- Pocos contratos de origen
    ORDER BY
    tx_count DESC
    ),
    -- Refinamiento con correlación temporal y patrones de uso de contratos
    RefinedSuspectWallets AS (
    SELECT
    SENDER_WALLET,
    SOURCE_CHAIN,
    DESTINATION_CHAIN,
    Last run: 21 days ago
    SENDER_WALLET
    SOURCE_CHAIN
    DESTINATION_CHAIN
    TX_COUNT
    TOTAL_VOLUME_USD
    FIRST_TX
    LAST_TX
    SOURCE_OF_FUNDS
    1
    		0x98d52aaa2b4342306876de1402711fffca1bccceAvalancheFantom100.099793578162023-05-19 13:55:28.0002023-05-19 14:01:10.0000x5b57abcf3d3efabe9d4cf0a280c42e8403d1ae49
    2
    		0xe5223b9d911d3cf795ba498bde288dedd62eeac7AvalancheFantom100.099793578162023-05-19 10:55:44.0002023-05-19 11:03:56.0000x5b57abcf3d3efabe9d4cf0a280c42e8403d1ae49
    3
    		0x809ab464e2c313b4806d700c7e37233f5e01e48cAvalancheFantom100.099793578162023-05-19 13:56:03.0002023-05-19 14:01:21.0000x5b57abcf3d3efabe9d4cf0a280c42e8403d1ae49
    4
    		0xf60db0135520d634892c102f7d59b7e21557c4d7AvalancheFantom90.089814220342023-05-19 10:56:30.0002023-05-19 11:00:37.0000x5b57abcf3d3efabe9d4cf0a280c42e8403d1ae49
    5
    		0xa5ceb7a3bc3e62922625ccaf63d18c58522525fbAvalancheBase779.9136925922023-12-04 12:58:31.0002023-12-04 13:16:13.0000x9f8c163cba728e99993abe7495f06c0a3c8ac8b9
    6
    		0xc5abe9d6a3ba9cededf3e1e22b8aebefdd4b54dfAvalancheBase779.9136925922023-12-04 13:02:48.0002023-12-04 13:15:49.0000x9f8c163cba728e99993abe7495f06c0a3c8ac8b9
    7
    		0xdce8d006eeadea02f82d011cbcc9a4c2056fde13AvalancheBase769.9244811432023-12-04 12:58:39.0002023-12-04 13:15:32.0000x9f8c163cba728e99993abe7495f06c0a3c8ac8b9
    8
    		0x59e7a64dbc04a28a85331b5fcc2d40030caa2516AvalancheBase769.9244811432023-12-04 13:00:04.0002023-12-04 13:15:32.0000x9f8c163cba728e99993abe7495f06c0a3c8ac8b9
    9
    		0x3e4fce5c5298207f5f16919f6c450153fa0d5627AvalancheFantom6133.9943500572023-12-22 05:45:46.0002023-12-22 06:07:43.0000x9f8c163cba728e99993abe7495f06c0a3c8ac8b9
    10
    		0x864af44532e98bfcd894ffacd4120885f87260abAvalancheFantom6133.9890752172023-12-22 05:45:46.0002023-12-22 06:07:41.0000x9f8c163cba728e99993abe7495f06c0a3c8ac8b9
    11
    		0xf6b98c3393e4d388dcdf0258a261323207a829ecAvalancheFantom6133.9890752172023-12-22 05:45:46.0002023-12-22 06:07:43.0000x9f8c163cba728e99993abe7495f06c0a3c8ac8b9
    12
    		0x0f0d844bd7f67b652625f820706c3e807a503e94AvalancheMetis110.014158384752023-06-03 21:37:11.0002023-06-03 21:47:58.0000x9f8c163cba728e99993abe7495f06c0a3c8ac8b9
    13
    		0x1afc7169a98fd2eeefca4c0897b2c25acd60e20bAvalancheMetis110.01394975422023-06-05 00:12:40.0002023-06-05 00:22:07.0000x9f8c163cba728e99993abe7495f06c0a3c8ac8b9
    14
    		0x145b6f2c9df112960162d9c07d2702d78050e18cAvalancheMetis110.010656052742023-06-03 19:16:06.0002023-06-03 19:31:27.0000x9f8c163cba728e99993abe7495f06c0a3c8ac8b9
    15
    		0x53039c6aa4a86c7e28fa5568a1db54801cdee290AvalancheMetis70.0014505167472023-06-01 02:36:20.0002023-06-01 03:09:51.0000x9f8c163cba728e99993abe7495f06c0a3c8ac8b9
    16
    		0x644d5c8536d7b5d7f8b12975c0ade09019563774AvalancheFantom210.60973432392023-04-10 07:32:06.0002023-04-10 07:36:46.0000xa16f524a804beaed0d791de0aa0b5836295a2a84
    17
    		0xdcc4513afd18da7ba2ea9947c6ee06aefc7daf5cAvalancheFantom210.60764937912023-04-07 06:27:02.0002023-04-07 06:32:18.0000xa16f524a804beaed0d791de0aa0b5836295a2a84
    18
    		0x212ab4d72156eeee654afe6a1a05869ce5e14752AvalancheFantom210.26420348712023-04-10 06:58:08.0002023-04-10 07:05:00.0000xa16f524a804beaed0d791de0aa0b5836295a2a84
    19
    		0x4b991379b1cc7e4dd83249566f6851079a506509AvalancheFantom210.26408446452023-04-09 06:40:16.0002023-04-09 06:47:26.0000xa16f524a804beaed0d791de0aa0b5836295a2a84
    20
    		0xe819efb4299096ee6f1a162fc9be34d3b175a486AvalancheFantom200.58024398182023-04-06 12:20:02.0002023-04-06 12:45:29.0000xa16f524a804beaed0d791de0aa0b5836295a2a84
    ...
    530
    94KB
    87s