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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ef19f7fd-4f9e-4777-91c7-76e2b7d70a21 | 2026-09-08 11:07 | 2026-09-08 11:07 | 2026-09-08 11:07 | ISRG | ISRG261002P00355000 | put | 355.0000 | 2026-10-02 | 13.4000 | 13.3000 | 13.5000 | 351.6600 | 68329.00 | 33749.00 | 34580.00 | 51 | 12 | 53 | 10 | 5.3 | 0.338960637179 | 0.338960637179 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 133517901682.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 52204df4-f588-4785-a845-9234beaa0cec | 2026-09-08 11:00 | 2026-09-08 10:59 | 2026-09-08 10:59 | ISRG | ISRG260925C00355000 | call | 355.0000 | 2026-09-25 | 9.1000 | 7.8000 | 9.1000 | 350.5800 | 136492.00 | 136492.00 | 0.00 | 150 | 31 | 151 | 0 | 0 | 0.359004601928074 | 0.359004601928074 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 133517901682.00 | 2026-10-20 | unknown | — | 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 |
| bbd62fe9-7d91-4c4d-90a0-d2b5e8a5fd0c | 2026-09-08 10:46 | 2026-09-08 10:45 | 2026-09-08 10:45 | ISRG | ISRG270617C00400000 | call | 400.0000 | 2027-06-17 | 35.9800 | 34.4000 | 36.2000 | 353.4600 | 161901.00 | 122961.00 | 38940.00 | 45 | 5 | 47 | 132 | 0.356060606060606 | 0.398076210852649 | 0.391594960776995 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 133517901682.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:47:12.085652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8453edfc-830a-48dc-973b-4e2b9f83f8e6 | 2026-08-27 13:51 | 2026-08-27 13:51 | 2026-08-27 13:51 | ISRG | ISRG261016P00375000 | put | 375.0000 | 2026-10-16 | 20.4000 | 19.6000 | 20.6000 | 369.5700 | 193760.00 | 191750.00 | 2010.00 | 95 | 20 | 97 | 86 | 1.12790697674419 | 0.339601581844275 | 0.334103487937267 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 133517901682.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T18:14:24.609292Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8043cd4a-df81-4686-879d-b46c659b6f0e | 2026-08-21 11:04 | 2026-08-21 11:04 | 2026-08-21 11:04 | ISRG | ISRG260918C00390000 | call | 390.0000 | 2026-09-18 | 10.3800 | 9.9000 | 10.8000 | 380.6250 | 60230.00 | 47820.00 | 7210.00 | 58 | 10 | 69 | 252 | 0.273809523809524 | 0.332727390848611 | 0.332727390848611 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 133517901682.00 | 2026-10-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:19:43.785048Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |