Hourly

Hourly USD prices for tokens on this chain, sourced from Allium’s price hydration pipeline (e.g. CoinGecko and DEX-derived prices).

Column Name	Data Type	Description
chain	VARCHAR(134217728)	The blockchain network name.
id	VARCHAR(134217728)	The unique identifier of the token (e.g., CoinGecko ID).
symbol	VARCHAR(134217728)	The ticker symbol of the token.
address	VARCHAR(134217728)	The contract address of the token.
decimals	NUMBER(38,0)	The number of decimal places for the token.
timestamp	TIMESTAMP_NTZ(9)	The hourly timestamp for the price data point.
price	VARCHAR(134217728)	The token price in USD at the given timestamp.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.