synapse_v1_fantom

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
2	0xaed5b25be1c3163c907a471082640450f928ddfe	0x93c08a3168fc469f3fc165cd3a471d19a37ca19e	false	898534455028867443278	9	34868721	2022-03-31T09:40:01.000Z	0xd0a1a9aec5cd26aaf602afb5e39595fd9b615b7e1214cef716871812f20cb4c7
3	0xaed5b25be1c3163c907a471082640450f928ddfe	0x93c08a3168fc469f3fc165cd3a471d19a37ca19e	false	2302916825945739132289	26	34909525	2022-03-31T21:42:02.000Z	0x85022acca3b9aed861d27080ef617870d8c5171bcb6a78acfcfbb88ea53aee00
3	0xaed5b25be1c3163c907a471082640450f928ddfe	0x8f40dcd6ba523561a8a497001896330965520fa4	false	6397536502204898532117	2	34904892	2022-03-31T20:27:06.000Z	0x44769a0a6d0c38b95a0694b40aee816dddf32341ad7fc7d1027e43160c98e4af

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_fantom.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
0x6d223f8534ac0db6098d262ca26c29ad494b34a2	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	3000000000000000000	1	53935	68816125	2023-09-30T15:23:19.000Z	0x59eade14b4d757170293186a293fd6647250e7c8b0462163f8f8debd492af177
0xeaeb463d658f26d339f415be7f33ada2d5c6cfae	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x78de9326792ce1d6eca0c978753c6953cdeedd73	400000000000000000000000	2	56	55112639	2023-02-05T05:05:34.000Z	0xa01859f1dce66e0a2c83a893ff8894d833324d8f2f82f87cab7254277aa099b8
0x0bf10ceeef0b41e8edfb590dffdc7370527198e5	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	1000000000000000000000	1	53935	55134898	2023-02-05T12:30:53.000Z	0xcb8925f7dfa1839a9da3548b30391ddfc7f183f6971977252a110d518a4e0fbd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_fantom.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_fantom.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
0xc73b6d3d7b69da5f5f8328c2cdf7920e433edf60	1000000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xd54a021c4efa51ea059da9516694c6230a3ef791d38954de79ca35e7bae7abf5	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	3997375200591141	46	64280534	2023-06-18T05:07:02.000Z	0xc23929d2a7c2e0bf05ef57313d75ff927a9bf56acf1445e6ec55248183840eb8
0x3254048c1fba48d5c8dd3b96537cdaba8d4b854a	3598071587215343	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x21a29f6df64f77d738a1647c99eae3373332d5780b0f359bf043604572bfb4fc	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	5993187907105024361	20	64303734	2023-06-18T18:38:10.000Z	0x33f9813468a3f228f1d72c63b367c39ae4ddec7101fe1bfac3798557df477c17
0xd78cafaeb472dfc84b92a94bcf15238ba934c60f	600000000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x657dbc90a5bee88b9be089b4d9fe4ed8f8e9c5728a420cb46d1397d3a23c9b17	0xed2a7edd7413021d440b09d654f3b87712abab66	150913600462848134	6	64313341	2023-06-18T22:30:51.000Z	0x61fb556e1c5c9d6a90d8cdef1bd22c04d7088600a260f096c7035e510b103af2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_fantom.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
0xa5bd4fa2db60afdf5cf57c6c2ea40beef982caae	1000000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xd1cf43928ecf2be596f41edf9444f1a80fdba87f583614fe9980befeff5f29e6	555920219889123505	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	578842378060311856	13	1684009834	62145879	true	2023-05-12T20:30:57.000Z	1	0x813a045453cdfbf9b7252a45427a3d41c1e7e8ff39f3cb3a15674f26f1ed1987
0x0d33067140e8af5cf2d023d23f9058182b944897	1000000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xc17302af8ca2d5567a98b604f367b4040b5d1911fd1ebae0fdab348d85f895bc	27846188883636622	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	28994365768051461	7	1683961014	62094064	true	2023-05-12T06:57:23.000Z	1	0xe5270daa8e4def5f476372282d459b3a937bd3b3d62125d43996e87e38d21e12
0x4408e04e4d8aeb7edbc0bc0ae66028762fdf29e5	1000000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x2bc6f045e72ebaaa7d24c7536582731e4944b86b30d659c0e4bba3d3d93259c6	325513050755072409	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	338934871673336537	18	1683956609	62089221	true	2023-05-12T05:44:44.000Z	1	0xf35936f193c77f4b698c8b3d563e244aef684e15968dca0933481d86545bf84a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_fantom.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
0x3f03409918d8a54feacf3adc09a7af8e62a41400	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	2028770703645816051	8	1	35941257	2022-04-13T07:41:35.000Z	0x2fd3d02997f3935d98e3059190e959865cfac50b878e398b47ae33553bb2e438
0xb224e28534e07c04eb43c7fe20a1f881a6061755	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	2604276607193977034	18	1	35920056	2022-04-13T01:30:41.000Z	0x3f9a9db2637be64e3439afa2048723a1e8492e7de00febeb38a302ca0d22418f
0x96671ed6382f1bbdff107854e4d300ba91c196a7	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	1719311246624577711	17	1	35956274	2022-04-13T12:14:32.000Z	0x7e9109e402ecf97d6ed5262dfc1cd0ffe4a83ee43abb10a00fc7ac9cb5c65e04

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_fantom.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
0x7f5674bc1cfd438af00dde5a02df3cdc345ead5a	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xed2a7edd7413021d440b09d654f3b87712abab66	3457426379977304447249	4	1	53665129	2023-01-13T02:23:38.000Z	1673662998	3295855385	0x8c08964336329f52ce1d48954a97aae77afef5f9a301db05bd0b071e2162a7a6	1
0xc00a6614b8030ce216302016e11c6b4140b5e499	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xed2a7edd7413021d440b09d654f3b87712abab66	2317681896574469099114	4	1	53716425	2023-01-13T22:44:00.000Z	1673736222	2199819564	0xcf1e68dfa7558d7aa7613d1fd9f79c8a245e8a749654bfe96646c186cb800654	1
0xaee2ae13ebf81d38df5a9ed7013e80ea3f72e39b	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xed2a7edd7413021d440b09d654f3b87712abab66	66666069485792438860745	4	1	53671537	2023-01-13T04:50:48.000Z	1673671834	64030088895	0x68bf5509b1e8bd45cf83cd4588d7cce6a83f4b27539dd0c8c71dc43f288995b4	1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_fantom.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
0xc27fd9d5113de19ea89d0265be9fd93f35f052c8	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	2091001633870158871	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	2181745720310434883	143	10	1643074925	28871019	2022-01-24T01:43:03.000Z	1	0x19ce4335cb47e9a2d2afe9e7b38718f965702c6c2d57ee21674d4f6e98fde1fd
0x533a04903dade8b86cc01fcb29204d273fc9f9b9	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	15052164427984469950	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	15674612588712276187	13	10	1643118160	28915831	2022-01-24T13:42:43.000Z	1	0x78b24703bea134109bb17258f659883cc5fc1a1ec64bde400c570dadacf689f6
0xc766d73be01caa06834032bf5c8f8f0f41a7bf36	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	9683721449187058576	0x67c10c397dd0ba417329543c1a40eb48aaa7cd00	10083996459647470250	92	10	1643115003	28912004	2022-01-24T12:50:16.000Z	1	0x62a49affcd59b864dd3a7292bd10972b471d988c0ee77f58cae2beb1f3847619

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_fantom.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	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0xa0554607e477cdc9d0ee2a6b087f4b2dc2815c22	3500000	0	121014925	33051518	2022-03-10T12:52:37.000Z	0x435ffeb5e29388d95fb915b7214c3e70040e8d33cd89a6a0d0046a446d285e3c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synapse_v1_fantom.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
0x6ffb400bf628e1bc43d96bce456660ab9a99b754	1000000000000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x7775e4af4438edd545a34c6f2a7de1656d877c7716d03ee0fcba2b4e12a70c7d	0x78de9326792ce1d6eca0c978753c6953cdeedd73	166403489519028638479519	175	48226397	2022-10-02T07:17:08.000Z	0x1f4bf7b0b31b011bb73ba53f52624301a32a40a00d46d2b58e329bf3d20bb7c7
0x2e4992d4c334104543925a47c21e9474df464932	2000000000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x9827657cb069a94ed88e2a902f879fadfc2f89193c25e939272d8d0cb8938a92	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	61451800000000000000	1	51334149	2022-11-23T09:14:44.000Z	0xd6769555ec91c50e42417537d61437ecb271be5d9b5e35bff25ec1054b05902c
0xef973c572a1a5003d6fa23ee2a01cac2318fbc38	5000000000000000000	0xaf41a65f786339e7911f4acdad6bd49426f2dc6b	false	0x1761e8f1982aafeca07f4bed3d6f98853ae041c78780d248f65070c18ce28e1f	0x78de9326792ce1d6eca0c978753c6953cdeedd73	147454017137101219893	0	22858728	2021-11-23T03:01:30.000Z	0x4b07b8ec905eb17f4750f7764f754222ba7ea8fada08a883418fbe3c329a02c6

Example Query

Query with partition filter

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