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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4bcdbff7-88f2-4738-8769-b676922d8e42 | 2026-09-18 15:21 | 2026-09-18 15:21 | 2026-09-18 15:21 | AXP | AXP281215C00350000 | call | 350.0000 | 2028-12-15 | 49.7500 | 48.9000 | 49.8000 | 312.5500 | 54720.00 | 14920.00 | 9950.00 | 11 | 6 | 22 | 68 | 0.323529411764706 | 0.273841153847377 | 0.274113460966454 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-18T19:37:13.545792Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| a4f40b33-eff7-41e8-9acc-20bc5bf50093 | 2026-09-17 11:16 | 2026-09-17 11:15 | 2026-09-17 11:15 | AXP | AXP281215C00400000 | call | 400.0000 | 2028-12-15 | 34.1800 | 34.1500 | 35.7000 | 314.0100 | 2854320.00 | 116760.00 | 2696460.00 | 835 | 75 | 835 | 1317 | 0.634016704631739 | 0.269673928822483 | 0.27316629781489 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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 |
| 440c82ee-2528-4a75-a903-429cebbc9e31 | 2026-09-16 12:58 | 2026-09-16 12:58 | 2026-09-16 12:58 | AXP | AXP270917C00270000 | call | 270.0000 | 2027-09-17 | 69.8100 | 67.9500 | 72.0000 | 316.4350 | 69810.00 | 0.00 | 69810.00 | 10 | 5 | 10 | 4 | 2.5 | 0.282667533373866 | 0.282667533373866 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 210987051124.00 | 2026-10-23 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T17:08:32.093964Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 9949d304-f170-4c84-85ff-796529a9e833 | 2026-09-14 11:05 | 2026-09-14 11:05 | 2026-09-14 11:05 | AXP | AXP261002P00332500 | put | 332.5000 | 2026-10-02 | 10.7100 | 10.1500 | 11.8000 | 325.4250 | 87850.00 | 44390.00 | 43460.00 | 82 | 7 | 82 | 0 | 0 | 0.237495245631189 | 0.244841831712191 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-14T15:20:09.779343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e0bd215b-c1c7-444e-88ff-7fa8f8a7d25a | 2026-09-11 13:16 | 2026-09-11 13:16 | 2026-09-11 13:16 | AXP | AXP270617P00320000 | put | 320.0000 | 2027-06-17 | 25.5100 | 25.0000 | 25.5500 | 325.0400 | 206643.00 | 201543.00 | 5100.00 | 81 | 32 | 152 | 151 | 1.00662251655629 | 0.294092265045789 | 0.294555430762307 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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 |
| cafcb0ed-5e8c-49a7-9105-bfd6b01e1116 | 2026-09-03 13:14 | 2026-09-03 13:13 | 2026-09-03 13:13 | AXP | AXP261023P00340000 | put | 340.0000 | 2026-10-23 | 17.5200 | 17.3000 | 19.5500 | 330.1900 | 224205.00 | 112205.00 | 112000.00 | 128 | 24 | 128 | 0 | 0 | 0.265833503970406 | 0.263742881094524 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-03T17:30:37.600118Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 736cfd1b-cb1e-48e3-8c5c-9898efaac05c | 2026-09-02 10:59 | 2026-09-02 10:59 | 2026-09-02 10:59 | AXP | AXP280121C00340000 | call | 340.0000 | 2028-01-21 | 48.7400 | 46.5500 | 48.8000 | 332.4550 | 292455.00 | 126710.00 | 165745.00 | 60 | 6 | 96 | 213 | 0.450704225352113 | 0.276273098931933 | 0.276606154602119 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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 |
| 88817617-3e8e-4ab8-8910-543bc825da34 | 2026-09-02 10:52 | 2026-09-02 10:51 | 2026-09-02 10:51 | AXP | AXP260918C00340000 | call | 340.0000 | 2026-09-18 | 3.3000 | 3.3000 | 3.7500 | 332.2100 | 93065.00 | 0.00 | 93065.00 | 282 | 50 | 2180 | 1344 | 1.62202380952381 | 0.221996829925162 | 0.223113748886111 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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 |
| c6270a77-a48d-4111-ad3d-8cdde67f128c | 2026-09-02 10:36 | 2026-09-02 10:35 | 2026-09-02 10:35 | AXP | AXP270617P00360000 | put | 360.0000 | 2027-06-17 | 43.9800 | 43.9000 | 44.4500 | 331.4850 | 404605.00 | 202440.00 | 202165.00 | 92 | 5 | 100 | 63 | 1.58730158730159 | 0.290078247692541 | 0.290931223691315 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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 |
| a20185db-48fa-4a99-8d14-b526e7449a54 | 2026-08-31 13:09 | 2026-08-31 13:09 | 2026-08-31 13:09 | AXP | AXP271217C00330000 | call | 330.0000 | 2027-12-17 | 50.6500 | 50.3000 | 52.3000 | 330.5900 | 177290.00 | 5075.00 | 172215.00 | 35 | 24 | 35 | 84 | 0.416666666666667 | 0.290461405463935 | 0.291160655854674 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-31T17:45:10.653528Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ea837c20-7562-430b-81fa-07c96e454d2e | 2026-08-26 11:33 | 2026-08-26 11:33 | 2026-08-26 11:33 | AXP | AXP270917C00360000 | call | 360.0000 | 2027-09-17 | 33.7700 | 33.7500 | 35.1500 | 334.9600 | 81057.00 | 0.00 | 81057.00 | 24 | 11 | 24 | 0 | 0 | 0.275396182460343 | 0.275396182460343 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-26T15:48:55.759300Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b7d4104b-f607-4d1a-9306-17b17922e31e | 2026-08-26 10:51 | 2026-08-26 10:51 | 2026-08-26 10:51 | AXP | AXP261016C00330000 | call | 330.0000 | 2026-10-16 | 15.7000 | 15.4500 | 16.1500 | 335.2550 | 409774.00 | 7850.00 | 398784.00 | 261 | 57 | 261 | 301 | 0.867109634551495 | 0.237338737871891 | 0.240490659105736 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-26T15:02:19.815281Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f43cbeb9-f8a3-43ed-9249-250f9eb73541 | 2026-08-25 10:42 | 2026-08-25 10:42 | 2026-08-25 10:42 | AXP | AXP260918C00320000 | call | 320.0000 | 2026-09-18 | 19.9000 | 19.9000 | 21.3500 | 336.8500 | 71655.00 | 2000.00 | 69655.00 | 36 | 9 | 85 | 538 | 0.157992565055762 | 0.245648542769846 | 0.249917738898586 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-25T15:00:40.665909Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2e5919bc-afb6-4ec6-a0c7-8f9c26f78c38 | 2026-08-25 10:28 | 2026-08-25 10:27 | 2026-08-25 10:27 | AXP | AXP260918P00355000 | put | 355.0000 | 2026-09-18 | 18.9000 | 18.9000 | 20.0000 | 337.8700 | 51040.00 | 3790.00 | 47250.00 | 27 | 8 | 100 | 0 | 0 | 0.237151007832532 | 0.23905139456934 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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 |
| a29859dc-24ad-48e8-872e-4c936465c8a8 | 2026-08-25 09:50 | 2026-08-25 09:50 | 2026-08-25 09:50 | AXP | AXP260904C00317500 | call | 317.5000 | 2026-09-04 | 18.2000 | 18.2000 | 20.4000 | 334.7300 | 67350.00 | 1825.00 | 65525.00 | 37 | 9 | 55 | 0 | 0 | 0.253175699430495 | 0.253175699430495 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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 |
| 3588f2aa-e509-4a58-a75e-faa10d125156 | 2026-08-25 09:49 | 2026-08-25 09:49 | 2026-08-25 09:49 | AXP | AXP261016P00360000 | put | 360.0000 | 2026-10-16 | 27.6700 | 27.6500 | 28.9000 | 334.7100 | 74705.00 | 0.00 | 74705.00 | 27 | 15 | 46 | 168 | 0.273809523809524 | 0.243838935513941 | 0.243838935513941 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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 |
| f9763674-195f-46ea-a3dc-089ad18e4398 | 2026-08-25 09:47 | 2026-08-25 09:47 | 2026-08-25 09:47 | AXP | AXP260918P00357500 | put | 357.5000 | 2026-09-18 | 23.1000 | 22.5500 | 24.7000 | 335.3099 | 85480.00 | 4630.00 | 80850.00 | 37 | 8 | 61 | 0 | 0 | 0.233643791271709 | 0.243692950553551 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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 |
| f1a782b4-7821-4860-9bfc-067c191b22d0 | 2026-08-25 09:37 | 2026-08-25 09:37 | 2026-08-25 09:37 | AXP | AXP260918P00357500 | put | 357.5000 | 2026-09-18 | 23.0600 | 22.9500 | 25.2500 | 335.1700 | 55340.00 | 2320.00 | 50710.00 | 24 | 8 | 24 | 0 | 0 | 0.233467729289302 | 0.240607786468636 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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 |
| a6e3d1be-a642-4ca0-8fa3-67265c82df24 | 2026-08-24 11:23 | 2026-08-24 11:23 | 2026-08-24 11:23 | AXP | AXP261016P00340000 | put | 340.0000 | 2026-10-16 | 11.6000 | 11.3500 | 11.9500 | 341.3650 | 1024383.00 | 4660.00 | 1018563.00 | 883 | 72 | 893 | 321 | 2.78193146417446 | 0.253289108997553 | 0.254797956898221 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-24T15:29:12.492303Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 94f1015d-2ce9-49c0-a146-2e274a46bbc1 | 2026-08-24 09:49 | 2026-08-24 09:49 | 2026-08-24 09:49 | AXP | AXP270617C00380000 | call | 380.0000 | 2027-06-17 | 23.7300 | 22.8000 | 24.0000 | 342.3150 | 104414.00 | 75974.00 | 21330.00 | 44 | 5 | 55 | 438 | 0.125570776255708 | 0.27438023262148 | 0.27438023262148 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-24T13:57:36.320523Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 55390029-4936-49fd-b32c-9fe28cf2c1f1 | 2026-08-19 10:52 | 2026-08-19 10:52 | 2026-08-19 10:52 | AXP | AXP270219P00330000 | put | 330.0000 | 2027-02-19 | 18.0100 | 18.0000 | 19.4500 | 343.5700 | 64835.00 | 3625.00 | 61210.00 | 36 | 19 | 36 | 31 | 1.16129032258065 | 0.285108395101134 | 0.286221224748561 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 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-19T15:01:13.058297Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d06a5e8d-59cb-4bd0-bbbc-caea32b0a883 | 2026-08-17 13:56 | 2026-08-17 13:56 | 2026-08-17 13:56 | AXP | AXP261218P00330000 | put | 330.0000 | 2026-12-18 | 15.0000 | 15.0000 | 15.4000 | 338.0000 | 58507.00 | 1505.00 | 57002.00 | 39 | 24 | 44 | 714 | 0.061624649859944 | 0.270933386193156 | 0.271605792594729 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Financial Services | 221353057061.00 | 2026-10-23 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T18:13:23.978459Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |