flipside

    Users acquired all chains
    Flipside CommunityUsers acquired all chains
    Updated 2025-02-04
    /*
    Charlie: 2024-01-10 change log
    - fixed Bitcoin (fixed month filter to < 2024) #ffd6e7
    - added Solana #ae9cb6
    */

    /*

    with polygon as (
    select date_trunc('month', block_timestamp) as month, count(from_address) as acquired_users,
    from polygon.core.fact_transactions
    where nonce=1
    and block_timestamp >= '2023-01-01'
    and block_timestamp < '2024-01-01'
    group by month
    )
    */

    with polygon as (
    select date_trunc('month', block_timestamp) as month, count(from_address) as acquired_users,
    'polygon' as chain
    from polygon.core.fact_transactions
    where nonce=1
    and block_timestamp >= '2023-01-01'
    and block_timestamp < '2024-01-01'
    group by month, chain
    ),

    ethereum as (
    select date_trunc('month', block_timestamp) as month, count(from_address) as acquired_users,
    'ethereum' as chain
    from ethereum.core.fact_transactions
    where nonce=1
    and block_timestamp >= '2023-01-01'
    and block_timestamp < '2024-01-01'
    group by month, chain
    Last run: 3 months ago
    MONTH
    ACQUIRED_USERS
    CHAIN
    1
    		2023-12-01 00:00:00.000274736optimism
    2
    		2023-05-01 00:00:00.000938006arbitrum
    3
    		2023-09-01 00:00:00.000368465base
    4
    		2023-09-01 00:00:00.0001195148polygon
    5
    		2023-12-01 00:00:00.000736482arbitrum
    6
    		2023-02-01 00:00:00.000241804arbitrum
    7
    		2023-08-01 00:00:00.000834737bitcoin
    8
    		2023-01-01 00:00:00.0002001649polygon
    9
    		2023-03-01 00:00:00.0001552974polygon
    10
    		2023-10-01 00:00:00.000405090base
    11
    		2023-03-01 00:00:00.00060357avalanche
    12
    		2023-11-01 00:00:00.000788257arbitrum
    13
    		2023-10-01 00:00:00.000878424bitcoin
    14
    		2023-10-01 00:00:00.000139416optimism
    15
    		2023-01-01 00:00:00.000162870optimism
    16
    		2023-03-01 00:00:00.0001249943ethereum
    17
    		2023-06-01 00:00:00.000417943optimism
    18
    		2023-04-01 00:00:00.0001750675polygon
    19
    		2023-08-01 00:00:00.000554335arbitrum
    20
    		2023-08-01 00:00:00.000633300base
    79
    4KB
    295s