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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90627f75-bf62-44f4-85db-d0c9feece2fe | 2026-08-20 15:21 | 2026-08-20 15:21 | 2026-08-20 15:21 | CLF | CLF260918C00010000 | call | 10.0000 | 2026-09-18 | 1.1400 | 1.0900 | 1.1500 | 10.6800 | 113998.00 | 113998.00 | 0.00 | 1000 | 6 | 2567 | 8881 | 0.289044026573584 | 0.621208592418561 | 0.621208592418561 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 6646791548.00 | 2026-10-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7abeb3ac-f4db-471c-81fc-8aea25f2af2d | 2026-08-21 11:33 | 2026-08-21 11:33 | 2026-08-21 11:33 | CLF | CLF260918C00013000 | call | 13.0000 | 2026-09-18 | 0.3900 | 0.3600 | 0.4000 | 11.6300 | 117359.00 | 96572.00 | 20787.00 | 3000 | 86 | 4615 | 12912 | 0.357419454770756 | 0.679423662931601 | 0.675921255054525 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 6646791548.00 | 2026-10-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 67650ac1-2d1a-4948-8c2e-c711e386cee0 | 2026-08-21 14:44 | 2026-08-21 14:44 | 2026-08-21 14:44 | CLF | CLF270319C00015000 | call | 15.0000 | 2027-03-19 | 1.2000 | 1.1600 | 1.2000 | 11.2600 | 42358.00 | 42358.00 | 0.00 | 354 | 27 | 609 | 4686 | 0.129961587708067 | 0.657005398050283 | 0.660056274188905 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 6646791548.00 | 2026-10-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:49:22.677317Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 374690fe-915a-4bc9-85b1-0a50291da1f4 | 2026-08-24 10:13 | 2026-08-24 10:12 | 2026-08-24 10:12 | CLF | CLF260828C00012500 | call | 12.5000 | 2026-08-28 | 0.2300 | 0.2000 | 0.2400 | 12.0550 | 18139.00 | 15498.00 | 2421.00 | 791 | 99 | 3108 | 2282 | 1.36196319018405 | 0.817500806992742 | 0.827664410465649 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 6646791548.00 | 2026-10-19 | unknown | — | 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 |
| 4caa9fa4-5f16-4bc0-8a92-41842853f116 | 2026-08-27 09:58 | 2026-08-27 09:58 | 2026-08-27 09:58 | CLF | CLF270115P00013000 | put | 13.0000 | 2027-01-15 | 2.5500 | 2.3500 | 2.5900 | 11.6200 | 11491.00 | 10980.00 | 511.00 | 45 | 8 | 45 | 1727 | 0.0260567458019687 | 0.631944302075323 | 0.635419262741327 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 6646791548.00 | 2026-10-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T14:00:28.149501Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f61d0217-3966-4dec-b3c2-8a0032afc3b1 | 2026-09-02 10:35 | 2026-09-02 10:35 | 2026-09-02 10:35 | CLF | CLF261120C00015000 | call | 15.0000 | 2026-11-20 | 0.6400 | 0.6100 | 0.6500 | 12.3450 | 15364.00 | 1512.00 | 63.00 | 241 | 5 | 241 | 899 | 0.268075639599555 | 0.630908552414671 | 0.635817703182098 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 6646791548.00 | 2026-10-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c64d3988-3ed9-4b9b-9ec4-2aedeb7ea431 | 2026-09-09 15:13 | 2026-09-09 15:12 | 2026-09-09 15:12 | CLF | CLF261120C00014000 | call | 14.0000 | 2026-11-20 | 0.7500 | 0.7400 | 0.7600 | 12.1150 | 14720.00 | 14720.00 | 0.00 | 195 | 10 | 274 | 544 | 0.503676470588235 | 0.641506442844562 | 0.64643455176439 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 6646791548.00 | 2026-10-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |