challenge_007.md

Data analyzing

Source List

To improove my understanding of Near protocol I have used sources below:

• https://nomicon.io/
• https://near-indexers.io/

To read data from blockchain I used docks from https://docs.near.org/api/rpc/introduction

Research Goals

• See historical validators productivity;
• See historical kicking out for each validators;
• See historical data about validator stake;
• Find difference between median and average stake;
• Find depencies between validator stake and quantity of produced blocks and chunks;

Technical Implementation

To grab data I have developed small backend service which includes 2 small microsevices:

• Data grabber which writes data to SQLite database;
• Http-server to get data by REST API.

I deployed it here: http://38.242.250.37:4000/

Screenshots of essential tables from SQLite DB below:

My backend endpoints API you can see in repository

Dashboard

I've created frontend service to show graphics. You can see it in interactive mode here: http://38.242.250.37/

It includes 3 views:

1. Epoch history info shows:

• Historical kicking out in epoch;
• Seat price history graphic;
• Median and average stake in each epoch and difference between them.
• Total validators quantity.

2. Pool history info

• Historical pool productivity;
• Historical validator stake;
• Historical data about uptime and kicking out;

3. Epoch pools productivity

• Dependency between validator stake and quantity of produced blocks and chunks;

⏮ Challenge 006	Challenge 008 ⏭