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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ce671ca1-2f5c-4335-86c0-a4a6d4baaffb | 2026-09-18 11:39 | 2026-09-18 11:39 | 2026-09-18 11:39 | BMNR | BMNR261016P00025000 | put | 25.0000 | 2026-10-16 | 1.8300 | 1.7800 | 1.8300 | 25.5250 | 18300.00 | 18300.00 | 0.00 | 100 | 5 | 257 | 1770 | 0.145197740112994 | 0.760971889580617 | 0.760971889580617 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 15677853980.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| fbc75577-97b3-4458-a6b5-cf9db84e7b70 | 2026-09-11 15:23 | 2026-09-11 15:23 | 2026-09-11 15:23 | BMNR | BMNR261016P00025000 | put | 25.0000 | 2026-10-16 | 2.2700 | 2.2700 | 2.3400 | 25.2000 | 12031.00 | 0.00 | 12031.00 | 53 | 7 | 1231 | 1324 | 0.9297583081571 | 0.781078763486758 | 0.781078763486758 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 15539111909.00 | — | premarket | — | 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 |
| ff8043d2-2d53-43d9-9e6b-b3f7aa86eda4 | 2026-09-11 12:47 | 2026-09-11 12:47 | 2026-09-11 12:47 | BMNR | BMNR261016P00025000 | put | 25.0000 | 2026-10-16 | 2.1200 | 2.1000 | 2.1200 | 25.5800 | 15476.00 | 15476.00 | 0.00 | 73 | 5 | 1066 | 1324 | 0.805135951661631 | 0.784308607714034 | 0.784308607714034 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 15539111909.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 48b87a0e-37ad-4f83-b246-98ea74eb9b7c | 2026-09-11 10:22 | 2026-09-11 10:22 | 2026-09-11 10:22 | BMNR | BMNR261016P00025000 | put | 25.0000 | 2026-10-16 | 1.8800 | 1.8800 | 1.9800 | 26.3250 | 165440.00 | 0.00 | 165440.00 | 880 | 29 | 933 | 1324 | 0.704682779456193 | 0.799846582055872 | 0.799846582055872 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 15539111909.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 476d64bd-a84b-4f73-a343-c88dae8059c7 | 2026-09-10 10:40 | 2026-09-10 10:40 | 2026-09-10 10:40 | BMNR | BMNR261016P00025000 | put | 25.0000 | 2026-10-16 | 2.7200 | 2.7200 | 2.7500 | 24.3099 | 12512.00 | 0.00 | 12512.00 | 46 | 21 | 72 | 1274 | 0.0565149136577708 | 0.784286222119109 | 0.784286222119109 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 15539111909.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:57:03.898045Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8949e5c2-439e-479e-a3ba-5b9f528da99b | 2026-09-08 11:02 | 2026-09-08 11:02 | 2026-09-08 11:02 | BMNR | BMNR261016P00025000 | put | 25.0000 | 2026-10-16 | 2.5200 | 2.4900 | 2.5200 | 24.8450 | 49392.00 | 49392.00 | 0.00 | 196 | 33 | 772 | 1133 | 0.681376875551633 | 0.78075777457565 | 0.78075777457565 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 15539111909.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 27aad586-4333-4082-ba85-0a9fb3f2977f | 2026-08-27 11:31 | 2026-08-27 11:31 | 2026-08-27 11:31 | BMNR | BMNR261016P00025000 | put | 25.0000 | 2026-10-16 | 2.4600 | 2.4600 | 2.5200 | 26.0500 | 18942.00 | 0.00 | 18942.00 | 77 | 6 | 208 | 295 | 0.705084745762712 | 0.804639723590271 | 0.804639723590271 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 15539111909.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:44:11.413260Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 529fbbd8-3e06-40ab-88b4-9bfe91de157d | 2026-08-25 10:29 | 2026-08-25 10:29 | 2026-08-25 10:29 | BMNR | BMNR261016P00025000 | put | 25.0000 | 2026-10-16 | 3.0000 | 2.9600 | 3.0500 | 25.2650 | 30044.00 | 7320.00 | 22724.00 | 100 | 5 | 208 | 32 | 6.5 | 0.863881234762217 | 0.847755236828373 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Financial Services | 15539111909.00 | — | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |