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×

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_datedatevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
dollar_volume_21dXLV2026-09-181271275525.0052400000metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dXLV2026-09-171320193561.9009500000metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dXLV2026-09-161338151196.3800000000metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dXLV2026-09-151338558511.3442900000metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dXLV2026-09-141321208977.1866700000metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dXLV2026-09-111301413203.8842900000metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dXLV2026-09-101309182189.2900000000metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dXLV2026-09-091302460001.9400000000metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dXLV2026-09-081295239753.7076200000metric_daily2026-09-18 18:302026-09-18 18:30
dollar_volume_21dXLV2026-09-041270040097.9333300000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-09-031294215977.1595200000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-09-021364178478.8604800000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-09-011416681688.1961900000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-311437603090.3666700000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-281452523283.4028600000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-271509695164.4771400000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-261543888711.3914300000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-251599198761.5123800000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-241616586112.6042900000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-211626444435.7804800000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-201591431698.6023800000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-191554532972.0509500000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-181466498265.6947600000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-171455958894.9723800000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-141468797773.6928600000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-131519820473.3866700000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-121547906902.2385700000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-111577507502.1604800000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-101576884845.3547600000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-071593510234.1623800000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-061604569504.5076200000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-051602465316.2957100000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-041578609089.5490500000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-08-031586172959.2319000000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-311616087656.1347600000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-301618652453.5757100000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-291608781502.9938100000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-281615500475.5233300000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-271640221533.3985700000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-241647318654.1142900000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-231661648516.6261900000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-221680775205.9776200000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-211721912877.2942900000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-201748645869.9022100000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-171776863084.5342000000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-161769121959.2212100000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-151747103130.5484300000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-141731492219.4530600000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-131721699304.9877500000metric_daily2026-09-15 12:152026-09-15 12:15
dollar_volume_21dXLV2026-07-101753745262.5274500000metric_daily2026-09-15 12:152026-09-15 12:15