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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f2159a5e-2c3b-48a7-97b5-9e122d0f619f | 2026-08-17 10:23 | 2026-08-17 10:22 | 2026-08-17 10:22 | HST | HST270115P00022280 | put | 22.2800 | 2027-01-15 | 1.4000 | 1.1000 | 1.7500 | 22.5950 | 224000.00 | 0.00 | 224000.00 | 1600 | 2 | 1601 | 744 | 2.15188172043011 | 0.301122540763459 | 0.301122540763459 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Real Estate | 15322807184.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:25:15.386684Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 878c12d7-1337-405e-b473-b3e2e53847e5 | 2026-08-20 11:40 | 2026-08-20 11:40 | 2026-08-20 11:40 | AGNC | AGNC260911P00010500 | put | 10.5000 | 2026-09-11 | 0.1000 | 0.0700 | 0.1000 | 10.9200 | 50000.00 | 50000.00 | 0.00 | 5000 | 1 | 5001 | 9402 | 0.531908104658583 | 0.252829546308195 | 0.252829546308195 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Real Estate | 11961507800.00 | 2026-10-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:52:12.298393Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8d6894a0-2cea-437b-a4b9-5e8224f20b57 | 2026-08-24 11:25 | 2026-08-24 11:25 | 2026-08-24 11:25 | VICI | VICI261016P00025000 | put | 25.0000 | 2026-10-16 | 0.2000 | 0.2000 | 0.2500 | 26.7750 | 28000.00 | 0.00 | 28000.00 | 1400 | 1 | 1412 | 52 | 27.1538461538462 | 0.21097140047517 | 0.21097140047517 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Real Estate | 27570982152.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:29:12.492303Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a1f8ff55-be93-4b02-978a-3ea6fefe6acf | 2026-08-24 15:21 | 2026-08-24 15:21 | 2026-08-24 15:21 | BEKE | BEKE260918C00021000 | call | 21.0000 | 2026-09-18 | 0.0500 | 0.0000 | 0.0500 | 17.8550 | 18750.00 | 18750.00 | 0.00 | 3750 | 1 | 3751 | 8008 | 0.468406593406593 | 0.390228362485177 | 0.390228362485177 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | ADR | Real Estate | 18001535976.00 | 2026-11-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T19:23:59.728896Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cc119f73-e0b6-41c3-ad31-57a17afcd1e2 | 2026-09-01 15:48 | 2026-09-01 15:48 | 2026-09-01 15:48 | EXR | EXR261016P00130000 | put | 130.0000 | 2026-10-16 | 1.2500 | 1.1000 | 1.5500 | 139.2300 | 214375.00 | 0.00 | 214375.00 | 1715 | 2 | 1715 | 5 | 343 | 0.244059334081018 | 0.244059334081018 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Real Estate | 29450976385.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T13:31:29.863287Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ad76836e-6c30-4d07-ad67-6438037c3b9d | 2026-09-11 15:04 | 2026-09-11 15:04 | 2026-09-11 15:04 | AGNC | AGNC261030C00010500 | call | 10.5000 | 2026-10-30 | 0.1700 | 0.1300 | 0.1900 | 10.1962 | 170000.00 | 170000.00 | 0.00 | 10000 | 1 | 10093 | 1 | 10093 | 0.184183909275494 | 0.184183909275494 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Real Estate | 11961507800.00 | 2026-10-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3ce8729d-202d-437a-94fc-743a27286d09 | 2026-09-16 10:16 | 2026-09-16 10:16 | 2026-09-16 10:16 | BXP | BXP260918P00067500 | put | 67.5000 | 2026-09-18 | 3.3000 | 2.7000 | 4.4000 | 63.0000 | 132000.00 | 0.00 | 132000.00 | 400 | 2 | 400 | 453 | 0.883002207505519 | 1.09342079583141 | 1.09342079583141 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 2 | Common Stock | Real Estate | 10224726046.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 05f6040c-8089-4912-b736-e6f6a2f0bb23 | 2026-09-16 13:37 | 2026-09-16 13:37 | 2026-09-16 13:37 | AGNC | AGNC260918C00010000 | call | 10.0000 | 2026-09-18 | 0.0800 | 0.0600 | 0.1000 | 9.9600 | 40000.00 | 0.00 | 0.00 | 5000 | 1 | 5691 | 1123 | 5.06767586821015 | 0.331748648234941 | 0.331748648234941 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Real Estate | 11712556696.00 | 2026-10-19 | unknown | — | 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 |