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:symbol = XLU×
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLU | 2026-06-22 | cash_dividend | — | — | — | 0.2844150000 | ["tiingo"] | {"tiingo":"0.284415"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2026-03-23 | cash_dividend | — | — | — | 0.3099420000 | ["tiingo"] | {"tiingo":"0.309942"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2025-12-22 | cash_dividend | — | — | — | 0.3172100000 | ["tiingo"] | {"tiingo":"0.31721"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2025-12-05 | split | 2.000000000000000 | 2 | 1 | — | ["tiingo","yfinance"] | {"tiingo":"2.0","yfinance":"2.0"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2025-09-22 | cash_dividend | — | — | — | 0.5678270000 | ["tiingo"] | {"tiingo":"0.567827"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2025-06-23 | cash_dividend | — | — | — | 0.5573970000 | ["tiingo"] | {"tiingo":"0.557397"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2025-03-24 | cash_dividend | — | — | — | 0.5550290000 | ["tiingo"] | {"tiingo":"0.555029"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2024-12-23 | cash_dividend | — | — | — | 0.6279890000 | ["tiingo"] | {"tiingo":"0.627989"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2024-09-23 | cash_dividend | — | — | — | 0.5394860000 | ["tiingo"] | {"tiingo":"0.539486"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2024-06-24 | cash_dividend | — | — | — | 0.5550750000 | ["tiingo"] | {"tiingo":"0.555075"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2024-03-18 | cash_dividend | — | — | — | 0.5195550000 | ["tiingo"] | {"tiingo":"0.519555"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2023-12-18 | cash_dividend | — | — | — | 0.5971740000 | ["tiingo"] | {"tiingo":"0.597174"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2023-09-18 | cash_dividend | — | — | — | 0.5215950000 | ["tiingo"] | {"tiingo":"0.521595"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2023-06-20 | cash_dividend | — | — | — | 0.5365980000 | ["tiingo"] | {"tiingo":"0.536598"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2023-03-20 | cash_dividend | — | — | — | 0.4897460000 | ["tiingo"] | {"tiingo":"0.489746"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2022-12-19 | cash_dividend | — | — | — | 0.5722410000 | ["tiingo"] | {"tiingo":"0.572241"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2022-09-19 | cash_dividend | — | — | — | 0.5014230000 | ["tiingo"] | {"tiingo":"0.501423"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2022-06-21 | cash_dividend | — | — | — | 0.5153980000 | ["tiingo"] | {"tiingo":"0.515398"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2022-03-21 | cash_dividend | — | — | — | 0.4694900000 | ["tiingo"] | {"tiingo":"0.46949"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2021-12-20 | cash_dividend | — | — | — | 0.5455600000 | ["tiingo"] | {"tiingo":"0.54556"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2021-09-20 | cash_dividend | — | — | — | 0.4991830000 | ["tiingo"] | {"tiingo":"0.499183"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2021-06-21 | cash_dividend | — | — | — | 0.4943180000 | ["tiingo"] | {"tiingo":"0.494318"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2021-03-22 | cash_dividend | — | — | — | 0.4607760000 | ["tiingo"] | {"tiingo":"0.460776"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2020-12-21 | cash_dividend | — | — | — | 0.5217740000 | ["tiingo"] | {"tiingo":"0.521774"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2020-09-21 | cash_dividend | — | — | — | 0.4985870000 | ["tiingo"] | {"tiingo":"0.498587"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2020-06-22 | cash_dividend | — | — | — | 0.4757610000 | ["tiingo"] | {"tiingo":"0.475761"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2020-03-23 | cash_dividend | — | — | — | 0.4739610000 | ["tiingo"] | {"tiingo":"0.473961"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2019-12-20 | cash_dividend | — | — | — | 0.5010000000 | ["tiingo"] | {"tiingo":"0.501"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2019-09-20 | cash_dividend | — | — | — | 0.4921450000 | ["tiingo"] | {"tiingo":"0.492145"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2019-06-21 | cash_dividend | — | — | — | 0.4855000000 | ["tiingo"] | {"tiingo":"0.4855"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2019-03-15 | cash_dividend | — | — | — | 0.4302000000 | ["tiingo"] | {"tiingo":"0.4302"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2018-12-21 | cash_dividend | — | — | — | 0.4590000000 | ["tiingo"] | {"tiingo":"0.459"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2018-09-21 | cash_dividend | — | — | — | 0.4749000000 | ["tiingo"] | {"tiingo":"0.4749"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2018-06-15 | cash_dividend | — | — | — | 0.4405000000 | ["tiingo"] | {"tiingo":"0.4405"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2018-03-16 | cash_dividend | — | — | — | 0.3866470000 | ["tiingo"] | {"tiingo":"0.386647"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2017-12-15 | cash_dividend | — | — | — | 0.5112140000 | ["tiingo"] | {"tiingo":"0.511214"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2017-09-15 | cash_dividend | — | — | — | 0.4172420000 | ["tiingo"] | {"tiingo":"0.417242"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2017-06-16 | cash_dividend | — | — | — | 0.4368460000 | ["tiingo"] | {"tiingo":"0.436846"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2017-03-17 | cash_dividend | — | — | — | 0.3871910000 | ["tiingo"] | {"tiingo":"0.387191"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2016-12-16 | cash_dividend | — | — | — | 0.4631350000 | ["tiingo"] | {"tiingo":"0.463135"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2016-09-16 | cash_dividend | — | — | — | 0.4161190000 | ["tiingo"] | {"tiingo":"0.416119"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2016-06-17 | cash_dividend | — | — | — | 0.4116240000 | ["tiingo"] | {"tiingo":"0.411624"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2016-03-18 | cash_dividend | — | — | — | 0.3675020000 | ["tiingo"] | {"tiingo":"0.367502"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2015-12-18 | cash_dividend | — | — | — | 0.4452640000 | ["tiingo"] | {"tiingo":"0.445264"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2015-09-18 | cash_dividend | — | — | — | 0.4008910000 | ["tiingo"] | {"tiingo":"0.400891"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2015-06-19 | cash_dividend | — | — | — | 0.3926500000 | ["tiingo"] | {"tiingo":"0.39265"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2015-03-20 | cash_dividend | — | — | — | 0.3509100000 | ["tiingo"] | {"tiingo":"0.35091"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2014-12-19 | cash_dividend | — | — | — | 0.4168600000 | ["tiingo"] | {"tiingo":"0.41686"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2014-09-19 | cash_dividend | — | — | — | 0.3804300000 | ["tiingo"] | {"tiingo":"0.38043"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2014-06-20 | cash_dividend | — | — | — | 0.3738300000 | ["tiingo"] | {"tiingo":"0.37383"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |