Simplify AnalyticsOptions 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d5fd4b16-4c0c-40c3-834f-1acebde62187 | 2026-08-20 12:48 | 2026-08-20 12:48 | 2026-08-20 12:48 | NBIS | NBIS270617P00090000 | put | 90.0000 | 2027-06-17 | 10.6500 | 9.9500 | 10.8000 | 216.1500 | 3195000.00 | 3195000.00 | 0.00 | 3000 | 1 | 3001 | 553 | 5.42676311030741 | 1.03438386808448 | 1.03438386808448 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 45b213f6-ee05-4672-8dec-e35a8770fec5 | 2026-08-20 14:57 | 2026-08-20 14:57 | 2026-08-20 14:57 | NBIS | NBIS270617C00220000 | call | 220.0000 | 2027-06-17 | 75.5800 | 74.0000 | 77.5000 | 216.3200 | 755800.00 | 0.00 | 755800.00 | 100 | 2 | 102 | 130 | 0.784615384615385 | 0.981322709592941 | 0.981322709592941 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:16:26.699237Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 673c5667-621a-4b13-a81d-6406d98e28f9 | 2026-08-21 10:32 | 2026-08-21 10:32 | 2026-08-21 10:32 | NBIS | NBIS261218P00165000 | put | 165.0000 | 2026-12-18 | 18.4000 | 17.8500 | 20.1500 | 221.0200 | 276000.00 | 0.00 | 276000.00 | 150 | 1 | 151 | 230 | 0.656521739130435 | 0.958422103801756 | 0.958422103801756 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:36:46.143381Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 31314c46-4105-4a95-b4c9-1958fe16b43b | 2026-08-24 12:52 | 2026-08-24 12:52 | 2026-08-24 12:52 | NBIS | NBIS280616P00130000 | put | 130.0000 | 2028-06-16 | 42.0000 | 42.0000 | 43.9500 | 211.3800 | 1260000.00 | 0.00 | 1260000.00 | 300 | 1 | 1004 | 7 | 143.428571428571 | 0.980180752673408 | 0.980180752673408 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T17:17:38.633077Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 25e4d522-26d9-4e9a-bab3-27e6a069739b | 2026-08-24 15:14 | 2026-08-24 15:14 | 2026-08-24 15:14 | NBIS | NBIS270219P00210000 | put | 210.0000 | 2027-02-19 | 52.6500 | 51.3500 | 53.7000 | 210.6401 | 1000350.00 | 1000350.00 | 0.00 | 190 | 1 | 190 | 183 | 1.03825136612022 | 0.962214452008566 | 0.962214452008566 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5861f92b-af47-4c5e-88be-46ce545a4af3 | 2026-08-31 10:37 | 2026-08-31 10:37 | 2026-08-31 10:37 | NBIS | NBIS270115P00140000 | put | 140.0000 | 2027-01-15 | 12.7500 | 12.5000 | 13.5000 | 203.9300 | 446250.00 | 0.00 | 446250.00 | 350 | 1 | 350 | 1640 | 0.213414634146341 | 0.898583332232599 | 0.898583332232599 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T14:41:39.850499Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ec228708-e1aa-4e5b-9479-922d750344b8 | 2026-09-01 10:23 | 2026-09-01 10:23 | 2026-09-01 10:23 | NBIS | NBIS261016P00125000 | put | 125.0000 | 2026-10-16 | 1.4000 | 1.3700 | 1.6900 | 196.3200 | 956200.00 | 0.00 | 956200.00 | 6830 | 1 | 6835 | 914 | 7.4781181619256 | 0.868842470525386 | 0.868842470525386 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 376c5e95-2546-4393-99eb-38a5d9d28ad5 | 2026-09-01 11:27 | 2026-09-01 11:26 | 2026-09-01 11:26 | NBIS | NBIS270319P00130000 | put | 130.0000 | 2027-03-19 | 15.4000 | 14.4000 | 16.8500 | 199.5800 | 616000.00 | 0.00 | 616000.00 | 400 | 1 | 401 | 1394 | 0.287661406025825 | 0.906058809763608 | 0.906058809763608 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T15:45:30.323966Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e9785d45-4f99-4cc5-b671-6f24345f32ed | 2026-09-01 14:52 | 2026-09-01 14:52 | 2026-09-01 14:52 | NBIS | NBIS270917P00120000 | put | 120.0000 | 2027-09-17 | 23.0000 | 22.5500 | 24.0000 | 199.5300 | 460000.00 | 0.00 | 460000.00 | 200 | 1 | 205 | 14 | 14.6428571428571 | 0.919645024529893 | 0.919645024529893 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:58:03.753197Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d669e415-ffea-4341-bebc-d76ea29b7b6a | 2026-09-02 09:42 | 2026-09-02 09:42 | 2026-09-02 09:42 | NBIS | NBIS270219C00210000 | call | 210.0000 | 2027-02-19 | 46.8000 | 45.6000 | 47.4000 | 202.9555 | 374400.00 | 374400.00 | 0.00 | 80 | 1 | 80 | 66 | 1.21212121212121 | 0.881678894286389 | 0.881678894286389 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T13:56:06.315925Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 66e49fd4-33be-406f-99bf-9b680a539d4d | 2026-09-02 10:25 | 2026-09-02 10:24 | 2026-09-02 10:24 | NBIS | NBIS270319P00125000 | put | 125.0000 | 2027-03-19 | 13.2000 | 12.7000 | 14.3000 | 201.5100 | 660000.00 | 0.00 | 660000.00 | 500 | 1 | 500 | 265 | 1.88679245283019 | 0.90264110235019 | 0.90264110235019 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7d0c4559-8d8b-49b0-b3cc-1869ca3bee35 | 2026-09-14 10:34 | 2026-09-14 10:34 | 2026-09-14 10:34 | NBIS | NBIS270617P00075000 | put | 75.0000 | 2027-06-17 | 4.6900 | 3.7000 | 4.9500 | 213.7876 | 1127476.00 | 1127476.00 | 0.00 | 2404 | 2 | 2412 | 3626 | 0.665195808052951 | 0.970199195417767 | 0.970199195417767 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Communication Services | 46568297023.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7c075e64-28a7-4f45-a91c-f153b80745a2 | 2026-09-15 12:37 | 2026-09-15 12:37 | 2026-09-15 12:37 | NBIS | NBIS281215C00210000 | call | 210.0000 | 2028-12-15 | 112.0500 | 110.4500 | 113.5500 | 209.0000 | 459405.00 | 459405.00 | 0.00 | 41 | 2 | 53 | 361 | 0.146814404432133 | 0.921386025947055 | 0.921386025947055 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 46568297023.00 | — | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| ecea48b7-5a3c-48b6-bfd9-f2dc86eaa68d | 2026-09-16 10:15 | 2026-09-16 10:15 | 2026-09-16 10:15 | NBIS | NBIS261218P00200000 | put | 200.0000 | 2026-12-18 | 28.4000 | 27.5500 | 29.1500 | 214.0000 | 1065000.00 | 1065000.00 | 0.00 | 375 | 1 | 395 | 2606 | 0.151573292402149 | 0.878507584691776 | 0.878507584691776 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 45949405475.00 | — | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 1ed5bfc9-c5d8-4c45-ae9a-6236647bee26 | 2026-09-18 10:11 | 2026-09-18 10:11 | 2026-09-18 10:11 | NBIS | NBIS260925P00225000 | put | 225.0000 | 2026-09-25 | 17.0500 | 16.8000 | 17.0500 | 212.2500 | 758725.00 | 758725.00 | 0.00 | 445 | 2 | 886 | 315 | 2.81269841269841 | 0.784117868881801 | 0.784117868881801 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Communication Services | 49059225772.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:19:45.885567Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 12c38aaa-e3e3-4751-8f26-3d064c74c2fb | 2026-09-18 10:38 | 2026-09-18 10:38 | 2026-09-18 10:38 | NBIS | NBIS261009P00210000 | put | 210.0000 | 2026-10-09 | 13.6500 | 12.7500 | 13.6500 | 214.6300 | 204750.00 | 204750.00 | 0.00 | 150 | 1 | 476 | 576 | 0.826388888888889 | 0.793372508935605 | 0.793372508935605 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Communication Services | 49059225772.00 | — | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:47:44.869175Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |