flipside

    Users' Retention Over Time (Stablejack ) V2
    Ali3NUsers' Retention Over Time (Stablejack ) V2
    Updated 2025-03-18
    with stablejackt as (
    select '0x013b34dba0d6c9810f530534507144a8646e3273' as address

    union all

    select '0x0363a3debe776de575c36f524b7877db7dd461db' as address

    union all

    select '0x698c34bad17193af7e1b4eb07d1309ff6c5e715e' as address

    union all

    select '0xabe7a9dfda35230ff60d1590a929ae0644c47dc1' as address

    union all

    select '0x8a63943ac3f394ed73c7b06fecf3a81bc11b840e' as address

    union all

    select '0x46080cd724102ac0e1d4d1fb45474d14e175a8f9' as address

    union all

    select '0xb79a06e4cbf379f4676983d1a6d83e996c3a63c4' as address

    union all

    select '0xdb8b3bd77b7a28c2835c9e8e3c15f7adbc2cd267' as address
    ),

    userst as(
    select origin_from_address,
    block_timestamp,
    tx_hash,
    Last run: about 1 month ago
    MINDATE
    New Wallets
    New Active Users
    Cumulative New Wallets
    Cumulative Active Users
    Active Only 1 Month
    Active >= 2 Months
    Active >= 3 Months
    Active >= 6 Months
    Active >= 12 Month
    1
    		2025-03-17 00:00:00.00040349450624641030802548414
    2
    		2025-03-16 00:00:00.00040349050624601030802548414
    3
    		2025-03-15 00:00:00.00020348650624571029802548414
    4
    		2025-03-14 00:00:00.00030348450624551029802548414
    5
    		2025-03-13 00:00:00.00020348150624521029802548414
    6
    		2025-03-12 00:00:00.00060347950624511028801548414
    7
    		2025-03-11 00:00:00.00020347350624471026801548414
    8
    		2025-03-10 00:00:00.00010347150624451026801548414
    9
    		2025-03-09 00:00:00.00020347050624441026801548414
    10
    		2025-03-07 00:00:00.000100346850624431025801548414
    11
    		2025-03-06 00:00:00.00090345850624361022799547414
    12
    		2025-03-05 00:00:00.000100344950624291020798547414
    13
    		2025-03-04 00:00:00.00040343950624231016796547414
    14
    		2025-03-03 00:00:00.00070343550624201015796547414
    15
    		2025-03-02 00:00:00.00060342850624161012794547414
    16
    		2025-03-01 00:00:00.00050342250624111011794547414
    17
    		2025-02-28 00:00:00.000110341750624071010794547414
    18
    		2025-02-27 00:00:00.00060340650624031003790547414
    19
    		2025-02-26 00:00:00.00050340050623991001789547414
    20
    		2025-02-25 00:00:00.0002033955062396999788547414
    ...
    249
    15KB
    15s