Near balances dashboard

Question

I just want to get dashboard with amount of users balances from 0 to 100N and from 100N to 1000N. I’m sitting on macOS High Sierra and my laptop is old, so I cannot to build whole part of indexer

I’m little bit confused, cause I don’t need to build whole migrations or indexer stuff. Maybe I can do it quietly simple that I think about it?

Answer 1

The indexer for explorer keeps track of a lot of information (more details found here). This information is public, although the access might not be reliable due to high usage volume. If you need reliability, it is recommended to run your own instance of the indexer for explorer or if you don't need all that data, you can run a custom indexer.

One of the tables in the database is the account_changes table which keeps track of all the changes for each account per block. If you wanted to get the latest balance, you could do a reverse order on the changed_in_block_timestamp & index_in_block and group by affected_account_id.