7 Available Tokens Data From Subgraph

note: here use RPC node to grab block close to chainhead and use it for timetravel query

# wait one minute - closing allocations takes a while so not needed
#Sys.sleep(60)


# Select columns needed for rewards_per_token calculation and general info
# Remove queries_per_indexer as it no longer exists
rewards_info = synced_subgraphs %>%
  select(deployment, signalled_tokens, total_allocated_tokens, rewards_proportion)
  # Optional: Add queries_per_indexer_48h here if needed for rewards_info analysis later
  # select(deployment, signalled_tokens, total_allocated_tokens, rewards_proportion, queries_per_indexer_48h)

# Now pull total available tokens
query = '{
  indexers(where: {id: "0x74dbb201ecc0b16934e68377bc13013883d9417b"}) {
    stakedTokens
    delegatedTokens
    availableStake
  }
}'

# Send POST request to the GraphQL API
response = POST(url, body = list(query = query), encode = "json")
# Parse the JSON response
content = content(response, "text", encoding='UTF-8')
json_data = fromJSON(content, flatten = TRUE)

# get available tokens amounts
available_tokens = as.data.frame(json_data$data$indexers) %>% 
  mutate(available_stake = as.numeric(availableStake)/10^18,
         total_stake = (as.numeric(stakedTokens)/10^18)+(as.numeric(delegatedTokens))/10^18) %>% 
  select(-availableStake, -delegatedTokens, -stakedTokens)

# Calculate rewards per token
rewards_info$rewards_per_token = rewards_info$rewards_proportion / rewards_info$total_allocated_tokens

# Sort by rewards per token in descending order
rewards_info = rewards_info[order(-rewards_info$rewards_per_token), ] %>% filter(rewards_per_token > 0, rewards_per_token < 9999999)

available_tokens

##   available_stake total_stake
## 1        404937.4     2641737

rewards_info

## # A tibble: 291 × 5
##    deployment         signalled_tokens total_allocated_tokens rewards_proportion
##    <chr>                         <dbl>                  <dbl>              <dbl>
##  1 QmeHJ8Wyk7HpAtFLS…             3.15                      1               3.15
##  2 Qma9bvmT39fCkG5wo…            11.9                       2               5.95
##  3 QmT4t8qY58x1M6wyG…             2.97                      1               2.97
##  4 QmWMLVUQCzsqvQjja…             2.10                      1               2.10
##  5 QmZhm7MB9vuPkBeH5…             1.98                      1               1.98
##  6 QmeZ9q66wq9nWJjrs…             1.00                      1               1.00
##  7 QmSj3cbVeNzXywVHQ…             1.00                      1               1.00
##  8 QmZM8HcNZRZDNTKf4…             1.00                      1               1.00
##  9 QmaB28b3BMpEnPtqJ…             1.00                      1               1.00
## 10 QmaJcXuvGW3GST8Uf…             1.00                      1               1.00
## # ℹ 281 more rows
## # ℹ 1 more variable: rewards_per_token <dbl>

save.image('/root/github/indexer_analytics_tutorial/data/chapters_snapshots/08-available_tokens.RData')