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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ec88cf52-07be-445b-a8f9-c51d989edd97 | 2026-08-21 14:55 | 2026-08-21 14:55 | 2026-08-21 14:55 | TEX | TEX260918C00060000 | call | 60.0000 | 2026-09-18 | 7.8500 | 7.4000 | 8.1000 | 66.7050 | 3138000.00 | 3138000.00 | 0.00 | 4000 | 2 | 8000 | 2 | 4000 | 0.476989886286578 | 0.476989886286578 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Industrials | 6707124000.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dbed4cbc-67b4-441d-8330-4ca14bfc1b5e | 2026-08-21 14:55 | 2026-08-21 14:55 | 2026-08-21 14:55 | TEX | TEX260821C00060000 | call | 60.0000 | 2026-08-21 | 6.8200 | 5.1000 | 7.3000 | 66.7050 | 1705000.00 | 1705000.00 | 0.00 | 2500 | 1 | 5000 | 8058 | 0.620501365103003 | 6.17136770103665 | 6.17136770103665 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Industrials | 6707124000.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0e06268d-3973-4098-86ec-ed5aba52d5c7 | 2026-08-21 14:55 | 2026-08-21 14:55 | 2026-08-21 14:55 | TEX | TEX260918C00075000 | call | 75.0000 | 2026-09-18 | 0.7200 | 0.5500 | 1.0500 | 66.7050 | 288000.00 | 0.00 | 288000.00 | 4000 | 1 | 8000 | 16 | 500 | 0.422723947174154 | 0.422723947174154 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Industrials | 6707124000.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cd84636d-b72e-4f70-9bab-3e89e4b88094 | 2026-09-03 11:52 | 2026-09-03 11:52 | 2026-09-03 11:52 | FPS | FPS260918C00040000 | call | 40.0000 | 2026-09-18 | 0.2000 | 0.1000 | 0.3500 | 30.1600 | 39980.00 | 0.00 | 39980.00 | 1999 | 1 | 2040 | 4918 | 0.414802765351769 | 0.934498128814351 | 0.934498128814351 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Industrials | 7862455972.00 | 2026-09-15 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b6460d55-b1a8-4546-836d-8c50f98d1b77 | 2026-09-04 11:29 | 2026-09-04 11:29 | 2026-09-04 11:29 | AGCO | AGCO270219C00165000 | call | 165.0000 | 2027-02-19 | 3.4000 | 1.1500 | 3.4000 | 130.4350 | 306000.00 | 306000.00 | 0.00 | 900 | 4 | 900 | 2 | 450 | 0.352734640081914 | 0.352734640081914 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Industrials | 8564880457.00 | 2026-10-30 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:46:11.944585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f1f8bacd-4b90-4180-b4d4-dd3f66b52208 | 2026-09-09 15:06 | 2026-09-09 15:06 | 2026-09-09 15:06 | XE | XE261016P00017500 | put | 17.5000 | 2026-10-16 | 2.0000 | 1.9500 | 2.1000 | 17.2050 | 160000.00 | 0.00 | 160000.00 | 800 | 1 | 891 | 1815 | 0.490909090909091 | 0.859612791588565 | 0.859612791588565 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Industrials | 4495854600.00 | 2026-11-12 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7b5e8bd0-b06f-4605-992a-3a7d9770222a | 2026-09-14 10:40 | 2026-09-14 10:40 | 2026-09-14 10:40 | AAL | AAL270319P00009000 | put | 9.0000 | 2027-03-19 | 0.3300 | 0.2800 | 0.3700 | 12.9701 | 72600.00 | 72600.00 | 0.00 | 2200 | 1 | 2200 | 98 | 22.4489795918367 | 0.536868150690223 | 0.536868150690223 | false | true | false | true | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Industrials | 8671806358.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:43:33.165845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 88fd08a7-cc61-4c10-83b0-474c4e993f13 | 2026-09-15 09:57 | 2026-09-15 09:57 | 2026-09-15 09:57 | FPS | FPS260918C00035000 | call | 35.0000 | 2026-09-18 | 0.8500 | 0.9000 | 1.0000 | 32.9250 | 85000.00 | 0.00 | 85000.00 | 1000 | 2 | 6216 | 10804 | 0.575342465753425 | 1.37293681044933 | 1.37293681044933 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 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 |
| d1958178-1f52-46a2-b2a1-05e81c03d6b9 | 2026-09-17 14:39 | 2026-09-17 14:39 | 2026-09-17 14:39 | RRX | RRX260918P00170000 | put | 170.0000 | 2026-09-18 | 21.3600 | 19.2000 | 21.7000 | 149.3450 | 747600.00 | 747600.00 | 0.00 | 350 | 1 | 354 | 126 | 2.80952380952381 | 1.90342320397528 | 1.90342320397528 | false | true | true | false | true | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Industrials | 9851600804.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| a6e8ac9e-f13c-4259-9fa4-7108c457ebf1 | 2026-09-17 15:16 | 2026-09-17 15:16 | 2026-09-17 15:16 | FPS | FPS261120C00040000 | call | 40.0000 | 2026-11-20 | 3.8100 | 3.6000 | 3.9000 | 37.3000 | 249936.00 | 249936.00 | 0.00 | 656 | 2 | 3253 | 1940 | 1.67680412371134 | 0.76869125567103 | 0.76869125567103 | false | true | true | false | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 2 | Common Stock | Industrials | 10448501198.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T19:28:01.580099Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| d0a5b07e-fcce-4545-a6e7-11c806f9abdb | 2026-09-18 11:14 | 2026-09-18 11:14 | 2026-09-18 11:14 | AAL | AAL280121P00008000 | put | 8.0000 | 2028-01-21 | 0.6700 | 0.6100 | 0.6900 | 12.9489 | 154100.00 | 154100.00 | 0.00 | 2300 | 1 | 2305 | 6193 | 0.372194413046989 | 0.548181521339149 | 0.548181521339149 | false | true | false | true | false | FloorTradeMidCap | d9769fb4-003b-49e4-9181-c78c9cc101f5 | 1 | Common Stock | Industrials | 8579130565.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |