Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_buyerSTRINGAddress of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokensSoldSTRINGQuantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
in_tokensBoughtSTRINGQuantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
in_soldIdSTRINGIndex identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
in_boughtIdSTRINGIndex identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.
addressremovedin_buyerin_soldIdlog_indexin_boughtIdblock_numberin_tokensSoldblock_timestampin_tokensBoughttransaction_hash
0x401afbc31ad2a3bc0ed8960d63efcdea749b4849false0xbefe110c2da80e143bc9b74b6b032b7fcb36a24d0519183717625600000002023-05-18T04:59:52.000Z25584671350980910765860x388f3fd65b8cae7fc1c1fdba95e0134c0bae1b93989772251d02fc7e5ead6b43
0x401afbc31ad2a3bc0ed8960d63efcdea749b4849false0xbefe110c2da80e143bc9b74b6b032b7fcb36a24d12109191807225619187890206602382202023-05-18T10:39:41.000Z25613206630xf8b9a79da306128b4b3670955ebdf3c9f5b24bb4a33635a9b26676e6e4b4ac9c
0x401afbc31ad2a3bc0ed8960d63efcdea749b4849false0xcfedfa1734528a1ad96a5ee999b034623785c6ae11460919936522059324602631643563562023-05-18T15:57:02.000Z2058834540xed254dc065bea1387dfdfcd713591fe47c324184af0e35b008ea829cfdb9df09
Query with partition filter
SELECT *
FROM `tt-contracts.saddlefinance_v1_arbitrum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolAddressSTRINGContract address of the liquidity pool. Hex-encoded, 0x-prefixed, 42-character string.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
in_poolDataSTRUCT<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.
addressremovedin_indexlog_indexin_poolDatablock_numberin_poolAddressblock_timestamptransaction_hash
0x38262c17a06a6b3588d3e5b70dfa768c06bf4ef1false11{“tokens”:“0x17fc002b466eec40dae837fc4be5c67993ddbd6f,0xff970a61a04b1ca14834a43f5de4533ebddb5cc8,0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“lpToken”:“0x0a20c2ffa10cd43f67d06170422505b7d6fc0953”,“poolName”:“0x4172625553445632000000000000000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0xfeea4d1bacb0519e8f952460a70719944fe56ee0”,“typeOfAsset”:2,“targetAddress”:“0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9”,“basePoolAddress”:“0x0000000000000000000000000000000000000000”,“isSaddleApproved”:true,“underlyingTokens”:"",“metaSwapDepositAddress”:“0x0000000000000000000000000000000000000000”}150100660xfeea4d1bacb0519e8f952460a70719944fe56ee02022-06-18T17:02:10.000Z0x85e5cab2a09d54c60d96f77def57124f73641192ee561560a8f62347e80a1d79
0x38262c17a06a6b3588d3e5b70dfa768c06bf4ef1false00{“tokens”:“0x2913e812cf0dcca30fb28e6cac3d2dcff4497688,0xfea7a6a0b346362bf88a9e4a88416b77a57d6c2a,0xff970a61a04b1ca14834a43f5de4533ebddb5cc8,0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“lpToken”:“0xc969dd0a7ab0f8a0c5a69c0839db39b6c928bc08”,“poolName”:“0x4172625553440000000000000000000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9”,“typeOfAsset”:2,“targetAddress”:“0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9”,“basePoolAddress”:“0x0000000000000000000000000000000000000000”,“isSaddleApproved”:true,“underlyingTokens”:"",“metaSwapDepositAddress”:“0x0000000000000000000000000000000000000000”}150100660xbea9f78090bdb9e662d8cb301a00ad09a5b756e92022-06-18T17:02:10.000Z0x85e5cab2a09d54c60d96f77def57124f73641192ee561560a8f62347e80a1d79
0x38262c17a06a6b3588d3e5b70dfa768c06bf4ef1false22{“tokens”:“0xd74f5255d557944cf7dd0e45ff521520002d5748,0x0a20c2ffa10cd43f67d06170422505b7d6fc0953”,“lpToken”:“0xa815b134294580692482e321dd1a191ac1454192”,“poolName”:“0x555344532d417262555344563200000000000000000000000000000000000000”,“isGuarded”:false,“isRemoved”:false,“poolAddress”:“0x5dd186f8809147f96d3ffc4508f3c82694e58c9c”,“typeOfAsset”:2,“targetAddress”:“0x5dd186f8809147f96d3ffc4508f3c82694e58c9c”,“basePoolAddress”:“0xfeea4d1bacb0519e8f952460a70719944fe56ee0”,“isSaddleApproved”:true,“underlyingTokens”:“0xd74f5255d557944cf7dd0e45ff521520002d5748,0x17fc002b466eec40dae837fc4be5c67993ddbd6f,0xff970a61a04b1ca14834a43f5de4533ebddb5cc8,0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“metaSwapDepositAddress”:“0xdca5b16a96f984ffb2a3022cff339eb049126101”}150100660x5dd186f8809147f96d3ffc4508f3c82694e58c9c2022-06-18T17:02:10.000Z0x85e5cab2a09d54c60d96f77def57124f73641192ee561560a8f62347e80a1d79
Query with partition filter
SELECT *
FROM `tt-contracts.saddlefinance_v1_arbitrum.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_buyerSTRINGAddress of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokensSoldSTRINGQuantity of tokens sold in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
in_tokensBoughtSTRINGQuantity of tokens acquired in the swap transaction. Numeric string value representing the raw token amount without decimal adjustment.
in_soldIdSTRINGIndex identifier for the token being sold in the swap. Numeric string value representing the position of the sold token in the swap pool.
in_boughtIdSTRINGIndex identifier for the token being acquired in the swap. Numeric string value representing the position of the purchased token in the swap pool.
addressremovedin_buyerin_soldIdlog_indexin_boughtIdblock_numberin_tokensSoldblock_timestampin_tokensBoughttransaction_hash
0xfeea4d1bacb0519e8f952460a70719944fe56ee0false0x569a11e9c23f6716073aeae549ec69de6356f9b31301289433915922977032022-05-25T02:22:24.000Z15935062865243879953560xe75e5d1d8d22245b3a8fb5ebaf386f1861621b499bb8ad9760a10a2f85829be7
0xbea9f78090bdb9e662d8cb301a00ad09a5b756e9false0x569a11e9c23f6716073aeae549ec69de6356f9b3230129535461871265641892022-05-25T22:00:31.000Z1866320346478353184843340x84f1c335d5da45963810b5bff93f1ae9e538915c33310682b6c7db46588f8e9a
0xfeea4d1bacb0519e8f952460a70719944fe56ee0false0x569a11e9c23f6716073aeae549ec69de6356f9b31301294523614019437332022-05-25T18:02:24.000Z14030093914661239189920x849c8121660546a27661f513203d15d1bb6e14e0054cfef91816fb3ae2612657
Query with partition filter
SELECT *
FROM `tt-contracts.saddlefinance_v1_arbitrum.SwapFlashLoan_TokenSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100