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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00b14d19-cc19-46e4-be58-63733bdba781 | 2026-09-18 11:25 | 2026-09-18 11:25 | 2026-09-18 11:25 | MRVL | MRVL261009C00250000 | call | 250.0000 | 2026-10-09 | 10.3100 | 9.9500 | 10.9000 | 238.2500 | 52590.00 | 13450.00 | 39140.00 | 51 | 25 | 181 | 2181 | 0.0829894543787254 | 0.654441465198344 | 0.656685243805645 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 214182825000.00 | 2026-12-01 | unknown | — | 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 |
| 19218fd3-8a4e-42c4-a68a-1257182beb3e | 2026-09-17 09:43 | 2026-09-17 09:43 | 2026-09-17 09:43 | MRVL | MRVL261009C00250000 | call | 250.0000 | 2026-10-09 | 15.0000 | 14.4000 | 15.0000 | 244.5000 | 106500.00 | 106500.00 | 0.00 | 71 | 7 | 149 | 2079 | 0.0716690716690717 | 0.717929501448138 | 0.717929501448138 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 211122444000.00 | 2026-12-01 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 5ea9faeb-f5cb-40c2-8fe2-354f02c22fd6 | 2026-09-17 09:35 | 2026-09-17 09:35 | 2026-09-17 09:35 | MRVL | MRVL261009C00250000 | call | 250.0000 | 2026-10-09 | 15.3500 | 15.0500 | 15.3500 | 244.6000 | 93615.00 | 92085.00 | 1530.00 | 61 | 15 | 72 | 2079 | 0.0346320346320346 | 0.727961432871441 | 0.728406085274571 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 211122444000.00 | 2026-12-01 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| e3768eb0-4206-4a59-8c28-404156c89952 | 2026-09-11 09:57 | 2026-09-11 09:57 | 2026-09-11 09:57 | MRVL | MRVL261009C00250000 | call | 250.0000 | 2026-10-09 | 11.2000 | 11.2000 | 11.6000 | 233.0000 | 50400.00 | 0.00 | 50400.00 | 45 | 6 | 194 | 1025 | 0.189268292682927 | 0.672761753513345 | 0.672761753513345 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 191883258000.00 | 2026-12-01 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 75823c90-e319-4d66-bd2c-62d65494dba5 | 2026-09-11 09:57 | 2026-09-11 09:57 | 2026-09-11 09:57 | MRVL | MRVL261009C00250000 | call | 250.0000 | 2026-10-09 | 11.4800 | 10.8500 | 11.6500 | 233.0000 | 90695.00 | 6865.00 | 83830.00 | 79 | 6 | 147 | 1025 | 0.143414634146341 | 0.681606889838131 | 0.673631825279977 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 191883258000.00 | 2026-12-01 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:59:42.234161Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ce1368e0-0cb8-4d2e-b114-25888100bece | 2026-09-09 09:55 | 2026-09-09 09:55 | 2026-09-09 09:55 | MRVL | MRVL261009C00250000 | call | 250.0000 | 2026-10-09 | 16.0000 | 15.7000 | 16.4500 | 239.8500 | 313608.00 | 75200.00 | 238408.00 | 196 | 12 | 447 | 958 | 0.466597077244259 | 0.728731968055662 | 0.728731968055662 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 191883258000.00 | 2026-12-01 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2ebe5d40-e02b-489d-8e98-6b218afd0c0f | 2026-09-09 09:36 | 2026-09-09 09:36 | 2026-09-09 09:36 | MRVL | MRVL261009C00250000 | call | 250.0000 | 2026-10-09 | 12.2200 | 11.6500 | 12.3000 | 231.9248 | 244389.00 | 244389.00 | 0.00 | 200 | 31 | 213 | 958 | 0.222338204592902 | 0.721321581193646 | 0.713304955495943 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 191883258000.00 | 2026-12-01 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:46:31.810255Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |