Options 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 611e433b-b330-4140-accc-4cfbd6e83393 | 2026-09-21 10:51 | 2026-09-21 10:51 | 2026-09-21 10:51 | JPM | JPM261218C00350000 | call | 350.0000 | 2026-12-18 | 18.4000 | 18.1000 | 18.4000 | 351.6450 | 103040.00 | 103040.00 | 0.00 | 56 | 28 | 83 | 2108 | 0.0393738140417457 | 0.229820856339162 | 0.229820856339162 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-21T14:55:57.762099Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 3114dd65-2168-4778-94de-f9fafe7fa88f | 2026-09-21 10:51 | 2026-09-21 10:51 | 2026-09-21 10:51 | JPM | JPM261218C00355000 | call | 355.0000 | 2026-12-18 | 15.7500 | 15.4500 | 15.7500 | 351.6450 | 12600.00 | 12600.00 | 0.00 | 8 | 5 | 21 | 429 | 0.048951048951049 | 0.227581896363396 | 0.227581896363396 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-21T14:55:57.762099Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 3826cd19-fafb-4876-bf7f-3aaf00d5463f | 2026-09-21 10:58 | 2026-09-21 10:57 | 2026-09-21 10:57 | JPM | JPM261016C00362500 | call | 362.5000 | 2026-10-16 | 4.7000 | 4.3000 | 4.7000 | 351.5750 | 18800.00 | 18800.00 | 0.00 | 40 | 5 | 45 | 0 | 0 | 0.236194588630034 | 0.236194588630034 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-21T14:59:04.068372Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| dd1671f6-64ae-4b4f-9368-95f51bd91485 | 2026-09-21 11:16 | 2026-09-21 11:16 | 2026-09-21 11:16 | JPM | JPM271217C00360000 | call | 360.0000 | 2027-12-17 | 41.6000 | 40.3000 | 41.8000 | 351.9550 | 91525.00 | 37440.00 | 8325.00 | 22 | 7 | 22 | 404 | 0.0544554455445545 | 0.228470630282924 | 0.228782388512902 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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:19:12.034191Z"} | 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 |
| 4c8a473c-c952-4621-82de-b73655685746 | 2026-09-21 12:10 | 2026-09-21 12:10 | 2026-09-21 12:10 | JPM | JPM260925P00350000 | put | 350.0000 | 2026-09-25 | 2.8900 | 2.8900 | 3.2000 | 351.3500 | 39027.00 | 0.00 | 39027.00 | 135 | 5 | 666 | 698 | 0.954154727793696 | 0.245274063040248 | 0.245966631573137 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-21T16:10:34.961716Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 94b649d0-c686-41f3-a932-81f8ba988345 | 2026-09-21 12:58 | 2026-09-21 12:58 | 2026-09-21 12:58 | JPM | JPM270319P00360000 | put | 360.0000 | 2027-03-19 | 26.5500 | 26.3500 | 26.7500 | 351.5300 | 21240.00 | 18585.00 | 2655.00 | 8 | 8 | 14 | 224 | 0.0625 | 0.264880918115224 | 0.264880918115224 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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:02:00.389820Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 92200aca-86cc-4f60-9910-42e15af94489 | 2026-09-21 13:12 | 2026-09-21 13:12 | 2026-09-21 13:12 | JPM | JPM260925P00342500 | put | 342.5000 | 2026-09-25 | 0.7000 | 0.7000 | 0.7700 | 352.5000 | 38221.00 | 71.00 | 38150.00 | 546 | 52 | 990 | 391 | 2.53196930946292 | 0.261987843949979 | 0.261987843949979 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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:16:02.178873Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 28006817-e659-439b-8745-83f2b2052d61 | 2026-09-21 13:12 | 2026-09-21 13:12 | 2026-09-21 13:12 | JPM | JPM260925P00347500 | put | 347.5000 | 2026-09-25 | 1.6500 | 1.6500 | 1.8200 | 352.5000 | 28050.00 | 0.00 | 28050.00 | 170 | 27 | 510 | 220 | 2.31818181818182 | 0.250725166887974 | 0.250725166887974 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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:16:02.178873Z"} | 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 |
| c9ef5c2f-ba96-4c36-ae5f-ad61c698eb1f | 2026-09-21 13:48 | 2026-09-21 13:48 | 2026-09-21 13:48 | JPM | JPM261218P00345000 | put | 345.0000 | 2026-12-18 | 11.8500 | 11.8500 | 12.8500 | 351.6000 | 46215.00 | 0.00 | 46215.00 | 39 | 12 | 45 | 412 | 0.109223300970874 | 0.241382615616573 | 0.241382615616573 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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:50:05.863152Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 87ac5ff2-586e-4ae3-80f2-0cf81cca4fa9 | 2026-09-21 13:48 | 2026-09-21 13:48 | 2026-09-21 13:48 | JPM | JPM261016C00355000 | call | 355.0000 | 2026-10-16 | 7.5600 | 7.4500 | 7.8000 | 351.5201 | 13615.00 | 760.00 | 12855.00 | 18 | 8 | 255 | 2389 | 0.106739221431561 | 0.237611280640367 | 0.237611280640367 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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:50:05.863152Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 51a6b2cb-697d-4032-a683-1fc64ea959d9 | 2026-09-21 13:57 | 2026-09-21 13:57 | 2026-09-21 13:57 | JPM | JPM270115C00400000 | call | 400.0000 | 2027-01-15 | 4.3500 | 4.2000 | 4.5000 | 351.8850 | 13485.00 | 13050.00 | 435.00 | 31 | 16 | 312 | 4657 | 0.0669959201202491 | 0.218528697883489 | 0.218528697883489 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-21T18:00:14.697100Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| dbb5dde0-df2c-4d69-a4de-cb1093426c39 | 2026-09-21 14:58 | 2026-09-21 14:58 | 2026-09-21 14:58 | JPM | JPM270917C00350000 | call | 350.0000 | 2027-09-17 | 41.6000 | 40.8000 | 41.6000 | 352.6000 | 83200.00 | 83200.00 | 0.00 | 20 | 5 | 20 | 101 | 0.198019801980198 | 0.235281657597355 | 0.235281657597355 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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:00:53.952817Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| d360295f-41f5-476c-82b8-9ff959777650 | 2026-09-21 15:07 | 2026-09-21 15:07 | 2026-09-21 15:07 | JPM | JPM260925P00350000 | put | 350.0000 | 2026-09-25 | 2.6500 | 2.5700 | 2.6500 | 351.9400 | 23850.00 | 23850.00 | 0.00 | 90 | 12 | 900 | 698 | 1.28939828080229 | 0.247345172626394 | 0.245651876354336 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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:10:48.404426Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 90ab91e6-bd75-482e-92ec-71e892763485 | 2026-09-21 15:08 | 2026-09-21 15:08 | 2026-09-21 15:08 | JPM | JPM261016C00350000 | call | 350.0000 | 2026-10-16 | 10.3000 | 10.2500 | 10.9500 | 351.8601 | 26785.00 | 1035.00 | 25750.00 | 26 | 5 | 200 | 2068 | 0.0967117988394584 | 0.241187270619365 | 0.241187270619365 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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:10:48.404426Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 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 |