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
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLI | 2026-06-22 | cash_dividend | — | — | — | 0.4440940000 | ["tiingo"] | {"tiingo":"0.444094"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2026-03-23 | cash_dividend | — | — | — | 0.4532100000 | ["tiingo"] | {"tiingo":"0.45321"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2025-12-22 | cash_dividend | — | — | — | 0.5316020000 | ["tiingo"] | {"tiingo":"0.531602"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2025-09-22 | cash_dividend | — | — | — | 0.6298260000 | ["tiingo"] | {"tiingo":"0.629826"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2025-06-23 | cash_dividend | — | — | — | 0.4316710000 | ["tiingo"] | {"tiingo":"0.431671"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2025-03-24 | cash_dividend | — | — | — | 0.4047430000 | ["tiingo"] | {"tiingo":"0.404743"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2024-12-23 | cash_dividend | — | — | — | 0.6701320000 | ["tiingo"] | {"tiingo":"0.670132"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2024-09-23 | cash_dividend | — | — | — | 0.4310220000 | ["tiingo"] | {"tiingo":"0.431022"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2024-06-24 | cash_dividend | — | — | — | 0.4212590000 | ["tiingo"] | {"tiingo":"0.421259"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2024-03-18 | cash_dividend | — | — | — | 0.3762770000 | ["tiingo"] | {"tiingo":"0.376277"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2023-12-18 | cash_dividend | — | — | — | 0.6146370000 | ["tiingo"] | {"tiingo":"0.614637"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2023-09-18 | cash_dividend | — | — | — | 0.4264150000 | ["tiingo"] | {"tiingo":"0.426415"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2023-06-20 | cash_dividend | — | — | — | 0.4198080000 | ["tiingo"] | {"tiingo":"0.419808"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2023-03-20 | cash_dividend | — | — | — | 0.3948550000 | ["tiingo"] | {"tiingo":"0.394855"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2022-12-19 | cash_dividend | — | — | — | 0.4655630000 | ["tiingo"] | {"tiingo":"0.465563"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2022-09-19 | cash_dividend | — | — | — | 0.4250070000 | ["tiingo"] | {"tiingo":"0.425007"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2022-06-21 | cash_dividend | — | — | — | 0.3741720000 | ["tiingo"] | {"tiingo":"0.374172"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2022-03-21 | cash_dividend | — | — | — | 0.3405510000 | ["tiingo"] | {"tiingo":"0.340551"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2021-12-20 | cash_dividend | — | — | — | 0.3849970000 | ["tiingo"] | {"tiingo":"0.384997"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2021-09-20 | cash_dividend | — | — | — | 0.3230980000 | ["tiingo"] | {"tiingo":"0.323098"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2021-06-21 | cash_dividend | — | — | — | 0.3143290000 | ["tiingo"] | {"tiingo":"0.314329"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2021-03-22 | cash_dividend | — | — | — | 0.2956430000 | ["tiingo"] | {"tiingo":"0.295643"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2020-12-21 | cash_dividend | — | — | — | 0.3658870000 | ["tiingo"] | {"tiingo":"0.365887"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2020-09-21 | cash_dividend | — | — | — | 0.3052830000 | ["tiingo"] | {"tiingo":"0.305283"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2020-06-22 | cash_dividend | — | — | — | 0.3063350000 | ["tiingo"] | {"tiingo":"0.306335"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2020-03-23 | cash_dividend | — | — | — | 0.3957720000 | ["tiingo"] | {"tiingo":"0.395772"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2019-12-20 | cash_dividend | — | — | — | 0.4030000000 | ["tiingo"] | {"tiingo":"0.403"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2019-09-20 | cash_dividend | — | — | — | 0.4145540000 | ["tiingo"] | {"tiingo":"0.414554"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2019-06-21 | cash_dividend | — | — | — | 0.3374000000 | ["tiingo"] | {"tiingo":"0.3374"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2019-03-15 | cash_dividend | — | — | — | 0.4277000000 | ["tiingo"] | {"tiingo":"0.4277"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2018-12-21 | cash_dividend | — | — | — | 0.3924000000 | ["tiingo"] | {"tiingo":"0.3924"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2018-09-21 | cash_dividend | — | — | — | 0.3838000000 | ["tiingo"] | {"tiingo":"0.3838"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2018-06-15 | cash_dividend | — | — | — | 0.3016000000 | ["tiingo"] | {"tiingo":"0.3016"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2018-03-16 | cash_dividend | — | — | — | 0.3072760000 | ["tiingo"] | {"tiingo":"0.307276"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2017-12-15 | cash_dividend | — | — | — | 0.4017120000 | ["tiingo"] | {"tiingo":"0.401712"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2017-09-15 | cash_dividend | — | — | — | 0.3158780000 | ["tiingo"] | {"tiingo":"0.315878"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2017-06-16 | cash_dividend | — | — | — | 0.3235930000 | ["tiingo"] | {"tiingo":"0.323593"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2017-03-17 | cash_dividend | — | — | — | 0.2966990000 | ["tiingo"] | {"tiingo":"0.296699"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2016-12-16 | cash_dividend | — | — | — | 0.3842240000 | ["tiingo"] | {"tiingo":"0.384224"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2016-09-16 | cash_dividend | — | — | — | 0.3115310000 | ["tiingo"] | {"tiingo":"0.311531"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2016-06-17 | cash_dividend | — | — | — | 0.3071760000 | ["tiingo"] | {"tiingo":"0.307176"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2016-03-18 | cash_dividend | — | — | — | 0.2828160000 | ["tiingo"] | {"tiingo":"0.282816"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2015-12-18 | cash_dividend | — | — | — | 0.3187390000 | ["tiingo"] | {"tiingo":"0.318739"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2015-09-18 | cash_dividend | — | — | — | 0.2809210000 | ["tiingo"] | {"tiingo":"0.280921"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2015-06-19 | cash_dividend | — | — | — | 0.2777600000 | ["tiingo"] | {"tiingo":"0.27776"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2015-03-20 | cash_dividend | — | — | — | 0.2607100000 | ["tiingo"] | {"tiingo":"0.26071"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2014-12-19 | cash_dividend | — | — | — | 0.3155800000 | ["tiingo"] | {"tiingo":"0.31558"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2014-09-19 | cash_dividend | — | — | — | 0.2573200000 | ["tiingo"] | {"tiingo":"0.25732"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2014-06-20 | cash_dividend | — | — | — | 0.2496500000 | ["tiingo"] | {"tiingo":"0.24965"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLI | 2014-03-21 | cash_dividend | — | — | — | 0.2244900000 | ["tiingo"] | {"tiingo":"0.22449"} | tiingo_prices | /tiingo/daily/XLI/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |