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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLV | 1999-12-20 | cash_dividend | — | — | — | 0.1761700000 | ["tiingo"] | {"tiingo":"0.17617"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2000-12-15 | cash_dividend | — | — | — | 0.0589800000 | ["tiingo"] | {"tiingo":"0.05898"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2001-03-16 | cash_dividend | — | — | — | 0.0051100000 | ["tiingo"] | {"tiingo":"0.00511"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2001-06-15 | cash_dividend | — | — | — | 0.0119200000 | ["tiingo"] | {"tiingo":"0.01192"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2001-09-21 | cash_dividend | — | — | — | 0.0091100000 | ["tiingo"] | {"tiingo":"0.00911"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2001-12-21 | cash_dividend | — | — | — | 0.0472100000 | ["tiingo"] | {"tiingo":"0.04721"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2002-03-15 | cash_dividend | — | — | — | 0.0125300000 | ["tiingo"] | {"tiingo":"0.01253"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2002-06-21 | cash_dividend | — | — | — | 0.0065400000 | ["tiingo"] | {"tiingo":"0.00654"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2002-09-20 | cash_dividend | — | — | — | 0.0791400000 | ["tiingo"] | {"tiingo":"0.07914"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2002-12-20 | cash_dividend | — | — | — | 0.0988100000 | ["tiingo"] | {"tiingo":"0.09881"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2003-03-21 | cash_dividend | — | — | — | 0.0717000000 | ["tiingo"] | {"tiingo":"0.0717"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2003-06-20 | cash_dividend | — | — | — | 0.0858800000 | ["tiingo"] | {"tiingo":"0.08588"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2003-09-19 | cash_dividend | — | — | — | 0.0864900000 | ["tiingo"] | {"tiingo":"0.08649"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2003-12-19 | cash_dividend | — | — | — | 0.1026200000 | ["tiingo"] | {"tiingo":"0.10262"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2004-03-19 | cash_dividend | — | — | — | 0.0747900000 | ["tiingo"] | {"tiingo":"0.07479"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2004-06-18 | cash_dividend | — | — | — | 0.0859500000 | ["tiingo"] | {"tiingo":"0.08595"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2004-09-17 | cash_dividend | — | — | — | 0.0887400000 | ["tiingo"] | {"tiingo":"0.08874"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2004-12-17 | cash_dividend | — | — | — | 0.0931400000 | ["tiingo"] | {"tiingo":"0.09314"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2005-03-18 | cash_dividend | — | — | — | 0.1005700000 | ["tiingo"] | {"tiingo":"0.10057"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2005-06-17 | cash_dividend | — | — | — | 0.0960300000 | ["tiingo"] | {"tiingo":"0.09603"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2005-09-16 | cash_dividend | — | — | — | 0.0955500000 | ["tiingo"] | {"tiingo":"0.09555"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2005-12-16 | cash_dividend | — | — | — | 0.1035700000 | ["tiingo"] | {"tiingo":"0.10357"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2006-03-17 | cash_dividend | — | — | — | 0.1065400000 | ["tiingo"] | {"tiingo":"0.10654"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2006-06-16 | cash_dividend | — | — | — | 0.1107700000 | ["tiingo"] | {"tiingo":"0.11077"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2006-09-15 | cash_dividend | — | — | — | 0.1171300000 | ["tiingo"] | {"tiingo":"0.11713"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2006-12-15 | cash_dividend | — | — | — | 0.1171300000 | ["tiingo"] | {"tiingo":"0.11713"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2007-03-16 | cash_dividend | — | — | — | 0.1243700000 | ["tiingo"] | {"tiingo":"0.12437"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2007-06-15 | cash_dividend | — | — | — | 0.1933000000 | ["tiingo"] | {"tiingo":"0.1933"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2007-09-21 | cash_dividend | — | — | — | 0.1227600000 | ["tiingo"] | {"tiingo":"0.12276"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2007-12-21 | cash_dividend | — | — | — | 0.1303400000 | ["tiingo"] | {"tiingo":"0.13034"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2008-03-20 | cash_dividend | — | — | — | 0.1392300000 | ["tiingo"] | {"tiingo":"0.13923"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2008-06-20 | cash_dividend | — | — | — | 0.1424000000 | ["tiingo"] | {"tiingo":"0.1424"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2008-09-19 | cash_dividend | — | — | — | 0.1424100000 | ["tiingo"] | {"tiingo":"0.14241"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2008-12-19 | cash_dividend | — | — | — | 0.1578700000 | ["tiingo"] | {"tiingo":"0.15787"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2009-03-20 | cash_dividend | — | — | — | 0.1462367400 | ["tiingo"] | {"tiingo":"0.14623674"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2009-06-19 | cash_dividend | — | — | — | 0.1295900000 | ["tiingo"] | {"tiingo":"0.12959"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2009-09-18 | cash_dividend | — | — | — | 0.1271700000 | ["tiingo"] | {"tiingo":"0.12717"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2009-12-18 | cash_dividend | — | — | — | 0.1714100000 | ["tiingo"] | {"tiingo":"0.17141"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2010-03-19 | cash_dividend | — | — | — | 0.1080300000 | ["tiingo"] | {"tiingo":"0.10803"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2010-06-18 | cash_dividend | — | — | — | 0.1512500000 | ["tiingo"] | {"tiingo":"0.15125"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2010-09-17 | cash_dividend | — | — | — | 0.1539700000 | ["tiingo"] | {"tiingo":"0.15397"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2010-12-17 | cash_dividend | — | — | — | 0.1643200000 | ["tiingo"] | {"tiingo":"0.16432"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2011-03-18 | cash_dividend | — | — | — | 0.1451300000 | ["tiingo"] | {"tiingo":"0.14513"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2011-06-17 | cash_dividend | — | — | — | 0.1699100000 | ["tiingo"] | {"tiingo":"0.16991"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2011-09-16 | cash_dividend | — | — | — | 0.1773200000 | ["tiingo"] | {"tiingo":"0.17732"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2011-12-16 | cash_dividend | — | — | — | 0.1883700000 | ["tiingo"] | {"tiingo":"0.18837"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2012-03-16 | cash_dividend | — | — | — | 0.1864900000 | ["tiingo"] | {"tiingo":"0.18649"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2012-06-15 | cash_dividend | — | — | — | 0.1986600000 | ["tiingo"] | {"tiingo":"0.19866"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2012-09-21 | cash_dividend | — | — | — | 0.1985000000 | ["tiingo"] | {"tiingo":"0.1985"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLV | 2012-12-21 | cash_dividend | — | — | — | 0.2188900000 | ["tiingo"] | {"tiingo":"0.21889"} | tiingo_prices | /tiingo/daily/XLV/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |