Reflector Prices Data FEX Snapshot - Stellar Developer Docs

Table Metadata

Property	Configuration
Natural Key(s)	asset_code, valid_from
Partition Field(s)	N/A
Clustered Field(s)	asset_code
Documentation	dbt docs

This table captures historical snapshots of the exchange price of fiat currencies (foreign exchange). 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		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