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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLY | 2026-06-22 | cash_dividend | — | — | — | 0.2332200000 | ["tiingo"] | {"tiingo":"0.23322"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2026-03-23 | cash_dividend | — | — | — | 0.2156230000 | ["tiingo"] | {"tiingo":"0.215623"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2025-12-22 | cash_dividend | — | — | — | 0.2408480000 | ["tiingo"] | {"tiingo":"0.240848"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2025-12-05 | split | 2.000000000000000 | 2 | 1 | — | ["tiingo","yfinance"] | {"tiingo":"2.0","yfinance":"2.0"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2025-09-22 | cash_dividend | — | — | — | 0.4254550000 | ["tiingo"] | {"tiingo":"0.425455"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2025-06-23 | cash_dividend | — | — | — | 0.4470420000 | ["tiingo"] | {"tiingo":"0.447042"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2025-03-24 | cash_dividend | — | — | — | 0.5419560000 | ["tiingo"] | {"tiingo":"0.541956"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2024-12-23 | cash_dividend | — | — | — | 0.4331280000 | ["tiingo"] | {"tiingo":"0.433128"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2024-09-23 | cash_dividend | — | — | — | 0.4046680000 | ["tiingo"] | {"tiingo":"0.404668"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2024-06-24 | cash_dividend | — | — | — | 0.3918170000 | ["tiingo"] | {"tiingo":"0.391817"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2024-03-18 | cash_dividend | — | — | — | 0.3872490000 | ["tiingo"] | {"tiingo":"0.387249"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2023-12-18 | cash_dividend | — | — | — | 0.3204470000 | ["tiingo"] | {"tiingo":"0.320447"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2023-09-18 | cash_dividend | — | — | — | 0.3052730000 | ["tiingo"] | {"tiingo":"0.305273"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2023-06-20 | cash_dividend | — | — | — | 0.3343770000 | ["tiingo"] | {"tiingo":"0.334377"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2023-03-20 | cash_dividend | — | — | — | 0.4301670000 | ["tiingo"] | {"tiingo":"0.430167"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2022-12-19 | cash_dividend | — | — | — | 0.3658120000 | ["tiingo"] | {"tiingo":"0.365812"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2022-09-19 | cash_dividend | — | — | — | 0.3300450000 | ["tiingo"] | {"tiingo":"0.330045"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2022-06-21 | cash_dividend | — | — | — | 0.3142440000 | ["tiingo"] | {"tiingo":"0.314244"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2022-03-21 | cash_dividend | — | — | — | 0.2787610000 | ["tiingo"] | {"tiingo":"0.278761"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2021-12-20 | cash_dividend | — | — | — | 0.2922250000 | ["tiingo"] | {"tiingo":"0.292225"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2021-09-20 | cash_dividend | — | — | — | 0.2748920000 | ["tiingo"] | {"tiingo":"0.274892"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2021-06-21 | cash_dividend | — | — | — | 0.2553500000 | ["tiingo"] | {"tiingo":"0.25535"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2021-03-22 | cash_dividend | — | — | — | 0.2640590000 | ["tiingo"] | {"tiingo":"0.264059"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2020-12-21 | cash_dividend | — | — | — | 0.2961230000 | ["tiingo"] | {"tiingo":"0.296123"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2020-09-21 | cash_dividend | — | — | — | 0.3055940000 | ["tiingo"] | {"tiingo":"0.305594"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2020-06-22 | cash_dividend | — | — | — | 0.2960380000 | ["tiingo"] | {"tiingo":"0.296038"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2020-03-23 | cash_dividend | — | — | — | 0.4236600000 | ["tiingo"] | {"tiingo":"0.42366"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2019-12-20 | cash_dividend | — | — | — | 0.4100000000 | ["tiingo"] | {"tiingo":"0.41"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2019-09-20 | cash_dividend | — | — | — | 0.4043710000 | ["tiingo"] | {"tiingo":"0.404371"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2019-06-21 | cash_dividend | — | — | — | 0.4139000000 | ["tiingo"] | {"tiingo":"0.4139"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2019-03-15 | cash_dividend | — | — | — | 0.3754000000 | ["tiingo"] | {"tiingo":"0.3754"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2018-12-21 | cash_dividend | — | — | — | 0.3758000000 | ["tiingo"] | {"tiingo":"0.3758"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2018-09-21 | cash_dividend | — | — | — | 0.3512000000 | ["tiingo"] | {"tiingo":"0.3512"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2018-06-15 | cash_dividend | — | — | — | 0.2936000000 | ["tiingo"] | {"tiingo":"0.2936"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2018-03-16 | cash_dividend | — | — | — | 0.3098110000 | ["tiingo"] | {"tiingo":"0.309811"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2017-12-15 | cash_dividend | — | — | — | 0.3318650000 | ["tiingo"] | {"tiingo":"0.331865"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2017-09-15 | cash_dividend | — | — | — | 0.3179460000 | ["tiingo"] | {"tiingo":"0.317946"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2017-06-16 | cash_dividend | — | — | — | 0.2746250000 | ["tiingo"] | {"tiingo":"0.274625"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2017-03-17 | cash_dividend | — | — | — | 0.2605370000 | ["tiingo"] | {"tiingo":"0.260537"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2016-12-16 | cash_dividend | — | — | — | 0.4920600000 | ["tiingo"] | {"tiingo":"0.49206"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2016-09-16 | cash_dividend | — | — | — | 0.2999490000 | ["tiingo"] | {"tiingo":"0.299949"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2016-06-17 | cash_dividend | — | — | — | 0.2767000000 | ["tiingo"] | {"tiingo":"0.2767"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2016-03-18 | cash_dividend | — | — | — | 0.3210470000 | ["tiingo"] | {"tiingo":"0.321047"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2015-12-18 | cash_dividend | — | — | — | 0.3251790000 | ["tiingo"] | {"tiingo":"0.325179"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2015-09-18 | cash_dividend | — | — | — | 0.2889730000 | ["tiingo"] | {"tiingo":"0.288973"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2015-06-19 | cash_dividend | — | — | — | 0.2469900000 | ["tiingo"] | {"tiingo":"0.24699"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2015-03-20 | cash_dividend | — | — | — | 0.2552700000 | ["tiingo"] | {"tiingo":"0.25527"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2014-12-19 | cash_dividend | — | — | — | 0.2931400000 | ["tiingo"] | {"tiingo":"0.29314"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2014-09-19 | cash_dividend | — | — | — | 0.2286100000 | ["tiingo"] | {"tiingo":"0.22861"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2014-06-20 | cash_dividend | — | — | — | 0.2124100000 | ["tiingo"] | {"tiingo":"0.21241"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |