across_v2_optimism

Tables

OptimismSpokePool_FilledRelay_event

Completed relay fulfillment events from Across Protocol V2 on Optimism, recording cross-chain bridge transfers with depositor, relayer, fee percentages, and token amounts. Used for analyzing bridge relay execution, relayer performance, and cross-chain liquidity flows between Ethereum mainnet and 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_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_repaymentChainId	in_totalFilledAmount	in_destinationChainId	in_appliedRelayerFeePct
0xa420b2d1c0841415a695b81e5b867bcd07dff8c9	false	1700000000000000000	2	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	77070164	70440	0x6d1e0220914f4fb73af954694564e77024de3693	0x67b20960013b9ddd1d12a642384c88d1585987be	1700000000000000000	false	2023-02-25T18:46:35.000Z	1	250934190941122	0xdb6e19e12387d92285d6b0a4bf75cac4524d431a003c74d1494ed4b630a58292	0x4200000000000000000000000000000000000006	10	1700000000000000000	10	250934190941122
0xa420b2d1c0841415a695b81e5b867bcd07dff8c9	false	1999999999	2	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	76915214	70300	0x6d1e0220914f4fb73af954694564e77024de3693	0xbefc15f65274bbb680976513b6e74bf0181e46e4	1999999999	false	2023-02-25T06:34:39.000Z	1	282902000091451	0x32ba1b5f22458c61ea0cb6af0ee6ae8db77a8efaacb5c31df556cdcd6b927fd2	0x7f5c764cbc14f9669b88837ca1490cca17c31607	10	1999999999	10	282902000091451
0xa420b2d1c0841415a695b81e5b867bcd07dff8c9	false	270000000000000000	2	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	76994547	70368	0x6604b79b688a2e78414f1b91d9a4f2ee4bd51cf6	0x6604b79b688a2e78414f1b91d9a4f2ee4bd51cf6	270000000000000000	false	2023-02-25T12:42:50.000Z	1	1091749362419296	0x708268ed8ffadbbca6713cd8d5aa386876e211dc1a4c787bff32c19b79041347	0x4200000000000000000000000000000000000006	10	270000000000000000	10	1091749362419296

Example Query

Query with partition filter

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

OptimismSpokePool_FundsDeposited_event

Deposit events from Across Protocol V2 bridge on Optimism, recording user-initiated token transfers to destination chains with depositor addresses, amounts, relayer fees, and target chain identifiers. Used for analyzing cross-chain bridge volume and fee dynamics.

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
0xa420b2d1c0841415a695b81e5b867bcd07dff8c9	false	17498152819449693	1	28464076	72556	0x6724eddf4e9ea791748d090a34e0f9e16e2bd4f5	0x6724eddf4e9ea791748d090a34e0f9e16e2bd4f5	0x4200000000000000000000000000000000000006	2022-10-10T03:49:14.000Z	10	242197147420000574	0x718c550d1feb74003056aebbf12cef74c3cc08400cf6e37a52e365f931683353	1665373715	1
0xa420b2d1c0841415a695b81e5b867bcd07dff8c9	false	247600000000000000	1	28468045	72581	0x2077737ab9fe9d8298f2033a3fe09c8d866aabf0	0x2077737ab9fe9d8298f2033a3fe09c8d866aabf0	0x4200000000000000000000000000000000000006	2022-10-10T04:52:46.000Z	10	14531474079271025	0x054c33201c11e214662fd1ee5cc9e7a69835516a560aeef6ed7dfbc2c3324c32	1665377555	1
0xa420b2d1c0841415a695b81e5b867bcd07dff8c9	false	18066029206143459	1	28465545	72567	0x077921a73b0ce86b1377fabfe63d15b95e3f164d	0x077921a73b0ce86b1377fabfe63d15b95e3f164d	0x4200000000000000000000000000000000000006	2022-10-10T04:13:52.000Z	10	237626998772647963	0x4bf99052ad18d0d97bddbc4f813f4c84613b300267e27848a143f5604e9d4a74	1665375215	1

Example Query

Query with partition filter

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

OptimismSpokePoolV2_FilledRelay_event

Completed cross-chain bridge relay events from Across Protocol V2 on Optimism, showing token transfers fulfilled by relayers with origin chain, depositor, recipient, fill amounts, and fee percentages. Used for analyzing bridge volume, relayer profitability, and cross-chain flow patterns between Ethereum, Arbitrum, and 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_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_repaymentChainId	in_totalFilledAmount	in_destinationChainId	in_updatableRelayData
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	51092272	2	0x	0x29850516a9b9a7ff67e64ce2588367f34f75b763	98135810	1004951	0x4efcdb7b77dd9a2d707a570e0db3225f41d126f5	0x4efcdb7b77dd9a2d707a570e0db3225f41d126f5	51092272	2023-05-14T07:38:14.000Z	42161	16991165066998782	0xa6b0b144243615f77c8d10c001f1feee1ce628447726fddc993fe00a0b972c60	0x7f5c764cbc14f9669b88837ca1490cca17c31607	10	51092272	10	{“message”:“0x”,“recipient”:“0x4efcdb7b77dd9a2d707a570e0db3225f41d126f5”,“isSlowRelay”:false,“relayerFeePct”:“16991165066998782”,“payoutAdjustmentPct”:“0”}
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	61224640	2	0x	0x29850516a9b9a7ff67e64ce2588367f34f75b763	98165103	1001840	0x3a23f943181408eac424116af7b7790c94cb97a5	0xdcc0c8bdb2c779232545ea3825dcb58fc6f616df	61224640	2023-05-14T10:00:23.000Z	1	17649339612286817	0x2a23a120cffbedabea604bb3b5581fda4b137d3b03dd5e3238392f2ad778564b	0x7f5c764cbc14f9669b88837ca1490cca17c31607	10	61224640	10	{“message”:“0x”,“recipient”:“0xdcc0c8bdb2c779232545ea3825dcb58fc6f616df”,“isSlowRelay”:false,“relayerFeePct”:“17649339612286817”,“payoutAdjustmentPct”:“0”}
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	5001932	2	0x	0x29850516a9b9a7ff67e64ce2588367f34f75b763	98136274	1004954	0x3a23f943181408eac424116af7b7790c94cb97a5	0x4203bf5021a544850a4c7dca3ae9cb5d8471fdb0	5001932	2023-05-14T07:40:29.000Z	42161	172584932502081195	0x8c5354bb920d5861f14f0615e89b0b9d93c90a1824b7d9f81e796787dea8deb2	0x7f5c764cbc14f9669b88837ca1490cca17c31607	10	5001932	10	{“message”:“0x”,“recipient”:“0x4203bf5021a544850a4c7dca3ae9cb5d8471fdb0”,“isSlowRelay”:false,“relayerFeePct”:“172584932502081195”,“payoutAdjustmentPct”:“0”}

Example Query

Query with partition filter

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

OptimismSpokePoolV2_FundsDeposited_event

Deposit event records from Across Protocol V2 bridge on Optimism, capturing cross-chain transfer initiation with depositor, recipient, token, amount, and relayer fee details. Used for analyzing bridge volume, fee dynamics, and cross-chain fund flows between Optimism and destination chains like Ethereum and Arbitrum.

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
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	20500000000000000	1	0x	106716215	1011233	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0x4906fb37c20479fb334c4b105769a98f590e841e	0x4200000000000000000000000000000000000006	2023-07-10T23:20:07.000Z	10	9228474045707219	0x371a506cf57848863c83c5f6a5648143832fbac46df1baf1e58e27b5fec514fe	1689030600	42161
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	4961500000000000000	1	0x	106699801	1011151	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0xa9e035ab8ffb2f9cf50af146476184abae2acb31	0x4200000000000000000000000000000000000006	2023-07-10T14:12:59.000Z	10	158333467788789	0x59fd4d96f272600033c8f1c7fdee01e23e5e6dc848d3799a3773cd078b89eb26	1688997900	42161
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	103000000000000000	1	0x	106680407	1010938	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0x20f93f6cd2491e2f7ad577bd05cc2ec606f172b5	0x4200000000000000000000000000000000000006	2023-07-10T03:26:31.000Z	10	1571478322968077	0x448506c9bdd25da092daeda5cc30aaa04b348acc0e23d7530fb033516938f05f	1688958900	42161

Example Query

Query with partition filter

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

OptimismSpokePoolV2_TokensBridged_event

Token bridge completion events from Across Protocol V2 on Optimism showing L2 token returns to users. Tracks amount, token address, caller, and leaf ID for reconciling cross-chain transfers and analyzing bridge settlement 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_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
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	0xca11bde05977b3631167028862be2a173976ca11	8	20	10	107071747	2023-07-19T04:51:11.000Z	0x2adc7b116c550851701f947164cd3d828a4f5fc74ea99dbc5e5958c6f023bba0	124211829256444230474	0xfe8b128ba8c78aabc59d4c64cee7ff28e9379921
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	0xca11bde05977b3631167028862be2a173976ca11	10	20	10	107103258	2023-07-19T22:21:33.000Z	0x816c90c392c7a094d8cfcf59606ef9d7ceea1987754bab5c3d28ebf3474c33d5	7332678851034171050221	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	0xca11bde05977b3631167028862be2a173976ca11	8	27	10	107085261	2023-07-19T12:21:39.000Z	0x9011da75eabc909321a01de9d816b7a75c3143379bd638ce8912db220ee86b86	75011508208304645529577	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1

Example Query

Query with partition filter

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

OptimismSpokePoolV2p5_FilledRelay_event

Cross-chain bridge relay completion events from Across Protocol V2.5 on Optimism, recording when relayers fulfill deposit orders by delivering tokens to recipients. Used for tracking bridge execution, relayer performance, and cross-chain transfer settlement between chains like Blast (81457) and Optimism/Ethereum.

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
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	24	0x00000000000000000000000007ae8551be970cb1cca11dd7a11f47ae82e70e67	131860591	1104814	0x00000000000000000000000047bdb621da24532b32088262b2ecd8fb673c843a	0x00000000000000000000000047bdb621da24532b32088262b2ecd8fb673c843a	0x0000000000000000000000004300000000000000000000000000000000000003	11651800000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000da10009cbd5d07dd0cecc66161fc93d7c9000da1	2025-02-12T00:25:59.000Z	1739331611	11636790158624910175848	81457	0xe0764ae67892e95f7dfbd05977e1e8fbf8a4bcaedc58ffe2de78341e3e0534b7	0x0000000000000000000000000000000000000000000000000000000000000000	10	{“fillType”:0,“updatedRecipient”:“0x00000000000000000000000047bdb621da24532b32088262b2ecd8fb673c843a”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“11636790158624910175848”}
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	24	0x00000000000000000000000007ae8551be970cb1cca11dd7a11f47ae82e70e67	131866833	1104841	0x000000000000000000000000a23e3951fb8dac1cf524ad6153d25962a17ad9af	0x000000000000000000000000a23e3951fb8dac1cf524ad6153d25962a17ad9af	0x0000000000000000000000004300000000000000000000000000000000000003	40088355200784678775678	0x0000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000da10009cbd5d07dd0cecc66161fc93d7c9000da1	2025-02-12T03:54:03.000Z	1739344123	40036236868817877379199	81457	0x116553dbca980cbfb5644d444a20b082187fa658fa2977b4853d0fd0a4ba8dad	0x0000000000000000000000000000000000000000000000000000000000000000	10	{“fillType”:0,“updatedRecipient”:“0x000000000000000000000000a23e3951fb8dac1cf524ad6153d25962a17ad9af”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“40036236868817877379199”}
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	33	0x00000000000000000000000007ae8551be970cb1cca11dd7a11f47ae82e70e67	131867557	1104843	0x000000000000000000000000e9bb74fe148e41ff9f0a4cae504005015ee6919d	0x000000000000000000000000e9bb74fe148e41ff9f0a4cae504005015ee6919d	0x0000000000000000000000004300000000000000000000000000000000000003	100142109070350886680087	0x0000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000da10009cbd5d07dd0cecc66161fc93d7c9000da1	2025-02-12T04:18:11.000Z	1739344531	100011209633325025545048	81457	0x2ae84ae7b1c125ffa68f5a32986a94fe018402acea87e8352e6ae64d5ec3ca44	0x0000000000000000000000000000000000000000000000000000000000000000	1	{“fillType”:1,“updatedRecipient”:“0x000000000000000000000000e9bb74fe148e41ff9f0a4cae504005015ee6919d”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“100011209633325025545048”}

Example Query

Query with partition filter

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

OptimismSpokePoolV2p5_FilledV3Relay_event

Completed cross-chain bridge transfers on Across Protocol V3 delivered to Optimism, containing deposit fulfillment records with relayer addresses, origin chain identifiers, input/output token amounts, and execution details. Used for analyzing bridge flow patterns, relayer performance, and cross-chain transfer fees between Base (origin chain 8453) and 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_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
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	86	0x	0x00000000000a59c8d4c548a43660a8950a542a71	124325280	2070047	0xbe62d6e65ae91eaf9896fa6e61cdf32893557eb4	0xbe62d6e65ae91eaf9896fa6e61cdf32893557eb4	0x4200000000000000000000000000000000000006	3500000000000000	0x4200000000000000000000000000000000000006	2024-08-21T14:08:57.000Z	4294967295	3498264563385904	8453	0x3ab5f0f3aa8831954eb9b8d89f85446ae0597f26099cbe96c182435bc87b56ac	0x0000000000000000000000000000000000000000	10	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0xbe62d6e65ae91eaf9896fa6e61cdf32893557eb4”,“updatedOutputAmount”:“3498264563385904”}
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	11	0x	0x00000000000a59c8d4c548a43660a8950a542a71	124316942	2069302	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0x5952c428212e93e12d833079b7c52ba3de8b9768	0x4200000000000000000000000000000000000006	2142585618769476	0x4200000000000000000000000000000000000006	2024-08-21T09:31:01.000Z	4294967295	2141887139588559	8453	0x1745e78419e37ee655d4a39bea77017abf8f980cce4dc9d7434b134a8d56c32f	0x0000000000000000000000000000000000000000	10	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0x5952c428212e93e12d833079b7c52ba3de8b9768”,“updatedOutputAmount”:“2141887139588559”}
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	39	0x	0x00000000000a59c8d4c548a43660a8950a542a71	124325040	2070029	0xfc69baf865b6f5642847181dcca95361f5c5b766	0xfc69baf865b6f5642847181dcca95361f5c5b766	0x4200000000000000000000000000000000000006	86165445619324	0x4200000000000000000000000000000000000006	2024-08-21T14:00:57.000Z	4294967295	85279242416958	8453	0x997e5d424e7d29c671899fda5f52b5eac3366d1594297e5fb2df7f306b2ff08e	0x0000000000000000000000000000000000000000	10	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0xfc69baf865b6f5642847181dcca95361f5c5b766”,“updatedOutputAmount”:“85279242416958”}

Example Query

Query with partition filter

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

OptimismSpokePoolV2p5_FundsDeposited_event

Cross-chain bridge deposit events from Across Protocol V2.5 on Optimism, recording token transfers with input/output amounts, destination chains, fill deadlines, and optional exclusive relayer assignments. Used for tracking bridge flow metrics, analyzing relayer competition dynamics, and monitoring cross-chain transfer 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_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	in_exclusivityDeadline
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	372	0x	135320630	2991390	0x0000000000000000000000000000f902774a9050326139449bfa9d45a0718f2f	0x0000000000000000000000000000f902774a9050326139449bfa9d45a0718f2f	0x0000000000000000000000004200000000000000000000000000000000000006	95919000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	2025-05-03T02:40:37.000Z	1746251727	95904804723706485	0xb9362308c5558acb8ff40e596f717c98d38e6874e6e143a94b5f7a715c58d005	1746239831	0x000000000000000000000000cad97616f91872c02ba3553db315db4015cbe850	8453	1746240042
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	23	0x	135346211	2992982	0x000000000000000000000000000aa047b0bfa841bbf67624843f5f1baeb689f9	0x000000000000000000000000000aa047b0bfa841bbf67624843f5f1baeb689f9	0x0000000000000000000000004200000000000000000000000000000000000006	560000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	2025-05-03T16:53:19.000Z	1746302888	559644449532860	0x64094968c4601acd15b91cd954a789a215bfd02c4574f672120eb7807c4c6624	1746290987	0x00000000000000000000000041ee28ee05341e7fdddc8d433ba66054cd302ca1	130	1746291204
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	406	0x	135331623	2991951	0x000000000000000000000000000cc82da0acff3625bb96161eac97bc40019862	0x000000000000000000000000000cc82da0acff3625bb96161eac97bc40019862	0x0000000000000000000000004200000000000000000000000000000000000006	300000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	2025-05-03T08:47:03.000Z	1746273709	299839428166711	0x76d364cf0aa05e8495966d5c9cafbebaeb4c657b06964a03bbddee6f8515b61c	1746261875	0x000000000000000000000000b96b74874126a787720a464eab3fbd2f35a5d14e	130	1746262028

Example Query

Query with partition filter

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

OptimismSpokePoolV2p5_TokensBridged_event

Token bridge events from Across Protocol V2.5 on Optimism recording L2-to-L1 token returns. Tracks caller addresses, token amounts, leaf identifiers, and destination chain IDs for analyzing cross-chain liquidity flows and bridge settlement 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
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	0xf7bac63fc7ceacf0589f25454ecf5c2ce904997c	6	20	10	133590175	2025-03-24T01:18:47.000Z	0x254b4ad5ec0ad19b59835bfb1082eabc9e4aa7755e6dd1448b082e71b9008bfa	409992157	0x00000000000000000000000068f180fcce6836688e9084f035309e29bf0a2095
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	0xf7bac63fc7ceacf0589f25454ecf5c2ce904997c	5	43	10	133617044	2025-03-24T16:14:25.000Z	0xa10927b2228dda4fbe286b77d5e1ff6df97bdc1ec4b3643da568d923837206ac	196899248197	0x0000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	0xf7bac63fc7ceacf0589f25454ecf5c2ce904997c	6	26	10	141275579	2025-09-17T22:58:55.000Z	0x7afa7d6d2f8b99fd2d7057706a740566086a6992b5239e4fba782e5fc96efbf1	28995355502234348302130	0x0000000000000000000000004e107a0000db66f0e9fd2039288bf811dd1f9c74

Example Query

Query with partition filter

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

OptimismSpokePoolV2p5_V3FundsDeposited_event

Cross-chain bridge deposit events from Across Protocol V2.5 on Optimism, capturing user deposits with input/output token amounts, destination chain IDs, and fill deadlines. Used for tracking bridge flows, analyzing fee spreads between chains, and monitoring relayer exclusivity periods.

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
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	64	0x	123902266	1931184	0xf8d342db903f266de73b10a1e46601bb08a3c195	0x00051d55999c7cd91b17af7276cbecd647dbc000	0x0b2c639c533813f4aa9d7837caf62653d097ff85	15000000000	0x0000000000000000000000000000000000000000	2024-08-11T19:08:29.000Z	1723424909	14995808291	0x609277c0fdebd06951e5af442b37d4c642a4ddc592d300d8c5cc53a671d27f63	1723403075	0x0000000000000000000000000000000000000000	1
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	43	0x	123902759	1931228	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0x0042b1fe93e7bb19a25834d12ee5dfa2d353d95f	0x4200000000000000000000000000000000000006	8291754672014560	0x0000000000000000000000000000000000000000	2024-08-11T19:24:55.000Z	4294967295	8286536003185807	0x7049ea53bc32d6c972473fa383e0c238080afa87e679cc8acb960ba61c557dc6	1723404035	0x0000000000000000000000000000000000000000	42161
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	36	0x	123901718	1931156	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0x0042b1fe93e7bb19a25834d12ee5dfa2d353d95f	0x4200000000000000000000000000000000000006	8457044525149850	0x0000000000000000000000000000000000000000	2024-08-11T18:50:13.000Z	4294967295	8454850614262748	0xc2a96a5f01f0c91f7abeba8d734ec9748a01020f3c69dc25b317c9fcebc251bf	1723402115	0x0000000000000000000000000000000000000000	8453

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

OptimismSpokePool_FilledRelay_event

OptimismSpokePool_FundsDeposited_event

OptimismSpokePoolV2_FilledRelay_event

OptimismSpokePoolV2_FundsDeposited_event

OptimismSpokePoolV2_TokensBridged_event

OptimismSpokePoolV2p5_FilledRelay_event

OptimismSpokePoolV2p5_FilledV3Relay_event

OptimismSpokePoolV2p5_FundsDeposited_event

OptimismSpokePoolV2p5_TokensBridged_event

OptimismSpokePoolV2p5_V3FundsDeposited_event

​Tables

​OptimismSpokePool_FilledRelay_event

​OptimismSpokePool_FundsDeposited_event

​OptimismSpokePoolV2_FilledRelay_event

​OptimismSpokePoolV2_FundsDeposited_event

​OptimismSpokePoolV2_TokensBridged_event

​OptimismSpokePoolV2p5_FilledRelay_event

​OptimismSpokePoolV2p5_FilledV3Relay_event

​OptimismSpokePoolV2p5_FundsDeposited_event

​OptimismSpokePoolV2p5_TokensBridged_event

​OptimismSpokePoolV2p5_V3FundsDeposited_event

Tables

OptimismSpokePool_FilledRelay_event

OptimismSpokePool_FundsDeposited_event

OptimismSpokePoolV2_FilledRelay_event

OptimismSpokePoolV2_FundsDeposited_event

OptimismSpokePoolV2_TokensBridged_event

OptimismSpokePoolV2p5_FilledRelay_event

OptimismSpokePoolV2p5_FilledV3Relay_event

OptimismSpokePoolV2p5_FundsDeposited_event

OptimismSpokePoolV2p5_TokensBridged_event

OptimismSpokePoolV2p5_V3FundsDeposited_event