defillama.tvl.historical_agg_token_values
shows daily historical token values of protocols.
Column Name | Description |
---|---|
protocol_name | The full name of the DeFi protocol |
protocol_id | Unique identifier for the protocol in DefiLlama’s system |
protocol_slug | URL-friendly version of the protocol name used in DefiLlama’s URLs |
token_value_usd | The USD token value held by the protocol on this date |
coingecko_token_id | The unique identifier of the token on CoinGecko |
date | Deprecated column; see section below for more details |
actual_timestamp | The record timestamp from DefiLlama |
nearest_date | The nearest date of actual_timestamp above |
token_ethereum_address | The contract address of the token on Ethereum network (if applicable) |
token_polygon_address | The contract address of the token on Polygon network (if applicable) |
token_solana_address | The token address on Solana network (if applicable) |
actual_timestamp
column.
date
column truncates the times from the timestamp column above. In this case, it will store dates 1 Mar, 2 Mar, 3 Mar, and another 3 Mar. This is likely undesirable for you.
The nearest_date
column instead rounds the time to the nearest date. In this case, it will store dates 1 Mar, 2 Mar, 3 Mar, and 4 Mar, ensuring that each date contains a data even when we fetch a slightly late data.