with main AS ( select CASE WHEN amount <= 20 THEN '01 [0,20]' WHEN amount > 20 AND amount <= 40 THEN '02 (20,40]' WHEN amount > 40 AND amount <= 60 THEN '03 (40,60]' WHEN amount > 60 AND amount <= 80 THEN '04 (60,80]' WHEN amount > 80 AND amount <= 100 THEN '05 (80,100]' WHEN amount > 100 AND amount <= 120 THEN '06 (100,120]' WHEN amount > 120 AND amount <= 140 THEN '07 (120,140]' WHEN amount > 140 AND amount <= 160 THEN '08 (140,160]' WHEN amount > 160 AND amount <= 180 THEN '09 (160,180]' WHEN amount > 180 AND amount <= 200 THEN '10 (180,200]' WHEN amount > 200 AND amount <= 220 THEN '11 (200,220]' WHEN amount > 220 AND amount <= 240 THEN '12 (220,240]' WHEN amount > 240 AND amount <= 260 THEN '13 (240,260]' WHEN amount > 260 AND amount <= 280 THEN '14 (260,280]' WHEN amount > 280 AND amount <= 300 THEN '15 (280,300]' WHEN amount > 300 AND amount <= 320 THEN '16 (300,320]' WHEN amount > 320 AND amount <= 340 THEN '17 (320,340]' WHEN amount > 340 AND amount <= 360 THEN '18 (340,360]' WHEN amount > 360 AND amount <= 380 THEN '19 (360,380]' WHEN amount > 380 AND amount <= 400 THEN '20 (380,400]' WHEN amount > 400 AND amount <= 420 THEN '21 (400,420]' WHEN amount > 420 AND amount <= 440 THEN '22 (420,440]' WHEN amount > 440 AND amount <= 460 THEN '23 (440,460]' WHEN amount > 460 AND amount <= 480 THEN '24 (460,480]' WHEN amount > 480 AND amount <= 500 THEN '25 (480,500]' WHEN amount > 500 AND amount <= 520 THEN '26 (500,520]' WHEN amount > 520 AND amount <= 540 THEN '27 (520,540]' WHEN amount > 540 AND amount <= 560 THEN '28 (540,560]' WHEN amount > 560 AND amount <= 580 THEN '29 (560,580]' WHEN amount > 580 AND amount <= 600 THEN '30 (580,600]' WHEN amount > 600 AND amount <= 620 THEN '31 (600,620]' WHEN amount > 620 AND amount <= 640 THEN '32 (620,640]' WHEN amount > 640 AND amount <= 660 THEN '33 (640,660]' WHEN amount > 660 AND amount <= 680 THEN '34 (660,680]' WHEN amount > 680 AND amount <= 700 THEN '35 (680,700]' WHEN amount > 700 AND amount <= 720 THEN '36 (700,720]' WHEN amount > 720 AND amount <= 740 THEN '37 (720,740]' WHEN amount > 740 AND amount <= 760 THEN '38 (740,760]' WHEN amount > 760 AND amount <= 780 THEN '39 (760,780]' WHEN amount > 780 AND amount <= 800 THEN '40 (780,800]' WHEN amount > 800 AND amount <= 820 THEN '41 (800,820]' WHEN amount > 820 AND amount <= 840 THEN '42 (820,840]' WHEN amount > 840 AND amount <= 860 THEN '43 (840,860]' WHEN amount > 860 AND amount <= 880 THEN '44 (860,880]' WHEN amount > 880 AND amount <= 900 THEN '45 (880,900]' WHEN amount > 900 AND amount <= 920 THEN '46 (900,920]' WHEN amount > 920 AND amount <= 940 THEN '47 (920,940]' WHEN amount > 940 AND amount <= 960 THEN '48 (940,960]' WHEN amount > 960 AND amount <= 980 THEN '49 (960,980]' WHEN amount > 980 AND amount <= 1000 THEN '50 (980,1000]' WHEN amount > 1000 THEN '51 >1000' END AS amount_bucket , count(*) AS transactions from algorand.payment_transaction where block_timestamp::date > '2022-03-30' and try_base64_decode_string(tx_message:txn:note::string) like '%af/gov1:j{"rewardsPrd":2%' GROUP BY 1 ORDER BY 1 ) SELECT * , sum(transactions) OVER (ORDER BY amount_bucket)/sum(transactions) OVER () AS cum_percent_sum_transactions FROM main ORDER BY amount_bucket -- select * -- from algorand.payment_transaction -- where block_timestamp::date > '2022-03-30' and try_base64_decode_string(tx_message:txn:note::string) like '%af/gov1:j{"rewardsPrd":2%' -- AND receiver = 'WC6M5SRAF5NTTODMW5U5CLOFZNEBRLVARXXM4LSI36BVLIIJT4IIMCAYZ4'

Algorand Period 2 Governance Rewards Payouts