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:source = tiingo_prices×

ex_date leads no index, so this sort reads every matching row and keeps only the top 450 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

AAPL	2023-08-11	cash_dividend	—	—	—	0.2400000000	["tiingo"]	{"tiingo":"0.24"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
INTC	2023-08-04	cash_dividend	—	—	—	0.1250000000	["tiingo"]	{"tiingo":"0.125"}	tiingo_prices	/tiingo/daily/INTC/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
DELL	2023-07-24	cash_dividend	—	—	—	0.3700000000	["tiingo"]	{"tiingo":"0.37"}	tiingo_prices	/tiingo/daily/DELL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
DIA	2023-07-21	cash_dividend	—	—	—	0.2677900000	["tiingo"]	{"tiingo":"0.26779"}	tiingo_prices	/tiingo/daily/DIA/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
CAT	2023-07-19	cash_dividend	—	—	—	1.3000000000	["tiingo"]	{"tiingo":"1.3"}	tiingo_prices	/tiingo/daily/CAT/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2023-07-11	cash_dividend	—	—	—	0.4000000000	["tiingo"]	{"tiingo":"0.4"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
MU	2023-07-07	cash_dividend	—	—	—	0.1150000000	["tiingo"]	{"tiingo":"0.115"}	tiingo_prices	/tiingo/daily/MU/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
MRVL	2023-07-06	cash_dividend	—	—	—	0.0600000000	["tiingo"]	{"tiingo":"0.06"}	tiingo_prices	/tiingo/daily/MRVL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
DE	2023-06-29	cash_dividend	—	—	—	1.2500000000	["tiingo"]	{"tiingo":"1.25"}	tiingo_prices	/tiingo/daily/DE/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
AVGO	2023-06-21	cash_dividend	—	—	—	4.6000000000	["tiingo"]	{"tiingo":"4.6"}	tiingo_prices	/tiingo/daily/AVGO/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
XLY	2023-06-20	cash_dividend	—	—	—	0.3343770000	["tiingo"]	{"tiingo":"0.334377"}	tiingo_prices	/tiingo/daily/XLY/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLV	2023-06-20	cash_dividend	—	—	—	0.5424430000	["tiingo"]	{"tiingo":"0.542443"}	tiingo_prices	/tiingo/daily/XLV/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLU	2023-06-20	cash_dividend	—	—	—	0.5365980000	["tiingo"]	{"tiingo":"0.536598"}	tiingo_prices	/tiingo/daily/XLU/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLP	2023-06-20	cash_dividend	—	—	—	0.5260260000	["tiingo"]	{"tiingo":"0.526026"}	tiingo_prices	/tiingo/daily/XLP/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLK	2023-06-20	cash_dividend	—	—	—	0.3615830000	["tiingo"]	{"tiingo":"0.361583"}	tiingo_prices	/tiingo/daily/XLK/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLI	2023-06-20	cash_dividend	—	—	—	0.4198080000	["tiingo"]	{"tiingo":"0.419808"}	tiingo_prices	/tiingo/daily/XLI/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLF	2023-06-20	cash_dividend	—	—	—	0.1503170000	["tiingo"]	{"tiingo":"0.150317"}	tiingo_prices	/tiingo/daily/XLF/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLE	2023-06-20	cash_dividend	—	—	—	0.7058430000	["tiingo"]	{"tiingo":"0.705843"}	tiingo_prices	/tiingo/daily/XLE/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
STX	2023-06-20	cash_dividend	—	—	—	0.7000000000	["tiingo"]	{"tiingo":"0.7"}	tiingo_prices	/tiingo/daily/STX/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
QQQ	2023-06-20	cash_dividend	—	—	—	0.5039500000	["tiingo"]	{"tiingo":"0.50395"}	tiingo_prices	/tiingo/daily/QQQ/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
SPY	2023-06-16	cash_dividend	—	—	—	1.6383670000	["tiingo"]	{"tiingo":"1.638367"}	tiingo_prices	/tiingo/daily/SPY/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
DIA	2023-06-16	cash_dividend	—	—	—	0.7757100000	["tiingo"]	{"tiingo":"0.77571"}	tiingo_prices	/tiingo/daily/DIA/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
SOXX	2023-06-07	cash_dividend	—	—	—	0.6507090000	["tiingo"]	{"tiingo":"0.650709"}	tiingo_prices	/tiingo/daily/SOXX/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
NVDA	2023-06-07	cash_dividend	—	—	—	0.0400000000	["tiingo"]	{"tiingo":"0.04"}	tiingo_prices	/tiingo/daily/NVDA/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
IWM	2023-06-07	cash_dividend	—	—	—	0.5086750000	["tiingo"]	{"tiingo":"0.508675"}	tiingo_prices	/tiingo/daily/IWM/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
LMT	2023-05-31	cash_dividend	—	—	—	3.0000000000	["tiingo"]	{"tiingo":"3.0"}	tiingo_prices	/tiingo/daily/LMT/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
DIA	2023-05-19	cash_dividend	—	—	—	0.7259800000	["tiingo"]	{"tiingo":"0.72598"}	tiingo_prices	/tiingo/daily/DIA/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
MSFT	2023-05-17	cash_dividend	—	—	—	0.6800000000	["tiingo"]	{"tiingo":"0.68"}	tiingo_prices	/tiingo/daily/MSFT/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
XOM	2023-05-15	cash_dividend	—	—	—	0.9100000000	["tiingo"]	{"tiingo":"0.91"}	tiingo_prices	/tiingo/daily/XOM/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
AAPL	2023-05-12	cash_dividend	—	—	—	0.2400000000	["tiingo"]	{"tiingo":"0.24"}	tiingo_prices	/tiingo/daily/AAPL/prices	{}	2026-09-07	2026-09-07 13:28	2026-09-07 13:28
SMH	2023-05-05	split	2.000000000000000	2	1	—	["tiingo","yfinance"]	{"tiingo":"2.0","yfinance":"2.0"}	tiingo_prices	/tiingo/daily/SMH/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
INTC	2023-05-04	cash_dividend	—	—	—	0.1250000000	["tiingo"]	{"tiingo":"0.125"}	tiingo_prices	/tiingo/daily/INTC/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
DELL	2023-04-24	cash_dividend	—	—	—	0.3700000000	["tiingo"]	{"tiingo":"0.37"}	tiingo_prices	/tiingo/daily/DELL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
DIA	2023-04-21	cash_dividend	—	—	—	0.1843000000	["tiingo"]	{"tiingo":"0.1843"}	tiingo_prices	/tiingo/daily/DIA/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
CAT	2023-04-21	cash_dividend	—	—	—	1.2000000000	["tiingo"]	{"tiingo":"1.2"}	tiingo_prices	/tiingo/daily/CAT/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
ORCL	2023-04-10	cash_dividend	—	—	—	0.4000000000	["tiingo"]	{"tiingo":"0.4"}	tiingo_prices	/tiingo/daily/ORCL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
MU	2023-04-06	cash_dividend	—	—	—	0.1150000000	["tiingo"]	{"tiingo":"0.115"}	tiingo_prices	/tiingo/daily/MU/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
MRVL	2023-04-05	cash_dividend	—	—	—	0.0600000000	["tiingo"]	{"tiingo":"0.06"}	tiingo_prices	/tiingo/daily/MRVL/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
DE	2023-03-30	cash_dividend	—	—	—	1.2500000000	["tiingo"]	{"tiingo":"1.25"}	tiingo_prices	/tiingo/daily/DE/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
SOXX	2023-03-23	cash_dividend	—	—	—	1.0724100000	["tiingo"]	{"tiingo":"1.07241"}	tiingo_prices	/tiingo/daily/SOXX/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
IWM	2023-03-23	cash_dividend	—	—	—	0.6306670000	["tiingo"]	{"tiingo":"0.630667"}	tiingo_prices	/tiingo/daily/IWM/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
STX	2023-03-21	cash_dividend	—	—	—	0.7000000000	["tiingo"]	{"tiingo":"0.7"}	tiingo_prices	/tiingo/daily/STX/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
AVGO	2023-03-21	cash_dividend	—	—	—	4.6000000000	["tiingo"]	{"tiingo":"4.6"}	tiingo_prices	/tiingo/daily/AVGO/prices	{}	2026-09-07	2026-09-07 13:29	2026-09-07 13:29
XLY	2023-03-20	cash_dividend	—	—	—	0.4301670000	["tiingo"]	{"tiingo":"0.430167"}	tiingo_prices	/tiingo/daily/XLY/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLV	2023-03-20	cash_dividend	—	—	—	0.4891370000	["tiingo"]	{"tiingo":"0.489137"}	tiingo_prices	/tiingo/daily/XLV/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLU	2023-03-20	cash_dividend	—	—	—	0.4897460000	["tiingo"]	{"tiingo":"0.489746"}	tiingo_prices	/tiingo/daily/XLU/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLP	2023-03-20	cash_dividend	—	—	—	0.3446610000	["tiingo"]	{"tiingo":"0.344661"}	tiingo_prices	/tiingo/daily/XLP/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLK	2023-03-20	cash_dividend	—	—	—	0.3154520000	["tiingo"]	{"tiingo":"0.315452"}	tiingo_prices	/tiingo/daily/XLK/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLI	2023-03-20	cash_dividend	—	—	—	0.3948550000	["tiingo"]	{"tiingo":"0.394855"}	tiingo_prices	/tiingo/daily/XLI/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30
XLF	2023-03-20	cash_dividend	—	—	—	0.1526100000	["tiingo"]	{"tiingo":"0.15261"}	tiingo_prices	/tiingo/daily/XLF/prices	{}	2026-09-07	2026-09-07 13:30	2026-09-07 13:30