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.

283,802 rowsCSV — whole table, not this view

Sources in this table

tiingo_prices283,802 rowsexportable

active:symbol = XLP×

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

XLP	2023-02-27	73.060000	73.255000	72.470000	72.630000	10162251	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	2023-02-24	72.660000	72.825000	72.270000	72.710000	11340619	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	2023-02-23	73.360000	73.560000	72.745000	73.200000	12700140	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	2023-02-22	73.500000	74.010000	73.109900	73.290000	8851001	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	2023-02-21	73.380000	73.790000	73.010300	73.400000	8974751	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	2023-02-17	72.530000	73.710000	72.530000	73.680000	11116125	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	2023-02-16	72.620000	73.180000	72.309000	72.740000	8355096	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	2023-02-15	72.980000	73.290000	72.680000	73.270000	9006025	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	2023-02-14	73.750000	73.780000	72.880000	73.130000	9344740	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	2023-02-13	73.190000	73.827500	73.150000	73.800000	7440544	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	2023-02-10	72.300000	73.030000	72.145000	72.970000	8197163	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	2023-02-09	73.000000	73.260000	72.205000	72.300000	8341482	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	2023-02-08	72.780000	72.910000	72.490000	72.620000	8933483	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	2023-02-07	72.960000	73.320000	72.448900	73.180000	9268430	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	2023-02-06	73.280000	73.630000	73.230000	73.490000	7209101	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	2023-02-03	73.910000	73.930000	72.860000	73.400000	12874814	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	2023-02-02	73.830000	74.170000	73.360000	73.690000	12238803	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	2023-02-01	73.680000	74.660000	73.360000	74.330000	15447622	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	2023-01-31	73.090000	73.750000	72.870000	73.740000	8002698	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	2023-01-30	72.710000	73.495000	72.710000	72.950000	10463129	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	2023-01-27	73.020000	73.195000	72.505000	72.860000	10341793	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	2023-01-26	73.250000	73.310000	72.830000	73.070000	8081676	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	2023-01-25	72.710000	73.330000	72.350000	73.330000	11606801	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	2023-01-24	72.830000	73.350000	72.400000	73.150000	13465588	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	2023-01-23	72.760000	73.225000	72.545000	72.850000	12000433	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	2023-01-20	72.110000	72.650000	71.600000	72.620000	12349611	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	2023-01-19	72.460000	72.790000	72.035000	72.060000	12421545	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	2023-01-18	74.610000	74.660000	72.640000	72.750000	16069923	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	2023-01-17	74.860000	75.420000	74.680000	74.790000	9007022	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	2023-01-13	74.190000	74.760000	74.140000	74.740000	9274343	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	2023-01-12	75.140000	75.150000	74.210000	74.390000	9841291	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	2023-01-11	75.190000	75.405000	74.321400	74.980000	9848317	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	2023-01-10	75.130000	75.245000	74.690000	74.940000	8427855	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	2023-01-09	75.730000	76.245000	75.040000	75.040000	11081840	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	2023-01-06	74.760000	76.075000	74.700000	75.780000	9982384	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	2023-01-05	74.420000	74.485000	73.660000	73.810000	9848196	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	2023-01-04	74.480000	75.020000	74.090000	74.560000	12197256	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	2023-01-03	74.590000	74.620000	73.520000	74.270000	14433360	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	2022-12-30	74.770000	74.830000	74.010100	74.550000	6249894	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	2022-12-29	74.900000	75.190000	74.780100	74.920000	5574893	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	2022-12-28	75.760000	75.860000	74.595000	74.600000	5028990	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	2022-12-27	75.280000	75.690000	75.120000	75.540000	4839729	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	2022-12-23	74.830000	75.230000	74.580000	75.180000	4874660	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	2022-12-22	74.690000	74.825000	73.960000	74.790000	6888351	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	2022-12-21	74.580000	75.250000	74.530000	74.960000	7953290	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	2022-12-20	74.150000	74.510000	73.810000	74.220000	7368975	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	2022-12-19	74.310000	74.935000	73.840000	74.280000	8093914	1.000000000000000	0.5330160000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2022-12-16	74.840000	75.100000	74.210000	74.860000	14561475	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	2022-12-15	75.890000	76.040000	74.665000	75.230000	11281678	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	2022-12-14	76.700000	77.270000	76.080000	76.530000	13820240	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