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.
Simplify Analyticsuw_flow_alerts474,253 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 |
|---|
| 40d8ba79-6284-40f7-9ab4-38fb54f45d9a | 2026-09-25 14:47 | 2026-09-25 14:47 | 2026-09-25 14:47 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 1.2400 | 1.2300 | 1.3000 | 1075.0000 | 12380.00 | 0.00 | 12380.00 | 100 | 5 | 51212 | 1516 | 33.7810026385224 | 0.487960212157773 | 0.487960212157773 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Technology | 1222319619464.00 | 2026-09-30 | postmarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-25T18:55:18.072403Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| b5181814-10dc-49c1-8ce3-3dea5e077977 | 2026-09-25 14:27 | 2026-09-25 14:26 | 2026-09-25 14:26 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 2.5000 | 2.4800 | 2.6500 | 1084.0000 | 19764.00 | 0.00 | 19764.00 | 79 | 5 | 46514 | 1516 | 30.6820580474934 | 0.511837515540848 | 0.512250001408356 | false | false | false | |||||||||||||||||
| 357472f3-c532-4eeb-87ed-cd7a1f998076 | 2026-09-25 14:00 | 2026-09-25 14:00 | 2026-09-25 14:00 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 2.0000 | 1.9600 | 2.0500 | 1075.0000 | 20027.00 | 11868.00 | 0.00 | 100 | 8 | 42028 | 1516 | 27.7229551451187 | 0.504693299011378 | 0.510046654829948 | false | false | false | |||||||||||||||||
| 3a8ec501-c397-4ff8-9266-c3fd746db720 | 2026-09-25 13:21 | 2026-09-25 13:21 | 2026-09-25 13:21 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 2.4900 | 2.4000 | 2.7100 | 1075.0000 | 11946.00 | 0.00 | 11946.00 | 48 | 5 | 35652 | 1516 | 23.5171503957784 | 0.492673342439902 | 0.520551605730823 | false | false | false | |||||||||||||||||
| f1b7732f-9394-4036-93e0-435db6c47bfb | 2026-09-25 13:05 | 2026-09-25 13:05 | 2026-09-25 13:05 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 2.3800 | 2.3100 | 2.4400 | 1081.0500 | 10237.00 | 9996.00 | 241.00 | 43 | 5 | 32618 | 1516 | 21.5158311345646 | 0.505250018083546 | 0.513474825744152 | false | false | false | |||||||||||||||||
| 00d4c73d-d8c9-43e2-bd4b-e6bec6d3f705 | 2026-09-25 13:01 | 2026-09-25 13:01 | 2026-09-25 13:01 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 2.9400 | 2.8250 | 2.9700 | 1082.6199 | 140975.00 | 32272.00 | 108703.00 | 480 | 12 | 31673 | 1516 | 20.8924802110818 | 0.521927703379693 | 0.502625512859887 | false | false | false | |||||||||||||||||
| 7fd0efbb-a2fe-4e47-bec5-7fc5ba5dc0d1 | 2026-09-25 12:49 | 2026-09-25 12:49 | 2026-09-25 12:49 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 1.6200 | 1.6100 | 1.7000 | 1077.2950 | 18283.00 | 1680.00 | 16603.00 | 113 | 16 | 28995 | 1516 | 19.1259894459103 | 0.545668639999817 | 0.550272158584902 | false | false | false | |||||||||||||||||
| 243b0b90-01f8-4e70-9bb8-34bb7e497b29 | 2026-09-25 12:41 | 2026-09-25 12:41 | 2026-09-25 12:41 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 2.4400 | 2.2700 | 2.4400 | 1080.1050 | 127560.00 | 114924.00 | 12636.00 | 523 | 11 | 27630 | 1516 | 18.2255936675462 | 0.5337845930256 | 0.531169342815189 | true | false | false | |||||||||||||||||
| 201cef75-6601-49f4-b0d0-6bfa5064a25c | 2026-09-25 12:12 | 2026-09-25 12:12 | 2026-09-25 12:12 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 2.9100 | 2.7400 | 2.9500 | 1075.0000 | 145024.00 | 51773.00 | 90923.00 | 499 | 18 | 20510 | 1516 | 13.5290237467018 | 0.546340169325688 | 0.531050879915274 | false | false | false | |||||||||||||||||
| 8aabffc6-3fac-45f1-85fd-da961076a3c8 | 2026-09-25 12:11 | 2026-09-25 12:11 | 2026-09-25 12:11 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 3.0000 | 3.0000 | 3.2000 | 1075.0000 | 32419.00 | 0.00 | 32419.00 | 108 | 9 | 19722 | 1516 | 13.009234828496 | 0.535905487381113 | 0.528991315587385 | false | false | false | |||||||||||||||||
| b8c8af5a-9816-45d6-93d2-e2854fd4931a | 2026-09-25 12:08 | 2026-09-25 12:08 | 2026-09-25 12:08 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 2.7400 | 2.6100 | 2.7600 | 1080.0000 | 35557.00 | 35557.00 | 0.00 | 130 | 9 | 18753 | 1516 | 12.3700527704485 | 0.534836207513137 | 0.528832278326737 | true | false | false | |||||||||||||||||
| beb00f70-0b96-4709-a7fd-0b455176493b | 2026-09-25 11:43 | 2026-09-25 11:43 | 2026-09-25 11:43 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 2.5500 | 2.4300 | 2.5500 | 1079.1231 | 51187.00 | 51187.00 | 0.00 | 201 | 16 | 13661 | 1516 | 9.01121372031662 | 0.510796158951241 | 0.511537540804458 | true | false | false | |||||||||||||||||
| f4ee9d39-0b47-4ae2-943d-3c54d2cdc15a | 2026-09-25 11:28 | 2026-09-25 11:28 | 2026-09-25 11:28 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 3.3900 | 3.2000 | 3.4000 | 1075.0000 | 16931.00 | 16931.00 | 0.00 | 50 | 6 | 11034 | 1516 | 7.27836411609499 | 0.521312000250933 | 0.521312000250933 | false | false | false | |||||||||||||||||
| 4295ee55-4e3d-4465-b7c8-7d6c6479b6d9 | 2026-09-25 11:27 | 2026-09-25 11:27 | 2026-09-25 11:27 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 3.0000 | 2.9700 | 3.1500 | 1075.0000 | 12591.00 | 0.00 | 12591.00 | 42 | 16 | 10895 | 1516 | 7.18667546174142 | 0.514908264107038 | 0.519148010307516 | true | false | false | |||||||||||||||||
| 53b83f82-4f8d-493a-8307-cfb493c87336 | 2026-09-25 10:37 | 2026-09-25 10:37 | 2026-09-25 10:37 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 5.6700 | 5.4500 | 5.9000 | 1082.5100 | 17020.00 | 0.00 | 17020.00 | 30 | 6 | 4691 | 1516 | 3.094327176781 | 0.62182959402311 | 0.612623582995256 | false | false | false | |||||||||||||||||
| e6c9145e-f840-46dc-bff6-04a831207d11 | 2026-09-25 10:37 | 2026-09-25 10:37 | 2026-09-25 10:37 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 6.0000 | 5.9500 | 6.1500 | 1083.0901 | 33600.00 | 605.00 | 1795.00 | 56 | 6 | 4608 | 1516 | 3.03957783641161 | 0.648427670854431 | 0.639043502565124 | true | false | false | |||||||||||||||||
| 9314e386-c14f-4d10-a4d1-87e9058c6f6b | 2026-09-25 10:20 | 2026-09-25 10:20 | 2026-09-25 10:20 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 4.0100 | 3.8500 | 4.3000 | 1075.2950 | 10825.00 | 9200.00 | 1625.00 | 27 | 5 | 2693 | 1516 | 1.77638522427441 | 0.702745124833634 | 0.722543920632491 | false | false | false | |||||||||||||||||
| 3a803580-b154-4580-b56f-6c567cc14bef | 2026-09-25 09:30 | 2026-09-25 09:30 | 2026-09-25 09:30 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 14.3800 | 13.1000 | 14.7500 | 1093.6650 | 10065.00 | 8640.00 | 1425.00 | 7 | 7 | 42 | 1516 | 0.0277044854881266 | 0.823237591531981 | 0.782575239595205 | true | false | false | |||||||||||||||||
| 8c5aed78-142e-46e8-b071-5cb184fab19a | 2026-09-24 15:03 | 2026-09-24 15:03 | 2026-09-24 15:03 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 7.5900 | 7.6000 | 7.7000 | 1073.3280 | 15186.00 | 0.00 | 15186.00 | 20 | 5 | 6667 | 1058 | 6.30151228733459 | 0.556961434695536 | 0.556961434695536 | true | false | false | |||||||||||||||||
| 665fb8cc-ebdc-41c5-994b-ca82a083aee8 | 2026-09-24 13:09 | 2026-09-24 13:09 | 2026-09-24 13:09 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 8.4900 | 8.4500 | 8.6000 | 1073.5200 | 29712.00 | 0.00 | 29712.00 | 35 | 5 | 5296 | 1058 | 5.00567107750473 | 0.595652432465567 | 0.595182569536021 | false | false | false | |||||||||||||||||
| 674ac3d8-117c-477c-8ce8-abe52f3ed872 | 2026-09-24 11:28 | 2026-09-24 11:28 | 2026-09-24 11:28 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 3.8400 | 3.8000 | 3.9250 | 1056.2150 | 51864.00 | 0.00 | 51864.00 | 135 | 29 | 2903 | 1058 | 2.74385633270321 | 0.609629292381088 | 0.607754021687662 | true | false | false | |||||||||||||||||
| 460c9795-b886-4e63-be92-45750befbdac | 2026-09-22 14:55 | 2026-09-22 14:55 | 2026-09-22 14:55 | MU | MU260925C01085000 | call | 1085.0000 | 2026-09-25 | 26.1000 | 26.0000 | 26.2500 | 1088.8000 | 18273.00 | 2610.00 | 15663.00 | 7 | 6 | 2907 | 785 | 3.7031847133758 | 0.610599709553081 | 0.609834322454211 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:31:26.314014Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:10:19.042064Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:23:42.010099Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:13:31.947650Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T17:04:49.737352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:52:03.026935Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:45:32.616673Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:14:10.282260Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:14:10.282260Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:10:39.655295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:46:29.692189Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:30:17.746556Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T15:30:17.746556Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:40:21.587562Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:37:32.022295Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:22:54.159476Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:31:26.059584Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T19:07:42.806014Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:14:36.344002Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T15:29:44.716579Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| 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 |