How to query the blockchain - advanced search?

[BitCoinSeo]

hi there,
I'm wondering if there are any public tools to do an advanced search on the BTC blockchain, for example;

All transactions that match:
Date range e.g. October 20-30th, 2013.
where coin transfer amount = 4
From existing wallet with balance > 0
To new wallet with balance < 0

Reason is to help a friend who lost track of his wallet address, but still has his password. The senders address is unavailable.

Thankyou

[1715244237]

1715244237

[1715244237]

1715244237

[LoyceV]

I'm wondering if there are any public tools to do an advanced search on the BTC blockchain

I know Blockchair.com can export searches, but I can't find the link. If it's only 10 days, you might even be able to use their data dumps, and search in a spreadsheet.

To new wallet with balance < 0

There won't be any matches for negative balance.

Reason is to help a friend who lost track of his wallet address, but still has his password. The senders address is unavailable.

What is the password for? If it's for a wallet, there's no use if you don't have the wallet. Finding the transaction won't help.

[NotATether]

It is not possible to search by wallet balance from a block explorer because the secret nature of derived public keys prevents their addresses from being linked together. The best you can do is search the individual wallet addresses respectively [for a wallet.dat with lost password for example, the public keys can still be accessed directly from the file using tools such as pywallet as they are stored unencrypted]. It's easier if you made transactions from these addresses because you can just look at the payment histories of the various services you paid for.

[o_e_l_e_o]

I know Blockchair.com can export searches, but I can't find the link.

Here's the closest search you can do with Blockchair based on the data OP has provided: https://blockchair.com/bitcoin/transactions?q=time(2013-10-20..2013-10-30)%2Cinput_total(400000000)

Still returns 622 transactions, which is probably far more than he was hoping for. It's not possible Blockchair to specify that a receiving address must be unused. The best way of narrowing it down from here would be for OP to know how many inputs and outputs were in the transaction.

[databoi]

If you know SQL, I put together a Bitcoin database https://www.dolthub.com/repositories/web3/bitcoin that is currently updated till 2013. I have a more optimized database on the way that will be easier to download and work with. If interested, I can help you with the SQL queries.

[Next-door]

[A few words about blockchain developers
First you need to learn a web programming language like PHP or JSP so that you can exchange information in JSON-RPC with the node of a coin. Then you need to decide which Coin's Blockchain you want to work on. If you go to the website of your favorite Coin and see their Developer Documentation, you will understand what you need to do by calling Function. Two books by Andreas Antonopoulos to be a blockchain developer ...


1. https://github.com/bitcoinbook/bitcoinbook
2. https://github.com/ethereumbook/ethereumbook



You can read it for free on Github. Linked. If you have skills in Bitcoin and Ethereum Blockchain, it will be convenient for you to work in other Coins.

[NotATether]

First you need to learn a web programming language like PHP or JSP so that you can exchange information in JSON-RPC with the node of a coin.

Not necessary. Just install jq on a Linux box and you can easily parse JSON responses on the command-line. (It is not too hard to construct a JSON document from just a string.)