eclipse.core Table: fact_transfers Type: Base Table
Contains transfer events for Eclipse and spl-tokens.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_ID | NUMBER | Slot for which a block can be created. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| TX_ID | TEXT | A unique key that identifies a transaction |
| SUCCEEDED | BOOLEAN | True when a transaction is successful, otherwise false. |
| INDEX | NUMBER | Location of the instruction (event) within a transaction |
| INNER_INDEX | NUMBER | Location of the instruction within an instruction’s (event) inner instruction |
| PROGRAM_ID | TEXT | An address that identifies the program that is being interacted with. I.E. which DEX for a swap or marketplace for an NFT sale. |
| TX_FROM | TEXT | The wallet address that initiated an event |
| TX_TO | TEXT | The wallet address that receives tokens in an event |
| MINT | TEXT | Address of the token or NFT |
| AMOUNT | VARIANT | The non-decimal adjusted number of tokens sent during an event |
| DECIMAL | VARIANT | Number of decimals in the token value, need to divide amount by 10^decimal |
| SOURCE_TOKEN_ACCOUNT | TEXT | |
| DEST_TOKEN_ACCOUNT | TEXT | |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| FACT_TRANSFERS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which the record was initially created and inserted into this table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which this record was last modified by an internal process. |