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_alerts566,287 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 | expiry |
|---|
| 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 |
|---|
| b2099458-a78f-428b-8e0b-85ad7798bd1b | 2026-09-29 12:59 | 2026-09-29 12:59 | 2026-09-29 12:59 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 0.3800 | 0.3700 | 0.4000 | 355.0000 | 13414.00 | 0.00 | 11742.00 | 353 | 33 | 2204 | 10460 | 0.210707456978968 | 0.461347382095067 | 0.461347382095067 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1695115965062.00 | 2026-12-10 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T17:01:16.214882Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 905c7dd2-1f47-4525-bc6d-9bc16579ea78 | 2026-09-25 13:54 | 2026-09-25 13:54 | 2026-09-25 13:54 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 0.6600 | 0.6500 | 0.6900 | 352.8950 | 11154.00 | 0.00 | 10626.00 | 169 | 26 | 1741 | 8931 | 0.194938976598365 | 0.372108490699968 | 0.372108490699968 | false | false | false | true | ||||||||||||||||
| 879d3632-7765-4aaf-a4cf-7009f6b1a66e | 2026-09-25 11:16 | 2026-09-25 11:16 | 2026-09-25 11:16 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 0.6400 | 0.6000 | 0.6500 | 351.4600 | 30400.00 | 30336.00 | 0.00 | 475 | 57 | 1269 | 8931 | 0.142089351696339 | 0.385138440613767 | 0.385138440613767 | true | false | false | true | ||||||||||||||||
| 338bd541-d945-4624-bd78-02661be16796 | 2026-09-25 11:11 | 2026-09-25 11:11 | 2026-09-25 11:11 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 0.6200 | 0.6000 | 0.6200 | 351.5299 | 11656.00 | 11656.00 | 0.00 | 188 | 8 | 764 | 8931 | 0.0855447318329414 | 0.381519223917327 | 0.381519223917327 | true | false | false | true | ||||||||||||||||
| 882efc17-a3ed-4bac-acd2-c3d2c063340b | 2026-09-25 11:11 | 2026-09-25 11:11 | 2026-09-25 11:11 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 0.6200 | 0.5800 | 0.6300 | 351.5600 | 16306.00 | 14942.00 | 620.00 | 263 | 38 | 539 | 8931 | 0.0603515843690516 | 0.381190656582187 | 0.381190656582187 | true | false | false | true | ||||||||||||||||
| 41c49d33-9830-4ec7-a3fe-234a776f5618 | 2026-09-22 15:06 | 2026-09-22 15:06 | 2026-09-22 15:06 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.7500 | 3.6500 | 3.7500 | 364.6500 | 13497.00 | 13497.00 | 0.00 | 36 | 7 | 9558 | 2543 | 3.75855289028706 | 0.382199016019471 | 0.382199016019471 | true | false | false | true | ||||||||||||||||
| e130d8c3-036a-4962-a68a-ba3e9c621eb9 | 2026-09-22 14:58 | 2026-09-22 14:57 | 2026-09-22 14:57 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.6000 | 3.6000 | 3.6500 | 364.0500 | 141480.00 | 0.00 | 141480.00 | 393 | 7 | 9398 | 2543 | 3.69563507668109 | 0.382775198815408 | 0.382775198815408 | true | false | false | true | ||||||||||||||||
| bb76ba7c-46c6-4b73-a7d6-7db2c576018a | 2026-09-22 14:42 | 2026-09-22 14:42 | 2026-09-22 14:42 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.6000 | 3.6000 | 3.7000 | 364.2900 | 39600.00 | 0.00 | 39600.00 | 110 | 11 | 8169 | 2543 | 3.21234762092017 | 0.379549362461327 | 0.379549362461327 | true | false | false | true | ||||||||||||||||
| 0e74ec71-775d-4fe2-954a-fdb81dd7221e | 2026-09-22 14:20 | 2026-09-22 14:20 | 2026-09-22 14:20 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.6000 | 3.6000 | 3.6500 | 364.0850 | 84240.00 | 0.00 | 84240.00 | 234 | 9 | 7752 | 2543 | 3.04836806920959 | 0.382305195269659 | 0.382305195269659 | true | false | false | true | ||||||||||||||||
| 7cb65ebb-9cac-4af4-9619-6b1d4303f922 | 2026-09-22 14:20 | 2026-09-22 14:19 | 2026-09-22 14:19 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.6000 | 3.6000 | 3.6500 | 364.2600 | 54000.00 | 0.00 | 54000.00 | 150 | 5 | 7505 | 2543 | 2.95123869445537 | 0.37995297247156 | 0.37995297247156 | true | false | false | true | ||||||||||||||||
| 3a99f0eb-8a1a-401c-a688-7084e87ea6a7 | 2026-09-22 14:18 | 2026-09-22 14:18 | 2026-09-22 14:18 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.6000 | 3.6000 | 3.6500 | 364.2450 | 75960.00 | 0.00 | 75960.00 | 211 | 5 | 7335 | 2543 | 2.88438851749902 | 0.379413455771606 | 0.380154736461064 | true | false | false | true | ||||||||||||||||
| 4b363f3c-53a8-48f0-9c39-0210d88f5f97 | 2026-09-22 14:17 | 2026-09-22 14:17 | 2026-09-22 14:17 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.6000 | 3.6000 | 3.6500 | 364.2900 | 193320.00 | 0.00 | 193320.00 | 537 | 6 | 6916 | 2543 | 2.71962249311836 | 0.379549362461327 | 0.379549362461327 | true | false | false | true | ||||||||||||||||
| 2ab00aa8-c9bd-4e1b-8482-7dda70b94421 | 2026-09-22 14:17 | 2026-09-22 14:17 | 2026-09-22 14:17 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.6000 | 3.6000 | 3.6500 | 364.3250 | 54000.00 | 0.00 | 54000.00 | 150 | 7 | 6379 | 2543 | 2.5084545812033 | 0.379078345527538 | 0.379078345527538 | true | false | false | true | ||||||||||||||||
| 6469f2a7-9dee-42df-acc3-b3c1ab6abb47 | 2026-09-22 14:16 | 2026-09-22 14:16 | 2026-09-22 14:16 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.6000 | 3.6000 | 3.6500 | 364.3000 | 262440.00 | 0.00 | 262440.00 | 729 | 25 | 6079 | 2543 | 2.3904836806921 | 0.379414801443342 | 0.379414801443342 | true | false | false | true | ||||||||||||||||
| 2270377a-ab0d-4184-a305-c9951e257a82 | 2026-09-22 14:14 | 2026-09-22 14:14 | 2026-09-22 14:14 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.5500 | 3.5500 | 3.6000 | 364.3000 | 497355.00 | 0.00 | 497355.00 | 1401 | 9 | 4974 | 2543 | 1.95595753047582 | 0.376887248634301 | 0.376887248634301 | false | false | false | true | ||||||||||||||||
| 69f2935f-1303-4656-8ecd-8e703a57a05b | 2026-09-22 13:22 | 2026-09-22 13:22 | 2026-09-22 13:22 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.4000 | 3.4000 | 3.4500 | 363.7529 | 15640.00 | 0.00 | 15640.00 | 46 | 5 | 3002 | 2543 | 1.18049547778215 | 0.376520274816344 | 0.376520274816344 | false | false | false | true | ||||||||||||||||
| eb83fd86-abc3-41ab-aeb1-c2af98b4285f | 2026-09-22 10:48 | 2026-09-22 10:48 | 2026-09-22 10:48 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.0000 | 3.0000 | 3.1000 | 362.2000 | 58800.00 | 0.00 | 58800.00 | 196 | 34 | 2343 | 2543 | 0.921352732992529 | 0.375554700895428 | 0.375554700895428 | false | false | false | true | ||||||||||||||||
| ef5bffdc-e547-461e-a3c0-8cb507a26607 | 2026-09-21 14:22 | 2026-09-21 14:22 | 2026-09-21 14:22 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.1500 | 3.0500 | 3.1500 | 361.2500 | 46935.00 | 46935.00 | 0.00 | 149 | 19 | 1523 | 1498 | 1.01668891855808 | 0.376945955864685 | 0.376945955864685 | false | false | false | true | ||||||||||||||||
| f6c05dc3-01b8-403a-98d6-49744359e3a7 | 2026-09-21 14:22 | 2026-09-21 14:21 | 2026-09-21 14:21 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 3.1000 | 3.0000 | 3.1500 | 361.1895 | 31310.00 | 31310.00 | 0.00 | 101 | 7 | 1374 | 1498 | 0.917222963951936 | 0.375082079936231 | 0.375082079936231 | false | false | false | true | ||||||||||||||||
| 440ef7d2-77a6-4126-b7eb-11a5aa924b0d | 2026-09-21 12:51 | 2026-09-21 12:51 | 2026-09-21 12:51 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 2.8800 | 2.8100 | 2.8800 | 360.0000 | 16704.00 | 16704.00 | 0.00 | 58 | 6 | 960 | 1498 | 0.640854472630174 | 0.368641847112166 | 0.368641847112166 | true | false | false | true | ||||||||||||||||
| 8db111db-fd81-42b5-96a8-754df3074c34 | 2026-09-08 09:34 | 2026-09-08 09:34 | 2026-09-08 09:34 | AVGO | AVGO261002C00380000 | call | 380.0000 | 2026-10-02 | 10.1100 | 9.0000 | 10.3500 | 367.5150 | 180970.00 | 154710.00 | 26260.00 | 179 | 7 | 189 | 533 | 0.354596622889306 | 0.397641379539922 | 0.399014067247936 | true | false | false | true |
| 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:00:15.336636Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-25T15:19:48.264136Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-25T15:11:41.812883Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 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-25T15:11:41.812883Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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 |
| 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:02:38.336545Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T18:44:24.241276Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T18:23:27.944500Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T18:23:27.944500Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T18:23:27.944500Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T18:18:27.911867Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T17:23:35.118331Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T14:48:37.826382Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-21T18:23:56.707397Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T18:23:56.707397Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| 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-08T13:39:51.680537Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |