<p>I wanted to do a similar thing to put all the transactions in the database (it was PostgreSQL for me, but you can use anything). After some research ended up using <a href="https://github.com/jtobey/bitcoin-abe" rel="nofollow">bitcoin abe</a> and it worked great for me. Be patient though, it does take a long time - was several days in my case.</p>

CC BY-SA 3.0
2013-03-07T20:45:10.303Z
2013-03-07T21:12:20.497Z
2013-03-07T21:12:20.497Z
Sergey Golovchenko
<p>I want to download the entire bitcoin transaction history and store it in a database at my end to perform certain analysis. How do I get from the blk*.dat files to a useful format?</p>

CC BY-SA 3.0
2013-03-07T07:18:24.067Z
possible duplicate of [How can one download the initial Blockchain data files securely?](http://bitcoin.stackexchange.com/questions/3551/how-can-one-download-the-initial-blockchain-data-files-securely)
Highly Irregular
CC BY-SA 3.0
2013-03-07T07:54:25.713Z
@HighlyIrregular Edited to not be a straight duplicate.
Nick ODell
CC BY-SA 3.0
2013-03-07T08:43:18.347Z
possible duplicate of [How can I read information from the blockchain?](http://bitcoin.stackexchange.com/questions/4601/how-can-i-read-information-from-the-blockchain)
Stephen Gornick
CC BY-SA 3.0
2013-03-07T08:52:32.307Z
I want the transaction information is some kind of usable format. How do I make sense of this ??
user1754257
CC BY-SA 3.0
2013-03-07T09:08:21.407Z
I want which public key(s) sent how much bitcion to which keys at what time for all transactions starting from the inception till now..
user1754257
CC BY-SA 3.0
2013-03-07T21:58:18.003Z
@user1754257 Then clarify your question. You've got an edit button for a reason.
Nick ODell
<transactions>
How should I get all transaction history in a format that I can analyze?
user1754257
# How should I get all transaction history in a format that I can analyze?

(Asked by: username_0 on 2013-03-07)

I want to download the entire bitcoin transaction history and store it in a database at my end to perform certain analysis. How do I get from the blk\*.dat files to a useful format?

**Tags:** transactions

> **Comments:**
> **username_1**: possible duplicate of [How can one download the initial Blockchain data files securely?](http://bitcoin.stackexchange.com/questions/3551/how-can-one-download-the-initial-blockchain-data-files-securely)  
> **username_2**: @username_1 Edited to not be a straight duplicate.  
> **username_3**: possible duplicate of [How can I read information from the blockchain?](http://bitcoin.stackexchange.com/questions/4601/how-can-i-read-information-from-the-blockchain)  
> **username_0**: I want the transaction information is some kind of usable format. How do I make sense of this ??  
> **username_0**: I want which public key(s) sent how much bitcion to which keys at what time for all transactions starting from the inception till now..  
> **username_2**: @username_0 Then clarify your question. You've got an edit button for a reason.  

---

## 1 answers

### Answer by username_4 on 2013-03-07. Score: 4

I wanted to do a similar thing to put all the transactions in the database (it was PostgreSQL for me, but you can use anything). After some research ended up using [bitcoin abe](https://github.com/jtobey/bitcoin-abe) and it worked great for me. Be patient though, it does take a long time - was several days in my case.


---

