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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dcaddc9b-2687-41ba-9d0d-b47c68553463 | 2026-09-14 13:31 | 2026-09-14 13:30 | 2026-09-14 13:30 | CBRS | CBRS281215P00155000 | put | 155.0000 | 2028-12-15 | 52.5000 | 51.4000 | 56.4000 | 182.1450 | 105000.00 | 0.00 | 105000.00 | 20 | 1 | 20 | 37 | 0.540540540540541 | 0.793434313392187 | 0.793434313392187 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 20340298622.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7dcd93b9-2e5a-46ed-b777-ed1e6f629d98 | 2026-08-21 13:50 | 2026-08-21 13:49 | 2026-08-21 13:49 | CBRS | CBRS261016P00200000 | put | 200.0000 | 2026-10-16 | 27.1000 | 26.9000 | 29.0000 | 199.7850 | 271000.00 | 0.00 | 271000.00 | 100 | 1 | 105 | 670 | 0.156716417910448 | 0.889679472442843 | 0.889679472442843 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 20340298622.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:03:10.492596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5a0ec26f-62dc-4d4e-bfc9-7bb7ad4dfa83 | 2026-08-21 11:53 | 2026-08-21 11:53 | 2026-08-21 11:53 | CBRS | CBRS260918P00185000 | put | 185.0000 | 2026-09-18 | 11.2700 | 10.8000 | 11.6000 | 201.1600 | 450800.00 | 450800.00 | 0.00 | 400 | 3 | 1019 | 332 | 3.06927710843373 | 0.867604734906949 | 0.867604734906949 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 20340298622.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2e85f8b0-3a03-4ac5-9f50-ce18599b34a4 | 2026-08-20 10:43 | 2026-08-20 10:43 | 2026-08-20 10:43 | CBRS | CBRS260918C00220000 | call | 220.0000 | 2026-09-18 | 18.2200 | 17.5000 | 18.8000 | 209.3400 | 273300.00 | 273300.00 | 0.00 | 150 | 2 | 299 | 687 | 0.435225618631732 | 0.952032311267409 | 0.952032311267409 | false | true | true | false | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 20340298622.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1d24a0c0-8704-411a-a094-dfe26d26b852 | 2026-08-19 10:38 | 2026-08-19 10:38 | 2026-08-19 10:38 | CBRS | CBRS260828C00202500 | call | 202.5000 | 2026-08-28 | 16.0400 | 15.1000 | 17.0000 | 208.5000 | 160400.00 | 0.00 | 160400.00 | 100 | 2 | 166 | 3 | 55.3333333333333 | 0.988552247793349 | 0.988552247793349 | false | true | true | false | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 20340298622.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:50:22.027850Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1c44a2d5-0228-44b3-acff-d05514c0746c | 2026-08-18 11:40 | 2026-08-18 11:40 | 2026-08-18 11:40 | CBRS | CBRS270617P00200000 | put | 200.0000 | 2027-06-17 | 55.7000 | 54.0000 | 57.5000 | 220.3000 | 835500.00 | 0.00 | 835500.00 | 150 | 1 | 151 | 129 | 1.17054263565891 | 0.936933428922133 | 0.936933428922133 | false | true | false | true | true | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 20340298622.00 | 2026-11-11 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a1d5f708-a999-484b-8dd8-0d38f95be036 | 2026-08-17 10:17 | 2026-08-17 10:17 | 2026-08-17 10:17 | CBRS | CBRS260918C00250000 | call | 250.0000 | 2026-09-18 | 31.0000 | 27.8000 | 32.1000 | 250.1200 | 155000.00 | 155000.00 | 0.00 | 50 | 1 | 247 | 525 | 0.47047619047619 | 1.03907810371952 | 1.03907810371952 | false | true | false | true | false | FloorTradeLargeCap | 85cc2f90-fef8-4e3c-8c5c-01d1ead51af1 | 1 | Common Stock | Technology | 20340298622.00 | 2026-11-11 | 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 |