datavortexTop Tokens
    Updated 2025-05-04
    WITH TokenCounts AS (
    SELECT
    CASE
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'sol-c58e6539c2f2e097c251f8edf11f9c03e581f8d4.omft.near' THEN 'TURBO'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'eth-0xdac17f958d2ee523a2206206994597c13d831ec7.omft.near' THEN 'USDT.e'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'sol-df27d7abcc1c656d4ac3b1399bbfbba1994e6d8c.omft.near' THEN 'TURBO'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'token.sweat' THEN 'SWEAT'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'zec.omft.near' THEN 'ZEC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'gnear-229.meme-cooking.near' THEN 'GNEAR'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'abg-966.meme-cooking.near' THEN 'ABG'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'token.0xshitzu.near' THEN 'SHITZU'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'gnosis-0xddafbb505ad214d7b80b1f830fccc89b60fb7a83.omft.near' THEN 'USDC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'gnosis-0x4d18815d14fe5c3304e87b3fa18318baa5c23820.omft.near' THEN 'SAFE(GNOSIS)'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'arb-0xaf88d065e77c8cc2239327c5edb3a432268e5831.omft.near' THEN 'USDC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'eth-0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9.omft.near' THEN 'AAVE'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'blackdragon.tkn.near' THEN 'BLACKDRAGON'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'gnosis-0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1.omft.near' THEN 'WETH'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'sol-c800a4bd850783ccb82c2b2c7e84175443606352.omft.near' THEN 'USDT'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'base-0x833589fcd6edb6e08f4c7c32d4f71b54bda02913.omft.near' THEN 'USDC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'bera.omft.near' THEN 'BERA'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'token.v2.ref-finance.near' THEN 'REF'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'sol.omft.near' THEN 'SOL'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'doge.omft.near' THEN 'DOGE'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'aaaaaa20d9e0e2461697782ef11675f668207961.factory.bridge.near' THEN 'AURORA'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'noear-324.meme-cooking.near' THEN 'NOEAR'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'eth-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.omft.near' THEN 'USDC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'sol-d600e625449a4d9380eaf5e3265e54c90d34e260.omft.near' THEN 'MELANIA'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'eth-0x6b175474e89094c44da98b954eedeac495271d0f.omft.near' THEN 'DAI'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'btc.omft.near' THEN 'BTC'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'btc.omft.near' THEN 'ETH'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'a35923162c49cf95e6bf26623385eb431ad920d3.factory.bridge.near' THEN 'NEAR(FACTORY)'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'aurora' THEN 'AURORA'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'mpdao-token.near' THEN 'MPDAO'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'arb-0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9.omft.near' THEN 'USDT'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'base.omft.near' THEN 'ETH'
    WHEN SPLIT_PART(token_id, 'nep141:', 2) = 'arb-0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a.omft.near' THEN 'GMX'
    Last run: 28 days ago
    TOKEN_SYMBOL
    TRANSACTION_COUNT
    1
    Unknown64732
    2
    USDC52203
    3
    wNEAR42030
    4
    ZEC28494
    5
    USDT.e24811
    6
    USDT21498
    7
    USN11781
    8
    BTC8787
    9
    ETH7104
    10
    SOL7023
    10
    149B
    2s