flipside

    Main Addresses that StarsArena Hacker Interacted with
    SocioCryptoMain Addresses that StarsArena Hacker Interacted with
    Updated 2024-01-29

    SELECT DISTINCT address,
    type
    FROM (
    SELECT
    'Stars Arena Hacker' as type,
    origin_from_address as address
    FROM avalanche.core.ez_avax_transfers
    WHERE tx_hash = '0x4f37ffecdad598f53b8d5a2d9df98e3c00fbda4328585eb9947a412b5fe17ac5'
    AND avax_to_address = '0xa2ebf3fcd757e9be1e58b643b6b5077d11b4ad7a'
    UNION
    SELECT
    'contract' as type,
    avax_from_address as address
    FROM avalanche.core.ez_avax_transfers
    WHERE tx_hash = '0x4f37ffecdad598f53b8d5a2d9df98e3c00fbda4328585eb9947a412b5fe17ac5'
    AND avax_to_address = '0xa2ebf3fcd757e9be1e58b643b6b5077d11b4ad7a'
    UNION
    SELECT
    'address related to Hacker' as type,
    from_address as address
    FROM avalanche.core.fact_transactions
    WHERE to_address = '0xa2ebf3fcd757e9be1e58b643b6b5077d11b4ad7a'
    UNION
    SELECT
    'address related to Hacker' as type,
    to_address as address
    FROM avalanche.core.fact_transactions
    WHERE from_address = '0xa2ebf3fcd757e9be1e58b643b6b5077d11b4ad7a'
    UNION
    SELECT
    'contract' as type,
    avax_from_address as address
    FROM avalanche.core.ez_avax_transfers
    WHERE origin_from_address = '0xa2ebf3fcd757e9be1e58b643b6b5077d11b4ad7a'
    AND block_timestamp > '2023-10-07 05:23:35.000'
    Last run: over 1 year agoAuto-refreshes every 24 hours
    ADDRESS
    TYPE
    1
    		0x366bdcfcf288898e8135c15832638a985da7cefbaddress hacker send avax to
    2
    		0xa2ebf3fcd757e9be1e58b643b6b5077d11b4ad7aStars Arena Hacker
    3
    		0xa2ebf3fcd757e9be1e58b643b6b5077d11b4ad7acontract
    4
    		0xf9b30d77af58245bdffd7f3b2aaff1518af086d1address hacker send avax to
    5
    		0xfbe87a244e182f6ebdbcb1ce04b28eea75316a5aaddress related to Hacker
    6
    		0xaae26da1bfd8eed3deab0a9dfd64fbcf70bbe6cbaddress hacker send avax to
    7
    		0xbb4f53f4bd4af99c4ae20b2b7fadc6474bbe9e54address hacker send avax to
    8
    		0xe57da70ce5ab023e2d90e3ec042ae2fa306da5abaddress hacker send avax to
    9
    		0x859fa01bf76fdeb0f8a47e93a6841c4b22e6542baddress hacker send avax to
    10
    		0x91d632396c3f3bb65881abe482e64a1ce080d776address hacker send avax to
    11
    		0x3434a28a0b155f064d06b8d28b91298b78deb628address hacker send avax to
    12
    		0x6528f20a46845fee6c883eb09fd4671b535945f6address hacker send avax to
    13
    		0xdd9afc0e3c43951659c8ebe7aef9ee40879863eacontract
    14
    		0x16a3a898ec1080575524faa6d3ecd609015d2fa3address hacker send avax to
    15
    		0x57faa40ab5b8b81a371d97b86039231ececa73d7address hacker send avax to
    16
    		0xe36d7288a5ca0034be834534f23a8a1048ee0bbbaddress hacker send avax to
    17
    		0x63935a7a65a4a4679ddc128e5b2a0f1f45827d95address hacker send avax to
    18
    		0x781ea583691b45c8e9d401b8c8f8b99c56606659address hacker send avax to
    19
    		0x5dd0d87caa220883311f3476b0e10bd1a63af758address hacker send avax to
    20
    		0xa81d071f21ed3f9aa0cac61d994c146612419bd5address hacker send avax to
    ...
    303
    23KB
    22s