Miner profitability

[philiphacks]

Add page to track miner commitments (in BTC) with date filters, and checking their profitability

[nieldeckx]

Requirements:

• Per block # miners participating + bid amount
• Per block miner who won + rewards
• Get all info for given date range + aggregated info

[nieldeckx]

Reward slot holders: https://api.mainnet.hiro.so/extended/v1/burnchain/reward_slot_holders -> We already have all rewards in DB

Bitcoin API: https://api.blockcypher.com/v1/btc/main/addrs/bc1q9ll6ngymkla8mnk5fq6dwlhgr3yutuxvg3whz5/full

Mining rewards: https://docs.stacks.co/stacks-101/mining Coinbase rewards + all TXs fees

Block miner: https://api.mainnet.hiro.so/extended/v2/blocks/150987 miner_txid https://www.blockchain.com/explorer/transactions/btc/84142066977b25a27123fc76155bda78f03d9afc899c65b4954bf126d0ea355b

Find miners: https://docs.stacks.co/stacks-101/mining Miners commit Bitcoin to two addresses in every leader block commit. The amount committed to each address must be the same. The addresses are chosen from the current reward set of stacking participants. Addresses are chosen using a verifiable-random-function, and determining the correct two addresses for a given block requires monitoring the Stacks chain. So once we have 1 miner, we can find all of them.

Lambda Function On each block:

• Use stacks api /extended/v2/blocks/xx/transactions to get total fee amount
• Use stacks api /extended/v2/blocks/xx to get miner_txid
• Use bitcoin api with miner_txid to get the miner address
• Use bitcoin api to get all TXs based on first txid (https://api.blockcypher.com/v1/btc/main/addrs/1DbqwTa1SoLyGBdjTbYJ3qyXAwh6Hx5qBj/full?after=844552&before=844553)