prices

Tables

prices_end_of_day

Daily closing prices in USD for tokens across multiple blockchain networks. Used for historical price analysis, portfolio valuation, and time-series comparisons of token performance.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Timestamp representing the end of the pricing period for the token. All sample values show midnight UTC (00:00:00), indicating daily snapshot times aligned to the timestamp_grain.
`timestamp_grain`	`STRING`	Granularity of the price snapshot, indicating the time interval at which prices are aggregated. All rows in this table use ‘day’ for end-of-day pricing.
`chain`	`STRING`	Blockchain network identifier where the data originates. Lowercase string naming the specific blockchain network.
`token_address`	`STRING`	Contract address or module identifier of the token on the specified chain. For Aptos, uses the module format `address::module::type`; for EVM chains, uses hex-encoded 0x-prefixed addresses.
`price_usd`	`FLOAT64`	Token price denominated in United States dollars at the timestamp specified. Represents the market value at the daily close based on the timestamp_grain.

Sample Data

chain	price_usd	timestamp	token_address	timestamp_grain
aptos	0.000029422505927217045	2025-03-24T00:00:00.000Z	0x1fccdef89b13d4697064d4eff89d26547f2b08d194b495973642729503a7f38f::RBT::RBT	day
aptos	0.000031418972056330546	2025-03-01T00:00:00.000Z	0x1fccdef89b13d4697064d4eff89d26547f2b08d194b495973642729503a7f38f::RBT::RBT	day
aptos	0.000026226518556790717	2025-03-11T00:00:00.000Z	0x1fccdef89b13d4697064d4eff89d26547f2b08d194b495973642729503a7f38f::RBT::RBT	day

Example Query

Query with partition filter

SELECT *
FROM `tt-primitives.prices.prices_end_of_day`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)
LIMIT 100

prices_per_day

Daily USD price snapshots for tokens across blockchains, indexed by contract address and chain. Used for historical price analysis, portfolio valuation, and calculating trading returns over time.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	UTC timestamp representing the start of the day for which the token price is recorded. All sample values show midnight (00:00:00) timestamps, indicating daily price snapshots aggregated at day-level granularity.
`timestamp_grain`	`STRING`	Specifies the time aggregation level for the price data point. Always set to “day” indicating daily price snapshots at 00:00:00 UTC.
`chain`	`STRING`	Blockchain network identifier where the data originates. Lowercase string naming the specific blockchain network.
`token_address`	`STRING`	Contract address of the token being priced on the specified chain. Hex-encoded, 0x-prefixed 40-character string for EVM chains like Ethereum.
`price_usd`	`FLOAT64`	Daily closing price of the token denominated in US dollars. Values typically reflect end-of-day snapshots and may vary slightly around stable price points due to market fluctuations.

Sample Data

chain	price_usd	timestamp	token_address	timestamp_grain
ethereum	1.008098252156842	2019-04-22T00:00:00.000Z	0x3afdc9bca9213a35503b077a6072f3d0d5ab0840	day
ethereum	1.0050138359430159	2019-04-15T00:00:00.000Z	0x3afdc9bca9213a35503b077a6072f3d0d5ab0840	day
ethereum	0.9972353851680991	2019-04-07T00:00:00.000Z	0x3afdc9bca9213a35503b077a6072f3d0d5ab0840	day

Example Query

Query with partition filter

SELECT *
FROM `tt-primitives.prices.prices_per_day`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)
LIMIT 100

prices_per_hour

Hourly USD price snapshots for tokens across multiple blockchain networks, identified by chain and contract address. Used for historical price analysis, portfolio valuation, and calculating returns over time.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	UTC timestamp marking the start of the hourly price observation period. Aligned to the top of each hour (e.g., 02:00:00, 08:00:00) as indicated by the hour grain.
`timestamp_grain`	`STRING`	Time granularity of the price observation, indicating the aggregation interval for the data point. All records in this table use “hour” granularity, representing hourly price snapshots.
`chain`	`STRING`	Blockchain network identifier where the data originates. Lowercase string naming the specific blockchain network.
`token_address`	`STRING`	Contract address of the token on the specified chain. Hex-encoded, 0x-prefixed 40-character string for EVM chains.
`price_usd`	`FLOAT64`	USD-denominated price of the token at the specified timestamp. Represents the market value per token unit, aggregated at hourly intervals.

Sample Data

chain	price_usd	timestamp	token_address	timestamp_grain
arbitrum	2.867440611968693	2025-01-19T02:00:00.000Z	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	hour
arbitrum	2.6249961088772356	2025-01-21T08:00:00.000Z	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	hour
arbitrum	2.59161125290021	2025-01-24T03:00:00.000Z	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	hour

Example Query

Query with partition filter

SELECT *
FROM `tt-primitives.prices.prices_per_hour`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

prices_end_of_day

prices_per_day

prices_per_hour

Metrics

Primitives

Contracts

Blockchain

​Tables

​prices_end_of_day

​prices_per_day

​prices_per_hour

Tables

prices_end_of_day

prices_per_day

prices_per_hour