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 = ORCL×

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

ORCL	2014-01-03	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2013-10-04	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2013-07-10	cash_dividend	—	—	—	0.1200000000	["tiingo"]	{"tiingo":"0.12"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2012-12-12	cash_dividend	—	—	—	0.1800000000	["tiingo"]	{"tiingo":"0.18"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2012-10-10	cash_dividend	—	—	—	0.0600000000	["tiingo"]	{"tiingo":"0.06"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2012-07-11	cash_dividend	—	—	—	0.0600000000	["tiingo"]	{"tiingo":"0.06"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2012-04-09	cash_dividend	—	—	—	0.0600000000	["tiingo"]	{"tiingo":"0.06"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2012-01-09	cash_dividend	—	—	—	0.0600000000	["tiingo"]	{"tiingo":"0.06"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2011-10-07	cash_dividend	—	—	—	0.0600000000	["tiingo"]	{"tiingo":"0.06"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2011-07-11	cash_dividend	—	—	—	0.0600000000	["tiingo"]	{"tiingo":"0.06"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2011-04-11	cash_dividend	—	—	—	0.0600000000	["tiingo"]	{"tiingo":"0.06"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2011-01-14	cash_dividend	—	—	—	0.0500000000	["tiingo"]	{"tiingo":"0.05"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2010-10-04	cash_dividend	—	—	—	0.0500000000	["tiingo"]	{"tiingo":"0.05"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2010-07-12	cash_dividend	—	—	—	0.0500000000	["tiingo"]	{"tiingo":"0.05"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2010-04-12	cash_dividend	—	—	—	0.0500000000	["tiingo"]	{"tiingo":"0.05"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2010-01-14	cash_dividend	—	—	—	0.0500000000	["tiingo"]	{"tiingo":"0.05"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2009-10-09	cash_dividend	—	—	—	0.0500000000	["tiingo"]	{"tiingo":"0.05"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2009-07-13	cash_dividend	—	—	—	0.0500000000	["tiingo"]	{"tiingo":"0.05"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2009-04-06	cash_dividend	—	—	—	0.0500000000	["tiingo"]	{"tiingo":"0.05"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2000-10-13	split	2.000000000000000	2	1	—	["tiingo","yfinance"]	{"tiingo":"2.0","yfinance":"2.0"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2000-01-19	split	2.000000000000000	2	1	—	["tiingo","yfinance"]	{"tiingo":"2.0","yfinance":"2.0"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	1999-03-01	split	1.500000000000000	3	2	—	["tiingo","yfinance"]	{"tiingo":"1.5","yfinance":"1.5"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	1997-08-18	split	1.500000000000000	3	2	—	["tiingo","yfinance"]	{"tiingo":"1.5","yfinance":"1.5"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	1996-04-18	split	1.500000000000000	3	2	—	["tiingo","yfinance"]	{"tiingo":"1.5","yfinance":"1.5","yfinance_ex_date":"1996-04-17"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	1995-02-23	split	1.500000000000000	3	2	—	["tiingo","yfinance"]	{"tiingo":"1.5","yfinance":"1.5"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	1993-11-09	split	2.000000000000000	2	1	—	["tiingo","yfinance"]	{"tiingo":"2.0","yfinance":"2.0"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	1989-07-03	split	2.000000000000000	2	1	—	["tiingo","yfinance"]	{"tiingo":"2.0","yfinance":"2.0"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	1987-12-21	split	2.000000000000000	2	1	—	["tiingo","yfinance"]	{"tiingo":"2.0","yfinance":"2.0"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	1987-03-25	split	2.000000000000000	2	1	—	["tiingo","yfinance"]	{"tiingo":"2.0","yfinance":"2.0"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29