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:endpoint = /tiingo/daily/ORCL/prices×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
ORCL1987-03-25split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL1987-12-21split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL1989-07-03split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL1993-11-09split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL1995-02-23split1.50000000000000032—["tiingo","yfinance"]{"tiingo":"1.5","yfinance":"1.5"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL1996-04-18split1.50000000000000032—["tiingo","yfinance"]{"tiingo":"1.5","yfinance":"1.5","yfinance_ex_date":"1996-04-17"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL1997-08-18split1.50000000000000032—["tiingo","yfinance"]{"tiingo":"1.5","yfinance":"1.5"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL1999-03-01split1.50000000000000032—["tiingo","yfinance"]{"tiingo":"1.5","yfinance":"1.5"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2000-01-19split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2000-10-13split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2009-04-06cash_dividend———0.0500000000["tiingo"]{"tiingo":"0.05"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2009-07-13cash_dividend———0.0500000000["tiingo"]{"tiingo":"0.05"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2009-10-09cash_dividend———0.0500000000["tiingo"]{"tiingo":"0.05"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2010-01-14cash_dividend———0.0500000000["tiingo"]{"tiingo":"0.05"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2010-04-12cash_dividend———0.0500000000["tiingo"]{"tiingo":"0.05"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2010-07-12cash_dividend———0.0500000000["tiingo"]{"tiingo":"0.05"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2010-10-04cash_dividend———0.0500000000["tiingo"]{"tiingo":"0.05"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2011-01-14cash_dividend———0.0500000000["tiingo"]{"tiingo":"0.05"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2011-04-11cash_dividend———0.0600000000["tiingo"]{"tiingo":"0.06"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2011-07-11cash_dividend———0.0600000000["tiingo"]{"tiingo":"0.06"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2011-10-07cash_dividend———0.0600000000["tiingo"]{"tiingo":"0.06"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2012-01-09cash_dividend———0.0600000000["tiingo"]{"tiingo":"0.06"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2012-04-09cash_dividend———0.0600000000["tiingo"]{"tiingo":"0.06"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2012-07-11cash_dividend———0.0600000000["tiingo"]{"tiingo":"0.06"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2012-10-10cash_dividend———0.0600000000["tiingo"]{"tiingo":"0.06"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2012-12-12cash_dividend———0.1800000000["tiingo"]{"tiingo":"0.18"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2013-07-10cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2013-10-04cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2014-01-03cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2014-04-04cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2014-07-07cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2014-10-06cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2015-01-05cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2015-04-02cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2015-07-06cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2015-10-09cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2016-01-04cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2016-04-12cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2016-07-01cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2016-10-07cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2017-01-03cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2017-04-10cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2017-07-17cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2017-10-10cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2018-01-09cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2018-04-16cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2018-07-16cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2018-10-15cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2019-01-15cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2019-04-10cash_dividend———0.2400000000["tiingo"]{"tiingo":"0.24"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29