core.flow_alerts
Every UW flow alert, on every ticker - untracked ones included, which is the point. Keyed on the vendor's alert id. `ticker` is verbatim (SPX weeklies arrive as SPXW). Not exportable: each alert carries the contract's bid and ask.
uw_flow_alerts658,639 rowsrestricted — hover for the licence| iduuid | created_at ↓timestamp with time zone | start_timetimestamp with time zone | end_timetimestamp with time zone | tickertext | option_symboltext | option_typetext | strike |
|---|
| expirydate |
|---|
| pricenumeric |
|---|
| bidnumeric |
|---|
| asknumeric |
|---|
| underlying_pricenumeric |
|---|
| total_premiumnumeric |
|---|
| total_ask_side_premnumeric |
|---|
| total_bid_side_premnumeric |
|---|
| total_sizebigint |
|---|
| trade_countinteger |
|---|
| volumebigint |
|---|
| open_interestbigint |
|---|
| volume_oi_rationumeric |
|---|
| iv_startnumeric |
|---|
| iv_endnumeric |
|---|
| has_sweepboolean |
|---|
| has_floorboolean |
|---|
| has_multilegboolean |
|---|
| has_singlelegboolean |
|---|
| all_opening_tradesboolean |
|---|
| alert_ruletext |
|---|
| rule_iduuid |
|---|
| expiry_countinteger |
|---|
| issue_typetext |
|---|
| sectortext |
|---|
| marketcapnumeric |
|---|
| next_earnings_datedate |
|---|
| er_timetext |
|---|
| missing_periscopeboolean |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 094f7c9a-5384-45be-8a9d-05f451598e42 | 2026-10-01 10:02 | 2026-10-01 10:02 | 2026-10-01 10:02 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 40.7700 | 40.4500 | 40.8500 | 724.8560 | 20385.00 | 12245.00 | 8140.00 | 5 | 5 | 41 | 379 | 0.108179419525066 | 0.395620890078028 | 0.393734473837169 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Communication Services | 1600768938538.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T14:03:29.849529Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| 17cd0847-4a40-49db-8f3e-54ea1cbae9f9 | 2026-10-01 10:00 | 2026-10-01 10:00 | 2026-10-01 10:00 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 38.2200 | 37.8500 | 38.3000 | 728.2700 | 19110.00 | 15300.00 | 3810.00 | 5 | 5 | 36 | 379 | 0.0949868073878628 | 0.390306016849173 | 0.389387967394937 | true | false | false | |||||||||||||||||
| fa84197f-3915-40d0-ac6a-06e7fdf1f524 | 2026-09-24 12:29 | 2026-09-24 12:29 | 2026-09-24 12:29 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 25.6100 | 25.3500 | 25.9000 | 768.7200 | 25606.00 | 10232.00 | 15374.00 | 10 | 7 | 229 | 278 | 0.823741007194245 | 0.442823452182229 | 0.439540600315359 | false | false | false | |||||||||||||||||
| 8426265c-d94c-479b-83f1-ff8f816520f0 | 2026-09-23 11:23 | 2026-09-23 11:23 | 2026-09-23 11:23 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 34.0100 | 33.9500 | 34.2000 | 754.1450 | 20408.00 | 10208.00 | 10200.00 | 6 | 5 | 324 | 120 | 2.7 | 0.458612398937595 | 0.457550572990762 | true | false | false | |||||||||||||||||
| 5727da1f-7024-4f5e-8b42-1a2d70ec50d5 | 2026-09-23 09:54 | 2026-09-23 09:53 | 2026-09-23 09:53 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 32.2700 | 32.0000 | 32.3500 | 756.8600 | 25815.00 | 12920.00 | 12895.00 | 8 | 6 | 136 | 120 | 1.13333333333333 | 0.450201659277203 | 0.451789675998326 | true | false | false | |||||||||||||||||
| 5a3a4bbe-ec12-4911-a418-bb525f616cb3 | 2026-09-21 12:21 | 2026-09-21 12:21 | 2026-09-21 12:21 | META | META261016P00755000 | put | 755.0000 | 2026-10-16 | 49.3000 | 49.2000 | 49.6000 | 726.1600 | 266240.00 | 34510.00 | 231730.00 | 54 | 19 | 105 | 5 | 21 | 0.444883318778561 | 0.443875584280359 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1600768938538.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T14:00:47.539332Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T15:23:47.442599Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1640836123547.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:55:29.867504Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Communication Services |
| 1634540481654.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:25:44.384112Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |