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_alerts474,253 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 | price |
|---|
| 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 |
|---|
| e55a71c3-9bcb-4f26-adfc-39c1d8302bfe | 2026-09-14 11:05 | 2026-09-14 11:05 | 2026-09-14 11:05 | HNGE | HNGE260918C00095000 | call | 95.0000 | 2026-09-18 | 1.5000 | 1.3500 | 1.5000 | 92.5650 | 11700.00 | 11700.00 | 0.00 | 78 | 12 | 917 | 3535 | 0.259405940594059 | 0.643204889847782 | 0.643204889847782 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Healthcare | 5921410064.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T15:20:09.779343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cbf91045-48ba-41c2-a01f-1788245d138e | 2026-09-14 12:06 | 2026-09-14 12:06 | 2026-09-14 12:06 | HNGE | HNGE260918P00090000 | put | 90.0000 | 2026-09-18 | 1.2500 | 1.2500 | 1.4000 | 92.9304 | 17250.00 | 0.00 | 17250.00 | 138 | 44 | 229 | 1196 | 0.191471571906355 | 0.642778718226291 | 0.642778718226291 | true | false | false | true | false | |||||||||||||||
| b0109011-5ea4-4645-b149-415e96ce8fea | 2026-09-14 12:13 | 2026-09-14 12:13 | 2026-09-14 12:13 | HNGE | HNGE260918P00090000 | put | 90.0000 | 2026-09-18 | 1.2500 | 1.2500 | 1.4500 | 93.1500 | 66375.00 | 0.00 | 66375.00 | 531 | 11 | 978 | 1196 | 0.817725752508361 | 0.652069094056735 | 0.662203719017317 | true | false | false | true | false | |||||||||||||||
| aeb4f634-035f-40af-9557-414905c7afa5 | 2026-09-14 14:39 | 2026-09-14 14:39 | 2026-09-14 14:39 | HNGE | HNGE261016C00100000 | call | 100.0000 | 2026-10-16 | 3.8000 | 3.8000 | 3.9000 | 93.1450 | 12935.00 | 0.00 | 11780.00 | 34 | 13 | 920 | 341 | 2.69794721407625 | 0.580298352177182 | 0.575532244114406 | false | false | false | true | false | |||||||||||||||
| ff0b2077-8d6e-47dc-b1c4-9ad8f2918632 | 2026-09-14 15:38 | 2026-09-14 15:38 | 2026-09-14 15:38 | HNGE | HNGE260918C00100000 | call | 100.0000 | 2026-09-18 | 0.7400 | 0.6500 | 0.8000 | 94.3600 | 15100.00 | 15100.00 | 0.00 | 204 | 26 | 2157 | 3209 | 0.672172016204425 | 0.67008320152996 | 0.65680952898916 | false | false | false | true | false | |||||||||||||||
| f45d42e7-d505-4f4c-94f4-60a7caba5585 | 2026-09-14 15:39 | 2026-09-14 15:39 | 2026-09-14 15:39 | HNGE | HNGE260918C00090000 | call | 90.0000 | 2026-09-18 | 5.4000 | 5.4000 | 6.0000 | 94.5350 | 21600.00 | 0.00 | 21600.00 | 40 | 5 | 159 | 1001 | 0.158841158841159 | 0.640770962485021 | 0.640770962485021 | false | false | false | true | false | |||||||||||||||
| 9215f816-cd20-4bc8-b636-b824ac9bd5c2 | 2026-09-14 15:59 | 2026-09-14 15:59 | 2026-09-14 15:59 | HNGE | HNGE261218C00110000 | call | 110.0000 | 2026-12-18 | 7.3300 | 6.8000 | 7.5000 | 94.0000 | 19048.00 | 19048.00 | 0.00 | 26 | 12 | 32 | 96 | 0.333333333333333 | 0.643829794540502 | 0.643829794540502 | false | false | false | true | false | |||||||||||||||
| 53efc781-d9d9-49f1-bd71-0a70c897b468 | 2026-09-15 12:15 | 2026-09-15 12:15 | 2026-09-15 12:15 | HNGE | HNGE260918C00095000 | call | 95.0000 | 2026-09-18 | 2.0000 | 1.7500 | 2.2500 | 94.5100 | 123024.00 | 212.00 | 122812.00 | 615 | 47 | 1060 | 2437 | 0.434961017644645 | 0.648583025513888 | 0.683732963015344 | false | false | false | true | false | |||||||||||||||
| 11a1359b-d963-4cac-a9de-08b041c93f3d | 2026-09-15 15:38 | 2026-09-15 15:37 | 2026-09-15 15:37 | HNGE | HNGE260918C00085000 | call | 85.0000 | 2026-09-18 | 8.4000 | 8.4000 | 10.0000 | 93.2200 | 41162.00 | 0.00 | 41162.00 | 49 | 11 | 60 | 419 | 0.143198090692124 | 0.672894402177927 | 0.672894402177927 | false | false | false | true | false | |||||||||||||||
| 113d036b-0c91-49d5-a227-23c8ad71e2b6 | 2026-09-16 12:02 | 2026-09-16 12:01 | 2026-09-16 12:01 | HNGE | HNGE261016C00095000 | call | 95.0000 | 2026-10-16 | 6.2000 | 6.1000 | 6.3000 | 94.6450 | 70060.00 | 3720.00 | 65100.00 | 113 | 12 | 217 | 969 | 0.223942208462332 | 0.57550409134402 | 0.57550409134402 | false | false | false | true | false | |||||||||||||||
| 39d0c64a-1994-46ea-833a-16dcf12f1ffc | 2026-09-16 12:09 | 2026-09-16 12:09 | 2026-09-16 12:09 | HNGE | HNGE261016C00095000 | call | 95.0000 | 2026-10-16 | 6.0100 | 6.0000 | 6.4000 | 94.2900 | 10215.00 | 0.00 | 10215.00 | 17 | 12 | 244 | 969 | 0.251805985552116 | 0.574308131821542 | 0.57895201335897 | false | false | false | true | false | |||||||||||||||
| 06002062-2768-4595-9193-adc9369ebcec | 2026-09-17 09:53 | 2026-09-17 09:53 | 2026-09-17 09:53 | HNGE | HNGE261016C00095000 | call | 95.0000 | 2026-10-16 | 6.0000 | 6.0000 | 6.3000 | 94.5500 | 79800.00 | 0.00 | 79800.00 | 133 | 9 | 177 | 1021 | 0.173359451518119 | 0.571581813030444 | 0.571581813030444 | false | false | false | true | false | |||||||||||||||
| f8d30dd3-7ac3-4ffc-aee5-5132696969cb | 2026-09-17 10:28 | 2026-09-17 10:28 | 2026-09-17 10:28 | HNGE | HNGE261016C00095000 | call | 95.0000 | 2026-10-16 | 6.6900 | 6.0000 | 6.7000 | 95.7500 | 12040.00 | 12040.00 | 0.00 | 18 | 10 | 230 | 1021 | 0.225269343780607 | 0.578338771905633 | 0.576046032419576 | false | false | false | true | false | |||||||||||||||
| d893383e-b276-489d-abfa-cd93bef0c07c | 2026-09-18 14:12 | 2026-09-18 14:12 | 2026-09-18 14:12 | HNGE | HNGE261218C00100000 | call | 100.0000 | 2026-12-18 | 10.6000 | 10.6000 | 11.0000 | 95.4500 | 16960.00 | 0.00 | 16960.00 | 16 | 5 | 232 | 365 | 0.635616438356164 | 0.636504448530402 | 0.636504448530402 | false | false | false | true | false | |||||||||||||||
| 22aa99e5-6279-4db9-ba46-dd948d94fb77 | 2026-09-18 14:12 | 2026-09-18 14:12 | 2026-09-18 14:12 | HNGE | HNGE261016C00105000 | call | 105.0000 | 2026-10-16 | 2.5100 | 2.3000 | 2.7000 | 95.4500 | 18840.00 | 4590.00 | 14250.00 | 75 | 15 | 227 | 106 | 2.14150943396226 | 0.547563306133948 | 0.545684945548273 | false | false | false | true | false | |||||||||||||||
| fe2d1255-f2f1-46b9-9179-b7e8de59e0d2 | 2026-09-22 12:52 | 2026-09-22 12:52 | 2026-09-22 12:52 | HNGE | HNGE261016C00095000 | call | 95.0000 | 2026-10-16 | 4.2000 | 4.2000 | 4.4000 | 92.7500 | 233100.00 | 0.00 | 233100.00 | 555 | 39 | 580 | 991 | 0.585267406659939 | 0.536328626731529 | 0.536328626731529 | false | false | false | true | false | |||||||||||||||
| 988261ad-fab0-4d96-95c0-ec743734772b | 2026-09-23 09:42 | 2026-09-23 09:42 | 2026-09-23 09:42 | HNGE | HNGE261218C00085000 | call | 85.0000 | 2026-12-18 | 16.4000 | 16.0000 | 17.2000 | 94.0700 | 29515.00 | 0.00 | 29515.00 | 18 | 9 | 28 | 200 | 0.14 | 0.63115615422097 | 0.62174100929133 | false | false | false | true | false | |||||||||||||||
| f0e353dd-3c68-44a8-ac8c-9c0d09b40f99 | 2026-09-24 12:09 | 2026-09-24 12:09 | 2026-09-24 12:09 | HNGE | HNGE261218C00095000 | call | 95.0000 | 2026-12-18 | 9.5000 | 9.5000 | 11.1000 | 91.0000 | 35150.00 | 0.00 | 35150.00 | 37 | 10 | 37 | 456 | 0.081140350877193 | 0.597001176727557 | 0.597001176727557 | false | false | false | true | false | |||||||||||||||
| 15eab0fa-9519-483d-9421-cacca530109b | 2026-09-24 12:09 | 2026-09-24 12:09 | 2026-09-24 12:09 | HNGE | HNGE261218C00100000 | call | 100.0000 | 2026-12-18 | 7.7000 | 7.6000 | 9.4000 | 91.0000 | 23110.00 | 0.00 | 23110.00 | 30 | 10 | 30 | 661 | 0.0453857791225416 | 0.599915166564844 | 0.605618485983725 | false | false | false | true | false | |||||||||||||||
| 2fed158a-97da-457d-94d6-ec37a63edca7 | 2026-09-24 14:40 | 2026-09-24 14:40 | 2026-09-24 14:40 | HNGE | HNGE261016P00090000 | put | 90.0000 | 2026-10-16 | 3.6000 | 3.3000 | 3.6000 | 92.4700 | 215280.00 | 215280.00 | 0.00 | 598 | 35 | 615 | 128 | 4.8046875 | 0.540987167806151 | 0.540987167806151 | false | false | false | true | false | |||||||||||||||
| 03b9e2e4-9d54-481c-9610-4647ad46413b | 2026-09-24 15:38 | 2026-09-24 15:38 | 2026-09-24 15:38 | HNGE | HNGE270319P00085000 | put | 85.0000 | 2027-03-19 | 10.9000 | 10.1000 | 10.9000 | 92.0000 | 41420.00 | 41420.00 | 0.00 | 38 | 8 | 44 | 41 | 1.07317073170732 | 0.618484807563428 | 0.618484807563428 | false | false | false | true | false | |||||||||||||||
| 037a1aea-c70e-4ef7-b249-3a8fce6cfe64 | 2026-09-25 15:14 | 2026-09-25 15:14 | 2026-09-25 15:14 | HNGE | HNGE261218P00090000 | put | 90.0000 | 2026-12-18 | 7.3000 | 7.2000 | 9.2000 | 95.9650 | 365000.00 | 14600.00 | 321930.00 | 500 | 39 | 500 | 1518 | 0.329380764163373 | 0.587261482413894 | 0.587261482413894 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5921410064.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5921410064.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5921410064.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:49:41.095224Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5921410064.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5921410064.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 5921410064.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 5921410064.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 5921410064.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5855193219.00 |
| 2026-11-03 |
| 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 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 5855193219.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T16:35:37.886334Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5917037253.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:57:31.198579Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Healthcare |
| 5917037253.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5928281623.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5928281623.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5881430082.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:59:26.444099Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Healthcare |
| 5764613574.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T13:43:47.947765Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5764613574.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:13:55.044964Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5764613574.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:13:55.044964Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5764613574.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:42:17.809304Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5764613574.00 |
| 2026-11-03 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Healthcare |
| 5970135666.00 |
| 2026-11-03 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:17:13.698421Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |