Reflector Prices Data SDEX Snapshot
Table Metadata​
| Property | Configuration |
|---|---|
| Natural Key(s) | asset_contract_id, valid_from |
| Partition Field(s) | N/A |
| Clustered Field(s) | asset_contract_id |
| Documentation | dbt docs |
This table captures historical snapshots of the exchange price of assets minted on the Stellar network. Prices originate from the Reflector oracle contracts on Stellar. The valid_from and valid_to timestamps identify when each record was active.
Column Details​
| Name | Description | Data Type | Domain Values | Required? | Notes |
|---|---|---|---|---|---|
| day | The day when the asset price is valid. | DATE | Yes | ||
| 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 | ||
| 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 |
| No | 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_contract_id | Contract id of the SAC or contract token. | STRING | Yes | Natural Key. Cluster Field. | |
| open_usd | Price of the asset in USD at the start of the day. | FLOAT | Yes | ||
| high_usd | Highest price of the asset in USD during the day. | FLOAT | Yes | ||
| low_usd | Lowest price of the asset in USD during the day. | FLOAT | Yes | ||
| close_usd | Price of the asset in USD at the end of the day. | FLOAT | Yes | ||
| valid_from | The timestamp when this snapshot row was first inserted and became effective. This helps in tracking changes over time. | TIMESTAMP | Yes | Natural Key. | |
| valid_to | The timestamp when this row is no longer valid. If null, the record is currently active. | TIMESTAMP | No |