nsa2000Node Performance (weekly)
    Updated 2022-10-05
    with pooled_validators as (
    select distinct node_address from (
    select
    split(memo,':')[1] as node_address,
    split(memo,':')[2] as bond_provider_address,
    asset_e8/1e8 as rune_amount,
    *
    from thorchain.bond_events
    where memo like 'BOND:%:%'
    )
    ),
    classic_validators as (
    select distinct node_address from (
    select
    split(memo,':')[1] as node_address,
    from_address as bond_provider_address,
    asset_e8/1e8 as rune_amount,
    *
    from thorchain.bond_events
    where memo not like 'BOND:%:%' and memo like 'BOND:%'
    order by node_address
    )
    ),
    txns as (
    select
    iff(p.node_address is null, 'classic', 'pooled') as type,
    s.*
    from thorchain.slash_points s
    left join pooled_validators p
    on p.node_address = s.node_address
    )

    select
    date_trunc('{{date_range}}',block_timestamp) as date,
    type,
    reason,
    Run a query to Download Data