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

Sources in this table

tiingo_prices277,715 rowsexportable

active:symbol = XLE×sorted by session_date ↑×

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

XLE	1999-07-29	27.970000	28.220000	27.910000	27.980000	29400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-07-30	28.440000	28.750000	28.380000	28.580000	40600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-02	28.390000	28.450000	27.950000	27.950000	13500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-03	28.200000	28.310000	28.000000	28.310000	24500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-04	28.270000	28.830000	28.270000	28.700000	29100	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-05	28.920000	29.250000	28.840000	29.200000	58600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-06	29.380000	29.500000	29.090000	29.160000	40400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-09	29.500000	29.860000	29.330000	29.860000	101700	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-10	29.860000	29.940000	29.380000	29.690000	61400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-11	29.590000	29.880000	29.270000	29.880000	105900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-12	29.690000	30.170000	29.690000	29.940000	146800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-13	29.830000	29.910000	29.690000	29.840000	223400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-16	29.700000	29.700000	29.300000	29.550000	872000	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-17	29.530000	29.770000	29.470000	29.770000	550700	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-18	29.530000	29.780000	29.520000	29.550000	675400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-19	29.410000	29.840000	29.410000	29.660000	252400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-20	29.690000	29.920000	29.640000	29.840000	41600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-23	29.910000	30.060000	29.780000	30.000000	98400	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-24	29.730000	29.840000	29.580000	29.750000	380700	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-25	29.940000	29.940000	29.360000	29.670000	292800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-26	29.440000	29.440000	28.880000	28.910000	55600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-27	29.000000	29.110000	28.720000	28.890000	38900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-30	29.000000	29.000000	28.500000	28.500000	103600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-08-31	28.590000	29.110000	28.560000	28.890000	291200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-01	28.890000	29.060000	28.800000	28.810000	70800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-02	28.590000	28.700000	28.310000	28.500000	49900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-03	28.840000	28.940000	28.700000	28.840000	15300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-07	28.780000	29.410000	28.780000	29.380000	149900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-08	29.310000	29.690000	29.190000	29.470000	48900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-09	29.730000	30.300000	29.730000	30.130000	111800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-10	30.310000	30.310000	29.910000	30.030000	67300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-13	29.750000	29.750000	29.480000	29.560000	161000	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-14	28.250000	29.630000	28.250000	29.230000	226200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-15	29.060000	29.190000	28.750000	28.810000	28200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-16	28.880000	28.880000	28.560000	28.800000	19300	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-17	28.690000	28.970000	28.470000	28.940000	410900	1.000000000000000	0.1304370000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-20	28.970000	28.970000	28.390000	28.500000	231800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-21	27.970000	28.090000	27.310000	27.560000	203500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-22	27.690000	28.000000	27.580000	27.590000	26900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-23	27.810000	27.940000	27.280000	27.280000	130600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-24	27.250000	27.250000	26.360000	27.000000	187200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-27	27.190000	27.440000	27.060000	27.250000	146500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-28	27.030000	27.030000	26.250000	26.810000	694200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-29	26.780000	27.560000	26.780000	27.170000	367800	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-09-30	27.250000	27.500000	27.090000	27.440000	609600	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-10-01	27.500000	27.500000	27.250000	27.340000	85100	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-10-04	27.630000	27.630000	26.980000	27.030000	68200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-10-05	26.780000	26.780000	26.130000	26.440000	66200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-10-06	26.630000	26.910000	26.530000	26.910000	69200	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLE	1999-10-07	26.630000	26.630000	26.280000	26.410000	220500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLE/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03