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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLF | 1999-03-19 | cash_dividend | — | — | — | 0.0693140000 | ["tiingo"] | {"tiingo":"0.069314"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 1999-06-18 | cash_dividend | — | — | — | 0.0706120000 | ["tiingo"] | {"tiingo":"0.070612"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 1999-09-17 | cash_dividend | — | — | — | 0.0747990000 | ["tiingo"] | {"tiingo":"0.074799"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 1999-12-17 | cash_dividend | — | — | — | 0.0838430000 | ["tiingo"] | {"tiingo":"0.083843"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2000-03-17 | cash_dividend | — | — | — | 0.0847770000 | ["tiingo"] | {"tiingo":"0.084777"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2000-06-16 | cash_dividend | — | — | — | 0.0873510000 | ["tiingo"] | {"tiingo":"0.087351"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2000-09-15 | cash_dividend | — | — | — | 0.0879490000 | ["tiingo"] | {"tiingo":"0.087949"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2000-12-15 | cash_dividend | — | — | — | 0.1032000000 | ["tiingo"] | {"tiingo":"0.1032"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2001-03-16 | cash_dividend | — | — | — | 0.0871500000 | ["tiingo"] | {"tiingo":"0.08715"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2001-06-15 | cash_dividend | — | — | — | 0.1010900000 | ["tiingo"] | {"tiingo":"0.10109"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2001-09-21 | cash_dividend | — | — | — | 0.0988200000 | ["tiingo"] | {"tiingo":"0.09882"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2001-12-21 | cash_dividend | — | — | — | 0.1154400000 | ["tiingo"] | {"tiingo":"0.11544"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2002-03-15 | cash_dividend | — | — | — | 0.0895000000 | ["tiingo"] | {"tiingo":"0.0895"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2002-06-21 | cash_dividend | — | — | — | 0.1116100000 | ["tiingo"] | {"tiingo":"0.11161"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2002-09-20 | cash_dividend | — | — | — | 0.1123300000 | ["tiingo"] | {"tiingo":"0.11233"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2002-12-20 | cash_dividend | — | — | — | 0.1334000000 | ["tiingo"] | {"tiingo":"0.1334"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2003-03-21 | cash_dividend | — | — | — | 0.0972000000 | ["tiingo"] | {"tiingo":"0.0972"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2003-06-20 | cash_dividend | — | — | — | 0.1161400000 | ["tiingo"] | {"tiingo":"0.11614"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2003-09-19 | cash_dividend | — | — | — | 0.1389100000 | ["tiingo"] | {"tiingo":"0.13891"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2003-12-19 | cash_dividend | — | — | — | 0.1643800000 | ["tiingo"] | {"tiingo":"0.16438"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2004-03-19 | cash_dividend | — | — | — | 0.1341200000 | ["tiingo"] | {"tiingo":"0.13412"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2004-06-18 | cash_dividend | — | — | — | 0.1455700000 | ["tiingo"] | {"tiingo":"0.14557"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2004-09-17 | cash_dividend | — | — | — | 0.1584700000 | ["tiingo"] | {"tiingo":"0.15847"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2004-12-17 | cash_dividend | — | — | — | 0.1872900000 | ["tiingo"] | {"tiingo":"0.18729"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2005-03-18 | cash_dividend | — | — | — | 0.1547500000 | ["tiingo"] | {"tiingo":"0.15475"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2005-06-17 | cash_dividend | — | — | — | 0.1754600000 | ["tiingo"] | {"tiingo":"0.17546"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2005-09-16 | cash_dividend | — | — | — | 0.1723300000 | ["tiingo"] | {"tiingo":"0.17233"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2005-12-16 | cash_dividend | — | — | — | 0.2080400000 | ["tiingo"] | {"tiingo":"0.20804"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2006-03-17 | cash_dividend | — | — | — | 0.1770200000 | ["tiingo"] | {"tiingo":"0.17702"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2006-06-16 | cash_dividend | — | — | — | 0.1867052700 | ["tiingo"] | {"tiingo":"0.18670527"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2006-09-15 | cash_dividend | — | — | — | 0.2810300000 | ["tiingo"] | {"tiingo":"0.28103"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2006-12-15 | cash_dividend | — | — | — | 0.2810300000 | ["tiingo"] | {"tiingo":"0.28103"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2007-03-16 | cash_dividend | — | — | — | 0.1480600000 | ["tiingo"] | {"tiingo":"0.14806"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2007-06-15 | cash_dividend | — | — | — | 0.2038800000 | ["tiingo"] | {"tiingo":"0.20388"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2007-09-21 | cash_dividend | — | — | — | 0.2554000000 | ["tiingo"] | {"tiingo":"0.2554"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2007-12-21 | cash_dividend | — | — | — | 0.2614900000 | ["tiingo"] | {"tiingo":"0.26149"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2008-03-20 | cash_dividend | — | — | — | 0.1980500000 | ["tiingo"] | {"tiingo":"0.19805"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2008-06-20 | cash_dividend | — | — | — | 0.1996400000 | ["tiingo"] | {"tiingo":"0.19964"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2008-09-19 | cash_dividend | — | — | — | 0.1896000000 | ["tiingo"] | {"tiingo":"0.1896"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2008-12-19 | cash_dividend | — | — | — | 0.1825900000 | ["tiingo"] | {"tiingo":"0.18259"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2009-03-20 | cash_dividend | — | — | — | 0.0862241300 | ["tiingo"] | {"tiingo":"0.08622413"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2009-06-19 | cash_dividend | — | — | — | 0.0606200000 | ["tiingo"] | {"tiingo":"0.06062"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2009-09-18 | cash_dividend | — | — | — | 0.0470000000 | ["tiingo"] | {"tiingo":"0.047"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2009-12-18 | cash_dividend | — | — | — | 0.0523400000 | ["tiingo"] | {"tiingo":"0.05234"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2010-03-19 | cash_dividend | — | — | — | 0.0363600000 | ["tiingo"] | {"tiingo":"0.03636"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2010-06-18 | cash_dividend | — | — | — | 0.0305600000 | ["tiingo"] | {"tiingo":"0.03056"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2010-09-17 | cash_dividend | — | — | — | 0.0333300000 | ["tiingo"] | {"tiingo":"0.03333"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2010-12-17 | cash_dividend | — | — | — | 0.0561900000 | ["tiingo"] | {"tiingo":"0.05619"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2011-03-18 | cash_dividend | — | — | — | 0.0418700000 | ["tiingo"] | {"tiingo":"0.04187"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2011-06-17 | cash_dividend | — | — | — | 0.0528800000 | ["tiingo"] | {"tiingo":"0.05288"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |