across_v1_ethereum

Tables

AcceleratingDistributor_RewardsWithdrawn_event

Reward withdrawal events from Across Protocol v1’s AcceleratingDistributor contract on Ethereum, recording token-based incentive claims by liquidity providers. Tracks withdrawn amounts, accumulated rewards per token, and user reward accounting for analyzing LP incentive distribution 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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardsToSend`	`STRING`	Amount of reward tokens being withdrawn by the user in this transaction, denominated in the smallest unit of the token (wei-equivalent). Values typically range from hundreds to tens of thousands of tokens in base units.
`in_tokenLastUpdateTime`	`STRING`	Unix timestamp of the last update to the token’s reward accounting state in the Across v1 liquidity mining distributor. Recorded in seconds since epoch, this tracks when reward calculations were most recently processed for the specified token.
`in_tokenRewardPerTokenStored`	`STRING`	Cumulative reward rate per staked token at the time of withdrawal, used to calculate total rewards earned. Represented in wei (smallest unit), this value increases over time as rewards accumulate in the Across V1 staking distributor contract.
`in_userRewardsOutstanding`	`STRING`	Outstanding reward balance for the user before this withdrawal transaction. Always zero in these samples, indicating users fully claim their accumulated rewards when withdrawing.
`in_userRewardsPaidPerToken`	`STRING`	Cumulative rewards per token that have been distributed to this specific user at the time of withdrawal. Value resets to zero after rewards are claimed, tracking the user’s reward checkpoint in the staking contract.

Sample Data

address	in_user	removed	in_token	log_index	block_number	block_timestamp	in_rewardsToSend	transaction_hash	in_tokenLastUpdateTime	in_userRewardsPaidPerToken	in_tokenRewardPerTokenStored
0x9040e41ef5e8b281535a96d9a48acb8cfabd9a48	0xb9a7329e124edb947255e58df434d4b495def0e9	false	0xb0c8fef534223b891d4a430e49537143829c4817	233	19574165	2024-04-03T08:49:35.000Z	195728157891628670358	0x1e1224cad84f987a41616e67c2461c2408835873283c043ef0cd5b2ff373c019	1712134175	113179872690123141	113179872690123141
0x9040e41ef5e8b281535a96d9a48acb8cfabd9a48	0xa5cd56527f645b74cdb851f2153a751d20843252	false	0xb0c8fef534223b891d4a430e49537143829c4817	240	19571765	2024-04-03T00:46:59.000Z	603392254088662026000	0xf419a40f57b499845ce646b498c9169d87e95f6eb511eb89132aac84ba0d2617	1712105219	113139292136648751	113139292136648751
0x9040e41ef5e8b281535a96d9a48acb8cfabd9a48	0x4587ef3555d49040d6340e102cdd525128b7fb32	false	0xb0c8fef534223b891d4a430e49537143829c4817	274	19572185	2024-04-03T02:11:35.000Z	134701141519641016946	0x7cd3567cd32a105d3c6152c31a9346a041f0e84306f48fd82541f1b6a261683c	1712110295	113146405883776631	113146405883776631

Example Query

Query with partition filter

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

AcrossMerkleDistributor_Claimed_event

Reward claim events from Across Protocol’s Merkle distributor contract on Ethereum, tracking token distributions to liquidity providers and relayers. Records include claimed amounts, reward token addresses, window/account indices for Merkle proof verification, and caller/recipient addresses for analyzing incentive distribution 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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_windowIndex`	`STRING`	Distribution window identifier for the reward claim period. String-encoded integer (typically “0”) representing the time-based epoch in Across’s Merkle distributor reward system.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountIndex`	`STRING`	Account identifier within the reward distribution merkle tree for the specified window. Used to verify the claim against the merkle proof structure.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	in_caller	log_index	in_account	block_number	in_rewardToken	block_timestamp	in_accountIndex	transaction_hash
0xe50b2ceac4f60e840ae513924033e753e2366487	false	2106667700000000000000	0x985e8a89dd6af8896ef075c8dd93512433dc5829	105	0xbdf7ecd3938bc86373d15709fe09dcf9bb677ca7	17041765	0xb0c8fef534223b891d4a430e49537143829c4817	2023-04-13T23:59:59.000Z	464	0x926c9d1a81d59493230faee7b3e2822006443c074e2ee4b9228747f02e22fbf5
0xe50b2ceac4f60e840ae513924033e753e2366487	false	824999000000000000000	0x985e8a89dd6af8896ef075c8dd93512433dc5829	362	0x554ee99540949c14cb9fa64cf00a09a8047fa747	17038912	0xb0c8fef534223b891d4a430e49537143829c4817	2023-04-13T13:50:35.000Z	205	0xa3893646b2b7bdd68efbe6e8f58fa98ac1162e3778100d919856b45f75e4a923
0xe50b2ceac4f60e840ae513924033e753e2366487	false	558985500000000000000	0x985e8a89dd6af8896ef075c8dd93512433dc5829	630	0xe225f433b0229cd633caf2afe87bb0008f73e422	17037636	0xb0c8fef534223b891d4a430e49537143829c4817	2023-04-13T09:06:23.000Z	13244	0x9a9bc0079e6e9396054c2031cbe91d26c3c044255a8d716fb78f6279a18d16ad

Example Query

Query with partition filter

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

AcrossMerkleDistributor_ClaimFor_event

Reward claim events from Across Protocol v1 on Ethereum where callers claim token distributions on behalf of recipient accounts using Merkle proof verification. Tracks claimed amounts, reward tokens, window indexes, and account indexes for analyzing liquidity provider incentive distributions.

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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_windowIndex`	`STRING`	Merkle tree reward distribution window identifier for the claim period. Value ‘0’ in samples indicates the first distribution window.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountIndex`	`STRING`	Unique identifier for the account within the Merkle tree distribution window. Numeric string that maps each eligible account to their position in the reward distribution structure.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	in_caller	log_index	in_account	block_number	in_rewardToken	block_timestamp	in_accountIndex	transaction_hash
0xe50b2ceac4f60e840ae513924033e753e2366487	false	546886400000000000000	0x985e8a89dd6af8896ef075c8dd93512433dc5829	849	0x10796b53d53bad010277737204a1bab224c5863f	18710695	0xb0c8fef534223b891d4a430e49537143829c4817	2023-12-04T04:43:47.000Z	4397	0x75999294b23ef6119a96c2a4f8a8431cddfed7436d4d3b315a0f7e45d2f9816b
0xe50b2ceac4f60e840ae513924033e753e2366487	false	7474914200000000000000	0x985e8a89dd6af8896ef075c8dd93512433dc5829	158	0x435d821ee5b346850545cb18443ca9808a9d47d0	18715076	0xb0c8fef534223b891d4a430e49537143829c4817	2023-12-04T19:26:23.000Z	6432	0xbcacbb34d96a0f56f08b0cdd7ad57c62b47c60962a7ed120a27994eebb5097cb
0xe50b2ceac4f60e840ae513924033e753e2366487	false	2170057600000000000000	0x985e8a89dd6af8896ef075c8dd93512433dc5829	249	0x76d80594a3612430f46e47ebbe966a17d4fc823d	18715495	0xb0c8fef534223b891d4a430e49537143829c4817	2023-12-04T20:50:35.000Z	582	0x594706eaba1851df9482a5c63def5ad17633458b99742d144bea7350319b6b0c

Example Query

Query with partition filter

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

BADGERBridgePoolProd_LiquidityAdded_event

Liquidity provider deposit events from the Across v1 BADGER token bridge pool on Ethereum, recording deposited amounts and LP tokens minted. Used for analyzing pool liquidity trends and individual provider participation in cross-chain BADGER transfers.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensMinted`	`STRING`	Quantity of liquidity pool tokens minted to the liquidity provider. Numeric string representation of LP token quantity in smallest denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash	in_lpTokensMinted	in_liquidityProvider
0x43298f9f91a4545df64748e78a2c777c580573d6	false	5000000000000000000000	382	14478683	2022-03-29T03:28:24.000Z	0x715089757c4896899ef4b256937a7584f90f92f7fbca3d42a990e17f93c46d28	4988507856830600713825	0xdacae5274d83dc1cb98a2692929d04b71a31320d
0x43298f9f91a4545df64748e78a2c777c580573d6	false	500000000000000000000	350	14443028	2022-03-23T14:14:16.000Z	0x0436a55fdade60b63740d530d5e1cd3cd5e80efbbe796e61ca7c48f95e40432b	498946846244169723174	0xd798428e860465e08b522f8440f707593e6d22c6
0x43298f9f91a4545df64748e78a2c777c580573d6	false	41667421408304749133	643	14522866	2022-04-05T01:02:57.000Z	0xeef2909e111a573e5f4079eb0ab3fb4b57e0149183ce5cea08322563e9b84034	41559344751514772005	0xde0aef70a7ae324045b7722c903aaaec2ac175f5

Example Query

Query with partition filter

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

BADGERBridgePoolProd_LiquidityRemoved_event

Liquidity withdrawal events from the Across V1 BADGER token bridge pool on Ethereum, recording LP token burns and corresponding BADGER amounts returned to providers. Used for tracking liquidity provider exits and analyzing pool depth changes 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensBurnt`	`STRING`	Quantity of liquidity provider tokens burned when removing liquidity from the pool. Numeric string representation in smallest token denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	in_lpTokensBurnt	transaction_hash	in_liquidityProvider
0x43298f9f91a4545df64748e78a2c777c580573d6	false	40305257301096824480	152	19387990	2024-03-08T04:13:23.000Z	40000000000000000000	0x6f6b32d76eeb8aabf7b4e62013265baa9aa68fcd1f8dbe5b9b9db120fbe333f3	0x9a8f92a830a5cb89a3816e3d267cb7791c16b04d
0x43298f9f91a4545df64748e78a2c777c580573d6	false	501183215595852972881	132	14801571	2022-05-18T23:04:15.000Z	498946846244169723174	0xe13064e30f9b8d7d66391af611d17cf0f61bf308fa1ee42fc677222809ecb9f0	0xd798428e860465e08b522f8440f707593e6d22c6
0x43298f9f91a4545df64748e78a2c777c580573d6	false	448912197511235543559	328	14701279	2022-05-02T23:40:24.000Z	447102200393119711793	0xd882512e5af32d83d72f0bd1b567c6a8e0a488d7048662b3273c982f77b53b10	0xde0aef70a7ae324045b7722c903aaaec2ac175f5

Example Query

Query with partition filter

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

BOBABridgePoolProd_LiquidityAdded_event

Liquidity provision events from the Across V1 BOBA bridge pool on Ethereum, recording deposited amounts and LP (liquidity provider) tokens minted to providers. Used for analyzing bridge liquidity depth, provider behavior, and pool participation 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensMinted`	`STRING`	Quantity of liquidity pool tokens minted to the liquidity provider. Numeric string representation of LP token quantity in smallest denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash	in_lpTokensMinted	in_liquidityProvider
0x4841572daa1f8e4ce0f62570877c2d0cc18c9535	false	250000000000000000000000	360	14208744	2022-02-15T05:02:59.000Z	0x29f454b6da0b38783edc06da434e1e873287da1f802f83d85e3b301a5932528f	250000000000000000000000	0x9db870ccc84eb68d4c10a87559c2a80776df8e92
0x4841572daa1f8e4ce0f62570877c2d0cc18c9535	false	378396498994576171834	848	14205807	2022-02-14T18:10:31.000Z	0x564dc054d363914eb3fc213375df198fd67dc91cd74dd3739eaa2dacbfb9355f	378396498994576171834	0x9a8f92a830a5cb89a3816e3d267cb7791c16b04d

Example Query

Query with partition filter

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

BOBABridgePoolProd_LiquidityRemoved_event

Liquidity withdrawal events from Across V1’s BOBA token bridge pool on Ethereum. Tracks LP token burns, withdrawn amounts, and liquidity provider addresses for analyzing pool participation and exit 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensBurnt`	`STRING`	Quantity of liquidity provider tokens burned when removing liquidity from the pool. Numeric string representation in smallest token denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	in_lpTokensBurnt	transaction_hash	in_liquidityProvider
0x4841572daa1f8e4ce0f62570877c2d0cc18c9535	false	252276169392182545250000	391	14845572	2022-05-26T03:09:38.000Z	250000000000000000000000	0x08070630683b9d8fe96544f022d15e58fb6c65fd345829501359e900b53c71a7	0x9db870ccc84eb68d4c10a87559c2a80776df8e92
0x4841572daa1f8e4ce0f62570877c2d0cc18c9535	false	378396498994576171834	135	14211863	2022-02-15T16:47:07.000Z	378396498994576171834	0x7242a2c05f3fd2af107fc50103637f39c3db2874dc0ef19b95fb21f96035c132	0x9a8f92a830a5cb89a3816e3d267cb7791c16b04d

Example Query

Query with partition filter

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

BridgePoolProd_DepositRelayed_event

Confirmed relay events for Across V1 bridge deposits completed on Ethereum mainnet from Layer 2 chains (Optimism, Boba). Records include deposit amounts, cross-chain sender/recipient addresses, relay fees, and bond amounts for analyzing bridge settlement activity and relayer performance.

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_depositHash`	`STRING`	Unique identifier hash for the original deposit transaction that initiated this cross-chain bridge transfer. Hex-encoded, 0x-prefixed 64-character hash used to track the deposit across Layer 1 and Layer 2.
`in_depositData`	`STRUCT<chainId STRING, depositId STRING, l1Recipient STRING, l2Sender STRING, amount STRING, slowRelayFeePct STRING, instantRelayFeePct STRING, quoteTimestamp STRING>`	Structured record containing the original deposit details from the L2 chain, including amount, sender/recipient addresses, chain ID, deposit ID, quote timestamp, and fee percentages. This data is referenced when processing the relay event to verify deposit parameters and calculate fees.
`in_relay`	`STRUCT<relayState INT64, slowRelayer STRING, relayId STRING, realizedLpFeePct STRING, priceRequestTime STRING, proposerBond STRING, finalFee STRING>`	Nested record containing relay execution details including relay ID, final fees, relay state, relayer addresses, bond amounts, and LP fee percentages. All fee and bond amounts are denominated in the token’s smallest unit (wei for ETH-based tokens).
`in_relayAncillaryDataHash`	`STRING`	Hash of auxiliary relay data used for dispute resolution. This 32-byte hex string identifies supplementary information submitted with the relay proposal for UMA oracle verification.

Sample Data

address	removed	in_relay	log_index	block_number	in_depositData	in_depositHash	block_timestamp	transaction_hash	in_relayAncillaryDataHash
0x256c8919ce1ab0e33974cf6aa9c71561ef3017b6	false	{“relayId”:“1158”,“finalFee”:“1500000000”,“relayState”:1,“slowRelayer”:“0x428ab2ba90eba0a4be7af34c9ac451ab061ac010”,“proposerBond”:“2987763347”,“priceRequestTime”:“1648739535”,“realizedLpFeePct”:“1050132808601635”}	113	14494683	{“amount”:“59755266949”,“chainId”:“10”,“l2Sender”:“0xc53bf13f351e2b43eaeb5b3cd03af28f6acabaeb”,“depositId”:“1946”,“l1Recipient”:“0xc53bf13f351e2b43eaeb5b3cd03af28f6acabaeb”,“quoteTimestamp”:“1648739391”,“slowRelayFeePct”:“1010875862232440”,“instantRelayFeePct”:“122070595153153”}	0x9ad8c9d30b9f094686c2828138849ed4622e41b1694a5d6578725a3729a67ae7	2022-03-31T15:12:15.000Z	0xaead6ea8ab9253af62055f2dfb94323f2ce280ea3ebc7bca2ab732c72c458cd0	0xa2f5f145949884386e21bdee7d49a5f1bfb45ee73c8ac6fe27effd6e857666a8
0x7355efc63ae731f584380a9838292c7046c1e433	false	{“relayId”:“8263”,“finalFee”:“350000000000000000”,“relayState”:1,“slowRelayer”:“0x428ab2ba90eba0a4be7af34c9ac451ab061ac010”,“proposerBond”:“2754300000000000000”,“priceRequestTime”:“1648700181”,“realizedLpFeePct”:“938712703111724”}	330	14491752	{“amount”:“55086000000000000000”,“chainId”:“10”,“l2Sender”:“0xfb5797d758c22c773925b0a64f227494490c0fca”,“depositId”:“1942”,“l1Recipient”:“0xfb5797d758c22c773925b0a64f227494490c0fca”,“quoteTimestamp”:“1648700054”,“slowRelayFeePct”:“124100971867855”,“instantRelayFeePct”:“15484212892856”}	0x4d95df06307dffc6e3e52c6ec654881266cf4a65adcf02c840a73c5992dbdcb2	2022-03-31T04:16:21.000Z	0x15b3f4bb92cf16510d90a98a6c9aeaa6b56136c693ee47434bce1a409453e656	0xa7442f95209dbfa891eba2d0268832a4935caa33197ce0a29e18c0a6f93ed46b
0x7355efc63ae731f584380a9838292c7046c1e433	false	{“relayId”:“8290”,“finalFee”:“350000000000000000”,“relayState”:1,“slowRelayer”:“0x428ab2ba90eba0a4be7af34c9ac451ab061ac010”,“proposerBond”:“499237879907771039”,“priceRequestTime”:“1648767256”,“realizedLpFeePct”:“938712703111729”}	271	14496740	{“amount”:“9984757598155420781”,“chainId”:“10”,“l2Sender”:“0xc8d3185b6834a6ad162df91b928f179c7411aafc”,“depositId”:“1948”,“l1Recipient”:“0xc8d3185b6834a6ad162df91b928f179c7411aafc”,“quoteTimestamp”:“1648767111”,“slowRelayFeePct”:“810830357561230”,“instantRelayFeePct”:“101168183355064”}	0x130b421de3e845f5165322b7d7410574918c080f5df12fd7866fcd847ccd88a8	2022-03-31T22:54:16.000Z	0x87a758aa590cce3245e4df44ddf5833039a85df2f8583650120401bfbc4ee174	0x92301d06b2afd2576b773ea7fee4ab27c3eddc2fd33ebbba3c7830cb7f2be0b1

Example Query

Query with partition filter

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

BridgePoolProd_LiquidityAdded_event

Liquidity provider deposit events from Across V1 bridge pools on Ethereum, recording deposited amounts and LP tokens minted. Used for tracking liquidity provision activity and calculating LP share allocations across different bridge pool contracts.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensMinted`	`STRING`	Quantity of liquidity pool tokens minted to the liquidity provider. Numeric string representation of LP token quantity in smallest denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash	in_lpTokensMinted	in_liquidityProvider
0x256c8919ce1ab0e33974cf6aa9c71561ef3017b6	false	700000000000	167	14562655	2022-04-11T06:02:20.000Z	0x1d63a2a35444f61d266b0e6a9aab708153a56b17b5f8690cd8dee6300f8567cd	693002270101	0x19282e37b5319727501e9577d79dbcdf43803883
0x256c8919ce1ab0e33974cf6aa9c71561ef3017b6	false	5000000000	189	14562528	2022-04-11T05:30:54.000Z	0xcb2928252c4140356eeeff0a12258dbd3b6194b8562b10ad9362c9b7a2dbd7fa	4950017923	0xcce853ecb829d914d119724761e3deb6ad982047
0x256c8919ce1ab0e33974cf6aa9c71561ef3017b6	false	87453986310	382	14565044	2022-04-11T14:50:10.000Z	0xe438ec514844912f27f2dfb18edeab9a363d009dbb73ef7957abecc020caa6fb	86579251816	0xf18cef01077cdb15a0804a27f6b1e0ec2ef305ee

Example Query

Query with partition filter

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

BridgePoolProd_LiquidityRemoved_event

Liquidity withdrawal events from Across V1 bridge pools on Ethereum, recording LP token burns and underlying asset amounts returned to providers. Used for tracking liquidity provider positions, pool depth changes, and yield 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensBurnt`	`STRING`	Quantity of liquidity provider tokens burned when removing liquidity from the pool. Numeric string representation in smallest token denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	in_lpTokensBurnt	transaction_hash	in_liquidityProvider
0x256c8919ce1ab0e33974cf6aa9c71561ef3017b6	false	1998107188	533	14045821	2022-01-21T00:51:19.000Z	1985423552	0x0e43455078d02754da335de9f4fb2ca2db98391c8667f6bb700d22f06da6ff8e	0x0fda6dee4165ac4b07a144ae059defd639f29880
0x7355efc63ae731f584380a9838292c7046c1e433	false	501927685174219696	517	14046855	2022-01-21T04:39:10.000Z	499717628098900150	0x734b8a50c7972084957bdca690dca777138e3eca5c03563a7a8faba55952d969	0xbd630a878bed3a6f7910be0780c139f9924f5071
0xdfe0ec39291e3b60aca122908f86809c9ee64e90	false	2402103892314693255859	87	13636575	2021-11-18T02:03:45.000Z	2402095921770829267031	0xb8f7ba40265a13062b1074b3d8089599b2e866c198b6851c7b42dfda20adf8c2	0x52d95bf1c50abb8031a5367db41ae3d73c1d7c06

Example Query

Query with partition filter

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

DAIBridgePoolProd_LiquidityAdded_event

Liquidity provider deposit events from Across V1 DAI bridge pool on Ethereum, recording DAI amounts deposited and corresponding LP tokens minted. Used for tracking liquidity provider positions and pool composition 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensMinted`	`STRING`	Quantity of liquidity pool tokens minted to the liquidity provider. Numeric string representation of LP token quantity in smallest denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash	in_lpTokensMinted	in_liquidityProvider
0x43f133fe6fdfa17c417695c476447dc2a449ba5b	false	250025399274868000000000	199	14556274	2022-04-10T06:14:20.000Z	0x0dac16580ad80359ce9b1e0e36145b109d40604de52b0f57a10c18c806e48d14	249162456185664049834188	0x4902b20bb3b8e7776cbcdcb6e3397e7f6b4e449e
0x43f133fe6fdfa17c417695c476447dc2a449ba5b	false	246550938495663495357157	575	14559619	2022-04-10T18:49:56.000Z	0xf698602e461645435cc6489364c317814c8825805d0a4da7761bf6c3f89949ef	245697431898056451325068	0x3119a5bf3ce136b2ea82969a26e5f570c0319209
0x43f133fe6fdfa17c417695c476447dc2a449ba5b	false	1000370317750176075946514	493	14622096	2022-04-20T13:08:12.000Z	0x7fe5c46c4b9fecdc82d8886a8a0dd73d5d5f84ea2b3c8fb08979db31170cf092	996661269927461416570695	0xbdfa4f4492dd7b7cf211209c4791af8d52bf5c50

Example Query

Query with partition filter

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

DAIBridgePoolProd_LiquidityRemoved_event

Liquidity withdrawal events from Across Protocol V1’s DAI bridge pool on Ethereum, recording provider addresses, DAI amounts removed, and LP tokens burned. Used for analyzing liquidity provider exit patterns and pool capital 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensBurnt`	`STRING`	Quantity of liquidity provider tokens burned when removing liquidity from the pool. Numeric string representation in smallest token denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	in_lpTokensBurnt	transaction_hash	in_liquidityProvider
0x43f133fe6fdfa17c417695c476447dc2a449ba5b	false	23686971372222000982397	490	14889574	2022-06-02T07:02:50.000Z	23491816747433375452838	0x28ef0e0e2fdb3d0d22de3e2f74284171f8a46fa75dc151fe9a68ab66ecd6ec01	0x8ccaf951c46899aa11e96435261c271c3e5ba963
0x43f133fe6fdfa17c417695c476447dc2a449ba5b	false	49832886922706653739970	279	14594351	2022-04-16T05:03:42.000Z	49654960291486845791675	0x7caa29485f1d94d432464dcd7f1dddb17294e83a04986d85fd168f19b87ce19c	0x9e564ee88d06f2d63815776c4562e01ab5b3da8d
0x43f133fe6fdfa17c417695c476447dc2a449ba5b	false	246579597901763522284612	82	14597666	2022-04-16T17:18:36.000Z	245697431898056451325068	0x07d6c6b343cdd15d9cbf39cd346311945c5d0310ab1ac676acb4f84456de9ec5	0x3119a5bf3ce136b2ea82969a26e5f570c0319209

Example Query

Query with partition filter

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

HubPool_L1TokenEnabledForLiquidityProvision_event

Event log tracking when L1 tokens are enabled for liquidity provision in Across V1’s HubPool on Ethereum, mapping L1 tokens to their corresponding LP tokens. Used for identifying which assets can accept liquidity provider deposits and their associated pool tokens.

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_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. Hex-encoded, 0x-prefixed, 42-character string.
`in_lpToken`	`STRING`	Contract address of the LP (liquidity provider) token issued to depositors who provide the corresponding L1 token to the Across protocol’s liquidity pool. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the fungible receipt token.

Sample Data

address	removed	log_index	in_l1Token	in_lpToken	block_number	block_timestamp	transaction_hash
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	117	0xba100000625a3754423978a60c9317c58a424e3d	0xfacd2ec4647df2cb758f684c2aaab56a93288f9e	15355628	2022-08-17T00:43:23.000Z	0x9ec428512e473c1a77e0acd73d844a2011a0aa91fa2d861f3fae30083eef8cea
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	126	0x4e107a0000db66f0e9fd2039288bf811dd1f9c74	0x8d29b8f64237cf39e93111a96a73e5dc03eb612d	22439611	2025-05-08T15:10:47.000Z	0x485a896b15d9d0c33c85388cc54ab18c85d34b7d90c6da9d42f3716e9e8c3c3b
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	160	0x6033f7f88332b8db6ad452b7c6d5bb643990ae3f	0xfd4a46d76fb8fc13f5a77883519a0cfb656d3bec	20276241	2024-07-10T12:56:47.000Z	0x566087fbaa74a32ec94bf4ba58c1451bf916991b686c0895245f726339b1725d

Example Query

Query with partition filter

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

HubPool_LiquidityAdded_event

Liquidity provision events from Across v1 bridge HubPool contract on Ethereum, tracking deposits of L1 tokens and corresponding LP token mints. Used for analyzing liquidity provider activity, pool composition, and yield calculation across different bridge assets.

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_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. 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_lpTokensMinted`	`STRING`	Quantity of liquidity pool tokens minted to the liquidity provider. Numeric string representation of LP token quantity in smallest denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	in_l1Token	block_number	block_timestamp	transaction_hash	in_lpTokensMinted	in_liquidityProvider
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	26304342177	249	0xdac17f958d2ee523a2206206994597c13d831ec7	17542543	2023-06-23T13:24:11.000Z	0xab468b9e836637cb438a74a2c618cc3408da6ededebe57ae72fb39b4e75e3293	26238492895	0x610d49f8a264db3b41a793173ba5b8aca70444c2
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	50006292	484	0xdac17f958d2ee523a2206206994597c13d831ec7	17540831	2023-06-23T07:36:47.000Z	0xce2ba4823def763be470a5a84e0bac66ab14b18eb3098267d2de1b59848bcdea	49881859	0xe38ea053b8c1a5033c6259868e0fff1795fb51a1
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	18643189084	431	0xdac17f958d2ee523a2206206994597c13d831ec7	17541848	2023-06-23T11:03:47.000Z	0xbbe50a556fbbb587cdb048052ae2941b7dd830800e48a1b93cbb3405733052ab	18596631383	0x4ffad6ac852c0af0aa301376f4c5dea3a928b120

Example Query

Query with partition filter

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

HubPool_LiquidityRemoved_event

Liquidity withdrawal events from Across v1 protocol’s HubPool contract on Ethereum, recording when liquidity providers remove their deposits and burn LP tokens in exchange for underlying L1 tokens (WETH, USDC, DAI, BAL). Used for tracking liquidity provider activity and pool composition changes 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_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. 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_lpTokensBurnt`	`STRING`	Quantity of liquidity provider tokens burned when removing liquidity from the pool. Numeric string representation in smallest token denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	in_l1Token	block_number	block_timestamp	in_lpTokensBurnt	transaction_hash	in_liquidityProvider
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	1009994286895576667	113	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	15551649	2022-09-17T06:54:11.000Z	999979720677297290	0x852e22f816478535f3c44b09ac177c7aa953f7651854ff0afc751dfcba6584c2	0x0bf93ea5a1fa4ce3dd22c7ffd314462d3869777f
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	670394980	63	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	15553429	2022-09-17T12:54:23.000Z	664688877	0x2752a99fa4f08d3638ec07862346fe729fe92582a5967e8a2eca4c66d7f2e120	0x54b17a1e4324b54eca169f36ad894ea5dcb326fc
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	2100675698	419	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	15552811	2022-09-17T10:49:11.000Z	2082804950	0xef3daa97dc7780673b868019132b5a9e7213482c7b61bc89d4aa703c9d9b887f	0x573f28db9ba30efbac1992a50b40a9dca64fe771

Example Query

Query with partition filter

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

HubPool_RootBundleExecuted_event

Across Protocol v1 root bundle execution events tracking cross-chain liquidity rebalancing on Ethereum mainnet. Records per-chain token settlements, LP fees, running balances, and net transfers for analyzing bridge operator activity and cross-chain fund 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_groupIndex`	`STRING`	Sequential identifier for grouping related bundle executions within the same root bundle. Typically ‘0’ for single-group bundles or increments for multi-group executions.
`in_leafId`	`STRING`	Sequential identifier for a leaf in the merkle tree structure used for cross-chain token bridging operations. Numeric string value.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_l1Tokens`	`ARRAY<STRING>`	Array of Ethereum mainnet (L1) token contract addresses involved in this root bundle execution. Each address is hex-encoded and corresponds to positions in the bundleLpFees, netSendAmounts, and runningBalances arrays.
`in_bundleLpFees`	`ARRAY<STRING>`	Array of liquidity provider fee amounts earned for each token in this root bundle execution, denominated in the respective token’s smallest unit. Values are string-encoded to handle large integers beyond JavaScript’s number precision.
`in_netSendAmounts`	`ARRAY<STRING>`	Array of token amounts net sent to or from the destination chain in this bundle execution. Values are string-encoded integers representing token amounts in their smallest unit (wei for ETH); negative values indicate sends to L2, positive values indicate receives from L2.
`in_runningBalances`	`ARRAY<STRING>`	Array of running balance totals for L1 tokens after bundle execution, denominated in token base units (e.g., wei for ETH). Values can be negative, indicating net outflows from the HubPool contract.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_caller	in_leafId	log_index	in_chainId	in_l1Tokens	block_number	block_timestamp	in_bundleLpFees	transaction_hash	in_netSendAmounts	in_runningBalances
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	0xca11bde05977b3631167028862be2a173976ca11	12	472	534352	[“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”]	21275493	2024-11-27T00:24:59.000Z	[“0”,“7391167879990”]	0xb9e1c467e323d04b14bdf80baf24a84c3aa9dbf846b00a17c51c768b14b51b2e	[“0”,“0”]	[“-33528277408”,“-78567149940556789174”]
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	0xca11bde05977b3631167028862be2a173976ca11	13	478	7777777	[“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”]	21275493	2024-11-27T00:24:59.000Z	[“0”]	0xb9e1c467e323d04b14bdf80baf24a84c3aa9dbf846b00a17c51c768b14b51b2e	[“0”]	[“-309400000000000000”]
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	0xca11bde05977b3631167028862be2a173976ca11	1	406	10	[“0x2260fac5e5542a773aa44fbcfedf7c193bc2c599”,“0x6b175474e89094c44da98b954eedeac495271d0f”,“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“0xdac17f958d2ee523a2206206994597c13d831ec7”]	21275493	2024-11-27T00:24:59.000Z	[“0”,“0”,“7228343”,“2305727090027279”,“92053”]	0xb9e1c467e323d04b14bdf80baf24a84c3aa9dbf846b00a17c51c768b14b51b2e	[“0”,“0”,“0”,“0”,“0”]	[“-420185820”,“-8834380565239759118974”,“-410393547447”,“-67584576679603528852”,“-50009691920”]

Example Query

Query with partition filter

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

HubPool_SetPoolRebalanceRoute_event

Configuration events for Across V1 bridge token routing between Ethereum Layer 1 and destination chains. Tracks token address mappings and chain IDs for cross-chain liquidity rebalancing in the HubPool 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_destinationChainId`	`STRING`	Chain identifier for the destination blockchain where tokens or messages will be received. Numeric string representing the standard chain ID.
`in_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. Hex-encoded, 0x-prefixed, 42-character string.
`in_destinationToken`	`STRING`	Contract address of the token being received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_l1Token	block_number	block_timestamp	transaction_hash	in_destinationToken	in_destinationChainId
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	173	0xba100000625a3754423978a60c9317c58a424e3d	15355628	2022-08-17T00:43:23.000Z	0x9ec428512e473c1a77e0acd73d844a2011a0aa91fa2d861f3fae30083eef8cea	0xfe8b128ba8c78aabc59d4c64cee7ff28e9379921	10
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	175	0xba100000625a3754423978a60c9317c58a424e3d	15355628	2022-08-17T00:43:23.000Z	0x9ec428512e473c1a77e0acd73d844a2011a0aa91fa2d861f3fae30083eef8cea	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	42161
0xc186fa914353c44b2e33ebe05f21846f1048beda	false	172	0xba100000625a3754423978a60c9317c58a424e3d	15355628	2022-08-17T00:43:23.000Z	0x9ec428512e473c1a77e0acd73d844a2011a0aa91fa2d861f3fae30083eef8cea	0xba100000625a3754423978a60c9317c58a424e3d	1

Example Query

Query with partition filter

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

HubPool_setPoolRebalanceRoute_function

Across V1 protocol HubPool function calls that configure cross-chain token rebalancing routes, mapping L1 tokens to their destination chain equivalents. Used for tracking liquidity pool configuration changes across supported chains including Ethereum, Optimism, Polygon, Arbitrum, Scroll, and Linea.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_destinationChainId`	`STRING`	Chain identifier for the destination blockchain where tokens or messages will be received. Numeric string representing the standard chain ID.
`in_l1Token`	`STRING`	Contract address of the token on Ethereum Layer 1. Hex-encoded, 0x-prefixed, 42-character string.
`in_destinationToken`	`STRING`	Contract address of the token being received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	gas_used	signature	in_l1Token	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash	in_destinationToken	in_destinationChainId
5277647	true	28495	0x10b99527	0x0cec1a9154ff802e7934fc916ed7ca50bde6844e	0xc186fa914353c44b2e33ebe05f21846f1048beda	17564440	0xb524735356985d2f267fa010d681f061dff03715	0,3,4	2023-06-26T15:18:35.000Z	0x6eb59d9dadc907ad382ab120ad168fba9a3f9980094d3f393778843903a0c6f3	0x0cec1a9154ff802e7934fc916ed7ca50bde6844e	1
5334448	true	28495	0x10b99527	0x0cec1a9154ff802e7934fc916ed7ca50bde6844e	0xc186fa914353c44b2e33ebe05f21846f1048beda	17564440	0xb524735356985d2f267fa010d681f061dff03715	0,3,2	2023-06-26T15:18:35.000Z	0x6eb59d9dadc907ad382ab120ad168fba9a3f9980094d3f393778843903a0c6f3	0x395ae52bb17aef68c2888d941736a71dc6d4e125	10
5306048	true	28495	0x10b99527	0x0cec1a9154ff802e7934fc916ed7ca50bde6844e	0xc186fa914353c44b2e33ebe05f21846f1048beda	17564440	0xb524735356985d2f267fa010d681f061dff03715	0,3,3	2023-06-26T15:18:35.000Z	0x6eb59d9dadc907ad382ab120ad168fba9a3f9980094d3f393778843903a0c6f3	0x25788a1a171ec66da6502f9975a15b609ff54cf6	137

Example Query

Query with partition filter

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

UMABridgePoolProd_LiquidityAdded_event

Liquidity provision events from Across V1 bridge pool on Ethereum, recording deposits with amounts and corresponding LP tokens minted. Used for analyzing liquidity provider activity and pool growth in the UMA-powered cross-chain bridge.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensMinted`	`STRING`	Quantity of liquidity pool tokens minted to the liquidity provider. Numeric string representation of LP token quantity in smallest denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash	in_lpTokensMinted	in_liquidityProvider
0xdfe0ec39291e3b60aca122908f86809c9ee64e90	false	9699999999999999999	353	13790429	2021-12-12T12:52:29.000Z	0x46e90df1de71f3210b9f50c433f78617be1027ad460e5164bc6b900be1fd8e99	9699967783769825782	0xcdeb3461dce9b17a5d28893f44141c4e695b68d1
0xdfe0ec39291e3b60aca122908f86809c9ee64e90	false	9890000000000000000	357	13790429	2021-12-12T12:52:29.000Z	0x4e037dd7e0bbd1ca2469115a350155b344a85b85d93b93e3979e256c28c58b02	9889967152730265669	0x68889e98a947501cae1f7e2fb4b771f0234575a1
0xdfe0ec39291e3b60aca122908f86809c9ee64e90	false	262490069590000000000	100	14149737	2022-02-06T02:24:49.000Z	0xc2f8337d2ba195b1024b4a914d9cd1d6ac6354ca6048cf31c5dfdbd750040a1f	262488492015518771954	0x99bcea6bb0403927fb3c038163478d5b42082fd9

Example Query

Query with partition filter

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

UMABridgePoolProd_LiquidityRemoved_event

Liquidity removal events from Across V1 bridge pool on Ethereum, tracking withdrawn amounts and burned LP tokens when providers exit positions. Used for analyzing liquidity provider behavior and pool capital 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensBurnt`	`STRING`	Quantity of liquidity provider tokens burned when removing liquidity from the pool. Numeric string representation in smallest token denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	in_lpTokensBurnt	transaction_hash	in_liquidityProvider
0xdfe0ec39291e3b60aca122908f86809c9ee64e90	false	84732464418131338844	496	16118969	2022-12-05T13:41:47.000Z	84731919285438650518	0x2ba29613d62c6251ec5ab7cb8bbcc18f31a01dce95efb0078c4809386ce39a8e	0x7b68a28d7ad85451188fa0608fb3ea2d83155bde
0xdfe0ec39291e3b60aca122908f86809c9ee64e90	false	847051948785434526059	257	14241739	2022-02-20T08:01:04.000Z	847046504504069631861	0xe0f2e7d35f3bbfc89f68b0ff7b76bf6b3fd8d52dba6df7402a526d83b956c856	0x6c9c5ce574f160a45bd8411e20fa647c2b112a1e
0xdfe0ec39291e3b60aca122908f86809c9ee64e90	false	2953620921693886354	215	15022943	2022-06-25T09:06:09.000Z	2953601919351191846	0xaa58414119e41a90e2a996507658d7e11cec1cd696628e0a9c77d03b5cc255b4	0x5f696426b382608e32bcfb0afb3b786242cf4f79

Example Query

Query with partition filter

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

USDCBridgePoolProd_LiquidityAdded_event

Liquidity deposit events from Across V1 USDC bridge pool on Ethereum, recording provider addresses, deposited amounts, and LP tokens minted. Used for tracking liquidity provider activity and pool capital 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensMinted`	`STRING`	Quantity of liquidity pool tokens minted to the liquidity provider. Numeric string representation of LP token quantity in smallest denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash	in_lpTokensMinted	in_liquidityProvider
0x256c8919ce1ab0e33974cf6aa9c71561ef3017b6	false	100000000	497	14339046	2022-03-07T10:03:18.000Z	0x63d3c9ca8e491ed4064682063e8eca45ae2c62442caa7fff6756facd37fcb7e3	99146648	0x7b89e5624b71ff104a69ba232b27fafe803d7263
0x256c8919ce1ab0e33974cf6aa9c71561ef3017b6	false	1001000805	86	14338182	2022-03-07T06:38:25.000Z	0x875de7be5de56734f31d170fcb5a46a72ea783b6e58667d676a170718d0ce3f4	992468479	0xfcb5a922877683128cc8b52cd7883cab12d21229
0x256c8919ce1ab0e33974cf6aa9c71561ef3017b6	false	50000000	373	14339131	2022-03-07T10:19:22.000Z	0x3a4d40b395b8e6c155f826c9bdbc10deaf6284af2a85e73bb6eb9f502822ac23	49573287	0xc7921fdc43ad1b02074139fed1b3d0865ebebfb6

Example Query

Query with partition filter

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

USDCBridgePoolProd_LiquidityRemoved_event

Liquidity withdrawal events from Across Protocol v1’s USDC bridge pool on Ethereum, recording when liquidity providers remove funds by burning LP tokens. Useful for tracking pool liquidity changes, provider behavior, and withdrawal-to-LP-token exchange rates 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensBurnt`	`STRING`	Quantity of liquidity provider tokens burned when removing liquidity from the pool. Numeric string representation in smallest token denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	in_lpTokensBurnt	transaction_hash	in_liquidityProvider
0x256c8919ce1ab0e33974cf6aa9c71561ef3017b6	false	6202591892	505	14865980	2022-05-29T10:35:06.000Z	6131963916	0x56a50aa09ab8409c971fb6474c06d4dbc858eaa4080d9170634871c615bfb376	0x848c49fd3fe4dd05831703a5e5934446d9cad60f
0x256c8919ce1ab0e33974cf6aa9c71561ef3017b6	false	3034583329	174	14865721	2022-05-29T09:31:44.000Z	3000036787	0x39c2d46e024872ad34ea538c5920d31bb72c691518058d3eb0cc3d88ce3ad810	0x09700d103f4c4a13dba21275a422d93f8271193f
0x256c8919ce1ab0e33974cf6aa9c71561ef3017b6	false	119856887	174	14544942	2022-04-08T11:48:58.000Z	118664707	0x90a757a59b55827cbefa621c712caa2155cc97c5fdc594f2e2fa73677f177d6c	0x64cee1eba2a47a5a8dae820834b7495ac371b07d

Example Query

Query with partition filter

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

WBTCBridgePoolProd_LiquidityAdded_event

Liquidity provision events from Across V1’s WBTC (Wrapped Bitcoin) bridge pool on Ethereum, recording deposits with amount, LP tokens minted, and provider addresses. Used for analyzing liquidity provider behavior and pool depth changes 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensMinted`	`STRING`	Quantity of liquidity pool tokens minted to the liquidity provider. Numeric string representation of LP token quantity in smallest denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash	in_lpTokensMinted	in_liquidityProvider
0x02fbb64517e1c6ed69a6faa3abf37db0482f1152	false	108715373	588	14545839	2022-04-08T15:01:01.000Z	0xef0dc52ac90b412f163bfb9d791383922811ebf9b7d23c45c70f9bdf24132c4c	108395008	0x3cb07d1f0620090bb667df1a5c90b4b80f8ede73
0x02fbb64517e1c6ed69a6faa3abf37db0482f1152	false	46497741	112	14420111	2022-03-20T00:41:13.000Z	0x070c23c0fba8a2b3df082696a18349e3891d480526195ed616a36c022cf43719	46370480	0xa2490947b30258b522b7d6fd8fabec2d21c42d57
0x02fbb64517e1c6ed69a6faa3abf37db0482f1152	false	264720000	221	14731545	2022-05-07T19:01:53.000Z	0xf67e1ea6cacad3a9f800dfea143cffd4b1c237bb80e84457c536a12d5a903596	263567564	0x1b50adc3c74b4f3a2a4307fe714c853634139e45

Example Query

Query with partition filter

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

WBTCBridgePoolProd_LiquidityRemoved_event

Liquidity withdrawal events from Across v1 WBTC (Wrapped Bitcoin) bridge pool on Ethereum, recording LP token burns and withdrawn amounts when providers exit the pool. Useful for analyzing liquidity provider behavior and pool depth changes 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensBurnt`	`STRING`	Quantity of liquidity provider tokens burned when removing liquidity from the pool. Numeric string representation in smallest token denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	in_lpTokensBurnt	transaction_hash	in_liquidityProvider
0x02fbb64517e1c6ed69a6faa3abf37db0482f1152	false	5017865	323	14822829	2022-05-22T10:22:47.000Z	4986013	0xb1d86d850c3304e15c7f3534412f9970487212ff25ac7ee4da7e5b81f91fd04a	0x9628f11c8fbf15df1307ad5284398ad7dcdf573c
0x02fbb64517e1c6ed69a6faa3abf37db0482f1152	false	2046562	347	14821933	2022-05-22T06:47:21.000Z	2033588	0xad035b555db0b4fc9411bc209caef07c3165011d1bc027cbab2663f65cb2a0cf	0xb1431f84f8f3764f64cbac125d7fd16ca4cf2ef0
0x02fbb64517e1c6ed69a6faa3abf37db0482f1152	false	503363380	517	15000171	2022-06-21T03:15:44.000Z	499362783	0xfa5fe2682c554f91d83943d8237f1b4483c100a830757f59cbc8246cf3754c6a	0xd165164cbab65004da73c596712687c16b981274

Example Query

Query with partition filter

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

WETHBridgePoolProd_LiquidityAdded_event

Liquidity provider deposit events from Across v1 WETH bridge pool on Ethereum, capturing WETH amounts added and corresponding LP tokens minted. Used for tracking liquidity provision activity and LP token supply changes in the bridge pool.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensMinted`	`STRING`	Quantity of liquidity pool tokens minted to the liquidity provider. Numeric string representation of LP token quantity in smallest denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash	in_lpTokensMinted	in_liquidityProvider
0x7355efc63ae731f584380a9838292c7046c1e433	false	100000000000000	272	13781978	2021-12-11T05:23:25.000Z	0x512f75e87b33a7ed18f09e85a9175137ff34b0cfe56f9cd2b2e8c1d82f36e825	99753407983753	0x64fc5aa061afb5e2dacfbd9b23fafbe80fed3c4c
0x7355efc63ae731f584380a9838292c7046c1e433	false	100000000000000	406	13781963	2021-12-11T05:19:02.000Z	0xb598545cc4e8ddb5b97d540c58834575a373463b358f98135c8b4d5f44941413	99753424730391	0x1fd4197b253a2ad27c2c3e01701e05faf7999999
0x7355efc63ae731f584380a9838292c7046c1e433	false	100000000000000	703	13783853	2021-12-11T12:29:14.000Z	0xc54203281bba7a3fc61e1908069229d5f0949dfb7d6cea02eed9db99de2271ee	99751772707806	0x5dca2483280d9727c80b5518fac4556617fb194f

Example Query

Query with partition filter

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

WETHBridgePoolProd_LiquidityRemoved_event

Liquidity withdrawal events from Across v1 WETH bridge pool on Ethereum, tracking LP token burns and corresponding WETH amounts removed by liquidity providers. Used for analyzing liquidity provider behavior and pool depth changes 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_lpTokensBurnt`	`STRING`	Quantity of liquidity provider tokens burned when removing liquidity from the pool. Numeric string representation in smallest token denomination.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	in_lpTokensBurnt	transaction_hash	in_liquidityProvider
0x7355efc63ae731f584380a9838292c7046c1e433	false	4235886542869669270	286	13830443	2021-12-18T17:27:00.000Z	4223705933027161036	0xa1ccb2c9a6f1265c047b48562b599b1ed0d81bda9d3e5be68fe35c37e845fdd0	0xe6e10ac150159dd2fcf7c8909d9eb5fd3331bd99
0x7355efc63ae731f584380a9838292c7046c1e433	false	2001830240108175731	434	13826912	2021-12-18T04:23:07.000Z	1996129599015412531	0xa54f71f8ba515ad019ce6b58fd0b3b3668c8e1453ed64066f4f687e3826f6e35	0x5b94f066d207f9a087610ff8b5c490521cfafba5
0x7355efc63ae731f584380a9838292c7046c1e433	false	5000000448739439	51	13831135	2021-12-18T19:54:19.000Z	4985597133224776	0xf15366f75a11423afa311201fa66c97389311e29a6e139b56c055b1b537e308a	0xfee044650102855c553dba07729326b9d48c2b5f

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AcceleratingDistributor_RewardsWithdrawn_event

AcrossMerkleDistributor_Claimed_event

AcrossMerkleDistributor_ClaimFor_event

BADGERBridgePoolProd_LiquidityAdded_event

BADGERBridgePoolProd_LiquidityRemoved_event

BOBABridgePoolProd_LiquidityAdded_event

BOBABridgePoolProd_LiquidityRemoved_event

BridgePoolProd_DepositRelayed_event

BridgePoolProd_LiquidityAdded_event

BridgePoolProd_LiquidityRemoved_event

DAIBridgePoolProd_LiquidityAdded_event

DAIBridgePoolProd_LiquidityRemoved_event

HubPool_L1TokenEnabledForLiquidityProvision_event

HubPool_LiquidityAdded_event

HubPool_LiquidityRemoved_event

HubPool_RootBundleExecuted_event

HubPool_SetPoolRebalanceRoute_event

HubPool_setPoolRebalanceRoute_function

UMABridgePoolProd_LiquidityAdded_event

UMABridgePoolProd_LiquidityRemoved_event

USDCBridgePoolProd_LiquidityAdded_event

USDCBridgePoolProd_LiquidityRemoved_event

WBTCBridgePoolProd_LiquidityAdded_event

WBTCBridgePoolProd_LiquidityRemoved_event

WETHBridgePoolProd_LiquidityAdded_event

WETHBridgePoolProd_LiquidityRemoved_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AcceleratingDistributor_RewardsWithdrawn_event

​AcrossMerkleDistributor_Claimed_event

​AcrossMerkleDistributor_ClaimFor_event

​BADGERBridgePoolProd_LiquidityAdded_event

​BADGERBridgePoolProd_LiquidityRemoved_event

​BOBABridgePoolProd_LiquidityAdded_event

​BOBABridgePoolProd_LiquidityRemoved_event

​BridgePoolProd_DepositRelayed_event

​BridgePoolProd_LiquidityAdded_event

​BridgePoolProd_LiquidityRemoved_event

​DAIBridgePoolProd_LiquidityAdded_event

​DAIBridgePoolProd_LiquidityRemoved_event

​HubPool_L1TokenEnabledForLiquidityProvision_event

​HubPool_LiquidityAdded_event

​HubPool_LiquidityRemoved_event

​HubPool_RootBundleExecuted_event

​HubPool_SetPoolRebalanceRoute_event

​HubPool_setPoolRebalanceRoute_function

​UMABridgePoolProd_LiquidityAdded_event

​UMABridgePoolProd_LiquidityRemoved_event

​USDCBridgePoolProd_LiquidityAdded_event

​USDCBridgePoolProd_LiquidityRemoved_event

​WBTCBridgePoolProd_LiquidityAdded_event

​WBTCBridgePoolProd_LiquidityRemoved_event

​WETHBridgePoolProd_LiquidityAdded_event

​WETHBridgePoolProd_LiquidityRemoved_event

Tables

AcceleratingDistributor_RewardsWithdrawn_event

AcrossMerkleDistributor_Claimed_event

AcrossMerkleDistributor_ClaimFor_event

BADGERBridgePoolProd_LiquidityAdded_event

BADGERBridgePoolProd_LiquidityRemoved_event

BOBABridgePoolProd_LiquidityAdded_event

BOBABridgePoolProd_LiquidityRemoved_event

BridgePoolProd_DepositRelayed_event

BridgePoolProd_LiquidityAdded_event

BridgePoolProd_LiquidityRemoved_event

DAIBridgePoolProd_LiquidityAdded_event

DAIBridgePoolProd_LiquidityRemoved_event

HubPool_L1TokenEnabledForLiquidityProvision_event

HubPool_LiquidityAdded_event

HubPool_LiquidityRemoved_event

HubPool_RootBundleExecuted_event

HubPool_SetPoolRebalanceRoute_event

HubPool_setPoolRebalanceRoute_function

UMABridgePoolProd_LiquidityAdded_event

UMABridgePoolProd_LiquidityRemoved_event

USDCBridgePoolProd_LiquidityAdded_event

USDCBridgePoolProd_LiquidityRemoved_event

WBTCBridgePoolProd_LiquidityAdded_event

WBTCBridgePoolProd_LiquidityRemoved_event

WETHBridgePoolProd_LiquidityAdded_event

WETHBridgePoolProd_LiquidityRemoved_event