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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a1229264-43c3-426f-8091-ead75bd00e78 | 2026-08-17 11:11 | 2026-08-17 11:11 | 2026-08-17 11:11 | ZM | ZM270115P00105000 | put | 105.0000 | 2027-01-15 | 11.5100 | 11.1500 | 11.5500 | 105.3900 | 28780.00 | 9230.00 | 0.00 | 25 | 22 | 89 | 1739 | 0.051178838412881 | 0.469332450699677 | 0.471225634902522 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | 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 |
| 117566c0-b3ad-4785-945e-83ee62f71940 | 2026-08-25 11:59 | 2026-08-25 11:59 | 2026-08-25 11:59 | ZM | ZM270319P00100000 | put | 100.0000 | 2027-03-19 | 11.3700 | 11.3000 | 11.4000 | 102.9350 | 59130.00 | 15945.00 | 0.00 | 52 | 34 | 304 | 150 | 2.02666666666667 | 0.460934642610119 | 0.462641919456441 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 04db44f4-4614-4af5-97c5-549f80c235e2 | 2026-08-25 11:59 | 2026-08-25 11:59 | 2026-08-25 11:59 | ZM | ZM270319P00100000 | put | 100.0000 | 2027-03-19 | 11.4200 | 11.4000 | 11.7500 | 102.8600 | 149625.00 | 3435.00 | 84360.00 | 131 | 23 | 252 | 150 | 1.68 | 0.461684358566355 | 0.46339175024658 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0ad145dc-dd29-4176-a6b7-c97edd92c15d | 2026-08-25 14:17 | 2026-08-25 14:17 | 2026-08-25 14:17 | ZM | ZM270219C00100000 | call | 100.0000 | 2027-02-19 | 14.6800 | 14.6500 | 15.4500 | 101.0000 | 14675.00 | 0.00 | 14675.00 | 10 | 6 | 13 | 48 | 0.270833333333333 | 0.463504691157257 | 0.465337133530406 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 66d1d304-0ed2-49b4-b032-f04b9ec64282 | 2026-08-25 15:32 | 2026-08-25 15:32 | 2026-08-25 15:32 | ZM | ZM261120P00080000 | put | 80.0000 | 2026-11-20 | 1.5100 | 0.9400 | 1.8500 | 101.2800 | 74985.00 | 8850.00 | 64625.00 | 497 | 29 | 499 | 135 | 3.6962962962963 | 0.470438684783441 | 0.471456744099762 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T19:47:14.629482Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0b677761-a5e9-487f-a74a-a1dfebb46629 | 2026-08-25 15:59 | 2026-08-25 15:59 | 2026-08-25 15:59 | ZM | ZM260828P00095000 | put | 95.0000 | 2026-08-28 | 2.2100 | 2.2000 | 2.3000 | 101.0000 | 12389.00 | 1115.00 | 11274.00 | 56 | 23 | 2324 | 449 | 5.17594654788419 | 1.30233330501211 | 1.30233330501211 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:31:08.388238Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8b6bd183-1d80-4f40-8e5f-3cbae752d37e | 2026-08-26 09:36 | 2026-08-26 09:36 | 2026-08-26 09:36 | ZM | ZM260828P00097000 | put | 97.0000 | 2026-08-28 | 2.4600 | 2.0500 | 2.7100 | 96.3800 | 24593.00 | 24593.00 | 0.00 | 100 | 5 | 368 | 442 | 0.832579185520362 | 0.709693656385374 | 0.752009345687199 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T13:43:42.919667Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 75198c38-4458-4b10-b84f-4c1072e12c0e | 2026-08-26 09:55 | 2026-08-26 09:55 | 2026-08-26 09:55 | ZM | ZM261016C00100000 | call | 100.0000 | 2026-10-16 | 4.1200 | 4.0000 | 4.4500 | 94.6100 | 168461.00 | 83256.00 | 83975.00 | 409 | 23 | 592 | 71 | 8.33802816901408 | 0.432919232353586 | 0.434772105627416 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 31472039-542c-467a-b225-048d52f4c58d | 2026-08-26 09:56 | 2026-08-26 09:56 | 2026-08-26 09:56 | ZM | ZM261016C00100000 | call | 100.0000 | 2026-10-16 | 4.0500 | 4.0000 | 4.3000 | 94.7400 | 411500.00 | 0.00 | 410285.00 | 1016 | 52 | 2201 | 71 | 31 | 0.420352466422365 | 0.423629371026307 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fff3338d-2113-44e2-8eb0-6ce53ff8ea76 | 2026-08-26 10:27 | 2026-08-26 10:27 | 2026-08-26 10:27 | ZM | ZM270617C00110000 | call | 110.0000 | 2027-06-17 | 11.0100 | 11.0000 | 11.7000 | 95.2100 | 15410.00 | 1105.00 | 14305.00 | 14 | 9 | 19 | 766 | 0.0248041775456919 | 0.446132104489223 | 0.447600794295497 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e3a741cf-0dcc-4857-a727-c4d8734f3377 | 2026-08-26 10:32 | 2026-08-26 10:32 | 2026-08-26 10:32 | ZM | ZM270617C00110000 | call | 110.0000 | 2027-06-17 | 10.8000 | 10.8000 | 11.4000 | 94.9000 | 60505.00 | 2175.00 | 58330.00 | 56 | 7 | 110 | 766 | 0.143603133159269 | 0.441796813802742 | 0.445978140309276 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a544e925-c9fb-4ed8-8910-47627e4eaa97 | 2026-08-27 14:57 | 2026-08-27 14:57 | 2026-08-27 14:57 | ZM | ZM280121C00165000 | call | 165.0000 | 2028-01-21 | 7.1200 | 6.7500 | 7.3500 | 99.0400 | 28470.00 | 28470.00 | 0.00 | 40 | 7 | 42 | 233 | 0.180257510729614 | 0.448853855624723 | 0.448853855624723 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | 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 |
| dc6e1637-c9c4-4649-8ebf-654f9810bd93 | 2026-09-02 15:58 | 2026-09-02 15:57 | 2026-09-02 15:57 | ZM | ZM270617P00090000 | put | 90.0000 | 2027-06-17 | 9.7900 | 9.7500 | 9.9500 | 96.1100 | 205600.00 | 156800.00 | 48800.00 | 210 | 21 | 630 | 75 | 8.4 | 0.421432540563177 | 0.422726987968076 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cc14ea76-1de9-421e-bae2-9dc910d6e418 | 2026-09-02 15:58 | 2026-09-02 15:57 | 2026-09-02 15:57 | ZM | ZM270617C00110000 | call | 110.0000 | 2027-06-17 | 10.6900 | 9.9000 | 10.7000 | 96.1000 | 213800.00 | 213800.00 | 0.00 | 200 | 21 | 1000 | 800 | 1.25 | 0.433282957088701 | 0.434893766120193 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 275efb9e-182a-4765-900c-ed8ba3f4478c | 2026-09-03 11:00 | 2026-09-03 11:00 | 2026-09-03 11:00 | ZM | ZM260918C00105000 | call | 105.0000 | 2026-09-18 | 0.8900 | 0.7600 | 0.9300 | 97.3700 | 16267.00 | 15634.00 | 633.00 | 182 | 45 | 215 | 4187 | 0.0513494148555051 | 0.415343428938317 | 0.418931343861101 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | 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 |
| 6948f76c-7c2f-4f99-b6ec-274734b3cb43 | 2026-09-03 15:41 | 2026-09-03 15:40 | 2026-09-03 15:40 | ZM | ZM260918P00095000 | put | 95.0000 | 2026-09-18 | 1.7300 | 1.6000 | 1.8000 | 97.8400 | 19685.00 | 17951.00 | 1734.00 | 114 | 9 | 387 | 1215 | 0.318518518518519 | 0.382466669258367 | 0.386637954353953 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T19:48:49.580975Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7f4fb830-b665-4668-afe3-6eba49c53a42 | 2026-09-09 15:47 | 2026-09-09 15:46 | 2026-09-09 15:46 | ZM | ZM261016C00105000 | call | 105.0000 | 2026-10-16 | 2.3000 | 2.2700 | 2.3900 | 96.6000 | 18828.00 | 1609.00 | 17219.00 | 82 | 10 | 318 | 974 | 0.326488706365503 | 0.420849077993678 | 0.421224682814184 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 25101912326.00 | 2026-11-23 | 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 |
| 9b1ede05-485a-4949-8d30-a2d48550517b | 2026-09-17 10:43 | 2026-09-17 10:43 | 2026-09-17 10:43 | ZM | ZM261016P00087500 | put | 87.5000 | 2026-10-16 | 1.7500 | 1.7400 | 1.7600 | 92.4900 | 25037.00 | 3862.00 | 21175.00 | 143 | 36 | 250 | 92 | 2.71739130434783 | 0.378233209770024 | 0.378233209770024 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 24259566275.00 | 2026-11-23 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 2a33e4c7-91ba-4417-9abb-05bcbba2ad54 | 2026-09-18 09:31 | 2026-09-18 09:31 | 2026-09-18 09:31 | ZM | ZM261016P00085000 | put | 85.0000 | 2026-10-16 | 1.2400 | 1.0500 | 1.4300 | 91.0800 | 26512.00 | 13145.00 | 13367.00 | 213 | 5 | 215 | 804 | 0.267412935323383 | 0.357068490000393 | 0.3664248157575 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Communication Services | 23367205927.00 | 2026-11-23 | 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 |