across_v2_ethereum

Tables

EthereumSpokePool_FilledRelay_event

Relay fulfillment events from Across Protocol v2 on Ethereum, recording cross-chain bridge transfers completed by relayers. Contains deposit details, fee structures, and routing information for analyzing bridge volume, relayer performance, and cross-chain liquidity 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_totalFilledAmount`	`STRING`	Cumulative amount of tokens filled for the deposit including the current fill. Numeric string representation of token quantity in smallest denomination.
`in_fillAmount`	`STRING`	Amount of tokens actually filled in the relay transaction. Numeric string representation of token quantity in smallest denomination.
`in_repaymentChainId`	`STRING`	Chain identifier for the blockchain where the relayer will be reimbursed for fulfilling the cross-chain transfer. Numeric string representing the standard chain ID.
`in_originChainId`	`STRING`	Chain identifier for the source blockchain where the cross-chain transfer originated. Numeric string representing the standard chain ID.
`in_destinationChainId`	`STRING`	Chain identifier for the destination blockchain where tokens or messages will be received. Numeric string representing the standard chain ID.
`in_relayerFeePct`	`STRING`	Relayer fee as a percentage for the cross-chain transfer. Numeric string representing the fee in basis points with 18-decimal precision.
`in_appliedRelayerFeePct`	`STRING`	Relayer fee percentage actually applied to the cross-chain transfer. Numeric string representing the fee in basis points with 18-decimal precision.
`in_realizedLpFeePct`	`STRING`	Liquidity provider fee percentage actually charged for the cross-chain transfer. Numeric string representing the fee in basis points with 18-decimal precision.
`in_depositId`	`STRING`	Unique identifier for the cross-chain deposit operation. Numeric string representing the sequential deposit index within the protocol.
`in_destinationToken`	`STRING`	Contract address of the token being received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. 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_isSlowRelay`	`BOOL`	Boolean flag indicating whether the relay was executed through the slow relay mechanism rather than the fast relay path.

Sample Data

address	removed	in_amount	log_index	in_relayer	block_number	in_depositId	in_depositor	in_recipient	in_fillAmount	in_isSlowRelay	block_timestamp	in_originChainId	in_relayerFeePct	transaction_hash	in_destinationToken	in_realizedLpFeePct	in_repaymentChainId	in_totalFilledAmount	in_destinationChainId	in_appliedRelayerFeePct
0x4d9079bb4165aeb4084c526a32695dcfd2f77381	false	500000000	414	0x15652636f3898f550b257b89926d5566821c32e1	16582613	228540	0x3ccb0f1f6cc0709f491a2d25b4fbca5fe78870e8	0x3ccb0f1f6cc0709f491a2d25b4fbca5fe78870e8	500000000	false	2023-02-08T07:36:47.000Z	10	8909740000000000	0xd19eb86cf667aa79151952d7f1782e3b951cd93ae82df85b40fc422458f7bf2d	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	380892276744279	1	500000000	1	8909740000000000
0x4d9079bb4165aeb4084c526a32695dcfd2f77381	false	103549200000000000000	108	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	16587222	228770	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0x3d7649127a9db2d11ab38a7456950192ad8fe9f0	103549200000000000000	false	2023-02-08T23:08:59.000Z	10	67245824813717551	0xf309da7217e9de01e20f6b0da6021ed7d5c4d2d43e3e35df28239be67be47661	0x6b175474e89094c44da98b954eedeac495271d0f	380892276744444	1	103549200000000000000	1	67245824813717551
0x4d9079bb4165aeb4084c526a32695dcfd2f77381	false	21842034489957832704920	109	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	16584171	228631	0x16ec2aea80863c1fb4e13440778d0c9967fc51cb	0x16ec2aea80863c1fb4e13440778d0c9967fc51cb	21842034489957832704920	false	2023-02-08T12:50:35.000Z	10	405853638611538	0x68959bff25cef934490ff45decefa43d748d010ccf742c5f3c15a52936f48d03	0x6b175474e89094c44da98b954eedeac495271d0f	380892276744451	1	21842034489957832704920	1	405853638611538

Example Query

Query with partition filter

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

EthereumSpokePool_FundsDeposited_event

Deposit events from Across Protocol v2’s Ethereum SpokePool contract tracking cross-chain bridge transfers with token amounts, relayer fees, and destination chain identifiers. Used for analyzing bridge volumes, fee rates, and deposit patterns between Ethereum and Layer 2 networks like Optimism.

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_originChainId`	`STRING`	Chain identifier for the source blockchain where the cross-chain transfer originated. Numeric string representing the standard chain ID.
`in_destinationChainId`	`STRING`	Chain identifier for the destination blockchain where tokens or messages will be received. Numeric string representing the standard chain ID.
`in_relayerFeePct`	`STRING`	Relayer fee as a percentage for the cross-chain transfer. Numeric string representing the fee in basis points with 18-decimal precision.
`in_depositId`	`STRING`	Unique identifier for the cross-chain deposit operation. Numeric string representing the sequential deposit index within the protocol.
`in_quoteTimestamp`	`STRING`	Unix timestamp when the cross-chain transfer quote was generated. Numeric string representing seconds since epoch.
`in_originToken`	`STRING`	Contract address of the token being deposited on the origin chain. 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_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	block_number	in_depositId	in_depositor	in_recipient	in_originToken	block_timestamp	in_originChainId	in_relayerFeePct	transaction_hash	in_quoteTimestamp	in_destinationChainId
0x4d9079bb4165aeb4084c526a32695dcfd2f77381	false	87971505793076706	270	16443244	62861	0x0b818dc9d41732617dfc5bc8dff03dac632780e1	0x0b818dc9d41732617dfc5bc8dff03dac632780e1	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-01-19T20:29:47.000Z	1	3174315231386884	0x581dd328850a5e86745cd0a82654eb4ad4317618f76e722821f38d0d64992282	1674159863	10
0x4d9079bb4165aeb4084c526a32695dcfd2f77381	false	5000000000000000	528	16440774	62828	0x0f52a7aa2b501eb4472080fee294b1707ca374f1	0x0f52a7aa2b501eb4472080fee294b1707ca374f1	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-01-19T12:12:47.000Z	1	34411121200150600	0x7bf0ffe32342ee7d48b7d08ebbae35f7553fa81951be55ddc3a233b98488781a	1674129851	10
0x4d9079bb4165aeb4084c526a32695dcfd2f77381	false	40000000000000000	365	16442144	62847	0x174fe560f3d26aeb40a15ff3b90537a1a778b783	0x174fe560f3d26aeb40a15ff3b90537a1a778b783	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-01-19T16:48:11.000Z	1	8384871814074450	0xe160f79d0403c8ff5bc83b9bacfb502564f12d1d1923421c68665760ce4944a9	1674146627	10

Example Query

Query with partition filter

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

EthereumSpokePoolV2_FilledRelay_event

Completed cross-chain bridge transfers on Across Protocol V2 where relayers fulfilled deposit requests on Ethereum mainnet. Used for analyzing bridge volumes, relayer profitability, and cross-chain transfer patterns between Ethereum and L2s like Arbitrum, Optimism, Base, and Polygon.

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_totalFilledAmount`	`STRING`	Cumulative amount of tokens filled for the deposit including the current fill. Numeric string representation of token quantity in smallest denomination.
`in_fillAmount`	`STRING`	Amount of tokens actually filled in the relay transaction. Numeric string representation of token quantity in smallest denomination.
`in_repaymentChainId`	`STRING`	Chain identifier for the blockchain where the relayer will be reimbursed for fulfilling the cross-chain transfer. Numeric string representing the standard chain ID.
`in_originChainId`	`STRING`	Chain identifier for the source blockchain where the cross-chain transfer originated. Numeric string representing the standard chain ID.
`in_destinationChainId`	`STRING`	Chain identifier for the destination blockchain where tokens or messages will be received. Numeric string representing the standard chain ID.
`in_relayerFeePct`	`STRING`	Relayer fee as a percentage for the cross-chain transfer. Numeric string representing the fee in basis points with 18-decimal precision.
`in_realizedLpFeePct`	`STRING`	Liquidity provider fee percentage actually charged for the cross-chain transfer. Numeric string representing the fee in basis points with 18-decimal precision.
`in_depositId`	`STRING`	Unique identifier for the cross-chain deposit operation. Numeric string representing the sequential deposit index within the protocol.
`in_destinationToken`	`STRING`	Contract address of the token being received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. 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_message`	`STRING`	Optional arbitrary data payload for the cross-chain transfer. Hex-encoded byte string with 0x prefix.
`in_updatableRelayData`	`STRUCT<recipient STRING, message STRING, relayerFeePct STRING, isSlowRelay BOOL, payoutAdjustmentPct STRING>`	Composite data structure containing modifiable relay parameters for cross-chain transfers. The recipient field specifies the receiving address, message contains optional payload data, relayerFeePct represents the relayer’s fee percentage with 18-decimal precision, isSlowRelay indicates whether this is a slow relay fulfillment, and payoutAdjustmentPct represents fee adjustments in basis points.

Sample Data

address	removed	in_amount	log_index	in_message	in_relayer	block_number	in_depositId	in_depositor	in_recipient	in_fillAmount	block_timestamp	in_originChainId	in_relayerFeePct	transaction_hash	in_destinationToken	in_realizedLpFeePct	in_repaymentChainId	in_totalFilledAmount	in_destinationChainId	in_updatableRelayData
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	2000000000	126	0x	0x147b12c06d9e8e3837280f783fd8070848d4412e	18894945	1100113	0x0c67fd994b2961cf89ec40d24cf1890b873c7071	0x0c67fd994b2961cf89ec40d24cf1890b873c7071	2000000000	2023-12-30T01:00:47.000Z	8453	3635792500000000	0x0e5bdbc7691bbdbbbeec69d1ae084073a5ced67b983f499bdd9a9f12232abb5e	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	380892276744386	1	2000000000	1	{“message”:“0x”,“recipient”:“0x0c67fd994b2961cf89ec40d24cf1890b873c7071”,“isSlowRelay”:false,“relayerFeePct”:“3635792500000000”,“payoutAdjustmentPct”:“0”}
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	1379895004	113	0x	0x147b12c06d9e8e3837280f783fd8070848d4412e	18900528	1125388	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0x318aa87febc5d4eb1afa25b57002bb62a5cd1852	1379895004	2023-12-30T19:51:47.000Z	137	6344890336909657	0xf9dd582084e4d25502459a42a7c5b983ae403195696230b2ba3b05b8cdbb465d	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	380892276744533	1	1379895004	1	{“message”:“0x”,“recipient”:“0x318aa87febc5d4eb1afa25b57002bb62a5cd1852”,“isSlowRelay”:false,“relayerFeePct”:“6344890336909657”,“payoutAdjustmentPct”:“0”}
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	1026420014808095344	55	0x	0x147b12c06d9e8e3837280f783fd8070848d4412e	18899842	1125278	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0xee1c9ea22901a3559c92753db43a430a40d9b1d1	1026420014808095344	2023-12-30T17:33:23.000Z	137	5329325249303023	0x46e9b79076c5accb57da841506a069c0cfe640478bc16b3c46a92d89eedd6d3a	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	399744091432053	1	1026420014808095344	1	{“message”:“0x”,“recipient”:“0xee1c9ea22901a3559c92753db43a430a40d9b1d1”,“isSlowRelay”:false,“relayerFeePct”:“5329325249303023”,“payoutAdjustmentPct”:“0”}

Example Query

Query with partition filter

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

EthereumSpokePoolV2_FundsDeposited_event

Cross-chain bridge deposit events from Across Protocol V2 on Ethereum, capturing token transfers with origin/destination chains, relayer fees, and deposit identifiers. Used for analyzing bridge volume, fee rates, and cross-chain token flow patterns between Ethereum and destination chains like Optimism and Polygon.

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_originChainId`	`STRING`	Chain identifier for the source blockchain where the cross-chain transfer originated. Numeric string representing the standard chain ID.
`in_destinationChainId`	`STRING`	Chain identifier for the destination blockchain where tokens or messages will be received. Numeric string representing the standard chain ID.
`in_relayerFeePct`	`STRING`	Relayer fee as a percentage for the cross-chain transfer. Numeric string representing the fee in basis points with 18-decimal precision.
`in_depositId`	`STRING`	Unique identifier for the cross-chain deposit operation. Numeric string representing the sequential deposit index within the protocol.
`in_quoteTimestamp`	`STRING`	Unix timestamp when the cross-chain transfer quote was generated. Numeric string representing seconds since epoch.
`in_originToken`	`STRING`	Contract address of the token being deposited on the origin chain. 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_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in_message`	`STRING`	Optional arbitrary data payload for the cross-chain transfer. Hex-encoded byte string with 0x prefix.

Sample Data

address	removed	in_amount	log_index	in_message	block_number	in_depositId	in_depositor	in_recipient	in_originToken	block_timestamp	in_originChainId	in_relayerFeePct	transaction_hash	in_quoteTimestamp	in_destinationChainId
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	500000000	93	0x	18588399	1063823	0xa82661ce6ff31ffbba0c712ae308729fcd2f74d1	0xa82661ce6ff31ffbba0c712ae308729fcd2f74d1	0xdac17f958d2ee523a2206206994597c13d831ec7	2023-11-17T01:43:47.000Z	1	666274000000000	0x4e6349f6148816539aa8861b7c32f21b2822547a7da6b11cab613eaa807134c0	1700184900	10
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	965821992	167	0x	18588512	1063833	0xc7487d2763b3e70c497b1d99ab439f5679b82210	0xc7487d2763b3e70c497b1d99ab439f5679b82210	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2023-11-17T02:06:23.000Z	1	410128868148637	0x42d172d9edf5bf424ae78a58fdc1ce1a19c0f9fc03fe0979eec0604a129df106	1700186400	10
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	4000000000	300	0x	18592552	1064159	0x922dd181a24e9dadcbf6cd76b3fe50a5be239655	0x922dd181a24e9dadcbf6cd76b3fe50a5be239655	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2023-11-17T15:40:59.000Z	1	255710750000000	0x7562fbe7a3888be9268b64af32104a616dce49c2a936c4739840df597f7233db	1700235300	10

Example Query

Query with partition filter

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

EthereumSpokePoolV2_TokensBridged_event

Token bridge completion events from Across Protocol V2 on Ethereum, recording tokens returned from Layer 2 chains to Ethereum mainnet. Used for tracking cross-chain bridge settlement flows and reconciling liquidity pools across supported chains.

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_amountToReturn`	`STRING`	Token amount to be returned to the caller in the bridging operation. Numeric string value representing the amount in the token’s smallest unit.
`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_leafId`	`STRING`	Sequential identifier for a leaf in the merkle tree structure used for cross-chain token bridging operations. Numeric string value.
`in_l2TokenAddress`	`STRING`	Contract address of the token being bridged on the Layer 2 network. Hex-encoded, 66-character string including 0x prefix with leading zeros padding.
`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	block_number	block_timestamp	transaction_hash	in_amountToReturn	in_l2TokenAddress
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	0xca11bde05977b3631167028862be2a173976ca11	2	241	1	17230947	2023-05-10T15:40:59.000Z	0xb05a1eeaea8834bdf12d4e95ff26cfd9083c36a515cbaf6a5db823b81d3dc3bc	97110016159	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	0xca11bde05977b3631167028862be2a173976ca11	1	289	1	17231686	2023-05-10T18:10:59.000Z	0xf4d3958ecbfd1a9940467fbb2fe7b47091959cc780e30a3e53d4d900b8c8d57d	200989397214	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	0xca11bde05977b3631167028862be2a173976ca11	1	249	1	17232428	2023-05-10T20:40:59.000Z	0x1a5acfa00fa43c790b4775a9f47136ccccbae01e721969dd732b9febe772a4f8	48641419949210186402	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2

Example Query

Query with partition filter

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

EthereumSpokePoolV2p5_FilledRelay_event

Completed cross-chain bridge relay events from Across Protocol V2.5 on Ethereum, recording deposits fulfilled by relayers with token amounts, fees, origin chains, and execution details. Useful for analyzing bridge liquidity provision, relayer profitability, and cross-chain transfer volumes.

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_inputToken`	`STRING`	Contract address of the token being deposited or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_outputToken`	`STRING`	Contract address of the token to be received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_inputAmount`	`STRING`	Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_repaymentChainId`	`STRING`	Chain identifier for the blockchain where the relayer will be reimbursed for fulfilling the cross-chain transfer. Numeric string representing the standard chain ID.
`in_originChainId`	`STRING`	Chain identifier for the source blockchain where the cross-chain transfer originated. Numeric string representing the standard chain ID.
`in_depositId`	`STRING`	Unique identifier for the cross-chain deposit operation. Numeric string representing the sequential deposit index within the protocol.
`in_fillDeadline`	`STRING`	Unix timestamp marking the final moment by which a cross-chain relay must be fulfilled. Numeric string representing seconds since epoch.
`in_exclusivityDeadline`	`STRING`	Unix timestamp marking the end of the exclusive relay period. Numeric string representing seconds since epoch, after which any relayer can fulfill the transfer.
`in_exclusiveRelayer`	`STRING`	Address designated with exclusive rights to fulfill the cross-chain transfer during the exclusivity period. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. 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_messageHash`	`STRING`	Hash of the cross-chain message data being transmitted. 66-character hex string including 0x prefix.
`in_relayExecutionInfo`	`STRUCT<updatedRecipient STRING, updatedMessageHash STRING, updatedOutputAmount STRING, fillType INT64>`	Structured relay fulfillment details capturing modifications applied at execution time. Contains updated recipient address, output amount, message data, and fill type indicator (0=normal, 1=slow, 2=speed-up).

Sample Data

address	removed	log_index	in_relayer	block_number	in_depositId	in_depositor	in_recipient	in_inputToken	in_inputAmount	in_messageHash	in_outputToken	block_timestamp	in_fillDeadline	in_outputAmount	in_originChainId	transaction_hash	in_exclusiveRelayer	in_repaymentChainId	in_relayExecutionInfo
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	398	0x00000000000000000000000007ae8551be970cb1cca11dd7a11f47ae82e70e67	22384862	1312822	0x0000000000000000000000007a16ff8270133f063aab6c9977183d9e72835428	0x0000000000000000000000007a16ff8270133f063aab6c9977183d9e72835428	0x00000000000000000000000006efdbff2a14a7c8e15944d1f4a48f9f95f663a4	45000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2025-04-30T22:33:35.000Z	1746064067	44986652843	534352	0x30596480391b935cb9fb72da49f1a21a16b7a58d7895205864c25e3fd46d5d5a	0x0000000000000000000000000000000000000000000000000000000000000000	534352	{“fillType”:0,“updatedRecipient”:“0x0000000000000000000000007a16ff8270133f063aab6c9977183d9e72835428”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“44986652843”}
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	629	0x00000000000000000000000007ae8551be970cb1cca11dd7a11f47ae82e70e67	22382216	136609	0x00000000000000000000000085abe641ae13a0653d5467460d754f53f9a598ee	0x00000000000000000000000085abe641ae13a0653d5467460d754f53f9a598ee	0x000000000000000000000000078d782b760474a361dda0af3839290b0ef57ad6	92951000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2025-04-30T13:39:47.000Z	1746032075	92941106821	130	0xa68fbcd2f8463b98b672324c7c1ca3077049c63a3865f7d99ad88fd6fbf9d24f	0x0000000000000000000000000000000000000000000000000000000000000000	1	{“fillType”:0,“updatedRecipient”:“0x00000000000000000000000085abe641ae13a0653d5467460d754f53f9a598ee”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“92941106821”}
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	494	0x00000000000000000000000007ae8551be970cb1cca11dd7a11f47ae82e70e67	22379214	135553	0x00000000000000000000000030ffa36ae5dd20f28471d6ef2163ab17f34d1bfe	0x00000000000000000000000030ffa36ae5dd20f28471d6ef2163ab17f34d1bfe	0x000000000000000000000000078d782b760474a361dda0af3839290b0ef57ad6	76306813108	0x0000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2025-04-30T03:34:47.000Z	1745995751	76298955341	130	0xcb3c7838630aaa7a7eb7ae640bf82f9cbcfe391aef88ea16f7e14369f23b50d8	0x0000000000000000000000000000000000000000000000000000000000000000	1	{“fillType”:0,“updatedRecipient”:“0x00000000000000000000000030ffa36ae5dd20f28471d6ef2163ab17f34d1bfe”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“76298955341”}

Example Query

Query with partition filter

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

EthereumSpokePoolV2p5_FilledV3Relay_event

Cross-chain bridge relay fulfillment events from Across Protocol V3 on Ethereum, recording token transfers from origin chains (Arbitrum, Optimism, Base, Polygon, zkSync Era) with depositor, relayer, amounts, and execution details for analyzing bridge volume 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_inputToken`	`STRING`	Contract address of the token being deposited or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_outputToken`	`STRING`	Contract address of the token to be received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_inputAmount`	`STRING`	Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_repaymentChainId`	`STRING`	Chain identifier for the blockchain where the relayer will be reimbursed for fulfilling the cross-chain transfer. Numeric string representing the standard chain ID.
`in_originChainId`	`STRING`	Chain identifier for the source blockchain where the cross-chain transfer originated. Numeric string representing the standard chain ID.
`in_depositId`	`STRING`	Unique identifier for the cross-chain deposit operation. Numeric string representing the sequential deposit index within the protocol.
`in_fillDeadline`	`STRING`	Unix timestamp marking the final moment by which a cross-chain relay must be fulfilled. Numeric string representing seconds since epoch.
`in_exclusivityDeadline`	`STRING`	Unix timestamp marking the end of the exclusive relay period. Numeric string representing seconds since epoch, after which any relayer can fulfill the transfer.
`in_exclusiveRelayer`	`STRING`	Address designated with exclusive rights to fulfill the cross-chain transfer during the exclusivity period. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. 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_message`	`STRING`	Optional arbitrary data payload for the cross-chain transfer. Hex-encoded byte string with 0x prefix.
`in_relayExecutionInfo`	`STRUCT<updatedRecipient STRING, updatedMessage STRING, updatedOutputAmount STRING, fillType INT64>`	Structured relay fulfillment details capturing modifications applied at execution time. Contains updated recipient address, output amount, message data, and fill type indicator (0=normal, 1=slow, 2=speed-up).

Sample Data

address	removed	log_index	in_message	in_relayer	block_number	in_depositId	in_depositor	in_recipient	in_inputToken	in_inputAmount	in_outputToken	block_timestamp	in_fillDeadline	in_outputAmount	in_originChainId	transaction_hash	in_exclusiveRelayer	in_repaymentChainId	in_relayExecutionInfo
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	309	0x	0x0000000000000000000000000000000000000000	19612574	1516397	0x3143b14a0df68c670c525a3549f824a977b0e10a	0x3143b14a0df68c670c525a3549f824a977b0e10a	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	7577140398606768849991	0xba100000625a3754423978a60c9317c58a424e3d	2024-04-08T17:56:35.000Z	4294967295	7563839062139809058775	42161	0xd15e6195309567e6deb83a7d24761136d92632590935d363f6678332a6fa2214	0x0000000000000000000000000000000000000000	0	{“fillType”:2,“updatedMessage”:“0x”,“updatedRecipient”:“0x3143b14a0df68c670c525a3549f824a977b0e10a”,“updatedOutputAmount”:“7571423226457026987158”}
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	307	0x	0x0000000000000000000000000000000000000000	19612574	1336410	0x3a23f943181408eac424116af7b7790c94cb97a5	0x79b6e5df8e627897cac89420e06a02f1c44bae2a	0x8700daec35af8ff88c16bdf0418774cb3d7599b4	15625000000000000000000	0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f	2024-04-08T17:56:35.000Z	4294967295	15600944168410278093750	10	0xd15e6195309567e6deb83a7d24761136d92632590935d363f6678332a6fa2214	0x0000000000000000000000000000000000000000	0	{“fillType”:2,“updatedMessage”:“0x”,“updatedRecipient”:“0x79b6e5df8e627897cac89420e06a02f1c44bae2a”,“updatedOutputAmount”:“15613210484412280109375”}
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	191	0x	0x07ae8551be970cb1cca11dd7a11f47ae82e70e67	19612360	1283729	0x37fee7dc51f65e7c39d41e67cbfb28d7846b44d5	0x37fee7dc51f65e7c39d41e67cbfb28d7846b44d5	0x4200000000000000000000000000000000000006	3093690268552808849	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2024-04-08T17:13:35.000Z	4294967295	3085333212856423810	8453	0x2d25681206b3ee1d77672ae492dad824784b28c00973bdd24c474b765a8f83a4	0x0000000000000000000000000000000000000000	1	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0x37fee7dc51f65e7c39d41e67cbfb28d7846b44d5”,“updatedOutputAmount”:“3085333212856423810”}

Example Query

Query with partition filter

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

EthereumSpokePoolV2p5_FundsDeposited_event

Cross-chain bridge deposit events from Across Protocol V2.5 on Ethereum, capturing user transfers with input/output tokens, amounts, destination chains, and relay parameters. Used for tracking bridge volume, fees, and relayer exclusivity periods across supported chains like Polygon, Arbitrum, and Base.

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_inputToken`	`STRING`	Contract address of the token being deposited or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_outputToken`	`STRING`	Contract address of the token to be received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_inputAmount`	`STRING`	Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_destinationChainId`	`STRING`	Chain identifier for the destination blockchain where tokens or messages will be received. Numeric string representing the standard chain ID.
`in_depositId`	`STRING`	Unique identifier for the cross-chain deposit operation. Numeric string representing the sequential deposit index within the protocol.
`in_quoteTimestamp`	`STRING`	Unix timestamp when the cross-chain transfer quote was generated. Numeric string representing seconds since epoch.
`in_fillDeadline`	`STRING`	Unix timestamp marking the final moment by which a cross-chain relay must be fulfilled. Numeric string representing seconds since epoch.
`in_exclusivityDeadline`	`STRING`	Unix timestamp marking the end of the exclusive relay period. Numeric string representing seconds since epoch, after which any relayer can fulfill the transfer.
`in_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. 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_exclusiveRelayer`	`STRING`	Address designated with exclusive rights to fulfill the cross-chain transfer during the exclusivity period. Hex-encoded, 0x-prefixed, 42-character string.
`in_message`	`STRING`	Optional arbitrary data payload for the cross-chain transfer. Hex-encoded byte string with 0x prefix.

Sample Data

address	removed	log_index	in_message	block_number	in_depositId	in_depositor	in_recipient	in_inputToken	in_inputAmount	in_outputToken	block_timestamp	in_fillDeadline	in_outputAmount	transaction_hash	in_quoteTimestamp	in_exclusiveRelayer	in_destinationChainId
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	105	0x0000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000253a0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000584982f8d3c76485b459c33d9ecf666635e3dffd0000000000000000000000004e3e1807aa17aed8d1fc580dda552079d9427ece000000000000000000000000000000000000000000000000000000000001df270000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000d73776170416e64556e777261700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000030000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000001bfd67037b42cf73acf2047067bd4f2c47d9bfd60000000000000000000000003bf668fe1ec79a84ca8481cead5dbb30d61cc6850000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000014ee463fe32b8d1e6e85f4520cb0472595cc719e8c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000017a91472df0f82c4bcfe01a274bd521e5d4c66586b7a5b87000000000000000000	23113661	2977065	0x0000000000000000000000003a54f61c8115ee886fbb65cf6bc6dc625d540bae	0x000000000000000000000000e0166434a2ad67536b5fdafcc9a6c1b41cc5e085	0x000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	35660616000000000	0x0000000000000000000000000000000000000000000000000000000000000000	2025-08-10T22:32:59.000Z	1754879579	35651155865176225	0x09632394f391b0a705aaaf54cdfdf9c015c0169a316d3ccc3cfd732b4cabd885	1754865179	0x0000000000000000000000000000000000000000000000000000000000000000	137
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	250	0x0000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000253c0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000403a09802812278466426f03b959e882b13ebf080000000000000000000000004e3e1807aa17aed8d1fc580dda552079d9427ece00000000000000000000000000000000000000000000000000000000000564840000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000d73776170416e64556e777261700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000030000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000001bfd67037b42cf73acf2047067bd4f2c47d9bfd60000000000000000000000003bf668fe1ec79a84ca8481cead5dbb30d61cc6850000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000014353d5884902278ea6d3286e6a1fae84714919de40000000000000000000000000000000000000000000000000000000000000000000000000000000000000017a91472df0f82c4bcfe01a274bd521e5d4c66586b7a5b87000000000000000000	23113668	2977074	0x0000000000000000000000003a54f61c8115ee886fbb65cf6bc6dc625d540bae	0x000000000000000000000000e0166434a2ad67536b5fdafcc9a6c1b41cc5e085	0x000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	102215110857374189	0x0000000000000000000000000000000000000000000000000000000000000000	2025-08-10T22:34:23.000Z	1754879663	102198232182068978	0x1229ce41ef8ee6040b50bbbb2cbda14f0f218dad65aa8e8eb8ed478ebfeb23aa	1754865263	0x0000000000000000000000000000000000000000000000000000000000000000	137
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	284	0x000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000024c10000000000000000000000000000000000000000000000000000000000000001000000000000000000000000096f411084066b9d0e4400a39267726e3e1e5a380000000000000000000000004e3e1807aa17aed8d1fc580dda552079d9427ece0000000000000000000000000000000000000000000000000000000000012c830000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000d73776170416e64556e777261700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000030000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000001bfd67037b42cf73acf2047067bd4f2c47d9bfd60000000000000000000000003bf668fe1ec79a84ca8481cead5dbb30d61cc6850000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000140e018b9c733f16197c674666cd6350063e960abb0000000000000000000000000000000000000000000000000000000000000000000000000000000000000017a91472df0f82c4bcfe01a274bd521e5d4c66586b7a5b87000000000000000000	23107460	2972992	0x0000000000000000000000003a54f61c8115ee886fbb65cf6bc6dc625d540bae	0x000000000000000000000000e0166434a2ad67536b5fdafcc9a6c1b41cc5e085	0x000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	21513427530882014	0x0000000000000000000000000000000000000000000000000000000000000000	2025-08-10T01:44:47.000Z	1754804687	21505847529371709	0x94dfb7b92ecc373169ebb6ea45017190bd74332e0af1098eb241d9514a94904f	1754790287	0x0000000000000000000000000000000000000000000000000000000000000000	137

Example Query

Query with partition filter

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

EthereumSpokePoolV2p5_TokensBridged_event

Token bridge completion events from Across Protocol v2.5 on Ethereum, recording tokens returned to users after cross-chain transfers. Used for tracking bridge settlement amounts, token flows, and analyzing liquidity provider rebalancing 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_amountToReturn`	`STRING`	Token amount to be returned to the caller in the bridging operation. Numeric string value representing the amount in the token’s smallest unit.
`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_leafId`	`STRING`	Sequential identifier for a leaf in the merkle tree structure used for cross-chain token bridging operations. Numeric string value.
`in_l2TokenAddress`	`STRING`	Contract address of the token being bridged on the Layer 2 network. Hex-encoded, 66-character string including 0x prefix with leading zeros padding.
`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	block_number	block_timestamp	transaction_hash	in_amountToReturn	in_l2TokenAddress
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	0xca11bde05977b3631167028862be2a173976ca11	2	176	1	22619778	2025-06-02T21:51:35.000Z	0x1b014485f5afa170ab121ef9b5ab73d109096fd373ae032a61883fc9ec0249e8	25885024195566011099	0x000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	0xca11bde05977b3631167028862be2a173976ca11	0	157	1	22619778	2025-06-02T21:51:35.000Z	0x1b014485f5afa170ab121ef9b5ab73d109096fd373ae032a61883fc9ec0249e8	2644114255203686555264	0x0000000000000000000000006b175474e89094c44da98b954eedeac495271d0f
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	0xca11bde05977b3631167028862be2a173976ca11	1	164	1	22619778	2025-06-02T21:51:35.000Z	0x1b014485f5afa170ab121ef9b5ab73d109096fd373ae032a61883fc9ec0249e8	407043415396	0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48

Example Query

Query with partition filter

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

EthereumSpokePoolV2p5_V3FundsDeposited_event

Cross-chain bridge deposit events from Across Protocol V3 on Ethereum, recording token transfers initiated from Ethereum to destination chains like Polygon, Arbitrum, and Base. Contains deposit amounts, recipient addresses, fill deadlines, and quoted exchange rates for tracking bridge utilization 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_inputToken`	`STRING`	Contract address of the token being deposited or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_outputToken`	`STRING`	Contract address of the token to be received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_inputAmount`	`STRING`	Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_destinationChainId`	`STRING`	Chain identifier for the destination blockchain where tokens or messages will be received. Numeric string representing the standard chain ID.
`in_depositId`	`STRING`	Unique identifier for the cross-chain deposit operation. Numeric string representing the sequential deposit index within the protocol.
`in_quoteTimestamp`	`STRING`	Unix timestamp when the cross-chain transfer quote was generated. Numeric string representing seconds since epoch.
`in_fillDeadline`	`STRING`	Unix timestamp marking the final moment by which a cross-chain relay must be fulfilled. Numeric string representing seconds since epoch.
`in_exclusivityDeadline`	`STRING`	Unix timestamp marking the end of the exclusive relay period. Numeric string representing seconds since epoch, after which any relayer can fulfill the transfer.
`in_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. 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_exclusiveRelayer`	`STRING`	Address designated with exclusive rights to fulfill the cross-chain transfer during the exclusivity period. Hex-encoded, 0x-prefixed, 42-character string.
`in_message`	`STRING`	Optional arbitrary data payload for the cross-chain transfer. Hex-encoded byte string with 0x prefix.

Sample Data

address	removed	log_index	in_message	block_number	in_depositId	in_depositor	in_recipient	in_inputToken	in_inputAmount	in_outputToken	block_timestamp	in_fillDeadline	in_outputAmount	transaction_hash	in_quoteTimestamp	in_exclusiveRelayer	in_destinationChainId
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	62	0x	19421743	1167202	0x0837ff2b43d496fba7531a18516eb86c9c5a7b6d	0x0837ff2b43d496fba7531a18516eb86c9c5a7b6d	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	260000000000000000	0x0000000000000000000000000000000000000000	2024-03-12T21:39:47.000Z	4294967295	259963277662234481	0x24bc18e8e3df10c974980e13e577f470aeadff33dc9419861ece72cd264c9cfb	1710279000	0x0000000000000000000000000000000000000000	137
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	143	0x	19415294	1166289	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0x8f6da0c1662ee72bf3b333d94efc1d9ebb615577	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	35000000000000000	0x0000000000000000000000000000000000000000	2024-03-12T00:01:47.000Z	4294967295	34548409093259755	0xf0aed904b1101cc86387e53878161d94604e1f148a2471f40112b76ca26f674e	1710201300	0x0000000000000000000000000000000000000000	8453
0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5	false	174	0x	19415338	1166301	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0x4823be7f266c5bca85b7dbd8e41f4710e1c49a7b	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	30000000000	0x0000000000000000000000000000000000000000	2024-03-12T00:10:47.000Z	4294967295	29996860872	0x5e776e6ec77af0a35cc72d84b2e145e67936b869ad207282aa5f9959310ed746	1710201900	0x0000000000000000000000000000000000000000	137

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

EthereumSpokePool_FilledRelay_event

EthereumSpokePool_FundsDeposited_event

EthereumSpokePoolV2_FilledRelay_event

EthereumSpokePoolV2_FundsDeposited_event

EthereumSpokePoolV2_TokensBridged_event

EthereumSpokePoolV2p5_FilledRelay_event

EthereumSpokePoolV2p5_FilledV3Relay_event

EthereumSpokePoolV2p5_FundsDeposited_event

EthereumSpokePoolV2p5_TokensBridged_event

EthereumSpokePoolV2p5_V3FundsDeposited_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​EthereumSpokePool_FilledRelay_event

​EthereumSpokePool_FundsDeposited_event

​EthereumSpokePoolV2_FilledRelay_event

​EthereumSpokePoolV2_FundsDeposited_event

​EthereumSpokePoolV2_TokensBridged_event

​EthereumSpokePoolV2p5_FilledRelay_event

​EthereumSpokePoolV2p5_FilledV3Relay_event

​EthereumSpokePoolV2p5_FundsDeposited_event

​EthereumSpokePoolV2p5_TokensBridged_event

​EthereumSpokePoolV2p5_V3FundsDeposited_event

Tables

EthereumSpokePool_FilledRelay_event

EthereumSpokePool_FundsDeposited_event

EthereumSpokePoolV2_FilledRelay_event

EthereumSpokePoolV2_FundsDeposited_event

EthereumSpokePoolV2_TokensBridged_event

EthereumSpokePoolV2p5_FilledRelay_event

EthereumSpokePoolV2p5_FilledV3Relay_event

EthereumSpokePoolV2p5_FundsDeposited_event

EthereumSpokePoolV2p5_TokensBridged_event

EthereumSpokePoolV2p5_V3FundsDeposited_event