Ricky's Indexer Data Analytics Tutorial
1 Introduction
2 Getting Started
3 Close Allocations
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

6 Join the 48-hour volume data using the correct column names

current_allocations %<>% left_join(forty_eight_hour_volume, by=c(‘deployment’=‘subgraph_deployment_ipfs_hash’))