<p>In order to produce this graph</p>
<p><a href="https://i.sstatic.net/o8ux5.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/o8ux5.png" alt="Bitcoin transaction data volume in recent months" /></a></p>
<p>I used a blockchain parser to read block files that Bitcoin core had created. The blockchain parser created CSV data that I summarised using a second program and plotted using GNUPlot</p>
<p>A search for &quot;Bitcoin blockchain parser&quot; ought to find some examples. Perhaps one of them would be of use to you.</p>
<p>I wrote my own (see my profile)</p>

CC BY-SA 4.0
2023-02-16T22:19:54.457Z
2023-02-16T22:19:54.457Z
RedGrittyBrick
<p>If you are comfortable with SQL and are interested in running queries over the entire chain, there is a BigQuery database hosted by Google. You can find more information here: <a href="https://bitcoin.stackexchange.com/a/117171/139612">https://bitcoin.stackexchange.com/a/117171/139612</a></p>
<p>If you are more interested in the analysis of specific blocks or of transactions, <code>bitcoin-cli</code> provides a number of RPCs that can be used for fetching data, although this can be very slow when querying over large ranges.</p>
<p>In general, I'd recommend against parsing block files or leveldb files as those files are designed for efficient storage and easy use in the Bitcoin Core client and make no guarantees about being usable in other applications or providing a stable format.</p>

CC BY-SA 4.0
2023-02-16T10:28:09.507Z
2023-02-16T10:28:09.507Z
josie
<p>I want to fetch statistical data about the bitcoin network. Things things like wallet count, transaction count etc. Had a node running and the blockchain is on my disk. However parsing it seems to be not that trivial. I tried python-blockchain-parser however I get leveldb issues on all of my machines. I dont know the structure well and it seems like an easy thing to miss out data (segwit, lightning). Any tips?</p>

<history><statistics>
How can I produce a time series of bitcoin blockchain data?
ManuelSchneid3r
# How can I produce a time series of bitcoin blockchain data?

(Asked by: username_0 on 2023-02-14)

I want to fetch statistical data about the bitcoin network. Things things like wallet count, transaction count etc. Had a node running and the blockchain is on my disk. However parsing it seems to be not that trivial. I tried python-blockchain-parser however I get leveldb issues on all of my machines. I dont know the structure well and it seems like an easy thing to miss out data (segwit, lightning). Any tips?

**Tags:** history, statistics


---

## 2 answers

### Answer by username_1 on 2023-02-16. Score: 1

In order to produce this graph

[![Bitcoin transaction data volume in recent months](https://i.sstatic.net/o8ux5.png)](https://i.sstatic.net/o8ux5.png)

I used a blockchain parser to read block files that Bitcoin core had created. The blockchain parser created CSV data that I summarised using a second program and plotted using GNUPlot

A search for "Bitcoin blockchain parser" ought to find some examples. Perhaps one of them would be of use to you.

I wrote my own (see my profile)


---

### Answer by username_2 on 2023-02-16. Score: 1

If you are comfortable with SQL and are interested in running queries over the entire chain, there is a BigQuery database hosted by Google. You can find more information here: <https://bitcoin.stackexchange.com/a/117171/139612>

If you are more interested in the analysis of specific blocks or of transactions, `bitcoin-cli` provides a number of RPCs that can be used for fetching data, although this can be very slow when querying over large ranges.

In general, I'd recommend against parsing block files or leveldb files as those files are designed for efficient storage and easy use in the Bitcoin Core client and make no guarantees about being usable in other applications or providing a stable format.


---

