Simplify Analytics
← Data Explorer

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

session_dateto
column equals (exact text)
sort
chart against session_date
reset
active:endpoint = /tiingo/daily/XLE/prices×sorted by session_date ↑×
symboltextsession_date ↑dateopennumerichighnumericlownumericclosenumericvolumebigintsplit_factornumericdiv_cashnumericsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
XLE1999-03-0822.98000023.25000022.89000023.1900001076001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-0922.94000023.31000022.84000022.940000790001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-1023.03000024.31000023.03000024.25000017338001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-1125.00000025.25000024.25000024.5900009090001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-1224.88000025.06000024.25000024.5000006043001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-1524.56000024.63000024.02000024.3100005230001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-1624.09000024.31000024.00000024.1900002733001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-1724.31000024.84000024.25000024.8100003628001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-1825.25000025.31000024.94000025.1300003326001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-1925.25000025.28000024.63000024.7800002604001.0000000000000000.0896990000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-2225.00000025.13000024.73000024.9400001650001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-2324.75000024.75000024.25000024.5000001379001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-2424.63000024.72000024.16000024.380000611001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-2524.31000024.56000024.06000024.4400001665001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-2624.69000024.88000024.47000024.750000447001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-2925.38000025.69000025.34000025.440000844001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-3025.28000025.31000024.91000024.970000608001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-03-3125.16000025.19000024.59000024.590000670001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-0124.63000024.66000024.30000024.560000220001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-0524.56000025.25000024.56000025.160000584001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-0625.09000025.13000024.72000024.910000426001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-0724.88000024.91000024.47000024.6600008364001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-0824.77000025.19000024.67000024.9100008523001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-0924.92000025.50000024.89000025.380000524001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-1225.25000025.75000025.25000025.560000625001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-1325.41000025.73000025.41000025.530000678001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-1425.50000025.66000025.22000025.220000270001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-1525.38000026.44000025.38000026.3100002594001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-1626.59000027.16000026.38000027.140000885001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-1927.88000028.34000027.44000027.4700002455001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-2027.56000027.56000026.77000027.0300003864001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-2126.88000027.06000026.38000026.6300001812001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-2226.56000027.09000026.25000027.0900003959001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-2326.98000027.00000026.55000026.750000163001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-2626.56000026.56000026.02000026.1600002978001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-2726.45000027.00000026.44000026.980000824001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-2827.13000028.28000027.13000027.8800001037001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-2926.81000028.88000026.75000028.7200002401001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-04-3028.38000028.63000028.00000028.2300009661001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-05-0328.25000028.94000028.00000028.9400002766001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-05-0428.97000029.13000028.73000028.9700003585001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-05-0528.94000028.94000028.16000028.5500003810001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-05-0628.69000028.75000028.03000028.4700004025001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-05-0728.28000028.67000028.11000028.6400003607001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-05-1028.61000028.91000028.31000028.3100002707001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-05-1128.50000028.53000028.25000028.410000716001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-05-1227.75000028.00000027.25000027.8800005317001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-05-1328.06000028.31000027.88000028.0200002647001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-05-1427.88000028.06000027.66000027.8100002549001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE1999-05-1727.44000027.78000027.38000027.7000001058001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03