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:symbol = CAT×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
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
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
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
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
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
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
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
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
CAT1989-07-14cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1989-10-17cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1990-01-16cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1990-01-18cash_dividend———0.3250000000["tiingo"]{"tiingo":"0.325"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1990-04-17cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1990-07-16cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1990-10-16cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1991-01-15cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1991-04-16cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1991-07-16cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1991-10-15cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1992-01-14cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1992-04-13cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1992-07-14cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1992-10-20cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1993-01-13cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1993-04-20cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1993-07-14cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1993-10-19cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1994-01-13cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1994-04-19cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1994-07-14cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1994-09-06split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1994-10-18cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1995-01-13cash_dividend———0.2500000000["tiingo"]{"tiingo":"0.25"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1995-04-18cash_dividend———0.2500000000["tiingo"]{"tiingo":"0.25"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1995-07-18cash_dividend———0.3500000000["tiingo"]{"tiingo":"0.35"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1995-10-19cash_dividend———0.3500000000["tiingo"]{"tiingo":"0.35"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1996-01-18cash_dividend———0.3500000000["tiingo"]{"tiingo":"0.35"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1996-04-18cash_dividend———0.3500000000["tiingo"]{"tiingo":"0.35"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1996-07-18cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1996-10-17cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1997-01-16cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1997-04-17cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1997-07-14split2.00000000000000021—["tiingo","yfinance"]{"tiingo":"2.0","yfinance":"2.0"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1997-07-17cash_dividend———0.2500000000["tiingo"]{"tiingo":"0.25"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1997-10-16cash_dividend———0.2500000000["tiingo"]{"tiingo":"0.25"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1998-01-15cash_dividend———0.2500000000["tiingo"]{"tiingo":"0.25"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1998-04-16cash_dividend———0.2500000000["tiingo"]{"tiingo":"0.25"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1998-07-16cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT1998-10-22cash_dividend———0.3000000000["tiingo"]{"tiingo":"0.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29