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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLE | 1998-12-22 | 23.310000 | 23.390000 | 23.190000 | 23.270000 | 15200 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1998-12-23 | 23.340000 | 23.750000 | 23.310000 | 23.750000 | 67800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1998-12-24 | 23.810000 | 23.810000 | 23.590000 | 23.630000 | 12300 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1998-12-28 | 23.750000 | 23.750000 | 23.340000 | 23.500000 | 13500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1998-12-29 | 23.560000 | 23.730000 | 23.340000 | 23.730000 | 22000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1998-12-30 | 23.720000 | 23.720000 | 23.360000 | 23.380000 | 21800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1998-12-31 | 23.340000 | 23.340000 | 23.220000 | 23.340000 | 13000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-04 | 23.280000 | 23.750000 | 23.280000 | 23.330000 | 28600 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-05 | 23.470000 | 23.470000 | 23.170000 | 23.200000 | 42700 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-06 | 23.470000 | 24.000000 | 23.310000 | 23.970000 | 56400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-07 | 23.970000 | 23.980000 | 23.580000 | 23.860000 | 72600 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-08 | 24.000000 | 24.560000 | 23.380000 | 23.970000 | 421100 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-11 | 23.750000 | 23.780000 | 23.440000 | 23.520000 | 35000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-12 | 23.500000 | 23.590000 | 23.130000 | 23.160000 | 89200 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-13 | 22.750000 | 23.190000 | 22.690000 | 22.810000 | 42400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-14 | 22.750000 | 22.880000 | 22.380000 | 22.380000 | 70000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-15 | 22.560000 | 22.750000 | 22.450000 | 22.720000 | 10700 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-19 | 22.810000 | 22.810000 | 22.530000 | 22.720000 | 12800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-20 | 22.590000 | 22.810000 | 22.520000 | 22.530000 | 15800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-21 | 22.530000 | 22.910000 | 22.500000 | 22.720000 | 23900 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-22 | 22.750000 | 22.810000 | 22.560000 | 22.590000 | 19300 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-25 | 22.690000 | 22.690000 | 22.380000 | 22.560000 | 18200 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-26 | 22.590000 | 22.590000 | 22.160000 | 22.340000 | 25700 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-27 | 22.380000 | 22.380000 | 21.880000 | 21.940000 | 37100 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-28 | 22.000000 | 22.000000 | 21.630000 | 21.810000 | 30800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-01-29 | 21.690000 | 21.810000 | 21.440000 | 21.810000 | 18600 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-01 | 21.810000 | 21.880000 | 21.590000 | 21.590000 | 23100 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-02 | 21.630000 | 21.810000 | 21.530000 | 21.630000 | 26500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-03 | 21.750000 | 22.250000 | 21.750000 | 22.130000 | 29400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-04 | 22.130000 | 22.310000 | 22.060000 | 22.250000 | 26000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-05 | 22.310000 | 22.940000 | 22.190000 | 22.880000 | 66000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-08 | 22.970000 | 23.190000 | 22.940000 | 23.190000 | 31100 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-09 | 23.220000 | 23.220000 | 22.750000 | 22.750000 | 64300 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-10 | 22.840000 | 23.060000 | 22.690000 | 22.810000 | 69300 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-11 | 22.720000 | 22.720000 | 22.280000 | 22.630000 | 216800 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-12 | 22.380000 | 22.630000 | 22.160000 | 22.160000 | 242300 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-16 | 22.330000 | 22.440000 | 21.780000 | 22.000000 | 36600 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-17 | 21.880000 | 22.090000 | 21.750000 | 21.780000 | 41700 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-18 | 21.750000 | 21.970000 | 21.530000 | 21.840000 | 83000 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-19 | 21.940000 | 21.970000 | 21.530000 | 21.720000 | 130300 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-22 | 21.880000 | 22.000000 | 21.690000 | 21.940000 | 79500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-23 | 22.000000 | 22.090000 | 21.750000 | 21.750000 | 309600 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-24 | 21.810000 | 22.090000 | 21.660000 | 21.660000 | 34500 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-25 | 21.640000 | 21.910000 | 21.630000 | 21.770000 | 44600 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-02-26 | 21.840000 | 22.000000 | 21.630000 | 21.630000 | 24900 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-03-01 | 21.670000 | 21.690000 | 21.340000 | 21.410000 | 13300 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-03-02 | 21.440000 | 21.530000 | 21.090000 | 21.190000 | 55100 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-03-03 | 21.380000 | 21.750000 | 21.220000 | 21.660000 | 103300 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-03-04 | 21.840000 | 22.560000 | 21.840000 | 22.440000 | 90400 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |
| XLE | 1999-03-05 | 23.000000 | 23.030000 | 22.630000 | 22.860000 | 92700 | 1.000000000000000 | 0.0000000000 | tiingo_prices | /tiingo/daily/XLE/prices | {"format":"json","startDate":null} | 2026-09-07 | 2026-09-07 11:03 | 2026-09-07 11:03 |