ez_perp_candles

hypercore.core.ez_perp_candles

Schema: hypercore.core Table: ez_perp_candles Type: View

What

OHLCV (Open, High, Low, Close, Volume) candlestick data for perpetual markets, enriched with market metadata. Candle data is collected via the Streamline REST API.

Key Use Cases

• Building price charts and technical analysis
• Calculating volatility metrics
• Tracking volume trends by market
• Identifying price patterns and breakouts
• Comparing trading activity across time intervals

Important Relationships

• Derived from silver__candles via Streamline API
• Enriched with core__dim_perp_markets via coin
• Complements core__ez_perp_asset_snapshots for different market views

Commonly-used Fields

• coin: Perp asset identifier
• candle_interval: Time interval (e.g. 1h)
• open_time / close_time: Candle time boundaries
• open_price / close_price / high_price / low_price: OHLC prices
• volume: Trading volume in base asset
• trade_count: Number of trades in interval

Columns

Column Name	Data Type	Description
COIN	TEXT	Raw asset identifier. Perps use plain ticker (e.g. BTC), spot uses @token_index format (e.g. @2), prelaunch uses xyz:name prefix.
ASSET_INDEX	NUMBER	Numeric index for the asset on the Hyperliquid exchange.
SIZE_DECIMALS	NUMBER	Decimal precision for order sizes on this market.
MAX_LEVERAGE	NUMBER	Maximum allowed leverage for this perpetual market.
CANDLE_INTERVAL	TEXT	Time interval for the candlestick (e.g. 1h).
OPEN_TIME	TIMESTAMP_NTZ	Timestamp when the candle period opened.
CLOSE_TIME	TIMESTAMP_NTZ	Timestamp when the candle period closed.
OPEN_PRICE	FLOAT	Price at the start of the candle period.
CLOSE_PRICE	FLOAT	Price at the end of the candle period.
HIGH_PRICE	FLOAT	Highest price during the candle period.
LOW_PRICE	FLOAT	Lowest price during the candle period.
VOLUME	FLOAT	Trading volume in base asset units during the candle period.
TRADE_COUNT	NUMBER	Number of trades executed during the candle period.
INSERTED_TIMESTAMP	TIMESTAMP_NTZ	Timestamp when the record was inserted into this table (Snowflake SYSDATE).
MODIFIED_TIMESTAMP	TIMESTAMP_NTZ	Timestamp when the record was last modified in this table (Snowflake SYSDATE).
EZ_PERP_CANDLES_ID	TEXT	Surrogate key for candle records
_INVOCATION_ID	TEXT	dbt invocation identifier for tracking which run produced this record.