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
tiingo_prices3,253 rowsexportable
active:endpoint = /tiingo/daily/XLP/prices×
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLP | 2026-06-22 | cash_dividend | — | — | — | 0.5741880000 | ["tiingo"] | {"tiingo":"0.574188"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2026-03-23 | cash_dividend | — | — | — | 0.4548960000 | ["tiingo"] | {"tiingo":"0.454896"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2025-12-22 | cash_dividend | — | — | — | 0.6269710000 | ["tiingo"] | {"tiingo":"0.626971"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2025-09-22 | cash_dividend | — | — | — | 0.5412440000 | ["tiingo"] | {"tiingo":"0.541244"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2025-06-23 | cash_dividend | — | — | — | 0.5523270000 | ["tiingo"] | {"tiingo":"0.552327"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2025-03-24 | cash_dividend | — | — | — | 0.4182350000 | ["tiingo"] | {"tiingo":"0.418235"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2024-12-23 | cash_dividend | — | — | — | 0.6023610000 | ["tiingo"] | {"tiingo":"0.602361"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2024-09-23 | cash_dividend | — | — | — | 0.4389630000 | ["tiingo"] | {"tiingo":"0.438963"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2024-06-24 | cash_dividend | — | — | — | 0.5819300000 | ["tiingo"] | {"tiingo":"0.58193"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2024-03-18 | cash_dividend | — | — | — | 0.5522370000 | ["tiingo"] | {"tiingo":"0.552237"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2023-12-18 | cash_dividend | — | — | — | 0.5364460000 | ["tiingo"] | {"tiingo":"0.536446"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2023-09-18 | cash_dividend | — | — | — | 0.4852200000 | ["tiingo"] | {"tiingo":"0.48522"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2023-06-20 | cash_dividend | — | — | — | 0.5260260000 | ["tiingo"] | {"tiingo":"0.526026"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2023-03-20 | cash_dividend | — | — | — | 0.3446610000 | ["tiingo"] | {"tiingo":"0.344661"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2022-12-19 | cash_dividend | — | — | — | 0.5330160000 | ["tiingo"] | {"tiingo":"0.533016"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2022-09-19 | cash_dividend | — | — | — | 0.4605320000 | ["tiingo"] | {"tiingo":"0.460532"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2022-06-21 | cash_dividend | — | — | — | 0.5128600000 | ["tiingo"] | {"tiingo":"0.51286"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2022-03-21 | cash_dividend | — | — | — | 0.3349200000 | ["tiingo"] | {"tiingo":"0.33492"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2021-12-20 | cash_dividend | — | — | — | 0.5117370000 | ["tiingo"] | {"tiingo":"0.511737"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2021-09-20 | cash_dividend | — | — | — | 0.4420060000 | ["tiingo"] | {"tiingo":"0.442006"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2021-06-21 | cash_dividend | — | — | — | 0.4436280000 | ["tiingo"] | {"tiingo":"0.443628"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2021-03-22 | cash_dividend | — | — | — | 0.3569400000 | ["tiingo"] | {"tiingo":"0.35694"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2020-12-21 | cash_dividend | — | — | — | 0.5644050000 | ["tiingo"] | {"tiingo":"0.564405"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2020-09-21 | cash_dividend | — | — | — | 0.3766280000 | ["tiingo"] | {"tiingo":"0.376628"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2020-06-22 | cash_dividend | — | — | — | 0.4607760000 | ["tiingo"] | {"tiingo":"0.460776"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2020-03-23 | cash_dividend | — | — | — | 0.2873810000 | ["tiingo"] | {"tiingo":"0.287381"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2019-12-20 | cash_dividend | — | — | — | 0.5130000000 | ["tiingo"] | {"tiingo":"0.513"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2019-09-20 | cash_dividend | — | — | — | 0.3577850000 | ["tiingo"] | {"tiingo":"0.357785"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2019-06-21 | cash_dividend | — | — | — | 0.4485000000 | ["tiingo"] | {"tiingo":"0.4485"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2019-03-15 | cash_dividend | — | — | — | 0.2977000000 | ["tiingo"] | {"tiingo":"0.2977"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2018-12-21 | cash_dividend | — | — | — | 0.4640000000 | ["tiingo"] | {"tiingo":"0.464"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2018-09-21 | cash_dividend | — | — | — | 0.3885000000 | ["tiingo"] | {"tiingo":"0.3885"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2018-06-15 | cash_dividend | — | — | — | 0.3938000000 | ["tiingo"] | {"tiingo":"0.3938"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2018-03-16 | cash_dividend | — | — | — | 0.2985510000 | ["tiingo"] | {"tiingo":"0.298551"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2017-12-15 | cash_dividend | — | — | — | 0.4177010000 | ["tiingo"] | {"tiingo":"0.417701"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2017-09-15 | cash_dividend | — | — | — | 0.3460390000 | ["tiingo"] | {"tiingo":"0.346039"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2017-06-16 | cash_dividend | — | — | — | 0.4357890000 | ["tiingo"] | {"tiingo":"0.435789"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2017-03-17 | cash_dividend | — | — | — | 0.2898480000 | ["tiingo"] | {"tiingo":"0.289848"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2016-12-16 | cash_dividend | — | — | — | 0.3858400000 | ["tiingo"] | {"tiingo":"0.38584"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2016-09-16 | cash_dividend | — | — | — | 0.3281470000 | ["tiingo"] | {"tiingo":"0.328147"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2016-06-17 | cash_dividend | — | — | — | 0.3234340000 | ["tiingo"] | {"tiingo":"0.323434"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2016-03-18 | cash_dividend | — | — | — | 0.2709280000 | ["tiingo"] | {"tiingo":"0.270928"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2015-12-18 | cash_dividend | — | — | — | 0.3698830000 | ["tiingo"] | {"tiingo":"0.369883"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2015-09-18 | cash_dividend | — | — | — | 0.3076570000 | ["tiingo"] | {"tiingo":"0.307657"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2015-06-19 | cash_dividend | — | — | — | 0.3016800000 | ["tiingo"] | {"tiingo":"0.30168"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2015-03-20 | cash_dividend | — | — | — | 0.2955900000 | ["tiingo"] | {"tiingo":"0.29559"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2014-12-19 | cash_dividend | — | — | — | 0.3503300000 | ["tiingo"] | {"tiingo":"0.35033"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2014-09-19 | cash_dividend | — | — | — | 0.2864700000 | ["tiingo"] | {"tiingo":"0.28647"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2014-06-20 | cash_dividend | — | — | — | 0.3111500000 | ["tiingo"] | {"tiingo":"0.31115"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2014-03-21 | cash_dividend | — | — | — | 0.2163800000 | ["tiingo"] | {"tiingo":"0.21638"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |