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 = XLV×metric_id = dollar_volume_21d×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
dollar_volume_21dXLV2016-09-01440163036.2956520000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-02438279893.4894650000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-06438946140.4669410000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-07441151666.3469340000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-08421399737.7069910000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-09441005956.3573010000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-12459145325.6029640000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-13475603209.2865480000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-14500970352.0042990000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-15510982210.3754290000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-16514460773.9913690000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-19530750553.3825650000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-20533207112.5972730000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-21545908151.1101580000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-22539481900.3329240000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-23529986407.0724480000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-26520452841.4918470000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-27514162171.2790240000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-28511580365.1342830000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-29520985584.5415400000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-09-30528766893.2570490000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-03527760825.0911950000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-04535003552.6180190000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-05546835008.3219540000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-06551699753.8077450000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-07566356069.0478210000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-10557868716.7937230000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-11555376962.5142740000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-12553484812.6840100000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-13554288902.0571600000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-14549805886.1641840000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-17548210243.3824030000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-18534995106.4204250000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-19534572612.3046790000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-20529139167.3713230000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-21525392481.4549810000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-24530020695.5126220000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-25536075868.7519510000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-26535505437.8906690000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-27535880603.6595670000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-28560934227.4632940000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-10-31573773688.6000010000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-11-01587396619.7530950000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-11-02604947604.7061010000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-11-03626365782.1184870000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-11-04656766685.9299530000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-11-07675819004.4518200000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-11-08687668090.1028220000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-11-09794440161.3205090000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLV2016-11-10843281414.0571130000metric_daily——2026-09-09 11:172026-09-09 11:17