across_v3_optimism

Tables

SpokePool_FilledRelay_event

Cross-chain relay fulfillment events emitted when relayers complete token transfers between blockchains through the Across Protocol V3 SpokePool contract. Records deposit identifiers, origin and destination chain IDs, token addresses, fill amounts, relayer and LP fee percentages, and recipient information for bridge transaction tracking.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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	5990000	4	0x	0x29850516a9b9a7ff67e64ce2588367f34f75b763	106946492	1042125	0x3a23f943181408eac424116af7b7790c94cb97a5	0x6c5fe0c4f7443691397e744806684486040c00a4	5990000	2023-07-16T07:16:01.000Z	42161	30009432387312186	0x09a0d098f72cfee7b59825e1df0553bd514fbb9e97892544436d62e5e42fc599	0x7f5c764cbc14f9669b88837ca1490cca17c31607	10	5990000	10	{“message”:“0x”,“recipient”:“0x6c5fe0c4f7443691397e744806684486040c00a4”,“isSlowRelay”:false,“relayerFeePct”:“30009432387312186”,“payoutAdjustmentPct”:“0”}
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	587337859	23	0x	0x29850516a9b9a7ff67e64ce2588367f34f75b763	106968362	1042519	0x3a23f943181408eac424116af7b7790c94cb97a5	0x39b370dca90663ffdd30838cd97c93a5042cceaa	587337859	2023-07-16T19:25:01.000Z	42161	315118274965482	0xfcb5e006c5a07d8da565727c2e497580d8272edfc622ebe1ebd665198d6ed4c8	0x7f5c764cbc14f9669b88837ca1490cca17c31607	10	587337859	10	{“message”:“0x”,“recipient”:“0x39b370dca90663ffdd30838cd97c93a5042cceaa”,“isSlowRelay”:false,“relayerFeePct”:“315118274965482”,“payoutAdjustmentPct”:“0”}
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	11200000	2	0x	0x29850516a9b9a7ff67e64ce2588367f34f75b763	106937552	1041988	0x3a23f943181408eac424116af7b7790c94cb97a5	0xba447ade5518bdf48e204141b5163a4fa62b7df3	11200000	2023-07-16T02:18:01.000Z	42161	14861160714285714	0xecf3887586d3e2fb14661c5ac30f0e19daa028082d27c7eb1c6c584aedb0b619	0x7f5c764cbc14f9669b88837ca1490cca17c31607	10	11200000	10	{“message”:“0x”,“recipient”:“0xba447ade5518bdf48e204141b5163a4fa62b7df3”,“isSlowRelay”:false,“relayerFeePct”:“14861160714285714”,“payoutAdjustmentPct”:“0”}

Example Query

Query with partition filter

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

SpokePool_FilledV3Relay_event

Cross-chain relay fulfillment events from Across Protocol V3 SpokePool contracts. Records successful deposit fills with depositor details, token amounts, relay execution parameters, and relayer compensation chain identifiers for tracking bridge completion and settlement.

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	82	0x	0x00000000000a59c8d4c548a43660a8950a542a71	123465664	2009313	0x714b831eb02fe854283219b2b9f1c6951f46dcb9	0x714b831eb02fe854283219b2b9f1c6951f46dcb9	0x4200000000000000000000000000000000000006	701000000000000000	0x4200000000000000000000000000000000000006	2024-08-01T16:35:05.000Z	4294967295	700894816623708212	8453	0xe5fbea5130813698d4369178df24efc533682a83b2fa660bc1f618dae994ebdb	0x0000000000000000000000000000000000000000	10	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0x714b831eb02fe854283219b2b9f1c6951f46dcb9”,“updatedOutputAmount”:“700894816623708212”}
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	16	0x	0x00000000000a59c8d4c548a43660a8950a542a71	123461216	2008910	0xa019fa82f89ca523bec44a8ec49e23b20a5a0144	0xa019fa82f89ca523bec44a8ec49e23b20a5a0144	0x4200000000000000000000000000000000000006	174000000000000000	0x4200000000000000000000000000000000000006	2024-08-01T14:06:49.000Z	1722542172	173973448016918017	8453	0xb27ba9e08eb89481b976744e73d9c1b2d29adad3c5bed5952331e7e9f1415def	0x0000000000000000000000000000000000000000	10	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0xa019fa82f89ca523bec44a8ec49e23b20a5a0144”,“updatedOutputAmount”:“173973448016918017”}
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	12	0x	0x00000000000a59c8d4c548a43660a8950a542a71	123465519	2009300	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0xa851470e868e0f7cccac4d5024cd7da8007cf16c	0x4200000000000000000000000000000000000006	3600000000000000	0x4200000000000000000000000000000000000006	2024-08-01T16:30:15.000Z	4294967295	3598261059288777	8453	0x85938094afad49900a56a1c13f415b96719486725bd26980eb2cbdca269882eb	0x0000000000000000000000000000000000000000	10	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0xa851470e868e0f7cccac4d5024cd7da8007cf16c”,“updatedOutputAmount”:“3598261059288777”}

Example Query

Query with partition filter

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

SpokePool_FundsDeposited_event

Cross-chain deposit events emitted by Across Protocol SpokePool contracts when users initiate token transfers between blockchains. Contains deposit parameters including token amount, origin and destination chain identifiers, depositor and recipient addresses, relayer fee percentage, and quote timestamp for tracking bridge transactions across supported networks.

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	900000000000000000	1	0x	110779069	1087005	0x3a23f943181408eac424116af7b7790c94cb97a5	0xb3313b023e68cda95d7b625200e1b0fe6335a0c2	0x4200000000000000000000000000000000000006	2023-10-13T00:28:35.000Z	10	1253494562908493	0x6f71f4426f861b8687c89c3cda367abff2cd4f221e4d56bfccbb2cb16be92973	1697156400	1
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	7147180973124344	8	0x	110779860	1087014	0x69460570c93f9de5e2edbc3052bf10125f0ca22d	0x4b71c12083177359aa6d3893ea3dece9bbdb8767	0x4200000000000000000000000000000000000006	2023-10-13T00:54:57.000Z	10	118632415882508782	0x6fbb9af950baf2e6a4e48b2301738fb390fec4177a906a53ba6556a2239f075a	1697158463	1
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	180500967	81	0x	110780572	1087030	0x1905c1e4278d34920fbd4a479b8f5d51ea065b3d	0x1905c1e4278d34920fbd4a479b8f5d51ea065b3d	0x7f5c764cbc14f9669b88837ca1490cca17c31607	2023-10-13T01:18:41.000Z	10	9849555846201691	0x5336feb99c60d3a431af0fc776cd2da39a4d74b443ae9f103cec550b4e0b9d7b	1697159400	1

Example Query

Query with partition filter

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

SpokePool_V3FundsDeposited_event

Across Protocol V3 deposit events emitted when users initiate cross-chain token transfers. Contains deposit identifiers, token amounts, destination chain IDs, relayer exclusivity parameters, and fulfillment deadlines for tracking bridge operations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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	12	0x	116999261	1259460	0x460145d20d34679006962c14b4a057286c9c6aba	0x460145d20d34679006962c14b4a057286c9c6aba	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	800000000	0x0000000000000000000000000000000000000000	2024-03-05T00:08:19.000Z	4294967295	798566113	0xff1b4b0ac5fb77f61f7ead06107e03443729e72ef582bbc28e4a97d29121f4ba	1709596800	0x0000000000000000000000000000000000000000	324
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	101	0x	117001071	1259478	0xc4aba48292a70e73b65d6be60d4f79ad48e2dad4	0xc4aba48292a70e73b65d6be60d4f79ad48e2dad4	0x7f5c764cbc14f9669b88837ca1490cca17c31607	524129096	0x0000000000000000000000000000000000000000	2024-03-05T01:08:39.000Z	4294967295	522493385	0xc48e27c0919f4849d1c0d37c027bead0b7b279467f62b764fc0fd54aa316cbc5	1709597700	0x0000000000000000000000000000000000000000	324
0x6f26bf09b1c792e3228e5467807a900a503c0281	false	12	0x	117002416	1259498	0xfb15339d187a76af62698f73d700e1f8536f03bd	0xfb15339d187a76af62698f73d700e1f8536f03bd	0x7f5c764cbc14f9669b88837ca1490cca17c31607	100000000	0x0000000000000000000000000000000000000000	2024-03-05T01:53:29.000Z	4294967295	99936641	0x84a9030f7745bd3b72a6975d14ac8fda0cc870ce42d40845fd3d00cbdfc18cc8	1709603100	0x0000000000000000000000000000000000000000	137

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

SpokePool_FilledRelay_event

SpokePool_FilledV3Relay_event

SpokePool_FundsDeposited_event

SpokePool_V3FundsDeposited_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​SpokePool_FilledRelay_event

​SpokePool_FilledV3Relay_event

​SpokePool_FundsDeposited_event

​SpokePool_V3FundsDeposited_event

Tables

SpokePool_FilledRelay_event

SpokePool_FilledV3Relay_event

SpokePool_FundsDeposited_event

SpokePool_V3FundsDeposited_event