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-04-2757.10000057.68000056.63000056.770000330706041.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-2456.77000056.92000056.17000056.870000364267441.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-2356.89000057.19000056.46500056.980000347071721.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-2256.36000056.78000056.13000056.540000405655071.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-2155.32000055.96000054.92000055.870000412998331.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-2055.10000055.72000054.80000055.070000351500371.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-1754.41000055.16000053.41000055.020000909132531.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-1655.84000056.87500055.76500056.580000312825681.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-1555.60000056.21000055.27000055.760000395514891.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-1456.50000056.50000055.40500055.950000588300781.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-1357.61500057.72000056.64500057.110000431008681.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-1057.17000057.47500056.40000056.940000425616891.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-0958.20000059.02000057.11000057.330000550885071.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-0856.68000058.19000056.18000058.050000880236281.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-0759.81000060.77000059.79000060.160000388117001.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-0659.11000059.69000058.89100059.680000254741561.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-0260.53000061.01000058.98000059.250000604005331.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-04-0159.72000060.62000058.35500058.970000966528951.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-3162.04000062.83000060.03500061.260000947669291.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-3063.13000063.46000061.78000061.960000497501201.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-2761.53000062.79000061.26000062.560000595532121.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-2660.67000061.86000060.59000061.520000549676381.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-2560.32000061.00000060.26000060.570000426807361.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-2459.80000061.47000059.77000060.840000512074511.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-2357.89000059.84000057.66000059.630000710272101.0000000000000000.3851780000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-2059.55500060.32000059.28000059.310000730034141.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-1958.87000059.72000058.52000059.360000692313821.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-1858.74000058.97000058.43000058.430000429080211.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-1758.23000059.05000057.98000058.510000401377441.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-1657.76000058.10000057.27000057.900000394743221.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-1357.50000057.93000057.10000057.700000433746331.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-1257.13000058.21500057.06000057.510000693587071.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-1155.63000057.04000055.54000056.980000487437111.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-1056.05500056.46000055.36500055.600000888178741.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-0956.84000057.15000055.94000056.320000887474151.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-0657.15000057.34000056.17000056.570000682190401.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-0556.53000057.06000056.08000056.480000851778111.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-0456.06000056.43000055.32500056.190000707327421.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-0357.38500057.72000056.05000056.5200001547708131.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-03-0257.77000057.88000056.27000057.0400001356333311.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-02-2755.64000056.15000054.92500055.920000590714601.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-02-2654.37000055.67000054.12000055.050000470335071.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-02-2555.30000055.37000054.18500054.870000362074941.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-02-2455.11000055.22000054.40000055.100000429216561.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-02-2355.03500055.93000054.86500055.150000440134721.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-02-2055.00000055.28500054.51000054.880000508334961.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-02-1955.46000055.88000054.92500055.180000625135221.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-02-1854.53000054.86000054.22000054.780000591961161.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-02-1754.56000054.90500053.18000053.750000504995931.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-02-1353.94000054.57500053.81000054.350000483921311.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03