synapse_v1_bsc

Tables

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	0x8f5bbb2bb8c2ee94639e55d5f41de9b4839c1280	0x0b372e31e6825349c6c920878726c1350f02deef	false	214951953443949851	338	18063747	2022-05-23T22:22:04.000Z	0x2abbec38f3f5ffa9f708a1c18b39c3d9762510585a8ade201f7952b082251e7a
1	0x8f5bbb2bb8c2ee94639e55d5f41de9b4839c1280	0xc5ed2333f8a2c351fca35e5ebadb2a82f5d254c3	false	869542411686954129320	30	18037951	2022-05-23T00:47:28.000Z	0xd83f9a65f81376b04fd6a00ea97eef5ea404871d624becd8db03ab8a0e2c15f5
1	0x8f5bbb2bb8c2ee94639e55d5f41de9b4839c1280	0xc5ed2333f8a2c351fca35e5ebadb2a82f5d254c3	false	869816405632377868523	17	18052320	2022-05-23T12:48:28.000Z	0x42c940acf9792fb1c5a734e2915793eed3c3a817d4db5796c1d1593bb4d3c97b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_bsc.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
0xaef897aa692840fe94eb4721df9842fcdf888993	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	10000000000000000000	743	43114	26062400	2023-02-28T15:34:53.000Z	0x39399f6fbd9a096073071cde3c3bf55267de99dc0d5b877c437dc826cb34b2fc
0xf1d3e20844c9c7d717f2749e44c3cadcdfec1f8f	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xe9e7cea3dedca5984780bafc599bd69add087d56	2000000000000000000	161	56	24925503	2023-01-19T15:49:47.000Z	0x59b0a73ae79d5a840246b6f54578710249cd8cf475b65a201374e176fb363333
0xae5e6a9998b031b3898535849baedb82225233e4	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xe9e7cea3dedca5984780bafc599bd69add087d56	12060611494552038276	431	2000	24179248	2022-12-24T10:54:05.000Z	0xe3cd7544a5dea4a5144a2b4f0af9d4629636497db9b6f06a4f0ffceae759edf1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_bsc.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_bsc.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
0x743c37cec6bb400126ad048d2b21f7320353582d	35000000000000000000	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xef75fb12d66903969233b086ca8941eb26715a244ed13c6befe1927c19b6e978	0x130025ee738a66e691e6a7a62381cb33c6d9ae83	165000000000000000000	272	15079645	2022-02-08T15:19:06.000Z	0xab28be9ca1d0a35c03c7475b6b9e74cb297bcdd60c82e14c12cc01976a8bde4c
0x0d080a3c3290c98e755d8123908498bce2c5620d	1000000000000000000	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xf2b79f67029018e07ef45834ef893a34b67eb4eb13f23e079357bcf99422db3d	0xa4080f1778e69467e905b8d6f72f6e441f9e9484	368414395464062735620	137	15078384	2022-02-08T14:15:32.000Z	0x70b93b7e3952dd8825191087b45060716ed5dcbcc0e62298f9f5cc813501930d
0xfbd2fb29719b2372d9b46dff92f1067d3974ca67	1000000000000000000	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xe5ffde10677a6f809ce6302ed8da042d097bdc74d4045724a8aa9fa435314020	0xa4080f1778e69467e905b8d6f72f6e441f9e9484	11244057223271460118	86	15081499	2022-02-08T16:52:59.000Z	0x9e20cb10528d0deb61a3a29571944d8c485536c7330e384161fc16cea521d70b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_bsc.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
0x49aeb029966057481eea09752df660891ef91a74	2000000000000000000	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xd88b346d258f7b0261f6b381c8908f62b5baf028e730281be3606827767e2e39	71412645214629832270	0x23b891e5c62e0955ae2bd185990103928ab817b3	71497513820581232793	267	1681217715	27255729	false	2023-04-11T13:13:15.000Z	1	0xd18467e7e437d18de42ca1a091eb5fbd0ae38948b14080225d45dac00ff46022
0xef2539ecc96565063cd744076f705d3c481659c8	2000000000000000000	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0x714601af41e3fae8f4e1d3324ddc01ca59d77cbde59d1ddf5fce10ed114d680a	47944404314745829905	0x23b891e5c62e0955ae2bd185990103928ab817b3	48000000000000000000	43	1681199660	27250818	false	2023-04-11T09:04:09.000Z	1	0xe3629dd4628e94e620c4444519d8bc6865b982adf3adf0044a5071a75ebe0285
0xf14441ff631bed279f8e18d199098175fea99fe3	2000000000000000000	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xa94aa796c561cc0097a2328c888e97e98621a98db6639af9a3e789d341aab7c9	18737554637784819982	0x23b891e5c62e0955ae2bd185990103928ab817b3	18757950696568235617	316	1681180231	27249189	false	2023-04-11T07:42:17.000Z	1	0x1f11e7a814267a60e7ff3ca6f2704e33d3eb02e9eb157a0346b4c14fe42734ab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_bsc.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
0xeaeb463d658f26d339f415be7f33ada2d5c6cfae	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0x130025ee738a66e691e6a7a62381cb33c6d9ae83	21812900591729265426577	444	250	15066512	2022-02-08T04:21:23.000Z	0x77780c2b6a518d4a1ac1fc3dcf35bc5acf59e4fd02ed4016bb4ad38b4f0c239f
0xccd5e36a8c2dbfcae556a78a266b74ab6096ca96	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0x130025ee738a66e691e6a7a62381cb33c6d9ae83	43376712191221790832336	462	250	15088093	2022-02-08T22:22:45.000Z	0x5eb8fd8eeda82e3069e77c15d82a1650d31b55b1d79e6bd8658ee5721f67ae4c
0xebaec6481f5a24e3cd9eda221764ba2555d12872	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0x130025ee738a66e691e6a7a62381cb33c6d9ae83	49369875764636159970325	633	250	15070314	2022-02-08T07:31:29.000Z	0x2bbecec4d15735c60077038757bc7f9dafa100c6a0347e9400ab1688c337c976

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_bsc.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
0x498b867f76a9c6a065cc35ebfa7b4baffa956880	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0x23b891e5c62e0955ae2bd185990103928ab817b3	1284678801167497711101	241	1	17961796	2022-05-20T09:07:03.000Z	1653124012	1178134278	0xaf7027ec771381ed25fcb3ec27b80189a39a44bd90d011a3c9f4eb6c6de5d01c	2
0x4f24af10010c9910c79a6a7bb3fab98cf0702144	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0x23b891e5c62e0955ae2bd185990103928ab817b3	476652477923780410317	209	1	17972984	2022-05-20T18:27:12.000Z	1653157621	400372848	0xdbeb50c90b86367ad959f273117bb00fe463e8cc2730096edf637a340293f48c	1
0x79c41b04ebefe105913e112d8b4a1ecf7ea22101	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0x23b891e5c62e0955ae2bd185990103928ab817b3	12414876837730289433241	162	1	17975093	2022-05-20T20:13:16.000Z	1653163987	11871638452	0x303000aa779617d7f8401501fe236dc934921f285cdd9e530165782ac324abdf	1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_bsc.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
0x40efb119647113c7ebbf5d43a9c2bfe0a92bc3ce	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	63352970	0x23b891e5c62e0955ae2bd185990103928ab817b3	75860024764158045660	393	10	1651472038	17417423	2022-05-01T06:14:13.000Z	1	0xaea6603a2b52b74f20510358bbb4f8528d63cf231db4910bbf7a4766e1af203d
0xd3636bb636a1bc7a8efaeef8cc2d595725957dd7	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	278495933	0x23b891e5c62e0955ae2bd185990103928ab817b3	299564926178022987777	991	10	1651497140	17425660	2022-05-01T13:12:26.000Z	1	0xe7b457050e5b32bf4be0dc5dc841ac2822605522791263d5fb523feab338f535
0xb0aa921e77363846489ebf000c95871edc482f24	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	7671332	0x23b891e5c62e0955ae2bd185990103928ab817b3	17975427354534453710	623	10	1651502755	17427543	2022-05-01T14:47:40.000Z	1	0xcdba5896286b513b48ef8f1fa8ec718b8ab9f42aab61c1d951caa1631907d40c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_bsc.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	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xb7a6c5f0cc98d24cf4b2011842e64316ff6d042c	6000000	79	121014925	15904106	2022-03-09T08:42:18.000Z	0xb7ebedc4f0a9a25f9f00dc2075128e9e4b804ea196af550fcba8c7f99bb6f5a5
0x0d0714181a1217170c1f150d04150e111e1e000c01100d110904020b080a1b14	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xb7a6c5f0cc98d24cf4b2011842e64316ff6d042c	5000000	96	121014925	15904133	2022-03-09T08:43:39.000Z	0x5c5ada63fc3b92a7ba60a72dcf3c46b2ea277206e18377b98129cbaba80d81a9
0x0d0714181a1217170c1f150d04150e111e1e000c01100d110904020b080a1b14	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xb7a6c5f0cc98d24cf4b2011842e64316ff6d042c	1800000	46	121014925	15896284	2022-03-09T02:10:03.000Z	0xab2fcb7400436402c183fa48e374f9b82bbac51c178a223426adeab6cac5678b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_bsc.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
0x7b1d3bb271aa9144a0f058553383fb0b696f441b	1000000000000000000	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xda8c4331abe79f5e3700a731bd1bf77ac3e15455203c17003bfd861d9d2dd496	0xe9e7cea3dedca5984780bafc599bd69add087d56	11050000000000000000	24	26878634	2023-03-29T06:59:07.000Z	0x229cf69491253b7067842e661822a129488a232a198418e438656f9369ea1f3e
0x9586d60e8558077438abf7597dbba9137194c7d7	1000000000000000000	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xef88408ec46be59162c4e90ae438bafad6dedff4dc3336d21332941bf84ec2a1	0xe9e7cea3dedca5984780bafc599bd69add087d56	428848051627069945255	27	24939935	2023-01-20T04:03:11.000Z	0xea5757fa2062721b35c719e6814e739500a56745fe449759f995928d9693a71a
0xca077a26544657b08508e1f02236fc10bac86bf3	1000000000000000000	0xd123f70ae324d34a9e76b67a27bf77593ba8749f	false	0xdae437d559863ec2eef7d76c1f4c4cf3a304ba2b4c056a0a65c85d5af2aad7f9	0xe9e7cea3dedca5984780bafc599bd69add087d56	557000000000000000000	128	27164759	2023-04-08T08:47:10.000Z	0x9866e4383471430f3dcdc7a58736a16ad27a1ee902335a96d0b942a34490a218

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

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

​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

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