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/SOXX/prices×
ex_date leads no index, so this sort reads every matching row and keeps only the top 100 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 | 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-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-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 | 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 | 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-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-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 | 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 | 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-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-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 | 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 | 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-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-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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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-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-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 | 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 | 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-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 | 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 | 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 |