Token Prices Hourly

Hourly token prices by symbol.

Centralized Exchange (CEX) Token Prices

common.prices.token_prices_hourly &common.prices.token_prices_hourly_latest contains the hourly prices from Centralized Exchanges.

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.

Note that can be multiple quote asset for the same base asset within the same exchange and across different exchange.

For one Base Asset there can be multiple quote asset.

Price Sources

Price sources included in this table.

Active	Inactive
coinbasepro, binance, binance_us	FTX (last timestamp 2022-11-11 23:00)

Sample Query

Avg hourly ETH usd price across Centralized Exchanges in the last 24 hours

select 
    timestamp, 
    base_asset_symbol, 
    avg(price) as avg_usd_price,
    listagg(distinct source, ', ') as price_sources,
    listagg(distinct symbol, ', ') as price_symbols
from common.prices.token_prices_hourly
where 1=1 
    and base_asset_symbol = 'ETH' 
    and quote_asset_symbol in ('USD', 'USDT', 'USDC')
and timestamp >= current_timestamp - interval '24 hours'
group by all
order by timestamp desc 

Table Columns

Column Name	Descriptipn	Example
timestamp	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