flipside

    01) creation stats monthly - BASE
    Flipside Community01) creation stats monthly - BASE
    Updated 2025-02-04
    with acquired_transaction as (
    select from_address,(block_timestamp) as acquired_time
    from base.core.fact_transactions
    where nonce=1

    )

    select date_trunc('month',acquired_time) as month, count(distinct from_address) as acquired_users
    from acquired_transaction
    where acquired_time between '2023-01-01' and '2024-01-01'
    group by month


    Last run: 3 months ago
    MONTH
    ACQUIRED_USERS
    1
    		2023-10-01 00:00:00.000405090
    2
    		2023-08-01 00:00:00.000633300
    3
    		2023-09-01 00:00:00.000368465
    4
    		2023-06-01 00:00:00.00015
    5
    		2023-07-01 00:00:00.000131331
    6
    		2023-11-01 00:00:00.000180981
    7
    		2023-12-01 00:00:00.000221728
    7
    242B
    60s