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 |
|---|
| expirydate |
|---|
| 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 |
|---|
| fb8216de-b9e5-4054-bdf8-4e7091d4bd93 | 2026-09-25 09:35 | 2026-09-25 09:34 | 2026-09-25 09:34 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 0.7800 | 0.7800 | 0.8400 | 1106.5800 | 37992.00 | 0.00 | 37992.00 | 486 | 11 | 963 | 4550 | 0.211648351648352 | 0.501002955484261 | 0.499711867880564 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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:35:49.891887Z"} | 2026-09-25 | 2026-09-25 21:15 | 2026-09-25 21:15 |
| 4f93002b-3c1a-4a4d-a538-d6e28df460ff | 2026-09-24 15:59 | 2026-09-24 15:59 | 2026-09-24 15:59 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 0.5100 | 0.5100 | 0.5300 | 1075.0000 | 10781.00 | 0.00 | 9741.00 | 211 | 12 | 6981 | 2826 | 2.47027600849257 | 0.501035035165953 | 0.499500479662333 | false | false | false | |||||||||||||||||
| a2c35aee-11fe-4e5e-a5d4-0c2a2ec03569 | 2026-09-24 15:31 | 2026-09-24 15:31 | 2026-09-24 15:31 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 0.5000 | 0.4900 | 0.5000 | 1076.6700 | 24696.00 | 24500.00 | 196.00 | 494 | 11 | 5230 | 2826 | 1.85067232837933 | 0.512583467570231 | 0.512583467570231 | false | false | false | |||||||||||||||||
| 7020c45d-7b72-49a2-a2df-f99b4705157f | 2026-09-24 14:25 | 2026-09-24 14:25 | 2026-09-24 14:25 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 0.4100 | 0.4000 | 0.4100 | 1069.5200 | 10414.00 | 10414.00 | 0.00 | 254 | 18 | 4254 | 2826 | 1.50530785562633 | 0.523544488710721 | 0.523544488710721 | false | false | false | |||||||||||||||||
| 8afe4d8b-061a-4cc5-ae76-8ba2729a9878 | 2026-09-24 14:23 | 2026-09-24 14:23 | 2026-09-24 14:23 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 0.3900 | 0.3800 | 0.3900 | 1068.2201 | 13143.00 | 13143.00 | 0.00 | 337 | 7 | 3974 | 2826 | 1.40622788393489 | 0.524457383502831 | 0.524457383502831 | false | false | false | |||||||||||||||||
| 63422550-7779-4166-bda9-830d176d3049 | 2026-09-22 15:07 | 2026-09-22 15:07 | 2026-09-22 15:07 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 4.0400 | 4.0000 | 4.0500 | 1093.6000 | 16578.00 | 16578.00 | 0.00 | 41 | 8 | 6301 | 1034 | 6.09381044487427 | 0.566933069339946 | 0.566550994959729 | false | false | false | |||||||||||||||||
| 2eb28cdf-f16b-4c19-81cf-ad108308d04b | 2026-09-22 14:29 | 2026-09-22 14:29 | 2026-09-22 14:29 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 3.4400 | 3.3000 | 3.4500 | 1087.9400 | 41322.00 | 41322.00 | 0.00 | 120 | 19 | 5777 | 1034 | 5.58704061895551 | 0.566098056441876 | 0.564831523129469 | false | false | false | |||||||||||||||||
| 705059fe-1669-4d53-8557-32b599240021 | 2026-09-22 12:14 | 2026-09-22 12:14 | 2026-09-22 12:14 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 2.5700 | 2.5200 | 2.5700 | 1079.4491 | 12850.00 | 12850.00 | 0.00 | 50 | 9 | 4655 | 1034 | 4.50193423597679 | 0.559109467612637 | 0.559109467612637 | false | false | false | |||||||||||||||||
| b2542c1a-1236-44b4-b066-fe5051790510 | 2026-09-22 12:09 | 2026-09-22 12:09 | 2026-09-22 12:09 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 2.7900 | 2.7900 | 2.8400 | 1081.1350 | 95139.00 | 0.00 | 95139.00 | 341 | 26 | 4264 | 1034 | 4.12379110251451 | 0.563429218580764 | 0.563429218580764 | false | false | false | |||||||||||||||||
| 01071c5c-69ca-43e3-892a-1adbff2e15b7 | 2026-09-22 12:09 | 2026-09-22 12:09 | 2026-09-22 12:09 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 2.7900 | 2.7900 | 2.8300 | 1081.1350 | 39618.00 | 0.00 | 39618.00 | 142 | 5 | 4406 | 1034 | 4.26112185686654 | 0.563429218580764 | 0.563429218580764 | false | false | false | |||||||||||||||||
| 0fb8f0d0-43d3-4499-a58d-db931ddfe7c1 | 2026-09-22 12:09 | 2026-09-22 12:09 | 2026-09-22 12:09 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 2.7800 | 2.7800 | 2.8200 | 1080.8200 | 48928.00 | 0.00 | 48928.00 | 176 | 10 | 3598 | 1034 | 3.47969052224371 | 0.564173329269784 | 0.564173329269784 | false | false | false | |||||||||||||||||
| 537e2ede-0ba5-4458-973d-bae90fa01458 | 2026-09-22 12:08 | 2026-09-22 12:08 | 2026-09-22 12:08 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 2.8400 | 2.8400 | 2.9000 | 1081.5900 | 142006.00 | 574.00 | 141432.00 | 500 | 12 | 3419 | 1034 | 3.30657640232108 | 0.565471459295547 | 0.564047473016898 | false | false | false | |||||||||||||||||
| a72ed8d0-908e-478e-8413-55611f3d8a66 | 2026-09-22 12:07 | 2026-09-22 12:07 | 2026-09-22 12:07 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 2.6400 | 2.6100 | 2.6500 | 1079.1300 | 43296.00 | 43296.00 | 0.00 | 164 | 16 | 2611 | 1034 | 2.52514506769826 | 0.563851156900913 | 0.563851156900913 | false | false | false | |||||||||||||||||
| 444e19e2-5084-4e5b-b885-5b4a0de0b3d7 | 2026-09-22 12:07 | 2026-09-22 12:06 | 2026-09-22 12:06 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 2.6300 | 2.6000 | 2.6300 | 1079.0900 | 11572.00 | 1315.00 | 0.00 | 44 | 5 | 2447 | 1034 | 2.36653771760155 | 0.563505938885805 | 0.563505938885805 | true | false | false | |||||||||||||||||
| 813017a6-2d22-4a66-8294-54054b498e79 | 2026-09-22 12:06 | 2026-09-22 12:06 | 2026-09-22 12:06 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 2.6500 | 2.6000 | 2.6500 | 1078.8100 | 68860.00 | 68860.00 | 0.00 | 260 | 13 | 2157 | 1034 | 2.08607350096712 | 0.565275890736784 | 0.565085423202003 | false | false | false | |||||||||||||||||
| 7a5bebc4-5a7d-44c3-a62f-31d1b3375d66 | 2026-09-22 12:02 | 2026-09-22 12:02 | 2026-09-22 12:02 | MU | MU260928C01200000 | call | 1200.0000 | 2026-09-28 | 2.4500 | 2.4000 | 2.4500 | 1077.3000 | 122484.00 | 118580.00 | 0.00 | 500 | 10 | 1771 | 1034 | 1.71276595744681 | 0.561169677067766 | 0.560646747451165 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:37:02.882742Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:26:21.590036Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T18:26:21.590036Z"} |
| 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:10:39.996631Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T18:29:55.439380Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:20:35.100506Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:12:44.237245Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:12:44.237245Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:12:44.237245Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T16:12:44.237245Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T16:07:35.242191Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |