Author

Topic: Bitcoin’s Mempool statistics (Read 165 times)

legendary
Activity: 2226
Merit: 6947
Currently not much available - see my websitelink
December 17, 2023, 06:13:33 PM
#9
Okay, many thanks for your helpful answers and input here, @anyone.  Smiley
I'll lock this topic for now as it's sufficient for my initial question.

And let's hope that Bitcoin transactions will get a bit cheaper over Christmas, where I expect less activity.  Smiley
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
December 17, 2023, 02:13:57 PM
#8
Okay, so it seems to be more of a tracking issue and for whatever reason this only starts in 2017 but technically this data should be available to scrape and put into a graph (since we can look it up manually as data in the Blockchain is available for everyone).
I don't think you can still scrape this data somewhere: there's not really a point to keep old mempool snapshots.
Before the BCH-fork (which may or may not have been a cause for Bitcoin blockchain spam), I don't think mempool was an issue. As far as I know, it was empty most of the time.

I have some related data though, see Bitcoin block data available in CSV format: size.txt shows which blocks weren't full. If blocks aren't full, that means mempool gets emptied every time. There's more data on fees, either in sats on in dollars.
legendary
Activity: 4326
Merit: 8950
'The right to privacy matters'
December 17, 2023, 01:37:58 PM
#7
If you don't have a glassnode subscription then probably the best you can get is this:
https://charts.woobull.com/bitcoin-congestion/
Blockchain goes to 2016 but beyond that there was nobody really interested in the mempool

You can see here why:
https://www.blockchain.com/explorer/charts/avg-block-size
Blocks were most of the time not full so there was no congestion whatsoever so no mempool going above 2-3MB!

LE:
Blockchair shows ~4900 blocks over 975kb from 2010 till 2016 Jan 1st
So those being random, it's 5 out of 130 on average, not enough to make the mempool worth a subject of discussion!

And the ratios of rewards to fees were

50 coins to under 1 coin
25 coins to under 1 coin

from 2009 to MID 2016
legendary
Activity: 2912
Merit: 6403
Blackjack.fun
December 17, 2023, 01:23:03 PM
#6
If you don't have a glassnode subscription then probably the best you can get is this:
https://charts.woobull.com/bitcoin-congestion/
Blockchain goes to 2016 but beyond that there was nobody really interested in the mempool

You can see here why:
https://www.blockchain.com/explorer/charts/avg-block-size
Blocks were most of the time not full so there was no congestion whatsoever so no mempool going above 2-3MB!

LE:
Blockchair shows ~4900 blocks over 975kb from 2010 till 2016 Jan 1st
So those being random, it's 1 out of 60 on average, not enough to make the mempool worth a subject of discussion!
legendary
Activity: 4326
Merit: 8950
'The right to privacy matters'
December 17, 2023, 01:16:43 PM
#5
Actually I have been doing some research if I can get it, but it seems as though it wasn't on record, I can't get it anywhere, it's only from 2017 till date that is available, but check this if it might be helpful.

fees were dirt cheap so no one tracked them.  
Okay, so it seems to be more of a tracking issue and for whatever reason this only starts in 2017 but technically this data should be available to scrape and put into a graph (since we can look it up manually as data in the Blockchain is available for everyone).
And to conclude: For earlier bull markets, substantial fees didn't seem to be a problem  (as only 2013 / 2014 should be relevant here), in opposition to the crypto winter late 2014 - late 2016).

But what we can see in the chart from Jochen Hoenicke, even in January 2017, there was substantial weight in the Mempool. So probably, this increase has been rather sharp end of 2016, probably?

I punched in block 444,444 about dec 21 2016

12.5 coins   around 9953 usd
 0.8 fees.    around   647 usd


so you can punch in blocks

444,444 - 446,000

every 10th one
legendary
Activity: 2226
Merit: 6947
Currently not much available - see my websitelink
December 17, 2023, 01:04:02 PM
#4
Actually I have been doing some research if I can get it, but it seems as though it wasn't on record, I can't get it anywhere, it's only from 2017 till date that is available, but check this if it might be helpful.

fees were dirt cheap so no one tracked them. 
Okay, so it seems to be more of a tracking issue and for whatever reason this only starts in 2017 but technically this data should be available to scrape and put into a graph (since we can look it up manually as data in the Blockchain is available for everyone).
And to conclude: For earlier bull markets, substantial fees didn't seem to be a problem  (as only 2013 / 2014 should be relevant here), in opposition to the crypto winter late 2014 - late 2016).

But what we can see in the chart from Jochen Hoenicke, even in January 2017, there was substantial weight in the Mempool. So probably, this increase has been rather sharp end of 2016, probably?
legendary
Activity: 4326
Merit: 8950
'The right to privacy matters'
December 16, 2023, 07:40:06 PM
#3
Maybe someone knows a website, where we can see Bitcoin’s Memepool statistics from pre 2017? I’ve checked various websites and it’s always just from 2017 until today. Previous data doesn’t seem to be available anywhere, like here from Jochen Hoenicke‘s Memepool statistics:


https://jochen-hoenicke.de/queue/#BTC,all,weight

Does someone know any known site, where we can find data like from 2011 or 2012 until today?
I’m not a coder, so I don’t know if there’s any technical detail preventing it for the public, to look up earlier data because it’s not available maybe?
Because ALL sites I’ve checked, it’s always just starting in 2017…
It's a bit odd...


fees were dirt cheap so no one tracked them.  and blocks were big in 2016  25 coins were huge compared to fees.

btc was never higher than 1300 usd 2009 to 2016

we had 1 peak event in 2013 and 1300 usd price was brief.

in 2016 we were always under 1000 usd so fees were 40x cheaper

then today and 19x cheaper than 2017 .



also high fees started up in early 2017 as there was no LN and only legacy addresses maybe legacy segwit.

most of us did btc to ltc to move wealth if fees were any kind of an issue.

I don't program so I am don't goinng to look at fees in 2016 or 2015 to make a chart up.

https://blockchair.com/bitcoin/blocks


above will go all the way back.


so I searched blocks

https://blockchair.com/bitcoin/block/399999

date-------------  block number-------   fee
02/25/2016........ 399,999............... 0.2052 .... worth  87  usd
02/25/2016.........400,000------------ 0.3334..... worth 141 usd


if you want to do the work the info is on that link
sr. member
Activity: 266
Merit: 205
December 16, 2023, 07:22:58 PM
#2
Actually I have been doing some research if I can get it, but it seems as though it wasn't on record, I can't get it anywhere, it's only from 2017 till date that is available, but check this if it might be helpful.
https://blog.summerofbitcoin.org/mempool-space/
legendary
Activity: 2226
Merit: 6947
Currently not much available - see my websitelink
December 16, 2023, 03:40:29 PM
#1
Maybe someone knows a website, where we can see Bitcoin’s Memepool statistics from pre 2017? I’ve checked various websites and it’s always just from 2017 until today. Previous data doesn’t seem to be available anywhere, like here from Jochen Hoenicke‘s Memepool statistics:


https://jochen-hoenicke.de/queue/#BTC,all,weight

Does someone know any known site, where we can find data like from 2011 or 2012 until today?
I’m not a coder, so I don’t know if there’s any technical detail preventing it for the public, to look up earlier data because it’s not available maybe?
Because ALL sites I’ve checked, it’s always just starting in 2017…
It's a bit odd...
Jump to: