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×sorted by session_date ↑×

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

XLP	2003-05-12	19.490000	19.700000	19.360000	19.600000	339300	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	2003-05-13	19.600000	19.620000	19.450000	19.510000	252100	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	2003-05-14	19.630000	19.630000	19.360000	19.360000	135300	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	2003-05-15	19.540000	19.540000	19.380000	19.510000	176000	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	2003-05-16	19.450000	19.580000	19.330000	19.400000	882200	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	2003-05-19	19.290000	19.300000	19.140000	19.210000	69000	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	2003-05-20	19.250000	19.420000	19.220000	19.330000	284600	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	2003-05-21	19.260000	19.510000	19.260000	19.480000	173000	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	2003-05-22	19.390000	19.800000	19.390000	19.740000	233900	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	2003-05-23	19.700000	19.760000	19.600000	19.640000	354600	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	2003-05-27	19.600000	19.880000	19.590000	19.830000	816000	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	2003-05-28	19.920000	19.980000	19.810000	19.950000	258600	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	2003-05-29	19.970000	20.090000	19.810000	19.850000	474500	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	2003-05-30	19.970000	20.140000	19.920000	20.060000	792600	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	2003-06-02	20.200000	20.240000	20.010000	20.020000	338400	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	2003-06-03	20.100000	20.220000	20.040000	20.220000	258800	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	2003-06-04	20.280000	20.440000	20.180000	20.370000	192400	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	2003-06-05	20.450000	20.470000	20.300000	20.390000	262400	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	2003-06-06	20.490000	20.550000	20.260000	20.320000	681600	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	2003-06-09	20.380000	20.390000	20.210000	20.280000	269000	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	2003-06-10	20.320000	20.420000	20.260000	20.340000	323100	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	2003-06-11	20.430000	20.510000	20.360000	20.490000	164700	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	2003-06-12	20.600000	20.600000	20.300000	20.560000	58900	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	2003-06-13	20.500000	20.580000	20.320000	20.360000	43100	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	2003-06-16	20.550000	20.770000	20.450000	20.770000	116200	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	2003-06-17	20.780000	20.800000	20.570000	20.640000	117700	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	2003-06-18	20.630000	20.720000	20.500000	20.610000	372300	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	2003-06-19	20.610000	20.680000	20.360000	20.380000	116700	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	2003-06-20	20.380000	20.430000	20.220000	20.290000	121100	1.000000000000000	0.0917800000	tiingo_prices	/tiingo/daily/XLP/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLP	2003-06-23	20.240000	20.240000	20.040000	20.180000	108700	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	2003-06-24	20.170000	20.450000	20.170000	20.400000	366200	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	2003-06-25	20.400000	20.470000	20.110000	20.110000	147900	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	2003-06-26	20.100000	20.250000	20.030000	20.240000	43600	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	2003-06-27	20.300000	20.360000	20.070000	20.130000	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	2003-06-30	20.150000	20.260000	20.090000	20.160000	40500	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	2003-07-01	20.010000	20.330000	19.950000	20.330000	127500	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	2003-07-02	20.260000	20.470000	20.260000	20.460000	114000	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	2003-07-03	20.330000	20.480000	20.250000	20.340000	13800	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	2003-07-07	20.450000	20.570000	20.430000	20.490000	172000	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	2003-07-08	20.420000	20.510000	20.350000	20.510000	67700	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	2003-07-09	20.480000	20.480000	20.160000	20.240000	79600	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	2003-07-10	20.230000	20.230000	20.070000	20.160000	418300	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	2003-07-11	20.250000	20.420000	20.180000	20.300000	98600	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	2003-07-14	20.410000	20.520000	20.220000	20.250000	90100	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	2003-07-15	20.360000	20.410000	20.250000	20.360000	247700	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	2003-07-16	20.360000	20.380000	20.090000	20.150000	159100	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	2003-07-17	20.220000	20.340000	20.060000	20.080000	97800	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	2003-07-18	20.190000	20.300000	20.080000	20.260000	148400	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	2003-07-21	20.290000	20.290000	20.060000	20.090000	121800	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	2003-07-22	20.100000	20.360000	20.050000	20.300000	155900	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