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 | expiry |
|---|
| 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 |
|---|
| 3d75cad7-de44-4b19-888e-4bba67ea201d | 2026-09-22 09:41 | 2026-09-22 09:41 | 2026-09-22 09:41 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 6.5500 | 6.3500 | 6.5500 | 1053.9050 | 13100.00 | 13100.00 | 0.00 | 20 | 7 | 87 | 572 | 0.152097902097902 | 0.644236395425782 | 0.644236395425782 | true | false | false | true | 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-22T13:41:44.035284Z"} | 2026-09-22 | 2026-09-22 21:15 | 2026-09-22 21:15 |
| c29054cf-3e10-4b85-b11a-178e5d2d26a2 | 2026-09-22 10:06 | 2026-09-22 10:06 | 2026-09-22 10:06 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 13.0000 | 12.9000 | 13.1500 | 1077.8300 | 14300.00 | 0.00 | 13000.00 | 11 | 5 | 410 | 572 | 0.716783216783217 | 0.653630119214813 | 0.653630119214813 | false | false | false | true | ||||||||||||||||
| 1e46d63e-39c7-4287-a696-8027b5cf909c | 2026-09-22 11:34 | 2026-09-22 11:34 | 2026-09-22 11:34 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 11.8600 | 11.7000 | 11.9000 | 1077.7300 | 11862.00 | 9520.00 | 2342.00 | 10 | 5 | 983 | 572 | 1.71853146853147 | 0.623320103568392 | 0.617460379567904 | false | false | false | true | ||||||||||||||||
| 39f7c756-c13a-4bf5-a9c9-8563ea5cd287 | 2026-09-22 15:18 | 2026-09-22 15:18 | 2026-09-22 15:18 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 17.7000 | 17.7000 | 17.8500 | 1094.0810 | 10620.00 | 0.00 | 10620.00 | 6 | 6 | 1590 | 572 | 2.77972027972028 | 0.619966150809048 | 0.619966150809048 | false | false | false | true | ||||||||||||||||
| 6ef4bf4a-c45f-4f2b-8db7-2ea8f4c6b875 | 2026-09-22 15:59 | 2026-09-22 15:59 | 2026-09-22 15:59 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 18.1500 | 18.1500 | 18.3000 | 1090.0000 | 12705.00 | 0.00 | 12705.00 | 7 | 7 | 2261 | 572 | 3.9527972027972 | 0.613420217764098 | 0.613420217764098 | false | false | false | true | ||||||||||||||||
| e8087e74-a37a-4b23-904a-4f1299f2dbc4 | 2026-09-22 15:59 | 2026-09-22 15:59 | 2026-09-22 15:59 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 18.0500 | 18.0500 | 18.3000 | 1090.0000 | 16245.00 | 0.00 | 16245.00 | 9 | 9 | 2270 | 572 | 3.96853146853147 | 0.609220345094482 | 0.609220345094482 | false | false | false | true | ||||||||||||||||
| 8a8c606b-7e93-4ea8-aa20-9b5cabd1a716 | 2026-09-23 09:52 | 2026-09-23 09:52 | 2026-09-23 09:52 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 11.2000 | 10.8500 | 11.2000 | 1084.7700 | 16800.00 | 16800.00 | 0.00 | 15 | 6 | 881 | 894 | 0.985458612975392 | 0.658580952829335 | 0.660980850163253 | false | false | false | true | ||||||||||||||||
| 7ea795eb-ede2-462b-a9de-285c72344ddc | 2026-09-23 10:28 | 2026-09-23 10:28 | 2026-09-23 10:28 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 7.9000 | 7.9000 | 8.1500 | 1076.3550 | 23700.00 | 0.00 | 23700.00 | 30 | 8 | 1316 | 894 | 1.47203579418345 | 0.632003922750449 | 0.632003922750449 | false | false | false | true | ||||||||||||||||
| f5599d44-0a1e-4506-bca6-7b3662052a40 | 2026-09-23 10:34 | 2026-09-23 10:34 | 2026-09-23 10:34 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 7.8000 | 7.5500 | 7.8000 | 1074.4700 | 15600.00 | 15600.00 | 0.00 | 20 | 5 | 1425 | 894 | 1.59395973154362 | 0.647154147593181 | 0.647154147593181 | false | false | false | true | ||||||||||||||||
| 1c2f39e1-b798-4614-8806-76ebe1e95e08 | 2026-09-23 11:59 | 2026-09-23 11:59 | 2026-09-23 11:59 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 6.9200 | 6.7500 | 6.9500 | 1076.2050 | 13840.00 | 5560.00 | 8280.00 | 20 | 6 | 1873 | 894 | 2.09507829977629 | 0.596557366728834 | 0.594582463620624 | false | false | false | true | ||||||||||||||||
| 2740888f-0834-4d8b-b935-7ab63abd0e4a | 2026-09-25 09:34 | 2026-09-25 09:34 | 2026-09-25 09:34 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 5.0000 | 4.7500 | 5.0000 | 1095.0000 | 10000.00 | 10000.00 | 0.00 | 20 | 7 | 908 | 2989 | 0.303780528604885 | 0.795516281385808 | 0.795516281385808 | false | false | false | true | ||||||||||||||||
| 5a8d6027-aacd-4414-8c49-3e51ee7572d1 | 2026-09-25 09:35 | 2026-09-25 09:35 | 2026-09-25 09:35 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 8.0400 | 8.0000 | 8.3000 | 1106.7510 | 12870.00 | 1625.00 | 11245.00 | 16 | 8 | 2384 | 2989 | 0.797591167614587 | 0.793384248687228 | 0.800311960550248 | true | false | false | true | ||||||||||||||||
| 15c46169-598c-4a31-8d95-6d67340a6163 | 2026-09-25 09:35 | 2026-09-25 09:35 | 2026-09-25 09:35 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 8.3500 | 8.3000 | 8.6000 | 1107.7650 | 11685.00 | 0.00 | 10850.00 | 14 | 5 | 2529 | 2989 | 0.84610237537638 | 0.786585661376178 | 0.782387730922527 | false | false | false | true | ||||||||||||||||
| 88f880d9-2bf0-4356-8ee1-362a566e4769 | 2026-09-25 09:36 | 2026-09-25 09:36 | 2026-09-25 09:36 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 7.8900 | 7.8000 | 8.2000 | 1107.0200 | 12629.00 | 5590.00 | 7039.00 | 16 | 8 | 3069 | 2989 | 1.02676480428237 | 0.781504809669243 | 0.77813095827137 | false | false | false | true | ||||||||||||||||
| e5b8d2a8-be40-44a6-a2f6-2f3ba7070a3f | 2026-09-25 09:40 | 2026-09-25 09:40 | 2026-09-25 09:40 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 7.5000 | 7.2500 | 7.5000 | 1106.4463 | 25500.00 | 25500.00 | 0.00 | 34 | 6 | 5325 | 2989 | 1.78153228504517 | 0.770870155140883 | 0.770870155140883 | false | false | false | true | ||||||||||||||||
| dfba4303-b8a2-4682-9b56-25487ff0e438 | 2026-09-25 09:41 | 2026-09-25 09:41 | 2026-09-25 09:41 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 8.0000 | 7.7000 | 8.0000 | 1107.7200 | 14397.00 | 13600.00 | 797.00 | 18 | 9 | 5604 | 2989 | 1.87487453997993 | 0.764595065093327 | 0.764595065093327 | false | false | false | true | ||||||||||||||||
| 8ea629bb-c4a4-4f68-bea9-4525681c234b | 2026-09-25 09:41 | 2026-09-25 09:41 | 2026-09-25 09:41 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 8.0000 | 7.8500 | 8.0500 | 1107.7400 | 26401.00 | 13621.00 | 1580.00 | 33 | 13 | 5648 | 2989 | 1.88959518233523 | 0.763825140751246 | 0.763825140751246 | true | false | false | true | ||||||||||||||||
| 57afaaed-80ef-471d-8883-9d5f3a23e615 | 2026-09-25 09:42 | 2026-09-25 09:42 | 2026-09-25 09:42 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 5.2000 | 5.0000 | 5.3500 | 1101.5900 | 11957.00 | 10397.00 | 1560.00 | 23 | 8 | 8134 | 2989 | 2.72131147540984 | 0.742392496944312 | 0.736821366761393 | false | false | false | true | ||||||||||||||||
| 1b00b2ad-912d-4972-a2a8-bd18b3b03cf6 | 2026-09-25 09:43 | 2026-09-25 09:43 | 2026-09-25 09:43 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 4.0700 | 4.0000 | 4.2000 | 1098.0201 | 13838.00 | 4978.00 | 8860.00 | 34 | 7 | 8907 | 2989 | 2.97992639678822 | 0.750009732947155 | 0.740793729945643 | true | false | false | true | ||||||||||||||||
| 956cec25-6d61-46ba-9cd5-15b47d9a78aa | 2026-09-25 09:56 | 2026-09-25 09:55 | 2026-09-25 09:56 | MU | MU260925C01110000 | call | 1110.0000 | 2026-09-25 | 2.1300 | 2.1300 | 2.2000 | 1090.6850 | 11076.00 | 0.00 | 11076.00 | 52 | 6 | 13269 | 2989 | 4.43927735028438 | 0.737132937431705 | 0.737149846177601 | false | false | false | true |
| 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:07:23.951488Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T15:38:41.762966Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T19:23:17.824277Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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 |
| 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 |
| 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-23T13:52:21.829557Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T14:29:05.852425Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T14:35:38.031989Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 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-23T16:00:35.931587Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1222319619464.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T13:34:45.543817Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T13:35:49.891887Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T13:35:49.891887Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T13:37:30.150792Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T13:41:37.814256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T13:41:37.814256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T13:41:37.814256Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T13:43:32.172352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T13:43:32.172352Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| 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-25T13:56:09.661998Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |