Simplify Analytics
← Data Explorer

Daily bars (unadjusted)

core.price_daily

UNADJUSTED by design (DESIGN.md:135). Adjustment happens at query time in core.prices_asof(); a return computed off these raw closes prints -50% on every 2-for-1 split.

277,637 rowsCSV — whole table, not this view

Sources in this table

session_dateto
column equals (exact text)
sort
chart against session_date
reset
active:symbol = XLI×sorted by session_date ↑×
symboltextsession_date ↑dateopennumerichighnumericlownumericclosenumericvolumebigintsplit_factornumericdiv_cashnumericsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
XLI1998-12-2223.21000023.28000023.21000023.2800006001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1998-12-2323.45000023.75000023.45000023.6900009001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1998-12-2423.91000024.02000023.83000024.00000014001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1998-12-2824.00000024.14000024.00000024.13000074001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1998-12-2924.25000024.47000024.25000024.47000014001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1998-12-3024.45000024.45000024.30000024.36000028001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1998-12-3124.36000024.56000024.31000024.560000331001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-0424.59000024.84000024.22000024.22000064001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-0524.47000024.77000024.36000024.72000020001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-0624.95000025.33000024.95000025.250000135001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-0725.06000025.13000024.84000025.030000131001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-0824.97000025.25000024.83000025.220000110001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-1125.16000025.16000024.88000024.98000022001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-1224.86000024.92000024.61000024.69000065001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-1324.03000024.36000024.00000024.06000017001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-1424.00000024.22000023.95000023.95000041001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-1524.08000024.42000024.08000024.36000049001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-1924.58000024.58000024.11000024.310000101001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-2024.38000024.50000024.25000024.25000017001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-2124.14000024.14000023.98000024.00000025001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-2223.66000023.75000023.53000023.53000087001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-2523.64000023.92000023.61000023.92000046001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-2623.92000023.92000023.92000023.92000001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-2724.20000024.20000024.11000024.1100005001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-2824.03000024.19000023.95000024.14000019001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-01-2924.23000024.41000023.95000024.3000001092001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-0124.50000024.50000024.33000024.33000024001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-0224.16000024.19000023.86000024.140000207001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-0324.14000024.38000024.14000024.380000201001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-0424.34000024.42000024.25000024.41000061001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-0524.48000024.48000024.30000024.33000043001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-0824.50000024.50000024.14000024.41000029001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-0924.36000024.36000024.08000024.08000041001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-1024.17000024.17000024.05000024.17000054001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-1124.33000024.50000024.33000024.50000035001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-1224.39000024.39000024.31000024.36000026001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-1624.52000024.53000024.47000024.48000038001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-1724.28000024.75000024.28000024.48000054001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-1824.33000024.53000024.27000024.48000043001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-1924.38000024.67000024.38000024.64000028001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-2224.66000025.02000024.66000025.02000064001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-2324.94000025.05000024.86000025.00000054001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-2425.16000025.17000024.88000024.94000053001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-2524.58000024.58000024.28000024.44000032001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-02-2624.56000024.66000024.38000024.52000034001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-03-0124.47000024.50000024.31000024.50000032001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-03-0224.56000024.61000024.30000024.300000476001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-03-0324.48000024.48000024.11000024.160000136001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-03-0424.34000024.63000024.34000024.630000157001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI1999-03-0525.05000025.17000025.05000025.17000052001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03