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_alerts609,118 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 | strikenumeric | expiry |
|---|
| 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 |
|---|
| 3bbcd2dd-4ad8-41a1-8891-ca216f82aa61 | 2026-09-25 15:36 | 2026-09-25 15:36 | 2026-09-25 15:36 | SBUX | SBUX261218C00110000 | call | 110.0000 | 2026-12-18 | 1.1600 | 1.1300 | 1.1600 | 94.0000 | 11368.00 | 11368.00 | 0.00 | 98 | 6 | 146 | 10194 | 0.0143221502844811 | 0.291984403110218 | 0.291984403110218 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 108140400000.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T19:39:29.889694Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 909cbc62-0dd5-4b36-ad6c-8f7fa8852b30 | 2026-09-22 13:49 | 2026-09-22 13:49 | 2026-09-22 13:49 | SBUX | SBUX261218C00110000 | call | 110.0000 | 2026-12-18 | 1.3000 | 1.2900 | 1.3000 | 94.9850 | 20670.00 | 6890.00 | 0.00 | 159 | 5 | 511 | 8689 | 0.0588099896420762 | 0.291883660250518 | 0.291883660250518 | false | false | false | true | ||||||||||||||||
| 1a0d5d6c-9ddd-4c9f-9b85-63a8cc9c8f39 | 2026-09-22 13:49 | 2026-09-22 13:49 | 2026-09-22 13:49 | SBUX | SBUX261218C00110000 | call | 110.0000 | 2026-12-18 | 1.3100 | 1.2800 | 1.3500 | 94.9600 | 16506.00 | 13100.00 | 3406.00 | 126 | 11 | 224 | 8689 | 0.0257797214869375 | 0.292910518722476 | 0.293060824349018 | false | false | false | true | ||||||||||||||||
| a2aed344-473e-47b2-9713-9e3cd538bc04 | 2026-08-27 11:12 | 2026-08-27 11:12 | 2026-08-27 11:12 | SBUX | SBUX261218C00110000 | call | 110.0000 | 2026-12-18 | 6.6500 | 6.6500 | 6.8500 | 107.9200 | 124355.00 | 0.00 | 124355.00 | 187 | 12 | 193 | 6554 | 0.0294476655477571 | 0.292606621363821 | 0.292606621363821 | false | false | false | true | ||||||||||||||||
| 621b15d9-71a2-4b09-946b-7859f57b4cb9 | 2026-08-24 11:35 | 2026-08-24 11:35 | 2026-08-24 11:35 | SBUX | SBUX261218C00110000 | call | 110.0000 | 2026-12-18 | 6.3500 | 6.3000 | 6.3500 | 107.2700 | 140970.00 | 140970.00 | 0.00 | 222 | 7 | 1559 | 6538 | 0.238452126032426 | 0.289499316406306 | 0.28929152159582 | false | false | false | true | ||||||||||||||||
| 3f6674f9-d882-436f-b7b0-12d77b0ebbfb | 2026-08-24 11:34 | 2026-08-24 11:34 | 2026-08-24 11:34 | SBUX | SBUX261218C00110000 | call | 110.0000 | 2026-12-18 | 6.4000 | 6.3500 | 6.4000 | 107.3900 | 144640.00 | 144640.00 | 0.00 | 226 | 6 | 1206 | 6538 | 0.184460079535026 | 0.290531560465052 | 0.288863834760923 | false | false | false | true | ||||||||||||||||
| 4f3d4cde-27ae-4ba9-834f-1fd7874dd50e | 2026-08-24 10:41 | 2026-08-24 10:41 | 2026-08-24 10:41 | SBUX | SBUX261218C00110000 | call | 110.0000 | 2026-12-18 | 6.0000 | 5.9000 | 6.2000 | 106.3000 | 136200.00 | 121800.00 | 14400.00 | 227 | 7 | 232 | 6538 | 0.035484857754665 | 0.294148080836192 | 0.294550791658901 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 108425400000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:52:53.749956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 108425400000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:52:53.749956Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 112939800000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T15:23:19.203737Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 112939800000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:49:37.820281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 112939800000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T15:49:37.820281Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 112939800000.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |