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

Sources in this table

tiingo_prices283,802 rowsexportable

active:symbol = SOXX×sorted by session_date ↑×

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

SOXX	2002-05-06	60.250000	60.800000	58.220000	58.350000	7100	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-05-07	58.550000	58.920000	56.850000	58.000000	180900	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-05-08	62.200000	65.130000	61.850000	64.800000	71700	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-05-09	64.600000	64.840000	62.700000	63.770000	15600	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-05-10	63.150000	63.150000	59.720000	60.180000	24300	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-05-13	61.150000	63.390000	61.000000	63.390000	12600	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-05-14	67.050000	67.600000	66.010000	67.460000	35900	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-05-15	66.000000	69.150000	65.460000	66.910000	29100	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-05-16	67.000000	67.890000	66.100000	67.890000	14200	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-05-17	68.800000	68.840000	67.000000	67.940000	13600	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-05-20	67.300000	67.400000	66.500000	67.090000	5900	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-05-21	67.300000	67.600000	64.690000	65.250000	15000	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-05-22	64.500000	65.500000	63.450000	63.640000	49000	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-05-23	65.000000	65.000000	63.000000	64.990000	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	2002-05-24	62.700000	63.090000	62.350000	62.700000	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	2002-05-28	63.000000	63.000000	61.700000	62.450000	5400	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-05-29	61.000000	61.240000	60.400000	60.560000	12800	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-05-30	59.200000	60.350000	58.350000	59.890000	19100	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-05-31	60.650000	61.400000	59.750000	59.800000	125200	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-06-03	59.100000	59.100000	56.750000	56.900000	26900	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-06-04	56.700000	58.800000	56.400000	58.140000	21800	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-06-05	58.700000	58.700000	57.000000	58.490000	13500	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-06-06	56.810000	57.050000	55.900000	56.390000	30500	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-06-07	52.800000	54.650000	52.000000	54.640000	33600	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-06-10	54.500000	55.240000	53.970000	54.080000	119700	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-06-11	54.260000	54.390000	51.750000	51.750000	108300	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-06-12	52.350000	53.450000	51.070000	53.340000	31600	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-06-13	52.910000	54.340000	52.340000	52.610000	634200	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-06-14	50.000000	53.000000	49.800000	52.500000	14200	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-06-17	53.850000	55.650000	53.850000	55.150000	17900	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-06-18	55.100000	56.700000	54.500000	54.500000	22800	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-06-19	52.550000	53.250000	50.750000	50.850000	117500	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-06-20	51.750000	51.750000	48.250000	48.600000	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	2002-06-21	48.510000	49.130000	47.050000	47.280000	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	2002-06-24	47.350000	49.650000	46.700000	49.400000	20700	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-06-25	49.750000	49.750000	46.450000	46.700000	25600	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-06-26	44.400000	46.700000	44.400000	46.510000	8900	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-06-27	48.500000	49.140000	47.250000	48.700000	80100	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-06-28	48.800000	50.110000	47.850000	47.910000	35000	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-07-01	48.300000	48.650000	45.750000	45.750000	25200	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-07-02	45.000000	45.350000	43.700000	44.090000	17000	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-07-03	43.250000	45.650000	43.250000	45.600000	23400	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-07-05	48.000000	49.350000	47.800000	49.350000	13000	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-07-08	49.450000	49.450000	47.500000	47.500000	5600	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-07-09	46.800000	46.850000	45.800000	45.800000	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	2002-07-10	46.350000	46.360000	44.090000	44.390000	12300	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-07-11	43.550000	46.620000	43.140000	46.620000	35800	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-07-12	47.000000	47.950000	46.280000	47.530000	38000	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-07-15	46.400000	48.000000	45.740000	47.650000	21200	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-07-16	49.200000	50.800000	48.000000	48.630000	79900	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