stellar.core Table: dim_assets Type: Base Table
What
Table reports which assets are used during the batch interval, which can help identify periods of time of large activity for an asset. The table does not have a primary key and assets are duplicated in the table as they are used during different periods of time. To get a distinct count of assets on the network, please refer to the history_assets table. Table not widely used. Learn more about Stellar assets: https://developers.stellar.org/docs/learn/fundamentals/stellar-data-structures/assetsColumns
| Column Name | Data Type | Description |
|---|---|---|
| ASSET_ID | NUMBER | The Farm Hash encoding of Asset Code + Asset Issuer + Asset Type. This field is optimized for cross table joins since integer joins are less expensive than the original asset id components. |
| ASSET_TYPE | TEXT | The identifier for type of asset code, can be an alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM. |
| ASSET_CODE | TEXT | The 4 or 12 character code representation of the asset on the network. |
| ASSET_ISSUER | TEXT | The account address of the original asset issuer that created the asset. |
| ID | FLOAT | Numeric hash of assetid, assettype, and asset_issuer for join operations |
| DIM_ASSETS_ID | TEXT | Unique primary key for the dimension table, used as the main identifier for each record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was last modified. |