Skip to main content
Schema: 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 NameData TypeDescription
ASSET_IDNUMBERThe 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_TYPETEXTThe identifier for type of asset code, can be an alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM.
ASSET_CODETEXTThe 4 or 12 character code representation of the asset on the network.
ASSET_ISSUERTEXTThe account address of the original asset issuer that created the asset.
IDFLOATNumeric hash of asset_id, asset_type, and asset_issuer for join operations
DIM_ASSETS_IDTEXTUnique primary key for the dimension table, used as the main identifier for each record.
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when this record was inserted.
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when this record was last modified.