i_danawake-gold
    Updated 10 days ago
    Select *
    FROM ronin.core.dim_labels
    --WHERE address_name ILIKE '%pirate%'
    -- OR label ILIKE '%pirate%'
    Last run: 10 days ago
    BLOCKCHAIN
    CREATOR
    ADDRESS
    ADDRESS_NAME
    LABEL_TYPE
    LABEL_SUBTYPE
    LABEL
    DIM_LABELS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    roninflipside0x97797358f0d12aee117209c15d964ee0022bf1aasidekicksnftnf_token_contractsidekicks4be07661165e4f000df2119f2f3ab1002025-02-13 15:39:24.3712025-02-13 15:39:24.371
    2
    roninflipside0x879f7b62b1da5d5843ef4d343e8e8f210c6095b9pihtnftnf_token_contractpiht6c07da164dc38a13da0b4d23582a08c82025-02-13 15:39:24.3712025-02-13 15:39:24.371
    3
    roninflipside0x47b5a7c2e4f07772696bbf8c8c32fe2b9eabd550moki collectionnftnf_token_contractmoki collection11f05396341338611e144fd4e561afd92025-02-13 15:39:24.3712025-02-13 15:39:24.371
    4
    roninflipside0x9b959d27840a31988410ee69991bcf0110d61f02validatoroperatorvalidatorvalidatorc0fb9f5341d572a8f18de85adee9800d2025-02-13 15:39:24.3712025-02-13 15:39:24.371
    5
    roninflipside0xcf113ca9ce5259050e95c70750121a7fc12673a7hitbtc: hot walletcexhot_wallethitbtc1d9c74ab1cd7a3ff7744b352a9e018d32025-02-13 15:39:24.3712025-02-13 15:39:24.371
    6
    roninflipside0x9fbeb5dc51974f1c88e20a3d4df3bf33ce554719okx: hot walletcexhot_walletokx15cc667c100021e32dba3ad2e2e5bcf82025-02-13 15:39:24.3712025-02-13 15:39:24.371
    7
    roninflipside0x5c2bfcf9c17cd53d55033769727196736cd188b3zkme identity soulbound tokennftnf_token_contractzkme identity soulbound token8e502beffe120490f4021f448c35369f2025-02-13 15:39:24.3712025-02-13 15:39:24.371
    8
    roninflipside0x72288a7f32bec9de4a42bd19a746b9e7798996bbprimal heroznftnf_token_contractprimal herozcb2ab960108498e4bf87d9cb997257f22025-02-13 15:39:24.3712025-02-13 15:39:24.371
    9
    roninflipside0xeaa05784e6da3ee53027dc0507cf3970c246c638pimtnftnf_token_contractpimt28907116908f68e64b14c5613f6036512025-02-13 15:39:24.3712025-02-13 15:39:24.371
    10
    roninflipside0x814a9c959a3ef6ca44b5e2349e3bba9845393947axie charmnftnf_token_contractaxie charm8319124a0f9776fe7662d568ba9c0f3c2025-02-13 15:39:24.3712025-02-13 15:39:24.371
    11
    roninflipside0xcedb8e5c29dc498b8d805852b531849af91dfae3apeironapostlenftnf_token_contractapeironapostle949597e2b5674873b95d51e7f4c1675d2025-02-13 15:39:24.3712025-02-13 15:39:24.371
    12
    roninflipside0x17770acd983e92151468cdcd1646c08840034df9katana: weth / wron 0.01%dexpoolkatanab66dc63d19f83d04e5553e0aa4c0efec2025-02-13 15:39:24.3712025-02-13 15:39:24.371
    13
    roninflipside0xb24bc60ca9b346cdd1ef2e91145d196b988b6098katana: kanstar / wron 0.3%dexpoolkatana3f785c86f297cb17c1f54473bcfd60dd2025-02-13 15:39:24.3712025-02-13 15:39:24.371
    14
    roninflipside0xe0042bffba452767e68ed4a0289ae5873281eb8bpuzzlechampionsnftnftnf_token_contractpuzzlechampionsnftdeea0d856a6a95e9a9d521cd3ef41dfc2025-02-13 15:39:24.3712025-02-13 15:39:24.371
    15
    roninflipside0x312bc45785596455e8bd935b5423c063c70fa3f6test genesis nftnftnf_token_contracttest genesis nft078a627836f77575292cdd42d7468faa2025-02-13 15:39:24.3712025-02-13 15:39:24.371
    16
    roninflipside0x2a6120978d3f868299aa020303b93b9a90f257cffightleaguecharactersnftnf_token_contractfightleaguecharacters43e1f6ddfb6b2c9430e57588a049287f2025-02-13 15:39:24.3712025-02-13 15:39:24.371
    17
    roninflipside0xd061161d99f252c5515dd13644765161ee226f67puff generalnftnf_token_contractpuff general6005ee54af7487717cdc97847a84b17e2025-02-13 15:39:24.3712025-02-13 15:39:24.371
    18
    roninflipside0xb99bcb13c4a6a9946880253e5448eb9096cd970aaxiemementonftnf_token_contractaxiemementoaa225d736a7eb17a2625ce7e7706ca662025-02-13 15:39:24.3712025-02-13 15:39:24.371
    19
    roninflipside0x8c811e3c958e190f5ec15fb376533a3398620500axie landnftnf_token_contractaxie landa2f665ded4ebd6eb23441b5916ac61542025-02-13 15:39:24.3712025-02-13 15:39:24.371
    20
    roninflipside0xffdfdfc307632d3199d8c639e6b2608025d424d4katana: zent / wrondexpoolkatana0a08b34d7c8fb317922d212bbfce6dca2025-02-13 15:39:24.3712025-02-13 15:39:24.371
    ...
    370
    74KB
    1s