Token Prices Hourly

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

Swaps above USD volume > 1 USD are included in the price calculation.
For a given token, the sum of the total USD swap volume (both sold/bought volume) was divided by the sum of the total volume of the token swapped in DEX trades.
If token A had 200,000 USD volume in swaps and the total volume of token A swapped was 18,000 for a given hour, the price calculated will be:

price = sum(usd_volume)/sum(token_volume) 
11.111 USD = 200,000/18,000
where price = 11.111 USD and the usd_trading_volume = 200,000

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