> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# utils.days

> Calendar date scaffold — one row per day for time-series joins and aggregation windows.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

The `utils.days` table contains one row per day from January 3, 2009 (Bitcoin genesis) to the current date. Use it to fill gaps in daily time-series data.

## Table Schema

| Column      | Type        | Description                                                   |
| ----------- | ----------- | ------------------------------------------------------------- |
| `timestamp` | `TIMESTAMP` | Day timestamp (one row per day from Bitcoin genesis to today) |

## Table sample

<TableSample tableSchema="utils" tableName="days" />