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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90e56126-04c3-4e17-ae1a-ae2adcfe9f39 | 2026-09-18 15:50 | 2026-09-18 15:50 | 2026-09-18 15:50 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 15.0500 | 15.0000 | 15.4500 | 98.4500 | 230260.00 | 0.00 | 230260.00 | 153 | 28 | 281 | 6807 | 0.0412810342294697 | 0.949992707682669 | 0.946880974269598 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 12170639870.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 14c560b4-f2ff-43ec-881b-b844a3c646a8 | 2026-09-18 15:50 | 2026-09-18 15:50 | 2026-09-18 15:50 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 15.1500 | 14.7500 | 15.1500 | 98.4700 | 19695.00 | 19695.00 | 0.00 | 13 | 7 | 40 | 6807 | 0.00587630380490671 | 0.955507209267385 | 0.955507209267385 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 12170639870.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| f322762c-9bef-4e18-b540-af61bc3e67d7 | 2026-09-16 14:10 | 2026-09-16 14:10 | 2026-09-16 14:10 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 12.6000 | 12.4000 | 13.0000 | 93.2750 | 90720.00 | 36540.00 | 54180.00 | 72 | 6 | 413 | 5236 | 0.0788770053475936 | 0.957725046440501 | 0.957725046440501 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 11071165416.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T18:26:46.257544Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 13cf9b6d-f598-4edb-b17d-24037f12fa36 | 2026-09-16 14:06 | 2026-09-16 14:06 | 2026-09-16 14:06 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 12.8000 | 11.8000 | 13.0500 | 93.5000 | 75500.00 | 74230.00 | 1270.00 | 59 | 8 | 297 | 5236 | 0.0567226890756303 | 0.96665661042942 | 0.963001499015742 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 11071165416.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T18:26:46.257544Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 459d7091-a335-4a18-9bba-153f84d83c27 | 2026-09-16 14:00 | 2026-09-16 14:00 | 2026-09-16 14:00 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 12.6000 | 10.6500 | 13.2000 | 92.0000 | 112140.00 | 112140.00 | 0.00 | 89 | 5 | 210 | 5236 | 0.0401069518716578 | 0.971127030704117 | 0.971127030704117 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 11071165416.00 | 2026-11-03 | unknown | 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 |
| 81de1bef-cf64-450e-b202-061c8780025d | 2026-09-16 11:28 | 2026-09-16 11:28 | 2026-09-16 11:28 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 13.0000 | 13.0000 | 13.2500 | 93.6700 | 102700.00 | 0.00 | 102700.00 | 79 | 8 | 100 | 5236 | 0.0190985485103132 | 0.970057824840683 | 0.970057824840683 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 11071165416.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 |
| 052390ca-ed82-40a1-907f-a8bba5e8367c | 2026-09-15 10:37 | 2026-09-15 10:37 | 2026-09-15 10:37 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 10.6500 | 10.3000 | 10.9500 | 88.5800 | 62835.00 | 38340.00 | 24495.00 | 59 | 8 | 493 | 4749 | 0.103811328700779 | 0.974807025295673 | 0.974807025295673 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 11232635319.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 83e8bc48-ddf7-4e5d-9da5-584ac9efb69a | 2026-09-15 10:37 | 2026-09-15 10:37 | 2026-09-15 10:37 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 10.6500 | 10.6500 | 10.9500 | 88.6700 | 38340.00 | 0.00 | 38340.00 | 36 | 6 | 431 | 4749 | 0.0907559486207623 | 0.971967072924872 | 0.971967072924872 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 11232635319.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:53:20.680156Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 66715fa8-be3a-45a7-b374-ad114dab3332 | 2026-09-15 10:36 | 2026-09-15 10:36 | 2026-09-15 10:36 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 10.6500 | 10.6500 | 11.1500 | 88.7300 | 47925.00 | 0.00 | 47925.00 | 45 | 13 | 296 | 4749 | 0.0623289113497578 | 0.970074085757974 | 0.970074085757974 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 11232635319.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:36:37.058930Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 1cd13d26-0388-4c9d-bedf-29f7de541e5f | 2026-09-15 10:15 | 2026-09-15 10:15 | 2026-09-15 10:15 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 10.7000 | 10.4000 | 11.0500 | 88.6350 | 161570.00 | 21400.00 | 77040.00 | 151 | 9 | 251 | 4749 | 0.052853232259423 | 0.976403944626649 | 0.976403944626649 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 11232635319.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 8eb2a631-f2a4-4f48-8636-6f1d35294b32 | 2026-09-15 10:15 | 2026-09-15 10:15 | 2026-09-15 10:15 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 10.6500 | 10.0000 | 12.0000 | 88.6350 | 106495.00 | 80935.00 | 25560.00 | 100 | 16 | 100 | 4749 | 0.0210570646451885 | 0.973071430737989 | 0.969738550956732 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 11232635319.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 5b125a44-eb19-436c-8a08-4b3d86bd3b8b | 2026-08-21 10:50 | 2026-08-21 10:50 | 2026-08-21 10:50 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 9.7800 | 8.8500 | 9.8000 | 79.3301 | 11735.00 | 9795.00 | 1940.00 | 12 | 8 | 16 | 4337 | 0.00368918607332257 | 1.01977665274982 | 1.02620699945584 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 11232635319.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:50:41.871179Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fc77ad5b-dd54-45a4-8467-b53aa4547d7c | 2026-08-20 13:49 | 2026-08-20 13:48 | 2026-08-20 13:48 | HUT | HUT261120C00100000 | call | 100.0000 | 2026-11-20 | 13.1700 | 13.1000 | 13.5500 | 87.4568 | 47400.00 | 17155.00 | 30245.00 | 36 | 5 | 57 | 4174 | 0.0136559655007187 | 0.994491978705413 | 0.994491978705413 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 11232635319.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T18:14:08.178572Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |