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
tiingo_prices277,637 rowsexportable
| symboltext | session_date ↑date | opennumeric | highnumeric | lownumeric | closenumeric | volumebigint | split_factornumeric | div_cashnumeric | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SMH | 2000-06-05 | 97.500000 | 100.500000 | 96.310000 | 98.690000 | 148400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-06 | 98.500000 | 100.300000 | 94.630000 | 94.630000 | 222800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-07 | 95.750000 | 97.000000 | 93.190000 | 96.190000 | 215500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-08 | 98.810000 | 98.880000 | 95.810000 | 96.630000 | 195200 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-09 | 98.250000 | 99.000000 | 97.060000 | 98.630000 | 97500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-12 | 99.250000 | 99.250000 | 94.630000 | 94.810000 | 56200 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-13 | 95.000000 | 98.810000 | 93.310000 | 98.810000 | 194500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-14 | 98.810000 | 98.880000 | 94.560000 | 94.560000 | 97500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-15 | 94.750000 | 96.690000 | 93.250000 | 95.380000 | 108900 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-16 | 95.500000 | 96.940000 | 94.560000 | 96.000000 | 86900 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-19 | 96.380000 | 102.500000 | 95.630000 | 102.500000 | 218200 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-20 | 103.500000 | 105.800000 | 103.000000 | 104.000000 | 248500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-21 | 102.600000 | 105.200000 | 102.500000 | 104.400000 | 185800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-22 | 103.500000 | 103.500000 | 99.000000 | 99.250000 | 391400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-23 | 99.380000 | 100.200000 | 97.250000 | 97.500000 | 342900 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-26 | 98.380000 | 99.380000 | 96.380000 | 97.500000 | 154000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-27 | 98.250000 | 98.440000 | 94.380000 | 94.380000 | 236100 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-28 | 94.630000 | 97.130000 | 94.630000 | 94.880000 | 228500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-29 | 93.750000 | 94.380000 | 91.250000 | 92.690000 | 281800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-06-30 | 93.000000 | 94.810000 | 92.310000 | 94.000000 | 458000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-03 | 93.880000 | 96.250000 | 93.750000 | 96.130000 | 52600 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-05 | 90.500000 | 91.560000 | 88.130000 | 88.630000 | 1362200 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-06 | 89.940000 | 92.750000 | 88.130000 | 92.250000 | 1393400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-07 | 94.250000 | 96.750000 | 93.810000 | 95.250000 | 179900 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-10 | 95.500000 | 96.690000 | 94.500000 | 95.130000 | 93600 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-11 | 95.000000 | 97.130000 | 92.560000 | 93.630000 | 223200 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-12 | 95.880000 | 97.190000 | 94.440000 | 95.940000 | 114600 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-13 | 98.000000 | 99.940000 | 97.440000 | 98.380000 | 144100 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-14 | 100.300000 | 101.400000 | 98.750000 | 101.400000 | 136400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-17 | 101.400000 | 103.100000 | 100.000000 | 102.900000 | 165500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-18 | 101.000000 | 101.300000 | 98.000000 | 98.440000 | 217400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-19 | 98.310000 | 98.310000 | 93.750000 | 94.940000 | 372500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-20 | 95.440000 | 97.310000 | 92.690000 | 93.440000 | 272200 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-21 | 92.060000 | 92.500000 | 88.750000 | 89.630000 | 625700 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-24 | 89.000000 | 92.750000 | 88.500000 | 89.250000 | 1236400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-25 | 92.630000 | 92.940000 | 90.310000 | 92.810000 | 274300 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-26 | 89.250000 | 90.130000 | 86.560000 | 88.750000 | 500800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-27 | 85.380000 | 85.380000 | 82.000000 | 82.690000 | 526400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-28 | 83.880000 | 85.000000 | 80.250000 | 81.940000 | 1352400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-07-31 | 82.810000 | 85.380000 | 80.940000 | 84.630000 | 214800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-08-01 | 84.380000 | 84.380000 | 81.380000 | 81.810000 | 656800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-08-02 | 81.810000 | 84.500000 | 80.380000 | 81.000000 | 302000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-08-03 | 75.250000 | 80.880000 | 75.250000 | 80.880000 | 1421000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-08-04 | 82.880000 | 82.880000 | 77.500000 | 78.690000 | 764800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-08-07 | 78.500000 | 81.630000 | 77.690000 | 81.000000 | 275400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-08-08 | 81.250000 | 82.130000 | 80.500000 | 81.060000 | 206300 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-08-09 | 84.250000 | 85.130000 | 83.130000 | 83.440000 | 359900 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-08-10 | 83.130000 | 83.940000 | 81.130000 | 81.440000 | 566600 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-08-11 | 81.380000 | 83.060000 | 78.810000 | 82.690000 | 316100 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| SMH | 2000-08-14 | 84.380000 | 88.000000 | 83.000000 | 87.750000 | 503000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SMH/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |