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 = XLI×
symboltextsession_date ↓dateopennumerichighnumericlownumericclosenumericvolumebigintsplit_factornumericdiv_cashnumericsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
XLI2026-09-18169.000000169.920000168.480000169.75000085199521.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-182026-09-18 18:052026-09-18 18:05
XLI2026-09-17171.510000171.510000168.660000169.01000057850411.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-172026-09-17 18:052026-09-17 18:05
XLI2026-09-16169.610000170.680000167.490000168.71000088850981.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-162026-09-16 18:052026-09-16 18:05
XLI2026-09-15170.470000171.030000168.420000168.85000088415331.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-152026-09-15 17:302026-09-15 17:30
XLI2026-09-14168.670000170.135000168.340000169.93000073095821.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-142026-09-14 17:302026-09-14 17:30
XLI2026-09-11172.450000172.915000171.870000172.37000055624491.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-112026-09-11 17:302026-09-11 17:30
XLI2026-09-10170.830000171.680000170.000000170.55000076902491.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-102026-09-10 17:302026-09-10 17:30
XLI2026-09-09173.530000174.160000171.710000171.79000063740771.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-092026-09-09 17:302026-09-09 17:30
XLI2026-09-08175.140000175.710000174.270000174.42000062254671.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-082026-09-08 21:562026-09-08 21:56
XLI2026-09-04174.340000175.775000174.100000175.27000058419471.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-09-03173.760000174.560000172.020000174.56000083406461.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-09-02173.340000173.340000171.615000172.780000108310201.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-09-01174.340000175.440000172.145000172.73000091430821.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-31176.090000176.255000174.730000175.13000073622711.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-28179.440000179.520000176.650000177.14000082356191.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-27180.470000180.490000178.180000178.80000054649091.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-26178.900000180.900000178.900000180.34000081426081.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-25180.760000180.960000178.160000178.40000065670701.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-24180.090000180.300000178.355000179.00000052429091.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-21180.950000181.240000179.790000180.25000054712431.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-20181.010000182.030000179.550000179.77000064978231.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-19184.240000184.620000181.720000181.95000083121341.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-18185.210000185.575000183.505000183.57000046467761.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-17186.390000187.390000186.180000186.32000053631531.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-14186.180000186.880000185.600100186.51000035903731.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-13186.480000186.670000184.740000185.79000049425591.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-12187.170000187.410000185.150000185.88000040521411.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-11185.080000187.260000185.030000185.70000048939031.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-10185.930000185.930000184.370000184.60000034386961.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-07185.450000185.870000183.990000185.18000061702311.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-06186.700000187.460000184.500000184.76000055205991.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-05186.580000188.190000185.990000186.35000056410641.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-04185.640000186.870000183.280000186.400000104979571.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-08-03180.460000183.347000180.100000183.16000088140291.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-31180.500000180.924400177.890000179.84000072062701.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-30178.930000179.100000175.960000178.39000073681721.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-29181.000000181.440000176.350000176.66000095070731.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-28182.630000182.950000181.440000182.49000057086781.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-27183.620000184.420000180.840000183.20000061957371.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-24181.920000183.900000181.740000182.66000055077181.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-23179.090000182.980000179.090000181.94000085560331.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-22178.200000179.840000178.140000178.85000043501961.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-21179.510000179.940000177.760000178.66000048360721.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-20180.610000181.265000177.590000178.12000060446191.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-17178.260000181.460000177.600000179.41000080617431.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-16178.790000180.560000178.550000180.15000060931691.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-15180.780000181.020000177.780000180.06000074917271.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-14181.670000182.510000179.860000180.45000066728781.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-13181.520000182.180000179.800000180.37000053848991.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
XLI2026-07-10181.150000182.580000180.160000181.92000053158281.0000000000000000.0000000000tiingo_prices/tiingo/daily/XLI/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03