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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| e1bfc997-f276-46db-a136-ca3ea1d7e53e | 2026-08-18 13:45 | 2026-08-18 13:45 | 2026-08-18 13:45 | QCOM | QCOM261016P00150000 | put | 150.0000 | 2026-10-16 | 6.8500 | 6.8000 | 7.1500 | 159.3000 | 281545.00 | 1370.00 | 277435.00 | 411 | 53 | 494 | 2786 | 0.177315147164393 | 0.454423783886452 | 0.454846796201165 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 80eb8184-397f-4648-918f-1d0737a0d07c | 2026-08-18 12:30 | 2026-08-18 12:29 | 2026-08-18 12:29 | QCOM | QCOM261016C00160000 | call | 160.0000 | 2026-10-16 | 10.6500 | 10.6000 | 10.8000 | 158.5300 | 134199.00 | 0.00 | 134199.00 | 126 | 35 | 1027 | 626 | 1.6405750798722 | 0.428185422818252 | 0.428185422818252 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 84831a70-166d-421d-b44f-89e4d9cc77bc | 2026-08-18 10:37 | 2026-08-18 10:37 | 2026-08-18 10:37 | QCOM | QCOM261218P00160000 | put | 160.0000 | 2026-12-18 | 17.9500 | 17.4500 | 18.6000 | 158.4500 | 807760.00 | 0.00 | 807760.00 | 450 | 49 | 454 | 2942 | 0.154316791298436 | 0.501249087402121 | 0.501249087402121 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:49:07.673043Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5a955bf5-7392-4ad8-af4e-4ba8a0e68f03 | 2026-08-18 10:19 | 2026-08-18 10:19 | 2026-08-18 10:19 | QCOM | QCOM261016P00160000 | put | 160.0000 | 2026-10-16 | 12.1000 | 12.0500 | 12.3500 | 158.3500 | 628101.00 | 23080.00 | 605021.00 | 519 | 58 | 2533 | 3191 | 0.793795048574115 | 0.462892985307238 | 0.462892985307238 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:32:52.256663Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6743e6e9-f665-4761-a0f3-7ef5ed0c8f88 | 2026-08-18 10:14 | 2026-08-18 10:14 | 2026-08-18 10:14 | QCOM | QCOM261016C00170000 | call | 170.0000 | 2026-10-16 | 7.0000 | 7.0000 | 7.5500 | 158.1500 | 321410.00 | 12690.00 | 308720.00 | 459 | 61 | 466 | 711 | 0.655414908579465 | 0.443516060012864 | 0.445406672919658 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a4882c18-279b-40b7-9b01-e3d4264938ce | 2026-08-17 14:10 | 2026-08-17 14:09 | 2026-08-17 14:09 | QCOM | QCOM260918C00175000 | call | 175.0000 | 2026-09-18 | 3.6000 | 3.6000 | 3.7500 | 161.0000 | 60489.00 | 0.00 | 60489.00 | 168 | 36 | 376 | 3772 | 0.0996818663838812 | 0.425772850186166 | 0.426131350766811 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2e659c9d-afbd-4b9d-ace5-300d8f750377 | 2026-08-17 10:20 | 2026-08-17 10:19 | 2026-08-17 10:19 | QCOM | QCOM270617C00300000 | call | 300.0000 | 2027-06-17 | 6.0000 | 5.7500 | 6.0000 | 164.4400 | 301669.00 | 298744.00 | 2925.00 | 503 | 31 | 808 | 3206 | 0.252027448533999 | 0.524174810394037 | 0.526784770539548 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.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 |
| 10ed049c-2344-41bd-9749-c8a89eabecee | 2026-08-17 10:20 | 2026-08-17 10:19 | 2026-08-17 10:19 | QCOM | QCOM270617C00300000 | call | 300.0000 | 2027-06-17 | 5.9000 | 5.7500 | 6.1000 | 164.4950 | 59015.00 | 4735.00 | 53090.00 | 100 | 7 | 908 | 3206 | 0.283218964441672 | 0.522616762057147 | 0.525234566469257 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.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 |
| 7536b679-0240-4ece-b276-7424e0f87500 | 2026-08-17 10:09 | 2026-08-17 10:09 | 2026-08-17 10:09 | QCOM | QCOM261218P00155000 | put | 155.0000 | 2026-12-18 | 13.2000 | 12.8500 | 13.4500 | 164.0200 | 768260.00 | 7930.00 | 757690.00 | 582 | 44 | 588 | 1153 | 0.509973980919341 | 0.496899235910515 | 0.499260468687616 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fbf62de8-ac8d-4e51-acac-91cb686f67e6 | 2026-08-17 09:55 | 2026-08-17 09:55 | 2026-08-17 09:55 | QCOM | QCOM270319C00240000 | call | 240.0000 | 2027-03-19 | 7.1100 | 6.6000 | 7.9500 | 162.9700 | 177740.00 | 0.00 | 177740.00 | 250 | 6 | 250 | 352 | 0.710227272727273 | 0.508164784751707 | 0.508164784751707 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 50f4d2da-83f4-466d-98ab-ad19fc87cfb4 | 2026-08-17 09:44 | 2026-08-17 09:44 | 2026-08-17 09:44 | QCOM | QCOM280121C00200000 | call | 200.0000 | 2028-01-21 | 29.0100 | 28.5500 | 29.9500 | 163.5300 | 101518.00 | 17415.00 | 84103.00 | 35 | 10 | 57 | 3039 | 0.018756169792695 | 0.486077094306017 | 0.485435523962089 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 189157500000.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |