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
tiingo_prices3,253 rowsexportable
active: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.
| symboltext | ex_date ↓date | action_typetext | ratio_rawnumeric | ratio_numbigint | ratio_denbigint | div_cashnumeric | vendorsARRAY | vendor_valuesjsonb | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CAT | 2026-07-20 | cash_dividend | — | — | — | 1.6300000000 | ["tiingo"] | {"tiingo":"1.63"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2026-04-20 | cash_dividend | — | — | — | 1.5100000000 | ["tiingo"] | {"tiingo":"1.51"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2026-01-20 | cash_dividend | — | — | — | 1.5100000000 | ["tiingo"] | {"tiingo":"1.51"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2025-10-20 | cash_dividend | — | — | — | 1.5100000000 | ["tiingo"] | {"tiingo":"1.51"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2025-07-21 | cash_dividend | — | — | — | 1.5100000000 | ["tiingo"] | {"tiingo":"1.51"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2025-04-21 | cash_dividend | — | — | — | 1.4100000000 | ["tiingo"] | {"tiingo":"1.41"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2025-01-21 | cash_dividend | — | — | — | 1.4100000000 | ["tiingo"] | {"tiingo":"1.41"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2024-10-21 | cash_dividend | — | — | — | 1.4100000000 | ["tiingo"] | {"tiingo":"1.41"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2024-07-22 | cash_dividend | — | — | — | 1.4100000000 | ["tiingo"] | {"tiingo":"1.41"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2024-04-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 |
| CAT | 2024-01-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 |
| CAT | 2023-10-20 | 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 |
| 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 |
| 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 |
| CAT | 2023-01-19 | 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 |
| CAT | 2022-10-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 |
| CAT | 2022-07-19 | 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 |
| CAT | 2022-04-22 | cash_dividend | — | — | — | 1.1100000000 | ["tiingo"] | {"tiingo":"1.11"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2022-01-19 | cash_dividend | — | — | — | 1.1100000000 | ["tiingo"] | {"tiingo":"1.11"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2021-10-22 | cash_dividend | — | — | — | 1.1100000000 | ["tiingo"] | {"tiingo":"1.11"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2021-07-19 | cash_dividend | — | — | — | 1.1100000000 | ["tiingo"] | {"tiingo":"1.11"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2021-04-23 | cash_dividend | — | — | — | 1.0300000000 | ["tiingo"] | {"tiingo":"1.03"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2021-01-19 | cash_dividend | — | — | — | 1.0300000000 | ["tiingo"] | {"tiingo":"1.03"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2020-10-23 | cash_dividend | — | — | — | 1.0300000000 | ["tiingo"] | {"tiingo":"1.03"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2020-07-17 | cash_dividend | — | — | — | 1.0300000000 | ["tiingo"] | {"tiingo":"1.03"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2020-04-17 | cash_dividend | — | — | — | 1.0300000000 | ["tiingo"] | {"tiingo":"1.03"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2020-01-17 | cash_dividend | — | — | — | 1.0300000000 | ["tiingo"] | {"tiingo":"1.03"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2019-10-18 | cash_dividend | — | — | — | 1.0300000000 | ["tiingo"] | {"tiingo":"1.03"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2019-07-19 | cash_dividend | — | — | — | 1.0300000000 | ["tiingo"] | {"tiingo":"1.03"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2019-04-18 | cash_dividend | — | — | — | 0.8600000000 | ["tiingo"] | {"tiingo":"0.86"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2019-01-18 | cash_dividend | — | — | — | 0.8600000000 | ["tiingo"] | {"tiingo":"0.86"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2018-10-19 | cash_dividend | — | — | — | 0.8600000000 | ["tiingo"] | {"tiingo":"0.86"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2018-07-19 | cash_dividend | — | — | — | 0.8600000000 | ["tiingo"] | {"tiingo":"0.86"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2018-04-20 | cash_dividend | — | — | — | 0.7800000000 | ["tiingo"] | {"tiingo":"0.78"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2018-01-19 | cash_dividend | — | — | — | 0.7800000000 | ["tiingo"] | {"tiingo":"0.78"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2017-10-20 | cash_dividend | — | — | — | 0.7800000000 | ["tiingo"] | {"tiingo":"0.78"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2017-07-18 | cash_dividend | — | — | — | 0.7800000000 | ["tiingo"] | {"tiingo":"0.78"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2017-04-20 | cash_dividend | — | — | — | 0.7700000000 | ["tiingo"] | {"tiingo":"0.77"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2017-01-18 | cash_dividend | — | — | — | 0.7700000000 | ["tiingo"] | {"tiingo":"0.77"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2016-10-20 | cash_dividend | — | — | — | 0.7700000000 | ["tiingo"] | {"tiingo":"0.77"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2016-07-18 | cash_dividend | — | — | — | 0.7700000000 | ["tiingo"] | {"tiingo":"0.77"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2016-04-21 | cash_dividend | — | — | — | 0.7700000000 | ["tiingo"] | {"tiingo":"0.77"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2016-01-15 | cash_dividend | — | — | — | 0.7700000000 | ["tiingo"] | {"tiingo":"0.77"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2015-10-22 | cash_dividend | — | — | — | 0.7700000000 | ["tiingo"] | {"tiingo":"0.77"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2015-07-16 | cash_dividend | — | — | — | 0.7700000000 | ["tiingo"] | {"tiingo":"0.77"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2015-04-16 | cash_dividend | — | — | — | 0.7000000000 | ["tiingo"] | {"tiingo":"0.7"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2015-01-15 | cash_dividend | — | — | — | 0.7000000000 | ["tiingo"] | {"tiingo":"0.7"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2014-10-16 | cash_dividend | — | — | — | 0.7000000000 | ["tiingo"] | {"tiingo":"0.7"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2014-07-17 | cash_dividend | — | — | — | 0.7000000000 | ["tiingo"] | {"tiingo":"0.7"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2014-04-16 | cash_dividend | — | — | — | 0.6000000000 | ["tiingo"] | {"tiingo":"0.6"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |