anomoneAlgorand rewards - complete distribution
    Updated 2022-02-04
    /*SELECT ADDRESS , 100* REWARDS_TOTAL/ ( SELECT sum(REWARDS_TOTAL) from algorand.account ) FROM algorand.account
    where
    -- MAX(REWARDS_TOTAL) = 25358653.059435
    SELECT COUNT(*) FROM algorand.account
    WHERE account_closed = 'FALSE'
    */
    select concat(bucket * 100000, '-', (bucket * 100000 - 1) + 100000) as prange, count(REWARDS_TOTAL)
    from
    (select *, floor(REWARDS_TOTAL/100000) as bucket
    from algorand.account
    )
    group by bucket
    order by bucket
    Run a query to Download Data