Simplify Analytics
← Data Explorer

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.

277,637 rowsCSV — whole table, not this view

Sources in this table

session_dateto
column equals (exact text)
sort
chart against session_date
reset
active:endpoint = /tiingo/daily/SMH/prices×symbol = SMH×
symboltextsession_date ↓dateopennumerichighnumericlownumericclosenumericvolumebigintsplit_factornumericdiv_cashnumericsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
SMH2026-09-18562.880000580.810000562.750000573.00000060724561.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-182026-09-18 18:052026-09-18 18:05
SMH2026-09-17560.095000561.769400557.560800560.61000059292801.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-172026-09-17 18:052026-09-17 18:05
SMH2026-09-16549.945000553.170000540.450000545.56000058905231.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-162026-09-16 18:052026-09-16 18:05
SMH2026-09-15546.565000548.190000540.105000542.11000058986411.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-152026-09-15 17:302026-09-15 17:30
SMH2026-09-14539.990000546.760000537.730000541.500000102650881.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-142026-09-14 17:302026-09-14 17:30
SMH2026-09-11568.828000572.800000564.000000568.53000048243701.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-112026-09-11 17:302026-09-11 17:30
SMH2026-09-10561.540000565.150000557.090000560.28000062420751.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-102026-09-10 17:302026-09-10 17:30
SMH2026-09-09569.900000577.570000569.900000574.29000033870001.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-092026-09-09 17:302026-09-09 17:30
SMH2026-09-08578.700000580.570000571.995000573.73000083002801.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-082026-09-08 21:562026-09-08 21:56
SMH2026-09-04560.500000569.400000557.720000567.01000094561121.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-09-03546.770000553.740000540.070000552.60000056234551.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-09-02545.225000553.190000541.720000550.48000051298841.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-09-01546.480000549.880000540.850000545.22000061951021.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-31554.380000558.430000552.790000556.63000043250531.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-28568.720000570.120000552.300000553.11000064684271.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-27569.365000573.210000562.540000573.00000065669331.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-26554.470000557.780000550.540000555.77000038649631.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-25555.375000560.380000550.660000555.82000060462221.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-24554.175000554.175000540.750000546.80000077433151.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-21569.440000569.440000556.100000560.42000096193301.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-20559.375000566.000000557.260000562.65000062406381.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-19575.060000576.835000556.315000560.92000087133011.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-18574.355000577.760000562.630000569.770000113643891.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-17593.715000600.369900591.500000594.07000077005381.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-14587.510000590.330000581.870000587.82000055242951.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-13586.380000597.950000585.010000589.12000067859841.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-12590.550000590.570000583.790000584.83000074140561.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-11578.570000578.600000569.170000572.93000050289831.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-10585.990000586.240000569.200000569.41000064767131.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-07583.580000586.090000572.320000582.70000065050321.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-06565.475000580.430000559.560000571.48000062316511.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-05574.410000585.000000568.380000569.70000062094311.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-04564.292000578.630000562.280000575.71000095662101.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-08-03530.430000548.490000524.770000545.46000072837631.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-31557.500000561.440000535.240000540.530000146738901.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-30529.858000544.640000524.560000538.900000141750011.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-29525.990000532.170000503.630000504.220000194409011.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-28531.650000535.940000518.250000529.600000184290411.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-27565.940000567.620000535.310000548.550000386821571.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-24574.430000578.520000556.490000561.190000191564031.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-23577.200000586.890000573.999400580.17000079632191.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-22571.352000592.010000571.352000586.91000052496611.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-21580.960000586.000000572.050000584.08000071297681.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-20568.780000572.770000557.240000558.83000069625631.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-17547.935000567.410000536.810000556.530000220838831.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-16575.750000581.840000564.450000568.920000123532711.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-15606.880000606.880000573.720000590.770000110207791.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-14608.895000608.895000590.380000600.31000075810881.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-13598.005000599.360000583.090000585.62000087364781.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-10600.870000615.050000595.840000611.03000066083651.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04