Simplify AnalyticsOptions flow alerts (market-wide)
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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 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 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d01c7e8e-f74e-4f28-998d-5b35acc0727d | 2026-09-17 13:42 | 2026-09-17 13:42 | 2026-09-17 13:42 | MPC | MPC270617P00380000 | put | 380.0000 | 2027-06-17 | 46.1800 | 45.0000 | 47.1000 | 421.7800 | 115450.00 | 46400.00 | 69050.00 | 25 | 5 | 31 | 27 | 1.14814814814815 | 0.517576278729119 | 0.518367556069928 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 118496816995.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 4efcec8a-065e-4ebe-b51c-80d725e00f6d | 2026-09-17 13:42 | 2026-09-17 13:42 | 2026-09-17 13:42 | MPC | MPC270617P00440000 | put | 440.0000 | 2027-06-17 | 77.2900 | 77.1000 | 78.7000 | 421.8900 | 123661.00 | 31000.00 | 84941.00 | 16 | 11 | 76 | 62 | 1.2258064516129 | 0.519611408306381 | 0.521716480424428 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 118496816995.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 5f3e28cf-ca71-4856-9a28-3c3efdc5142f | 2026-09-17 10:26 | 2026-09-17 10:26 | 2026-09-17 10:26 | MPC | MPC261120C00500000 | call | 500.0000 | 2026-11-20 | 11.5000 | 10.9000 | 12.6000 | 414.5500 | 112740.00 | 14950.00 | 82840.00 | 98 | 15 | 100 | 4 | 25 | 0.524262112432879 | 0.526119052659159 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 118496816995.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:33:58.839655Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 80d3d40f-d6a9-47d7-88c6-ca8e50f41c15 | 2026-09-16 11:14 | 2026-09-16 11:14 | 2026-09-16 11:14 | MPC | MPC270617C00440000 | call | 440.0000 | 2027-06-17 | 60.4400 | 60.3000 | 61.4000 | 410.6900 | 66480.00 | 30250.00 | 36230.00 | 11 | 5 | 18 | 37 | 0.486486486486487 | 0.470628531645559 | 0.472046945557349 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 116238985901.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 4396d997-4abe-4464-be57-b0adf2439710 | 2026-09-15 12:12 | 2026-09-15 12:12 | 2026-09-15 12:12 | MPC | MPC261016P00370000 | put | 370.0000 | 2026-10-16 | 8.9400 | 8.0000 | 9.3000 | 407.1700 | 67062.00 | 67062.00 | 0.00 | 75 | 19 | 903 | 526 | 1.71673003802281 | 0.514141885891555 | 0.514141885891555 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 1d06d73b-b2ef-4a3d-8400-beda40c2d7f6 | 2026-09-14 14:41 | 2026-09-14 14:41 | 2026-09-14 14:41 | MPC | MPC261016P00390000 | put | 390.0000 | 2026-10-16 | 21.5900 | 20.3000 | 21.7000 | 392.0100 | 719070.00 | 714850.00 | 4220.00 | 333 | 71 | 367 | 286 | 1.28321678321678 | 0.500441165053939 | 0.492766411039266 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | 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 |
| ab0edfec-5f5f-4820-aaeb-ad800f818b39 | 2026-09-11 09:30 | 2026-09-11 09:30 | 2026-09-11 09:30 | MPC | MPC270319C00400000 | call | 400.0000 | 2027-03-19 | 53.9700 | 52.8000 | 55.7000 | 395.6650 | 183500.00 | 118770.00 | 5380.00 | 34 | 34 | 55 | 118 | 0.466101694915254 | 0.467548024226945 | 0.467275742257901 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:30:31.573730Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c7a8e446-96f4-4d72-a40b-eda0861358a1 | 2026-09-10 13:05 | 2026-09-10 13:05 | 2026-09-10 13:05 | MPC | MPC261218C00420000 | call | 420.0000 | 2026-12-18 | 33.3000 | 33.3000 | 34.4000 | 399.4800 | 376314.00 | 0.00 | 376314.00 | 113 | 23 | 119 | 128 | 0.9296875 | 0.482898491535668 | 0.482898491535668 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T17:37:34.117542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7cff32e2-12f0-4bfd-a67e-a31bda68d9c1 | 2026-09-04 11:15 | 2026-09-04 11:15 | 2026-09-04 11:15 | MPC | MPC270617C00400000 | call | 400.0000 | 2027-06-17 | 60.0400 | 59.9000 | 61.9000 | 388.0600 | 180120.00 | 36120.00 | 144000.00 | 30 | 14 | 38 | 138 | 0.27536231884058 | 0.437540073473125 | 0.438284341623301 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:23:10.886670Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f22ed511-b263-4ab6-9cb7-aaf776b3b065 | 2026-09-03 13:31 | 2026-09-03 13:31 | 2026-09-03 13:31 | MPC | MPC261218C00400000 | call | 400.0000 | 2026-12-18 | 38.2400 | 37.5000 | 38.3000 | 391.7550 | 76480.00 | 68840.00 | 7640.00 | 20 | 11 | 77 | 588 | 0.130952380952381 | 0.473750977792154 | 0.474943336698551 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 570f8caa-50a6-4e00-8718-90a45308235b | 2026-09-03 10:53 | 2026-09-03 10:53 | 2026-09-03 10:53 | MPC | MPC270115C00460000 | call | 460.0000 | 2027-01-15 | 25.3700 | 24.4000 | 25.9000 | 398.2300 | 55810.00 | 40510.00 | 7650.00 | 22 | 11 | 22 | 23 | 0.956521739130435 | 0.469377987895722 | 0.471562611544504 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T14:57:35.447301Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 95b8c348-589a-4218-9bfd-0376882b8624 | 2026-09-02 15:23 | 2026-09-02 15:23 | 2026-09-02 15:23 | MPC | MPC261218P00410000 | put | 410.0000 | 2026-12-18 | 48.2600 | 47.1000 | 48.6000 | 391.1813 | 135130.00 | 130300.00 | 0.00 | 28 | 16 | 42 | 0 | 0 | 0.475419687411646 | 0.480153794472847 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7b0c2251-d009-413e-852d-c2480b64c07f | 2026-09-02 15:23 | 2026-09-02 15:23 | 2026-09-02 15:23 | MPC | MPC261218P00400000 | put | 400.0000 | 2026-12-18 | 42.4100 | 41.3000 | 42.6000 | 391.1813 | 203560.00 | 190890.00 | 8440.00 | 48 | 27 | 81 | 4 | 20.25 | 0.474180578430702 | 0.477744682227369 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:37:03.508091Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b9833db3-d0d6-47a1-a395-cfeb7b589301 | 2026-09-02 13:43 | 2026-09-02 13:43 | 2026-09-02 13:43 | MPC | MPC270617P00420000 | put | 420.0000 | 2027-06-17 | 74.3700 | 72.4000 | 74.6000 | 389.4050 | 171040.00 | 171040.00 | 0.00 | 23 | 11 | 30 | 2 | 15 | 0.467707310464665 | 0.469893510771023 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T18:05:44.095975Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6aeab188-f693-4174-b6b4-727eaef9c123 | 2026-09-02 13:10 | 2026-09-02 13:10 | 2026-09-02 13:10 | MPC | MPC260918P00350000 | put | 350.0000 | 2026-09-18 | 2.2200 | 2.1500 | 2.5500 | 388.3399 | 88623.00 | 7210.00 | 81413.00 | 400 | 55 | 854 | 777 | 1.0990990990991 | 0.441874416837985 | 0.452330601865766 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T17:36:40.694178Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7ab075bd-ceb1-4c81-88a3-710ab55b493e | 2026-08-31 15:21 | 2026-08-31 15:20 | 2026-08-31 15:20 | MPC | MPC270416C00360000 | call | 360.0000 | 2027-04-16 | 61.6000 | 59.6000 | 61.6000 | 373.5800 | 930123.00 | 923983.00 | 6140.00 | 151 | 5 | 163 | 0 | 0 | 0.434485842940727 | 0.432767889459955 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ecc4a9d1-0edc-4749-bffd-b27f35b34dc6 | 2026-08-28 13:04 | 2026-08-28 13:04 | 2026-08-28 13:04 | MPC | MPC261016P00320000 | put | 320.0000 | 2026-10-16 | 6.1400 | 5.6000 | 6.3000 | 365.6850 | 61361.00 | 61361.00 | 0.00 | 100 | 13 | 336 | 488 | 0.688524590163934 | 0.443052020823735 | 0.443052020823735 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 851ca31c-3687-47b4-a536-72103dafde75 | 2026-08-28 12:59 | 2026-08-28 12:59 | 2026-08-28 12:59 | MPC | MPC261016P00320000 | put | 320.0000 | 2026-10-16 | 5.8500 | 5.5000 | 6.1000 | 366.5600 | 58450.00 | 58450.00 | 0.00 | 100 | 6 | 135 | 488 | 0.276639344262295 | 0.441333974288871 | 0.441333974288871 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T17:15:24.821907Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e527bf2b-1d96-44e8-aa4d-421e0bc31081 | 2026-08-25 14:22 | 2026-08-25 14:22 | 2026-08-25 14:22 | MPC | MPC261218P00380000 | put | 380.0000 | 2026-12-18 | 44.9500 | 44.3000 | 45.2000 | 359.0000 | 260709.00 | 215609.00 | 0.00 | 58 | 10 | 71 | 30 | 2.36666666666667 | 0.446402040415702 | 0.448885898506601 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d12ee00f-1983-43b5-8f27-ae876b3b0412 | 2026-08-25 14:22 | 2026-08-25 14:22 | 2026-08-25 14:22 | MPC | MPC261218P00380000 | put | 380.0000 | 2026-12-18 | 45.3300 | 44.4000 | 45.4000 | 359.0000 | 145060.00 | 135980.00 | 0.00 | 32 | 13 | 103 | 30 | 3.43333333333333 | 0.450127765109273 | 0.452284848625392 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3dd4c839-b4c9-4075-a1e5-66a30f11e75d | 2026-08-25 14:22 | 2026-08-25 14:22 | 2026-08-25 14:22 | MPC | MPC261218P00370000 | put | 370.0000 | 2026-12-18 | 39.2600 | 38.2000 | 39.4000 | 359.0000 | 145280.00 | 145280.00 | 0.00 | 37 | 24 | 67 | 37 | 1.81081081081081 | 0.448593405356449 | 0.450779786028771 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T18:29:57.396798Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c5765c1b-d041-4b09-9382-3136079ef8ff | 2026-08-25 13:33 | 2026-08-25 13:33 | 2026-08-25 13:33 | MPC | MPC270617C00400000 | call | 400.0000 | 2027-06-17 | 43.4900 | 41.5000 | 43.6000 | 359.3900 | 126130.00 | 126130.00 | 0.00 | 29 | 5 | 35 | 114 | 0.307017543859649 | 0.421626796337184 | 0.422401313476253 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T17:59:30.582778Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4dec442e-997d-4728-bf5c-e8619cbcad04 | 2026-08-17 13:34 | 2026-08-17 13:34 | 2026-08-17 13:34 | MPC | MPC260918C00320000 | call | 320.0000 | 2026-09-18 | 45.4800 | 44.0000 | 45.5000 | 361.6900 | 100060.00 | 100060.00 | 0.00 | 22 | 9 | 50 | 576 | 0.0868055555555556 | 0.387643174456786 | 0.387643174456786 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Energy | 111332977291.00 | 2026-11-03 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |