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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8a0f1003-278a-4851-8dea-6b2b387df35c | 2026-09-18 15:42 | 2026-09-18 15:42 | 2026-09-18 15:42 | ABBV | ABBV261016C00250000 | call | 250.0000 | 2026-10-16 | 16.9000 | 16.2000 | 17.8000 | 264.4400 | 202752.00 | 0.00 | 202752.00 | 120 | 5 | 154 | 1401 | 0.109921484653819 | 0.190842353791397 | 0.251163145220157 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 466448278549.00 | 2026-10-30 | unknown | — | 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 |
| 6d00f7b3-580a-4898-bf68-db4a76f8f08a | 2026-09-18 09:38 | 2026-09-18 09:38 | 2026-09-18 09:38 | ABBV | ABBV261120P00260000 | put | 260.0000 | 2026-11-20 | 10.0000 | 10.0000 | 11.5000 | 265.5450 | 58025.00 | 1020.00 | 57005.00 | 58 | 8 | 98 | 398 | 0.246231155778894 | 0.308300418285315 | 0.313030470094559 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 466448278549.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:40:42.153741Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 41828604-5b06-422e-90fc-1ad3abb82552 | 2026-09-17 13:46 | 2026-09-17 13:46 | 2026-09-17 13:46 | ABBV | ABBV270115P00240000 | put | 240.0000 | 2027-01-15 | 7.8500 | 7.8000 | 8.2000 | 262.1950 | 419988.00 | 785.00 | 412133.00 | 535 | 64 | 551 | 1393 | 0.395549174443647 | 0.312126615350362 | 0.312126615350362 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 466554305586.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 31b42b7c-a365-4b69-8f5d-9ebe4436d636 | 2026-08-27 14:54 | 2026-08-27 14:54 | 2026-08-27 14:54 | ABBV | ABBV280121C00250000 | call | 250.0000 | 2028-01-21 | 40.1400 | 39.5500 | 41.6500 | 258.0650 | 200710.00 | 32000.00 | 168710.00 | 50 | 7 | 70 | 439 | 0.159453302961276 | 0.235763781279961 | 0.240782150587173 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 462578291694.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5b82ab5a-1976-4ccf-87ff-6660e4888a04 | 2026-08-25 13:03 | 2026-08-25 13:03 | 2026-08-25 13:03 | ABBV | ABBV270219P00240000 | put | 240.0000 | 2027-02-19 | 9.8500 | 9.6000 | 10.2500 | 266.1100 | 59123.00 | 995.00 | 58128.00 | 60 | 13 | 79 | 427 | 0.185011709601874 | 0.313863504508932 | 0.31554913996156 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 462578291694.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T17:31:01.749779Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 15630801-cb6c-451a-b579-cee67f5afab3 | 2026-08-21 14:13 | 2026-08-21 14:13 | 2026-08-21 14:13 | ABBV | ABBV260821C00257500 | call | 257.5000 | 2026-08-21 | 7.9500 | 6.9000 | 8.1000 | 265.0000 | 91392.00 | 42102.00 | 49290.00 | 115 | 10 | 210 | 1275 | 0.164705882352941 | 1.15000099473384 | 1.27297196348142 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 462578291694.00 | 2026-10-30 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b954307e-9058-40d7-9ea6-5e390469a1be | 2026-08-21 11:38 | 2026-08-21 11:37 | 2026-08-21 11:37 | ABBV | ABBV260828C00260000 | call | 260.0000 | 2026-08-28 | 7.6500 | 7.6500 | 8.2500 | 266.2300 | 159889.00 | 0.00 | 159889.00 | 209 | 33 | 257 | 445 | 0.57752808988764 | 0.244737720962519 | 0.244737720962519 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 462578291694.00 | 2026-10-30 | 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 |