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 |
|---|
| 6c6b0cc8-0f11-479c-ab35-a8cec6f7250e | 2026-09-23 12:27 | 2026-09-23 12:26 | 2026-09-23 12:26 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 1.0700 | 1.0300 | 1.0700 | 1072.8000 | 10700.00 | 10700.00 | 0.00 | 100 | 7 | 14721 | 692 | 21.2731213872832 | 0.571275142052457 | 0.571275142052457 | 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-23T16:31:43.812748Z"} | 2026-09-23 | 2026-09-23 21:15 | 2026-09-23 21:15 |
| c4396b8d-ecbe-4413-af8e-ea35639be181 | 2026-09-23 12:25 | 2026-09-23 12:25 | 2026-09-23 12:25 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 1.1000 | 1.0700 | 1.1700 | 1073.4399 | 22554.00 | 22444.00 | 110.00 | 205 | 5 | 14495 | 692 | 20.9465317919075 | 0.562085998213396 | 0.561849723144529 | false | false | false | true | ||||||||||||||||
| ec6d07c0-d090-4de5-9d83-8a88ddd2bb3d | 2026-09-23 10:36 | 2026-09-23 10:36 | 2026-09-23 10:36 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 4.5300 | 4.4000 | 4.6500 | 1078.6500 | 15400.00 | 4050.00 | 11350.00 | 34 | 5 | 4696 | 692 | 6.78612716763006 | 0.680074632511102 | 0.678612232017821 | false | false | false | true | ||||||||||||||||
| ab473200-42cc-4f48-9376-ad216dad635e | 2026-09-23 10:28 | 2026-09-23 10:28 | 2026-09-23 10:28 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 3.8000 | 3.8000 | 4.0000 | 1075.7400 | 45600.00 | 0.00 | 45600.00 | 120 | 18 | 4095 | 692 | 5.91763005780347 | 0.696215437020366 | 0.696215437020366 | false | false | false | true | ||||||||||||||||
| 86796d83-97b3-49be-b9c5-c15a2a7a751d | 2026-09-22 15:11 | 2026-09-22 15:11 | 2026-09-22 15:11 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 19.0000 | 18.7500 | 19.0500 | 1094.4750 | 22800.00 | 11400.00 | 0.00 | 12 | 6 | 13453 | 175 | 76.8742857142857 | 0.617994750045697 | 0.600861906885947 | false | false | false | true | ||||||||||||||||
| 8f485bd0-91c7-4b29-888e-a857248bd9a6 | 2026-09-22 14:50 | 2026-09-22 14:50 | 2026-09-22 14:50 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 15.1000 | 15.0000 | 15.1000 | 1088.1800 | 10570.00 | 10570.00 | 0.00 | 7 | 7 | 12706 | 175 | 72.6057142857143 | 0.590038671071246 | 0.590038671071246 | false | false | false | true | ||||||||||||||||
| 7159dc25-29b7-4a9f-b5fa-39fadefe81be | 2026-09-22 14:20 | 2026-09-22 14:20 | 2026-09-22 14:20 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 15.2800 | 15.1500 | 15.3500 | 1088.2800 | 15282.00 | 3052.00 | 12230.00 | 10 | 5 | 11468 | 175 | 65.5314285714286 | 0.590415808688212 | 0.594265845107583 | false | false | false | true | ||||||||||||||||
| 8be1deeb-2f68-4249-9ec0-3603201014e2 | 2026-09-22 14:16 | 2026-09-22 14:16 | 2026-09-22 14:16 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 13.6000 | 13.5500 | 13.7000 | 1085.4950 | 13600.00 | 2720.00 | 10880.00 | 10 | 6 | 10966 | 175 | 62.6628571428571 | 0.586568665864285 | 0.586568665864285 | false | false | false | true | ||||||||||||||||
| ed131d3d-6a7d-44e2-b851-ede0c1ad00c8 | 2026-09-22 14:15 | 2026-09-22 14:15 | 2026-09-22 14:15 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 13.6500 | 13.6500 | 13.8000 | 1085.5000 | 10920.00 | 0.00 | 10920.00 | 8 | 8 | 10940 | 175 | 62.5142857142857 | 0.58639301854144 | 0.588662452548365 | false | false | false | true | ||||||||||||||||
| 9edc03b7-13b7-426c-b3d4-7ef468dcb050 | 2026-09-22 14:11 | 2026-09-22 14:11 | 2026-09-22 14:11 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 13.0100 | 12.8500 | 13.1000 | 1084.4700 | 20810.00 | 7810.00 | 13000.00 | 16 | 7 | 10591 | 175 | 60.52 | 0.588333030361641 | 0.587452127395279 | false | false | false | true | ||||||||||||||||
| cf5e3b94-acc5-482c-9e5b-1c89567d03f3 | 2026-09-22 14:02 | 2026-09-22 14:02 | 2026-09-22 14:02 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 12.1000 | 12.0000 | 12.2000 | 1082.2083 | 35090.00 | 6050.00 | 0.00 | 29 | 5 | 10305 | 175 | 58.8857142857143 | 0.592017630270458 | 0.592017630270458 | false | false | false | true | ||||||||||||||||
| af710b10-04ca-4f1c-93b2-905dbd860c18 | 2026-09-22 13:52 | 2026-09-22 13:52 | 2026-09-22 13:52 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 12.7000 | 12.5000 | 12.7000 | 1083.0250 | 34289.00 | 34289.00 | 0.00 | 27 | 5 | 9639 | 175 | 55.08 | 0.601247484468186 | 0.601247484468186 | false | false | false | true | ||||||||||||||||
| 8e61c5b3-8dfa-444f-a85e-192c4cbd8a12 | 2026-09-22 13:44 | 2026-09-22 13:44 | 2026-09-22 13:44 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 13.5000 | 13.3500 | 13.5000 | 1084.3200 | 12150.00 | 12150.00 | 0.00 | 9 | 5 | 9290 | 175 | 53.0857142857143 | 0.60843256191259 | 0.60843256191259 | true | false | false | true | ||||||||||||||||
| ca66088c-cf2d-479b-bdd4-57fe72857143 | 2026-09-22 13:42 | 2026-09-22 13:42 | 2026-09-22 13:42 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 13.0000 | 12.9000 | 13.0000 | 1083.2852 | 13000.00 | 13000.00 | 0.00 | 10 | 5 | 9075 | 175 | 51.8571428571429 | 0.608921998943238 | 0.608921998943238 | false | false | false | true | ||||||||||||||||
| a46a917e-fc3b-4670-b343-bcb4f3df7575 | 2026-09-22 13:28 | 2026-09-22 13:28 | 2026-09-22 13:28 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 12.9000 | 12.9000 | 13.0500 | 1083.7100 | 25800.00 | 0.00 | 25800.00 | 20 | 6 | 8377 | 175 | 47.8685714285714 | 0.595295448311802 | 0.595295448311802 | false | false | false | true | ||||||||||||||||
| b4577b56-c666-403b-aa37-c1a7f935c151 | 2026-09-22 12:33 | 2026-09-22 12:33 | 2026-09-22 12:33 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 12.0000 | 11.8500 | 12.0000 | 1080.8900 | 12000.00 | 12000.00 | 0.00 | 10 | 5 | 6895 | 175 | 39.4 | 0.614957030781274 | 0.614957030781274 | false | false | false | true | ||||||||||||||||
| 9ae796b2-ade9-4f50-bcae-5129ec37354d | 2026-09-22 12:19 | 2026-09-22 12:18 | 2026-09-22 12:18 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 11.8000 | 11.7000 | 11.9000 | 1080.6900 | 11800.00 | 0.00 | 9440.00 | 10 | 5 | 6651 | 175 | 38.0057142857143 | 0.610141743794129 | 0.610141743794129 | false | false | false | true | ||||||||||||||||
| 31151cf1-a602-44a0-a5de-a2df62ce2279 | 2026-09-22 12:00 | 2026-09-22 12:00 | 2026-09-22 12:00 | MU | MU260923C01085000 | call | 1085.0000 | 2026-09-23 | 10.6000 | 10.4500 | 10.6500 | 1077.6500 | 14840.00 | 13780.00 | 1060.00 | 14 | 5 | 6035 | 175 | 34.4857142857143 | 0.619337730052797 | 0.616461207261062 | false | false | false | true |
| 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:31:43.812748Z"} |
| 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:37:43.750009Z"} |
| 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 |
| 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 |
| 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-22T18:55:20.077577Z"} |
| 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-22T18:23:27.944500Z"} |
| 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-22T18:18:27.911867Z"} |
| 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-22T18:18:27.911867Z"} |
| 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-22T18:18:27.911867Z"} |
| 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-22T18:03:20.556132Z"} |
| 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-22T17:52:53.749956Z"} |
| 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-22T17:49:14.593703Z"} |
| 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-22T17:49:14.593703Z"} |
| 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-22T17:30:55.056187Z"} |
| 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-22T16:35:05.886735Z"} |
| 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-22T16:20:35.100506Z"} |
| 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-22T16:00:55.569269Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |