Skip to main content
Schema: monad.price Table: fact_prices_ohlc_hourly Type: Fact Table

What

This table provides hourly OHLC (Open, High, Low, Close) price data for all assets tracked in the price schema. It is designed for time series analysis, volatility studies, and historical price lookups.

Key Use Cases

  • Technical analysis and candlestick chart creation
  • Volatility stud

Columns

Column NameData TypeDescription
ASSET_IDTEXTUnique identifier for the asset from the price provider. …
CLOSETEXTClosing price at the end of the hour in USD. Last recorde…
FACT_PRICES_OHLC_HOURLY_IDTEXTPrimary key - unique identifier for each row ensuring dat…
HIGHTEXTHighest price reached during the hour in USD. Maximum pri…
HOURTIMESTAMP_NTZUTC timestamp truncated to the hour for price recording. …
INSERTED_TIMESTAMPTIMESTAMP_NTZUTC timestamp when the record was first added to the Flip…
LOWTEXTLowest price reached during the hour in USD. Minimum pric…
MODIFIED_TIMESTAMPTIMESTAMP_NTZUTC timestamp of the most recent update to this record.
… | | OPEN | TEXT | Opening price at the start of the hour in USD. First reco… |