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_alerts375,978 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 |
|---|
| f9fcee17-7da1-4da8-bbaa-ee6779e684b7 | 2026-09-23 13:57 | 2026-09-23 13:57 | 2026-09-23 13:57 | WYNN | WYNN261120C00095000 | call | 95.0000 | 2026-11-20 | 1.1400 | 0.9000 | 1.1400 | 81.7200 | 14929.00 | 14364.00 | 565.00 | 131 | 33 | 131 | 1517 | 0.0863546473302571 | 0.372607716890907 | 0.37049760612171 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 8387223422.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-23T18:00:02.240433Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| 3bb40224-d8b8-4b18-ae26-3e2acd62dfad | 2026-09-17 15:49 | 2026-09-17 15:49 | 2026-09-17 15:49 | WYNN | WYNN270115C00087500 | call | 87.5000 | 2027-01-15 | 5.6000 | 5.2000 | 5.6000 | 83.1360 | 371275.00 | 371275.00 | 0.00 | 663 | 47 | 667 | 90 | 7.41111111111111 | 0.365288555559934 | 0.365288555559934 | false | false | false | |||||||||||||||||
| f6ce5746-cfe8-4f89-8f5e-3c2a0edca1a1 | 2026-09-17 15:45 | 2026-09-17 15:45 | 2026-09-17 15:45 | WYNN | WYNN261016P00070000 | put | 70.0000 | 2026-10-16 | 0.2900 | 0.2000 | 0.3100 | 83.2400 | 20100.00 | 19527.00 | 573.00 | 695 | 68 | 1550 | 1584 | 0.978535353535353 | 0.428180582444966 | 0.430271323645804 | false | false | false | |||||||||||||||||
| 0b8903d3-6ccb-46e2-b2bb-44bd9e98705f | 2026-09-17 13:27 | 2026-09-17 13:27 | 2026-09-17 13:27 | WYNN | WYNN261016P00080000 | put | 80.0000 | 2026-10-16 | 1.0600 | 1.0500 | 1.2100 | 85.2200 | 10484.00 | 106.00 | 10378.00 | 99 | 26 | 129 | 977 | 0.132036847492323 | 0.328550389297225 | 0.327152971948948 | false | false | false | |||||||||||||||||
| 3a8c4e6c-8770-4a45-9ef2-6ac578a93182 | 2026-09-15 10:09 | 2026-09-15 10:09 | 2026-09-15 10:09 | WYNN | WYNN261016C00092500 | call | 92.5000 | 2026-10-16 | 1.6700 | 1.5300 | 1.6800 | 87.5500 | 24767.00 | 23495.00 | 1272.00 | 148 | 22 | 655 | 40 | 16.375 | 0.339039705103151 | 0.32735577112026 | false | false | false | |||||||||||||||||
| 05906f56-5cd8-4684-8d62-f1be8142273e | 2026-09-15 10:05 | 2026-09-15 10:05 | 2026-09-15 10:05 | WYNN | WYNN270219P00087500 | put | 87.5000 | 2027-02-19 | 7.5900 | 6.9500 | 7.8500 | 87.3400 | 37958.00 | 37958.00 | 0.00 | 50 | 5 | 50 | 501 | 0.0998003992015968 | 0.366175456280882 | 0.366175456280882 | false | false | false | |||||||||||||||||
| 9ec4ac00-196d-413b-86cd-c841a9cc111d | 2026-09-11 13:50 | 2026-09-11 13:50 | 2026-09-11 13:50 | WYNN | WYNN261218C00080000 | call | 80.0000 | 2026-12-18 | 11.4900 | 11.4000 | 11.8000 | 87.9900 | 40216.00 | 0.00 | 40216.00 | 35 | 18 | 1046 | 603 | 1.7346600331675 | 0.355225070523872 | 0.353159875315318 | false | false | false | |||||||||||||||||
| e688ec40-abe9-4bf9-b565-1d323b5148c9 | 2026-09-08 12:34 | 2026-09-08 12:34 | 2026-09-08 12:34 | WYNN | WYNN260911P00095000 | put | 95.0000 | 2026-09-11 | 3.0500 | 2.6800 | 3.0500 | 92.3550 | 85380.00 | 85380.00 | 0.00 | 280 | 39 | 296 | 52 | 5.69230769230769 | 0.401742984523795 | 0.401742984523795 | false | false | false | |||||||||||||||||
| 556c60c9-8cfb-487c-a5c1-0579ace4b3a0 | 2026-09-08 11:36 | 2026-09-08 11:35 | 2026-09-08 11:35 | WYNN | WYNN260918C00092000 | call | 92.0000 | 2026-09-18 | 2.0200 | 1.8400 | 2.3400 | 91.9400 | 21017.00 | 203.00 | 20814.00 | 104 | 12 | 110 | 86 | 1.27906976744186 | 0.33154585906024 | 0.33154585906024 | true | false | false | |||||||||||||||||
| 0c100a2e-02e4-416f-b044-09821bd16872 | 2026-09-08 11:23 | 2026-09-08 11:23 | 2026-09-08 11:23 | WYNN | WYNN261218C00092500 | call | 92.5000 | 2026-12-18 | 7.1500 | 6.7500 | 7.1500 | 92.0800 | 478311.00 | 478311.00 | 0.00 | 669 | 55 | 669 | 292 | 2.29109589041096 | 0.355994534140705 | 0.355994534140705 | false | false | false | |||||||||||||||||
| bae2c0ed-254a-4508-8fb1-0118be40a724 | 2026-09-01 15:55 | 2026-09-01 15:55 | 2026-09-01 15:55 | WYNN | WYNN270115C00115000 | call | 115.0000 | 2027-01-15 | 1.3900 | 0.5700 | 2.0500 | 90.2600 | 11790.00 | 5952.00 | 5838.00 | 85 | 7 | 236 | 8740 | 0.0270022883295194 | 0.337925050039107 | 0.330326163200192 | false | false | false | |||||||||||||||||
| 257d1d09-2a1e-4a40-93be-e3c75ce439c4 | 2026-09-01 10:19 | 2026-09-01 10:19 | 2026-09-01 10:19 | WYNN | WYNN261120C00092500 | call | 92.5000 | 2026-11-20 | 5.8500 | 5.5500 | 5.8500 | 91.1465 | 305939.00 | 305939.00 | 0.00 | 523 | 38 | 523 | 20 | 26.15 | 0.359284103078791 | 0.359284103078791 | false | false | false | |||||||||||||||||
| 8096e577-2243-4346-9863-42abeb7e5e82 | 2026-08-31 13:24 | 2026-08-31 13:23 | 2026-08-31 13:23 | WYNN | WYNN270917C00115000 | call | 115.0000 | 2027-09-17 | 6.5700 | 6.5500 | 7.0500 | 91.7050 | 26291.00 | 5985.00 | 20306.00 | 40 | 6 | 63 | 4 | 15.75 | 0.343587168347667 | 0.343301959762468 | false | false | false | |||||||||||||||||
| d0edd39d-f263-4897-81dd-d47a2cb7aa3f | 2026-08-28 10:37 | 2026-08-28 10:37 | 2026-08-28 10:37 | WYNN | WYNN280121P00095000 | put | 95.0000 | 2028-01-21 | 13.7700 | 13.6000 | 14.1000 | 95.1600 | 57840.00 | 1375.00 | 56465.00 | 42 | 10 | 191 | 401 | 0.476309226932668 | 0.380941233477344 | 0.379212285555135 | true | false | false | |||||||||||||||||
| 8b56d463-8819-4857-9303-eeb0878daa69 | 2026-08-28 09:55 | 2026-08-28 09:55 | 2026-08-28 09:55 | WYNN | WYNN261218C00110000 | call | 110.0000 | 2026-12-18 | 2.7900 | 2.2800 | 2.7900 | 95.9750 | 94570.00 | 91512.00 | 2780.00 | 339 | 37 | 339 | 744 | 0.455645161290323 | 0.333366200756252 | 0.332343877981802 | true | false | false | |||||||||||||||||
| de40958a-3741-4db9-9833-3052ee75023b | 2026-08-27 12:32 | 2026-08-27 12:32 | 2026-08-27 12:32 | WYNN | WYNN261016P00095000 | put | 95.0000 | 2026-10-16 | 3.9000 | 3.5500 | 3.9000 | 95.3200 | 140770.00 | 140770.00 | 0.00 | 361 | 40 | 375 | 350 | 1.07142857142857 | 0.306590591459084 | 0.306590591459084 | false | false | false | |||||||||||||||||
| d47fddba-765a-4e4d-9990-f10330ea201e | 2026-08-20 11:31 | 2026-08-20 11:31 | 2026-08-20 11:31 | WYNN | WYNN261120P00095000 | put | 95.0000 | 2026-11-20 | 5.1000 | 4.9000 | 5.1000 | 97.7600 | 62210.00 | 61705.00 | 505.00 | 122 | 25 | 124 | 74 | 1.67567567567568 | 0.353614141198651 | 0.350938435879247 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8542713997.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8542713997.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T19:49:49.003815Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 8542713997.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T17:42:16.071983Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T16:42:24.738421Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:43:32.720264Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T15:26:49.659255Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T13:31:29.863287Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T14:20:18.853903Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T17:45:10.653528Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T14:38:22.875878Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-28T13:57:11.446067Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T16:57:23.365599Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Consumer Cyclical |
| 9036988674.00 |
| 2026-11-05 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |