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-07-09615.480000618.165600604.700000607.73000090451011.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-08575.330000595.000000575.040000593.00000095213281.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-07580.020000585.970000566.830000581.450000146192271.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-06607.050000618.210000604.050000604.30000098207151.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-02622.580000627.700000582.600000592.290000213340581.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-07-01634.350000639.890000618.620000620.460000134246661.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-30636.065000659.740000634.600000655.89000094068901.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-29615.030000633.260000596.170000631.980000104739431.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-26616.790000621.710000609.000000611.610000127283451.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-25649.370000650.030000613.930000636.880000149093511.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-24622.280000625.230000606.230000618.920000119019881.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-23625.930000636.880000617.270000622.050000191259631.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-22670.345000671.830000660.020100668.91000080429651.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-18648.545000663.799900648.150000659.880000112297151.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-17633.460000643.500000623.130000623.970000106588321.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-16643.520000648.310000616.000000616.000000109496321.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-15643.500000649.240000639.250000647.10000096138911.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-12607.950000624.620000602.210000619.96000089867161.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-11582.605000611.620000581.610000609.450000121968011.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-10580.755000598.730000568.290000570.910000127113681.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-09609.475000613.690000554.660000591.010000203297151.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-08597.210000606.200000588.540000598.160000138239011.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-05605.090000607.000000569.690000569.690000220380011.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-04613.000000634.780000604.610000627.530000104629361.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-03640.800000642.770000623.910000637.900000101798721.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-02619.600000632.570000614.465000632.21000080835021.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-06-01596.095000613.429900593.090000607.81000086489781.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-29606.030000611.788600597.120000598.93000076031831.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-28595.810000604.740000587.310000599.83000076249701.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-27611.940000612.300000584.930000595.500000112089901.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-26591.580000603.970000589.100000602.140000100085141.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-22574.270000582.500000572.860000576.32000075350201.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-21561.020000570.600000557.620000567.88000082938031.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-20552.750000564.720000551.650000564.66000086704541.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-19534.940000553.339000527.870000543.960000119058271.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-18565.475000567.210000536.870000546.160000123174571.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-15560.305000565.880000552.910100556.340000130096101.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-14570.840000581.169900567.750000578.34000084586911.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-13571.795000576.200000560.120000572.46000095866931.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-12565.005000570.400000542.670000561.250000177207871.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-11570.260000578.059800566.800000576.310000126809401.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-08551.580000566.790000549.000000566.54000085537141.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-07545.765000549.703200535.920000540.100000109051541.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-06537.770000549.880000532.350000549.760000152629131.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-05515.380000526.200000514.120000522.69000086246081.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-04512.470000513.150000501.150000506.79000068674621.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-05-01504.205000511.990000502.250000509.82000053082921.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-04-30504.705000507.789900495.020000506.72000084016421.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-04-29496.345000499.580000492.340000499.58000060079091.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
SMH2026-04-28488.185000496.660000483.290000491.210000126648111.0000000000000000.0000000000tiingo_prices/tiingo/daily/SMH/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04