CCIP-016: Query and Payout Information

[whoabuddy]

Getting this out of my Discord convo with @Rapha-btc, data courtesy of @friedger:

Query code:

select se.block_height , amount, ((b.burn_block_height  - 666050) / 2100) - 1 as cycle, * from stx_events se left join blocks b on se.block_height = b.block_height  where sender  = 'SP21YTSM60CAY6D011EZVEVNKXVW8FVZE198XEFFP'
and recipient = 'SP8A9HZ3PKST0S42VM9523Z9NV42SZ026V4K39WH.ccd002-treasury-mia-stacking'
and se.canonical and se.microblock_canonical 
and b.canonical
order by se.block_height desc

Resulting data for MIA:

block height	payout amount
144186	11956403387
142306	14691143091
140709	12658202794
138972	21862239159
137331	23761013666
135730	43886090272
134191	20528917568
132680	15495109117
130893	19913782531
129309	24147184987
127254	22070459358
126031	22346829090
124081	22875310501
122286	22049542417
120440	32036545780
118392	27330659232
116596	25195947330
114755	29773591836
112820	33867164794
111097	36386519532
109338	45695032162

Resulting data for NYC:

block height	payout amount	cycle
144186	7891090017	80
142306	9695916112	79
140709	8354173172	78
138972	14428419333	77
137331	15681210555	76
135730	28962280296	75
134191	13547686726	74
132588	10225347415	73
130893	13140642834	72
129309	15933649223	71
127254	14562588849	70
126031	14744214112	69
124081	15092603850	68
122286	14547584045	67
120440	21136466347	66
118392	18031083017	65
116596	16622163699	64
114755	19641588871	63
112820	22341600977	62
111097	24002944424	61
109338	30143370950	60

This will be helpful both for the CCIP table and for the download/analysis script:

• CCIP-016 calculation script scripts#19

We'll also need the numbers from 80 forward once the payout for 83 is complete.