> ## Documentation Index
> Fetch the complete documentation index at: https://developers.stellar.org/llms.txt
> Use this file to discover all available pages before exploring further.

# History Assets

> Reference documentation for the History Assets table in Hubble's Bronze data dictionary.

## Table Metadata

| Property | Configuration |
| - | - |
| Natural Key(s) | asset\_code, asset\_issuer, asset\_type |
| Partition Field(s) | batch\_run\_date (MONTH partition) |
| Clustered Field(s) | asset\_code, asset\_issuer, asset\_type |
| Documentation | [dbt\_docs](http://www.stellar-dbt-docs.com/#!/source/source.stellar_dbt_public.crypto_stellar.history_assets_staging) |

## Column Details

| Name | Description | Data Type | Domain Values | Required? | Notes |
| - | - | - | - | - | - |
| asset\_id | Unique identifier for asset\_code, asset\_issuer | integer | | No | |
| asset\_type | The identifier for type of asset code, can be a alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM. | string | <ul><li>credit\_alphanum4</li><li>credit\_alphanum12</li><li>native</li></ul> | Yes | XLM is the native asset to the network. XLM has no asset code or issuer representation and will instead be displayed with an asset type of 'native' |
| asset\_code | The 4 or 12 character code representation of the asset on the network | string | | No | Asset codes have no guarantees of uniqueness. The combination of asset code, issuer and type represents a distinct asset |
| asset\_issuer | The account address of the original asset issuer that created the asset | string | | No | |
| batch\_id | String representation of the run id for a given DAG in Airflow. Takes the form of `scheduled__<batch_end_date>-<dag_alias>`. Batch ids are unique to the batch and help with monitoring and rerun capabilities | string | | Yes | |
| batch\_run\_date | The start date for the batch interval. When taken with the date in the batch\_id, the date represents the interval of ledgers processed. The batch run date can be seen as a proxy of closed\_at for a ledger. | datetime | | Yes | The table is partitioned on batch\_run\_date. It is recommended to always include the batch\_run\_date in the filter if possible to help reduce query cost. |
| batch\_insert\_ts | The timestamp in UTC when a batch of records was inserted into the database. This field can help identify if a batch executed in real time or as part of a backfill | timestamp | | Yes | |
| ledger\_sequence | The sequence number of the ledger in which this asset was first seen. | integer | | Yes | |
| closed\_at | Timestamp in UTC when the ledger in which this asset was first seen closed and committed to the network. Ledgers are expected to close \~every 5 seconds. | timestamp | | Yes | |