flipside

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

    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.000859265
    2
    		2023-06-01 00:00:00.0001253876
    3
    		2023-07-01 00:00:00.0001062448
    4
    		2023-03-01 00:00:00.0001552974
    5
    		2023-01-01 00:00:00.0002001649
    6
    		2023-05-01 00:00:00.0001751502
    7
    		2023-08-01 00:00:00.000995350
    8
    		2023-09-01 00:00:00.0001195148
    9
    		2023-12-01 00:00:00.0001125831
    10
    		2023-02-01 00:00:00.000694268
    11
    		2023-04-01 00:00:00.0001750675
    12
    		2023-11-01 00:00:00.000997537
    12
    429B
    92s