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

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

XLY	2000-12-14	24.410000	24.560000	24.190000	24.420000	115300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2000-12-15	23.910000	24.030000	23.560000	23.720000	8900	1.000000000000000	0.0613500000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2000-12-18	23.940000	24.280000	23.940000	24.230000	72800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2000-12-19	24.300000	24.300000	23.630000	23.660000	97200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2000-12-20	22.910000	23.500000	22.810000	23.380000	31500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2000-12-21	23.340000	24.250000	23.340000	24.090000	97100	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2000-12-22	24.190000	24.630000	24.190000	24.500000	27200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2000-12-26	24.280000	24.420000	24.000000	24.030000	73400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2000-12-27	24.190000	25.310000	24.000000	25.190000	79400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2000-12-28	25.340000	25.500000	25.190000	25.500000	30200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2000-12-29	25.590000	26.060000	25.470000	25.590000	13900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-02	25.780000	25.940000	25.440000	25.550000	167100	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-03	25.310000	27.560000	25.310000	27.560000	1034400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-04	27.410000	28.310000	27.410000	27.950000	259900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-05	27.690000	27.690000	26.750000	27.030000	91300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-08	26.780000	26.940000	26.380000	26.670000	27600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-09	26.910000	26.910000	26.440000	26.450000	96500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-10	26.220000	26.630000	25.940000	26.630000	130900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-11	26.590000	27.000000	26.220000	26.860000	43800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-12	26.560000	27.000000	26.560000	26.840000	71700	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-16	26.810000	27.500000	26.810000	27.470000	19900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-17	27.470000	27.500000	26.910000	27.090000	170800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-18	27.090000	27.130000	26.690000	26.690000	7200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-19	26.030000	26.090000	25.630000	25.630000	223100	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-22	26.310000	26.690000	26.130000	26.590000	90800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-23	26.690000	26.910000	26.500000	26.910000	57400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-24	26.880000	26.970000	26.690000	26.940000	392800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-25	27.060000	27.630000	26.810000	27.360000	5793700	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-26	27.310000	27.380000	27.000000	27.060000	432000	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-29	27.340000	27.620000	27.180000	27.600000	358700	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-30	27.600000	27.810000	27.250000	27.680000	720600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-01-31	27.950000	28.630000	27.950000	28.570000	117500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-01	28.500000	28.530000	28.180000	28.530000	43800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-02	28.540000	28.610000	27.920000	27.990000	138800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-05	28.160000	28.160000	27.750000	27.830000	22200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-06	27.980000	28.240000	27.860000	27.860000	19400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-07	28.020000	28.080000	27.750000	27.920000	96400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-08	27.650000	27.650000	26.990000	27.100000	211700	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-09	27.500000	27.500000	26.560000	26.750000	1637800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-12	26.820000	27.500000	26.820000	27.500000	3422000	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-13	27.640000	28.050000	27.430000	27.870000	28500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-14	27.980000	27.980000	27.580000	27.600000	93800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-15	27.740000	27.770000	27.460000	27.590000	14500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-16	27.300000	27.720000	27.240000	27.240000	9300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-20	27.700000	28.000000	27.470000	27.600000	74900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-21	27.380000	27.380000	26.360000	26.410000	131800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-22	26.320000	26.480000	25.840000	26.000000	35600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-23	26.120000	26.460000	25.710000	26.430000	94600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-26	26.900000	27.240000	26.700000	27.240000	90500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
XLY	2001-02-27	27.100000	27.340000	26.820000	27.100000	93800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLY/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04