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.
uw_flow_alerts326,449 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 | expiry |
|---|
| 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 |
|---|
| 79169b6c-d17f-4866-a808-5c60a117f643 | 2026-08-17 12:56 | 2026-08-17 12:56 | 2026-08-17 12:56 | COHR | COHR261120C00400000 | call | 400.0000 | 2026-11-20 | 50.0000 | 50.0000 | 51.0000 | 362.2600 | 1045039.00 | 5010.00 | 1040029.00 | 209 | 23 | 280 | 293 | 0.955631399317406 | 0.855963021813026 | 0.85731946670015 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 52189293559.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:56:51.972483Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2fa5f31d-c2c9-4c4a-b3c4-005458edb3a5 | 2026-08-17 14:12 | 2026-08-17 14:12 | 2026-08-17 14:12 | COHR | COHR260821P00357500 | put | 357.5000 | 2026-08-21 | 14.7700 | 14.0000 | 15.5000 | 356.0000 | 81210.00 | 13230.00 | 65040.00 | 55 | 8 | 154 | 154 | 1 | 0.951127859787099 | 0.959193953512782 | false | false | false | true | ||||||||||||||||
| 489574f5-3d11-40f5-bea3-b1c1d7715ec7 | 2026-08-18 09:49 | 2026-08-18 09:49 | 2026-08-18 09:49 | COHR | COHR260821C00360000 | call | 360.0000 | 2026-08-21 | 1.5500 | 1.5500 | 2.2500 | 319.0000 | 80633.00 | 0.00 | 80633.00 | 520 | 51 | 640 | 1654 | 0.386940749697703 | 1.03252518962506 | 1.03252518962506 | false | false | false | true | ||||||||||||||||
| 9df9ffb2-6cbb-4dde-a57d-94cff942bb55 | 2026-08-18 10:52 | 2026-08-18 10:52 | 2026-08-18 10:52 | COHR | COHR261016P00330000 | put | 330.0000 | 2026-10-16 | 50.9500 | 49.7000 | 51.4000 | 310.2500 | 61140.00 | 25450.00 | 35690.00 | 12 | 9 | 18 | 297 | 0.0606060606060606 | 0.813442014822654 | 0.815451598588514 | true | false | false | true | ||||||||||||||||
| e738f073-755e-4caf-9d79-28b73b404a8a | 2026-08-19 12:19 | 2026-08-19 12:19 | 2026-08-19 12:19 | COHR | COHR261120C00400000 | call | 400.0000 | 2026-11-20 | 19.2000 | 19.0000 | 21.1000 | 294.0800 | 1887388.00 | 0.00 | 1887388.00 | 983 | 68 | 1001 | 530 | 1.88867924528302 | 0.817463395956432 | 0.818165241380788 | false | false | false | |||||||||||||||||
| 8aa60918-9ec7-4225-85a8-0da0da8cca75 | 2026-08-19 14:30 | 2026-08-19 14:30 | 2026-08-19 14:30 | COHR | COHR261120P00280000 | put | 280.0000 | 2026-11-20 | 40.1000 | 40.1000 | 41.5000 | 287.0750 | 517292.00 | 0.00 | 517292.00 | 129 | 29 | 328 | 887 | 0.36978579481398 | 0.79459261090569 | 0.79459261090569 | false | false | false | true | ||||||||||||||||
| 34e216e2-59cc-4688-bf53-e5d1d9d4e9fc | 2026-08-19 14:38 | 2026-08-19 14:38 | 2026-08-19 14:38 | COHR | COHR280121C00300000 | call | 300.0000 | 2028-01-21 | 107.0400 | 107.0000 | 112.0000 | 285.6700 | 984780.00 | 406980.00 | 577800.00 | 92 | 7 | 156 | 290 | 0.537931034482759 | 0.809963782648454 | 0.810794629805611 | false | false | false | |||||||||||||||||
| f31870a7-f844-49c9-8640-3b17808e90ec | 2026-08-21 10:10 | 2026-08-21 10:10 | 2026-08-21 10:10 | COHR | COHR260828C00320000 | call | 320.0000 | 2026-08-28 | 5.7400 | 5.4000 | 6.0000 | 298.2553 | 51618.00 | 28850.00 | 9088.00 | 90 | 8 | 778 | 277 | 2.8086642599278 | 0.814075623804505 | 0.814075623804505 | false | false | false | true | ||||||||||||||||
| 1541942f-78cb-4ec5-9eac-1ee9e862f31d | 2026-08-21 15:23 | 2026-08-21 15:22 | 2026-08-21 15:22 | COHR | COHR270319C00300000 | call | 300.0000 | 2027-03-19 | 67.3600 | 66.1000 | 67.5000 | 289.2300 | 255980.00 | 255980.00 | 0.00 | 38 | 5 | 73 | 1105 | 0.0660633484162896 | 0.799329060996724 | 0.800400419426668 | false | false | false | |||||||||||||||||
| 1d527e5a-46b2-4dc7-afa3-6fcc256c3e5f | 2026-08-24 09:30 | 2026-08-24 09:30 | 2026-08-24 09:30 | COHR | COHR260828C00270000 | call | 270.0000 | 2026-08-28 | 11.1000 | 9.3000 | 15.5000 | 270.0800 | 485211.00 | 6800.00 | 478411.00 | 437 | 13 | 1201 | 29 | 41.4137931034483 | 0.976313991219273 | 1.10066475935176 | false | false | false | |||||||||||||||||
| 7a11b7b3-9c1f-407f-bc28-2e0a359580b7 | 2026-08-25 10:02 | 2026-08-25 10:02 | 2026-08-25 10:02 | COHR | COHR260918C00290000 | call | 290.0000 | 2026-09-18 | 22.4200 | 21.8000 | 24.3000 | 289.2901 | 51570.00 | 6770.00 | 44800.00 | 23 | 15 | 33 | 234 | 0.141025641025641 | 0.757919162543132 | 0.757917333281134 | false | false | false | |||||||||||||||||
| 1f3a1440-3852-4104-a4b9-9a23fd8e4f80 | 2026-08-25 10:41 | 2026-08-25 10:40 | 2026-08-25 10:40 | COHR | COHR260925C00295000 | call | 295.0000 | 2026-09-25 | 22.6000 | 22.6000 | 24.9000 | 286.2250 | 320960.00 | 2270.00 | 316420.00 | 142 | 5 | 143 | 43 | 3.32558139534884 | 0.782214335141905 | 0.785219381964875 | false | false | false | |||||||||||||||||
| 5bf9c980-fb5d-4b14-9723-3e59b8acc00a | 2026-08-25 13:38 | 2026-08-25 13:38 | 2026-08-25 13:38 | COHR | COHR270115P00230000 | put | 230.0000 | 2027-01-15 | 25.6600 | 25.6000 | 26.0000 | 282.6600 | 66710.00 | 2570.00 | 28160.00 | 26 | 18 | 45 | 697 | 0.0645624103299857 | 0.775564173900517 | 0.777373184040537 | false | false | false | |||||||||||||||||
| 3259af01-b635-4d0c-897c-89beb91652a2 | 2026-08-27 09:32 | 2026-08-27 09:32 | 2026-08-27 09:32 | COHR | COHR260828C00320000 | call | 320.0000 | 2026-08-28 | 2.8300 | 0.8250 | 5.2000 | 305.5500 | 63783.00 | 59616.00 | 4167.00 | 225 | 10 | 226 | 4232 | 0.0534026465028355 | 1.15555199875075 | 1.23439711737782 | true | false | false | |||||||||||||||||
| e8f6d9bc-0424-49f6-8382-ca86ac10775f | 2026-08-28 12:05 | 2026-08-28 12:05 | 2026-08-28 12:05 | COHR | COHR261120P00280000 | put | 280.0000 | 2026-11-20 | 37.8000 | 37.8000 | 39.2000 | 283.0000 | 366681.00 | 7580.00 | 359101.00 | 97 | 37 | 210 | 1280 | 0.1640625 | 0.759438506632137 | 0.759438506632137 | false | false | false | true | ||||||||||||||||
| 1ea96ef3-e68c-4ba3-a74b-af2b6e30016a | 2026-09-01 14:22 | 2026-09-01 14:22 | 2026-09-01 14:22 | COHR | COHR270319P00200000 | put | 200.0000 | 2027-03-19 | 19.9000 | 19.9000 | 21.1000 | 273.4300 | 216916.00 | 0.00 | 216916.00 | 109 | 28 | 109 | 362 | 0.301104972375691 | 0.725971563357422 | 0.725971563357422 | false | false | false | |||||||||||||||||
| 7eb3a888-3961-4d4b-afa2-ef77170054ac | 2026-09-08 13:00 | 2026-09-08 13:00 | 2026-09-08 13:00 | COHR | COHR261016C00310000 | call | 310.0000 | 2026-10-16 | 29.4800 | 28.8000 | 29.5000 | 307.5500 | 85500.00 | 85500.00 | 0.00 | 29 | 6 | 110 | 419 | 0.262529832935561 | 0.758691687158239 | 0.76123190266186 | true | false | false | true | ||||||||||||||||
| 5dd4d5b1-4cce-4377-b447-994da331de46 | 2026-09-09 11:45 | 2026-09-09 11:44 | 2026-09-09 11:44 | COHR | COHR260911C00315000 | call | 315.0000 | 2026-09-11 | 5.8700 | 5.0000 | 6.6000 | 309.4700 | 58742.00 | 54742.00 | 4000.00 | 100 | 5 | 158 | 188 | 0.840425531914894 | 0.805404605112898 | 0.912510053149682 | false | false | false | |||||||||||||||||
| 6f9f413e-8724-48e7-b731-afb9ad6b8cb8 | 2026-09-10 12:28 | 2026-09-10 12:28 | 2026-09-10 12:28 | COHR | COHR260911P00305000 | put | 305.0000 | 2026-09-11 | 10.9100 | 7.7000 | 12.7000 | 296.2700 | 85060.00 | 8660.00 | 2150.00 | 78 | 78 | 128 | 111 | 1.15315315315315 | 0.835291310666244 | 0.913170277421515 | false | false | false | true | ||||||||||||||||
| 3fa6732d-673c-413a-a132-1fd831bb2a1c | 2026-09-15 10:02 | 2026-09-15 10:02 | 2026-09-15 10:02 | COHR | COHR270521P00230000 | put | 230.0000 | 2027-05-21 | 37.9000 | 37.9000 | 39.1000 | 276.9050 | 568425.00 | 0.00 | 568425.00 | 150 | 17 | 150 | 4 | 37.5 | 0.756028490294797 | 0.756709875279574 | false | false | false | true | ||||||||||||||||
| cbbf9b1d-1a99-4936-ad25-54d930fe8907 | 2026-09-16 11:47 | 2026-09-16 11:47 | 2026-09-16 11:47 | COHR | COHR260918P00285000 | put | 285.0000 | 2026-09-18 | 4.3000 | 4.2000 | 4.4000 | 292.9850 | 106120.00 | 52360.00 | 53760.00 | 247 | 9 | 278 | 722 | 0.385041551246537 | 0.885092436265932 | 0.910697101533821 | false | false | false | true | ||||||||||||||||
| b8c3f7a8-b77a-4c43-884d-7a0fd2eefeaf | 2026-09-21 15:45 | 2026-09-21 15:45 | 2026-09-21 15:45 | COHR | COHR290119P00250000 | put | 250.0000 | 2029-01-19 | 77.3000 | 76.0000 | 82.8000 | 323.6900 | 123687.00 | 7700.00 | 115987.00 | 16 | 11 | 36 | 5 | 7.2 | 0.773234810059177 | 0.782328264066069 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-18T15:04:03.259366Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:38:06.174043Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T13:38:22.111482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T16:07:30.029075Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:40:09.958238Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T17:11:09.796111Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T16:37:06.868856Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 52189293559.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 56777643083.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:04:58.541898Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 62963983734.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:46:53.809312Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |