hessmonthly new Stakers
    Updated 2 days ago
    with new as (select min(block_timestamp) as daily,
    DELEGATOR_ADDRESS
    from axelar.gov.fact_staking
    where action = 'delegate'
    group by 2
    )


    select trunc(daily,'month') as monthly,
    count(DISTINCT DELEGATOR_ADDRESS) as new_staker,
    sum(new_staker) over (order by monthly asc) as cumulative_new_staker
    from new
    group by 1
    Last run: 2 days ago
    MONTHLY
    NEW_STAKER
    CUMULATIVE_NEW_STAKER
    1
    2024-11-01 00:00:00.00065038100
    2
    2024-09-01 00:00:00.00040536253
    3
    2021-12-01 00:00:00.00066
    4
    2023-07-01 00:00:00.00048511245
    5
    2024-05-01 00:00:00.000145133667
    6
    2023-05-01 00:00:00.00057810325
    7
    2022-08-01 00:00:00.000574
    8
    2024-02-01 00:00:00.000400527351
    9
    2025-06-01 00:00:00.00023341407
    10
    2024-06-01 00:00:00.00077334440
    11
    2023-09-01 00:00:00.00038712223
    12
    2024-07-01 00:00:00.00085535295
    13
    2024-10-01 00:00:00.000119737450
    14
    2025-03-01 00:00:00.00043640497
    15
    2024-01-01 00:00:00.000710223346
    16
    2023-02-01 00:00:00.0007658202
    17
    2024-03-01 00:00:00.000321030561
    18
    2022-11-01 00:00:00.00010645527
    19
    2022-12-01 00:00:00.00010156542
    20
    2024-12-01 00:00:00.00083838938
    43
    2KB
    2s