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 | strike |
|---|
| 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 |
|---|
| f28af671-a2c9-43f2-ba4f-534655ec6cfe | 2026-09-28 09:42 | 2026-09-28 09:42 | 2026-09-28 09:42 | MU | MU260928C01085000 | call | 1085.0000 | 2026-09-28 | 2.6200 | 2.5900 | 2.7300 | 1067.7200 | 10746.00 | 262.00 | 10484.00 | 41 | 11 | 1642 | 1513 | 1.08526107072042 | 0.752160212249693 | 0.750967281735098 | false | 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-28T13:43:35.547112Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 1cef3aff-2648-4441-904d-1cfffde11f16 | 2026-09-28 09:32 | 2026-09-28 09:32 | 2026-09-28 09:32 | MU | MU260928C01085000 | call | 1085.0000 | 2026-09-28 | 9.4700 | 8.8000 | 10.0500 | 1081.5500 | 35029.00 | 7634.00 | 27395.00 | 37 | 16 | 509 | 1513 | 0.336417713152677 | 0.881646930245889 | 0.892481827294574 | false | false | false | |||||||||||||||||
| 744124ab-c8a3-4bf6-8ff8-2d0e76aa97af | 2026-09-28 09:32 | 2026-09-28 09:32 | 2026-09-28 09:32 | MU | MU260928C01085000 | call | 1085.0000 | 2026-09-28 | 9.6400 | 9.4500 | 9.8500 | 1083.3350 | 27964.00 | 3859.00 | 24105.00 | 29 | 7 | 453 | 1513 | 0.299405155320555 | 0.889798477072333 | 0.889593717634054 | false | false | false | |||||||||||||||||
| 4e5140b3-8b3b-49ae-80d1-346c5d295288 | 2026-09-28 09:32 | 2026-09-28 09:32 | 2026-09-28 09:32 | MU | MU260928C01085000 | call | 1085.0000 | 2026-09-28 | 8.2900 | 8.0500 | 8.4000 | 1081.1025 | 58025.00 | 53115.00 | 4910.00 | 70 | 20 | 246 | 1513 | 0.162590879048249 | 0.861867739275748 | 0.861867739275748 | true | false | false | |||||||||||||||||
| 2e621edc-d3fb-4a9e-a075-76ba3b58a8be | 2026-09-25 15:54 | 2026-09-25 15:54 | 2026-09-25 15:54 | MU | MU260928C01085000 | call | 1085.0000 | 2026-09-28 | 13.8500 | 13.7500 | 14.2500 | 1085.8400 | 145450.00 | 1410.00 | 144040.00 | 105 | 5 | 7483 | 689 | 10.8606676342525 | 0.345228909954645 | 0.337396081366708 | false | false | false | |||||||||||||||||
| eb4e324c-e0e5-42ac-996b-1db8e980b3c2 | 2026-09-25 14:15 | 2026-09-25 14:15 | 2026-09-25 14:15 | MU | MU260928C01085000 | call | 1085.0000 | 2026-09-28 | 13.3000 | 13.0500 | 13.4000 | 1083.7300 | 655674.00 | 654339.00 | 0.00 | 493 | 60 | 4001 | 689 | 5.80696661828737 | 0.353414867632664 | 0.351977013425002 | false | false | false | |||||||||||||||||
| a0c064d8-eda0-4a55-92ae-2f083df7cea7 | 2026-09-23 14:10 | 2026-09-23 14:10 | 2026-09-23 14:10 | MU | MU260928C01085000 | call | 1085.0000 | 2026-09-28 | 17.8500 | 17.6000 | 18.1000 | 1072.9000 | 17846.00 | 10706.00 | 3570.00 | 10 | 6 | 1110 | 360 | 3.08333333333333 | 0.458849443033221 | 0.459319672743513 | false | false | false |
| 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-28T13:33:12.079590Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T13:33:12.079590Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-28T13:33:12.079590Z"} |
| 2026-09-28 |
| 2026-09-28 21:15 |
| 2026-09-28 21:15 |
| 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-25T19:58:21.779683Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T18:18:37.657539Z"} |
| 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-23T18:11:21.793472Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |