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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5fcc6cb8-ff92-4f12-9eb9-a61da75e315e | 2026-08-14 15:55 | 2026-08-14 15:55 | 2026-08-14 15:55 | XLK | XLK260821C00175000 | call | 175.0000 | 2026-08-21 | 15.7200 | 14.9000 | 16.0000 | 189.8150 | 496709.00 | 466509.00 | 30200.00 | 316 | 14 | 1077 | 2357 | 0.456936784047518 | 0.559945434342586 | 0.363040840514176 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 119462218474.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c7d0da94-f268-4487-a86b-eb5529aae40d | 2026-08-17 15:22 | 2026-08-17 15:22 | 2026-08-17 15:22 | XLK | XLK270319P00160000 | put | 160.0000 | 2027-03-19 | 5.4000 | 5.4000 | 5.8000 | 190.3300 | 11885.00 | 0.00 | 11885.00 | 22 | 5 | 133 | 53 | 2.50943396226415 | 0.33110320015109 | 0.329808265148885 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 119462218474.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 990aff4a-60f4-4e8a-8ad3-bf4708228405 | 2026-08-19 14:05 | 2026-08-19 14:05 | 2026-08-19 14:05 | XLK | XLK270617P00182500 | put | 182.5000 | 2027-06-17 | 16.3200 | 16.2500 | 17.4500 | 184.0200 | 60370.00 | 3280.00 | 57090.00 | 37 | 12 | 45 | 3523 | 0.0127732046551235 | 0.305207710517977 | 0.304427340236303 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 119462218474.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| eb8593aa-53a1-49e5-b378-726bf5d30e74 | 2026-08-24 10:17 | 2026-08-24 10:17 | 2026-08-24 10:17 | XLK | XLK260918P00175000 | put | 175.0000 | 2026-09-18 | 3.2000 | 3.0000 | 3.2000 | 179.1700 | 216931.00 | 216931.00 | 0.00 | 678 | 43 | 1439 | 5005 | 0.287512487512488 | 0.281024846385263 | 0.281024846385263 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 119462218474.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7f49843e-dc7a-4e10-82cf-2e02fb8bfff4 | 2026-08-27 10:27 | 2026-08-27 10:27 | 2026-08-27 10:27 | XLK | XLK260904C00193000 | call | 193.0000 | 2026-09-04 | 0.8700 | 0.6800 | 0.8700 | 187.6300 | 142675.00 | 142592.00 | 83.00 | 1640 | 46 | 1649 | 48 | 34.3541666666667 | 0.24178182328909 | 0.236981804811005 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 119462218474.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T14:37:18.031558Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| feb490e8-5f5f-4cf8-a282-cfc7762265e0 | 2026-08-31 11:51 | 2026-08-31 11:50 | 2026-08-31 11:50 | XLK | XLK270319C00189000 | call | 189.0000 | 2027-03-19 | 14.8700 | 14.8500 | 14.9000 | 185.7400 | 60984.00 | 28310.00 | 32674.00 | 41 | 6 | 411 | 45 | 9.13333333333333 | 0.269050235246473 | 0.268316623910285 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 119462218474.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b3d8f5e1-ddee-47c0-b78b-70c0f56bb0e7 | 2026-09-08 14:09 | 2026-09-08 14:09 | 2026-09-08 14:09 | XLK | XLK270319P00187000 | put | 187.0000 | 2027-03-19 | 11.7000 | 11.7000 | 12.1000 | 188.3400 | 210669.00 | 7080.00 | 203589.00 | 180 | 37 | 207 | 15 | 13.8 | 0.265303173482887 | 0.267005457562844 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 121839351825.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T18:15:47.972880Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 31f91864-e8fd-4d8a-bee3-39afc1f6c6f4 | 2026-09-15 09:40 | 2026-09-15 09:40 | 2026-09-15 09:40 | XLK | XLK270416C00210000 | call | 210.0000 | 2027-04-16 | 6.3500 | 6.3500 | 6.7000 | 184.7300 | 109239.00 | 0.00 | 109239.00 | 172 | 26 | 634 | 187 | 3.3903743315508 | 0.239374838264577 | 0.239049808327552 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 119462218474.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| a396dfd9-d4a0-436e-ae7d-a48a8cd7a78d | 2026-09-16 09:44 | 2026-09-16 09:43 | 2026-09-16 09:43 | XLK | XLK270617P00170000 | put | 170.0000 | 2027-06-17 | 8.6200 | 8.3500 | 9.1000 | 185.1400 | 64666.00 | 0.00 | 64666.00 | 75 | 5 | 300 | 1303 | 0.230237912509593 | 0.282322342984854 | 0.282322342984854 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 119221096945.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| dd43f73e-9642-4977-93e3-c7732d61e2b7 | 2026-09-16 12:02 | 2026-09-16 12:02 | 2026-09-16 12:02 | XLK | XLK270617P00180000 | put | 180.0000 | 2027-06-17 | 11.9500 | 11.6500 | 13.0500 | 185.5600 | 119489.00 | 0.00 | 119489.00 | 100 | 17 | 100 | 4286 | 0.0233317778814746 | 0.275915418819572 | 0.275915418819572 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 119221096945.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 2314bf30-a606-4549-bb9d-fc6286c9c548 | 2026-09-16 12:03 | 2026-09-16 12:02 | 2026-09-16 12:02 | XLK | XLK270617P00180000 | put | 180.0000 | 2027-06-17 | 11.9700 | 11.6500 | 12.7000 | 185.5500 | 119735.00 | 0.00 | 119735.00 | 100 | 13 | 200 | 4286 | 0.0466635557629491 | 0.276360220741809 | 0.276360220741809 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 119221096945.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 6458da5d-f81a-4f18-942e-a22fbb5b8aee | 2026-09-17 09:55 | 2026-09-17 09:55 | 2026-09-17 09:55 | XLK | XLK261218C00200000 | call | 200.0000 | 2026-12-18 | 4.9000 | 4.2500 | 4.9000 | 187.7000 | 97992.00 | 97992.00 | 0.00 | 200 | 36 | 203 | 3336 | 0.0608513189448441 | 0.235363032843087 | 0.235763820672835 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 119390893170.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:57:31.198579Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 16a27b2e-53a6-41c6-a5e3-0fdba5675114 | 2026-09-18 15:43 | 2026-09-18 15:43 | 2026-09-18 15:43 | XLK | XLK270617P00175000 | put | 175.0000 | 2027-06-17 | 9.0900 | 8.8500 | 9.5500 | 188.6620 | 90890.00 | 0.00 | 90890.00 | 100 | 11 | 305 | 3985 | 0.0765370138017566 | 0.278091537277178 | 0.278091537277178 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ETF | — | 121943675907.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |