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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ce6b2000-04b9-4e84-8c2b-b17161bc17ed | 2026-08-17 09:52 | 2026-08-17 09:52 | 2026-08-17 09:52 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 1.0600 | 1.0500 | 1.1200 | 95.8100 | 10610.00 | 0.00 | 10610.00 | 100 | 5 | 1044 | 8269 | 0.126254686177289 | 0.784221357917032 | 0.790667275421292 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:54:20.333138Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 66e46855-de51-445e-ac47-97246fb6d504 | 2026-08-17 10:00 | 2026-08-17 10:00 | 2026-08-17 10:00 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 0.9500 | 0.9100 | 0.9800 | 95.1300 | 19000.00 | 6270.00 | 12730.00 | 200 | 11 | 1478 | 8269 | 0.178739871810376 | 0.802202051576751 | 0.802202051576751 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T14:09:25.911404Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 42ca8f58-d903-4e53-af58-4e072618daad | 2026-08-17 11:07 | 2026-08-17 11:07 | 2026-08-17 11:07 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 1.4500 | 1.4500 | 1.5400 | 97.4700 | 45240.00 | 0.00 | 45240.00 | 312 | 23 | 2978 | 8269 | 0.360140282984641 | 0.767806823550644 | 0.770355356182905 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aa579896-099f-4af7-8e15-999da833120b | 2026-08-18 14:15 | 2026-08-18 14:14 | 2026-08-18 14:14 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 0.5000 | 0.4600 | 0.5000 | 94.2600 | 10000.00 | 10000.00 | 0.00 | 200 | 12 | 4201 | 9143 | 0.459477195668818 | 0.798194453374808 | 0.798194453374808 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T18:16:58.911276Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 10caf11f-3b6a-4b21-b386-75e731e12077 | 2026-08-19 10:41 | 2026-08-19 10:41 | 2026-08-19 10:41 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 1.8500 | 1.7700 | 1.8500 | 100.0243 | 33670.00 | 33670.00 | 0.00 | 182 | 38 | 1544 | 9479 | 0.162886380419876 | 0.917017903046851 | 0.910831391961805 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | 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 |
| 759a4c08-25dd-492d-be1b-0f44d516a7fa | 2026-08-19 11:03 | 2026-08-19 11:03 | 2026-08-19 11:03 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 3.2500 | 3.2500 | 3.5000 | 102.7350 | 15600.00 | 0.00 | 15600.00 | 48 | 10 | 2654 | 9479 | 0.279987340436755 | 0.945053190094836 | 0.945053190094836 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 21679bac-cb92-481c-aa75-5144ded6cc26 | 2026-08-19 11:10 | 2026-08-19 11:10 | 2026-08-19 11:10 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 3.0500 | 3.0500 | 3.1500 | 102.3500 | 93940.00 | 0.00 | 93940.00 | 308 | 12 | 3179 | 9479 | 0.335372929633928 | 0.948351825050842 | 0.948351825050842 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8ae7bd09-a962-40f4-b870-a1f41141aa02 | 2026-08-19 11:26 | 2026-08-19 11:26 | 2026-08-19 11:26 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 3.9000 | 3.6500 | 3.9500 | 103.8300 | 13260.00 | 12870.00 | 390.00 | 34 | 7 | 3731 | 9479 | 0.393606920561241 | 0.956371060016276 | 0.948031538800861 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:33:41.628321Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f2e10273-e95b-474e-8584-9374073802a0 | 2026-08-20 09:41 | 2026-08-20 09:41 | 2026-08-20 09:41 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 9.5000 | 8.4000 | 9.6500 | 111.1950 | 16150.00 | 16150.00 | 0.00 | 17 | 5 | 106 | 9355 | 0.0113308391234634 | 1.24037286494761 | 1.24037286494761 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:45:25.718532Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 87de97b0-314f-47cd-8043-767875b17760 | 2026-08-20 12:18 | 2026-08-20 12:18 | 2026-08-20 12:18 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 9.7000 | 9.1500 | 9.7000 | 111.4300 | 32980.00 | 32980.00 | 0.00 | 34 | 8 | 788 | 9355 | 0.084233030464992 | 1.22271838516933 | 1.22271838516933 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2e9800da-6fcf-4231-a958-c72a0ca5d8a8 | 2026-08-21 12:45 | 2026-08-21 12:45 | 2026-08-21 12:45 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 17.6000 | 17.6000 | 17.8000 | 119.6000 | 33440.00 | 0.00 | 33440.00 | 19 | 7 | 929 | 9155 | 0.101474604041507 | 4.91144857693511 | 4.91144857693511 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T17:09:02.511847Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 22f5d9cf-fa40-46c3-8faa-6210411664b5 | 2026-08-21 15:30 | 2026-08-21 15:29 | 2026-08-21 15:29 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 17.1500 | 17.0000 | 17.7500 | 119.1350 | 36009.00 | 0.00 | 36009.00 | 21 | 6 | 2309 | 9155 | 0.252211906062261 | 7.35786127930759 | 7.35786127930759 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0f0dc577-3af8-4778-b2da-b36a62dccf62 | 2026-08-21 15:36 | 2026-08-21 15:36 | 2026-08-21 15:36 | MSTR | MSTR260821C00102000 | call | 102.0000 | 2026-08-21 | 16.9700 | 16.9000 | 17.2500 | 118.9400 | 20358.00 | 0.00 | 20358.00 | 12 | 7 | 2326 | 9155 | 0.25406881485527 | 9.61001181767477 | 9.61001181767477 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 49926338507.00 | 2026-10-29 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |