FPPS rate = 1 + (Sum of Block Transaction Fees / Sum of Block Subsidies)
You may use data from Blockchair or Mempool.space, but it's easier to work with Blockchair's data which is aggregated by UTC day:
https://gz.blockchair.com/bitcoin/blocks/
Steps to calculate:
- Download desired file from https://gz.blockchair.com/bitcoin/blocks/
- For example, if you want data for 2023-05-30, then download the file called blockchair_bitcoin_blocks_20230530.tsv.gz
- Open and extract the downloaded GZ file using 7-Zip software: https://7-zip.org
- Open the TSV file with Microsoft Excel
- Sum up the "fee_total" column to calculate "Sum of Block Transaction Fees" for that day excluding the 3 highest fee and 3 lowest fee blocks
- Sum up the "generation" column to calculate "Sum of Block Subsidies" for that day excluding the 3 highest fee and 3 lowest fee blocks
- Calculate FPPS rate with this formula:
- FPPS rate = 1 + (Sum of Block Transaction Fees / Sum of Block Subsidies)