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-05-18	27.440000	27.500000	27.020000	27.060000	33800	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-05-19	27.280000	27.590000	27.020000	27.440000	280700	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-05-20	27.340000	27.840000	27.340000	27.750000	147500	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-05-21	27.880000	28.340000	27.690000	28.190000	215100	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-05-24	28.310000	28.590000	27.520000	27.520000	310300	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-05-25	27.560000	28.190000	27.410000	27.410000	451000	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-05-26	27.780000	28.280000	27.630000	28.190000	64700	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-05-27	28.000000	28.380000	27.340000	27.340000	76700	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-05-28	27.410000	27.810000	27.310000	27.630000	107800	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-06-01	27.560000	27.560000	27.020000	27.440000	421500	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-06-02	27.580000	27.840000	27.580000	27.780000	32000	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-06-03	28.090000	28.250000	27.880000	27.880000	43300	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-06-04	28.160000	28.310000	27.880000	28.310000	22500	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-06-07	28.340000	28.730000	28.280000	28.640000	182300	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-06-08	28.500000	28.590000	28.190000	28.190000	169800	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-06-09	28.160000	28.470000	28.130000	28.250000	14400	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-06-10	28.380000	28.530000	28.130000	28.410000	122100	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-06-11	28.560000	28.750000	28.440000	28.660000	81700	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-06-14	28.750000	28.940000	28.530000	28.830000	271000	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-06-15	28.940000	29.340000	28.770000	29.230000	151300	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-06-16	29.380000	29.380000	28.840000	28.940000	228800	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-06-17	28.750000	29.060000	28.690000	28.970000	64300	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-06-18	29.000000	29.130000	28.780000	28.880000	59800	1.000000000000000	0.1462960000	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-06-21	28.810000	28.810000	27.970000	28.200000	87500	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-06-22	27.880000	28.080000	27.840000	27.910000	251000	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-06-23	28.130000	28.250000	28.020000	28.130000	261800	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-06-24	27.940000	27.940000	27.520000	27.660000	232500	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-06-25	27.660000	27.660000	27.380000	27.440000	265500	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-06-28	27.410000	27.520000	27.170000	27.270000	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-06-29	27.270000	27.660000	27.160000	27.640000	68700	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-06-30	27.750000	28.220000	27.750000	28.050000	108000	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-01	28.130000	28.310000	27.970000	28.270000	33200	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-02	28.280000	28.450000	28.090000	28.360000	51600	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-06	28.500000	29.110000	28.500000	28.890000	48800	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-07	28.840000	28.840000	28.590000	28.810000	120600	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-08	29.000000	29.220000	28.950000	29.000000	94300	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-09	28.890000	29.090000	28.810000	28.980000	25700	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-12	29.250000	29.280000	29.000000	29.280000	92200	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-13	29.030000	29.060000	28.810000	29.000000	46200	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-14	29.050000	29.220000	28.840000	29.050000	18800	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-15	29.230000	29.380000	29.060000	29.310000	33000	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-16	29.090000	29.220000	28.940000	29.130000	27000	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-19	29.060000	29.090000	28.780000	29.020000	24600	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-20	28.910000	28.940000	28.250000	28.250000	18400	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-21	28.060000	28.580000	28.000000	28.560000	40500	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-22	28.030000	28.190000	27.700000	28.140000	53500	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-23	28.380000	28.450000	28.170000	28.280000	56300	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-26	28.220000	28.440000	27.750000	27.750000	71800	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-27	27.940000	28.060000	27.670000	27.750000	29700	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-28	27.780000	28.250000	27.590000	28.160000	14200	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