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_alerts658,639 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 |
|---|
| 0bdd6df3-3499-4ee7-b7c4-b0ab1116d998 | 2026-10-01 11:16 | 2026-10-01 11:16 | 2026-10-01 11:16 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 22.3000 | 21.9000 | 22.3000 | 1048.3300 | 26756.00 | 26756.00 | 0.00 | 12 | 5 | 2100 | 8062 | 0.260481270156289 | 0.516380613540552 | 0.516515563093667 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Technology | 1239384749976.00 | 2026-12-16 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-10-01T15:19:44.137827Z"} | 2026-10-01 | 2026-10-01 21:15 | 2026-10-01 21:15 |
| c1e881a9-f7d8-48a5-be0b-482712a83923 | 2026-10-01 09:58 | 2026-10-01 09:58 | 2026-10-01 09:58 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 23.1400 | 22.8500 | 23.5000 | 1046.5600 | 231405.00 | 81025.00 | 150380.00 | 100 | 7 | 864 | 8062 | 0.107169436864302 | 0.516472244087679 | 0.521345602112368 | false | false | false | |||||||||||||||||
| ab0b5258-edc3-485e-b380-01e1d97041f6 | 2026-10-01 09:54 | 2026-10-01 09:54 | 2026-10-01 09:54 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 23.4700 | 23.3000 | 24.1000 | 1046.8100 | 14080.00 | 7045.00 | 7035.00 | 6 | 6 | 695 | 8062 | 0.0862068965517241 | 0.525723272427002 | 0.525723272427002 | false | false | false | |||||||||||||||||
| 40f6f6f8-c976-4ccc-abe7-7da7ef1ef134 | 2026-10-01 09:49 | 2026-10-01 09:49 | 2026-10-01 09:49 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 22.6800 | 22.4500 | 23.3500 | 1050.3201 | 18145.00 | 9080.00 | 9065.00 | 8 | 8 | 669 | 8062 | 0.0829818903497891 | 0.530215395240634 | 0.529324342760344 | false | false | false | |||||||||||||||||
| e42e0bfc-ac9e-425d-9069-6db16c21693b | 2026-10-01 09:44 | 2026-10-01 09:43 | 2026-10-01 09:43 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 23.2600 | 23.2000 | 24.0000 | 1048.5000 | 34895.00 | 16295.00 | 18600.00 | 15 | 7 | 480 | 8062 | 0.0595385760357231 | 0.52999894083314 | 0.52999894083314 | true | false | false | |||||||||||||||||
| 7182799b-68fb-4276-8189-1ad1eb9d7166 | 2026-09-30 15:55 | 2026-09-30 15:55 | 2026-09-30 15:55 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 28.0400 | 28.0000 | 28.2500 | 1062.9100 | 22435.00 | 5610.00 | 16825.00 | 8 | 7 | 2288 | 7054 | 0.324354975900198 | 0.63187407581412 | 0.632410748562162 | false | false | false | |||||||||||||||||
| e91b9ad8-e01d-4322-ae1c-f0cad8d04fc5 | 2026-09-30 15:55 | 2026-09-30 15:54 | 2026-09-30 15:54 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 27.1900 | 27.1000 | 27.7000 | 1065.6900 | 489435.00 | 218025.00 | 271410.00 | 180 | 12 | 2278 | 7054 | 0.322937340516019 | 0.630408803916411 | 0.632531896950603 | false | false | false | |||||||||||||||||
| 807137f7-ca99-48ff-9538-bb513fb4f4d3 | 2026-09-29 10:41 | 2026-09-29 10:41 | 2026-09-29 10:41 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 24.4400 | 23.9000 | 24.4500 | 1080.4200 | 122216.00 | 122216.00 | 0.00 | 50 | 6 | 322 | 7070 | 0.0455445544554455 | 0.629601557927879 | 0.629601557927879 | false | false | false | |||||||||||||||||
| 6d03d52f-7676-4045-b750-8e8a085a0829 | 2026-09-29 09:30 | 2026-09-29 09:30 | 2026-09-29 09:30 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 26.4700 | 26.2000 | 27.9000 | 1075.8050 | 92655.00 | 26385.00 | 66270.00 | 35 | 14 | 52 | 7070 | 0.00735502121640736 | 0.637957264694117 | 0.638842641730427 | true | false | false | |||||||||||||||||
| 8057aba9-b868-4367-83bd-58da49255d44 | 2026-09-24 09:56 | 2026-09-24 09:56 | 2026-09-24 09:56 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 42.5200 | 42.2500 | 42.5500 | 1048.1000 | 25510.00 | 17010.00 | 8500.00 | 6 | 6 | 104 | 6415 | 0.0162120031176929 | 0.644663283419897 | 0.646525512834571 | false | false | false | |||||||||||||||||
| 7f4bdc9e-f8e3-47d3-9eed-d2eaded53224 | 2026-09-23 11:34 | 2026-09-23 11:34 | 2026-09-23 11:34 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 32.8900 | 32.8500 | 33.5500 | 1078.0000 | 16445.00 | 0.00 | 16445.00 | 5 | 5 | 478 | 6308 | 0.0757767913760304 | 0.629936106895381 | 0.630480855039782 | false | false | false | |||||||||||||||||
| 890ec73a-4fb7-4585-9f37-3175264bb961 | 2026-09-22 12:26 | 2026-09-22 12:26 | 2026-09-22 12:26 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 34.2400 | 34.0000 | 34.2500 | 1079.5400 | 44507.00 | 44507.00 | 0.00 | 13 | 13 | 2379 | 5165 | 0.460600193610842 | 0.635774324595979 | 0.636624899359106 | true | false | false | |||||||||||||||||
| 06428e14-f024-4076-937c-912ee1d3478b | 2026-09-22 12:16 | 2026-09-22 12:16 | 2026-09-22 12:16 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 33.6100 | 33.5000 | 33.6500 | 1080.8000 | 678875.00 | 312635.00 | 362880.00 | 202 | 63 | 2364 | 5165 | 0.457696030977735 | 0.633196274265252 | 0.634046529464158 | true | false | false | |||||||||||||||||
| fe2a3fb4-874a-4131-a01c-a5b2e8f1059d | 2026-09-22 09:40 | 2026-09-22 09:40 | 2026-09-22 09:40 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 41.4600 | 41.3500 | 41.7000 | 1052.7100 | 24875.00 | 8305.00 | 16570.00 | 6 | 6 | 88 | 5165 | 0.0170377541142304 | 0.623663753491305 | 0.624676789106707 | true | false | false | |||||||||||||||||
| 37e31825-6d34-409f-8352-5bc827d261bb | 2026-09-21 12:04 | 2026-09-21 12:04 | 2026-09-21 12:04 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 47.2600 | 47.2000 | 48.0500 | 1038.7700 | 61435.00 | 9455.00 | 51980.00 | 13 | 11 | 1075 | 4435 | 0.2423900789177 | 0.619778622940495 | 0.62101579151982 | true | false | false | |||||||||||||||||
| 8c0b3d92-f89b-449b-80c1-86a975ace41f | 2026-09-18 09:44 | 2026-09-18 09:44 | 2026-09-18 09:44 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 67.4700 | 67.4500 | 68.1000 | 991.1600 | 317105.00 | 0.00 | 310355.00 | 47 | 23 | 108 | 4215 | 0.0256227758007117 | 0.587957253540579 | 0.588414274377621 | true | false | false | |||||||||||||||||
| 084a332c-c944-471c-bb63-25b85de199d0 | 2026-09-17 11:16 | 2026-09-17 11:16 | 2026-09-17 11:16 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 75.8900 | 75.8000 | 76.3000 | 979.5700 | 121422.00 | 37970.00 | 83452.00 | 16 | 13 | 153 | 4189 | 0.0365242301265218 | 0.602402472832926 | 0.602765661964659 | true | false | false | |||||||||||||||||
| 3da9ea65-3e89-4555-8839-818717528346 | 2026-09-16 09:44 | 2026-09-16 09:44 | 2026-09-16 09:44 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 104.7400 | 104.2500 | 104.9000 | 928.6500 | 481800.00 | 387535.00 | 94265.00 | 46 | 18 | 60 | 4178 | 0.0143609382479655 | 0.591648148150104 | 0.592344604186034 | true | false | false | |||||||||||||||||
| 736de669-a21b-4ada-9d44-98cdda29f4d7 | 2026-09-09 12:45 | 2026-09-09 12:45 | 2026-09-09 12:45 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 72.0600 | 72.0000 | 73.2000 | 1015.0000 | 100885.00 | 43255.00 | 57630.00 | 14 | 10 | 665 | 4005 | 0.166042446941323 | 0.658909335626236 | 0.658201421105233 | true | false | false | |||||||||||||||||
| 570e8214-3025-418e-85e9-87b7c33aa26c | 2026-08-24 10:53 | 2026-08-24 10:52 | 2026-08-24 10:52 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 151.3700 | 151.3500 | 152.8500 | 902.8900 | 832554.00 | 75800.00 | 756754.00 | 55 | 8 | 92 | 3425 | 0.0268613138686131 | 0.687803984002437 | 0.689901999253161 | true | false | false | |||||||||||||||||
| afdc5241-c7d8-460c-9c6a-56da821bbd57 | 2026-08-19 11:10 | 2026-08-19 11:10 | 2026-08-19 11:10 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 140.7300 | 140.4500 | 141.2000 | 931.8800 | 337750.00 | 28160.00 | 309590.00 | 24 | 5 | 50 | 3326 | 0.0150330727600722 | 0.699708567697846 | 0.700677059762338 | false | false | false |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1239384749976.00 |
| 2026-12-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:59:25.903362Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1239384749976.00 |
| 2026-12-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:56:33.722234Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1239384749976.00 |
| 2026-12-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:50:07.772259Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1239384749976.00 |
| 2026-12-16 |
| unknown |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-10-01T13:44:24.931446Z"} |
| 2026-10-01 |
| 2026-10-01 21:15 |
| 2026-10-01 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:56:14.102421Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-30T19:56:14.102421Z"} |
| 2026-09-30 |
| 2026-09-30 21:15 |
| 2026-09-30 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T14:43:57.970888Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1202894057267.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-29T13:31:03.669649Z"} |
| 2026-09-29 |
| 2026-09-29 21:15 |
| 2026-09-29 21:15 |
| false |
| 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-24T13:56:38.298983Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| false |
| 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-23T15:35:15.101362Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:27:20.551854Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 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:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:07:39.472771Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1147237562786.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1103981805103.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1046439224059.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T13:45:36.515971Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| false |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Technology |
| 1043593153319.00 |
| 2026-09-30 |
| postmarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-08-24T15:09:19.758040Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| false |
| 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-08-19T15:17:48.302096Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |