Skip to main content

​
Tables

​
Transmuter_Swap_event

Swap event records from Angle Protocol’s Transmuter contract on Ethereum, capturing token conversions with input/output amounts, token addresses, and sender/recipient information. Used for analyzing stablecoin swap activity and liquidity flows within Angle’s collateral management system.
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_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenOutSTRINGContract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_amountInSTRINGAmount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
in_amountOutSTRINGAmount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toaddressin_fromremovedlog_indexin_tokenInin_amountInin_tokenOutblock_numberin_amountOutblock_timestamptransaction_hash
0xcf5540fffcdc3d510b18bfca6d2b9987b07725590x00253582b2a3fe112feec532221d9708c64cefab0x7e15eb462cdc67cf92af1f7102465a8f8c784874false1120x1abaea1f7c830bd89acc67ec4af516284b1bc33c500000000000x1a7e4e63778b4f12a199c062f3efdd288afcbce818220491499500499500499500499502023-09-26T14:17:23.000Z0xfcbf4154d0f5f5dd5ad118e60881b51508c72b36528fe498a5ca0943392a8755
0x1c073d5045b1abb6924d5f0f8b2f667b1653a4c30x00253582b2a3fe112feec532221d9708c64cefab0x1c073d5045b1abb6924d5f0f8b2f667b1653a4c3false70x1abaea1f7c830bd89acc67ec4af516284b1bc33c302990641930x1a7e4e63778b4f12a199c062f3efdd288afcbce818405517302769217949368214757752023-10-22T11:23:35.000Z0xb3e91c5ce747f8ff73a6c6358f724dcbfd22feb7c491f88ffc3ceb6ae78746b8
0x7b5caaf06f5b0638ec5093ba2a58ac5444a2fe790x00253582b2a3fe112feec532221d9708c64cefab0x7b5caaf06f5b0638ec5093ba2a58ac5444a2fe79false4210x1abaea1f7c830bd89acc67ec4af516284b1bc33c1000000x1a7e4e63778b4f12a199c062f3efdd288afcbce818012837998529968641182722023-08-28T11:26:23.000Z0x9fa7d27b26610b766b387fcb2c0b9cc622dadea291a43947d824b53dc77f98b3
Query with partition filter
SELECT *
FROM `tt-contracts.angle_v2_ethereum.Transmuter_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100