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.

698,194 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 = INTC×sorted by as_of_date ↑×

as_of_date leads no index, so this sort reads every matching row and keeps only the top 150 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
dollar_volume_21dINTC2016-09-26689371544.8969020000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-2629.6979893204metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-270.0144611187metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-270.2193577599metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-270.1541541984metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-27-0.0130076984metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-27701808285.5191280000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-2730.1274554689metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-280.0069930070metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-280.2190023799metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-280.1615016936metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-28-0.0061056544metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-28708348397.0453070000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-2830.3381369756metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-29-0.0032051282metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-290.2198023535metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-290.1571151520metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-29-0.0092912132metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-29712885740.3763270000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-2930.2408993571metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-300.0115219721metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-300.2219484084metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-300.1698243253metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-300.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-30719775245.9343010000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-3030.5893341568metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-10-03-0.0023841060metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-10-030.2225408295metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-10-030.1664518124metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-10-03-0.0023841060metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-10-03713980005.3447150000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-10-0330.5164059429metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-10-04-0.0031864047metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-10-040.2233253129metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-10-040.1621070963metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-10-04-0.0055629139metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-10-04711542016.1740320000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-10-0430.4191683244metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-10-050.0119872136metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-10-050.2223487153metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-10-050.1751356480metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-10-050.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-10-05712887652.2183930000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-10-0530.7838093938metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-10-060.0021058173metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-10-060.2216284077metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-10-060.1767598518metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-10-060.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-10-06709153468.2005360000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-10-0630.8486344728metric_daily——2026-09-09 11:172026-09-09 11:17