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/SPY/prices×source = tiingo_prices×
symboltextsession_date ↓dateopennumerichighnumericlownumericclosenumericvolumebigintsplit_factornumericdiv_cashnumericsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
SPY2026-07-09747.350000751.970000745.590000751.710000414417181.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-07-08743.160000746.150000739.510000745.400000437673931.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-07-07750.220000750.960000745.210000747.710000437214941.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-07-06748.740000752.410000747.410000751.280000506733101.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-07-02747.400000751.310000740.030000744.780000575059531.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-07-01745.000000749.435000742.375000745.760000471008781.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-30741.290000748.020000740.890000746.770000556260351.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-29736.525000741.560000732.090000741.000000580352281.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-26728.945000736.530000716.580000728.990000710339691.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-25738.910000739.370000729.600000734.300000541280651.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-24735.170000739.945000730.840000733.240000574395071.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-23733.810000739.630000732.300000733.580000668467801.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-22747.700000750.180000743.130000744.390000466280741.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-18747.760000748.230000743.860000746.740000808756571.0000000000000001.9035160000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-17751.290000752.150000739.220000740.960000859452271.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-16754.550000755.440000749.880000750.330000670931421.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-15751.850000756.680000751.760000754.830000601764251.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-12740.710000744.440000735.030000741.750000570795331.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-11728.760000740.000000724.405000737.760000863305221.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-10733.390000738.380000725.330000725.430000603413491.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-09743.630000746.900000722.590000737.050000876835171.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-08743.360000745.340000738.190000739.220000493191441.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-05752.310000752.820000735.525000737.550000939894161.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-04752.100000758.310000751.470000757.090000499230361.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-03758.150000758.800000753.570000754.240000514025181.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-02757.030000760.400000756.750000759.570000315818521.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-06-01755.360000760.280000754.690000758.540000436349331.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-29755.900000758.080000754.690000756.480000550757391.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-28750.250000755.150000749.230000754.600000415625631.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-27750.880000751.380000748.220000750.460000421062851.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-26750.010000752.130000748.370000750.590000411236211.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-22746.240000748.940000744.480000745.640000417620061.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-21738.640000744.870000737.030000742.720000433322251.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-20735.710000741.870000733.890000741.250000433815001.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-19734.780000737.650000731.530000733.730000542559131.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-18739.830000741.415000733.390000738.650000478438651.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-15741.790000743.460000737.960000739.170000604107711.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-14743.650000749.530000743.560000748.170000453076031.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-13738.470000743.910000735.470000742.310000442002031.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-12736.890000738.840000731.830000738.180000541852731.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-11736.450000740.790000736.450000739.300000440239511.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-08734.930000738.080000734.570000737.620000472270851.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-07735.050000736.130000729.750000731.580000517246421.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-06728.160000734.590000727.820000733.830000532889401.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-05721.770000725.040000721.489800723.770000369332261.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-04720.070000722.120000714.990000718.010000519505581.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-05-01721.250000724.870000720.470000720.650000430498491.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-04-30714.630000719.790000710.445000718.660000672409491.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-04-29711.000000712.200000708.370000711.580000418592271.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03
SPY2026-04-28711.815000712.880000709.250000711.690000431174361.0000000000000000.0000000000tiingo_prices/tiingo/daily/SPY/prices{"format":"json","startDate":null}2026-09-072026-09-07 11:032026-09-07 11:03