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
active:endpoint = /tiingo/daily/SPCX/prices×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SPCX | 2026-07-09 | 150.445000 | 153.500000 | 147.590000 | 152.160000 | 46468592 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-07-08 | 152.550000 | 152.930000 | 145.200000 | 148.300000 | 60949410 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-07-07 | 158.920000 | 159.299900 | 148.860000 | 149.470000 | 83779737 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-07-06 | 165.950000 | 167.895000 | 155.040000 | 160.420000 | 188831328 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-07-02 | 159.725000 | 162.160000 | 155.880000 | 162.000000 | 61257120 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-07-01 | 171.565000 | 171.740000 | 155.000000 | 157.540000 | 109317597 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-30 | 163.380000 | 172.400000 | 161.640000 | 170.860000 | 82047546 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-29 | 157.355000 | 166.170000 | 151.735600 | 164.190000 | 81443101 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-26 | 150.620000 | 158.400000 | 148.510000 | 153.230000 | 126932861 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-25 | 156.625000 | 160.650000 | 150.000000 | 153.000000 | 62212435 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-24 | 154.195400 | 159.860000 | 150.720000 | 154.540000 | 76101541 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-23 | 151.060000 | 165.500000 | 147.110000 | 156.110000 | 155848109 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-22 | 176.042000 | 176.750000 | 154.000000 | 154.600000 | 169183799 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-18 | 188.390000 | 190.000000 | 172.110000 | 185.000000 | 272126781 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-17 | 209.840000 | 213.799900 | 187.010000 | 191.820000 | 201719498 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-16 | 200.510000 | 225.640000 | 195.130000 | 201.800000 | 322149250 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-15 | 171.740000 | 193.000000 | 168.350000 | 192.500000 | 256226632 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPCX | 2026-06-12 | 150.000000 | 176.520000 | 149.340000 | 160.950000 | 522131790 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPCX/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |