stellar.core Table: dim_assets Type: Base Table
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/assets
Columns
| 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 asset_id, asset_type, 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. |