| DAY | TEXT | Day that the market details were recorded at |
| NAME | TEXT | The name of asset. |
| SYMBOL | TEXT | The symbol of asset. |
| FULLY_DILUTED_VALUATION | NUMBER | The total market value of the asset if all tokens were in circulation, calculated as current price multiplied by max supply. |
| CIRCULATING_SUPPLY | NUMBER | The total number of tokens currently in circulation and available for trading in the market. |
| TOTAL_SUPPLY | NUMBER | The total number of tokens that currently exist, including those held in reserve or locked. |
| MAX_SUPPLY | NUMBER | The maximum number of tokens that will ever be created for this asset, or NULL if no maximum is defined. |
| CURRENT_PRICE | FLOAT | The current trading price of the asset in USD at the time of data collection. |
| ATH | FLOAT | The highest price (All-Time High) that the asset has ever reached in USD. |
| ATH_CHANGE_PERCENTAGE | FLOAT | The percentage change from the current price to the all-time high price, typically shown as a negative value. |
| ATH_DATE | TIMESTAMP_NTZ | The timestamp when the asset reached its all-time high price. |
| ATL | FLOAT | The lowest price (All-Time Low) that the asset has ever reached in USD. |
| ATL_CHANGE_PERCENTAGE | FLOAT | The percentage change from the current price to the all-time low price, typically shown as a positive value. |
| ATL_DATE | TIMESTAMP_NTZ | The timestamp when the asset reached its all-time low price. |
| HIGH_24H | FLOAT | The highest price the asset reached in USD within the last 24 hours. |
| LOW_24H | FLOAT | The lowest price the asset reached in USD within the last 24 hours. |
| PRICE_CHANGE_24H | FLOAT | The absolute change in price (in USD) over the last 24 hours. |
| PRICE_CHANGE_PERCENTAGE_24H | FLOAT | The percentage change in price over the last 24 hours. |
| MARKET_CAP | NUMBER | The total market value of the asset, calculated as current price multiplied by circulating supply. |
| MARKET_CAP_RANK | NUMBER | The ranking of this asset by market capitalization compared to other assets tracked by the provider. |
| MARKET_CAP_CHANGE_24H | FLOAT | The absolute change in market capitalization (in USD) over the last 24 hours. |
| MARKET_CAP_CHANGE_PERCENTAGE_24H | FLOAT | The percentage change in market capitalization over the last 24 hours. |
| TOTAL_VOLUME | NUMBER | The total trading volume for the asset in USD over the last 24 hours across all exchanges. |
| ROI_JSON | VARIANT | Return on investment data in JSON format, containing percentage and currency information for historical performance tracking. |
| IMAGE_URL | TEXT | The URL pointing to the official image or logo representing the asset. |
| LAST_UPDATED | TIMESTAMP_NTZ | The timestamp when this market data record was last updated by the data provider. |
| ASSET_ID | TEXT | The unique identifier representing the asset. |
| PROVIDER | TEXT | The provider or source of the data. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |
| FACT_ASSET_METRICS_DAILY_ID | TEXT | FACT_ASSET_METRICS_DAILY_ID column |
