core.corporate_actions
Splits, cash dividends and price factors. The second half of the PIT price spine - these are what core.prices_asof() applies.
Simplify Analyticstiingo_prices3,264 rowsexportableex_date leads no index, so this sort reads every matching row and keeps only the top 100 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 | source |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| CAT | 2014-01-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 |
| CAT | 2013-10-17 | 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 |
| CAT | 2013-07-18 | 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 |
| CAT | 2013-04-18 | cash_dividend | — | — | — | 0.5200000000 | ["tiingo"] | {"tiingo":"0.52"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2012-12-20 | cash_dividend | — | — | — | 0.5200000000 | ["tiingo"] | {"tiingo":"0.52"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2012-10-18 | cash_dividend | — | — | — | 0.5200000000 | ["tiingo"] | {"tiingo":"0.52"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2012-07-18 | cash_dividend | — | — | — | 0.5200000000 | ["tiingo"] | {"tiingo":"0.52"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2012-04-19 | cash_dividend | — | — | — | 0.4600000000 | ["tiingo"] | {"tiingo":"0.46"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2012-01-18 | cash_dividend | — | — | — | 0.4600000000 | ["tiingo"] | {"tiingo":"0.46"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2011-10-20 | cash_dividend | — | — | — | 0.4600000000 | ["tiingo"] | {"tiingo":"0.46"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2011-07-18 | cash_dividend | — | — | — | 0.4600000000 | ["tiingo"] | {"tiingo":"0.46"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2011-04-20 | cash_dividend | — | — | — | 0.4400000000 | ["tiingo"] | {"tiingo":"0.44"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2011-01-18 | cash_dividend | — | — | — | 0.4400000000 | ["tiingo"] | {"tiingo":"0.44"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2010-10-21 | cash_dividend | — | — | — | 0.4400000000 | ["tiingo"] | {"tiingo":"0.44"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2010-07-16 | cash_dividend | — | — | — | 0.4400000000 | ["tiingo"] | {"tiingo":"0.44"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2010-04-22 | cash_dividend | — | — | — | 0.4200000000 | ["tiingo"] | {"tiingo":"0.42"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2010-01-15 | cash_dividend | — | — | — | 0.4200000000 | ["tiingo"] | {"tiingo":"0.42"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2009-10-22 | cash_dividend | — | — | — | 0.4200000000 | ["tiingo"] | {"tiingo":"0.42"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2009-07-16 | cash_dividend | — | — | — | 0.4200000000 | ["tiingo"] | {"tiingo":"0.42"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2009-04-16 | cash_dividend | — | — | — | 0.4200000000 | ["tiingo"] | {"tiingo":"0.42"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2009-01-15 | cash_dividend | — | — | — | 0.4200000000 | ["tiingo"] | {"tiingo":"0.42"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2008-10-16 | cash_dividend | — | — | — | 0.4200000000 | ["tiingo"] | {"tiingo":"0.42"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2008-07-17 | cash_dividend | — | — | — | 0.4200000000 | ["tiingo"] | {"tiingo":"0.42"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2008-04-17 | cash_dividend | — | — | — | 0.3600000000 | ["tiingo"] | {"tiingo":"0.36"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2008-01-17 | cash_dividend | — | — | — | 0.3600000000 | ["tiingo"] | {"tiingo":"0.36"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2007-10-18 | cash_dividend | — | — | — | 0.3600000000 | ["tiingo"] | {"tiingo":"0.36"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2007-07-18 | cash_dividend | — | — | — | 0.3600000000 | ["tiingo"] | {"tiingo":"0.36"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2007-04-19 | cash_dividend | — | — | — | 0.3000000000 | ["tiingo"] | {"tiingo":"0.3"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2007-01-18 | cash_dividend | — | — | — | 0.3000000000 | ["tiingo"] | {"tiingo":"0.3"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2006-10-19 | cash_dividend | — | — | — | 0.3000000000 | ["tiingo"] | {"tiingo":"0.3"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2006-07-18 | cash_dividend | — | — | — | 0.3000000000 | ["tiingo"] | {"tiingo":"0.3"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2006-04-20 | cash_dividend | — | — | — | 0.2500000000 | ["tiingo"] | {"tiingo":"0.25"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2006-01-18 | cash_dividend | — | — | — | 0.2500000000 | ["tiingo"] | {"tiingo":"0.25"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2005-10-20 | cash_dividend | — | — | — | 0.2500000000 | ["tiingo"] | {"tiingo":"0.25"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2005-07-20 | cash_dividend | — | — | — | 0.2500000000 | ["tiingo"] | {"tiingo":"0.25"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2005-07-14 | split | 2.000000000000000 | 2 | 1 | — | ["tiingo","yfinance"] | {"tiingo":"2.0","yfinance":"2.0"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2005-04-21 | cash_dividend | — | — | — | 0.4100000000 | ["tiingo"] | {"tiingo":"0.41"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2005-01-18 | cash_dividend | — | — | — | 0.4100000000 | ["tiingo"] | {"tiingo":"0.41"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2004-10-21 | cash_dividend | — | — | — | 0.4100000000 | ["tiingo"] | {"tiingo":"0.41"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2004-07-16 | cash_dividend | — | — | — | 0.4100000000 | ["tiingo"] | {"tiingo":"0.41"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2004-04-22 | cash_dividend | — | — | — | 0.3700000000 | ["tiingo"] | {"tiingo":"0.37"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2004-01-15 | cash_dividend | — | — | — | 0.3700000000 | ["tiingo"] | {"tiingo":"0.37"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2003-10-16 | cash_dividend | — | — | — | 0.3700000000 | ["tiingo"] | {"tiingo":"0.37"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2003-07-17 | cash_dividend | — | — | — | 0.3500000000 | ["tiingo"] | {"tiingo":"0.35"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2003-04-16 | cash_dividend | — | — | — | 0.3500000000 | ["tiingo"] | {"tiingo":"0.35"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2003-01-16 | cash_dividend | — | — | — | 0.3500000000 | ["tiingo"] | {"tiingo":"0.35"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2002-10-17 | cash_dividend | — | — | — | 0.3500000000 | ["tiingo"] | {"tiingo":"0.35"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2002-07-18 | cash_dividend | — | — | — | 0.3500000000 | ["tiingo"] | {"tiingo":"0.35"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2002-04-18 | cash_dividend | — | — | — | 0.3500000000 | ["tiingo"] | {"tiingo":"0.35"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 2002-01-17 | cash_dividend | — | — | — | 0.3500000000 | ["tiingo"] | {"tiingo":"0.35"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |