velodrome_v1_optimism

Tables

Gauge_ClaimFees_event

Fee claim events from Velodrome V1 liquidity gauge contracts on Optimism, recording when liquidity providers withdraw accumulated trading fees from their staked positions. Tracks claimed amounts for both tokens in each pair along with the recipient address and gauge contract.

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 token0 claimed as fees from the Velodrome gauge by the specified address, denominated in the token’s smallest unit (wei for most tokens). This value represents accumulated trading fees distributed to liquidity providers or stakers.
`in_claimed1`	`STRING`	Amount of the second token (token1) claimed as fees from the Velodrome gauge, denominated in the token’s smallest unit (wei). This value represents accumulated trading fees from the liquidity pool’s token1 that the claimer is collecting.

Sample Data

address	in_from	removed	log_index	in_claimed0	in_claimed1	block_number	block_timestamp	transaction_hash
0x69c9aa3aee75558ecb32c8a3b28b579004c4748b	0x09236cff45047dbee6b921e00704bed6d6b8cf7e	false	10	56127868991564	106852001770216448	12992850	2022-06-25T04:36:25.000Z	0x58f64c0ed8d4900dcb4ecaff01474e6a98800a470a0505277360bcb015a37403
0x3b9ce26a8527b1c2f92e8d60ed920c7dae77bbdd	0x09236cff45047dbee6b921e00704bed6d6b8cf7e	false	6	2051	766137868570622	13042053	2022-06-25T13:35:06.000Z	0x6151990a88c25173bc0c7107a94fe35c040590eab584575382df5f0d28fc4071
0xc7bb5b7c35f48ea077fb9c2f8825102110a6ec29	0x09236cff45047dbee6b921e00704bed6d6b8cf7e	false	6	24918	22119076726237942	13039874	2022-06-25T13:08:37.000Z	0x1e8f270ac40259e0ac408b90c51617f299a2f4726ecbd808ab135fa44c8d49db

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.velodrome_v1_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_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
0x0299d40e99f2a5a1390261f5a71d13c3932e214c	0x8ed16e19f2ae9142abf9221c08a384a568dfc710	false	447209043076386762734	0x3c8b650257cfb5f272f799f5e2b4e65093a11a05	1	10765554	2022-06-06T18:23:52.000Z	0x170913f1b3f995295fa25fa7e43dbcb87022f24e7c5c36b09fb5df84b48adf8f
0x0299d40e99f2a5a1390261f5a71d13c3932e214c	0xf116569b3f888d639372a5485685a6d8ee28a593	false	112173761025143716289	0x3c8b650257cfb5f272f799f5e2b4e65093a11a05	1	10748546	2022-06-06T14:38:02.000Z	0x13917ed694d144d33e10e415042be28be9ea04fe93202bfc46b18dc54bfdbffe
0x0299d40e99f2a5a1390261f5a71d13c3932e214c	0xadc1d13acf57ea12cdf14679177fd669221adf2c	false	660757601983623417859	0x3c8b650257cfb5f272f799f5e2b4e65093a11a05	1	10759613	2022-06-06T16:54:02.000Z	0x289c8df22d2d8817762767b80e30fbdd25a4a5ec66c4dec7b26ff2141b5ea9e3

Example Query

Query with partition filter

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

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) 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_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.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xb59cdf2ec741a7f905c15a21aff9e4f884f9c31a	0x06141423dcf1a5a4c137039063ac873cdc1e363a	false	0x9c12939390052919af3155f41bf4160fd3666a6f	5	1056998101941179426246	18988326124603544	37782186	2022-11-13T12:32:44.000Z	0x4801017fcd158c83c120c26da10444e2b24a1b2e086573eaca2396d51383e23b
0x1740735d7ff5790024d6bcaa69589b14b2c394e9	0x06141423dcf1a5a4c137039063ac873cdc1e363a	false	0x9c12939390052919af3155f41bf4160fd3666a6f	5	1093574267289900615837	20025320921903453	37904941	2022-11-13T23:35:21.000Z	0x044ab6216ac350dbd5861f51731add1c3ffae49d8243d381e1fea3093b3e701d
0xdfc1ab69cf949dcd000069ec8a9d25df01bb1385	0x078f65c0e854ab7fa3baa2cff62a4f9cb4031382	false	0x9c12939390052919af3155f41bf4160fd3666a6f	5	20093901	20099999844351310970	37706791	2022-11-13T08:01:22.000Z	0x3bc41685e4814b4325ff4bd6978bbf70bfa846b89f730fc676c45047ebb32dd9

Example Query

Query with partition filter

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

Pair_Claim_event

Claim events from liquidity pool pair contracts recording amounts of both tokens withdrawn by liquidity providers. Tracks sender address, recipient address, and claimed amounts in smallest token denomination for both token0 and token1.

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
0xf8edf2da8fcf610cf77235d3f90cc110723159aa	false	0x59bc700acd8826675c3b729794b1647978be2d7f	2	38710498213837779817	2557176736451581249	17894767	0x59bc700acd8826675c3b729794b1647978be2d7f	2022-08-05T14:04:47.000Z	0xbeec6fe97de7be917ff0805c8cff648b2857634d0b76162220483eb8ad13a1f8
0x6dd153c14c9f4417c786b35ef9c870d8d3465565	false	0x3b6b729e32ed640c05c7dc790324bddc961e1a18	2	31110289477123736	13267793829632165	17803437	0x3b6b729e32ed640c05c7dc790324bddc961e1a18	2022-08-05T05:35:39.000Z	0x1243c469b5cd4e5333aa04d0814de98f810f18e68aee58ba545ada4a22a78091
0xea9e6730d15d899b166e992956b6dcaedb4afda8	false	0x6ab1a7a258718e49fbd65b0fe86a1c36a34a23a8	2	2731135830620	2829911565640618	17813310	0x6ab1a7a258718e49fbd65b0fe86a1c36a34a23a8	2022-08-05T06:45:50.000Z	0x2eb7737c24d2770d5d1e8a27db42692bd4d58f05d49cc71afea3912ffeb3617c

Example Query

Query with partition filter

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

Pair_Fees_event

Trading fee collection events from Automated Market Maker (AMM) liquidity pairs recording fee amounts in both token0 and token1 denominations. Used for tracking protocol revenue and liquidity provider earnings across decentralized exchange 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_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
0xcc441718f7f50d55f497fd37e3f3f3fe4789cf6b	false	0x0825b2f46dbba2d05cfc1879fe91e2b360733766	21	14572629657689	0	115276546	2024-01-25T03:04:29.000Z	0xbe8d0c1cc93efe6e83a8cf9a934adf8471adc1b3d3229a393bef438858ceb5f0
0x06141423dcf1a5a4c137039063ac873cdc1e363a	false	0x0825b2f46dbba2d05cfc1879fe91e2b360733766	37	0	13332614616472	115280902	2024-01-25T05:29:41.000Z	0x60864ee63095931120d5287b652216acab74fcc5378cdd65253488157e41fb54
0xe8537b6ff1039cb9ed0b71713f697ddbadbb717d	false	0x0825b2f46dbba2d05cfc1879fe91e2b360733766	28	682730052235482754	0	115280902	2024-01-25T05:29:41.000Z	0x3f1755b1fa393b6db657d9dcfd9234d4a266c69412a5a4cfce977e00fbf1ff35

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

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
0x050d6dbc73f6993a29e1327846117c4f5fc7d68e	false	0x9c12939390052919af3155f41bf4160fd3666a6f	6	31505584000000000000	107318174170128063391	80637670	2023-03-13T20:42:20.000Z	0x48eb1a00f56930adf3b354689fc02c3dd5820cd33e1fdaf50dd08a5417cf7cb3
0x050d6dbc73f6993a29e1327846117c4f5fc7d68e	false	0x9c12939390052919af3155f41bf4160fd3666a6f	6	1314067975250698362	1721797054265130312	80404509	2023-03-13T00:21:23.000Z	0xd0e15467402c054a4070b040730c99f03d38c344b4a49359c637709fb4da8af4
0x050d6dbc73f6993a29e1327846117c4f5fc7d68e	false	0x9c12939390052919af3155f41bf4160fd3666a6f	6	2330154563035213319	3067710458827719845	80414127	2023-03-13T01:04:03.000Z	0x05cb4c1feb19ec3e2861b9feff42cefe251e8986a49b724ac734af612129acc5

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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_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`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount1In	in_amount0Out	block_timestamp	transaction_hash
0x03013cb348417559cb849d38befcecc51956bdb8	0xc899c4d73ed8df2ead1543ab915888b0bf7d57a2	false	0x03013cb348417559cb849d38befcecc51956bdb8	6	109841761	168588302	2072090005915357249521	2023-09-21T07:44:59.000Z	0x137347fe6f765d5456183732dffeca3762fa79667e9702c58c67f7ac50209267
0x03013cb348417559cb849d38befcecc51956bdb8	0x79c912fef520be002c2b6e57ec4324e260f38e50	false	0x03013cb348417559cb849d38befcecc51956bdb8	10	109830477	31864975	19692104200584871	2023-09-21T01:28:51.000Z	0x76fb7cba7fae11d68376a5449464a718d3a937084cebe6ceb02cac36ab296288
0x03013cb348417559cb849d38befcecc51956bdb8	0x47029bc8f5cbe3b464004e87ef9c9419a48018cd	false	0x03013cb348417559cb849d38befcecc51956bdb8	5	109839513	525967843	395257551739660517599	2023-09-21T06:30:03.000Z	0xe03d2dcc15911c3be341d5312fbb51e42cb9d75174cc252f5978b05ce03e173d

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

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
0xe75a3f4bf99882ad9f8aebab2115873315425d00	false	125	1892912957	2539875633077289322690	111837439	2023-11-06T12:27:35.000Z	0xeecf7ef938ed06a353e7d40d19015b5c842baeb1f802a02f9baa00155b39b296
0xe75a3f4bf99882ad9f8aebab2115873315425d00	false	119	1912790003	2519885633077289322690	111837439	2023-11-06T12:27:35.000Z	0xeecf7ef938ed06a353e7d40d19015b5c842baeb1f802a02f9baa00155b39b296
0xe75a3f4bf99882ad9f8aebab2115873315425d00	false	68	1932892957	2499689004461201148520	111852820	2023-11-06T21:00:17.000Z	0x9da3fa5a5b80e033c5dae927f21cd7d90639acd3387dcde656e88c7c9d7f0c8a

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.

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
0xa77ae94fd4a89b787d638325f79294353cc23859	0x06141423dcf1a5a4c137039063ac873cdc1e363a	0x0000000000000000000000000000000000000000	false	114389722268600427	32	20694673	2022-08-26T21:08:00.000Z	0xb4b279c0744167eaff7f95b680a98c6e227195471e1a8def7a4f2bd1b7e99765
0x0aaf1de71910d9f2be10e6c75b3eb6eca377cbf2	0x06141423dcf1a5a4c137039063ac873cdc1e363a	0xa77ae94fd4a89b787d638325f79294353cc23859	false	114389722268600427	35	20694673	2022-08-26T21:08:00.000Z	0xb4b279c0744167eaff7f95b680a98c6e227195471e1a8def7a4f2bd1b7e99765
0x0aaf1de71910d9f2be10e6c75b3eb6eca377cbf2	0x06141423dcf1a5a4c137039063ac873cdc1e363a	0xaff67afde8fc7910a04e8461ebeaaee6aea851ac	false	123287857884492838	14	20615288	2022-08-26T10:15:59.000Z	0x90de6fdba0b31a0ccc071be001759c20bbbb0c6ac8d4eaeae3a02b0af3132e33

Example Query

Query with partition filter

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

PairFactory_PairCreated_event

Event logs emitted when a new liquidity pool pair is created by a DEX (Decentralized Exchange) factory contract. Records the deployed pair contract address, constituent token addresses, and creation metadata for tracking protocol liquidity expansion.

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_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. 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_pair	removed	in_anon4	in_stable	in_token0	in_token1	block_number	block_timestamp	transaction_hash
0x25cbddb98b35ab1ff77413456b31ec81a6b6b746	0x6798dc2f6530923eb630256f57cf83cb06c3cc61	false	331	false	0x76fb31fb4af56892a25e32cfc43de717950c9278	0x7f5c764cbc14f9669b88837ca1490cca17c31607	39148336	2022-11-17T22:55:48.000Z	0xdbef186bb393da55de732c52e2b50b0ddef5a5ee73a5f6bd87ad6bf6af0ac785
0x25cbddb98b35ab1ff77413456b31ec81a6b6b746	0xac57f288493fccec2b37e26fd9d9f399db9fef6c	false	330	false	0x676f784d19c7f1ac6c6beaeaac78b02a73427852	0x73cb180bf0521828d8849bc8cf2b920918e23032	39120625	2022-11-17T19:27:34.000Z	0x749757ec59c1edbbcf975a95cac95fc9ba78ce8fffa813500ec53ec8177baff8
0x25cbddb98b35ab1ff77413456b31ec81a6b6b746	0x2b97ed5784fca82b90c8998b7ca01fbb8a6715fa	false	193	false	0x3f56e0c36d275367b8c502090edf38289b3dea0d	0x7f5c764cbc14f9669b88837ca1490cca17c31607	21479958	2022-09-01T07:55:27.000Z	0x2d8a1bfb29270289f78d61ff7e3c5a27f12a73b97334e89c4bade8e08d73847a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.velodrome_v1_optimism.PairFactory_PairCreated_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_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.
`in_internal_bribe`	`STRING`	Contract address of the internal bribe contract associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.
`in_external_bribe`	`STRING`	Contract address of the external bribe contract associated with the gauge. 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.

Sample Data

address	in_pool	removed	in_gauge	log_index	in_creator	block_number	block_timestamp	transaction_hash	in_external_bribe	in_internal_bribe
0x09236cff45047dbee6b921e00704bed6d6b8cf7e	0x82cdd997fd9912c99133d1f8af9d2bf9296d5518	false	0xa3fa84af6d3cfb0bb531686e3c286e4dbc34ce8e	1	0x9017cbc34991f97694d5de56b9072591e4e10062	17899067	2022-08-05T14:24:26.000Z	0x5e57734670f93935a9ec9b8cf9cb2edae518f781674666dab8554aae8c166a07	0x1111996061a83a250855fc186f787797c6df4bb8	0xf3a59c8b6639e98891899410f12ff6e35c91a009
0x09236cff45047dbee6b921e00704bed6d6b8cf7e	0xbf9dd15a88fd489b92373bfb71db101d286d6ba3	false	0x8960e1978b1b1dbe7451f13ab3b90bc0ac39b1aa	1	0x20b92b34214a643aa620e80fdfaae25138612af8	77366949	2023-02-26T20:51:19.000Z	0xb7ec1dea67a3de11155abdbe791ccb425b641509021c5b98d88b5dcfe78c6fb1	0xb68fcfb72afcdd27fbc044f758f65a5e19acaf40	0x7dbc8152e26509b817e29e96ca805eb2729d97d0
0x09236cff45047dbee6b921e00704bed6d6b8cf7e	0x9fe66aef626b3304cf736c71cc6077e03a285b45	false	0x5a7dded66fcccf470deac3c70d7a5089d074fbcc	1	0x1371d3038d35e9406f7ce55df1db4c6302704f10	77201781	2023-02-26T07:08:47.000Z	0x54250e91a915a0aa116dfb2d515f36b97da28ff5923ee551fe2cf3cb5573a0b5	0x146e86bf5687bbb8639e2ad26f88685d4ef1fcd5	0x5976f6d30ecfb7760c4bc28d8e2462cbf1dac94e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Gauge_ClaimFees_event

Gauge_ClaimRewards_event

Pair_Burn_event

Pair_Claim_event

Pair_Fees_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event

Voter_GaugeCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Gauge_ClaimFees_event

​Gauge_ClaimRewards_event

​Pair_Burn_event

​Pair_Claim_event

​Pair_Fees_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

​PairFactory_PairCreated_event

​Voter_GaugeCreated_event

Tables

Gauge_ClaimFees_event

Gauge_ClaimRewards_event

Pair_Burn_event

Pair_Claim_event

Pair_Fees_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event

Voter_GaugeCreated_event