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.
231,528 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts231,528 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 278b44c2-c1d6-4e4d-81db-c809b2727d24 | 2026-09-18 12:54 | 2026-09-18 12:54 | 2026-09-18 12:54 | AXP | AXP270617P00320000 | put | 320.0000 | 2027-06-17 | 30.9000 | 30.8000 | 32.1500 | 311.1550 | 135958.00 | 3085.00 | 132873.00 | 44 | 5 | 44 | 416 | 0.105769230769231 | 0.296807559448955 | 0.296241591336964 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 210399531569.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T17:09:50.881001Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| be77beb5-2549-444f-9832-30072593063e | 2026-09-17 11:16 | 2026-09-17 11:16 | 2026-09-17 11:16 | AXP | AXP281215C00400000 | call | 400.0000 | 2028-12-15 | 34.5900 | 34.2500 | 34.7500 | 313.9200 | 103780.00 | 44975.00 | 58805.00 | 30 | 13 | 904 | 1317 | 0.686408504176158 | 0.272524271383511 | 0.272524271383511 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 210136160735.00 | 2026-10-23 | premarket | — | 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 |
| 4ef28afc-b4d3-47b2-84f4-76607e245443 | 2026-09-11 13:02 | 2026-09-11 13:02 | 2026-09-11 13:02 | AXP | AXP260918C00325000 | call | 325.0000 | 2026-09-18 | 4.6500 | 4.4000 | 4.6500 | 325.5800 | 79045.00 | 79045.00 | 0.00 | 170 | 40 | 404 | 2657 | 0.15205118554761 | 0.235217177554752 | 0.235217177554752 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | 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 |
| c2df1522-2e8e-43b6-a062-76e79c9dcdad | 2026-09-03 12:42 | 2026-09-03 12:41 | 2026-09-03 12:41 | AXP | AXP270617C00300000 | call | 300.0000 | 2027-06-17 | 54.4500 | 53.7000 | 54.4500 | 330.5700 | 811252.00 | 805812.00 | 5440.00 | 149 | 5 | 154 | 152 | 1.01315789473684 | 0.275755766412212 | 0.275226504928436 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:58:53.831299Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1ff88b28-c1d0-4e6f-9ba5-b6ec480dcc86 | 2026-09-02 10:48 | 2026-09-02 10:48 | 2026-09-02 10:48 | AXP | AXP260918C00340000 | call | 340.0000 | 2026-09-18 | 3.2500 | 3.2000 | 3.4000 | 331.8650 | 79645.00 | 28925.00 | 50720.00 | 245 | 74 | 472 | 1344 | 0.351190476190476 | 0.22762724193237 | 0.225630270074039 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T15:04:15.415728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2ec4bbd0-3384-4b96-9cd1-256fc09db9f4 | 2026-09-02 10:36 | 2026-09-02 10:36 | 2026-09-02 10:36 | AXP | AXP270617P00360000 | put | 360.0000 | 2027-06-17 | 43.9000 | 43.7500 | 44.4500 | 331.5600 | 456582.00 | 8770.00 | 447812.00 | 104 | 7 | 204 | 63 | 3.23809523809524 | 0.290840453946033 | 0.289987712336109 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T14:46:18.296261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e694626d-63fe-40f9-8288-d524a639f214 | 2026-08-28 13:58 | 2026-08-28 13:58 | 2026-08-28 13:58 | AXP | AXP281215P00270000 | put | 270.0000 | 2028-12-15 | 22.8500 | 22.8500 | 23.2000 | 333.0950 | 61696.00 | 0.00 | 61696.00 | 27 | 11 | 63 | 128 | 0.4921875 | 0.318539630603059 | 0.318539630603059 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T18:18:32.282709Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ebc78632-4f3b-4190-a891-2618c54d087e | 2026-08-26 12:28 | 2026-08-26 12:28 | 2026-08-26 12:28 | AXP | AXP260918C00350000 | call | 350.0000 | 2026-09-18 | 3.0300 | 3.0000 | 3.1500 | 335.2200 | 58998.00 | 0.00 | 58998.00 | 195 | 10 | 212 | 854 | 0.24824355971897 | 0.238093171633106 | 0.238804977608262 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T16:52:20.196728Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6cd0ffa7-5d4e-4fea-ae94-304c016307fb | 2026-08-25 10:19 | 2026-08-25 10:19 | 2026-08-25 10:19 | AXP | AXP260828C00320000 | call | 320.0000 | 2026-08-28 | 17.9800 | 16.4000 | 18.0000 | 337.1700 | 84490.00 | 82695.00 | 1795.00 | 47 | 16 | 89 | 4 | 22.25 | 0.469718111751 | 0.469718111751 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | 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 |
| 7dc5644a-894e-4203-875d-3e069ef3eb8c | 2026-08-25 10:07 | 2026-08-25 10:07 | 2026-08-25 10:07 | AXP | AXP260904C00325000 | call | 325.0000 | 2026-09-04 | 13.7000 | 12.6000 | 13.7000 | 336.2100 | 60274.00 | 60274.00 | 0.00 | 44 | 10 | 45 | 3 | 15 | 0.289581650957992 | 0.286582753863141 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | 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 |
| cd57a9da-4cac-4ed4-a260-52bd04614db4 | 2026-08-25 10:01 | 2026-08-25 10:01 | 2026-08-25 10:01 | AXP | AXP260918C00342500 | call | 342.5000 | 2026-09-18 | 6.1000 | 5.6000 | 6.1000 | 336.2100 | 59753.00 | 56728.00 | 3025.00 | 98 | 26 | 101 | 2 | 50.5 | 0.246496136798978 | 0.2450057565426 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | 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 |
| 0bb51543-7f90-49b1-afa0-a408ad28cb90 | 2026-08-25 09:58 | 2026-08-25 09:58 | 2026-08-25 09:58 | AXP | AXP260828P00345000 | put | 345.0000 | 2026-08-28 | 10.4500 | 9.4000 | 10.4500 | 335.6600 | 71048.00 | 71048.00 | 0.00 | 68 | 11 | 86 | 31 | 2.7741935483871 | 0.354799610278175 | 0.343057693584743 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | 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 |
| ceb34299-ce35-4716-a9f2-0ac3ed7e5673 | 2026-08-25 09:45 | 2026-08-25 09:45 | 2026-08-25 09:45 | AXP | AXP260828C00322500 | call | 322.5000 | 2026-08-28 | 14.4400 | 12.1000 | 14.8000 | 336.1900 | 51985.00 | 37570.00 | 12975.00 | 36 | 12 | 37 | 0 | 0 | 0.404289133256748 | 0.350772792404561 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:56:08.271417Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a8243631-88e4-4e71-9dbd-abbadd53bedf | 2026-08-25 09:39 | 2026-08-25 09:39 | 2026-08-25 09:39 | AXP | AXP260828C00320000 | call | 320.0000 | 2026-08-28 | 16.7000 | 14.0500 | 16.7000 | 335.7700 | 53430.00 | 50100.00 | 3330.00 | 32 | 10 | 32 | 4 | 8 | 0.460038727158487 | 0.460038727158487 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T13:41:46.514863Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6844c02d-b386-45e2-9a74-68e7b1d3c332 | 2026-08-24 14:19 | 2026-08-24 14:18 | 2026-08-24 14:18 | AXP | AXP260918C00330000 | call | 330.0000 | 2026-09-18 | 13.9500 | 13.6500 | 13.9500 | 338.0300 | 412901.00 | 411511.00 | 1390.00 | 296 | 45 | 297 | 475 | 0.625263157894737 | 0.25276394420784 | 0.25276394420784 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T18:20:03.734818Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 903cb0d2-13ef-46c6-8cbf-81c87735a845 | 2026-08-24 10:12 | 2026-08-24 10:12 | 2026-08-24 10:12 | AXP | AXP270115C00380000 | call | 380.0000 | 2027-01-15 | 11.1800 | 10.4500 | 11.2500 | 343.3700 | 89411.00 | 79416.00 | 9995.00 | 80 | 14 | 80 | 868 | 0.0921658986175115 | 0.261169580517311 | 0.260785246877733 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:21:20.397116Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 225c7f56-36bf-4fb3-ad30-cc6c7f577859 | 2026-08-21 10:03 | 2026-08-21 10:03 | 2026-08-21 10:03 | AXP | AXP270617C00340000 | call | 340.0000 | 2027-06-17 | 38.0000 | 35.1500 | 38.4000 | 336.8400 | 239380.00 | 209000.00 | 18980.00 | 63 | 7 | 68 | 76 | 0.894736842105263 | 0.282745354161118 | 0.282745354161118 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T14:12:36.432845Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ff1447b3-83bd-459f-9bb4-3bedea12428c | 2026-08-20 15:59 | 2026-08-20 15:59 | 2026-08-20 15:59 | AXP | AXP261120P00370000 | put | 370.0000 | 2026-11-20 | 42.0700 | 39.8500 | 42.1000 | 331.7200 | 117810.00 | 101020.00 | 16790.00 | 28 | 15 | 28 | 219 | 0.127853881278539 | 0.289679294625777 | 0.287597250317848 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T13:35:10.222979Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a64b3b8d-201e-4849-8c67-0de3da4a0b4f | 2026-08-20 13:37 | 2026-08-20 13:37 | 2026-08-20 13:37 | AXP | AXP281215C00390000 | call | 390.0000 | 2028-12-15 | 49.5000 | 48.7500 | 50.2500 | 334.0950 | 1118730.00 | 405995.00 | 712735.00 | 226 | 33 | 426 | 244 | 1.74590163934426 | 0.284310715417245 | 0.284080893711508 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:47:44.203247Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 406e1e77-1b19-4798-85a4-74cd146c4891 | 2026-08-20 13:12 | 2026-08-20 13:12 | 2026-08-20 13:12 | AXP | AXP281215C00400000 | call | 400.0000 | 2028-12-15 | 46.0000 | 44.5000 | 46.0000 | 333.8100 | 919947.00 | 919947.00 | 0.00 | 200 | 25 | 200 | 535 | 0.373831775700935 | 0.282920725261259 | 0.282771185470731 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |