sei.defi Table: fact_dex_swaps Type: View
Deprecating soon!Records swap transactions on Sei for Astroport, Fuzio, and Seaswap. Note: this only
contains swaps from native sei protocols.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| PLATFORM | TEXT | |
| BLOCK_ID | NUMBER | The block height the block was recorded at. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| TX_SUCCEEDED | BOOLEAN | Transaction status is TRUE if the transaction was successful, FALSE if the transaction failed. |
| TX_ID | TEXT | A unique key that identifies a transaction. Called “TxHash” on block explorers. |
| SWAPPER | TEXT | The wallet address of the individual who initiated the swap. |
| MSG_GROUP | NUMBER | Value grouping different messages together to represent a single action. Format will include the numeric msg_group and msg_sub_group with a ”:” seperator. The subgroup will always be 0 except for “Exec” actions. NULL group means messages are related to the header (overall transaction) |
| MSG_SUB_GROUP | NUMBER | Silver only — Numeric value grouping different messages together to represent a single action within a group. This is relevent for exec actions that contain mutiple underlying actions. NULL sub group means messages are related to the header (overall transaction) |
| MSG_INDEX | NUMBER | Short for “message index,” the position in which messages occur in a transaction. |
| AMOUNT_IN | NUMBER | The amount that was sent into the swap transaction. |
| CURRENCY_IN | TEXT | The currency that was sent into the swap transaction. |
| AMOUNT_OUT | NUMBER | The amount that was received from the swap transaction. |
| CURRENCY_OUT | TEXT | |
| POOL_ADDRESS | TEXT | Address of the pool |
| POOL_NAME | TEXT | The name of the pool |
| _INSERTED_TIMESTAMP | TIMESTAMP_LTZ | |
| FACT_DEX_SWAPS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |