> ## 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.

# Offers

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

## Table Metadata

| Property | Configuration |
| - | - |
| Natural Key(s) | offer\_id, closed\_at |
| Partition Field(s) | batch\_run\_date (MONTH partition) |
| Clustered Field(s) | selling\_asset\_id, buying\_asset\_id, last\_modified\_ledger |
| Documentation | [dbt docs](http://www.stellar-dbt-docs.com/#!/source/source.stellar_dbt_public.crypto_stellar.offers) |

## Column Details

| Name | Description | Data Type | Domain Values | Required? | Notes |
| - | - | - | - | - | - |
| seller\_id | The account address that is making this offer | string | | Yes | |
| offer\_id | The unique identifier for this offer | integer | | Yes | |
| selling\_asset\_type | The identifier for type of asset code, can be an 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 | |
| selling\_asset\_code | The 4 or 12 character code representation of the asset offered to be sold | string | | No | |
| selling\_asset\_issuer | The account address of the original asset issuer that minted the asset which will be sold in exchange for another asset | string | | No | |
| buying\_asset\_type | The identifier for type of asset code, can be an 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 | |
| buying\_asset\_code | The 4 or 12 character code representation of the asset desired to be purchased | string | | No | |
| buying\_asset\_issuer | The account address of the original asset issuer that minted the asset which will be bought in exchange for a currently held asset | string | | No | |
| amount | The amount of selling that the account making this offer is willing to sell | float | | Yes | |
| pricen | The numerator of the precise representation of the buy and sell price of assets on offer (The buy amount desired) | integer | | Yes | If an offer wants to sell 10 XLM in exchange for 1 USD, the numerator will be 1. |
| priced | The denominator of the precise representation of the buy and sell price of assets on offer (The sell amount offered) | integer | | Yes | If an offer wants to sell 10 XLM in exchange for 1 USD, the denominator will be 10. |
| price | How many units of buying it takes to get 1 unit of selling. This number is the decimal form of pricen / priced | float | | Yes | If an offer wants to sell 10 XLM in exchange for 1 USD, the price will be 0.1 |
| flags | Denotes the enabling/disabling of certain asset issuer privileges | integer | <ul><li>0 - None, Default</li><li>1 - Passive (offer with this flag will not act on and take a reverse offer of equal price)</li></ul> | Yes | |
| last\_modified\_ledger | The ledger sequence number when the ledger entry (this unique signer for the account) was modified. Deletions do not count as a modification and will report the prior modification sequence number | integer | | Yes | |
| ledger\_entry\_change | Code that describes the ledger entry change type that was applied to the ledger entry. | integer | <ul><li>0 - Ledger Entry Created</li><li>1 - Ledger Entry Updated</li><li>2 - Ledger Entry Deleted</li><li>3 - Ledger Entry State (value of the entry)</li></ul> | Yes | Valid entry change types are 0, 1, and 2 for ledger entries of type `offers`. |
| deleted | Indicates whether the ledger entry (offer id) has been deleted or not. Once an entry is deleted, it cannot be recovered | boolean | | Yes | |
| closed\_at | Timestamp in UTC when this ledger closed and committed to the network. Ledgers are expected to close \~every 5 seconds | timestamp | | Yes | |
| ledger\_sequence | The sequence number of this ledger. It represents the order of the ledger within the Stellar blockchain. Each ledger has a unique sequence number that increments with every new ledger, ensuring that ledgers are processed in the correct order. | integer | | Yes | |
| sponsor | The account address that is sponsoring the base reserves for the offer | 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 | |
| selling\_asset\_id | Unique identifier for selling\_asset\_code, selling\_asset\_issuer | integer | | No | |
| buying\_asset\_id | Unique identifier for buying\_asset\_code, buying\_asset\_issuer | integer | | No | |