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×symbol = CAT×

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
CAT2026-07-20cash_dividend———1.6300000000["tiingo"]{"tiingo":"1.63"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2026-04-20cash_dividend———1.5100000000["tiingo"]{"tiingo":"1.51"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2026-01-20cash_dividend———1.5100000000["tiingo"]{"tiingo":"1.51"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2025-10-20cash_dividend———1.5100000000["tiingo"]{"tiingo":"1.51"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2025-07-21cash_dividend———1.5100000000["tiingo"]{"tiingo":"1.51"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2025-04-21cash_dividend———1.4100000000["tiingo"]{"tiingo":"1.41"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2025-01-21cash_dividend———1.4100000000["tiingo"]{"tiingo":"1.41"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2024-10-21cash_dividend———1.4100000000["tiingo"]{"tiingo":"1.41"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2024-07-22cash_dividend———1.4100000000["tiingo"]{"tiingo":"1.41"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2024-04-19cash_dividend———1.3000000000["tiingo"]{"tiingo":"1.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2024-01-19cash_dividend———1.3000000000["tiingo"]{"tiingo":"1.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2023-10-20cash_dividend———1.3000000000["tiingo"]{"tiingo":"1.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2023-07-19cash_dividend———1.3000000000["tiingo"]{"tiingo":"1.3"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2023-04-21cash_dividend———1.2000000000["tiingo"]{"tiingo":"1.2"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2023-01-19cash_dividend———1.2000000000["tiingo"]{"tiingo":"1.2"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2022-10-21cash_dividend———1.2000000000["tiingo"]{"tiingo":"1.2"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2022-07-19cash_dividend———1.2000000000["tiingo"]{"tiingo":"1.2"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2022-04-22cash_dividend———1.1100000000["tiingo"]{"tiingo":"1.11"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2022-01-19cash_dividend———1.1100000000["tiingo"]{"tiingo":"1.11"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2021-10-22cash_dividend———1.1100000000["tiingo"]{"tiingo":"1.11"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2021-07-19cash_dividend———1.1100000000["tiingo"]{"tiingo":"1.11"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2021-04-23cash_dividend———1.0300000000["tiingo"]{"tiingo":"1.03"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2021-01-19cash_dividend———1.0300000000["tiingo"]{"tiingo":"1.03"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2020-10-23cash_dividend———1.0300000000["tiingo"]{"tiingo":"1.03"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2020-07-17cash_dividend———1.0300000000["tiingo"]{"tiingo":"1.03"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2020-04-17cash_dividend———1.0300000000["tiingo"]{"tiingo":"1.03"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2020-01-17cash_dividend———1.0300000000["tiingo"]{"tiingo":"1.03"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2019-10-18cash_dividend———1.0300000000["tiingo"]{"tiingo":"1.03"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2019-07-19cash_dividend———1.0300000000["tiingo"]{"tiingo":"1.03"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2019-04-18cash_dividend———0.8600000000["tiingo"]{"tiingo":"0.86"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2019-01-18cash_dividend———0.8600000000["tiingo"]{"tiingo":"0.86"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2018-10-19cash_dividend———0.8600000000["tiingo"]{"tiingo":"0.86"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2018-07-19cash_dividend———0.8600000000["tiingo"]{"tiingo":"0.86"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2018-04-20cash_dividend———0.7800000000["tiingo"]{"tiingo":"0.78"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2018-01-19cash_dividend———0.7800000000["tiingo"]{"tiingo":"0.78"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2017-10-20cash_dividend———0.7800000000["tiingo"]{"tiingo":"0.78"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2017-07-18cash_dividend———0.7800000000["tiingo"]{"tiingo":"0.78"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2017-04-20cash_dividend———0.7700000000["tiingo"]{"tiingo":"0.77"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2017-01-18cash_dividend———0.7700000000["tiingo"]{"tiingo":"0.77"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2016-10-20cash_dividend———0.7700000000["tiingo"]{"tiingo":"0.77"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2016-07-18cash_dividend———0.7700000000["tiingo"]{"tiingo":"0.77"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2016-04-21cash_dividend———0.7700000000["tiingo"]{"tiingo":"0.77"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2016-01-15cash_dividend———0.7700000000["tiingo"]{"tiingo":"0.77"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2015-10-22cash_dividend———0.7700000000["tiingo"]{"tiingo":"0.77"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2015-07-16cash_dividend———0.7700000000["tiingo"]{"tiingo":"0.77"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2015-04-16cash_dividend———0.7000000000["tiingo"]{"tiingo":"0.7"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2015-01-15cash_dividend———0.7000000000["tiingo"]{"tiingo":"0.7"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2014-10-16cash_dividend———0.7000000000["tiingo"]{"tiingo":"0.7"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2014-07-17cash_dividend———0.7000000000["tiingo"]{"tiingo":"0.7"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
CAT2014-04-16cash_dividend———0.6000000000["tiingo"]{"tiingo":"0.6"}tiingo_prices/tiingo/daily/CAT/prices{}2026-09-072026-09-07 13:292026-09-07 13:29