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 100 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 | 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 |
| XLE | 2014-06-20 | cash_dividend | — | — | — | 0.4635300000 | ["tiingo"] | {"tiingo":"0.46353"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2014-03-21 | cash_dividend | — | — | — | 0.4270700000 | ["tiingo"] | {"tiingo":"0.42707"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2013-12-20 | cash_dividend | — | — | — | 0.4026800000 | ["tiingo"] | {"tiingo":"0.40268"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2013-09-20 | cash_dividend | — | — | — | 0.3926600000 | ["tiingo"] | {"tiingo":"0.39266"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2013-06-21 | cash_dividend | — | — | — | 0.3743800000 | ["tiingo"] | {"tiingo":"0.37438"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2013-03-15 | cash_dividend | — | — | — | 0.3571000000 | ["tiingo"] | {"tiingo":"0.3571"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2012-12-21 | cash_dividend | — | — | — | 0.3709500000 | ["tiingo"] | {"tiingo":"0.37095"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2012-09-21 | cash_dividend | — | — | — | 0.3336900000 | ["tiingo"] | {"tiingo":"0.33369"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2012-06-15 | cash_dividend | — | — | — | 0.3110900000 | ["tiingo"] | {"tiingo":"0.31109"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2012-03-16 | cash_dividend | — | — | — | 0.2846200000 | ["tiingo"] | {"tiingo":"0.28462"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2011-12-16 | cash_dividend | — | — | — | 0.2773800000 | ["tiingo"] | {"tiingo":"0.27738"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2011-09-16 | cash_dividend | — | — | — | 0.2644400000 | ["tiingo"] | {"tiingo":"0.26444"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2011-06-17 | cash_dividend | — | — | — | 0.2645700000 | ["tiingo"] | {"tiingo":"0.26457"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2011-03-18 | cash_dividend | — | — | — | 0.2549000000 | ["tiingo"] | {"tiingo":"0.2549"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2010-12-17 | cash_dividend | — | — | — | 0.2929100000 | ["tiingo"] | {"tiingo":"0.29291"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2010-09-17 | cash_dividend | — | — | — | 0.2491900000 | ["tiingo"] | {"tiingo":"0.24919"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2010-06-18 | cash_dividend | — | — | — | 0.2515700000 | ["tiingo"] | {"tiingo":"0.25157"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2010-03-19 | cash_dividend | — | — | — | 0.2032600000 | ["tiingo"] | {"tiingo":"0.20326"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2009-12-18 | cash_dividend | — | — | — | 0.3044700000 | ["tiingo"] | {"tiingo":"0.30447"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2009-09-18 | cash_dividend | — | — | — | 0.2462500000 | ["tiingo"] | {"tiingo":"0.24625"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2009-06-19 | cash_dividend | — | — | — | 0.2535800000 | ["tiingo"] | {"tiingo":"0.25358"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2009-03-20 | cash_dividend | — | — | — | 0.2297898900 | ["tiingo"] | {"tiingo":"0.22978989"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2008-12-19 | cash_dividend | — | — | — | 0.2387900000 | ["tiingo"] | {"tiingo":"0.23879"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2008-09-19 | cash_dividend | — | — | — | 0.2150900000 | ["tiingo"] | {"tiingo":"0.21509"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2008-06-20 | cash_dividend | — | — | — | 0.2283800000 | ["tiingo"] | {"tiingo":"0.22838"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2008-03-20 | cash_dividend | — | — | — | 0.2028100000 | ["tiingo"] | {"tiingo":"0.20281"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2007-12-21 | cash_dividend | — | — | — | 0.1988000000 | ["tiingo"] | {"tiingo":"0.1988"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2007-09-21 | cash_dividend | — | — | — | 0.1976600000 | ["tiingo"] | {"tiingo":"0.19766"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2007-06-15 | cash_dividend | — | — | — | 0.2032200000 | ["tiingo"] | {"tiingo":"0.20322"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2007-03-16 | cash_dividend | — | — | — | 0.1869200000 | ["tiingo"] | {"tiingo":"0.18692"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2006-12-15 | cash_dividend | — | — | — | 0.1836900000 | ["tiingo"] | {"tiingo":"0.18369"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2006-09-15 | cash_dividend | — | — | — | 0.1836900000 | ["tiingo"] | {"tiingo":"0.18369"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2006-06-16 | cash_dividend | — | — | — | 0.1974628600 | ["tiingo"] | {"tiingo":"0.19746286"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2006-03-17 | cash_dividend | — | — | — | 0.1614300000 | ["tiingo"] | {"tiingo":"0.16143"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2005-12-16 | cash_dividend | — | — | — | 0.1367800000 | ["tiingo"] | {"tiingo":"0.13678"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2005-09-16 | cash_dividend | — | — | — | 0.1476100000 | ["tiingo"] | {"tiingo":"0.14761"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2005-06-17 | cash_dividend | — | — | — | 0.1405700000 | ["tiingo"] | {"tiingo":"0.14057"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2005-03-18 | cash_dividend | — | — | — | 0.1444000000 | ["tiingo"] | {"tiingo":"0.1444"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2004-12-17 | cash_dividend | — | — | — | 0.1309000000 | ["tiingo"] | {"tiingo":"0.1309"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2004-09-17 | cash_dividend | — | — | — | 0.1330600000 | ["tiingo"] | {"tiingo":"0.13306"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2004-06-18 | cash_dividend | — | — | — | 0.1236900000 | ["tiingo"] | {"tiingo":"0.12369"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2004-03-19 | cash_dividend | — | — | — | 0.1266400000 | ["tiingo"] | {"tiingo":"0.12664"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2003-12-19 | cash_dividend | — | — | — | 0.1221700000 | ["tiingo"] | {"tiingo":"0.12217"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2003-09-19 | cash_dividend | — | — | — | 0.1206400000 | ["tiingo"] | {"tiingo":"0.12064"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2003-06-20 | cash_dividend | — | — | — | 0.1181000000 | ["tiingo"] | {"tiingo":"0.1181"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2003-03-21 | cash_dividend | — | — | — | 0.1194100000 | ["tiingo"] | {"tiingo":"0.11941"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2002-12-20 | cash_dividend | — | — | — | 0.1154900000 | ["tiingo"] | {"tiingo":"0.11549"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2002-09-20 | cash_dividend | — | — | — | 0.1154900000 | ["tiingo"] | {"tiingo":"0.11549"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLE | 2002-06-21 | cash_dividend | — | — | — | 0.1557900000 | ["tiingo"] | {"tiingo":"0.15579"} | tiingo_prices | /tiingo/daily/XLE/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |