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×
symboltextsession_date ↓dateopennumerichighnumericlownumericclosenumericvolumebigintsplit_factornumericdiv_cashnumericsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
XLE2026-07-0955.28000055.48000054.73000054.820000217707241.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-0855.45500056.03500054.86500055.600000397413541.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-0753.61000054.82000053.60000054.640000418336471.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-0653.05800053.55000053.00000053.130000247352641.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-0253.24000053.65000052.91000053.220000285382181.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-0153.04500053.44000052.62000052.810000336627001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-3053.62000054.11500053.08000053.110000282839521.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-2953.98000054.28000053.47000053.580000251423171.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-2654.00000054.15000053.67500053.840000190252391.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-2553.20000054.31500053.00000054.090000282386161.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-2453.50000053.76500052.94000053.570000430346111.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-2354.14000054.56000053.87000054.460000386904041.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-2253.53000054.13000053.16500054.060000307656181.0000000000000000.3848760000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-1854.14000054.25000053.24500053.770000396456901.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-1755.26000055.36000054.54000054.670000385530361.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-1655.00000055.47500054.95000055.360000420083941.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-1555.20000056.05000055.02000055.550000443190551.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-1256.79000058.15000056.63000057.550000319647341.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-1158.77500058.99000057.05500057.120000408635271.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-1057.94000059.04000057.78000058.250000365152741.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-0958.08000058.21000056.81000057.390000460262981.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-0858.08000058.96000057.97000058.330000257177861.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-0558.66500058.78000057.63000057.670000282129711.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-0458.50000059.02500058.17000058.750000239163271.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-0358.24000059.37500058.01000058.710000463127951.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-0257.19000058.17000057.08000057.960000238426161.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-06-0157.02500057.81000056.85000057.300000558793501.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-2956.68000056.79000055.99000056.290000323896341.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-2857.55000057.68000056.68000056.950000465540641.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-2757.01000057.50000056.47500056.990000483298331.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-2658.87000059.57000057.83500057.850000388198751.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-2258.99000059.61000058.83000059.490000424288531.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-2160.48000060.59000058.71500059.130000458511291.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-2060.81000061.70000059.67500059.800000589642771.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-1960.81000061.49000060.29500061.290000311110271.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-1859.12500060.70000058.72000060.580000415165911.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-1558.70000059.47000058.47500059.440000335654571.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-1457.65000058.18000057.50500058.070000234869531.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-1357.47000057.71000056.96000057.630000227071911.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-1257.73000057.84000057.14000057.570000368145451.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-1156.26000057.22000056.24000057.170000319433121.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-0855.85000056.22500055.46000055.700000305734891.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-0755.87000056.15000055.13000055.950000529098571.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-0657.29000057.89000056.65500057.000000579075171.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-0559.23000059.76000058.89000059.450000270414181.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-0458.73000059.63000058.22000059.390000368829571.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-05-0159.06000059.60000058.26000058.850000358284351.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-3058.20000059.83500057.93500059.650000358967661.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-2958.28000059.11000058.06000059.030000406166921.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-2857.72000058.05000057.37500057.710000391512811.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03