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_alerts609,118 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 |
|---|
| 74c9666a-3782-4516-a243-b4a995480d0d | 2026-08-19 09:59 | 2026-08-19 09:59 | 2026-08-19 09:59 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 14.2500 | 13.7500 | 14.3500 | 362.0650 | 528675.00 | 329175.00 | 199500.00 | 371 | 11 | 602 | 3695 | 0.162922868741543 | 0.51039830679949 | 0.51039830679949 | false | false | false | true | false | 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-08-19T14:00:52.208142Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9d75b622-b06a-49b9-892a-db42f06d507b | 2026-08-19 12:01 | 2026-08-19 12:00 | 2026-08-19 12:00 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 14.0500 | 14.0500 | 14.3500 | 363.0100 | 108185.00 | 0.00 | 108185.00 | 77 | 5 | 2159 | 3695 | 0.584303112313938 | 0.495887406002932 | 0.495887406002932 | false | false | false | true | ||||||||||||||||
| 7153d25c-2752-4f2f-80fb-ba2f95aadda4 | 2026-08-19 12:03 | 2026-08-19 12:03 | 2026-08-19 12:03 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 14.5000 | 14.3000 | 14.6000 | 363.9050 | 435000.00 | 85550.00 | 349450.00 | 300 | 6 | 2790 | 3695 | 0.755074424898512 | 0.497864253375738 | 0.497864253375738 | false | false | false | true | ||||||||||||||||
| 15ab48f7-ae39-4b07-a53d-0b1d66166878 | 2026-08-19 12:08 | 2026-08-19 12:08 | 2026-08-19 12:08 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 14.6500 | 14.3500 | 14.6500 | 363.9450 | 273955.00 | 273955.00 | 0.00 | 187 | 26 | 3058 | 3695 | 0.827604871447903 | 0.50113728435394 | 0.50113728435394 | false | false | false | true | ||||||||||||||||
| f1440cb7-9e2d-4906-ac0d-8be3543d0331 | 2026-08-20 13:57 | 2026-08-20 13:57 | 2026-08-20 13:57 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 14.7500 | 14.3000 | 14.7500 | 365.4200 | 123900.00 | 123900.00 | 0.00 | 84 | 13 | 1051 | 6234 | 0.168591594481874 | 0.497108947403587 | 0.497108947403587 | false | false | false | true | ||||||||||||||||
| 6f1ec1e5-f7af-40c2-ab58-b16b8dd6f622 | 2026-08-21 12:12 | 2026-08-21 12:12 | 2026-08-21 12:12 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 16.0000 | 15.8000 | 16.2000 | 367.2650 | 502400.00 | 27200.00 | 275200.00 | 314 | 11 | 1337 | 6928 | 0.192984988452656 | 0.517459338195722 | 0.517459338195722 | false | false | false | true | ||||||||||||||||
| 48f95157-65fe-4679-bbf3-ef29ab3fb4f3 | 2026-08-21 12:12 | 2026-08-21 12:12 | 2026-08-21 12:12 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 16.2000 | 15.8500 | 16.2000 | 367.5600 | 463312.00 | 463312.00 | 0.00 | 286 | 34 | 1623 | 6928 | 0.234266743648961 | 0.520175283285831 | 0.519181838418894 | false | false | false | true | ||||||||||||||||
| 97d4e4c4-cdfa-4c8f-b5fc-94a4da9c1dbe | 2026-08-24 10:58 | 2026-08-24 10:58 | 2026-08-24 10:58 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 12.5500 | 12.5000 | 12.5500 | 361.5600 | 376500.00 | 376500.00 | 0.00 | 300 | 14 | 441 | 7769 | 0.0567640622988802 | 0.519913624134574 | 0.519913624134574 | true | false | false | true | ||||||||||||||||
| c83de75e-dbce-4a54-8e69-d1c3216076b5 | 2026-08-27 09:39 | 2026-08-27 09:39 | 2026-08-27 09:39 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 13.7100 | 12.9000 | 13.8000 | 363.9100 | 1096776.00 | 1096776.00 | 0.00 | 800 | 5 | 935 | 7925 | 0.117981072555205 | 0.558406620066012 | 0.558406620066012 | false | false | false | true | ||||||||||||||||
| c95d4c22-12d5-413f-907c-9cab8d81a59d | 2026-09-02 13:07 | 2026-09-02 13:07 | 2026-09-02 13:07 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 13.6000 | 13.4500 | 13.8000 | 368.7500 | 265194.00 | 208079.00 | 57115.00 | 195 | 26 | 5693 | 8904 | 0.639375561545373 | 0.589780244374056 | 0.589994295108381 | false | false | false | true | ||||||||||||||||
| df8407d5-3e85-4a4b-8d77-2f44a8803523 | 2026-09-08 10:31 | 2026-09-08 10:31 | 2026-09-08 10:31 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 5.9600 | 5.8500 | 6.1000 | 368.5800 | 178806.00 | 169806.00 | 9000.00 | 300 | 17 | 1424 | 11389 | 0.125032926508034 | 0.429802445970301 | 0.429802445970301 | false | false | false | true | ||||||||||||||||
| 14ac88b7-e59a-4404-8e84-bae0600bd45c | 2026-09-08 11:27 | 2026-09-08 11:27 | 2026-09-08 11:27 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 7.4500 | 7.3500 | 7.5000 | 372.5450 | 125160.00 | 115475.00 | 0.00 | 168 | 18 | 3131 | 11389 | 0.274914391079111 | 0.427287714143652 | 0.427287714143652 | true | false | false | true | ||||||||||||||||
| 7e9b813e-b864-459d-b95f-6e4a690764d3 | 2026-09-08 11:27 | 2026-09-08 11:27 | 2026-09-08 11:27 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 7.4500 | 7.3500 | 7.5000 | 372.5600 | 103555.00 | 93870.00 | 0.00 | 139 | 14 | 3341 | 11389 | 0.293353235578189 | 0.426348339907279 | 0.427031603249139 | true | false | false | true | ||||||||||||||||
| fc0b0fcd-8da0-4f8d-a9f5-0979b10224ec | 2026-09-08 11:28 | 2026-09-08 11:28 | 2026-09-08 11:28 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 7.4500 | 7.3000 | 7.5500 | 372.4900 | 227225.00 | 148255.00 | 51405.00 | 305 | 27 | 3720 | 11389 | 0.326630959697954 | 0.426310747695208 | 0.428226262964344 | true | false | false | true | ||||||||||||||||
| 8e81314d-29bd-45a0-878d-7ca1ee783032 | 2026-09-09 11:16 | 2026-09-09 11:16 | 2026-09-09 11:16 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 2.8700 | 2.8600 | 3.0000 | 360.9500 | 165315.00 | 290.00 | 165025.00 | 576 | 54 | 2737 | 12602 | 0.217187747976512 | 0.405630688321831 | 0.407400430028792 | false | false | false | true | ||||||||||||||||
| f92d4a54-e741-4376-b25f-94a0a2f0c6c5 | 2026-09-11 10:03 | 2026-09-11 10:03 | 2026-09-11 10:03 | AVGO | AVGO260918C00380000 | call | 380.0000 | 2026-09-18 | 1.9000 | 1.7600 | 1.9000 | 362.7900 | 171190.00 | 171190.00 | 0.00 | 901 | 29 | 1521 | 12026 | 0.126475968734409 | 0.367529702103982 | 0.36683102066469 | 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-08-19T16:07:57.422777Z"} |
| 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-08-19T16:07:57.422777Z"} |
| 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-08-19T16:28:32.259187Z"} |
| 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-08-20T18:14:08.178572Z"} |
| 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-08-21T16:17:50.496167Z"} |
| 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-08-21T16:17:50.496167Z"} |
| 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-08-24T15:09:19.758040Z"} |
| 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-08-27T13:49:05.616113Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1645565687063.00 |
| 2026-12-10 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-08T14:47:12.085652Z"} |
| 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-08T15:43:32.720264Z"} |
| 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-08T15:43:32.720264Z"} |
| 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-08T15:43:32.720264Z"} |
| 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-09T15:29:26.424015Z"} |
| 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-11T14:11:33.656123Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |