> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# thegraph_v1_ethereum
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | signature | to\_address | in\_\_restake | block\_number | from\_address | trace\_address | block\_timestamp | in\_\_allocationID | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 210337 | 0 | true | 131048 | 0x92fd2daf | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | false | 12051575 | 0x2177318680d9e9265470903b6d0ddfcc5edb054c | | 2021-03-16T19:31:41.000Z | 0x72e3b1bac38a428cbc3f2babdd2fc9bfacf6c88a | 0xc5ff9f2fdcaf73e025e34176f013a0ea23ca2aab3cdaa58467854359e4b94c32 |
| 210304 | 0 | true | 131030 | 0x92fd2daf | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | false | 12051563 | 0xe35c249f495c563e42d5822985158825eb37e61e | | 2021-03-16T19:28:51.000Z | 0x33672e2c37cbf91a2d97004f65643a95413e5626 | 0x5912411d69809c2ecddc6e4898849b807370fec3298aa3b659b61d757d524bc1 |
| 210376 | 0 | true | 131074 | 0x92fd2daf | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | false | 12051563 | 0x37e3e7799ff278a7aca1feaa7cc25d1d27dbca8c | | 2021-03-16T19:28:51.000Z | 0x566d469927f1f10f1ab9f9c9ad8fe6f58836ca80 | 0xdfe2a8ff3a37ce8f6c91432131ff8301626b1bd20452f186fc5a684672eb71ad |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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. |
| gas | value | status | gas\_used | signature | to\_address | in\_\_restake | block\_number | from\_address | trace\_address | block\_timestamp | in\_\_allocationID | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ |
| 228296 | 0 | true | 142808 | 0x36a4fbd6 | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | true | 16530973 | 0xf3152ba60655e662d5ba0249304840b95e3a5540 | | 2023-02-01T02:25:47.000Z | \["0x3eeb4f10643bf47f36ccf629a5c2aa176fdd54e1"] | 0x7180f346825d032ba473cd79f324654fa3eb926cab0bcd935e28f5725d93b81b |
| 577960 | 0 | true | 371804 | 0x36a4fbd6 | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | false | 14916038 | 0x2177318680d9e9265470903b6d0ddfcc5edb054c | | 2022-06-06T16:59:15.000Z | \["0x0338591f7516c53f86856f65b4eeb1371d20e420","0x10c6fa0a35a94142b026a73907b3009e9b0e0d0f","0x85e39b4a1ab368d5c900565a60a84e9be293b13b","0xc34161b72fdba73cecd0c6048e83be48d1a2736c","0xefd335b43f6ab5a5bd2d09f6a0de927dee0b6e33"] | 0x364b05a968c89d7047cc1389d223a91908b4c18bc2fdb3ebee74b2a4e353ac88 |
| 966418 | 0 | true | 626247 | 0x36a4fbd6 | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | false | 14915990 | 0x4feab0138f6eb8e71e29b60ea43b480fad74d474 | | 2022-06-06T16:47:22.000Z | \["0x0d3400161478d54050ed465ff97622a0e051cd1c","0x2ec0b2659517aff7f14303b343ff6f473facca57","0x92a477f5c165b6db210dcafe89adfe894aa1c67f","0xb90b778e9d22a22f527bf20cdbf4d0c703bf0cf5","0xbe05036b7456c81c481c8dc7c4392b0013b776c5","0xda9d679fe52ce98c511440710296465e677dccb0","0xe89b8e99a81aae677866d321c32364f1e4b5efd5","0xf09fa203ec643cd5a5b55670b3870ca778b3cc5e","0xf13aca285212737f6be555e4ca3771acd22af7c7"] | 0xc43d934d2daf99bff695f6f4ef8dfac12edde51a4943064d3f654add51fefc5d |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | in\_epoch | in\_tokens | log\_index | in\_indexer | in\_forEpoch | block\_number | block\_timestamp | in\_allocationID | transaction\_hash | in\_delegationFees | in\_subgraphDeploymentID | in\_unclaimedAllocationsCount |
| ------------------------------------------ | ------- | --------- | ---------- | ---------- | ------------------------------------------ | ------------ | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------ | ------------------------------------------------------------------ | ----------------------------- |
| 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | false | 59 | 0 | 250 | 0xf4a097ce3a4efbd1748b2ef2076813961e4e6fa7 | 52 | 11838911 | 2021-02-12T01:39:51.000Z | 0xbfb5c19b189d5b5e3040a4ec2d2581a8aee82740 | 0x4d7c55f2f70b24fef62e1a9f4c22808e612ca403ecc86a67d4b7968c1691e2d0 | 0 | 0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500 | 6 |
| 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | false | 59 | 0 | 114 | 0x5a8904be09625965d9aec4bffd30d853438a053e | 52 | 11838918 | 2021-02-12T01:41:16.000Z | 0xee11860e1e01829967aa081a0608ee7070a33d3d | 0x270e3a27a720183f30e0c7aa2a2acb00faac07e5331b0c00aafbde335b9ec732 | 0 | 0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500 | 5 |
| 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | false | 59 | 0 | 172 | 0xd93456bf656436e66a8e0a8835c43a6f59afbb37 | 52 | 11838892 | 2021-02-12T01:34:43.000Z | 0x1034d50ceaf259e2e44a977f273464ace08320bc | 0x6dc9400491139c7ca9acb0dc409ca4d62fa469f99309ffea54c7d9a840b5a346 | 0 | 0x31edcacc9a53bc8ab4be2eeb0d873409da4c4228cb2d60e4243bd3b4e8af7500 | 10 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | out\_anon0 | signature | in\_\_shares | to\_address | in\_\_indexer | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ----------------------- | ---------- | ----------------------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 278320 | 0 | true | 69415 | 9342338001216204231097 | 0x4d99dd16 | 8670700631692724784568 | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | 0x5a8904be09625965d9aec4bffd30d853438a053e | 12845367 | 0x397e4922317be1aa463de4233b676d1eadf40765 | | 2021-07-17T16:37:31.000Z | 0x7739d4745ca27b2916de04b220b3d25455bf748312d08ec1a8178bc582865ef0 |
| 278320 | 0 | true | 103592 | 7118986718078133750380 | 0x4d99dd16 | 6519487863021414629577 | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | 0x9238584c74e5fa445a8f72a4d4ef4699dd783852 | 12845379 | 0x397e4922317be1aa463de4233b676d1eadf40765 | | 2021-07-17T16:41:34.000Z | 0x02553a56768f5b72efd485ac9693b40258efd7d838de6396cbaada12966694cf |
| 278320 | 0 | true | 103592 | 16262807481851612636185 | 0x4d99dd16 | 15117287312049409572919 | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | 0xb06071394531b63b0bac78f27e12dc2beaa913e4 | 12843515 | 0x109ea970dfa1042c4322528b3591b0cf9b2949cb | | 2021-07-17T09:43:45.000Z | 0xaf6dcd756128263fa97fb801017a346459011a413340d4ac9116f2cef3bdaccc |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | out\_anon0 | signature | to\_address | in\_\_indexer | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash | in\_\_delegateToIndexer |
| ------ | ----- | ------ | --------- | ----------------------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 278440 | 0 | true | 84632 | 1169107464548210331340 | 0x51a60b02 | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | 0xd11e05240a50e2eedb03e72d4c9c6465bc05f2a4 | 13066580 | 0xca85c97e49d1022cf095adeba300662dc590e13a | | 2021-08-21T04:43:33.000Z | 0x281c5cac3a79a25c93017929d464d89655729da0214f54fe25b35433a56016a6 | 0x0000000000000000000000000000000000000000 |
| 278440 | 0 | true | 84632 | 12105352932831718559961 | 0x51a60b02 | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | 0x85fe868adf7f5950b052469075556fb207e5372d | 13067174 | 0x0f715b4a1426c8d1ca77e4173dff15659a5fe6db | | 2021-08-21T06:53:52.000Z | 0x66db6f6e891ec17d0188a30dd7083ac886b40eba266cbb7b9c155cb89b9313a8 | 0x0000000000000000000000000000000000000000 |
| 278440 | 0 | true | 84632 | 1173267556208598301113 | 0x51a60b02 | 0xf55041e37e12cd407ad00ce2910b8269b01263b9 | 0x5a8904be09625965d9aec4bffd30d853438a053e | 13066826 | 0x25f5906916f1588997fdcd353124df1c374c93cf | | 2021-08-21T05:39:48.000Z | 0xc851e5b54246742273b63f7cb3d25a709a689354304f09ce7c28394dbf9f08bf | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thegraph_v1_ethereum.Staking_withdrawDelegated_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***