Afonso_DiazOvertime
    Updated 10 days ago
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    sender as user
    from
    aptos.core.fact_transactions
    where
    success
    and payload_function ilike '0x68476f9d437e3f32fd262ba898b5e3ee0a23a1d586a6cf29a28add35f253f6f7%'
    ),

    overtime as (
    select
    date_trunc('{{ period }}', block_timestamp) as date,
    count(distinct tx_hash) as transactions,
    count(distinct user) as users,
    sum(transactions) over (order by date) as cumulative_transactions
    from main
    group by 1
    ),

    new_users as (
    select
    date_trunc('{{ period }}', min_date) as date,
    count(distinct user) as new_user
    from (
    select
    user,
    min(block_timestamp)::date as min_date
    from main
    group by 1
    )
    group by 1
    Last run: 10 days ago
    DATE
    TRANSACTIONS
    USERS
    CUMULATIVE_TRANSACTIONS
    NEW_USERS
    RETURNING_USERS
    1
    2024-07-01 00:00:00.00039152391520
    2
    2024-08-01 00:00:00.00020961245721352242235
    3
    2024-09-01 00:00:00.000159131987372651657330
    4
    2024-10-01 00:00:00.0004696760728423249441128
    5
    2024-11-01 00:00:00.00045909630313014145281775
    6
    2024-12-01 00:00:00.00037098503416723929482086
    7
    2025-01-01 00:00:00.00023727334219096614901852
    8
    2025-02-01 00:00:00.0002582922542167958331421
    9
    2025-03-01 00:00:00.00040079414025687425421598
    10
    2025-04-01 00:00:00.00056225310631309911531953
    11
    2025-05-01 00:00:00.00045529279235862810581734
    11
    598B
    121s