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,253 rowsCSV — whole table, not this view
Sources in this table
tiingo_prices3,253 rowsexportable
active:symbol = ORCL×
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ORCL | 2026-07-10 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2026-04-09 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2026-01-09 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2025-10-09 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2025-07-10 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2025-04-10 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2025-01-10 | cash_dividend | — | — | — | 0.4000000000 | ["tiingo"] | {"tiingo":"0.4"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2024-10-10 | cash_dividend | — | — | — | 0.4000000000 | ["tiingo"] | {"tiingo":"0.4"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2024-07-11 | cash_dividend | — | — | — | 0.4000000000 | ["tiingo"] | {"tiingo":"0.4"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2024-04-09 | cash_dividend | — | — | — | 0.4000000000 | ["tiingo"] | {"tiingo":"0.4"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2024-01-10 | cash_dividend | — | — | — | 0.4000000000 | ["tiingo"] | {"tiingo":"0.4"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2023-10-11 | cash_dividend | — | — | — | 0.4000000000 | ["tiingo"] | {"tiingo":"0.4"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2023-07-11 | cash_dividend | — | — | — | 0.4000000000 | ["tiingo"] | {"tiingo":"0.4"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2023-04-10 | cash_dividend | — | — | — | 0.4000000000 | ["tiingo"] | {"tiingo":"0.4"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2023-01-09 | cash_dividend | — | — | — | 0.3200000000 | ["tiingo"] | {"tiingo":"0.32"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2022-10-11 | cash_dividend | — | — | — | 0.3200000000 | ["tiingo"] | {"tiingo":"0.32"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2022-07-11 | cash_dividend | — | — | — | 0.3200000000 | ["tiingo"] | {"tiingo":"0.32"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2022-04-07 | cash_dividend | — | — | — | 0.3200000000 | ["tiingo"] | {"tiingo":"0.32"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2022-01-06 | cash_dividend | — | — | — | 0.3200000000 | ["tiingo"] | {"tiingo":"0.32"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2021-10-08 | cash_dividend | — | — | — | 0.3200000000 | ["tiingo"] | {"tiingo":"0.32"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2021-07-14 | cash_dividend | — | — | — | 0.3200000000 | ["tiingo"] | {"tiingo":"0.32"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2021-04-07 | cash_dividend | — | — | — | 0.3200000000 | ["tiingo"] | {"tiingo":"0.32"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2021-01-06 | cash_dividend | — | — | — | 0.2400000000 | ["tiingo"] | {"tiingo":"0.24"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2020-10-07 | cash_dividend | — | — | — | 0.2400000000 | ["tiingo"] | {"tiingo":"0.24"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2020-07-14 | cash_dividend | — | — | — | 0.2400000000 | ["tiingo"] | {"tiingo":"0.24"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2020-04-08 | cash_dividend | — | — | — | 0.2400000000 | ["tiingo"] | {"tiingo":"0.24"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2020-01-08 | cash_dividend | — | — | — | 0.2400000000 | ["tiingo"] | {"tiingo":"0.24"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2019-10-09 | cash_dividend | — | — | — | 0.2400000000 | ["tiingo"] | {"tiingo":"0.24"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2019-07-16 | cash_dividend | — | — | — | 0.2400000000 | ["tiingo"] | {"tiingo":"0.24"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2019-04-10 | cash_dividend | — | — | — | 0.2400000000 | ["tiingo"] | {"tiingo":"0.24"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2019-01-15 | cash_dividend | — | — | — | 0.1900000000 | ["tiingo"] | {"tiingo":"0.19"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2018-10-15 | cash_dividend | — | — | — | 0.1900000000 | ["tiingo"] | {"tiingo":"0.19"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2018-07-16 | cash_dividend | — | — | — | 0.1900000000 | ["tiingo"] | {"tiingo":"0.19"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2018-04-16 | cash_dividend | — | — | — | 0.1900000000 | ["tiingo"] | {"tiingo":"0.19"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2018-01-09 | cash_dividend | — | — | — | 0.1900000000 | ["tiingo"] | {"tiingo":"0.19"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2017-10-10 | cash_dividend | — | — | — | 0.1900000000 | ["tiingo"] | {"tiingo":"0.19"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2017-07-17 | cash_dividend | — | — | — | 0.1900000000 | ["tiingo"] | {"tiingo":"0.19"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2017-04-10 | cash_dividend | — | — | — | 0.1900000000 | ["tiingo"] | {"tiingo":"0.19"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2017-01-03 | cash_dividend | — | — | — | 0.1500000000 | ["tiingo"] | {"tiingo":"0.15"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2016-10-07 | cash_dividend | — | — | — | 0.1500000000 | ["tiingo"] | {"tiingo":"0.15"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2016-07-01 | cash_dividend | — | — | — | 0.1500000000 | ["tiingo"] | {"tiingo":"0.15"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2016-04-12 | cash_dividend | — | — | — | 0.1500000000 | ["tiingo"] | {"tiingo":"0.15"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2016-01-04 | cash_dividend | — | — | — | 0.1500000000 | ["tiingo"] | {"tiingo":"0.15"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2015-10-09 | cash_dividend | — | — | — | 0.1500000000 | ["tiingo"] | {"tiingo":"0.15"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2015-07-06 | cash_dividend | — | — | — | 0.1500000000 | ["tiingo"] | {"tiingo":"0.15"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2015-04-02 | cash_dividend | — | — | — | 0.1500000000 | ["tiingo"] | {"tiingo":"0.15"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2015-01-05 | cash_dividend | — | — | — | 0.1200000000 | ["tiingo"] | {"tiingo":"0.12"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2014-10-06 | cash_dividend | — | — | — | 0.1200000000 | ["tiingo"] | {"tiingo":"0.12"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2014-07-07 | cash_dividend | — | — | — | 0.1200000000 | ["tiingo"] | {"tiingo":"0.12"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| ORCL | 2014-04-04 | cash_dividend | — | — | — | 0.1200000000 | ["tiingo"] | {"tiingo":"0.12"} | tiingo_prices | /tiingo/daily/ORCL/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |