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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6b9e6490-5400-4699-b836-e85dd68f44c9 | 2026-08-14 15:56 | 2026-08-14 15:55 | 2026-08-14 15:55 | CCXI | CCXI260918C00017500 | call | 17.5000 | 2026-09-18 | 2.6000 | 2.2500 | 2.6000 | 16.9700 | 18707.00 | 18707.00 | 0.00 | 72 | 5 | 982 | 2409 | 0.40763802407638 | 1.27724802068561 | 1.3398324061248 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | Healthcare | 502800000.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 |
| 0a21600a-abda-4c45-823b-6de964c4e7c5 | 2026-08-17 09:36 | 2026-08-17 09:36 | 2026-08-17 09:36 | CCXI | CCXI270219C00025000 | call | 25.0000 | 2027-02-19 | 5.6000 | 5.0000 | 5.7000 | 18.0300 | 118717.00 | 24637.00 | 23520.00 | 212 | 7 | 272 | 825 | 0.32969696969697 | 1.46374846617918 | 1.46974867963123 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | Healthcare | 502800000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:42:20.529509Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0ce61d24-7b96-4dad-a74a-3892b43d0c59 | 2026-08-17 10:14 | 2026-08-17 10:14 | 2026-08-17 10:14 | CCXI | CCXI260821C00020000 | call | 20.0000 | 2026-08-21 | 0.6900 | 0.5000 | 0.7000 | 17.7900 | 41296.00 | 41296.00 | 0.00 | 600 | 6 | 2606 | 6945 | 0.375233981281497 | 1.95301619682027 | 1.95301619682027 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | Healthcare | 502800000.00 | — | — | — | 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 |
| eb2809f3-6fc6-4e6d-acf8-76fde3dd098b | 2026-08-25 11:45 | 2026-08-25 11:45 | 2026-08-25 11:45 | CCXI | CCXI270219C00015000 | call | 15.0000 | 2027-02-19 | 4.9000 | 4.8000 | 5.0000 | 14.4700 | 20571.00 | 16657.00 | 3914.00 | 42 | 7 | 154 | 1288 | 0.119565217391304 | 1.26791742715351 | 1.27606394108732 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | Healthcare | 502800000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d472d8bd-9f8b-4e29-8903-c93810396e61 | 2026-09-02 10:49 | 2026-09-02 10:49 | 2026-09-02 10:49 | CCXI | CCXI260918P00015000 | put | 15.0000 | 2026-09-18 | 1.9000 | 1.9000 | 2.5000 | 13.4300 | 13332.00 | 0.00 | 13332.00 | 70 | 6 | 139 | 2499 | 0.0556222488995598 | 0.796802521543796 | 0.796802521543796 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | Healthcare | 502800000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4363c4e8-174e-4f4f-b8d6-2978da20476d | 2026-09-08 12:06 | 2026-09-08 12:06 | 2026-09-08 12:06 | CCXI | CCXI261016P00012500 | put | 12.5000 | 2026-10-16 | 0.6000 | 0.5500 | 0.7500 | 13.6000 | 25462.00 | 6720.00 | 18742.00 | 424 | 56 | 475 | 1616 | 0.293935643564356 | 0.644665686491501 | 0.644665686491501 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | Healthcare | 502800000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T16:21:42.633253Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6061b11a-0d2e-4445-804d-6f9f6208ce6c | 2026-09-08 13:28 | 2026-09-08 13:27 | 2026-09-08 13:27 | CCXI | CCXI261016C00012500 | call | 12.5000 | 2026-10-16 | 2.0900 | 1.7500 | 2.3000 | 13.9401 | 20934.00 | 20934.00 | 0.00 | 100 | 7 | 204 | 341 | 0.598240469208211 | 0.689786869226291 | 0.689786869226291 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | Healthcare | 502800000.00 | — | — | — | 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 |
| d4cc3fd2-e89a-4f01-a2cb-17479dcfb362 | 2026-09-08 15:42 | 2026-09-08 15:42 | 2026-09-08 15:42 | CCXI | CCXI270219C00015000 | call | 15.0000 | 2027-02-19 | 3.8500 | 3.7000 | 4.1000 | 13.7450 | 17319.00 | 0.00 | 17319.00 | 45 | 5 | 342 | 1623 | 0.210720887245841 | 1.15997084439158 | 1.15997084439158 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | Healthcare | 502800000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 19519b01-49d4-43fa-8421-f882215a86bc | 2026-09-18 13:57 | 2026-09-18 13:57 | 2026-09-18 13:57 | CCXI | CCXI260918C00012500 | call | 12.5000 | 2026-09-18 | 0.4000 | 0.2000 | 0.4000 | 12.8600 | 15966.00 | 15966.00 | 0.00 | 400 | 21 | 3761 | 4796 | 0.78419516263553 | 2.06424989454188 | 2.06424989454188 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | — | Healthcare | 540510000.00 | — | — | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |