across_v2_base

Tables

BaseSpokePool_FilledRelay_event

Completed cross-chain bridge transfers on Across Protocol V2 for Base network, emitted when relayers fill user deposit requests. Used for analyzing bridge volume, relayer performance, fee structures, and cross-chain liquidity flows between Base and origin 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_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
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	18081000000	1	0x	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	5256898	1043988	0xe5d882ba0bbca7945c8f2f09b1d8cdebb6e0e92f	0xe5d882ba0bbca7945c8f2f09b1d8cdebb6e0e92f	18081000000	2023-10-14T17:05:43.000Z	1	118198620435816	0x7207215d341fc32e7af8f0234330acad447dce9a32586ef15484e16815643318	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	8453	18081000000	8453	{“message”:“0x”,“recipient”:“0xe5d882ba0bbca7945c8f2f09b1d8cdebb6e0e92f”,“isSlowRelay”:false,“relayerFeePct”:“118198620435816”,“payoutAdjustmentPct”:“0”}
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	800000000	2	0x	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	5256677	1043979	0xe5d882ba0bbca7945c8f2f09b1d8cdebb6e0e92f	0xe5d882ba0bbca7945c8f2f09b1d8cdebb6e0e92f	800000000	2023-10-14T16:58:21.000Z	1	470275000000000	0xc3480e5a75ff7633679c7ea6f1c9dfa10634c096c9e79eb469e97cabe65f2cbc	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	8453	800000000	8453	{“message”:“0x”,“recipient”:“0xe5d882ba0bbca7945c8f2f09b1d8cdebb6e0e92f”,“isSlowRelay”:false,“relayerFeePct”:“470275000000000”,“payoutAdjustmentPct”:“0”}
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	8300000000000000	5	0x	0x6e728bc51536ff37082ba19115a6e3fa652f2723	5227087	1043568	0x3f54d16c6747abf89409299f6b07a2bcffc3b528	0x3f54d16c6747abf89409299f6b07a2bcffc3b528	8300000000000000	2023-10-14T00:32:01.000Z	1	65110894228487402	0x57778e996dc74500fd56f280a6f03dc555c157207863189cec26eb9e3227cecc	0x4200000000000000000000000000000000000006	8453	8300000000000000	8453	{“message”:“0x”,“recipient”:“0x3f54d16c6747abf89409299f6b07a2bcffc3b528”,“isSlowRelay”:false,“relayerFeePct”:“65110894228487402”,“payoutAdjustmentPct”:“0”}

Example Query

Query with partition filter

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

BaseSpokePool_FundsDeposited_event

Cross-chain deposit events from Across Protocol’s Base spoke pool contract, capturing user-initiated token transfers with origin/destination chain routing, relayer fee percentages, and unique deposit identifiers. Used for analyzing bridge volume, fee dynamics, and cross-chain flow patterns between Base and destination chains like Arbitrum, zkSync, 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
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	5000000000000000000	1	0x	7163585	1071289	0xa311f7ca3eb2fb98123a807f9b8e4bbbdbdcb2ee	0xa311f7ca3eb2fb98123a807f9b8e4bbbdbdcb2ee	0x4200000000000000000000000000000000000006	2023-11-27T20:21:57.000Z	8453	195655351087133	0x89540bb65fc6be582d876a9edc48261cd893db6d5d7b95b28006bffd25704b22	1701116100	42161
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	289504900	2	0x	7129286	1070627	0xa5cb97830f353683b90d872a0d4409faf4e9c428	0xa5cb97830f353683b90d872a0d4409faf4e9c428	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	2023-11-27T01:18:39.000Z	8453	2270738323630143	0x2915c33c399a611ee53fcce757ea8d6a3c17be00b52784c669eae66d4d27bebf	1701047400	324
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	22469953495435116810	2	0x	7169091	1071353	0x53d8edf6a54239eb785ec72213919fb6b6b73598	0x53d8edf6a54239eb785ec72213919fb6b6b73598	0x4158734d47fc9692176b5085e0f52ee0da5d47f1	2023-11-27T23:25:29.000Z	8453	9538124454804238	0x5a91b0dc1e7ad314f8e8f074d9fb9bb486a983b8723df6834a76617e7207d4a9	1701127200	42161

Example Query

Query with partition filter

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

BaseSpokePoolV2p5_FilledRelay_event

Completed cross-chain bridge relay events from Across Protocol V2.5 on Base, recording token transfers fulfilled by relayers including depositor, recipient, input/output amounts, and fees. Used for analyzing bridge volume, relayer profitability, and cross-chain transfer patterns between Base and origin chains 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_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	in_exclusivityDeadline
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	426	0x0000000000000000000000000000000000e3e50357ab6f3a7efb5117351720b4	33047925	3268236	0x0000000000000000000000005538e73f9e4467c20da09cc2e46bd2a14bcaaf1d	0x0000000000000000000000005538e73f9e4467c20da09cc2e46bd2a14bcaaf1d	0x0000000000000000000000004200000000000000000000000000000000000006	236736000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000004200000000000000000000000000000000000006	2025-07-19T00:33:17.000Z	1752896889	236702159739251219	10	0xfaa1af9b99ebfac8bff276f5eb5b1fc794891028b067a95dc05a53e105ffaf34	0x0000000000000000000000000000000000e3e50357ab6f3a7efb5117351720b4	10	{“fillType”:0,“updatedRecipient”:“0x0000000000000000000000005538e73f9e4467c20da09cc2e46bd2a14bcaaf1d”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“236702159739251219”}	1752885200
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	540	0x0000000000000000000000000000000000e3e50357ab6f3a7efb5117351720b4	33051139	3268369	0x000000000000000000000000ad7b268c0a8e9dbcc84d9962b24d91a62d0dcd5e	0x000000000000000000000000ad7b268c0a8e9dbcc84d9962b24d91a62d0dcd5e	0x0000000000000000000000004200000000000000000000000000000000000006	1649250492350091	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000004200000000000000000000000000000000000006	2025-07-19T02:20:25.000Z	1752903313	1647441133560270	10	0xd993b5d651a27265b4f6d615448324e5391cc545b9d3fc7b9752153395f7728e	0x0000000000000000000000000000000000e3e50357ab6f3a7efb5117351720b4	10	{“fillType”:0,“updatedRecipient”:“0x000000000000000000000000ad7b268c0a8e9dbcc84d9962b24d91a62d0dcd5e”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“1647441133560270”}	1752891628
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	374	0x0000000000000000000000000000000000e3e50357ab6f3a7efb5117351720b4	33051169	3268371	0x000000000000000000000000e928716f0d8fc8d2a7087b1d3104e718a3edaf7f	0x000000000000000000000000e928716f0d8fc8d2a7087b1d3104e718a3edaf7f	0x0000000000000000000000004200000000000000000000000000000000000006	9542000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000004200000000000000000000000000000000000006	2025-07-19T02:21:25.000Z	1752903375	9538960118907343	10	0xa51c4798027d2bca4928402d53b2a759b14d95eaae2dfabbbaeb011dc86dfab8	0x0000000000000000000000000000000000e3e50357ab6f3a7efb5117351720b4	10	{“fillType”:0,“updatedRecipient”:“0x000000000000000000000000e928716f0d8fc8d2a7087b1d3104e718a3edaf7f”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“9538960118907343”}	1752891688

Example Query

Query with partition filter

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

BaseSpokePoolV2p5_FilledV3Relay_event

Completed cross-chain bridge transfers on Across Protocol V3 arriving on Base, containing depositor, relayer, token amounts, and origin chain information. Used for analyzing bridge volume, relayer performance, and cross-chain token 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_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
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	18	0x	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	17851870	2266533	0x9223c5770afa50104faf709008b55c85b8549898	0x9223c5770afa50104faf709008b55c85b8549898	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	64812821881857550588	0x4158734d47fc9692176b5085e0f52ee0da5d47f1	2024-08-01T06:18:07.000Z	4294967295	64767958403561699660	42161	0x8cbdc5e2286473f1b503ef5dd9218b10ecd99ff031a13d7299511662b9e3911b	0x0000000000000000000000000000000000000000	8453	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0x9223c5770afa50104faf709008b55c85b8549898”,“updatedOutputAmount”:“64767958403561699660”}
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	0	0x	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	17852913	2266664	0x9223c5770afa50104faf709008b55c85b8549898	0x9223c5770afa50104faf709008b55c85b8549898	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	64677427767971062375	0x4158734d47fc9692176b5085e0f52ee0da5d47f1	2024-08-01T06:52:53.000Z	4294967295	64632771809928859938	42161	0x0fc8bc3d308dede72db2315ba8ffa06a5bb99b8f764bf33dd9fc85afc5a9cade	0x0000000000000000000000000000000000000000	8453	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0x9223c5770afa50104faf709008b55c85b8549898”,“updatedOutputAmount”:“64632771809928859938”}
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	33	0x	0x428ab2ba90eba0a4be7af34c9ac451ab061ac010	17867979	2269298	0x9223c5770afa50104faf709008b55c85b8549898	0x9223c5770afa50104faf709008b55c85b8549898	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	65206156284042434235	0x4158734d47fc9692176b5085e0f52ee0da5d47f1	2024-08-01T15:15:05.000Z	4294967295	65158105950714259212	42161	0x8a53f5b88de3dc964d1aa4acfa3e47bf966e774159a1e775ea946fc168bc1602	0x0000000000000000000000000000000000000000	8453	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0x9223c5770afa50104faf709008b55c85b8549898”,“updatedOutputAmount”:“65158105950714259212”}

Example Query

Query with partition filter

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

BaseSpokePoolV2p5_FundsDeposited_event

Cross-chain deposit events from Across Protocol v2.5 on Base, capturing bridge transfers with input/output token details, amounts, destination chains, and relayer parameters. Used for analyzing bridging volume, fee rates, 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_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
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	415	0x000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000021b90000000000000000000000000000000000000000000000000000000000002105000000000000000000000000a1e8c2b7d5b0a7e0ab21161c4cd73d391d87c8140000000000000000000000004e3e1807aa17aed8d1fc580dda552079d9427ece000000000000000000000000000000000000000000000000000000000000462c0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000d73776170416e64556e777261700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000030000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000001bfd67037b42cf73acf2047067bd4f2c47d9bfd60000000000000000000000003bf668fe1ec79a84ca8481cead5dbb30d61cc6850000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000001493972fcdec539ae8bffc1a9e76a8b904c43e19f30000000000000000000000000000000000000000000000000000000000000000000000000000000000000017a91472df0f82c4bcfe01a274bd521e5d4c66586b7a5b87000000000000000000	28438342	3614052	0x000000000000000000000000ec4a7d93750bbce2a07fd1bc748507ea645e9d52	0x000000000000000000000000e0166434a2ad67536b5fdafcc9a6c1b41cc5e085	0x0000000000000000000000004200000000000000000000000000000000000006	8700000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	2025-04-03T07:40:31.000Z	4294967295	8688327705281340	0x4c099efd088ecb01fe7f2ee93846deaf230ca18b22f1ddaed36233974ab7169b	1743666031	0x0000000000000000000000000000000000000000000000000000000000000000	137
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	253	0x	28452584	3615594	0x00000000000000000000000039143a0c96789a58f910503af45cdb6d319df733	0x00000000000000000000000039143a0c96789a58f910503af45cdb6d319df733	0x0000000000000000000000004200000000000000000000000000000000000006	33000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	2025-04-03T15:35:15.000Z	1743706209	32992180501194212	0xf8f70d957afea7dddd81c25573abac048bd8d2ae0e663ede42cc644d6e6146d8	1743694355	0x0000000000000000000000000000000000000000000000000000000000000000	42161
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	284	0x	28449766	3615289	0x0000000000000000000000006f5b8cf34914ad6c1244ae9590c051bf857a4e55	0x0000000000000000000000006f5b8cf34914ad6c1244ae9590c051bf857a4e55	0x000000000000000000000000833589fcd6edb6e08f4c7c32d4f71b54bda02913	140837363	0x0000000000000000000000000000000000000000000000000000000000000000	2025-04-03T14:01:19.000Z	1743710479	140809196	0x4a13635a1096a4b27e6447fa30d1033c372c22c718a4e52eae3ccd04b82325e1	1743688843	0x0000000000000000000000000000000000000000000000000000000000000000	10

Example Query

Query with partition filter

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

BaseSpokePoolV2p5_TokensBridged_event

Token bridge withdrawal events from Across Protocol V2.5 on Base, recording L2-to-L1 token transfers with amounts, token addresses, and leaf identifiers for relayer settlement 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_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
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	0xf7bac63fc7ceacf0589f25454ecf5c2ce904997c	28	343	8453	28719113	2025-04-09T19:39:33.000Z	0x89c88e52066bdf4f0dd891dd65d006ec3afdf8e2dda561e5ffa544cbaac894d8	357224618918	0x000000000000000000000000833589fcd6edb6e08f4c7c32d4f71b54bda02913
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	0xf7bac63fc7ceacf0589f25454ecf5c2ce904997c	29	276	8453	28710524	2025-04-09T14:53:15.000Z	0x72f8d4f0ec2c39948c522e3c16fee51794fdc7567c785c44a1bd141fd38bcd0d	247917382402	0x000000000000000000000000833589fcd6edb6e08f4c7c32d4f71b54bda02913
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	0xf7bac63fc7ceacf0589f25454ecf5c2ce904997c	29	215	8453	28708264	2025-04-09T13:37:55.000Z	0xb734697e7275b91308b3ca6006026e4e31937e2e0525179c023438adfcda6ab5	244322806669	0x000000000000000000000000833589fcd6edb6e08f4c7c32d4f71b54bda02913

Example Query

Query with partition filter

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

BaseSpokePoolV2p5_V3FundsDeposited_event

Deposit events from Across Protocol bridge on Base, recording cross-chain transfer requests with input/output token amounts, destination chains, and relayer parameters. Enables analysis of bridge volume, fee rates, and cross-chain flow patterns between Base and other networks like Ethereum, Arbitrum, 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_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
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	195	0x	16026138	1768237	0xdf2e7a58ac62c29f8a1d15b2c51ca90b2197d169	0xdf2e7a58ac62c29f8a1d15b2c51ca90b2197d169	0x4200000000000000000000000000000000000006	3000000000000000	0x0000000000000000000000000000000000000000	2024-06-20T00:00:23.000Z	4294967295	2985572874064681	0x3ed96e96db4ce81a58ecd4b773147ccb76af0c9186c56884d291e4c53e5b9d04	1718841311	0x0000000000000000000000000000000000000000	10
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	192	0x	16026183	1768239	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0xc4744d5492091a9bd4924c1c843526992d0eb715	0x4200000000000000000000000000000000000006	5000000000000000	0x0000000000000000000000000000000000000000	2024-06-20T00:01:53.000Z	4294967295	4995066604432139	0xbb399245523b994f70a9f1b6a27916e2e0f3ac827e2d34592d73d0c21df5cefd	1718841551	0x0000000000000000000000000000000000000000	42161
0x09aea4b2242abc8bb4bb78d537a67a245a7bec64	false	276	0x	16026185	1768240	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0x6e7d0a4300c2313618eef2aa147cade624f852c5	0x4200000000000000000000000000000000000006	8443429571936808225	0x0000000000000000000000000000000000000000	2024-06-20T00:01:57.000Z	4294967295	8440544818717220353	0x843100121c80476dde818c88dcfdaac0c10dcae94d36d5719040066f468bdb99	1718841551	0x0000000000000000000000000000000000000000	1

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BaseSpokePool_FilledRelay_event

BaseSpokePool_FundsDeposited_event

BaseSpokePoolV2p5_FilledRelay_event

BaseSpokePoolV2p5_FilledV3Relay_event

BaseSpokePoolV2p5_FundsDeposited_event

BaseSpokePoolV2p5_TokensBridged_event

BaseSpokePoolV2p5_V3FundsDeposited_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​BaseSpokePool_FilledRelay_event

​BaseSpokePool_FundsDeposited_event

​BaseSpokePoolV2p5_FilledRelay_event

​BaseSpokePoolV2p5_FilledV3Relay_event

​BaseSpokePoolV2p5_FundsDeposited_event

​BaseSpokePoolV2p5_TokensBridged_event

​BaseSpokePoolV2p5_V3FundsDeposited_event

Tables

BaseSpokePool_FilledRelay_event

BaseSpokePool_FundsDeposited_event

BaseSpokePoolV2p5_FilledRelay_event

BaseSpokePoolV2p5_FilledV3Relay_event

BaseSpokePoolV2p5_FundsDeposited_event

BaseSpokePoolV2p5_TokensBridged_event

BaseSpokePoolV2p5_V3FundsDeposited_event