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 = 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.

symboltextex_date ↓dateaction_typetextratio_rawnumericratio_numbigintratio_denbigintdiv_cashnumericvendorsARRAYvendor_valuesjsonbsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
ORCL2026-07-10cash_dividend———0.5000000000["tiingo"]{"tiingo":"0.5"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2026-04-09cash_dividend———0.5000000000["tiingo"]{"tiingo":"0.5"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2026-01-09cash_dividend———0.5000000000["tiingo"]{"tiingo":"0.5"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2025-10-09cash_dividend———0.5000000000["tiingo"]{"tiingo":"0.5"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2025-07-10cash_dividend———0.5000000000["tiingo"]{"tiingo":"0.5"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2025-04-10cash_dividend———0.5000000000["tiingo"]{"tiingo":"0.5"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2025-01-10cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2024-10-10cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2024-07-11cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2024-04-09cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2024-01-10cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2023-10-11cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2023-07-11cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2023-04-10cash_dividend———0.4000000000["tiingo"]{"tiingo":"0.4"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2023-01-09cash_dividend———0.3200000000["tiingo"]{"tiingo":"0.32"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2022-10-11cash_dividend———0.3200000000["tiingo"]{"tiingo":"0.32"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2022-07-11cash_dividend———0.3200000000["tiingo"]{"tiingo":"0.32"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2022-04-07cash_dividend———0.3200000000["tiingo"]{"tiingo":"0.32"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2022-01-06cash_dividend———0.3200000000["tiingo"]{"tiingo":"0.32"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2021-10-08cash_dividend———0.3200000000["tiingo"]{"tiingo":"0.32"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2021-07-14cash_dividend———0.3200000000["tiingo"]{"tiingo":"0.32"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2021-04-07cash_dividend———0.3200000000["tiingo"]{"tiingo":"0.32"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2021-01-06cash_dividend———0.2400000000["tiingo"]{"tiingo":"0.24"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2020-10-07cash_dividend———0.2400000000["tiingo"]{"tiingo":"0.24"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2020-07-14cash_dividend———0.2400000000["tiingo"]{"tiingo":"0.24"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2020-04-08cash_dividend———0.2400000000["tiingo"]{"tiingo":"0.24"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2020-01-08cash_dividend———0.2400000000["tiingo"]{"tiingo":"0.24"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2019-10-09cash_dividend———0.2400000000["tiingo"]{"tiingo":"0.24"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2019-07-16cash_dividend———0.2400000000["tiingo"]{"tiingo":"0.24"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2019-04-10cash_dividend———0.2400000000["tiingo"]{"tiingo":"0.24"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2019-01-15cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2018-10-15cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2018-07-16cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2018-04-16cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2018-01-09cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2017-10-10cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2017-07-17cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2017-04-10cash_dividend———0.1900000000["tiingo"]{"tiingo":"0.19"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2017-01-03cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2016-10-07cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2016-07-01cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2016-04-12cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2016-01-04cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2015-10-09cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2015-07-06cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2015-04-02cash_dividend———0.1500000000["tiingo"]{"tiingo":"0.15"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2015-01-05cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2014-10-06cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2014-07-07cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29
ORCL2014-04-04cash_dividend———0.1200000000["tiingo"]{"tiingo":"0.12"}tiingo_prices/tiingo/daily/ORCL/prices{}2026-09-072026-09-07 13:292026-09-07 13:29