saddlefinance_v1_optimism

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
0x5847f8177221268d279cf377d0e01ab3fd993628	false	0xfcd0845cbac7e7af231573cdc8767a11e837a868	2	1	8459809	107004147697345309396	2022-05-17T10:38:15.000Z	106513850	0xd93aea34a3f9f965a08acb9866b5cc3f157d65c650e8c014d6c2a7ae4a08532c
0x5847f8177221268d279cf377d0e01ab3fd993628	false	0x145aa20fe7f57d43e0395afe5aba3bd5b22e1fd3	2	1	8461274	108100461744128448018	2022-05-17T11:20:45.000Z	107608929	0xab836ce18f923fee54c7cbea0d20f58157fd6978741868263050179e722d7621
0x5847f8177221268d279cf377d0e01ab3fd993628	false	0xa6baa075fb5cf4721b43fe068ee81b56f34fa06d	8	2	8455978	486177976652785491292	2022-05-17T08:50:38.000Z	486013568	0x0a84129e2b096a1f7331985579deacfdb967f3469ed5c30a8c2e0b5d9a418541

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.saddlefinance_v1_optimism.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
0x4e1484607760118ebe2ab07c0c71f1b4d9671e01	false	5	0	{“tokens”:“0xbfd291da8a403daaf7e5e9dc1ec0aceacd4848b9,0xf74ebe6e5586275dc4ced78f5dbef31b1efbe7a5”,“lpToken”:“0xf349fb2b5ed45864e1d9ad34a483eb37ac6e0034”,“poolName”:“0x5553582d46524158425000000000000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0xe184f7e575a5beb8f2409e8e2218cd770ddda2a6”,“typeOfAsset”:2,“targetAddress”:“0x5847f8177221268d279cf377d0e01ab3fd993628”,“basePoolAddress”:“0xf6c2e0adc659007ba7c48446f5a4e4e94dfe08b5”,“isSaddleApproved”:true,“underlyingTokens”:“0xbfd291da8a403daaf7e5e9dc1ec0aceacd4848b9,0x7f5c764cbc14f9669b88837ca1490cca17c31607,0x2e3d870790dc77a83dd1d18184acc7439a53f475”,“metaSwapDepositAddress”:“0xb10ac31a6e613c6fcb5522c19f4bdbcffa94f89d”}	26547428	0xe184f7e575a5beb8f2409e8e2218cd770ddda2a6	2022-09-30T17:32:51.000Z	0x08dd5252c9dd1f94511debb61188444d3c62fac7e48d3b1f243451489754ec4a
0x4e1484607760118ebe2ab07c0c71f1b4d9671e01	false	2	0	{“tokens”:“0x7f5c764cbc14f9669b88837ca1490cca17c31607,0x2e3d870790dc77a83dd1d18184acc7439a53f475”,“lpToken”:“0xf74ebe6e5586275dc4ced78f5dbef31b1efbe7a5”,“poolName”:“0x465241582d555344432d42500000000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0xf6c2e0adc659007ba7c48446f5a4e4e94dfe08b5”,“typeOfAsset”:2,“targetAddress”:“0x5847f8177221268d279cf377d0e01ab3fd993628”,“basePoolAddress”:“0x0000000000000000000000000000000000000000”,“isSaddleApproved”:true,“underlyingTokens”:"",“metaSwapDepositAddress”:“0x0000000000000000000000000000000000000000”}	13333391	0xf6c2e0adc659007ba7c48446f5a4e4e94dfe08b5	2022-06-27T18:39:50.000Z	0xba5c0310bae1e50d8ea7dcb8f4a531921d00467380f6c769e230074c49e75a90
0x4e1484607760118ebe2ab07c0c71f1b4d9671e01	false	3	1	{“tokens”:“0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9,0xf74ebe6e5586275dc4ced78f5dbef31b1efbe7a5”,“lpToken”:“0x205c9b8c1fca803b779b1eb4b887aa0e00fe629f”,“poolName”:“0x4652415842502d53555344000000000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0x250184dddec6d38e28ac12b481c9016867226e9d”,“typeOfAsset”:2,“targetAddress”:“0x250184dddec6d38e28ac12b481c9016867226e9d”,“basePoolAddress”:“0xf6c2e0adc659007ba7c48446f5a4e4e94dfe08b5”,“isSaddleApproved”:true,“underlyingTokens”:“0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9,0x7f5c764cbc14f9669b88837ca1490cca17c31607,0x2e3d870790dc77a83dd1d18184acc7439a53f475”,“metaSwapDepositAddress”:“0xdf815ea6b066ac9f3107d8863a6c19aa2a5d24d3”}	13333391	0x250184dddec6d38e28ac12b481c9016867226e9d	2022-06-27T18:39:50.000Z	0xba5c0310bae1e50d8ea7dcb8f4a531921d00467380f6c769e230074c49e75a90

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.saddlefinance_v1_optimism.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	in_boughtId	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0x5847f8177221268d279cf377d0e01ab3fd993628	false	0xa6baa075fb5cf4721b43fe068ee81b56f34fa06d	0	6	1	3632786	3858487584429813113624	2022-02-17T08:35:38.000Z	3855578151	0xcd658b0eb996dc850a3b138ca587cbc2056a0486af865d0c5ed3e022a27f1452
0x5847f8177221268d279cf377d0e01ab3fd993628	false	0xa6baa075fb5cf4721b43fe068ee81b56f34fa06d	2	16	0	3631472	1983831702	2022-02-17T08:10:33.000Z	1985524063668526269412	0xb72e90583e3a1ff4b38bc7a5264bc831aa60932f8a7996a8543a74bea5168b80
0x5847f8177221268d279cf377d0e01ab3fd993628	false	0xa6baa075fb5cf4721b43fe068ee81b56f34fa06d	1	10	2	3625845	1098360608	2022-02-17T04:03:11.000Z	1097945353	0x62026ef5272258cc810b6e76c822d1b13c6aa5782e6b2f515a5415d6b21714ed

Example Query

Query with partition filter

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