LordkingChange List
    Updated 2025-02-22



    -- hint:
    -- to use this query for other tokens, you should notice to two major points:
    -- 1- just replace (token contract) address with existing one.
    -- 2- take a look at (round) functions and be careful about them
    -- 3- somewhere, the lable of tokens like (Neko) were used. please kindly change the symbol
    -- pool_id


    with

    token_bonk as (
    select * from
    ( values
    ( '24', 'Neko', 'ftv2.nekotoken.near'),
    ( '6', 'USDC.e', 'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near'),
    ( '24', 'wNEAR', 'wrap.near'),
    ( '8', 'USMeme', 'usmeme.tg'),

    ( '8', 'MEPT', 'pre.meteor-token.near'),
    ( '8', 'NEARVIDIA', 'nearnvidia.near'),
    ( '18', 'UWON ', '438e48ed4ce6beecf503d43b9dbd3c30d516e7fd.factory.bridge.near'),
    ( '6', 'USDT.e', 'dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near'),
    ( '24', 'blackdragon', 'blackdragon.tkn.near'),
    ( '18', 'REF', 'token.v2.ref-finance.near'),
    ( '24', 'LiNEAR', 'linear-protocol.near'),
    ( '8', 'LONK', 'token.lonkingnearbackto2024.near'),
    ( '18', 'DAI', '6b175474e89094c44da98b954eedeac495271d0f.factory.bridge.near'),
    ( '18', 'Woo', '4691937a7508860f876c9c0a2a617e7d9e945d4b.factory.bridge.near'),
    ( '6', 'USDT', 'usdt.tether-token.near'),
    ( '6', 'USDC', '17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1'),
    ( '18', 'OCT', 'f5cfbc74057c610c8ef151a439252680ac68c6dc.factory.bridge.near'),
    ( '18', 'Aurora', 'aaaaaa20d9e0e2461697782ef11675f668207961.factory.bridge.near'),
    Last run: about 2 months ago
    period
    Unique Swaps
    Unique Swappers
    Total Volume (USD)
    Unique Buyers
    Unique Sellers
    Total Buy Volume (USD)
    Total Sell Volume (USD)
    1
    Last 1 Day1428166481515323325
    2
    Last 7 Days14349879904638047205184
    3
    Last 30 Days61864275700162092223402335993
    4
    Total72217144569278411981124342871349913
    4
    273B
    6s