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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ca05287c-8a86-4744-a467-e9ef0d067b54 | 2026-09-18 13:23 | 2026-09-18 13:22 | 2026-09-18 13:22 | HMY | HMY261016C00020000 | call | 20.0000 | 2026-10-16 | 0.9000 | 0.9000 | 1.0000 | 19.8600 | 17370.00 | 0.00 | 17370.00 | 193 | 32 | 1023 | 532 | 1.92293233082707 | 0.42732731344984 | 0.42732731344984 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 12644573062.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 2a75ac6c-d1d5-400e-9201-ff7a9ce9a8ce | 2026-09-16 13:44 | 2026-09-16 13:44 | 2026-09-16 13:44 | CX | CX280121C00015000 | call | 15.0000 | 2028-01-21 | 0.7500 | 0.6500 | 0.8000 | 10.0000 | 40950.00 | 4125.00 | 36825.00 | 546 | 8 | 3883 | 3401 | 1.1417230226404 | 0.383794108861602 | 0.38416529151105 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 14739548108.00 | 2026-10-26 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T18:03:30.942669Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| f966f283-bc1c-4b24-8d2e-9751d65abccb | 2026-09-16 13:40 | 2026-09-16 13:40 | 2026-09-16 13:40 | CX | CX280121C00015000 | call | 15.0000 | 2028-01-21 | 0.7500 | 0.6500 | 0.8000 | 10.2950 | 17775.00 | 14475.00 | 3300.00 | 237 | 5 | 3301 | 3401 | 0.970596883269627 | 0.383423060077955 | 0.383423060077955 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 14739548108.00 | 2026-10-26 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 5dde26ce-9fd2-47b1-b129-296553ec74b0 | 2026-09-16 13:40 | 2026-09-16 13:40 | 2026-09-16 13:40 | CX | CX280121C00015000 | call | 15.0000 | 2028-01-21 | 0.7500 | 0.6500 | 0.8000 | 10.2950 | 17475.00 | 14700.00 | 2775.00 | 233 | 6 | 3064 | 3401 | 0.900911496618642 | 0.383423060077955 | 0.383423060077955 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 14739548108.00 | 2026-10-26 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 221353e7-7f21-45b9-bed2-9cbec22a678d | 2026-09-16 13:40 | 2026-09-16 13:40 | 2026-09-16 13:40 | CX | CX280121C00015000 | call | 15.0000 | 2028-01-21 | 0.7500 | 0.6500 | 0.8000 | 10.3000 | 65550.00 | 50175.00 | 15375.00 | 874 | 16 | 2831 | 3401 | 0.832402234636871 | 0.383423060077955 | 0.383052144880218 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 14739548108.00 | 2026-10-26 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| ee1c13c4-ffcb-44f9-86aa-6b6af04703de | 2026-09-16 13:39 | 2026-09-16 13:38 | 2026-09-16 13:38 | CX | CX280121C00015000 | call | 15.0000 | 2028-01-21 | 0.7500 | 0.6500 | 0.8000 | 10.2800 | 14925.00 | 12825.00 | 2100.00 | 199 | 7 | 902 | 3401 | 0.265216112907968 | 0.384536608306297 | 0.384536608306297 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 14739548108.00 | 2026-10-26 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 5b13783f-9d99-4feb-b244-931d3a2f9eba | 2026-09-16 13:38 | 2026-09-16 13:38 | 2026-09-16 13:38 | CX | CX280121C00015000 | call | 15.0000 | 2028-01-21 | 0.7500 | 0.6500 | 0.7500 | 10.2700 | 30000.00 | 30000.00 | 0.00 | 400 | 9 | 668 | 3401 | 0.196412819758894 | 0.386023222549092 | 0.385279645454731 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 14739548108.00 | 2026-10-26 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| f17c6922-82b8-4ec2-8700-82aa3d840861 | 2026-09-16 12:02 | 2026-09-16 12:02 | 2026-09-16 12:02 | CX | CX280121C00015000 | call | 15.0000 | 2028-01-21 | 0.7500 | 0.6500 | 0.8000 | 10.2800 | 12600.00 | 12525.00 | 0.00 | 168 | 22 | 168 | 3401 | 0.0493972361070273 | 0.384536608306297 | 0.384536608306297 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 14739548108.00 | 2026-10-26 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 7e132ff5-16a3-4577-86ce-b7e7d55b510f | 2026-09-10 11:32 | 2026-09-10 11:32 | 2026-09-10 11:32 | CX | CX261016C00012000 | call | 12.0000 | 2026-10-16 | 0.1500 | 0.1500 | 0.2000 | 10.6450 | 15000.00 | 0.00 | 1500.00 | 1000 | 5 | 1000 | 151 | 6.62251655629139 | 0.414682424525014 | 0.414682424525014 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 15160263556.00 | 2026-10-26 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:47:40.219521Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4158edca-5405-4952-9fbf-da47311132f9 | 2026-08-28 12:32 | 2026-08-28 12:32 | 2026-08-28 12:32 | CX | CX270115C00011000 | call | 11.0000 | 2027-01-15 | 1.0500 | 0.8000 | 1.0500 | 10.7704 | 20998.00 | 20998.00 | 0.00 | 200 | 24 | 200 | 288 | 0.694444444444444 | 0.406456221554867 | 0.406456221554867 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 15160263556.00 | 2026-10-26 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T16:48:38.038469Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bc48b150-2d0f-4f6f-bd80-25950c9d7fc5 | 2026-08-27 13:17 | 2026-08-27 13:17 | 2026-08-27 13:17 | SXT | SXT260918C00135000 | call | 135.0000 | 2026-09-18 | 3.5000 | 2.9000 | 3.5000 | 134.1050 | 15400.00 | 15400.00 | 0.00 | 44 | 5 | 50 | 54 | 0.925925925925926 | 0.28766489345093 | 0.28766489345093 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 5386323732.00 | 2026-10-30 | premarket | — | 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 |
| 66dfb91d-c834-49ce-9392-23f8345d0797 | 2026-08-25 15:08 | 2026-08-25 15:08 | 2026-08-25 15:08 | HMY | HMY260918C00024000 | call | 24.0000 | 2026-09-18 | 1.0500 | 1.0000 | 1.0500 | 22.9400 | 10500.00 | 10500.00 | 0.00 | 100 | 5 | 110 | 1529 | 0.0719424460431655 | 0.625174311694449 | 0.625174311694449 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 12460490422.00 | — | premarket | — | 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 |
| 013cebe3-fa24-40fc-b187-20906707de17 | 2026-08-25 12:13 | 2026-08-25 12:13 | 2026-08-25 12:13 | HMY | HMY261120P00017000 | put | 17.0000 | 2026-11-20 | 0.4000 | 0.4000 | 0.4500 | 22.8300 | 13200.00 | 0.00 | 13200.00 | 330 | 16 | 505 | 1262 | 0.400158478605388 | 0.580694429001437 | 0.580694429001437 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 12460490422.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:29:52.792110Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4aead362-c84c-475e-bc2a-1e1cc68c1092 | 2026-08-21 13:22 | 2026-08-21 13:22 | 2026-08-21 13:22 | HMY | HMY260821C00021000 | call | 21.0000 | 2026-08-21 | 2.5000 | 2.4500 | 2.7000 | 23.5200 | 25000.00 | 0.00 | 25000.00 | 100 | 8 | 400 | 1387 | 0.288392213410238 | 5.55071475905021 | 6.21003239643064 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 12460490422.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T17:35:06.376767Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c552e2fd-71b7-4361-a339-3f76fae12889 | 2026-08-21 12:55 | 2026-08-21 12:55 | 2026-08-21 12:55 | HMY | HMY280121P00025000 | put | 25.0000 | 2028-01-21 | 6.7000 | 6.2000 | 7.8000 | 23.5850 | 124620.00 | 109210.00 | 15410.00 | 186 | 14 | 212 | 788 | 0.269035532994924 | 0.612688641332704 | 0.612688641332704 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 12460490422.00 | — | premarket | — | 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 |
| 90a6fe45-af95-4472-8a17-e1a9b4d02681 | 2026-08-20 14:37 | 2026-08-20 14:37 | 2026-08-20 14:37 | HMY | HMY270319C00030000 | call | 30.0000 | 2027-03-19 | 1.5000 | 1.1500 | 1.6500 | 21.7990 | 15000.00 | 1800.00 | 13200.00 | 100 | 6 | 400 | 0 | 0 | 0.554987574190074 | 0.554987574190074 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 12460490422.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cb45c65a-33a9-4ce4-b050-f6e54906f10d | 2026-08-20 14:36 | 2026-08-20 14:36 | 2026-08-20 14:36 | HMY | HMY270319C00030000 | call | 30.0000 | 2027-03-19 | 1.6000 | 1.1500 | 1.6000 | 21.8050 | 16000.00 | 16000.00 | 0.00 | 100 | 6 | 300 | 0 | 0 | 0.571611330510136 | 0.571611330510136 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 12460490422.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7da935c0-1baa-47e2-847c-ab484432d913 | 2026-08-20 11:53 | 2026-08-20 11:53 | 2026-08-20 11:53 | HMY | HMY260918C00024000 | call | 24.0000 | 2026-09-18 | 0.6500 | 0.6000 | 0.7000 | 21.7650 | 21905.00 | 520.00 | 21385.00 | 337 | 19 | 483 | 3 | 161 | 0.580329546181332 | 0.580329546181332 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 12460490422.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 55d32d1d-fe39-406c-9e3d-01bf8d310bc7 | 2026-08-20 10:28 | 2026-08-20 10:27 | 2026-08-20 10:27 | HMY | HMY260821C00019000 | call | 19.0000 | 2026-08-21 | 2.4000 | 2.4000 | 2.9000 | 21.4100 | 12000.00 | 0.00 | 12000.00 | 50 | 9 | 142 | 1018 | 0.139489194499018 | 3.25305080514859 | 3.25305080514859 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 12460490422.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bae2b4e5-9c85-4316-8aee-11576e9dd335 | 2026-08-18 11:05 | 2026-08-18 11:05 | 2026-08-18 11:05 | HMY | HMY260821C00018000 | call | 18.0000 | 2026-08-21 | 1.5500 | 1.1500 | 1.5500 | 19.4727 | 18600.00 | 18600.00 | 0.00 | 120 | 9 | 120 | 997 | 0.120361083249749 | 0.733631373559612 | 0.733631373559612 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | ADR | Basic Materials | 12460490422.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |