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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c9484f09-231a-4474-a609-5572552ea090 | 2026-09-18 12:42 | 2026-09-18 12:41 | 2026-09-18 12:41 | CDE | CDE261016C00022500 | call | 22.5000 | 2026-10-16 | 0.4600 | 0.4500 | 0.5000 | 19.8099 | 83215.00 | 18100.00 | 65115.00 | 1809 | 2 | 2640 | 3231 | 0.817084493964717 | 0.594385588149425 | 0.622672699931444 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 20311995560.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| ed1cbbbc-d8e0-47fc-9717-47d25379b359 | 2026-09-08 15:37 | 2026-09-08 15:37 | 2026-09-08 15:37 | CDE | CDE261218C00040000 | call | 40.0000 | 2026-12-18 | 0.2700 | 0.2000 | 0.3000 | 20.8201 | 27000.00 | 12000.00 | 0.00 | 1000 | 2 | 2000 | 5965 | 0.335289186923722 | 0.754998834672824 | 0.784847632575508 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 20435347760.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T19:50:17.541936Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 09e36085-4207-45cd-8e99-5779976a4faa | 2026-09-03 13:22 | 2026-09-03 13:22 | 2026-09-03 13:22 | AG | AG261218C00023000 | call | 23.0000 | 2026-12-18 | 2.4900 | 2.4500 | 2.6400 | 21.2550 | 747000.00 | 0.00 | 747000.00 | 3000 | 2 | 3069 | 582 | 5.27319587628866 | 0.67929223236361 | 0.67929223236361 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 9236859315.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T17:30:37.600118Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 156be01a-6ee3-43cc-81dc-ce8352e70710 | 2026-09-03 09:51 | 2026-09-03 09:50 | 2026-09-03 09:50 | DD | DD261016C00135000 | call | 135.0000 | 2026-10-16 | 4.7500 | 3.3000 | 5.5000 | 132.8900 | 475000.00 | 475000.00 | 0.00 | 1000 | 2 | 1000 | 8 | 125 | 0.299376168925568 | 0.299376168925568 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 16784491363.00 | 2026-11-05 | 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 |
| ce53fe67-942f-41f1-954d-04c3195529df | 2026-08-28 13:42 | 2026-08-28 13:42 | 2026-08-28 13:42 | NTR | NTR261218C00090000 | call | 90.0000 | 2026-12-18 | 1.0600 | 0.8000 | 1.4000 | 73.8400 | 212000.00 | 0.00 | 212000.00 | 2000 | 6 | 2000 | 43 | 46.5116279069767 | 0.317481094251029 | 0.317481094251029 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 23955899394.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T17:47:47.104019Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b748a288-9af2-40d7-977c-3e51c43f4091 | 2026-08-28 13:42 | 2026-08-28 13:42 | 2026-08-28 13:42 | NTR | NTR261218C00080000 | call | 80.0000 | 2026-12-18 | 3.0200 | 2.8000 | 3.2000 | 73.8400 | 302000.00 | 302000.00 | 0.00 | 1000 | 6 | 1000 | 278 | 3.59712230215827 | 0.309335606905512 | 0.309335606905512 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 23955899394.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T17:47:47.104019Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 87e72740-400f-43e5-9f37-e87f9a2a0411 | 2026-08-27 14:40 | 2026-08-27 14:40 | 2026-08-27 14:40 | DOW | DOW260918C00032000 | call | 32.0000 | 2026-09-18 | 0.5400 | 0.4900 | 0.5500 | 30.4900 | 467640.00 | 467640.00 | 0.00 | 8660 | 2 | 10000 | 83 | 120.481927710843 | 0.364673695945326 | 0.364673695945326 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 20875646548.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T18:43:44.836810Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fe53ddd1-316b-47c4-a0cd-8f5ce11a6842 | 2026-08-26 12:09 | 2026-08-26 12:09 | 2026-08-26 12:09 | LYB | LYB261016P00060000 | put | 60.0000 | 2026-10-16 | 2.4000 | 2.3000 | 2.5500 | 62.6200 | 240000.00 | 0.00 | 240000.00 | 1000 | 2 | 1008 | 34 | 29.6470588235294 | 0.404448750017503 | 0.404448750017503 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 20270631488.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8c21bc0f-9c61-4a65-ac30-3f16b9bfc328 | 2026-08-21 12:43 | 2026-08-21 12:42 | 2026-08-21 12:42 | CDE | CDE261218C00022500 | call | 22.5000 | 2026-12-18 | 2.9900 | 2.9500 | 3.1000 | 21.4600 | 149500.00 | 0.00 | 149500.00 | 500 | 2 | 1641 | 4218 | 0.389046941678521 | 0.68076773184358 | 0.68076773184358 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 20435347760.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T16:43:46.028086Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a9dd9700-5a37-41ef-a16a-54a6326aaa7a | 2026-08-21 10:58 | 2026-08-21 10:58 | 2026-08-21 10:58 | AA | AA260904C00056000 | call | 56.0000 | 2026-09-04 | 0.8000 | 0.7100 | 0.9600 | 52.4150 | 80000.00 | 0.00 | 80000.00 | 1000 | 1 | 2022 | 2072 | 0.975868725868726 | 0.497469477813651 | 0.497469477813651 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:04:10.571442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 354ba52b-5826-4414-84ff-b1935ae77389 | 2026-08-20 15:56 | 2026-08-20 15:56 | 2026-08-20 15:56 | STLD | STLD260918C00240000 | call | 240.0000 | 2026-09-18 | 3.6000 | 2.8500 | 4.7000 | 219.2550 | 360000.00 | 0.00 | 360000.00 | 1000 | 2 | 1009 | 570 | 1.77017543859649 | 0.418701583991681 | 0.418701583991681 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 33614736479.00 | 2026-10-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e14f74cc-362d-47c8-9522-818829fb2ac1 | 2026-08-20 11:48 | 2026-08-20 11:48 | 2026-08-20 11:48 | DOW | DOW260821P00028000 | put | 28.0000 | 2026-08-21 | 0.0200 | 0.0000 | 0.3000 | 33.0150 | 8000.00 | 0.00 | 8000.00 | 4000 | 1 | 4000 | 4782 | 0.836470096194061 | 1.55981635983651 | 1.55981635983651 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 20875646548.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7cc44035-152b-4e56-b0d6-062fe6357683 | 2026-08-19 15:00 | 2026-08-19 15:00 | 2026-08-19 15:00 | AA | AA260821C00053000 | call | 53.0000 | 2026-08-21 | 0.3400 | 0.3000 | 0.3900 | 51.2300 | 34000.00 | 0.00 | 34000.00 | 1000 | 1 | 1067 | 690 | 1.5463768115942 | 0.635674226974657 | 0.635674226974657 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f68cc2aa-4d73-4b80-925a-bba86213468b | 2026-08-18 12:43 | 2026-08-18 12:43 | 2026-08-18 12:43 | NTR | NTR260821P00057500 | put | 57.5000 | 2026-08-21 | 0.0100 | 0.0000 | 0.1000 | 69.2700 | 7358.00 | 0.00 | 7358.00 | 7358 | 1 | 7358 | 9216 | 0.798394097222222 | 0.82859038090564 | 0.82859038090564 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Basic Materials | 23955899394.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 |