Ricky's Indexer Data Analytics Tutorial
1
Introduction
2
Getting Started
2.1
The tidyverse
2.2
Prepare Data
2.2.1
Filter Data
2.2.2
Mutate/Transform
2.3
Visualize Results
3
Close Allocations
3.1
Pull Active Allocations
3.2
Pull Current Epoch
3.3
Exclude High Volume Subgraphs
4
Calculate 48-hour query volume using the ‘query_volume’ object loaded from the previous step’s snapshot.
5
This object contains daily query counts per subgraph.
6
Join the 48-hour volume data using the correct column names
7
Replace NA volume with 0 for filtering purposes
8
Filter allocations based on user’s criteria:
9
1. Exclude allocations created in the current epoch.
10
2. Exclude allocations serving > 100k queries in the last 48h AND are less than 20 epochs old.
11
(i.e., keep allocations if they are NOT (high volume AND young))
12
The previous filter based on mean_value (recent query rate) is removed as per the new requirement.
12.1
Close Allocations
13
Synced Subgraphs
14
Indexing Rewards Proportions
15
Query Fee Proportions
16
Available Tokens Data From Subgraph
17
Active Allocations Data From Subgraph
18
Calculate New Allocations
19
Allocate
Delegate to the indexer
Data Analytics for Indexers
4
Calculate 48-hour query volume using the ‘query_volume’ object loaded from the previous step’s snapshot.