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

Sources in this table

tiingo_prices291,212 rows

active:symbol = XLP×

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

XLP	2021-05-18	70.890000	71.170000	70.550000	70.590000	11169175	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	2021-05-17	70.950000	71.255000	70.660000	70.810000	10705805	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	2021-05-14	70.870000	71.335000	70.830000	70.910000	9672566	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	2021-05-13	69.610000	70.920000	69.530000	70.600000	18497984	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	2021-05-12	70.400000	70.480000	69.610000	69.620000	13223132	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	2021-05-11	71.210000	71.360000	70.240000	70.560000	14385702	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	2021-05-10	70.940000	71.640000	70.880000	71.180000	10558652	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	2021-05-07	70.530000	70.855000	70.359700	70.640000	9841789	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	2021-05-06	69.870000	70.660000	69.870000	70.640000	10192046	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	2021-05-05	69.770000	69.870000	69.500000	69.740000	5499736	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	2021-05-04	70.000000	70.268500	69.570000	69.790000	11147284	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	2021-05-03	69.730000	70.410000	69.660000	70.150000	12671491	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	2021-04-30	69.520000	69.610000	69.240000	69.580000	10784797	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	2021-04-29	68.760000	69.630000	68.760000	69.520000	9202883	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	2021-04-28	69.020000	69.180000	68.710000	68.790000	7925308	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	2021-04-27	68.750000	68.885000	68.440000	68.740000	10078892	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	2021-04-26	69.530000	69.530000	68.690000	68.790000	8750052	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	2021-04-23	69.610000	69.790000	69.290000	69.570000	9133794	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	2021-04-22	70.150000	70.190000	69.600000	69.750000	10762899	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	2021-04-21	70.000000	70.470000	70.000000	70.270000	10794944	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	2021-04-20	69.050000	70.140000	68.950000	69.920000	13168950	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	2021-04-19	69.820000	69.960000	69.320000	69.540000	10867366	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	2021-04-16	69.700000	69.950000	69.430000	69.810000	7810039	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	2021-04-15	69.020000	69.520000	69.020000	69.410000	7714920	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	2021-04-14	68.880000	68.960000	68.570000	68.860000	12087520	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	2021-04-13	68.990000	69.180000	68.830000	68.920000	11982803	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	2021-04-12	69.010000	69.300000	68.915000	69.290000	10117926	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	2021-04-09	69.050000	69.205000	68.500000	68.920000	7020455	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	2021-04-08	68.940000	69.180000	68.860000	69.040000	10244788	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	2021-04-07	69.260000	69.350000	68.880000	68.970000	20763858	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	2021-04-06	68.730000	69.400000	68.680000	69.140000	19302195	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	2021-04-05	68.270000	69.220000	68.150000	68.850000	20092997	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	2021-04-01	68.040000	68.330000	67.530000	67.980000	21191774	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	2021-03-31	68.500000	68.780000	68.160000	68.310000	18241132	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	2021-03-30	69.140000	69.210000	68.400000	68.530000	14042732	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	2021-03-29	68.380000	69.335000	68.350000	69.270000	11857274	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	2021-03-26	67.470000	68.620000	67.275000	68.580000	15098562	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	2021-03-25	66.830000	67.470000	66.500000	67.390000	14763964	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	2021-03-24	66.840000	67.170000	66.585000	66.740000	15831102	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	2021-03-23	66.710000	67.310000	66.530000	67.000000	13216342	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	2021-03-22	65.910000	66.760000	65.860000	66.720000	14499457	1.000000000000000	0.3569400000	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-03-19	66.220000	66.559800	66.060000	66.380000	20807120	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	2021-03-18	66.250000	66.520000	65.830000	66.150000	14497554	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	2021-03-17	66.550000	66.820000	66.195000	66.420000	12254152	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	2021-03-16	66.360000	66.730000	66.360000	66.520000	13550248	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	2021-03-15	66.388000	66.500000	66.040000	66.440000	8384558	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	2021-03-12	65.850000	66.235000	65.795000	66.150000	10518244	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	2021-03-11	65.840000	66.040000	65.540000	65.610000	12386463	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	2021-03-10	64.970000	66.055000	64.760000	65.770000	15827666	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	2021-03-09	65.200000	65.510000	64.870000	64.920000	17259567	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