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_alerts609,118 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 |
|---|
| e8b62cea-8abb-4beb-bcf9-70e5207c77ad | 2026-09-29 11:58 | 2026-09-29 11:58 | 2026-09-29 11:58 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 106.2400 | 104.4000 | 106.3000 | 1067.4300 | 127486.00 | 127486.00 | 0.00 | 12 | 11 | 316 | 2639 | 0.119742326638878 | 0.582678018264967 | 0.582929276709512 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1202894057267.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-29T16:02:30.295749Z"} | 2026-09-29 | 2026-09-29 21:15 | 2026-09-29 21:15 |
| 27060e7b-c613-4d2f-9be2-db6e3df243bc | 2026-09-29 11:52 | 2026-09-29 11:52 | 2026-09-29 11:52 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 105.3100 | 104.6500 | 105.4000 | 1065.1350 | 52655.00 | 10535.00 | 10500.00 | 5 | 5 | 304 | 2639 | 0.115195149677908 | 0.584688263064959 | 0.582674729995178 | false | false | false | |||||||||||||||||
| 97426244-15d7-4267-8c83-f0424589a731 | 2026-09-29 10:35 | 2026-09-29 10:35 | 2026-09-29 10:35 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 113.2100 | 112.9500 | 114.4000 | 1080.5000 | 464175.00 | 11365.00 | 452810.00 | 41 | 9 | 257 | 2639 | 0.0973853732474422 | 0.582229425738214 | 0.582842432460043 | false | false | false | |||||||||||||||||
| 43772d56-9d2e-4264-b32c-0e66f05b5a44 | 2026-09-28 09:49 | 2026-09-28 09:49 | 2026-09-28 09:49 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 104.1400 | 104.0000 | 107.5500 | 1058.6850 | 166625.00 | 52135.00 | 114490.00 | 16 | 6 | 57 | 2625 | 0.0217142857142857 | 0.590730727151091 | 0.591988038966435 | true | false | false | |||||||||||||||||
| 71ccec30-dda1-4c9a-bf95-367b9442c9e6 | 2026-09-28 09:44 | 2026-09-28 09:44 | 2026-09-28 09:44 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 105.0200 | 104.8500 | 109.7500 | 1059.0200 | 199545.00 | 10520.00 | 189025.00 | 19 | 7 | 41 | 2625 | 0.0156190476190476 | 0.593648795453036 | 0.595395176233817 | true | false | false | |||||||||||||||||
| 944a28eb-6da1-4c7f-bc61-9680d3524f1e | 2026-09-22 15:12 | 2026-09-22 15:12 | 2026-09-22 15:12 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 133.6600 | 133.1000 | 133.7500 | 1093.1500 | 66830.00 | 40105.00 | 26725.00 | 5 | 5 | 670 | 2282 | 0.293602103418054 | 0.621728365140003 | 0.621970496056385 | false | false | false | |||||||||||||||||
| 6a642831-79ff-4713-9c7d-2ef9dba64519 | 2026-09-22 10:20 | 2026-09-22 10:20 | 2026-09-22 10:20 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 125.8300 | 122.8000 | 126.1500 | 1081.2788 | 352333.00 | 201123.00 | 151210.00 | 28 | 5 | 319 | 2282 | 0.139789658194566 | 0.615463308680753 | 0.617014841588297 | false | false | false | |||||||||||||||||
| 933cef4e-c235-4fd7-bfeb-7413d1aa3114 | 2026-09-16 10:08 | 2026-09-16 10:08 | 2026-09-16 10:08 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 54.6700 | 54.6500 | 55.9000 | 927.8800 | 109345.00 | 0.00 | 109345.00 | 20 | 5 | 33 | 2161 | 0.015270708005553 | 0.584168810994778 | 0.584168810994778 | false | false | false | |||||||||||||||||
| 7ac315bb-6ae7-42a6-a5c5-6caa551a35ea | 2026-09-09 12:26 | 2026-09-09 12:26 | 2026-09-09 12:26 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 111.1500 | 111.1500 | 114.6500 | 1017.4400 | 2034047.00 | 0.00 | 2034047.00 | 183 | 26 | 558 | 1953 | 0.285714285714286 | 0.657051442444198 | 0.657005222260461 | false | false | false | |||||||||||||||||
| b0c5925c-c348-429d-a33a-1061bccaaddc | 2026-09-04 12:53 | 2026-09-04 12:53 | 2026-09-04 12:53 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 104.3800 | 102.7000 | 105.4000 | 1004.5500 | 1002090.00 | 501360.00 | 500730.00 | 96 | 13 | 201 | 1727 | 0.11638679791546 | 0.638182704758588 | 0.638182704758588 | false | false | false | |||||||||||||||||
| 6a7f8e0c-dc8a-4127-a066-1b883104b652 | 2026-08-27 10:13 | 2026-08-27 10:12 | 2026-08-27 10:12 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 83.6800 | 81.1500 | 84.3500 | 932.5400 | 133890.00 | 92065.00 | 41825.00 | 16 | 9 | 115 | 1840 | 0.0625 | 0.666342118254168 | 0.666342118254168 | true | false | false | |||||||||||||||||
| 2f0484ec-9d66-4060-a6db-601d5ac613be | 2026-08-27 10:13 | 2026-08-27 10:12 | 2026-08-27 10:12 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 83.8400 | 81.1000 | 84.8500 | 932.5400 | 259915.00 | 134190.00 | 125725.00 | 31 | 5 | 98 | 1840 | 0.0532608695652174 | 0.667581401067395 | 0.666342118254168 | false | false | false | |||||||||||||||||
| 3a3d8d88-9598-4863-b50f-e8013e2ded9f | 2026-08-24 12:04 | 2026-08-24 12:04 | 2026-08-24 12:04 | MU | MU261218C01100000 | call | 1100.0000 | 2026-12-18 | 81.6500 | 80.1000 | 81.8000 | 911.4000 | 163300.00 | 65320.00 | 32660.00 | 20 | 6 | 377 | 1520 | 0.248026315789474 | 0.689614896195719 | 0.689614896195719 | false | false | false |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T15:55:27.801272Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:37:12.234330Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:49:52.918259Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| 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:17:07.798020Z"} |
| 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-22T14:23:46.275389Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1046439224059.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T14:14:36.942021Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| 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-09-09T16:45:40.179334Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T14:23:23.910306Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-24T16:14:40.561585Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |