Options flow alerts (market-wide)
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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d3b26007-5f6c-4323-b606-35d0932da9db | 2026-09-16 15:48 | 2026-09-16 15:48 | 2026-09-16 15:48 | BKNG | BKNG261120P00175000 | put | 175.0000 | 2026-11-20 | 13.1100 | 13.1000 | 13.8000 | 170.0000 | 198000.00 | 0.00 | 198000.00 | 151 | 28 | 240 | 286 | 0.839160839160839 | 0.404074334570652 | 0.404427731661251 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 128786617700.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 7b1c5954-5bd9-435a-8eb8-2a7878b458c2 | 2026-09-16 13:08 | 2026-09-16 13:08 | 2026-09-16 13:08 | BKNG | BKNG290119C00180000 | call | 180.0000 | 2029-01-19 | 44.1000 | 43.3000 | 45.0000 | 172.4950 | 57328.00 | 8820.00 | 48508.00 | 13 | 5 | 296 | 0 | 0 | 0.380628384370245 | 0.380525331267522 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 128786617700.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 7c7d57b2-b378-4547-9507-b74bfd01b06d | 2026-09-09 10:40 | 2026-09-09 10:40 | 2026-09-09 10:40 | BKNG | BKNG261016P00180000 | put | 180.0000 | 2026-10-16 | 12.8200 | 12.8000 | 13.6000 | 172.3500 | 64120.00 | 1290.00 | 57670.00 | 50 | 16 | 530 | 698 | 0.759312320916905 | 0.403746531476341 | 0.399039465591241 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:59:53.339088Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f8808743-52b4-4d25-bd63-5e4e853cae9a | 2026-09-09 09:38 | 2026-09-09 09:38 | 2026-09-09 09:38 | BKNG | BKNG270115P00165000 | put | 165.0000 | 2027-01-15 | 12.6900 | 9.5000 | 12.7000 | 170.3000 | 219610.00 | 217110.00 | 2500.00 | 173 | 19 | 173 | 1171 | 0.147736976942784 | 0.413169524601732 | 0.408152481695473 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:46:31.810255Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5454c68d-2043-4f65-8c07-3d82e8a97ea9 | 2026-09-09 09:37 | 2026-09-09 09:37 | 2026-09-09 09:37 | BKNG | BKNG261120P00155000 | put | 155.0000 | 2026-11-20 | 5.9000 | 5.3000 | 6.0000 | 170.6350 | 60150.00 | 46590.00 | 13560.00 | 102 | 6 | 103 | 58 | 1.77586206896552 | 0.438201397503588 | 0.438201397503588 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:46:31.810255Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9e7b7ff0-d31a-4f19-8705-51a616853b28 | 2026-09-08 13:33 | 2026-09-08 13:33 | 2026-09-08 13:33 | BKNG | BKNG261120P00170000 | put | 170.0000 | 2026-11-20 | 7.5900 | 7.5000 | 7.7000 | 181.0000 | 82760.00 | 50920.00 | 31840.00 | 109 | 20 | 167 | 49 | 3.40816326530612 | 0.412244669431951 | 0.412108236715181 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T17:42:35.153326Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ba2754db-6416-4986-a85e-76d324b87492 | 2026-09-08 10:26 | 2026-09-08 10:26 | 2026-09-08 10:26 | BKNG | BKNG271217C00184800 | call | 184.8000 | 2027-12-17 | 34.3500 | 27.4000 | 34.5000 | 184.6850 | 54956.00 | 10304.00 | 27477.00 | 16 | 8 | 67 | 0 | 0 | 0.36261532189472 | 0.36261532189472 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:28:51.897139Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9fc913c1-2431-46a5-aff8-5a2624bef053 | 2026-09-03 13:55 | 2026-09-03 13:55 | 2026-09-03 13:55 | BKNG | BKNG261016P00195000 | put | 195.0000 | 2026-10-16 | 7.9000 | 7.5000 | 7.9000 | 196.1970 | 180096.00 | 178536.00 | 1560.00 | 228 | 39 | 230 | 263 | 0.874524714828897 | 0.333441249962927 | 0.333441249962927 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T18:16:35.526734Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 276b57fb-95cf-465d-89ea-80228ee1cb80 | 2026-09-01 14:55 | 2026-09-01 14:55 | 2026-09-01 14:55 | BKNG | BKNG271217C00219200 | call | 219.2000 | 2027-12-17 | 27.1000 | 27.1000 | 29.9000 | 197.3500 | 97565.00 | 0.00 | 97565.00 | 36 | 8 | 46 | 3802 | 0.0120988953182536 | 0.348950684356626 | 0.348838674777991 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:58:03.753197Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1a13d224-5635-48d3-83a2-885fcdd27cb6 | 2026-08-28 12:14 | 2026-08-28 12:14 | 2026-08-28 12:14 | BKNG | BKNG261218C00216000 | call | 216.0000 | 2026-12-18 | 13.3000 | 13.3000 | 13.9000 | 207.0000 | 95790.00 | 0.00 | 95790.00 | 72 | 15 | 75 | 607 | 0.123558484349259 | 0.35406166947204 | 0.35406166947204 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:25:17.992358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c6038ba2-3e57-4f31-b393-b96ee7180f2d | 2026-08-28 10:56 | 2026-08-28 10:56 | 2026-08-28 10:56 | BKNG | BKNG271217C00219200 | call | 219.2000 | 2027-12-17 | 32.8900 | 30.1000 | 33.8000 | 205.5600 | 62490.00 | 39600.00 | 22890.00 | 19 | 5 | 44 | 3798 | 0.0115850447604002 | 0.363608702504037 | 0.363608702504037 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T15:11:58.135920Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4f43840f-3374-49c4-a951-84ecbc6ad40b | 2026-08-27 13:20 | 2026-08-27 13:20 | 2026-08-27 13:20 | BKNG | BKNG261016P00175000 | put | 175.0000 | 2026-10-16 | 1.5500 | 1.2000 | 1.5500 | 203.7000 | 66010.00 | 66010.00 | 0.00 | 426 | 41 | 432 | 429 | 1.00699300699301 | 0.365871718032948 | 0.365871718032948 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 109c8fc5-88e8-44e4-b4b1-072a255db9c0 | 2026-08-24 15:28 | 2026-08-24 15:28 | 2026-08-24 15:28 | BKNG | BKNG270416C00220000 | call | 220.0000 | 2027-04-16 | 23.3000 | 23.3000 | 24.2000 | 213.8100 | 86222.00 | 0.00 | 86222.00 | 37 | 5 | 39 | 1 | 39 | 0.345420376894793 | 0.345125712908547 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:47:47.207382Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f9a6c13d-94b2-464a-b568-2f304b3b42ef | 2026-08-19 11:26 | 2026-08-19 11:26 | 2026-08-19 11:26 | BKNG | BKNG270115P00222000 | put | 222.0000 | 2027-01-15 | 22.3800 | 21.7000 | 22.5000 | 214.8300 | 109680.00 | 91830.00 | 17850.00 | 49 | 14 | 417 | 191 | 2.18324607329843 | 0.374587103125889 | 0.372758688872167 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8304ed5f-2e12-4d13-b65d-22988514b192 | 2026-08-19 11:26 | 2026-08-19 11:26 | 2026-08-19 11:26 | BKNG | BKNG270115P00222000 | put | 222.0000 | 2027-01-15 | 22.7100 | 21.2000 | 22.8000 | 214.9200 | 134000.00 | 122900.00 | 11100.00 | 59 | 5 | 207 | 191 | 1.08376963350785 | 0.380860535698329 | 0.369893187520853 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 131754570675.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |