flipside

    EVMs New users (180 Days)
    IBC_insiderEVMs New users (180 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
    		24932025-03-27 00:00:00.000Optimism3202866
    2
    		297922025-03-27 00:00:00.000arbitrum10614699
    3
    		1079462025-03-27 00:00:00.000base92959100
    4
    		20112025-03-27 00:00:00.000avalanche2197231
    5
    		1322025-03-27 00:00:00.000gnosis386821
    6
    		102602025-03-27 00:00:00.000Sei14249522
    7
    		1562025-03-27 00:00:00.000Blast225615
    8
    		103992025-03-26 00:00:00.000Optimism3200373
    9
    		103032025-03-26 00:00:00.000avalanche2195220
    10
    		9002025-03-26 00:00:00.000gnosis386689
    11
    		2913392025-03-26 00:00:00.000base92851154
    12
    		4302025-03-26 00:00:00.000Blast225459
    13
    		451562025-03-26 00:00:00.000Sei14239262
    14
    		1222392025-03-26 00:00:00.000arbitrum10584907
    15
    		151792025-03-25 00:00:00.000Blast225029
    16
    		5952025-03-25 00:00:00.000gnosis385789
    17
    		141362025-03-25 00:00:00.000avalanche2184917
    18
    		3913352025-03-25 00:00:00.000base92559815
    19
    		1150292025-03-25 00:00:00.000arbitrum10462668
    20
    		450822025-03-25 00:00:00.000Sei14194106
    ...
    1260
    62KB
    453s