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 = XLY×
symboltextsession_datedateopennumerichighnumericlownumericclosenumericvolumebigintsplit_factornumericdiv_cashnumericsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
XLY2026-09-18111.460000111.770000110.630000111.03000051898361.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-182026-09-18 18:052026-09-18 18:05
XLY2026-09-17112.040000112.240000111.172600111.39000043504311.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-172026-09-17 18:052026-09-17 18:05
XLY2026-09-16111.100000111.460000109.625000110.18000088400411.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-162026-09-16 18:052026-09-16 18:05
XLY2026-09-15112.530000112.630000110.560000110.880000126472661.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-152026-09-15 17:302026-09-15 17:30
XLY2026-09-14112.310000113.280000112.110000112.85000052598881.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-142026-09-14 17:302026-09-14 17:30
XLY2026-09-11112.870000113.250000112.545000112.96000045296381.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-112026-09-11 17:302026-09-11 17:30
XLY2026-09-10111.490000112.650000111.020000111.96000057934341.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-102026-09-10 17:302026-09-10 17:30
XLY2026-09-09112.960000113.270000112.265000112.46000076371991.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-092026-09-09 17:302026-09-09 17:30
XLY2026-09-08114.470000114.630000113.750000113.99000078212021.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-082026-09-08 21:562026-09-08 21:56
XLY2026-09-04115.260000115.740000114.460000114.91000051202361.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-09-03115.930000117.065000115.830000116.46000056587031.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-09-02114.990000115.110000114.250000114.86000042386021.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-09-01115.420000115.615000114.320000114.59000058833101.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-31116.560000117.140000116.290000116.59000049127441.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-28116.710000117.570000116.375000117.21000045057561.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-27116.540000116.620000115.810000115.88000052316091.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-26117.690000117.840000116.745000117.16000032717011.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-25118.410000118.570000117.745000117.95000041564011.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-24118.380000118.790000118.070000118.30000046624211.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-21117.440000118.430000116.740000118.02000065614101.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-20117.050000117.400000116.375000116.68000051560141.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-19116.900000119.060000116.730000118.59000075264071.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-18116.700000117.580000116.070000116.36000052870151.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-17117.960000117.960000116.494100116.75000068849141.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-14118.470000119.175000118.090000118.20000038392771.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-13118.040000118.930000117.885000118.45000045210721.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-12119.320000119.320000117.550000117.89000044869351.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-11119.670000119.960000119.110000119.24000037886301.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-10119.225000119.855000118.860000119.67000044661971.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-07118.520000120.435000118.497300119.86000050773651.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-06118.610000118.795000117.705000118.10000048278971.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-05119.280000119.640000118.070000118.64000061174851.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-04117.530000118.565000117.120000118.290000105009471.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-08-03117.640000119.120000117.640000118.210000100415031.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-31115.440000116.390000114.970000116.090000131580761.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-30112.170000112.795000111.460000112.39000080745611.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-29111.950000113.590000111.440000111.61000075343951.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-28111.660000112.530000111.250000112.48000060181391.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-27110.870000111.360000110.300000110.84000069793581.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-24109.100000109.935000108.650000109.41000082108261.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-23110.480000110.590000108.290000108.760000126504031.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-22114.900000115.230000113.820000114.02000071063801.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-21114.640000115.170000114.280000114.87000065577981.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-20116.220000116.220000114.380000114.61000078045611.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-17115.910000116.870000115.320000115.440000102751431.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-16117.120000118.215000116.860000117.34000060570411.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-15116.460000117.810000116.455000117.00000090731731.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-14116.010000116.400000115.460000115.90000066693251.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-13117.200000117.520000115.620000116.04000059848581.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04
XLY2026-07-10117.590000117.890000116.480000117.24000059715151.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:042026-09-07 11:04