core.corporate_actions
Splits, cash dividends and price factors. The second half of the PIT price spine - these are what core.prices_asof() applies.
Simplify Analyticstiingo_prices3,264 rowsexportableex_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 | source |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| META | 2024-02-21 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/META/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| META | 2024-06-14 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/META/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| META | 2024-09-16 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/META/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| META | 2024-12-16 | cash_dividend | — | — | — | 0.5000000000 | ["tiingo"] | {"tiingo":"0.5"} | tiingo_prices | /tiingo/daily/META/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| META | 2025-03-14 | cash_dividend | — | — | — | 0.5250000000 | ["tiingo"] | {"tiingo":"0.525"} | tiingo_prices | /tiingo/daily/META/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| META | 2025-06-16 | cash_dividend | — | — | — | 0.5250000000 | ["tiingo"] | {"tiingo":"0.525"} | tiingo_prices | /tiingo/daily/META/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| META | 2025-09-22 | cash_dividend | — | — | — | 0.5250000000 | ["tiingo"] | {"tiingo":"0.525"} | tiingo_prices | /tiingo/daily/META/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| META | 2025-12-15 | cash_dividend | — | — | — | 0.5250000000 | ["tiingo"] | {"tiingo":"0.525"} | tiingo_prices | /tiingo/daily/META/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| META | 2026-03-16 | cash_dividend | — | — | — | 0.5250000000 | ["tiingo"] | {"tiingo":"0.525"} | tiingo_prices | /tiingo/daily/META/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| META | 2026-06-15 | cash_dividend | — | — | — | 0.5250000000 | ["tiingo"] | {"tiingo":"0.525"} | tiingo_prices | /tiingo/daily/META/prices | {} | 2026-09-07 | 2026-09-07 13:29 | 2026-09-07 13:29 |
| META | 2026-09-21 | cash_dividend | — | — | — | 0.5250000000 | ["tiingo"] | {"tiingo":"0.525"} | tiingo_prices | /tiingo/daily/META/prices | {} | 2026-09-21 | 2026-09-21 18:05 | 2026-09-21 18:05 |