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.

697,178 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 = CAT×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
ret_1dCAT2016-09-01-0.0061012813metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCAT2016-09-010.1138405007metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCAT2016-09-010.1329486956metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCAT2016-09-01-0.0350669352metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCAT2016-09-01216844286.5115290000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCAT2016-09-0165.4057902496metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCAT2016-09-020.0029465930metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCAT2016-09-020.1138785780metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCAT2016-09-020.1351448641metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCAT2016-09-02-0.0322236702metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCAT2016-09-02216967653.2045820000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCAT2016-09-0265.5985144934metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCAT2016-09-060.0047741462metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCAT2016-09-060.1098288715metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCAT2016-09-060.1394593037metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCAT2016-09-06-0.0276033645metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCAT2016-09-06216231987.9463780000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCAT2016-09-0665.9116913897metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCAT2016-09-070.0199805068metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCAT2016-09-070.1251749688metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCAT2016-09-070.1609460497metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCAT2016-09-07-0.0081743869metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCAT2016-09-07217714935.2515570000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCAT2016-09-0767.2286403892metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCAT2016-09-08-0.0021500239metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCAT2016-09-080.1225277145metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCAT2016-09-080.1572767163metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCAT2016-09-08-0.0103068357metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCAT2016-09-08221245721.4923650000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCAT2016-09-0867.0840972063metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCAT2016-09-09-0.0329183625metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCAT2016-09-090.1684542461metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCAT2016-09-090.1182525005metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCAT2016-09-09-0.0428859140metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCAT2016-09-09230416502.7800180000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCAT2016-09-0964.8757985791metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCAT2016-09-120.0139868796metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCAT2016-09-120.1742102669metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCAT2016-09-120.1328936911metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCAT2016-09-12-0.0294988745metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCAT2016-09-12236197876.6371090000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCAT2016-09-1265.7832085605metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCAT2016-09-13-0.0206298828metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCAT2016-09-130.1873592856metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaCAT2016-09-130.1086810239metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dCAT2016-09-13-0.0495201990metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dCAT2016-09-13236958308.0493080000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCAT2016-09-1364.4261086768metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dCAT2016-09-140.0098466908metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dCAT2016-09-140.1836852273metric_daily——2026-09-09 11:172026-09-09 11:17