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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b7aec3b9-0868-4fc8-b571-8ddb8ee6edc0 | 2026-09-18 10:55 | 2026-09-18 10:55 | 2026-09-18 10:55 | JNJ | JNJ261016C00260000 | call | 260.0000 | 2026-10-16 | 13.4000 | 13.1500 | 13.4000 | 268.6750 | 191620.00 | 191620.00 | 0.00 | 143 | 5 | 161 | 3536 | 0.0455316742081448 | 0.26640277632521 | 0.26640277632521 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 650648522204.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 8854effc-b647-4598-a372-f6416be41e79 | 2026-09-16 15:06 | 2026-09-16 15:06 | 2026-09-16 15:06 | JNJ | JNJ270416C00290000 | call | 290.0000 | 2027-04-16 | 13.3800 | 13.3000 | 14.5000 | 268.1600 | 153830.00 | 0.00 | 153830.00 | 115 | 27 | 153 | 20 | 7.65 | 0.23589031046395 | 0.240895289917412 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 644117697006.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T19:16:52.058969Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 12b06d3e-2499-45fb-b698-8098d507f13b | 2026-09-16 13:09 | 2026-09-16 13:09 | 2026-09-16 13:09 | JNJ | JNJ261016C00280000 | call | 280.0000 | 2026-10-16 | 3.6500 | 3.3500 | 3.6500 | 267.4300 | 135744.00 | 135744.00 | 0.00 | 372 | 48 | 747 | 6584 | 0.113456865127582 | 0.262350890753651 | 0.262350890753651 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 644117697006.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:41:31.610627Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 38ef4ffd-4f90-4ff1-99e3-98be62c5af3c | 2026-09-16 11:25 | 2026-09-16 11:24 | 2026-09-16 11:24 | JNJ | JNJ280121C00280000 | call | 280.0000 | 2028-01-21 | 30.3000 | 29.4000 | 30.4000 | 267.3700 | 184820.00 | 184820.00 | 0.00 | 61 | 17 | 61 | 855 | 0.0713450292397661 | 0.228816585243139 | 0.228816585243139 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 644117697006.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 5cc5dd88-ee10-4c6c-b1ad-d8ca68fe9665 | 2026-09-16 10:42 | 2026-09-16 10:42 | 2026-09-16 10:42 | JNJ | JNJ260918C00260000 | call | 260.0000 | 2026-09-18 | 7.5000 | 7.2000 | 8.0000 | 267.0200 | 138750.00 | 0.00 | 138750.00 | 185 | 17 | 259 | 5571 | 0.0464907556991563 | 0.303521769766965 | 0.325720806565885 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 644117697006.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:55:35.772586Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 1488fab0-fbfa-4f17-9bf6-2fe44a0e9fbc | 2026-09-15 15:13 | 2026-09-15 15:13 | 2026-09-15 15:13 | JNJ | JNJ260925P00260000 | put | 260.0000 | 2026-09-25 | 2.3400 | 2.0200 | 2.4000 | 265.5050 | 149440.00 | 149440.00 | 0.00 | 640 | 2 | 1798 | 244 | 7.36885245901639 | 0.268924789717594 | 0.268924789717594 | false | true | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 67ddda84-5921-4424-9e4b-c53194b252f4 | 2026-09-14 10:19 | 2026-09-14 10:19 | 2026-09-14 10:19 | JNJ | JNJ260918P00272500 | put | 272.5000 | 2026-09-18 | 4.9000 | 4.0000 | 4.9500 | 269.0000 | 152904.00 | 147024.00 | 0.00 | 312 | 19 | 313 | 108 | 2.89814814814815 | 0.280089173454964 | 0.284833588673525 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0930b710-aa90-40bc-a1ae-e23dcfd9e3c3 | 2026-09-09 12:05 | 2026-09-09 12:05 | 2026-09-09 12:05 | JNJ | JNJ260911P00265000 | put | 265.0000 | 2026-09-11 | 0.9100 | 0.5500 | 0.8400 | 268.9900 | 589386.00 | 589386.00 | 0.00 | 6500 | 46 | 6561 | 662 | 9.91087613293051 | 0.294757877788115 | 0.305959876982437 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T16:21:26.040266Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 00885dbf-36c7-4221-a5d9-dd32b4ac5fee | 2026-09-03 13:16 | 2026-09-03 13:16 | 2026-09-03 13:16 | JNJ | JNJ270319P00280000 | put | 280.0000 | 2027-03-19 | 19.7900 | 19.5000 | 20.1500 | 278.2950 | 395744.00 | 51576.00 | 344168.00 | 200 | 18 | 274 | 50 | 5.48 | 0.271793533791344 | 0.271793533791344 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T17:30:37.600118Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| eccb8d0a-2704-423a-9e00-1a461d9601c3 | 2026-09-02 10:22 | 2026-09-02 10:22 | 2026-09-02 10:22 | JNJ | JNJ261218P00280000 | put | 280.0000 | 2026-12-18 | 16.5000 | 16.5000 | 17.1500 | 274.8150 | 105600.00 | 0.00 | 105600.00 | 64 | 7 | 64 | 518 | 0.123552123552124 | 0.260547307530583 | 0.260547307530583 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:25:30.485375Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5ae683d3-4567-482c-822a-1f4f612025ce | 2026-08-27 09:36 | 2026-08-27 09:36 | 2026-08-27 09:36 | JNJ | JNJ260828P00270000 | put | 270.0000 | 2026-08-28 | 3.2000 | 2.6700 | 4.1000 | 267.1350 | 160000.00 | 149440.00 | 4480.00 | 500 | 8 | 1010 | 1765 | 0.572237960339943 | 0.236429948406273 | 0.236429948406273 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | 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 |
| 87bf8269-b1dc-43fa-955b-f3337a7ecae7 | 2026-08-27 09:34 | 2026-08-27 09:34 | 2026-08-27 09:34 | JNJ | JNJ260828P00270000 | put | 270.0000 | 2026-08-28 | 3.3000 | 3.3000 | 5.0500 | 266.6950 | 112200.00 | 0.00 | 112200.00 | 340 | 33 | 510 | 1765 | 0.288951841359773 | 0.126930776404239 | 0.126930776404239 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | 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 |
| f91b00ef-30eb-4cd6-a8a0-4e2a3f673875 | 2026-08-21 14:23 | 2026-08-21 14:23 | 2026-08-21 14:23 | JNJ | JNJ260821C00252500 | call | 252.5000 | 2026-08-21 | 19.2000 | 19.0000 | 19.4000 | 271.0000 | 307200.00 | 218880.00 | 88320.00 | 160 | 25 | 460 | 823 | 0.558930741190765 | 3.12218609038619 | 2.73606588662796 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7aafebde-02a8-4700-a29f-7f8b834e502c | 2026-08-21 14:23 | 2026-08-21 14:22 | 2026-08-21 14:22 | JNJ | JNJ260821C00252500 | call | 252.5000 | 2026-08-21 | 19.2000 | 19.0000 | 19.5500 | 271.0000 | 161280.00 | 0.00 | 86400.00 | 84 | 10 | 300 | 823 | 0.364520048602673 | 3.49314528017311 | 3.08682971581134 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 20f02563-5129-454d-8590-6993a8af1323 | 2026-08-21 14:22 | 2026-08-21 14:22 | 2026-08-21 14:22 | JNJ | JNJ260821C00252500 | call | 252.5000 | 2026-08-21 | 19.2000 | 18.8500 | 19.2000 | 271.0000 | 109440.00 | 51840.00 | 0.00 | 57 | 13 | 207 | 823 | 0.251518833535844 | 2.40779755313942 | 2.40800627834753 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 838a2389-7561-4a52-9eb8-cc3c4f4e86cb | 2026-08-21 14:22 | 2026-08-21 14:22 | 2026-08-21 14:22 | JNJ | JNJ260821C00252500 | call | 252.5000 | 2026-08-21 | 19.1500 | 18.8500 | 19.4500 | 271.0000 | 191500.00 | 90005.00 | 0.00 | 100 | 8 | 150 | 823 | 0.182260024301337 | 2.43979297500608 | 2.43979297500608 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| dcddedb0-ba5b-45ed-92e1-29f32dadb5c3 | 2026-08-21 14:05 | 2026-08-21 14:05 | 2026-08-21 14:05 | JNJ | JNJ260821C00250000 | call | 250.0000 | 2026-08-21 | 21.2000 | 20.9500 | 21.2500 | 271.0000 | 175960.00 | 175960.00 | 0.00 | 83 | 27 | 164 | 4160 | 0.0394230769230769 | 2.54776542467562 | 2.54776542467562 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 502eebab-8333-4258-abe5-33354ee83ce2 | 2026-08-20 09:58 | 2026-08-20 09:58 | 2026-08-20 09:58 | JNJ | JNJ260918C00250000 | call | 250.0000 | 2026-09-18 | 22.0000 | 21.3500 | 22.6500 | 271.4750 | 110010.00 | 22010.00 | 0.00 | 50 | 6 | 58 | 5464 | 0.0106149341142021 | 0.201290948758983 | 0.201290948758983 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:05:52.049536Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 81086c8d-64ed-436a-89ea-fdef5c16c493 | 2026-08-19 09:59 | 2026-08-19 09:59 | 2026-08-19 09:59 | JNJ | JNJ260918C00290000 | call | 290.0000 | 2026-09-18 | 2.3800 | 2.0300 | 2.4700 | 275.3500 | 138000.00 | 121621.00 | 16379.00 | 581 | 50 | 657 | 14987 | 0.0438379929272036 | 0.225656837080351 | 0.227300508214724 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:00:52.208142Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e26cc321-33cd-4676-b6c8-f28e01a02c0f | 2026-08-18 15:31 | 2026-08-18 15:30 | 2026-08-18 15:30 | JNJ | JNJ260821P00290000 | put | 290.0000 | 2026-08-21 | 19.1500 | 17.5500 | 19.1500 | 270.9300 | 181925.00 | 181925.00 | 0.00 | 95 | 21 | 610 | 0 | 0 | 0.424454673483304 | 0.424454673483304 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T19:46:05.553268Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7f6ec05f-1883-4b0d-a65d-100ba9cab731 | 2026-08-18 11:50 | 2026-08-18 11:50 | 2026-08-18 11:50 | JNJ | JNJ260918C00270000 | call | 270.0000 | 2026-09-18 | 7.7500 | 7.7500 | 7.9500 | 271.5750 | 155000.00 | 0.00 | 155000.00 | 200 | 8 | 12843 | 15644 | 0.820953720276144 | 0.205280058777591 | 0.205280058777591 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d3e7bc67-caf4-4fe2-b436-f6d210e88eb9 | 2026-08-18 11:49 | 2026-08-18 11:48 | 2026-08-18 11:48 | JNJ | JNJ260821C00240000 | call | 240.0000 | 2026-08-21 | 31.6000 | 29.7000 | 32.5000 | 271.7100 | 948000.00 | 948000.00 | 0.00 | 300 | 5 | 929 | 1572 | 0.590966921119593 | 0.297317897731983 | 0.94541987130135 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5b9099c3-9a33-4a2d-b323-2079901fccf0 | 2026-08-18 11:02 | 2026-08-18 11:01 | 2026-08-18 11:01 | JNJ | JNJ260821C00240000 | call | 240.0000 | 2026-08-21 | 30.1000 | 28.3500 | 31.6000 | 270.2100 | 903000.00 | 803670.00 | 0.00 | 300 | 6 | 318 | 1572 | 0.202290076335878 | 0.310192644364797 | 0.310192644364797 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | 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 |
| 6dbe902c-fc51-4852-8343-8b8aeb78cb23 | 2026-08-17 12:17 | 2026-08-17 12:16 | 2026-08-17 12:16 | JNJ | JNJ260821C00265000 | call | 265.0000 | 2026-08-21 | 2.4000 | 2.3400 | 2.4000 | 264.2300 | 123360.00 | 123360.00 | 0.00 | 514 | 14 | 1216 | 5349 | 0.227332211628342 | 0.245935566997019 | 0.245935566997019 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 641804194353.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |