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	2000-03-02	20.170000	20.470000	20.170000	20.380000	1447500	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	2000-03-03	20.440000	20.500000	20.190000	20.270000	220900	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	2000-03-06	20.080000	20.310000	19.780000	19.780000	315100	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	2000-03-07	19.200000	19.200000	18.340000	18.720000	224100	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	2000-03-08	18.940000	19.500000	18.610000	19.300000	309900	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	2000-03-09	19.360000	19.970000	19.250000	19.810000	1267300	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	2000-03-10	19.810000	20.000000	19.440000	19.580000	1967700	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	2000-03-13	19.160000	19.580000	19.130000	19.270000	1061900	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	2000-03-14	19.500000	19.500000	19.000000	19.160000	552800	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	2000-03-15	19.170000	20.470000	19.030000	20.380000	1582200	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	2000-03-16	21.000000	21.630000	20.750000	21.500000	580200	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	2000-03-17	21.630000	21.640000	20.920000	21.090000	116000	1.000000000000000	0.0683310000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2000-03-20	21.200000	21.200000	20.660000	20.910000	563400	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	2000-03-21	20.950000	21.300000	20.770000	21.300000	32600	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	2000-03-22	21.050000	21.190000	20.800000	21.130000	132900	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	2000-03-23	21.110000	21.340000	20.840000	20.950000	126400	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	2000-03-24	21.000000	21.160000	20.520000	20.580000	231100	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	2000-03-27	20.780000	20.780000	20.300000	20.310000	52200	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	2000-03-28	20.300000	20.660000	20.250000	20.550000	71600	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	2000-03-29	20.690000	21.130000	20.560000	21.050000	36200	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	2000-03-30	20.970000	21.500000	20.970000	21.330000	62200	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	2000-03-31	21.000000	21.500000	20.940000	21.220000	439800	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	2000-04-03	21.630000	22.190000	21.360000	22.190000	76600	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	2000-04-04	22.060000	23.000000	21.920000	22.810000	823600	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	2000-04-05	22.750000	22.750000	22.380000	22.500000	38800	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	2000-04-06	22.250000	22.440000	21.830000	22.090000	55100	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	2000-04-07	22.280000	22.310000	21.750000	21.810000	169700	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	2000-04-10	22.030000	22.450000	21.880000	22.360000	55200	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	2000-04-11	22.560000	22.880000	22.340000	22.750000	60900	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	2000-04-12	22.860000	23.470000	22.670000	23.020000	76500	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	2000-04-13	22.500000	23.000000	22.450000	22.860000	506700	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	2000-04-14	22.190000	22.560000	21.550000	21.730000	62900	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	2000-04-17	22.330000	22.360000	21.720000	22.360000	139500	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	2000-04-18	22.000000	22.500000	22.000000	22.500000	129000	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	2000-04-19	22.610000	23.000000	22.250000	22.770000	39500	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	2000-04-20	22.700000	22.920000	22.590000	22.750000	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	2000-04-24	22.750000	23.470000	22.750000	23.380000	75300	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	2000-04-25	23.380000	23.440000	23.000000	23.270000	51400	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	2000-04-26	23.310000	23.310000	22.800000	23.000000	39100	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	2000-04-27	22.700000	23.000000	22.670000	23.000000	27900	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	2000-04-28	22.940000	22.940000	22.280000	22.340000	56400	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	2000-05-01	22.500000	22.810000	22.160000	22.630000	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	2000-05-02	22.590000	22.780000	22.390000	22.690000	19000	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	2000-05-03	22.940000	22.970000	22.500000	22.690000	309800	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	2000-05-04	22.750000	22.940000	22.520000	22.690000	30600	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	2000-05-05	22.630000	23.220000	22.630000	23.220000	11600	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	2000-05-08	23.330000	23.700000	23.200000	23.700000	277200	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	2000-05-09	23.770000	23.810000	23.470000	23.810000	975200	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	2000-05-10	23.660000	23.720000	23.310000	23.660000	87000	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	2000-05-11	23.520000	23.700000	23.380000	23.630000	28800	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