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/XLV/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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLV | 2026-06-22 | cash_dividend | — | — | — | 0.6562520000 | ["tiingo"] | {"tiingo":"0.656252"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2026-03-23 | cash_dividend | — | — | — | 0.5946800000 | ["tiingo"] | {"tiingo":"0.59468"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2025-12-22 | cash_dividend | — | — | — | 0.6568220000 | ["tiingo"] | {"tiingo":"0.656822"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2025-09-22 | cash_dividend | — | — | — | 0.6248680000 | ["tiingo"] | {"tiingo":"0.624868"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2025-06-23 | cash_dividend | — | — | — | 0.6303820000 | ["tiingo"] | {"tiingo":"0.630382"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2025-03-24 | cash_dividend | — | — | — | 0.5645390000 | ["tiingo"] | {"tiingo":"0.564539"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2024-12-23 | cash_dividend | — | — | — | 0.6216550000 | ["tiingo"] | {"tiingo":"0.621655"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2024-09-23 | cash_dividend | — | — | — | 0.5772340000 | ["tiingo"] | {"tiingo":"0.577234"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2024-06-24 | cash_dividend | — | — | — | 0.5725330000 | ["tiingo"] | {"tiingo":"0.572533"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2024-03-18 | cash_dividend | — | — | — | 0.5229410000 | ["tiingo"] | {"tiingo":"0.522941"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2023-12-18 | cash_dividend | — | — | — | 0.5977250000 | ["tiingo"] | {"tiingo":"0.597725"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2023-09-18 | cash_dividend | — | — | — | 0.5395190000 | ["tiingo"] | {"tiingo":"0.539519"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2023-06-20 | cash_dividend | — | — | — | 0.5424430000 | ["tiingo"] | {"tiingo":"0.542443"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2023-03-20 | cash_dividend | — | — | — | 0.4891370000 | ["tiingo"] | {"tiingo":"0.489137"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2022-12-19 | cash_dividend | — | — | — | 0.5561260000 | ["tiingo"] | {"tiingo":"0.556126"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2022-09-19 | cash_dividend | — | — | — | 0.5058270000 | ["tiingo"] | {"tiingo":"0.505827"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2022-06-21 | cash_dividend | — | — | — | 0.5042240000 | ["tiingo"] | {"tiingo":"0.504224"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2022-03-21 | cash_dividend | — | — | — | 0.4263610000 | ["tiingo"] | {"tiingo":"0.426361"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2021-12-20 | cash_dividend | — | — | — | 0.5275210000 | ["tiingo"] | {"tiingo":"0.527521"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2021-09-20 | cash_dividend | — | — | — | 0.4665420000 | ["tiingo"] | {"tiingo":"0.466542"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2021-06-21 | cash_dividend | — | — | — | 0.4808300000 | ["tiingo"] | {"tiingo":"0.48083"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2021-03-22 | cash_dividend | — | — | — | 0.3974680000 | ["tiingo"] | {"tiingo":"0.397468"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2020-12-21 | cash_dividend | — | — | — | 0.4643410000 | ["tiingo"] | {"tiingo":"0.464341"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2020-09-21 | cash_dividend | — | — | — | 0.4183620000 | ["tiingo"] | {"tiingo":"0.418362"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2020-06-22 | cash_dividend | — | — | — | 0.4248070000 | ["tiingo"] | {"tiingo":"0.424807"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2020-03-23 | cash_dividend | — | — | — | 0.3819830000 | ["tiingo"] | {"tiingo":"0.381983"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2019-12-30 | cash_dividend | — | — | — | 0.6660000000 | ["tiingo"] | {"tiingo":"0.666"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2019-12-20 | cash_dividend | — | — | — | 0.4220000000 | ["tiingo"] | {"tiingo":"0.422"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2019-09-20 | cash_dividend | — | — | — | 0.3795000000 | ["tiingo"] | {"tiingo":"0.3795"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2019-06-21 | cash_dividend | — | — | — | 0.3984000000 | ["tiingo"] | {"tiingo":"0.3984"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2019-03-15 | cash_dividend | — | — | — | 0.3409000000 | ["tiingo"] | {"tiingo":"0.3409"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2018-12-21 | cash_dividend | — | — | — | 0.3795000000 | ["tiingo"] | {"tiingo":"0.3795"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2018-09-21 | cash_dividend | — | — | — | 0.3671000000 | ["tiingo"] | {"tiingo":"0.3671"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2018-06-15 | cash_dividend | — | — | — | 0.3160000000 | ["tiingo"] | {"tiingo":"0.316"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2018-03-16 | cash_dividend | — | — | — | 0.2996680000 | ["tiingo"] | {"tiingo":"0.299668"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2017-12-15 | cash_dividend | — | — | — | 0.3305460000 | ["tiingo"] | {"tiingo":"0.330546"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2017-09-15 | cash_dividend | — | — | — | 0.3047550000 | ["tiingo"] | {"tiingo":"0.304755"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2017-06-16 | cash_dividend | — | — | — | 0.3078230000 | ["tiingo"] | {"tiingo":"0.307823"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2017-03-17 | cash_dividend | — | — | — | 0.2738390000 | ["tiingo"] | {"tiingo":"0.273839"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2016-12-16 | cash_dividend | — | — | — | 0.3054160000 | ["tiingo"] | {"tiingo":"0.305416"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2016-09-16 | cash_dividend | — | — | — | 0.2785020000 | ["tiingo"] | {"tiingo":"0.278502"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2016-06-17 | cash_dividend | — | — | — | 0.2852140000 | ["tiingo"] | {"tiingo":"0.285214"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2016-03-18 | cash_dividend | — | — | — | 0.2366960000 | ["tiingo"] | {"tiingo":"0.236696"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2015-12-18 | cash_dividend | — | — | — | 0.3028160000 | ["tiingo"] | {"tiingo":"0.302816"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2015-09-18 | cash_dividend | — | — | — | 0.2607220000 | ["tiingo"] | {"tiingo":"0.260722"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2015-06-19 | cash_dividend | — | — | — | 0.2614100000 | ["tiingo"] | {"tiingo":"0.26141"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2015-03-20 | cash_dividend | — | — | — | 0.2084500000 | ["tiingo"] | {"tiingo":"0.20845"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2014-12-19 | cash_dividend | — | — | — | 0.2597300000 | ["tiingo"] | {"tiingo":"0.25973"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2014-09-19 | cash_dividend | — | — | — | 0.2308200000 | ["tiingo"] | {"tiingo":"0.23082"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2014-06-20 | cash_dividend | — | — | — | 0.2261700000 | ["tiingo"] | {"tiingo":"0.22617"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |