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.

291,171 rowsCSV — whole table, not this view

Sources in this table

tiingo_prices291,171 rowsexportable

active:symbol = XLP×

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

XLP	2021-12-17	76.240000	76.620000	75.160000	75.200000	23809878	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-16	75.910000	76.780000	75.895000	76.510000	14498964	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-15	75.220000	76.060000	75.195000	75.970000	21276952	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-14	75.010000	75.330000	74.720100	75.210000	16048344	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-13	74.170000	75.390000	74.060000	75.160000	16518053	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-10	73.390000	74.240000	73.255000	74.190000	10889958	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-09	72.750000	73.220000	72.440000	72.960000	8613861	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-08	72.870000	73.190000	72.140000	72.760000	14489774	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-07	72.950000	73.350000	72.810000	72.990000	13169467	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-06	72.080000	73.100000	72.070000	72.830000	18524398	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-03	71.080000	71.680000	70.870000	71.570000	22867553	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-02	70.190000	71.140000	70.190000	70.690000	18704007	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-12-01	70.770000	71.360100	69.920000	69.950000	22902452	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-30	71.690000	71.750000	70.140000	70.290000	23715133	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-29	72.040000	72.420000	71.680000	72.140000	13646622	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-26	72.390000	72.720000	71.700000	71.960000	11715564	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-24	73.000000	73.110000	72.549900	72.880000	9556367	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-23	72.630000	73.220000	72.510000	73.100000	13405650	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-22	72.140000	73.120000	72.060000	72.620000	13425797	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-19	72.470000	72.490000	72.010000	72.050000	11924034	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-18	72.380000	72.480000	71.964700	72.310000	11270219	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-17	72.660000	72.795000	72.445000	72.570000	10444910	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-16	73.140000	73.380000	72.700000	72.730000	6562151	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-15	72.970000	73.265000	72.830000	73.190000	6381465	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-12	72.990000	73.180000	72.720000	72.840000	7468670	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-11	72.940000	72.980000	72.670000	72.840000	6319124	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-10	72.740000	73.080000	72.605000	72.890000	11350551	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-09	72.440000	72.740000	72.200000	72.670000	13092918	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-08	73.030000	73.080000	72.080000	72.420000	12813578	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-05	72.860000	73.120000	72.720000	73.000000	9929095	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-04	72.250000	72.643000	72.060000	72.580000	11701782	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-03	71.850000	72.510000	71.800000	72.510000	10471142	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-02	71.400000	72.000000	71.190000	71.840000	9939788	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-11-01	71.400000	71.520000	71.105000	71.360000	7033473	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-29	71.140000	71.530000	71.070000	71.250000	8105319	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-28	71.090000	71.350000	70.970000	71.320000	8614806	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-27	71.860000	71.910000	71.040000	71.070000	10335096	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-26	71.250000	71.670000	71.200000	71.490000	8805735	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-25	71.240000	71.395000	70.740000	71.240000	6844587	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-22	70.880000	71.400000	70.820000	71.290000	9575787	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-21	70.930000	70.986700	70.660000	70.740000	7976583	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-20	70.490000	71.070000	70.430000	70.830000	8829799	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-19	70.270000	70.430000	69.930000	70.420000	10203062	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-18	70.500000	70.720000	70.020000	70.390000	10043296	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-15	71.220000	71.245000	70.605000	70.810000	11575233	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-14	70.450000	71.090000	70.400000	70.980000	9975213	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-13	70.130000	70.380000	69.585000	70.190000	9548277	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-12	70.090000	70.600000	69.905000	70.060000	12401220	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-11	70.160000	70.410000	69.970000	70.030000	8218354	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2021-10-08	70.180000	70.340000	69.920000	70.050000	7285705	1.000000000000000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04