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/SPY/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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SPY | 2026-09-18 | 761.310000 | 762.000000 | 757.971000 | 761.690000 | 63258994 | 1.000000000000000 | 1.8888340000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-18 | 2026-09-18 18:05 | 2026-09-18 18:05 |
| SPY | 2026-09-17 | 763.150000 | 763.570000 | 759.960000 | 762.600000 | 45073734 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-17 | 2026-09-17 18:05 | 2026-09-17 18:05 |
| SPY | 2026-09-16 | 759.500000 | 761.670000 | 749.600000 | 754.050000 | 54319706 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-16 | 2026-09-16 18:05 | 2026-09-16 18:05 |
| SPY | 2026-09-15 | 760.117000 | 760.350000 | 756.150000 | 757.390000 | 44101683 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-15 | 2026-09-15 17:30 | 2026-09-15 17:30 |
| SPY | 2026-09-14 | 759.000000 | 763.520000 | 757.930000 | 760.880000 | 42472944 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-14 | 2026-09-14 17:30 | 2026-09-14 17:30 |
| SPY | 2026-09-11 | 764.720000 | 766.380000 | 763.600000 | 764.290000 | 44698647 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-11 | 2026-09-11 17:30 | 2026-09-11 17:30 |
| SPY | 2026-09-10 | 758.030000 | 760.110000 | 756.640000 | 757.830000 | 41498240 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-10 | 2026-09-10 17:30 | 2026-09-10 17:30 |
| SPY | 2026-09-09 | 764.080000 | 764.470000 | 760.940000 | 762.400000 | 31586975 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-09 | 2026-09-09 17:30 | 2026-09-09 17:30 |
| SPY | 2026-09-08 | 769.070000 | 769.700000 | 765.140000 | 765.960000 | 44746095 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-08 | 2026-09-08 21:56 | 2026-09-08 21:56 |
| SPY | 2026-09-04 | 772.010000 | 772.870000 | 769.000000 | 770.190000 | 34054199 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-09-03 | 767.900000 | 774.030000 | 767.450000 | 773.170000 | 43531581 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-09-02 | 762.450000 | 766.430000 | 761.730000 | 765.160000 | 29566216 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-09-01 | 762.010000 | 764.670000 | 759.480000 | 761.780000 | 41126315 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-31 | 767.330000 | 767.995000 | 764.715000 | 767.050000 | 38810779 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-28 | 771.760000 | 775.300000 | 768.307600 | 769.350000 | 36744344 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-27 | 768.500000 | 772.355000 | 767.160000 | 771.100000 | 34557064 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-26 | 764.730000 | 767.350000 | 763.930000 | 766.080000 | 28751592 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-25 | 766.160000 | 766.780000 | 763.050100 | 765.910000 | 27422263 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-24 | 764.780000 | 765.220000 | 762.080000 | 763.470000 | 32430886 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-21 | 766.050000 | 767.850000 | 764.170000 | 765.720000 | 39188673 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-20 | 765.960000 | 768.150000 | 762.040000 | 762.600000 | 45520302 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-19 | 770.360000 | 772.470000 | 768.100000 | 769.060000 | 40306023 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-18 | 768.700000 | 769.500000 | 766.920000 | 767.450000 | 43920908 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-17 | 776.180000 | 776.775000 | 772.510000 | 772.670000 | 34356577 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-14 | 778.540000 | 778.800000 | 775.430100 | 776.340000 | 31367913 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-13 | 774.870000 | 779.370000 | 774.111000 | 777.880000 | 35634483 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-12 | 774.710000 | 774.900000 | 771.280000 | 772.490000 | 33179126 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-11 | 774.530000 | 774.610000 | 769.200000 | 770.560000 | 36740555 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-10 | 772.600000 | 775.050000 | 771.620000 | 773.030000 | 39249478 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-07 | 771.020000 | 773.915000 | 769.610000 | 773.260000 | 43586333 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-06 | 770.210000 | 771.820000 | 767.460000 | 768.560000 | 38416896 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-05 | 775.850000 | 776.850000 | 769.510000 | 769.790000 | 44689081 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-04 | 760.630000 | 773.410000 | 760.520000 | 771.330000 | 69154788 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-08-03 | 749.440000 | 758.580000 | 748.800000 | 757.670000 | 59927538 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-31 | 744.680000 | 748.895000 | 737.680000 | 747.030000 | 62445899 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-30 | 736.050000 | 742.450000 | 734.590000 | 741.690000 | 66811268 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-29 | 739.970000 | 742.680000 | 729.100000 | 729.460000 | 70697215 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-28 | 739.190000 | 742.790100 | 735.980000 | 740.860000 | 47322247 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-27 | 744.910000 | 745.530000 | 735.870000 | 739.090000 | 41461194 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-24 | 738.510000 | 743.720000 | 737.290000 | 738.930000 | 44781983 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-23 | 739.370000 | 742.560000 | 735.210000 | 738.180000 | 55437332 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-22 | 746.620000 | 750.020000 | 746.370000 | 747.410000 | 32836200 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-21 | 746.290000 | 749.040000 | 744.180000 | 748.280000 | 34324262 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-20 | 747.060000 | 748.730000 | 741.510300 | 742.090000 | 50422324 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-17 | 742.080000 | 747.290000 | 740.800000 | 743.290000 | 62650961 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-16 | 752.760000 | 754.570000 | 747.880000 | 750.720000 | 46409814 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-15 | 754.240000 | 755.580000 | 750.200000 | 754.810000 | 43844769 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-14 | 750.910000 | 753.340000 | 748.660000 | 751.830000 | 35143138 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-13 | 752.470000 | 753.910500 | 748.000000 | 749.170000 | 44013628 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| SPY | 2026-07-10 | 752.050000 | 755.420000 | 748.100000 | 754.950000 | 42191313 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/SPY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |