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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5382ed8d-fee1-4ef5-bd7b-ac119959bd2b | 2026-08-17 10:17 | 2026-08-17 10:16 | 2026-08-17 10:16 | BTG | BTG261002P00004500 | put | 4.5000 | 2026-10-02 | 0.1200 | 0.0000 | 0.7500 | 5.2000 | 24780.00 | 0.00 | 24780.00 | 2065 | 2 | 2065 | 0 | 0 | 0.607378046265122 | 0.509550780730878 | false | true | false | true | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Basic Materials | 6998046088.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7591d55d-df0f-4db5-a473-c607f43e674c | 2026-08-21 10:50 | 2026-08-21 10:50 | 2026-08-21 10:50 | HCC | HCC270416C00135000 | call | 135.0000 | 2027-04-16 | 9.9000 | 7.0000 | 10.0000 | 107.8700 | 693000.00 | 693000.00 | 0.00 | 700 | 1 | 700 | 0 | 0 | 0.510647565061483 | 0.510647565061483 | false | true | true | false | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Basic Materials | 5040487225.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 776c6cbf-2651-4354-8b0a-449b158b6bef | 2026-08-24 11:23 | 2026-08-24 11:22 | 2026-08-24 11:22 | TMC | TMC260828P00004500 | put | 4.5000 | 2026-08-28 | 0.1900 | 0.0900 | 0.2100 | 4.6250 | 77083.00 | 77083.00 | 0.00 | 4057 | 1 | 4434 | 1610 | 2.75403726708075 | 1.30444880523597 | 1.30444880523597 | false | true | true | false | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Basic Materials | 1689548896.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 61e00870-0a5f-462a-8782-848197c1a907 | 2026-08-25 10:23 | 2026-08-25 10:23 | 2026-08-25 10:23 | SBSW | SBSW270115C00012000 | call | 12.0000 | 2027-01-15 | 1.9200 | 1.8500 | 2.1000 | 12.3800 | 480000.00 | 0.00 | 480000.00 | 2500 | 2 | 2505 | 11009 | 0.227541102734127 | 0.539585699255387 | 0.539585699255387 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | ADR | Basic Materials | 8428014029.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:28:24.156188Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cfcced62-d34e-4d05-bee4-1b5c52734076 | 2026-08-25 12:32 | 2026-08-25 12:31 | 2026-08-25 12:31 | SSRM | SSRM261218C00055000 | call | 55.0000 | 2026-12-18 | 1.5500 | 1.3000 | 1.7500 | 38.9500 | 392150.00 | 392150.00 | 0.00 | 2530 | 1 | 2555 | 0 | 0 | 0.637658062706959 | 0.637658062706959 | false | true | false | true | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Basic Materials | 7098083151.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 86b80de3-6878-4ded-a9a7-39809b95ad6a | 2026-09-02 15:22 | 2026-09-02 15:22 | 2026-09-02 15:22 | MOS | MOS261218C00025000 | call | 25.0000 | 2026-12-18 | 3.1500 | 3.0000 | 3.2000 | 25.9100 | 157500.00 | 157500.00 | 0.00 | 500 | 2 | 1015 | 5872 | 0.172854223433242 | 0.459431917259543 | 0.459431917259543 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 52ef8071-3817-4d61-8656-2f4ace94996d | 2026-09-03 11:15 | 2026-09-03 11:15 | 2026-09-03 11:15 | ESI | ESI260918C00036000 | call | 36.0000 | 2026-09-18 | 0.5800 | 0.2000 | 0.6500 | 34.3200 | 116000.00 | 116000.00 | 0.00 | 2000 | 2 | 2015 | 1296 | 1.55478395061728 | 0.418901905664666 | 0.418901905664666 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Basic Materials | 7829789067.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |