synapse_v1_optimism - Token Terminal Docs

Tables

CCTP_ChainGasAirdropped_event

Cross-Chain Transfer Protocol (CCTP) event logs recording native gas token airdrops to bridge users. Tracks the input amount of gas distributed to facilitate cross-chain transactions and improve user experience.

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.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	300000000000000	22	110894101	2023-10-15T16:22:59.000Z	0xf5192d92245d74ccc246f04b591915c6609645b6506fabdf75f38eb47ab358e9
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	300000000000000	31	109792406	2023-09-20T04:19:49.000Z	0x63937339eb1f034ca2bd5b7247b770514eaf74149a6660e19ac81c93cf4d0d19
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	300000000000000	17	109823507	2023-09-20T21:36:31.000Z	0xb78cda5e76c6b57415508ffdba05a1e1ed89bfe4c59e8c0b0761b25409617cb6

Example Query

Query with partition filter

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

CCTP_ChainGasAmountUpdated_event

Cross-Chain Transfer Protocol (CCTP) configuration events recording updates to destination chain gas amount allocations. Emitted when protocol administrators modify the gas reserves allocated for cross-chain message execution.

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_chainGasAmount`	`STRING`	Amount of native gas token allocated for executing the transaction on the destination chain. Numeric string representing the gas amount in the smallest denomination (wei for EVM chains).

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_chainGasAmount
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	44	109126748	2023-09-04T18:31:13.000Z	0xd55060000709cf45c5eeea98cd7b92343ba51901d721bcefe8d22ca5eebaa8e9	300000000000000
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	29	108941888	2023-08-31T11:49:13.000Z	0x3cd32957b2cf4a8dd1e0134ff9508e0166b5b7d852f0fb5a741575f94908c93a	1337

Example Query

Query with partition filter

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

CCTP_CircleRequestFulfilled_event

Cross-Chain Transfer Protocol (CCTP) fulfillment events recording completed token mints on destination chains. Contains origin domain identifiers, request IDs, mint token addresses, recipient addresses, transfer amounts, and protocol fees for tracking cross-chain USDC transfers.

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_originDomain`	`STRING`	Domain identifier for the originating blockchain in a cross-chain transfer. Numeric string representation of the source chain identifier.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_mintToken`	`STRING`	Contract address of the token being minted. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_requestID`	`STRING`	Unique identifier for a cross-chain CCTP (Cross-Chain Transfer Protocol) request. 66-character hex string including 0x prefix.

Sample Data

in_fee	address	removed	in_token	in_amount	log_index	block_number	in_mintToken	in_recipient	in_requestID	block_timestamp	in_originDomain	transaction_hash
1662775	0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	4155274911	7	110810384	0x0b2c639c533813f4aa9d7837caf62653d097ff85	0x3831d812f87814b2203615d1bf1a647d1c1816c5	0xc37e068f208866331f3d607f5696e7e903af8de34fddc692d68a25ca779d6557	2023-10-13T17:52:25.000Z	0	0xe9f42df713500d8c9c0511c55f2281ddc62334c640f0f7246e3727b9eb7b499d
2786989	0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	6964686962	10	110805205	0x0b2c639c533813f4aa9d7837caf62653d097ff85	0xd6fd705ee0b31a9300d3e2154bcce777270cbb6f	0x5c17bbb436c2bafbb05bb7e90840b254727dc97b1e536da9c1293b7bd6a42adc	2023-10-13T14:59:47.000Z	0	0xdd20b1dff1004d25b70c1d4d4def7672b3becebf918eee2dd175bf045568340b
1999600	0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	4999035461662666669604	26	110112850	0x0b2c639c533813f4aa9d7837caf62653d097ff85	0x6ed7e9d7928f5db04bc61690572cbdd3bd4397a9	0xb2103786eb5606f7b7dc30cda3365c916bce5742fc8d49eeb08f4991c1d89647	2023-09-27T14:21:17.000Z	3	0x0535a61b771d09325e82ada1f5c05911c1c9cada381151b3e43dab7aac62affa

Example Query

Query with partition filter

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

CCTP_CircleRequestSent_event

Cross-Chain Transfer Protocol (CCTP) request initiation events containing sender address, token details, transfer amount, destination chain identifier, and unique request ID with nonce. Used for tracking cross-chain token transfer requests and analyzing bridge activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_requestVersion`	`STRING`	Version identifier for the CCTP request format. Numeric string representation of the protocol version number.
`in_formattedRequest`	`STRING`	ABI-encoded CCTP request parameters containing the destination chain, nonce, token, amount, sender, and recipient details. Hex-encoded string with 0x prefix.
`in_requestID`	`STRING`	Unique identifier for a cross-chain CCTP (Cross-Chain Transfer Protocol) request. 66-character hex string including 0x prefix.

Sample Data

address	removed	in_nonce	in_token	in_amount	in_sender	log_index	in_chainId	block_number	in_requestID	block_timestamp	transaction_hash	in_formattedRequest
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	1432	0x0b2c639c533813f4aa9d7837caf62653d097ff85	49880699298	0x4aeb065bbd8e00e03baf59097013a984ab74f456	27	1	109858141	0x33c291fc8848acf94f864a1b861c21022dcf6a97244f873b259b10bae47654a0	2023-09-21T16:50:59.000Z	0xed4906bb18f6a837b8b8ba820186719429aa673ce25308084fad5677b2842ba8	0x000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000005980000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff850000000000000000000000000000000000000000000000000000000b9d1f11a20000000000000000000000004aeb065bbd8e00e03baf59097013a984ab74f456
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	1352	0x0b2c639c533813f4aa9d7837caf62653d097ff85	1970333135	0x35b5711093844c4cc31c334026b30b6a35b24057	60	1	109835867	0xf302cb8f9ca48008ab19d7f6d5b9a76442d080d35cde7888a386a23373bb3dcd	2023-09-21T04:28:31.000Z	0x2fda9f1f32d1dfd29e0b60d72803f172c3b5854da03c4b0d95eecfe70bfea5ae	0x000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000005480000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff85000000000000000000000000000000000000000000000000000000007570e5cf00000000000000000000000035b5711093844c4cc31c334026b30b6a35b24057
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	1440	0x0b2c639c533813f4aa9d7837caf62653d097ff85	1999000000	0xb37070e31046cedf9a08d251c1cfcb1a8f47a92d	12	42161	109864983	0x147918218966d504270095371776bf9f10241381d8d03a29b9c1dbfbe7c29cdd	2023-09-21T20:39:03.000Z	0x9aec306cfcb0f7b54bc68eebedbd8ec7e90759e67bb52e159827aff32f6a9010	0x000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000005a00000000000000000000000000b2c639c533813f4aa9d7837caf62653d097ff8500000000000000000000000000000000000000000000000000000000772651c0000000000000000000000000b37070e31046cedf9a08d251c1cfcb1a8f47a92d

Example Query

Query with partition filter

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

CCTP_FeeCollected_event

Cross-Chain Transfer Protocol (CCTP) fee collection events recording protocol and relayer fees extracted from bridge transactions. Contains fee collector address, protocol fee amount, and relayer fee amount for tracking fee distribution and revenue analytics.

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_feeCollector`	`STRING`	Address of the account designated to receive collected fees. Hex-encoded, 0x-prefixed, 42-character string.
`in_relayerFeeAmount`	`STRING`	Amount of fees allocated to the relayer from the cross-chain transaction. String-encoded integer representing the fee in the smallest denomination of the token.
`in_protocolFeeAmount`	`STRING`	Amount of fees collected by the protocol from the transaction. String-encoded integer representing the fee in the smallest denomination of the token.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_feeCollector	transaction_hash	in_protocolFeeAmount
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	4	111456560	2023-10-28T16:51:37.000Z	0x0000000000000000000000000000000000000000	0xe4d2d1dacd7a8055c5ace6de2fd686da666135c5f6983d9be2153fce2fddd764	1000000
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	4	111454739	2023-10-28T15:50:55.000Z	0x0000000000000000000000000000000000000000	0xa3a20a846be41020ee1047e61f1d7cf46b185a4bfe6b20c0da18d3f112eabd6f	1000000
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	4	111440210	2023-10-28T07:46:37.000Z	0x0000000000000000000000000000000000000000	0x1177c7de1fc052198be544bfe7033a906979ff777495deb6307df64cb60647d7	1000000

Example Query

Query with partition filter

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

CCTP_FeeCollectorUpdated_event

No description available.

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_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldFeeCollector`	`STRING`	Address of the previous fee collector contract before a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.
`in_newFeeCollector`	`STRING`	Address of the new fee collector contract after a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

CCTP_OwnershipTransferred_event

Ownership transfer events from Cross-Chain Transfer Protocol (CCTP) contracts recording transitions from previous owner to new owner addresses. Used for tracking contract administration and governance authority changes across blockchain 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_previousOwner`	`STRING`	Address of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_newOwner	block_number	block_timestamp	in_previousOwner	transaction_hash
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	1	0x0fea3e5840334fc758a3decf14546bfdfbef5cd3	108940944	2023-08-31T11:17:45.000Z	0x0000000000ffe8b47b3e2130213b802212439497	0xc74e7462edca42b95ac029215f942913d297e6ca6ce619520e39c3a9d205c871
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	0	0x0000000000ffe8b47b3e2130213b802212439497	108940944	2023-08-31T11:17:45.000Z	0x0000000000000000000000000000000000000000	0xc74e7462edca42b95ac029215f942913d297e6ca6ce619520e39c3a9d205c871
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	45	0x2431cbdc0792f5485c4cb0a9bef06c4f21541d52	109126748	2023-09-04T18:31:13.000Z	0x0fea3e5840334fc758a3decf14546bfdfbef5cd3	0x51160851dfb652e889d3d83cd33b95e220a5f678c5582f32d0bcd15125328278

Example Query

Query with partition filter

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

CCTP_Paused_event

Cross-Chain Transfer Protocol (CCTP) pause state change events emitted when protocol operations are suspended or resumed. Records the account that triggered the pause action for tracking protocol governance and security controls.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_account	block_number	block_timestamp	transaction_hash
0x5e69c336661dde70404e3345ba61f9c01ddb4c36	false	4	0x2431cbdc0792f5485c4cb0a9bef06c4f21541d52	114564278	2024-01-08T15:22:13.000Z	0x500101faf1a3b613a48b1746e3e4537ba7bf9a08971f72f0d1afa4ae50592233

Example Query

Query with partition filter

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

CCTP_ProtocolFeeUpdated_event

No description available.

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_newProtocolFee`	`STRING`	Updated protocol fee value. Integer representing the new fee amount in basis points or protocol-specific units.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

CCTP_Unpaused_event

No description available.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

FastBridge_BridgeDepositClaimed_event

Bridge deposit claim events from Synapse FastBridge protocol on Optimism, recording when relayers claim funds for completing cross-chain transfers with token address, amount, recipient, and unique transaction identifiers. Used for analyzing relayer activity, bridge settlement patterns, and cross-chain transfer completion times.

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_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_token	in_amount	log_index	in_relayer	block_number	block_timestamp	in_transactionId	transaction_hash
0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	0x6c0771ad91442d670159a8171c35f4828e19afd2	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	104127275	31	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	116362170	2024-02-19T06:11:57.000Z	0x22e0ccfb79b871b7fe37892b66f2cc5cd2432f96e7a4d12931d27c8b3924a292	0x08a3d3fadebbdaf72c94a689a2e5e9969995bb8afa1315674ddb7aeb7a0eaa95
0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	0x6c0771ad91442d670159a8171c35f4828e19afd2	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	649870000	6	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	116384270	2024-02-19T18:28:37.000Z	0xc3f14f525340280996b2f97f1ab7e8b44c58bca5c193316324bf75036c6f0464	0x106c2e3ecb25ae4658ad1f9af92282c4cc9ceb916052a637f95da320588c5aad
0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	0x6c0771ad91442d670159a8171c35f4828e19afd2	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	1321710306	40	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	116389620	2024-02-19T21:26:57.000Z	0x9a18537b20664f3c3ab51812dfe40e4445fdff30cf0c4143b9e18081395067ab	0x2bdfc7e848fa6f881e94ed53848e2c57a2c584c725c90dae7f7ffd5df02ce6cf

Example Query

Query with partition filter

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

FastBridge_BridgeDepositRefunded_event

Bridge deposit refund events from Synapse FastBridge protocol on Optimism, capturing failed or canceled cross-chain transfers with token addresses, amounts, and recipient details for tracking bridge exception handling and user fund returns.

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_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_token	in_amount	log_index	block_number	block_timestamp	in_transactionId	transaction_hash
0x0af91fa049a7e1894f480bfe5bba20142c6c29a9	0x6c0771ad91442d670159a8171c35f4828e19afd2	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	3000000	9	114864594	2024-01-15T14:12:45.000Z	0x5ebaa50427bcc46f8816e67416a2a0e1f892de0760f8f84b324bd6f0e2e99418	0x2499c1de84de8693a4cfe6fda1668fa20f8ffadbfecf8e36827dfffe95b2c98d
0x127bbc2904dbb53cf601782fc12fa4fd633394e4	0x6c0771ad91442d670159a8171c35f4828e19afd2	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	2138044252	7	114867355	2024-01-15T15:44:47.000Z	0x98058d9d6f5953a4164d601f127bcaddf324f4d89398e6b5331ac820e00bb2c9	0x481eaf70d6afa4a993dc6afd005d0e924a68c44f4424ffddab18177aba05556e
0x41fc6db7d930db6d1869163f664fe4bdc3fe8b61	0x6c0771ad91442d670159a8171c35f4828e19afd2	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	100000000000000000	0	116167891	2024-02-14T18:15:59.000Z	0x660aa2289103ea5dcbc21dd1ee1e9c34d529d6d16247ed0814eb3ffbf51b5445	0x3277c54149e0b94e44347cb7a0f756f63b64dc2cbc5eb228dd48da4b64d3dd9d

Example Query

Query with partition filter

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

FastBridge_BridgeProofDisputed_event

No description available.

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_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

FastBridge_BridgeProofProvided_event

Proof submission events from Synapse FastBridge protocol on Optimism, recording when relayers provide cryptographic proof that a cross-chain bridge transaction was executed on the destination chain. Used for tracking bridge settlement completion and relayer performance analysis.

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_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_transactionHash`	`STRING`	Transaction hash on the destination chain for the cross-chain bridge or swap operation. 66-character hex string including 0x prefix.

Sample Data

address	removed	log_index	in_relayer	block_number	block_timestamp	in_transactionId	transaction_hash	in_transactionHash
0x6c0771ad91442d670159a8171c35f4828e19afd2	false	25	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	115859273	2024-02-07T14:48:43.000Z	0xf24a48677add3b18d8b9757cdd575912eda1d67663b9e6f50edfb242ac81642f	0x5cd3baf9bc347f974f855c1bd5ce27a2079a70772433760bfd84419c10a142c6	0x9f75cb66ef70b3d0fced1171cb7e2caad2ade3ed4f483b58f1e69013e6ec5e11
0x6c0771ad91442d670159a8171c35f4828e19afd2	false	11	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	115847772	2024-02-07T08:25:21.000Z	0x7ff69416bff42b4048422a8d5963b2b0142504ccaa0570f5bb33e7d7ce162a42	0x9a528d918e018d796129db1b0bcdf17f9f1bf59d493291cf2d78b22b7b3fb533	0x91f8d6d41fd36e59b42cc7552b4e786d0cdf0e4db68af5e6a56942388f20118b
0x6c0771ad91442d670159a8171c35f4828e19afd2	false	11	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	115855031	2024-02-07T12:27:19.000Z	0x4b7f549456fcc3c36a5e72605a7ed4983b631736fe41c62bb5694651363202e9	0x7e093c9a63b25a5aecd764b5ac953f52fdcf9bb6e2cbb46dcb735b555002137b	0xa77eff5eaf8a2c77187abda9899729c5773a67d079877b80f9435f773b57ab90

Example Query

Query with partition filter

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

FastBridge_BridgeRelayed_event

Bridge relay completion events from Synapse FastBridge protocol on Optimism, recording when cross-chain transfers are fulfilled by relayers with origin/destination token amounts and chain identifiers. Used for tracking bridge settlement activity, relayer performance, and cross-chain token flow analysis between Ethereum mainnet, Arbitrum, and Optimism.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_originChainId`	`STRING`	Chain identifier for the source blockchain where the cross-chain transfer originated. Numeric string representing the standard chain ID.
`in_originToken`	`STRING`	Contract address of the token being deposited on the origin chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_destToken`	`STRING`	Contract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_originAmount`	`STRING`	Amount of tokens sent from the origin chain in the smallest denomination of the token. Numeric string representing the token quantity in base units.
`in_destAmount`	`STRING`	Amount of tokens received on the destination chain in the smallest denomination of the token. Numeric string representing the token quantity in base units.
`in_chainGasAmount`	`STRING`	Amount of native gas token allocated for executing the transaction on the destination chain. Numeric string representing the gas amount in the smallest denomination (wei for EVM chains).

Sample Data

in_to	address	removed	log_index	in_relayer	block_number	in_destToken	in_destAmount	in_originToken	block_timestamp	in_originAmount	in_originChainId	in_transactionId	transaction_hash
0x08e61677363e7228adfa967bb542b1bcc02bcf4f	0x6c0771ad91442d670159a8171c35f4828e19afd2	false	16	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	116380444	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	93462800134580101	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	2024-02-19T16:21:05.000Z	99980000000000000	1	0x65fa7f7b2cb9ddcb28ea7597dc381cab04f1915952af68149b5135e7c5887583	0x2f82dba3c3d379e2ec8e5aa0eda250e2a1a3786aa9e729602564d49e9024d2d4
0x9f9dfc6a0098545d4762cc43320ab85ba3e7242a	0x6c0771ad91442d670159a8171c35f4828e19afd2	false	38	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	116383972	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	8009106270042655	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	2024-02-19T18:18:41.000Z	14997000000000000	1	0x737f0a94218f56f4aa1c66c78b98487c6d3a5dfbc2e03957c2aae261f56e71fb	0x720fd38f618bd16585b2766aedc2d75cdd0fdfec484cc339ffcb6d9a33fc79c8
0xb8685166a6e856e2c20ac51db55b1f507805bf49	0x6c0771ad91442d670159a8171c35f4828e19afd2	false	91	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	116370526	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	45568699268590563	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	2024-02-19T10:50:29.000Z	49990000000000000	1	0x10571d3f0b01a97ba964d93f99cf5160e2a4be952fd3c70cacbdca1e6e6efcf5	0x74024fb081b029362a1d69f5b2162c6ea04b71a66227aa855a88d13fc0fa0878

Example Query

Query with partition filter

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

FastBridge_BridgeRequested_event

Bridge request events from Synapse’s FastBridge protocol on Optimism, capturing cross-chain transfer initiations with origin/destination tokens, amounts, and destination chain IDs. Used for tracking bridge transaction flows and analyzing cross-chain liquidity movements between Optimism and other chains (primarily Ethereum mainnet).

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_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_request`	`STRING`	ABI-encoded bridge request parameters containing sender, recipient, token addresses, amounts, and gas settings. Hex-encoded bytes payload used for cross-chain message verification and execution.
`in_destChainId`	`STRING`	Numeric identifier of the destination blockchain where bridged assets will be delivered. Chain ID 1 indicates Ethereum mainnet in these samples.
`in_originToken`	`STRING`	Contract address of the token being deposited on the origin chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_destToken`	`STRING`	Contract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_originAmount`	`STRING`	Amount of tokens sent from the origin chain in the smallest denomination of the token. Numeric string representing the token quantity in base units.
`in_destAmount`	`STRING`	Amount of tokens received on the destination chain in the smallest denomination of the token. Numeric string representing the token quantity in base units.
`in_sendChainGas`	`BOOL`	Boolean flag indicating whether gas tokens should be sent to the recipient on the destination chain. When false, the bridged amount excludes additional gas for the destination chain transaction.

Sample Data

address	removed	in_sender	log_index	in_request	block_number	in_destToken	in_destAmount	in_destChainId	in_originToken	block_timestamp	in_originAmount	in_sendChainGas	in_transactionId	transaction_hash
0x6c0771ad91442d670159a8171c35f4828e19afd2	false	0x8ec106f16eea798f57c1995306c51d970918bc33	18	0x000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000010000000000000000000000008ec106f16eea798f57c1995306c51d970918bc330000000000000000000000008ec106f16eea798f57c1995306c51d970918bc33000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000000018dd308aecd000000000000000000000000000000000000000000000000000000748d84871e3d200000000000000000000000000000000000000000000000000000145f680b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000065cfd5b4000000000000000000000000000000000000000000000000000000000000025d	116258568	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	2050418602533842	1	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	2024-02-16T20:38:33.000Z	6998600000000000	false	0x76e9d7711f6d810ebfe7c4d4e5e6987b0035189ba9db0b4fb3097992b63db16c	0x946e8f0760577a072071a3a8b8cfdb972535b6eb074d3c1bbe70c339ea79b60a
0x6c0771ad91442d670159a8171c35f4828e19afd2	false	0xb1b89662a74d89f55da3268e2006b059b51ef249	108	0x000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000b1b89662a74d89f55da3268e2006b059b51ef249000000000000000000000000b1b89662a74d89f55da3268e2006b059b51ef249000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000000000000000000000000000000238520c676e0000000000000000000000000000000000000000000000000000013a33396388153000000000000000000000000000000000000000000000000000001d1a94a200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000065ced5e8000000000000000000000000000000000000000000000000000000000000024d	116225812	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	5527466516447571	1	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	2024-02-16T02:26:41.000Z	9998000000000000	false	0x4b4e1480e5ce8e479c33515e984fc0443b94fc3cd7a563ce8beccb8b15ddfb10	0xb4f13d9c05f8a26c1fb687d6c6b34fedca87319c7d86996122ffb5617761e18f
0x6c0771ad91442d670159a8171c35f4828e19afd2	false	0x0810fe89c46068e3b59c5126b678bfbb96ea2628	70	0x000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000810fe89c46068e3b59c5126b678bfbb96ea26280000000000000000000000000810fe89c46068e3b59c5126b678bfbb96ea2628000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000000000000000000000002a9fc0ee284000000000000000000000000000000000000000000000000000001be39e0d36adfd0000000000000000000000000000000000000000000000000000022ecb25c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000065cf349d0000000000000000000000000000000000000000000000000000000000000254	116237936	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	7850092337212925	1	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	2024-02-16T09:10:49.000Z	11997600000000000	false	0xf9dd2520601eab308d44c77d0fdeb8165c41efb8276b1a0fceb0c29fefc3ff01	0x49e0b6ec92b9f4b40b5e07da1230c2f801ce939d60f1c5760232b59ca070a66b

Example Query

Query with partition filter

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

FastBridge_ChainGasAmountUpdated_event

No description available.

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_oldChainGasAmount`	`STRING`	-
`in_newChainGasAmount`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

FastBridge_FeeRateUpdated_event

Fee rate change events from Synapse FastBridge contract on Optimism, tracking updates to bridge fee parameters with old and new rate values in basis points for monitoring fee policy adjustments.

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_oldFeeRate`	`STRING`	Previous fee rate (in basis points) charged by the FastBridge contract before this update event. Value of ‘0’ indicates no fee was previously set.
`in_newFeeRate`	`STRING`	Fee rate applied after this update event, expressed in basis points (bps) where 10000 equals 100%. Sample values like ‘200’ represent 2% fee rates.

Sample Data

address	removed	log_index	block_number	in_newFeeRate	in_oldFeeRate	block_timestamp	transaction_hash
0x6c0771ad91442d670159a8171c35f4828e19afd2	false	2	115311784	200	0	2024-01-25T22:39:05.000Z	0x9e171c71c52ba785d315b1a6efef4f1588b72f14a479c77c2a951d0a167f9fc2

Example Query

Query with partition filter

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

FastBridge_FeesSwept_event

No description available.

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_token`	`STRING`	Token address involved in the transaction or operation. 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

FastBridge_GovernorAdded_event

GovernorAdded events from Synapse Protocol’s FastBridge contract on Optimism, tracking additions and removals of governance addresses authorized to manage cross-chain 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_governor`	`STRING`	Address of the governor being added or removed from the governance role. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_governor	block_number	block_timestamp	transaction_hash
0x6c0771ad91442d670159a8171c35f4828e19afd2	false	132	0xbd88862fcc17de436f7bd17276c537acadda9a67	115311646	2024-01-25T22:34:29.000Z	0xff93d32dcb146c64d7bed9d4ef166a2dd6b1ef4f2bee5a58961ae639029b2caf

Example Query

Query with partition filter

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

FastBridge_GovernorRemoved_event

No description available.

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_governor`	`STRING`	Address of the governor being added or removed from the governance role. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

FastBridge_GuardAdded_event

No description available.

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_guard`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

FastBridge_GuardRemoved_event

No description available.

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_guard`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

FastBridge_RelayerAdded_event

Event log tracking the addition of authorized relayers to Synapse’s FastBridge cross-chain messaging protocol on Optimism. Used to monitor relayer network changes and validate which addresses have permission to execute bridge transactions.

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_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_relayer	block_number	block_timestamp	transaction_hash
0x6c0771ad91442d670159a8171c35f4828e19afd2	false	2	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	114753197	2024-01-13T00:19:31.000Z	0x314f80d6bde0eb445ff80986138bbd1c353f443666d8481446ffbf3b2dc4686e

Example Query

Query with partition filter

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

FastBridge_RelayerRemoved_event

No description available.

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_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

FastBridge_RoleAdminChanged_event

No description available.

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_role`	`STRING`	Role identifier for access control. 66-character keccak256 hash including 0x prefix.
`in_previousAdminRole`	`STRING`	Previous admin role identifier before the role change. 66-character keccak256 hash including 0x prefix.
`in_newAdminRole`	`STRING`	New admin role identifier for the specified role. 66-character keccak256 hash including 0x prefix.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

FastBridge_RoleGranted_event

Role assignment events from Synapse FastBridge contract on Optimism, tracking access control changes including admin and operator permissions. Used to monitor governance actions and permission management across the cross-chain bridge protocol.

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_role`	`STRING`	Role identifier for access control. 66-character keccak256 hash including 0x prefix.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_role	removed	in_sender	log_index	in_account	block_number	block_timestamp	transaction_hash
0x6c0771ad91442d670159a8171c35f4828e19afd2	0xe2b7fb3b832174769106daebcfd6d1970523240dda11281102db9363b83b0dc4	false	0xbd88862fcc17de436f7bd17276c537acadda9a67	1	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	114753197	2024-01-13T00:19:31.000Z	0x314f80d6bde0eb445ff80986138bbd1c353f443666d8481446ffbf3b2dc4686e
0x6c0771ad91442d670159a8171c35f4828e19afd2	0x0000000000000000000000000000000000000000000000000000000000000000	false	0xbd88862fcc17de436f7bd17276c537acadda9a67	0	0xbd88862fcc17de436f7bd17276c537acadda9a67	114753197	2024-01-13T00:19:31.000Z	0x471e3c044986e29fdd3ef07133ebb99e6a01cf3c3cd8768e589bff2d7dd1020e
0x6c0771ad91442d670159a8171c35f4828e19afd2	0x7935bd0ae54bc31f548c14dba4d37c5c64b3f8ca900cb468fb8abd54d5894f55	false	0xbd88862fcc17de436f7bd17276c537acadda9a67	131	0xbd88862fcc17de436f7bd17276c537acadda9a67	115311646	2024-01-25T22:34:29.000Z	0xff93d32dcb146c64d7bed9d4ef166a2dd6b1ef4f2bee5a58961ae639029b2caf

Example Query

Query with partition filter

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

FastBridge_RoleRevoked_event

No description available.

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_role`	`STRING`	Role identifier for access control. 66-character keccak256 hash including 0x prefix.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

FastBridge2_BridgeDepositClaimed_event

Bridge deposit claim events from Synapse FastBridge2 protocol on Optimism, recording when relayers claim deposits after cross-chain transfers complete. Used to track relayer activity, bridge settlement timing, and cross-chain transaction finality.

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_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_token	in_amount	log_index	in_relayer	block_number	block_timestamp	in_transactionId	transaction_hash
0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	0x5523d3c98809dddb82c686e152f5c58b1b0fb59e	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	49987396	1	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	117386474	2024-03-13T23:15:25.000Z	0x865471128830175da663941bac8dc94f8f54b409b57a1ec4d483138fde806d4e	0x2e344185c0217028a7db9eb02ede511106c0924708bdbd1a499325e5bb2f5e21
0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	0x5523d3c98809dddb82c686e152f5c58b1b0fb59e	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	59164795	62	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	117369646	2024-03-13T13:54:29.000Z	0x7ea739b4b25e00bdff6416928ee1301bf9d2cd1a57a3884c65b8071842727399	0xe58ece1f5898b45966ec7c4e24ba9ecfaa304c7a4d6d104cf339869d028e0295
0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	0x5523d3c98809dddb82c686e152f5c58b1b0fb59e	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	2002935325	16	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	117350783	2024-03-13T03:25:43.000Z	0xd85e27d622e6493978da8de213147ca0bf13a255246d812332475a791f1628e0	0x3b25fa07d4b2e0f523ffd5207dbf2b6ff1d06cd929fce294271ce73fc8bb69eb

Example Query

Query with partition filter

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

FastBridge2_BridgeDepositRefunded_event

Refunded bridge deposit events from Synapse FastBridge v2 protocol on Optimism, capturing failed cross-chain transfers returned to users. Used for monitoring bridge reliability and analyzing transaction failures with recipient addresses, token amounts, and unique transaction identifiers.

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_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_token	in_amount	log_index	block_number	block_timestamp	in_transactionId	transaction_hash
0xb1bde20ef1e8372d9d7cbaec1020708c0565c221	0x5523d3c98809dddb82c686e152f5c58b1b0fb59e	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	123642681085596	14	121644370	2024-06-20T12:45:17.000Z	0x480ea723d8ae4d8c38175c84792953d972416b44fbcd567cf12fff5a3e6fd876	0xa600cce49311ff34f4a29a9515d03a0fd1735ddb0ada96d529b6064fae5c4cdf
0x67acc20ef7a0b9d24184f9bb3c18dfd1fa597944	0x5523d3c98809dddb82c686e152f5c58b1b0fb59e	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	10000000000000	16	121644370	2024-06-20T12:45:17.000Z	0xb579d49de4f1eae3c8dc0b03b9b48b6296cbd4acf1b575eaaf4f392bb76fbf81	0x04726c7386b60fcc90fd27082a434e16b50c393ecd935bc01847373c4cf154d2
0xa5ff6c40baecf70dac0b33d853a7ac7e135b86c3	0x5523d3c98809dddb82c686e152f5c58b1b0fb59e	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	500000000000000	15	121644370	2024-06-20T12:45:17.000Z	0xd6b6cd6bfee5384011fc1093cb53f38a31b3701bbc872b52ba3eb696391240c8	0x253f605e840c8df02c3540003de83aff0a4c6f4fde8357fde70189289559dcca

Example Query

Query with partition filter

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

FastBridge2_BridgeRelayed_event

Bridge relay completion events from Synapse FastBridge v2 protocol on Optimism, tracking cross-chain token transfers with origin chain details, relayer addresses, and token amounts. Useful for analyzing cross-chain bridging volume, relayer activity, and fee structures between Ethereum mainnet, Arbitrum, and Optimism.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_originChainId`	`STRING`	Chain identifier for the source blockchain where the cross-chain transfer originated. Numeric string representing the standard chain ID.
`in_originToken`	`STRING`	Contract address of the token being deposited on the origin chain. Hex-encoded, 0x-prefixed, 42-character string.
`in_destToken`	`STRING`	Contract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_originAmount`	`STRING`	Amount of tokens sent from the origin chain in the smallest denomination of the token. Numeric string representing the token quantity in base units.
`in_destAmount`	`STRING`	Amount of tokens received on the destination chain in the smallest denomination of the token. Numeric string representing the token quantity in base units.
`in_chainGasAmount`	`STRING`	Amount of native gas token allocated for executing the transaction on the destination chain. Numeric string representing the gas amount in the smallest denomination (wei for EVM chains).

Sample Data

in_to	address	removed	log_index	in_relayer	block_number	in_destToken	in_destAmount	in_originToken	block_timestamp	in_originAmount	in_originChainId	in_transactionId	transaction_hash
0x724d304928f680aa5215a9fa4318a971949f84c6	0x5523d3c98809dddb82c686e152f5c58b1b0fb59e	false	1	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	117384695	0x0b2c639c533813f4aa9d7837caf62653d097ff85	3762908655	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2024-03-13T22:16:07.000Z	3797649875	1	0xb655c7d1aacd42023ff9d2815a3524c29b67a42b640bea3de57ee5fe05801522	0x0e2a39b2377c102ff305fc21f2e0b909baa75069bdf85a8a39e3913be6ff7ea8
0x2f5f8aede9ad024b08bbb9ec92a09c109e224a4e	0x5523d3c98809dddb82c686e152f5c58b1b0fb59e	false	2	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	117350662	0x0b2c639c533813f4aa9d7837caf62653d097ff85	9992900930	0xaf88d065e77c8cc2239327c5edb3a432268e5831	2024-03-13T03:21:41.000Z	9998000000	42161	0x06a2b3ea8dd548f54d67ecaf76a17ee079ff19012bf0726f71a9fd272c9701e7	0x9fd7a02b69939e6e55c7029937a3c5eeb2c9ce3024972d89a8e559687127be88
0x2c9394f92fd4a275f534041b0d85c0bce540e2de	0x5523d3c98809dddb82c686e152f5c58b1b0fb59e	false	6	0xdd50676f81f607fd8ba7ed3187ddf172db174cd3	117359386	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	22973737782480790	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	2024-03-13T08:12:29.000Z	29994000000000000	1	0x56dc11facc37131c846a5134415e27954d0c6fc72f88c458de26914fa3a8bf6c	0x41c4a59a6c32df32b40b4285fe9681cf053d770acbc9a1dbbf15b5655e5842c5

Example Query

Query with partition filter

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

FastBridge2_FeesSwept_event

No description available.

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_token`	`STRING`	Token address involved in the transaction or operation. 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

MiniChef_Harvest_event

Reward claims from MiniChef staking contracts emitted when users harvest accumulated incentive tokens. Contains pool identifier, user address, and harvested token amount for tracking yield farming rewards across liquidity mining programs.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pid`	`STRING`	Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xe8c610fcb63a4974f02da52f0b4523937012aaa0	0x7a6e41ea4edced41207660e6c0f16345cdd6150a	false	10479200015297781127	2	72715581	2023-02-07T10:15:11.000Z	0x387b656c180d6e32b55ef5ce91ae346020073f4fbbe844c15efa67c47ea42fe1
0xe8c610fcb63a4974f02da52f0b4523937012aaa0	0x0e649d15b366ee8f559dd272f7ce6fca4573b21d	false	236409245579174333489	2	72754268	2023-02-07T15:34:02.000Z	0x82f4b36485402953545b967ef22683a99b602a7bbda2b208905a34731f1cfa0e
0xe8c610fcb63a4974f02da52f0b4523937012aaa0	0x153b4f4f2c6c284f844a53eb2e097d23b7bfa4dd	false	6810634591666658551	2	72727612	2023-02-07T11:59:57.000Z	0x14037ad032ddabc0a3e86f556c53268d227a33394356651af29dff9496a02c9b

Example Query

Query with partition filter

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

SynapseBridge_TokenDeposit_event

TokenDeposit events emitted by Synapse Bridge contracts recording cross-chain token transfers. Contains source token address, transfer amount, destination chain identifier (EIP-155), and recipient address for tracking bridge deposit 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_token	in_amount	log_index	in_chainId	block_number	block_timestamp	transaction_hash
0xae80ea74e9e28d4b519b94e80fd547cae6dad6c0	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x121ab82b49b2bc4c7901ca46b8277962b4350204	1000000000000000	2	1	20462684	2022-08-24T21:40:54.000Z	0x1ab9b52256b6fa2b01a595d4cad9359cb4c0c1e0e509801684663edb54fa1f53

Example Query

Query with partition filter

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

SynapseBridge_TokenDepositAndSwap_event

Cross-chain token deposit events where tokens are deposited to the Synapse Bridge and swapped via liquidity pool before being bridged to the destination chain. Contains deposit amount, destination chain ID (EIP-155), recipient address, pool swap parameters (token indexes, minimum output amount), and deadline timestamp for tracking combined deposit-and-swap operations across bridge transfers.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_tokenIndexFrom`	`INT64`	Index of the source token in the liquidity pool for the swap operation.
`in_tokenIndexTo`	`INT64`	Index of the destination token in the liquidity pool for the swap operation.
`in_minDy`	`STRING`	Minimum output amount expected from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SynapseBridge_TokenMint_event

Token minting events emitted by Synapse Bridge contracts when wrapped tokens are minted on the destination chain during cross-chain transfers. Contains recipient address, token contract, minted amount, bridge fee, and kappa identifier for tracking cross-chain message delivery.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_kappa`	`STRING`	Unique identifier for the cross-chain bridge transaction. 66-character hex string including 0x prefix.

Sample Data

in_to	in_fee	address	removed	in_kappa	in_token	in_amount	block_number	block_timestamp	transaction_hash
0x1578f034078d5b5dc9d017af75779ae436048415	2500000000000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x6dd5d941e3c2debed382059a3991241b75b5c80629d5a1fb2b1d0bfad67047aa	0xd52f94df742a6f4b4c8b033369fe13a41782bf44	246765800000000000000000	74720562	2023-02-16T13:23:17.000Z	0x4d492ca6ce64d6d8300d134825c87ce6b4297942dee7cb668d547e66d844fabf
0x1578f034078d5b5dc9d017af75779ae436048415	2500000000000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x9db05b00ed6efe427e05a78c5c50480c80e93a01a1e29de592e99ac470bbbd60	0xd52f94df742a6f4b4c8b033369fe13a41782bf44	248488000000000000000000	74743288	2023-02-16T15:05:18.000Z	0x0bca7f074a1a63f966bc8bd39f709e9c46da3bd8310f1545be11686c7a0ca789
0x1578f034078d5b5dc9d017af75779ae436048415	2500000000000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x4777a8153ab1da4eec1938f2004e8f32d7e00efce7db6b5ae48a01a868b36007	0xd52f94df742a6f4b4c8b033369fe13a41782bf44	186061000000000000000000	74773109	2023-02-16T17:07:01.000Z	0x8ca0cab63c86ffabe2e9aec8edf764fb318c1afbf8c0626b5bc681c59349ce9c

Example Query

Query with partition filter

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

SynapseBridge_TokenMintAndSwap_event

Synapse Bridge cross-chain token mint and swap events combining minting on destination chain with automatic token swap execution. Records bridge transaction identifier (kappa), source and destination token indices, swap amounts, slippage parameters, fees, deadlines, and swap success status for cross-chain liquidity 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_tokenIndexFrom`	`INT64`	Index of the source token in the liquidity pool for the swap operation.
`in_tokenIndexTo`	`INT64`	Index of the destination token in the liquidity pool for the swap operation.
`in_minDy`	`STRING`	Minimum output amount expected from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.
`in_swapSuccess`	`BOOL`	Boolean flag indicating whether the token swap operation completed successfully within the cross-chain bridge transaction.
`in_kappa`	`STRING`	Unique identifier for the cross-chain bridge transaction. 66-character hex string including 0x prefix.

Sample Data

in_to	in_fee	address	removed	in_kappa	in_minDy	in_token	in_amount	log_index	in_deadline	block_number	in_swapSuccess	block_timestamp	in_tokenIndexTo	transaction_hash
0x05c4b5fa7f14c33da1c825eb4dd9f1caf800ba35	500000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xb8b9eba7b2158ecd065d04ccdea811cc02cf1ac8251c9c05bcf8275a9acb0322	3997367800789130	0x809dc529f07651bd43a172e8db6f4a7a0d771036	5001711449745096	7	1698434659	111115766	true	2023-10-20T19:31:49.000Z	1	0x93f9002e6b6de33faa42bc24645932cc9c5c4ea93d5095b84077021bba17840e
0x2136184d88f0e711f59098586511e60005404db8	500000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xf152ed85467bf5f5a5ae93069f11d9aca8d10a5545ef0d9858373476b4699898	5043313673668427	0x809dc529f07651bd43a172e8db6f4a7a0d771036	5251263716855923	14	1697864979	111089917	true	2023-10-20T05:10:11.000Z	1	0xa03d5ec4ad17a7fd35eb6db41359a33ff985a5bfdcfe421d797ecec7b14f2e14
0xdc08c1111caa4132abede6bcf6da7838183882d5	500000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x181bb3f3b51c50d42fe0bf1e9faa11fb2d7a3c820afddcd9b646b32ca23f619c	10486768839537735	0x809dc529f07651bd43a172e8db6f4a7a0d771036	11497758764570361	12	1698367286	111081878	true	2023-10-20T00:42:13.000Z	1	0x4d3fb27020546e4aeabeebb2b39e4d8ceafa4773c54a61a53d4a5277a29ecd5c

Example Query

Query with partition filter

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

SynapseBridge_TokenRedeem_event

TokenRedeem events emitted by Synapse Bridge contracts when tokens are redeemed from one chain to another. Contains destination chain identifier, recipient address, token address, and amount for tracking cross-chain token redemption 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_token	in_amount	log_index	in_chainId	block_number	block_timestamp	transaction_hash
0x569d327288d8354f16813afb01bba0e60c1301f9	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x5a5fff6f753d7c11a56a52fe47a177a87e431655	90883091857640387654	2	43114	80620600	2023-03-13T18:34:49.000Z	0xdd1dfdc82204ca5e9725b225bd4dcfd585c78ea588ed2d6161267fd80d127964
0xc6c3fecb7a6e801b6026bb8dcd218271e5d3fb9a	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x5a5fff6f753d7c11a56a52fe47a177a87e431655	834418080554267629312	2	1	80466670	2023-03-13T05:39:25.000Z	0xa76f020a71027f12ba96d2c7938c95f3e8b0b5f512714c67f6bf6b3154e5e037
0x87bd6713e6967a0aac10649bac60216041dcd13a	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x809dc529f07651bd43a172e8db6f4a7a0d771036	649799343648338734	4	1	80625076	2023-03-13T19:05:42.000Z	0x1d375baf5ea9cd02759ba0db0b61e77717ac9e90e2cf17292b0931dfef36787c

Example Query

Query with partition filter

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

SynapseBridge_TokenRedeemAndRemove_event

Cross-chain bridge redemption events where synthetic tokens are burned and withdrawn with automatic pool swap execution. Contains source token amounts, destination chain identifiers (EIP-155), recipient addresses, swap parameters including deadline and slippage protection, and target liquidity pool token indices for atomic redeem-and-swap 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_swapTokenIndex`	`INT64`	Index of the target token within a liquidity pool for the swap operation. Zero-indexed integer identifying which token in the pool will be received.
`in_swapMinAmount`	`STRING`	Minimum token amount acceptable from a swap operation. Numeric string representation of token quantity in smallest denomination.
`in_swapDeadline`	`STRING`	Unix timestamp representing the deadline by which a token swap must be executed. Integer value encoded as a string.

Sample Data

in_to	address	removed	in_token	in_amount	log_index	in_chainId	block_number	block_timestamp	in_swapDeadline	in_swapMinAmount	transaction_hash	in_swapTokenIndex
0x14bd6d35a22d8cd6cac3e2bd2b336b991bd8cea9	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	4268777764367270415568	6	1	20281446	2022-08-23T12:35:34.000Z	1661344516	4075457600	0x505d53cdf9524ac5157cf6aa263a5e640474cd094db6ebfbd40a459afd714dec	1
0x535b51bac7bab9bff70c9def9e9f62062cba3e7b	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	4200134576196638827891	6	1	20224682	2022-08-23T01:30:34.000Z	1661304630	4009532748	0xdb18d3ddd29cb89a4010fdf20ea8fd09ffd2fdff1fb01cbcf6dc65364e156fef	1
0x73933c5ba2e5622c2a91f2ac31cf411b8e1ba444	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	1996885183027527705943	6	1	20219912	2022-08-23T00:30:42.000Z	1661301040	1891125147	0xc5cefe3250c013197a3e8f71bbd9fa24d26ac5e2ebb616764eef943d088bcb62	1

Example Query

Query with partition filter

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

SynapseBridge_TokenRedeemAndSwap_event

Cross-chain token redemption events that combine bridging with an atomic swap operation. Records bridge transfers where the recipient receives a different token than sent, including source chain identifier, token addresses, pool indices, amounts, slippage parameters, and expiration deadline for tracking Synapse Protocol cross-chain asset conversions.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_tokenIndexFrom`	`INT64`	Index of the source token in the liquidity pool for the swap operation.
`in_tokenIndexTo`	`INT64`	Index of the destination token in the liquidity pool for the swap operation.
`in_minDy`	`STRING`	Minimum output amount expected from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

in_to	address	removed	in_minDy	in_token	in_amount	log_index	in_chainId	in_deadline	block_number	block_timestamp	in_tokenIndexTo	transaction_hash
0xc76982cc5c6b7a6a775005f631569142dbd4e0b5	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	18902141546952383768	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	20892394876532276076	31	56	1698761977	111279206	2023-10-24T14:19:49.000Z	2	0x2a8f00c235b4716e23a290464d3271ef6950d1c6d907041ab2ca110e0d02f5eb
0xe12d731750e222ec53b001e00d978901b134cfc9	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	15689019861066157686	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	17668311016476329243	92	56	1698777842	111287138	2023-10-24T18:44:13.000Z	1	0xb959653db94bc2c24b1447ef81e83d943996cc941fe469cbf96e1e8aba1108ae
0xda2c334bd07a621592d0db0193dce16ae72b7677	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	20207625	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	20697072816650250695	28	137	1698786186	111291317	2023-10-24T21:03:31.000Z	2	0xaabf0bc6fad107b3756de1d519cbbfdf6fd3d189cd355fa401f68e8d73fdba94

Example Query

Query with partition filter

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

SynapseBridge_TokenRedeemV2_event

TokenRedeemV2 events emitted by Synapse Bridge contracts when users redeem tokens on the destination chain of a cross-chain transfer. Records the redeemed token address, amount, recipient address, and target chain identifier for tracking cross-chain asset movement completions.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_token	in_amount	in_chainId	block_number	block_timestamp	transaction_hash
0x121d0e021f000a19001d0a1a0106031313000c1a071e00060700131a03020f0c	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xfb21b70922b9f6e3c6274bcd6cb1aa8a0fe20b80	11952858277	121014925	5837506	2022-04-15T02:27:57.000Z	0xf5d31aeabe134945c34d401bc6d5016c724d745fc0b5305bb74839ca1c99ac9b
0x181312031701160e071b170c070c14091f11070d070c1a020e080f0519151e08	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xfb21b70922b9f6e3c6274bcd6cb1aa8a0fe20b80	26861536377	121014925	8925394	2022-05-24T16:26:06.000Z	0xf1c88b87bbcf6cb4bb4fd6804cf4057c1565ea18c6e8df98fe7454df7386110a
0x1c1f1a0b191d1e1e02121e14021f03030b11011917100b030f1813010f050304	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xfb21b70922b9f6e3c6274bcd6cb1aa8a0fe20b80	115880535	121014925	22550531	2022-09-09T19:08:12.000Z	0xef310835db39ecfd9a0657e784dfc4c9b40049f4466aff265993c1ce9e44e559

Example Query

Query with partition filter

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

SynapseBridge_TokenWithdraw_event

Token withdrawal events from Synapse Bridge contracts recording cross-chain bridge transaction completions. Contains recipient address, token contract, withdrawal amount, bridge fee, and kappa transaction identifier for tracking asset movements between blockchains.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_kappa`	`STRING`	Unique identifier for the cross-chain bridge transaction. 66-character hex string including 0x prefix.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SynapseBridge_TokenWithdrawAndRemove_event

Cross-chain bridge withdrawal events recording token redemptions with integrated liquidity pool removal operations. Contains bridge transaction identifiers (kappa), token amounts, fees, swap parameters including deadline and minimum acceptable output, and swap execution status for tracking Synapse Bridge cross-chain asset transfers.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_swapTokenIndex`	`INT64`	Index of the target token within a liquidity pool for the swap operation. Zero-indexed integer identifying which token in the pool will be received.
`in_swapMinAmount`	`STRING`	Minimum token amount acceptable from a swap operation. Numeric string representation of token quantity in smallest denomination.
`in_swapDeadline`	`STRING`	Unix timestamp representing the deadline by which a token swap must be executed. Integer value encoded as a string.
`in_swapSuccess`	`BOOL`	Boolean flag indicating whether the token swap operation completed successfully within the cross-chain bridge transaction.
`in_kappa`	`STRING`	Unique identifier for the cross-chain bridge transaction. 66-character hex string including 0x prefix.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

​Tables

​CCTP_ChainGasAirdropped_event

​CCTP_ChainGasAmountUpdated_event

​CCTP_CircleRequestFulfilled_event

​CCTP_CircleRequestSent_event

​CCTP_FeeCollected_event

​CCTP_FeeCollectorUpdated_event

​CCTP_OwnershipTransferred_event

​CCTP_Paused_event

​CCTP_ProtocolFeeUpdated_event

​CCTP_Unpaused_event

​FastBridge_BridgeDepositClaimed_event

​FastBridge_BridgeDepositRefunded_event

​FastBridge_BridgeProofDisputed_event

​FastBridge_BridgeProofProvided_event

​FastBridge_BridgeRelayed_event

​FastBridge_BridgeRequested_event

​FastBridge_ChainGasAmountUpdated_event

​FastBridge_FeeRateUpdated_event

​FastBridge_FeesSwept_event

​FastBridge_GovernorAdded_event

​FastBridge_GovernorRemoved_event

​FastBridge_GuardAdded_event

​FastBridge_GuardRemoved_event

​FastBridge_RelayerAdded_event

​FastBridge_RelayerRemoved_event

​FastBridge_RoleAdminChanged_event

​FastBridge_RoleGranted_event

​FastBridge_RoleRevoked_event

​FastBridge2_BridgeDepositClaimed_event

​FastBridge2_BridgeDepositRefunded_event

​FastBridge2_BridgeRelayed_event

​FastBridge2_FeesSwept_event

​MiniChef_Harvest_event

​SynapseBridge_TokenDeposit_event

​SynapseBridge_TokenDepositAndSwap_event

​SynapseBridge_TokenMint_event

​SynapseBridge_TokenMintAndSwap_event

​SynapseBridge_TokenRedeem_event

​SynapseBridge_TokenRedeemAndRemove_event

​SynapseBridge_TokenRedeemAndSwap_event

​SynapseBridge_TokenRedeemV2_event

​SynapseBridge_TokenWithdraw_event

​SynapseBridge_TokenWithdrawAndRemove_event

Tables

CCTP_ChainGasAirdropped_event

CCTP_ChainGasAmountUpdated_event

CCTP_CircleRequestFulfilled_event

CCTP_CircleRequestSent_event

CCTP_FeeCollected_event

CCTP_FeeCollectorUpdated_event

CCTP_OwnershipTransferred_event

CCTP_Paused_event

CCTP_ProtocolFeeUpdated_event

CCTP_Unpaused_event

FastBridge_BridgeDepositClaimed_event

FastBridge_BridgeDepositRefunded_event

FastBridge_BridgeProofDisputed_event

FastBridge_BridgeProofProvided_event

FastBridge_BridgeRelayed_event

FastBridge_BridgeRequested_event

FastBridge_ChainGasAmountUpdated_event

FastBridge_FeeRateUpdated_event

FastBridge_FeesSwept_event

FastBridge_GovernorAdded_event

FastBridge_GovernorRemoved_event

FastBridge_GuardAdded_event

FastBridge_GuardRemoved_event

FastBridge_RelayerAdded_event

FastBridge_RelayerRemoved_event

FastBridge_RoleAdminChanged_event

FastBridge_RoleGranted_event

FastBridge_RoleRevoked_event

FastBridge2_BridgeDepositClaimed_event

FastBridge2_BridgeDepositRefunded_event

FastBridge2_BridgeRelayed_event

FastBridge2_FeesSwept_event

MiniChef_Harvest_event

SynapseBridge_TokenDeposit_event

SynapseBridge_TokenDepositAndSwap_event

SynapseBridge_TokenMint_event

SynapseBridge_TokenMintAndSwap_event

SynapseBridge_TokenRedeem_event

SynapseBridge_TokenRedeemAndRemove_event

SynapseBridge_TokenRedeemAndSwap_event

SynapseBridge_TokenRedeemV2_event

SynapseBridge_TokenWithdraw_event

SynapseBridge_TokenWithdrawAndRemove_event