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

​
What

​
Description

This table provides hourly price data for both native tokens and fungible tokens across multiple blockchain networks. The data combines curated token prices from external APIs like CoinGecko and CoinMarketCap into a unified view. Token addresses are normalized based on blockchain-specific conventions (e.g., IBC tokens and certain blockchains retain original case, while others are converted to lowercase). This table serves as the primary source for cross-chain price analysis and USD value calculations.

​
Key Use Cases

  • Cross-chain price comparison and analysis
  • USD value calculations for token transfers and DeFi transactions
  • Time-series price analysis and trend detection
  • Arbitrage opportunity identification across blockchains
  • Portfolio valuation and performance tracking
  • Bridge activity monitoring and cross-chain flow analysis
  • Token price volatility and market movement analysis

​
Important Relationships

  • Native blockchain assets are flagged by the boolean column is_native and tokens that have been verified by the Flipside team by the boolean column is_verified.
  • Used by ez_token_transfers and other ez_ tables for USD value calculations
  • Supports DeFi analytics through ez_dex_swaps and ez_lending tables
  • Enables cross-chain bridge analysis via ez_bridge_activity tables
  • Provides price context for NFT sales in ez_nft_sales tables

​
Commonly-used Fields

  • hour: Primary field for time-series analysis and trend detection
  • token_address and blockchain: Essential for identifying specific assets across chains
  • price: Critical for USD value calculations and financial analysis
  • symbol and name: Key for asset identification and reporting, however these columns have no uniqueness constraints and should not be used as the only identifier when filtering to a particular token price.
  • is_native: Important for distinguishing between native tokens and contract tokens
  • is_imputed: Critical for data quality assessment and low-liquidity token analysis
  • is_verified: Essential for filtering reliable token data and avoiding scams

​
Columns

Column NameData TypeDescription
HOURTIMESTAMP_NTZHour that the price was recorded at.
TOKEN_ADDRESSTEXTThe specific address representing the asset on a specific platform. This will be NULL if referring to a native asset.
SYMBOLTEXTThe symbol of asset.
NAMETEXTThe name of asset.
DECIMALSNUMBERThe number of decimals for the asset. May be NULL.
PRICEFLOATClosing price of the recorded hour in USD.
BLOCKCHAINTEXTThe Blockchain, Network, or Platform for this asset.
IS_NATIVEBOOLEANA flag indicating assets native to the respective blockchain.
IS_IMPUTEDBOOLEANA flag indicating if the price was imputed, or derived, from the last arriving record. This is generally used for tokens with low-liquidity or inconsistent reporting.
IS_DEPRECATEDBOOLEANA flag indicating if the asset is deprecated or no longer supported by the provider.
IS_VERIFIEDBOOLEANA boolean flag indicating if the token is verified by either uniswap labs or passing a threshold of transfers metrics on the chain.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.
EZ_PRICES_HOURLY_IDTEXTThe unique identifier for each row in the table.