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
active:endpoint = /tiingo/daily/XLF/prices×
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 | 2026-06-22 | cash_dividend | — | — | — | 0.1870830000 | ["tiingo"] | {"tiingo":"0.187083"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2026-03-23 | cash_dividend | — | — | — | 0.2514920000 | ["tiingo"] | {"tiingo":"0.251492"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2025-12-22 | cash_dividend | — | — | — | 0.1907710000 | ["tiingo"] | {"tiingo":"0.190771"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2025-09-22 | cash_dividend | — | — | — | 0.1779930000 | ["tiingo"] | {"tiingo":"0.177993"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2025-06-23 | cash_dividend | — | — | — | 0.1721050000 | ["tiingo"] | {"tiingo":"0.172105"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2025-03-24 | cash_dividend | — | — | — | 0.1787760000 | ["tiingo"] | {"tiingo":"0.178776"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2024-12-23 | cash_dividend | — | — | — | 0.2062450000 | ["tiingo"] | {"tiingo":"0.206245"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2024-09-23 | cash_dividend | — | — | — | 0.1653060000 | ["tiingo"] | {"tiingo":"0.165306"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2024-06-24 | cash_dividend | — | — | — | 0.1627960000 | ["tiingo"] | {"tiingo":"0.162796"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2024-03-18 | cash_dividend | — | — | — | 0.1525220000 | ["tiingo"] | {"tiingo":"0.152522"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2023-12-18 | cash_dividend | — | — | — | 0.1835010000 | ["tiingo"] | {"tiingo":"0.183501"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2023-09-18 | cash_dividend | — | — | — | 0.1550530000 | ["tiingo"] | {"tiingo":"0.155053"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2023-06-20 | cash_dividend | — | — | — | 0.1503170000 | ["tiingo"] | {"tiingo":"0.150317"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2023-03-20 | cash_dividend | — | — | — | 0.1526100000 | ["tiingo"] | {"tiingo":"0.15261"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2022-12-19 | cash_dividend | — | — | — | 0.2096180000 | ["tiingo"] | {"tiingo":"0.209618"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2022-09-19 | cash_dividend | — | — | — | 0.1725440000 | ["tiingo"] | {"tiingo":"0.172544"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2022-06-21 | cash_dividend | — | — | — | 0.1638960000 | ["tiingo"] | {"tiingo":"0.163896"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2022-03-21 | cash_dividend | — | — | — | 0.1519330000 | ["tiingo"] | {"tiingo":"0.151933"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2021-12-20 | cash_dividend | — | — | — | 0.1844110000 | ["tiingo"] | {"tiingo":"0.184411"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2021-09-20 | cash_dividend | — | — | — | 0.1620320000 | ["tiingo"] | {"tiingo":"0.162032"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2021-06-21 | cash_dividend | — | — | — | 0.1392990000 | ["tiingo"] | {"tiingo":"0.139299"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2021-03-22 | cash_dividend | — | — | — | 0.1512330000 | ["tiingo"] | {"tiingo":"0.151233"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2020-12-21 | cash_dividend | — | — | — | 0.1520000000 | ["tiingo"] | {"tiingo":"0.152"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2020-09-21 | cash_dividend | — | — | — | 0.1352780000 | ["tiingo"] | {"tiingo":"0.135278"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2020-06-22 | cash_dividend | — | — | — | 0.1515960000 | ["tiingo"] | {"tiingo":"0.151596"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2020-03-23 | cash_dividend | — | — | — | 0.1592960000 | ["tiingo"] | {"tiingo":"0.159296"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2019-12-20 | cash_dividend | — | — | — | 0.1562920000 | ["tiingo"] | {"tiingo":"0.156292"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2019-09-20 | cash_dividend | — | — | — | 0.1442730000 | ["tiingo"] | {"tiingo":"0.144273"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2019-06-21 | cash_dividend | — | — | — | 0.1395000000 | ["tiingo"] | {"tiingo":"0.1395"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2019-03-15 | cash_dividend | — | — | — | 0.1347000000 | ["tiingo"] | {"tiingo":"0.1347"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2018-12-21 | cash_dividend | — | — | — | 0.1449000000 | ["tiingo"] | {"tiingo":"0.1449"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2018-09-21 | cash_dividend | — | — | — | 0.1275000000 | ["tiingo"] | {"tiingo":"0.1275"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2018-06-15 | cash_dividend | — | — | — | 0.1190000000 | ["tiingo"] | {"tiingo":"0.119"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2018-03-16 | cash_dividend | — | — | — | 0.1045620000 | ["tiingo"] | {"tiingo":"0.104562"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2017-12-15 | cash_dividend | — | — | — | 0.1282840000 | ["tiingo"] | {"tiingo":"0.128284"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2017-09-15 | cash_dividend | — | — | — | 0.1032250000 | ["tiingo"] | {"tiingo":"0.103225"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2017-06-16 | cash_dividend | — | — | — | 0.0930590000 | ["tiingo"] | {"tiingo":"0.093059"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2017-03-17 | cash_dividend | — | — | — | 0.0879030000 | ["tiingo"] | {"tiingo":"0.087903"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2016-12-16 | cash_dividend | — | — | — | 0.1067470000 | ["tiingo"] | {"tiingo":"0.106747"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2016-09-19 | price_factor | 1.231000000000000 | — | — | — | ["tiingo","yfinance"] | {"yfinance":"1.231","tiingo_div_cash":"4.44014886"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2016-09-16 | cash_dividend | — | — | — | 0.1143860000 | ["tiingo"] | {"tiingo":"0.114386"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2016-06-17 | cash_dividend | — | — | — | 0.1210970000 | ["tiingo"] | {"tiingo":"0.121097"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2016-03-18 | cash_dividend | — | — | — | 0.1229950000 | ["tiingo"] | {"tiingo":"0.122995"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2015-12-18 | cash_dividend | — | — | — | 0.1498440000 | ["tiingo"] | {"tiingo":"0.149844"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2015-09-18 | cash_dividend | — | — | — | 0.1134690000 | ["tiingo"] | {"tiingo":"0.113469"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2015-06-19 | cash_dividend | — | — | — | 0.1101400000 | ["tiingo"] | {"tiingo":"0.11014"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2015-03-20 | cash_dividend | — | — | — | 0.0907200000 | ["tiingo"] | {"tiingo":"0.09072"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2014-12-19 | cash_dividend | — | — | — | 0.1261100000 | ["tiingo"] | {"tiingo":"0.12611"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2014-09-19 | cash_dividend | — | — | — | 0.0983600000 | ["tiingo"] | {"tiingo":"0.09836"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| XLF | 2014-06-20 | cash_dividend | — | — | — | 0.0896100000 | ["tiingo"] | {"tiingo":"0.08961"} | tiingo_prices | /tiingo/daily/XLF/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |