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:symbol = XLE×
symboltextsession_date ↓dateopennumerichighnumericlownumericclosenumericvolumebigintsplit_factornumericdiv_cashnumericsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
XLE2026-09-1864.20000064.75000064.10000064.310000291683101.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-182026-09-18 18:052026-09-18 18:05
XLE2026-09-1763.50000064.52000063.46000064.480000339335751.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-172026-09-17 18:052026-09-17 18:05
XLE2026-09-1665.22000065.22000063.68000064.030000485186921.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-162026-09-16 18:052026-09-16 18:05
XLE2026-09-1564.88000066.11500064.81000065.930000341396671.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-152026-09-15 17:302026-09-15 17:30
XLE2026-09-1465.95500066.05000064.18000064.530000460133881.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-142026-09-14 17:302026-09-14 17:30
XLE2026-09-1164.89000065.72500064.71000065.140000304813981.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-112026-09-11 17:302026-09-11 17:30
XLE2026-09-1066.14000066.17000064.34000064.930000368567321.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-102026-09-10 17:302026-09-10 17:30
XLE2026-09-0965.56000065.91500065.01000065.310000250631121.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-092026-09-09 17:302026-09-09 17:30
XLE2026-09-0864.83000065.24000064.31000064.770000280882431.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-082026-09-08 21:562026-09-08 21:56
XLE2026-09-0464.04000064.33000063.37500064.060000262895531.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-09-0365.12000065.52000064.58250064.620000240794061.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-09-0264.27000065.34500064.25000065.100000274014151.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-09-0164.87000064.95000064.05000064.770000332759481.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-3163.80000064.44000063.14000063.960000271488381.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-2862.35000062.74000062.11800062.680000206245401.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-2762.23000062.72000061.55000062.290000296039901.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-2661.43000063.02000061.31000062.430000243985711.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-2562.20000062.78500062.04000062.060000274264421.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-2463.24000063.72000062.56000063.110000230103581.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-2163.90500064.30000063.35000063.640000277985871.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-2064.25000064.70000063.69000063.750000243041261.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-1963.85000064.25000063.40000063.580000255378221.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-1863.41000063.71000063.11500063.680000272805221.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-1762.21500062.68500061.78500062.580000235502951.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-1461.37000062.11000061.25000061.910000227777421.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-1360.52000061.12500060.23000061.060000207035541.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-1260.47000061.17000060.33500061.030000225841531.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-1159.99000061.08000059.99000060.930000224008391.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-1058.19000060.21000058.10000060.180000336778481.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-0757.52500058.04500057.11000057.500000210927191.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-0658.39000058.56000057.58000058.160000250842781.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-0558.77000058.98000057.20500057.310000332135381.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-0457.70000058.72000057.13000058.520000376615421.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-08-0358.69000059.32500058.16000058.790000260383651.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-3158.93000059.68500058.32000059.550000235564761.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-3058.08000059.10500058.02000058.960000230457241.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-2959.08000059.30000058.42000058.650000341755761.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-2858.41000058.79000057.25000057.570000278008111.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-2758.41000059.27990058.23000058.360000338263621.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-2459.40000060.45000059.40000059.620000341818991.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-2360.24400060.37680059.26500059.380000358386301.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-2259.27000059.52000058.90000059.200000295485681.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-2158.16000058.53000057.83000058.500000203156791.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-2057.55500058.38500057.41000057.940000273293271.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-1757.95000058.11500057.28000057.680000313977931.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-1656.66000057.30000056.59500057.020000274769801.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-1556.94000057.04000055.76000056.500000331841981.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-1457.00000057.22000056.29000056.950000325789641.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-1355.86000056.97000055.86000056.740000412008991.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLE2026-07-1055.08000055.24000054.36000055.080000229746521.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLE/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03