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

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

SOXX	2003-02-20	35.250000	35.570000	34.910000	35.500000	183100	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-02-21	35.400000	35.490000	34.520000	35.250000	124900	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-02-24	35.000000	35.570000	34.820000	34.850000	56800	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-02-25	34.050000	34.890000	33.600000	34.560000	113400	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-02-26	34.320000	34.990000	33.670000	33.670000	34800	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-02-27	34.180000	34.800000	33.910000	34.780000	308400	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-02-28	35.000000	35.850000	34.990000	35.850000	726200	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-03	36.300000	36.340000	34.510000	34.520000	69300	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-04	34.500000	34.700000	34.100000	34.100000	9200	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-05	34.200000	34.780000	34.050000	34.510000	21500	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-06	34.100000	34.680000	34.100000	34.400000	9200	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-07	33.300000	34.180000	33.300000	33.850000	31100	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-10	33.600000	33.780000	33.110000	33.200000	17600	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-11	33.100000	33.490000	33.050000	33.050000	9800	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-12	33.500000	34.000000	32.910000	33.990000	28000	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-13	35.000000	36.500000	34.490000	36.450000	58900	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-14	36.500000	37.000000	35.600000	35.810000	189600	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-17	35.600000	38.280000	35.420000	37.950000	196600	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-18	38.100000	38.630000	37.550000	38.540000	166600	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-19	38.000000	38.430000	37.360000	38.200000	53400	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-20	37.700000	38.950000	37.510000	38.350000	38200	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-21	39.050000	39.440000	38.660000	39.350000	127300	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-24	38.000000	38.070000	37.220000	37.220000	793000	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-25	37.300000	38.300000	37.150000	38.070000	104100	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-26	38.000000	38.390000	37.600000	37.880000	44000	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-27	37.050000	37.580000	36.820000	37.300000	494600	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-28	36.900000	37.390000	36.220000	36.400000	28300	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-03-31	35.600000	35.640000	34.820000	34.940000	120300	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-01	35.000000	35.680000	35.000000	35.160000	10100	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-02	37.000000	37.740000	36.650000	37.500000	37100	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-03	37.700000	38.180000	37.070000	37.550000	118900	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-04	37.100000	37.230000	36.120000	36.550000	55300	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-07	38.400000	38.400000	37.000000	37.100000	42100	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-08	36.400000	36.400000	35.500000	35.560000	72500	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-09	35.560000	36.030000	35.010000	35.200000	102700	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-10	35.000000	35.590000	34.750000	35.160000	14600	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-11	35.800000	35.800000	34.710000	34.760000	7500	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-14	35.150000	35.880000	34.830000	35.880000	14400	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-15	35.150000	36.450000	35.110000	35.840000	12700	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-16	37.200000	37.940000	37.060000	37.430000	121900	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-17	37.650000	39.190000	37.430000	39.000000	119100	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-21	38.800000	39.290000	38.750000	39.180000	92200	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-22	38.500000	40.450000	38.500000	40.430000	163200	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-23	40.300000	40.870000	40.110000	40.710000	18000	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-24	40.100000	40.480000	39.770000	40.180000	41900	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-25	39.000000	39.080000	38.100000	38.310000	28700	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-28	38.310000	39.480000	38.310000	39.380000	13900	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-29	39.950000	40.500000	39.670000	40.200000	336300	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-04-30	39.720000	39.880000	39.230000	39.400000	191500	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04
SOXX	2003-05-01	39.400000	39.640000	38.750000	39.370000	38900	1.000000000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04