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 |
|---|
| 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 |
|---|
| 10ecc205-b16c-4031-9714-57e9ad4670f0 | 2026-09-21 11:46 | 2026-09-21 11:46 | 2026-09-21 11:46 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 0.1300 | 0.1300 | 0.1500 | 493.7350 | 11207.00 | 0.00 | 11207.00 | 834 | 22 | 23728 | 900 | 26.3644444444444 | 0.264654690535501 | 0.264654690535501 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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:49:21.879731Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 91f9bb41-b077-429d-84b9-3ac256c074c4 | 2026-09-21 12:06 | 2026-09-21 12:06 | 2026-09-21 12:06 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 0.1700 | 0.1500 | 0.1800 | 494.3200 | 17506.00 | 17473.00 | 33.00 | 1002 | 58 | 29040 | 900 | 32.2666666666667 | 0.264003623821685 | 0.258701093973144 | false | false | false | true | ||||||||||||||||
| c2329ae9-43ce-4f1d-894f-f6b64ea2ca66 | 2026-09-21 12:59 | 2026-09-21 12:59 | 2026-09-21 12:59 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 0.5200 | 0.5200 | 0.5500 | 496.4000 | 13000.00 | 0.00 | 13000.00 | 250 | 9 | 42584 | 900 | 47.3155555555556 | 0.26435976940648 | 0.26435976940648 | false | false | false | true | ||||||||||||||||
| 13cccf6d-27c9-48a1-9ecb-9e54c3221cd2 | 2026-09-21 13:00 | 2026-09-21 13:00 | 2026-09-21 13:00 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 0.5600 | 0.5500 | 0.5700 | 496.4900 | 13496.00 | 12936.00 | 560.00 | 241 | 39 | 42852 | 900 | 47.6133333333333 | 0.267663389928008 | 0.267663389928008 | false | false | false | true | ||||||||||||||||
| bdfa3a28-e7e9-4000-8f56-91950ad7e81e | 2026-09-21 13:00 | 2026-09-21 13:00 | 2026-09-21 13:00 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 0.6100 | 0.6100 | 0.6500 | 496.6600 | 15080.00 | 256.00 | 14824.00 | 247 | 10 | 43103 | 900 | 47.8922222222222 | 0.264726377061 | 0.264738731773597 | false | false | false | true | ||||||||||||||||
| 76a87d0c-b3e0-475f-ad4f-76d442ab34da | 2026-09-21 13:02 | 2026-09-21 13:02 | 2026-09-21 13:02 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 0.4700 | 0.4600 | 0.4900 | 496.3500 | 11750.00 | 0.00 | 11750.00 | 250 | 18 | 44346 | 900 | 49.2733333333333 | 0.253410828333643 | 0.255837208073809 | false | false | false | true | ||||||||||||||||
| 5cc14d18-d91f-4d47-a845-05c669e801e9 | 2026-09-21 13:12 | 2026-09-21 13:12 | 2026-09-21 13:12 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 0.5600 | 0.5400 | 0.5600 | 496.7099 | 11200.00 | 11200.00 | 0.00 | 200 | 6 | 46656 | 900 | 51.84 | 0.253909551608194 | 0.253909551608194 | false | false | false | true | ||||||||||||||||
| 754a4102-4acc-4a8b-8531-ccb2f94ff6d3 | 2026-09-21 13:15 | 2026-09-21 13:14 | 2026-09-21 13:14 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 0.6900 | 0.6500 | 0.7000 | 497.0200 | 14078.00 | 14078.00 | 0.00 | 204 | 10 | 47268 | 900 | 52.52 | 0.264107691251119 | 0.260969720643215 | false | false | false | true | ||||||||||||||||
| f00391f0-29eb-48d2-87e7-4f8100a146c9 | 2026-09-21 13:20 | 2026-09-21 13:20 | 2026-09-21 13:20 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 1.0400 | 1.0300 | 1.1300 | 497.0000 | 20891.00 | 0.00 | 20891.00 | 201 | 26 | 50354 | 900 | 55.9488888888889 | 0.26580661590337 | 0.262902353727888 | false | false | false | true | ||||||||||||||||
| 70e7f872-7810-457d-a9ca-afaea41be973 | 2026-09-21 13:24 | 2026-09-21 13:24 | 2026-09-21 13:24 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 0.7600 | 0.7600 | 0.8200 | 497.0000 | 10339.00 | 0.00 | 10339.00 | 136 | 8 | 51326 | 900 | 57.0288888888889 | 0.264991633844524 | 0.256152278884828 | false | false | false | true | ||||||||||||||||
| 4349557c-9bf3-43c9-9be3-bf4f9f3fd0d9 | 2026-09-21 13:54 | 2026-09-21 13:53 | 2026-09-21 13:53 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 1.7200 | 1.6100 | 1.7200 | 498.7800 | 16301.00 | 16131.00 | 170.00 | 95 | 8 | 55821 | 900 | 62.0233333333333 | 0.302079864794017 | 0.298290857291711 | true | false | false | true | ||||||||||||||||
| 6d30ecf8-a7cd-42fc-85b8-62af83354c77 | 2026-09-21 14:19 | 2026-09-21 14:19 | 2026-09-21 14:19 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 1.1300 | 1.0800 | 1.1800 | 498.1400 | 16914.00 | 13566.00 | 3348.00 | 150 | 9 | 58266 | 900 | 64.74 | 0.259528187546981 | 0.282733043026806 | false | false | false | true | ||||||||||||||||
| a97b964c-8f72-4d96-bf77-3064093cfd88 | 2026-09-21 14:38 | 2026-09-21 14:37 | 2026-09-21 14:37 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 0.8300 | 0.7700 | 0.8400 | 497.6380 | 16505.00 | 16505.00 | 0.00 | 200 | 10 | 59926 | 900 | 66.5844444444444 | 0.309449677105177 | 0.30540620138296 | false | false | false | true | ||||||||||||||||
| 0ab9d8a1-1177-413b-878a-d56ca8bf7796 | 2026-09-21 14:48 | 2026-09-21 14:48 | 2026-09-21 14:48 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 1.8600 | 1.8500 | 1.9600 | 499.0000 | 28474.00 | 0.00 | 28474.00 | 153 | 16 | 60953 | 900 | 67.7255555555556 | 0.310849512343603 | 0.323886335507566 | false | false | false | true | ||||||||||||||||
| 6740885d-871f-4b3f-a6ac-54a1afdf6fef | 2026-09-21 14:48 | 2026-09-21 14:48 | 2026-09-21 14:48 | MSFT | MSFT260921C00497500 | call | 497.5000 | 2026-09-21 | 1.8700 | 1.8600 | 1.9600 | 499.0000 | 25427.00 | 0.00 | 25427.00 | 136 | 7 | 61149 | 900 | 67.9433333333333 | 0.34517231506266 | 0.339063483950613 | false | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:02:00.389820Z"} |
| 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:02:00.389820Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:02:00.389820Z"} |
| 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:07:15.058898Z"} |
| 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 |
| 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 |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:20:55.206028Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T17:24:56.111062Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:55:32.885478Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:20:26.028708Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:42:48.011261Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:50:33.734980Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 3724727873741.00 |
| 2026-11-04 |
| unknown |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T18:50:33.734980Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |