flipside

    EVMs New users (7 Days)
    IBC_insiderEVMs New users (7 Days)
    Updated 2025-03-27
    with t1 AS
    (
    (SELECT
    'Blast' AS CHain
    ,min(BLOCK_TIMESTAMP) AS Dote
    ,FROM_ADDRESS
    FROM
    blast.core.fact_transactions
    GROUP BY 3)

    UNION ALL

    (SELECT
    'Sei' AS CHain
    ,min(BLOCK_TIMESTAMP) AS Dote
    ,FROM_ADDRESS
    FROM
    sei.core_evm.fact_transactions
    GROUP BY 3)

    UNION ALL

    ((SELECT
    'Optimism' AS CHain
    ,min(BLOCK_TIMESTAMP) AS Dote
    ,FROM_ADDRESS
    FROM
    optimism.core.fact_transactions
    GROUP BY 3))


    UNION ALL

    ((SELECT
    'gnosis' AS CHain
    ,min(BLOCK_TIMESTAMP) AS Dote
    Last run: about 1 month ago
    New users
    DATE
    CHAIN
    TOTAL USERS
    1
    		1079462025-03-27 00:00:00.000base14056279
    2
    		1322025-03-27 00:00:00.000gnosis29938
    3
    		1562025-03-27 00:00:00.000Blast64072
    4
    		297922025-03-27 00:00:00.000arbitrum2279605
    5
    		24932025-03-27 00:00:00.000Optimism471950
    6
    		102602025-03-27 00:00:00.000Sei1523502
    7
    		20112025-03-27 00:00:00.000avalanche281331
    8
    		451562025-03-26 00:00:00.000Sei1513242
    9
    		9002025-03-26 00:00:00.000gnosis29806
    10
    		2913392025-03-26 00:00:00.000base13948333
    11
    		103992025-03-26 00:00:00.000Optimism469457
    12
    		4302025-03-26 00:00:00.000Blast63916
    13
    		1222392025-03-26 00:00:00.000arbitrum2249813
    14
    		103032025-03-26 00:00:00.000avalanche279320
    15
    		1150292025-03-25 00:00:00.000arbitrum2127574
    16
    		123562025-03-25 00:00:00.000Optimism459058
    17
    		5952025-03-25 00:00:00.000gnosis28906
    18
    		3913352025-03-25 00:00:00.000base13656994
    19
    		450822025-03-25 00:00:00.000Sei1468086
    20
    		141362025-03-25 00:00:00.000avalanche269017
    ...
    210
    10KB
    454s