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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1c6c1307-844c-4e0b-beec-49a9addcdbea | 2026-08-19 10:11 | 2026-08-19 10:11 | 2026-08-19 10:11 | MP | MP270115P00055000 | put | 55.0000 | 2027-01-15 | 8.3900 | 7.5000 | 8.5000 | 56.5450 | 12590.00 | 12590.00 | 0.00 | 15 | 5 | 15 | 9776 | 0.00153436988543372 | 0.690791756089177 | 0.661605162895365 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T14:11:54.267551Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 96ce1ca6-b11f-48a2-baf3-ab9fd7a6cd9c | 2026-08-20 10:19 | 2026-08-20 10:19 | 2026-08-20 10:19 | MP | MP270115C00080000 | call | 80.0000 | 2027-01-15 | 2.9400 | 2.8600 | 3.3000 | 53.1000 | 10279.00 | 0.00 | 10279.00 | 35 | 6 | 60 | 2806 | 0.0213827512473272 | 0.700223490041015 | 0.700223490041015 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:33:56.503993Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 527e9934-3528-4934-b603-a0a42e9a1e12 | 2026-08-20 15:21 | 2026-08-20 15:21 | 2026-08-20 15:21 | MP | MP270319C00070000 | call | 70.0000 | 2027-03-19 | 6.4700 | 6.3000 | 6.7500 | 53.9200 | 15537.00 | 0.00 | 15537.00 | 24 | 5 | 33 | 417 | 0.079136690647482 | 0.678921599200389 | 0.678921599200389 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:42:29.270849Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9e817b94-dba3-4d49-86ce-74918397ba2e | 2026-08-25 10:02 | 2026-08-25 10:02 | 2026-08-25 10:02 | MP | MP260904P00060000 | put | 60.0000 | 2026-09-04 | 4.6300 | 4.2500 | 4.7000 | 57.2950 | 46295.00 | 45830.00 | 465.00 | 100 | 9 | 100 | 81 | 1.23456790123457 | 0.815622303630759 | 0.815622303630759 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5d0371f9-42fd-4522-8f27-3dc4fc35cb70 | 2026-08-25 10:02 | 2026-08-25 10:02 | 2026-08-25 10:02 | MP | MP260904P00061000 | put | 61.0000 | 2026-09-04 | 5.3800 | 4.9000 | 5.4500 | 57.2950 | 12905.00 | 6480.00 | 5885.00 | 24 | 15 | 24 | 2 | 12 | 0.836245861563165 | 0.822038521139228 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:12:03.649618Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c1042453-b40a-4484-ade3-fb9d05f3e30e | 2026-08-25 10:15 | 2026-08-25 10:14 | 2026-08-25 10:14 | MP | MP260904C00055000 | call | 55.0000 | 2026-09-04 | 3.9100 | 3.8500 | 4.2500 | 57.1400 | 28536.00 | 0.00 | 27756.00 | 73 | 9 | 98 | 436 | 0.224770642201835 | 0.707399203378833 | 0.718843502679199 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T14:28:24.156188Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2bc24e80-0e39-445c-9815-8fb9e9021579 | 2026-08-26 09:48 | 2026-08-26 09:47 | 2026-08-26 09:47 | MP | MP271217C00080000 | call | 80.0000 | 2027-12-17 | 14.8100 | 13.3000 | 16.3000 | 61.8500 | 296124.00 | 29820.00 | 11744.00 | 200 | 6 | 203 | 1093 | 0.185727355901189 | 0.69813713178067 | 0.69813713178067 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | 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 |
| b6e16cd6-1ae9-4c94-abd2-5d405c829f01 | 2026-08-26 11:50 | 2026-08-26 11:50 | 2026-08-26 11:50 | MP | MP260918C00065000 | call | 65.0000 | 2026-09-18 | 1.9700 | 1.8300 | 2.1500 | 58.7950 | 10664.00 | 8600.00 | 2064.00 | 54 | 8 | 620 | 5230 | 0.118546845124283 | 0.708308456576191 | 0.708308456576191 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T16:19:14.401378Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 148b3a1d-b9f2-4270-80be-62c7158fd6f6 | 2026-08-26 15:38 | 2026-08-26 15:38 | 2026-08-26 15:38 | MP | MP261016P00065000 | put | 65.0000 | 2026-10-16 | 9.8100 | 9.6000 | 9.8500 | 59.0100 | 11776.00 | 11776.00 | 0.00 | 12 | 6 | 111 | 8 | 13.875 | 0.72324433120286 | 0.710472214392337 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T19:41:15.773512Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2b36bf16-8452-4c4d-9638-12234472fcf1 | 2026-09-08 11:00 | 2026-09-08 11:00 | 2026-09-08 11:00 | MP | MP260918C00055000 | call | 55.0000 | 2026-09-18 | 3.4800 | 3.4000 | 3.5500 | 56.5700 | 16688.00 | 9791.00 | 1032.00 | 48 | 27 | 246 | 3487 | 0.0705477487811873 | 0.722298712106796 | 0.694231733238202 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:02:25.769037Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 936c2e79-178c-4b42-8bb6-e63f85a8a4b1 | 2026-09-08 11:02 | 2026-09-08 11:02 | 2026-09-08 11:02 | MP | MP260918C00055000 | call | 55.0000 | 2026-09-18 | 3.5700 | 3.5500 | 3.6500 | 56.8000 | 13930.00 | 0.00 | 12850.00 | 39 | 14 | 554 | 3487 | 0.158875824490966 | 0.695743879249263 | 0.68157776710188 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-08T15:14:28.726538Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 855fecd6-15c2-41d6-9b20-03ac58b905a6 | 2026-09-10 12:09 | 2026-09-10 12:09 | 2026-09-10 12:09 | MP | MP280121C00050000 | call | 50.0000 | 2028-01-21 | 17.7100 | 17.3500 | 19.1000 | 51.7700 | 53132.00 | 3820.00 | 49312.00 | 30 | 5 | 47 | 2197 | 0.0213928083750569 | 0.746218596823771 | 0.673725047965522 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T16:13:08.333814Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 9976b15a-1acb-4dff-b21b-e30c001bb8c0 | 2026-09-11 09:34 | 2026-09-11 09:34 | 2026-09-11 09:34 | MP | MP270115C00050000 | call | 50.0000 | 2027-01-15 | 8.3700 | 7.9000 | 9.0500 | 50.0000 | 41826.00 | 1810.00 | 40016.00 | 50 | 9 | 50 | 2288 | 0.0218531468531469 | 0.719023037505607 | 0.656234584651206 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T13:37:33.609039Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7b2055af-8d6c-4b35-878e-c48cd533edf5 | 2026-09-11 10:18 | 2026-09-11 10:18 | 2026-09-11 10:18 | MP | MP260918C00054000 | call | 54.0000 | 2026-09-18 | 1.0300 | 0.8400 | 1.0500 | 51.6550 | 33211.00 | 33211.00 | 0.00 | 321 | 31 | 737 | 2186 | 0.337145471180238 | 0.684477536794636 | 0.668525086526821 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T14:26:53.669819Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 745c660a-77cf-488f-ac78-53207a81aea0 | 2026-09-15 11:21 | 2026-09-15 11:21 | 2026-09-15 11:21 | MP | MP261218C00060000 | call | 60.0000 | 2026-12-18 | 3.1000 | 3.0500 | 3.2500 | 49.0350 | 113515.00 | 2205.00 | 111310.00 | 366 | 66 | 433 | 5077 | 0.0852865865668702 | 0.656860119207083 | 0.651946139181759 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T15:29:06.202071Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| fc199e16-9c91-4a07-9e5b-e405a4baf878 | 2026-09-15 13:34 | 2026-09-15 13:34 | 2026-09-15 13:34 | MP | MP281215P00040000 | put | 40.0000 | 2028-12-15 | 9.2600 | 9.2500 | 9.5000 | 49.6200 | 39800.00 | 0.00 | 39800.00 | 43 | 6 | 44 | 1606 | 0.0273972602739726 | 0.59507368446288 | 0.592794978310676 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T17:45:33.615815Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 6d5eb9b5-99ad-4492-a07b-1cff8f9a4dd6 | 2026-09-15 14:22 | 2026-09-15 14:22 | 2026-09-15 14:22 | MP | MP281215P00040000 | put | 40.0000 | 2028-12-15 | 9.2400 | 9.2000 | 9.5000 | 49.5200 | 55426.00 | 0.00 | 41401.00 | 60 | 26 | 130 | 1606 | 0.0809464508094645 | 0.596357583050122 | 0.589520701532033 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| f148f2de-4560-4467-a508-1c672aa1fa53 | 2026-09-15 14:22 | 2026-09-15 14:22 | 2026-09-15 14:22 | MP | MP281215P00040000 | put | 40.0000 | 2028-12-15 | 9.2400 | 9.2000 | 9.5500 | 49.5101 | 55470.00 | 14070.00 | 41400.00 | 60 | 17 | 191 | 1606 | 0.11892901618929 | 0.597627075961818 | 0.589421878860986 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:42:39.046957Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 6709dd4e-c77f-484b-8a72-75fa3ee3953c | 2026-09-15 15:19 | 2026-09-15 15:19 | 2026-09-15 15:19 | MP | MP270319P00040000 | put | 40.0000 | 2027-03-19 | 3.4400 | 3.4000 | 3.6000 | 49.3700 | 23738.00 | 0.00 | 23738.00 | 69 | 10 | 369 | 1184 | 0.311655405405405 | 0.597839685589668 | 0.592167215775004 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 71a11c11-069c-4114-be65-699cca625958 | 2026-09-15 15:20 | 2026-09-15 15:19 | 2026-09-15 15:19 | MP | MP270319P00040000 | put | 40.0000 | 2027-03-19 | 3.4200 | 3.4000 | 3.6000 | 49.3700 | 39638.00 | 0.00 | 39638.00 | 116 | 28 | 485 | 1184 | 0.409628378378378 | 0.595950335674587 | 0.592167215775004 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 9026188480.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| b05931e0-45a5-4fa5-9c5f-5f6dc284db6e | 2026-09-17 11:12 | 2026-09-17 11:12 | 2026-09-17 11:12 | MP | MP270319C00045000 | call | 45.0000 | 2027-03-19 | 10.9400 | 10.6500 | 12.4000 | 49.2700 | 164072.00 | 0.00 | 164072.00 | 150 | 7 | 150 | 232 | 0.646551724137931 | 0.617045932715882 | 0.616240846644786 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 8794656415.00 | 2026-11-05 | unknown | — | 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 |
| 664defe5-8a94-41ca-98ef-a8039ae69bca | 2026-09-18 10:52 | 2026-09-18 10:52 | 2026-09-18 10:52 | MP | MP261120P00050000 | put | 50.0000 | 2026-11-20 | 5.8100 | 5.4500 | 5.9000 | 48.1350 | 35465.00 | 9945.00 | 25520.00 | 61 | 11 | 75 | 25 | 3 | 0.626105231108464 | 0.619837692937705 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Basic Materials | 8417081049.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |