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 |
|---|
| 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 |
|---|
| ccdacba1-4e42-4307-8d4b-670320f25f22 | 2026-09-28 10:18 | 2026-09-28 10:18 | 2026-09-28 10:18 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 19.6500 | 19.4500 | 19.7500 | 1049.8100 | 37340.00 | 23595.00 | 13745.00 | 19 | 8 | 959 | 2559 | 0.374755763970301 | 0.932746702740756 | 0.931418968800496 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 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 |
| 884d933d-e178-4601-b68d-757d9eee56f2 | 2026-09-25 10:26 | 2026-09-25 10:26 | 2026-09-25 10:26 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 15.9400 | 15.5500 | 15.9500 | 1079.4900 | 149869.00 | 149869.00 | 0.00 | 94 | 26 | 666 | 2113 | 0.315191670610506 | 0.789423454338952 | 0.786594572135696 | false | false | false | |||||||||||||||||
| e13299e3-c702-4613-8e81-217f6f3ee453 | 2026-09-24 09:34 | 2026-09-24 09:34 | 2026-09-24 09:34 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 29.0100 | 28.7000 | 29.7000 | 1046.9000 | 40620.00 | 20310.00 | 20310.00 | 14 | 6 | 50 | 1713 | 0.0291885580852306 | 0.816668165867148 | 0.81476377312261 | true | false | false | |||||||||||||||||
| b7167ab3-2ce5-4db7-9cff-90733c2044cb | 2026-09-21 10:09 | 2026-09-21 10:09 | 2026-09-21 10:09 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 33.8300 | 32.9500 | 34.0500 | 1037.1300 | 16915.00 | 6760.00 | 10155.00 | 5 | 5 | 532 | 799 | 0.665832290362954 | 0.721759191977576 | 0.719317556511115 | false | false | false | |||||||||||||||||
| b1394657-d8f2-4506-bfc1-f57030a63cfb | 2026-09-18 12:55 | 2026-09-18 12:55 | 2026-09-18 12:55 | MU | MU261002P01000000 | put | 1000.0000 | 2026-10-02 | 53.3800 | 52.5500 | 53.8000 | 994.4150 | 277595.00 | 10655.00 | 117420.00 | 52 | 20 | 140 | 467 | 0.299785867237687 | 0.660058272473606 | 0.656069592947274 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T14:29:28.038338Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 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 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:10:29.738922Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1147237562786.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |