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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37acc6ad-d186-484f-8ac1-4e0fdc94f124 | 2026-09-18 13:58 | 2026-09-18 13:57 | 2026-09-18 13:57 | UMAC | UMAC261016C00030000 | call | 30.0000 | 2026-10-16 | 0.7000 | 0.6000 | 0.7000 | 23.0300 | 52468.00 | 52468.00 | 0.00 | 750 | 50 | 973 | 2263 | 0.429960229783473 | 1.01646375236754 | 1.01646375236754 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1157991786.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 801bb11d-b8d0-46e1-883d-09540c27dbf6 | 2026-09-09 11:06 | 2026-09-09 11:06 | 2026-09-09 11:06 | UMAC | UMAC260918P00025000 | put | 25.0000 | 2026-09-18 | 1.6500 | 1.6500 | 1.9000 | 24.9150 | 27237.00 | 0.00 | 27237.00 | 165 | 6 | 366 | 1624 | 0.225369458128079 | 1.05003436593742 | 1.0371916834453 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1132014403.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:13:56.572588Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 34b097a1-2e94-4385-834f-ea8c66f28421 | 2026-09-02 13:01 | 2026-09-02 13:01 | 2026-09-02 13:01 | UMAC | UMAC260918C00023500 | call | 23.5000 | 2026-09-18 | 1.6000 | 1.6000 | 1.7500 | 22.8350 | 23850.00 | 0.00 | 23850.00 | 149 | 10 | 175 | 44 | 3.97727272727273 | 0.987823173389006 | 0.982578193799012 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1132014403.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ff5f003c-127a-498c-ba96-533791295047 | 2026-08-28 15:21 | 2026-08-28 15:21 | 2026-08-28 15:21 | UMAC | UMAC261016C00022500 | call | 22.5000 | 2026-10-16 | 4.3900 | 4.2000 | 4.4000 | 23.8100 | 10542.00 | 10542.00 | 0.00 | 24 | 5 | 71 | 69 | 1.02898550724638 | 1.08660406436584 | 1.05907693505274 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1132014403.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T19:36:54.231390Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f4836f30-5027-4a01-a90a-c957b5a69ac1 | 2026-08-28 12:53 | 2026-08-28 12:52 | 2026-08-28 12:52 | UMAC | UMAC280121C00020000 | call | 20.0000 | 2028-01-21 | 12.5600 | 12.0000 | 13.0000 | 23.2250 | 15076.00 | 15076.00 | 0.00 | 12 | 10 | 22 | 610 | 0.0360655737704918 | 1.11180995342053 | 1.11180995342053 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1132014403.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b568b163-42ca-492b-895f-2617f13a21e3 | 2026-08-26 14:18 | 2026-08-26 14:17 | 2026-08-26 14:17 | UMAC | UMAC270115P00025000 | put | 25.0000 | 2027-01-15 | 6.9900 | 6.8000 | 7.1000 | 23.7250 | 157352.00 | 104852.00 | 52500.00 | 225 | 5 | 252 | 603 | 0.417910447761194 | 1.10875793172377 | 1.1062440539395 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1132014403.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 46e583ea-b60b-4056-942a-a63437287e77 | 2026-08-18 10:01 | 2026-08-18 10:01 | 2026-08-18 10:01 | UMAC | UMAC260828P00037000 | put | 37.0000 | 2026-08-28 | 5.6000 | 5.2000 | 5.6000 | 33.0000 | 179187.00 | 179187.00 | 0.00 | 320 | 46 | 320 | 0 | 0 | 1.40792357893013 | 1.40792357893013 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1132014403.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:02:16.040235Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6f546b2b-4ff8-456a-81df-c1036ec70877 | 2026-08-17 11:07 | 2026-08-17 11:07 | 2026-08-17 11:07 | UMAC | UMAC261120C00050000 | call | 50.0000 | 2026-11-20 | 3.9100 | 3.8000 | 4.9000 | 31.5505 | 26560.00 | 0.00 | 26560.00 | 68 | 8 | 68 | 0 | 0 | 1.33909515822401 | 1.32268421201032 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Industrials | 1132014403.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |