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_alerts658,639 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 |
|---|
| 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 |
|---|
| 2aed1d86-10c6-416f-9246-8377c9756bd5 | 2026-08-31 09:35 | 2026-08-31 09:35 | 2026-08-31 09:35 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 53.0500 | 52.8000 | 54.9000 | 369.0300 | 100795.00 | 26575.00 | 74220.00 | 19 | 5 | 26 | 4150 | 0.00626506024096386 | 0.460607043935644 | 0.460068233564406 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1645565687063.00 | 2026-12-10 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T13:47:44.562652Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 92eb6d1e-c474-4eb1-85df-20239840f745 | 2026-09-09 11:32 | 2026-09-09 11:32 | 2026-09-09 11:32 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 43.3500 | 43.1000 | 43.7500 | 360.5400 | 260101.00 | 0.00 | 260101.00 | 60 | 13 | 108 | 4720 | 0.0228813559322034 | 0.425314471601554 | 0.425314471601554 | false | false | false | true | ||||||||||||||||
| 96a0cdbd-dc1d-4a02-9a27-b661957a23b9 | 2026-09-09 12:47 | 2026-09-09 12:47 | 2026-09-09 12:47 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 43.7500 | 43.7500 | 44.1500 | 361.0000 | 271250.00 | 0.00 | 271250.00 | 62 | 7 | 179 | 4720 | 0.0379237288135593 | 0.423632021900712 | 0.423632021900712 | false | false | false | true | ||||||||||||||||
| ca77ad6a-5f6b-46f8-bf65-9516b01a650c | 2026-09-10 12:47 | 2026-09-10 12:47 | 2026-09-10 12:47 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 44.6700 | 44.6500 | 45.7000 | 363.0000 | 183142.00 | 22400.00 | 160742.00 | 41 | 7 | 70 | 4770 | 0.0146750524109015 | 0.419574198627996 | 0.421385643586898 | false | false | false | true | ||||||||||||||||
| 51c330b4-4e6a-4304-a0ad-ee07f2cc6875 | 2026-09-14 10:59 | 2026-09-14 10:59 | 2026-09-14 10:59 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 32.2800 | 32.0000 | 32.5500 | 344.1500 | 100068.00 | 100068.00 | 0.00 | 31 | 5 | 502 | 4750 | 0.105684210526316 | 0.411774356647174 | 0.411774356647174 | false | false | false | true | ||||||||||||||||
| 397b0ded-6ffe-4674-975b-a02a9cc15d60 | 2026-09-14 15:41 | 2026-09-14 15:41 | 2026-09-14 15:41 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 32.4000 | 32.3500 | 32.7500 | 344.6400 | 868368.00 | 3240.00 | 865128.00 | 268 | 27 | 1322 | 4750 | 0.278315789473684 | 0.409927498697582 | 0.409927498697582 | true | false | false | true | ||||||||||||||||
| 16a11d21-0f6e-4b7d-a51a-670c5ac7ae45 | 2026-09-17 09:35 | 2026-09-17 09:35 | 2026-09-17 09:35 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 33.0000 | 32.2000 | 33.0000 | 348.0300 | 273900.00 | 273900.00 | 0.00 | 83 | 6 | 129 | 5508 | 0.0234204793028322 | 0.398710825992948 | 0.398710825992948 | false | false | false | true | ||||||||||||||||
| f2d6ce3b-9f66-4d2d-ab9c-96454ccb18d7 | 2026-09-17 10:50 | 2026-09-17 10:50 | 2026-09-17 10:50 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 33.5800 | 33.2500 | 33.7500 | 348.8500 | 335802.00 | 335802.00 | 0.00 | 100 | 15 | 569 | 5508 | 0.103304284676834 | 0.399590050447754 | 0.399590050447754 | false | false | false | true | ||||||||||||||||
| 5740109a-a151-4917-b342-479c006057f0 | 2026-09-23 13:45 | 2026-09-23 13:45 | 2026-09-23 13:45 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 37.2100 | 36.8000 | 37.2500 | 355.0000 | 63263.00 | 63263.00 | 0.00 | 17 | 5 | 245 | 5411 | 0.0452781371280724 | 0.41071668043284 | 0.41071668043284 | false | false | false | true | ||||||||||||||||
| 50a568e6-b468-4a67-9f25-27ae4e425ac9 | 2026-09-25 14:36 | 2026-09-25 14:36 | 2026-09-25 14:36 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 35.2200 | 35.0500 | 35.2500 | 352.9650 | 56345.00 | 56345.00 | 0.00 | 16 | 5 | 232 | 5737 | 0.0404392539654872 | 0.40600105194322 | 0.40665622407582 | false | false | false | true | ||||||||||||||||
| b2a7c140-ac65-414e-a844-59aa06b0e67c | 2026-09-28 15:21 | 2026-09-28 15:21 | 2026-09-28 15:21 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 32.9000 | 32.9000 | 33.0000 | 349.6900 | 55930.00 | 0.00 | 55930.00 | 17 | 6 | 634 | 5806 | 0.109197382018601 | 0.406838138839336 | 0.406838138839336 | false | false | false | true | ||||||||||||||||
| 92c890b2-1455-4003-8d28-2192ba5e30f5 | 2026-09-29 12:27 | 2026-09-29 12:27 | 2026-09-29 12:27 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 37.6100 | 37.5000 | 38.0000 | 357.0700 | 33845.00 | 7525.00 | 26320.00 | 9 | 7 | 259 | 5999 | 0.0431738623103851 | 0.414128460962615 | 0.414795612371542 | false | false | false | true | ||||||||||||||||
| 624bbd90-94fe-4ef2-ac4a-c85e3e81df22 | 2026-09-30 15:42 | 2026-09-30 15:42 | 2026-09-30 15:42 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 33.9700 | 33.9500 | 34.6000 | 352.2600 | 71328.00 | 0.00 | 71328.00 | 21 | 5 | 144 | 5915 | 0.0243448858833474 | 0.409526685993707 | 0.406063816053435 | true | false | false | true | ||||||||||||||||
| ca4a4168-6d32-4f54-b9cd-742b43b1e810 | 2026-10-01 14:41 | 2026-10-01 14:41 | 2026-10-01 14:41 | AVGO | AVGO270115C00350000 | call | 350.0000 | 2027-01-15 | 31.4000 | 30.7500 | 31.4000 | 347.5450 | 37680.00 | 37680.00 | 0.00 | 12 | 5 | 294 | 5939 | 0.0495032833810406 | 0.409485471764773 | 0.409485471764773 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T15:51:30.246262Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T17:02:16.286608Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T15:02:08.921486Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1657881652115.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1657881652115.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:02:25.509626Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-23T17:48:41.957434Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-25T18:38:37.498256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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:23:02.177643Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1695115965062.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T16:30:08.808043Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1695115965062.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:46:40.965849Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1640410166809.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T18:43:39.301035Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |