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 — whole table, not this view
Sources in this table
tiingo_prices3,264 rowsexportable
active:symbol = WDC×
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| WDC | 2026-09-08 | cash_dividend | — | — | — | 0.1500000000 | ["tiingo"] | {"tiingo":"0.15"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-08 | 2026-09-08 21:56 | 2026-09-08 21:56 |
| WDC | 2026-06-05 | cash_dividend | — | — | — | 0.1500000000 | ["tiingo"] | {"tiingo":"0.15"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2026-03-05 | cash_dividend | — | — | — | 0.1250000000 | ["tiingo"] | {"tiingo":"0.125"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2025-12-04 | cash_dividend | — | — | — | 0.1250000000 | ["tiingo"] | {"tiingo":"0.125"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2025-09-04 | cash_dividend | — | — | — | 0.1000000000 | ["tiingo"] | {"tiingo":"0.1"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2025-06-04 | cash_dividend | — | — | — | 0.1000000000 | ["tiingo"] | {"tiingo":"0.1"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2025-02-24 | price_factor | 1.323000000000000 | — | — | — | ["tiingo","yfinance"] | {"tiingo":"1.323","yfinance":"1.323"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2020-04-02 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2020-01-02 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2019-10-03 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2019-06-27 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2019-03-28 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2018-12-27 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2018-09-27 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2018-06-28 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2018-03-28 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2017-12-28 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2017-09-28 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2017-06-28 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2017-03-29 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2016-12-28 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2016-09-28 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2016-06-29 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2016-03-30 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2015-12-29 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2015-09-30 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2015-06-30 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2015-03-31 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2014-12-30 | cash_dividend | — | — | — | 0.4000000000 | ["tiingo"] | {"tiingo":"0.4"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2014-10-01 | cash_dividend | — | — | — | 0.4000000000 | ["tiingo"] | {"tiingo":"0.4"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2014-06-25 | cash_dividend | — | — | — | 0.4000000000 | ["tiingo"] | {"tiingo":"0.4"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2014-03-26 | cash_dividend | — | — | — | 0.3000000000 | ["tiingo"] | {"tiingo":"0.3"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2013-12-24 | cash_dividend | — | — | — | 0.3000000000 | ["tiingo"] | {"tiingo":"0.3"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2013-09-26 | cash_dividend | — | — | — | 0.2500000000 | ["tiingo"] | {"tiingo":"0.25"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2013-06-26 | cash_dividend | — | — | — | 0.2500000000 | ["tiingo"] | {"tiingo":"0.25"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2013-03-26 | cash_dividend | — | — | — | 0.2500000000 | ["tiingo"] | {"tiingo":"0.25"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2012-12-12 | cash_dividend | — | — | — | 0.2500000000 | ["tiingo"] | {"tiingo":"0.25"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 2012-09-26 | cash_dividend | — | — | — | 0.2500000000 | ["tiingo"] | {"tiingo":"0.25"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| WDC | 1997-06-04 | split | 2.000000000000000 | 2 | 1 | — | ["tiingo","yfinance"] | {"tiingo":"2.0","yfinance":"2.0"} | tiingo_prices | /tiingo/daily/WDC/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |