Afonso_DiazOvertime
    Updated 10 days ago
    with

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

    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-08-01 00:00:00.000205414020541400
    2
    2024-09-01 00:00:00.00013767189015821180288
    3
    2024-10-01 00:00:00.0007040101322861836177
    4
    2024-11-01 00:00:00.0004117597464036695279
    5
    2024-12-01 00:00:00.00010660101174696703308
    6
    2025-01-01 00:00:00.0005180104679876602444
    7
    2025-02-01 00:00:00.0009532114689408817329
    8
    2025-03-01 00:00:00.000154081210104816771439
    9
    2025-04-01 00:00:00.00012379788117195273515
    10
    2025-05-01 00:00:00.0008287507125482156351
    10
    522B
    85s