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_alerts425,429 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 |
|---|
| ff1cac7d-9d5a-497a-bb5c-51d4f35d9f62 | 2026-09-24 09:56 | 2026-09-24 09:56 | 2026-09-24 09:56 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 42.1400 | 42.1000 | 42.3500 | 1048.2268 | 21070.00 | 0.00 | 21070.00 | 5 | 5 | 116 | 6415 | 0.0180826188620421 | 0.642782432519634 | 0.642256382092352 | 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-24T13:59:25.813942Z"} | 2026-09-24 | 2026-09-24 21:15 | 2026-09-24 21:15 |
| d92c7436-b29e-4336-95c5-a43c47d3ae30 | 2026-09-23 10:02 | 2026-09-23 10:02 | 2026-09-23 10:02 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 31.2500 | 30.3500 | 31.2500 | 1088.0800 | 356220.00 | 356220.00 | 0.00 | 114 | 25 | 186 | 6308 | 0.0294863665187064 | 0.642947338428825 | 0.642947338428825 | false | false | false | true | ||||||||||||||||
| b74e19f8-90af-4db4-ad92-1917a53cac66 | 2026-09-22 15:19 | 2026-09-22 15:19 | 2026-09-22 15:19 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 32.0500 | 31.9500 | 32.1000 | 1092.7000 | 25640.00 | 25640.00 | 0.00 | 8 | 5 | 2806 | 5165 | 0.543272023233301 | 0.651881922321513 | 0.651881922321513 | false | false | false | true | ||||||||||||||||
| 6172355c-04b9-448f-a51d-f401d6b1087e | 2026-09-22 10:31 | 2026-09-22 10:31 | 2026-09-22 10:31 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 34.2500 | 34.2500 | 34.4500 | 1081.6900 | 30825.00 | 0.00 | 30825.00 | 9 | 9 | 455 | 5165 | 0.0880929332042594 | 0.641756172529743 | 0.64312880919045 | false | false | false | true | ||||||||||||||||
| ea4b0d06-b041-4375-87ce-f00513ffd754 | 2026-09-22 10:31 | 2026-09-22 10:31 | 2026-09-22 10:31 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 34.2500 | 34.0500 | 34.3500 | 1080.9995 | 71925.00 | 3425.00 | 61650.00 | 21 | 19 | 444 | 5165 | 0.0859632139399806 | 0.641540289396063 | 0.641044928603879 | false | false | false | true | ||||||||||||||||
| 3fb5a34c-2d5b-4f86-a6b6-cb5c9f7a52ed | 2026-09-22 10:31 | 2026-09-22 10:31 | 2026-09-22 10:31 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 34.4500 | 34.4500 | 34.5000 | 1080.3850 | 20670.00 | 0.00 | 20670.00 | 6 | 5 | 422 | 5165 | 0.081703775411423 | 0.641313946251897 | 0.641313946251897 | false | false | false | true | ||||||||||||||||
| ca353739-addf-4e97-bdd7-4b56c71a2e75 | 2026-09-22 10:31 | 2026-09-22 10:31 | 2026-09-22 10:31 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 34.4500 | 34.4500 | 34.5500 | 1079.9800 | 37895.00 | 0.00 | 37895.00 | 11 | 8 | 396 | 5165 | 0.0766698935140368 | 0.640086050012222 | 0.640086050012222 | false | false | false | true | ||||||||||||||||
| 1a078d10-ac78-4b37-9936-e90cd92dbc49 | 2026-09-22 10:31 | 2026-09-22 10:31 | 2026-09-22 10:31 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 34.4500 | 34.4500 | 34.5000 | 1080.1500 | 68900.00 | 0.00 | 68900.00 | 20 | 20 | 416 | 5165 | 0.0805421103581801 | 0.640601660031961 | 0.640601660031961 | false | false | false | true | ||||||||||||||||
| ad4e787a-1546-41bd-be80-9a5cde1ccd6c | 2026-09-22 10:31 | 2026-09-22 10:31 | 2026-09-22 10:31 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 34.1500 | 34.1500 | 34.3000 | 1081.4800 | 112695.00 | 0.00 | 112695.00 | 33 | 31 | 385 | 5165 | 0.074540174249758 | 0.641791571734946 | 0.64142980098518 | false | false | false | true | ||||||||||||||||
| fbaf88a8-9a32-4441-a003-61f3fe39425a | 2026-09-22 09:40 | 2026-09-22 09:40 | 2026-09-22 09:40 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 41.3500 | 41.3500 | 41.6000 | 1053.1400 | 49623.00 | 0.00 | 49623.00 | 12 | 5 | 112 | 5165 | 0.0216844143272023 | 0.624998576849322 | 0.625135742902875 | true | false | false | true | ||||||||||||||||
| 7939590d-1b40-4049-9699-a69204137544 | 2026-09-22 09:40 | 2026-09-22 09:40 | 2026-09-22 09:40 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 41.4200 | 41.3500 | 41.4500 | 1053.0150 | 24850.00 | 12430.00 | 8280.00 | 6 | 6 | 100 | 5165 | 0.0193610842207164 | 0.62550564427636 | 0.625214781289888 | true | false | false | true | ||||||||||||||||
| 491dcfe0-0fbe-46c9-b0ca-9bc5d57156c7 | 2026-09-21 11:51 | 2026-09-21 11:51 | 2026-09-21 11:51 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 47.9000 | 47.2000 | 48.4000 | 1036.9401 | 57480.00 | 52690.00 | 4790.00 | 12 | 12 | 1009 | 4435 | 0.227508455467869 | 0.620717299787879 | 0.620717299787879 | false | false | false | true | ||||||||||||||||
| a895c3af-694c-40fe-96d6-912ebe88e7e7 | 2026-09-21 10:08 | 2026-09-21 10:08 | 2026-09-21 10:08 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 46.5000 | 46.4500 | 46.5000 | 1040.5900 | 60450.00 | 60450.00 | 0.00 | 13 | 10 | 911 | 4435 | 0.205411499436302 | 0.620230772476788 | 0.620230772476788 | false | false | false | true | ||||||||||||||||
| 0995fa7d-0128-4446-8a07-e5ebb156d1df | 2026-09-18 09:46 | 2026-09-18 09:46 | 2026-09-18 09:46 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 67.6000 | 67.6000 | 67.7500 | 990.4900 | 135200.00 | 0.00 | 135200.00 | 20 | 5 | 128 | 4215 | 0.030367734282325 | 0.586371805310033 | 0.586371805310033 | false | false | false | true | ||||||||||||||||
| d0eba777-83e5-450c-b301-eba840559646 | 2026-09-18 09:44 | 2026-09-18 09:44 | 2026-09-18 09:44 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 67.3000 | 67.0000 | 67.3000 | 991.9750 | 188440.00 | 188440.00 | 0.00 | 28 | 23 | 54 | 4215 | 0.0128113879003559 | 0.590166688544992 | 0.590166688544992 | false | false | false | true | ||||||||||||||||
| 540ed7d3-75c3-4d0f-936a-c18489ef0f67 | 2026-09-17 09:38 | 2026-09-17 09:38 | 2026-09-17 09:38 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 81.1100 | 78.1500 | 81.4000 | 969.0150 | 194675.00 | 105425.00 | 16215.00 | 24 | 6 | 44 | 4189 | 0.0105037001671043 | 0.60146883606619 | 0.601041290004794 | false | false | false | true | ||||||||||||||||
| 7f13ed29-7ac4-405c-866f-56c4cb20aa95 | 2026-09-10 15:31 | 2026-09-10 15:31 | 2026-09-10 15:31 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 85.6000 | 85.5500 | 86.9000 | 983.3000 | 214000.00 | 0.00 | 205440.00 | 25 | 10 | 208 | 4230 | 0.0491725768321513 | 0.637369374651917 | 0.637369374651917 | false | false | false | true | ||||||||||||||||
| c4af5419-1903-4d3f-98b3-cdd9e1b9bb1c | 2026-09-09 10:41 | 2026-09-09 10:41 | 2026-09-09 10:41 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 69.1500 | 69.1500 | 70.1000 | 1034.2600 | 138300.00 | 0.00 | 138300.00 | 20 | 11 | 433 | 4005 | 0.108114856429463 | 0.674792900371675 | 0.674792900371675 | true | false | false | true | ||||||||||||||||
| 1603b8b5-265e-404c-a345-34e916a0e9ea | 2026-09-09 10:38 | 2026-09-09 10:38 | 2026-09-09 10:38 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 69.6000 | 69.6000 | 70.3000 | 1030.0000 | 278400.00 | 0.00 | 278400.00 | 40 | 8 | 412 | 4005 | 0.102871410736579 | 0.675423285262292 | 0.675423285262292 | true | false | false | true | ||||||||||||||||
| e1ab9e4c-71e1-48aa-8e2b-923ba6a8785b | 2026-09-04 15:53 | 2026-09-04 15:53 | 2026-09-04 15:53 | MU | MU261016P01000000 | put | 1000.0000 | 2026-10-16 | 81.5000 | 78.5000 | 81.5000 | 1012.2500 | 1222500.00 | 1222500.00 | 0.00 | 150 | 15 | 411 | 3640 | 0.112912087912088 | 0.662319056040819 | 0.661086224400535 | true | 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-23T14:04:12.048624Z"} |
| 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: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 |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T14:34:01.762519Z"} |
| 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-22T14:34:01.762519Z"} |
| 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-22T14:34:01.762519Z"} |
| 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-22T14:34:01.762519Z"} |
| 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-22T14:34:01.762519Z"} |
| 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-22T14:31:31.654153Z"} |
| 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-22T13:40:19.961747Z"} |
| 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-22T13:40:19.961747Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T15:52:20.515056Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1179041273918.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T14:10:29.738922Z"} |
| 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-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 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-18T13:50:28.178058Z"} |
| 2026-09-18 |
| 2026-09-18 21:15 |
| 2026-09-18 21:15 |
| RepeatedHits |
| e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 |
| 1 |
| Common Stock |
| Technology |
| 1103981805103.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-17T13:39:40.470874Z"} |
| 2026-09-17 |
| 2026-09-17 21:15 |
| 2026-09-17 21:15 |
| 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-10T19:48:54.834059Z"} |
| 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-09T14:59:53.339088Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"} |
| 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-04T20:00:02.053596Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |