Fact Asset Metrics Daily

price.fact_asset_metrics_daily

Schema: tron.price Table: fact_asset_metrics_daily Type: Base Table

What

This table provides daily market data for assets tracked in the price schema on Tron. It includes market capitalization, fully diluted valuation, supply metrics, trading volume, and all-time high/low data 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

Important Relationships

• Join with ez_asset_metadata: Use asset_id for asset details
• Join with dim_asset_metadata: Use asset_id for provider metadata

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 x total supply)
• circulating_supply: Number of tokens in circulation
• total_volume: 24-hour trading volume in USD

Sample queries

-- TRX market cap trend
SELECT
    recorded_date,
    current_price,
    market_cap,
    fully_diluted_valuation,
    market_cap_rank,
    total_volume
FROM tron.price.fact_asset_metrics_daily
WHERE asset_id = 'tron'
    AND recorded_date >= CURRENT_DATE - 90
ORDER BY recorded_date DESC;

-- Supply metrics over time
SELECT
    recorded_date,
    circulating_supply,
    total_supply,
    max_supply,
    circulating_supply / NULLIF(total_supply, 0) * 100 AS pct_circulating
FROM tron.price.fact_asset_metrics_daily
WHERE asset_id = 'tron'
    AND recorded_date >= CURRENT_DATE - 90
ORDER BY recorded_date DESC;

Columns

Column Name	Data Type	Description
ASSET_ID	TEXT	Unique identifier for the asset from the upstream price provider. Example: ‘tron’
NAME	TEXT	Full name of the asset or token. Example: ‘Tether USD’
SYMBOL	TEXT	Token ticker symbol as commonly recognized. Example: ‘USDT’
RECORDED_DATE	TEXT	The date of the market data snapshot in UTC. Example: ‘2024-01-15’
CURRENT_PRICE	FLOAT	The USD price of the asset at the time of recording. Example: 0.12
HIGH_24H	FLOAT	The highest price reached in the last 24 hours in USD. Example: 0.125
LOW_24H	FLOAT	The lowest price reached in the last 24 hours in USD. Example: 0.115
PRICE_CHANGE_24H	FLOAT	The absolute price change over the last 24 hours in USD. Example: 0.005
PRICE_CHANGE_PERCENTAGE_24H	FLOAT	The percentage price change over the last 24 hours. Example: 4.2
MARKET_CAP	NUMBER	Total market capitalization in USD, calculated as current price multiplied by circulating supply. Note: This is global (not chain-specific). Example: 10500000000
MARKET_CAP_RANK	NUMBER	The ranking of the asset by market capitalization. Example: 10
MARKET_CAP_CHANGE_24H	FLOAT	The absolute change in market cap over the last 24 hours in USD. Example: 150000000
MARKET_CAP_CHANGE_PERCENTAGE_24H	FLOAT	The percentage change in market cap over the last 24 hours. Example: 1.5
FULLY_DILUTED_VALUATION	NUMBER	Total fully diluted valuation (FDV) in USD, calculated as current price multiplied by total supply. Note: This is global (not chain-specific). Example: 11000000000
CIRCULATING_SUPPLY	NUMBER	The number of tokens currently in circulation and available in the market. Example: 87500000000
TOTAL_SUPPLY	NUMBER	The total number of tokens that exist, including locked or reserved tokens. Example: 100000000000
MAX_SUPPLY	NUMBER	The maximum number of tokens that can ever exist. NULL if no cap. Example: NULL
TOTAL_VOLUME	NUMBER	The 24-hour trading volume in USD at the time of recording. Example: 500000000
ATH	FLOAT	The all-time high price in USD. Example: 0.2317
ATH_CHANGE_PERCENTAGE	FLOAT	The percentage change from the all-time high price. Example: -48.2
ATH_DATE	TIMESTAMP_NTZ	The date when the all-time high price was reached. Example: ‘2018-01-05 00:00:00.000’
ATL	FLOAT	The all-time low price in USD. Example: 0.001091
ATL_CHANGE_PERCENTAGE	FLOAT	The percentage change from the all-time low price. Example: 10900.0
ATL_DATE	TIMESTAMP_NTZ	The date when the all-time low price was reached. Example: ‘2017-11-12 00:00:00.000’
PROVIDER	TEXT	The data source that provided the market data. Example: ‘coingecko’
FACT_ASSET_METRICS_DAILY_ID	TEXT	Primary key — unique identifier for each row ensuring data integrity. Format: VARCHAR containing composite key generated using MD5 hash of the relevant columns. Usage: Deduplication in incremental loads Join operations for data quality checks Troubleshooting specific records
INSERTED_TIMESTAMP	TIMESTAMP_NTZ	UTC timestamp when the record was first added to the Flipside database. Format: TIMESTAMP_NTZ Use Cases: Data freshness monitoring Incremental processing markers Debugging data pipeline issues
MODIFIED_TIMESTAMP	TIMESTAMP_NTZ	UTC timestamp of the most recent update to this record. Format: TIMESTAMP_NTZ Use Cases: Tracking data corrections and reprocessing Monitoring incremental model updates Data quality audits