thegraph_v1_ethereum

Tables

Curation_Burned_event

Curation signal withdrawal events from The Graph protocol on Ethereum, recording when curators burn their curation shares on subgraph deployments to redeem GRT tokens. Used to analyze curator behavior, signal lifecycle, and subgraph adoption trends.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_curator`	`STRING`	Ethereum address of the curator performing the signal or burn operation in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_subgraphDeploymentID`	`STRING`	Unique identifier for a subgraph deployment in The Graph protocol. 66-character hex string including 0x prefix.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_signal`	`STRING`	Amount of curation signal shares minted or burned in The Graph protocol curation events. Decimal string representing wei-denominated value with 18 decimal places of precision.

Sample Data

address	removed	in_signal	in_tokens	log_index	in_curator	block_number	block_timestamp	transaction_hash	in_subgraphDeploymentID
0x8fe00a685bcb3b2cc296ff6ffeab10aca4ce1538	false	145940034674058645016	21298493720665439607738	152	0xadca0dd4729c8ba3acf3e99f3a9f471ef37b6825	14766644	2022-05-13T09:49:07.000Z	0xb2564629b2c87b4181daff2f817a1107577508ffa3fd662f734545614a50fabc	0x7ef9d81e3d5b10910808f1519135928275f518ee8a85fb01880f446231a0db7a
0x8fe00a685bcb3b2cc296ff6ffeab10aca4ce1538	false	5331526901289445920	4118290256076151112667	463	0xadca0dd4729c8ba3acf3e99f3a9f471ef37b6825	14770223	2022-05-13T23:03:48.000Z	0xdb38e3e064eb0104e09e93278e8f32d20afd9d4f1f64fde282fe21959ce7a367	0x4a008334f8e7ea21be223d15462084f51abcc0e6625f61de806b8456e67e603e
0x8fe00a685bcb3b2cc296ff6ffeab10aca4ce1538	false	179427492204831289048	32194224958914792997547	289	0xadca0dd4729c8ba3acf3e99f3a9f471ef37b6825	14770031	2022-05-13T22:22:56.000Z	0xfacfbb73508f9b18fdf941e15f0ffcc4ae0f01d8ee208c182e2ff8efc23fa08c	0x9f305faeec7f327dc145d078ec2168e284b1bf46a67c15160965226e97f21191

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Curation_Burned_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Curation_Collected_event

Curation fee collection events from The Graph protocol on Ethereum, recording GRT tokens collected from subgraph deployment curation activities. Used for analyzing curator rewards and protocol fee distribution across indexed subgraphs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_subgraphDeploymentID`	`STRING`	Unique identifier for a subgraph deployment in The Graph protocol. 66-character hex string including 0x prefix.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

address	removed	in_tokens	log_index	block_number	block_timestamp	transaction_hash	in_subgraphDeploymentID
0x8fe00a685bcb3b2cc296ff6ffeab10aca4ce1538	false	126745113723564852	302	11541445	2020-12-28T08:54:18.000Z	0x5928999d479f1ed6e4a6bf55af21c0eee01d98cdc5ba9518c05ce2753a32e50c	0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500
0x8fe00a685bcb3b2cc296ff6ffeab10aca4ce1538	false	127344204753297585	249	11541545	2020-12-28T09:15:24.000Z	0x3f6fca2604bb99ba09a57a70035d40a6fedfa1cc4bb4e20dec0dab8a22b99c57	0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500
0x8fe00a685bcb3b2cc296ff6ffeab10aca4ce1538	false	127576174229832206	176	11541529	2020-12-28T09:13:37.000Z	0xac6a28ba291de8de26b437630201c1cdf2df03efe6e7e136dd1b1fa06198c61f	0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Curation_Collected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Curation_Signalled_event

Curation signal events from The Graph protocol on Ethereum, recording when curators stake GRT tokens on subgraph deployments. Contains curator addresses, signal amounts, token quantities with curation tax, and subgraph deployment identifiers for analyzing curator behavior and subgraph quality signals.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_curator`	`STRING`	Ethereum address of the curator performing the signal or burn operation in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_subgraphDeploymentID`	`STRING`	Unique identifier for a subgraph deployment in The Graph protocol. 66-character hex string including 0x prefix.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_signal`	`STRING`	Amount of curation signal shares minted or burned in The Graph protocol curation events. Decimal string representing wei-denominated value with 18 decimal places of precision.
`in_curationTax`	`STRING`	Amount of GRT tokens collected as curation tax on this signaling transaction, denominated in wei (10^-18 GRT). The Graph protocol charges a percentage of signaled tokens as a tax, typically 2.5% of the deposited amount.

Sample Data

address	removed	in_signal	in_tokens	log_index	in_curator	block_number	in_curationTax	block_timestamp	transaction_hash	in_subgraphDeploymentID
0x8fe00a685bcb3b2cc296ff6ffeab10aca4ce1538	false	113741600623408671987	13067830012500000000000	220	0xadca0dd4729c8ba3acf3e99f3a9f471ef37b6825	17084245	130678300125000000000	2023-04-20T00:40:11.000Z	0x124e0366fc535c70c34cf65492118d326e0a53af5b023d37b882758fe30bdcf7	0xcbeff8faca06909f08062de5e6be99bb0fcabc3dff101c2411d02efee7493856
0x8fe00a685bcb3b2cc296ff6ffeab10aca4ce1538	false	34013243305420779335	6003018478209477739478	67	0xadca0dd4729c8ba3acf3e99f3a9f471ef37b6825	17088240	60030184782094777394	2023-04-20T14:16:23.000Z	0xbbd323dc6ccd7f851b040508ecf783077b2589331263b8e9c0400a9279f81561	0x74a5b87c996567028cf99ddf71af2ba687fb9581b1cb8572a397dcbb6963b815
0x8fe00a685bcb3b2cc296ff6ffeab10aca4ce1538	false	70356236397351443318	5000000000000000000000	84	0xadca0dd4729c8ba3acf3e99f3a9f471ef37b6825	17087366	50000000000000000000	2023-04-20T11:19:11.000Z	0xa1fb1ed192a427ac682025f335445e7745da4b9b92a95a460fbd1462e6cb41ac	0x74a5b87c996567028cf99ddf71af2ba687fb9581b1cb8572a397dcbb6963b815

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Curation_Signalled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DisputeManager_DisputeAccepted_event

Accepted dispute events from The Graph protocol on Ethereum, recording when fishermen successfully challenge indexer behavior and receive token rewards. Used for analyzing dispute resolution outcomes and slashing penalties in The Graph’s decentralized indexing network.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_disputeID`	`STRING`	Unique identifier for a dispute in The Graph protocol’s dispute resolution system. 66-character hex string including 0x prefix.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_fisherman`	`STRING`	Address of the fisherman who initiated the dispute in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

address	removed	in_tokens	log_index	in_indexer	block_number	in_disputeID	in_fisherman	block_timestamp	transaction_hash
0x97307b963662cca2f7ed50e38dcc555dffc4fb0b	false	72501860149723998288187	357	0x63c560997b8338f2b033f3ffdcc0f7c680feec45	16342366	0x08de8c88793b5eda85ac752ca7d1482ef9bf7df8425a2601285e053ba38ff690	0xc56961836857210e256d71c91a62e90865075380	2023-01-05T18:25:47.000Z	0x555a9ed6d7358fbb5786670af8153fa09cf62718708bae006f18282ba87dccc8
0x97307b963662cca2f7ed50e38dcc555dffc4fb0b	false	24332897034375926042922	55	0x76e84025978a0c16fc7ba483718b667388f2973c	13058230	0xf6dd49f420750111fe0ec51b4e5c4f175ce2a65a864d6f714e7c2ef66829031a	0xe3671ff90401c21e2bb55b2dfab4506cede113e5	2021-08-19T21:39:29.000Z	0x1596590788e3b6464685e27ab099daa36f8bf9236153ee6ea8cde379bd2da3cf
0x97307b963662cca2f7ed50e38dcc555dffc4fb0b	false	24700407214744539531202	50	0x76e84025978a0c16fc7ba483718b667388f2973c	13058230	0xa6e48245e348d1533e31cba5bac4da3125104c927c53b11fa99ab95a8ba15a27	0xe3671ff90401c21e2bb55b2dfab4506cede113e5	2021-08-19T21:39:29.000Z	0x1596590788e3b6464685e27ab099daa36f8bf9236153ee6ea8cde379bd2da3cf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.DisputeManager_DisputeAccepted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DisputeManager_DisputeDrawn_event

Records of drawn (tied) dispute resolutions in The Graph protocol’s dispute manager on Ethereum, where challenges between fishermen and indexers result in no clear winner. Used for analyzing governance outcomes and token slashing events in The Graph’s decentralized indexing network.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_disputeID`	`STRING`	Unique identifier for a dispute in The Graph protocol’s dispute resolution system. 66-character hex string including 0x prefix.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_fisherman`	`STRING`	Address of the fisherman who initiated the dispute in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

address	removed	in_tokens	log_index	in_indexer	block_number	in_disputeID	in_fisherman	block_timestamp	transaction_hash
0x97307b963662cca2f7ed50e38dcc555dffc4fb0b	false	10000000000000000000000	284	0x5a8904be09625965d9aec4bffd30d853438a053e	12692543	0x08e959b7cf82f4935a5063721d7b7a01a0b33ebf0c8056b4d7ce4d126e7049a3	0x992bb240b1ef27bc95a2e4767d9de6f8bf6d9632	2021-06-23T20:26:07.000Z	0x06e38b76dccdeda22b67cb7f6453d01d94377ad8079fa858ae6f152092e8ee99
0x97307b963662cca2f7ed50e38dcc555dffc4fb0b	false	10000000000000000000000	360	0x453b5e165cf98ff60167ccd3560ebf8d436ca86c	14037202	0xb856a651b6ceec4d41f3903ca84544b32ccc452eedc5a4de2a523984b09cb2aa	0xec022aa5960c97764237f3dde3ed4065dd7ecf2f	2022-01-19T17:05:53.000Z	0xb8f067d9d2da5c7e1eadf8c0ca3b34cce0eac082c2bda1b4be2545ccbed4b6aa
0x97307b963662cca2f7ed50e38dcc555dffc4fb0b	false	10000000000000000000000	101	0x453b5e165cf98ff60167ccd3560ebf8d436ca86c	13999071	0xacb9026d7aba202bdf26776d7b21bbc8215282f39d10a06b2dc20e6a36d2207a	0xec022aa5960c97764237f3dde3ed4065dd7ecf2f	2022-01-13T19:39:01.000Z	0x90bed50f59b1080ee7e93e6e876dd24447e849da9194b59097313b99f7e7bb19

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.DisputeManager_DisputeDrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DisputeManager_DisputeRejected_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_disputeID`	`STRING`	Unique identifier for a dispute in The Graph protocol’s dispute resolution system. 66-character hex string including 0x prefix.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_fisherman`	`STRING`	Address of the fisherman who initiated the dispute in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.DisputeManager_DisputeRejected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DisputeManager_IndexingDisputeCreated_event

Indexing dispute creation events from The Graph protocol’s DisputeManager contract on Ethereum, where fishermen challenge indexers with staked tokens. Used to analyze protocol governance, dispute patterns, and indexer slashing activity across subgraph allocations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_disputeID`	`STRING`	Unique identifier for a dispute in The Graph protocol’s dispute resolution system. 66-character hex string including 0x prefix.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_fisherman`	`STRING`	Address of the fisherman who initiated the dispute in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_allocationID`	`STRING`	Unique identifier for a token allocation in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_tokens	log_index	in_indexer	block_number	in_disputeID	in_fisherman	block_timestamp	in_allocationID	transaction_hash
0x97307b963662cca2f7ed50e38dcc555dffc4fb0b	false	10000000000000000000000	168	0x62eecb89c407a731e06e2b2c25563e2a8f96dfaa	16633205	0x2b07b4fb43084b5b519adb0926327a89e077314e39aa92a683cb090e8f33940b	0x2c452073377ec65b4b8c7dfa995624d60028cd53	2023-02-15T09:19:23.000Z	0x7ba06d64de3606b6a3f59c5105c243f203e16f2c	0x67aca50d358c26015634b14ee066c1838fa24a299a27dd5252c34d36e990f070
0x97307b963662cca2f7ed50e38dcc555dffc4fb0b	false	10000000000000000000000	10	0x5a8904be09625965d9aec4bffd30d853438a053e	12377068	0x08e959b7cf82f4935a5063721d7b7a01a0b33ebf0c8056b4d7ce4d126e7049a3	0x992bb240b1ef27bc95a2e4767d9de6f8bf6d9632	2021-05-05T22:49:53.000Z	0x3a8dace06b3db1f870ffa9c2d0f50e4f7945abf6	0xf241ecfb0205696c74eff0d3853d26fb265b0906b98767bc7345dd766bf7d4a2
0x97307b963662cca2f7ed50e38dcc555dffc4fb0b	false	10000000000000000000000	304	0x5a8904be09625965d9aec4bffd30d853438a053e	12377057	0x6f6b765d937dbb774bbfce23309cd41658be4d39dea336c2729374eb3dd9d2b7	0x992bb240b1ef27bc95a2e4767d9de6f8bf6d9632	2021-05-05T22:47:59.000Z	0x3b1361093cb7b4a98c05a6455e2c76fd5099acee	0x3e03910426bece3d4704eae2cacf085c4bd84523e775416caa0c472ab8984e60

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.DisputeManager_IndexingDisputeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

RewardsManager_RewardsAssigned_event

Indexing reward distribution events from The Graph protocol on Ethereum, recording GRT token amounts assigned to indexers per epoch and allocation. Used for analyzing indexer revenue, reward distribution patterns, and protocol incentive economics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_allocationID`	`STRING`	Unique identifier for a token allocation in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_epoch	in_amount	log_index	in_indexer	block_number	block_timestamp	in_allocationID	transaction_hash
0x9ac758ab77733b4150a901ebd659cbf8cb93ed66	false	525	4718999339863229000000	497	0x4167eb613d784c910f5dc0f3f0515d61ec6ec8df	14942163	2022-06-11T03:50:17.000Z	0xa0e102d2137a0b9631d5676e4af161822d9c5543	0xe635a65a5bc27702ddbe8a775a898be000847d3fa3177d17179ac89fa2cb2c89
0x9ac758ab77733b4150a901ebd659cbf8cb93ed66	false	525	7408118728205983900242	95	0x4167eb613d784c910f5dc0f3f0515d61ec6ec8df	14942177	2022-06-11T03:52:17.000Z	0x258661dbd61533808239f4210a2fe8d038661cf6	0x63a5bc32ecb9c4c80a17b3deb20a652160c6381c3d5f543bb328c8431c8503c5
0x9ac758ab77733b4150a901ebd659cbf8cb93ed66	false	525	4769631029769150000000	79	0x4167eb613d784c910f5dc0f3f0515d61ec6ec8df	14942168	2022-06-11T03:50:58.000Z	0xcdb100cae5ca85a3c2c764b523a94fc6ced9113e	0x6623e03c128285ea9c309c71f82aefc22bb9eadc84c6a4ccb3e95eee0c7c3121

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.RewardsManager_RewardsAssigned_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

RewardsManager_RewardsDenied_event

Records of denied indexing rewards from The Graph protocol’s RewardsManager contract on Ethereum. Tracks instances where indexer allocations were rejected for reward distribution in specific epochs, useful for analyzing indexer performance issues and protocol compliance.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_allocationID`	`STRING`	Unique identifier for a token allocation in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.

Sample Data

address	removed	in_epoch	log_index	in_indexer	block_number	block_timestamp	in_allocationID	transaction_hash
0x9ac758ab77733b4150a901ebd659cbf8cb93ed66	false	882	71	0x978cd3207d0cf5a89003d85c2913bc9be120c31f	17370617	2023-05-30T08:38:47.000Z	0x7c1b0d8a95b634d3b39d5bcfe272271ba43a2ffb	0xe65af7696d0279434181c2e27a2c92bf9e91b561213cdb94e60901aa2d297f37
0x9ac758ab77733b4150a901ebd659cbf8cb93ed66	false	882	80	0x5140ff5e7cbc5272c67e604611fdbf6dba7c27a6	17371538	2023-05-30T11:46:59.000Z	0x41262d430fea68bff61e1aa54557d1060f531c91	0x7dda2ecf5971a35978a021700d70fcbabdf8cc14739e605d757676c9ee0c63f9
0x9ac758ab77733b4150a901ebd659cbf8cb93ed66	false	889	88	0x223260f3ca014adc40c98d50d5c4178657d53e26	17422170	2023-06-06T15:03:35.000Z	0x5c40a5db5b9fc816ba79e7565fb08985c56697c0	0xabb19a30b05169dae90b24f871e666a1c6c0dbd294f676d28e4852403929f82d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.RewardsManager_RewardsDenied_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_AllocationClosed_event

Allocation closure events from The Graph protocol on Ethereum, recording when indexers close their stake allocations to subgraphs with proof of indexing (POI) data and token amounts. Used for analyzing indexer staking behavior, reward distribution timing, and subgraph indexing completion across protocol epochs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_subgraphDeploymentID`	`STRING`	Unique identifier for a subgraph deployment in The Graph protocol. 66-character hex string including 0x prefix.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_allocationID`	`STRING`	Unique identifier for a token allocation in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_effectiveAllocation`	`STRING`	Token amount that was effectively staked to this allocation after applying delegation weighting rules in The Graph protocol. Denominated in wei (smallest GRT unit), typically larger than `in_tokens` when delegators are involved.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_poi`	`STRING`	Proof of Indexing (POI) hash submitted by the indexer to cryptographically verify they correctly indexed the subgraph deployment. A zero hash indicates no valid proof was provided for this allocation closure.
`in_isDelegator`	`BOOL`	Flag indicating whether the allocation was closed by a delegator or the indexer themselves. False indicates the indexer directly closed the allocation.

Sample Data

in_poi	address	removed	in_epoch	in_sender	in_tokens	log_index	in_indexer	block_number	in_isDelegator	block_timestamp	in_allocationID	transaction_hash	in_effectiveAllocation	in_subgraphDeploymentID
0x9a5a7144c872dfafe9e0864730d42f1e5cf6ebf5163fcd741e5094b1ce3290ec	0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	594	0x07eb5c56ee6d928fc5faaa89e74422c6c64bf786	118846000000000000000000	94	0x55f3dcdaf0b73f7f0c761a9070d8865f37986e2c	15401044	false	2022-08-24T05:18:59.000Z	0x5f1d5283144a61a26652683a55d6615aef992054	0x697600b435214b761c7b9d2c524f7a61e472621e47d552d752cd9babdf5751af	2971150000000000000000000	0x42a81a83f3bf21ba5c9aab216ed4b0d315c9a7cf6e856765bb439c72cc679272
0x64ed785bfb6bcfcbee50679e163c3559f5801f7cd9d63ca188bebdedb7d6c020	0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	594	0x07eb5c56ee6d928fc5faaa89e74422c6c64bf786	200000000000000000000000	566	0x55f3dcdaf0b73f7f0c761a9070d8865f37986e2c	15401019	false	2022-08-24T05:12:40.000Z	0xb00e7cd052885f0890f707154b85fd8a161371d0	0x7be363155b2bea8fda80ad9e903e77028751f1a5f56b7204780d4d0ed77b3b89	5600000000000000000000000	0x73d760c6ef8fb889b3af6625fff6f22fed34218ee33ff27aa0d75932678d3065
0x288783a337c1bd4f47747ec1e9589532a19748619af5ad39e320733dc8c9641d	0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	594	0x5e34ec7569db1808e76994c646e6600d81099166	450000000000000000000000	61	0xd68acbab921191a55faeb3d64614f54194604f99	15400539	false	2022-08-24T03:27:08.000Z	0x00258edd2f9399b8326cdc5b92beeebcf88e9c3a	0x123376b915906160f7427f3ae6a9e08c22b9b04254ea8c103d1103a0aa1ede1a	2250000000000000000000000	0xae2811a2ee2fc40c34ae842b5d242f7a2979592ab8e5e6057dd93ede38582db6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_AllocationClosed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_AllocationCollected_event

AllocationCollected event logs from The Graph Protocol staking contract on Ethereum, recording when indexers collect query fee rebates and curation fees from closed allocations for specific subgraph deployments. Used for analyzing indexer revenue distribution across epochs and subgraph performance.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_subgraphDeploymentID`	`STRING`	Unique identifier for a subgraph deployment in The Graph protocol. 66-character hex string including 0x prefix.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_allocationID`	`STRING`	Unique identifier for a token allocation in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_curationFees`	`STRING`	Curation fees collected from query fees as part of this indexer allocation closure. Denominated in wei (smallest GRT unit), often zero for allocations with no curator signals.
`in_rebateFees`	`STRING`	Query rebate fees collected by the indexer for this allocation, denominated in GRT (The Graph token) with 18 decimal places. Always present in sample data, typically representing the majority of the total tokens collected compared to curation fees.

Sample Data

address	in_from	removed	in_epoch	in_tokens	log_index	in_indexer	block_number	in_rebateFees	block_timestamp	in_allocationID	in_curationFees	transaction_hash	in_subgraphDeploymentID
0xf55041e37e12cd407ad00ce2910b8269b01263b9	0x4a53cf3b3eda545dc61dee0ca21ea8996c94385f	false	276	1635000000000000	68	0x8f9793029b66325b70fffbfdf2b04d8491682466	13284337	1456785000000000	2021-09-23T21:14:27.000Z	0x121bcabdcddca261ce1c27f5259c1f6bfd543454	161865000000000	0x10ff3d7ae5aef7367cc1994069ed0212a232c2f41b48ef21296388789c9038cc	0xc064c354bc21dd958b1d41b67b8ef161b75d2246b425f68ed4c74964ae705cbd
0xf55041e37e12cd407ad00ce2910b8269b01263b9	0x4a53cf3b3eda545dc61dee0ca21ea8996c94385f	false	276	449000000000000	38	0x8f9793029b66325b70fffbfdf2b04d8491682466	13284355	400059000000000	2021-09-23T21:17:56.000Z	0x6c198dc6bb22a4ab73a22a5f41413c47f7eb3f6d	44451000000000	0xa79841b0e80d901f7e3a8c53777b429a36f6872def550443011875f63e27af3c	0x2aaeb45afa62af1cc8f6d61decd5249429e0aaed67996238adc2bfd396b5f715
0xf55041e37e12cd407ad00ce2910b8269b01263b9	0x4a53cf3b3eda545dc61dee0ca21ea8996c94385f	false	276	1000000000000	45	0x8f9793029b66325b70fffbfdf2b04d8491682466	13284347	891000000000	2021-09-23T21:16:01.000Z	0x38f6ab7956217a024a579c9ea63b684cfdeec4fe	99000000000	0x84274bdf86c854346bf5478f45092d7d2b382a011341e6d476c1819ad7ce3870	0x4a008334f8e7ea21be223d15462084f51abcc0e6625f61de806b8456e67e603e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_AllocationCollected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_AllocationCreated_event

Records of Graph Protocol indexer stake allocations to subgraph deployments on Ethereum, tracking GRT token amounts allocated per epoch. Used to analyze indexer economic activity, subgraph popularity, and network participation patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_subgraphDeploymentID`	`STRING`	Unique identifier for a subgraph deployment in The Graph protocol. 66-character hex string including 0x prefix.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_allocationID`	`STRING`	Unique identifier for a token allocation in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_metadata`	`STRING`	Metadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.

Sample Data

address	removed	in_epoch	in_tokens	log_index	in_indexer	in_metadata	block_number	block_timestamp	in_allocationID	transaction_hash	in_subgraphDeploymentID
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	66	297000000000000000000000	85	0x5ea935a6164629dd9c0f7f1e3b79c2d041108e26	0x0000000000000000000000000000000000000000000000000000000000000000	11885445	2021-02-19T05:34:06.000Z	0xa218d11dab53f81689278db0c7e1e80887243d02	0xfbbeb875b4e221812371ba1e1e841b9e23857661dc8820b2810a7cca4769aab4	0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	66	1645550000000000000000000	76	0x03db85e86779febdd96d96ba43ac48382fb1a88d	0x0000000000000000000000000000000000000000000000000000000000000000	11886724	2021-02-19T10:17:22.000Z	0xd74a4014d6758bd07100083197afdfa64635e576	0x34e9f0893983168ceb8f47b129636cd97bdf851a182b346ad5b4365749e13aac	0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	66	1645550000000000000000000	263	0x03db85e86779febdd96d96ba43ac48382fb1a88d	0x0000000000000000000000000000000000000000000000000000000000000000	11886695	2021-02-19T10:09:48.000Z	0xc3eb0c80a071a6795d84651179a2a03fde7e685b	0xc450ed2faae3b1e3c293299d9a314bc12f9b7ea8e85322d17014c359b23ce3a3	0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_AllocationCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_claim_function

Indexer reward claim transactions from The Graph protocol staking contract on Ethereum, including allocation IDs and restaking preferences. Used for tracking indexer earnings distribution and analyzing reward claiming patterns across Graph Network participants.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__allocationID`	`STRING`	Allocation identifier for The Graph protocol indexer rewards being claimed. Hex-encoded, 0x-prefixed 40-character string representing the specific query allocation from which rewards are withdrawn.
`in__restake`	`BOOL`	Boolean flag indicating whether claimed indexing rewards are automatically restaked back into the Graph Network allocation. When true, rewards compound within the protocol rather than being withdrawn to the claimer’s wallet.

Sample Data

gas	status	gas_used	signature	to_address	in__restake	block_number	from_address	block_timestamp	in__allocationID	transaction_hash
210337	true	131048	0x92fd2daf	0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	12051575	0x2177318680d9e9265470903b6d0ddfcc5edb054c	2021-03-16T19:31:41.000Z	0x72e3b1bac38a428cbc3f2babdd2fc9bfacf6c88a	0xc5ff9f2fdcaf73e025e34176f013a0ea23ca2aab3cdaa58467854359e4b94c32
210304	true	131030	0x92fd2daf	0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	12051563	0xe35c249f495c563e42d5822985158825eb37e61e	2021-03-16T19:28:51.000Z	0x33672e2c37cbf91a2d97004f65643a95413e5626	0x5912411d69809c2ecddc6e4898849b807370fec3298aa3b659b61d757d524bc1
210376	true	131074	0x92fd2daf	0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	12051563	0x37e3e7799ff278a7aca1feaa7cc25d1d27dbca8c	2021-03-16T19:28:51.000Z	0x566d469927f1f10f1ab9f9c9ad8fe6f58836ca80	0xdfe2a8ff3a37ce8f6c91432131ff8301626b1bd20452f186fc5a684672eb71ad

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_claim_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_claimMany_function

Function calls to claim rewards from multiple Graph Protocol indexer allocations simultaneously, with option to restake or withdraw claimed tokens. Used to analyze indexer reward collection patterns and staking strategy behavior.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__allocationID`	`ARRAY<STRING>`	Array of allocation identifiers being claimed in this transaction for The Graph protocol staking rewards. Each ID is a hex-encoded Ethereum address representing a specific indexer allocation from which rewards are being withdrawn.
`in__restake`	`BOOL`	Boolean flag indicating whether claimed rewards should be automatically restaked into the Graph protocol allocation or withdrawn. True means rewards are restaked; false means they are claimed to the user’s address.

Sample Data

gas	status	gas_used	signature	to_address	in__restake	block_number	from_address	block_timestamp	in__allocationID	transaction_hash
228296	true	142808	0x36a4fbd6	0xf55041e37e12cd407ad00ce2910b8269b01263b9	true	16530973	0xf3152ba60655e662d5ba0249304840b95e3a5540	2023-02-01T02:25:47.000Z	[“0x3eeb4f10643bf47f36ccf629a5c2aa176fdd54e1”]	0x7180f346825d032ba473cd79f324654fa3eb926cab0bcd935e28f5725d93b81b
577960	true	371804	0x36a4fbd6	0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	14916038	0x2177318680d9e9265470903b6d0ddfcc5edb054c	2022-06-06T16:59:15.000Z	[“0x0338591f7516c53f86856f65b4eeb1371d20e420”,“0x10c6fa0a35a94142b026a73907b3009e9b0e0d0f”,“0x85e39b4a1ab368d5c900565a60a84e9be293b13b”,“0xc34161b72fdba73cecd0c6048e83be48d1a2736c”,“0xefd335b43f6ab5a5bd2d09f6a0de927dee0b6e33”]	0x364b05a968c89d7047cc1389d223a91908b4c18bc2fdb3ebee74b2a4e353ac88
966418	true	626247	0x36a4fbd6	0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	14915990	0x4feab0138f6eb8e71e29b60ea43b480fad74d474	2022-06-06T16:47:22.000Z	[“0x0d3400161478d54050ed465ff97622a0e051cd1c”,“0x2ec0b2659517aff7f14303b343ff6f473facca57”,“0x92a477f5c165b6db210dcafe89adfe894aa1c67f”,“0xb90b778e9d22a22f527bf20cdbf4d0c703bf0cf5”,“0xbe05036b7456c81c481c8dc7c4392b0013b776c5”,“0xda9d679fe52ce98c511440710296465e677dccb0”,“0xe89b8e99a81aae677866d321c32364f1e4b5efd5”,“0xf09fa203ec643cd5a5b55670b3870ca778b3cc5e”,“0xf13aca285212737f6be555e4ca3771acd22af7c7”]	0xc43d934d2daf99bff695f6f4ef8dfac12edde51a4943064d3f654add51fefc5d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_claimMany_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_DelegationParametersUpdated_event

Events emitted when The Graph protocol indexers update their delegation parameters including query fee cuts, indexing reward cuts, and cooldown periods. Used for tracking indexer configuration changes and analyzing delegation economics on Ethereum mainnet.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_indexingRewardCut`	`STRING`	Indexer’s share of indexing rewards taken as commission from delegators, expressed in parts per million (PPM). Values like ‘600000’ represent 60%, ‘1000000’ represents 100% of rewards retained by the indexer.
`in_queryFeeCut`	`STRING`	Percentage of query fees retained by the indexer before distributing to delegators, expressed in parts per million (e.g., 600000 = 60%). Values typically range from 0 to 1000000, with higher values indicating indexers retain a larger share.
`in_cooldownBlocks`	`STRING`	Number of Ethereum blocks an indexer must wait before delegation parameter changes take effect in The Graph protocol. Typically set to 0 or 1 block based on sample data.

Sample Data

address	removed	log_index	in_indexer	block_number	in_queryFeeCut	block_timestamp	transaction_hash	in_cooldownBlocks	in_indexingRewardCut
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	272	0xf251d93b7ef841ff72bee6bb603d1782092e7db1	12254413	600000	2021-04-17T00:35:34.000Z	0xd29d0869ba4ac23a11359b2fdd57748bb62636fba43ebc442a13fece1aad70c8	0	600000
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	226	0xf4a097ce3a4efbd1748b2ef2076813961e4e6fa7	12258691	218261	2021-04-17T16:31:55.000Z	0xbf8f56f6f2a56a0de8c0570e35b48e848e1d8bcba950904a0011e6db431453e2	1	218261
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	26	0xdeddf0ee2e8eb7f532e85bac0b1498d7d60ccae6	15710242	1000000	2022-10-09T11:28:47.000Z	0x8397a5912d588b6e91ed377dafef3d9d7188b1ddf8fee77526c6180cb9c2ead2	0	1000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_DelegationParametersUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_RebateClaimed_event

Rebate claim events from The Graph protocol staking contract on Ethereum, recording indexer query fee rebates claimed per epoch with allocation IDs and subgraph deployment identifiers. Used for analyzing indexer rewards distribution and delegation fee structures across Graph Network epochs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_subgraphDeploymentID`	`STRING`	Unique identifier for a subgraph deployment in The Graph protocol. 66-character hex string including 0x prefix.
`in_allocationID`	`STRING`	Unique identifier for a token allocation in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_forEpoch`	`STRING`	The Graph protocol epoch number for which this rebate was earned and is being claimed. Typically lags several epochs behind the current epoch (in_epoch) when claims are processed.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_unclaimedAllocationsCount`	`STRING`	Number of allocations that remain unclaimed for the indexer at the time of this rebate claim event. Values range from single digits to hundreds, typically decreasing as indexers claim rebates for their allocations.
`in_delegationFees`	`STRING`	Delegation fees collected by the indexer for this specific allocation, denominated in GRT (Graph Token) wei. Value is zero when no delegation fees were earned for the claimed rebate period.

Sample Data

address	removed	in_epoch	log_index	in_indexer	in_forEpoch	block_number	block_timestamp	in_allocationID	transaction_hash	in_subgraphDeploymentID	in_unclaimedAllocationsCount
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	59	250	0xf4a097ce3a4efbd1748b2ef2076813961e4e6fa7	52	11838911	2021-02-12T01:39:51.000Z	0xbfb5c19b189d5b5e3040a4ec2d2581a8aee82740	0x4d7c55f2f70b24fef62e1a9f4c22808e612ca403ecc86a67d4b7968c1691e2d0	0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500	6
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	59	114	0x5a8904be09625965d9aec4bffd30d853438a053e	52	11838918	2021-02-12T01:41:16.000Z	0xee11860e1e01829967aa081a0608ee7070a33d3d	0x270e3a27a720183f30e0c7aa2a2acb00faac07e5331b0c00aafbde335b9ec732	0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500	5
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	59	172	0xd93456bf656436e66a8e0a8835c43a6f59afbb37	52	11838892	2021-02-12T01:34:43.000Z	0x1034d50ceaf259e2e44a977f273464ace08320bc	0x6dc9400491139c7ca9acb0dc409ca4d62fa469f99309ffea54c7d9a840b5a346	0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500	10

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_RebateClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_StakeDelegated_event

Delegation events from The Graph protocol’s staking contract on Ethereum, recording when delegators stake GRT tokens to indexers. Contains token amounts, delegation shares, and participant addresses for analyzing delegation behavior and indexer selection patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_delegator`	`STRING`	Address of the delegator participating in the staking or delegation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_shares	in_tokens	log_index	in_indexer	block_number	in_delegator	block_timestamp	transaction_hash
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	71923109675351327019060	75348673450000000000000	223	0x1a99dd7d916117a523f3ce6510dcfd6bceab11e7	12118228	0xe97750c73bc2d02d5c1dafff6ddb18d4e4ed9f0d	2021-03-27T01:37:17.000Z	0xf083b98f4e4c99fef983bf6dc7892511cc4eef9ad813d276fcd2ecfcd88b1916
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	58755765064384745197022	61690335439375000000000	194	0x1a99dd7d916117a523f3ce6510dcfd6bceab11e7	12124103	0x4e06c33342a57ccd2fc78dcae90de29d3ad29fb6	2021-03-27T23:25:23.000Z	0x3046e6fb0912a372159f8a51f8b8d8a4e79903c5c3b2c926994c61531793d51e
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	1012075797037666556883	1108071103500000000000	312	0x39839abed87475422c5353256d17e08395c3af6b	12123965	0x4ba6014a8a399c85eaa89cc353901de37e1e3e11	2021-03-27T22:56:32.000Z	0x2a4e31f5de67ec8a31fb11deb246e99f876e725faba42075ef8a277a5a9246a9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_StakeDelegated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_StakeDelegatedWithdrawn_event

StakeDelegatedWithdrawn event logs from The Graph protocol staking contract on Ethereum, recording when delegators withdraw their GRT tokens from indexers. Tracks withdrawal amounts in wei-denominated tokens along with delegator and indexer addresses for analyzing delegation flows and staking behavior.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_delegator`	`STRING`	Address of the delegator participating in the staking or delegation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

address	removed	in_tokens	log_index	in_indexer	block_number	in_delegator	block_timestamp	transaction_hash
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	597000000000000000000	296	0x3e1536fc83cd5bed83a521a26034ff3e59c6a7c4	15929573	0x0766a2c5fede6fb9c6563fe6401706f68996f1a1	2022-11-09T02:44:23.000Z	0xae2c1efa994f51f2fcf37e3b4518f3991a6600bf378ae0991810ac04ee6569d5
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	2481695925038130625823	147	0x6125ea331851367716bee301ecde7f38a7e429e7	15931407	0x8b8ef01f391ece3dc17d26306c7d28dd6a26d332	2022-11-09T08:53:23.000Z	0x99be6cdb23461957fce92e1d01b52fb5b28c73a1775c5f355af8399b21b94405
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	32168105202880788602502	404	0x39839abed87475422c5353256d17e08395c3af6b	16488849	0x25e3b602cd7927d1df5169854cb72c67397d68de	2023-01-26T05:17:35.000Z	0xa6a690bd7d38dcc3755b3b8f6d61e9ff5de9081ade75a4ddb81d77d0f4c185c9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_StakeDelegatedWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_StakeDeposited_event

GRT (Graph) token stake deposit events from The Graph protocol staking contract on Ethereum, recording when delegators or indexers add tokens to stake positions. Used for analyzing staking behavior, indexer growth, and protocol participation over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

address	removed	in_tokens	log_index	in_indexer	block_number	block_timestamp	transaction_hash
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	1117997840635155517	139	0x39839abed87475422c5353256d17e08395c3af6b	11799034	2021-02-05T22:46:10.000Z	0xc896c5b549b57237715155111fb12186449e052b6b1389b6fa7a6b43200f46e7
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	171876165468910824	289	0x39839abed87475422c5353256d17e08395c3af6b	11799036	2021-02-05T22:46:19.000Z	0xd178982f9d1cf88130bea1115985768398d6fd8e4f79561a29bd7cb2b14a133b
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	7849312859175645200000	144	0x4bd07ae84869eaf4413c1a9873a534109f40cc3a	11797723	2021-02-05T17:46:56.000Z	0xedf41a8b8fa2002797d9fad0368c367ccd75fe26b16bb1c9b9fae35bd1b9eb65

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_StakeDeposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_StakeSlashed_event

Slashing events from The Graph protocol staking contract on Ethereum, recording when indexer stakes are penalized for protocol violations. Contains slashed token amounts, associated rewards, indexer addresses, and beneficiary recipients for analyzing network security enforcement and indexer performance penalties.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_reward	in_tokens	log_index	in_indexer	block_number	in_beneficiary	block_timestamp	transaction_hash
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	12952465487540498719009	25904930975080997438019	73	0x76e84025978a0c16fc7ba483718b667388f2973c	13058230	0xe3671ff90401c21e2bb55b2dfab4506cede113e5	2021-08-19T21:39:29.000Z	0x1596590788e3b6464685e27ab099daa36f8bf9236153ee6ea8cde379bd2da3cf
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	14700407214744539531202	29400814429489079062405	48	0x76e84025978a0c16fc7ba483718b667388f2973c	13058230	0xe3671ff90401c21e2bb55b2dfab4506cede113e5	2021-08-19T21:39:29.000Z	0x1596590788e3b6464685e27ab099daa36f8bf9236153ee6ea8cde379bd2da3cf
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	13284579987221024327189	26569159974442048654378	68	0x76e84025978a0c16fc7ba483718b667388f2973c	13058230	0xe3671ff90401c21e2bb55b2dfab4506cede113e5	2021-08-19T21:39:29.000Z	0x1596590788e3b6464685e27ab099daa36f8bf9236153ee6ea8cde379bd2da3cf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_StakeSlashed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_StakeWithdrawn_event

Stake withdrawal events from The Graph protocol on Ethereum, recording when indexers unstake Graph Tokens (GRT) from the staking contract. Used for analyzing indexer staking behavior, capital allocation changes, and protocol participation dynamics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_indexer`	`STRING`	Address of the indexer participating in The Graph protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

address	removed	in_tokens	log_index	in_indexer	block_number	block_timestamp	transaction_hash
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	100000000000000000000000	203	0x646c3e975e33516cc6ccb39c2f8380c7f1cd6aab	17722298	2023-07-18T19:50:23.000Z	0xd083246ef54400ab71bcc5452a520f9998269cb3a8b7e958f72bcf0a68898851
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	106600925535015063700775	406	0xa7b07d3305d25306986eb50c0af30a48f067a99e	17721207	2023-07-18T16:09:35.000Z	0xac7dbf1f144e12f98fc55fd5924645edd7f1ad7a0f080e74a234195c4268b1a0
0xf55041e37e12cd407ad00ce2910b8269b01263b9	false	10000000000000000000	258	0x06590a641dc3eb43f2cebe435576389f209116da	11454831	2020-12-15T02:11:30.000Z	0x0bad21ce53c35950e57441e09f0de0973dab50afeef6b45f4ae51bd42cbe2ca6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_StakeWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_undelegate_function

Function call records for undelegating GRT tokens from indexers in The Graph protocol’s staking contract on Ethereum. Tracks delegator withdrawals with share amounts and returned token values for analyzing delegation flows and indexer stake changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__indexer`	`STRING`	Contract address of the indexer from whom shares are being undelegated in The Graph protocol. Hex-encoded, 0x-prefixed 40-character Ethereum address; null when transaction fails.
`in__shares`	`STRING`	Number of delegation shares being removed from the specified indexer in The Graph protocol. Input parameter for the undelegate function, represented as a high-precision integer string typically in the quadrillions range.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	out_anon0	signature	in__shares	to_address	in__indexer	block_number	from_address	block_timestamp	transaction_hash
278320	true	69415	9342338001216204231097	0x4d99dd16	8670700631692724784568	0xf55041e37e12cd407ad00ce2910b8269b01263b9	0x5a8904be09625965d9aec4bffd30d853438a053e	12845367	0x397e4922317be1aa463de4233b676d1eadf40765	2021-07-17T16:37:31.000Z	0x7739d4745ca27b2916de04b220b3d25455bf748312d08ec1a8178bc582865ef0
278320	true	103592	7118986718078133750380	0x4d99dd16	6519487863021414629577	0xf55041e37e12cd407ad00ce2910b8269b01263b9	0x9238584c74e5fa445a8f72a4d4ef4699dd783852	12845379	0x397e4922317be1aa463de4233b676d1eadf40765	2021-07-17T16:41:34.000Z	0x02553a56768f5b72efd485ac9693b40258efd7d838de6396cbaada12966694cf
278320	true	103592	16262807481851612636185	0x4d99dd16	15117287312049409572919	0xf55041e37e12cd407ad00ce2910b8269b01263b9	0xb06071394531b63b0bac78f27e12dc2beaa913e4	12843515	0x109ea970dfa1042c4322528b3591b0cf9b2949cb	2021-07-17T09:43:45.000Z	0xaf6dcd756128263fa97fb801017a346459011a413340d4ac9116f2cef3bdaccc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_undelegate_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_withdrawDelegated_function

Delegation withdrawal transactions from The Graph protocol staking contract on Ethereum, tracking delegators removing GRT tokens from indexers. Used for analyzing delegation flows, indexer performance metrics, and delegator behavior patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__indexer`	`STRING`	Address of The Graph indexer from which delegated stake is being withdrawn. Always non-zero when function executes successfully on the Staking contract.
`in__delegateToIndexer`	`STRING`	Address of the new indexer to which the withdrawn delegation will be redirected on The Graph protocol. Typically set to the zero address when not re-delegating withdrawn tokens.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	out_anon0	signature	to_address	in__indexer	block_number	from_address	block_timestamp	transaction_hash	in__delegateToIndexer
278440	true	84632	1169107464548210331340	0x51a60b02	0xf55041e37e12cd407ad00ce2910b8269b01263b9	0xd11e05240a50e2eedb03e72d4c9c6465bc05f2a4	13066580	0xca85c97e49d1022cf095adeba300662dc590e13a	2021-08-21T04:43:33.000Z	0x281c5cac3a79a25c93017929d464d89655729da0214f54fe25b35433a56016a6	0x0000000000000000000000000000000000000000
278440	true	84632	12105352932831718559961	0x51a60b02	0xf55041e37e12cd407ad00ce2910b8269b01263b9	0x85fe868adf7f5950b052469075556fb207e5372d	13067174	0x0f715b4a1426c8d1ca77e4173dff15659a5fe6db	2021-08-21T06:53:52.000Z	0x66db6f6e891ec17d0188a30dd7083ac886b40eba266cbb7b9c155cb89b9313a8	0x0000000000000000000000000000000000000000
278440	true	84632	1173267556208598301113	0x51a60b02	0xf55041e37e12cd407ad00ce2910b8269b01263b9	0x5a8904be09625965d9aec4bffd30d853438a053e	13066826	0x25f5906916f1588997fdcd353124df1c374c93cf	2021-08-21T05:39:48.000Z	0xc851e5b54246742273b63f7cb3d25a709a689354304f09ce7c28394dbf9f08bf	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_withdrawDelegated_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Curation_Burned_event

Curation_Collected_event

Curation_Signalled_event

DisputeManager_DisputeAccepted_event

DisputeManager_DisputeDrawn_event

DisputeManager_DisputeRejected_event

DisputeManager_IndexingDisputeCreated_event

RewardsManager_RewardsAssigned_event

RewardsManager_RewardsDenied_event

Staking_AllocationClosed_event

Staking_AllocationCollected_event

Staking_AllocationCreated_event

Staking_claim_function

Staking_claimMany_function

Staking_DelegationParametersUpdated_event

Staking_RebateClaimed_event

Staking_StakeDelegated_event

Staking_StakeDelegatedWithdrawn_event

Staking_StakeDeposited_event

Staking_StakeSlashed_event

Staking_StakeWithdrawn_event

Staking_undelegate_function

Staking_withdrawDelegated_function

​Tables

​Curation_Burned_event

​Curation_Collected_event

​Curation_Signalled_event

​DisputeManager_DisputeAccepted_event

​DisputeManager_DisputeDrawn_event

​DisputeManager_DisputeRejected_event

​DisputeManager_IndexingDisputeCreated_event

​RewardsManager_RewardsAssigned_event

​RewardsManager_RewardsDenied_event

​Staking_AllocationClosed_event

​Staking_AllocationCollected_event

​Staking_AllocationCreated_event

​Staking_claim_function

​Staking_claimMany_function

​Staking_DelegationParametersUpdated_event

​Staking_RebateClaimed_event

​Staking_StakeDelegated_event

​Staking_StakeDelegatedWithdrawn_event

​Staking_StakeDeposited_event

​Staking_StakeSlashed_event

​Staking_StakeWithdrawn_event

​Staking_undelegate_function

​Staking_withdrawDelegated_function

Tables

Curation_Burned_event

Curation_Collected_event

Curation_Signalled_event

DisputeManager_DisputeAccepted_event

DisputeManager_DisputeDrawn_event

DisputeManager_DisputeRejected_event

DisputeManager_IndexingDisputeCreated_event

RewardsManager_RewardsAssigned_event

RewardsManager_RewardsDenied_event

Staking_AllocationClosed_event

Staking_AllocationCollected_event

Staking_AllocationCreated_event

Staking_claim_function

Staking_claimMany_function

Staking_DelegationParametersUpdated_event

Staking_RebateClaimed_event

Staking_StakeDelegated_event

Staking_StakeDelegatedWithdrawn_event

Staking_StakeDeposited_event

Staking_StakeSlashed_event

Staking_StakeWithdrawn_event

Staking_undelegate_function

Staking_withdrawDelegated_function