Token Prices Hourly - Allium Documentation Hub

Thedex.token_prices_hourly table contains hourly price data of tokens computed from the dex.trades table. This table also provides metrics for the swap volumes, traders and trade counts of assets swapped onchain at the hourly basis.

Table Details

Property	Value
Table Name	`hyperevm.dex.token_prices_hourly`
Table Status	Production-Ready
Unique Key	`timestamp`, `address`
Clustering Key(s)	`timestamp::date`

Table Columns

Column Name	Data Type	Description
chain	VARCHAR(16777216)	Blockchain network (e.g., ‘ethereum’, ‘arbitrum’)
timestamp	TIMESTAMP_NTZ(9)	Start of the hourly period
address	VARCHAR(42)	Token contract address
symbol	VARCHAR(16777216)	Token symbol
name	VARCHAR(16777216)	Token name
decimals	NUMBER(38,0)	Number of decimal places for the token
price	FLOAT	Volume-weighted average price for the hour
median_price	FLOAT	Median price from all trades in the hour
median_safe_price	FLOAT	Filtered median price by filtering swaps > 100 usd in volume
usd_trading_volume	FLOAT	Total USD volume traded in the hour
traders	NUMBER(38,0)	Number of distinct traders that swapped the token for the hour by counting distinct `transaction_from_address.`
trade_count	NUMBER(38,0)	Total number of swaps executed
_created_at	TIMESTAMP_NTZ(9)	Timestamp of entry creation
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of entry update

EVM DEX Token Prices Hourly

Token Prices 5Min Trades

⌘I