Skip to main content
Schema: sui.price Table: ez_prices_hourly Type: View

​
Description

This table provides hourly historical token pricing data for Sui blockchain assets in USD. It includes both actual market prices and imputed prices (when direct pricing is unavailable), enabling comprehensive time-series price analysis and USD value calculations across all token activities.

​
Key Use Cases

  • Historical price lookups for USD value calculations
  • Time-series price analysis and charting
  • Portfolio valuation and historical balance calculations
  • Price trend analysis and volatility tracking
  • Enriching transaction and transfer data with USD values
  • Market analysis and price correlation studies

​
Important Relationships

  • Referenced by defi.ez_dex_swaps for swap USD value calculations
  • Referenced by core.ez_transfers for transfer USD value enrichment
  • Referenced by defi.ez_bridge_activity for bridge volume USD calculations
  • Provides price context for all value-based analytics

​
Commonly-used Fields

  • hour: Timestamp for hourly price buckets
  • token_address: Token identifier for joins
  • symbol: User-friendly token symbol
  • price: USD price per token unit
  • is_imputed: Flag indicating if price is estimated vs. actual
  • blockchain: Always “sui” for this schema

​
Columns

Column NameData TypeDescription
HOURTIMESTAMP_NTZThe hourly timestamp representing the start of the hour for this price record.
Data type: Timestamp Example:
  • 2024-01-15 14:00:00
  • 2024-01-15 15:00:00
Business Context:
  • Primary temporal dimension for price lookups and joins.
  • Essential for time-series analysis and historical price tracking.
  • Enables hourly aggregation and trend analysis. | | TOKEN_ADDRESS | TEXT | The full Move type identifier for the token.
Data type: String Example:
  • 0x2::sui::SUI
  • 0x5d4b302506645c37ff133b98c4b50a5ae14841659738d6d733d59d0d217a93bf::coin::COIN
Business Context:
  • Primary identifier for token price lookups and joins.
  • Essential for linking prices to token activity.
  • Enables token-specific price analysis. | | SYMBOL | TEXT | The token symbol for user-friendly identification.
Data type: String Example:
  • SUI
  • USDC
  • CETUS
Business Context:
  • Used for user-friendly displays and filtering.
  • Enables symbol-based price lookups.
  • Supports human-readable reporting. | | PRICE | FLOAT | The price of the token in USD at this hour.
Data type: Decimal Example:
  • 1.50 (token worth $1.50)
  • 0.99 (stablecoin near $1)
  • 0.0001234 (low-value token)
Business Context:
  • Primary price metric for USD value calculations.
  • Essential for portfolio valuation and financial analysis.
  • Critical for converting token amounts to USD values. | | IS_IMPUTED | BOOLEAN | Flag indicating whether this price is imputed (estimated) rather than directly observed.
Data type: Boolean Example:
  • false (actual market price)
  • true (estimated/imputed price)
Business Context:
  • Essential for understanding price data quality and reliability.
  • Critical for filtering high-confidence vs. estimated prices.
  • Enables data quality tracking and validation. | | BLOCKCHAIN | TEXT | The blockchain identifier, always “sui” for this schema.
Data type: String Example:
  • sui
Business Context:
  • Ensures consistency in cross-chain datasets.
  • Used for filtering in multi-blockchain queries.
  • Supports cross-chain price analytics. | | EZ_PRICES_HOURLY_ID | TEXT | Unique primary key identifier for each row.
Data type: String Example:
  • 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef
Business Context:
  • Essential for data integrity.
  • Critical for join operations.
  • Enables precise data retrieval. | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the row was inserted.
Data type: Timestamp Example:
  • 2024-01-15 14:30:25.123456
Business Context:
  • Essential for data lineage tracking.
  • Critical for data freshness monitoring.
  • Enables pipeline performance analysis. | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the row was last modified.
Data type: Timestamp Example:
  • 2024-01-15 14:30:25.123456
Business Context:
  • Essential for update tracking.
  • Critical for data quality monitoring.
  • Enables change detection. |