Token Prices Hourly Latest

Latest hourly token prices by symbol.

Centralized Exchange (CEX) Token Prices

common.prices.token_prices_hourly_latest contains the latest token prices from Centralized Exchanges.

This table qualifies the prices by the symbol from common.prices.token_prices_hourly

Currently, this table only includes tokens paired with quote asset: USDC, USDT, and USD.

The token price in this table is in reference to the quote asset.

The underlying price in these table reflect the closing price of the asset at the hour.

Sample Query

Latest prices for ETH. Note that this outputs can be more than one row since it qualifies by symbol.

select *
from common.prices.token_prices_hourly_latest
  where base_asset_symbol = 'ETH'

Column Name

Column Name	Descriptipn	Example
timestamp	Latest hourly timestamp of the token price.	2022-12-14T23:00:00
symbol	The currencies pairs that are referenced for price data. The first currency is called the base currency and the second currency is called the quote currency.	ETH/USDC
base_asset_symbol	The base asset is traded against the quote asset.	ETH
quote_asset_symbol	The base asset is traded against the quote asset. Sometimes known as the counter currency.	USDC
price	USD equivalent price of the base_asset_symbol	1308.22
source	The source of the token price.	binance_us