Author

Topic: How to verify the results of glassnode? (Read 86 times)

legendary
Activity: 2870
Merit: 7490
Crypto Swap Exchange
August 10, 2021, 04:40:26 AM
#5
I know it's not specific, but easier way to find out without much programming knowledge is self-hosting blockchain explorer (such as https://github.com/mempool/mempool), then use it's API and compare the result with glass node data. But the downside the API isn't as rich as glassnode's API.

I couldn't find commands for querying this in bitcoin core itself looking at the help menu but that might not mean there isn't one, it's just not well documented on the console start screen.

Bitcoin Core don't have such feature (address indexing and searching). On a side note,
1. If you type help on Bitcoin Core GUI console, it should show all available command.
2. If you type help command_name, you can get detail of the command.
copper member
Activity: 2856
Merit: 3071
https://bit.ly/387FXHi lightning theory
August 09, 2021, 01:08:19 PM
#4
Are you experienced in programming, how is the best way you'd want to enter a query like that - could you do it in python or would you prefer SQL?

It's highly likely that a list of addresses will not fit in a single SQL database.

That'd just be how the command is input and interpreted, a lot of database management systems built into a programming language (for example) will just iterate over the raw data if asked to count it (which is what we would expect to be the most efficient here - it could dump addresses and their balance in a file but that might not be necessary).
legendary
Activity: 1568
Merit: 6660
bitcoincleanup.com / bitmixlist.org
August 09, 2021, 12:30:54 PM
#3
Blockchair has a similar API query you can use to verify the Glassnode results: https://blockchair.com/bitcoin/addresses?q=balance(0.01..)

Although it's going to be infeasible to check all of them by hand, and possibly even by machine because the cost of performing API calls for each platform becomes prohibitively expensive.

Are you experienced in programming, how is the best way you'd want to enter a query like that - could you do it in python or would you prefer SQL?

It's highly likely that a list of addresses will not fit in a single SQL database.
copper member
Activity: 2856
Merit: 3071
https://bit.ly/387FXHi lightning theory
August 09, 2021, 12:28:21 PM
#2
Are you experienced in programming, how is the best way you'd want to enter a query like that - could you do it in python or would you prefer SQL?

I have found a thread discussing querying the data on the blockchain - https://bitcoin.stackexchange.com/questions/61252/how-to-learn-to-query-the-block-chain

There are also a few implementations of python chain parsers you might want to look at, for example - https://github.com/alecalve/python-bitcoin-blockchain-parser (but I haven't tested this).

If you had the time or money, you could also commission someone else to do this - you could also look at APIs that might be available from block explorers too.

I couldn't find commands for querying this in bitcoin core itself looking at the help menu but that might not mean there isn't one, it's just not well documented on the console start screen.
jr. member
Activity: 49
Merit: 3
August 09, 2021, 12:05:01 PM
#1
For example, I would like to know addresses with balance >=0.01 (https://studio.glassnode.com/metrics?a=BTC&category=Addresses&m=addresses.MinPointZero1Count).

How can I check if glassnode data is correct from analyzing the blockchain? I am quite familiar with Linux but not quite with Bitcoin source code.

Please give specific steps and don't give irrelevant comments such as it is not helpful to analyze.

Thanks very much.
Jump to: