nsa2000Daily pooled validator participants over time
    Updated 2022-09-20
    WITH
    tab1 as (
    SELECT
    trunc(block_timestamp,'day') as days,
    substring(memo, CHARINDEX('UNBOND:', memo) + 7, CHARINDEX('UNBOND:', memo) + 42) as operator,
    count(distinct tx_id) as participations,
    --cum(bonds) over (partition by operator order by days) as cum_bonds,
    sum(e8/pow(10,8)) as rune_to_unbond
    --sum(bonded) over (partition by operator order by days) as cum_rune_to_unbond
    FROM thorchain.bond_events
    WHERE bond_type = 'bond_returned' and memo like '%UNBOND:%' and CHARINDEX('UNBOND:', memo) > 0
    group by 1,2
    ORDER BY 1
    )
    SELECT
    days,
    operator,
    participations, sum(participations) over (partition by operator order by days) as cum_participations,
    rune_to_unbond, sum(rune_to_unbond) over (partition by operator order by days) as cum_rune_to_unbond
    from tab1
    order by 1 asc
    Run a query to Download Data