Querying data from Full node ?

[pawanjain]

I am having a full node. What do I do to fetch data from it as per the user requirement ?

Let's consider the below examples with x = any random number

1. I want to receive all address "with x+ BTC"

2. I want to receive all transactions "in last 24" hours which transacted x amount

3. fetch blocks between date ranges

4. fetch transactions where fees was x


If it were a normal SQL database we could have used SQL queries such as

Select tx from full node where amount=x

but I am not sure how to receive block data from the full node.
I want to develop a program where I can code to retrieve the above data.

[DaveF]

Short version....you can't.
You are going to have to pull that data into a DB and query the data from there.
Otherwise every time you want to find out something you are going to have to parse the entire blockchain.

https://blockchair.com/ has a very good API that is fairly cheap to use if you do not have that many queries that you will do every day.

-Dave

[ABCbits]

Assuming you're using Bitcoin Core, all of them are impossible. If you wish to do it,
1. Follow @DaveF suggestion to use your own DB, which is indexable.
2. Follow @DaveF suggestion to use third party API.
3. Host your own blockchain explorer using open-source bitcoin block explorer. I took a peek at mempool.space and esplora API documentation, but it looks like it doesn't have feature you're looking for.