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_alerts523,327 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 |
|---|
| 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 |
|---|
| 1e33bf79-4ce8-466a-b8bc-7468b25d441d | 2026-09-28 15:13 | 2026-09-28 15:13 | 2026-09-28 15:13 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 13.7500 | 13.5500 | 13.8500 | 350.2400 | 13750.00 | 12375.00 | 1375.00 | 10 | 7 | 2432 | 6558 | 0.370844769746874 | 0.369317673713566 | 0.368963615372902 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1668717791908.00 | 2026-12-10 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T19:15:55.789711Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 22152d17-6dcd-48b3-95d0-42be499eee59 | 2026-09-28 15:12 | 2026-09-28 15:12 | 2026-09-28 15:12 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 13.7000 | 13.6500 | 13.9500 | 350.2850 | 23290.00 | 1370.00 | 21920.00 | 17 | 7 | 2337 | 6558 | 0.356358645928637 | 0.368305438584792 | 0.368305438584792 | true | false | false | |||||||||||||||||
| 1cde85f5-0ba6-4384-b0ff-ffc8e9b84634 | 2026-09-28 15:06 | 2026-09-28 15:06 | 2026-09-28 15:06 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 13.6000 | 13.4500 | 13.6000 | 350.6650 | 114232.00 | 114232.00 | 0.00 | 84 | 22 | 2223 | 6558 | 0.338975297346752 | 0.369116347209085 | 0.369116347209085 | true | false | false | |||||||||||||||||
| 0603fc88-e5c3-4584-8d53-763f3abd4920 | 2026-09-28 13:45 | 2026-09-28 13:45 | 2026-09-28 13:45 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 13.3500 | 13.3000 | 13.5500 | 351.2400 | 10680.00 | 0.00 | 9345.00 | 8 | 8 | 1009 | 6558 | 0.153857883501067 | 0.368344697909581 | 0.368344697909581 | false | false | false | |||||||||||||||||
| 64ed88c3-f7dd-445e-930c-1270ae210f49 | 2026-09-25 10:10 | 2026-09-25 10:10 | 2026-09-25 10:10 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 13.5000 | 13.4500 | 13.9000 | 351.7400 | 16200.00 | 2700.00 | 13500.00 | 12 | 11 | 47 | 6011 | 0.00781899850274497 | 0.365620897845468 | 0.365620897845468 | true | false | false | |||||||||||||||||
| 64b33e1c-1f9a-44f1-9c01-59e30f91be25 | 2026-09-24 13:46 | 2026-09-24 13:45 | 2026-09-24 13:45 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 14.3500 | 14.3500 | 14.8500 | 349.0000 | 12915.00 | 0.00 | 12915.00 | 9 | 5 | 325 | 5839 | 0.0556602157903751 | 0.364130207256233 | 0.364130207256233 | true | false | false | |||||||||||||||||
| b520eb64-4582-41ed-9b28-2ea3d09c2657 | 2026-09-24 13:28 | 2026-09-24 13:28 | 2026-09-24 13:28 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 14.3900 | 14.3500 | 14.6000 | 349.6501 | 71950.00 | 0.00 | 71950.00 | 50 | 6 | 316 | 5839 | 0.0541188559684878 | 0.364604791682406 | 0.364604791682406 | false | false | false | |||||||||||||||||
| dae5d74b-8b6a-4bda-9ea1-ac3a75477e21 | 2026-09-24 11:12 | 2026-09-24 11:11 | 2026-09-24 11:11 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 15.1500 | 14.9000 | 15.2000 | 347.0000 | 10604.00 | 7575.00 | 3029.00 | 7 | 7 | 146 | 5839 | 0.0250042815550608 | 0.362080341097575 | 0.361891166958269 | true | false | false | |||||||||||||||||
| f57b226b-c155-43dc-8426-7604c35ac926 | 2026-09-24 09:42 | 2026-09-24 09:42 | 2026-09-24 09:42 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 15.1500 | 15.1000 | 15.5000 | 348.5000 | 10605.00 | 0.00 | 10605.00 | 7 | 7 | 25 | 5839 | 0.00428155506079808 | 0.370678158413395 | 0.370678158413395 | false | false | false | |||||||||||||||||
| 220d808d-0b09-4c61-83e2-2d67b10dc470 | 2026-09-23 10:24 | 2026-09-23 10:24 | 2026-09-23 10:24 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 12.8500 | 12.8500 | 13.1000 | 355.8900 | 95090.00 | 0.00 | 95090.00 | 74 | 23 | 474 | 5581 | 0.0849310159469629 | 0.374761738762866 | 0.374761738762866 | true | false | false | |||||||||||||||||
| f6703cb9-3266-4d7e-980d-76ceb11daadb | 2026-09-23 10:18 | 2026-09-23 10:18 | 2026-09-23 10:18 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 12.7000 | 12.6500 | 12.7000 | 356.0000 | 63500.00 | 63500.00 | 0.00 | 50 | 5 | 395 | 5581 | 0.0707758466224691 | 0.374027931874848 | 0.373478917438002 | true | false | false | |||||||||||||||||
| 9892f69a-f591-4cf2-bf00-0a598c8881d5 | 2026-09-23 10:08 | 2026-09-23 10:08 | 2026-09-23 10:08 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 12.2000 | 12.2000 | 12.2000 | 357.4390 | 12200.00 | 0.00 | 0.00 | 10 | 10 | 330 | 5581 | 0.0591291883175058 | 0.37206981778735 | 0.37206981778735 | false | false | false | |||||||||||||||||
| ffb4fe07-2c59-48a5-b3aa-4bb279f810f3 | 2026-09-22 15:04 | 2026-09-22 15:03 | 2026-09-22 15:03 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 10.7500 | 10.7000 | 10.7500 | 364.5350 | 31175.00 | 31175.00 | 0.00 | 29 | 24 | 427 | 5492 | 0.0777494537509104 | 0.382891252381882 | 0.383085499214403 | true | false | false | |||||||||||||||||
| ffafa60b-277e-4fbe-a3ba-2a733d332254 | 2026-09-22 15:03 | 2026-09-22 15:03 | 2026-09-22 15:03 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 10.7500 | 10.6500 | 10.8000 | 364.5300 | 69875.00 | 68800.00 | 0.00 | 65 | 47 | 392 | 5492 | 0.0713765477057538 | 0.383056937622631 | 0.383056937622631 | true | false | false | |||||||||||||||||
| 16d50678-d7cc-46de-93b5-5e2c0b1c0c6e | 2026-09-21 14:47 | 2026-09-21 14:47 | 2026-09-21 14:47 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 11.8000 | 11.6500 | 11.8000 | 361.0000 | 42471.00 | 42471.00 | 0.00 | 36 | 20 | 374 | 5405 | 0.0691951896392229 | 0.385309384222397 | 0.384955349820302 | true | false | false | |||||||||||||||||
| 8a185126-24b4-41de-94bc-420251841d7f | 2026-09-21 10:45 | 2026-09-21 10:45 | 2026-09-21 10:45 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 12.5500 | 12.4500 | 12.5500 | 357.4500 | 18825.00 | 18825.00 | 0.00 | 15 | 5 | 107 | 5405 | 0.0197964847363552 | 0.373185769512057 | 0.373185769512057 | true | false | false | |||||||||||||||||
| d95a2119-672c-4dff-8fcd-d89f1236366d | 2026-09-21 10:33 | 2026-09-21 10:32 | 2026-09-21 10:32 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 12.5000 | 12.3500 | 12.5000 | 357.6300 | 39993.00 | 39993.00 | 0.00 | 32 | 15 | 89 | 5405 | 0.0164662349676226 | 0.373350065503053 | 0.373350065503053 | true | false | false | |||||||||||||||||
| b5dbd4c8-f24b-46f9-86c1-1ccc1a70c3a0 | 2026-09-18 10:03 | 2026-09-18 10:03 | 2026-09-18 10:03 | AVGO | AVGO261120P00340000 | put | 340.0000 | 2026-11-20 | 12.6900 | 12.5500 | 13.0500 | 358.4850 | 761400.00 | 0.00 | 761400.00 | 600 | 2 | 665 | 4560 | 0.145833333333333 | 0.374161279199731 | 0.374161279199731 | false | true | false |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1668717791908.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:15:55.789711Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1668717791908.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:11:33.715590Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1668717791908.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T17:50:34.009292Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1684184352671.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:11:57.153448Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:47:19.997705Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:30:31.713908Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:12:31.706500Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T13:42:52.039375Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:24:55.903933Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:19:47.877581Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1694590865776.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T14:09:27.878659Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1740179030987.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1740179030987.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T19:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1731204606841.00 |
| 2026-12-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:50:33.734980Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1731204606841.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:47:49.730853Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1731204606841.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:34:41.643622Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1707097776023.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |