3 Close Allocations
This is where the allocation management for the indexer begins.
3.1 Pull Active Allocations
First let’s build the query to get the list of active allocations for the indexer:
query = '{
allocations(where: {indexer:"0x74dbb201ecc0b16934e68377bc13013883d9417b", status: Active}, first:1000) {
id
status
allocatedTokens
createdAtEpoch
subgraphDeployment {
ipfsHash
}
}
}'
# And update the Prometheus query to:
prometheus_query <- 'sum by (deployment) (rate(indexer_query_handler_seconds_count[1m]))'Next let’s make the GraphQL request:
# Send POST request to the GraphQL API
response = POST(url, body = list(query = query), encode = "json")## Response [https://gateway.thegraph.com/api/[REDACTED]/subgraphs/id/DZz4kDTdmzWLWsV373w2bSmoar3umKKH9y82SUKr5qmp]## Date: 1745705991## Status: 200## Content-Type: application/json## Size:Now we can get the content of the response:
content = content(response, "text", encoding='UTF-8')## [1] "{\"data\":{\"allocations\":[{\"allocatedTokens\":\"7400000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x0475e99243a8c09856ff943facfca64ac2e7a1b3\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmcykahJW7hPPpvZKXcgTfNeVTVdHfm5wDEoojSzuYmpJA\"}},{\"allocatedTokens\":\"10000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x05631019ff11b6229669327661f2dacd4877ee07\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmRuPq9vmTwDPEQvUaoMGvB3zEPc5S3J1wuJPoW5WMTuVL\"}},{\"allocatedTokens\":\"23500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x08d2649ed14120c6259c1e2b8d15231b0e058893\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmYPnsfXt9W6dMqq6PPfhfEZ6bXv8Tti7fqtSh9EpnLfBe\"}},{\"allocatedTokens\":\"9900000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x0ac03ff73c93a62e9d60b772ab823e684f324ab0\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmPtGvWk56Bw1S9DjUeSq412w7AC4bDdwThf9AYHgjFNKu\"}},{\"allocatedTokens\":\"30600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x0c787cc6dd5ac7d62ecf786f376c10e34471f8d5\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmfEttTZtkWdvsmRkn9VrES9EybS4jiYdMzZZH2LVz2t5Q\"}},{\"allocatedTokens\":\"9800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x0d41de09a1648e8348b37289f72eb92e716bd2d4\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmTxm59Gj98m24yLiP6nMJpWhxdoJ1Xh3nocvu3LDDeKjd\"}},{\"allocatedTokens\":\"9500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x0f96203f00d920b244ecb41744e6464ec14c6d0e\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmUSffoxhjXNQjZmfi56EPWtt1dGGcZcGqz98hmQLh8UzG\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x103a4926bce0445b9b783dd18d9559fb063fcae5\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmSEf3a9UBEmJfu3NDUidWJkFGHTgEWiCVWBEJHaTjGiSA\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x10868386075176fb22883292860c1d0ea9c02e4f\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmPpm5vp6zSn3g6ozPKq9KsKNbvcfjKjqy82ex5QiA6uQJ\"}},{\"allocatedTokens\":\"28400000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x117e356bf7d9cd399f9aa5b7efba6a6130edfd7d\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmYzVKbGx2pAPLNUbmMhA3KMVMHD3WPqdDDjTm9Fm3sgdw\"}},{\"allocatedTokens\":\"18400000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x120b583f8df7fc140a09ae6ebbc68ce7f0baff24\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qmf2LYYE8f2doyoQpCvN7Nc9UZV9YSXUYC5koZ6SHWu2wm\"}},{\"allocatedTokens\":\"2500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x131cf9a055eea49990350ccca6ddf93392703e99\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmY6YjNussTjjaj75jcxXfDUwNiufoBwxYN1Xggr7zTH7R\"}},{\"allocatedTokens\":\"2000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x13a422277bd3b76a79418fe2c0c6996e1869bce1\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmWaCrvdyepm1Pe6RPkJFT3u8KmaZahAvJEFCt27HRWyK4\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x13cb041e1bace3f338fd2ee21557a736be8f6d2a\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmcaswVo8QTsnAFG29wBEGfxEyfPBmazTxxW8XvczPTGsR\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x146087d084ab8ce0cd411c18af6fb3541f926ee6\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmcMk21Jdeng7SWv8yqhskhKbykqgH12vE64cnNhzSbXJ8\"}},{\"allocatedTokens\":\"3000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x16afd5617d4171499c21b6ad0a289eb1d41beeaf\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmP2vXFMSKp4JJkw7WhRv2UrbFFdidHPkVxdnBrycDrN2P\"}},{\"allocatedTokens\":\"9400000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x174f5014e43503e0fad257cfc88a410d01d920b4\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmQUUhJCBR1RLnqXSjSBjjbKMMevnRMNqnseMDsRAcjwPL\"}},{\"allocatedTokens\":\"16500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x1c1f9c7037444e4644ca362b887fde51045d2112\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmZtTFVqw46STD3uwHLD1gQWwn11NS7NaSw1tzZfKCgewG\"}},{\"allocatedTokens\":\"9200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x1e8104012bea4d0d52780dd3762283c995c2a7ec\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmaBwqJfMSksDTGNSGg8HSPwHdsFEq6HMSCAcCBJMrN3Pw\"}},{\"allocatedTokens\":\"10500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x204f34ea4dda805c37169d651a23e1f143f161e8\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmdsSNTCMe1zYjWWb78W7JjeMZbn7cHKBHm3iNxRwqaLwT\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x230058f7479b2ba71dde93941d68ebc0c7c5d4a6\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmYwkNTGCHFu2Q1Kmmd5TrcqvruLMjKjzsGVJaikK6dpXj\"}},{\"allocatedTokens\":\"9200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x2575ea636e300564f83047fbfeebe54fa7be98b6\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmXK4zttkPkpuMYjpyp8YdQYmb15CPN4WETqLStXW9XiGD\"}},{\"allocatedTokens\":\"3500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x25bd88e3baac3af914d7546c4683419bd6de7e37\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmZgJpzfqCveZ1D5Fs8ZFH3C7CUHptbJr2VhnXJPrcKmti\"}},{\"allocatedTokens\":\"1200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x25e2cd48d0e0ad33b9cfa845af6670c8d23c5439\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmPGK7WXbbaifnxMj1SLZQ6Nzoop6UqeZ9zVL6qwfkXEho\"}},{\"allocatedTokens\":\"800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x2b39125a4b5e090a44b5ff6bcb70c0e7efa4df17\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmZbhHCjwzqmeWEroA4DnHjnDJjbVh6rkpY7ACadMvrfqH\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x2e03e7fa73fe4223398a90e3de7b9dde1d8c677c\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmNxTYUMZMzJrg2Q73i9WceoBXHV7AW5RbdB1jQiNKnNRj\"}},{\"allocatedTokens\":\"14200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x2f0050d2a8a85dbc9fb2720f023749a3fa6c4ebb\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmSThLAKsPhzGffqKwcZnteqA2CR6HbQCtHygVojErwiEN\"}},{\"allocatedTokens\":\"8800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x300e1d5f7b38c7e8be40c6599161f591878f33d1\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmddvgpoNsfxXyQ972KhpHMDAyPjwZWcHTd6pXZ9CsuqsZ\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x32c992dda7cab54154b70d89a2940073eb6c9ff5\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmWqnxMsbZTggnmuTouA68bFeKKCwkC6RKpvPXbggCaS3x\"}},{\"allocatedTokens\":\"219000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x333fd74a91457e96541253d78776d421e672cfa6\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmQTx44cVb1YVACtaMbgufyyd791C7TrwK8RykNezYgxiw\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x38aa8c3fdb7f2743015379a7a2d7c7533ea4a174\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmXmSGEiVvQNkcUBbW6CbyYAYJB5Pd6ecd78oPuPvjnkx1\"}},{\"allocatedTokens\":\"6600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x39400d233e8cc610f0e80936fb494697faf8c9c1\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmZBvbb1ud2DMDBSBD3NV3SMWBoNcgi1Z4v62R4X6vBEMh\"}},{\"allocatedTokens\":\"9600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x3a6da5e6a63178e672b23fd89e8d37c14a7edd3a\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmTHjj9Tdy5zCtJn3KvGQam8RaQ3ZncMAgDZL8y9BFxBqY\"}},{\"allocatedTokens\":\"3400000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x3af01ccad52d54861b59ec67cf57b90ba55d14a6\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmNWuoJm4vdpCqi8uZ3JusWoGbRvDn1HB2RhaLqDyq5Qzp\"}},{\"allocatedTokens\":\"50900000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x3bd0ae1d495ea99af2c2974badf9215409703d93\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmWgi6hNfwCGiTAhH7gTSMSfvvYUPRbBQSjRmvuviRGGwy\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x3c82fb6feada72f17adb64d65b1bfe14c3c86c93\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmPbAPGuq8PT5qMW2dtKCZoxW3Rpa2kFfr3qddCFMsorcc\"}},{\"allocatedTokens\":\"1200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x3d7e99530abb7592ffd05138546b180067246df9\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmVQtVpxv9P3Lf1TtLDufqgnkw5RHCMubgsGTgq2orbCfU\"}},{\"allocatedTokens\":\"16700000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x3ebd08748f87ddec1fa7d4db19e345f57e1ef73a\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmdJx5rhUBkjfNWvZzD2w9xbUQYVdgcexL8KkoNPUgswsK\"}},{\"allocatedTokens\":\"7800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x40ee06a8fbe3078d671fd7b3d2e8afef67987ec6\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmaAFmLb4HBgazuxNHY8HziUDAD66zfRALx1kqfD24Ueb8\"}},{\"allocatedTokens\":\"18000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x425f3c620fb264bc5512285e16f63d965a9d81ec\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmdRe7FszwQAknHdYZoETWfPZwvZZA9QYgVcaiMLpKHyDT\"}},{\"allocatedTokens\":\"4600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x444274760a20a1f1d77e75b7fa585f6f77e2959c\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmdwWYDXFWeNcyBwmGP3JUudjsKt4SXqjtFctPdaMtuv4m\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x4575716a8cda6c33a2d28659c3498edb6cb9f4d1\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmZ7jF5cK2gtdanXRvL7bxdWvnP9B38ikWeEXQxoivjsdo\"}},{\"allocatedTokens\":\"32200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x463fa416eb53fce9f46f136cf6e6b097ca5d344b\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmRKm6THtyr3Ej73LF9jVe4GdSiq1sMQg4XVip6axvLdHm\"}},{\"allocatedTokens\":\"15200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x478d796bd7012e6627ce013ab85a54b1157f689f\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qma91PBS9v2N8xFCuTgu18oU1nuqfqgrxTJXWEQ6wWNUMp\"}},{\"allocatedTokens\":\"13900000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x4a1220e2204d2481d3056a3115543ad9c71baa42\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmYk6JtWHXCaRbLkLxFJ5A7oPkKAJ3k61efUxDk5SgTur7\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x4b06b0260e5ca2635f794584b9bd6ead157ede2d\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmXhqwzJZDgnAAVsEYYhg7H46wZQqCMnvXhKionqdmBxGk\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x51253959814006ae7ff0589707b6950944154ca3\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmeHZcGmj7wrJMHRrPVDGiVaprs7t21n1jjeUHhPUeMRcA\"}},{\"allocatedTokens\":\"19600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x52b5c2f1be2e562e1c173ed0023c02b7128fc3b4\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmSXRGMMU4XwbYyhnzM7pjVS3dLkEUn8UuFN7hs9q6U7qd\"}},{\"allocatedTokens\":\"42600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x54b26195c4bb6c8b098466f061e112a132564ae7\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmNNRntvbtiCKNfbak7XqZCgK2TQVR1rd4PohM2sDnPin6\"}},{\"allocatedTokens\":\"24400000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x550942e60ae794f099042dd7f289af999f79bef7\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmRQQYmGyFKhS9VUeuN3airsAQivjqm1QNuHWqe39az4kX\"}},{\"allocatedTokens\":\"16100000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x555bbf19fe39bfeca4fd19a97ee5656ad7ca6c65\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmSdWHc2EMeYdYpkMwpogtNECesGYhaaNFaPzKn4Wrcamv\"}},{\"allocatedTokens\":\"9600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x560b4864ac423314eae353eab80b9bb8c8e52b81\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmVi7VY4RVYr3Ukf2RaWai9tQJ945hCRxFNFfvCNDjwaHY\"}},{\"allocatedTokens\":\"5700000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x5637a9bc8664d2d678d84cb3ee3ce58803843fcf\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmZVxhK2AbqkdiRm9manVAZ3hfaswfiRxTtcePotJTn8Mf\"}},{\"allocatedTokens\":\"12500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x57c9c3260873565be00f262e3b33b2a8e7a40207\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmVFGoBvTa2YWE5QCDXFg1EeaYHKvds9voYQGd2PWRPdrZ\"}},{\"allocatedTokens\":\"3400000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x57fc10a28e81768e92a79f949e258fb1d39dd5f5\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmPorvah322jyTLZdwAGcXyr3FXhLr4oZUYjEkwtfuBitL\"}},{\"allocatedTokens\":\"10300000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x5a0734e430734f7a9243560c7d5254957edd07f9\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmPkfN5871AkgEAaKhbh48oJ78C5E4hZbyBBAvKTa8Epzf\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x5bd67c7dff379ea6c9398862bdffae04aa1e9bc5\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qmduy6o7VkWqJRgBqHUVVuPnowT6kAqWJmQWo5WecgKsV6\"}},{\"allocatedTokens\":\"1100000000000000000000\",\"createdAtEpoch\":878,\"id\":\"0x5d1582b220d8940dd47b3017ad9e49aa8898363e\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qmb7rYJk1BmDDkfYQSobCG9HSLvbEiKrRh5gqv3xXCkzNq\"}},{\"allocatedTokens\":\"20300000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x61f802964d9e3f18282509116d59f9c4ce9de32e\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmTK9rCAwaFewM9fS4jAGzdK35wowJKRNK8dWuPhtjtves\"}},{\"allocatedTokens\":\"14800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x6462a06faebb9fc445d050f472407a1f813f9bad\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmdWjLiYkTUijiRvSYmfMzZXq7wYhSVJYtUADgQEQrYVaa\"}},{\"allocatedTokens\":\"11000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x64918d9693231010e557390b55aedbe0d2137074\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmNRhNkLoaqHbVdbG8aVat7NvVWFq1wGpmEgicUCAiLonD\"}},{\"allocatedTokens\":\"2600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x6534ef28823c7fbc6b285caff616639d1ee23e6b\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmU8G3bY1v3r5RkLjcpJQbBnZauj4pL6KdGQMEhXj3N8qA\"}},{\"allocatedTokens\":\"1200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x65521d72ef065a8b430068b0f0ea0d761ec9ebbc\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmcumC3ZhLgkEyh548qA8tUNwSCe2pRG4fjYH5GsjRQMMs\"}},{\"allocatedTokens\":\"5700000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x67645c4f0f22ce26f0a2cdb155697fed58f71f45\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmX2XKyk1Rk12PSkeC2vBUn7TM1kPESRiipc8yWjezM2Mk\"}},{\"allocatedTokens\":\"16800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x680d9d86cad7719b96b86dde1df0e0362d703dae\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmeJMbnUgBuEkaA85vvM7Su71XR9dW2uhCdxCLqYoLd4Za\"}},{\"allocatedTokens\":\"9300000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x687cce95d5866c8c9af6a923ce84865172155592\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmTyVpF3phzakM765zxsH9wGBtEAqo5x9SkM6CqUF59DMQ\"}},{\"allocatedTokens\":\"5100000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x6fe5ac736825d591e4f674a0b71cf1141625e8c8\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmcPi2qpDKaQuZdmkakgLq7pTCdd6emPJtW5TgNz1o9RNe\"}},{\"allocatedTokens\":\"1800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x72f63d4aceceae10bb4d8c7b1eed26dd18af5c89\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qmdp89ALKgfGVTjvwpD3hDtgTvGpfM9VuZPUtc6MiCztqh\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":878,\"id\":\"0x73c61b69e27f9dad087b694c5216e3e285d71e7a\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmRT7M2wHbkFdC9N9qje9UZ7WMHQ3MhwMvSHfWFYg9vGBr\"}},{\"allocatedTokens\":\"16800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x75683ff83fe31a958de91fab4649ecd26f5dfaf5\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qmaxcs5FKtvm2hgKRFPSfoQf9w4r5squ3XixKG6YwG1R14\"}},{\"allocatedTokens\":\"10100000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x77797a7a3d8c13e212243598ca26a8b0adea1428\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmVpFJ5tfc9YPDS8TaRj2ocsq9CGKYhRem2HMbCRWMBLRE\"}},{\"allocatedTokens\":\"18800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x7b3c9f5086cb76af6ec2f56dab953431c064cd1b\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmPpNXZS6SfP7LYFgV1aHRwqSGrZRHB3piFMtz6qKsVH7o\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x7b5cdc3fbcf4c412180370acda8795f78982e34b\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmWXhLkz6fRJwLyFmgBKVu2NyMD6MqtGhcrt8bNcm1xpuU\"}},{\"allocatedTokens\":\"39700000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x7c4dc144508f637488dc1ddabaf51d7c48f59308\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmUCbuvzqWwa9GcBucSdejFKZqM6dYxK7iNPj1k52cKt59\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x7d7dd4f9756f2554d295ace345f6402755d0f2f5\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmXiRbvCs9aCt7PzkFE26SE4usDLJLeKhDWNpZfzV7qHGW\"}},{\"allocatedTokens\":\"67100000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x7f31f6302b8aa21396338c56e516e8e32ce840f0\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmVUcp8WqE47payYxMJULkqhTbn2H9yhUSCXnUi5zH2Co5\"}},{\"allocatedTokens\":\"43000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x7f942b60d4633297253a2df0b8cc9f1f4584fd4f\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmSK5hvEsM5mw6658SE1BWm4JdAWV42PZTVFh5H7xWAEiz\"}},{\"allocatedTokens\":\"38500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x7fe3e6bd4af0c5e364a3a894c22973ea8cb66884\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qmd7Tub28sBv3UF4FZH46LAXyBQSq3TJUCY7jF3KVdSTpW\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x7fee4ae7ae9525c38b235e0597ac59ec2fbb7f0e\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmXJMMj2hUoBmcXtq4Z7oSh8K6msyE2pk4hTSvpHxJ2TdZ\"}},{\"allocatedTokens\":\"21500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x80a78cd7fea1b397c693fd703eb3ba9066d18059\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qme4pZsov2kSRxYR74SvYCQuiWi8MqybCfBWbEXeyMYEjv\"}},{\"allocatedTokens\":\"9000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x80cffcf072d62ee69eef3b13cd1e2017024d3ec1\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmVZPQKJwQuEkHAHAc3DMGxgAnnHi86F83iTtGoBaxcuWs\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x81d40fc125ace50ce3d407ebd9e387b4f51173f5\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmSzo43g1vnQCRE3paJXkWwawujVkEs3LqDpB4SoXmbUSP\"}},{\"allocatedTokens\":\"113900000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x89a3a31a188158ed560873c534ecd40598b302a6\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmeYDDGexx97zQu5udspRQpYHpV2Er3718cz4UyGDVnVtp\"}},{\"allocatedTokens\":\"17500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x8b9df225645ea771794172f4d6bfe460a9646cf9\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmUYUauhzyakRidG1FEZdC2PuR3vnt4VQotmPXaNKqtD8r\"}},{\"allocatedTokens\":\"2500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x8e1c5fb2af7e80e154d33ca5d7763ce46ce7f891\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmZaHRYsV6rh6iJKyf8vsVKn8977FTAh6iAXXqYbs9ETBN\"}},{\"allocatedTokens\":\"25600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x8e7fcf82c480782ff9bcf12876b1fc0bc6d521ae\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmQ5V1UsyNFPjHBCw4dieu46tNrWi9AVtGbiym2EXUQmVc\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x8ee3fd2019469b06ae793fd005553b9199309abb\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmYWvmm6rxvAk8E3cA6iXPhC6ETBLJFuEw8maYJ7YV9ATx\"}},{\"allocatedTokens\":\"21300000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x8f87c4d115fb28ef99fd59340b2004f3391792ee\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmZd7ew6pgSn3BA1zPKJ5GC3iRRtYezMNcADpcHnpPAdju\"}},{\"allocatedTokens\":\"21300000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x902dffe28585aed4e00a520266882886c18566dd\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmPBLbvqWxYxEMY7JSQU2SjR2cYZpQv7XErQaaMMpCSDq5\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x953aa82e651baf8636dc8d00b58c085cb5a05423\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmTiai398HETp6qKhMph6t8bZihgTTaRG3roKEYDG5CCN7\"}},{\"allocatedTokens\":\"11200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0x98cb1c4ad737d6812f801f30130d682d8fa42d25\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qmaj3MHPQ5AecbPuzUyLo9rFvuQwcAYpkXrf3dTUPV8rRu\"}},{\"allocatedTokens\":\"11200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xa0929349a11018aa43c451a0bad7c77876ce35bc\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmVxRKd6bbcbUzbNncEwTr8MxEZcnAb3NqV9YN1aBw6tgS\"}},{\"allocatedTokens\":\"142900000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xa1c557a083eb02ff9fafad72547a9f4a22416701\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmarbBQvPpbfG1juCocy46bKfVXpTCPnsqPZ39hZ8m8jx3\"}},{\"allocatedTokens\":\"5600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xa2274e7d720621f8e4ef991ff974adbab93fe1c1\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qmb5uEy2BRXTzKo5xNyxcQrPBE7vPztcS9eoZmdpQksCto\"}},{\"allocatedTokens\":\"20200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xa2eab34358fce6647329c97c3ac9fded577442c6\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmcdvmAXqHh4cy37ePuETRcFjWv5tSUF1A1QqJf6Nx147t\"}},{\"allocatedTokens\":\"1900000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xa440754a4f0224d538349e2d665f0229ec7ea366\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmeSiH8GW213XNQFY31rRC4XhLZv2D6y2Sr14tF5pqAKSb\"}},{\"allocatedTokens\":\"30200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xa47fbe78fa74a8b8e26e54cdf711048d89c41e52\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmTLSeRxpzC9qheT67f28LYCsNDd6Coje2S1VR8NSdjJhU\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xa71c5455f41c6fb571c32f0c44667c9bc26e1eab\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qme5nGiCCDJcDtA5xoJ4iPAtjQgBfLekqRvxXesKCiH8XX\"}},{\"allocatedTokens\":\"24200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xa86f8599ae55934251f8a0fe524d631c55d56fdb\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmNbPLNKU4GLrZbi6o4Kw7Z42GC3Wd7J21aXqie1Tj3Avp\"}},{\"allocatedTokens\":\"4500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xacf83f67cfb20d1c6c0b5cb8ea271443f27702de\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmbmFMeTQQu41NeAYRKnrzbp7ABHG2QfGsxB1RxKHCfhoB\"}},{\"allocatedTokens\":\"26700000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xad20fb57b000336c8728532c9abc6aba2f496ade\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmXkEwZRMagTAtZt1mf6vPRu2kV4JUyjoKHriayJ6YbJfv\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xaf1ee3d2e66148c1812359f72131e3105fa78f26\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmUv1eeYZnvodEv92JmULdHgoZGacm4391zki6dxPz2vk9\"}},{\"allocatedTokens\":\"10100000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xb1f90d907ef274282aa2bac6067d0ef2ccd993ef\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmTvVAGTfCUcYXEAzgB76bpM2R27tuFBopjZnUFQmTxgbm\"}},{\"allocatedTokens\":\"6300000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xb28b9eb0ef94ccbf333f216dbc65d1f52d4ee97a\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmXkQR47WZeBQq1XhMujqR5ou642PDSRnf26UHtQaoNbbP\"}},{\"allocatedTokens\":\"46100000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xb31f862f1a4034e33292cfe44cc922cacc254915\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmRbn71wTNK3PmEb62wUK4G1XmKN14ZbHeTgi5JubL7evA\"}},{\"allocatedTokens\":\"20900000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xb36f77ed13e314f89e60b24c86463641d4f3d5a7\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qmdv8zRyxPC7cmi5fpTdcViptimbCwaHVdb71sXPdWzUhL\"}},{\"allocatedTokens\":\"5300000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xb3e7ea4be2fc4cd569529f06625c5e29935d9084\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmR1jfvovkrsMGd4YVNweJtVmi2DPzgnTfnVsFMjUnNRkB\"}},{\"allocatedTokens\":\"11100000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xb84a87b6881286404386885e35903761ba09fa78\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmUaEvatzK4DokiCFr8JyJTj64CKX74pV7LJgthqvUGYND\"}},{\"allocatedTokens\":\"28100000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xb8d1d5a151a4836976dc50a14141b35f8f04ec9d\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmWoG43UWCqZpM3ZCvdvjAfeNuYxs3kEeME9aCytkSZAGE\"}},{\"allocatedTokens\":\"6900000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xb8f6af0392c3f50dd65d99bf8723b30b836cb520\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmSfzHGKNGRuXMUvqMo3ksoZaB5Go9FpoVHtBToBGyYgf4\"}},{\"allocatedTokens\":\"9600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xb9461821bada40b41850a2ec11188f8cf184c0f8\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmXpQxU2u8CeswB7t43M6bEnqCa13b6qHD3x5t9qY2BBaQ\"}},{\"allocatedTokens\":\"36600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xb9f00575fc82fcd96ca04aa2907416d66e091427\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmQtNd36amtQ8h8GF5rwkLLWyyBGwqad3j3WgZAMuLvDMd\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xba3e8ded76649c88b92255b5625207aac5a98be7\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmVHVUTkiTEdF7SijmwvjaGYcPYgwwBBnPd6f177bqFuhd\"}},{\"allocatedTokens\":\"10400000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xbe032ac965f62c124eaa40240fa81c413ee4a25e\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmUSU8LmgDXx9xS8N7wWfjepjGMUqAkfMoHCD6N82LXqFB\"}},{\"allocatedTokens\":\"27000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xbf5f1281d2563f5e1e8320a848103fea58d4ffc7\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmTP1TLUgMFYSwGUArxQypa2R4QmEWyoDKfjFcu4mUavac\"}},{\"allocatedTokens\":\"2200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xbf67f243ed888b18c4483b260189ca1e33480c1f\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmdR4xn8pvAgHNfb4i16RGeurWPRaphCQWnHkGAv2j3yoM\"}},{\"allocatedTokens\":\"4800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xc3f0fbc613fc1e8f308b78ce61353aa438f8937c\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmSnb9bKAQTq2jt26LF2DHPP67UKh6FcSXGAXzo1cVNFAD\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xc510e5991631710c3ca9e84455d87e5d31dd7b3a\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmWFAFmcKXaksfC1TpDDr8dJHt6gjJcEWKLowEyKnKoxoT\"}},{\"allocatedTokens\":\"18600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xc683a28d90bf86b9e34a94cc5d767956e71ca9d2\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmWVPZbwTwbdWtFsyqFyaweXA8T3wHXYWQcBQ1r6FMPEkz\"}},{\"allocatedTokens\":\"32000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xc7ce5a6bf1f665d872dd40ff6d337a857f90ad04\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmcK5HmdqJjhJh18g8cTog2FYP7497T2nz25ESaWdyXk1Z\"}},{\"allocatedTokens\":\"12400000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xc8acb209f610bea1a33b3b5bce32813dcf5e2a12\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qmf7y7jWbNnaqgePvpvSfMbJPrmbRb2xUtXBUeTd9XHVkF\"}},{\"allocatedTokens\":\"50700000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xc8f38c1145be55824b0a83997a1776ad1bbbc866\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmbjYuCtfduXuckjswRHf9qdT1H7J6HNSKtVSijYizXsBh\"}},{\"allocatedTokens\":\"41200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xc9480326849a8c239386294a13a16bdf0f281972\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmVXQ6gcgLbrJpDdUMmFSvqkFebYbhCsPgWho1qcNDMhNe\"}},{\"allocatedTokens\":\"27500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xca3407b68f8e8827630a8800a37c8f2e4ee6fd08\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmVGzXHaNyCCJd7tjzGRCJZdWwCW5nCxqub6iHrFxmaaS8\"}},{\"allocatedTokens\":\"8200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xca409cdd40416f2189bbed11eaafdf9c191bac93\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmSmcEG9MemxKGrj4ASDJ3JccRtZDbxTLvXgCu7WBYQeAQ\"}},{\"allocatedTokens\":\"2100000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xcaf6693acaf8d54e16e2e2c36a52e9cae89b899f\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmXq9iyPmbWFfSZ5rJQGT1L8RmgKLGQJXxHknpLsJ1QUXb\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xcc3ff93a44eef4e33eda9df0f21a006e973ea08b\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmTYD6jJ4eY1dsBdnsAa8nauSbyGCwfcv7y6XzU9SfWRcy\"}},{\"allocatedTokens\":\"10000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xd0475a52ef78cfb245c531434741c5abb4bee27d\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmdwwtZact8w2pE7bRpvptS91cd95kWGmxZyj41yi2noZi\"}},{\"allocatedTokens\":\"24500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xd36a149f3598cb9fb491a511c191ccafea4e89ff\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmdRFSobiBMoKKyNZnwahtn8uzPFxat86qg1Mu7KobJcSb\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xd3aefb31671b0748f07583723c1186bf265bf7e0\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmUhiH6Z5xo6o3GNzsSvqpGKLmCt6w5WzKQ1yHk6C8AA8S\"}},{\"allocatedTokens\":\"12400000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xd5294819017c94e819876bfeb19c4a20b13a70f3\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmP6bTNozTjdcv9nXvRRzoCV1f3bMh4cuWBDfafARHrQqC\"}},{\"allocatedTokens\":\"4200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xd5529d667de195ec11e95acc00c250d3686828b0\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmNVHQWAUsrjq83SQCD7R8M4HAUyVvsrPcwHisPTfGrw1Z\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xd93e398d2ae98aec788ae3c151af7404d78dd647\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmP1uNJnsz2v4ynvoyRKSaoJFgVtotQyyttdQDhHtGTmwr\"}},{\"allocatedTokens\":\"3500000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xda659b8652b9b74db16e5f0a1335eaa72ac49054\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmUuXLf2WA7AaThyrv9rMcKTgqwjgoSA3wujjYCfBrhXQc\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xdc65f260c13e22d378d612e3e27c28f4e8f75501\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmfLdMHaFQzpYV5Yzqc8UxQcHJ8xjer5J8fkYMkzu9hakM\"}},{\"allocatedTokens\":\"8900000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xdd2377458a923a0b72ceab062af57e8e8aba5c5c\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmWJiduWv7RpLckjMEsXCKffwAcdAsM8gfnTfV642CwfMr\"}},{\"allocatedTokens\":\"3900000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xdd3dde90dd96ff40eb2313d3e9aeb0ebc05bc52d\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmVxMhEzFyPHoGzK7E4HQLVv9E8HzPB8hSpqVL9evtqh2K\"}},{\"allocatedTokens\":\"7100000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xe11f79cdd190ecd38722ead886709b2282e9a66c\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmcQSBBPpJgDcYrKyGy6oGP9BN7FcczRv32t1cfKbtWuRU\"}},{\"allocatedTokens\":\"31800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xe137ef93b935ef1eda5ef9f4c79344765fb112e8\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmV5QTCUK8Zs6k6pjz5dqAvt2ZNvwKTqDWNyJmqFjsnYyV\"}},{\"allocatedTokens\":\"12000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xe635d3c68fb36889e5a90b6ad7eb5b7851560370\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmbS4ZMCW4QFEwUXMKs1xYZ4RZBNQCLccd5qoVU7erQtTM\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xf006c4e5dcdf0c1a619f61f42cd6a43e82e5ee7c\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmTL9gppqx1peUXStyro9UNN8eHRUR9rwBXjRJwhUrkHTR\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xf04925a42cae40df543de2df6dca632a819d80cb\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"Qmb27RY3RqP98UMKbTgScf6F7hhokfMuS9fV7VAtPiZHwF\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xf0be01e154087e0054f7047b64f6ef13f8334a04\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmQTGTovKTt3pni5iRyeWKYkUM2sttEahfDd5yhwqqiBkW\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xf30510bf0b0bea6d3188b1e8f9431127586adb7c\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmP1yBXic8wBA9u3vdHHL9smk7sE7gcox48L2QoTGL35Cs\"}},{\"allocatedTokens\":\"58700000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xf41714034d8c2921de33ae6c2a71d73925081f87\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmYzXQTUFhqwnDFxS1ya7xjMSHZmvu7VdM8xRtHXmTrNs9\"}},{\"allocatedTokens\":\"233900000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xf549494c5fc94b747a896a81a87cf8d94cde863d\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmdKXcBUHR3UyURqVRQHu1oV6VUkBrhi2vNvMx3bNDnUCc\"}},{\"allocatedTokens\":\"5600000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xf5e7b13342868f945529ab9d2bccd06c2898a346\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmR3U5haiQg5ymFW9okrkbNBBiRzYJR8kB5Qh9AhFQK5Z5\"}},{\"allocatedTokens\":\"9800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xf63a0f6a7def277c93a5771774ef63024d6071f8\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmY7fYywXjPvedrvy6KvpjZGq5zmK6qA3TzRzcxH2XHSP3\"}},{\"allocatedTokens\":\"1000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xfaec09d95a8e64d94e7db534a9a0ba0348a1cfe2\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmeHE5D625KJ2btdn7jx9b9EtLtH5kiTjp75y6Qtd5XUo5\"}},{\"allocatedTokens\":\"9200000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xfbe06b9fcb5f661a0fcd6a07c5a6b1eefe327e81\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmcwB9YSdLPEZY952LwJcGCkbCuxXd1uT8xTMdwtw2vsUw\"}},{\"allocatedTokens\":\"2000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xfd08bc27491b1e3f4919ceadfccd8a3472303dc3\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmTCHDfwDRJspwLKboHDyTzLYwhxvsSSpi6grB5G9ZRmtS\"}},{\"allocatedTokens\":\"7000000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xfdbc0980ab2b303f5a086655300a7e733e056933\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmabixWKSqeUms5NU5RNgAMVRrRnX9n9bt45hAftggUs7q\"}},{\"allocatedTokens\":\"12800000000000000000000\",\"createdAtEpoch\":868,\"id\":\"0xfe04b7f52540dab12d1befc562115c67c9c4c9c7\",\"status\":\"Active\",\"subgraphDeployment\":{\"ipfsHash\":\"QmazyoeJLSfTPhWa2q9LkfJAm2TGTxWomfSs2ivSux3vVb\"}}]}}"Next let’s parse from JSON into a dataframe:
json_data = fromJSON(content, flatten = TRUE)## $data
## $data$allocations
## allocatedTokens createdAtEpoch
## 1 7400000000000000000000 868
## 2 10000000000000000000000 868
## 3 23500000000000000000000 868
## 4 9900000000000000000000 868
## 5 30600000000000000000000 868
## 6 9800000000000000000000 868
## 7 9500000000000000000000 868
## 8 7000000000000000000000 868
## 9 7000000000000000000000 868
## 10 28400000000000000000000 868
## 11 18400000000000000000000 868
## 12 2500000000000000000000 868
## 13 2000000000000000000000 868
## 14 7000000000000000000000 868
## 15 7000000000000000000000 868
## 16 3000000000000000000000 868
## 17 9400000000000000000000 868
## 18 16500000000000000000000 868
## 19 9200000000000000000000 868
## 20 10500000000000000000000 868
## 21 7000000000000000000000 868
## 22 9200000000000000000000 868
## 23 3500000000000000000000 868
## 24 1200000000000000000000 868
## 25 800000000000000000000 868
## 26 7000000000000000000000 868
## 27 14200000000000000000000 868
## 28 8800000000000000000000 868
## 29 7000000000000000000000 868
## 30 219000000000000000000000 868
## 31 7000000000000000000000 868
## 32 6600000000000000000000 868
## 33 9600000000000000000000 868
## 34 3400000000000000000000 868
## 35 50900000000000000000000 868
## 36 7000000000000000000000 868
## 37 1200000000000000000000 868
## 38 16700000000000000000000 868
## 39 7800000000000000000000 868
## 40 18000000000000000000000 868
## 41 4600000000000000000000 868
## 42 7000000000000000000000 868
## 43 32200000000000000000000 868
## 44 15200000000000000000000 868
## 45 13900000000000000000000 868
## 46 7000000000000000000000 868
## 47 7000000000000000000000 868
## 48 19600000000000000000000 868
## 49 42600000000000000000000 868
## 50 24400000000000000000000 868
## 51 16100000000000000000000 868
## 52 9600000000000000000000 868
## 53 5700000000000000000000 868
## 54 12500000000000000000000 868
## 55 3400000000000000000000 868
## 56 10300000000000000000000 868
## 57 7000000000000000000000 868
## 58 1100000000000000000000 878
## 59 20300000000000000000000 868
## 60 14800000000000000000000 868
## 61 11000000000000000000000 868
## 62 2600000000000000000000 868
## 63 1200000000000000000000 868
## 64 5700000000000000000000 868
## 65 16800000000000000000000 868
## 66 9300000000000000000000 868
## 67 5100000000000000000000 868
## 68 1800000000000000000000 868
## 69 7000000000000000000000 878
## 70 16800000000000000000000 868
## 71 10100000000000000000000 868
## 72 18800000000000000000000 868
## 73 7000000000000000000000 868
## 74 39700000000000000000000 868
## 75 7000000000000000000000 868
## 76 67100000000000000000000 868
## 77 43000000000000000000000 868
## 78 38500000000000000000000 868
## 79 7000000000000000000000 868
## 80 21500000000000000000000 868
## 81 9000000000000000000000 868
## 82 7000000000000000000000 868
## 83 113900000000000000000000 868
## 84 17500000000000000000000 868
## 85 2500000000000000000000 868
## 86 25600000000000000000000 868
## 87 7000000000000000000000 868
## 88 21300000000000000000000 868
## 89 21300000000000000000000 868
## 90 7000000000000000000000 868
## 91 11200000000000000000000 868
## 92 11200000000000000000000 868
## 93 142900000000000000000000 868
## 94 5600000000000000000000 868
## 95 20200000000000000000000 868
## 96 1900000000000000000000 868
## 97 30200000000000000000000 868
## 98 7000000000000000000000 868
## 99 24200000000000000000000 868
## 100 4500000000000000000000 868
## 101 26700000000000000000000 868
## 102 7000000000000000000000 868
## 103 10100000000000000000000 868
## 104 6300000000000000000000 868
## 105 46100000000000000000000 868
## 106 20900000000000000000000 868
## 107 5300000000000000000000 868
## 108 11100000000000000000000 868
## 109 28100000000000000000000 868
## 110 6900000000000000000000 868
## 111 9600000000000000000000 868
## 112 36600000000000000000000 868
## 113 7000000000000000000000 868
## 114 10400000000000000000000 868
## 115 27000000000000000000000 868
## 116 2200000000000000000000 868
## 117 4800000000000000000000 868
## 118 7000000000000000000000 868
## 119 18600000000000000000000 868
## 120 32000000000000000000000 868
## 121 12400000000000000000000 868
## 122 50700000000000000000000 868
## 123 41200000000000000000000 868
## 124 27500000000000000000000 868
## 125 8200000000000000000000 868
## 126 2100000000000000000000 868
## 127 7000000000000000000000 868
## 128 10000000000000000000000 868
## 129 24500000000000000000000 868
## 130 7000000000000000000000 868
## 131 12400000000000000000000 868
## 132 4200000000000000000000 868
## 133 7000000000000000000000 868
## 134 3500000000000000000000 868
## 135 7000000000000000000000 868
## 136 8900000000000000000000 868
## 137 3900000000000000000000 868
## 138 7100000000000000000000 868
## 139 31800000000000000000000 868
## 140 12000000000000000000000 868
## 141 7000000000000000000000 868
## 142 7000000000000000000000 868
## 143 7000000000000000000000 868
## 144 7000000000000000000000 868
## 145 58700000000000000000000 868
## 146 233900000000000000000000 868
## 147 5600000000000000000000 868
## 148 9800000000000000000000 868
## 149 1000000000000000000000 868
## 150 9200000000000000000000 868
## 151 2000000000000000000000 868
## 152 7000000000000000000000 868
## 153 12800000000000000000000 868
## id status
## 1 0x0475e99243a8c09856ff943facfca64ac2e7a1b3 Active
## 2 0x05631019ff11b6229669327661f2dacd4877ee07 Active
## 3 0x08d2649ed14120c6259c1e2b8d15231b0e058893 Active
## 4 0x0ac03ff73c93a62e9d60b772ab823e684f324ab0 Active
## 5 0x0c787cc6dd5ac7d62ecf786f376c10e34471f8d5 Active
## 6 0x0d41de09a1648e8348b37289f72eb92e716bd2d4 Active
## 7 0x0f96203f00d920b244ecb41744e6464ec14c6d0e Active
## 8 0x103a4926bce0445b9b783dd18d9559fb063fcae5 Active
## 9 0x10868386075176fb22883292860c1d0ea9c02e4f Active
## 10 0x117e356bf7d9cd399f9aa5b7efba6a6130edfd7d Active
## 11 0x120b583f8df7fc140a09ae6ebbc68ce7f0baff24 Active
## 12 0x131cf9a055eea49990350ccca6ddf93392703e99 Active
## 13 0x13a422277bd3b76a79418fe2c0c6996e1869bce1 Active
## 14 0x13cb041e1bace3f338fd2ee21557a736be8f6d2a Active
## 15 0x146087d084ab8ce0cd411c18af6fb3541f926ee6 Active
## 16 0x16afd5617d4171499c21b6ad0a289eb1d41beeaf Active
## 17 0x174f5014e43503e0fad257cfc88a410d01d920b4 Active
## 18 0x1c1f9c7037444e4644ca362b887fde51045d2112 Active
## 19 0x1e8104012bea4d0d52780dd3762283c995c2a7ec Active
## 20 0x204f34ea4dda805c37169d651a23e1f143f161e8 Active
## 21 0x230058f7479b2ba71dde93941d68ebc0c7c5d4a6 Active
## 22 0x2575ea636e300564f83047fbfeebe54fa7be98b6 Active
## 23 0x25bd88e3baac3af914d7546c4683419bd6de7e37 Active
## 24 0x25e2cd48d0e0ad33b9cfa845af6670c8d23c5439 Active
## 25 0x2b39125a4b5e090a44b5ff6bcb70c0e7efa4df17 Active
## 26 0x2e03e7fa73fe4223398a90e3de7b9dde1d8c677c Active
## 27 0x2f0050d2a8a85dbc9fb2720f023749a3fa6c4ebb Active
## 28 0x300e1d5f7b38c7e8be40c6599161f591878f33d1 Active
## 29 0x32c992dda7cab54154b70d89a2940073eb6c9ff5 Active
## 30 0x333fd74a91457e96541253d78776d421e672cfa6 Active
## 31 0x38aa8c3fdb7f2743015379a7a2d7c7533ea4a174 Active
## 32 0x39400d233e8cc610f0e80936fb494697faf8c9c1 Active
## 33 0x3a6da5e6a63178e672b23fd89e8d37c14a7edd3a Active
## 34 0x3af01ccad52d54861b59ec67cf57b90ba55d14a6 Active
## 35 0x3bd0ae1d495ea99af2c2974badf9215409703d93 Active
## 36 0x3c82fb6feada72f17adb64d65b1bfe14c3c86c93 Active
## 37 0x3d7e99530abb7592ffd05138546b180067246df9 Active
## 38 0x3ebd08748f87ddec1fa7d4db19e345f57e1ef73a Active
## 39 0x40ee06a8fbe3078d671fd7b3d2e8afef67987ec6 Active
## 40 0x425f3c620fb264bc5512285e16f63d965a9d81ec Active
## 41 0x444274760a20a1f1d77e75b7fa585f6f77e2959c Active
## 42 0x4575716a8cda6c33a2d28659c3498edb6cb9f4d1 Active
## 43 0x463fa416eb53fce9f46f136cf6e6b097ca5d344b Active
## 44 0x478d796bd7012e6627ce013ab85a54b1157f689f Active
## 45 0x4a1220e2204d2481d3056a3115543ad9c71baa42 Active
## 46 0x4b06b0260e5ca2635f794584b9bd6ead157ede2d Active
## 47 0x51253959814006ae7ff0589707b6950944154ca3 Active
## 48 0x52b5c2f1be2e562e1c173ed0023c02b7128fc3b4 Active
## 49 0x54b26195c4bb6c8b098466f061e112a132564ae7 Active
## 50 0x550942e60ae794f099042dd7f289af999f79bef7 Active
## 51 0x555bbf19fe39bfeca4fd19a97ee5656ad7ca6c65 Active
## 52 0x560b4864ac423314eae353eab80b9bb8c8e52b81 Active
## 53 0x5637a9bc8664d2d678d84cb3ee3ce58803843fcf Active
## 54 0x57c9c3260873565be00f262e3b33b2a8e7a40207 Active
## 55 0x57fc10a28e81768e92a79f949e258fb1d39dd5f5 Active
## 56 0x5a0734e430734f7a9243560c7d5254957edd07f9 Active
## 57 0x5bd67c7dff379ea6c9398862bdffae04aa1e9bc5 Active
## 58 0x5d1582b220d8940dd47b3017ad9e49aa8898363e Active
## 59 0x61f802964d9e3f18282509116d59f9c4ce9de32e Active
## 60 0x6462a06faebb9fc445d050f472407a1f813f9bad Active
## 61 0x64918d9693231010e557390b55aedbe0d2137074 Active
## 62 0x6534ef28823c7fbc6b285caff616639d1ee23e6b Active
## 63 0x65521d72ef065a8b430068b0f0ea0d761ec9ebbc Active
## 64 0x67645c4f0f22ce26f0a2cdb155697fed58f71f45 Active
## 65 0x680d9d86cad7719b96b86dde1df0e0362d703dae Active
## 66 0x687cce95d5866c8c9af6a923ce84865172155592 Active
## 67 0x6fe5ac736825d591e4f674a0b71cf1141625e8c8 Active
## 68 0x72f63d4aceceae10bb4d8c7b1eed26dd18af5c89 Active
## 69 0x73c61b69e27f9dad087b694c5216e3e285d71e7a Active
## 70 0x75683ff83fe31a958de91fab4649ecd26f5dfaf5 Active
## 71 0x77797a7a3d8c13e212243598ca26a8b0adea1428 Active
## 72 0x7b3c9f5086cb76af6ec2f56dab953431c064cd1b Active
## 73 0x7b5cdc3fbcf4c412180370acda8795f78982e34b Active
## 74 0x7c4dc144508f637488dc1ddabaf51d7c48f59308 Active
## 75 0x7d7dd4f9756f2554d295ace345f6402755d0f2f5 Active
## 76 0x7f31f6302b8aa21396338c56e516e8e32ce840f0 Active
## 77 0x7f942b60d4633297253a2df0b8cc9f1f4584fd4f Active
## 78 0x7fe3e6bd4af0c5e364a3a894c22973ea8cb66884 Active
## 79 0x7fee4ae7ae9525c38b235e0597ac59ec2fbb7f0e Active
## 80 0x80a78cd7fea1b397c693fd703eb3ba9066d18059 Active
## 81 0x80cffcf072d62ee69eef3b13cd1e2017024d3ec1 Active
## 82 0x81d40fc125ace50ce3d407ebd9e387b4f51173f5 Active
## 83 0x89a3a31a188158ed560873c534ecd40598b302a6 Active
## 84 0x8b9df225645ea771794172f4d6bfe460a9646cf9 Active
## 85 0x8e1c5fb2af7e80e154d33ca5d7763ce46ce7f891 Active
## 86 0x8e7fcf82c480782ff9bcf12876b1fc0bc6d521ae Active
## 87 0x8ee3fd2019469b06ae793fd005553b9199309abb Active
## 88 0x8f87c4d115fb28ef99fd59340b2004f3391792ee Active
## 89 0x902dffe28585aed4e00a520266882886c18566dd Active
## 90 0x953aa82e651baf8636dc8d00b58c085cb5a05423 Active
## 91 0x98cb1c4ad737d6812f801f30130d682d8fa42d25 Active
## 92 0xa0929349a11018aa43c451a0bad7c77876ce35bc Active
## 93 0xa1c557a083eb02ff9fafad72547a9f4a22416701 Active
## 94 0xa2274e7d720621f8e4ef991ff974adbab93fe1c1 Active
## 95 0xa2eab34358fce6647329c97c3ac9fded577442c6 Active
## 96 0xa440754a4f0224d538349e2d665f0229ec7ea366 Active
## 97 0xa47fbe78fa74a8b8e26e54cdf711048d89c41e52 Active
## 98 0xa71c5455f41c6fb571c32f0c44667c9bc26e1eab Active
## 99 0xa86f8599ae55934251f8a0fe524d631c55d56fdb Active
## 100 0xacf83f67cfb20d1c6c0b5cb8ea271443f27702de Active
## 101 0xad20fb57b000336c8728532c9abc6aba2f496ade Active
## 102 0xaf1ee3d2e66148c1812359f72131e3105fa78f26 Active
## 103 0xb1f90d907ef274282aa2bac6067d0ef2ccd993ef Active
## 104 0xb28b9eb0ef94ccbf333f216dbc65d1f52d4ee97a Active
## 105 0xb31f862f1a4034e33292cfe44cc922cacc254915 Active
## 106 0xb36f77ed13e314f89e60b24c86463641d4f3d5a7 Active
## 107 0xb3e7ea4be2fc4cd569529f06625c5e29935d9084 Active
## 108 0xb84a87b6881286404386885e35903761ba09fa78 Active
## 109 0xb8d1d5a151a4836976dc50a14141b35f8f04ec9d Active
## 110 0xb8f6af0392c3f50dd65d99bf8723b30b836cb520 Active
## 111 0xb9461821bada40b41850a2ec11188f8cf184c0f8 Active
## 112 0xb9f00575fc82fcd96ca04aa2907416d66e091427 Active
## 113 0xba3e8ded76649c88b92255b5625207aac5a98be7 Active
## 114 0xbe032ac965f62c124eaa40240fa81c413ee4a25e Active
## 115 0xbf5f1281d2563f5e1e8320a848103fea58d4ffc7 Active
## 116 0xbf67f243ed888b18c4483b260189ca1e33480c1f Active
## 117 0xc3f0fbc613fc1e8f308b78ce61353aa438f8937c Active
## 118 0xc510e5991631710c3ca9e84455d87e5d31dd7b3a Active
## 119 0xc683a28d90bf86b9e34a94cc5d767956e71ca9d2 Active
## 120 0xc7ce5a6bf1f665d872dd40ff6d337a857f90ad04 Active
## 121 0xc8acb209f610bea1a33b3b5bce32813dcf5e2a12 Active
## 122 0xc8f38c1145be55824b0a83997a1776ad1bbbc866 Active
## 123 0xc9480326849a8c239386294a13a16bdf0f281972 Active
## 124 0xca3407b68f8e8827630a8800a37c8f2e4ee6fd08 Active
## 125 0xca409cdd40416f2189bbed11eaafdf9c191bac93 Active
## 126 0xcaf6693acaf8d54e16e2e2c36a52e9cae89b899f Active
## 127 0xcc3ff93a44eef4e33eda9df0f21a006e973ea08b Active
## 128 0xd0475a52ef78cfb245c531434741c5abb4bee27d Active
## 129 0xd36a149f3598cb9fb491a511c191ccafea4e89ff Active
## 130 0xd3aefb31671b0748f07583723c1186bf265bf7e0 Active
## 131 0xd5294819017c94e819876bfeb19c4a20b13a70f3 Active
## 132 0xd5529d667de195ec11e95acc00c250d3686828b0 Active
## 133 0xd93e398d2ae98aec788ae3c151af7404d78dd647 Active
## 134 0xda659b8652b9b74db16e5f0a1335eaa72ac49054 Active
## 135 0xdc65f260c13e22d378d612e3e27c28f4e8f75501 Active
## 136 0xdd2377458a923a0b72ceab062af57e8e8aba5c5c Active
## 137 0xdd3dde90dd96ff40eb2313d3e9aeb0ebc05bc52d Active
## 138 0xe11f79cdd190ecd38722ead886709b2282e9a66c Active
## 139 0xe137ef93b935ef1eda5ef9f4c79344765fb112e8 Active
## 140 0xe635d3c68fb36889e5a90b6ad7eb5b7851560370 Active
## 141 0xf006c4e5dcdf0c1a619f61f42cd6a43e82e5ee7c Active
## 142 0xf04925a42cae40df543de2df6dca632a819d80cb Active
## 143 0xf0be01e154087e0054f7047b64f6ef13f8334a04 Active
## 144 0xf30510bf0b0bea6d3188b1e8f9431127586adb7c Active
## 145 0xf41714034d8c2921de33ae6c2a71d73925081f87 Active
## 146 0xf549494c5fc94b747a896a81a87cf8d94cde863d Active
## 147 0xf5e7b13342868f945529ab9d2bccd06c2898a346 Active
## 148 0xf63a0f6a7def277c93a5771774ef63024d6071f8 Active
## 149 0xfaec09d95a8e64d94e7db534a9a0ba0348a1cfe2 Active
## 150 0xfbe06b9fcb5f661a0fcd6a07c5a6b1eefe327e81 Active
## 151 0xfd08bc27491b1e3f4919ceadfccd8a3472303dc3 Active
## 152 0xfdbc0980ab2b303f5a086655300a7e733e056933 Active
## 153 0xfe04b7f52540dab12d1befc562115c67c9c4c9c7 Active
## subgraphDeployment.ipfsHash
## 1 QmcykahJW7hPPpvZKXcgTfNeVTVdHfm5wDEoojSzuYmpJA
## 2 QmRuPq9vmTwDPEQvUaoMGvB3zEPc5S3J1wuJPoW5WMTuVL
## 3 QmYPnsfXt9W6dMqq6PPfhfEZ6bXv8Tti7fqtSh9EpnLfBe
## 4 QmPtGvWk56Bw1S9DjUeSq412w7AC4bDdwThf9AYHgjFNKu
## 5 QmfEttTZtkWdvsmRkn9VrES9EybS4jiYdMzZZH2LVz2t5Q
## 6 QmTxm59Gj98m24yLiP6nMJpWhxdoJ1Xh3nocvu3LDDeKjd
## 7 QmUSffoxhjXNQjZmfi56EPWtt1dGGcZcGqz98hmQLh8UzG
## 8 QmSEf3a9UBEmJfu3NDUidWJkFGHTgEWiCVWBEJHaTjGiSA
## 9 QmPpm5vp6zSn3g6ozPKq9KsKNbvcfjKjqy82ex5QiA6uQJ
## 10 QmYzVKbGx2pAPLNUbmMhA3KMVMHD3WPqdDDjTm9Fm3sgdw
## 11 Qmf2LYYE8f2doyoQpCvN7Nc9UZV9YSXUYC5koZ6SHWu2wm
## 12 QmY6YjNussTjjaj75jcxXfDUwNiufoBwxYN1Xggr7zTH7R
## 13 QmWaCrvdyepm1Pe6RPkJFT3u8KmaZahAvJEFCt27HRWyK4
## 14 QmcaswVo8QTsnAFG29wBEGfxEyfPBmazTxxW8XvczPTGsR
## 15 QmcMk21Jdeng7SWv8yqhskhKbykqgH12vE64cnNhzSbXJ8
## 16 QmP2vXFMSKp4JJkw7WhRv2UrbFFdidHPkVxdnBrycDrN2P
## 17 QmQUUhJCBR1RLnqXSjSBjjbKMMevnRMNqnseMDsRAcjwPL
## 18 QmZtTFVqw46STD3uwHLD1gQWwn11NS7NaSw1tzZfKCgewG
## 19 QmaBwqJfMSksDTGNSGg8HSPwHdsFEq6HMSCAcCBJMrN3Pw
## 20 QmdsSNTCMe1zYjWWb78W7JjeMZbn7cHKBHm3iNxRwqaLwT
## 21 QmYwkNTGCHFu2Q1Kmmd5TrcqvruLMjKjzsGVJaikK6dpXj
## 22 QmXK4zttkPkpuMYjpyp8YdQYmb15CPN4WETqLStXW9XiGD
## 23 QmZgJpzfqCveZ1D5Fs8ZFH3C7CUHptbJr2VhnXJPrcKmti
## 24 QmPGK7WXbbaifnxMj1SLZQ6Nzoop6UqeZ9zVL6qwfkXEho
## 25 QmZbhHCjwzqmeWEroA4DnHjnDJjbVh6rkpY7ACadMvrfqH
## 26 QmNxTYUMZMzJrg2Q73i9WceoBXHV7AW5RbdB1jQiNKnNRj
## 27 QmSThLAKsPhzGffqKwcZnteqA2CR6HbQCtHygVojErwiEN
## 28 QmddvgpoNsfxXyQ972KhpHMDAyPjwZWcHTd6pXZ9CsuqsZ
## 29 QmWqnxMsbZTggnmuTouA68bFeKKCwkC6RKpvPXbggCaS3x
## 30 QmQTx44cVb1YVACtaMbgufyyd791C7TrwK8RykNezYgxiw
## 31 QmXmSGEiVvQNkcUBbW6CbyYAYJB5Pd6ecd78oPuPvjnkx1
## 32 QmZBvbb1ud2DMDBSBD3NV3SMWBoNcgi1Z4v62R4X6vBEMh
## 33 QmTHjj9Tdy5zCtJn3KvGQam8RaQ3ZncMAgDZL8y9BFxBqY
## 34 QmNWuoJm4vdpCqi8uZ3JusWoGbRvDn1HB2RhaLqDyq5Qzp
## 35 QmWgi6hNfwCGiTAhH7gTSMSfvvYUPRbBQSjRmvuviRGGwy
## 36 QmPbAPGuq8PT5qMW2dtKCZoxW3Rpa2kFfr3qddCFMsorcc
## 37 QmVQtVpxv9P3Lf1TtLDufqgnkw5RHCMubgsGTgq2orbCfU
## 38 QmdJx5rhUBkjfNWvZzD2w9xbUQYVdgcexL8KkoNPUgswsK
## 39 QmaAFmLb4HBgazuxNHY8HziUDAD66zfRALx1kqfD24Ueb8
## 40 QmdRe7FszwQAknHdYZoETWfPZwvZZA9QYgVcaiMLpKHyDT
## 41 QmdwWYDXFWeNcyBwmGP3JUudjsKt4SXqjtFctPdaMtuv4m
## 42 QmZ7jF5cK2gtdanXRvL7bxdWvnP9B38ikWeEXQxoivjsdo
## 43 QmRKm6THtyr3Ej73LF9jVe4GdSiq1sMQg4XVip6axvLdHm
## 44 Qma91PBS9v2N8xFCuTgu18oU1nuqfqgrxTJXWEQ6wWNUMp
## 45 QmYk6JtWHXCaRbLkLxFJ5A7oPkKAJ3k61efUxDk5SgTur7
## 46 QmXhqwzJZDgnAAVsEYYhg7H46wZQqCMnvXhKionqdmBxGk
## 47 QmeHZcGmj7wrJMHRrPVDGiVaprs7t21n1jjeUHhPUeMRcA
## 48 QmSXRGMMU4XwbYyhnzM7pjVS3dLkEUn8UuFN7hs9q6U7qd
## 49 QmNNRntvbtiCKNfbak7XqZCgK2TQVR1rd4PohM2sDnPin6
## 50 QmRQQYmGyFKhS9VUeuN3airsAQivjqm1QNuHWqe39az4kX
## 51 QmSdWHc2EMeYdYpkMwpogtNECesGYhaaNFaPzKn4Wrcamv
## 52 QmVi7VY4RVYr3Ukf2RaWai9tQJ945hCRxFNFfvCNDjwaHY
## 53 QmZVxhK2AbqkdiRm9manVAZ3hfaswfiRxTtcePotJTn8Mf
## 54 QmVFGoBvTa2YWE5QCDXFg1EeaYHKvds9voYQGd2PWRPdrZ
## 55 QmPorvah322jyTLZdwAGcXyr3FXhLr4oZUYjEkwtfuBitL
## 56 QmPkfN5871AkgEAaKhbh48oJ78C5E4hZbyBBAvKTa8Epzf
## 57 Qmduy6o7VkWqJRgBqHUVVuPnowT6kAqWJmQWo5WecgKsV6
## 58 Qmb7rYJk1BmDDkfYQSobCG9HSLvbEiKrRh5gqv3xXCkzNq
## 59 QmTK9rCAwaFewM9fS4jAGzdK35wowJKRNK8dWuPhtjtves
## 60 QmdWjLiYkTUijiRvSYmfMzZXq7wYhSVJYtUADgQEQrYVaa
## 61 QmNRhNkLoaqHbVdbG8aVat7NvVWFq1wGpmEgicUCAiLonD
## 62 QmU8G3bY1v3r5RkLjcpJQbBnZauj4pL6KdGQMEhXj3N8qA
## 63 QmcumC3ZhLgkEyh548qA8tUNwSCe2pRG4fjYH5GsjRQMMs
## 64 QmX2XKyk1Rk12PSkeC2vBUn7TM1kPESRiipc8yWjezM2Mk
## 65 QmeJMbnUgBuEkaA85vvM7Su71XR9dW2uhCdxCLqYoLd4Za
## 66 QmTyVpF3phzakM765zxsH9wGBtEAqo5x9SkM6CqUF59DMQ
## 67 QmcPi2qpDKaQuZdmkakgLq7pTCdd6emPJtW5TgNz1o9RNe
## 68 Qmdp89ALKgfGVTjvwpD3hDtgTvGpfM9VuZPUtc6MiCztqh
## 69 QmRT7M2wHbkFdC9N9qje9UZ7WMHQ3MhwMvSHfWFYg9vGBr
## 70 Qmaxcs5FKtvm2hgKRFPSfoQf9w4r5squ3XixKG6YwG1R14
## 71 QmVpFJ5tfc9YPDS8TaRj2ocsq9CGKYhRem2HMbCRWMBLRE
## 72 QmPpNXZS6SfP7LYFgV1aHRwqSGrZRHB3piFMtz6qKsVH7o
## 73 QmWXhLkz6fRJwLyFmgBKVu2NyMD6MqtGhcrt8bNcm1xpuU
## 74 QmUCbuvzqWwa9GcBucSdejFKZqM6dYxK7iNPj1k52cKt59
## 75 QmXiRbvCs9aCt7PzkFE26SE4usDLJLeKhDWNpZfzV7qHGW
## 76 QmVUcp8WqE47payYxMJULkqhTbn2H9yhUSCXnUi5zH2Co5
## 77 QmSK5hvEsM5mw6658SE1BWm4JdAWV42PZTVFh5H7xWAEiz
## 78 Qmd7Tub28sBv3UF4FZH46LAXyBQSq3TJUCY7jF3KVdSTpW
## 79 QmXJMMj2hUoBmcXtq4Z7oSh8K6msyE2pk4hTSvpHxJ2TdZ
## 80 Qme4pZsov2kSRxYR74SvYCQuiWi8MqybCfBWbEXeyMYEjv
## 81 QmVZPQKJwQuEkHAHAc3DMGxgAnnHi86F83iTtGoBaxcuWs
## 82 QmSzo43g1vnQCRE3paJXkWwawujVkEs3LqDpB4SoXmbUSP
## 83 QmeYDDGexx97zQu5udspRQpYHpV2Er3718cz4UyGDVnVtp
## 84 QmUYUauhzyakRidG1FEZdC2PuR3vnt4VQotmPXaNKqtD8r
## 85 QmZaHRYsV6rh6iJKyf8vsVKn8977FTAh6iAXXqYbs9ETBN
## 86 QmQ5V1UsyNFPjHBCw4dieu46tNrWi9AVtGbiym2EXUQmVc
## 87 QmYWvmm6rxvAk8E3cA6iXPhC6ETBLJFuEw8maYJ7YV9ATx
## 88 QmZd7ew6pgSn3BA1zPKJ5GC3iRRtYezMNcADpcHnpPAdju
## 89 QmPBLbvqWxYxEMY7JSQU2SjR2cYZpQv7XErQaaMMpCSDq5
## 90 QmTiai398HETp6qKhMph6t8bZihgTTaRG3roKEYDG5CCN7
## 91 Qmaj3MHPQ5AecbPuzUyLo9rFvuQwcAYpkXrf3dTUPV8rRu
## 92 QmVxRKd6bbcbUzbNncEwTr8MxEZcnAb3NqV9YN1aBw6tgS
## 93 QmarbBQvPpbfG1juCocy46bKfVXpTCPnsqPZ39hZ8m8jx3
## 94 Qmb5uEy2BRXTzKo5xNyxcQrPBE7vPztcS9eoZmdpQksCto
## 95 QmcdvmAXqHh4cy37ePuETRcFjWv5tSUF1A1QqJf6Nx147t
## 96 QmeSiH8GW213XNQFY31rRC4XhLZv2D6y2Sr14tF5pqAKSb
## 97 QmTLSeRxpzC9qheT67f28LYCsNDd6Coje2S1VR8NSdjJhU
## 98 Qme5nGiCCDJcDtA5xoJ4iPAtjQgBfLekqRvxXesKCiH8XX
## 99 QmNbPLNKU4GLrZbi6o4Kw7Z42GC3Wd7J21aXqie1Tj3Avp
## 100 QmbmFMeTQQu41NeAYRKnrzbp7ABHG2QfGsxB1RxKHCfhoB
## 101 QmXkEwZRMagTAtZt1mf6vPRu2kV4JUyjoKHriayJ6YbJfv
## 102 QmUv1eeYZnvodEv92JmULdHgoZGacm4391zki6dxPz2vk9
## 103 QmTvVAGTfCUcYXEAzgB76bpM2R27tuFBopjZnUFQmTxgbm
## 104 QmXkQR47WZeBQq1XhMujqR5ou642PDSRnf26UHtQaoNbbP
## 105 QmRbn71wTNK3PmEb62wUK4G1XmKN14ZbHeTgi5JubL7evA
## 106 Qmdv8zRyxPC7cmi5fpTdcViptimbCwaHVdb71sXPdWzUhL
## 107 QmR1jfvovkrsMGd4YVNweJtVmi2DPzgnTfnVsFMjUnNRkB
## 108 QmUaEvatzK4DokiCFr8JyJTj64CKX74pV7LJgthqvUGYND
## 109 QmWoG43UWCqZpM3ZCvdvjAfeNuYxs3kEeME9aCytkSZAGE
## 110 QmSfzHGKNGRuXMUvqMo3ksoZaB5Go9FpoVHtBToBGyYgf4
## 111 QmXpQxU2u8CeswB7t43M6bEnqCa13b6qHD3x5t9qY2BBaQ
## 112 QmQtNd36amtQ8h8GF5rwkLLWyyBGwqad3j3WgZAMuLvDMd
## 113 QmVHVUTkiTEdF7SijmwvjaGYcPYgwwBBnPd6f177bqFuhd
## 114 QmUSU8LmgDXx9xS8N7wWfjepjGMUqAkfMoHCD6N82LXqFB
## 115 QmTP1TLUgMFYSwGUArxQypa2R4QmEWyoDKfjFcu4mUavac
## 116 QmdR4xn8pvAgHNfb4i16RGeurWPRaphCQWnHkGAv2j3yoM
## 117 QmSnb9bKAQTq2jt26LF2DHPP67UKh6FcSXGAXzo1cVNFAD
## 118 QmWFAFmcKXaksfC1TpDDr8dJHt6gjJcEWKLowEyKnKoxoT
## 119 QmWVPZbwTwbdWtFsyqFyaweXA8T3wHXYWQcBQ1r6FMPEkz
## 120 QmcK5HmdqJjhJh18g8cTog2FYP7497T2nz25ESaWdyXk1Z
## 121 Qmf7y7jWbNnaqgePvpvSfMbJPrmbRb2xUtXBUeTd9XHVkF
## 122 QmbjYuCtfduXuckjswRHf9qdT1H7J6HNSKtVSijYizXsBh
## 123 QmVXQ6gcgLbrJpDdUMmFSvqkFebYbhCsPgWho1qcNDMhNe
## 124 QmVGzXHaNyCCJd7tjzGRCJZdWwCW5nCxqub6iHrFxmaaS8
## 125 QmSmcEG9MemxKGrj4ASDJ3JccRtZDbxTLvXgCu7WBYQeAQ
## 126 QmXq9iyPmbWFfSZ5rJQGT1L8RmgKLGQJXxHknpLsJ1QUXb
## 127 QmTYD6jJ4eY1dsBdnsAa8nauSbyGCwfcv7y6XzU9SfWRcy
## 128 QmdwwtZact8w2pE7bRpvptS91cd95kWGmxZyj41yi2noZi
## 129 QmdRFSobiBMoKKyNZnwahtn8uzPFxat86qg1Mu7KobJcSb
## 130 QmUhiH6Z5xo6o3GNzsSvqpGKLmCt6w5WzKQ1yHk6C8AA8S
## 131 QmP6bTNozTjdcv9nXvRRzoCV1f3bMh4cuWBDfafARHrQqC
## 132 QmNVHQWAUsrjq83SQCD7R8M4HAUyVvsrPcwHisPTfGrw1Z
## 133 QmP1uNJnsz2v4ynvoyRKSaoJFgVtotQyyttdQDhHtGTmwr
## 134 QmUuXLf2WA7AaThyrv9rMcKTgqwjgoSA3wujjYCfBrhXQc
## 135 QmfLdMHaFQzpYV5Yzqc8UxQcHJ8xjer5J8fkYMkzu9hakM
## 136 QmWJiduWv7RpLckjMEsXCKffwAcdAsM8gfnTfV642CwfMr
## 137 QmVxMhEzFyPHoGzK7E4HQLVv9E8HzPB8hSpqVL9evtqh2K
## 138 QmcQSBBPpJgDcYrKyGy6oGP9BN7FcczRv32t1cfKbtWuRU
## 139 QmV5QTCUK8Zs6k6pjz5dqAvt2ZNvwKTqDWNyJmqFjsnYyV
## 140 QmbS4ZMCW4QFEwUXMKs1xYZ4RZBNQCLccd5qoVU7erQtTM
## 141 QmTL9gppqx1peUXStyro9UNN8eHRUR9rwBXjRJwhUrkHTR
## 142 Qmb27RY3RqP98UMKbTgScf6F7hhokfMuS9fV7VAtPiZHwF
## 143 QmQTGTovKTt3pni5iRyeWKYkUM2sttEahfDd5yhwqqiBkW
## 144 QmP1yBXic8wBA9u3vdHHL9smk7sE7gcox48L2QoTGL35Cs
## 145 QmYzXQTUFhqwnDFxS1ya7xjMSHZmvu7VdM8xRtHXmTrNs9
## 146 QmdKXcBUHR3UyURqVRQHu1oV6VUkBrhi2vNvMx3bNDnUCc
## 147 QmR3U5haiQg5ymFW9okrkbNBBiRzYJR8kB5Qh9AhFQK5Z5
## 148 QmY7fYywXjPvedrvy6KvpjZGq5zmK6qA3TzRzcxH2XHSP3
## 149 QmeHE5D625KJ2btdn7jx9b9EtLtH5kiTjp75y6Qtd5XUo5
## 150 QmcwB9YSdLPEZY952LwJcGCkbCuxXd1uT8xTMdwtw2vsUw
## 151 QmTCHDfwDRJspwLKboHDyTzLYwhxvsSSpi6grB5G9ZRmtS
## 152 QmabixWKSqeUms5NU5RNgAMVRrRnX9n9bt45hAftggUs7q
## 153 QmazyoeJLSfTPhWa2q9LkfJAm2TGTxWomfSs2ivSux3vVbNow we can extract the data we care about from json_data$data$allocations into a dataframe:
# get list of current allocations
current_allocations = as.data.frame(json_data$data$allocations)## # A tibble: 153 × 5
## allocatedTokens createdAtEpoch id status subgraphDeployment.i…¹
## <chr> <int> <chr> <chr> <chr>
## 1 7400000000000000000000 868 0x0475e… Active QmcykahJW7hPPpvZKXcgT…
## 2 10000000000000000000000 868 0x05631… Active QmRuPq9vmTwDPEQvUaoMG…
## 3 23500000000000000000000 868 0x08d26… Active QmYPnsfXt9W6dMqq6PPfh…
## 4 9900000000000000000000 868 0x0ac03… Active QmPtGvWk56Bw1S9DjUeSq…
## 5 30600000000000000000000 868 0x0c787… Active QmfEttTZtkWdvsmRkn9Vr…
## 6 9800000000000000000000 868 0x0d41d… Active QmTxm59Gj98m24yLiP6nM…
## 7 9500000000000000000000 868 0x0f962… Active QmUSffoxhjXNQjZmfi56E…
## 8 7000000000000000000000 868 0x103a4… Active QmSEf3a9UBEmJfu3NDUid…
## 9 7000000000000000000000 868 0x10868… Active QmPpm5vp6zSn3g6ozPKq9…
## 10 28400000000000000000000 868 0x117e3… Active QmYzVKbGx2pAPLNUbmMhA…
## # ℹ 143 more rows
## # ℹ abbreviated name: ¹subgraphDeployment.ipfsHashWe still have a nested column in subgraphDeployment. Next let’s extract the ipfsHash and unnest this column to get a cleaned dataset:
# add ipfs hash
current_allocations$deployment = json_data$data$allocations$subgraphDeployment.ipfsHash
# remove old nested column
current_allocations %<>% select(-subgraphDeployment.ipfsHash) ## # A tibble: 153 × 5
## allocatedTokens createdAtEpoch id status deployment
## <chr> <int> <chr> <chr> <chr>
## 1 7400000000000000000000 868 0x0475e99243a8c0985… Active QmcykahJW…
## 2 10000000000000000000000 868 0x05631019ff11b6229… Active QmRuPq9vm…
## 3 23500000000000000000000 868 0x08d2649ed14120c62… Active QmYPnsfXt…
## 4 9900000000000000000000 868 0x0ac03ff73c93a62e9… Active QmPtGvWk5…
## 5 30600000000000000000000 868 0x0c787cc6dd5ac7d62… Active QmfEttTZt…
## 6 9800000000000000000000 868 0x0d41de09a1648e834… Active QmTxm59Gj…
## 7 9500000000000000000000 868 0x0f96203f00d920b24… Active QmUSffoxh…
## 8 7000000000000000000000 868 0x103a4926bce0445b9… Active QmSEf3a9U…
## 9 7000000000000000000000 868 0x10868386075176fb2… Active QmPpm5vp6…
## 10 28400000000000000000000 868 0x117e356bf7d9cd399… Active QmYzVKbGx…
## # ℹ 143 more rowsThe last thing we want to do is adjust the allocatedTokens to show the value in GRT instead of the full decimals value. We can do this by dividing the value by 10^18:
current_allocations$allocatedTokens = as.numeric(current_allocations$allocatedTokens)/10^18## # A tibble: 153 × 5
## allocatedTokens createdAtEpoch id status deployment
## <dbl> <int> <chr> <chr> <chr>
## 1 7400 868 0x0475e99243a8c09856ff943fa… Active QmcykahJW…
## 2 10000 868 0x05631019ff11b622966932766… Active QmRuPq9vm…
## 3 23500 868 0x08d2649ed14120c6259c1e2b8… Active QmYPnsfXt…
## 4 9900 868 0x0ac03ff73c93a62e9d60b772a… Active QmPtGvWk5…
## 5 30600 868 0x0c787cc6dd5ac7d62ecf786f3… Active QmfEttTZt…
## 6 9800 868 0x0d41de09a1648e8348b37289f… Active QmTxm59Gj…
## 7 9500 868 0x0f96203f00d920b244ecb4174… Active QmUSffoxh…
## 8 7000 868 0x103a4926bce0445b9b783dd18… Active QmSEf3a9U…
## 9 7000 868 0x10868386075176fb228832928… Active QmPpm5vp6…
## 10 28400 868 0x117e356bf7d9cd399f9aa5b7e… Active QmYzVKbGx…
## # ℹ 143 more rows3.2 Pull Current Epoch
We can’t close any allocations that we have opened during the same epoch. We take the same process as the query to pull active allocations above, but this time we are just getting one number for the current epoch on The Graph Network:
# Don't close allocations that have been opened in the same epoch
query = '{
graphNetworks {
currentEpoch
}
}'
# 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 current epoch
current_epoch = json_data$data$graphNetworks$currentEpoch[1]
# view results
current_epoch## [1] 8793.3 Exclude High Volume Subgraphs
When we are already serving a high number of queries on a particular subgraph, we want to avoid closing the allocation if it’s not one that’s been open that long in order to avoid disrupting queries being served.
## [1] "prometheus container IP: 172.18.0.13"## [1] "Processed prometheus data:"
## # A tibble: 161 × 2
## deployment mean_value
## <chr> <dbl>
## 1 QmYWvmm6rxvAk8E3cA6iXPhC6ETBLJFuEw8maYJ7YV9ATx 0.964
## 2 QmUhiH6Z5xo6o3GNzsSvqpGKLmCt6w5WzKQ1yHk6C8AA8S 0.491
## 3 QmUv1eeYZnvodEv92JmULdHgoZGacm4391zki6dxPz2vk9 0.473
## 4 QmWJiduWv7RpLckjMEsXCKffwAcdAsM8gfnTfV642CwfMr 0.2
## 5 QmTiai398HETp6qKhMph6t8bZihgTTaRG3roKEYDG5CCN7 0.164
## 6 QmWXhLkz6fRJwLyFmgBKVu2NyMD6MqtGhcrt8bNcm1xpuU 0.164
## 7 QmcdvmAXqHh4cy37ePuETRcFjWv5tSUF1A1QqJf6Nx147t 0.127
## 8 QmNxTYUMZMzJrg2Q73i9WceoBXHV7AW5RbdB1jQiNKnNRj 0.0909
## 9 QmVxRKd6bbcbUzbNncEwTr8MxEZcnAb3NqV9YN1aBw6tgS 0.0727
## 10 QmfEttTZtkWdvsmRkn9VrES9EybS4jiYdMzZZH2LVz2t5Q 0.0545
## # ℹ 151 more rowsThe data below has been pulled from Prometheus for the indexer. For simplicity this data pull was hidden, reach out to me for more information. This step isn’t necessary, just something in place to not hurt the indexer’s ability to serve queries while also frequently unallocating.
In the data below, mean_value represents the average number of queries served on a subgraph deployment by the indexer over the previous 2 hour period:
## # A tibble: 161 × 2
## deployment mean_value
## <chr> <dbl>
## 1 QmYWvmm6rxvAk8E3cA6iXPhC6ETBLJFuEw8maYJ7YV9ATx 0.964
## 2 QmUhiH6Z5xo6o3GNzsSvqpGKLmCt6w5WzKQ1yHk6C8AA8S 0.491
## 3 QmUv1eeYZnvodEv92JmULdHgoZGacm4391zki6dxPz2vk9 0.473
## 4 QmWJiduWv7RpLckjMEsXCKffwAcdAsM8gfnTfV642CwfMr 0.2
## 5 QmTiai398HETp6qKhMph6t8bZihgTTaRG3roKEYDG5CCN7 0.164
## 6 QmWXhLkz6fRJwLyFmgBKVu2NyMD6MqtGhcrt8bNcm1xpuU 0.164
## 7 QmcdvmAXqHh4cy37ePuETRcFjWv5tSUF1A1QqJf6Nx147t 0.127
## 8 QmNxTYUMZMzJrg2Q73i9WceoBXHV7AW5RbdB1jQiNKnNRj 0.0909
## 9 QmVxRKd6bbcbUzbNncEwTr8MxEZcnAb3NqV9YN1aBw6tgS 0.0727
## 10 QmfEttTZtkWdvsmRkn9VrES9EybS4jiYdMzZZH2LVz2t5Q 0.0545
## # ℹ 151 more rowsNow we can join the new data above prometheus_data_clean to our main dataset current_allocations to bring in the new field for queries served on the subgraph over the past 2 hours:
current_allocations = current_allocations %>%
left_join(prometheus_data_clean) ## # A tibble: 153 × 6
## allocatedTokens createdAtEpoch id status deployment mean_value
## <dbl> <int> <chr> <chr> <chr> <dbl>
## 1 7400 868 0x0475e99243a8c0… Active QmcykahJW… NA
## 2 10000 868 0x05631019ff11b6… Active QmRuPq9vm… 0.0182
## 3 23500 868 0x08d2649ed14120… Active QmYPnsfXt… 0
## 4 9900 868 0x0ac03ff73c93a6… Active QmPtGvWk5… 0
## 5 30600 868 0x0c787cc6dd5ac7… Active QmfEttTZt… 0.0545
## 6 9800 868 0x0d41de09a1648e… Active QmTxm59Gj… 0
## 7 9500 868 0x0f96203f00d920… Active QmUSffoxh… NA
## 8 7000 868 0x103a4926bce044… Active QmSEf3a9U… 0.0364
## 9 7000 868 0x10868386075176… Active QmPpm5vp6… 0
## 10 28400 868 0x117e356bf7d9cd… Active QmYzVKbGx… NA
## # ℹ 143 more rowsLet’s also make sure to replace any NA or infinite values with 0:
current_allocations %<>%
mutate(mean_value = case_when(is.na(mean_value) == TRUE ~ 0,
is.finite(mean_value) == FALSE ~ 0,
TRUE ~ mean_value))## # A tibble: 153 × 6
## allocatedTokens createdAtEpoch id status deployment mean_value
## <dbl> <int> <chr> <chr> <chr> <dbl>
## 1 7400 868 0x0475e99243a8c0… Active QmcykahJW… 0
## 2 10000 868 0x05631019ff11b6… Active QmRuPq9vm… 0.0182
## 3 23500 868 0x08d2649ed14120… Active QmYPnsfXt… 0
## 4 9900 868 0x0ac03ff73c93a6… Active QmPtGvWk5… 0
## 5 30600 868 0x0c787cc6dd5ac7… Active QmfEttTZt… 0.0545
## 6 9800 868 0x0d41de09a1648e… Active QmTxm59Gj… 0
## 7 9500 868 0x0f96203f00d920… Active QmUSffoxh… 0
## 8 7000 868 0x103a4926bce044… Active QmSEf3a9U… 0.0364
## 9 7000 868 0x10868386075176… Active QmPpm5vp6… 0
## 10 28400 868 0x117e356bf7d9cd… Active QmYzVKbGx… 0
## # ℹ 143 more rows