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:source = tiingo_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
CAT1964-07-06split2.00000000000000021—["yfinance"]{"yfinance":"2.0"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
DE1972-09-22split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/DE/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
XOM1976-07-26split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
CAT1976-07-26split1.50000000000000032—["tiingo","yfinance"]{"tiingo":"1.5","yfinance":"1.5"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
DE1976-09-22split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/DE/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
INTC1980-10-09split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/INTC/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
AMD1980-10-24split2.00000000000000021—["yfinance"]{"yfinance":"2.0"}tiingo_prices/tiingo/daily/AMD/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
XOM1981-06-12split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
AMD1982-10-28split1.50000000000000032—["yfinance"]{"yfinance":"1.5"}tiingo_prices/tiingo/daily/AMD/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
INTC1983-07-01split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/INTC/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
AMD1983-08-23split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/AMD/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
LMT1983-09-09split3.00000000000000031—["yfinance"]{"yfinance":"3.0"}tiingo_prices/tiingo/daily/LMT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
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
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
XOM1987-09-15split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
MSFT1987-09-21split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/MSFT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1987-10-20cash_dividend———0.1250000000["tiingo"]{"tiingo":"0.125"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
INTC1987-10-26split1.50000000000000032—["tiingo","yfinance"]{"tiingo":"1.5","yfinance":"1.5","yfinance_ex_date":"1987-10-29"}tiingo_prices/tiingo/daily/INTC/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
XOM1987-11-05cash_dividend———0.5000000000["tiingo"]{"tiingo":"0.5"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
LMT1987-11-12cash_dividend———0.2150000000["tiingo"]{"tiingo":"0.215"}tiingo_prices/tiingo/daily/LMT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
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
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
DE1987-12-24cash_dividend———0.1250000000["tiingo"]{"tiingo":"0.125"}tiingo_prices/tiingo/daily/DE/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1988-01-13cash_dividend———0.1880000000["tiingo"]{"tiingo":"0.188"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
XOM1988-02-05cash_dividend———0.5000000000["tiingo"]{"tiingo":"0.5"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
LMT1988-02-10cash_dividend———0.2150000000["tiingo"]{"tiingo":"0.215"}tiingo_prices/tiingo/daily/LMT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
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
DE1988-03-25cash_dividend———0.1250000000["tiingo"]{"tiingo":"0.125"}tiingo_prices/tiingo/daily/DE/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1988-04-19cash_dividend———0.1880000000["tiingo"]{"tiingo":"0.188"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
XOM1988-05-09cash_dividend———0.5500000000["tiingo"]{"tiingo":"0.55"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
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
LMT1988-05-18cash_dividend———0.2450000000["tiingo"]{"tiingo":"0.245"}tiingo_prices/tiingo/daily/LMT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
DE1988-06-24cash_dividend———0.2000000000["tiingo"]{"tiingo":"0.2"}tiingo_prices/tiingo/daily/DE/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1988-07-14cash_dividend———0.1880000000["tiingo"]{"tiingo":"0.188"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
XOM1988-08-09cash_dividend———0.5500000000["tiingo"]{"tiingo":"0.55"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
LMT1988-08-11cash_dividend———0.2450000000["tiingo"]{"tiingo":"0.245"}tiingo_prices/tiingo/daily/LMT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
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
DE1988-09-26cash_dividend———0.2000000000["tiingo"]{"tiingo":"0.2"}tiingo_prices/tiingo/daily/DE/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1988-10-18cash_dividend———0.1880000000["tiingo"]{"tiingo":"0.188"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
XOM1988-11-07cash_dividend———0.5500000000["tiingo"]{"tiingo":"0.55"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
LMT1988-11-15cash_dividend———0.2450000000["tiingo"]{"tiingo":"0.245"}tiingo_prices/tiingo/daily/LMT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
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
DE1988-12-23cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/DE/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1989-01-13cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
XOM1989-02-06cash_dividend———0.5500000000["tiingo"]{"tiingo":"0.55"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
LMT1989-02-14cash_dividend———0.2450000000["tiingo"]{"tiingo":"0.245"}tiingo_prices/tiingo/daily/LMT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
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
DE1989-03-27cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/DE/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1989-04-18cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
XOM1989-05-09cash_dividend———0.5500000000["tiingo"]{"tiingo":"0.55"}tiingo_prices/tiingo/daily/XOM/prices{}2026-09-072026-09-07 13:302026-09-07 13:30