2

I installed Bitcoin-Core Wallet and downloaded the whole 130gigs BlockChain. Now I'd like to read the BlockChain Data to know all bitcoin values since the beginning. Not sure how to start. I need that data for making my own graphs in Excel

How can I read data from the whole BlockChain? Thanks.

  • 4
    What do you mean by bitcoin values? – Pieter Wuille Apr 15 '17 at 22:57
3

It sounds like you are asking how to build a block explorer. Basically you would activate the full transaction index by adding txindex=1 to your bitcoin.conf. Parse all the history data and dump it into a database. Then keep track of all the new transaction data on your own database as blocks come in with blocknotify or real-time with ZMQ notifications.

https://github.com/bitcoin/bitcoin/blob/master/doc/zmq.md#usage

There's also options like bitpay's bitcore that pretty much does the work for you. It does require a lot more HD space though.

| improve this answer | |
1

My understanding of your question is that you want a tool that parses/queries the blockchain and saves the results into an Excel file. I'm not sure that something like that exists, but if you're willing to experiment with code then there are options.

  • Abe is a block browser for Bitcoin & similar currencies. Written in Python.
  • BitcoinJS is a javaScript library for the Bitcoin blockchain.
  • fast-dat-parser a blockchain parser written in C++.

Each of these libraries is capable of reading the blockchain, and the languages have other libraries for saving data to Excel, CSV, in a database, etc.

| improve this answer | |
-1

Checkout this API: https://blockchain.info/api

Specifically look at "Transactions & Blocks Data" & "Market Data".

With PHP you can use that API and work with the data. PHP also allows you to create and export to Excel sheets: http://www.the-art-of-web.com/php/dataexport/

For me, because I know PHP, this would be the easiest route to go.

| improve this answer | |
  • OP is asking how to read data from the blockchain that his Bitcoin Core instance downloaded, not how to use a 3rd party API. – Pieter Wuille Apr 23 '17 at 8:48
  • I was just telling him how I would do it as the last line of my answer says. Any bit of information helps that is relevant. Maybe if he knew PHP he would find it easier to do the route I recommended. But I do see your perspective. – Marc Alexander Jun 9 '17 at 22:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.