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,793 rowsCSV — whole table, not this view

Sources in this table

tiingo_prices277,793 rowsexportable

active:symbol = XLP×sorted by session_date ↑×

symboltext	session_date ↑date	opennumeric	highnumeric	lownumeric	closenumeric	volumebigint	split_factornumeric	div_cashnumeric	sourcetext

XLP	1999-05-18	25.920000	26.970000	25.360000	25.580000	95500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-05-19	25.700000	25.980000	25.630000	25.940000	59400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-05-20	25.860000	26.170000	25.860000	26.000000	150600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-05-21	25.950000	26.110000	25.730000	25.920000	78100	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-05-24	25.770000	26.050000	25.250000	25.250000	20100	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-05-25	25.330000	25.550000	25.000000	25.000000	33500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-05-26	25.220000	25.250000	24.860000	25.000000	67600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-05-27	24.780000	25.270000	24.770000	24.880000	24400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-05-28	25.130000	25.410000	25.000000	25.250000	16500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-01	25.300000	25.380000	24.950000	25.340000	36700	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-02	25.080000	25.330000	24.950000	24.950000	65200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-03	25.000000	25.470000	25.000000	25.190000	40600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-04	25.190000	26.060000	25.190000	26.060000	17400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-07	26.110000	26.110000	25.770000	25.840000	28400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-08	25.590000	25.830000	25.340000	25.480000	77100	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-09	25.450000	25.670000	25.250000	25.340000	18400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-10	25.000000	25.230000	24.810000	24.880000	71200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-11	25.250000	25.310000	24.630000	24.630000	20400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-14	24.640000	24.840000	24.560000	24.700000	32300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-15	24.750000	25.000000	24.670000	24.770000	25600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-16	25.000000	25.030000	24.720000	24.950000	46300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-17	24.880000	25.380000	24.880000	25.160000	26300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-18	25.090000	25.160000	24.810000	25.050000	33600	1.000000000000000	0.1003100000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-21	25.020000	25.020000	24.480000	24.770000	35900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-22	24.720000	25.000000	24.720000	24.910000	85400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-23	24.610000	24.890000	24.520000	24.640000	17400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-24	24.550000	24.910000	24.500000	24.560000	23000	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-25	24.940000	25.000000	24.410000	24.550000	149300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-28	24.840000	25.860000	24.520000	24.560000	21200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-29	24.630000	25.220000	24.520000	25.000000	46400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-06-30	25.220000	25.630000	24.830000	25.590000	51000	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-01	25.670000	25.970000	25.580000	25.780000	38400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-02	25.830000	26.000000	25.720000	25.880000	48500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-06	25.980000	26.230000	25.700000	25.860000	93000	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-07	25.910000	25.920000	25.690000	25.750000	17800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-08	25.480000	25.980000	25.480000	25.550000	34800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-09	25.910000	25.910000	25.630000	25.670000	31900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-12	25.720000	25.750000	25.550000	25.630000	14300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-13	25.550000	26.000000	25.470000	25.720000	22600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-14	25.750000	25.890000	25.550000	25.640000	19100	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-15	25.830000	26.220000	25.830000	25.920000	28000	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-16	26.200000	26.200000	25.830000	25.880000	23700	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-19	26.250000	26.250000	25.590000	25.660000	33100	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-20	25.980000	25.980000	25.330000	25.440000	35900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-21	25.630000	25.720000	25.340000	25.550000	23700	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-22	25.550000	25.660000	25.130000	25.270000	24900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-23	25.220000	25.470000	25.060000	25.080000	37200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-26	25.160000	25.310000	25.020000	25.310000	82300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-27	25.420000	25.560000	25.090000	25.390000	38000	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	1999-07-28	25.230000	25.310000	25.030000	25.160000	20600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04