solidlizard_v1_arbitrum

Tables

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.
`in_recepient`	`STRING`	Wallet address receiving the claimed reward tokens from the Solidlizard gauge contract. Typically matches `in_from`, indicating users claim rewards to their own address.

Sample Data

address	in_from	removed	in_amount	in_reward	log_index	block_number	in_recepient	block_timestamp	transaction_hash
0x0322cebacf1f235913be3fce407f9f81632ede8b	0x408baf59e27a83740ff426d0bc8c1319f30720c7	false	1363812142482561674847	0x463913d3a3d3d291667d53b8325c598eb88d3b0e	10	199270995	0x408baf59e27a83740ff426d0bc8c1319f30720c7	2024-04-09T16:12:34.000Z	0xdf0a3dbf9307e29ebd6f08a807b4932f221ec1b4f7c60f04916523778a501e6c
0x12981565263628164cdfa32290ebccdbd7e5cca4	0x8e2f7d5aaae5abbd5052acb74019b9b11cb74349	false	5508353033085301568647	0x463913d3a3d3d291667d53b8325c598eb88d3b0e	2	199329864	0x8e2f7d5aaae5abbd5052acb74019b9b11cb74349	2024-04-09T20:19:04.000Z	0xd3e937d1e682be559a82afa497136659398199c79cdc113ffed075fcfbaac914
0x12981565263628164cdfa32290ebccdbd7e5cca4	0x8e2f7d5aaae5abbd5052acb74019b9b11cb74349	false	5860005443385838938610	0x463913d3a3d3d291667d53b8325c598eb88d3b0e	2	199119134	0x8e2f7d5aaae5abbd5052acb74019b9b11cb74349	2024-04-09T05:35:05.000Z	0xad9b36abd8cb3b33b255d9dfa854acb639908a77c8ab19da5c63d0883a7d671b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solidlizard_v1_arbitrum.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
0x3b8950c11dc7d883239724d89bd7765ce693db0f	0xced06c9330b02c378c31c7b12570b1c38abfcea6	false	0xf26515d5482e2c2fd237149bf6a653da4794b3d0	6	24943453774979393	44300411999415003363	100369778	2023-06-12T10:32:48.000Z	0x2913aaa66d509d64abbdbbc9da93f0a9792940ab1b25deb8316d1af32ecce00c
0xfbe12d942b8c152248fd118f598c08124ff3d7de	0x5d6bfc8f54a2d9196904e44c3a4fbcfd62cb8ce5	false	0xf26515d5482e2c2fd237149bf6a653da4794b3d0	6	3777828822535050523098	23275160	100334363	2023-06-12T08:05:36.000Z	0x0205e6ecc8fc62530fb7c8c78c79362f4533ef30274ded786679cdd32a1a5160
0xfbe12d942b8c152248fd118f598c08124ff3d7de	0x5cf76ae6ac0d07ea9ec16c59dbb23a768adbca70	false	0xf26515d5482e2c2fd237149bf6a653da4794b3d0	6	53711344548948574044404	110017519	100337308	2023-06-12T08:17:59.000Z	0xe4a510f865f2251343caba003ea70621e65768727dc07c42cebc72184fcd945f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solidlizard_v1_arbitrum.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
0x6460492ff9fed7acfd6b690a049239d526404406	false	0x7fdf2877ee9a2a3d268ee04d87a5a4f46e9d0acb	11	0	5573129614328132908	142595449	0x7fdf2877ee9a2a3d268ee04d87a5a4f46e9d0acb	2023-10-21T12:28:26.000Z	0x8bf9bcedee4c7d2615b34219b7256c50d39c88202d4fcff34aeb33a4cb441887
0x32242bcc946aed908934a3bfd7ed7e02f928e224	false	0x471b36c1d03c8155b06343b879f45e542d01832f	11	4964393388386984869	15751820373119966	142595347	0x471b36c1d03c8155b06343b879f45e542d01832f	2023-10-21T12:28:00.000Z	0x7c9cb45756af8fada2e89b6bc7b869add7787b43acf3cd976ee1a786b302e57e
0xccbde15521fd593530cded2b7c53f46b7322d6ac	false	0x3dcb41313daf6c0095f5bcd0f1ba387c610b45c5	1	8802198820108	0	142595497	0x3dcb41313daf6c0095f5bcd0f1ba387c610b45c5	2023-10-21T12:28:38.000Z	0xa6f3bebdb725189b9501748360c5b1882a9ec60b94ff35a33a44917443a29375

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solidlizard_v1_arbitrum.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_amount1	block_number	block_timestamp	transaction_hash
0xf8ba0b028e8308dbcb046019326fbaa9ec4110d8	false	0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd	11	14113509573083	242923868	2024-08-14T22:43:44.000Z	0xad2a6d38a7a3acf2fa5fe3a48b842512297ed329c7883ac80e129eb0a959ea35
0xf8ba0b028e8308dbcb046019326fbaa9ec4110d8	false	0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd	9	7341338143077	242939476	2024-08-14T23:49:28.000Z	0xa4d41862b29dd0139fa9a0ae5265bcfebfaaf63d6acae77f83b1bbf5941cbba2
0xdf7386dbbd132dd248be37e9301cb01e3304c2ca	false	0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd	11	2368923979342421583	242830109	2024-08-14T16:11:11.000Z	0x95f5f02c4162d36a5c7688eb15eec6a3bc45cf47f20f4c4fae168b7d882b642b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solidlizard_v1_arbitrum.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
0x4c405a69eb3048423943a131d9c2540f74c7d10f	false	0xf26515d5482e2c2fd237149bf6a653da4794b3d0	66	269328214	295999999	292063803	2025-01-05T00:14:32.000Z	0x9da41ed8eff236172bb742e5e0e04bfda14823b8d14604e5a05a8305339ec18b
0x07d7f291e731a41d3f0ea4f1ae5b6d920ffb3fe0	false	0xf26515d5482e2c2fd237149bf6a653da4794b3d0	5	100000000000000000	99237	60394737	2023-02-12T23:52:08.000Z	0x778e9d1520323f8c6e6b497ab7dfe487898fbd19cd7604493841c7cae886fc12
0x13a5051d59d798809fac68af954fd82c7f568685	false	0xf26515d5482e2c2fd237149bf6a653da4794b3d0	5	3306552204951470293321	69744000000000000	60286296	2023-02-12T15:04:13.000Z	0x0740347a55d404c2c4cb82ab96e2d6e6a5a7c6d65668f04b0ac5cc836caf224c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solidlizard_v1_arbitrum.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_amount0In	in_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash
0x30c14facbf36dc93c2ea4d579851f1d14faa2d46	0x07d7f291e731a41d3f0ea4f1ae5b6d920ffb3fe0	false	0xf26515d5482e2c2fd237149bf6a653da4794b3d0	43	117785772	3360000000000000000000	0	0	3359472629	2023-08-03T15:51:08.000Z	0x25cd73054054b1f4d122ba0be5ba83fa717a017902c20594ac26537e4019a9dd
0x7cdfa244edb25a0cbce03579e5da2e24fd998cc2	0x9e7fb82fdf08a6aaba760a81f0a64602af045d2a	false	0x7e3e803e966291ee9aa69e6fada116cd07462e5d	19	117781748	0	11664748	6476548887646608596540	0	2023-08-03T15:34:12.000Z	0x15fa5b300fa0bfed4cf1095f331e85d2d4818bb108333078cc881d5ab67e4dc0
0x78e125480efdd4cdb1fb562be50f7f18741e79a6	0x5f304b844da3e7a444c896e7ee26f419fdbcc777	false	0xf26515d5482e2c2fd237149bf6a653da4794b3d0	22	117650258	41290517665925639755	0	0	69190594250077598	2023-08-03T06:22:28.000Z	0x92255ab3d1e2a7a9643556a429fa8d8bde13dc65ff22c02e00e57ca41f816566

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solidlizard_v1_arbitrum.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
0x01a9be7dc8bab17e37b21306aa130d01ecb8c863	false	11	253110026713228815006392	2884549608786178223	80577841	2023-04-15T03:32:52.000Z	0x6536522dfbbfb77fe97fb3781bae097b9d57a506e678bcb43124a38c0b612899
0x01a9be7dc8bab17e37b21306aa130d01ecb8c863	false	6	255233026713228815006392	2908744220508895054	80708568	2023-04-15T12:38:37.000Z	0x91eb7424857f22435e3db6dac7bde3ea7c5ba5aa6a289ae1e70c37b10bc1af2c
0x037691f9acf2afa5d376dbbc016ea57d67803bdb	false	4	5758202218435683455600	3805420730944876267275	80654724	2023-04-15T08:56:04.000Z	0x4089bbc4991f8517e4150d293f5323bad5c02e657b382ebe82d503362eba2fdc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solidlizard_v1_arbitrum.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_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
0x1d07077cbbfbcca024807ffdba42a2f316ed934e	0x07d7f291e731a41d3f0ea4f1ae5b6d920ffb3fe0	0x0000000000000000000000000000000000000000	false	14584622636	55	117854245	2023-08-03T20:43:39.000Z	0x8910b914747f613c78edb6616bc527b3e9d317c67aed29491acf092399278ec1
0x884c28296b6ec728ac27bfe7579419709514d154	0x07d7f291e731a41d3f0ea4f1ae5b6d920ffb3fe0	0x408baf59e27a83740ff426d0bc8c1319f30720c7	false	14584622636	60	117854245	2023-08-03T20:43:39.000Z	0x8910b914747f613c78edb6616bc527b3e9d317c67aed29491acf092399278ec1
0x408baf59e27a83740ff426d0bc8c1319f30720c7	0x07d7f291e731a41d3f0ea4f1ae5b6d920ffb3fe0	0x1d07077cbbfbcca024807ffdba42a2f316ed934e	false	14584622636	58	117854245	2023-08-03T20:43:39.000Z	0x8910b914747f613c78edb6616bc527b3e9d317c67aed29491acf092399278ec1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solidlizard_v1_arbitrum.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_allPairsLength`	`STRING`	Total number of liquidity pairs that have been created through the SolidLizard factory up to this point. This counter increments with each new pair creation event, providing a sequential identifier.

Sample Data

address	in_pair	removed	in_stable	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash	in_allPairsLength
0x734d84631f00dc0d3fcd18b04b6cf42bfd407074	0x7b660621409eee5518c78766182e8a4d639d1a1d	false	false	0xad435674417520aeeed6b504bbe654d4f556182f	0xd22a58f79e9481d1a88e00c343885a588b34b68b	3	71628525	2023-03-20T02:30:34.000Z	0x44d64540d42497d8dc5cafc700c8dc76eb050a3a1244e58d4c5678addb7ba8ef	125
0x734d84631f00dc0d3fcd18b04b6cf42bfd407074	0xc373925f0ce5e72c4bccffb1627c4760fe5f1ac3	false	true	0x463913d3a3d3d291667d53b8325c598eb88d3b0e	0xd740e693483ecec9c4569619ea76b4f24575a05c	0	71779697	2023-03-20T12:59:36.000Z	0x9b8bdfd641b86d2977dba82fe5f050bdb61fb4c5ef7a89939fe77083c8f968cd	126
0x734d84631f00dc0d3fcd18b04b6cf42bfd407074	0x3d663830bbb83f81e703adacdf4744cbfd251738	false	true	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	47	229044344	2024-07-05T14:34:32.000Z	0x19f4028a9050ec8db191231b2650123553a5b922dcb8a90db722fc1c08ed91d7	203

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solidlizard_v1_arbitrum.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_bribe`	`STRING`	Contract address of the bribe contract associated with the gauge or pool. 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_bribe	in_gauge	log_index	in_creator	block_number	block_timestamp	transaction_hash
0x98a1de08715800801e9764349f5a71cbe63f99cc	0x984cb2798d61d66a02d681a8bc6dcda01c82f85e	false	0x2432b815801f222b0fb5cbdabd4dcf499268e65e	0x9e5129ee4637d859cb0107ffc470f4b0272809eb	3	0x4bf7a0c21660879fdd051f5ee92cd2936779ec57	67128563	2023-03-06T00:18:07.000Z	0x0e2d7b03fe6194e67c9d7d1a636030440e1766e80b7d71a400b6f11f3a1ae3d4
0x98a1de08715800801e9764349f5a71cbe63f99cc	0x534d1631a8355b8a7c59973f79b8f0b751cf563b	false	0x967877b8e540acd010284ff97ad4989a0a421f69	0xb4f09eaf219aa6d2c59c4af95fd7fa790d2673a8	4	0x27a333a11a8cc8545a76ba1d36a23742c2f4b97c	67305611	2023-03-06T13:54:59.000Z	0xcd342e5882cd8c321127eceddb699e251e806b54238f50c0f4a57836571fb491
0x98a1de08715800801e9764349f5a71cbe63f99cc	0x0ebabbede9f09b48736875d82bfec97816e75389	false	0xbc876e8c6a759c16ac071881493284d80f1b3d2c	0xe0b1642f7bed70093d192de2ddbb3dbf5e0ff867	10	0x1cabc3e62e0527cbe09917f5ca8e6d9999502d82	81497880	2023-04-17T19:27:41.000Z	0x8e05a948db9139b6b12e66d9982892be6cfaa0ea68e8ecca816ae7468b729332

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

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_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_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