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 |
|---|
| 0056bd47-f2ac-4564-820e-7698e46b061f | 2026-09-03 10:42 | 2026-09-03 10:42 | 2026-09-03 10:42 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 14.6000 | 14.5000 | 14.6000 | 344.3500 | 194180.00 | 194180.00 | 0.00 | 133 | 13 | 1369 | 934 | 1.46573875802998 | 0.349071631098195 | 0.349071631098195 | true | 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-09-03T14:57:35.447301Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4a79603f-1339-4d2a-adf3-e91b9fb73356 | 2026-09-08 09:30 | 2026-09-08 09:30 | 2026-09-08 09:30 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 27.1400 | 25.7000 | 27.2500 | 365.3950 | 116705.00 | 65185.00 | 51520.00 | 43 | 20 | 79 | 2437 | 0.0324169060320066 | 0.38168857305487 | 0.38168857305487 | true | false | false | true | ||||||||||||||||
| 25c10785-48b0-47d9-b153-609be9e9eefa | 2026-09-14 09:35 | 2026-09-14 09:35 | 2026-09-14 09:35 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 14.8400 | 14.4500 | 15.0000 | 347.8900 | 192900.00 | 118650.00 | 74250.00 | 130 | 5 | 147 | 2537 | 0.0579424517146236 | 0.372722412651415 | 0.371992057115426 | false | false | false | true | ||||||||||||||||
| f2bffbea-783e-4326-9526-ee870df700a3 | 2026-09-21 10:49 | 2026-09-21 10:49 | 2026-09-21 10:49 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 17.9500 | 17.9500 | 18.1500 | 357.8181 | 466774.00 | 0.00 | 466774.00 | 260 | 40 | 412 | 3816 | 0.107966457023061 | 0.353926421722612 | 0.355187376328376 | false | false | false | true | ||||||||||||||||
| 01a80e94-b4bb-4e03-bbe3-61e8a0eb404b | 2026-09-21 10:49 | 2026-09-21 10:49 | 2026-09-21 10:49 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 18.0900 | 17.8500 | 18.2000 | 357.9500 | 18094.00 | 16284.00 | 1810.00 | 10 | 8 | 422 | 3816 | 0.110587002096436 | 0.357092782441118 | 0.357092782441118 | true | false | false | true | ||||||||||||||||
| f7db09f4-64cc-4cda-8764-1d8361c8c4e2 | 2026-09-21 15:11 | 2026-09-21 15:11 | 2026-09-21 15:11 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 22.0000 | 21.8000 | 22.0000 | 362.8700 | 13200.00 | 13200.00 | 0.00 | 6 | 6 | 693 | 3816 | 0.181603773584906 | 0.377419921260918 | 0.377419921260918 | false | false | false | true | ||||||||||||||||
| 630352b7-1f00-4bfe-bb34-d946a591932f | 2026-09-22 10:32 | 2026-09-22 10:32 | 2026-09-22 10:32 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 22.4000 | 22.2000 | 22.5000 | 363.9100 | 47040.00 | 47040.00 | 0.00 | 21 | 5 | 135 | 3584 | 0.0376674107142857 | 0.376868608700964 | 0.376868608700964 | false | false | false | true | ||||||||||||||||
| 7b565fc0-9839-4cca-a16f-379fd828f1d3 | 2026-09-22 10:38 | 2026-09-22 10:38 | 2026-09-22 10:38 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 21.5500 | 21.4500 | 21.7500 | 362.8799 | 36635.00 | 2155.00 | 32325.00 | 17 | 5 | 169 | 3584 | 0.0471540178571429 | 0.37236656733678 | 0.37236656733678 | false | false | false | true | ||||||||||||||||
| c136bcb1-1585-4afb-b913-f72dfaa95481 | 2026-09-24 09:38 | 2026-09-24 09:38 | 2026-09-24 09:38 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 12.0900 | 12.0500 | 12.2500 | 349.4000 | 14512.00 | 0.00 | 14512.00 | 12 | 5 | 72 | 3606 | 0.0199667221297837 | 0.350280116694368 | 0.350280116694368 | false | false | false | true | ||||||||||||||||
| 9abef27b-dfe2-45aa-af2d-ec47db69db2e | 2026-09-24 12:08 | 2026-09-24 12:08 | 2026-09-24 12:08 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 10.9500 | 10.9000 | 10.9500 | 347.0000 | 24090.00 | 24090.00 | 0.00 | 22 | 6 | 714 | 3606 | 0.198003327787022 | 0.343961696612772 | 0.343961696612772 | false | false | false | true | ||||||||||||||||
| 477daaaa-9f5a-44de-816f-4b1f690d9826 | 2026-09-24 12:38 | 2026-09-24 12:38 | 2026-09-24 12:38 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 12.2000 | 12.1500 | 12.3000 | 350.0748 | 21960.00 | 0.00 | 20740.00 | 18 | 5 | 823 | 3606 | 0.228230726566833 | 0.342848059655588 | 0.342848059655588 | false | false | false | true | ||||||||||||||||
| 8f7c6dae-5c98-4a76-868f-b68a523834c3 | 2026-09-24 14:53 | 2026-09-24 14:53 | 2026-09-24 14:53 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 12.1000 | 12.0500 | 12.2000 | 349.7900 | 18150.00 | 0.00 | 18150.00 | 15 | 6 | 938 | 3606 | 0.26012201885746 | 0.344315170506305 | 0.344315170506305 | false | false | false | true | ||||||||||||||||
| cfcbe773-79a2-4b36-b0aa-4908be11f923 | 2026-09-28 13:47 | 2026-09-28 13:47 | 2026-09-28 13:47 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 11.8500 | 11.8500 | 12.0000 | 351.0650 | 17775.00 | 0.00 | 17775.00 | 15 | 8 | 347 | 3848 | 0.0901767151767152 | 0.352936343390503 | 0.352936343390503 | false | false | false | true | ||||||||||||||||
| 136e3598-168b-403b-868a-0fd7f1c78cf1 | 2026-09-28 14:00 | 2026-09-28 14:00 | 2026-09-28 14:00 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 11.9500 | 11.9500 | 12.1000 | 351.2300 | 29875.00 | 0.00 | 29875.00 | 25 | 7 | 374 | 3848 | 0.0971933471933472 | 0.353276172961459 | 0.353276172961459 | false | false | false | true | ||||||||||||||||
| f0e277b7-5f8b-475e-879e-58bd91b286a0 | 2026-09-28 15:05 | 2026-09-28 15:05 | 2026-09-28 15:05 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 11.6000 | 11.4500 | 11.6000 | 350.6600 | 25520.00 | 25520.00 | 0.00 | 22 | 7 | 416 | 3848 | 0.108108108108108 | 0.351901856246387 | 0.351901856246387 | false | false | false | true | ||||||||||||||||
| a2828499-d5ee-4d0c-ac53-58dc3cc67970 | 2026-09-29 09:58 | 2026-09-29 09:58 | 2026-09-29 09:58 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 17.1500 | 16.9500 | 17.1500 | 359.0000 | 10290.00 | 10290.00 | 0.00 | 6 | 5 | 157 | 3638 | 0.0431555799890049 | 0.366213376763601 | 0.366213376763601 | false | false | false | true | ||||||||||||||||
| 3754aa52-b757-43dd-b94f-70bf6555a96b | 2026-09-29 11:39 | 2026-09-29 11:39 | 2026-09-29 11:39 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 16.6500 | 16.6500 | 16.9000 | 358.7101 | 13320.00 | 0.00 | 13320.00 | 8 | 5 | 370 | 3638 | 0.101704233095107 | 0.372703777587212 | 0.372703777587212 | false | false | false | true | ||||||||||||||||
| 8bf1e98e-2296-468b-b423-df70424eb591 | 2026-09-29 13:08 | 2026-09-29 13:08 | 2026-09-29 13:08 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 14.8500 | 14.7500 | 15.0000 | 355.9800 | 29700.00 | 5940.00 | 23760.00 | 20 | 7 | 421 | 3638 | 0.115722924683892 | 0.369635264485004 | 0.369635264485004 | false | false | false | true | ||||||||||||||||
| e9a4c247-4795-455f-98d8-073359a0b56d | 2026-09-29 14:26 | 2026-09-29 14:26 | 2026-09-29 14:26 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 14.6400 | 14.2500 | 15.0000 | 355.0000 | 23420.00 | 20500.00 | 2920.00 | 16 | 7 | 453 | 3638 | 0.124518966465091 | 0.374925971935443 | 0.369489426556122 | false | false | false | true | ||||||||||||||||
| f1c82512-21a4-4cd5-a76e-d90eb14c6409 | 2026-09-30 09:36 | 2026-09-30 09:36 | 2026-09-30 09:36 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 13.7000 | 13.6500 | 13.9000 | 355.1750 | 21920.00 | 0.00 | 21920.00 | 16 | 6 | 21 | 3552 | 0.00591216216216216 | 0.358658823344847 | 0.358658823344847 | false | false | false | true | ||||||||||||||||
| 64d70f69-e0c3-44d0-a736-a50fe434c610 | 2026-09-30 10:12 | 2026-09-30 10:12 | 2026-09-30 10:12 | AVGO | AVGO261016C00350000 | call | 350.0000 | 2026-10-16 | 13.2000 | 13.1500 | 13.3500 | 354.0000 | 21120.00 | 0.00 | 19800.00 | 16 | 5 | 157 | 3552 | 0.0442004504504505 | 0.350323822409372 | 0.350323822409372 | false | false | false | true |
| 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-08T13:33:29.575205Z"} |
| 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-14T13:38:30.454841Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:51:11.587541Z"} |
| 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-21T14:51:11.587541Z"} |
| 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-21T19:15:34.344712Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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:34:01.762519Z"} |
| 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:38:45.745623Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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:38:54.076483Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T16:13:55.044964Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T16:39:34.063443Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T18:57:49.526864Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-28T17:50:34.009292Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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-28T18:00:44.175376Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 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:11:33.715590Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:59:42.347553Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-29T15:42:05.749928Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-29T17:09:02.591360Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T18:32:00.493327Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 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-30T13:38:56.066049Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| 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-30T14:14:21.800901Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |