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_alerts326,449 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 |
|---|
| c4f6e68d-0a72-4934-8772-5e60890f36d6 | 2026-08-19 12:09 | 2026-08-19 12:09 | 2026-08-19 12:09 | MS | MS260918P00210000 | put | 210.0000 | 2026-09-18 | 4.3200 | 4.1000 | 4.3500 | 215.2900 | 97710.00 | 95560.00 | 2150.00 | 226 | 14 | 251 | 4550 | 0.0551648351648352 | 0.282819933124648 | 0.282819933124648 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 324447584601.00 | 2026-10-14 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T16:28:32.259187Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| cde20837-9ceb-431d-8812-78329d8dcaa8 | 2026-08-20 09:34 | 2026-08-20 09:34 | 2026-08-20 09:34 | MS | MS280121C00200000 | call | 200.0000 | 2028-01-21 | 42.7300 | 42.3500 | 45.2500 | 214.4600 | 85452.00 | 0.00 | 85452.00 | 20 | 6 | 20 | 1274 | 0.0156985871271586 | 0.287631120767957 | 0.298320426081422 | false | false | false | true | ||||||||||||||||
| b6c9f805-aa3a-4342-85fb-ee3ff7912ecf | 2026-08-20 11:23 | 2026-08-20 11:23 | 2026-08-20 11:23 | MS | MS261016P00220000 | put | 220.0000 | 2026-10-16 | 13.8500 | 13.8500 | 14.4000 | 212.2800 | 1283915.00 | 2780.00 | 1281135.00 | 927 | 66 | 937 | 852 | 1.09976525821596 | 0.304191398513189 | 0.304191398513189 | false | false | false | true | ||||||||||||||||
| c0923568-f7c6-4050-996b-fc946ebe510c | 2026-08-20 12:30 | 2026-08-20 12:30 | 2026-08-20 12:30 | MS | MS261120C00220000 | call | 220.0000 | 2026-11-20 | 9.3000 | 9.3000 | 9.4500 | 210.5800 | 115328.00 | 0.00 | 115328.00 | 124 | 33 | 151 | 1318 | 0.114567526555387 | 0.294112838908959 | 0.294112838908959 | false | false | false | true | ||||||||||||||||
| 8c9b36ac-0629-406e-b375-dfb121a4c9a0 | 2026-08-21 11:52 | 2026-08-21 11:51 | 2026-08-21 11:51 | MS | MS270917P00165000 | put | 165.0000 | 2027-09-17 | 8.3800 | 7.6500 | 9.3500 | 211.3050 | 103120.00 | 33400.00 | 69720.00 | 123 | 24 | 184 | 0 | 0 | 0.360165502351423 | 0.361080892932324 | false | false | false | true | ||||||||||||||||
| 296eb383-41e3-482a-9776-ce3f7772aa2f | 2026-08-21 14:25 | 2026-08-21 14:25 | 2026-08-21 14:25 | MS | MS260918P00200000 | put | 200.0000 | 2026-09-18 | 2.2300 | 2.2100 | 2.2400 | 212.0000 | 59437.00 | 48608.00 | 10829.00 | 266 | 15 | 295 | 4904 | 0.0601549755301794 | 0.299297739107748 | 0.299297739107748 | false | false | false | true | ||||||||||||||||
| a1bf91cc-fc73-42ee-a8e6-e4aa846ecaaa | 2026-08-24 10:38 | 2026-08-24 10:38 | 2026-08-24 10:38 | MS | MS261120C00230000 | call | 230.0000 | 2026-11-20 | 7.4900 | 7.3000 | 7.5000 | 214.9700 | 235202.00 | 191245.00 | 43957.00 | 314 | 24 | 319 | 1106 | 0.288426763110307 | 0.297346586447339 | 0.297346586447339 | false | false | false | true | ||||||||||||||||
| 45bc22ac-650c-4abd-96b3-e306e5a18610 | 2026-08-26 09:58 | 2026-08-26 09:58 | 2026-08-26 09:58 | MS | MS270115P00190000 | put | 190.0000 | 2027-01-15 | 6.6200 | 5.7500 | 6.6500 | 214.1700 | 70860.00 | 69560.00 | 1300.00 | 107 | 15 | 109 | 2664 | 0.0409159159159159 | 0.337095943446391 | 0.338335861746466 | true | false | false | true | ||||||||||||||||
| b4f7db0b-f07e-4546-81d9-06323b01ea45 | 2026-08-31 15:32 | 2026-08-31 15:32 | 2026-08-31 15:32 | MS | MS280121C00210000 | call | 210.0000 | 2028-01-21 | 36.5200 | 36.3500 | 38.1000 | 213.4800 | 51130.00 | 25585.00 | 25545.00 | 14 | 6 | 14 | 298 | 0.0469798657718121 | 0.289329407369332 | 0.290405735159284 | false | false | false | true | ||||||||||||||||
| 64be123c-01ca-4797-bde4-cb305847fa37 | 2026-09-02 12:19 | 2026-09-02 12:19 | 2026-09-02 12:19 | MS | MS261218C00250000 | call | 250.0000 | 2026-12-18 | 2.9800 | 2.8500 | 2.9900 | 211.9400 | 128611.00 | 105194.00 | 20128.00 | 431 | 39 | 440 | 911 | 0.482985729967069 | 0.285002051028018 | 0.284823007151318 | false | false | false | true | ||||||||||||||||
| b7743cbb-bc3c-479d-a53c-12ad284572b2 | 2026-09-03 12:21 | 2026-09-03 12:21 | 2026-09-03 12:21 | MS | MS260918C00215000 | call | 215.0000 | 2026-09-18 | 6.0000 | 6.0000 | 6.3000 | 216.7950 | 463215.00 | 0.00 | 463215.00 | 772 | 59 | 774 | 202 | 3.83168316831683 | 0.278691684880528 | 0.278691684880528 | false | false | false | true | ||||||||||||||||
| e189be18-aedf-4a89-aa1d-6d68232de5aa | 2026-09-10 14:58 | 2026-09-10 14:58 | 2026-09-10 14:58 | MS | MS270115P00200000 | put | 200.0000 | 2027-01-15 | 9.6800 | 9.4500 | 9.8000 | 213.0540 | 54190.00 | 27170.00 | 22195.00 | 56 | 12 | 92 | 2580 | 0.0356589147286822 | 0.339093108613133 | 0.34073602312277 | false | false | false | true | ||||||||||||||||
| dd60effb-7686-47ea-840a-4d4d40f6b56d | 2026-09-11 13:14 | 2026-09-11 13:14 | 2026-09-11 13:14 | MS | MS261218P00220000 | put | 220.0000 | 2026-12-18 | 16.5900 | 16.3500 | 16.6000 | 214.2000 | 68027.00 | 63062.00 | 4965.00 | 41 | 8 | 306 | 360 | 0.85 | 0.33261862033664 | 0.331941087202285 | false | false | false | true | ||||||||||||||||
| ceb727e0-5ef0-4d13-b324-a5f8a285c521 | 2026-09-11 15:34 | 2026-09-11 15:34 | 2026-09-11 15:34 | MS | MS270917P00180000 | put | 180.0000 | 2027-09-17 | 11.3500 | 11.3500 | 11.6500 | 214.4800 | 143070.00 | 13680.00 | 129390.00 | 126 | 20 | 130 | 153 | 0.849673202614379 | 0.356384707013683 | 0.356384707013683 | false | false | false | true | ||||||||||||||||
| 4dbdbd6b-3e7c-4da6-935a-8ab65269ceba | 2026-09-14 13:33 | 2026-09-14 13:32 | 2026-09-14 13:32 | MS | MS260918P00202500 | put | 202.5000 | 2026-09-18 | 1.6600 | 1.5100 | 1.7500 | 206.8900 | 82998.00 | 82998.00 | 0.00 | 500 | 5 | 2603 | 341 | 7.63343108504399 | 0.401728288006833 | 0.401728288006833 | false | false | false | true | ||||||||||||||||
| d3e0d02d-d83d-4926-998a-403b7cc9ba3c | 2026-09-14 14:23 | 2026-09-14 14:23 | 2026-09-14 14:23 | MS | MS270115P00200000 | put | 200.0000 | 2027-01-15 | 11.6500 | 11.4000 | 12.0000 | 206.6400 | 219033.00 | 1170.00 | 216698.00 | 188 | 21 | 203 | 2553 | 0.0795142969056013 | 0.339286954379402 | 0.341044849730638 | false | false | false | true | ||||||||||||||||
| 05752272-c683-4ac9-8abe-741641e56a3c | 2026-09-15 11:29 | 2026-09-15 11:29 | 2026-09-15 11:29 | MS | MS270115P00210000 | put | 210.0000 | 2027-01-15 | 18.4600 | 18.0500 | 18.5000 | 202.7300 | 110770.00 | 77600.00 | 33170.00 | 60 | 9 | 69 | 864 | 0.0798611111111111 | 0.342317167957338 | 0.342897065069556 | true | false | false | true | ||||||||||||||||
| 04c5b999-8155-4458-9dd8-caa9d798afa5 | 2026-09-16 14:17 | 2026-09-16 14:17 | 2026-09-16 14:17 | MS | MS290119P00195000 | put | 195.0000 | 2029-01-19 | 27.5800 | 26.3000 | 29.0500 | 207.2250 | 273035.00 | 248155.00 | 24880.00 | 99 | 6 | 99 | 0 | 0 | 0.363145095359046 | 0.369702679590746 | false | false | false | true | ||||||||||||||||
| 58f37f64-fa7f-4744-b98a-07d7ddaae6af | 2026-09-16 15:39 | 2026-09-16 15:39 | 2026-09-16 15:39 | MS | MS280121P00210000 | put | 210.0000 | 2028-01-21 | 31.2000 | 30.8000 | 31.2000 | 201.4750 | 293240.00 | 293240.00 | 0.00 | 94 | 7 | 101 | 587 | 0.17206132879046 | 0.36292151296943 | 0.36292151296943 | false | false | false | true | ||||||||||||||||
| b90031a3-3b11-444a-8262-b2fdf63c61e3 | 2026-09-21 12:55 | 2026-09-21 12:55 | 2026-09-21 12:55 | MS | MS261002P00200000 | put | 200.0000 | 2026-10-02 | 2.0200 | 1.9300 | 2.2200 | 205.0000 | 32122.00 | 205.00 | 31917.00 | 159 | 38 | 250 | 433 | 0.577367205542725 | 0.302907472660407 | 0.305362398064534 | false | false | false | true | ||||||||||||||||
| c705f36d-b9f4-4a11-9e60-597cb775e543 | 2026-09-22 09:43 | 2026-09-22 09:42 | 2026-09-22 09:42 | MS | MS260925P00200000 | put | 200.0000 | 2026-09-25 | 1.0400 | 0.6500 | 1.2500 | 204.2200 | 19143.00 | 11651.00 | 108.00 | 184 | 18 | 185 | 1199 | 0.154295246038365 | 0.362525893074847 | 0.369241046799463 | false | false | false | true | ||||||||||||||||
| 504e12df-0952-463d-bf91-02b40a495c45 | 2026-09-22 11:41 | 2026-09-22 11:41 | 2026-09-22 11:41 | MS | MS261016C00215000 | call | 215.0000 | 2026-10-16 | 2.1300 | 2.1100 | 2.3100 | 199.6200 | 115513.00 | 44201.00 | 71312.00 | 542 | 48 | 1051 | 58 | 18.1206896551724 | 0.341566698093493 | 0.345515606880933 | true | false | false | true | ||||||||||||||||
| 81032ffb-3448-4d27-a593-ac152a5a0641 | 2026-09-22 13:28 | 2026-09-22 13:28 | 2026-09-22 13:28 | MS | MS261218C00190000 | call | 190.0000 | 2026-12-18 | 18.5000 | 18.4500 | 18.8000 | 200.1750 | 70310.00 | 1870.00 | 68440.00 | 38 | 7 | 1032 | 309 | 3.33980582524272 | 0.302522152734502 | 0.309753291115013 | true | false | false | true |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T15:34:13.056370Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-20T16:44:56.732853Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T15:55:19.311132Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-26T14:00:25.587411Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-08-31T19:54:15.623665Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-02T16:56:20.498446Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T17:27:08.545704Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-11T19:55:36.907305Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T17:44:35.656770Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-14T18:49:41.095224Z"} |
| 2026-09-15 |
| 2026-09-15 08:45 |
| 2026-09-15 08:45 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 324447584601.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-15T15:54:17.138635Z"} |
| 2026-09-15 |
| 2026-09-15 21:15 |
| 2026-09-15 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 317914028827.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T18:26:46.257544Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 317914028827.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-16T19:45:47.974261Z"} |
| 2026-09-16 |
| 2026-09-16 21:15 |
| 2026-09-16 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 323725124107.00 |
| 2026-10-14 |
| premarket |
| true |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-21T16:56:43.151057Z"} |
| 2026-09-21 |
| 2026-09-21 21:15 |
| 2026-09-21 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 314395960333.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T13:43:21.956551Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 314395960333.00 |
| 2026-10-14 |
| premarket |
| — |
| uw_flow_alerts |
| /api/option-trades/flow-alerts |
| {"limit":500,"older_than":"2026-09-22T15:42:55.952799Z"} |
| 2026-09-22 |
| 2026-09-22 21:15 |
| 2026-09-22 21:15 |
| RepeatedHitsAscendingFill |
| a0979b52-28e4-4585-8f22-881faad2dd8e |
| 1 |
| Common Stock |
| Financial Services |
| 314395960333.00 |
| 2026-10-14 |
| premarket |
| — |
| 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 |