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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5fa57d9e-91b4-4d66-8d67-71d14ea69c8b | 2026-09-21 14:21 | 2026-09-21 14:21 | 2026-09-21 14:21 | RGEN | RGEN261218C00170000 | call | 170.0000 | 2026-12-18 | 27.5000 | 24.5000 | 27.5000 | 180.4000 | 22000.00 | 22000.00 | 0.00 | 8 | 6 | 18 | 1 | 18 | 0.61455958110402 | 0.61455958110402 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:23:56.707397Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 7ac0b84d-0327-4235-b8d2-9235afc344bd | 2026-09-21 14:17 | 2026-09-21 14:17 | 2026-09-21 14:17 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 32.0000 | 32.0000 | 32.2000 | 180.5000 | 32000.00 | 0.00 | 32000.00 | 10 | 7 | 986 | 0 | 0 | 0.573335146354815 | 0.573335146354815 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T18:20:26.028708Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 4114a259-35ae-46bc-80dd-3a2afbb40c33 | 2026-09-21 13:35 | 2026-09-21 13:34 | 2026-09-21 13:34 | RGEN | RGEN261016C00200000 | call | 200.0000 | 2026-10-16 | 4.5000 | 4.5000 | 4.6000 | 180.0000 | 13510.00 | 0.00 | 12600.00 | 30 | 11 | 6326 | 10 | 632.6 | 0.593993782686556 | 0.593993782686556 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:39:31.841992Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 4405e35b-0a3e-464b-8ee6-cda9c6481f42 | 2026-09-21 13:18 | 2026-09-21 13:18 | 2026-09-21 13:18 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 31.8000 | 31.8000 | 32.0000 | 180.0000 | 19080.00 | 0.00 | 19080.00 | 6 | 5 | 814 | 0 | 0 | 0.572834470366563 | 0.572834470366563 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:20:55.206028Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 7bf07a7b-38d5-4369-9a29-f7a564a499ab | 2026-09-21 13:16 | 2026-09-21 13:16 | 2026-09-21 13:16 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 32.0000 | 31.9000 | 32.3000 | 180.0000 | 22400.00 | 0.00 | 22400.00 | 7 | 5 | 794 | 0 | 0 | 0.578871914874456 | 0.578871914874456 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:20:55.206028Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 0dcaff21-3b6a-474b-9463-4100131a3de7 | 2026-09-21 13:06 | 2026-09-21 13:06 | 2026-09-21 13:06 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 32.0000 | 32.0000 | 33.5000 | 180.3120 | 166400.00 | 0.00 | 166400.00 | 52 | 27 | 767 | 0 | 0 | 0.577963946314258 | 0.577963946314258 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:07:15.058898Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 0aae5699-72f8-47fc-8e4e-8f1615cd1932 | 2026-09-21 12:47 | 2026-09-21 12:46 | 2026-09-21 12:46 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 32.0100 | 31.9000 | 33.5000 | 180.3050 | 22408.00 | 0.00 | 22408.00 | 7 | 6 | 671 | 0 | 0 | 0.578135799409895 | 0.578135799409895 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:51:16.040164Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 9a99ccd2-bb02-4585-a8da-61d613f30a03 | 2026-09-21 12:42 | 2026-09-21 12:42 | 2026-09-21 12:42 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 32.0000 | 31.9000 | 32.5000 | 180.6250 | 400000.00 | 0.00 | 345600.00 | 125 | 41 | 653 | 0 | 0 | 0.57024299730017 | 0.57024299730017 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:45:57.787225Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| f5b3bffe-7bc8-4feb-9dc6-6a1e3de979d5 | 2026-09-21 12:18 | 2026-09-21 12:18 | 2026-09-21 12:18 | RGEN | RGEN261218C00200000 | call | 200.0000 | 2026-12-18 | 12.4000 | 12.0000 | 13.2000 | 181.0000 | 22320.00 | 17360.00 | 4960.00 | 18 | 5 | 41 | 2 | 20.5 | 0.522310355118041 | 0.522310355118041 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:21:14.001426Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 63b9d479-0ca8-4531-9556-a09ed1f1f099 | 2026-09-21 12:18 | 2026-09-21 12:18 | 2026-09-21 12:18 | RGEN | RGEN261016C00200000 | call | 200.0000 | 2026-10-16 | 4.0000 | 3.9000 | 4.2000 | 181.0000 | 50000.00 | 0.00 | 50000.00 | 125 | 8 | 4102 | 10 | 410.2 | 0.529104429054242 | 0.529104429054242 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:21:14.001426Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| d312e3e8-0b1e-431b-bb96-6934adc7fcd8 | 2026-09-21 12:17 | 2026-09-21 12:17 | 2026-09-21 12:17 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 32.5000 | 32.0000 | 32.5000 | 181.0000 | 32500.00 | 32500.00 | 0.00 | 10 | 5 | 374 | 0 | 0 | 0.555298191099465 | 0.555298191099465 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:21:14.001426Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 5f183df1-411b-4b15-b41f-4690c0081498 | 2026-09-21 12:16 | 2026-09-21 12:15 | 2026-09-21 12:15 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 31.9900 | 31.9000 | 32.1000 | 181.5599 | 31990.00 | 0.00 | 31990.00 | 10 | 9 | 324 | 0 | 0 | 0.546719421679085 | 0.543260883381423 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:17:17.704519Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| b6d2343a-c51a-475b-981e-1293b92b2f8d | 2026-09-21 12:13 | 2026-09-21 12:13 | 2026-09-21 12:13 | RGEN | RGEN261016C00200000 | call | 200.0000 | 2026-10-16 | 4.0000 | 4.0000 | 4.5000 | 181.2900 | 10001.00 | 0.00 | 10001.00 | 25 | 7 | 3532 | 10 | 353.2 | 0.540362292979848 | 0.540996383201596 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:17:17.704519Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 9a046b66-9c0e-4c02-96d0-2f073e03b47c | 2026-09-21 12:13 | 2026-09-21 12:13 | 2026-09-21 12:13 | RGEN | RGEN261016C00200000 | call | 200.0000 | 2026-10-16 | 4.3000 | 4.0000 | 4.3000 | 181.4300 | 15910.00 | 15910.00 | 0.00 | 37 | 16 | 3493 | 10 | 349.3 | 0.55678517918003 | 0.55678517918003 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:17:17.704519Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 9323d441-4c84-4cf2-b470-ff3c0b83f3fc | 2026-09-21 12:09 | 2026-09-21 12:09 | 2026-09-21 12:09 | RGEN | RGEN261016C00200000 | call | 200.0000 | 2026-10-16 | 3.7700 | 3.7000 | 3.9000 | 180.4400 | 10180.00 | 4560.00 | 3720.00 | 27 | 5 | 2772 | 10 | 277.2 | 0.542127670299169 | 0.542127670299169 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 1baf734f-d5fa-43d3-a605-a28f9ed647a1 | 2026-09-21 12:07 | 2026-09-21 12:07 | 2026-09-21 12:07 | RGEN | RGEN261016C00200000 | call | 200.0000 | 2026-10-16 | 3.6000 | 3.6000 | 3.9000 | 180.3300 | 36005.00 | 0.00 | 36005.00 | 100 | 10 | 2302 | 10 | 230.2 | 0.530912876523012 | 0.530912876523012 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10198481071.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:10:34.961716Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 16918a8f-9fd5-4a37-80e9-cbe810c67d8a | 2026-09-10 15:42 | 2026-09-10 15:42 | 2026-09-10 15:42 | RGEN | RGEN260918P00160000 | put | 160.0000 | 2026-09-18 | 3.8000 | 3.2000 | 3.8000 | 163.8900 | 10640.00 | 10640.00 | 0.00 | 28 | 7 | 150 | 2 | 75 | 0.584111969589804 | 0.584111969589804 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 9481184328.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T19:48:54.834059Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1c95771c-ad54-41df-a260-bd29e7885339 | 2026-09-10 11:56 | 2026-09-10 11:56 | 2026-09-10 11:56 | RGEN | RGEN260918P00165000 | put | 165.0000 | 2026-09-18 | 6.6000 | 5.6000 | 6.6000 | 163.2950 | 17819.00 | 17819.00 | 0.00 | 27 | 12 | 238 | 56 | 4.25 | 0.596906975409701 | 0.596906975409701 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 9481184328.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 74b38deb-8312-47b8-8c55-206641b64b8b | 2026-09-09 14:23 | 2026-09-09 14:23 | 2026-09-09 14:23 | RGEN | RGEN261016C00165000 | call | 165.0000 | 2026-10-16 | 9.2000 | 8.2000 | 9.2000 | 164.9500 | 23000.00 | 23000.00 | 0.00 | 25 | 16 | 25 | 0 | 0 | 0.425672664714381 | 0.425672664714381 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 9481184328.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ba808374-27e7-49e9-92b4-4180ef1099e7 | 2026-09-09 14:20 | 2026-09-09 14:20 | 2026-09-09 14:20 | RGEN | RGEN260918C00165000 | call | 165.0000 | 2026-09-18 | 4.6000 | 4.2000 | 4.6000 | 164.7650 | 22080.00 | 22080.00 | 0.00 | 48 | 48 | 50 | 162 | 0.308641975308642 | 0.449516310114127 | 0.449516310114127 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 9481184328.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T18:27:25.894507Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e9b8e307-df65-4ced-b7f8-4c428bcb08d0 | 2026-08-27 15:39 | 2026-08-27 15:38 | 2026-08-27 15:38 | RGEN | RGEN260918C00180000 | call | 180.0000 | 2026-09-18 | 9.2000 | 7.8000 | 9.2000 | 182.7850 | 12880.00 | 12880.00 | 0.00 | 14 | 14 | 14 | 8 | 1.75 | 0.422522114261965 | 0.422522114261965 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 9481184328.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:52:49.177007Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |