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 formatThen, 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:
