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 |
|---|
| 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 |
|---|
| 329f492a-7c57-4e1a-bd16-6c20cf47e3c4 | 2026-09-16 10:00 | 2026-09-16 10:00 | 2026-09-16 10:00 | GMAB | GMAB270219P00035000 | put | 35.0000 | 2027-02-19 | 4.6600 | 3.1000 | 4.8000 | 34.3100 | 18641.00 | 18641.00 | 0.00 | 40 | 9 | 40 | 79 | 0.506329113924051 | 0.51188443797465 | 0.51188443797465 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | ADR | Healthcare | 22098012352.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 5bb2bcbe-602e-4380-8184-0de80c3ce8c9 | 2026-09-10 12:34 | 2026-09-10 12:34 | 2026-09-10 12:34 | GMAB | GMAB270115C00040000 | call | 40.0000 | 2027-01-15 | 1.8300 | 1.5000 | 1.9000 | 32.3100 | 52609.00 | 29674.00 | 7765.00 | 287 | 44 | 294 | 3670 | 0.0801089918256131 | 0.538324316808957 | 0.543785449473917 | true | false | false | |||||||||||||||||
| 5a6126d6-ec0c-42fe-90da-ab4a748c81d8 | 2026-09-10 11:06 | 2026-09-10 11:06 | 2026-09-10 11:06 | GMAB | GMAB270219P00030000 | put | 30.0000 | 2027-02-19 | 3.0900 | 2.5500 | 3.2000 | 32.4100 | 15460.00 | 15460.00 | 0.00 | 50 | 17 | 367 | 879 | 0.417519908987486 | 0.53504199924977 | 0.53504199924977 | false | false | false | |||||||||||||||||
| 4a143d2e-f53e-42bb-acec-ff99b7638341 | 2026-09-02 14:56 | 2026-09-02 14:55 | 2026-09-02 14:55 | GMAB | GMAB261218P00035000 | put | 35.0000 | 2026-12-18 | 4.1900 | 3.9000 | 4.2000 | 34.1700 | 20964.00 | 20964.00 | 0.00 | 50 | 10 | 60 | 68 | 0.882352941176471 | 0.534250104114124 | 0.534250104114124 | false | false | false | |||||||||||||||||
| ebae93b6-54b8-44b6-a84f-ae952d75fdf1 | 2026-09-02 10:09 | 2026-09-02 10:09 | 2026-09-02 10:09 | GMAB | GMAB270115C00035000 | call | 35.0000 | 2027-01-15 | 3.9200 | 3.4000 | 4.1000 | 33.8600 | 40017.00 | 39617.00 | 400.00 | 102 | 23 | 107 | 2688 | 0.0398065476190476 | 0.505704710707706 | 0.521513656944234 | false | false | false | |||||||||||||||||
| d92572e5-cbfd-4851-b940-9b4f8e7f7e06 | 2026-08-25 10:12 | 2026-08-25 10:12 | 2026-08-25 10:12 | GMAB | GMAB270115C00045000 | call | 45.0000 | 2027-01-15 | 1.2900 | 0.6000 | 1.3500 | 34.0000 | 56045.00 | 56045.00 | 0.00 | 433 | 24 | 479 | 228 | 2.10087719298246 | 0.486938594090953 | 0.494686399890389 | false | false | false | |||||||||||||||||
| 533496e9-37a7-42ea-b5c4-c8263250fc41 | 2026-08-21 15:03 | 2026-08-21 15:03 | 2026-08-21 15:03 | GMAB | GMAB270219C00035000 | call | 35.0000 | 2027-02-19 | 4.4800 | 3.7000 | 4.5000 | 33.3200 | 67212.00 | 67212.00 | 0.00 | 150 | 18 | 166 | 188 | 0.882978723404255 | 0.513995222347478 | 0.525777426897208 | false | false | false | |||||||||||||||||
| 32c5e182-0d57-431d-9ff6-aa2080f5a7b3 | 2026-08-21 14:54 | 2026-08-21 14:54 | 2026-08-21 14:54 | GMAB | GMAB260918C00035000 | call | 35.0000 | 2026-09-18 | 1.0000 | 0.9500 | 1.4000 | 33.3600 | 18811.00 | 0.00 | 18611.00 | 188 | 34 | 293 | 1265 | 0.231620553359684 | 0.438584978148017 | 0.439662634963227 | false | false | false | |||||||||||||||||
| 26b31f01-ad50-48cc-bc22-44ae0c5b40ea | 2026-08-20 12:08 | 2026-08-20 12:08 | 2026-08-20 12:08 | GMAB | GMAB261120C00035000 | call | 35.0000 | 2026-11-20 | 3.0900 | 2.7000 | 3.1000 | 33.5000 | 123655.00 | 123655.00 | 0.00 | 400 | 20 | 621 | 346 | 1.79479768786127 | 0.514111486107426 | 0.53646742306342 | false | false | false | |||||||||||||||||
| 3241d3d3-61b3-4cc2-8768-d0ca695ce426 | 2026-08-20 10:49 | 2026-08-20 10:49 | 2026-08-20 10:49 | GMAB | GMAB270115P00035000 | put | 35.0000 | 2027-01-15 | 5.1000 | 5.0000 | 5.1000 | 33.3700 | 39810.00 | 39810.00 | 0.00 | 78 | 14 | 175 | 137 | 1.27737226277372 | 0.529856681263504 | 0.529856681263504 | true | false | false | |||||||||||||||||
| 5945ebb5-9f2a-47a8-af4e-519b6c4f2313 | 2026-08-20 10:36 | 2026-08-20 10:36 | 2026-08-20 10:36 | GMAB | GMAB270115P00030000 | put | 30.0000 | 2027-01-15 | 2.5800 | 2.3000 | 2.6000 | 33.3650 | 34250.00 | 34250.00 | 0.00 | 133 | 18 | 199 | 40 | 4.975 | 0.518567622115464 | 0.534880439641325 | false | false | false | |||||||||||||||||
| 97d92147-ba50-48bd-9e31-a0e69f498d5a | 2026-08-20 10:36 | 2026-08-20 10:36 | 2026-08-20 10:36 | GMAB | GMAB270115P00030000 | put | 30.0000 | 2027-01-15 | 2.5200 | 2.3000 | 2.6000 | 33.3750 | 12580.00 | 12580.00 | 0.00 | 50 | 7 | 66 | 40 | 1.65 | 0.518970755834834 | 0.535285132965585 | false | false | false | |||||||||||||||||
| b3310a70-069e-4a12-9c57-12d890058252 | 2026-08-20 10:27 | 2026-08-20 10:26 | 2026-08-20 10:26 | GMAB | GMAB261218P00030000 | put | 30.0000 | 2026-12-18 | 2.2500 | 1.9500 | 2.2500 | 33.6900 | 68780.00 | 68780.00 | 0.00 | 306 | 38 | 312 | 137 | 2.27737226277372 | 0.532633659553894 | 0.54942712096044 | false | false | false | |||||||||||||||||
| e413de47-932c-4744-9656-8aac8faca5c7 | 2026-08-19 15:31 | 2026-08-19 15:31 | 2026-08-19 15:31 | GMAB | GMAB261120C00035000 | call | 35.0000 | 2026-11-20 | 3.3900 | 2.2500 | 3.4000 | 34.0700 | 67715.00 | 67715.00 | 0.00 | 200 | 17 | 262 | 159 | 1.64779874213836 | 0.506465313644302 | 0.534219993751105 | false | false | false | |||||||||||||||||
| 3d265aec-6960-4b00-9d31-f203ede18d49 | 2026-08-19 14:50 | 2026-08-19 14:50 | 2026-08-19 14:50 | GMAB | GMAB270115C00030000 | call | 30.0000 | 2027-01-15 | 6.7500 | 6.1000 | 6.9000 | 33.8600 | 79696.00 | 79696.00 | 0.00 | 118 | 20 | 134 | 971 | 0.138002059732235 | 0.517569859412914 | 0.533984363495489 | false | false | false | |||||||||||||||||
| cae2fc1a-8196-400a-9c97-ef2e68d20d1d | 2026-08-19 13:21 | 2026-08-19 13:21 | 2026-08-19 13:21 | GMAB | GMAB261218C00040000 | call | 40.0000 | 2026-12-18 | 1.9500 | 1.7000 | 2.0000 | 33.6100 | 12281.00 | 776.00 | 11505.00 | 63 | 5 | 99 | 641 | 0.154446177847114 | 0.508629816988736 | 0.510034344241425 | false | false | false | |||||||||||||||||
| 37c9daff-8fda-404d-a107-33e7fc119176 | 2026-08-17 15:23 | 2026-08-17 15:23 | 2026-08-17 15:23 | GMAB | GMAB270115C00035000 | call | 35.0000 | 2027-01-15 | 3.9800 | 3.6000 | 4.6000 | 32.8900 | 48560.00 | 4000.00 | 44560.00 | 122 | 6 | 147 | 2357 | 0.0623674162070429 | 0.526716759530093 | 0.527021271928632 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T16:37:06.868856Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T19:08:56.003529Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T14:11:00.326314Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-25T14:28:24.156188Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T19:11:44.414359Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:19:11.314726Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:02:58.462752Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| ADR |
| Healthcare |
| 20973840212.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-17T19:39:36.389012Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |