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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

address	removed	log_index	block_number	in_feeManager	block_timestamp	transaction_hash
0xf1046053aa5682b4f9a81b5481394da16be5ff5a	false	0	105896960	0xba4bb89f4d1e66aa86b60696534892ae0ccf91f5	2023-06-22T00:11:37.000Z	0xe9dda913dc26db046248a5a0c1deac0115f319fb096dc190a95022dadebb2788

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

address	removed	in_pauser	log_index	block_number	block_timestamp	transaction_hash
0xf1046053aa5682b4f9a81b5481394da16be5ff5a	false	0xba4bb89f4d1e66aa86b60696534892ae0ccf91f5	0	105896939	2023-06-22T00:10:55.000Z	0xcb5c923fc5d45838b67cee0f12aafb7790ba6bf056d396703157fed1866e88b6

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	removed	in_voter	log_index	block_number	block_timestamp	transaction_hash
0xf1046053aa5682b4f9a81b5481394da16be5ff5a	false	0x41c914ee0c7e1a5edcd0295623e6dc557b5abf3c	0	105896964	2023-06-22T00:11:45.000Z	0x86d20722c63d12e58faf73625bc1cfaab204db6bcd7efb46db66798850113bdb

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

bribeVotingReward_ClaimRewards_event

bribeVotingReward_Deposit_event

bribeVotingReward_NotifyReward_event

bribeVotingReward_Withdraw_event

Factory_PoolCreated_event

Factory_SetCustomFee_event

Factory_SetFeeManager_event

Factory_SetPauser_event

Factory_SetVoter_event

Gauge_ClaimFees_event

Gauge_ClaimRewards_event

Gauge_Deposit_event

Gauge_NotifyReward_event

Gauge_Withdraw_event

Pool_Burn_event

Pool_Claim_event

Pool_Fees_event

Pool_Mint_event

Pool_Swap_event

Pool_Sync_event

Pool_Transfer_event

Voter_Abstained_event

Voter_DistributeReward_event

Voter_GaugeCreated_event

Voter_GaugeKilled_event

Voter_NotifyReward_event

Voter_Voted_event

Voter_WhitelistNFT_event

Voter_WhitelistToken_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​bribeVotingReward_ClaimRewards_event

​bribeVotingReward_Deposit_event

​bribeVotingReward_NotifyReward_event

​bribeVotingReward_Withdraw_event

​Factory_PoolCreated_event

​Factory_SetCustomFee_event

​Factory_SetFeeManager_event

​Factory_SetPauser_event

​Factory_SetVoter_event

​Gauge_ClaimFees_event

​Gauge_ClaimRewards_event

​Gauge_Deposit_event

​Gauge_NotifyReward_event

​Gauge_Withdraw_event

​Pool_Burn_event

​Pool_Claim_event

​Pool_Fees_event

​Pool_Mint_event

​Pool_Swap_event

​Pool_Sync_event

​Pool_Transfer_event

​Voter_Abstained_event

​Voter_DistributeReward_event

​Voter_GaugeCreated_event

​Voter_GaugeKilled_event

​Voter_NotifyReward_event

​Voter_Voted_event

​Voter_WhitelistNFT_event

​Voter_WhitelistToken_event

Tables

bribeVotingReward_ClaimRewards_event

bribeVotingReward_Deposit_event

bribeVotingReward_NotifyReward_event

bribeVotingReward_Withdraw_event

Factory_PoolCreated_event

Factory_SetCustomFee_event

Factory_SetFeeManager_event

Factory_SetPauser_event

Factory_SetVoter_event

Gauge_ClaimFees_event

Gauge_ClaimRewards_event

Gauge_Deposit_event

Gauge_NotifyReward_event

Gauge_Withdraw_event

Pool_Burn_event

Pool_Claim_event

Pool_Fees_event

Pool_Mint_event

Pool_Swap_event

Pool_Sync_event

Pool_Transfer_event

Voter_Abstained_event

Voter_DistributeReward_event

Voter_GaugeCreated_event

Voter_GaugeKilled_event

Voter_NotifyReward_event

Voter_Voted_event

Voter_WhitelistNFT_event

Voter_WhitelistToken_event