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_alerts609,118 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 |
|---|
| 7f0acbb9-a538-43ab-83cc-093c04e2b47e | 2026-09-29 12:14 | 2026-09-29 12:14 | 2026-09-29 12:14 | AEO | AEO261016C00017000 | call | 17.0000 | 2026-10-16 | 0.9500 | 0.9500 | 1.0000 | 17.0000 | 19097.00 | 0.00 | 19097.00 | 201 | 16 | 753 | 2312 | 0.325692041522491 | 0.407319155044806 | 0.42179298906943 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Cyclical | 3039780261.00 | 2026-12-01 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T16:14:29.710858Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| e149d7ed-f9de-4f9f-8b05-80bdaad0c39f | 2026-09-11 09:39 | 2026-09-11 09:39 | 2026-09-11 09:39 | AEO | AEO260918C00014500 | call | 14.5000 | 2026-09-18 | 0.5500 | 0.4500 | 0.6600 | 14.7600 | 11018.00 | 1870.00 | 9148.00 | 200 | 8 | 200 | 334 | 0.598802395209581 | 0.52282522731339 | 0.533955908764491 | false | false | false | |||||||||||||||||
| 7b5a5de1-bf9f-4781-b2f6-a018288a5888 | 2026-09-10 14:23 | 2026-09-10 14:23 | 2026-09-10 14:23 | AEO | AEO261120C00015000 | call | 15.0000 | 2026-11-20 | 0.8400 | 0.8000 | 0.8400 | 14.1650 | 14278.00 | 14195.00 | 83.00 | 170 | 32 | 1388 | 11203 | 0.123895385164688 | 0.453654545101922 | 0.457711420512288 | false | false | false | |||||||||||||||||
| a3bd4cae-78d1-427b-aed2-386100e586b6 | 2026-09-10 10:21 | 2026-09-10 10:21 | 2026-09-10 10:21 | AEO | AEO261016C00016000 | call | 16.0000 | 2026-10-16 | 0.4800 | 0.4500 | 0.4800 | 14.9200 | 15990.00 | 15990.00 | 0.00 | 334 | 13 | 364 | 355 | 1.02535211267606 | 0.460556386701224 | 0.460354787500897 | false | false | false | |||||||||||||||||
| a24d9a9a-6e09-40b4-a910-8cb24b9a4766 | 2026-09-09 15:06 | 2026-09-09 15:06 | 2026-09-09 15:06 | AEO | AEO260911C00017000 | call | 17.0000 | 2026-09-11 | 1.2900 | 1.2500 | 1.3000 | 17.1850 | 25416.00 | 18579.00 | 1419.00 | 197 | 21 | 3233 | 2107 | 1.5344091124822 | 2.36750388042404 | 2.38743364642234 | false | false | false | |||||||||||||||||
| fa0d8e85-4f15-464f-9f54-6e168110b68a | 2026-09-09 14:49 | 2026-09-09 14:49 | 2026-09-09 14:49 | AEO | AEO260911C00019000 | call | 19.0000 | 2026-09-11 | 0.5600 | 0.5100 | 0.6000 | 17.1650 | 165193.00 | 165032.00 | 161.00 | 2950 | 5 | 4047 | 1268 | 3.1916403785489 | 2.31910772887413 | 2.31910772887413 | false | false | false | |||||||||||||||||
| 6637c2bb-450d-4691-8764-7d25c2b7820e | 2026-09-04 10:35 | 2026-09-04 10:35 | 2026-09-04 10:35 | AEO | AEO261016P00017000 | put | 17.0000 | 2026-10-16 | 1.6000 | 1.5900 | 1.6600 | 16.9600 | 32586.00 | 23840.00 | 8746.00 | 204 | 22 | 214 | 104 | 2.05769230769231 | 0.703056679863418 | 0.707449827113697 | false | false | false | |||||||||||||||||
| 89bd8a8c-479b-43f1-980e-8ccd1287aac7 | 2026-09-04 09:59 | 2026-09-04 09:59 | 2026-09-04 09:59 | AEO | AEO260911C00018000 | call | 18.0000 | 2026-09-11 | 0.8800 | 0.8700 | 0.8900 | 17.0000 | 10638.00 | 0.00 | 10550.00 | 121 | 13 | 545 | 660 | 0.825757575757576 | 1.35209086678177 | 1.36296688796753 | false | false | false | |||||||||||||||||
| 6f0cb3a5-5ae3-4ff3-933f-9b9529e14ea5 | 2026-09-03 14:16 | 2026-09-03 14:16 | 2026-09-03 14:16 | AEO | AEO261120C00015000 | call | 15.0000 | 2026-11-20 | 3.0400 | 2.9300 | 3.0500 | 17.0600 | 597806.00 | 597507.00 | 299.00 | 1968 | 62 | 5260 | 322 | 16.3354037267081 | 0.596279256314777 | 0.596777634953523 | false | false | false | |||||||||||||||||
| 75b3ec03-d18d-452c-9a3e-4ddd288c5076 | 2026-08-26 12:43 | 2026-08-26 12:43 | 2026-08-26 12:43 | AEO | AEO260918C00017500 | call | 17.5000 | 2026-09-18 | 1.5000 | 1.4200 | 1.5200 | 17.5500 | 747154.00 | 745821.00 | 297.00 | 4985 | 45 | 5715 | 156 | 36.6346153846154 | 0.821479852505733 | 0.830806461707513 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T18:37:18.479310Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T14:21:23.599560Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T18:58:33.363095Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:44:26.340635Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T18:47:01.806289Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 2585656528.00 |
| 2026-12-01 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |