Simplify Analytics
← Data Explorer

Corporate actions

core.corporate_actions

Splits, cash dividends and price factors. The second half of the PIT price spine - these are what core.prices_asof() applies.

3,253 rowsCSV — whole table, not this view

Sources in this table

ex_dateto
column equals (exact text)
sort
chart against ex_date
reset
active:symbol = MSFT×sorted by ex_date ↑×

ex_date leads no index, so this sort reads every matching row and keeps only the top 50 in a heap (the page LIMIT), under a 5s statement timeout.

symboltextex_date ↑dateaction_typetextratio_rawnumericratio_numbigintratio_denbigintdiv_cashnumericvendorsARRAYvendor_valuesjsonbsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
MSFT1987-09-21split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT1990-04-16split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT1991-06-27split1.50000000000000032—["tiingo","yfinance"]{"tiingo":"1.5","yfinance":"1.5"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT1992-06-15split1.50000000000000032—["tiingo","yfinance"]{"tiingo":"1.5","yfinance":"1.5"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT1994-05-23split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT1996-12-09split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT1998-02-23split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT1999-03-29split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2003-02-18split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2003-02-19cash_dividend———0.0800000000["tiingo"]{"tiingo":"0.08"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2003-10-15cash_dividend———0.1600000000["tiingo"]{"tiingo":"0.16"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2004-08-23cash_dividend———0.0800000000["tiingo"]{"tiingo":"0.08"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2004-11-15cash_dividend———3.0800000000["tiingo"]{"tiingo":"3.08"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2005-02-15cash_dividend———0.0800000000["tiingo"]{"tiingo":"0.08"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2005-05-16cash_dividend———0.0800000000["tiingo"]{"tiingo":"0.08"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2005-08-15cash_dividend———0.0800000000["tiingo"]{"tiingo":"0.08"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2005-11-15cash_dividend———0.0800000000["tiingo"]{"tiingo":"0.08"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2006-02-15cash_dividend———0.0900000000["tiingo"]{"tiingo":"0.09"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2006-05-15cash_dividend———0.0900000000["tiingo"]{"tiingo":"0.09"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2006-08-15cash_dividend———0.0900000000["tiingo"]{"tiingo":"0.09"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2006-11-14cash_dividend———0.1000000000["tiingo"]{"tiingo":"0.1"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2007-02-13cash_dividend———0.1000000000["tiingo"]{"tiingo":"0.1"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2007-05-15cash_dividend———0.1000000000["tiingo"]{"tiingo":"0.1"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2007-08-14cash_dividend———0.1000000000["tiingo"]{"tiingo":"0.1"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2007-11-13cash_dividend———0.1100000000["tiingo"]{"tiingo":"0.11"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2008-02-19cash_dividend———0.1100000000["tiingo"]{"tiingo":"0.11"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2008-05-13cash_dividend———0.1100000000["tiingo"]{"tiingo":"0.11"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2008-08-19cash_dividend———0.1100000000["tiingo"]{"tiingo":"0.11"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2008-11-18cash_dividend———0.1300000000["tiingo"]{"tiingo":"0.13"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2009-02-17cash_dividend———0.1300000000["tiingo"]{"tiingo":"0.13"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2009-05-19cash_dividend———0.1300000000["tiingo"]{"tiingo":"0.13"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2009-08-18cash_dividend———0.1300000000["tiingo"]{"tiingo":"0.13"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2009-11-17cash_dividend———0.1300000000["tiingo"]{"tiingo":"0.13"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2010-02-16cash_dividend———0.1300000000["tiingo"]{"tiingo":"0.13"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2010-05-18cash_dividend———0.1300000000["tiingo"]{"tiingo":"0.13"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2010-08-17cash_dividend———0.1300000000["tiingo"]{"tiingo":"0.13"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2010-11-16cash_dividend———0.1600000000["tiingo"]{"tiingo":"0.16"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2011-02-15cash_dividend———0.1600000000["tiingo"]{"tiingo":"0.16"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2011-05-17cash_dividend———0.1600000000["tiingo"]{"tiingo":"0.16"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2011-08-16cash_dividend———0.1600000000["tiingo"]{"tiingo":"0.16"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2011-11-15cash_dividend———0.2000000000["tiingo"]{"tiingo":"0.2"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2012-02-14cash_dividend———0.2000000000["tiingo"]{"tiingo":"0.2"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2012-05-15cash_dividend———0.2000000000["tiingo"]{"tiingo":"0.2"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2012-08-14cash_dividend———0.2000000000["tiingo"]{"tiingo":"0.2"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2012-11-13cash_dividend———0.2300000000["tiingo"]{"tiingo":"0.23"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2013-02-19cash_dividend———0.2300000000["tiingo"]{"tiingo":"0.23"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2013-05-14cash_dividend———0.2300000000["tiingo"]{"tiingo":"0.23"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2013-08-13cash_dividend———0.2300000000["tiingo"]{"tiingo":"0.23"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2013-11-19cash_dividend———0.2800000000["tiingo"]{"tiingo":"0.28"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
MSFT2014-02-18cash_dividend———0.2800000000["tiingo"]{"tiingo":"0.28"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29