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
active:option_symbol = MSTR260925C00167500×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9bd483ec-ffb1-4282-97fc-c2cfe9109073 | 2026-09-18 15:58 | 2026-09-18 15:58 | 2026-09-18 15:58 | MSTR | MSTR260925C00167500 | call | 167.5000 | 2026-09-25 | 2.1400 | 2.1200 | 2.1500 | 153.0000 | 13071.00 | 13071.00 | 0.00 | 61 | 6 | 6086 | 412 | 14.7718446601942 | 0.776483343520731 | 0.774952509287412 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 56117000314.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 71b6d671-f422-4f96-9b49-25ffd575f812 | 2026-09-18 15:54 | 2026-09-18 15:53 | 2026-09-18 15:53 | MSTR | MSTR260925C00167500 | call | 167.5000 | 2026-09-25 | 2.1100 | 2.0700 | 2.1100 | 153.0000 | 42169.00 | 42169.00 | 0.00 | 200 | 17 | 5902 | 412 | 14.3252427184466 | 0.783889690486807 | 0.784245604000297 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 56117000314.00 | 2026-10-29 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a40df978-4c4c-41e9-afb7-eba4d21d673c | 2026-09-18 15:39 | 2026-09-18 15:39 | 2026-09-18 15:39 | MSTR | MSTR260925C00167500 | call | 167.5000 | 2026-09-25 | 1.8900 | 1.8900 | 1.9200 | 152.7350 | 37611.00 | 0.00 | 37611.00 | 199 | 8 | 5295 | 412 | 12.8519417475728 | 0.777229812028875 | 0.777229812028875 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 56117000314.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:51:24.020322Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 0d0bd895-2b7d-41b1-86c7-02f2c81a01e5 | 2026-09-18 15:21 | 2026-09-18 15:21 | 2026-09-18 15:21 | MSTR | MSTR260925C00167500 | call | 167.5000 | 2026-09-25 | 2.0700 | 2.0400 | 2.0700 | 153.5900 | 19044.00 | 19044.00 | 0.00 | 92 | 6 | 3518 | 412 | 8.53883495145631 | 0.775899032710105 | 0.775899032710105 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 56117000314.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:37:13.545792Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| e64c8961-5927-4e09-9b56-8a94e0f1a2bc | 2026-09-18 15:20 | 2026-09-18 15:20 | 2026-09-18 15:20 | MSTR | MSTR260925C00167500 | call | 167.5000 | 2026-09-25 | 2.0700 | 2.0500 | 2.1000 | 153.5550 | 50508.00 | 43470.00 | 7038.00 | 244 | 7 | 3291 | 412 | 7.9878640776699 | 0.778026441908643 | 0.777140113985242 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 56117000314.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 6794e34b-175e-4750-aea6-569c549c5ce4 | 2026-09-18 15:20 | 2026-09-18 15:20 | 2026-09-18 15:20 | MSTR | MSTR260925C00167500 | call | 167.5000 | 2026-09-25 | 2.0500 | 2.0200 | 2.0700 | 153.4300 | 40795.00 | 23165.00 | 0.00 | 199 | 5 | 3012 | 412 | 7.31067961165049 | 0.778441897896733 | 0.778441897896733 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 56117000314.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 9f4f0969-046b-409d-a09f-db700fdfc1f8 | 2026-09-18 15:19 | 2026-09-18 15:19 | 2026-09-18 15:19 | MSTR | MSTR260925C00167500 | call | 167.5000 | 2026-09-25 | 2.0400 | 2.0100 | 2.0400 | 153.3900 | 13056.00 | 13056.00 | 0.00 | 64 | 9 | 2403 | 412 | 5.83252427184466 | 0.778287349550655 | 0.778287349550655 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 56117000314.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 1f12e5ed-11a4-4cc8-a452-16a324572a04 | 2026-09-18 14:47 | 2026-09-18 14:47 | 2026-09-18 14:47 | MSTR | MSTR260925C00167500 | call | 167.5000 | 2026-09-25 | 1.6400 | 1.5800 | 1.6400 | 151.8200 | 54120.00 | 54120.00 | 0.00 | 330 | 43 | 1969 | 412 | 4.77912621359223 | 0.766451908137211 | 0.766451908137211 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 56117000314.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 77fbbcc9-9ea1-4427-a3a7-a5333cb3b335 | 2026-09-18 13:25 | 2026-09-18 13:25 | 2026-09-18 13:25 | MSTR | MSTR260925C00167500 | call | 167.5000 | 2026-09-25 | 1.4900 | 1.4300 | 1.5000 | 150.3300 | 17432.00 | 14900.00 | 297.00 | 117 | 14 | 735 | 412 | 1.78398058252427 | 0.788920941282515 | 0.788920941282515 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 56117000314.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:36:08.685771Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |