freeman_7New users
    Updated 2024-12-31
    with slipstream as (
    select
    date_trunc({{period}}, block_timestamp) as date_time,
    origin_from_address as address,
    row_number() over(
    partition by address
    order by
    block_timestamp
    ) as nu
    from
    base.defi.ez_dex_swaps
    where
    platform in ('aerodrome', 'aerodrome-slipstream')
    )
    SELECT
    date_time,
    CASE
    when nu = 1 then 'new user'
    else 'regular user'
    end as classify,
    count(distinct address) as total_users
    from
    slipstream
    group by
    1,
    2
    order by
    1 asc
    Last run: 3 months ago
    DATE_TIME
    CLASSIFY
    TOTAL_USERS
    1
    2023-08-28 00:00:00.000new user8536
    2
    2023-08-28 00:00:00.000regular user6493
    3
    2023-09-04 00:00:00.000regular user5792
    4
    2023-09-04 00:00:00.000new user4072
    5
    2023-09-11 00:00:00.000regular user5321
    6
    2023-09-11 00:00:00.000new user3553
    7
    2023-09-18 00:00:00.000new user3688
    8
    2023-09-18 00:00:00.000regular user5331
    9
    2023-09-25 00:00:00.000new user5074
    10
    2023-09-25 00:00:00.000regular user6782
    11
    2023-10-02 00:00:00.000regular user7906
    12
    2023-10-02 00:00:00.000new user6500
    13
    2023-10-09 00:00:00.000regular user6884
    14
    2023-10-09 00:00:00.000new user5071
    15
    2023-10-16 00:00:00.000new user6244
    16
    2023-10-16 00:00:00.000regular user7963
    17
    2023-10-23 00:00:00.000new user4329
    18
    2023-10-23 00:00:00.000regular user6311
    19
    2023-10-30 00:00:00.000regular user5829
    20
    2023-10-30 00:00:00.000new user3953
    ...
    142
    6KB
    18s