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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 856e1771-c7ad-4eab-8d08-59e452327d92 | 2026-09-16 11:32 | 2026-09-16 11:32 | 2026-09-16 11:32 | MOS | MOS261002C00027000 | call | 27.0000 | 2026-10-02 | 0.4500 | 0.1500 | 0.4500 | 25.1250 | 22396.00 | 22396.00 | 0.00 | 500 | 17 | 503 | 2033 | 0.247417609444171 | 0.526154765973256 | 0.500949840083752 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7880633064.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| a0857196-49aa-4f18-b658-47fafb458faa | 2026-09-09 13:01 | 2026-09-09 13:01 | 2026-09-09 13:01 | MOS | MOS280121C00050000 | call | 50.0000 | 2028-01-21 | 1.5200 | 1.3500 | 1.6000 | 26.0000 | 14136.00 | 14136.00 | 0.00 | 93 | 8 | 150 | 4616 | 0.0324956672443674 | 0.477847857591984 | 0.477847857591984 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e9502337-525e-4092-90b7-0b93b730b186 | 2026-09-08 12:23 | 2026-09-08 12:23 | 2026-09-08 12:23 | MOS | MOS261218C00026000 | call | 26.0000 | 2026-12-18 | 2.7700 | 2.7500 | 2.8500 | 26.2400 | 11068.00 | 0.00 | 11068.00 | 40 | 7 | 256 | 3524 | 0.0726447219069239 | 0.459374123151532 | 0.459374123151532 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T16:42:24.738421Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e2e81fe2-8372-44eb-9aff-aeb62d9332d1 | 2026-09-04 12:47 | 2026-09-04 12:47 | 2026-09-04 12:47 | MOS | MOS270115C00030000 | call | 30.0000 | 2027-01-15 | 1.5700 | 1.5500 | 1.6500 | 25.9250 | 766321.00 | 0.00 | 766321.00 | 4881 | 7 | 5021 | 20425 | 0.245826193390453 | 0.462392990401099 | 0.462392990401099 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| de743db2-b8e2-4533-8755-824b8f966a13 | 2026-09-04 10:51 | 2026-09-04 10:51 | 2026-09-04 10:51 | MOS | MOS261016C00025000 | call | 25.0000 | 2026-10-16 | 1.7500 | 1.7500 | 1.8000 | 25.4850 | 25729.00 | 0.00 | 25729.00 | 147 | 8 | 737 | 7996 | 0.0921710855427714 | 0.426359099081319 | 0.420394977034705 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| de3b17ab-17fa-4cca-bfa4-d2aa3e140056 | 2026-09-01 12:17 | 2026-09-01 12:17 | 2026-09-01 12:17 | MOS | MOS270115C00030000 | call | 30.0000 | 2027-01-15 | 1.3000 | 1.3000 | 1.3500 | 24.9750 | 15770.00 | 0.00 | 15770.00 | 121 | 5 | 639 | 19693 | 0.0324480779972579 | 0.467266471942381 | 0.467266471942381 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T16:27:11.873526Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fed0a23d-4518-482a-835a-b5a3eb811cc0 | 2026-08-31 10:58 | 2026-08-31 10:58 | 2026-08-31 10:58 | MOS | MOS270319C00030000 | call | 30.0000 | 2027-03-19 | 1.5400 | 1.5000 | 1.7500 | 24.0900 | 38554.00 | 0.00 | 38554.00 | 250 | 5 | 267 | 4344 | 0.0614640883977901 | 0.456807614872113 | 0.456807614872113 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T15:07:09.972110Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 460058bd-2230-4a01-b630-14c671646055 | 2026-08-31 10:21 | 2026-08-31 10:21 | 2026-08-31 10:21 | MOS | MOS260904C00025000 | call | 25.0000 | 2026-09-04 | 0.2500 | 0.2500 | 0.3500 | 24.3310 | 24102.00 | 0.00 | 24102.00 | 963 | 5 | 1215 | 850 | 1.42941176470588 | 0.509694670448437 | 0.498654095692189 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | 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 |
| a5c91459-a0f5-4c02-87e8-69f5a6c9b27b | 2026-08-26 11:56 | 2026-08-26 11:56 | 2026-08-26 11:56 | MOS | MOS261016C00025000 | call | 25.0000 | 2026-10-16 | 1.4500 | 1.3500 | 1.9500 | 24.4700 | 307562.00 | 293062.00 | 14500.00 | 2122 | 70 | 2247 | 5435 | 0.41343146274149 | 0.457770441505452 | 0.446972946965342 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | 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 |
| b8fc746c-ea89-453b-80bb-812061480b41 | 2026-08-24 14:52 | 2026-08-24 14:52 | 2026-08-24 14:52 | MOS | MOS280121C00025000 | call | 25.0000 | 2028-01-21 | 5.1000 | 4.9000 | 5.2000 | 23.8550 | 50950.00 | 35650.00 | 15300.00 | 100 | 6 | 251 | 13089 | 0.0191764076705631 | 0.445429124899457 | 0.44450685116847 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | 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 |
| 00050e30-8537-4531-a61a-295ea000bda0 | 2026-08-24 10:39 | 2026-08-24 10:39 | 2026-08-24 10:39 | MOS | MOS261218C00027500 | call | 27.5000 | 2026-12-18 | 1.6600 | 1.6500 | 1.7000 | 24.9000 | 10768.00 | 840.00 | 9928.00 | 65 | 6 | 248 | 2638 | 0.0940106141015921 | 0.455738992252602 | 0.450259339024508 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bf8ace94-4478-4936-b612-e5a91c0b9aa4 | 2026-08-21 12:54 | 2026-08-21 12:54 | 2026-08-21 12:54 | MOS | MOS261016C00030000 | call | 30.0000 | 2026-10-16 | 0.3500 | 0.3000 | 0.3500 | 24.6750 | 16298.00 | 16298.00 | 0.00 | 466 | 37 | 888 | 0 | 0 | 0.453471504427257 | 0.452785989074867 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4660adf1-e56a-4e2f-8869-c3ae6cb96002 | 2026-08-17 13:41 | 2026-08-17 13:41 | 2026-08-17 13:41 | MOS | MOS280121C00030000 | call | 30.0000 | 2028-01-21 | 2.2000 | 2.2000 | 2.3500 | 20.9100 | 13641.00 | 0.00 | 13641.00 | 62 | 5 | 875 | 5164 | 0.169442292796282 | 0.439566591678155 | 0.438514377254074 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9288e73a-01dc-45fa-9af3-80680dc011d5 | 2026-08-17 10:38 | 2026-08-17 10:38 | 2026-08-17 10:38 | MOS | MOS280121C00035000 | call | 35.0000 | 2028-01-21 | 1.6600 | 1.5500 | 1.7000 | 20.9918 | 54581.00 | 9761.00 | 44820.00 | 329 | 10 | 460 | 1425 | 0.32280701754386 | 0.462451030956047 | 0.461233575379206 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 7963285932.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:42:42.502476Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |