Simplify Analytics
← Data Explorer

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

ex_dateto
column equals (exact text)
sort
chart against ex_date
reset
active:symbol = SMH×sorted by ex_date ↑×

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.

symboltextex_date ↑dateaction_typetextratio_rawnumericratio_numbigintratio_denbigintdiv_cashnumericvendorsARRAYvendor_valuesjsonbsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
SMH2006-03-16cash_dividend———0.0018000000["tiingo"]{"tiingo":"0.0018"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-04-26cash_dividend———0.0035000000["tiingo"]{"tiingo":"0.0035"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-05-03cash_dividend———0.0186750000["tiingo"]{"tiingo":"0.018675"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-05-16cash_dividend———0.0130000000["tiingo"]{"tiingo":"0.013"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-05-24cash_dividend———0.0096000000["tiingo"]{"tiingo":"0.0096"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-06-15cash_dividend———0.0018000000["tiingo"]{"tiingo":"0.0018"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-07-27cash_dividend———0.0019200000["tiingo"]{"tiingo":"0.00192"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-08-02cash_dividend———0.0035000000["tiingo"]{"tiingo":"0.0035"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-08-03cash_dividend———0.0186750000["tiingo"]{"tiingo":"0.018675"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-08-11cash_dividend———0.0036000000["tiingo"]{"tiingo":"0.0036"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-08-15cash_dividend———0.0130000000["tiingo"]{"tiingo":"0.013"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-08-17cash_dividend———0.0078000000["tiingo"]{"tiingo":"0.0078"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-08-23cash_dividend———0.0096000000["tiingo"]{"tiingo":"0.0096"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-09-14cash_dividend———0.0018000000["tiingo"]{"tiingo":"0.0018"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-10-27cash_dividend———0.0041250000["tiingo"]{"tiingo":"0.004125"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-11-03cash_dividend———0.0186750000["tiingo"]{"tiingo":"0.018675"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-11-13cash_dividend———0.0045000000["tiingo"]{"tiingo":"0.0045"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-11-14cash_dividend———0.0130000000["tiingo"]{"tiingo":"0.013"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-11-17cash_dividend———0.0078000000["tiingo"]{"tiingo":"0.0078"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-11-21cash_dividend———0.0096000000["tiingo"]{"tiingo":"0.0096"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2006-12-14cash_dividend———0.0024000000["tiingo"]{"tiingo":"0.0024"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-01-29cash_dividend———0.0041250000["tiingo"]{"tiingo":"0.004125"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-02-05cash_dividend———0.0224250000["tiingo"]{"tiingo":"0.022425"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-02-13cash_dividend———0.0130000000["tiingo"]{"tiingo":"0.013"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-02-14cash_dividend———0.0078000000["tiingo"]{"tiingo":"0.0078"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-03-07cash_dividend———0.0108000000["tiingo"]{"tiingo":"0.0108"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-03-15cash_dividend———0.0024000000["tiingo"]{"tiingo":"0.0024"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-04-25cash_dividend———0.0050000000["tiingo"]{"tiingo":"0.005"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-04-26cash_dividend———0.0129250000["tiingo"]{"tiingo":"0.012925"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-05-03cash_dividend———0.0224250000["tiingo"]{"tiingo":"0.022425"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-05-07cash_dividend———0.0060000000["tiingo"]{"tiingo":"0.006"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-05-08cash_dividend———0.0024000000["tiingo"]{"tiingo":"0.0024"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-05-09cash_dividend———0.0078000000["tiingo"]{"tiingo":"0.0078"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-05-11cash_dividend———0.0036000000["tiingo"]{"tiingo":"0.0036"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-05-15cash_dividend———0.0156000000["tiingo"]{"tiingo":"0.0156"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-05-30cash_dividend———0.0108000000["tiingo"]{"tiingo":"0.0108"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-06-14cash_dividend———0.0024000000["tiingo"]{"tiingo":"0.0024"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-07-27cash_dividend———0.0129250000["tiingo"]{"tiingo":"0.012925"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-08-03cash_dividend———0.0224250000["tiingo"]{"tiingo":"0.022425"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-08-13cash_dividend———0.0060000000["tiingo"]{"tiingo":"0.006"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-08-14cash_dividend———0.0156000000["tiingo"]{"tiingo":"0.0156"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-08-16cash_dividend———0.0045000000["tiingo"]{"tiingo":"0.0045"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-08-21cash_dividend———0.0093700000["tiingo"]{"tiingo":"0.00937"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-08-29cash_dividend———0.0108000000["tiingo"]{"tiingo":"0.0108"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-09-13cash_dividend———0.0024000000["tiingo"]{"tiingo":"0.0024"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-10-12cash_dividend———1.4330000000["tiingo"]{"tiingo":"1.433"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-10-29cash_dividend———0.0173250000["tiingo"]{"tiingo":"0.017325"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-11-05cash_dividend———0.0224250000["tiingo"]{"tiingo":"0.022425"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-11-09cash_dividend———0.0060000000["tiingo"]{"tiingo":"0.006"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30
SMH2007-11-13cash_dividend———0.0156000000["tiingo"]{"tiingo":"0.0156"}tiingo_prices/tiingo/daily/SMH/prices{}2026-09-072026-09-07 13:302026-09-07 13:30