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 |
|---|
| 872ab56d-594b-4fae-b255-e4e3bc4a0303 | 2026-08-17 11:29 | 2026-08-17 11:28 | 2026-08-17 11:28 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 162.7000 | 162.0000 | 164.3000 | 1033.6700 | 325400.00 | 0.00 | 325400.00 | 20 | 5 | 283 | 5742 | 0.0492859630790665 | 0.663031974813689 | 0.664169844267539 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1043593153319.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3e26e3be-00c0-4b19-8526-40a88cca89e5 | 2026-08-19 09:31 | 2026-08-19 09:31 | 2026-08-19 09:31 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 101.0000 | 100.0500 | 103.6500 | 953.4800 | 1030165.00 | 10060.00 | 1020105.00 | 102 | 7 | 102 | 5688 | 0.0179324894514768 | 0.656086499514005 | 0.655556832868678 | false | false | false | true | ||||||||||||||||
| e284a6e8-eab3-4db3-9680-ed4a8aa8da53 | 2026-08-24 09:53 | 2026-08-24 09:53 | 2026-08-24 09:53 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 59.1900 | 58.6000 | 61.3000 | 895.2950 | 1213419.00 | 0.00 | 1213419.00 | 205 | 7 | 1301 | 5557 | 0.234119129026453 | 0.649026997261821 | 0.649240227288973 | false | false | false | true | ||||||||||||||||
| 47d3164f-78af-4255-bf64-bbd3ec4e1069 | 2026-08-24 09:58 | 2026-08-24 09:58 | 2026-08-24 09:58 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 60.3000 | 60.3000 | 61.7500 | 897.1000 | 886410.00 | 0.00 | 886410.00 | 147 | 6 | 1758 | 5557 | 0.316357746985784 | 0.647347360723231 | 0.647347360723231 | true | false | false | true | ||||||||||||||||
| 02327959-c0b1-48dd-aef1-ee0159472f14 | 2026-08-24 10:14 | 2026-08-24 10:14 | 2026-08-24 10:14 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 58.8000 | 58.8000 | 58.9500 | 893.2900 | 588000.00 | 0.00 | 588000.00 | 100 | 7 | 2363 | 5557 | 0.42522944034551 | 0.652813392990588 | 0.652813392990588 | false | false | false | true | ||||||||||||||||
| 5e4926b6-f4c2-412c-a7a5-6541c9fc7cb8 | 2026-08-27 09:31 | 2026-08-27 09:30 | 2026-08-27 09:30 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 92.0600 | 92.0500 | 94.5000 | 961.6950 | 184110.00 | 0.00 | 184110.00 | 20 | 6 | 25 | 5619 | 0.00444919024737498 | 0.597383625054128 | 0.597383625054128 | false | false | false | true | ||||||||||||||||
| b29afdee-8f2d-4ea3-b001-aaa0247f71a9 | 2026-08-27 14:57 | 2026-08-27 14:56 | 2026-08-27 14:56 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 60.4900 | 59.9500 | 62.0000 | 915.2700 | 120988.00 | 0.00 | 120988.00 | 20 | 5 | 612 | 5619 | 0.108916177255739 | 0.572831548011505 | 0.580123560026821 | false | false | false | true | ||||||||||||||||
| d518abe9-f9c9-43d4-ac3d-dc84fb14f805 | 2026-09-03 09:34 | 2026-09-03 09:34 | 2026-09-03 09:34 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 59.3500 | 59.3500 | 60.9500 | 932.7000 | 160245.00 | 0.00 | 160245.00 | 27 | 7 | 48 | 5163 | 0.00929692039511912 | 0.540642310016503 | 0.540642310016503 | false | false | false | true | ||||||||||||||||
| 9d1e9cd3-bdf6-44e3-92ce-10e8582aae7f | 2026-09-03 09:44 | 2026-09-03 09:44 | 2026-09-03 09:44 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 62.4900 | 60.5000 | 63.6500 | 937.0500 | 187460.00 | 187460.00 | 0.00 | 30 | 10 | 101 | 5163 | 0.0195622699980631 | 0.54432318054487 | 0.54432318054487 | false | false | false | true | ||||||||||||||||
| 7f870f41-1fbf-4650-8666-9e1ab16dace1 | 2026-09-04 09:44 | 2026-09-04 09:44 | 2026-09-04 09:44 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 102.4500 | 102.4500 | 104.2000 | 991.9900 | 2591990.00 | 10250.00 | 2581740.00 | 253 | 37 | 336 | 5131 | 0.0654843110504775 | 0.534300159417685 | 0.535358999447573 | false | false | false | true | ||||||||||||||||
| 2c5dcb20-7a65-492e-9b1b-732e5dd9c96a | 2026-09-04 10:07 | 2026-09-04 10:07 | 2026-09-04 10:07 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 107.1500 | 107.1500 | 108.7500 | 996.4250 | 107150.00 | 0.00 | 107150.00 | 10 | 10 | 399 | 5131 | 0.077762619372442 | 0.554858290533632 | 0.554858290533632 | false | false | false | true | ||||||||||||||||
| 3c364f2f-58ae-4c3a-964b-02d70f7a6fe8 | 2026-09-04 12:49 | 2026-09-04 12:49 | 2026-09-04 12:49 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 113.5900 | 112.1000 | 113.6500 | 1003.6450 | 374855.00 | 340895.00 | 33960.00 | 33 | 13 | 750 | 5131 | 0.146170337166244 | 0.562969510780939 | 0.561853613754123 | false | false | false | true | ||||||||||||||||
| 8930ec44-73c7-4c5b-87b1-39555b1d5463 | 2026-09-10 09:49 | 2026-09-10 09:49 | 2026-09-10 09:49 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 99.2000 | 96.0500 | 99.2000 | 991.7300 | 634865.00 | 634865.00 | 0.00 | 64 | 32 | 112 | 4605 | 0.0243213897937025 | 0.631609452335302 | 0.630055030293134 | false | false | false | true | ||||||||||||||||
| 794242b3-0640-493c-a651-b93af1ba8dd8 | 2026-09-11 09:39 | 2026-09-11 09:39 | 2026-09-11 09:39 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 84.8600 | 84.1000 | 86.1000 | 979.4900 | 288520.00 | 93660.00 | 186450.00 | 34 | 6 | 39 | 4774 | 0.00816925010473398 | 0.522042640435449 | 0.546453461913406 | true | false | false | true | ||||||||||||||||
| 2dafd2e0-2242-4aed-9413-1395ef5ef5eb | 2026-09-17 09:35 | 2026-09-17 09:35 | 2026-09-17 09:35 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 76.4600 | 75.1500 | 80.7000 | 978.2000 | 229388.00 | 0.00 | 229388.00 | 30 | 6 | 148 | 4356 | 0.0339761248852158 | 1.18469115296311 | 0.831647555727883 | false | false | false | true | ||||||||||||||||
| 6398500f-0745-412c-a7c7-54471dc8f9d1 | 2026-09-17 09:41 | 2026-09-17 09:41 | 2026-09-17 09:41 | MU | MU260918C00900000 | call | 900.0000 | 2026-09-18 | 73.6600 | 72.0500 | 76.1500 | 973.4700 | 184161.00 | 0.00 | 184161.00 | 25 | 8 | 201 | 4356 | 0.0461432506887052 | 1.15571278446475 | 0.843981559555067 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-19T13:32:56.078945Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T13:57:36.320523Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T13:38:22.111482Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:35:49.066709Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T13:45:03.310585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T13:45:37.268469Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T14:09:16.630592Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T16:50:32.806937Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T13:52:43.061304Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T13:46:58.036194Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1103981805103.00 |
| 2026-09-30 |
| postmarket |
| — |
| 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 |
| 1103981805103.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:47:44.789077Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |