Title: Bitcoin’s Mempool statistics Post by: 1miau on December 16, 2023, 08:40:29 PM 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://www.talkimg.com/images/2023/12/16/EBIXD.png 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... Title: Re: Bitcoin’s Mempool statistics Post by: Barikui1 on December 17, 2023, 12:22:58 AM 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/ Title: Re: Bitcoin’s Mempool statistics Post by: philipma1957 on December 17, 2023, 12:40:06 AM 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://www.talkimg.com/images/2023/12/16/EBIXD.png 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 Title: Re: Bitcoin’s Mempool statistics Post by: 1miau on December 17, 2023, 06:04:02 PM 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? Title: Re: Bitcoin’s Mempool statistics Post by: philipma1957 on December 17, 2023, 06:16:43 PM 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 Title: Re: Bitcoin’s Mempool statistics Post by: stompix on December 17, 2023, 06:23:03 PM 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 (https://blockchair.com/bitcoin/blocks?s=id(desc)&q=size(975000..),time(2010-12-09..2016-01-01)#f=id,hash,time,guessed_miner,transaction_count,size) So those being random, it's 1 out of 60 on average, not enough to make the mempool worth a subject of discussion! Title: Re: Bitcoin’s Mempool statistics Post by: philipma1957 on December 17, 2023, 06:37:58 PM 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 (https://blockchair.com/bitcoin/blocks?s=id(desc)&q=size(975000..),time(2010-12-09..2016-01-01)#f=id,hash,time,guessed_miner,transaction_count,size) 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 Title: Re: Bitcoin’s Mempool statistics Post by: LoyceV on December 17, 2023, 07:13:57 PM 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 (https://bitcointalk.org/index.php?topic=5246271.0): size.txt (https://loyce.club/blockdata/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. Title: Re: Bitcoin’s Mempool statistics Post by: 1miau on December 17, 2023, 11:13:33 PM Okay, many thanks for your helpful answers and input here, @anyone. :)
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. :) |