--- fixed cost declared by active pools (non-zero stake, epoch 652) --- band | pools | pct_of_pools | total_stake_ada | pct_of_stake ------------------------------+-------+--------------+-----------------+-------------- exactly 340 (pre-2023 floor) | 1749 | 65.4 | 14479606016 | 67.6 exactly 170 (at floor) | 504 | 18.8 | 4844251447 | 22.6 other, above floor | 422 | 15.8 | 2094793911 | 9.8 (3 rows) --- same, restricted to pools that actually minted a block in 641-650 --- band | pools_minting | pct_of_minting_pools | blocks_641_650 | pct_of_blocks ------------------------------+---------------+----------------------+----------------+--------------- exactly 340 (pre-2023 floor) | 722 | 59.3 | 142732 | 67.3 exactly 170 (at floor) | 361 | 29.7 | 47776 | 22.5 other, above floor | 134 | 11.0 | 21456 | 10.1 (3 rows) --- stake distribution of the pools at exactly 170 ADA --- pools | total_stake_ada | min_ada | p25_ada | median_ada | mean_ada | p75_ada | p95_ada | max_ada -------+-----------------+---------+---------+------------+----------+---------+----------+---------- 504 | 4844251447 | 3 | 126266 | 762550 | 9611610 | 3993901 | 64358249 | 83924628 (1 row) --- stake buckets for the pools at exactly 170 ADA --- bucket | pools | pct_pools | stake_ada ----------------+-------+-----------+------------ a. under 100k | 107 | 21.2 | 1802002 b. 100k - 500k | 111 | 22.0 | 27646692 c. 500k - 1M | 54 | 10.7 | 38836787 d. 1M - 5M | 115 | 22.8 | 266851984 e. 5M - 10M | 16 | 3.2 | 119028925 f. 10M - 30M | 36 | 7.1 | 663479257 g. 30M+ | 65 | 12.9 | 3726605799 (7 rows) --- expected blocks/epoch implied by that stake (context for 03_) --- total_active_stake_ada | mean_blocks_per_epoch | ada_of_stake_per_block ------------------------+-----------------------+------------------------ 21419162225 | 21199 | 1010400 (1 row)