Simplify AnalyticsCorporate 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 = XLE×
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLE | 2026-06-22 | cash_dividend | — | — | — | 0.3848760000 | ["tiingo"] | {"tiingo":"0.384876"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2026-03-23 | cash_dividend | — | — | — | 0.3851780000 | ["tiingo"] | {"tiingo":"0.385178"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2025-12-22 | cash_dividend | — | — | — | 0.3730150000 | ["tiingo"] | {"tiingo":"0.373015"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2025-12-05 | split | 2.000000000000000 | 2 | 1 | — | ["tiingo","yfinance"] | {"tiingo":"2.0","yfinance":"2.0"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2025-09-22 | cash_dividend | — | — | — | 0.7487310000 | ["tiingo"] | {"tiingo":"0.748731"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2025-06-23 | cash_dividend | — | — | — | 0.7182580000 | ["tiingo"] | {"tiingo":"0.718258"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2025-03-24 | cash_dividend | — | — | — | 0.7163300000 | ["tiingo"] | {"tiingo":"0.71633"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2024-12-23 | cash_dividend | — | — | — | 0.6999890000 | ["tiingo"] | {"tiingo":"0.699989"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2024-09-23 | cash_dividend | — | — | — | 0.7274920000 | ["tiingo"] | {"tiingo":"0.727492"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2024-06-24 | cash_dividend | — | — | — | 0.7148390000 | ["tiingo"] | {"tiingo":"0.714839"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2024-03-18 | cash_dividend | — | — | — | 0.7339330000 | ["tiingo"] | {"tiingo":"0.733933"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2023-12-18 | cash_dividend | — | — | — | 0.8021390000 | ["tiingo"] | {"tiingo":"0.802139"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2023-09-18 | cash_dividend | — | — | — | 0.6736080000 | ["tiingo"] | {"tiingo":"0.673608"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2023-06-20 | cash_dividend | — | — | — | 0.7058430000 | ["tiingo"] | {"tiingo":"0.705843"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2023-03-20 | cash_dividend | — | — | — | 0.7953470000 | ["tiingo"] | {"tiingo":"0.795347"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2022-12-19 | cash_dividend | — | — | — | 0.8596300000 | ["tiingo"] | {"tiingo":"0.85963"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2022-09-19 | cash_dividend | — | — | — | 0.8462450000 | ["tiingo"] | {"tiingo":"0.846245"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2022-06-21 | cash_dividend | — | — | — | 0.8150610000 | ["tiingo"] | {"tiingo":"0.815061"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2022-03-21 | cash_dividend | — | — | — | 0.6999620000 | ["tiingo"] | {"tiingo":"0.699962"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2021-12-20 | cash_dividend | — | — | — | 0.6950150000 | ["tiingo"] | {"tiingo":"0.695015"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2021-09-20 | cash_dividend | — | — | — | 0.5919010000 | ["tiingo"] | {"tiingo":"0.591901"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2021-06-21 | cash_dividend | — | — | — | 0.5302910000 | ["tiingo"] | {"tiingo":"0.530291"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2021-03-22 | cash_dividend | — | — | — | 0.5199440000 | ["tiingo"] | {"tiingo":"0.519944"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2020-12-21 | cash_dividend | — | — | — | 0.5201000000 | ["tiingo"] | {"tiingo":"0.5201"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2020-09-21 | cash_dividend | — | — | — | 0.5435710000 | ["tiingo"] | {"tiingo":"0.543571"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2020-06-22 | cash_dividend | — | — | — | 0.5010410000 | ["tiingo"] | {"tiingo":"0.501041"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2020-03-23 | cash_dividend | — | — | — | 0.5657560000 | ["tiingo"] | {"tiingo":"0.565756"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2019-12-30 | cash_dividend | — | — | — | 1.7910000000 | ["tiingo"] | {"tiingo":"1.791"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2019-12-20 | cash_dividend | — | — | — | 0.5930000000 | ["tiingo"] | {"tiingo":"0.593"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2019-09-20 | cash_dividend | — | — | — | 0.5604550000 | ["tiingo"] | {"tiingo":"0.560455"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2019-06-21 | cash_dividend | — | — | — | 0.5765000000 | ["tiingo"] | {"tiingo":"0.5765"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2019-03-15 | cash_dividend | — | — | — | 0.5136000000 | ["tiingo"] | {"tiingo":"0.5136"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2018-12-21 | cash_dividend | — | — | — | 0.5300000000 | ["tiingo"] | {"tiingo":"0.53"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2018-09-21 | cash_dividend | — | — | — | 0.5132000000 | ["tiingo"] | {"tiingo":"0.5132"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2018-06-15 | cash_dividend | — | — | — | 0.5124000000 | ["tiingo"] | {"tiingo":"0.5124"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2018-03-16 | cash_dividend | — | — | — | 0.4747880000 | ["tiingo"] | {"tiingo":"0.474788"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2017-12-15 | cash_dividend | — | — | — | 0.4583290000 | ["tiingo"] | {"tiingo":"0.458329"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2017-09-15 | cash_dividend | — | — | — | 0.8653790000 | ["tiingo"] | {"tiingo":"0.865379"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2017-06-16 | cash_dividend | — | — | — | 0.4491470000 | ["tiingo"] | {"tiingo":"0.449147"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2017-03-17 | cash_dividend | — | — | — | 0.4190150000 | ["tiingo"] | {"tiingo":"0.419015"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2016-12-16 | cash_dividend | — | — | — | 0.4023640000 | ["tiingo"] | {"tiingo":"0.402364"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2016-09-16 | cash_dividend | — | — | — | 0.4105180000 | ["tiingo"] | {"tiingo":"0.410518"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2016-06-17 | cash_dividend | — | — | — | 0.4364310000 | ["tiingo"] | {"tiingo":"0.436431"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2016-03-18 | cash_dividend | — | — | — | 0.4524070000 | ["tiingo"] | {"tiingo":"0.452407"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2015-12-18 | cash_dividend | — | — | — | 0.5422360000 | ["tiingo"] | {"tiingo":"0.542236"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2015-09-18 | cash_dividend | — | — | — | 0.4781120000 | ["tiingo"] | {"tiingo":"0.478112"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2015-06-19 | cash_dividend | — | — | — | 0.5088200000 | ["tiingo"] | {"tiingo":"0.50882"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2015-03-20 | cash_dividend | — | — | — | 0.5149400000 | ["tiingo"] | {"tiingo":"0.51494"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2014-12-19 | cash_dividend | — | — | — | 0.4854200000 | ["tiingo"] | {"tiingo":"0.48542"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2014-09-19 | cash_dividend | — | — | — | 0.4832700000 | ["tiingo"] | {"tiingo":"0.48327"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |