synapse_v1_avalanche

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
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	25000000000000000	7	34084133	2023-08-18T15:57:19.000Z	0x4b41baa8c006806fc5a359cb528f3bddd466cbab5943c1815abe709eb8190521
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	25000000000000000	10	34089134	2023-08-18T18:56:27.000Z	0x0c4c4ea743d8914a380a6fea5e379fcc81a8898c32dcc69dfb41398dc7389a53
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	25000000000000000	31	34079693	2023-08-18T13:17:19.000Z	0x7bd01fcd06e3160c20c9f1ccb1c8c90cbbe2415fd0ff2678eaa746a7a53be3b5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	14	31804895	2023-06-25T23:59:21.000Z	0xcb77c3b6233cd263c1db43f49282b12d3ee1eae71773c86b9be13c0633d102df	25000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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
1000000	0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	49266000	53	33181973	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	0x2ea2d72416099c682269cfca31b7b99c04b376fa	0x4d0b9ba1237bc9b8a81c80c586dcebb0805c6072d1e1b8c6493e00672d6fbb6e	2023-07-28T10:20:40.000Z	0	0x49e964283a52945efdd6414aadd25594a8b873c7d3ec82f25dd7d7e995d0ab2d
800000	0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	1457698852	15	36795183	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	0xef5704c5116a05ebdd23739506740cf0700fa321	0x3dbbd91ef8857e71d44da945d3e6c5cc958520b7204566d51bf712e9de1968c9	2023-10-22T23:57:29.000Z	3	0xabe4424cfca232481a930f5b87d95e39c81e522f4120296bf2c80f825db0e48f
800000	0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	0xd586e7f844cea2f87f50152665bcbc2c279d8d70	468810879357433852459	26	36790674	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	0x371cccf19da105c4e22bd8c2e296e7aaaab071ac	0xbc7fd6f55aee2ebe185e5e657d92959465ca5b7140e1b3f701a5f6d8ef1a73bc	2023-10-22T21:23:51.000Z	0	0xe2cdcd2b03ffbc40415aa3d73ab1a86d9c543d8fa3596f7ee02f5c9d60c56c69

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	1046	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	5000000000	0xc35f0c0e755419098ff5ab639cae01376f5f4709	12	1	32042650	0xcd89f7d3a0b2f76d833ac9604c0cc9cd5c4b145c3637ae9914d42d82a0e603e6	2023-07-01T14:36:20.000Z	0xd67a3f4a3fd506592c89140179d07e34ef870a646a32f7fbccdc5d2dad4eb064	0x00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000416000000000000000000000000b97ef9ef8734c71904d8002f8b6bc66dd9c48a6e000000000000000000000000000000000000000000000000000000012a05f200000000000000000000000000c35f0c0e755419098ff5ab639cae01376f5f4709
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	1063	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	747009554	0x579031c51cbc0c28e062a74b289204c254fabe34	28	1	32056800	0xe2a4b4fa330a77fe0fe04a93a0eedb029f1f44277f45384507e2a103455ebae8	2023-07-01T22:35:48.000Z	0xead7fda96de299a996f6b5d6a304cde5cbb30d1799dda8951b51f02bd24ea5f4	0x00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000427000000000000000000000000b97ef9ef8734c71904d8002f8b6bc66dd9c48a6e000000000000000000000000000000000000000000000000000000002c867612000000000000000000000000579031c51cbc0c28e062a74b289204c254fabe34
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	1048	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	20698957	0x2844310391cd489c8e2dcd5ba7e34aa47a37c6ce	44	42161	32043697	0x69a2253f7a796ae9f194cdfc5062a475ae6953dffa0f89a99291aeb921e23581	2023-07-01T15:12:43.000Z	0x0a1a67d2d562f11c7111d869a904d8ae5e214fc6f519b1abee0e376f84426549	0x00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000418000000000000000000000000b97ef9ef8734c71904d8002f8b6bc66dd9c48a6e00000000000000000000000000000000000000000000000000000000013bd74d0000000000000000000000002844310391cd489c8e2dcd5ba7e34aa47a37c6ce

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	17	34245419	2023-08-22T16:29:19.000Z	0x0000000000000000000000000000000000000000	0xc4d324ef66d5b837d6ca3ea1a195ea47a247a3a45899fca2d9196aaa17d7400e	1000000
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	23	34238023	2023-08-22T12:07:03.000Z	0x0000000000000000000000000000000000000000	0x7ba27a063cab68d546de16e642e3eb73c48d034193b6d8552d95dc76d06fe47a	1000000
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	9	34257021	2023-08-22T23:25:21.000Z	0x0000000000000000000000000000000000000000	0xcba26361ff08483978bf3974f6a2c51d55b081f66368eb5aa0d42d13d4fccca0	1000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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_avalanche.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
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	5	0xb73acb429ba868984c0236bdf940d4fe1e643f27	31804348	2023-06-25T23:40:49.000Z	0x890bc5691e6011f580e264065d09a7a1a6902131	0x3d9b518df4fa2a1972c1ac17f36f3ffa8ea09bccd3fd6ba8848e251122186160
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	4	0x890bc5691e6011f580e264065d09a7a1a6902131	31804348	2023-06-25T23:40:49.000Z	0x0000000000000000000000000000000000000000	0x3d9b518df4fa2a1972c1ac17f36f3ffa8ea09bccd3fd6ba8848e251122186160
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	25	0xe9530411510c4d6cf699712904beca2849488176	32016355	2023-06-30T23:40:18.000Z	0xb73acb429ba868984c0236bdf940d4fe1e643f27	0x8a235bf462a2e1a6077ea0d29a3841e1d994ff6e0d6a284b149bec9bc4b0a6e5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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
0xfb2bfc368a7edfd51aa2cbec513ad50edea74e84	false	1	0xe9530411510c4d6cf699712904beca2849488176	39136197	2023-12-16T20:42:17.000Z	0x5e1b112868dded860574eb07c80509dd98ea782081c53b40c0784cc158fa2f5c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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_avalanche.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_avalanche.CCTP_Unpaused_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

in_pid	address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
1	0x3a01521f8e7f012eb37eaaf1cb9490a5d9e18249	0x9e325b1a063ada6088f1f06587580ee5a4233313	false	568831306112923848778	25	17540958	2022-07-19T18:22:20.000Z	0x07167fc745ba05d0c790d76b6e76008ab7ef4ee8062c9ee80ddc63111655c114
1	0x3a01521f8e7f012eb37eaaf1cb9490a5d9e18249	0xe7ad0c5488687d7ba44a81f9f5460435fc9d057d	false	3718771602135942613	23	17531705	2022-07-19T13:15:14.000Z	0xc467b6452cfeb163b2d1d766ac3b55c42635f3fffb0f6bc26b11ee829be1ef73
1	0x3a01521f8e7f012eb37eaaf1cb9490a5d9e18249	0x22ecc33bf964ed13d18419fdae725919a757f230	false	17502737454735105363	105	17520508	2022-07-19T07:00:07.000Z	0xb3a8d331fa7a1ce46358f2cecf93a7ae6735aa88e6797b81ae7d9be3da987917

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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
0x47c383866f172601e0963192c9e9a89d68c1176e	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	1000000000000000000	130	1284	11405545	2022-02-26T04:48:22.000Z	0x13ebb6dab2ca7ca957e91472eba906e38473c91b3f4049c8483d8eb5755f24e4
0x13df57376f8ee5066471e61606def582f2c6bd6f	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	11010000000000000000	2	1284	19305505	2022-08-30T07:16:53.000Z	0xe8b98fb8e08b71c615431bbb26e8f843bc5f25e6333e669e3dc11019e935e923
0x23819c768fee6cc5c77c50bcf70b9c7d9eb8f024	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	9000000000000000000	1	53935	19329430	2022-08-30T20:37:24.000Z	0x475e70ba97a1762a045e041c6ef884a01f6e8219040a55012e8fe7384fc5dc50

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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

in_to	address	removed	in_minDy	in_token	in_amount	log_index	in_chainId	in_deadline	block_number	block_timestamp	in_tokenIndexTo	transaction_hash
0x3dac2b3d450e2f989743c1aaa2991fee18de9225	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	57690586477821045238	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	58000000000000000000	6	1666600000	1652854560	14802668	2022-05-17T06:16:11.000Z	1	0x61c1bec00eb08082f9c1fb02f3272fa7b4d6719dbe959b86e567ca1c2c16a1f1
0x6e47966a011d3b14144dfc525fb7cbc44c58dc05	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	11925464716090778760	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	12000000000000000000	6	1666600000	1652914674	14832533	2022-05-17T22:58:00.000Z	1	0x602b857af491d7276510e60182535188a717fcca6859a6de0e0b1e572c98831b
0x6e47966a011d3b14144dfc525fb7cbc44c58dc05	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	1213323692814520515	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	1230000000000000000	10	1666600000	1652914746	14832567	2022-05-17T22:59:11.000Z	1	0xd48e2dea0efd44e750b81f6ad72dc898c25b2049f9bd0a4209a108e33368e486

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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	log_index	block_number	block_timestamp	transaction_hash
0x79c9af4fd5de2e1106b031a9ed76aca2a13cdf2b	2000000000000000	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0x230cd0ce5ba996dcea9840e311d28309ba829802dc562de29ad0294a0ef0b9e7	0x19e1ae0ee35c0404f835521146206595d37981ae	65125000000000000	1	36347112	2023-10-12T06:41:32.000Z	0xba2b1edb1c4190a5b84484e190e7451e2e0b7a3247fcdd4bd0a41bd122ca48c6
0x7a6a59588b8106045303e1923227a2cefbec2b66	5000000000000000000	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0x017d1ccd8965feaab03e766666fdeaee2e3f00384aebea5dc59cdb760f6935c1	0x1f1e7c893855525b303f99bdf5c3c05be09ca251	544414708346806670278	5	36362633	2023-10-12T15:28:33.000Z	0x78979ecc4e98a4afeb1bd413804ea2327f55dfb1a136ee6d788a8b381520e76b
0x16eb1deae4c4c32805da237db93771b4cb12416a	2000000000000000	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0x1840195a50e505695af6ff7fda004664ca9fb3961012e738bcf0cdb24b7f50c6	0x321e7092a180bb43555132ec53aaa65a5bf84251	91982497597084614	3	13647278	2022-04-20T01:53:50.000Z	0x5566611e1879138e102856a6e2790b865bdd2b46858f1c8955299f53c5040f06

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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
0xd07f165d4da8f0b66feb3b17614532c8c565caa0	2000000000000000	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xd639d8dfa793d9d708c298ec6ec0bad8f47ba143323a3e8cfd21869eda53f181	7985615496679169	0x19e1ae0ee35c0404f835521146206595d37981ae	8001610716501456	19	1684394327	30126808	true	2023-05-17T07:27:15.000Z	1	0xe059c2ddccd8d45bfd014fb123d0b16fe931d3c8e9b010593bd1552ea0a6a5e1
0xb95a01d3b437c57631231bf995ca65678764b2e8	2000000000000000	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xbe514bf6755a93926f4972b5f7af9a3b63e3e6e906e42a8181fdcdbd75aeb0e4	197644157613167833	0x19e1ae0ee35c0404f835521146206595d37981ae	198040039652433048	19	1684413676	30136075	true	2023-05-17T12:48:19.000Z	1	0xa11ff313540cd047ee79d612ef72d6b12a777436f58a315832f8a3d7756d12ce
0x80de8a0c5392aff981cc4dbd0bff2c47f21a851d	2000000000000000	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0x3d30268c119c5f1b5b612c3c97f53e379d65bdd963b518aa15988eef6b162494	6987411278024888	0x19e1ae0ee35c0404f835521146206595d37981ae	7001407090799397	22	1684372402	30115928	true	2023-05-17T01:20:32.000Z	1	0x3f2aed11cb202a3b44a66e5a49596daa24e80d6a2aeb334b1727f9afffed069e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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
0x05024a2a13a3067d96fb2f4ea6ff45e629a8bc5e	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0x1f1e7c893855525b303f99bdf5c3c05be09ca251	10000000000000000000	56	56	6436661	2021-11-02T17:08:32.000Z	0xa6aace9a4127be01e2a0aa78d397d762234fe1b5681d94dfb661299864e5068e
0x147aac5e6237bfb7533ac1a809c18f39311f7e87	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0x1f1e7c893855525b303f99bdf5c3c05be09ca251	281793246542482402461	64	56	6438000	2021-11-02T17:54:47.000Z	0x322b7e73b94e69a64640c29d1f7179b987f3c25f27419f780ceb87f0f27134e6
0x147aac5e6237bfb7533ac1a809c18f39311f7e87	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0x1f1e7c893855525b303f99bdf5c3c05be09ca251	283792799950770806472	6	56	6417231	2021-11-02T06:13:40.000Z	0x4df44f950ce02e211b6adedd8278bd806c75b78547ba118a512cd4df243c36ed

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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
0x23d35090fe1d86da7153c0dbb05929a8281dc9d7	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xcfc37a6ab183dd4aed08c204d1c2773c0b1bdf46	131879032446321327272675	13	1	5022698	2021-09-30T05:17:54.000Z	1633065465	126477687673	0x2c4b5eeda84bfb1afd03e077ad45a51125fb400f168abb2267ee0951b9996ac5	2
0xe440fb473b7e46eae0d9cc3f1f9f726a752131be	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xcfc37a6ab183dd4aed08c204d1c2773c0b1bdf46	19821752645959763078757	13	1	5028153	2021-09-30T08:25:39.000Z	1633076731	18944478334	0x7d4f73725110d1f01d91b2bf242aacf53104aa13182914049bf4915f97068ad5	2
0x0a38e385e3f29d84705c3338bb2568bc1629870d	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xcfc37a6ab183dd4aed08c204d1c2773c0b1bdf46	1149014727093084275885	13	1	5017411	2021-09-30T02:16:04.000Z	1632969303	1025932695	0x2f4a84c3038514c96ac1aafc6caad3a1e894c3aa7e5e465bf56234e84ac5aab3	1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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
0xc3dd0b4d4e17acc7c51eab7bcfecae6b28f37ec1	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	1846065649096285133877	0xcfc37a6ab183dd4aed08c204d1c2773c0b1bdf46	1924755607609347942681	19	56	1637802748	7345980	2021-11-24T01:12:44.000Z	1	0x47b50c36f3d021ab97bcc4ba4da2dc80c492fad935e2eb5574d7cda7bc845eb0
0x660d80dc3352060b3e2e8710befaae40efb99c7e	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	949001236214319352735	0xcfc37a6ab183dd4aed08c204d1c2773c0b1bdf46	990885185345711694543	124	56	1637812585	7350871	2021-11-24T03:56:39.000Z	1	0x641c8a9d24c935996f4ff444bb70ab6c7570dbb1df16cfcd194b8361dd2b6f88
0xd04c382490d4c2f03526169b7f3b053f86e8b2e2	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	1438077595969146426883	0xcfc37a6ab183dd4aed08c204d1c2773c0b1bdf46	1499988400833655227651	203	56	1637803674	7346444	2021-11-24T01:28:12.000Z	1	0x636d8e415368cda0946187a06c6f5d5761f34a5585536abcd9026374f7a52169

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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	log_index	in_chainId	block_number	block_timestamp	transaction_hash
0x0d0714181a1217170c1f150d04150e111e1e000c01100d110904020b080a1b14	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xe97097de8d6a17be3c39d53ae63347706dcf8f43	11000000	0	121014925	11959465	2022-03-11T04:37:28.000Z	0xeaa4655aeaacf9f76aaf64c93395ae63a84012764a1457ab5dd293a40cf873a5
0x020c0908141f04130d12090d15150f0a0e060b0a0e141c0e161b170103031309	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xe97097de8d6a17be3c39d53ae63347706dcf8f43	99900000	6	121014925	11275753	2022-02-23T03:14:44.000Z	0x14fc52434cb4f89667df93b0fb0548f228fb7c91199128cc47287a2c0a83f57e
0x020c0908141f04130d12090d15150f0a0e060b0a0e141c0e161b170103031309	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xe97097de8d6a17be3c39d53ae63347706dcf8f43	19980000	56	121014925	12841360	2022-04-01T04:06:34.000Z	0x9966afb776b96c8a1716d119f227538b145dd8d5cc5603b28fd260ca5c3ef1af

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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

in_to	in_fee	address	removed	in_kappa	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x53c12e707c0e71780820ac5526b2f47ba4fd7f68	50000000000000000	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xf9bdd9b3387bbfa4c5a64abf766428d5047eecc68a0afd311ef76852ff71c5be	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	2063588000000000000	1	17810213	2022-07-26T02:52:52.000Z	0x2c41e118ca9d511300a7e1937a1e25cbc68a878280b3119b698130f9292c52dc
0x0859c85f89b2834cfbc1111327993d04a6c739bb	50000000000000000	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0x08d9e2aace8289032f393a2558549a99b0325ffd6349fc2ad5b94c9de821097c	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	6773700000000000000	1	17837820	2022-07-26T18:55:08.000Z	0x2a3fe802eead1d1c3051bdb7490b60d3c04ae43ddbcc8c9d58f45c129639ea60
0x4148b87f7c9f0897db73e98d3081bd1aed62aff8	50000000000000000	0xc05e61d0e7a63d27546389b7ad62fdff5a91aace	false	0xeb98617c028cb6b4b24479f469d10f0cae9f4c434959102919235a9905e631d8	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	8559174930470510000	1	17836559	2022-07-26T18:11:20.000Z	0xa3e36ff51835602e1455ad578a111418829a9878c7d0245ad1abc86c8cf0842a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_avalanche.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_avalanche.SynapseBridge_TokenWithdrawAndRemove_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

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

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

Metrics

Primitives

Contracts

Blockchain

​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

​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

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