How to verify the results of glassnode?

[franklin2058]

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.

[jackg]

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.

[NotATether]

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.

[jackg]

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).