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 |
|---|
| 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 |
|---|
| c5723fd3-3306-41a7-8fd6-2de8f0b6e752 | 2026-09-21 12:07 | 2026-09-21 12:06 | 2026-09-21 12:06 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 52.8700 | 51.7000 | 52.9000 | 1039.1711 | 311953.00 | 148118.00 | 163835.00 | 59 | 10 | 206 | 609 | 0.338259441707718 | 0.636479235576182 | 0.636479235576182 | false | false | false | true | 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-21T16:07:39.472771Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| a8a9e1cf-7fd0-42b8-b45e-2e2c112e83c9 | 2026-09-22 13:04 | 2026-09-22 13:04 | 2026-09-22 13:04 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 73.7000 | 73.5500 | 73.9500 | 1075.0000 | 36850.00 | 0.00 | 36850.00 | 5 | 5 | 486 | 766 | 0.634464751958224 | 0.651520680252905 | 0.651520680252905 | false | false | false | |||||||||||||||||
| 5fbd389f-2d58-4f3f-92f2-a8831cdfa239 | 2026-09-22 15:20 | 2026-09-22 15:20 | 2026-09-22 15:20 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 81.7400 | 81.2000 | 81.7500 | 1092.8000 | 81740.00 | 81740.00 | 0.00 | 10 | 6 | 705 | 766 | 0.920365535248042 | 0.664663308208057 | 0.664209567286099 | true | false | false | |||||||||||||||||
| 2eebb822-3e52-49bc-8006-09ad97334e13 | 2026-09-22 15:58 | 2026-09-22 15:58 | 2026-09-22 15:58 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 82.2500 | 82.0000 | 82.2500 | 1090.0000 | 74025.00 | 74025.00 | 0.00 | 9 | 9 | 769 | 766 | 1.00391644908616 | 0.65876120771042 | 0.65876120771042 | false | false | false | |||||||||||||||||
| 84dcab78-8d31-47f3-95bd-50e7d65fb597 | 2026-09-23 09:58 | 2026-09-23 09:58 | 2026-09-23 09:58 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 77.5000 | 75.7500 | 77.6000 | 1090.2100 | 309998.00 | 209508.00 | 100490.00 | 40 | 11 | 102 | 777 | 0.131274131274131 | 0.654548835601216 | 0.651767999944564 | false | false | false | |||||||||||||||||
| 02100298-19d4-4325-9bac-9145467e9024 | 2026-09-23 11:12 | 2026-09-23 11:12 | 2026-09-23 11:12 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 70.8000 | 70.8000 | 71.3500 | 1079.5350 | 708000.00 | 0.00 | 92040.00 | 100 | 20 | 346 | 777 | 0.445302445302445 | 0.645883269757088 | 0.645883269757088 | false | false | false | |||||||||||||||||
| eba95715-5dd8-475d-b260-b39a8b76cabf | 2026-09-23 14:00 | 2026-09-23 14:00 | 2026-09-23 14:00 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 68.5400 | 68.0000 | 68.7000 | 1075.4600 | 47980.00 | 27420.00 | 20560.00 | 7 | 7 | 469 | 777 | 0.603603603603604 | 0.645147499610294 | 0.645147499610294 | true | false | false | |||||||||||||||||
| bb9d8a6d-eb1d-4446-b108-37a3ab13e12e | 2026-09-24 09:56 | 2026-09-24 09:56 | 2026-09-24 09:56 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 54.9600 | 54.9000 | 55.7000 | 1047.8100 | 38475.00 | 16495.00 | 21980.00 | 7 | 7 | 43 | 1194 | 0.0360134003350084 | 0.661215468438271 | 0.661215468438271 | false | false | false | |||||||||||||||||
| 7f9be70d-1605-4534-9064-8c14c97dd888 | 2026-09-24 12:43 | 2026-09-24 12:43 | 2026-09-24 12:43 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 66.8400 | 66.5000 | 66.8500 | 1074.1450 | 40105.00 | 40105.00 | 0.00 | 6 | 6 | 212 | 1194 | 0.177554438860972 | 0.650032376530303 | 0.650508517776916 | true | false | false | |||||||||||||||||
| 729542bc-7b30-4fd5-bc55-fcf8ccce0de8 | 2026-09-24 12:45 | 2026-09-24 12:45 | 2026-09-24 12:45 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 64.8000 | 64.5500 | 64.8000 | 1070.3100 | 116635.00 | 116635.00 | 0.00 | 18 | 7 | 236 | 1194 | 0.197654941373534 | 0.64954533089839 | 0.649968936265588 | false | false | false | |||||||||||||||||
| 4205c49a-a402-4cbf-8506-1c2abafe4938 | 2026-09-24 13:01 | 2026-09-24 13:01 | 2026-09-24 13:01 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 65.9400 | 65.6500 | 66.1500 | 1073.1600 | 59345.00 | 52755.00 | 6590.00 | 9 | 9 | 309 | 1194 | 0.258793969849246 | 0.646842799130491 | 0.646366394984432 | true | false | false | |||||||||||||||||
| edaae0e1-ce68-4aba-a0dc-8d1c77e6cf25 | 2026-09-24 13:43 | 2026-09-24 13:43 | 2026-09-24 13:43 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 64.1800 | 63.6500 | 64.4500 | 1065.0000 | 51345.00 | 44930.00 | 6415.00 | 8 | 6 | 347 | 1194 | 0.290619765494137 | 0.649185395197544 | 0.649185395197544 | true | false | false | |||||||||||||||||
| 52ef131e-0047-4b51-8088-1f18741810c3 | 2026-09-24 14:22 | 2026-09-24 14:22 | 2026-09-24 14:22 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 63.0600 | 63.0500 | 63.6500 | 1067.8796 | 37833.00 | 0.00 | 37833.00 | 6 | 6 | 382 | 1194 | 0.319932998324958 | 0.645430983876349 | 0.645144077378027 | false | false | false | |||||||||||||||||
| da163091-db0b-4884-abec-6f29d31551d2 | 2026-09-24 15:49 | 2026-09-24 15:49 | 2026-09-24 15:49 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 67.5500 | 67.5000 | 67.5500 | 1076.7100 | 33775.00 | 33775.00 | 0.00 | 5 | 5 | 585 | 1194 | 0.489949748743719 | 0.644304666562458 | 0.644304666562458 | false | false | false | |||||||||||||||||
| 926419c0-4d08-4d16-bf02-1f21921c7a9d | 2026-09-24 15:51 | 2026-09-24 15:51 | 2026-09-24 15:51 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 68.1000 | 68.1000 | 68.2000 | 1078.2500 | 34050.00 | 0.00 | 34050.00 | 5 | 5 | 619 | 1194 | 0.518425460636516 | 0.641750354287371 | 0.641750354287371 | false | false | false | |||||||||||||||||
| 415fa9b0-3546-4c6c-84ad-c649e601cb5b | 2026-09-25 14:30 | 2026-09-25 14:30 | 2026-09-25 14:30 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 67.5000 | 67.0000 | 67.5000 | 1084.0576 | 135000.00 | 135000.00 | 0.00 | 20 | 6 | 758 | 1282 | 0.591263650546022 | 0.62107951658108 | 0.62107951658108 | true | false | false | |||||||||||||||||
| baf2f090-f128-4b6c-8dc7-56e7079c373a | 2026-09-25 15:17 | 2026-09-25 15:17 | 2026-09-25 15:17 | MU | MU261016C01080000 | call | 1080.0000 | 2026-10-16 | 67.2900 | 67.0000 | 68.0500 | 1084.3795 | 47100.00 | 6720.00 | 40380.00 | 7 | 5 | 1074 | 1282 | 0.837753510140406 | 0.617598686841177 | 0.616462385438057 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1237995596400.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T17:06:21.234354Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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:23:17.824277Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 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-23T13:58:49.832976Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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-23T15:14:40.062093Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| 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-23T18:04:42.135923Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:59:25.813942Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:45:03.999525Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-24T16:48:32.631672Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T17:03:43.722265Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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-24T17:47:19.997705Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T18:26:21.590036Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-24T19:50:03.728318Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-24T19:53:57.742588Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-25T18:31:26.314014Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| false |
| 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-25T19:24:28.165724Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |