core.economic_calendar
The forward ~5-day window as it stood each day. An event appears in several snapshots; its forecast can change between them.
Simplify Analyticsuw_economic_calendar131 rowsexportableas_of leads no index, so this sort reads every matching row and keeps only the top 50 in a heap (the page LIMIT), under a 5s statement timeout.
| eventtext | event_timetimestamp with time zone | as_of ↓date | event_typetext | reported_periodtext | forecasttext | prevtext | sourcetext | endpointtext | request_params |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| New Home Sales | 2026-09-24 10:00 | 2026-09-22 | report | August | 620000 | 607000 | uw_economic_calendar | /api/market/economic-calendar | {} | 2026-09-22 20:45 | 2026-09-22 20:45 |
| New Home Sales | 2026-09-24 10:00 | 2026-09-21 | report | August | 620000 | 607000 | uw_economic_calendar | /api/market/economic-calendar | {} | 2026-09-21 20:45 | 2026-09-21 20:45 |
| New Home Sales | 2026-09-24 10:00 | 2026-09-20 | report | August | 620000 | 607000 | uw_economic_calendar | /api/market/economic-calendar | {} | 2026-09-20 20:45 | 2026-09-20 20:45 |