This dataset is structured into two main tables: history and projects.

The history table contains historical data for cryptocurrencies, with the following columns:

Column NameDescription
COINGECKO_IDUnique identifier for the cryptocurrency
DATEDate of the recorded data
FDMCFully Diluted Market Cap
H24_VOLUME24-hour trading volume
MARKET_CAPMarket capitalization
PRICEPrice of the cryptocurrency
SYMBOLSymbol of the cryptocurrency

The projects table provides detailed information about cryptocurrency projects, with the following columns:

Column NameDescription
CIRCULATING_SUPPLYCurrent circulating supply of the cryptocurrency
COINGECKO_IDUnique identifier for the cryptocurrency
FDMCFully Diluted Market Cap
HIGH_24HHighest price in the last 24 hours
LOW_24HLowest price in the last 24 hours
MARKET_CAPMarket capitalization
MARKET_CAP_CHANGE_24HChange in market cap over the last 24 hours
MARKET_CAP_CHANGE_PERCENTAGE_24HPercentage change in market cap over the last 24 hours
MAX_SUPPLYMaximum supply of the cryptocurrency
NAMEName of the cryptocurrency project
PRICECurrent price of the cryptocurrency
PRICE_ATHAll-time high price
PRICE_ATH_CHANGE_PERCENTAGEPercentage change from all-time high price
PRICE_ATH_DATEDate of the all-time high price
PRICE_ATLAll-time low price
PRICE_ATL_CHANGE_PERCENTAGEPercentage change from all-time low price
PRICE_ATL_DATEDate of the all-time low price
PRICE_CHANGE_24HPrice change over the last 24 hours
PRICE_CHANGE_PERCENTAGE_24HPercentage change in price over the last 24 hours
SYMBOLSymbol of the cryptocurrency
TOTAL_SUPPLYTotal supply of the cryptocurrency
VOLUME_24H24-hour trading volume