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-07-15	49.800000	50.200000	49.030000	49.330000	89300	1.000000000000000	0.0000000000	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-07-16	50.000000	50.000000	48.400000	49.250000	132000	1.000000000000000	0.0000000000	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-07-17	47.780000	47.900000	46.620000	47.120000	91100	1.000000000000000	0.0000000000	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-07-18	47.220000	47.680000	46.050000	47.250000	59300	1.000000000000000	0.0000000000	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-07-21	47.050000	47.050000	45.920000	46.390000	137200	1.000000000000000	0.0000000000	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-07-22	47.200000	48.040000	47.120000	47.930000	54500	1.000000000000000	0.0000000000	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-07-23	47.900000	48.840000	47.530000	48.840000	49000	1.000000000000000	0.0000000000	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-07-24	48.950000	49.150000	47.510000	47.510000	109100	1.000000000000000	0.0000000000	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-07-25	47.600000	48.480000	46.600000	48.480000	56700	1.000000000000000	0.0000000000	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-07-28	48.250000	49.180000	48.210000	49.060000	33800	1.000000000000000	0.0000000000	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-07-29	48.850000	48.850000	47.620000	47.900000	94200	1.000000000000000	0.0000000000	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-07-30	48.050000	48.050000	47.490000	47.600000	47300	1.000000000000000	0.0000000000	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-07-31	48.750000	49.410000	48.300000	48.300000	149100	1.000000000000000	0.0000000000	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-08-01	48.500000	48.900000	48.010000	48.900000	109300	1.000000000000000	0.0000000000	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-08-04	48.800000	49.300000	48.050000	49.080000	18900	1.000000000000000	0.0000000000	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-08-05	49.050000	49.050000	47.500000	47.500000	64700	1.000000000000000	0.0000000000	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-08-06	47.350000	47.890000	46.750000	47.100000	54200	1.000000000000000	0.0000000000	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-08-07	47.000000	47.120000	46.410000	46.700000	77300	1.000000000000000	0.0000000000	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-08-08	46.750000	47.000000	44.860000	45.490000	155800	1.000000000000000	0.0000000000	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-08-11	45.690000	46.520000	45.690000	46.320000	81700	1.000000000000000	0.0000000000	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-08-12	46.300000	47.200000	46.300000	47.200000	15100	1.000000000000000	0.0000000000	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-08-13	47.420000	48.600000	47.210000	48.070000	51100	1.000000000000000	0.0000000000	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-08-14	48.200000	48.660000	47.890000	48.620000	14100	1.000000000000000	0.0000000000	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-08-15	48.480000	48.750000	48.480000	48.750000	1600	1.000000000000000	0.0000000000	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-08-18	48.780000	51.000000	48.780000	51.000000	110500	1.000000000000000	0.0000000000	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-08-19	51.150000	52.000000	50.990000	52.000000	402900	1.000000000000000	0.0000000000	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-08-20	51.200000	52.380000	51.060000	51.500000	132500	1.000000000000000	0.0000000000	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-08-21	52.500000	53.540000	52.250000	53.200000	612200	1.000000000000000	0.0000000000	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-08-22	55.950000	56.150000	54.010000	54.200000	1293900	1.000000000000000	0.0000000000	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-08-25	54.000000	54.090000	53.190000	53.540000	1084900	1.000000000000000	0.0000000000	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-08-26	52.900000	53.750000	52.260000	53.750000	43000	1.000000000000000	0.0000000000	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-08-27	53.900000	55.380000	53.890000	55.380000	52400	1.000000000000000	0.0000000000	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-08-28	55.700000	55.960000	54.620000	55.860000	603100	1.000000000000000	0.0000000000	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-08-29	55.750000	56.390000	55.550000	56.200000	565600	1.000000000000000	0.0000000000	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-09-02	56.400000	56.410000	55.250000	56.300000	92900	1.000000000000000	0.0000000000	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-09-03	56.300000	56.440000	54.800000	55.200000	231700	1.000000000000000	0.0000000000	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-09-04	55.100000	56.440000	54.920000	56.010000	92000	1.000000000000000	0.0000000000	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-09-05	56.100000	57.980000	55.900000	56.750000	160100	1.000000000000000	0.0000000000	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-09-08	57.700000	58.840000	57.610000	58.670000	267000	1.000000000000000	0.0000000000	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-09-09	58.550000	58.700000	57.720000	58.000000	174100	1.000000000000000	0.0000000000	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-09-10	56.200000	56.450000	54.550000	54.650000	1009500	1.000000000000000	0.0000000000	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-09-11	55.300000	56.120000	53.750000	55.420000	278800	1.000000000000000	0.0000000000	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-09-12	55.000000	56.430000	54.510000	55.710000	191400	1.000000000000000	0.0000000000	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-09-15	56.200000	56.230000	54.800000	54.830000	32700	1.000000000000000	0.0036000000	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-09-16	55.550000	56.970000	55.300000	56.950000	446800	1.000000000000000	0.0000000000	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-09-17	56.900000	57.260000	56.330000	56.600000	52200	1.000000000000000	0.0000000000	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-09-18	55.870000	57.100000	55.500000	56.960000	68600	1.000000000000000	0.0000000000	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-09-19	56.800000	57.240000	56.210000	56.740000	20700	1.000000000000000	0.0000000000	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-09-22	55.900000	56.000000	55.170000	55.420000	72600	1.000000000000000	0.0000000000	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-09-23	55.650000	56.300000	55.250000	56.240000	35900	1.000000000000000	0.0000000000	tiingo_prices	/tiingo/daily/SOXX/prices	{"format":"json","startDate":null}	2026-09-07	2026-09-07 11:04	2026-09-07 11:04