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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86de1238-7467-4dce-b930-31217263e956 | 2026-09-18 14:22 | 2026-09-18 14:22 | 2026-09-18 14:22 | STM | STM261002P00050000 | put | 50.0000 | 2026-10-02 | 2.1000 | 1.9000 | 2.1000 | 49.5550 | 16554.00 | 16554.00 | 0.00 | 79 | 15 | 144 | 63 | 2.28571428571429 | 0.491637653366388 | 0.491637653366388 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 44598385867.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 86b9e074-bc62-47d7-b14e-e1c3f745e423 | 2026-09-17 12:04 | 2026-09-17 12:04 | 2026-09-17 12:04 | STM | STM261002P00049000 | put | 49.0000 | 2026-10-02 | 2.0500 | 2.0500 | 2.1500 | 48.6600 | 51665.00 | 0.00 | 51665.00 | 252 | 15 | 261 | 45 | 5.8 | 0.498735684805033 | 0.486030192438462 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 43203019869.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T16:22:15.429007Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| c70b9848-0517-4902-9045-4306b4ae8605 | 2026-09-16 15:44 | 2026-09-16 15:44 | 2026-09-16 15:44 | STM | STM260918C00047500 | call | 47.5000 | 2026-09-18 | 1.0000 | 0.9000 | 1.0000 | 47.7600 | 19900.00 | 19900.00 | 0.00 | 200 | 9 | 562 | 1 | 562 | 0.61020422111291 | 0.603035099546669 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42714197385.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| bdfdaa5c-6156-42e0-bf0a-2622e4248b22 | 2026-09-16 12:12 | 2026-09-16 12:12 | 2026-09-16 12:12 | STM | STM270115C00055000 | call | 55.0000 | 2027-01-15 | 4.1300 | 4.1000 | 4.3000 | 49.0900 | 12387.00 | 0.00 | 12387.00 | 30 | 5 | 370 | 3408 | 0.108568075117371 | 0.540997123342406 | 0.540997123342406 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42714197385.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 8a58261d-c5a2-4240-9e0c-a1ef9e8a2a2b | 2026-09-10 10:36 | 2026-09-10 10:36 | 2026-09-10 10:36 | STM | STM261016P00047000 | put | 47.0000 | 2026-10-16 | 1.7100 | 1.7000 | 1.8500 | 50.4700 | 17073.00 | 0.00 | 17073.00 | 100 | 7 | 109 | 440 | 0.247727272727273 | 0.528900244941992 | 0.525250233556094 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ae29b4a7-c017-4850-854b-6c1ab97354c8 | 2026-09-10 10:32 | 2026-09-10 10:32 | 2026-09-10 10:32 | STM | STM270115P00042000 | put | 42.0000 | 2027-01-15 | 2.5600 | 2.5000 | 2.6000 | 50.4700 | 49145.00 | 17524.00 | 31621.00 | 192 | 36 | 292 | 152 | 1.92105263157895 | 0.566010032144963 | 0.561638261071454 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 082c4c15-0d02-45fa-be44-f79360e6eaff | 2026-09-10 10:30 | 2026-09-10 10:30 | 2026-09-10 10:30 | STM | STM270115P00042000 | put | 42.0000 | 2027-01-15 | 2.6100 | 2.6000 | 2.7000 | 50.3700 | 26075.00 | 0.00 | 26075.00 | 100 | 7 | 100 | 152 | 0.657894736842105 | 0.568096573522405 | 0.564736731532289 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:36:53.026568Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f1c9ecf5-ed50-4b20-b610-6a53e1931edf | 2026-09-09 10:13 | 2026-09-09 10:12 | 2026-09-09 10:12 | STM | STM260918C00055000 | call | 55.0000 | 2026-09-18 | 0.9500 | 0.8000 | 1.0000 | 52.1000 | 55216.00 | 55216.00 | 0.00 | 582 | 18 | 617 | 4986 | 0.123746490172483 | 0.617703680981905 | 0.617703680981905 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:24:00.331334Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| adf5905c-9dec-4eb0-8e15-6bbf3c7ce685 | 2026-09-09 09:58 | 2026-09-09 09:58 | 2026-09-09 09:58 | STM | STM261016C00060000 | call | 60.0000 | 2026-10-16 | 1.2000 | 1.0000 | 1.2500 | 51.9600 | 59602.00 | 59602.00 | 0.00 | 497 | 57 | 518 | 3033 | 0.170787998681174 | 0.555816092421587 | 0.555348481078682 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:11:22.686371Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0bef7a42-89a6-4a0e-bfa6-19b6fff477bb | 2026-09-08 15:00 | 2026-09-08 15:00 | 2026-09-08 15:00 | STM | STM260911C00054000 | call | 54.0000 | 2026-09-11 | 0.6000 | 0.5000 | 0.6500 | 52.0700 | 41660.00 | 28220.00 | 7620.00 | 695 | 159 | 11502 | 104 | 110.596153846154 | 0.706433164648692 | 0.701899095115654 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T19:03:39.512328Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9bdb3f3f-7c46-4140-9905-11a8f99335e8 | 2026-09-08 11:20 | 2026-09-08 11:20 | 2026-09-08 11:20 | STM | STM261016C00060000 | call | 60.0000 | 2026-10-16 | 1.2000 | 1.1500 | 1.2000 | 52.1900 | 89157.00 | 89157.00 | 0.00 | 743 | 57 | 811 | 2385 | 0.340041928721174 | 0.53716697976587 | 0.53716697976587 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ea6858a6-0184-47c5-9123-aa2f1844f7d7 | 2026-09-08 09:50 | 2026-09-08 09:50 | 2026-09-08 09:50 | STM | STM261016P00055000 | put | 55.0000 | 2026-10-16 | 4.9100 | 4.4000 | 5.2000 | 52.3500 | 49056.00 | 49056.00 | 0.00 | 100 | 12 | 100 | 3556 | 0.0281214848143982 | 0.520873549831701 | 0.520873549831701 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T14:00:31.869599Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1b9c56f3-88b4-41f4-aad7-d427f99cae08 | 2026-09-04 14:25 | 2026-09-04 14:25 | 2026-09-04 14:25 | STM | STM270416C00060000 | call | 60.0000 | 2027-04-16 | 6.5300 | 6.5000 | 6.7000 | 52.2350 | 13068.00 | 0.00 | 13068.00 | 20 | 6 | 45 | 531 | 0.0847457627118644 | 0.544551277501742 | 0.544551277501742 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d360e9c4-83ea-4e1a-b393-37e89e535ab8 | 2026-09-04 14:19 | 2026-09-04 14:19 | 2026-09-04 14:19 | STM | STM270115P00055000 | put | 55.0000 | 2027-01-15 | 8.1000 | 8.1000 | 8.3000 | 52.2350 | 40524.00 | 0.00 | 40524.00 | 50 | 6 | 111 | 2518 | 0.0440826052422558 | 0.554742382345674 | 0.554742382345674 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1e610363-aef2-4ba4-9b71-2a57d48e4964 | 2026-09-04 14:17 | 2026-09-04 14:17 | 2026-09-04 14:17 | STM | STM270115C00055000 | call | 55.0000 | 2027-01-15 | 6.0000 | 6.0000 | 6.2000 | 52.2000 | 55242.00 | 0.00 | 55242.00 | 92 | 10 | 258 | 3151 | 0.0818787686448746 | 0.547359463864998 | 0.545766456836911 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T18:34:11.376593Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8644ae0d-249d-4927-bb47-ae190e706d14 | 2026-09-04 10:00 | 2026-09-04 10:00 | 2026-09-04 10:00 | STM | STM280121P00055000 | put | 55.0000 | 2028-01-21 | 12.9500 | 12.8000 | 13.4000 | 52.4450 | 12946.00 | 0.00 | 12946.00 | 10 | 5 | 40 | 1691 | 0.0236546422235364 | 0.554355447678695 | 0.550040884170875 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ea9da0d2-9de9-42ea-a6bb-edbf6cee6570 | 2026-09-03 09:54 | 2026-09-03 09:54 | 2026-09-03 09:54 | STM | STM280121P00055000 | put | 55.0000 | 2028-01-21 | 13.8200 | 13.6000 | 14.2000 | 50.3700 | 142305.00 | 1380.00 | 140925.00 | 103 | 25 | 148 | 1524 | 0.0971128608923885 | 0.544581791900663 | 0.540116588642197 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T13:54:48.730813Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 05b3ce49-a3b8-449e-9cde-aaa58d0c556d | 2026-09-02 10:37 | 2026-09-02 10:37 | 2026-09-02 10:37 | STM | STM270115C00065000 | call | 65.0000 | 2027-01-15 | 2.6500 | 2.6500 | 2.7500 | 50.7700 | 53074.00 | 0.00 | 53074.00 | 200 | 31 | 241 | 2088 | 0.115421455938697 | 0.545389824499642 | 0.54257703826862 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c9b252ef-ea52-46f9-a5fb-0b24afe5aacc | 2026-09-02 10:28 | 2026-09-02 10:28 | 2026-09-02 10:28 | STM | STM270115P00047000 | put | 47.0000 | 2027-01-15 | 4.5100 | 4.5000 | 4.6000 | 50.7100 | 14875.00 | 0.00 | 14875.00 | 33 | 9 | 118 | 5980 | 0.0197324414715719 | 0.552996525316668 | 0.552101860651181 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 75b63644-540c-44e8-95b6-2ac121ad0512 | 2026-09-02 09:40 | 2026-09-02 09:40 | 2026-09-02 09:40 | STM | STM260918C00055000 | call | 55.0000 | 2026-09-18 | 0.6500 | 0.5000 | 0.6500 | 50.3800 | 34858.00 | 34858.00 | 0.00 | 537 | 26 | 828 | 3037 | 0.272637471188673 | 0.507632849589257 | 0.507632849589257 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T13:42:51.501101Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8603c368-0a74-46f6-a843-19aa95a25da0 | 2026-08-27 13:52 | 2026-08-27 13:52 | 2026-08-27 13:52 | STM | STM270416P00045000 | put | 45.0000 | 2027-04-16 | 5.4000 | 5.4000 | 6.2000 | 51.1900 | 130759.00 | 0.00 | 130759.00 | 242 | 20 | 251 | 18 | 13.9444444444444 | 0.575821315826159 | 0.572937396984059 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | 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 |
| 20e71e6d-6ffd-4817-8979-8216d1583b22 | 2026-08-27 13:30 | 2026-08-27 13:30 | 2026-08-27 13:30 | STM | STM270115P00047000 | put | 47.0000 | 2027-01-15 | 4.6100 | 4.6000 | 4.8000 | 51.2600 | 230401.00 | 0.00 | 230401.00 | 500 | 14 | 507 | 5472 | 0.0926535087719298 | 0.57072794242625 | 0.565467424439882 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:46:53.178792Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2bf1970a-8633-4075-b730-8252a6d70f31 | 2026-08-17 15:31 | 2026-08-17 15:30 | 2026-08-17 15:30 | STM | STM260918C00065000 | call | 65.0000 | 2026-09-18 | 1.1500 | 1.0500 | 1.1500 | 56.1400 | 36664.00 | 36664.00 | 0.00 | 319 | 48 | 1695 | 1780 | 0.952247191011236 | 0.575582841869623 | 0.576034457021267 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | ADR | Technology | 42465342303.00 | 2026-10-29 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |