Author

Topic: Extract stats from Bitcoin Core DB - HELP! (Read 106 times)

legendary
Activity: 2870
Merit: 7490
Crypto Swap Exchange
July 29, 2023, 06:21:28 AM
#6
Op, I believe this article might be helpful to you: https://www.shakudo.io/blog/how-to-extract-on-chain-bitcoin-data

It might require a bit of Python knowledge, but even if you don't have much, you could still get some ideas from it. Check it out!


OP, if you decide to follow that article make sure you copy chainstate folder first and perform work on that copy. If you're not being careful, you might corrupt the chainstate which force to perform reindex which take hours.

Yes, you can extract information about the total number of wallets and historical data related to the number of addresses with a non-zero balance from Bitcoin Core. Bitcoin Core provides a full-node implementation of the Bitcoin protocol, and you can use its built-in commands to access and extract various statistics and data.

Wrong, Bitcoin Core doesn't have address index and snapshot feature which is necessary for OP works. That means OP need different software to generate the stats or write one by himself.

You can using pywallet for do it.

pywallet is software to restore wallet, not obtaining stats from blockchain stored by Bitcoin Core.
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
is there a way to extract from Bitcoin Core some stats about the totale number of wallets?
There's software out there that extracts this (current) information from chainstate, so it should also work on a pruned node.

I have snapshots going back a year (second link), or data dumps per day (last link).

If you only want to count funded addresses, I have data since September 2020: total_number_of_funded_addresses.txt.
newbie
Activity: 5
Merit: 5
thank you both!
very useful 🙏
legendary
Activity: 1596
Merit: 2588
Top Crypto Casino
Op, I believe this article might be helpful to you: https://www.shakudo.io/blog/how-to-extract-on-chain-bitcoin-data

It might require a bit of Python knowledge, but even if you don't have much, you could still get some ideas from it. Check it out!
staff
Activity: 3472
Merit: 6129
No, as far as I know, that's not possible. I'm guessing you're referring to all the wallets out there, and not just yours. Right?

If so, take a look at LoyceV's topic, it should help you achieve what you want : https://bitcointalksearch.org/topic/list-of-all-bitcoin-addresses-with-a-balance-5254914

newbie
Activity: 5
Merit: 5
Hi guys, maybe someone can help me here:
is there a way to extract from Bitcoin Core some stats about the totale number of wallets?
like an historical series of how the number of addresses with greater than zero balance evolved over time?
or just a snapshots of all the addresses balance at a given period of time...
or to export the DB in CSV or something readable...
than I could derive my stats.
Jump to: