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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLP | 1999-03-19 | cash_dividend | — | — | — | 0.0489560000 | ["tiingo"] | {"tiingo":"0.048956"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 1999-06-18 | cash_dividend | — | — | — | 0.1003100000 | ["tiingo"] | {"tiingo":"0.10031"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 1999-09-17 | cash_dividend | — | — | — | 0.0553710000 | ["tiingo"] | {"tiingo":"0.055371"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 1999-12-17 | cash_dividend | — | — | — | 0.0667400000 | ["tiingo"] | {"tiingo":"0.06674"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2000-03-17 | cash_dividend | — | — | — | 0.0683310000 | ["tiingo"] | {"tiingo":"0.068331"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2000-06-16 | cash_dividend | — | — | — | 0.0567320000 | ["tiingo"] | {"tiingo":"0.056732"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2000-09-15 | cash_dividend | — | — | — | 0.0902640000 | ["tiingo"] | {"tiingo":"0.090264"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2000-12-15 | cash_dividend | — | — | — | 0.0807500000 | ["tiingo"] | {"tiingo":"0.08075"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2001-03-16 | cash_dividend | — | — | — | 0.0724600000 | ["tiingo"] | {"tiingo":"0.07246"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2001-06-15 | cash_dividend | — | — | — | 0.0806600000 | ["tiingo"] | {"tiingo":"0.08066"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2001-09-21 | cash_dividend | — | — | — | 0.0772900000 | ["tiingo"] | {"tiingo":"0.07729"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2001-12-21 | cash_dividend | — | — | — | 0.0900300000 | ["tiingo"] | {"tiingo":"0.09003"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2002-03-15 | cash_dividend | — | — | — | 0.0746200000 | ["tiingo"] | {"tiingo":"0.07462"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2002-06-21 | cash_dividend | — | — | — | 0.0721700000 | ["tiingo"] | {"tiingo":"0.07217"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2002-09-20 | cash_dividend | — | — | — | 0.1320300000 | ["tiingo"] | {"tiingo":"0.13203"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2002-12-20 | cash_dividend | — | — | — | 0.1052800000 | ["tiingo"] | {"tiingo":"0.10528"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2003-03-21 | cash_dividend | — | — | — | 0.1047100000 | ["tiingo"] | {"tiingo":"0.10471"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2003-06-20 | cash_dividend | — | — | — | 0.0917800000 | ["tiingo"] | {"tiingo":"0.09178"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2003-09-19 | cash_dividend | — | — | — | 0.0712400000 | ["tiingo"] | {"tiingo":"0.07124"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2003-12-19 | cash_dividend | — | — | — | 0.0907500000 | ["tiingo"] | {"tiingo":"0.09075"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2004-03-19 | cash_dividend | — | — | — | 0.0815200000 | ["tiingo"] | {"tiingo":"0.08152"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2004-06-18 | cash_dividend | — | — | — | 0.0867500000 | ["tiingo"] | {"tiingo":"0.08675"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2004-09-17 | cash_dividend | — | — | — | 0.0929400000 | ["tiingo"] | {"tiingo":"0.09294"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2004-12-17 | cash_dividend | — | — | — | 0.0952700000 | ["tiingo"] | {"tiingo":"0.09527"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2005-03-18 | cash_dividend | — | — | — | 0.0955300000 | ["tiingo"] | {"tiingo":"0.09553"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2005-06-17 | cash_dividend | — | — | — | 0.1122800000 | ["tiingo"] | {"tiingo":"0.11228"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2005-09-16 | cash_dividend | — | — | — | 0.1144800000 | ["tiingo"] | {"tiingo":"0.11448"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2005-12-16 | cash_dividend | — | — | — | 0.1204000000 | ["tiingo"] | {"tiingo":"0.1204"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2006-03-17 | cash_dividend | — | — | — | 0.1261600000 | ["tiingo"] | {"tiingo":"0.12616"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2006-06-16 | cash_dividend | — | — | — | 0.1266196300 | ["tiingo"] | {"tiingo":"0.12661963"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2006-09-15 | cash_dividend | — | — | — | 0.1318000000 | ["tiingo"] | {"tiingo":"0.1318"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2006-12-15 | cash_dividend | — | — | — | 0.1318000000 | ["tiingo"] | {"tiingo":"0.1318"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2007-03-16 | cash_dividend | — | — | — | 0.1290200000 | ["tiingo"] | {"tiingo":"0.12902"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2007-06-15 | cash_dividend | — | — | — | 0.1691700000 | ["tiingo"] | {"tiingo":"0.16917"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2007-09-21 | cash_dividend | — | — | — | 0.1538200000 | ["tiingo"] | {"tiingo":"0.15382"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2007-12-21 | cash_dividend | — | — | — | 0.1472100000 | ["tiingo"] | {"tiingo":"0.14721"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2008-03-20 | cash_dividend | — | — | — | 0.1463600000 | ["tiingo"] | {"tiingo":"0.14636"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2008-06-20 | cash_dividend | — | — | — | 0.1190300000 | ["tiingo"] | {"tiingo":"0.11903"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2008-09-19 | cash_dividend | — | — | — | 0.1890100000 | ["tiingo"] | {"tiingo":"0.18901"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2008-12-19 | cash_dividend | — | — | — | 0.2000000000 | ["tiingo"] | {"tiingo":"0.2"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2009-03-20 | cash_dividend | — | — | — | 0.1228248000 | ["tiingo"] | {"tiingo":"0.1228248"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2009-06-19 | cash_dividend | — | — | — | 0.1770200000 | ["tiingo"] | {"tiingo":"0.17702"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2009-09-18 | cash_dividend | — | — | — | 0.1786400000 | ["tiingo"] | {"tiingo":"0.17864"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2009-12-18 | cash_dividend | — | — | — | 0.1714100000 | ["tiingo"] | {"tiingo":"0.17141"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2010-03-19 | cash_dividend | — | — | — | 0.1182500000 | ["tiingo"] | {"tiingo":"0.11825"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2010-06-18 | cash_dividend | — | — | — | 0.1921300000 | ["tiingo"] | {"tiingo":"0.19213"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2010-09-17 | cash_dividend | — | — | — | 0.1974600000 | ["tiingo"] | {"tiingo":"0.19746"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2010-12-17 | cash_dividend | — | — | — | 0.2555400000 | ["tiingo"] | {"tiingo":"0.25554"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2011-03-18 | cash_dividend | — | — | — | 0.1640700000 | ["tiingo"] | {"tiingo":"0.16407"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLP | 2011-06-17 | cash_dividend | — | — | — | 0.2169400000 | ["tiingo"] | {"tiingo":"0.21694"} | tiingo_prices | /tiingo/daily/XLP/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |