LordkingPool Daily
    Updated 2025-04-13

    -- 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', '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'),
    ( '18', 'SWEAT', 'token.sweat'),
    ( '18', 'BRRR', 'token.burrow.near'),
    ( '8', 'WBTC', '2260fac5e5542a773aa44fbcfedf7c193bc2c599.factory.bridge.near'),
    ( '18', 'WETH', 'c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2.factory.bridge.near'),
    Last run: 12 days ago
    DAY
    POOL
    DAILY_USD_VOLUME
    DAILY_TRANSACTIONS
    DAILY_UNIQUE_SIGNERS
    1
    2025-04-13 00:00:00.000wNEAR - Gear 302.5185644
    2
    2025-04-12 00:00:00.000wNEAR - Gear 797.09312893
    3
    2025-04-11 00:00:00.000wNEAR - Gear 778.55413890
    4
    2025-04-11 00:00:00.000blackdragon - Gear 0.00111
    5
    2025-04-10 00:00:00.000wNEAR - Gear 967.169160103
    6
    2025-04-09 00:00:00.000wNEAR - Gear 1232.65149103
    7
    2025-04-08 00:00:00.000wNEAR - Gear 2210.733148101
    8
    2025-04-08 00:00:00.000USDC.e - Gear 0.03311
    9
    2025-04-07 00:00:00.000wNEAR - Gear 1653.79313995
    10
    2025-04-06 00:00:00.000wNEAR - Gear 1364.061162110
    11
    2025-04-06 00:00:00.000LONK - Gear 0.10211
    12
    2025-04-06 00:00:00.000AVB - Gear 0.05911
    13
    2025-04-06 00:00:00.000blackdragon - Gear 0.00411
    14
    2025-04-05 00:00:00.000wNEAR - Gear 603.88813195
    15
    2025-04-04 00:00:00.000wNEAR - Gear 993.968150103
    16
    2025-04-03 00:00:00.000wNEAR - Gear 1358.39147102
    17
    2025-04-03 00:00:00.000LONK - Gear 0.0311
    18
    2025-04-03 00:00:00.000blackdragon - Gear 011
    19
    2025-04-02 00:00:00.000wNEAR - Gear 6507.604150111
    20
    2025-04-02 00:00:00.000AVB - Gear 0.04511
    ...
    2444
    133KB
    14s