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_alerts523,327 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 |
|---|
| 42e98b87-bebd-47ae-8d44-05d1ccb47c9e | 2026-09-28 13:55 | 2026-09-28 13:55 | 2026-09-28 13:55 | MU | MU270115C01200000 | call | 1200.0000 | 2027-01-15 | 88.9500 | 88.2000 | 89.0000 | 1055.0150 | 62265.00 | 53370.00 | 8895.00 | 7 | 5 | 614 | 6289 | 0.0976307839084115 | 0.595606746327256 | 0.595606746327256 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Technology | 1190357793291.00 | 2026-09-30 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-28T18:00:44.175376Z"} | 2026-09-28 | 2026-09-28 21:15 | 2026-09-28 21:15 |
| 9fd8cfca-24a7-411b-b2fc-8ac2295f583e | 2026-09-25 10:15 | 2026-09-25 10:15 | 2026-09-25 10:15 | MU | MU270115C01200000 | call | 1200.0000 | 2027-01-15 | 107.0000 | 105.0500 | 110.8000 | 1083.6400 | 160500.00 | 85600.00 | 74900.00 | 15 | 5 | 71 | 6317 | 0.0112395124267849 | 0.60988113368224 | 0.60988113368224 | false | false | false | true | ||||||||||||||||
| ffe8fd0c-3ab6-45a2-8c07-1147fce1497b | 2026-09-21 10:42 | 2026-09-21 10:42 | 2026-09-21 10:42 | MU | MU270115C01200000 | call | 1200.0000 | 2027-01-15 | 89.5800 | 88.2500 | 89.6000 | 1035.0000 | 447898.00 | 447898.00 | 0.00 | 50 | 8 | 2020 | 5516 | 0.366207396664249 | 0.608072527541342 | 0.608072527541342 | false | false | false | true | ||||||||||||||||
| dc35748a-bd2d-4ee8-b22e-a5b4fcb15b62 | 2026-09-18 12:34 | 2026-09-18 12:34 | 2026-09-18 12:34 | MU | MU270115C01200000 | call | 1200.0000 | 2027-01-15 | 69.7800 | 68.8000 | 69.8000 | 992.3300 | 251210.00 | 251210.00 | 0.00 | 36 | 5 | 192 | 5521 | 0.0347763086397392 | 0.592930780229946 | 0.593033186416742 | false | false | false | true | ||||||||||||||||
| 60643f94-b554-4a6b-825c-1d7806294d56 | 2026-09-16 14:47 | 2026-09-16 14:47 | 2026-09-16 14:47 | MU | MU270115C01200000 | call | 1200.0000 | 2027-01-15 | 51.2000 | 48.9000 | 51.2000 | 935.3500 | 517115.00 | 517115.00 | 0.00 | 101 | 5 | 167 | 5640 | 0.0296099290780142 | 0.589581535041143 | 0.589581535041143 | false | false | false | true | ||||||||||||||||
| 7872f32b-c7d5-44e6-af87-912b2704918f | 2026-09-14 15:52 | 2026-09-14 15:52 | 2026-09-14 15:52 | MU | MU270115C01200000 | call | 1200.0000 | 2027-01-15 | 52.0800 | 51.8500 | 52.1000 | 926.0000 | 468692.00 | 468692.00 | 0.00 | 90 | 6 | 663 | 5602 | 0.11835058907533 | 0.60348306795303 | 0.60348306795303 | false | false | false | true | ||||||||||||||||
| fee7a857-b703-4e91-97fb-ca9ee8ea75a5 | 2026-09-09 09:56 | 2026-09-09 09:56 | 2026-09-09 09:56 | MU | MU270115C01200000 | call | 1200.0000 | 2027-01-15 | 107.2600 | 103.9500 | 107.8000 | 1028.7850 | 160895.00 | 64370.00 | 96525.00 | 15 | 5 | 104 | 4901 | 0.0212201591511936 | 0.670327006115585 | 0.670118829632132 | false | false | false | true | ||||||||||||||||
| e2c2ebba-0f2a-4f11-9db1-5725d1806b03 | 2026-09-03 14:48 | 2026-09-03 14:48 | 2026-09-03 14:48 | MU | MU270115C01200000 | call | 1200.0000 | 2027-01-15 | 69.2800 | 68.0500 | 69.3500 | 955.1657 | 138560.00 | 138560.00 | 0.00 | 20 | 5 | 377 | 4715 | 0.0799575821845175 | 0.615730805904491 | 0.615730805904491 | false | false | false | true | ||||||||||||||||
| d16d4da2-5937-4248-8e00-9c995bf6f7c4 | 2026-09-01 14:52 | 2026-09-01 14:52 | 2026-09-01 14:52 | MU | MU270115C01200000 | call | 1200.0000 | 2027-01-15 | 62.4000 | 62.0000 | 62.7000 | 927.9672 | 106076.00 | 106076.00 | 0.00 | 17 | 7 | 99 | 4690 | 0.0211087420042644 | 0.623545298379678 | 0.623790092626541 | false | false | false | true | ||||||||||||||||
| 91778e44-5357-4436-a261-af0afa340055 | 2026-08-27 12:57 | 2026-08-27 12:57 | 2026-08-27 12:57 | MU | MU270115C01200000 | call | 1200.0000 | 2027-01-15 | 68.3400 | 66.5500 | 68.3500 | 912.2500 | 239195.00 | 198215.00 | 40980.00 | 35 | 6 | 238 | 4601 | 0.0517278852423386 | 0.664188355960185 | 0.664188355960185 | false | false | false | true | ||||||||||||||||
| 5e517562-9048-4335-bbab-6626893ab104 | 2026-08-26 14:30 | 2026-08-26 14:30 | 2026-08-26 14:30 | MU | MU270115C01200000 | call | 1200.0000 | 2027-01-15 | 82.1000 | 81.4500 | 82.7500 | 938.9238 | 270930.00 | 114940.00 | 0.00 | 33 | 5 | 515 | 4401 | 0.117018859350148 | 0.681701432043367 | 0.681701432043367 | false | false | false | true |
| 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-25T14:15:34.282180Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:45:07.990945Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1147237562786.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T16:45:45.480252Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1046439224059.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsDescendingFill |
| 5ce5ec11-087c-4c00-b164-08106b015856 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T13:57:31.693440Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-01T18:58:03.753197Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |