Derived metrics

core.metric_daily

Derived from the tables above via the registry in app/core/metrics.py. Export is decided per METRIC here, not per source - see core.metric_registry.

723,600 rows

Sources in this table

metric_daily723,600 rows

active:metric_id = px_vs_200dma×sorted by as_of_date ↑×

as_of_date leads no index, so this sort reads every matching row and keeps only the top 300 in a heap (the page LIMIT), under a 5s statement timeout.

metric_idtext	entity_idtext	as_of_date ↑date	valuenumeric	sourcetext	endpointtext	request_paramsjsonb	vintage_tstimestamp with time zone	retrieved_attimestamp with time zone