elenahoodreadful-amaranth
    Updated 8 days ago
    select
    distinct blockchain, label_type, label_subtype, address_name, project_name, address
    from CROSSCHAIN.core.dim_labels
    where label_type in ('flotsam') --'other_xfer','cex','dex','chadmin', 'flotsam','nft','token','dapp','floatsam'
    and blockchain in ('ethereum')
    limit 1000
    -- claim
    -- other_xfer 'unknown transfer to'
    -- cex '??'
    -- swap 'swap inside chain'
    -- dex 'lp or staking'
    -- nft '??'
    -- token '??'
    -- defi 'lp or staking'
    -- bridge 'transfer out'
    -- dapp '??'
    -- chadmin 'liquid staking'
    -- flotsam '??'
    -- operator 'liquid staking'
    -- games '??'
    Last run: 8 days ago
    BLOCKCHAIN
    LABEL_TYPE
    LABEL_SUBTYPE
    ADDRESS_NAME
    PROJECT_NAME
    ADDRESS
    1
    ethereumflotsamcontract_deployereth666.me: deployereth666.me0x76130fd699cd7ab670c51e699e67d3eea4b8f8db
    2
    ethereumflotsamtoxicfake_phishing4084fake_phishing40840x8bda591ac93925f485cd420a47a48eba87985ea0
    3
    ethereumflotsamtoxicfake_phishing5218phish hack0x51c43b800f1509263049f85946ce6d77f9301f67
    4
    ethereumflotsamtoxicfake_phishing1425phish hack0x52bdb97e587a35d5e54b01344168d41783120310
    5
    ethereumflotsamtoxicfake_phishing1090phish hack0x5580fb6e95230bf16ae7e2c6467d11566ed5b3ea
    6
    ethereumflotsamtoxicfake_phishing2962phish hack0x8a6762e718beb7e6af9ab3868320c3c5137adc6c
    7
    ethereumflotsamtoxicanubisdao liquidity rug 3heist0xb1302743acf31f567e9020810523f5030942e211
    8
    ethereumflotsamtoxicfake_phishing2421phish hack0xd4c9f4dbd26ae8c9b87a0d9b3368c0096241a162
    9
    ethereumflotsamtoxicchainsafe: lido node operatorchainsafe0xf82b1fdcd493b2defab52c740399ff150baa7a2a
    10
    ethereumflotsamtoxicfake_phishing1264phish hack0x8ca61e380ebbebe412b5787a20b6ecdf2ab21997
    11
    ethereumflotsamgeneral_contractwallie.meponzi0xc0b52b76055c392d67392622ae7737cdb6d42133
    12
    ethereumflotsamtoxicfake_phishing4445fake_phishing44450x7cacaea4a2126818a1f2a3ebbbfce3b0e5480318
    13
    ethereumflotsamtoxicfake_phishing2257phish hack0x63f32b8ec6e4dea892149834a7b8d7c9e67b4a0a
    14
    ethereumflotsamtoxicfake_phishing2775phish hack0x219b9040eb7d8d8c2e8e84b87ce9ac1c83071980
    15
    ethereumflotsamtoxicfake_phishing1371phish hack0xf5289352f62ab27a4369780572c4799f58ca3563
    16
    ethereumflotsamtoxicfake_phishing2171phish hack0x8b661cdee484cafba8a00b9b304f622a54ff2a4e
    17
    ethereumflotsamtoxicfake_phishing250phish hack0x4bf722014e54aeab05fcf1519e6e4c0c3f742e43
    18
    ethereumflotsamtoxicfake_phishing5193phish hack0x96b31af8cb5c0eab92f44862407ef01332415ff0
    19
    ethereumflotsamtoxicfake_phishing649phish hack0x540c6f30ae667319e032a8988dcb81b28a960433
    20
    ethereumflotsamtoxicscbank.ioscbank.io0x4f3db6d4c97b8248ad5e244e4f619086084f6848
    ...
    1000
    108KB
    2s