saddlefinance_v1_ethereum

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	in_soldId	log_index	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0x3911f80530595fbd01ab1516ab61255d75aeb066	false	0x22f9dcf4647084d6c31b2765f6910cd85c178c18	1	381	12491768	80601657198	2021-05-23T16:51:08.000Z	80513624590837105434700	0x8f27bfe6c4e37b30bdd38f0d41b93001dce38769bd2eed9d9c291d367551359d
0x3911f80530595fbd01ab1516ab61255d75aeb066	false	0x22f9dcf4647084d6c31b2765f6910cd85c178c18	2	314	12489978	110501537034	2021-05-23T10:18:53.000Z	110405782807775043298987	0xb2d9675b6098fbfb6f87f2b111f359d31c58ae97bd8b9a61a92532789557a57d
0x3911f80530595fbd01ab1516ab61255d75aeb066	false	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	1	137	12491211	53182946108	2021-05-23T14:54:53.000Z	53090739823914527189538	0xebe3e506275b1d505cedeb76524d5d848ad214a0db9068e12ff55d709ce74ad7

Example Query

Query with partition filter

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

MetaSwap_TokenSwapUnderlying_event

Token swap events from Saddle Finance MetaSwap pools on Ethereum, tracking trades between underlying assets in metapools with sold/bought token IDs, amounts, and buyer addresses. Used for analyzing liquidity pool trading activity and price impact across paired stablecoin or pegged asset 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
0x0c8bae14c9f9bf2c953997c881befac7729fd314	false	0x1e35ebf875f8a2185edf22da02e7dbca0f5558ab	2	106	0	13242560	9972819	2021-09-17T10:02:48.000Z	9959670256459082457	0x7e6eb3f1e8e21443aee78a195be84a9c949e07977766cf2d5266b57834936960
0x0c8bae14c9f9bf2c953997c881befac7729fd314	false	0x1e35ebf875f8a2185edf22da02e7dbca0f5558ab	1	85	0	13245426	100000000000000000000	2021-09-17T20:31:01.000Z	99932045901527146399	0x311bd8c97d3364650973f8c606d225bb52f9171e5ea5516adcf9b6e7394867f0
0x0c8bae14c9f9bf2c953997c881befac7729fd314	false	0x1e35ebf875f8a2185edf22da02e7dbca0f5558ab	0	178	1	13241450	115775144382707954625	2021-09-17T05:46:29.000Z	115720123516642880125	0x4df1f39f754850faec4f74400d1017db0e28f0d667f5d8b269688ec5808111a1

Example Query

Query with partition filter

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

Minter_Minted_event

Token minting events from Saddle Finance liquidity gauge reward system on Ethereum. Records gauge reward token distributions to recipients with minted amounts and associated gauge addresses.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_minted`	`STRING`	Amount of tokens minted and issued to the user. String-encoded integer value representing the quantity in the smallest unit of the token.

Sample Data

address	removed	in_gauge	in_minted	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x358fe82370a1b9adae2e3ad69d6cf9e503c96018	false	0x44f38ee9df2a051477da758eafadbfd5731bba82	393495102545078056070681	256	17241730	0x44f38ee9df2a051477da758eafadbfd5731bba82	2023-05-12T04:19:23.000Z	0x89c712241b9781069fa47860876ee2d387e9f8eb22673aae0aba9ef298352a5d
0x358fe82370a1b9adae2e3ad69d6cf9e503c96018	false	0x69dcbef8c34e41684d3c6d44464f394846c03728	785310363738149129642137	484	17241731	0x69dcbef8c34e41684d3c6d44464f394846c03728	2023-05-12T04:19:35.000Z	0x1e60315083011b7463942e51d4a48e88127cc5b35bf7f5f5c4851a30ba549e9f
0x358fe82370a1b9adae2e3ad69d6cf9e503c96018	false	0x342c6d31494ece56d9cabd783ab004593eea1961	2707387878556280903766285	432	17241727	0x342c6d31494ece56d9cabd783ab004593eea1961	2023-05-12T04:18:47.000Z	0xc86ade66d8e8016cb3a6229a1db7de99bb3d9b35e7ef5256f8b3286f5bd7f93a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.saddlefinance_v1_ethereum.Minter_Minted_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
0xfb4de84c4375d7c8577327153de88f58f69eec81	false	23	303	{“tokens”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48,0x0a5e677a6a24b2f1a2bf4f3bffc443231d2fdec8”,“lpToken”:“0x1ae28a6aca177c29b5773e91fbf74afb0b7fe5c9”,“poolName”:“0x555344432d555358000000000000000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0x2bff1b48cc01284416e681b099a0cddca0231d72”,“typeOfAsset”:2,“targetAddress”:“0xc68bf77e33f1df59d8247dd564da4c8c81519db6”,“basePoolAddress”:“0x0000000000000000000000000000000000000000”,“isSaddleApproved”:true,“underlyingTokens”:"",“metaSwapDepositAddress”:“0x0000000000000000000000000000000000000000”}	15103096	0x2bff1b48cc01284416e681b099a0cddca0231d72	2022-07-08T16:48:06.000Z	0xc36c64d11e35550083ed942a7d3bb867d9bac056478ab78f0662e85ca22bad47
0xfb4de84c4375d7c8577327153de88f58f69eec81	false	22	77	{“tokens”:“0xbc6da0fe9ad5f3b0d58160288917aa56653660e9,0x927e6f04609a45b107c789af34ba90ebbf479f7f”,“lpToken”:“0x3cf7b9479a01eeb3bbfc43581fa3bb21cd888e2a”,“poolName”:“0x4652415842502d616c5553440000000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0xfb516cf3710fc6901f2266aaeb8834cf5e4e9558”,“typeOfAsset”:2,“targetAddress”:“0xfb516cf3710fc6901f2266aaeb8834cf5e4e9558”,“basePoolAddress”:“0x13cc34aa8037f722405285ad2c82fe570bfa2bdc”,“isSaddleApproved”:true,“underlyingTokens”:“0xbc6da0fe9ad5f3b0d58160288917aa56653660e9,0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48,0x853d955acef822db058eb8505911ed77f175b99e”,“metaSwapDepositAddress”:“0xe9154791883df07e1328b636bcedfccb80fefa38”}	15072566	0xfb516cf3710fc6901f2266aaeb8834cf5e4e9558	2022-07-03T23:30:11.000Z	0xc3032ac155757966beee3ed272104e7893d16a959ce7d614cd860552fc4d28f8
0xfb4de84c4375d7c8577327153de88f58f69eec81	false	24	135	{“tokens”:“0x0a5e677a6a24b2f1a2bf4f3bffc443231d2fdec8,0x927e6f04609a45b107c789af34ba90ebbf479f7f”,“lpToken”:“0xaad59b28cc76ed4c9f7c83e697e5cc925fb0b920”,“poolName”:“0x4652415842502d55535800000000000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0x1dcb69a2b9148c641a43f731fcee123e2be30bab”,“typeOfAsset”:2,“targetAddress”:“0x1dcb69a2b9148c641a43f731fcee123e2be30bab”,“basePoolAddress”:“0x13cc34aa8037f722405285ad2c82fe570bfa2bdc”,“isSaddleApproved”:true,“underlyingTokens”:“0x0a5e677a6a24b2f1a2bf4f3bffc443231d2fdec8,0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48,0x853d955acef822db058eb8505911ed77f175b99e”,“metaSwapDepositAddress”:“0x4f0e41a37ce2ff1fa654cc93eb03f9d16e65fd11”}	15238955	0x1dcb69a2b9148c641a43f731fcee123e2be30bab	2022-07-29T18:16:44.000Z	0x29d308e844ebec95b367de796c5aee5f217fbedfe1b3a4c855834bb35ac7b44e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.saddlefinance_v1_ethereum.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
0xdec2157831d6abc3ec328291119cc91b337272b5	false	0x342f8c90b261675f3e20c94a1ebcab3c3f7c493b	0	75	1	12281852	10000000000000000000	2021-04-21T06:03:44.000Z	10479238225571664362	0x2364f19612d3a96831458d1c521926bf2d0cb5f0d9f3d5747edd1efcd5c998b8
0xdec2157831d6abc3ec328291119cc91b337272b5	false	0x36bdc2abfb856d4b1831c31233e76303fdac897f	0	159	1	12283036	5000000000000000000	2021-04-21T10:28:37.000Z	5250660122547374221	0x38a723111842ccd4b0369a2649a84a99022d6da3b94dcf380f03b9332e2c5d5b
0x4f6a43ad7cba042606decaca730d4ce0a57ac62e	false	0x78a55b9b3bbeffb36a43d9905f654d2769dc55e8	1	189	0	12283996	49948478	2021-04-21T14:05:02.000Z	494023630246435076	0x35ecc0e59aafd4d7eeba1fa346824cbbb35db24a04e544afd228fa20e26d89b7

Example Query

Query with partition filter

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

SwapUtils_TokenSwap_event

Token swap events from Saddle Finance stablecoin pools on Ethereum, recording trades between pool assets with token IDs, amounts exchanged, and buyer addresses. Used for analyzing liquidity pool trading volume, swap rates, and user activity across Saddle’s automated market maker 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	log_index	in_boughtId	block_number	in_tokensSold	block_timestamp	in_tokensBought	transaction_hash
0x4f6a43ad7cba042606decaca730d4ce0a57ac62e	false	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	265	1	12725780	3998000000000000000	2021-06-29T00:29:29.000Z	404455768	0xf10aa95fc754d0eaf4659767dbea642a810bbb655a39db746507fe6dd20c3fb8
0xc69ddcd4dfef25d8a793241834d4cc4b3668ead6	false	0x1c073d5045b1abb6924d5f0f8b2f667b1653a4c3	8	3	12726076	8001853605817241892360	2021-06-29T01:36:58.000Z	7944875434547557424257	0x7861d19f79786babc31b71eeea57afcca8af442a3e88cb580de08f5dc3a2ef80
0x3911f80530595fbd01ab1516ab61255d75aeb066	false	0x89bd2afd044bb59eb0d436fa502ef732cf3e4c68	25	2	12731245	250000000000000000000000	2021-06-29T21:08:24.000Z	250151876897	0x2b6b8443ba86f06fd9c677d87f319c9442f17974d619620008abb87e3ba2a83a

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

MetaSwap_TokenSwap_event

MetaSwap_TokenSwapUnderlying_event

Minter_Minted_event

PoolRegistry_AddPool_event

SwapFlashLoan_TokenSwap_event

SwapUtils_TokenSwap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​MetaSwap_TokenSwap_event

​MetaSwap_TokenSwapUnderlying_event

​Minter_Minted_event

​PoolRegistry_AddPool_event

​SwapFlashLoan_TokenSwap_event

​SwapUtils_TokenSwap_event

Tables

MetaSwap_TokenSwap_event

MetaSwap_TokenSwapUnderlying_event

Minter_Minted_event

PoolRegistry_AddPool_event

SwapFlashLoan_TokenSwap_event

SwapUtils_TokenSwap_event