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.Columns
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_tokenIn | STRING | Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string. |
in_tokenOut | STRING | Contract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string. |
in_amountIn | STRING | Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination. |
in_amountOut | STRING | Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination. |
in_from | STRING | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| in_to | address | in_from | removed | log_index | in_tokenIn | in_amountIn | in_tokenOut | block_number | in_amountOut | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xcf5540fffcdc3d510b18bfca6d2b9987b0772559 | 0x00253582b2a3fe112feec532221d9708c64cefab | 0x7e15eb462cdc67cf92af1f7102465a8f8c784874 | false | 112 | 0x1abaea1f7c830bd89acc67ec4af516284b1bc33c | 50000000000 | 0x1a7e4e63778b4f12a199c062f3efdd288afcbce8 | 18220491 | 49950049950049950049950 | 2023-09-26T14:17:23.000Z | 0xfcbf4154d0f5f5dd5ad118e60881b51508c72b36528fe498a5ca0943392a8755 |
| 0x1c073d5045b1abb6924d5f0f8b2f667b1653a4c3 | 0x00253582b2a3fe112feec532221d9708c64cefab | 0x1c073d5045b1abb6924d5f0f8b2f667b1653a4c3 | false | 7 | 0x1abaea1f7c830bd89acc67ec4af516284b1bc33c | 30299064193 | 0x1a7e4e63778b4f12a199c062f3efdd288afcbce8 | 18405517 | 30276921794936821475775 | 2023-10-22T11:23:35.000Z | 0xb3e91c5ce747f8ff73a6c6358f724dcbfd22feb7c491f88ffc3ceb6ae78746b8 |
| 0x7b5caaf06f5b0638ec5093ba2a58ac5444a2fe79 | 0x00253582b2a3fe112feec532221d9708c64cefab | 0x7b5caaf06f5b0638ec5093ba2a58ac5444a2fe79 | false | 421 | 0x1abaea1f7c830bd89acc67ec4af516284b1bc33c | 100000 | 0x1a7e4e63778b4f12a199c062f3efdd288afcbce8 | 18012837 | 99852996864118272 | 2023-08-28T11:26:23.000Z | 0x9fa7d27b26610b766b387fcb2c0b9cc622dadea291a43947d824b53dc77f98b3 |
Example Query
Example Query
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