Simplify AnalyticsCorporate 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XLY | 1999-03-19 | cash_dividend | — | — | — | 0.0319950000 | ["tiingo"] | {"tiingo":"0.031995"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 1999-06-18 | cash_dividend | — | — | — | 0.0378770000 | ["tiingo"] | {"tiingo":"0.037877"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 1999-09-17 | cash_dividend | — | — | — | 0.0374250000 | ["tiingo"] | {"tiingo":"0.037425"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 1999-12-17 | cash_dividend | — | — | — | 0.0380580000 | ["tiingo"] | {"tiingo":"0.038058"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2000-03-17 | cash_dividend | — | — | — | 0.0548390000 | ["tiingo"] | {"tiingo":"0.054839"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2000-06-16 | cash_dividend | — | — | — | 0.0503980000 | ["tiingo"] | {"tiingo":"0.050398"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2000-09-15 | cash_dividend | — | — | — | 0.0661180000 | ["tiingo"] | {"tiingo":"0.066118"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2000-12-15 | cash_dividend | — | — | — | 0.0613500000 | ["tiingo"] | {"tiingo":"0.06135"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2001-03-16 | cash_dividend | — | — | — | 0.0531400000 | ["tiingo"] | {"tiingo":"0.05314"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2001-06-15 | cash_dividend | — | — | — | 0.0587400000 | ["tiingo"] | {"tiingo":"0.05874"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2001-09-21 | cash_dividend | — | — | — | 0.0634400000 | ["tiingo"] | {"tiingo":"0.06344"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2001-12-21 | cash_dividend | — | — | — | 0.0442600000 | ["tiingo"] | {"tiingo":"0.04426"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2002-03-15 | cash_dividend | — | — | — | 0.0376800000 | ["tiingo"] | {"tiingo":"0.03768"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2002-06-21 | cash_dividend | — | — | — | 0.0505800000 | ["tiingo"] | {"tiingo":"0.05058"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2002-09-20 | cash_dividend | — | — | — | 0.0302300000 | ["tiingo"] | {"tiingo":"0.03023"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2002-12-20 | cash_dividend | — | — | — | 0.0525400000 | ["tiingo"] | {"tiingo":"0.05254"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2003-03-21 | cash_dividend | — | — | — | 0.0341400000 | ["tiingo"] | {"tiingo":"0.03414"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2003-06-20 | cash_dividend | — | — | — | 0.0381900000 | ["tiingo"] | {"tiingo":"0.03819"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2003-09-19 | cash_dividend | — | — | — | 0.0382200000 | ["tiingo"] | {"tiingo":"0.03822"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2003-12-19 | cash_dividend | — | — | — | 0.0839600000 | ["tiingo"] | {"tiingo":"0.08396"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2004-03-19 | cash_dividend | — | — | — | 0.0418100000 | ["tiingo"] | {"tiingo":"0.04181"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2004-06-18 | cash_dividend | — | — | — | 0.0421200000 | ["tiingo"] | {"tiingo":"0.04212"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2004-09-17 | cash_dividend | — | — | — | 0.0458800000 | ["tiingo"] | {"tiingo":"0.04588"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2004-12-17 | cash_dividend | — | — | — | 0.1079400000 | ["tiingo"] | {"tiingo":"0.10794"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2005-03-18 | cash_dividend | — | — | — | 0.0481100000 | ["tiingo"] | {"tiingo":"0.04811"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2005-06-17 | cash_dividend | — | — | — | 0.0490400000 | ["tiingo"] | {"tiingo":"0.04904"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2005-09-16 | cash_dividend | — | — | — | 0.0592100000 | ["tiingo"] | {"tiingo":"0.05921"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2005-12-16 | cash_dividend | — | — | — | 0.1711800000 | ["tiingo"] | {"tiingo":"0.17118"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2006-03-17 | cash_dividend | — | — | — | 0.0068400000 | ["tiingo"] | {"tiingo":"0.00684"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2006-06-16 | cash_dividend | — | — | — | 0.0707399900 | ["tiingo"] | {"tiingo":"0.07073999"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2006-09-15 | cash_dividend | — | — | — | 0.1378300000 | ["tiingo"] | {"tiingo":"0.13783"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2006-12-15 | cash_dividend | — | — | — | 0.1378300000 | ["tiingo"] | {"tiingo":"0.13783"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2007-03-16 | cash_dividend | — | — | — | 0.0683400000 | ["tiingo"] | {"tiingo":"0.06834"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2007-06-15 | cash_dividend | — | — | — | 0.0702000000 | ["tiingo"] | {"tiingo":"0.0702"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2007-09-21 | cash_dividend | — | — | — | 0.0733500000 | ["tiingo"] | {"tiingo":"0.07335"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2007-12-21 | cash_dividend | — | — | — | 0.2348200000 | ["tiingo"] | {"tiingo":"0.23482"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2008-03-20 | cash_dividend | — | — | — | 0.0396200000 | ["tiingo"] | {"tiingo":"0.03962"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2008-06-20 | cash_dividend | — | — | — | 0.1118200000 | ["tiingo"] | {"tiingo":"0.11182"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2008-09-19 | cash_dividend | — | — | — | 0.1045600000 | ["tiingo"] | {"tiingo":"0.10456"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2008-12-19 | cash_dividend | — | — | — | 0.1623000000 | ["tiingo"] | {"tiingo":"0.1623"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2009-03-20 | cash_dividend | — | — | — | 0.1024582500 | ["tiingo"] | {"tiingo":"0.10245825"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2009-06-19 | cash_dividend | — | — | — | 0.0975500000 | ["tiingo"] | {"tiingo":"0.09755"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2009-09-18 | cash_dividend | — | — | — | 0.0902600000 | ["tiingo"] | {"tiingo":"0.09026"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2009-12-18 | cash_dividend | — | — | — | 0.1607400000 | ["tiingo"] | {"tiingo":"0.16074"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2010-03-19 | cash_dividend | — | — | — | 0.0622400000 | ["tiingo"] | {"tiingo":"0.06224"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2010-06-18 | cash_dividend | — | — | — | 0.1053300000 | ["tiingo"] | {"tiingo":"0.10533"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2010-09-17 | cash_dividend | — | — | — | 0.1048700000 | ["tiingo"] | {"tiingo":"0.10487"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2010-12-17 | cash_dividend | — | — | — | 0.2196400000 | ["tiingo"] | {"tiingo":"0.21964"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2011-03-18 | cash_dividend | — | — | — | 0.1259200000 | ["tiingo"] | {"tiingo":"0.12592"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLY | 2011-06-17 | cash_dividend | — | — | — | 0.1333500000 | ["tiingo"] | {"tiingo":"0.13335"} | tiingo_prices | /tiingo/daily/XLY/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |