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 |
|---|
| 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 |
|---|
| 8fe16ae3-aad5-4628-8f9b-ef18d650d22a | 2026-09-21 11:55 | 2026-09-21 11:55 | 2026-09-21 11:55 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 10.6600 | 10.6500 | 11.1000 | 1035.9000 | 53286.00 | 0.00 | 53286.00 | 50 | 9 | 2297 | 2396 | 0.958681135225376 | 0.776192157312563 | 0.778986183631333 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1179041273918.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:56:02.019393Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 0415af80-1590-4ba8-88eb-3611f5580ff4 | 2026-09-22 09:50 | 2026-09-22 09:50 | 2026-09-22 09:50 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 14.9900 | 14.6000 | 15.0000 | 1063.5500 | 19490.00 | 17995.00 | 1495.00 | 13 | 5 | 1436 | 2711 | 0.529693839911472 | 0.80226107278127 | 0.801967726971887 | false | false | false | |||||||||||||||||
| 19307840-9ad5-474b-b5de-90e519dc98bc | 2026-09-22 15:03 | 2026-09-22 15:03 | 2026-09-22 15:03 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 22.5100 | 22.5000 | 22.9500 | 1091.9000 | 67529.00 | 2255.00 | 65274.00 | 30 | 11 | 5056 | 2711 | 1.86499446698635 | 0.81783017454058 | 0.818671262784159 | false | false | false | |||||||||||||||||
| 12eacf91-7fbd-4ac0-b0ab-275a318f4385 | 2026-09-22 15:03 | 2026-09-22 15:03 | 2026-09-22 15:03 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 22.5000 | 22.5000 | 23.0000 | 1092.0000 | 101259.00 | 0.00 | 101259.00 | 45 | 10 | 5026 | 2711 | 1.85392843969015 | 0.817380778860062 | 0.817380778860062 | false | false | false | |||||||||||||||||
| 5066e0f0-d70d-473e-aa42-fe5ba4d72896 | 2026-09-24 15:50 | 2026-09-24 15:50 | 2026-09-24 15:50 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 15.1000 | 14.7000 | 15.4500 | 1077.7200 | 13589.00 | 13589.00 | 0.00 | 9 | 7 | 3662 | 4215 | 0.868801897983393 | 0.834281991731703 | 0.834859127482086 | false | false | false | |||||||||||||||||
| 171c6ae1-7e74-485b-a789-565420fe282e | 2026-09-25 15:59 | 2026-09-25 15:59 | 2026-09-25 15:59 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 12.5700 | 12.5500 | 12.6500 | 1075.0000 | 17592.00 | 3787.00 | 13805.00 | 14 | 9 | 5751 | 4959 | 1.15970961887477 | 0.811028749830857 | 0.812234397807991 | false | false | false | |||||||||||||||||
| 8a68482a-a4ed-482e-a69a-bb5f60b21ee0 | 2026-09-28 12:49 | 2026-09-28 12:48 | 2026-09-28 12:48 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 7.0800 | 7.0000 | 7.1000 | 1050.0000 | 70832.00 | 47567.00 | 0.00 | 100 | 8 | 8603 | 5673 | 1.51648157941125 | 1.0338846361838 | 1.03602992630333 | false | false | false | |||||||||||||||||
| fd4c4a4f-e3d4-42b5-9f44-24b0165aed99 | 2026-09-28 12:51 | 2026-09-28 12:51 | 2026-09-28 12:51 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 6.9200 | 6.8500 | 6.9500 | 1054.0900 | 13848.00 | 12468.00 | 0.00 | 20 | 9 | 9089 | 5673 | 1.60215053763441 | 1.0334954280494 | 1.0334954280494 | false | false | false | |||||||||||||||||
| 9f281c3a-ace8-4914-901b-351deb3610b7 | 2026-09-28 15:51 | 2026-09-28 15:51 | 2026-09-28 15:51 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 5.9300 | 5.9000 | 6.0000 | 1052.9200 | 32630.00 | 0.00 | 11210.00 | 55 | 5 | 11417 | 5673 | 2.01251542393795 | 0.993996417406372 | 0.99718633767623 | false | false | false | |||||||||||||||||
| 5ca5228b-3e0b-42dc-a229-df038746b24a | 2026-09-29 10:17 | 2026-09-29 10:17 | 2026-09-29 10:17 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 8.1400 | 8.0000 | 8.1500 | 1077.6499 | 17906.00 | 17906.00 | 0.00 | 22 | 6 | 3537 | 8413 | 0.420420777368358 | 1.09843435444968 | 1.09843435444968 | false | false | false | |||||||||||||||||
| ec09fefa-02e5-45ea-b773-2d2547c6d697 | 2026-09-29 11:33 | 2026-09-29 11:33 | 2026-09-29 11:33 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 7.0000 | 6.8500 | 7.0000 | 1060.0000 | 209998.00 | 209998.00 | 0.00 | 300 | 9 | 6839 | 8413 | 0.812908593842862 | 1.12323161914989 | 1.12371176330337 | false | false | false | |||||||||||||||||
| 6bedf9e2-eac0-4704-9224-22233100238d | 2026-09-30 10:20 | 2026-09-30 10:19 | 2026-09-30 10:19 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 7.2000 | 7.2000 | 7.3500 | 1072.9601 | 529319.00 | 0.00 | 529319.00 | 735 | 47 | 4247 | 9630 | 0.441017653167186 | 1.33269291408753 | 1.33269291408753 | false | false | false | |||||||||||||||||
| e9f0e88f-baae-41a8-be43-83bb19f22e62 | 2026-09-30 10:40 | 2026-09-30 10:40 | 2026-09-30 10:40 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 6.6100 | 6.6000 | 6.7000 | 1070.2900 | 49548.00 | 0.00 | 49548.00 | 75 | 6 | 4885 | 9630 | 0.507268951194185 | 1.31955703834829 | 1.32063456489187 | false | false | false | |||||||||||||||||
| 4bb7821c-4c9d-49aa-be0c-2b4f07e6fc84 | 2026-09-30 10:53 | 2026-09-30 10:53 | 2026-09-30 10:53 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 7.2700 | 7.2000 | 7.3000 | 1070.0000 | 72658.00 | 72658.00 | 0.00 | 100 | 16 | 5491 | 9630 | 0.570197300103842 | 1.3084566607975 | 1.31013151098185 | true | false | false | |||||||||||||||||
| f06c9955-fdf9-4017-8e1d-e31d037649e5 | 2026-09-30 15:53 | 2026-09-30 15:53 | 2026-09-30 15:53 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 6.8600 | 6.8500 | 6.9500 | 1065.0000 | 17147.00 | 0.00 | 17147.00 | 25 | 5 | 15536 | 9630 | 1.61329179646937 | 1.33771758162992 | 1.33947004034393 | false | false | false | |||||||||||||||||
| da48a68d-abdf-4f43-a2eb-a6cc24c1ae53 | 2026-09-30 15:59 | 2026-09-30 15:59 | 2026-09-30 15:59 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 6.4100 | 6.3500 | 6.5000 | 1065.8650 | 79510.00 | 79510.00 | 0.00 | 124 | 6 | 17115 | 9630 | 1.77725856697819 | 1.3411395604947 | 1.3472193609325 | false | false | false | |||||||||||||||||
| 4e6d3a27-91fb-4bfd-9b97-216ece673ae9 | 2026-09-30 15:59 | 2026-09-30 15:59 | 2026-09-30 15:59 | MU | MU261002C01200000 | call | 1200.0000 | 2026-10-02 | 6.4800 | 6.4500 | 6.6000 | 1060.0000 | 18140.00 | 1310.00 | 12900.00 | 28 | 7 | 17494 | 9630 | 1.81661474558671 | 1.33741238522219 | 1.34632497780476 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:50:24.302840Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:53:57.742588Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:49:03.667640Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T16:56:37.183860Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T19:53:15.788869Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:18:33.635703Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:33:47.985859Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:20:51.632634Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:42:27.796047Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T14:54:10.101725Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:54:17.966040Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:59:18.109572Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |