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

tiingo_prices3,264 rowsexportable

active:symbol = AAPL×

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

symboltext	ex_date ↓date	action_typetext	ratio_rawnumeric	ratio_numbigint	ratio_denbigint	div_cashnumeric	vendorsARRAY	vendor_valuesjsonb	source

AAPL	2014-06-09	split	7.000007000000000	7	1	—	["tiingo","yfinance"]	{"tiingo":"7.000007","yfinance":"7.0"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	2014-05-08	cash_dividend	—	—	—	3.2900000000	["tiingo"]	{"tiingo":"3.29"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	2014-02-06	cash_dividend	—	—	—	3.0500000000	["tiingo"]	{"tiingo":"3.05"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	2013-11-06	cash_dividend	—	—	—	3.0500000000	["tiingo"]	{"tiingo":"3.05"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	2013-08-08	cash_dividend	—	—	—	3.0500000000	["tiingo"]	{"tiingo":"3.05"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	2013-05-09	cash_dividend	—	—	—	3.0500000000	["tiingo"]	{"tiingo":"3.05"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	2013-02-07	cash_dividend	—	—	—	2.6500000000	["tiingo"]	{"tiingo":"2.65"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	2012-11-07	cash_dividend	—	—	—	2.6500000000	["tiingo"]	{"tiingo":"2.65"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	2012-08-09	cash_dividend	—	—	—	2.6500000000	["tiingo"]	{"tiingo":"2.65"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	2005-02-28	split	2.000000000000000	2	1	—	["tiingo","yfinance"]	{"tiingo":"2.0","yfinance":"2.0"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	2000-06-21	split	2.000000000000000	2	1	—	["tiingo","yfinance"]	{"tiingo":"2.0","yfinance":"2.0"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1995-11-21	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1995-08-16	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1995-05-26	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1995-02-13	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1994-11-18	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1994-08-15	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1994-05-27	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1994-02-07	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1993-11-19	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1993-08-16	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1993-05-28	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1993-02-12	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1992-11-30	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1992-08-17	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1992-06-01	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1992-02-14	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1991-11-18	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1991-08-19	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1991-05-20	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1991-02-15	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1990-11-16	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1990-08-20	cash_dividend	—	—	—	0.1100000000	["tiingo"]	{"tiingo":"0.11"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1990-05-21	cash_dividend	—	—	—	0.1100000000	["tiingo"]	{"tiingo":"0.11"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1990-02-16	cash_dividend	—	—	—	0.1100000000	["tiingo"]	{"tiingo":"0.11"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1989-11-17	cash_dividend	—	—	—	0.1100000000	["tiingo"]	{"tiingo":"0.11"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1989-08-21	cash_dividend	—	—	—	0.1000000000	["tiingo"]	{"tiingo":"0.1"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1989-05-22	cash_dividend	—	—	—	0.1000000000	["tiingo"]	{"tiingo":"0.1"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1989-02-17	cash_dividend	—	—	—	0.1000000000	["tiingo"]	{"tiingo":"0.1"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1988-11-21	cash_dividend	—	—	—	0.1000000000	["tiingo"]	{"tiingo":"0.1"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1988-08-15	cash_dividend	—	—	—	0.0800000000	["tiingo"]	{"tiingo":"0.08"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1988-05-16	cash_dividend	—	—	—	0.0800000000	["tiingo"]	{"tiingo":"0.08"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1988-02-12	cash_dividend	—	—	—	0.0800000000	["tiingo"]	{"tiingo":"0.08"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1987-11-17	cash_dividend	—	—	—	0.0800000000	["tiingo"]	{"tiingo":"0.08"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
AAPL	1987-06-16	split	2.000000000000000	2	1	—	["tiingo","yfinance"]	{"tiingo":"2.0","yfinance":"2.0"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28