flipside

    Sample 1
    MotilolaSample 1
    Updated 2025-02-02
    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
    g.graduated_token,
    c.name,
    c.symbol,
    DATEDIFF('day', g.graduation_date, CURRENT_DATE) AS days_since_graduation
    FROM
    graduated g
    LEFT JOIN base.core.dim_contracts c ON g.graduated_token = c.address
    )

    SELECT
    l.launched_token,
    c.name,
    Last run: 2 months ago
    LAUNCHED_TOKEN
    NAME
    SYMBOL
    LAUNCHED_DATE
    GRADUATION_DATE
    DAYS_SINCE_GRADUATION
    1
    		0x6aaf76b2724e4220b9ff36ab325e9463a3f92feb2025-02-02 00:00:00.000
    2
    		0xfbc0386c552c062459852429966c549bdc19944cfun AIBTCAIBTC2025-02-02 00:00:00.000
    3
    		0x8cda12b492d1c096cde008a1e2a831537fcf3234fun CybercentryCENTRY2025-02-02 00:00:00.000
    4
    		0x333c3e745bb058c8987bb376a317c25f1c386530fun BASEDCHESH2025-02-02 00:00:00.000
    5
    		0xfb92d44bda3d3ead2efc1f662810cb2e8ee7c867fun DolphStep DOLPH2025-02-02 00:00:00.000
    6
    		0x787d2141396db7df371aff1687f06c17ec14cf1dfun Sevant SEVANT2025-02-02 00:00:00.000
    7
    		0x41f3d67fa3666299d1135333a4e85c71c326decd2025-02-02 00:00:00.000
    8
    		0xdffaeb57ac093d519baaad4734dae18ca79d534e2025-02-02 00:00:00.000
    9
    		0x46f571b22665834ba816607bf038e91557814d0bfun Pro AgentPA2025-02-02 00:00:00.000
    10
    		0xe1215024244b056b6abdcca8e83fb62b5cf99da92025-02-02 00:00:00.000
    11
    		0x68c0e86189ca865de9afd529834a1e0c632238272025-02-01 00:00:00.000
    12
    		0xeb3908eb950cf72dd4332b061b12a21e484a43b52025-02-01 00:00:00.000
    13
    		0x59159905a22b499355aa3a15d60e24abf414c125fun VORTEXVRTX2025-02-01 00:00:00.000
    14
    		0x0943bf6af5f5900a02f0b040582cfc86b0a070f52025-02-01 00:00:00.000
    15
    		0x11d6047800b213ac3d1b7993430e2bef683ff4e12025-02-01 00:00:00.000
    16
    		0x6ad737a27ac9193eab9d1b1910fa6e047fb6ee33fun ANTI ICONICON2025-02-01 00:00:00.000
    17
    		0x930607ab18bda5043defa20bd24208eb905c3b4bfun docDOC2025-02-01 00:00:00.000
    18
    		0x8faaad3dbb66a6ba12aaaa6a8c9c367964e6555a2025-02-01 00:00:00.000
    19
    		0xbe583aefa5a285833af0d1ef25a79dd43620c886fun Beff AIBEFFAI2025-02-01 00:00:00.000
    20
    		0x8cdec6f8ebb027ba187278849b2632bd6ce4aa08fun ResumAIRESUME2025-02-01 00:00:00.000
    ...
    14724
    1MB
    12s