niraVirtuals AI Agent Token Screener copy
    Updated 2025-01-03
    with launched as (
    SELECT
    date_trunc('day',block_timestamp) as launched_date,
    decoded_log:token::string as launched_token
    FROM base.core.ez_decoded_event_logs
    where contract_address = lower('0xF66DeA7b3e897cD44A5a231c61B6B4423d613259')
    and event_name = 'Launched'
    ),

    graduated as (
    SELECT
    date_trunc('day', block_timestamp) as graduation_date,
    decoded_log:agentToken::string as graduated_token
    FROM base.core.ez_decoded_event_logs
    where contract_address = lower('0xF66DeA7b3e897cD44A5a231c61B6B4423d613259')
    and event_name = 'Graduated'
    ),

    names as (
    SELECT
    graduated_token,
    name,
    symbol,
    datediff('day', graduation_date, current_Date()) as days_since_graduation
    from graduated left join base.core.dim_contracts on graduated_token = address
    ),

    virtual_price as (
    SELECT
    hour,
    token_address,
    price
    from base.price.ez_prices_hourly
    ),

    dex_data as (
    Last run: 3 months ago
    GRADUATED_TOKEN
    NAME
    SYMBOL
    DAYS_SINCE_GRADUATION
    LAUNCHED_PRICE
    CURRENT_PRICE
    MARKET_CAP_RAW
    CHANGE_IN_PRICE
    MARKET_CAP
    BUY_VOLUME
    SELL_VOLUME
    DEXSCREENER_LINK
    1
    0x4152e26fe66547415579e6205aa6dffacba920afDoTheySupportItBot by VirtualsDTSI10.0015409481310.0142437641514243764.1510622824.35%14.24M17.48M18.03Mhttps://dexscreener.com/base/0x4152e26fe66547415579e6205aa6dffacba920af
    2
    0x2efb2110f352fc98cd39dc041887c41766dbb301cr0w by VirtualsCROW30.001187298910.013540594713540594.6999851040.45%13.54M7.12M7.66Mhttps://dexscreener.com/base/0x2efb2110f352fc98cd39dc041887c41766dbb301
    3
    0xd9da0a693ea8057dcd97f02df6c98951acf92ef7CPA by VirtualsCPA30.0011789449040.0073936591947393659.19449126527.14%7.39M12.08M12.25Mhttps://dexscreener.com/base/0xd9da0a693ea8057dcd97f02df6c98951acf92ef7
    4
    0x8feef9f0ffa554e51220a3391e7bb7560526a72a0xsim by VirtualsSAGE 30.0013151037950.0069502654246950265.42394536428.5%6.95M1.69M1.89Mhttps://dexscreener.com/base/0x8feef9f0ffa554e51220a3391e7bb7560526a72a
    5
    0x6379219890843c0b9e3160044de072ced66baab2ThreatSlayerAI by VirtualsSLAYER30.001427848850.0050747408265074740.82595255255.41%5.07M4.3M4.48Mhttps://dexscreener.com/base/0x6379219890843c0b9e3160044de072ced66baab2
    6
    0xc8db98437bed9943f11c5b31b645b07c0efc17e0LEOONO by VirtualsLEO10.0015707892960.0045450131154545013.11491824189.35%4.55M2.04M2.2Mhttps://dexscreener.com/base/0xc8db98437bed9943f11c5b31b645b07c0efc17e0
    7
    0x7d0d1e23bbb6ff6e23f32e601680a1ed7d537424HERACLES by VirtualsHERAC00.0015234968940.0027228037162722803.7156608678.72%2.72M1.05M1.13Mhttps://dexscreener.com/base/0x7d0d1e23bbb6ff6e23f32e601680a1ed7d537424
    8
    0xd82eab40ed2393eb92974717b9c8683d5d5eaae5Condom Man Capital by VirtualsCMC10.0016479213020.0026941566572694156.6574796763.49%2.69M1.6M1.67Mhttps://dexscreener.com/base/0xd82eab40ed2393eb92974717b9c8683d5d5eaae5
    9
    0x776bc714752e33c95045250699c502cd2725615cMUSSEL by VirtualsMUSSEL00.0014238986230.0015637854481563785.448147079.82%1.56M22.73k30.33khttps://dexscreener.com/base/0x776bc714752e33c95045250699c502cd2725615c
    10
    0xc95e16f99267d6112eadaa46140bea095c8c7ba5Exmplr.ai by VirtualsEXMPLR20.0014090829160.0013554453681355445.36837839-3.81%1.36M2.3M2.3Mhttps://dexscreener.com/base/0xc95e16f99267d6112eadaa46140bea095c8c7ba5
    11
    0x7e74e0e4d58b3b5ac68af071bbd411f554e0a516Baldashin by VirtualsBALDA10.0016128426790.0011674679881167467.98848158-27.61%1.17M293.9k272.42khttps://dexscreener.com/base/0x7e74e0e4d58b3b5ac68af071bbd411f554e0a516
    12
    0xd7fbad6b0fdc6f41e990a17b7ff4e2c89c901309XAIXBT by VirtualsXAIXBT20.0013505038320.0011123661381112366.13781101-17.63%1.11M2.07M2.06Mhttps://dexscreener.com/base/0xd7fbad6b0fdc6f41e990a17b7ff4e2c89c901309
    13
    0x36a1c2c49981c16464f5bdeb6b07a98307092216Catarrini by VirtualsCAT10.0015562852770.0010047819011004781.9007143-35.44%1M298.72k269.36khttps://dexscreener.com/base/0x36a1c2c49981c16464f5bdeb6b07a98307092216
    14
    0x2ce1340f1d402ae75afeb55003d7491645db1857WAGMI by VirtualsWAGMI00.0015520528690.000977481526977481.526014664-37.02%977.48K323.95k287.97khttps://dexscreener.com/base/0x2ce1340f1d402ae75afeb55003d7491645db1857
    15
    0x9cc8c9c88ba07ce24d54597e174c4127c7995757ResearchSynth by VirtualsR20.001420490790.0009620487131962048.71309059-32.27%962.05K1.54M1.52Mhttps://dexscreener.com/base/0x9cc8c9c88ba07ce24d54597e174c4127c7995757
    16
    0x8aaf9fa1ee649eade46201394a9b8e06312f0f17Boofus by VirtualsBOOF00.0015507861020.0007281030384728103.038438392-53.05%728.1K410.33k357.83khttps://dexscreener.com/base/0x8aaf9fa1ee649eade46201394a9b8e06312f0f17
    17
    0xabf7347db2caea398aeb782beba624df92913ffdPredictoor by VirtualsPRDCT30.0013613325080.0004568773255456877.325524007-66.44%456.88K861.98k796khttps://dexscreener.com/base/0xabf7347db2caea398aeb782beba624df92913ffd
    18
    0xffdbd9e960971e9d8067fa1aa097fdea1d0a1404HorseAI by VirtualsHORSE10.0016656435510.0004314450861431445.086077745-74.1%431.45K929.98k844.75khttps://dexscreener.com/base/0xffdbd9e960971e9d8067fa1aa097fdea1d0a1404
    19
    0x55ff51da774b8ce0ed1abaed1cb76236bc6b2f16Voice of the Gods by VirtualsADM10.0016974792840.0002286733035228673.30351-86.53%228.67K2.23M2.11Mhttps://dexscreener.com/base/0x55ff51da774b8ce0ed1abaed1cb76236bc6b2f16
    20
    0xf6c26b7aa2ab5a9fa85c11e5d4af2c43da4ddab4Odin by VirtualsODIN30.0012072166750.0001920600896192060.08959664-84.09%192.06K722.45k627.31khttps://dexscreener.com/base/0xf6c26b7aa2ab5a9fa85c11e5d4af2c43da4ddab4
    20
    5KB
    13s