Simplify AnalyticsOptions 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0139b6a9-a6a7-4a48-ae76-e33d8b33c3ca | 2026-08-17 12:24 | 2026-08-17 12:24 | 2026-08-17 12:24 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 9.8000 | 9.8000 | 10.2000 | 148.4500 | 83300.00 | 0.00 | 83300.00 | 85 | 22 | 411 | 20124 | 0.0204233750745379 | 0.628224960122035 | 0.628224960122035 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | 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 |
| f6406635-eedd-4783-afac-a9eb5f94ee52 | 2026-08-19 14:27 | 2026-08-19 14:27 | 2026-08-19 14:27 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 8.6000 | 8.5000 | 8.6000 | 144.4600 | 172000.00 | 56760.00 | 0.00 | 200 | 5 | 1607 | 20496 | 0.0784055425448868 | 0.632412975807287 | 0.632412975807287 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | 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 |
| ade42dbb-78bd-47fe-8115-7f2921ec1531 | 2026-09-01 14:06 | 2026-09-01 14:05 | 2026-09-01 14:05 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 6.2500 | 6.1500 | 6.2500 | 141.2250 | 150000.00 | 150000.00 | 0.00 | 240 | 7 | 920 | 28107 | 0.0327320596292738 | 0.612051737406581 | 0.612051737406581 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T18:15:43.135015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e4b5c8a5-5209-47e4-a47e-41c1c75de986 | 2026-09-03 10:48 | 2026-09-03 10:48 | 2026-09-03 10:48 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 8.9500 | 8.9500 | 9.1000 | 152.7250 | 447500.00 | 0.00 | 447500.00 | 500 | 7 | 780 | 28489 | 0.0273789883814806 | 0.601341608024376 | 0.601341608024376 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 94ecfebd-8989-49d7-abf3-7c7de1036b67 | 2026-09-03 12:07 | 2026-09-03 12:07 | 2026-09-03 12:07 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 9.0000 | 8.9500 | 9.3000 | 153.2300 | 90015.00 | 0.00 | 90015.00 | 100 | 11 | 990 | 28489 | 0.0347502544841869 | 0.59797095952477 | 0.598158144298095 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3c103850-14a8-4fe9-aa4a-bc642290ca7f | 2026-09-04 15:59 | 2026-09-04 15:59 | 2026-09-04 15:59 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 11.0000 | 10.8500 | 11.1000 | 158.7300 | 137500.00 | 24200.00 | 113300.00 | 125 | 15 | 1625 | 29015 | 0.0560055143891091 | 0.607395064873136 | 0.607395064873136 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9ba5b432-a4fa-4e56-82ff-e7a663cc5fb3 | 2026-09-08 09:31 | 2026-09-08 09:31 | 2026-09-08 09:31 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 15.0000 | 13.6000 | 16.1500 | 169.6009 | 322500.00 | 322500.00 | 0.00 | 215 | 5 | 215 | 28184 | 0.00762844166903208 | 0.613874269698549 | 0.614961404830557 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T13:33:29.575205Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7674c785-143d-449c-89c8-9623f0042fcf | 2026-09-08 11:09 | 2026-09-08 11:08 | 2026-09-08 11:08 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 12.7000 | 12.6000 | 12.8000 | 163.4800 | 472389.00 | 383519.00 | 24100.00 | 372 | 19 | 1826 | 28184 | 0.0647885325007096 | 0.617028376773948 | 0.61677565501902 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 27c74ffa-dfce-4e70-bde7-35699fd6c73d | 2026-09-09 11:16 | 2026-09-09 11:16 | 2026-09-09 11:16 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 11.7700 | 11.6000 | 11.9000 | 161.0100 | 1059386.00 | 729240.00 | 327796.00 | 900 | 11 | 1162 | 27132 | 0.042827657378741 | 0.618107832080944 | 0.618107832080944 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| bd04ff59-eaf7-4304-9632-197b60e801ea | 2026-09-09 11:26 | 2026-09-09 11:25 | 2026-09-09 11:25 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 11.8900 | 11.5500 | 11.9000 | 161.0600 | 108232.00 | 108232.00 | 0.00 | 91 | 5 | 1359 | 27132 | 0.0500884564352057 | 0.623239993547641 | 0.623802344428742 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T15:29:26.424015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 767dbb32-314d-4858-aa88-d031fb73fb6a | 2026-09-09 11:56 | 2026-09-09 11:55 | 2026-09-09 11:55 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 12.0000 | 11.7500 | 12.0000 | 161.3300 | 240000.00 | 240000.00 | 0.00 | 200 | 11 | 1595 | 27132 | 0.0587866725637623 | 0.623899126434955 | 0.623899126434955 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | 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 |
| 58c37f14-7e7e-4e8e-8274-0874c070fe1a | 2026-09-09 11:56 | 2026-09-09 11:56 | 2026-09-09 11:56 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 12.0000 | 11.7500 | 12.0000 | 161.2900 | 119962.00 | 119962.00 | 0.00 | 100 | 7 | 1695 | 27132 | 0.0624723573639982 | 0.623740274356669 | 0.623740274356669 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | 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 |
| d50326e8-a2fe-41ac-90a7-f94d3043f8e8 | 2026-09-09 15:02 | 2026-09-09 15:02 | 2026-09-09 15:02 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 12.5500 | 12.5500 | 12.7500 | 163.4280 | 525870.00 | 0.00 | 525870.00 | 419 | 26 | 2302 | 27132 | 0.08484446410143 | 0.617993847626662 | 0.617993847626662 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T19:27:55.926703Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e809a3ec-7ee9-4a49-b5e6-a48d05ac2f3d | 2026-09-10 11:00 | 2026-09-10 11:00 | 2026-09-10 11:00 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 10.8000 | 10.8000 | 11.2500 | 158.6750 | 108000.00 | 0.00 | 108000.00 | 100 | 6 | 389 | 28571 | 0.0136152042280634 | 0.616847065891817 | 0.616847065891817 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0688fd68-0048-4b95-a9c8-929cd771b2ac | 2026-09-10 11:01 | 2026-09-10 11:01 | 2026-09-10 11:01 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 10.9000 | 10.8000 | 11.2000 | 158.5400 | 109000.00 | 21800.00 | 87200.00 | 100 | 8 | 489 | 28571 | 0.0171152567288509 | 0.621103726168487 | 0.621103726168487 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 0baf4fb7-44d0-499e-b694-314807ed549a | 2026-09-10 11:13 | 2026-09-10 11:13 | 2026-09-10 11:13 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 10.9000 | 10.9000 | 11.0500 | 158.7300 | 109000.00 | 0.00 | 109000.00 | 100 | 9 | 993 | 28571 | 0.03475552133282 | 0.619219474996276 | 0.619219474996276 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 51feee55-008a-46bf-8035-1c45f9ec43ac | 2026-09-11 10:22 | 2026-09-11 10:21 | 2026-09-11 10:21 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 6.8800 | 6.6500 | 7.3000 | 151.4550 | 128709.00 | 27600.00 | 77649.00 | 187 | 13 | 1223 | 29160 | 0.0419410150891632 | 0.565359732782517 | 0.565359732782517 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d5d3cad0-eeec-4f22-be85-1a891e8b813b | 2026-09-11 10:28 | 2026-09-11 10:28 | 2026-09-11 10:28 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 7.2500 | 7.2500 | 7.5000 | 153.6150 | 108750.00 | 0.00 | 108750.00 | 150 | 16 | 1451 | 29160 | 0.0497599451303155 | 0.557523937632318 | 0.557523937632318 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:44:39.456230Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 81cf9741-91a3-48f3-be83-e84d66487771 | 2026-09-11 11:09 | 2026-09-11 11:09 | 2026-09-11 11:09 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 7.0000 | 6.9500 | 7.2000 | 152.8250 | 70000.00 | 0.00 | 70000.00 | 100 | 7 | 1926 | 29160 | 0.0660493827160494 | 0.556331425785798 | 0.556331425785798 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T15:28:46.184785Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 506caa71-ab62-4000-bff2-b387fd1fe9e4 | 2026-09-15 10:00 | 2026-09-15 10:00 | 2026-09-15 10:00 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 4.0000 | 4.0000 | 4.1500 | 140.6600 | 184000.00 | 0.00 | 184000.00 | 460 | 6 | 1710 | 30734 | 0.055638706318735 | 0.555697736835383 | 0.555697736835383 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | 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 |
| fe4d3430-a638-4821-986c-fda29aaf0ce7 | 2026-09-15 10:05 | 2026-09-15 10:05 | 2026-09-15 10:05 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 4.0500 | 4.0000 | 4.0500 | 140.6750 | 165949.00 | 165949.00 | 0.00 | 410 | 21 | 2189 | 30734 | 0.0712240515390122 | 0.557857171042446 | 0.557400454503116 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 18d5b735-491f-4802-8ac6-c3f22cc10377 | 2026-09-15 12:20 | 2026-09-15 12:20 | 2026-09-15 12:20 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 4.5600 | 4.5500 | 4.6500 | 143.0000 | 102951.00 | 458.00 | 102493.00 | 226 | 9 | 2692 | 30734 | 0.0875902908830611 | 0.55439918817147 | 0.55312555327655 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 437806735440.00 | 2026-12-09 | 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 |
| 7a2aba36-b628-4d31-a472-470cde927ca0 | 2026-09-17 09:47 | 2026-09-17 09:47 | 2026-09-17 09:47 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 5.4000 | 5.4000 | 5.6000 | 148.8400 | 108067.00 | 0.00 | 108067.00 | 200 | 11 | 486 | 29553 | 0.0164450309613237 | 0.547748612626867 | 0.547748612626867 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 455344404240.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| f4094de2-0931-4e18-a7b2-3b25fcf03937 | 2026-09-17 11:53 | 2026-09-17 11:53 | 2026-09-17 11:53 | ORCL | ORCL270115C00200000 | call | 200.0000 | 2027-01-15 | 6.3000 | 6.2500 | 6.3500 | 151.8700 | 63000.00 | 49140.00 | 2520.00 | 100 | 7 | 1157 | 29553 | 0.0391500016918756 | 0.553995022904007 | 0.553995022904007 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 455344404240.00 | 2026-12-09 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T15:59:42.981722Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |