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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLU | 1999-03-19 | cash_dividend | — | — | — | 0.1890560000 | ["tiingo"] | {"tiingo":"0.189056"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 1999-06-18 | cash_dividend | — | — | — | 0.1865430000 | ["tiingo"] | {"tiingo":"0.186543"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 1999-09-17 | cash_dividend | — | — | — | 0.2226040000 | ["tiingo"] | {"tiingo":"0.222604"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 1999-12-17 | cash_dividend | — | — | — | 0.3651830000 | ["tiingo"] | {"tiingo":"0.365183"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2000-03-17 | cash_dividend | — | — | — | 0.1968750000 | ["tiingo"] | {"tiingo":"0.196875"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2000-06-16 | cash_dividend | — | — | — | 0.2212460000 | ["tiingo"] | {"tiingo":"0.221246"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2000-09-15 | cash_dividend | — | — | — | 0.2514150000 | ["tiingo"] | {"tiingo":"0.251415"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2000-12-15 | cash_dividend | — | — | — | 0.4919700000 | ["tiingo"] | {"tiingo":"0.49197"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2000-12-18 | cash_dividend | — | — | — | 0.2535100000 | ["tiingo"] | {"tiingo":"0.25351"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2001-03-16 | cash_dividend | — | — | — | 0.2147500000 | ["tiingo"] | {"tiingo":"0.21475"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2001-06-15 | cash_dividend | — | — | — | 0.2191000000 | ["tiingo"] | {"tiingo":"0.2191"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2001-09-21 | cash_dividend | — | — | — | 0.2313900000 | ["tiingo"] | {"tiingo":"0.23139"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2001-12-21 | cash_dividend | — | — | — | 0.2147500000 | ["tiingo"] | {"tiingo":"0.21475"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2002-03-15 | cash_dividend | — | — | — | 0.2237800000 | ["tiingo"] | {"tiingo":"0.22378"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2002-06-21 | cash_dividend | — | — | — | 0.2368600000 | ["tiingo"] | {"tiingo":"0.23686"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2002-09-20 | cash_dividend | — | — | — | 0.2321900000 | ["tiingo"] | {"tiingo":"0.23219"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2002-12-20 | cash_dividend | — | — | — | 0.2273600000 | ["tiingo"] | {"tiingo":"0.22736"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2003-03-21 | cash_dividend | — | — | — | 0.1966900000 | ["tiingo"] | {"tiingo":"0.19669"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2003-06-20 | cash_dividend | — | — | — | 0.1933100000 | ["tiingo"] | {"tiingo":"0.19331"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2003-09-19 | cash_dividend | — | — | — | 0.1945200000 | ["tiingo"] | {"tiingo":"0.19452"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2003-12-19 | cash_dividend | — | — | — | 0.2117500000 | ["tiingo"] | {"tiingo":"0.21175"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2004-03-19 | cash_dividend | — | — | — | 0.1984200000 | ["tiingo"] | {"tiingo":"0.19842"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2004-06-18 | cash_dividend | — | — | — | 0.2050600000 | ["tiingo"] | {"tiingo":"0.20506"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2004-09-17 | cash_dividend | — | — | — | 0.2090700000 | ["tiingo"] | {"tiingo":"0.20907"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2004-12-17 | cash_dividend | — | — | — | 0.2623100000 | ["tiingo"] | {"tiingo":"0.26231"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2005-03-18 | cash_dividend | — | — | — | 0.2216500000 | ["tiingo"] | {"tiingo":"0.22165"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2005-06-17 | cash_dividend | — | — | — | 0.2492900000 | ["tiingo"] | {"tiingo":"0.24929"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2005-09-16 | cash_dividend | — | — | — | 0.2509700000 | ["tiingo"] | {"tiingo":"0.25097"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2005-12-16 | cash_dividend | — | — | — | 0.2883100000 | ["tiingo"] | {"tiingo":"0.28831"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2006-03-17 | cash_dividend | — | — | — | 0.2423900000 | ["tiingo"] | {"tiingo":"0.24239"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2006-06-16 | cash_dividend | — | — | — | 0.2693204400 | ["tiingo"] | {"tiingo":"0.26932044"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2006-09-15 | cash_dividend | — | — | — | 0.3362700000 | ["tiingo"] | {"tiingo":"0.33627"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2006-12-15 | cash_dividend | — | — | — | 0.3362700000 | ["tiingo"] | {"tiingo":"0.33627"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2007-03-16 | cash_dividend | — | — | — | 0.2084500000 | ["tiingo"] | {"tiingo":"0.20845"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2007-06-15 | cash_dividend | — | — | — | 0.2756000000 | ["tiingo"] | {"tiingo":"0.2756"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2007-09-21 | cash_dividend | — | — | — | 0.2844700000 | ["tiingo"] | {"tiingo":"0.28447"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2007-12-21 | cash_dividend | — | — | — | 0.3271800000 | ["tiingo"] | {"tiingo":"0.32718"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2008-03-20 | cash_dividend | — | — | — | 0.2709900000 | ["tiingo"] | {"tiingo":"0.27099"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2008-06-20 | cash_dividend | — | — | — | 0.3051300000 | ["tiingo"] | {"tiingo":"0.30513"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2008-09-19 | cash_dividend | — | — | — | 0.3003400000 | ["tiingo"] | {"tiingo":"0.30034"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2008-12-19 | cash_dividend | — | — | — | 0.3591100000 | ["tiingo"] | {"tiingo":"0.35911"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2009-03-20 | cash_dividend | — | — | — | 0.2817259000 | ["tiingo"] | {"tiingo":"0.2817259"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2009-06-19 | cash_dividend | — | — | — | 0.3169000000 | ["tiingo"] | {"tiingo":"0.3169"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2009-09-18 | cash_dividend | — | — | — | 0.3053700000 | ["tiingo"] | {"tiingo":"0.30537"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2009-12-18 | cash_dividend | — | — | — | 0.3690900000 | ["tiingo"] | {"tiingo":"0.36909"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2010-03-19 | cash_dividend | — | — | — | 0.2665700000 | ["tiingo"] | {"tiingo":"0.26657"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2010-06-18 | cash_dividend | — | — | — | 0.3166100000 | ["tiingo"] | {"tiingo":"0.31661"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2010-09-17 | cash_dividend | — | — | — | 0.3171200000 | ["tiingo"] | {"tiingo":"0.31712"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2010-12-17 | cash_dividend | — | — | — | 0.3704800000 | ["tiingo"] | {"tiingo":"0.37048"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLU | 2011-03-18 | cash_dividend | — | — | — | 0.3025200000 | ["tiingo"] | {"tiingo":"0.30252"} | tiingo_prices | /tiingo/daily/XLU/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |