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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0c3bf80d-8326-4f6f-8b41-334cedc7e014 | 2026-08-24 12:11 | 2026-08-24 12:10 | 2026-08-24 12:10 | FPS | FPS260918C00037500 | call | 37.5000 | 2026-09-18 | 1.6400 | 1.5000 | 1.7000 | 32.5100 | 16400.00 | 16400.00 | 0.00 | 100 | 5 | 662 | 876 | 0.755707762557078 | 0.981045995731007 | 0.981045995731007 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 7862455972.00 | 2026-09-15 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 980530ba-93e1-46d1-b6bc-7d0816a8557d | 2026-09-02 14:08 | 2026-09-02 14:08 | 2026-09-02 14:08 | FPS | FPS260918C00037500 | call | 37.5000 | 2026-09-18 | 0.3500 | 0.3000 | 0.3500 | 28.9450 | 15040.00 | 15040.00 | 0.00 | 430 | 25 | 459 | 1501 | 0.305796135909394 | 0.989744726836808 | 0.989744726836808 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 7862455972.00 | 2026-09-15 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T18:39:55.300995Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6255e908-6683-4ea7-9ede-475a34716c8a | 2026-09-15 09:57 | 2026-09-15 09:57 | 2026-09-15 09:57 | FPS | FPS260918C00037500 | call | 37.5000 | 2026-09-18 | 0.4300 | 0.4000 | 0.4500 | 32.7450 | 10782.00 | 10782.00 | 0.00 | 250 | 5 | 593 | 2477 | 0.239402503027856 | 1.55053827267839 | 1.53792178009224 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 7862455972.00 | 2026-09-15 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 91ed605b-9943-403f-8a02-dff08733c371 | 2026-09-16 11:57 | 2026-09-16 11:57 | 2026-09-16 11:57 | FPS | FPS260918C00037500 | call | 37.5000 | 2026-09-18 | 0.3600 | 0.3500 | 0.4000 | 35.0800 | 10704.00 | 0.00 | 10704.00 | 300 | 16 | 1399 | 2802 | 0.499286224125625 | 1.10713903328429 | 1.1200776841234 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 9564523955.00 | — | 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 |
| 8d047f85-199b-4f49-859e-f787729ee80c | 2026-09-17 09:36 | 2026-09-17 09:36 | 2026-09-17 09:36 | FPS | FPS260918C00037500 | call | 37.5000 | 2026-09-18 | 0.6900 | 0.4000 | 0.7000 | 37.0000 | 11442.00 | 11442.00 | 0.00 | 165 | 14 | 433 | 4063 | 0.106571498892444 | 1.15595068413654 | 1.19194990945882 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 10448501198.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 9bdf435a-87a6-4c5e-bb30-d9584e6d9e3d | 2026-09-18 09:55 | 2026-09-18 09:55 | 2026-09-18 09:55 | FPS | FPS260918C00037500 | call | 37.5000 | 2026-09-18 | 1.2000 | 1.0500 | 1.5000 | 38.5900 | 12025.00 | 0.00 | 12025.00 | 100 | 5 | 334 | 3382 | 0.0987581312832643 | 1.19904907196263 | 1.19904907196263 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 10827348587.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 6d867900-38c6-4228-ab6e-ae29a7446110 | 2026-09-18 09:55 | 2026-09-18 09:55 | 2026-09-18 09:55 | FPS | FPS260918C00037500 | call | 37.5000 | 2026-09-18 | 1.2000 | 1.0500 | 1.5000 | 38.5900 | 11999.00 | 0.00 | 11999.00 | 100 | 5 | 434 | 3382 | 0.128326434062685 | 1.16116642518391 | 1.19946224360148 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 10827348587.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 056351fe-70c6-4ca6-98e3-13bd1cddfbc5 | 2026-09-18 09:57 | 2026-09-18 09:57 | 2026-09-18 09:57 | FPS | FPS260918C00037500 | call | 37.5000 | 2026-09-18 | 1.0500 | 1.0000 | 1.2500 | 38.4900 | 15819.00 | 0.00 | 15819.00 | 150 | 5 | 986 | 3382 | 0.291543465405086 | 0.978125147471246 | 0.978125147471246 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 10827348587.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a0703936-76d2-4c99-85a7-8bc6ce0e8f48 | 2026-09-18 10:22 | 2026-09-18 10:22 | 2026-09-18 10:22 | FPS | FPS260918C00037500 | call | 37.5000 | 2026-09-18 | 1.5000 | 1.3500 | 1.5000 | 38.8250 | 12000.00 | 12000.00 | 0.00 | 80 | 7 | 1178 | 3382 | 0.348314606741573 | 1.62234475219743 | 1.62234475219743 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 10827348587.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 392d3ff8-5fcf-4499-819b-6ecd44019e02 | 2026-09-18 10:22 | 2026-09-18 10:22 | 2026-09-18 10:22 | FPS | FPS260918C00037500 | call | 37.5000 | 2026-09-18 | 1.4900 | 1.3500 | 1.5000 | 38.8550 | 13580.00 | 13580.00 | 0.00 | 91 | 10 | 1287 | 3382 | 0.380544056771141 | 1.24443756342954 | 1.52891602098801 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Industrials | 10827348587.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:32:18.430939Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 1bcaaff8-d639-44f8-93ab-197c67f6bf57 | 2026-09-18 14:34 | 2026-09-18 14:34 | 2026-09-18 14:34 | FPS | FPS260918C00037500 | call | 37.5000 | 2026-09-18 | 1.7500 | 1.6000 | 1.9500 | 39.2550 | 30450.00 | 3500.00 | 26950.00 | 174 | 5 | 2514 | 3382 | 0.74334713187463 | 1.09888353030806 | 3.97738659730914 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Industrials | 10827348587.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |