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.

283,842 rowsCSV — whole table, not this view

Sources in this table

tiingo_prices283,842 rowsexportable

active:symbol = SOXX×sorted by session_date ↑×

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

SOXX	2002-12-06	39.250000	40.890000	39.250000	40.160000	137400	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	2002-12-09	39.250000	39.300000	37.410000	37.750000	122600	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	2002-12-10	38.200000	39.500000	37.600000	39.450000	84200	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	2002-12-11	38.500000	40.000000	38.350000	39.150000	48700	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	2002-12-12	39.250000	39.950000	38.480000	38.750000	235500	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	2002-12-13	37.800000	37.990000	37.400000	37.510000	91000	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	2002-12-16	37.700000	39.350000	37.360000	39.250000	34300	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	2002-12-17	38.750000	39.730000	38.200000	38.410000	519400	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	2002-12-18	37.000000	37.000000	35.660000	35.970000	76100	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	2002-12-19	36.000000	36.580000	35.020000	35.690000	131400	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	2002-12-20	35.900000	36.400000	35.510000	35.770000	173400	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	2002-12-23	35.900000	36.820000	35.900000	36.450000	329400	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	2002-12-24	36.400000	36.500000	35.900000	35.950000	11900	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	2002-12-26	36.790000	37.160000	35.700000	35.800000	20000	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	2002-12-27	35.960000	36.050000	35.400000	35.550000	59900	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	2002-12-30	36.100000	36.100000	34.520000	34.800000	56200	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	2002-12-31	34.500000	35.020000	34.060000	34.680000	39800	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-01-02	35.300000	37.040000	34.680000	36.980000	128700	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-01-03	36.950000	37.740000	36.610000	37.540000	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-01-06	38.300000	39.840000	38.150000	39.450000	43600	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-01-07	39.800000	40.540000	39.010000	39.250000	32400	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-01-08	38.750000	38.800000	37.590000	37.780000	27900	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-01-09	38.800000	39.790000	38.800000	38.940000	116200	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-01-10	38.500000	40.100000	38.210000	39.810000	84900	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-01-13	40.730000	40.730000	38.800000	39.190000	25800	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-01-14	39.100000	40.070000	38.900000	39.300000	32400	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-01-15	39.250000	39.250000	38.100000	38.500000	23600	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-01-16	38.500000	38.500000	37.070000	37.150000	195900	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-01-17	35.750000	36.040000	34.950000	35.000000	235900	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-01-21	35.500000	35.590000	34.520000	34.770000	23600	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-01-22	34.750000	35.390000	34.520000	34.530000	40600	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-01-23	35.500000	35.960000	34.910000	35.780000	166400	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-01-24	35.100000	35.100000	34.000000	34.300000	41200	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-01-27	33.800000	34.230000	33.400000	33.650000	56000	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-01-28	34.000000	34.300000	33.400000	34.010000	42200	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-01-29	34.000000	34.300000	33.400000	34.010000	51700	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-01-30	34.950000	34.950000	33.210000	33.220000	46200	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-01-31	31.800000	33.340000	31.710000	33.000000	107500	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-03	33.000000	33.740000	32.990000	33.000000	1009500	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-04	32.400000	32.820000	32.400000	32.480000	16500	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-05	33.000000	33.930000	32.600000	32.700000	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-02-06	32.600000	32.770000	32.050000	32.120000	23800	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-07	32.450000	32.450000	31.790000	31.800000	10900	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-10	31.800000	32.330000	31.420000	32.330000	16900	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-11	32.550000	33.140000	32.260000	32.340000	11100	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-12	32.530000	32.940000	32.200000	32.330000	13400	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-13	32.000000	32.180000	31.510000	31.970000	95000	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-14	32.500000	33.950000	32.500000	33.950000	25000	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-18	34.420000	35.290000	34.420000	35.230000	93300	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-19	35.300000	35.340000	34.300000	34.730000	49700	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