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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f7d358d8-c5fe-49eb-abe8-f695ec881104 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 2.4500 | 2.3500 | 2.5500 | 44.5000 | 20796.00 | 2550.00 | 14081.00 | 85 | 8 | 948 | 2305 | 0.411279826464208 | 0.821153550829819 | 0.855327724979994 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | 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 |
| ad555e24-6d35-41f1-81df-5d4b164531a7 | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | VIAV | VIAV260918C00060000 | call | 60.0000 | 2026-09-18 | 0.9500 | 0.6750 | 1.0500 | 44.6250 | 16218.00 | 14988.00 | 1140.00 | 171 | 34 | 186 | 2194 | 0.0847766636280766 | 0.89936594609771 | 0.90238497815039 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | 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 |
| 9f0ff4dd-09ed-4822-90ef-8be0b6840aba | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 2.7700 | 2.7000 | 2.9000 | 45.0000 | 22426.00 | 15001.00 | 3300.00 | 81 | 25 | 2595 | 2305 | 1.12581344902386 | 0.861170684517668 | 0.857010643813483 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | 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 |
| fe754792-0398-49fa-9d6d-783f0e379253 | 2026-08-17 09:32 | 2026-08-17 09:32 | 2026-08-17 09:32 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 3.0100 | 3.0000 | 3.1000 | 44.5950 | 22246.00 | 0.00 | 21636.00 | 74 | 10 | 4912 | 2305 | 2.13101952277657 | 0.937266172431451 | 0.937266172431451 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | 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 |
| 126dde41-4951-4e7d-aaa8-5d72b4cf67c6 | 2026-08-17 09:56 | 2026-08-17 09:56 | 2026-08-17 09:56 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 3.0000 | 2.9500 | 3.1000 | 45.6750 | 46220.00 | 0.00 | 45000.00 | 154 | 33 | 8539 | 2305 | 3.70455531453362 | 0.852837034083574 | 0.852837034083574 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.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 |
| f8d38f6b-c24c-44a7-a2ab-9730437730b0 | 2026-08-17 10:20 | 2026-08-17 10:20 | 2026-08-17 10:20 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 2.8900 | 2.8000 | 2.9000 | 45.4100 | 29225.00 | 26660.00 | 2280.00 | 101 | 11 | 10375 | 2305 | 4.50108459869848 | 0.852188875915001 | 0.854442939948907 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.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 |
| 493db300-4d40-4bbb-830e-4bcdac94f279 | 2026-08-17 11:02 | 2026-08-17 11:02 | 2026-08-17 11:02 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 3.1100 | 3.1000 | 3.2000 | 46.3000 | 30799.00 | 0.00 | 24184.00 | 99 | 27 | 11898 | 2305 | 5.16182212581345 | 0.811062536376808 | 0.822220446361872 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1f71007c-12e0-417a-99cd-3db89b5f1176 | 2026-08-17 11:04 | 2026-08-17 11:04 | 2026-08-17 11:04 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 3.0200 | 2.9500 | 3.1000 | 46.1400 | 37130.00 | 7625.00 | 23100.00 | 123 | 25 | 12053 | 2305 | 5.22906724511931 | 0.816254672788139 | 0.825605132972591 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 88568f3f-491f-447b-a58c-fb385ea970f3 | 2026-08-17 11:50 | 2026-08-17 11:49 | 2026-08-17 11:49 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 2.9100 | 2.9000 | 2.9500 | 45.7600 | 13658.00 | 1172.00 | 12486.00 | 47 | 18 | 14158 | 2305 | 6.14229934924078 | 0.827208687884543 | 0.827208687884543 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:01:56.961018Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8da0e2b8-d263-4d63-a0f9-21ce9abd984c | 2026-08-17 13:11 | 2026-08-17 13:11 | 2026-08-17 13:11 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 3.0800 | 3.0000 | 3.1000 | 46.1100 | 15375.00 | 10800.00 | 0.00 | 50 | 5 | 16795 | 2305 | 7.28633405639913 | 0.827979888455105 | 0.837329991887574 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8575cb12-26d5-441d-a049-3914102ffa71 | 2026-08-17 13:12 | 2026-08-17 13:12 | 2026-08-17 13:12 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 3.1600 | 3.1000 | 3.2000 | 46.2099 | 10110.00 | 9480.00 | 0.00 | 32 | 5 | 17113 | 2305 | 7.42429501084599 | 0.838703460214746 | 0.838703460214746 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:22:08.033203Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 185a0e54-0d7f-4d8d-9465-0fd6c837083a | 2026-08-17 14:08 | 2026-08-17 14:08 | 2026-08-17 14:08 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 3.1500 | 3.1000 | 3.2000 | 46.0000 | 15429.00 | 0.00 | 624.00 | 49 | 17 | 23906 | 2305 | 10.3713665943601 | 0.825537956866675 | 0.831109054639912 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.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 |
| 03fa7e32-7b54-4b8a-bd56-59ef92039f4d | 2026-08-17 14:15 | 2026-08-17 14:15 | 2026-08-17 14:15 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 3.1000 | 3.1000 | 3.2000 | 46.3400 | 81263.00 | 0.00 | 81263.00 | 262 | 80 | 24362 | 2305 | 10.5691973969631 | 0.819034696717956 | 0.819034696717956 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fa9fcbcf-cd2a-4acd-8534-234f69a68e06 | 2026-08-17 14:21 | 2026-08-17 14:21 | 2026-08-17 14:21 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 3.0000 | 3.0000 | 3.1000 | 46.0775 | 25814.00 | 0.00 | 25814.00 | 86 | 13 | 24557 | 2305 | 10.6537960954447 | 0.821183032385104 | 0.821183032385104 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:41:22.197029Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| df532b04-3642-4f7f-a89f-2df056aeed45 | 2026-08-18 09:30 | 2026-08-18 09:30 | 2026-08-18 09:30 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 2.5400 | 1.6000 | 2.8000 | 43.5400 | 16260.00 | 16260.00 | 0.00 | 64 | 21 | 67 | 20390 | 0.00328592447278077 | 0.743185894485487 | 0.994598593340305 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d629f0c6-17c4-43b8-838c-1d008fef2c67 | 2026-08-18 09:30 | 2026-08-18 09:30 | 2026-08-18 09:30 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 2.3600 | 2.0000 | 2.5500 | 43.5400 | 21960.00 | 9585.00 | 200.00 | 93 | 12 | 221 | 20390 | 0.0108386463952918 | 0.82473605750447 | 0.942312746262734 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3329dc0c-c199-4425-a26a-d3ea11a3b599 | 2026-08-18 09:30 | 2026-08-18 09:30 | 2026-08-18 09:30 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 2.1900 | 1.6500 | 2.4750 | 43.5400 | 13155.00 | 12945.00 | 210.00 | 60 | 17 | 128 | 20390 | 0.0062775870524767 | 0.82473605750447 | 0.846432860167468 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3d0313b9-9f41-464b-b0b3-e5f44c0ee832 | 2026-08-18 09:30 | 2026-08-18 09:30 | 2026-08-18 09:30 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 2.4300 | 2.1500 | 2.4500 | 43.6300 | 11918.00 | 10532.00 | 1386.00 | 49 | 16 | 1447 | 20390 | 0.0709661598822952 | 0.872048871619228 | 0.91444557958731 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:38:24.498702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1123002b-11b7-463e-916a-bff8d76170d5 | 2026-08-18 09:45 | 2026-08-18 09:45 | 2026-08-18 09:45 | VIAV | VIAV260918C00050000 | call | 50.0000 | 2026-09-18 | 2.0000 | 1.9500 | 2.1000 | 42.0000 | 11617.00 | 0.00 | 11617.00 | 58 | 12 | 2605 | 20390 | 0.12775870524767 | 0.861312365317369 | 0.869278740015016 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e254aafc-0df3-4aa9-88a1-1a7ba75acbd5 | 2026-08-18 11:01 | 2026-08-18 11:00 | 2026-08-18 11:00 | VIAV | VIAV260821C00046000 | call | 46.0000 | 2026-08-21 | 0.2000 | 0.2000 | 0.3000 | 40.8700 | 11020.00 | 0.00 | 11020.00 | 550 | 27 | 569 | 1005 | 0.566169154228856 | 1.03118734828944 | 1.03118734828944 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b03c76e4-2b51-4c1b-afbb-2d9c40e6b927 | 2026-08-18 15:46 | 2026-08-18 15:46 | 2026-08-18 15:46 | VIAV | VIAV261120P00025000 | put | 25.0000 | 2026-11-20 | 0.9500 | 0.9500 | 1.0500 | 41.0000 | 19102.00 | 0.00 | 19102.00 | 201 | 30 | 207 | 282 | 0.734042553191489 | 0.90943298361938 | 0.909693637386845 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8345079183.00 | 2026-11-04 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T13:30:09.852702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d5cf46b6-d368-4974-84c9-1b959e1fb5d7 | 2026-09-16 11:07 | 2026-09-16 11:07 | 2026-09-16 11:07 | VIAV | VIAV270115C00055000 | call | 55.0000 | 2027-01-15 | 1.4500 | 1.4500 | 1.5500 | 34.3700 | 119495.00 | 0.00 | 119495.00 | 824 | 38 | 824 | 1253 | 0.657621707901037 | 0.763942795985151 | 0.763942795985151 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 8505466571.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |