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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5e5bc7ec-be3e-45b3-94ce-969b55891fd7 | 2026-08-14 15:55 | 2026-08-14 15:55 | 2026-08-14 15:55 | OSCR | OSCR260814C00030500 | call | 30.5000 | 2026-08-14 | 2.2800 | 2.1500 | 2.5900 | 32.7500 | 15986.00 | 0.00 | 15986.00 | 70 | 5 | 231 | 482 | 0.479253112033195 | 14.8264054142155 | 14.8264054142155 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T13:32:33.788843Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3e6195b9-6fa8-4ca8-a786-4434d128a69f | 2026-08-18 12:50 | 2026-08-18 12:50 | 2026-08-18 12:50 | OSCR | OSCR261016C00031000 | call | 31.0000 | 2026-10-16 | 3.7500 | 3.6000 | 3.7500 | 31.7500 | 14235.00 | 13495.00 | 740.00 | 38 | 20 | 38 | 528 | 0.071969696969697 | 0.641165803435368 | 0.651284951860672 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 69f7fdfa-781d-40bb-beaf-2a552410b14d | 2026-08-19 15:00 | 2026-08-19 15:00 | 2026-08-19 15:00 | OSCR | OSCR270521C00030000 | call | 30.0000 | 2027-05-21 | 8.9200 | 8.6000 | 9.0000 | 31.8200 | 89164.00 | 89164.00 | 0.00 | 100 | 9 | 102 | 60 | 1.7 | 0.71886125975416 | 0.71886125975416 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6f50cb73-6e5d-4eee-8a73-0958bd89112b | 2026-08-20 11:30 | 2026-08-20 11:30 | 2026-08-20 11:30 | OSCR | OSCR260918C00035000 | call | 35.0000 | 2026-09-18 | 1.7000 | 1.6600 | 1.7200 | 32.6899 | 45347.00 | 35317.00 | 10030.00 | 266 | 17 | 8067 | 6153 | 1.31106777181862 | 0.701584024415943 | 0.706558793136392 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6afa5ce5-77ba-4a08-b14c-0dd40017eb90 | 2026-08-20 11:30 | 2026-08-20 11:30 | 2026-08-20 11:30 | OSCR | OSCR260918C00035000 | call | 35.0000 | 2026-09-18 | 1.7300 | 1.6800 | 1.7600 | 32.7400 | 73872.00 | 66976.00 | 5146.00 | 426 | 22 | 8888 | 6153 | 1.44449861856005 | 0.706547352851172 | 0.709173694064074 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 62a453e4-f3d2-4707-92e4-c86ea9e63b56 | 2026-08-20 13:16 | 2026-08-20 13:16 | 2026-08-20 13:16 | OSCR | OSCR260918C00035000 | call | 35.0000 | 2026-09-18 | 1.7500 | 1.7500 | 1.8200 | 32.8850 | 10679.00 | 704.00 | 9975.00 | 61 | 20 | 15319 | 6153 | 2.48967983097676 | 0.692461199515666 | 0.692461199515666 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3b419230-86d5-4d40-a36c-609bbd77870b | 2026-08-20 15:17 | 2026-08-20 15:16 | 2026-08-20 15:16 | OSCR | OSCR260918C00035000 | call | 35.0000 | 2026-09-18 | 1.2600 | 1.2400 | 1.3800 | 31.7100 | 17303.00 | 0.00 | 17303.00 | 137 | 21 | 19940 | 6153 | 3.2406955956444 | 0.674017509544559 | 0.680189862751562 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a1773dd6-8532-4e68-8dbe-b1059dd44e6a | 2026-08-20 15:26 | 2026-08-20 15:25 | 2026-08-20 15:25 | OSCR | OSCR260918C00035000 | call | 35.0000 | 2026-09-18 | 1.1100 | 1.0900 | 1.1200 | 31.3950 | 15437.00 | 15437.00 | 0.00 | 139 | 9 | 23413 | 6153 | 3.8051357061596 | 0.66289184180443 | 0.669216020188575 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8ed45607-c813-4462-9484-7f780978e29b | 2026-08-24 10:55 | 2026-08-24 10:55 | 2026-08-24 10:55 | OSCR | OSCR270115C00035000 | call | 35.0000 | 2027-01-15 | 5.1000 | 4.9500 | 5.2000 | 32.7700 | 25484.00 | 25484.00 | 0.00 | 50 | 5 | 157 | 26178 | 0.00599740239896096 | 0.705862540658397 | 0.705862540658397 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b47e1a52-b04f-4749-a41e-8a9d81098b8e | 2026-08-25 11:37 | 2026-08-25 11:37 | 2026-08-25 11:37 | OSCR | OSCR260911C00032000 | call | 32.0000 | 2026-09-11 | 1.2500 | 1.2000 | 1.3100 | 30.8900 | 11337.00 | 5292.00 | 6045.00 | 91 | 5 | 286 | 164 | 1.74390243902439 | 0.630975641628231 | 0.642430630976554 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 51f72ebc-ba46-432e-bf48-a6e2c5e27aee | 2026-09-01 15:35 | 2026-09-01 15:35 | 2026-09-01 15:35 | OSCR | OSCR260918C00034000 | call | 34.0000 | 2026-09-18 | 0.4300 | 0.3500 | 0.6500 | 29.3400 | 34671.00 | 33897.00 | 774.00 | 807 | 55 | 908 | 1660 | 0.546987951807229 | 0.70181791691405 | 0.70906290592564 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 17d6b343-ef4f-4ee0-bea2-aee3f729daeb | 2026-09-01 15:35 | 2026-09-01 15:35 | 2026-09-01 15:35 | OSCR | OSCR260918C00034000 | call | 34.0000 | 2026-09-18 | 0.4500 | 0.3500 | 0.4700 | 29.3600 | 369785.00 | 369745.00 | 40.00 | 8205 | 6 | 9113 | 1660 | 5.48975903614458 | 0.683307480422606 | 0.683307480422606 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T19:44:53.190071Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cfd7a233-6049-4e4d-bdf5-869aa1dc1194 | 2026-09-01 15:51 | 2026-09-01 15:51 | 2026-09-01 15:51 | OSCR | OSCR261016C00032000 | call | 32.0000 | 2026-10-16 | 2.1200 | 1.8900 | 2.1200 | 29.8400 | 27134.00 | 26923.00 | 211.00 | 128 | 9 | 1865 | 836 | 2.23086124401914 | 0.698125394288475 | 0.698125394288475 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T13:31:29.863287Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aae05dc8-2d4f-4ff3-a592-4072e0bcf2c7 | 2026-09-10 09:43 | 2026-09-10 09:43 | 2026-09-10 09:43 | OSCR | OSCR260918C00035000 | call | 35.0000 | 2026-09-18 | 0.9000 | 0.7500 | 0.9200 | 33.0650 | 33535.00 | 29070.00 | 4465.00 | 374 | 17 | 1449 | 9770 | 0.148311156601842 | 0.827959225042939 | 0.839020503101912 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T13:52:43.061304Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8a51d5fd-cf64-48c5-9c09-d66426410d9d | 2026-09-14 14:35 | 2026-09-14 14:35 | 2026-09-14 14:35 | OSCR | OSCR260918C00035000 | call | 35.0000 | 2026-09-18 | 0.9900 | 0.9000 | 1.0200 | 34.0800 | 11887.00 | 11887.00 | 0.00 | 120 | 5 | 942 | 9903 | 0.0951226900939109 | 0.968475815568602 | 0.975653433772916 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T18:49:41.095224Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 29a148fa-7251-4b1f-befa-d57357baa6c4 | 2026-09-15 12:30 | 2026-09-15 12:30 | 2026-09-15 12:30 | OSCR | OSCR260918C00035000 | call | 35.0000 | 2026-09-18 | 0.5600 | 0.4600 | 0.5800 | 32.0000 | 33610.00 | 33154.00 | 456.00 | 600 | 26 | 692 | 10097 | 0.0685352084777657 | 1.05736382359771 | 1.09252810513932 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:48:10.363261Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| a45d6bb3-8f3e-452b-8c97-ed7e797858fd | 2026-09-15 15:53 | 2026-09-15 15:53 | 2026-09-15 15:53 | OSCR | OSCR260918P00030500 | put | 30.5000 | 2026-09-18 | 0.4900 | 0.3400 | 0.5100 | 32.0000 | 29382.00 | 29382.00 | 0.00 | 600 | 24 | 1833 | 569 | 3.22144112478032 | 1.06844161434994 | 1.06844161434994 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 9245986890.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| f757e7f4-94aa-419f-8e6c-613a0494f91b | 2026-09-16 09:56 | 2026-09-16 09:56 | 2026-09-16 09:56 | OSCR | OSCR260918P00032500 | put | 32.5000 | 2026-09-18 | 1.0400 | 1.0200 | 1.0500 | 32.2800 | 86685.00 | 45885.00 | 40800.00 | 837 | 17 | 837 | 196 | 4.27040816326531 | 0.951188796745465 | 0.951188796745465 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 8843987460.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| b5da653b-0595-4660-ac22-8a5c4c53677f | 2026-09-16 09:56 | 2026-09-16 09:56 | 2026-09-16 09:56 | OSCR | OSCR260918P00033500 | put | 33.5000 | 2026-09-18 | 1.6300 | 1.6300 | 1.6600 | 32.2800 | 22231.00 | 3486.00 | 18745.00 | 136 | 7 | 136 | 245 | 0.555102040816327 | 0.922952727266526 | 0.958523793705927 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 8843987460.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 6ce1c9c2-9505-438f-b7c4-5ff1a701e13d | 2026-09-16 09:56 | 2026-09-16 09:56 | 2026-09-16 09:56 | OSCR | OSCR260918P00032000 | put | 32.0000 | 2026-09-18 | 0.7400 | 0.7400 | 0.7700 | 32.2800 | 91608.00 | 3696.00 | 87912.00 | 1236 | 25 | 1238 | 615 | 2.0130081300813 | 0.923215301677635 | 0.923215301677635 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 8843987460.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 66e96ba7-5f84-4397-9979-6911c3baae74 | 2026-09-16 09:56 | 2026-09-16 09:56 | 2026-09-16 09:56 | OSCR | OSCR260918C00034000 | call | 34.0000 | 2026-09-18 | 0.3300 | 0.2600 | 0.3300 | 32.2800 | 142365.00 | 121605.00 | 20760.00 | 4377 | 29 | 4981 | 10068 | 0.494735796583234 | 0.932012417699658 | 0.972176338342705 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 8843987460.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |