> ## 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.
# velodrome_v2_optimism
> Tables in tt-contracts.velodrome_v2_optimism
## Tables
### bribeVotingReward\_ClaimRewards\_event
Bribe reward claim events from Velodrome V2 DEX (decentralized exchange) on Optimism, recording when voters claim incentive tokens for their gauge votes. Used to track bribe distribution patterns, reward token flows, and voter incentive claiming behavior across liquidity pools.
| 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_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_reward` | `STRING` | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_from | removed | in\_amount | in\_reward | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | --------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0226cd3073ff122085b60d9072b4115f641f2ec2 | 0x2359497cc3f8f11a80d775715367d5cb3d0fd274 | false | 189560641737332920507 | 0xff733b2a3557a7ed6697007ab5d11b79fdd1b76b | 37 | 110406686 | 2023-10-04T09:35:49.000Z | 0xb4ab907829ef974e9b4a553d4c0653899bc61ed731e3b972a4dc5a93b6fae4d3 |
| 0x0226cd3073ff122085b60d9072b4115f641f2ec2 | 0xeee4cd5e66de82350e6c346307f8383588ffb229 | false | 587993268624456556517 | 0xff733b2a3557a7ed6697007ab5d11b79fdd1b76b | 12 | 110419232 | 2023-10-04T16:34:01.000Z | 0xb3dbe11bc28009f080c6d5d5032e32f7b40589ca93d454772570679e9c26ce59 |
| 0x0226cd3073ff122085b60d9072b4115f641f2ec2 | 0xaba92f62ef9d45d0b61808d330461c3b2d8fece8 | false | 18616628636568997529 | 0xff733b2a3557a7ed6697007ab5d11b79fdd1b76b | 21 | 110412353 | 2023-10-04T12:44:43.000Z | 0x5f7484e4bb3a5930d2d9ec10f832006347c3767f4d7f181f278dac3c8e824597 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.bribeVotingReward_ClaimRewards_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### bribeVotingReward\_Deposit\_event
Bribe deposit events for Velodrome V2 DEX (decentralized exchange) voting rewards on Optimism, tracking incentive payments to veNFT (vote-escrowed NFT) token holders. Used for analyzing bribe markets, governance incentive structures, and liquidity pool vote-buying activity.
| 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_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_from | removed | in\_amount | log\_index | in\_tokenId | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1764d3ed6071ebae1a0bfbc0dc7552b241d4ca33 | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 39654496010984134670 | 4 | 4408 | 106326544 | 2023-07-01T22:51:05.000Z | 0x89dd54dabd2863e4df7eaad609408bec41e89229391c6f399de0d00fa30d6216 |
| 0x1764d3ed6071ebae1a0bfbc0dc7552b241d4ca33 | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 70617081661135807840 | 16 | 4411 | 106326554 | 2023-07-01T22:51:25.000Z | 0xbaa50498887b53942b792cd7dd59e5b757fec53b3c6cc1a26ba428899d81f67a |
| 0x1764d3ed6071ebae1a0bfbc0dc7552b241d4ca33 | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 17497309646514147817 | 17 | 4405 | 106326536 | 2023-07-01T22:50:49.000Z | 0xb2ea083928baea6163bba13334fcc925fcc2be6ffcee21da1c7049a70215895a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.bribeVotingReward_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### bribeVotingReward\_NotifyReward\_event
Bribe notification events from Velodrome V2 decentralized exchange (DEX) on Optimism, recording when protocols deposit rewards to incentivize liquidity pool votes. Used for tracking protocol voting incentive strategies and analyzing the Velodrome vote-escrowed (ve) tokenomics model across weekly 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_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_reward` | `STRING` | Contract address of the reward token being distributed or claimed. 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 | in\_from | removed | in\_epoch | in\_amount | in\_reward | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xcc6251d32faecd8bb3e78b30968a42dce7d37326 | 0x067bed3ce9de9ed8359e8564c30c426f02a6fe4f | false | 1699488000 | 4000000000000000000000 | 0x9560e827af36c94d2ac33a39bce1fe78631088db | 2 | 112105492 | 2023-11-12T17:22:41.000Z | 0x91d86f902fcc5c37816003b08b6264a18c9ff68aae9a98ee6a8bc98ff2584b0e |
| 0x1219077b593cff63b10cc6861362b9be75ebafb8 | 0x20fbc8e5123dbb3ea535b7440e560e02d95d9c4c | false | 1699488000 | 450000000000000000000000 | 0x5976d4c3bcfc1c5f90ab1419d7f3ddf109cea35a | 7 | 112104826 | 2023-11-12T17:00:29.000Z | 0x305bc433aeb2d7f5a5bb779619676de36e49571eb8c2bf18663e7d4f3f748a80 |
| 0x7dd212ee6c1b0b22caf51b10cf37aba977b2f190 | 0x20fbc8e5123dbb3ea535b7440e560e02d95d9c4c | false | 1699488000 | 150000000000000000000000 | 0x5976d4c3bcfc1c5f90ab1419d7f3ddf109cea35a | 18 | 112104845 | 2023-11-12T17:01:07.000Z | 0x6aa8e2c51b9c0e059701935e80e2599e4d27f216c91719e69113a3d0eab8dd3e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.bribeVotingReward_NotifyReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### bribeVotingReward\_Withdraw\_event
Bribe reward withdrawal events from Velodrome V2 decentralized exchange on Optimism, tracking when users claim voting incentives associated with their veNFT positions (tokenId). Used for analyzing reward distribution patterns and voter participation in Velodrome's vote-escrowed governance system.
| 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_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_from | removed | in\_amount | log\_index | in\_tokenId | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x2734d75d6394c34be4868d46960bb1244fdc56f6 | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 554685135237981501620578 | 13 | 6 | 111333059 | 2023-10-25T20:14:55.000Z | 0x674d0b45a302495503711361de310a06a651a17ee35857da97533fbc0c39f63f |
| 0x1801131cf4c79e40eb32039f8fb2d20eb351c24a | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 739580180317308668827438 | 19 | 6 | 111333059 | 2023-10-25T20:14:55.000Z | 0x674d0b45a302495503711361de310a06a651a17ee35857da97533fbc0c39f63f |
| 0xa34ed712c42aeeb49a505f1965084364ea966a7b | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 739580180317308668827438 | 22 | 6 | 111333059 | 2023-10-25T20:14:55.000Z | 0x674d0b45a302495503711361de310a06a651a17ee35857da97533fbc0c39f63f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.bribeVotingReward_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory\_PoolCreated\_event
Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.
| 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_token0` | `STRING` | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token1` | `STRING` | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_stable` | `BOOL` | Boolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values. |
| `in_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_anon4` | `STRING` | Sequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value. |
| address | in\_pool | removed | in\_anon4 | in\_stable | in\_token0 | in\_token1 | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | --------- | ---------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | 0x3c4782795bff3c7be28b6e9651d1868192438641 | false | 636 | false | 0x4200000000000000000000000000000000000042 | 0xe1707e411bdbf4e74a805e55ba43d08c2e7e2208 | 150 | 114577981 | 2024-01-08T22:58:59.000Z | 0x1a08ac440738b4f37ebb1eb4db9fcd2ae267e4f2013f0a9aafd94cb6027bafae |
| 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | 0x25cd315a9d69ecfca301d0c6fb6a0d1f6a96a4bc | false | 635 | false | 0x4200000000000000000000000000000000000042 | 0xb33c093227d2bd1949d44899ebb4c98f6437d017 | 72 | 114573343 | 2024-01-08T20:24:23.000Z | 0x36b2bc18de63b109c34aa5385b9ad06081a4dd9c9ac824d025f02be3eda2d42d |
| 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | 0x825e291af3555685554a13971e731145393dc8a7 | false | 300 | true | 0x4200000000000000000000000000000000000006 | 0x7f5c764cbc14f9669b88837ca1490cca17c31607 | 36 | 107942122 | 2023-08-08T08:23:41.000Z | 0x7af2aec0930edcded8c9143626e69d59243c72fd5dae6025bc575e73ffa5b66f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Factory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory\_SetCustomFee\_event
Custom fee configuration events from Velodrome V2 decentralized exchange (DEX) factory on Optimism. Records per-pool fee tier adjustments in basis points, useful for analyzing fee strategy changes and liquidity pool 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| in\_fee | address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 7 | 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | 0x4706e50fde911525e4b904c240056c4ea0884aa6 | false | 5 | 112148244 | 2023-11-13T17:07:45.000Z | 0x692a85d2df50691f910c50ab23033e86c61bc3edb8465c92092e88aa0ae3beab |
| 10 | 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | 0x5e4a183fa83c52b1c55b11f2682f6a8421206633 | false | 6 | 112148244 | 2023-11-13T17:07:45.000Z | 0x692a85d2df50691f910c50ab23033e86c61bc3edb8465c92092e88aa0ae3beab |
| 8 | 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | 0xfff37730744930cb61be34c0014068f4f1ec28cf | false | 4 | 112148244 | 2023-11-13T17:07:45.000Z | 0x692a85d2df50691f910c50ab23033e86c61bc3edb8465c92092e88aa0ae3beab |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Factory_SetCustomFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory\_SetFeeManager\_event
Fee manager address changes on Velodrome V2 DEX factory contract on Optimism. Tracks administrative updates to the protocol's fee collection authority for governance and access control analysis.
| 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_feeManager` | `STRING` | Address of the account designated as the fee manager for the Velodrome V2 factory contract. This role has permissions to configure and manage protocol fee parameters. |
| address | removed | log\_index | block\_number | in\_feeManager | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | false | 0 | 105896960 | 0xba4bb89f4d1e66aa86b60696534892ae0ccf91f5 | 2023-06-22T00:11:37.000Z | 0xe9dda913dc26db046248a5a0c1deac0115f319fb096dc190a95022dadebb2788 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Factory_SetFeeManager_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory\_SetPauser\_event
Administrative events tracking changes to pauser role addresses in the Velodrome V2 DEX factory contract on Optimism. Used for governance analysis and protocol security monitoring.
| 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_pauser` | `STRING` | Address of the account granted pauser permissions in the Velodrome V2 factory contract. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the privileged role that can pause protocol operations. |
| address | removed | in\_pauser | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | false | 0xba4bb89f4d1e66aa86b60696534892ae0ccf91f5 | 0 | 105896939 | 2023-06-22T00:10:55.000Z | 0xcb5c923fc5d45838b67cee0f12aafb7790ba6bf056d396703157fed1866e88b6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Factory_SetPauser_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory\_SetVoter\_event
Governance events recording changes to the voter contract address in Velodrome V2's factory contract on Optimism. Tracks when voting power delegation contracts are updated or removed for the protocol's vote-escrowed tokenomics system.
| 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_voter` | `STRING` | Address of the account casting the vote or participating in governance. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_voter | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | false | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | 0 | 105896964 | 2023-06-22T00:11:45.000Z | 0x86d20722c63d12e58faf73625bc1cfaab204db6bcd7efb46db66798850113bdb |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Factory_SetVoter_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gauge\_ClaimFees\_event
Fee claim events from Velodrome V2 gauge contracts on Optimism, recording when liquidity providers withdraw accumulated trading fees from their staked positions. Captures amounts of both tokens in each pair claimed per gauge address.
| 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_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_claimed0` | `STRING` | Amount of the first token (token0) claimed as fees from the Velodrome V2 gauge. Value is denominated in the token's smallest unit (wei for 18-decimal tokens). |
| `in_claimed1` | `STRING` | Amount of the second token in the liquidity pair claimed as fees from the gauge, denominated in the token's smallest unit (wei for ERC20 tokens). Values vary based on pool composition and trading volume generating fees. |
| address | in\_from | removed | log\_index | in\_claimed0 | in\_claimed1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------ | --------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6e4b10dd7950c5dc8a084ac16f5de5ca7ee9e334 | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 67 | 167989908250 | 54304585986251 | 110130284 | 2023-09-28T00:02:25.000Z | 0x2feb13e7d491c977fd57fcc80d9d60435621e2da78e6410afe51fc394a3771e6 |
| 0xdfe0eea4b7ca157cb1faf73fac2135164b375fb0 | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 32 | 138391474929405001 | 156306492437850750 | 110130284 | 2023-09-28T00:02:25.000Z | 0x2feb13e7d491c977fd57fcc80d9d60435621e2da78e6410afe51fc394a3771e6 |
| 0xcc53cd0a8ec812d46f0e2c7cc5aadd869b6f0292 | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 190 | 521709269574778339 | 866651216088247231524 | 110130284 | 2023-09-28T00:02:25.000Z | 0x2feb13e7d491c977fd57fcc80d9d60435621e2da78e6410afe51fc394a3771e6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Gauge_ClaimFees_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gauge\_ClaimRewards\_event
Reward distribution events emitted when users claim accrued incentives from liquidity mining gauges. Records the claimer address, reward token contract, and claimed amount for tracking protocol incentive flows.
| 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_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_from | removed | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xcc53cd0a8ec812d46f0e2c7cc5aadd869b6f0292 | 0x01087c3419cdf589b55c086aaf006d5d8e54f7a1 | false | 402100583515523083413 | 121 | 107975794 | 2023-08-09T03:06:05.000Z | 0x2a13f5bd155ae7cb970a50421ec7e6dd872b227db0b64386bada2ffa080d7854 |
| 0xcc53cd0a8ec812d46f0e2c7cc5aadd869b6f0292 | 0x01087c3419cdf589b55c086aaf006d5d8e54f7a1 | false | 1297949642592164724133 | 109 | 107994907 | 2023-08-09T13:43:11.000Z | 0x318ce073652eef78f3333eb90f08b5cbd1135c138d88149697c2b87bf321bce7 |
| 0xcc53cd0a8ec812d46f0e2c7cc5aadd869b6f0292 | 0x01087c3419cdf589b55c086aaf006d5d8e54f7a1 | false | 1090729355416922690860 | 179 | 108002326 | 2023-08-09T17:50:29.000Z | 0xfa4e21b2c0794b73f2e06e6e4d7373ddcdc327292b5b07f11088bb59b6a550b8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Gauge_ClaimRewards_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gauge\_Deposit\_event
Liquidity provider staking events from Velodrome V2 gauge contracts on Optimism, capturing LP token deposits into gauges to earn protocol incentives. Used for analyzing liquidity mining participation, gauge TVL growth, and user staking behavior across Velodrome pools.
| 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_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| in\_to | address | in\_from | removed | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ----------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x4c2ab0b6041b977035b9507c1d391d6c437e74cb | 0x04b739f3488e4ca48a1638d945d41b9ae33424e5 | 0x4c2ab0b6041b977035b9507c1d391d6c437e74cb | false | 71953026892396351 | 90 | 107256940 | 2023-07-23T11:44:17.000Z | 0xd6da9dfb118d9144725b62eb319e13dd0a3c494e8947f640e8d6ed5da87efb26 |
| 0x4c2ab0b6041b977035b9507c1d391d6c437e74cb | 0x04b739f3488e4ca48a1638d945d41b9ae33424e5 | 0x4c2ab0b6041b977035b9507c1d391d6c437e74cb | false | 71196011774445740 | 80 | 107251756 | 2023-07-23T08:51:29.000Z | 0x0410eecf8bf6d74888418f0215d0359ca291193d43b0aa006eb23347eb79ae98 |
| 0x4c2ab0b6041b977035b9507c1d391d6c437e74cb | 0x04b739f3488e4ca48a1638d945d41b9ae33424e5 | 0x4c2ab0b6041b977035b9507c1d391d6c437e74cb | false | 90235060607903638 | 83 | 107276834 | 2023-07-23T22:47:25.000Z | 0x57d31a0243a5fb88f909742e5729623dec156c5216466bbc4fa6b55aee0506d6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Gauge_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gauge\_NotifyReward\_event
Reward distribution events from Velodrome V2 gauges on Optimism, recording when incentive tokens are allocated to liquidity pool gauges. Used for tracking emissions schedules and analyzing which pools receive voting rewards from the protocol's vote-escrowed tokenomics system.
| 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_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_from | removed | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ----------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0e9e97308ef8e35211a21aef9708dcc80f3d79ef | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 2205457772316700579555 | 30 | 108096796 | 2023-08-11T22:19:29.000Z | 0xb3fc99c4ff9bd2e86ea4c05ca8bf4fff8b4a4bb5d6ddd7e64c4f21d91b2aa093 |
| 0x2f434cad1525c38ff21aa60dd55e8a2c924fe1bf | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 14629786729891217167214 | 35 | 112247176 | 2023-11-16T00:05:29.000Z | 0xf311ddf79df093582d140b77e5042f1537a7e5e33a8b3067afb98861ea00fdd4 |
| 0x8cc252a212a42e381b0774ebf936c8615d9d3b44 | 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 363440055075069040482 | 54 | 112247176 | 2023-11-16T00:05:29.000Z | 0xf311ddf79df093582d140b77e5042f1537a7e5e33a8b3067afb98861ea00fdd4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Gauge_NotifyReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gauge\_Withdraw\_event
Withdrawal events from Velodrome V2 liquidity gauge contracts on Optimism, tracking when users unstake their LP (liquidity provider) tokens from gauges. Used for analyzing staking behavior, gauge participation trends, and liquidity mining exit 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_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_from | removed | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | --------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0193b726f29d7e12c8b1778298f888c546d0543f | 0x2d9f73c98f256870887ecfc2dd9114c9d0f97ae2 | false | 24058836643450 | 35 | 109087342 | 2023-09-03T20:37:41.000Z | 0x7b230eee3b2e064cd7e60b0ba8adaae08e161d6e39c672664e51a7cf65b5ed13 |
| 0x0193b726f29d7e12c8b1778298f888c546d0543f | 0x5e19807bce06a46be6c08ce4768d2c62548b73f7 | false | 15802678363851 | 9 | 109077681 | 2023-09-03T15:15:39.000Z | 0x083b9a11dfcf7a0b38ed8cb6517bbce470084a103dfc1b75896084851d28a4af |
| 0x04b739f3488e4ca48a1638d945d41b9ae33424e5 | 0x49ae63864988ee94791a8aeb0aa05a465699a5db | false | 814308494191977274437 | 6 | 109082907 | 2023-09-03T18:09:51.000Z | 0x411468dcd06ad5e4d253e7b87f56325f0883d6bb8f3e3be8caa969fd063b6501 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Gauge_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Burn\_event
Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL 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. |
| `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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount0` | `STRING` | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amount1` | `STRING` | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| in\_to | address | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6f030b74371167d3b71cf3214e749b0d1814c049 | 0x0493bf8b6dbb159ce2db2e0e8403e753abd1235b | false | 0xa062ae8a9c5e11aaa026fc2670b0d65ccc8b2858 | 251 | 5084015471775293 | 8412382 | 108841220 | 2023-08-29T03:53:37.000Z | 0xaa25a1198810d22423626091dd67bd64ef21ec710335cfa3cf298fe4bcf296eb |
| 0x70e90881790045ab17b59184f1adf33f456dcbd4 | 0x0493bf8b6dbb159ce2db2e0e8403e753abd1235b | false | 0xa062ae8a9c5e11aaa026fc2670b0d65ccc8b2858 | 102 | 3624180115687685 | 5957743 | 108853890 | 2023-08-29T10:55:57.000Z | 0x6c9928506f522d9447e93ff1f19333d53b27b901a31da36450b9d3f569d9b834 |
| 0x564eee8bb8b3ea0b732868ea4e29f584c6317891 | 0x0493bf8b6dbb159ce2db2e0e8403e753abd1235b | false | 0xa062ae8a9c5e11aaa026fc2670b0d65ccc8b2858 | 101 | 3304274378437760 | 5442586 | 108849533 | 2023-08-29T08:30:43.000Z | 0xea6b720fba16341bedfe2751457034cb29e5300bf79c8f9b3d33704528a804e8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Pool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Claim\_event
Fee claim events from Velodrome V2 liquidity pools on Optimism showing amounts of token0 and token1 collected by liquidity providers. Used for tracking LP fee revenue and pool performance analysis.
| 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount0` | `STRING` | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amount1` | `STRING` | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------------------- | ---------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xe5f28fc43bb40cdf7202ebe406793815b6f07fbd | false | 0xd85a08e8f475f8b6276c7d6bdf17d45736fea621 | 75 | 356546747123324759375 | 111856874 | 110432771 | 0xd85a08e8f475f8b6276c7d6bdf17d45736fea621 | 2023-10-05T00:05:19.000Z | 0xdf8caa5ab1300429f8621bedde471f823a9022afc1c261f6fc180915508451c6 |
| 0x56770b94279539416855fe29ef14b26438b5e421 | false | 0x21cda2b68318651dcc2c1006ea815e528bfe6db4 | 93 | 4662717180567187076936 | 2110173972 | 110432771 | 0x21cda2b68318651dcc2c1006ea815e528bfe6db4 | 2023-10-05T00:05:19.000Z | 0xdf8caa5ab1300429f8621bedde471f823a9022afc1c261f6fc180915508451c6 |
| 0xff5318f81dd791e92d51b8a54fa3538832d2890d | false | 0x325c9cbbf46aaecd4354b9ee793197aa78ebf682 | 22 | 279932002588137 | 1151944809747115 | 110432771 | 0x325c9cbbf46aaecd4354b9ee793197aa78ebf682 | 2023-10-05T00:05:19.000Z | 0xdf8caa5ab1300429f8621bedde471f823a9022afc1c261f6fc180915508451c6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Pool_Claim_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Fees\_event
Fee collection events from Velodrome V2 liquidity pools on Optimism. Records token0 and token1 fee amounts accrued per pool, useful for analyzing protocol revenue and liquidity provider earnings.
| 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount0` | `STRING` | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amount1` | `STRING` | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------- | ------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x7c9a7243f6a359781996822a141a28dc48aa258b | false | 0x057c1c332173d2b1d2f10c7c6c7a7ae51a96253d | 29 | 0 | 930000000000000000 | 114661542 | 2024-01-10T21:24:21.000Z | 0xbe348396fa44bbbc3e10be64d7f343bb2b3abb3052c10a101b4a33e95ec124ca |
| 0xc5c247580a4a6e4d3811c0da6215057aac480bac | false | 0x057c1c332173d2b1d2f10c7c6c7a7ae51a96253d | 3 | 0 | 396000000000000000 | 114663824 | 2024-01-10T22:40:25.000Z | 0xbadf777478a7a887f185f620dcdef645d8af07f9e69fb27fd85fd2e92299f38e |
| 0x7c9a7243f6a359781996822a141a28dc48aa258b | false | 0x057c1c332173d2b1d2f10c7c6c7a7ae51a96253d | 10 | 644994371367810 | 0 | 114627134 | 2024-01-10T02:17:25.000Z | 0x2883eacf02722be1bfb821e9f64a90da2d36c2c410fb89c0ce8fd8e328603443 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Pool_Fees_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Mint\_event
Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.
| 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount0` | `STRING` | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amount1` | `STRING` | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0493bf8b6dbb159ce2db2e0e8403e753abd1235b | false | 0xa062ae8a9c5e11aaa026fc2670b0d65ccc8b2858 | 127 | 462543619961681613962 | 962131777130 | 112002748 | 2023-11-10T08:17:53.000Z | 0x4df7d263cba6754cc91c18f066be2458089edd2831f72f1d1b800817610350bf |
| 0x0493bf8b6dbb159ce2db2e0e8403e753abd1235b | false | 0xa062ae8a9c5e11aaa026fc2670b0d65ccc8b2858 | 88 | 458672104287084587766 | 966099109197 | 112021190 | 2023-11-10T18:32:37.000Z | 0x47c0097b320a75bb38521c0038926cfcd66b51a9701d5abb2f87d65e4bbc39ed |
| 0x0493bf8b6dbb159ce2db2e0e8403e753abd1235b | false | 0xa062ae8a9c5e11aaa026fc2670b0d65ccc8b2858 | 107 | 466046930259861226140 | 969694584604 | 112013522 | 2023-11-10T14:17:01.000Z | 0x6866009938c0ccb0c5b1f098208868406d74542e46bf17a976eb475073a81359 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Pool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Swap\_event
Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.
| 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount0In` | `STRING` | Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
| `in_amount1In` | `STRING` | Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
| `in_amount0Out` | `STRING` | Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
| `in_amount1Out` | `STRING` | Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
| in\_to | address | removed | in\_sender | log\_index | block\_number | in\_amount0In | in\_amount1In | in\_amount0Out | in\_amount1Out | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ----------------------- | ---------------- | -------------- | ------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x000dd18e2a05c2c617dc517959d32f440e972f46 | 0x38160f7fcbf1e82a47c7abc03a531abdd48686f7 | false | 0xa062ae8a9c5e11aaa026fc2670b0d65ccc8b2858 | 144 | 115088415 | 0 | 5000000000000000 | 12307201 | 0 | 2024-01-20T18:33:27.000Z | 0xb84d7968abab9f454abc99c23733b3e7206377072f01cf62387491d9fa815673 |
| 0x0019da079128ade8285b64290b757d09360940a5 | 0x6910ba3714231c3a3756207e9941a814dbe84a96 | false | 0xa062ae8a9c5e11aaa026fc2670b0d65ccc8b2858 | 40 | 115066406 | 0 | 2459 | 37752958899689 | 0 | 2024-01-20T06:19:49.000Z | 0x1a771b3905d51a3e534e13078d36d7c459f50c18784c28e9dc11f48def7fcc5f |
| 0x00482a63f8e7708eb212bd9f7cd15e4cf8b68618 | 0x72aba20779797904bd395b7c69b4f9fb29cbb653 | false | 0xa062ae8a9c5e11aaa026fc2670b0d65ccc8b2858 | 23 | 115055301 | 36364095005459083892362 | 0 | 0 | 429158991131068211 | 2024-01-20T00:09:39.000Z | 0x4bf7f97c290b78d5aea2d570f9465b91c20019a6056bb28addda4b57768e2d6b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Sync\_event
Reserve balance updates from Velodrome V2 liquidity pools on Optimism after each swap or liquidity change. Used for tracking pool state changes, analyzing liquidity depth over time, and reconstructing historical exchange rates.
| 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_reserve0` | `STRING` | Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token. |
| `in_reserve1` | `STRING` | Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token. |
| address | removed | log\_index | in\_reserve0 | in\_reserve1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------------------- | ------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6d5ba400640226e24b50214d2bbb3d4db8e6e15a | false | 22 | 5855671276340 | 7600056976245166606318571 | 111945728 | 2023-11-09T00:37:13.000Z | 0xa59a01eb1d991c99a498b112e03bbb18ebbd2dae22a0d37baf555504a613ddb4 |
| 0xd95e98fc33670dc033424e7aa0578d742d00f9c7 | false | 27 | 1197980687170 | 964265982986 | 111945728 | 2023-11-09T00:37:13.000Z | 0xa59a01eb1d991c99a498b112e03bbb18ebbd2dae22a0d37baf555504a613ddb4 |
| 0x844d7d2fca6786be7de6721aabdff6957ace73a0 | false | 32 | 16519068520476279899077 | 224312016640 | 111945728 | 2023-11-09T00:37:13.000Z | 0xa59a01eb1d991c99a498b112e03bbb18ebbd2dae22a0d37baf555504a613ddb4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Pool_Sync_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Transfer\_event
Liquidity pool token transfer events emitted when LP (Liquidity Provider) tokens are minted, burned, or transferred between addresses. Contains sender, recipient, and token amount for tracking pool share ownership and liquidity position 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. |
| `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_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| in\_to | address | in\_from | removed | in\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0000000000000000000000000000000000000000 | 0x04730579f1468c06530ae3a84b7d5c233f3a130d | 0x04730579f1468c06530ae3a84b7d5c233f3a130d | false | 1045498903853 | 19 | 116348240 | 2024-02-18T22:27:37.000Z | 0x1d2858b2bba6530c038c12e8c36d9e35bb5212f9f9f48cb74816ea4280324c44 |
| 0x4dc286dea32dc4924fda7c673229e23751dff0a0 | 0x04730579f1468c06530ae3a84b7d5c233f3a130d | 0x0000000000000000000000000000000000000000 | false | 1045498903853 | 78 | 116348192 | 2024-02-18T22:26:01.000Z | 0x56b7fa7136f75b1733d472581cc66e5b677722e95196160251a846f84f6dfb6a |
| 0x04730579f1468c06530ae3a84b7d5c233f3a130d | 0x04730579f1468c06530ae3a84b7d5c233f3a130d | 0x4dc286dea32dc4924fda7c673229e23751dff0a0 | false | 1045498903853 | 18 | 116348240 | 2024-02-18T22:27:37.000Z | 0x1d2858b2bba6530c038c12e8c36d9e35bb5212f9f9f48cb74816ea4280324c44 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Pool_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voter\_Abstained\_event
Vote withdrawal events from Velodrome V2 decentralized exchange (DEX) on Optimism, recording when veVELO NFT holders remove their gauge votes. Used for analyzing voter behavior changes and tracking shifts in liquidity incentive allocation across pools.
| 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_voter` | `STRING` | Address of the account casting the vote or participating in governance. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
| `in_weight` | `STRING` | Voting power or gauge weight allocated to a pool or account. Numeric string representation of wei-denominated value. |
| `in_totalWeight` | `STRING` | Total voting weight allocated to the pool after this abstention event. Represented as a high-precision integer denominated in the smallest unit of the protocol's governance token. |
| `in_timestamp` | `STRING` | Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch. |
| address | in\_pool | removed | in\_voter | in\_weight | log\_index | in\_tokenId | block\_number | in\_timestamp | in\_totalWeight | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | -------------------------- | ---------- | ----------- | ------------- | ------------- | -------------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | 0xa1055762336f92b4b8d2edc032a0ce45ead6280a | false | 0x00621858d5dc273fcf204260265ba6e66c34b5e7 | 1001315825365690336427666 | 67 | 20276 | 116471051 | 1708540879 | 23185398936742041965936003 | 2024-02-21T18:41:19.000Z | 0x4d4e06207c7eb1a4c1542e3341905ac32124051315d8359d71ef860a923d06eb |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | 0x8134a2fdc127549480865fb8e5a9e8a8a95a54c5 | false | 0x00621858d5dc273fcf204260265ba6e66c34b5e7 | 51212670377815233122508544 | 10 | 20276 | 116471051 | 1708540879 | 14191555964093205760982850 | 2024-02-21T18:41:19.000Z | 0x4d4e06207c7eb1a4c1542e3341905ac32124051315d8359d71ef860a923d06eb |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | 0x6387765ffa609ab9a1da1b16c455548bfed7cbea | false | 0x00621858d5dc273fcf204260265ba6e66c34b5e7 | 1001315825365690336427666 | 73 | 20276 | 116471051 | 1708540879 | 12981158381678467397926734 | 2024-02-21T18:41:19.000Z | 0x4d4e06207c7eb1a4c1542e3341905ac32124051315d8359d71ef860a923d06eb |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Voter_Abstained_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voter\_DistributeReward\_event
Reward distribution events emitted when a Voter contract allocates tokens to gauge contracts. Records the sender address, target gauge contract, and token amount distributed for liquidity mining incentives.
| 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_gauge` | `STRING` | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_gauge | in\_amount | in\_sender | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ----------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 0x1239c54d9fd91e6ecec8eaad80df0fed43c47673 | 16644701418196291702703 | 0x7766eb408b671be8bc237639b20a0ec45e2750c7 | 93 | 111340028 | 2023-10-26T00:07:13.000Z | 0xc26e320c94ec8c1cef1353e471bcc33cb8454eff290f9387861231ae6bbc2784 |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 0xf686424d4f3572e4624bddf8a00fb77fe748237c | 76442045418920530509747 | 0x7766eb408b671be8bc237639b20a0ec45e2750c7 | 75 | 111340028 | 2023-10-26T00:07:13.000Z | 0xc26e320c94ec8c1cef1353e471bcc33cb8454eff290f9387861231ae6bbc2784 |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 0xdabd22f74cb002a6609dc9560e8b71b7e950c2d6 | 15420561906063619774 | 0x7766eb408b671be8bc237639b20a0ec45e2750c7 | 12 | 111340028 | 2023-10-26T00:07:13.000Z | 0xc26e320c94ec8c1cef1353e471bcc33cb8454eff290f9387861231ae6bbc2784 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Voter_DistributeReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voter\_GaugeCreated\_event
Gauge creation events emitted when new liquidity mining gauges are deployed for liquidity pools in vote-escrowed token (veToken) protocols. Links pool addresses to their corresponding gauge contracts and associated reward distribution mechanisms for governance-driven liquidity incentives.
| 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_poolFactory` | `STRING` | Contract address of the factory that deployed the liquidity pool associated with this gauge. This address remains constant across gauge creation events as Velodrome uses a single pool factory contract per deployment. |
| `in_votingRewardsFactory` | `STRING` | Contract address of the factory that deployed the voting rewards contracts for this gauge. This factory creates both bribe and fee voting reward contracts used in Velodrome's vote-escrowed governance system. |
| `in_gaugeFactory` | `STRING` | Contract address of the factory that deployed the gauge contract for this liquidity pool. This factory contract is responsible for standardized gauge creation on Velodrome V2. |
| `in_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_bribeVotingReward` | `STRING` | Contract address of the bribe voting reward contract created for this gauge on Velodrome V2. Incentivizes users who vote for allocating emissions to this liquidity pool gauge. |
| `in_feeVotingReward` | `STRING` | Contract address of the fee-based voting reward contract associated with this gauge on Velodrome V2. This contract distributes protocol fees to voters who allocated voting power to this gauge's liquidity pool. |
| `in_gauge` | `STRING` | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_creator` | `STRING` | Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_pool | removed | in\_gauge | log\_index | in\_creator | block\_number | in\_poolFactory | block\_timestamp | in\_gaugeFactory | transaction\_hash | in\_feeVotingReward | in\_bribeVotingReward | in\_votingRewardsFactory |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | 0xb90da30758b00e5f08e6c0b71bff122712d830cb | false | 0x9c3670f125278936f5d2d80c3d975bc0d8c7c721 | 2 | 0xbc306c15cad6459ebac7304365d4fed9b4daeb70 | 108941122 | 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | 2023-08-31T11:23:41.000Z | 0x8391fe399640e7228a059f8fa104b8a7b4835071 | 0x0e0e15fd7a9dcb0fccb746e296ef02c6d80b4b9640d45977122257cb31226327 | 0x5afd62198af789dd932682053c5169167f3c5668 | 0xe75e41ae504237e572385c802ca62cc6dc52b9f8 | 0x756e7c245c69d351fffbfb88ba234aa395ada8ec |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | 0x8e17f3d8dcece9e5f0af7daaacf5d2e637144a4e | false | 0x5ab6faf49f9132510ff1e355bba32fa3eb2d0f9b | 1 | 0xebfced2b9ca169d2ca566e1f72a75a9b6cc9291d | 108921156 | 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | 2023-08-31T00:18:09.000Z | 0x8391fe399640e7228a059f8fa104b8a7b4835071 | 0x3954aeed5eafd157a52c58ff4ac3eaf70515a3527f16825ec31770df6489ce52 | 0x0f01cba50fc52a704162846ac251791b4fb9ee7a | 0xfa374690963186bf4d0a1fada45c6a1d99714139 | 0x756e7c245c69d351fffbfb88ba234aa395ada8ec |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | 0xfff37730744930cb61be34c0014068f4f1ec28cf | false | 0x9647bc2cd383dec17d2a0b154c48c7a24db72640 | 3 | 0xc6387e937bcef8de3334f80edc623275d42457ff | 111408962 | 0xf1046053aa5682b4f9a81b5481394da16be5ff5a | 2023-10-27T14:25:01.000Z | 0x8391fe399640e7228a059f8fa104b8a7b4835071 | 0x94f94d2f2a1cd9d3c33258aac10a31e167514a45e04a03809f156b3ef95768e1 | 0x314d21c204d742dfe535fff546f40be19fdaa43b | 0x5b182ed8aed98dd53ae3d5dd7a1ce62da13acdcb | 0x756e7c245c69d351fffbfb88ba234aa395ada8ec |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Voter_GaugeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voter\_GaugeKilled\_event
Event logs recording the deactivation of gauge contracts from voting eligibility. Contains the gauge address that was removed from the active reward distribution set.
| 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_gauge` | `STRING` | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_gauge | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 0xe6b6e3806bb939bd7c6980bfd816b69816dade7b | 28 | 110498064 | 2023-10-06T12:21:45.000Z | 0x09509f543864e393ea61926d36ae2b9f599fc3bcb14b2816dd9770b268788dd5 |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 0xcc1a390ee7fdec5f7a89e706c2235c8037f779ee | 29 | 110498064 | 2023-10-06T12:21:45.000Z | 0x09509f543864e393ea61926d36ae2b9f599fc3bcb14b2816dd9770b268788dd5 |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 0x68950e787b9ded31d4e2b2418d7c09fddf4d32bb | 31 | 110498064 | 2023-10-06T12:21:45.000Z | 0x09509f543864e393ea61926d36ae2b9f599fc3bcb14b2816dd9770b268788dd5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Voter_GaugeKilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voter\_NotifyReward\_event
Reward distribution events emitted when tokens are allocated to voting gauges in Decentralized Exchange (DEX) voter contracts. Records the sender address, reward token contract, and token amount distributed to incentivize liquidity provision and governance participation.
| 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_reward` | `STRING` | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_amount | in\_reward | in\_sender | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | -------------------------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 13980980218604850000000000 | 0x9560e827af36c94d2ac33a39bce1fe78631088db | 0x6dc9e1c04ee59ed3531d73a72256c0da46d10982 | 11 | 108315949 | 2023-08-17T00:04:35.000Z | 0x291580819b8ac31d477c0c96f23e6ac93b95cfd6b0b5a21c581e9a0bcfde9335 |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 12145918023318878432704596 | 0x9560e827af36c94d2ac33a39bce1fe78631088db | 0x6dc9e1c04ee59ed3531d73a72256c0da46d10982 | 27 | 112549493 | 2023-11-23T00:02:43.000Z | 0xd4d4ac741ee6e6ce675bb505bda2aeca42fa122b20521109425916803e6616ff |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | 13162815344984519817783194 | 0x9560e827af36c94d2ac33a39bce1fe78631088db | 0x6dc9e1c04ee59ed3531d73a72256c0da46d10982 | 35 | 110130260 | 2023-09-28T00:01:37.000Z | 0x7e6453272d1dd6b0e3cf3ae4c5c6d10d3e05c771d82245fa1204d0ce18740ddd |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Voter_NotifyReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voter\_Voted\_event
Governance voting events recording weight allocation to liquidity pools or gauges. Contains voter address, target pool, and voting power in wei-denominated values for tracking vote distribution in vote-escrowed token systems.
| 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_voter` | `STRING` | Address of the account casting the vote or participating in governance. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
| `in_weight` | `STRING` | Voting power or gauge weight allocated to a pool or account. Numeric string representation of wei-denominated value. |
| `in_totalWeight` | `STRING` | Total voting weight allocated to the pool across all voters after this vote transaction. Represented as a string-encoded integer in the smallest token unit. |
| `in_timestamp` | `STRING` | Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch. |
| address | in\_pool | removed | in\_voter | in\_weight | log\_index | in\_tokenId | block\_number | in\_timestamp | in\_totalWeight | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------- | ---------- | ----------- | ------------- | ------------- | -------------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | 0x5954e5b20260c0cdd35c93bbda98d1f2c5abecaf | false | 0xfd90ad81ad93d9af1008a513d964f6fbc589034d | 193793528516691448576727 | 27 | 2951 | 110994431 | 1697587639 | 25256253950349589275675344 | 2023-10-18T00:07:19.000Z | 0xe1f26640a46d014a6b3551563c789800e0db4702c4d24bcede9b6a3b4df5005d |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | 0x5954e5b20260c0cdd35c93bbda98d1f2c5abecaf | false | 0xc877f7c4c1605692226888f884a823cfb8eb11bd | 62989731063627574020523 | 12 | 2690 | 110994674 | 1697588125 | 25287748815881403062685606 | 2023-10-18T00:15:25.000Z | 0x0fe4dbd19d032c42703975ee949c2dabc62030697d2c60c12b0272baf152fa31 |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | 0x5954e5b20260c0cdd35c93bbda98d1f2c5abecaf | false | 0xc877f7c4c1605692226888f884a823cfb8eb11bd | 2200866423233621136537466 | 28 | 1270 | 110994678 | 1697588133 | 26393358523597672320699370 | 2023-10-18T00:15:33.000Z | 0x04b724da28d595811b050f1f7f4cef1d5c1a5cefdb92bf5f51a0ddb110ad6d86 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Voter_Voted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voter\_WhitelistNFT\_event
NFT (non-fungible token) whitelist status changes from Velodrome V2's Voter contract on Optimism, tracking which token IDs are authorized by whitelister addresses. Used for analyzing governance permissions and NFT-based access control in the DEX (decentralized exchange) protocol.
| 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_whitelister` | `STRING` | Address of the account that performed the whitelisting action for the NFT token. Hex-encoded, 0x-prefixed 40-character Optimism address that initiated the whitelist status change. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
| `in__bool` | `BOOL` | Indicates whether the NFT token was added to (true) or removed from (false) the whitelist by the whitelister address. Based on sample data, all observed events show additions to the whitelist. |
| address | removed | in\_\_bool | log\_index | in\_tokenId | block\_number | in\_whitelister | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ---------- | ----------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | true | 3 | 19490 | 111635022 | 0xba4bb89f4d1e66aa86b60696534892ae0ccf91f5 | 2023-11-01T20:00:21.000Z | 0x78f21bbb0897ff3675ecd29f5f85c740d88094d14a02948976d1058542fcb954 |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | true | 4 | 19491 | 111635022 | 0xba4bb89f4d1e66aa86b60696534892ae0ccf91f5 | 2023-11-01T20:00:21.000Z | 0x78f21bbb0897ff3675ecd29f5f85c740d88094d14a02948976d1058542fcb954 |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | true | 3 | 20276 | 113661737 | 0xba4bb89f4d1e66aa86b60696534892ae0ccf91f5 | 2023-12-18T17:57:31.000Z | 0xf771084c3baac4e557cb1360f539269e0be66886cd108f2266a62f8ab4f0e953 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Voter_WhitelistNFT_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voter\_WhitelistToken\_event
Token whitelist status changes in Velodrome V2's governance Voter contract on Optimism, tracking which tokens are approved for emissions voting. Used for analyzing governance token eligibility and protocol-approved asset additions or removals 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_whitelister` | `STRING` | Address of the account that executed the whitelist operation for the token. This is typically a governance or admin address authorized to manage Velodrome's token whitelist. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__bool` | `BOOL` | Indicates whether the token was whitelisted (true) or removed from the whitelist (false) in the Velodrome V2 voting system. This boolean flag determines the token's eligibility for gauge voting incentives on Optimism. |
| address | removed | in\_\_bool | in\_token | log\_index | block\_number | in\_whitelister | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | true | 0xc03b43d492d904406db2d7d57e67c7e8234ba752 | 18 | 107695941 | 0xba4bb89f4d1e66aa86b60696534892ae0ccf91f5 | 2023-08-02T15:37:39.000Z | 0xbba18ed95a26102c78bb5cd4409ac45ce5cdadd5a8361ffa77e59e81c4c6559d |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | false | 0x88a89866439f4c2830986b79cbe6f69d1bd548bb | 60 | 109423158 | 0xba4bb89f4d1e66aa86b60696534892ae0ccf91f5 | 2023-09-11T15:11:33.000Z | 0xabc463a6e701b2ed71f2a2bb2b8b0dd79e2abb43800c16f475a12c0f1e1b660d |
| 0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c | false | true | 0x9dabae7274d28a45f0b65bf8ed201a5731492ca0 | 56 | 109423113 | 0xba4bb89f4d1e66aa86b60696534892ae0ccf91f5 | 2023-09-11T15:10:03.000Z | 0x1fcb1d006fec1038cb5e5b7529fc3c102432fcc593886c28813dc703d2d7189e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.velodrome_v2_optimism.Voter_WhitelistToken_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***