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_alerts326,449 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 |
|---|
| 8a315edc-0bf5-4f11-982c-e0858aef21be | 2026-09-14 15:51 | 2026-09-14 15:50 | 2026-09-14 15:50 | BBWI | BBWI261218P00015000 | put | 15.0000 | 2026-12-18 | 0.8000 | 0.6000 | 0.8000 | 17.0000 | 15280.00 | 15280.00 | 0.00 | 191 | 10 | 197 | 1748 | 0.112700228832952 | 0.599473108798333 | 0.599473108798333 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Cyclical | 3611467556.00 | 2026-11-19 | 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 |
| ffbd9bf3-1df6-48ac-a88f-a612465e8fdc | 2026-09-14 15:56 | 2026-09-14 15:56 | 2026-09-14 15:56 | BBWI | BBWI261218P00015000 | put | 15.0000 | 2026-12-18 | 0.8000 | 0.7000 | 0.8000 | 17.0000 | 18640.00 | 18640.00 | 0.00 | 233 | 6 | 430 | 1748 | 0.245995423340961 | 0.597454878507385 | 0.597252712606564 | false | false | false | true | false | |||||||||||||||
| 84129661-d367-41ff-86ed-dd2ca8f5cae6 | 2026-09-15 09:32 | 2026-09-15 09:32 | 2026-09-15 09:32 | BBWI | BBWI261218P00015000 | put | 15.0000 | 2026-12-18 | 0.8000 | 0.7500 | 0.8000 | 17.8100 | 30240.00 | 30240.00 | 0.00 | 378 | 16 | 576 | 2177 | 0.264584290307763 | 0.588666643781125 | 0.588666643781125 | false | false | false | true | false | |||||||||||||||
| 7fba2210-6f33-42d1-aff3-c0a44a362f2a | 2026-09-15 13:46 | 2026-09-15 13:46 | 2026-09-15 13:46 | BBWI | BBWI261016P00015000 | put | 15.0000 | 2026-10-16 | 0.3500 | 0.3000 | 0.4000 | 16.7142 | 14075.00 | 0.00 | 14075.00 | 403 | 21 | 433 | 681 | 0.63582966226138 | 0.525864832563513 | 0.540620811818177 | true | false | false | true | false | |||||||||||||||
| 887f617a-3be1-44c0-91ca-f326cc64da1f | 2026-09-15 14:41 | 2026-09-15 14:41 | 2026-09-15 14:41 | BBWI | BBWI260925C00016500 | call | 16.5000 | 2026-09-25 | 0.7500 | 0.6500 | 0.7500 | 16.6600 | 75000.00 | 75000.00 | 0.00 | 1000 | 1 | 1000 | 0 | 0 | 0.601266479581307 | 0.601266479581307 | false | true | false | true | true | |||||||||||||||
| 7608361f-c5b9-4ab8-892c-58af73bc5ef7 | 2026-09-16 14:39 | 2026-09-16 14:39 | 2026-09-16 14:39 | BBWI | BBWI260918C00017000 | call | 17.0000 | 2026-09-18 | 0.4000 | 0.4000 | 0.5500 | 17.1600 | 13846.00 | 0.00 | 13846.00 | 346 | 33 | 615 | 5566 | 0.110492274523895 | 0.617402598656984 | 0.617402598656984 | true | false | false | true | false | |||||||||||||||
| 8221da20-dc46-433d-be16-86c0680aba60 | 2026-09-17 10:42 | 2026-09-17 10:42 | 2026-09-17 10:42 | BBWI | BBWI260918C00017000 | call | 17.0000 | 2026-09-18 | 0.1500 | 0.1000 | 0.2000 | 16.8400 | 12285.00 | 3015.00 | 6960.00 | 819 | 7 | 2002 | 4904 | 0.408238172920065 | 0.623101747179186 | 0.623101747179186 | true | false | false | true | false | |||||||||||||||
| f712af73-21b2-492f-9c0a-9426d2c41be8 | 2026-09-17 14:19 | 2026-09-17 14:19 | 2026-09-17 14:19 | BBWI | BBWI260925C00017000 | call | 17.0000 | 2026-09-25 | 0.6300 | 0.5000 | 0.6500 | 17.1200 | 126000.00 | 126000.00 | 0.00 | 2000 | 2 | 2059 | 82 | 25.109756097561 | 0.526268239721465 | 0.526268239721465 | false | true | false | true | true | |||||||||||||||
| a775359a-7c71-412f-8bf1-181819c6abd0 | 2026-09-18 09:42 | 2026-09-18 09:41 | 2026-09-18 09:41 | BBWI | BBWI260918C00017000 | call | 17.0000 | 2026-09-18 | 0.5000 | 0.4000 | 0.8000 | 17.4701 | 42460.00 | 29400.00 | 13060.00 | 849 | 25 | 850 | 5328 | 0.159534534534535 | 0.832185745610616 | 0.926116806515764 | false | false | false | true | false | |||||||||||||||
| b51ca49b-8e7e-4b0d-a32b-2ecec0bea8ed | 2026-09-18 09:55 | 2026-09-18 09:55 | 2026-09-18 09:55 | BBWI | BBWI261002C00017000 | call | 17.0000 | 2026-10-02 | 1.0500 | 0.8500 | 1.1000 | 17.5100 | 80010.00 | 67830.00 | 12180.00 | 762 | 37 | 767 | 5 | 153.4 | 0.592038147436909 | 0.558446654331012 | true | false | false | true | false | |||||||||||||||
| cf0a41e5-7f70-4a3c-bb6c-cff92ea03d5e | 2026-09-18 09:55 | 2026-09-18 09:55 | 2026-09-18 09:55 | BBWI | BBWI261016C00017500 | call | 17.5000 | 2026-10-16 | 1.2500 | 1.1000 | 1.2500 | 17.7200 | 22000.00 | 22000.00 | 0.00 | 176 | 9 | 333 | 101 | 3.2970297029703 | 0.570912463465419 | 0.570912463465419 | true | false | false | true | false | |||||||||||||||
| 4673de3c-5ca3-4346-9103-4f2808f37a70 | 2026-09-18 09:55 | 2026-09-18 09:55 | 2026-09-18 09:55 | BBWI | BBWI261016C00017500 | call | 17.5000 | 2026-10-16 | 1.2500 | 1.1000 | 1.2500 | 17.7200 | 19250.00 | 19250.00 | 0.00 | 154 | 19 | 157 | 101 | 1.55445544554455 | 0.570912463465419 | 0.570912463465419 | true | false | false | true | false | |||||||||||||||
| 5d931adb-5f73-43c9-a500-243c74bf9570 | 2026-09-18 09:56 | 2026-09-18 09:56 | 2026-09-18 09:56 | BBWI | BBWI260925C00018000 | call | 18.0000 | 2026-09-25 | 0.5500 | 0.3000 | 0.5500 | 17.7300 | 22000.00 | 22000.00 | 0.00 | 400 | 19 | 414 | 1511 | 0.273990734612839 | 0.67972240618847 | 0.67972240618847 | true | false | false | true | false | |||||||||||||||
| 060973a4-b653-41f7-ba2e-4b203f787fca | 2026-09-21 15:38 | 2026-09-21 15:38 | 2026-09-21 15:38 | BBWI | BBWI261002C00017500 | call | 17.5000 | 2026-10-02 | 0.5500 | 0.5000 | 0.5500 | 17.1350 | 22000.00 | 22000.00 | 0.00 | 400 | 23 | 416 | 81 | 5.1358024691358 | 0.591613745091245 | 0.591613745091245 | true | false | false | true | false | |||||||||||||||
| 1c6b778a-4045-4e30-9c66-b0019dd8478c | 2026-09-22 09:43 | 2026-09-22 09:43 | 2026-09-22 09:43 | BBWI | BBWI260925C00017000 | call | 17.0000 | 2026-09-25 | 0.6000 | 0.4500 | 0.6000 | 17.0000 | 30000.00 | 240.00 | 0.00 | 500 | 69 | 500 | 2032 | 0.246062992125984 | 0.645158182955985 | 0.645158182955985 | false | false | false | true | false |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3611467556.00 |
| 2026-11-19 |
| 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 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3611467556.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T13:35:39.189623Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3611467556.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| d9769fb4-003b-49e4-9181-c78c9cc101f5 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3611467556.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3373526086.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:44:45.237115Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3466282930.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T14:48:09.438351Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3466282930.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3508628446.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3508628446.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3508628446.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3508628446.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3508628446.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3409822243.00 |
| 2026-11-19 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 3464266477.00 |
| 2026-11-19 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:45:11.876123Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |