Simplify Analytics
← Data Explorer

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.

696,350 rowsexport restricted — no row in this table may be redistributed

Sources in this table

as_of_dateto
column equals (exact text)
sort
chart against as_of_date
reset
active:entity_id = XLP×metric_id = zero_dte_volume_share×

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

metric_idtextentity_idtextas_of_datedatevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
zero_dte_volume_shareXLP2026-07-08metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-07-07metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-07-06metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-07-02metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-07-01metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-06-30metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-06-29metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-06-26metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-06-25metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-06-24metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-06-23metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-06-22metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-06-18metric_daily2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-06-17metric_daily2026-09-15 12:172026-09-15 12:17