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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f428eb94-a482-4b14-a083-d6338e74891c | 2026-08-17 09:30 | 2026-08-17 09:30 | 2026-08-17 09:30 | AVAV | AVAV261218P00120000 | put | 120.0000 | 2026-12-18 | 5.1000 | 3.9000 | 5.1000 | 191.9800 | 16819.00 | 16819.00 | 0.00 | 33 | 6 | 34 | 78 | 0.435897435897436 | 0.789568939171019 | 0.789056251694771 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | 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 |
| c6301a48-cd5a-4181-91d8-01114fc839aa | 2026-08-17 11:26 | 2026-08-17 11:26 | 2026-08-17 11:26 | AVAV | AVAV270115P00195000 | put | 195.0000 | 2027-01-15 | 39.7600 | 37.5000 | 40.3000 | 183.6500 | 75550.00 | 55700.00 | 19850.00 | 19 | 5 | 26 | 151 | 0.172185430463576 | 0.745238526405661 | 0.745238526405661 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 61b17351-a675-471c-b7d5-c5ec18ef46fc | 2026-08-20 13:43 | 2026-08-20 13:43 | 2026-08-20 13:43 | AVAV | AVAV260918P00150000 | put | 150.0000 | 2026-09-18 | 10.2800 | 10.2000 | 10.6000 | 156.8000 | 13370.00 | 2060.00 | 11310.00 | 13 | 8 | 64 | 772 | 0.0829015544041451 | 0.792424543673661 | 0.786447563773916 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 85605931-e3e6-4973-8028-052a25aa51d9 | 2026-08-25 09:32 | 2026-08-25 09:32 | 2026-08-25 09:32 | AVAV | AVAV270115C00200000 | call | 200.0000 | 2027-01-15 | 14.0900 | 12.3000 | 14.1000 | 150.4250 | 57750.00 | 1400.00 | 1360.00 | 41 | 8 | 41 | 733 | 0.0559345156889495 | 0.752450336327125 | 0.738327476925304 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:32:26.163070Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1d1708b1-e07d-44a5-918c-a3dd974855d3 | 2026-08-25 14:55 | 2026-08-25 14:55 | 2026-08-25 14:55 | AVAV | AVAV261218C00170000 | call | 170.0000 | 2026-12-18 | 17.2100 | 17.0000 | 17.7000 | 147.9000 | 12049.00 | 0.00 | 12049.00 | 7 | 5 | 7 | 108 | 0.0648148148148148 | 0.742311706983479 | 0.742311706983479 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T19:21:53.483381Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 58b14e9b-ee4c-4fb0-87ef-56a24e435784 | 2026-08-27 13:05 | 2026-08-27 13:05 | 2026-08-27 13:05 | AVAV | AVAV260828C00155000 | call | 155.0000 | 2026-08-28 | 1.4000 | 0.7500 | 1.4500 | 151.5300 | 31225.00 | 31225.00 | 0.00 | 223 | 18 | 557 | 364 | 1.53021978021978 | 0.921186178350962 | 0.794546921600323 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dec8c137-b434-4a8f-82b9-662919db1ce4 | 2026-09-01 10:40 | 2026-09-01 10:40 | 2026-09-01 10:40 | AVAV | AVAV260918C00170000 | call | 170.0000 | 2026-09-18 | 3.4000 | 3.3000 | 3.4000 | 144.7700 | 17325.00 | 16660.00 | 330.00 | 51 | 12 | 107 | 589 | 0.181663837011885 | 0.885811519314692 | 0.875254218381989 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 072cd47e-bcd7-45ea-9361-eaf08df5f1a5 | 2026-09-01 10:46 | 2026-09-01 10:46 | 2026-09-01 10:46 | AVAV | AVAV261218P00150000 | put | 150.0000 | 2026-12-18 | 24.5200 | 22.8000 | 25.2000 | 144.9800 | 24522.00 | 24522.00 | 0.00 | 10 | 6 | 10 | 184 | 0.0543478260869565 | 0.723035552347642 | 0.723035552347642 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:59:17.018627Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9014ac71-ad69-4094-a6d3-9f36d43920d0 | 2026-09-03 09:45 | 2026-09-03 09:45 | 2026-09-03 09:45 | AVAV | AVAV260918C00150000 | call | 150.0000 | 2026-09-18 | 9.5400 | 8.6000 | 10.2000 | 147.1450 | 47716.00 | 47716.00 | 0.00 | 50 | 8 | 65 | 170 | 0.382352941176471 | 0.907456528905436 | 0.907456528905436 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e838eb05-4a1d-437b-a075-70cda16e1724 | 2026-09-03 10:28 | 2026-09-03 10:28 | 2026-09-03 10:28 | AVAV | AVAV261218P00120000 | put | 120.0000 | 2026-12-18 | 10.3200 | 10.0000 | 10.9000 | 143.3100 | 10324.00 | 0.00 | 10324.00 | 10 | 6 | 13 | 105 | 0.123809523809524 | 0.729239157471984 | 0.729239157471984 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:40:26.963433Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 24a13199-45f2-47eb-a38d-9a7d1abc01b2 | 2026-09-03 11:09 | 2026-09-03 11:09 | 2026-09-03 11:09 | AVAV | AVAV260918C00150000 | call | 150.0000 | 2026-09-18 | 7.8300 | 7.8000 | 8.2000 | 141.9701 | 39130.00 | 0.00 | 39130.00 | 50 | 12 | 143 | 170 | 0.841176470588235 | 0.965979259933161 | 0.965979259933161 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T15:12:38.137640Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c254a1a9-2bef-442f-bf88-27f63d8b7f2d | 2026-09-09 11:42 | 2026-09-09 11:41 | 2026-09-09 11:41 | AVAV | AVAV261218C00160000 | call | 160.0000 | 2026-12-18 | 15.5000 | 15.5000 | 16.0000 | 141.9400 | 15502.00 | 0.00 | 15502.00 | 10 | 5 | 12 | 334 | 0.0359281437125748 | 0.731007423447352 | 0.730329711111003 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2594fdfe-4f65-4a61-9d3e-f3afed2edbb4 | 2026-09-09 14:19 | 2026-09-09 14:18 | 2026-09-09 14:18 | AVAV | AVAV261023C00145000 | call | 145.0000 | 2026-10-23 | 13.8900 | 12.6000 | 14.0000 | 141.5600 | 195880.00 | 163680.00 | 0.00 | 141 | 15 | 157 | 75 | 2.09333333333333 | 0.781071282415015 | 0.760992729495225 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2a97ded4-5025-458d-a7c0-4e9f3bc9e0dc | 2026-09-09 15:52 | 2026-09-09 15:52 | 2026-09-09 15:52 | AVAV | AVAV261016P00105000 | put | 105.0000 | 2026-10-16 | 1.5000 | 1.5000 | 2.0500 | 140.0900 | 40518.00 | 0.00 | 40518.00 | 270 | 6 | 345 | 63 | 5.47619047619048 | 0.746415375107999 | 0.746415375107999 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T19:53:17.072904Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fd5119cc-dcc0-4881-861f-9d0e8829b97e | 2026-09-10 09:30 | 2026-09-10 09:30 | 2026-09-10 09:30 | AVAV | AVAV260911C00148000 | call | 148.0000 | 2026-09-11 | 4.2800 | 2.3000 | 5.5000 | 146.4900 | 11560.00 | 11170.00 | 390.00 | 27 | 5 | 35 | 64 | 0.546875 | 1.63063575833132 | 1.49941905250947 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T13:32:54.294551Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4b8dd5f3-9813-4b12-9c79-5c6c374aabe6 | 2026-09-10 09:37 | 2026-09-10 09:37 | 2026-09-10 09:37 | AVAV | AVAV270319C00145000 | call | 145.0000 | 2027-03-19 | 35.6700 | 35.2000 | 38.7000 | 153.1750 | 17834.00 | 0.00 | 17834.00 | 5 | 5 | 13 | 56 | 0.232142857142857 | 0.714018050325446 | 0.714018050325446 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T13:42:34.192825Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2f24b1ca-77eb-4c2a-81f4-fed553e4e1b2 | 2026-09-10 10:25 | 2026-09-10 10:25 | 2026-09-10 10:25 | AVAV | AVAV270115C00145000 | call | 145.0000 | 2027-01-15 | 30.7700 | 29.3000 | 31.9000 | 155.3000 | 15385.00 | 15385.00 | 0.00 | 5 | 5 | 30 | 127 | 0.236220472440945 | 0.697642800273652 | 0.697642800273652 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7bc30ea9-a8ba-4026-8021-77b7ee167f27 | 2026-09-10 11:08 | 2026-09-10 11:07 | 2026-09-10 11:07 | AVAV | AVAV260918C00150000 | call | 150.0000 | 2026-09-18 | 9.8700 | 9.3000 | 11.0000 | 155.8933 | 11844.00 | 0.00 | 11844.00 | 12 | 6 | 781 | 603 | 1.29519071310116 | 0.71223491328214 | 0.71223491328214 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b4f42829-ca02-482e-b7a7-1689809b52bf | 2026-09-11 12:45 | 2026-09-11 12:45 | 2026-09-11 12:45 | AVAV | AVAV260918C00140000 | call | 140.0000 | 2026-09-18 | 5.4700 | 5.2000 | 6.2000 | 141.2700 | 21348.00 | 0.00 | 21348.00 | 39 | 12 | 135 | 315 | 0.428571428571429 | 0.617306589608727 | 0.617306589608727 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ee19c571-1834-41e3-a111-e23aa1561313 | 2026-09-11 13:52 | 2026-09-11 13:52 | 2026-09-11 13:52 | AVAV | AVAV260911C00146000 | call | 146.0000 | 2026-09-11 | 0.5500 | 0.2000 | 0.5500 | 145.1032 | 36878.00 | 36878.00 | 0.00 | 671 | 45 | 776 | 85 | 9.12941176470588 | 1.02908810299084 | 1.02908810299084 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e6a2cd7c-ffe2-4aa2-acc5-a208c322f044 | 2026-09-14 11:36 | 2026-09-14 11:36 | 2026-09-14 11:36 | AVAV | AVAV261016P00150000 | put | 150.0000 | 2026-10-16 | 8.6000 | 8.3000 | 8.7000 | 155.2300 | 242502.00 | 238202.00 | 4300.00 | 282 | 34 | 287 | 215 | 1.33488372093023 | 0.62480054932217 | 0.62480054932217 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:39:52.032222Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dc2c4b7e-84cd-4094-95f0-9919f03538ce | 2026-09-14 11:36 | 2026-09-14 11:36 | 2026-09-14 11:36 | AVAV | AVAV261016P00155000 | put | 155.0000 | 2026-10-16 | 10.9000 | 10.8000 | 11.3000 | 155.2300 | 119950.00 | 101470.00 | 18480.00 | 110 | 21 | 116 | 123 | 0.943089430894309 | 0.616584860231723 | 0.622076307368672 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 7795895687.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:39:52.032222Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 55a1aa2c-4df2-4235-a932-59681d1a25e4 | 2026-09-17 10:05 | 2026-09-17 10:05 | 2026-09-17 10:05 | AVAV | AVAV261016P00180000 | put | 180.0000 | 2026-10-16 | 21.3000 | 20.2000 | 21.3000 | 164.9400 | 583600.00 | 583600.00 | 0.00 | 274 | 37 | 274 | 18 | 15.2222222222222 | 0.660600265328915 | 0.660600265328915 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 8303086293.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:07:38.635762Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 8bab767d-9907-4c5f-9de3-726397a9df11 | 2026-09-18 12:54 | 2026-09-18 12:54 | 2026-09-18 12:54 | AVAV | AVAV270115C00170000 | call | 170.0000 | 2027-01-15 | 21.7000 | 21.5000 | 22.6000 | 161.4150 | 10850.00 | 0.00 | 10850.00 | 5 | 5 | 12 | 287 | 0.0418118466898955 | 0.66334446258368 | 0.66334446258368 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 8128771285.00 | 2026-12-08 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |