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_alerts523,327 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 |
|---|
| 3e9e9627-6935-4aab-a847-dbd3d8ea7423 | 2026-09-28 14:31 | 2026-09-28 14:31 | 2026-09-28 14:31 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 18.0000 | 18.0000 | 18.1500 | 1054.1800 | 14402.00 | 0.00 | 14402.00 | 8 | 8 | 3130 | 2559 | 1.2231340367331 | 0.92023186437486 | 0.92023186437486 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1190357793291.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T18:38:54.071675Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| eec53442-6559-449c-9d81-5615f423b005 | 2026-09-28 11:50 | 2026-09-28 11:50 | 2026-09-28 11:50 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 22.6500 | 22.5500 | 22.8000 | 1041.7619 | 74745.00 | 2265.00 | 72480.00 | 33 | 13 | 1978 | 2559 | 0.772958186791715 | 0.944165246977069 | 0.945576722656109 | false | false | false | true | ||||||||||||||||
| a049ab6a-7169-4cc0-ab23-41649c68ebf7 | 2026-09-28 10:58 | 2026-09-28 10:58 | 2026-09-28 10:58 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 24.3000 | 24.3000 | 24.5000 | 1038.3100 | 53460.00 | 0.00 | 53460.00 | 22 | 5 | 1695 | 2559 | 0.662368112543962 | 0.959052623428132 | 0.958841560393996 | false | false | false | true | ||||||||||||||||
| 82b2ab8f-f7a7-4048-b8b7-4e0fe1e3ae45 | 2026-09-28 10:48 | 2026-09-28 10:47 | 2026-09-28 10:47 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 25.8500 | 25.8500 | 26.0000 | 1032.7100 | 12926.00 | 0.00 | 12926.00 | 5 | 5 | 1480 | 2559 | 0.578350918327472 | 0.949503728539288 | 0.949503728539288 | false | false | false | true | ||||||||||||||||
| 001424d5-2bbb-457c-9780-8cef2a440fdb | 2026-09-28 10:46 | 2026-09-28 10:46 | 2026-09-28 10:46 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 25.2000 | 25.2000 | 25.4000 | 1030.0000 | 20160.00 | 0.00 | 20160.00 | 8 | 8 | 1452 | 2559 | 0.567409144196952 | 0.94975939871077 | 0.951490532977353 | false | false | false | true | ||||||||||||||||
| cdb3ceee-b43f-4cdb-9f8c-bb7e88458be8 | 2026-09-28 10:45 | 2026-09-28 10:45 | 2026-09-28 10:45 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 25.0000 | 24.9000 | 25.1000 | 1035.6400 | 22500.00 | 20000.00 | 0.00 | 9 | 8 | 1436 | 2559 | 0.561156701836655 | 0.953722132767376 | 0.953722132767376 | false | false | false | true | ||||||||||||||||
| d78d5582-288c-4d20-aee5-a8e518be2757 | 2026-09-28 10:19 | 2026-09-28 10:19 | 2026-09-28 10:19 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 19.5600 | 19.5500 | 19.8000 | 1050.5150 | 105645.00 | 0.00 | 105645.00 | 54 | 8 | 1033 | 2559 | 0.403673309886674 | 0.934188725481215 | 0.934188725481215 | true | false | false | true | ||||||||||||||||
| c21e07a4-e5ee-422f-b00e-31abe6eba513 | 2026-09-28 10:16 | 2026-09-28 10:16 | 2026-09-28 10:16 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 19.7500 | 19.7500 | 19.9000 | 1049.2301 | 197500.00 | 0.00 | 197500.00 | 100 | 31 | 916 | 2559 | 0.357952325127003 | 0.929589422094423 | 0.929589422094423 | false | false | false | true | ||||||||||||||||
| 7d393da6-529f-4796-b319-7e44a11f7252 | 2026-09-28 09:56 | 2026-09-28 09:56 | 2026-09-28 09:56 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 17.0500 | 17.0500 | 17.2500 | 1061.2900 | 18755.00 | 0.00 | 18755.00 | 11 | 11 | 589 | 2559 | 0.230168034388433 | 0.946003499417498 | 0.946003499417498 | false | false | false | true | ||||||||||||||||
| 789cef71-de19-468f-8442-b411d9218268 | 2026-09-28 09:43 | 2026-09-28 09:43 | 2026-09-28 09:43 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 17.5400 | 17.5000 | 17.7500 | 1063.9008 | 15785.00 | 0.00 | 15785.00 | 9 | 5 | 349 | 2559 | 0.136381398983978 | 0.978642731804362 | 0.977243063550636 | true | false | false | true | ||||||||||||||||
| c67f34d2-465b-441c-b9e6-bd0048e9ce91 | 2026-09-28 09:41 | 2026-09-28 09:41 | 2026-09-28 09:41 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 16.5500 | 16.5500 | 16.8000 | 1066.0100 | 14895.00 | 0.00 | 14895.00 | 9 | 9 | 281 | 2559 | 0.109808518952716 | 0.965320581934795 | 0.965320581934795 | false | false | false | true | ||||||||||||||||
| 83a3338a-9afd-45d0-8522-988920091307 | 2026-09-25 09:57 | 2026-09-25 09:57 | 2026-09-25 09:57 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 14.3000 | 14.3000 | 14.6000 | 1086.4134 | 12870.00 | 0.00 | 12870.00 | 9 | 6 | 346 | 2113 | 0.163748225272125 | 0.783265810042444 | 0.783809419495999 | false | false | false | true | ||||||||||||||||
| 0e200854-68b2-41d5-a48c-4c7f6f9515b2 | 2026-09-24 09:35 | 2026-09-24 09:35 | 2026-09-24 09:35 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 29.0900 | 28.4000 | 29.1500 | 1047.3100 | 14545.00 | 8730.00 | 5815.00 | 5 | 5 | 56 | 1713 | 0.0326911850554583 | 0.819842473227486 | 0.819842473227486 | false | false | false | true | ||||||||||||||||
| 3a249b25-ae80-452c-8b67-c9a0b9e7f431 | 2026-09-23 13:48 | 2026-09-23 13:48 | 2026-09-23 13:48 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 21.2000 | 21.0000 | 21.3500 | 1065.0000 | 21200.00 | 12720.00 | 0.00 | 10 | 5 | 820 | 1420 | 0.577464788732394 | 0.763275710160301 | 0.763275710160301 | false | false | false | true | ||||||||||||||||
| f1996339-3936-4640-a182-6e580a30a42b | 2026-09-23 13:24 | 2026-09-23 13:24 | 2026-09-23 13:24 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 22.0900 | 21.4500 | 22.1500 | 1069.3200 | 13255.00 | 8840.00 | 4415.00 | 6 | 6 | 796 | 1420 | 0.56056338028169 | 0.765004127334156 | 0.765004127334156 | true | false | false | true | ||||||||||||||||
| 33a18e0a-c9d9-4e94-b4c3-ffeee424e8cf | 2026-09-23 10:08 | 2026-09-23 10:08 | 2026-09-23 10:08 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 18.0000 | 17.4000 | 18.0000 | 1088.8100 | 18000.00 | 18000.00 | 0.00 | 10 | 5 | 305 | 1420 | 0.214788732394366 | 0.777054733896779 | 0.777054733896779 | false | false | false | true | ||||||||||||||||
| 6e22762a-ad3c-4049-a43c-aa68d41cb9ed | 2026-09-18 14:52 | 2026-09-18 14:52 | 2026-09-18 14:52 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 47.2000 | 46.8500 | 47.5500 | 1008.3050 | 269040.00 | 212400.00 | 0.00 | 57 | 6 | 525 | 467 | 1.12419700214133 | 0.663323907245997 | 0.663323907245997 | true | false | false | true | ||||||||||||||||
| 278a3e94-df84-42b3-8386-e12c52ab4206 | 2026-08-27 14:28 | 2026-08-27 14:28 | 2026-08-27 14:28 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 128.8500 | 123.5000 | 128.8500 | 909.6780 | 322125.00 | 322125.00 | 0.00 | 25 | 6 | 25 | 33 | 0.757575757575758 | 0.655202312499107 | 0.655202312499107 | false | false | false | true |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:53:41.284908Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T15:01:52.060675Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:48:11.739629Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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-28T14:47:02.150049Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:45:44.474621Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:22:37.821840Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T14:18:45.811547Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:56:17.476262Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:45:28.249714Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1190357793291.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-28T13:43:35.547112Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 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:58:47.547545Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-24T13:35:42.562828Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T17:48:41.957434Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T17:25:27.822923Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-23T14:09:27.878659Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1147237562786.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| 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-27T18:43:44.836810Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |