mmdrezaDaily Number of New and Total Flow Delegators
    Updated 2023-05-10
    select
    mindate::date as date,
    count (distinct delegator) as new_users,
    sum (new_users) over (order by date) as total_users
    from (
    select delegator,min(block_timestamp) as mindate from flow.core.ez_staking_actions
    where tx_succeeded = 'TRUE'
    and Block_timestamp >= '2023-01-01'
    group by 1)
    group by 1
    Run a query to Download Data