Extract stats from Bitcoin Core DB - HELP!

[ebn87]

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.

[OmegaStarScream]

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://bitcointalk.org/index.php?topic=5254914.0

[FatFork]

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!

[ebn87]

thank you both!
very useful 🙏

[LoyceV]

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.

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...

This is more work, it requires processing the actual blockchain. There's software out there for this too.

But:

or to export the DB in CSV or something readable...

Blockchair did this already, and you can easily download it! It's slow, so I created a mirror. You may like:

Related topics
Bitcoin block data available in CSV format
List of all Bitcoin addresses with a balance
List of all Bitcoin addresses ever used
[~500 GB] Bitcoin block data: inputs, outputs and transactions

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.