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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-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-10 | 150.125000 | 150.570000 | 145.070000 | 145.300000 | 46825995 | 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-13 | 144.700000 | 144.920000 | 136.780000 | 139.140000 | 71456511 | 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-14 | 140.950000 | 143.330000 | 135.520000 | 136.080000 | 46694833 | 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-15 | 137.505000 | 139.340000 | 132.150100 | 135.270000 | 58040919 | 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-16 | 135.010000 | 137.760000 | 130.740000 | 131.110000 | 58725579 | 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-17 | 127.430000 | 130.329900 | 122.120000 | 123.990000 | 83706220 | 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-20 | 125.285000 | 125.700000 | 119.680000 | 119.850000 | 57337250 | 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-21 | 122.105000 | 129.880000 | 120.360000 | 123.540000 | 79718078 | 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-22 | 123.290000 | 124.770000 | 115.190000 | 115.260000 | 92731796 | 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-23 | 115.205000 | 118.550000 | 110.850000 | 118.240000 | 75246453 | 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-24 | 116.005000 | 117.000000 | 111.400000 | 115.070000 | 56786082 | 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-27 | 113.500000 | 114.850000 | 108.660000 | 113.500000 | 64540679 | 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-28 | 109.320000 | 118.130000 | 107.010000 | 116.410000 | 81714250 | 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-29 | 114.395000 | 117.590000 | 110.350000 | 112.550000 | 53995189 | 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-30 | 115.140000 | 118.930000 | 111.350100 | 112.200000 | 56007950 | 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-31 | 113.096000 | 113.635000 | 107.570100 | 108.370000 | 58835713 | 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-08-03 | 106.400000 | 114.920000 | 104.830000 | 114.530000 | 70524025 | 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-08-04 | 117.330000 | 126.710000 | 115.720000 | 125.330000 | 144130084 | 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-08-05 | 112.370000 | 117.500000 | 106.660000 | 108.270000 | 208488385 | 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-08-06 | 107.085000 | 115.750000 | 105.110000 | 114.920000 | 255176620 | 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-08-07 | 114.965000 | 133.480000 | 114.530000 | 133.110000 | 242130745 | 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-08-10 | 134.950000 | 139.260000 | 130.170000 | 138.740000 | 169934327 | 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-08-11 | 138.655000 | 139.980000 | 130.500000 | 133.290000 | 108900589 | 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-08-12 | 135.045000 | 149.600000 | 134.010000 | 146.150000 | 167236422 | 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-08-13 | 143.750000 | 145.050000 | 139.760000 | 141.290000 | 120282152 | 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-08-14 | 142.900000 | 144.020000 | 135.500000 | 140.000000 | 96727761 | 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-08-17 | 139.975000 | 149.800000 | 139.580000 | 146.230000 | 116675369 | 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-08-18 | 140.725000 | 146.460000 | 139.410100 | 143.340000 | 84190976 | 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-08-19 | 144.960000 | 145.010000 | 136.720000 | 139.650000 | 76612316 | 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-08-20 | 137.285000 | 137.880000 | 130.390000 | 134.000000 | 119813167 | 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-08-21 | 134.315000 | 137.350000 | 131.220000 | 136.970000 | 78808308 | 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-08-24 | 134.355000 | 138.330000 | 133.100000 | 135.000000 | 60188375 | 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 |