Post
Topic
Board Bitcoin Discussion
Merits 8 from 3 users
Re: Segwit Adoption. I looked at some data, and we are not there yet.
by
bitmover
on 21/10/2020, 01:44:04 UTC
⭐ Merited by LoyceV (6) ,d5000 (1) ,ETFbitcoin (1)

Thanks. I will work on it soon.

let me show what I did today.

I discovered that you have  transaction_count.txt and witness_count.txt in your Bitcoin block data available in CSV format

Then, I just made a quick search in blockchair APi documentation and found that it is very easy to calculate the segwit adoption.
witness_count = Number of transactions in the block containing witness information

You just need to divide witness_count by transaction count to get the percentage.

The problem is that some miners, for some reason, only get SegWit transactions in a block (sometimes just one). This makes the results very weird as we will see a lot of 100% adoption blocks (which is not false, but it is not representative).

I sliced the block data before block 481824 (segwit activation)



Very ugly chart.

Then i decided to group transactions by month and see what was the adoption per month (instead of per block). The results were much nicer: