carlesmontalaDESCEN.POWER GOVERNANCE II-3
    Updated 2022-11-08
    with tab1 as (
    SELECT
    validator_address,
    min(date_trunc('week', block_timestamp)) as min_week
    FROM osmosis.core.fact_staking where currency LIKE 'uosmo'
    GROUP BY 1
    )
    SELECT
    *,
    sum(new_validators) over (ORDER by min_week) as cume_val
    FROM (
    SELECT
    min_week,
    count(*) as new_validators
    FROM tab1
    GROUP BY 1
    )
    Run a query to Download Data