nsa2000Total amount of NEAR UNdelegated per validator
    Updated 2022-09-14
    ---ref: https://cityofnear.xyz/
    SELECT
    tx_receiver as governor,
    COUNT(DISTINCT tx_signer) as number_of_unstakers,
    COUNT(DISTINCT a.TX_HASH) as number_transactions,
    try_parse_json(replace(args, '\\')):amount as amount, -- raw amount
    SUM(div0(ZEROIFNULL(amount),pow(10,24))) as near_unstaked,
    iff(args::string LIKE '%,%',1,0) as check_sys
    FROM near.core.fact_actions_events_function_call a
    JOIN near.core.fact_transactions b
    ON a.tx_hash = b.tx_hash
    WHERE tx_receiver ilike '%.pool%'
    AND method_name in ('unstake_all', 'unstake')
    AND check_sys = 0
    GROUP BY governor, args
    ORDER BY near_unstaked DESC -- Top 50 proposals by amounts unstaked
    LIMIT 50
    Run a query to Download Data