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:metric_id = zero_dte_volume_share×sorted by as_of_date ↑×

as_of_date 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.

metric_idtextentity_idtextas_of_date ↑datevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
zero_dte_volume_shareXOM2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLY2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLV2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLU2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLK2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLI2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLF2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLE2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareWDC2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareSTX2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareSPY2026-06-170.6400677868metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareSPCX2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareSOXX2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareSNDK2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareSMH2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareQQQ2026-06-170.6476784898metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_sharePLTR2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_sharePANW2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareORCL2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareNVDA2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareMU2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareMSFT2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareMRVL2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareMETA2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareLMT2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareIWM2026-06-170.3707029256metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareINTC2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareGOOG2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareDIA2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareDELL2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareDE2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareCRWD2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareCRSR2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareCAT2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareAVGO2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareAMZN2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareAMD2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareAAPL2026-06-17—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXOM2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLY2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLV2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLU2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLP2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLK2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLI2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLF2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareXLE2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareWDC2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17
zero_dte_volume_shareSTX2026-06-18—metric_daily——2026-09-15 12:172026-09-15 12:17