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 = XLF×

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

XLF	2023-05-12	32.240000	32.240000	31.690000	31.900000	36253024	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-05-11	31.880000	32.075000	31.740000	32.030000	36693238	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-05-10	32.470000	32.540000	31.795000	32.080000	39706084	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-05-09	32.140000	32.385000	32.065000	32.260000	29736172	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-05-08	32.510000	32.620000	32.340000	32.380000	34323628	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-05-05	32.070000	32.380000	32.020000	32.330000	55019390	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-05-04	31.680000	31.850000	31.260000	31.550000	76076589	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-05-03	32.370000	32.530000	31.930000	31.960000	65642402	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-05-02	32.950000	32.960000	32.025000	32.330000	76096651	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-05-01	33.260000	33.430000	33.040000	33.080000	31950590	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-28	32.620000	33.195700	32.545000	33.170000	54598658	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-27	32.380000	32.840000	32.380000	32.780000	46398842	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-26	32.480000	32.660000	32.120000	32.260000	53977479	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-25	32.930000	32.990000	32.560000	32.570000	58534295	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-24	33.195000	33.320000	33.060000	33.140000	32774163	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-21	33.240000	33.260000	33.030000	33.220000	41545017	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-20	33.220000	33.430800	33.210000	33.340000	39291820	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-19	33.310000	33.530000	33.250000	33.440000	39478861	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-18	33.330000	33.429900	33.080000	33.360000	49507548	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-17	32.860000	33.270000	32.720000	33.260000	69576694	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-14	32.900000	33.150000	32.720000	32.880000	65054415	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-13	32.290000	32.575000	32.070000	32.560000	58550281	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-12	32.500000	32.670000	32.190000	32.270000	63645798	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-11	32.140000	32.480000	32.120000	32.340000	53912616	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-10	31.870000	32.070000	31.800000	32.060000	27900715	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-06	31.810000	32.046000	31.775000	31.990000	36762286	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-05	31.670000	31.960000	31.660000	31.870000	57965324	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-04	32.290000	32.340000	31.700000	31.910000	45939269	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-04-03	32.115000	32.339900	32.020100	32.210000	51213486	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-31	31.980000	32.160000	31.860000	32.150000	49034438	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-30	32.100000	32.120000	31.620000	31.800000	45061690	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-29	31.750000	31.880000	31.610000	31.870000	52147171	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-28	31.380000	31.520000	31.220000	31.410000	42980099	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-27	31.520000	31.590000	31.235000	31.420000	61393348	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-24	30.630000	31.020000	30.390000	30.990000	76647535	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-23	31.280000	31.600000	30.790000	31.010000	82366321	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-22	31.960000	32.050000	31.200000	31.220000	67874143	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-21	31.880000	32.040000	31.810000	31.960000	115899169	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-20	31.070000	31.440000	31.020000	31.170000	75384475	1.000000000000000	0.1526100000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-17	31.710000	31.710000	30.895000	30.980000	136760563	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-16	31.200000	32.340000	30.900000	32.010000	134086719	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-15	31.355000	31.535000	30.960000	31.410000	132235003	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-14	32.840000	32.845000	31.870000	32.270000	128115514	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-13	31.760000	32.319900	31.365000	31.630000	165965875	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-10	33.145000	33.720000	32.525000	32.930000	166569401	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-09	34.760000	34.815000	33.370000	33.540000	107108500	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-08	35.050000	35.235000	34.780000	34.960000	50860314	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-07	35.890000	35.920000	35.000000	35.090000	53804397	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-06	36.010000	36.245000	35.910000	36.020000	30111132	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03
XLF	2023-03-03	35.570000	36.000000	35.500000	35.990000	33091585	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/XLF/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:03	2026-09-07 11:03