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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SOXX | 2003-09-15 | cash_dividend | — | — | — | 0.0036000000 | ["tiingo"] | {"tiingo":"0.0036"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2005-09-26 | cash_dividend | — | — | — | 0.0291000000 | ["tiingo"] | {"tiingo":"0.0291"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2006-06-23 | cash_dividend | — | — | — | 0.0365540000 | ["tiingo"] | {"tiingo":"0.036554"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2006-09-27 | cash_dividend | — | — | — | 0.0503560000 | ["tiingo"] | {"tiingo":"0.050356"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2006-12-21 | cash_dividend | — | — | — | 0.0100360000 | ["tiingo"] | {"tiingo":"0.010036"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2007-03-26 | cash_dividend | — | — | — | 0.0653080000 | ["tiingo"] | {"tiingo":"0.065308"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2007-06-29 | cash_dividend | — | — | — | 0.0915340000 | ["tiingo"] | {"tiingo":"0.091534"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2007-09-26 | cash_dividend | — | — | — | 0.0812230000 | ["tiingo"] | {"tiingo":"0.081223"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2007-12-27 | cash_dividend | — | — | — | 0.0749420000 | ["tiingo"] | {"tiingo":"0.074942"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2008-06-23 | cash_dividend | — | — | — | 0.1401110000 | ["tiingo"] | {"tiingo":"0.140111"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2008-12-22 | cash_dividend | — | — | — | 0.2484870000 | ["tiingo"] | {"tiingo":"0.248487"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2009-06-22 | cash_dividend | — | — | — | 0.1270940000 | ["tiingo"] | {"tiingo":"0.127094"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2009-12-21 | cash_dividend | — | — | — | 0.2223180000 | ["tiingo"] | {"tiingo":"0.222318"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2010-06-21 | cash_dividend | — | — | — | 0.2152190000 | ["tiingo"] | {"tiingo":"0.215219"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2010-12-20 | cash_dividend | — | — | — | 0.3181860000 | ["tiingo"] | {"tiingo":"0.318186"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2011-03-25 | cash_dividend | — | — | — | 0.0894450000 | ["tiingo"] | {"tiingo":"0.089445"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2011-06-23 | cash_dividend | — | — | — | 0.1068010000 | ["tiingo"] | {"tiingo":"0.106801"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2011-09-26 | cash_dividend | — | — | — | 0.1262650000 | ["tiingo"] | {"tiingo":"0.126265"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2011-12-22 | cash_dividend | — | — | — | 0.0942050000 | ["tiingo"] | {"tiingo":"0.094205"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2012-03-26 | cash_dividend | — | — | — | 0.1045370000 | ["tiingo"] | {"tiingo":"0.104537"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2012-06-19 | cash_dividend | — | — | — | 0.1181810000 | ["tiingo"] | {"tiingo":"0.118181"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2012-09-25 | cash_dividend | — | — | — | 0.2350200000 | ["tiingo"] | {"tiingo":"0.23502"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2012-12-19 | cash_dividend | — | — | — | 0.1877680000 | ["tiingo"] | {"tiingo":"0.187768"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2013-03-25 | cash_dividend | — | — | — | 0.1988110000 | ["tiingo"] | {"tiingo":"0.198811"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2013-06-26 | cash_dividend | — | — | — | 0.1306820000 | ["tiingo"] | {"tiingo":"0.130682"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2013-09-24 | cash_dividend | — | — | — | 0.3005770000 | ["tiingo"] | {"tiingo":"0.300577"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2013-12-23 | cash_dividend | — | — | — | 0.2289840000 | ["tiingo"] | {"tiingo":"0.228984"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2014-03-25 | cash_dividend | — | — | — | 0.2087660000 | ["tiingo"] | {"tiingo":"0.208766"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2014-06-24 | cash_dividend | — | — | — | 0.2424030000 | ["tiingo"] | {"tiingo":"0.242403"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2014-09-24 | cash_dividend | — | — | — | 0.2401180000 | ["tiingo"] | {"tiingo":"0.240118"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2014-12-24 | cash_dividend | — | — | — | 0.7611410000 | ["tiingo"] | {"tiingo":"0.761141"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2015-03-25 | cash_dividend | — | — | — | 0.2591550000 | ["tiingo"] | {"tiingo":"0.259155"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2015-06-24 | cash_dividend | — | — | — | 0.2546450000 | ["tiingo"] | {"tiingo":"0.254645"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2015-09-25 | cash_dividend | — | — | — | 0.4476530000 | ["tiingo"] | {"tiingo":"0.447653"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2015-12-24 | cash_dividend | — | — | — | 0.1933430000 | ["tiingo"] | {"tiingo":"0.193343"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2016-03-23 | cash_dividend | — | — | — | 0.2760380000 | ["tiingo"] | {"tiingo":"0.276038"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2016-06-21 | cash_dividend | — | — | — | 0.2987970000 | ["tiingo"] | {"tiingo":"0.298797"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2016-09-26 | cash_dividend | — | — | — | 0.4568830000 | ["tiingo"] | {"tiingo":"0.456883"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2016-12-21 | cash_dividend | — | — | — | 0.2898690000 | ["tiingo"] | {"tiingo":"0.289869"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2017-03-24 | cash_dividend | — | — | — | 0.3531670000 | ["tiingo"] | {"tiingo":"0.353167"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2017-06-27 | cash_dividend | — | — | — | 0.3597530000 | ["tiingo"] | {"tiingo":"0.359753"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2017-09-26 | cash_dividend | — | — | — | 0.4985270000 | ["tiingo"] | {"tiingo":"0.498527"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2017-12-19 | cash_dividend | — | — | — | 0.3166860000 | ["tiingo"] | {"tiingo":"0.316686"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2018-03-22 | cash_dividend | — | — | — | 0.3753920000 | ["tiingo"] | {"tiingo":"0.375392"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2018-06-26 | cash_dividend | — | — | — | 0.6203600000 | ["tiingo"] | {"tiingo":"0.62036"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2018-09-26 | cash_dividend | — | — | — | 0.8165410000 | ["tiingo"] | {"tiingo":"0.816541"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2018-12-17 | cash_dividend | — | — | — | 0.3389920000 | ["tiingo"] | {"tiingo":"0.338992"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2019-03-20 | cash_dividend | — | — | — | 0.5196100000 | ["tiingo"] | {"tiingo":"0.51961"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2019-06-17 | cash_dividend | — | — | — | 0.7573230000 | ["tiingo"] | {"tiingo":"0.757323"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |
| SOXX | 2019-09-24 | cash_dividend | — | — | — | 0.9600970000 | ["tiingo"] | {"tiingo":"0.960097"} | tiingo_prices | /tiingo/daily/SOXX/prices | {} | 2026-09-07 | 2026-09-07 13:30 | 2026-09-07 13:30 |