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 = XLY×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLY | 2026-09-18 | 111.460000 | 111.770000 | 110.630000 | 111.030000 | 5189836 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-18 | 2026-09-18 18:05 | 2026-09-18 18:05 |
| XLY | 2026-09-17 | 112.040000 | 112.240000 | 111.172600 | 111.390000 | 4350431 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-17 | 2026-09-17 18:05 | 2026-09-17 18:05 |
| XLY | 2026-09-16 | 111.100000 | 111.460000 | 109.625000 | 110.180000 | 8840041 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-16 | 2026-09-16 18:05 | 2026-09-16 18:05 |
| XLY | 2026-09-15 | 112.530000 | 112.630000 | 110.560000 | 110.880000 | 12647266 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-15 | 2026-09-15 17:30 | 2026-09-15 17:30 |
| XLY | 2026-09-14 | 112.310000 | 113.280000 | 112.110000 | 112.850000 | 5259888 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-14 | 2026-09-14 17:30 | 2026-09-14 17:30 |
| XLY | 2026-09-11 | 112.870000 | 113.250000 | 112.545000 | 112.960000 | 4529638 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-11 | 2026-09-11 17:30 | 2026-09-11 17:30 |
| XLY | 2026-09-10 | 111.490000 | 112.650000 | 111.020000 | 111.960000 | 5793434 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-10 | 2026-09-10 17:30 | 2026-09-10 17:30 |
| XLY | 2026-09-09 | 112.960000 | 113.270000 | 112.265000 | 112.460000 | 7637199 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-09 | 2026-09-09 17:30 | 2026-09-09 17:30 |
| XLY | 2026-09-08 | 114.470000 | 114.630000 | 113.750000 | 113.990000 | 7821202 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-08 | 2026-09-08 21:56 | 2026-09-08 21:56 |
| XLY | 2026-09-04 | 115.260000 | 115.740000 | 114.460000 | 114.910000 | 5120236 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-09-03 | 115.930000 | 117.065000 | 115.830000 | 116.460000 | 5658703 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-09-02 | 114.990000 | 115.110000 | 114.250000 | 114.860000 | 4238602 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-09-01 | 115.420000 | 115.615000 | 114.320000 | 114.590000 | 5883310 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-31 | 116.560000 | 117.140000 | 116.290000 | 116.590000 | 4912744 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-28 | 116.710000 | 117.570000 | 116.375000 | 117.210000 | 4505756 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-27 | 116.540000 | 116.620000 | 115.810000 | 115.880000 | 5231609 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-26 | 117.690000 | 117.840000 | 116.745000 | 117.160000 | 3271701 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-25 | 118.410000 | 118.570000 | 117.745000 | 117.950000 | 4156401 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-24 | 118.380000 | 118.790000 | 118.070000 | 118.300000 | 4662421 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-21 | 117.440000 | 118.430000 | 116.740000 | 118.020000 | 6561410 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-20 | 117.050000 | 117.400000 | 116.375000 | 116.680000 | 5156014 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-19 | 116.900000 | 119.060000 | 116.730000 | 118.590000 | 7526407 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-18 | 116.700000 | 117.580000 | 116.070000 | 116.360000 | 5287015 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-17 | 117.960000 | 117.960000 | 116.494100 | 116.750000 | 6884914 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-14 | 118.470000 | 119.175000 | 118.090000 | 118.200000 | 3839277 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-13 | 118.040000 | 118.930000 | 117.885000 | 118.450000 | 4521072 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-12 | 119.320000 | 119.320000 | 117.550000 | 117.890000 | 4486935 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-11 | 119.670000 | 119.960000 | 119.110000 | 119.240000 | 3788630 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-10 | 119.225000 | 119.855000 | 118.860000 | 119.670000 | 4466197 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-07 | 118.520000 | 120.435000 | 118.497300 | 119.860000 | 5077365 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-06 | 118.610000 | 118.795000 | 117.705000 | 118.100000 | 4827897 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-05 | 119.280000 | 119.640000 | 118.070000 | 118.640000 | 6117485 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-04 | 117.530000 | 118.565000 | 117.120000 | 118.290000 | 10500947 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-08-03 | 117.640000 | 119.120000 | 117.640000 | 118.210000 | 10041503 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-31 | 115.440000 | 116.390000 | 114.970000 | 116.090000 | 13158076 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-30 | 112.170000 | 112.795000 | 111.460000 | 112.390000 | 8074561 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-29 | 111.950000 | 113.590000 | 111.440000 | 111.610000 | 7534395 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-28 | 111.660000 | 112.530000 | 111.250000 | 112.480000 | 6018139 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-27 | 110.870000 | 111.360000 | 110.300000 | 110.840000 | 6979358 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-24 | 109.100000 | 109.935000 | 108.650000 | 109.410000 | 8210826 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-23 | 110.480000 | 110.590000 | 108.290000 | 108.760000 | 12650403 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-22 | 114.900000 | 115.230000 | 113.820000 | 114.020000 | 7106380 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-21 | 114.640000 | 115.170000 | 114.280000 | 114.870000 | 6557798 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-20 | 116.220000 | 116.220000 | 114.380000 | 114.610000 | 7804561 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-17 | 115.910000 | 116.870000 | 115.320000 | 115.440000 | 10275143 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-16 | 117.120000 | 118.215000 | 116.860000 | 117.340000 | 6057041 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-15 | 116.460000 | 117.810000 | 116.455000 | 117.000000 | 9073173 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-14 | 116.010000 | 116.400000 | 115.460000 | 115.900000 | 6669325 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-13 | 117.200000 | 117.520000 | 115.620000 | 116.040000 | 5984858 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |
| XLY | 2026-07-10 | 117.590000 | 117.890000 | 116.480000 | 117.240000 | 5971515 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLY/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:04 | 2026-09-07 11:04 |