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:symbol = XLP×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLP | 2026-09-18 | 83.140000 | 83.195000 | 82.800000 | 82.800000 | 10594693 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-18 | 2026-09-18 18:05 | 2026-09-18 18:05 |
| XLP | 2026-09-17 | 83.510000 | 83.715000 | 83.000000 | 83.490000 | 7566088 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-17 | 2026-09-17 18:05 | 2026-09-17 18:05 |
| XLP | 2026-09-16 | 83.680000 | 84.060000 | 83.315000 | 83.330000 | 9568602 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-16 | 2026-09-16 18:05 | 2026-09-16 18:05 |
| XLP | 2026-09-15 | 83.995000 | 84.070000 | 83.565000 | 83.730000 | 14142439 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-15 | 2026-09-15 17:30 | 2026-09-15 17:30 |
| XLP | 2026-09-14 | 84.380000 | 84.885200 | 84.250000 | 84.420000 | 10274633 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-14 | 2026-09-14 17:30 | 2026-09-14 17:30 |
| XLP | 2026-09-11 | 83.510000 | 83.690000 | 83.040000 | 83.380000 | 10784104 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-11 | 2026-09-11 17:30 | 2026-09-11 17:30 |
| XLP | 2026-09-10 | 83.370000 | 83.810000 | 83.060000 | 83.090000 | 10326358 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-10 | 2026-09-10 17:30 | 2026-09-10 17:30 |
| XLP | 2026-09-09 | 83.510000 | 83.520000 | 82.850000 | 83.050000 | 12181951 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-09 | 2026-09-09 17:30 | 2026-09-09 17:30 |
| XLP | 2026-09-08 | 84.280000 | 84.570000 | 83.810000 | 84.020000 | 13546347 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-08 | 2026-09-08 21:56 | 2026-09-08 21:56 |
| XLP | 2026-09-04 | 84.820000 | 85.300000 | 84.535000 | 84.580000 | 9904156 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-09-03 | 85.370000 | 85.645000 | 84.780000 | 85.260000 | 10265945 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-09-02 | 85.370000 | 86.080000 | 85.040000 | 85.530000 | 8445238 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-09-01 | 85.510000 | 86.160000 | 85.150000 | 85.250000 | 9353794 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-31 | 85.350000 | 85.350000 | 84.900000 | 84.980000 | 7012595 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-28 | 85.500000 | 85.605000 | 85.210000 | 85.450000 | 6809306 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-27 | 85.310000 | 85.855000 | 85.065000 | 85.080000 | 8495980 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-26 | 86.620000 | 86.685000 | 86.250000 | 86.270000 | 7317379 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-25 | 86.860000 | 87.010000 | 86.245000 | 86.520000 | 7022996 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-24 | 86.450000 | 87.465000 | 86.450000 | 87.450000 | 9108098 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-21 | 85.600000 | 86.010000 | 85.280000 | 85.990000 | 11194148 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-20 | 85.200000 | 86.000000 | 85.000000 | 85.320000 | 11495323 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-19 | 85.720000 | 87.190000 | 85.720000 | 86.540000 | 11244297 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-18 | 85.760000 | 86.190000 | 85.130000 | 85.580000 | 10663176 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-17 | 85.360000 | 85.610000 | 84.590000 | 84.680000 | 10513381 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-14 | 86.000000 | 86.300000 | 85.820000 | 86.090000 | 6970193 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-13 | 85.610000 | 86.200000 | 85.510000 | 86.000000 | 10352933 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-12 | 84.085000 | 85.130000 | 84.010000 | 85.080000 | 6448307 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-11 | 84.620000 | 84.980000 | 84.345000 | 84.690000 | 7358402 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-10 | 84.660000 | 85.045000 | 84.330000 | 84.950000 | 6917535 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-07 | 84.500000 | 85.210000 | 84.250000 | 85.120000 | 5690651 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-06 | 86.310000 | 86.410000 | 84.685000 | 85.110000 | 8275988 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-05 | 85.740000 | 85.880000 | 84.790000 | 85.330000 | 7739064 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-04 | 84.290000 | 85.430000 | 83.860000 | 85.370000 | 13262075 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-08-03 | 85.920000 | 86.340000 | 84.630000 | 84.860000 | 12592512 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-31 | 84.850000 | 85.430000 | 84.325000 | 85.050000 | 11382923 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-30 | 86.000000 | 86.090000 | 84.985000 | 85.470000 | 16609083 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-29 | 86.340000 | 87.875000 | 86.340000 | 87.360000 | 14869133 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-28 | 87.070000 | 88.780000 | 86.925000 | 87.060000 | 22253034 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-27 | 84.420000 | 85.765000 | 84.376800 | 85.360000 | 12244255 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-24 | 83.370000 | 84.280000 | 83.160000 | 84.130000 | 9634563 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-23 | 83.200000 | 83.690000 | 82.810000 | 83.210000 | 10351056 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-22 | 84.578000 | 85.015000 | 84.070000 | 84.380000 | 6545689 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-21 | 84.430000 | 84.600000 | 83.915000 | 84.060000 | 7388015 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-20 | 85.135000 | 85.399000 | 84.560000 | 84.860000 | 8571138 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-17 | 86.790000 | 87.430000 | 84.755000 | 85.190000 | 15692309 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-16 | 84.140000 | 85.815000 | 84.040000 | 85.810000 | 12146533 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-15 | 83.100000 | 84.220000 | 82.970000 | 83.470000 | 7387833 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-14 | 84.510000 | 84.735000 | 83.345000 | 83.420000 | 7871374 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-13 | 84.550000 | 85.540000 | 84.375000 | 84.590000 | 8118929 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLP | 2026-07-10 | 83.240000 | 84.190000 | 83.170000 | 84.120000 | 8305379 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLP/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |