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 = LMT×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_1dLMT2016-09-010.0026340700metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dLMT2016-09-010.1796534917metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-010.0690420420metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-01-0.0796753174metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dLMT2016-09-011242796626.7538200000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjLMT2016-09-01187.1045687577metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dLMT2016-09-02-0.0011904273metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dLMT2016-09-020.1785299462metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-020.0671330816metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-02-0.0807708970metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dLMT2016-09-021202518952.8163700000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjLMT2016-09-02186.8818343669metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dLMT2016-09-06-0.0013151406metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dLMT2016-09-060.1730112290metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-060.0651212017metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-06-0.0819798125metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dLMT2016-09-061174966970.4443800000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjLMT2016-09-06186.6360584874metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dLMT2016-09-07-0.0067078189metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dLMT2016-09-070.1732444351metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-070.0574281944metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-07-0.0881377257metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dLMT2016-09-071103325585.8299500000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjLMT2016-09-07185.3841376012metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dLMT2016-09-080.0010771844metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dLMT2016-09-080.1729977073metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-080.0580592061metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-08-0.0871554819metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dLMT2016-09-081020623761.3039400000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjLMT2016-09-08185.5838305033metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dLMT2016-09-09-0.0152712825metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dLMT2016-09-090.1765268643metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-090.0414849260metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-09-0.1010957884metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dLMT2016-09-09943526533.9131640000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjLMT2016-09-09182.7497273930metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dLMT2016-09-120.0036143566metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dLMT2016-09-120.1758574424metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-120.0448209228metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-12-0.0978468281metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dLMT2016-09-12838804201.8148300000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjLMT2016-09-12183.4102500691metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dLMT2016-09-13-0.0058207705metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dLMT2016-09-130.1719051584metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaLMT2016-09-130.0383314588metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-13-0.1030980547metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dLMT2016-09-13718798254.4727000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjLMT2016-09-13182.3426610926metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dLMT2016-09-140.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dLMT2016-09-140.1656948857metric_daily——2026-09-09 11:172026-09-09 11:17