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,264 rowsCSV — whole table, not this view
Sources in this table
tiingo_prices3,264 rowsexportable
active:symbol = AMD×
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AMD | 2000-08-22 | split | 2.000000000000000 | 2 | 1 | — | ["tiingo","yfinance"] | {"tiingo":"2.0","yfinance":"2.0"} | tiingo_prices | /tiingo/daily/AMD/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AMD | 1995-04-27 | cash_dividend | — | — | — | 0.0100000000 | ["tiingo"] | {"tiingo":"0.01"} | tiingo_prices | /tiingo/daily/AMD/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AMD | 1983-08-23 | split | 2.000000000000000 | 2 | 1 | — | ["tiingo","yfinance"] | {"tiingo":"2.0","yfinance":"2.0"} | tiingo_prices | /tiingo/daily/AMD/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AMD | 1982-10-28 | split | 1.500000000000000 | 3 | 2 | — | ["yfinance"] | {"yfinance":"1.5"} | tiingo_prices | /tiingo/daily/AMD/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| AMD | 1980-10-24 | split | 2.000000000000000 | 2 | 1 | — | ["yfinance"] | {"yfinance":"2.0"} | tiingo_prices | /tiingo/daily/AMD/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |