search

stxpub / web

The Unlicense
1 stars 1 forks source link

Mining total too low #1

Open friedger opened 4 days ago

friedger commented 4 days ago

From a rough estimation, the mining spend per 144 blocks for "bigger" miners should be closer to 0.7 BTC instead of 0.2 BTC.

image

diwakergupta commented 4 days ago

See https://github.com/stxpub/api/blob/main/tasks.go#L141

which is basically a port of https://github.com/jcnelson/status.sh/blob/main/status.sh#L363

I haven't verified that query myself, but feel free to send a PR if you come up with something better.

Thanks @friedger !

friedger commented 3 days ago

I was comparing the numbers with 

SELECT
    block_height,
    SUM(burn_fee),
    count(*),
    parent_block_ptr
FROM
    block_commits
WHERE block_height > 865850
GROUP by 1, 4
ORDER BY
    block_height DESC
LIMIT 100

And they do not match. Also, the exchange rate of btc spend/stx earnt would be around 600 sats/stx instead of 2660 sats/stx