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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12b63060-7c9e-402b-a177-8a2590e6d4d0 | 2026-08-20 12:13 | 2026-08-20 12:13 | 2026-08-20 12:13 | KWEB | KWEB260821C00026000 | call | 26.0000 | 2026-08-21 | 0.5900 | 0.5800 | 0.6900 | 26.5950 | 79591.00 | 0.00 | 79591.00 | 1349 | 1 | 4642 | 4787 | 0.96970963024859 | 0.549103265501181 | 0.549103265501181 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | ETF | — | 4223436000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ed58dd38-15bd-4ceb-a28e-97f249d2958d | 2026-08-24 10:52 | 2026-08-24 10:52 | 2026-08-24 10:52 | KWEB | KWEB261218C00039000 | call | 39.0000 | 2026-12-18 | 0.1200 | 0.0000 | 0.3600 | 26.3350 | 60000.00 | 0.00 | 60000.00 | 5000 | 1 | 5000 | 5485 | 0.911577028258888 | 0.390894192962936 | 0.390894192962936 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | ETF | — | 4223436000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9d2d2971-24a6-4d0e-bf41-b14be3ec986b | 2026-09-09 10:33 | 2026-09-09 10:33 | 2026-09-09 10:33 | KWEB | KWEB270115C00025000 | call | 25.0000 | 2027-01-15 | 1.9500 | 1.8500 | 1.9900 | 24.0000 | 292500.00 | 292500.00 | 0.00 | 1500 | 1 | 6117 | 8740 | 0.699885583524027 | 0.306623061627887 | 0.306623061627887 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | ETF | — | 4223436000.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9522788a-9b79-43ef-ae47-acef5ce5c6bf | 2026-09-10 14:48 | 2026-09-10 14:48 | 2026-09-10 14:48 | KWEB | KWEB260918P00028000 | put | 28.0000 | 2026-09-18 | 3.5500 | 3.4500 | 3.5500 | 24.4950 | 997550.00 | 997550.00 | 0.00 | 2810 | 2 | 20022 | 17046 | 1.17458641323478 | 0.599008170271393 | 0.599008170271393 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 2 | ETF | — | 4223436000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 60b7653e-92ff-4d6b-9a3a-da28d846d304 | 2026-09-18 15:53 | 2026-09-18 15:53 | 2026-09-18 15:53 | KWEB | KWEB260918P00025000 | put | 25.0000 | 2026-09-18 | 0.1500 | 0.1200 | 0.1700 | 24.0000 | 37500.00 | 37500.00 | 0.00 | 2500 | 2 | 4248 | 36860 | 0.115246880086815 | 1.27117010438788 | 1.27117010438788 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | ETF | — | 4223436000.00 | — | — | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |