Skip to main content
Schema: hyperevm.price Table: fact_asset_metrics_daily Type: Table

​
What

This table provides daily market data for all assets tracked in the price schema. It includes market capitalization, fully diluted valuation, supply metrics, and trading volume sourced from external providers like CoinGecko.

​
Key Use Cases

  • Track market cap and FDV trends over time
  • Analyze circulating vs total supply ratios
  • Monitor market cap rankings
  • Compare trading volumes across assets
  • Enrich stablecoin supply data with market valuations

​
Important Relationships

  • Join with ez_asset_metadata: For asset metadata using asset_id
  • Join with defi.ez_stablecoins_supply: For stablecoin market data enrichment

​
Commonly-used Fields

  • recorded_date: Date of the market data snapshot
  • asset_id: Unique identifier for the asset
  • market_cap: Market capitalization in USD
  • fully_diluted_valuation: FDV in USD (price × total supply)
  • circulating_supply: Number of tokens in circulation
  • total_supply: Total number of tokens
  • current_price: Price at time of recording
  • market_cap_rank: Ranking by market cap

​
Sample Queries

Market Cap Trend Analysis 
SELECT
    recorded_date,
    m.symbol,
    f.market_cap,
    f.fully_diluted_valuation,
    f.market_cap_rank
FROM hyperevm.price.fact_asset_metrics_daily f
JOIN hyperevm.price.ez_asset_metadata m
    ON f.asset_id = m.asset_id
WHERE m.symbol IN ('USDC', 'USDT', 'DAI')
    AND f.recorded_date >= CURRENT_DATE - 30
ORDER BY f.recorded_date DESC, f.market_cap_rank;

​
Columns

Column NameData TypeDescription
ASSET_IDTEXTUnique identifier for the asset from the price provider. Provider-specific ID format.
NAMETEXTFull name of the asset or token. More descriptive than symbol.
SYMBOLTEXTToken ticker symbol as commonly recognized. Usually 3-5 uppercase characters.
RECORDED_DATETEXTThe date of the market data snapshot in UTC.
CURRENT_PRICEFLOATThe USD price of the asset at the time of recording.
HIGH_24HFLOATThe highest price reached in the last 24 hours in USD.
LOW_24HFLOATThe lowest price reached in the last 24 hours in USD.
PRICE_CHANGE_24HFLOATThe absolute price change over the last 24 hours in USD.
PRICE_CHANGE_PERCENTAGE_24HFLOATThe percentage price change over the last 24 hours.
MARKET_CAPNUMBERTotal market capitalization in USD across all chains, calculated as current price multiplied by circulating supply. Sourced from 3rd party price providers such as CoinGecko. Note: This is not chain…
MARKET_CAP_RANKNUMBERThe ranking of the asset by market capitalization.
MARKET_CAP_CHANGE_24HFLOATThe absolute change in market cap over the last 24 hours in USD.
MARKET_CAP_CHANGE_PERCENTAGE_24HFLOATThe percentage change in market cap over the last 24 hours.
FULLY_DILUTED_VALUATIONNUMBERTotal fully diluted valuation (FDV) in USD across all chains, calculated as current price multiplied by total supply. Sourced from 3rd party price providers such as CoinGecko. Note: This is not cha…
CIRCULATING_SUPPLYNUMBERThe number of tokens currently in circulation and available in the market.
TOTAL_SUPPLYNUMBERThe total number of tokens that exist, including locked or reserved tokens.
MAX_SUPPLYNUMBERThe maximum number of tokens that can ever exist. NULL if no cap.
TOTAL_VOLUMENUMBERThe 24-hour trading volume in USD at the time of recording.
ATHFLOATThe all-time high price in USD.
ATH_CHANGE_PERCENTAGEFLOATThe percentage change from the all-time high price.
ATH_DATETIMESTAMP_NTZThe date when the all-time high price was reached.
ATLFLOATThe all-time low price in USD.
ATL_CHANGE_PERCENTAGEFLOATThe percentage change from the all-time low price.
ATL_DATETIMESTAMP_NTZThe date when the all-time low price was reached.
PROVIDERTEXTThe data source that provided the market data. Currently ‘coingecko’.
FACT_ASSET_METRICS_DAILY_IDTEXTPrimary key - unique identifier for each row ensuring data integrity.
INSERTED_TIMESTAMPTIMESTAMP_NTZUTC timestamp when the record was first added to the Flipside database.
MODIFIED_TIMESTAMPTIMESTAMP_NTZUTC timestamp of the most recent update to this record.