core.corporate_actions
Splits, cash dividends and price factors. The second half of the PIT price spine - these are what core.prices_asof() applies.
Simplify Analyticstiingo_prices3,264 rowsexportableex_date leads no index, so this sort reads every matching row and keeps only the top 150 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 | source |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| XLE | 2002-03-15 | cash_dividend | — | — | — | 0.0958200000 | ["tiingo"] | {"tiingo":"0.09582"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2001-12-21 | cash_dividend | — | — | — | 0.1056100000 | ["tiingo"] | {"tiingo":"0.10561"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2001-09-21 | cash_dividend | — | — | — | 0.1414600000 | ["tiingo"] | {"tiingo":"0.14146"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2001-06-15 | cash_dividend | — | — | — | 0.1510200000 | ["tiingo"] | {"tiingo":"0.15102"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2001-03-16 | cash_dividend | — | — | — | 0.0965900000 | ["tiingo"] | {"tiingo":"0.09659"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2000-12-15 | cash_dividend | — | — | — | 0.0911400000 | ["tiingo"] | {"tiingo":"0.09114"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2000-09-15 | cash_dividend | — | — | — | 0.1429770000 | ["tiingo"] | {"tiingo":"0.142977"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2000-06-16 | cash_dividend | — | — | — | 0.1508000000 | ["tiingo"] | {"tiingo":"0.1508"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2000-03-17 | cash_dividend | — | — | — | 0.0964000000 | ["tiingo"] | {"tiingo":"0.0964"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 1999-12-17 | cash_dividend | — | — | — | 0.0801500000 | ["tiingo"] | {"tiingo":"0.08015"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 1999-09-17 | cash_dividend | — | — | — | 0.1304370000 | ["tiingo"] | {"tiingo":"0.130437"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 1999-06-18 | cash_dividend | — | — | — | 0.1462960000 | ["tiingo"] | {"tiingo":"0.146296"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 1999-03-19 | cash_dividend | — | — | — | 0.0896990000 | ["tiingo"] | {"tiingo":"0.089699"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |