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_alerts566,287 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 |
|---|
| 35549526-174a-4959-9c4e-872bfda29c40 | 2026-09-23 10:35 | 2026-09-23 10:35 | 2026-09-23 10:35 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 32.0000 | 32.0000 | 33.0000 | 183.6050 | 51200.00 | 0.00 | 51200.00 | 16 | 10 | 28 | 1050 | 0.0266666666666667 | 0.498646577022214 | 0.498646577022214 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 10414065143.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T14:35:38.031989Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| b4138e2d-0c17-41b2-bfc0-e76aa2028711 | 2026-09-22 14:57 | 2026-09-22 14:57 | 2026-09-22 14:57 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 34.4900 | 34.1000 | 35.6000 | 186.3000 | 100010.00 | 0.00 | 100010.00 | 29 | 12 | 126 | 998 | 0.12625250501002 | 0.510454128233238 | 0.49547535819787 | false | false | false | true | ||||||||||||||||
| 614b84e0-7ea7-4f31-957c-a29e5c4a5d97 | 2026-09-22 09:30 | 2026-09-22 09:30 | 2026-09-22 09:30 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 32.0000 | 32.0000 | 33.8000 | 180.2300 | 44800.00 | 0.00 | 44800.00 | 14 | 5 | 45 | 998 | 0.0450901803607214 | 0.5834390179052 | 0.5834390179052 | false | false | false | true | false | |||||||||||||||
| 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 | |||||||||||||||
| 85213595-7086-4939-933e-93f477120b95 | 2026-09-21 13:34 | 2026-09-21 13:34 | 2026-09-21 13:34 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 31.5100 | 31.2000 | 32.3000 | 180.2300 | 28355.00 | 3150.00 | 25205.00 | 9 | 5 | 876 | 0 | 0 | 0.564717506832653 | 0.563017343304562 | false | false | false | true | false | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 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 | |||||||||||||||
| 026711b8-8cbc-48a6-bb10-f6b9ae37c61e | 2026-09-21 12:16 | 2026-09-21 12:16 | 2026-09-21 12:16 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 32.1600 | 31.9000 | 32.3000 | 181.5599 | 32160.00 | 32160.00 | 0.00 | 10 | 5 | 336 | 0 | 0 | 0.550172713941821 | 0.553620883593748 | false | false | false | true | false | |||||||||||||||
| 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 | |||||||||||||||
| ea82223b-3ea4-4596-8bd3-ca0132671327 | 2026-09-21 12:06 | 2026-09-21 12:05 | 2026-09-21 12:05 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 30.1300 | 29.2000 | 30.2000 | 180.2300 | 54230.00 | 51230.00 | 3000.00 | 18 | 12 | 95 | 0 | 0 | 0.518416972936371 | 0.518416972936371 | false | false | false | true | false | |||||||||||||||
| ae77c272-a313-4f73-acfe-5d5455c86513 | 2026-09-21 12:06 | 2026-09-21 12:05 | 2026-09-21 12:05 | RGEN | RGEN261218C00160000 | call | 160.0000 | 2026-12-18 | 30.0900 | 29.2000 | 30.2000 | 180.2300 | 57170.00 | 57170.00 | 0.00 | 19 | 12 | 77 | 0 | 0 | 0.508000873211679 | 0.518416972936371 | true | false | false | true | false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10539352222.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 10539352222.00 |
| 2026-10-27 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:30:37.895663Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:34:20.106500Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| 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 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:07:39.472771Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:07:39.472771Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |