SajjadiiiCorrelated Wallets List copy
    Updated 2025-05-14
    -- forked from MoDeFi / Correlated Wallets List @ https://flipsidecrypto.xyz/MoDeFi/q/_3LWT8o-CYIi/correlated-wallets-list

    WITH all_sami_address_wallets as
    (select BLOCK_TIMESTAMP, 'Polygon' as chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    from polygon.core.fact_transactions
    where TO_ADDRESS in (lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0xbA18cF4B6d98528ec92Ab3ca6FB8743Bcf36eb2f'),lower('0x70DFFC084A1C2EF81ff16ecf3056280ed07867Dd'),lower('0xb67992d4EbCc8cB67CBa994C0C2dB35Aa22d7F0F'),lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0x049140Bd618E741951C610233F96d98B3fC8E38b'),lower('0x02030a27DaB7fFBDEbb7C8e822D10CEd92072fec'),lower('0x873114D0B8beCF3707675889C3d57ca338100af6') )
    and TO_ADDRESS!=FROM_ADDRESS
    union all
    select BLOCK_TIMESTAMP, 'Optimism' as chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    from optimism.core.fact_transactions
    where TO_ADDRESS in (lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0xbA18cF4B6d98528ec92Ab3ca6FB8743Bcf36eb2f'),lower('0x70DFFC084A1C2EF81ff16ecf3056280ed07867Dd'),lower('0xb67992d4EbCc8cB67CBa994C0C2dB35Aa22d7F0F'),lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0x049140Bd618E741951C610233F96d98B3fC8E38b'),lower('0x02030a27DaB7fFBDEbb7C8e822D10CEd92072fec'),lower('0x873114D0B8beCF3707675889C3d57ca338100af6') )
    and TO_ADDRESS!=FROM_ADDRESS
    union all
    select BLOCK_TIMESTAMP, 'Arbitrum' as chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    from arbitrum.core.fact_transactions
    where TO_ADDRESS in (lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0xbA18cF4B6d98528ec92Ab3ca6FB8743Bcf36eb2f'),lower('0x70DFFC084A1C2EF81ff16ecf3056280ed07867Dd'),lower('0xb67992d4EbCc8cB67CBa994C0C2dB35Aa22d7F0F'),lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0x049140Bd618E741951C610233F96d98B3fC8E38b'),lower('0x02030a27DaB7fFBDEbb7C8e822D10CEd92072fec'),lower('0x873114D0B8beCF3707675889C3d57ca338100af6') )
    and TO_ADDRESS!=FROM_ADDRESS
    union all
    select BLOCK_TIMESTAMP, 'Ethereum' as chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    from ethereum.core.fact_transactions
    where TO_ADDRESS in (lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0xbA18cF4B6d98528ec92Ab3ca6FB8743Bcf36eb2f'),lower('0x70DFFC084A1C2EF81ff16ecf3056280ed07867Dd'),lower('0xb67992d4EbCc8cB67CBa994C0C2dB35Aa22d7F0F'),lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0x049140Bd618E741951C610233F96d98B3fC8E38b'),lower('0x02030a27DaB7fFBDEbb7C8e822D10CEd92072fec'),lower('0x873114D0B8beCF3707675889C3d57ca338100af6') )
    and TO_ADDRESS!=FROM_ADDRESS
    union all
    select BLOCK_TIMESTAMP, 'Avalanche' as chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    from avalanche.core.fact_transactions
    where TO_ADDRESS in (lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0xbA18cF4B6d98528ec92Ab3ca6FB8743Bcf36eb2f'),lower('0x70DFFC084A1C2EF81ff16ecf3056280ed07867Dd'),lower('0xb67992d4EbCc8cB67CBa994C0C2dB35Aa22d7F0F'),lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0x049140Bd618E741951C610233F96d98B3fC8E38b'),lower('0x02030a27DaB7fFBDEbb7C8e822D10CEd92072fec'),lower('0x873114D0B8beCF3707675889C3d57ca338100af6') )
    and TO_ADDRESS!=FROM_ADDRESS
    union all
    select BLOCK_TIMESTAMP, 'BSC' as chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    from bsc.core.fact_transactions
    where TO_ADDRESS in (lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0xbA18cF4B6d98528ec92Ab3ca6FB8743Bcf36eb2f'),lower('0x70DFFC084A1C2EF81ff16ecf3056280ed07867Dd'),lower('0xb67992d4EbCc8cB67CBa994C0C2dB35Aa22d7F0F'),lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0x049140Bd618E741951C610233F96d98B3fC8E38b'),lower('0x02030a27DaB7fFBDEbb7C8e822D10CEd92072fec'),lower('0x873114D0B8beCF3707675889C3d57ca338100af6'))
    and TO_ADDRESS!=FROM_ADDRESS
    union all
    select BLOCK_TIMESTAMP, 'Gnosis' as chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH
    from gnosis.core.fact_transactions
    where TO_ADDRESS in (lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0xbA18cF4B6d98528ec92Ab3ca6FB8743Bcf36eb2f'),lower('0x70DFFC084A1C2EF81ff16ecf3056280ed07867Dd'),lower('0xb67992d4EbCc8cB67CBa994C0C2dB35Aa22d7F0F'),lower('0xAC05B0aD6567694904714B25EA01F7E0d2f6F578'),lower('0x049140Bd618E741951C610233F96d98B3fC8E38b'),lower('0x02030a27DaB7fFBDEbb7C8e822D10CEd92072fec'),lower('0x873114D0B8beCF3707675889C3d57ca338100af6'))
    Last run: about 1 month ago
    Relation
    Transacitons
    First Wallet
    Second Wallet
    Type of Relation
    1
    ↔️50x3a14832b23d3dca67e155f6ac2bc90b0b23afacd0xc2f20fcb241d2cfc12fcb6ecadd6592ffe3b96d6Relation Other address
    2
    ⬅️10x99f6a9fffbe4649ac4f6fb905fffd736bc2bac730xc2f20fcb241d2cfc12fcb6ecadd6592ffe3b96d6Relation Other address
    3
    ⬅️10x1333a1bf7ae2a9be17cdd07413f183c8373ea7ea0x45c59b39da310e2d7a2de4e978693724643ed6e5Relation Other address
    4
    ⬅️10x923be472bdc829695c62dc22c2ffe41a67ddde000xc3cf627d355e2790547d365e7e7322bca761b8c5Relation Other address
    5
    ⬅️10x0a5ab74e4facba61bb0a6feedb04aeb517579fed0xc5ff4c97e0d2743c8b55f7d945c5ad9a210f10ecRelation Btw main address
    6
    ⬅️10x0711fe03a256e2e80162262c1bbda715f03b9bf40x5eccd8add21f7cbb803b0d10c5506a4366a09bc2Relation Other address
    7
    ➡️10x056b27d746215628038367a8a37f86ad0f6062430xc2f20fcb241d2cfc12fcb6ecadd6592ffe3b96d6Relation Other address
    8
    ➡️10x14896dc1285ece95408dbb30eb4515226be4941b0x259e9191eaad3f1e6e78471a4457193ea2738cd7Relation Other address
    9
    ↔️20x43fab27d58d5df5201e8113253c00fa0227f6a7c0x99f6a9fffbe4649ac4f6fb905fffd736bc2bac73Relation Other address
    10
    ➡️10x4420bf88c6a258fea99f7215079e3714ec8b33c70xc2f20fcb241d2cfc12fcb6ecadd6592ffe3b96d6Relation Other address
    11
    ⬅️10x0a5ab74e4facba61bb0a6feedb04aeb517579fed0x52ea9b683938db6648c592e9919c282767e4bd62Relation Btw main address
    12
    ➡️10x259e9191eaad3f1e6e78471a4457193ea2738cd70x6bd2acd0683b4574c277ce3b7a949afc425d5602Relation Other address
    13
    ⬅️10x99f6a9fffbe4649ac4f6fb905fffd736bc2bac730xa36c0ad71ca69566ccdd29e50e2ca6c95c20c4cdRelation Other address
    14
    ➡️10x1333a1bf7ae2a9be17cdd07413f183c8373ea7ea0xa36c0ad71ca69566ccdd29e50e2ca6c95c20c4cdRelation Other address
    15
    ⬅️10x0a5ab74e4facba61bb0a6feedb04aeb517579fed0xa36c0ad71ca69566ccdd29e50e2ca6c95c20c4cdRelation Btw main address
    16
    ⬅️10xc2f20fcb241d2cfc12fcb6ecadd6592ffe3b96d60xc5ff4c97e0d2743c8b55f7d945c5ad9a210f10ecRelation Other address
    17
    ⬅️10x7243405de4fb93314a3bcf5430488eed0dbc42c10xabff7697fa57f379375149fe998fd79d065f531aRelation Other address
    18
    ⬅️20x0a24534db97a688abeaebed91f8e7e06e13d50740xc3cf627d355e2790547d365e7e7322bca761b8c5Relation Other address
    19
    ➡️10x3a14832b23d3dca67e155f6ac2bc90b0b23afacd0xc3cf627d355e2790547d365e7e7322bca761b8c5Relation Other address
    20
    ↔️60x0711fe03a256e2e80162262c1bbda715f03b9bf40x7f3fa708ee6c57b749fe1af8ac55007cb0738928Relation Other address
    ...
    170
    21KB
    100s