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-07-17	51.550000	51.550000	47.790000	48.850000	105700	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-18	48.670000	49.300000	47.510000	47.750000	20400	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-19	46.750000	48.160000	46.100000	46.400000	49800	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-22	46.500000	47.180000	45.000000	45.350000	50100	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-23	45.250000	45.810000	43.000000	43.000000	81700	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-24	41.600000	44.810000	41.600000	44.810000	34600	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-25	43.150000	43.150000	38.920000	40.580000	86500	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-26	40.700000	40.790000	38.750000	39.650000	29800	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-29	41.100000	42.530000	40.400000	42.400000	25700	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-30	42.540000	43.930000	41.820000	43.550000	23000	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-31	42.580000	42.650000	40.980000	41.400000	24200	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-08-01	41.100000	41.700000	39.120000	39.120000	17200	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-08-02	39.000000	39.000000	36.970000	37.510000	51300	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-08-05	37.500000	37.510000	35.110000	35.390000	26700	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-08-06	36.750000	38.460000	36.700000	37.500000	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-08-07	39.650000	39.650000	36.500000	38.290000	72600	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-08-08	37.610000	40.000000	37.150000	39.710000	18100	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-08-09	38.600000	39.770000	38.310000	39.500000	26000	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-08-12	38.300000	38.700000	38.150000	38.550000	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	2002-08-13	38.600000	39.810000	37.160000	37.160000	10200	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-08-14	37.050000	39.550000	36.610000	39.430000	28400	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-08-15	40.150000	40.760000	39.100000	40.250000	36400	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-08-16	39.900000	43.350000	39.850000	42.750000	81200	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-08-19	42.750000	45.250000	42.690000	44.760000	43100	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-08-20	44.000000	44.000000	42.650000	42.850000	41400	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-08-21	44.150000	44.990000	43.070000	44.650000	22100	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-08-22	44.650000	45.820000	44.050000	44.900000	56700	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-08-23	43.400000	43.870000	42.000000	42.240000	40000	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-08-26	42.000000	42.620000	41.010000	42.290000	24600	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-08-27	42.450000	42.450000	40.100000	40.400000	45300	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-08-28	39.050000	39.870000	38.120000	38.310000	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-08-29	37.500000	39.010000	37.090000	38.440000	45600	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-08-30	37.640000	38.850000	37.640000	38.000000	50000	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-09-03	37.240000	37.240000	35.900000	36.100000	27800	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-09-04	36.000000	36.650000	34.950000	36.300000	52400	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-09-05	35.600000	35.600000	34.680000	34.760000	47800	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-09-06	36.900000	37.050000	36.510000	36.810000	40000	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-09-09	35.800000	36.790000	35.450000	36.700000	31000	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-09-10	36.800000	38.190000	36.700000	37.540000	33300	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-09-11	39.200000	39.200000	38.110000	38.150000	55400	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-09-12	36.750000	36.940000	35.720000	35.720000	43800	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-09-13	35.300000	36.020000	34.900000	35.200000	56400	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-09-16	34.600000	34.600000	33.400000	33.650000	64100	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-09-17	35.100000	35.100000	32.760000	32.940000	88300	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-09-18	32.300000	33.000000	31.810000	32.350000	282100	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-09-19	31.680000	32.380000	31.240000	31.560000	91600	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-09-20	31.880000	32.070000	30.910000	31.090000	16300	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-09-23	30.600000	30.600000	29.160000	29.690000	64600	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-09-24	29.390000	30.750000	29.320000	29.790000	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-09-25	30.650000	32.330000	30.180000	31.850000	64500	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