Bitcoin transaction graph

I am trying to make bitcoin transaction graph, but I am not sure how to go about it. I have extracted the necessary data from blockchain like the sender, receiver, amount of bitcoins sent, transaction hash and the date and time when it first got included in the block. The format for which is shown below:-

TXID                                                                       Input Address                  Value               Output Address                    Time & Dates

363ec29e4fc43f97576423d0d522f5f0fc79c5c018c3a210c5644ab79a38041d                                        25.0301   [u'1CjPR7Z5ZSyWk6WtXvSFgkptmpoi4UM9BC']    2014-01-12 01:36:19

f264c5c36b624110201a27bd02883508d29dfe1f94975aa8cc652fb8bc1496a9 1AyHWFST4jhcdVs74Hd3pvCdafpktmiF8Y       299.0   [u'13vZBq8ayCzficfP3uwm52bctv5mSXKfM1']    2014-01-12 01:36:19

I am not sure what should be my first step towards constructing transaction graph. I am trying to use hadoopcryptoledger library available in Apache spark for doing so, but not sure how to use the result that I have extracted from blockchain for that. Do I first need to create a database to store my result?
The file that contains the above information is in .txt format. Any help would be appreciated.

Transaction cancelled but bitcoin was not return back to my wallet

I made a transaction on 2017-05-04 04:40:52 to 39j2nuZWr4F2hZ5wYDwQwZWzsTJC4H6ujn and my transaction was on pending till today and i got a message today Sun, May 28, 2017 at 4:20 AM that my transaction was cancelled but my bitcoin was not return to my bitcoin wallet account, i want to know what is going and i will appreciate you help, thank you

What is the best way to download a “recent” UTXO set snapshot?

I am using bitcoinj to listen for payments. I need a way to maintain the entire UTXO set in a local database.

  1. Can bitcoinj be used to download every block (I think it downloads only recent blocks and headers for older blocks)?

  2. I don’t need to use bitcoinj or even Java for creating or maintaining this database if a better solution exists. Is there anything like this?

Ideally what I want is a wallet that downloads only the UTXO set without downloading the entire blockchain (due to bandwidth limitations) and maintains it from then onward. This needs to be the entire set, not just for the addresses I own.
Additionally I need an API that allows for following queries:

  1. Given a UTXO, check if it is present in the set.
  2. Given an address, get me all the UTXOs for it.

I think that it is currently not possible to validate a given UTXO set without downloading the entire blockchain, so some solution in this regard would also be appreciated.

Bitcoin transaction as been unconfirmed for 9 days

Please what can I do? I received a transfer of 0.559btc and it has remained unconfirmed for 9 days, I can’t even find it again on the but it was there for almost 4 days. I can see the transaction here on tradeblock. I have alerted the company that made the transfer to me but their customer service is horrible. Please any help? Can I still get this deposit?

Also why did it disappear from

Transaction created with sendtoaddress didn’t propagate to the network, how to resend?

i am running Bitcoin Core 0.14.1 on a Centos6 Server.
I had several transactions (receive, send) in the last days, and everything was fine.

I always did my transaction with the bitcoin-cli sendtoaddress ADDRESS AMOUNT … and that worked fine. Always after some minutes i could see my unconfirmed transactions at

But yesterday i made a new transaction same as always and i get an transactions id successfully, but i cant find my transaction in the Blockchain. And the receiver does not the transaction also.

What i have tried:

  • I wait more than 24 hours ( but my transaction is not showing up in blockchain, and wasnt include in any block)
  • I turned off the IP Tables and make sure that the Wallet is connected to the network.

  • I stooped Bitcoin with bitcoin-cli stop and made an recan with bitcoind -rescan

  • I stooped Bitcoin with bitcoin-cli stop and made an recan with bitcoind -zapwallettxes
  • I deleted the memorypool.dat in .bitcoin directory
  • I reload the complete Blockchain

Who has the solution?

Bitcoin and Smart Contracts

I have recently come across the features of ethereum and the idea of smart contracts.

I like the concept of smart contracts however as a currency, I much prefer the bitcoin to the ether.

Is there any way smart contracts could ever be utilised by bitcoin?