defillama.tvl.historical_agg_tvl
shows daily historical total value locked (TVL) in 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 |
total_liquidity_usd | The TVL of the protocol on this date |
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 |
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.