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 |
|---|
| 9cf2e649-a1bd-4cbe-96f2-505a81e7ceae | 2026-08-26 11:32 | 2026-08-26 11:32 | 2026-08-26 11:32 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 157.3000 | 156.9500 | 161.2000 | 943.3600 | 251680.00 | 0.00 | 251680.00 | 16 | 5 | 26 | 414 | 0.0628019323671498 | 0.667754513612811 | 0.667754513612811 | false | false | false | true | false | 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-26T15:48:55.759300Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 39c55975-e48a-4f1e-a546-32b74a378a18 | 2026-09-08 09:44 | 2026-09-08 09:44 | 2026-09-08 09:44 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 109.0000 | 106.0000 | 110.8000 | 1009.8050 | 109000.00 | 10900.00 | 32700.00 | 10 | 10 | 15 | 419 | 0.035799522673031 | 0.678738338420769 | 0.679961536427498 | false | false | false | true | ||||||||||||||||
| 7fc2b47b-63e1-4ac0-b8d4-3b71fa3274fc | 2026-09-21 14:07 | 2026-09-21 14:07 | 2026-09-21 14:07 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 71.9000 | 70.9500 | 72.5000 | 1035.0000 | 79087.00 | 71897.00 | 7190.00 | 11 | 9 | 451 | 590 | 0.764406779661017 | 0.630049012720658 | 0.630049012720658 | false | false | false | true | ||||||||||||||||
| 1d6be4d8-a132-4e35-b522-9fee6ca36c19 | 2026-09-22 09:35 | 2026-09-22 09:35 | 2026-09-22 09:35 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 67.5500 | 67.5000 | 67.8500 | 1047.3800 | 175635.00 | 20270.00 | 155365.00 | 26 | 8 | 31 | 634 | 0.0488958990536278 | 0.630101735371058 | 0.631690275788102 | true | false | false | true | ||||||||||||||||
| f1bd4423-2126-4640-850d-c59156237d36 | 2026-09-22 10:12 | 2026-09-22 10:12 | 2026-09-22 10:12 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 56.0000 | 56.0000 | 56.2500 | 1077.3750 | 56000.00 | 0.00 | 56000.00 | 10 | 10 | 333 | 634 | 0.525236593059937 | 0.645139109979321 | 0.645139109979321 | false | false | false | true | ||||||||||||||||
| 7a4461e4-341f-4ba1-8164-f3864cf6c15d | 2026-09-22 13:15 | 2026-09-22 13:15 | 2026-09-22 13:15 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 54.4100 | 54.4500 | 54.7000 | 1080.7278 | 27205.00 | 0.00 | 27205.00 | 5 | 5 | 633 | 634 | 0.998422712933754 | 0.642116706661421 | 0.643055623557701 | true | false | false | true | ||||||||||||||||
| a41167b3-0e7e-4cc7-80d8-82e7d2763c79 | 2026-09-22 15:26 | 2026-09-22 15:26 | 2026-09-22 15:26 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 51.3900 | 51.3000 | 51.6500 | 1092.0600 | 41115.00 | 5140.00 | 35975.00 | 8 | 7 | 770 | 634 | 1.21451104100946 | 0.654976861151339 | 0.654976861151339 | true | false | false | true | ||||||||||||||||
| 40a55ea3-fcb4-4ffc-9b1c-c316b40f2dff | 2026-09-23 10:02 | 2026-09-23 10:02 | 2026-09-23 10:02 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 50.7500 | 49.8000 | 50.7500 | 1088.0800 | 436445.00 | 431375.00 | 5070.00 | 86 | 22 | 154 | 706 | 0.218130311614731 | 0.648011167998957 | 0.648011167998957 | false | false | false | true | ||||||||||||||||
| 81f71d21-db04-44d2-b1ae-6aaf907392df | 2026-09-23 15:12 | 2026-09-23 15:12 | 2026-09-23 15:12 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 57.7500 | 57.0500 | 57.9000 | 1069.0800 | 196350.00 | 190575.00 | 5775.00 | 34 | 8 | 565 | 706 | 0.80028328611898 | 0.642702839859829 | 0.642862319046421 | true | false | false | true | ||||||||||||||||
| eb8151b3-f43e-48b2-a404-46536e1e195e | 2026-09-24 10:22 | 2026-09-24 10:22 | 2026-09-24 10:22 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 62.8800 | 62.5500 | 62.9000 | 1054.0500 | 144621.00 | 132051.00 | 6285.00 | 23 | 17 | 120 | 861 | 0.139372822299652 | 0.64278910740313 | 0.643179296977424 | true | false | false | true | ||||||||||||||||
| 6f428c6d-d523-4911-872d-ae12760f31ad | 2026-09-24 10:27 | 2026-09-24 10:27 | 2026-09-24 10:27 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 63.2200 | 62.9500 | 63.3500 | 1053.7600 | 31610.00 | 18970.00 | 12640.00 | 5 | 5 | 164 | 861 | 0.19047619047619 | 0.644921480577401 | 0.645409259669131 | true | false | false | true | ||||||||||||||||
| 40e1574a-efbf-44f9-b303-58a28d5fe0a3 | 2026-09-24 10:40 | 2026-09-24 10:40 | 2026-09-24 10:40 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 62.8500 | 62.7500 | 63.0000 | 1054.8200 | 56565.00 | 31425.00 | 25140.00 | 9 | 7 | 197 | 861 | 0.228803716608595 | 0.64618287743708 | 0.64618287743708 | false | false | false | true | ||||||||||||||||
| b7b3fbda-0554-4b27-a7e4-365c957acbd7 | 2026-09-24 12:33 | 2026-09-24 12:33 | 2026-09-24 12:33 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 57.3500 | 57.0500 | 57.4000 | 1066.1000 | 131904.00 | 103274.00 | 28630.00 | 23 | 10 | 475 | 861 | 0.551684088269454 | 0.640690345060764 | 0.640202711884775 | true | false | false | true | ||||||||||||||||
| 220eeec1-5e8f-456b-84b2-764333b3ef67 | 2026-09-24 15:13 | 2026-09-24 15:13 | 2026-09-24 15:13 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 54.9500 | 54.5000 | 54.9500 | 1071.4000 | 60442.00 | 60442.00 | 0.00 | 11 | 5 | 1135 | 861 | 1.31823461091754 | 0.638605575188115 | 0.638898620965787 | false | false | false | true | ||||||||||||||||
| fb494c66-321e-4320-8779-6b05d3998ec4 | 2026-09-24 15:43 | 2026-09-24 15:43 | 2026-09-24 15:43 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 53.2000 | 53.2000 | 53.7500 | 1074.8300 | 37243.00 | 0.00 | 37243.00 | 7 | 6 | 1183 | 861 | 1.3739837398374 | 0.635470299674852 | 0.635470299674852 | false | false | false | true | ||||||||||||||||
| 28281e8c-c23d-459c-b811-4a02e66ffea0 | 2026-09-25 09:32 | 2026-09-25 09:31 | 2026-09-25 09:31 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 44.8900 | 44.1000 | 46.3000 | 1094.7770 | 121215.00 | 4470.00 | 116745.00 | 27 | 8 | 31 | 1377 | 0.0225127087872186 | 0.637455464478036 | 0.640865667488411 | false | false | false | true | ||||||||||||||||
| b7d0b64d-18b1-473f-8892-21f55cf07ce8 | 2026-09-25 14:50 | 2026-09-25 14:50 | 2026-09-25 14:50 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 47.4500 | 46.9000 | 47.4500 | 1075.0000 | 52195.00 | 52195.00 | 0.00 | 11 | 7 | 148 | 1377 | 0.107480029048657 | 0.618884396789948 | 0.618884396789948 | true | false | false | true | ||||||||||||||||
| 414da61e-e77c-4ac5-ba69-bf50a5c98198 | 2026-09-25 15:25 | 2026-09-25 15:25 | 2026-09-25 15:25 | MU | MU261016P01050000 | put | 1050.0000 | 2026-10-16 | 46.0000 | 45.9500 | 46.6000 | 1084.3400 | 55205.00 | 9205.00 | 46000.00 | 12 | 12 | 180 | 1377 | 0.130718954248366 | 0.614625713117057 | 0.615028131762113 | false | false | false | true |
| 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-08T13:49:15.511852Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| 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-21T18:09:57.736377Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 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:36:05.660724Z"} |
| 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:13:22.184869Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| 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-22T17:23:35.118331Z"} |
| 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:27:59.988967Z"} |
| 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-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 |
| 1210573930694.00 |
| 2026-09-30 |
| postmarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-23T19:19:13.860823Z"} |
| 2026-09-23 |
| 2026-09-23 21:15 |
| 2026-09-23 21:15 |
| 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-24T14:24:55.986256Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T14:28:24.219175Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T14:44:10.025245Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T16:36:42.025876Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 21:15 |
| 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-24T19:15:33.602136Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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-24T19:50:03.728318Z"} |
| 2026-09-24 |
| 2026-09-24 21:15 |
| 2026-09-24 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:32:31.841243Z"} |
| 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 |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-25T18:55:18.072403Z"} |
| 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-25T19:30:11.536652Z"} |
| 2026-09-25 |
| 2026-09-25 21:15 |
| 2026-09-25 21:15 |