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,264 rowsCSV — whole table, not this view

Sources in this table

ex_dateto
column equals (exact text)
sort
chart against ex_date
reset
active:symbol = AAPL×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
AAPL1987-06-16split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1987-11-17cash_dividend———0.0800000000["tiingo"]{"tiingo":"0.08"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1988-02-12cash_dividend———0.0800000000["tiingo"]{"tiingo":"0.08"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1988-05-16cash_dividend———0.0800000000["tiingo"]{"tiingo":"0.08"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1988-08-15cash_dividend———0.0800000000["tiingo"]{"tiingo":"0.08"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1988-11-21cash_dividend———0.1000000000["tiingo"]{"tiingo":"0.1"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1989-02-17cash_dividend———0.1000000000["tiingo"]{"tiingo":"0.1"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1989-05-22cash_dividend———0.1000000000["tiingo"]{"tiingo":"0.1"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1989-08-21cash_dividend———0.1000000000["tiingo"]{"tiingo":"0.1"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1989-11-17cash_dividend———0.1100000000["tiingo"]{"tiingo":"0.11"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1990-02-16cash_dividend———0.1100000000["tiingo"]{"tiingo":"0.11"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1990-05-21cash_dividend———0.1100000000["tiingo"]{"tiingo":"0.11"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1990-08-20cash_dividend———0.1100000000["tiingo"]{"tiingo":"0.11"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1990-11-16cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1991-02-15cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1991-05-20cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1991-08-19cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1991-11-18cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1992-02-14cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1992-06-01cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1992-08-17cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1992-11-30cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1993-02-12cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1993-05-28cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1993-08-16cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1993-11-19cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1994-02-07cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1994-05-27cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1994-08-15cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1994-11-18cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1995-02-13cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1995-05-26cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1995-08-16cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL1995-11-21cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2000-06-21split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2005-02-28split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2012-08-09cash_dividend———2.6500000000["tiingo"]{"tiingo":"2.65"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2012-11-07cash_dividend———2.6500000000["tiingo"]{"tiingo":"2.65"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2013-02-07cash_dividend———2.6500000000["tiingo"]{"tiingo":"2.65"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2013-05-09cash_dividend———3.0500000000["tiingo"]{"tiingo":"3.05"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2013-08-08cash_dividend———3.0500000000["tiingo"]{"tiingo":"3.05"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2013-11-06cash_dividend———3.0500000000["tiingo"]{"tiingo":"3.05"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2014-02-06cash_dividend———3.0500000000["tiingo"]{"tiingo":"3.05"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2014-05-08cash_dividend———3.2900000000["tiingo"]{"tiingo":"3.29"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2014-06-09split7.00000700000000071—["tiingo","yfinance"]{"tiingo":"7.000007","yfinance":"7.0"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2014-08-07cash_dividend———0.4700000000["tiingo"]{"tiingo":"0.47"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2014-11-06cash_dividend———0.4700000000["tiingo"]{"tiingo":"0.47"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2015-02-05cash_dividend———0.4700000000["tiingo"]{"tiingo":"0.47"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2015-05-07cash_dividend———0.5200000000["tiingo"]{"tiingo":"0.52"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28
AAPL2015-08-06cash_dividend———0.5200000000["tiingo"]{"tiingo":"0.52"}tiingo_prices/tiingo/daily/AAPL/prices{}2026-09-072026-09-07 13:282026-09-07 13:28