across_v2_zksyncera

Tables

ZkSyncSpokePool_FilledRelay_event

Completed relay fills from Across Protocol V2 bridge on zkSync Era, tracking cross-chain token transfers with depositor, relayer, fill amounts, and fee percentages. Used for analyzing bridge volume, relayer profitability, and cross-chain liquidity flows between Ethereum mainnet (chain ID 1) and zkSync Era (chain ID 324).

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
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	9396183167120100	84	0x	0x53596ab134569396b9a7070d2c4e6cd536b3c130	13877709	1025813	0x2eaa3c4c668aa98b6bfc5f7aba1b743a231e224b	0x2eaa3c4c668aa98b6bfc5f7aba1b743a231e224b	9396183167120100	2023-09-15T01:05:37.000Z	1	18928345964616048	0x22b5c5b589f622ba6042a8e714cc41cfe03cb878c88099a906c578c4485b40cc	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	324	9396183167120100	324	{“message”:“0x”,“recipient”:“0x2eaa3c4c668aa98b6bfc5f7aba1b743a231e224b”,“isSlowRelay”:false,“relayerFeePct”:“18928345964616048”,“payoutAdjustmentPct”:“0”}
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	17874000000000000	534	0x	0x53596ab134569396b9a7070d2c4e6cd536b3c130	13882743	1025825	0x3a23f943181408eac424116af7b7790c94cb97a5	0xecce18fb262d0b6d4637845bcd2da53ff940bec5	17874000000000000	2023-09-15T02:30:50.000Z	1	10111406798950710	0x89cf9e5710779a625db843dab01425659c97a73398ccd74ffbd018e34d843dbd	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	324	17874000000000000	324	{“message”:“0x”,“recipient”:“0xecce18fb262d0b6d4637845bcd2da53ff940bec5”,“isSlowRelay”:false,“relayerFeePct”:“10111406798950710”,“payoutAdjustmentPct”:“0”}
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	187794174000000000	30	0x	0x41ee28ee05341e7fdddc8d433ba66054cd302ca1	13940911	1026118	0x3a23f943181408eac424116af7b7790c94cb97a5	0xf961f33c73d18fc8546dc2b1af297bafdd99b84c	187794174000000000	2023-09-15T19:07:02.000Z	1	2185715715184332	0x6a6477fc651e07b83fa6cd9cff924fac2ea9f86d86696feafea64e7d6975ae92	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	324	187794174000000000	324	{“message”:“0x”,“recipient”:“0xf961f33c73d18fc8546dc2b1af297bafdd99b84c”,“isSlowRelay”:false,“relayerFeePct”:“2185715715184332”,“payoutAdjustmentPct”:“0”}

Example Query

Query with partition filter

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

ZkSyncSpokePool_FundsDeposited_event

Cross-chain bridge deposit events from Across Protocol V2 on zkSync Era, capturing token transfers initiated on chain 324 (zkSync Era) for relay to destination chains. Used for analyzing bridge volume, relayer fee structures, and cross-chain fund flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	600000000000000000	38	0x	13284718	1020606	0xadde7028e7ec226777e5dea5d53f6457c21ec7d6	0x212d165ba5c0fb6fa1b026a85a901a1d3a9f3dd0	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	2023-09-08T00:48:18.000Z	324	3395149958299175	0x21efcf7ab40b8cc597176a5287c54adde1c0732593c0d1224e3d8413346d24f3	1694133600	1
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	411610263	35	0x	13286917	1020622	0xadde7028e7ec226777e5dea5d53f6457c21ec7d6	0xa6586f56adfa72a2047eb1b1e7941008f8c713d9	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	2023-09-08T01:25:38.000Z	324	8373834147918233	0xae4963fd59528a1c9acf370a7dc2ed119af45de1eaa0eb0e3bcbcd9f2e2517ac	1694136000	1
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	9930000000000000	66	0x	13288468	1020639	0xadde7028e7ec226777e5dea5d53f6457c21ec7d6	0x9e5ad1484660388e32d08d57ed6c8cafe684d4a8	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	2023-09-08T01:52:05.000Z	324	184884831999850151	0x7f767b446c1e299600d63c469d4b83c6160593e3c35bd647864a53971e286e70	1694137500	1

Example Query

Query with partition filter

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

ZkSyncSpokePoolV2p5_FilledRelay_event

Completed cross-chain bridge relay fills on zkSync Era through Across Protocol V2.5, capturing deposit fulfillment with relayer addresses, token amounts, origin and destination chain details, and execution parameters for analyzing bridge activity and relayer performance.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	2	0x00000000000000000000000007ae8551be970cb1cca11dd7a11f47ae82e70e67	65091349	3466745	0x000000000000000000000000d3e7a2532dd6586612dd758f98491a8ff1157cfa	0x000000000000000000000000d3e7a2532dd6586612dd758f98491a8ff1157cfa	0x0000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85	22568000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000003355df6d4c9c3035724fd0e3914de96a5a83aaf4	2025-10-06T19:57:59.000Z	1759794839	22565000570	10	0x3248e346c36412ad0279eb405bad26ac84be7377353fe7804df94b8278e8742a	0x0000000000000000000000000000000000000000000000000000000000000000	10	{“fillType”:0,“updatedRecipient”:“0x000000000000000000000000d3e7a2532dd6586612dd758f98491a8ff1157cfa”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“22565000570”}	0
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	23	0x00000000000000000000000007ae8551be970cb1cca11dd7a11f47ae82e70e67	65085598	3466079	0x000000000000000000000000819fec2168eeed0be582621cc991aa38df6d296c	0x000000000000000000000000819fec2168eeed0be582621cc991aa38df6d296c	0x0000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85	1000182410	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000003355df6d4c9c3035724fd0e3914de96a5a83aaf4	2025-10-06T14:06:15.000Z	1759777567	999999994	10	0x43ace61938e9230a1f9afa7bfacf9e4f90ffcbd97ebfc344c1cf4ecc685ea37d	0x0000000000000000000000000000000000000000000000000000000000000000	10	{“fillType”:0,“updatedRecipient”:“0x000000000000000000000000819fec2168eeed0be582621cc991aa38df6d296c”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“999999994”}	0
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	2	0x00000000000000000000000007ae8551be970cb1cca11dd7a11f47ae82e70e67	65091606	3466760	0x000000000000000000000000819fec2168eeed0be582621cc991aa38df6d296c	0x000000000000000000000000819fec2168eeed0be582621cc991aa38df6d296c	0x0000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85	1000180770	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000003355df6d4c9c3035724fd0e3914de96a5a83aaf4	2025-10-06T20:11:33.000Z	1759799147	999999998	10	0x696dce7983d89929f8b12460231fa6019f184baebc96b64c1ac974e10acd7cbd	0x000000000000000000000000cad97616f91872c02ba3553db315db4015cbe850	10	{“fillType”:0,“updatedRecipient”:“0x000000000000000000000000819fec2168eeed0be582621cc991aa38df6d296c”,“updatedMessageHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“updatedOutputAmount”:“999999998”}	1759781158

Example Query

Query with partition filter

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

ZkSyncSpokePoolV2p5_FilledV3Relay_event

Cross-chain bridge relay fulfillment events from Across Protocol v2.5 on zkSync Era, tracking completed token transfers with depositor, relayer, origin/destination chain data, and token amounts. Used for analyzing bridge volume, relayer performance, and 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_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
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	2	0x	0x41ee28ee05341e7fdddc8d433ba66054cd302ca1	42949814	1511881	0xe397c4883ec89ed4fc9d258f00c689708b2799c9	0x1705b9c647ad292ec2adb78b9d8b310440718fae	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	51049375000000000	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	2024-08-30T05:00:14.000Z	4294967295	51031148125167269	1	0xbe684216d9209846a16f5572fad1894d4b66b3181d8c616959f9442de6ec16dc	0x0000000000000000000000000000000000000000	1	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0x1705b9c647ad292ec2adb78b9d8b310440718fae”,“updatedOutputAmount”:“51031148125167269”}
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	2	0x	0x07ae8551be970cb1cca11dd7a11f47ae82e70e67	42968354	2096827	0x28e41705385d0224922f1cc0618c3c0a0a66a79d	0x28e41705385d0224922f1cc0618c3c0a0a66a79d	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	5001000000	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	2024-08-30T10:18:12.000Z	1725034597	5000149438	8453	0x6a62ded39a88695a56e0c47511b8fd6570976ace5ed066932020babadc43b730	0x0000000000000000000000000000000000000000	1	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0x28e41705385d0224922f1cc0618c3c0a0a66a79d”,“updatedOutputAmount”:“5000149438”}
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	13	0x	0x41ee28ee05341e7fdddc8d433ba66054cd302ca1	43005993	1513776	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0x2f2f777bfda78f8ac16b9cca0bdc2badb684df15	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	4648542410000000	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	2024-08-30T21:10:39.000Z	4294967295	4634842306608389	1	0xd5d6354d0fe9dc02a379788179dbadf60be34a69d3e3099e5c86dfbdf9b0a566	0x0000000000000000000000000000000000000000	1	{“fillType”:0,“updatedMessage”:“0x”,“updatedRecipient”:“0x2f2f777bfda78f8ac16b9cca0bdc2badb684df15”,“updatedOutputAmount”:“4634842306608389”}

Example Query

Query with partition filter

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

ZkSyncSpokePoolV2p5_FundsDeposited_event

Cross-chain deposit events from Across Protocol v2.5 on zkSync Era, capturing user bridge requests with input/output tokens, amounts, destination chains, and relayer parameters. Used for tracking bridge volume, analyzing cross-chain token flows, and monitoring relayer fill opportunities.

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
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	30	0x	56897588	3190409	0x000000000000000000000000c992ada77e5f26f362db9a4fe65a48cacc48f886	0x000000000000000000000000c992ada77e5f26f362db9a4fe65a48cacc48f886	0x000000000000000000000000493257fd37edb34451f62edf8d2a0c418852ba4c	260117134	0x000000000000000000000000f0f161fda2712db8b566946122a5af183995e2ed	2025-03-02T16:35:19.000Z	1740942316	259988015	0x07e16b662038fe93232dbc5aabcdd1a506d329271d23f26fbe325f0bb6afa9c0	1740933095	0x0000000000000000000000000000000000000000000000000000000000000000	34443
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	5	0x	56908587	3190518	0x000000000000000000000000642459ed2f7c1f9f88e05a60ec3b7d142f807163	0x000000000000000000000000642459ed2f7c1f9f88e05a60ec3b7d142f807163	0x000000000000000000000000bbeb516fb02a01611cbbe0453fe3c580d7281011	2146	0x0000000000000000000000003aab2285ddcddad8edf438c1bab47e1a9d05a9b4	2025-03-02T20:03:14.000Z	1740954782	2125	0x1a040c551aa0ec2f37fda0d886637debd1a6cfdaa883fa926fd1848e4cae53e7	1740945587	0x0000000000000000000000000000000000000000000000000000000000000000	59144
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	14	0x	56872088	3190123	0x0000000000000000000000004e3a9949461384bef2bc09ba4f2539c4c6e4eed4	0x0000000000000000000000004e3a9949461384bef2bc09ba4f2539c4c6e4eed4	0x0000000000000000000000003355df6d4c9c3035724fd0e3914de96a5a83aaf4	49452620	0x00000000000000000000000079a02482a880bce3f13e09da970dc34db4cd24d1	2025-03-02T06:43:19.000Z	1740906795	49440128	0x651184687dc4b575a1746ab36103fc90ec505602db14b21baf591aab858135ec	1740897731	0x0000000000000000000000000000000000000000000000000000000000000000	480

Example Query

Query with partition filter

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

ZkSyncSpokePoolV2p5_V3FundsDeposited_event

Cross-chain bridge deposit events from Across Protocol on zkSync Era, capturing user deposits with source token, destination chain, amounts, and relayer parameters. Used for tracking bridge flow volume and analyzing cross-chain transfer patterns between zkSync Era and other 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_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
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	586	0x	27343100	1611009	0x341e94069f53234fe6dabef707ad424830525715	0xead6605b9e105e28bd35e9f494131c10c1281ce9	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	2000000000000000000	0x0000000000000000000000000000000000000000	2024-02-24T00:30:53.000Z	4294967295	1993995584017328242	0xe0d91e7aafd83af0c35a3c93c1f0273e1f9522b46135c28ccabba46a9dc74c8b	1708734300	0x0000000000000000000000000000000000000000	1
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	46	0x	27343286	1611024	0xadde7028e7ec226777e5dea5d53f6457c21ec7d6	0x060202ad7524222f73a903724f95a660bdc9f7c1	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	349860000000000000	0x0000000000000000000000000000000000000000	2024-02-24T00:34:07.000Z	4294967295	345429555916354059	0x52774c5dda9b107980fa69fe976a77bb4dd92cbb0958f1f21f3082793e9fb151	1708734300	0x0000000000000000000000000000000000000000	1
0xe0b015e54d54fc84a6cb9b666099c46ade9335ff	false	147	0x	27344125	1611088	0x1840d4a615a6eac22fd4ebd21a183689bc631e7b	0x1840d4a615a6eac22fd4ebd21a183689bc631e7b	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	30000000000000000	0x0000000000000000000000000000000000000000	2024-02-24T00:49:04.000Z	4294967295	26078183390022693	0xe5ca34c926362c930abf28eafdca86f82f64cbabce40ebefb3c12e6693a63d70	1708735200	0x0000000000000000000000000000000000000000	1

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ZkSyncSpokePool_FilledRelay_event

ZkSyncSpokePool_FundsDeposited_event

ZkSyncSpokePoolV2p5_FilledRelay_event

ZkSyncSpokePoolV2p5_FilledV3Relay_event

ZkSyncSpokePoolV2p5_FundsDeposited_event

ZkSyncSpokePoolV2p5_V3FundsDeposited_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ZkSyncSpokePool_FilledRelay_event

​ZkSyncSpokePool_FundsDeposited_event

​ZkSyncSpokePoolV2p5_FilledRelay_event

​ZkSyncSpokePoolV2p5_FilledV3Relay_event

​ZkSyncSpokePoolV2p5_FundsDeposited_event

​ZkSyncSpokePoolV2p5_V3FundsDeposited_event

Tables

ZkSyncSpokePool_FilledRelay_event

ZkSyncSpokePool_FundsDeposited_event

ZkSyncSpokePoolV2p5_FilledRelay_event

ZkSyncSpokePoolV2p5_FilledV3Relay_event

ZkSyncSpokePoolV2p5_FundsDeposited_event

ZkSyncSpokePoolV2p5_V3FundsDeposited_event