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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86ac9f6c-7120-4d43-92ed-7797f1ca5ad5 | 2026-09-21 15:51 | 2026-09-21 15:51 | 2026-09-21 15:51 | JPM | JPM270319P00325000 | put | 325.0000 | 2027-03-19 | 12.5900 | 12.2500 | 12.6500 | 351.7000 | 11330.00 | 6300.00 | 2510.00 | 9 | 8 | 22 | 524 | 0.0419847328244275 | 0.277916296570269 | 0.277303264758654 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 935787868088.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T19:52:57.186278Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| f7e964be-846e-4b79-bbf8-9fd8eb9a402c | 2026-09-21 13:31 | 2026-09-21 13:31 | 2026-09-21 13:31 | JPM | JPM261016C00360000 | call | 360.0000 | 2026-10-16 | 5.7200 | 5.6000 | 5.8500 | 352.1300 | 17158.00 | 2300.00 | 14858.00 | 30 | 8 | 163 | 4060 | 0.0401477832512315 | 0.236235914953645 | 0.236235914953645 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 935787868088.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T17:34:20.106500Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 1aee8eab-02b2-4692-ac2c-446483c7e801 | 2026-09-21 11:47 | 2026-09-21 11:47 | 2026-09-21 11:47 | JPM | JPM280121P00380000 | put | 380.0000 | 2028-01-21 | 49.6600 | 49.6500 | 50.2000 | 351.3500 | 84418.00 | 0.00 | 84418.00 | 17 | 8 | 27 | 127 | 0.21259842519685 | 0.290098142365244 | 0.289289135017639 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 935787868088.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T15:49:21.879731Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| d3bee592-f33b-45ae-a8b3-5a0b0734f559 | 2026-09-18 14:00 | 2026-09-18 14:00 | 2026-09-18 14:00 | JPM | JPM270617C00320000 | call | 320.0000 | 2027-06-17 | 50.0000 | 49.2000 | 50.9500 | 347.2750 | 279974.00 | 35125.00 | 244849.00 | 56 | 21 | 56 | 753 | 0.0743691899070385 | 0.242359015017179 | 0.24277265707431 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 929487966806.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 2e1b6443-ba73-4349-aff0-f9845fecbd33 | 2026-09-18 10:07 | 2026-09-18 10:06 | 2026-09-18 10:06 | JPM | JPM290119C00350000 | call | 350.0000 | 2029-01-19 | 64.1200 | 62.0000 | 64.1500 | 347.0300 | 115420.00 | 115420.00 | 0.00 | 18 | 10 | 19 | 4 | 4.75 | 0.227525234576222 | 0.225158645192066 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 929487966806.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| bc3cd9cc-7fbb-4589-84b9-ddca3e9a5f9d | 2026-09-17 12:58 | 2026-09-17 12:58 | 2026-09-17 12:58 | JPM | JPM270917C00390000 | call | 390.0000 | 2027-09-17 | 22.9600 | 22.9500 | 23.7500 | 349.8000 | 337450.00 | 0.00 | 337450.00 | 147 | 6 | 151 | 28 | 5.39285714285714 | 0.23156654304968 | 0.23142133341766 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 928531019775.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T17:10:56.508407Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 3ed6a392-030d-48fa-9431-009a0813046b | 2026-09-15 15:00 | 2026-09-15 15:00 | 2026-09-15 15:00 | JPM | JPM271217C00360000 | call | 360.0000 | 2027-12-17 | 43.1800 | 42.0000 | 44.6500 | 351.9200 | 1036424.00 | 347764.00 | 688660.00 | 240 | 18 | 547 | 754 | 0.725464190981432 | 0.240962989327094 | 0.237649617188949 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | 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 |
| 38dcb6ee-66a3-480b-96ee-e58941d5edeb | 2026-09-15 14:50 | 2026-09-15 14:50 | 2026-09-15 14:50 | JPM | JPM260918C00345000 | call | 345.0000 | 2026-09-18 | 5.5500 | 4.2500 | 5.5500 | 346.5900 | 292476.00 | 292476.00 | 0.00 | 527 | 26 | 1355 | 3313 | 0.408994868699064 | 0.371852918038607 | 0.371852918038607 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 6d2522a0-80d7-4812-afc4-4d09ab32c985 | 2026-09-04 15:35 | 2026-09-04 15:34 | 2026-09-04 15:34 | JPM | JPM270617P00370000 | put | 370.0000 | 2027-06-17 | 34.5000 | 33.5500 | 34.5000 | 357.9550 | 248380.00 | 244945.00 | 3435.00 | 72 | 24 | 72 | 379 | 0.189973614775726 | 0.272269165790366 | 0.271002216806973 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T19:47:04.296573Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ac204852-cea7-4717-970f-6f7b0de9a09b | 2026-09-04 13:34 | 2026-09-04 13:33 | 2026-09-04 13:33 | JPM | JPM261120C00365000 | call | 365.0000 | 2026-11-20 | 12.9500 | 12.6500 | 12.9500 | 358.7450 | 444155.00 | 437705.00 | 0.00 | 343 | 49 | 353 | 557 | 0.633752244165171 | 0.220091943379905 | 0.220091943379905 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 32d95ae3-e476-48cf-b4bf-63f1b4ababba | 2026-09-04 13:00 | 2026-09-04 13:00 | 2026-09-04 13:00 | JPM | JPM260911P00360000 | put | 360.0000 | 2026-09-11 | 4.3900 | 4.3500 | 5.3000 | 358.4900 | 290458.00 | 129933.00 | 160525.00 | 661 | 38 | 721 | 236 | 3.05508474576271 | 0.19513190197893 | 0.191268613179908 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T17:07:55.847311Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8ab77e40-d1c1-44b2-90cd-094e0fa71c48 | 2026-09-03 11:20 | 2026-09-03 11:20 | 2026-09-03 11:20 | JPM | JPM270319C00320000 | call | 320.0000 | 2027-03-19 | 55.3700 | 53.4000 | 56.1500 | 361.3300 | 110744.00 | 110744.00 | 0.00 | 20 | 8 | 20 | 460 | 0.0434782608695652 | 0.24052120983706 | 0.24052120983706 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T15:27:44.291947Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c19fd7da-edfb-437f-8cba-c31ee4ed79f4 | 2026-09-02 12:14 | 2026-09-02 12:14 | 2026-09-02 12:14 | JPM | JPM260918C00347500 | call | 347.5000 | 2026-09-18 | 12.7100 | 12.7000 | 13.2500 | 357.0500 | 547775.00 | 102000.00 | 149865.00 | 431 | 34 | 446 | 22 | 20.2727272727273 | 0.219606674507322 | 0.219606674507322 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T16:19:14.278097Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 606173f9-9326-4ab0-abb0-f8306f3b79c2 | 2026-09-01 10:27 | 2026-09-01 10:27 | 2026-09-01 10:27 | JPM | JPM270617C00440000 | call | 440.0000 | 2027-06-17 | 8.2000 | 7.1500 | 8.4500 | 359.0900 | 141905.00 | 71770.00 | 70135.00 | 173 | 13 | 173 | 268 | 0.645522388059702 | 0.222638782317077 | 0.220536574665677 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-01T14:37:25.650051Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3aec65f3-ed0a-42ac-81a5-ee571b85e43a | 2026-08-28 15:38 | 2026-08-28 15:38 | 2026-08-28 15:38 | JPM | JPM270617P00340000 | put | 340.0000 | 2027-06-17 | 21.3600 | 21.3500 | 22.2000 | 356.9300 | 269076.00 | 0.00 | 269076.00 | 126 | 12 | 142 | 1268 | 0.11198738170347 | 0.273469481099747 | 0.273382619923869 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T19:57:19.773601Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f17a84a7-4bac-4862-a0a3-025eb437eacf | 2026-08-25 12:57 | 2026-08-25 12:57 | 2026-08-25 12:57 | JPM | JPM280121P00360000 | put | 360.0000 | 2028-01-21 | 39.1000 | 39.1000 | 39.8000 | 355.8300 | 156401.00 | 0.00 | 156401.00 | 40 | 15 | 81 | 462 | 0.175324675324675 | 0.287062370633559 | 0.287062370633559 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:59:46.608693Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b6ba8b55-463e-411d-a280-f5e5d51eb3f3 | 2026-08-21 11:27 | 2026-08-21 11:27 | 2026-08-21 11:27 | JPM | JPM270319P00310000 | put | 310.0000 | 2027-03-19 | 9.8800 | 9.5500 | 9.9000 | 352.5350 | 1265176.00 | 1173156.00 | 4900.00 | 1280 | 68 | 1281 | 643 | 1.99222395023328 | 0.283417505529534 | 0.283118990626483 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T15:38:28.521674Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4561fe8c-0a11-449c-a11c-f5cee351675d | 2026-08-21 09:43 | 2026-08-21 09:43 | 2026-08-21 09:43 | JPM | JPM281215C00360000 | call | 360.0000 | 2028-12-15 | 63.6300 | 62.9000 | 64.0000 | 355.4700 | 146345.00 | 12730.00 | 89065.00 | 23 | 23 | 47 | 167 | 0.281437125748503 | 0.232263899178985 | 0.232011532047892 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:52:23.943774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 099a7a49-511a-43fe-823a-89bd247fff73 | 2026-08-20 11:31 | 2026-08-20 11:31 | 2026-08-20 11:31 | JPM | JPM260904P00355000 | put | 355.0000 | 2026-09-04 | 5.6500 | 5.2500 | 5.6500 | 355.3900 | 353683.00 | 353683.00 | 0.00 | 626 | 55 | 631 | 184 | 3.42934782608696 | 0.212820669542482 | 0.212820669542482 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | 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 |
| 3cb124c7-00c5-4075-9a68-838bdd2b1eb8 | 2026-08-18 12:20 | 2026-08-18 12:20 | 2026-08-18 12:20 | JPM | JPM270115C00320000 | call | 320.0000 | 2027-01-15 | 50.9600 | 50.5000 | 51.0000 | 360.2404 | 606449.00 | 606449.00 | 0.00 | 119 | 16 | 637 | 3814 | 0.167016255899318 | 0.242935924433478 | 0.242790301077058 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| abfbc85e-312b-4359-ad61-e8c5c84cfe18 | 2026-08-18 12:19 | 2026-08-18 12:19 | 2026-08-18 12:19 | JPM | JPM270115C00320000 | call | 320.0000 | 2027-01-15 | 50.6600 | 50.3500 | 51.2000 | 359.8500 | 471183.00 | 253250.00 | 217933.00 | 93 | 10 | 426 | 3814 | 0.111693759832197 | 0.243170542726515 | 0.237400076681669 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:50:14.134420Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1d3d5f9d-b19e-4dab-9e11-b648bad0f860 | 2026-08-18 12:18 | 2026-08-18 12:18 | 2026-08-18 12:18 | JPM | JPM270115C00320000 | call | 320.0000 | 2027-01-15 | 50.5000 | 49.7500 | 51.3000 | 359.7400 | 848337.00 | 0.00 | 424137.00 | 168 | 9 | 186 | 3814 | 0.048767697954903 | 0.241498975481929 | 0.241498975481929 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T16:18:52.426930Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c0dc630b-966d-40df-8172-a5b77212c242 | 2026-08-17 11:14 | 2026-08-17 11:14 | 2026-08-17 11:14 | JPM | JPM260918C00370000 | call | 370.0000 | 2026-09-18 | 6.1500 | 5.8000 | 6.1500 | 364.2550 | 456305.00 | 453255.00 | 3050.00 | 742 | 52 | 818 | 2824 | 0.289660056657224 | 0.190794271286583 | 0.1896411184659 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 930710732455.00 | 2026-10-13 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T15:18:08.402289Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |