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_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 | 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 |
|---|
| 22c2dc99-a6d7-486a-8abd-72c0c3a1f678 | 2026-09-21 10:58 | 2026-09-21 10:58 | 2026-09-21 10:58 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 2.2600 | 2.2600 | 2.3600 | 494.0000 | 57178.00 | 0.00 | 57178.00 | 253 | 19 | 580 | 9071 | 0.0639400286627715 | 0.238472507293299 | 0.238472507293299 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 3724727873741.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T14:59:04.068372Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| b3d45ab3-aa52-480a-8ba6-3168b34bf0c2 | 2026-09-21 11:06 | 2026-09-21 11:06 | 2026-09-21 11:06 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 2.1000 | 2.0700 | 2.1400 | 493.1200 | 14910.00 | 8400.00 | 6510.00 | 71 | 11 | 1081 | 9071 | 0.119170984455959 | 0.237524587296399 | 0.237281688041757 | false | false | false | true | ||||||||||||||||
| 5fe17f54-718c-450f-9cf4-2b35cd73489c | 2026-09-21 11:06 | 2026-09-21 11:06 | 2026-09-21 11:06 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 2.1000 | 2.0700 | 2.1400 | 493.1200 | 33180.00 | 19740.00 | 13440.00 | 158 | 39 | 1239 | 9071 | 0.136589130195127 | 0.237281688041757 | 0.237281688041757 | false | false | false | true | ||||||||||||||||
| 2ced3a6a-2618-421c-8c86-1dea90bfc440 | 2026-09-21 11:06 | 2026-09-21 11:06 | 2026-09-21 11:06 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 2.1000 | 2.0700 | 2.1000 | 493.1434 | 22890.00 | 22890.00 | 0.00 | 109 | 21 | 1375 | 9071 | 0.15158196450226 | 0.237168000280795 | 0.237168000280795 | false | false | false | true | ||||||||||||||||
| 95d04540-4091-4df0-a03f-eaaea6f5d921 | 2026-09-21 12:06 | 2026-09-21 12:06 | 2026-09-21 12:06 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 2.3800 | 2.3800 | 2.5000 | 494.4912 | 46410.00 | 0.00 | 46410.00 | 195 | 23 | 1751 | 9071 | 0.193032741704332 | 0.240031519811242 | 0.240031519811242 | false | false | false | true | ||||||||||||||||
| d99bda44-7b20-4c58-80e2-187391bcde7b | 2026-09-21 13:15 | 2026-09-21 13:15 | 2026-09-21 13:15 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 2.8100 | 2.8100 | 2.9200 | 497.0101 | 14050.00 | 0.00 | 14050.00 | 50 | 6 | 1884 | 9071 | 0.207694851725278 | 0.240734641222839 | 0.240734641222839 | false | false | false | true | ||||||||||||||||
| ca90aaa9-95f1-4137-988d-220f2510b04e | 2026-09-22 09:42 | 2026-09-22 09:42 | 2026-09-22 09:42 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 3.6000 | 3.5000 | 3.6000 | 499.1404 | 15120.00 | 12600.00 | 0.00 | 42 | 19 | 203 | 9077 | 0.0223642172523962 | 0.257432389669255 | 0.257432389669255 | false | false | false | true | ||||||||||||||||
| 7fbb6970-be7b-4096-9895-c664c59569d3 | 2026-09-23 15:38 | 2026-09-23 15:38 | 2026-09-23 15:38 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 3.4000 | 3.2500 | 3.4000 | 499.7150 | 31960.00 | 31960.00 | 0.00 | 94 | 11 | 2194 | 12699 | 0.17276950941019 | 0.254271582073191 | 0.254271582073191 | false | false | false | true | ||||||||||||||||
| fc23dd2c-68be-4e43-b161-f079e862360d | 2026-09-25 09:34 | 2026-09-25 09:34 | 2026-09-25 09:34 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 5.0000 | 4.7500 | 5.0000 | 508.0000 | 27480.00 | 26495.00 | 985.00 | 55 | 6 | 214 | 12019 | 0.0178051418587237 | 0.252964602181046 | 0.251393930060069 | false | false | false | true | ||||||||||||||||
| 3408d1e2-8dfe-4fd0-be61-50fdf1fca81f | 2026-09-25 09:43 | 2026-09-25 09:43 | 2026-09-25 09:43 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 6.6000 | 6.4500 | 6.6000 | 513.4100 | 179520.00 | 179520.00 | 0.00 | 272 | 26 | 1769 | 12019 | 0.147183625925618 | 0.257730861622699 | 0.257730861622699 | true | false | false | true | ||||||||||||||||
| eb610e2e-5195-4695-b776-fb8beec6ad65 | 2026-09-25 10:09 | 2026-09-25 10:09 | 2026-09-25 10:09 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 6.2500 | 6.2500 | 6.4500 | 511.0000 | 115625.00 | 0.00 | 115625.00 | 185 | 11 | 3413 | 12019 | 0.283967052167402 | 0.263212641938203 | 0.261991995707018 | false | false | false | true | ||||||||||||||||
| bb44676a-4dad-4223-8077-d6e0b348e95d | 2026-09-25 12:20 | 2026-09-25 12:20 | 2026-09-25 12:20 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 7.2500 | 7.2500 | 7.5000 | 515.0000 | 21750.00 | 0.00 | 21750.00 | 30 | 10 | 4257 | 12019 | 0.354189200432648 | 0.257646517589957 | 0.257646517589957 | true | false | false | true | ||||||||||||||||
| 04645a67-8cf8-4a3b-8d00-19f6ab6774a4 | 2026-09-25 12:20 | 2026-09-25 12:20 | 2026-09-25 12:20 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 7.0800 | 7.0000 | 7.2500 | 514.7250 | 13447.00 | 5648.00 | 7799.00 | 19 | 7 | 4282 | 12019 | 0.356269240369415 | 0.259694037211865 | 0.259473970426857 | false | false | false | true | ||||||||||||||||
| 417eda4b-0ca5-4e34-b6a3-d74a4a390c39 | 2026-09-25 12:21 | 2026-09-25 12:20 | 2026-09-25 12:20 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 7.0000 | 6.9000 | 7.1500 | 514.6700 | 13300.00 | 5600.00 | 7700.00 | 19 | 5 | 4301 | 12019 | 0.357850070721358 | 0.256868155027684 | 0.257245336507182 | true | false | false | true | ||||||||||||||||
| d7b371f1-58f3-4aa1-973c-94a85426aeb9 | 2026-09-25 12:40 | 2026-09-25 12:40 | 2026-09-25 12:40 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 7.3500 | 7.3500 | 7.5000 | 515.9350 | 16170.00 | 0.00 | 16170.00 | 22 | 9 | 4372 | 12019 | 0.363757384141775 | 0.255256334378406 | 0.255256334378406 | true | false | false | true | ||||||||||||||||
| 96c053ad-1caa-4103-8431-f9078e07ad38 | 2026-09-25 13:59 | 2026-09-25 13:59 | 2026-09-25 13:59 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 8.0000 | 7.5500 | 8.0500 | 517.9500 | 12800.00 | 12000.00 | 800.00 | 16 | 5 | 4598 | 12019 | 0.382560945170147 | 0.254391646563192 | 0.253350698046234 | false | false | false | true | ||||||||||||||||
| a40ded8b-9961-4778-8971-79cc73ccf5fe | 2026-09-25 14:26 | 2026-09-25 14:26 | 2026-09-25 14:26 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 8.4000 | 8.2500 | 8.4000 | 518.2200 | 55440.00 | 55440.00 | 0.00 | 66 | 11 | 4750 | 12019 | 0.395207587985689 | 0.259619334967841 | 0.259619334967841 | false | false | false | true | ||||||||||||||||
| 52fe1ecf-ba19-410d-815e-367a9e7b2bf0 | 2026-09-25 15:24 | 2026-09-25 15:24 | 2026-09-25 15:24 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 7.3000 | 7.3000 | 7.5000 | 515.8500 | 25550.00 | 0.00 | 25550.00 | 35 | 9 | 4952 | 12019 | 0.412014310674765 | 0.254825277517708 | 0.254825277517708 | false | false | false | true | ||||||||||||||||
| fb6ea8e1-aa78-47f7-955d-0da7d75f836c | 2026-09-25 15:40 | 2026-09-25 15:40 | 2026-09-25 15:40 | MSFT | MSFT261016C00530000 | call | 530.0000 | 2026-10-16 | 7.2500 | 7.2500 | 7.5500 | 515.0000 | 126875.00 | 0.00 | 126875.00 | 175 | 25 | 5157 | 12019 | 0.429070638156253 | 0.25327727852525 | 0.25358474797193 | true | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:08:57.828180Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:07:39.472771Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:16:02.178873Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3697921654518.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3717153817340.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:42:45.926021Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:34:45.543817Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:45:37.818098Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:09:41.700516Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:20:53.748346Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:23:36.031471Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T16:23:36.031471Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| 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 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:00:15.336636Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:27:02.000981Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:24:28.165724Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 3832843816089.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T19:44:21.808017Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |