saddlefinance_v1_fantom

Tables

MetaSwap_TokenSwap_event

Token swap events from Saddle Finance MetaSwap pools containing buyer address, token indices, and swap amounts. Records pool-to-pool token exchanges with soldId and boughtId representing token positions within the liquidity pool.

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_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

address	removed	in_buyer	log_index	in_boughtId	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9	false	0x50ae81c68b499386065f7e6f89bbe14da64a6c04	128	1	52551657	5966846004211870811	2022-12-19T18:50:48.000Z	5958121	0x17821bd6556e4840442709ea66a920d50a30c1d1cc563c83d8e846fba9c9f17f
0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9	false	0x93131efee501d5721737c32576238f619548edda	271	1	52537164	14400000000000000000	2022-12-19T08:48:08.000Z	14267017	0xf36098cd618822cbc0f2ecde600fe2d665994e23e7fb1ee0cd88bf9d73fb81f6
0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9	false	0x3319161b131401124e61ffcdff0aa7f6fdcbbfed	47	1	52530562	8410309791674270652	2022-12-19T03:48:57.000Z	8376894	0x2ce1a2835e50689d26a95f33372fc2234ebf89e0fa5fb64a9fc199fa75b691dc

Example Query

Query with partition filter

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

PoolRegistry_AddPool_event

Pool registration events emitted when a new liquidity pool is added to the Saddle Finance registry. Contains pool configuration including token addresses, LP (Liquidity Provider) token, asset type classification, approval status, and optional metapool parameters.

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_poolAddress`	`STRING`	Contract address of the liquidity pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_poolData`	`STRUCT<poolAddress STRING, lpToken STRING, typeOfAsset INT64, poolName STRING, targetAddress STRING, tokens STRING, underlyingTokens STRING, basePoolAddress STRING, metaSwapDepositAddress STRING, isSaddleApproved BOOL, isRemoved BOOL, isGuarded BOOL>`	Structured data containing liquidity pool configuration and metadata for Saddle Finance pools. Includes pool and LP token addresses, asset type, pool name (hex-encoded bytes32), token addresses (comma-separated), base pool references for metapools, and approval status flags.

Sample Data

address	removed	in_index	log_index	in_poolData	block_number	in_poolAddress	block_timestamp	transaction_hash
0x88cc4aa0dd6cf126b00c012dda9f6f4fd9388b17	false	1	0	{“tokens”:“0xb67fa6defce4042070eb1ae1511dcd6dcc6a532e,0xc969dd0a7ab0f8a0c5a69c0839db39b6c928bc08”,“lpToken”:“0x1c1091558709788c671c82753e69cfcf1a29c6c9”,“poolName”:“0x4652415842502d616c5553440000000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0xab374155a7b6ca520d23de8db6a85471ceafb620”,“typeOfAsset”:2,“targetAddress”:“0xab374155a7b6ca520d23de8db6a85471ceafb620”,“basePoolAddress”:“0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9”,“isSaddleApproved”:true,“underlyingTokens”:“0xb67fa6defce4042070eb1ae1511dcd6dcc6a532e,0xdc301622e621166bd8e82f2ca0a26c13ad0be355,0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“metaSwapDepositAddress”:“0x5dd186f8809147f96d3ffc4508f3c82694e58c9c”}	41480323	0xab374155a7b6ca520d23de8db6a85471ceafb620	2022-06-27T19:00:05.000Z	0xde07e3eae3e4142ac7492dda1f78085e7e2e080ea529c7c6119d1dc8797124cc
0x88cc4aa0dd6cf126b00c012dda9f6f4fd9388b17	false	2	1	{“tokens”:“0x049d68029688eabf473097a2fc38ef61633a3c7a,0xc969dd0a7ab0f8a0c5a69c0839db39b6c928bc08”,“lpToken”:“0x21ea072844fd4abed72539750c054e009d877f72”,“poolName”:“0x4652415842502d55534454000000000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0xdb5c5a6162115ce9a188e7d773c4d011f421bbe5”,“typeOfAsset”:2,“targetAddress”:“0xdb5c5a6162115ce9a188e7d773c4d011f421bbe5”,“basePoolAddress”:“0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9”,“isSaddleApproved”:true,“underlyingTokens”:“0x049d68029688eabf473097a2fc38ef61633a3c7a,0xdc301622e621166bd8e82f2ca0a26c13ad0be355,0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“metaSwapDepositAddress”:“0x4a5208f83a17e030a18830521e4064e80728c4fc”}	41480323	0xdb5c5a6162115ce9a188e7d773c4d011f421bbe5	2022-06-27T19:00:05.000Z	0xde07e3eae3e4142ac7492dda1f78085e7e2e080ea529c7c6119d1dc8797124cc
0x88cc4aa0dd6cf126b00c012dda9f6f4fd9388b17	false	3	41	{“tokens”:“0xb67fa6defce4042070eb1ae1511dcd6dcc6a532e,0xc969dd0a7ab0f8a0c5a69c0839db39b6c928bc08”,“lpToken”:“0xd7d1b50c8ef77d9ab410723f81363c8b252c729f”,“poolName”:“0x4652415842502d616c5553440000000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0x4e1484607760118ebe2ab07c0c71f1b4d9671e01”,“typeOfAsset”:2,“targetAddress”:“0x4e1484607760118ebe2ab07c0c71f1b4d9671e01”,“basePoolAddress”:“0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9”,“isSaddleApproved”:true,“underlyingTokens”:“0xb67fa6defce4042070eb1ae1511dcd6dcc6a532e,0xdc301622e621166bd8e82f2ca0a26c13ad0be355,0x04068da6c83afcfa0e13ba15a6696662335d5b75”,“metaSwapDepositAddress”:“0x0e510c9b20a5d136e75f7fd2a5f344bd98f9d875”}	41952966	0x4e1484607760118ebe2ab07c0c71f1b4d9671e01	2022-07-03T23:33:29.000Z	0x444159de54ac2145114c397c051512caeee1b11aed2eb70e07f1a799af90316f

Example Query

Query with partition filter

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

SwapFlashLoan_TokenSwap_event

Token swap events from Saddle Finance and Zyberswap liquidity pools recording buyer address, sold and bought token identifiers, and token quantities exchanged. Used for tracking decentralized exchange (DEX) trading activity and price impact analysis across automated market maker (AMM) pools.

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_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokensSold`	`STRING`	Quantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_tokensBought`	`STRING`	Quantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
`in_soldId`	`STRING`	Index identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
`in_boughtId`	`STRING`	Index identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.

Sample Data

address	removed	in_buyer	in_soldId	log_index	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9	false	0x5bab9d61f84630a76fa9e2f67739f2da694b5402	1	12	63651667	4538984	2023-06-06T01:02:22.000Z	4569983300542971491	0x8068ee9afccf2af720b6e3391effc18a29abd9e09ec321240c369facb2dc0af2
0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9	false	0x5bab9d61f84630a76fa9e2f67739f2da694b5402	1	77	63666659	3466697	2023-06-06T08:52:26.000Z	3486554220057846377	0x27c114654ca86892e3a49bd28ec20b950ade5073c6a33187460ff3ff181431bb
0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9	false	0x8f4e8a8acface47507afee6302b793f3612ceaf1	1	11	63683863	7975140	2023-06-06T17:21:45.000Z	8011273375228729931	0x37173f51bc1d06b11d5ec9c70ae9425675d88400d1922ef2809517a9e4afccb3

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

MetaSwap_TokenSwap_event

PoolRegistry_AddPool_event

SwapFlashLoan_TokenSwap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​MetaSwap_TokenSwap_event

​PoolRegistry_AddPool_event

​SwapFlashLoan_TokenSwap_event

Tables

MetaSwap_TokenSwap_event

PoolRegistry_AddPool_event

SwapFlashLoan_TokenSwap_event