Bitcoin Forum

Bitcoin => Development & Technical Discussion => Topic started by: Greg Tonoski on April 26, 2023, 07:45:46 AM



Title: How many Bitcoin blocks are not full of transaction - info needed
Post by: Greg Tonoski on April 26, 2023, 07:45:46 AM
Can I ask you for information about count (or percentage) of half-empty blocks last year (or monthly), please? I couldn't find it in Google, Glassnode, Bitmex, mempool.space.


Title: Re: How many Bitcoin blocks are not full of transaction - info needed
Post by: Little Mouse on April 26, 2023, 08:01:17 AM
You can scrap data from here- https://mempool.space/blocks
It has transactions count, block size etc. (You already checked, my bad but you can get from there).

In better shape, only transactions count here- https://loyce.club/blockdata/transaction_count.txt
And block size here- https://loyce.club/blockdata/size.txt

More useful data- https://loyce.club/blockdata

Try loyce.club as they are organized. Import these data in a excel sheet and filter them as your need.


Title: Re: How many Bitcoin blocks are not full of transaction - info needed
Post by: Greg Tonoski on April 26, 2023, 09:09:45 AM
Thanks for a reply. Indeed, I could aggregate the raw blockchain data myself. Maybe there is the job done already and a report or a tool published. I look forward to more suggestions if any.


Title: Re: How many Bitcoin blocks are not full of transaction - info needed
Post by: ABCbits on April 26, 2023, 11:24:42 AM
I don't remember whether they have API, but https://www.statoshi.info/d/000000002/blocks?viewPanel=5&orgId=1 (https://www.statoshi.info/d/000000002/blocks?viewPanel=5&orgId=1) show weight size of each block.

In better shape, only transactions count here- https://loyce.club/blockdata/transaction_count.txt
And block size here- https://loyce.club/blockdata/size.txt

More useful data- https://loyce.club/blockdata

Try loyce.club as they are organized. Import these data in a excel sheet and filter them as your need.

Transaction count cannot be used as reliable indicable how full is a block. Theorically 10 ordinal transaction (each with size almost 400.000 weight unit) could fill whole block. As for block size data, unfortunately it can't be used either (for this case) since it use byte unit, not weight unit.


Title: Re: How many Bitcoin blocks are not full of transaction - info needed
Post by: Little Mouse on April 26, 2023, 11:42:41 AM
Transaction count cannot be used as reliable indicable how full is a block. Theorically 10 ordinal transaction (each with size almost 400.000 weight unit) could fill whole block. As for block size data, unfortunately it can't be used either (for this case) since it use byte unit, not weight unit.
Thanks but I'm aware about tx count vs tx size.
For weight, LoyceV has this file- https://loyce.club/blockdata/weight.txt


Title: Re: How many Bitcoin blocks are not full of transaction - info needed
Post by: Greg Tonoski on April 26, 2023, 03:09:07 PM
I don't remember whether they have API, but https://www.statoshi.info/d/000000002/blocks?viewPanel=5&orgId=1 (https://www.statoshi.info/d/000000002/blocks?viewPanel=5&orgId=1) show weight size of each block.
Thank you. That's exactly what I was looking for.

The data show that there were 81 (5.6%) blocks not-full (out of the total 1440 in the past 7 days; not-full block defined as the one of weight < 3 900 000 "weight units").

BTW I also found other data source:
https://bitcoinvisuals.com/chain-block-weight
https://mempool.space/graphs/mining/block-sizes-weights


Title: Re: How many Bitcoin blocks are not full of transaction - info needed
Post by: DaveF on April 27, 2023, 02:40:53 PM
I don't remember whether they have API, but https://www.statoshi.info/d/000000002/blocks?viewPanel=5&orgId=1 (https://www.statoshi.info/d/000000002/blocks?viewPanel=5&orgId=1) show weight size of each block.
Thank you. That's exactly what I was looking for.

The data show that there were 81 (5.6%) blocks not-full (out of the total 1440 in the past 7 days; not-full block defined as the one of weight < 3 900 000 "weight units").

BTW I also found other data source:
https://bitcoinvisuals.com/chain-block-weight
https://mempool.space/graphs/mining/block-sizes-weights

That 81 (5.6%) number seems a bit high. I only found about 40 blocks that were not full / 99% full in the past week.
But, there are not 1440 blocks per week. There should be about 2016 blocks every 2 weeks (per difficulty adjustment) so every week you get in the range of 1008.
So looking back from now till last Thursday, may be giving me a different number then you if you went back 10 days (about 144 blocks per day)

-Dave



Title: Re: How many Bitcoin blocks are not full of transaction - info needed
Post by: pooya87 on April 28, 2023, 04:23:43 AM
With some effort you could use the blockchair.com web interface to get that information, you basically have to mess around with the blocks page's Time and Weight factors. For example setting the date to be in the past 1 day (27 and 28 of April) would show 163 blocks (10 showed + 153 more rows) and all of them seem to have near 4 MB weight which you can see by changing the sort based on Weight[1].
You can change the date to a different period, for example if you set it to start from first day of April you can see there has been 3 empty blocks (with only 1 tx)[2] and by playing with the weight threshold you can filter the results even more[3].


[1] https://blockchair.com/bitcoin/blocks?q=time(2023-04-27..2023-04-28)#f=id,time,weight
[2] https://blockchair.com/bitcoin/blocks?s=weight(asc)&q=time(2023-04-01..2023-04-28)#f=id,time,weight,transaction_count
[3] https://blockchair.com/bitcoin/blocks?s=weight(asc)&q=time(2023-04-01..2023-04-28),weight(0..2000)#f=id,time,weight,transaction_count