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.
Simplify Analyticsuw_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 |
|---|
| 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 |
|---|
| 97183220-8a85-4d93-a6c0-11dd4e73162a | 2026-09-24 11:34 | 2026-09-24 11:34 | 2026-09-24 11:34 | MU | MU260925C01060000 | call | 1060.0000 | 2026-09-25 | 10.8000 | 10.7000 | 10.8500 | 1056.0000 | 39960.00 | 38880.00 | 1080.00 | 37 | 6 | 8381 | 1394 | 6.01219512195122 | 0.57251602540979 | 0.57251602540979 | false | false | false | true | 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-24T15:34:38.323653Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| 97335c4f-4f2c-4ae7-9a27-9d52176f204d | 2026-09-24 11:47 | 2026-09-24 11:47 | 2026-09-24 11:47 | MU | MU260925C01060000 | call | 1060.0000 | 2026-09-25 | 11.2900 | 11.1500 | 11.3000 | 1057.2950 | 11287.00 | 11287.00 | 0.00 | 10 | 7 | 8660 | 1394 | 6.21233859397417 | 0.56653461188626 | 0.567859677580823 | true | false | false | true | ||||||||||||||||
| 78c58a01-fd6c-4e47-9691-6858d73c56d7 | 2026-09-24 12:16 | 2026-09-24 12:16 | 2026-09-24 12:16 | MU | MU260925C01060000 | call | 1060.0000 | 2026-09-25 | 13.0000 | 12.8000 | 13.0000 | 1055.0000 | 14300.00 | 14300.00 | 0.00 | 11 | 5 | 10669 | 1394 | 7.65351506456241 | 0.568563205691342 | 0.568563205691342 | false | false | false | true | ||||||||||||||||
| a0336e19-4b89-421f-a0af-115f95473011 | 2026-09-24 12:16 | 2026-09-24 12:16 | 2026-09-24 12:16 | MU | MU260925C01060000 | call | 1060.0000 | 2026-09-25 | 14.3900 | 14.2500 | 14.4500 | 1063.0400 | 11510.00 | 8640.00 | 2870.00 | 8 | 6 | 10759 | 1394 | 7.7180774748924 | 0.553699907207605 | 0.575704283828831 | false | false | false | true | ||||||||||||||||
| 426ebe55-8ac6-4178-befb-33aa70da30eb | 2026-09-24 12:17 | 2026-09-24 12:17 | 2026-09-24 12:17 | MU | MU260925C01060000 | call | 1060.0000 | 2026-09-25 | 15.0000 | 14.8000 | 15.1000 | 1063.9000 | 22500.00 | 22500.00 | 0.00 | 15 | 8 | 10889 | 1394 | 7.81133428981349 | 0.581454223828359 | 0.581454223828359 | true | false | false | true | ||||||||||||||||
| 6298c113-0945-45c8-aa33-7e613c3b7bc7 | 2026-09-24 12:18 | 2026-09-24 12:18 | 2026-09-24 12:18 | MU | MU260925C01060000 | call | 1060.0000 | 2026-09-25 | 15.3600 | 15.0500 | 15.4000 | 1064.5850 | 10750.00 | 10750.00 | 0.00 | 7 | 5 | 10932 | 1394 | 7.84218077474892 | 0.582143104943202 | 0.582212847498335 | true | false | false | true | ||||||||||||||||
| 76e4f780-3b3e-4e9a-88d3-a3cf08ba6581 | 2026-09-24 12:44 | 2026-09-24 12:44 | 2026-09-24 12:44 | MU | MU260925C01060000 | call | 1060.0000 | 2026-09-25 | 20.9100 | 20.9000 | 21.0500 | 1073.7100 | 14636.00 | 0.00 | 14636.00 | 7 | 7 | 12340 | 1394 | 8.85222381635581 | 0.578405186436201 | 0.575451512626561 | false | false | false | true | ||||||||||||||||
| 9d6aaa1d-044a-4047-9abe-6af93c487909 | 2026-09-24 13:12 | 2026-09-24 13:12 | 2026-09-24 13:12 | MU | MU260925C01060000 | call | 1060.0000 | 2026-09-25 | 19.6600 | 19.6500 | 19.8500 | 1072.0000 | 11793.00 | 0.00 | 11793.00 | 6 | 6 | 12752 | 1394 | 9.14777618364419 | 0.569782780880418 | 0.569782780880418 | false | false | false | true | ||||||||||||||||
| ce1abd6e-8179-454e-abbb-daa88dcd3d52 | 2026-09-24 15:26 | 2026-09-24 15:26 | 2026-09-24 15:26 | MU | MU260925C01060000 | call | 1060.0000 | 2026-09-25 | 21.9300 | 21.3500 | 22.0000 | 1076.6300 | 32900.00 | 32900.00 | 0.00 | 15 | 5 | 14102 | 1394 | 10.116212338594 | 0.540351102847701 | 0.528215230789366 | false | false | false | true | ||||||||||||||||
| f7789107-f1a3-45f9-8076-e20efbbc97e1 | 2026-09-25 15:15 | 2026-09-25 15:15 | 2026-09-25 15:15 | MU | MU260925C01060000 | call | 1060.0000 | 2026-09-25 | 25.5000 | 24.8500 | 26.4000 | 1085.5000 | 267735.00 | 211635.00 | 56100.00 | 105 | 21 | 2245 | 1847 | 1.21548456957228 | 1.25727306949757 | 1.97989618761976 | false | false | false | true |
| 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-24T15:50:02.461499Z"} |
| 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-24T16:16:49.777231Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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:17:19.978572Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T16:18:11.979462Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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:18:11.979462Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T16:45:03.999525Z"} |
| 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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-24T17:14:36.344002Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T19:29:28.297700Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:17:13.698421Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |