Simplify AnalyticsCorporate 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,264 rowsCSV
Sources in this table
tiingo_prices3,264 rowsexportable
active:sorted by ex_date ↑×
ex_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 | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LMT | 1989-05-17 | cash_dividend | — | — | — | 0.2760000000 | ["tiingo"] | {"tiingo":"0.276"} | tiingo_prices | /tiingo/daily/LMT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AAPL | 1989-05-22 | cash_dividend | — | — | — | 0.1000000000 | ["tiingo"] | {"tiingo":"0.1"} | tiingo_prices | /tiingo/daily/AAPL/prices | {} | 2026-09-07 | 2026-09-07 13:28 | 2026-09-07 13:28 |
| DE | 1989-06-26 | cash_dividend | — | — | — | 0.3500000000 | ["tiingo"] | {"tiingo":"0.35"} | tiingo_prices | /tiingo/daily/DE/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 1989-07-03 | split | 2.000000000000000 | 2 | 1 | — | ["tiingo","yfinance"] | {"tiingo":"2.0","yfinance":"2.0"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 1989-07-14 | 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 |
| XOM | 1989-08-08 | cash_dividend | — | — | — | 0.6000000000 | ["tiingo"] | {"tiingo":"0.6"} | tiingo_prices | /tiingo/daily/XOM/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| LMT | 1989-08-15 | cash_dividend | — | — | — | 0.2760000000 | ["tiingo"] | {"tiingo":"0.276"} | tiingo_prices | /tiingo/daily/LMT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AAPL | 1989-08-21 | cash_dividend | — | — | — | 0.1000000000 | ["tiingo"] | {"tiingo":"0.1"} | tiingo_prices | /tiingo/daily/AAPL/prices | {} | 2026-09-07 | 2026-09-07 13:28 | 2026-09-07 13:28 |
| DE | 1989-09-25 | cash_dividend | — | — | — | 0.3500000000 | ["tiingo"] | {"tiingo":"0.35"} | tiingo_prices | /tiingo/daily/DE/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 1989-10-17 | 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 |
| XOM | 1989-11-07 | cash_dividend | — | — | — | 0.6000000000 | ["tiingo"] | {"tiingo":"0.6"} | tiingo_prices | /tiingo/daily/XOM/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| LMT | 1989-11-14 | cash_dividend | — | — | — | 0.2760000000 | ["tiingo"] | {"tiingo":"0.276"} | tiingo_prices | /tiingo/daily/LMT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AAPL | 1989-11-17 | cash_dividend | — | — | — | 0.1100000000 | ["tiingo"] | {"tiingo":"0.11"} | tiingo_prices | /tiingo/daily/AAPL/prices | {} | 2026-09-07 | 2026-09-07 13:28 | 2026-09-07 13:28 |
| DE | 1989-12-26 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/DE/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 1990-01-16 | 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 | 1990-01-18 | cash_dividend | — | — | — | 0.3250000000 | ["tiingo"] | {"tiingo":"0.325"} | tiingo_prices | /tiingo/daily/CAT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| XOM | 1990-02-06 | cash_dividend | — | — | — | 0.6000000000 | ["tiingo"] | {"tiingo":"0.6"} | tiingo_prices | /tiingo/daily/XOM/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| LMT | 1990-02-13 | cash_dividend | — | — | — | 0.2760000000 | ["tiingo"] | {"tiingo":"0.276"} | tiingo_prices | /tiingo/daily/LMT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AAPL | 1990-02-16 | cash_dividend | — | — | — | 0.1100000000 | ["tiingo"] | {"tiingo":"0.11"} | tiingo_prices | /tiingo/daily/AAPL/prices | {} | 2026-09-07 | 2026-09-07 13:28 | 2026-09-07 13:28 |
| DE | 1990-03-26 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/DE/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| MSFT | 1990-04-16 | split | 2.000000000000000 | 2 | 1 | — | ["tiingo","yfinance"] | {"tiingo":"2.0","yfinance":"2.0"} | tiingo_prices | /tiingo/daily/MSFT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 1990-04-17 | 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 |
| XOM | 1990-05-08 | cash_dividend | — | — | — | 0.6000000000 | ["tiingo"] | {"tiingo":"0.6"} | tiingo_prices | /tiingo/daily/XOM/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| AAPL | 1990-05-21 | cash_dividend | — | — | — | 0.1100000000 | ["tiingo"] | {"tiingo":"0.11"} | tiingo_prices | /tiingo/daily/AAPL/prices | {} | 2026-09-07 | 2026-09-07 13:28 | 2026-09-07 13:28 |
| DE | 1990-06-25 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/DE/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 1990-07-16 | 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 |
| XOM | 1990-08-07 | cash_dividend | — | — | — | 0.6000000000 | ["tiingo"] | {"tiingo":"0.6"} | tiingo_prices | /tiingo/daily/XOM/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| LMT | 1990-08-14 | cash_dividend | — | — | — | 0.2760000000 | ["tiingo"] | {"tiingo":"0.276"} | tiingo_prices | /tiingo/daily/LMT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AAPL | 1990-08-20 | cash_dividend | — | — | — | 0.1100000000 | ["tiingo"] | {"tiingo":"0.11"} | tiingo_prices | /tiingo/daily/AAPL/prices | {} | 2026-09-07 | 2026-09-07 13:28 | 2026-09-07 13:28 |
| DE | 1990-09-24 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/DE/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 1990-10-16 | 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 |
| XOM | 1990-11-05 | cash_dividend | — | — | — | 0.6700000000 | ["tiingo"] | {"tiingo":"0.67"} | tiingo_prices | /tiingo/daily/XOM/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| LMT | 1990-11-13 | cash_dividend | — | — | — | 0.2760000000 | ["tiingo"] | {"tiingo":"0.276"} | tiingo_prices | /tiingo/daily/LMT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AAPL | 1990-11-16 | cash_dividend | — | — | — | 0.1200000000 | ["tiingo"] | {"tiingo":"0.12"} | tiingo_prices | /tiingo/daily/AAPL/prices | {} | 2026-09-07 | 2026-09-07 13:28 | 2026-09-07 13:28 |
| DE | 1990-12-24 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/DE/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 1991-01-15 | 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 |
| XOM | 1991-02-05 | cash_dividend | — | — | — | 0.6700000000 | ["tiingo"] | {"tiingo":"0.67"} | tiingo_prices | /tiingo/daily/XOM/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| LMT | 1991-02-12 | cash_dividend | — | — | — | 0.2760000000 | ["tiingo"] | {"tiingo":"0.276"} | tiingo_prices | /tiingo/daily/LMT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AAPL | 1991-02-15 | cash_dividend | — | — | — | 0.1200000000 | ["tiingo"] | {"tiingo":"0.12"} | tiingo_prices | /tiingo/daily/AAPL/prices | {} | 2026-09-07 | 2026-09-07 13:28 | 2026-09-07 13:28 |
| DE | 1991-03-22 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/DE/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 1991-04-16 | 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 |
| XOM | 1991-05-07 | cash_dividend | — | — | — | 0.6700000000 | ["tiingo"] | {"tiingo":"0.67"} | tiingo_prices | /tiingo/daily/XOM/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| LMT | 1991-05-15 | cash_dividend | — | — | — | 0.3070000000 | ["tiingo"] | {"tiingo":"0.307"} | tiingo_prices | /tiingo/daily/LMT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AAPL | 1991-05-20 | cash_dividend | — | — | — | 0.1200000000 | ["tiingo"] | {"tiingo":"0.12"} | tiingo_prices | /tiingo/daily/AAPL/prices | {} | 2026-09-07 | 2026-09-07 13:28 | 2026-09-07 13:28 |
| DE | 1991-06-24 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/DE/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| MSFT | 1991-06-27 | split | 1.500000000000000 | 3 | 2 | — | ["tiingo","yfinance"] | {"tiingo":"1.5","yfinance":"1.5"} | tiingo_prices | /tiingo/daily/MSFT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| CAT | 1991-07-16 | 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 |
| XOM | 1991-08-07 | cash_dividend | — | — | — | 0.6700000000 | ["tiingo"] | {"tiingo":"0.67"} | tiingo_prices | /tiingo/daily/XOM/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| LMT | 1991-08-14 | cash_dividend | — | — | — | 0.3070000000 | ["tiingo"] | {"tiingo":"0.307"} | tiingo_prices | /tiingo/daily/LMT/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AAPL | 1991-08-19 | cash_dividend | — | — | — | 0.1200000000 | ["tiingo"] | {"tiingo":"0.12"} | tiingo_prices | /tiingo/daily/AAPL/prices | {} | 2026-09-07 | 2026-09-07 13:28 | 2026-09-07 13:28 |