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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d2f70c29-91a0-4be2-a29f-1c34e8069f0c | 2026-08-17 12:22 | 2026-08-17 12:22 | 2026-08-17 12:22 | AA | AA261016C00055000 | call | 55.0000 | 2026-10-16 | 2.9000 | 2.8300 | 2.9100 | 51.3900 | 43241.00 | 42661.00 | 0.00 | 149 | 25 | 231 | 2329 | 0.0991841992271361 | 0.506980709433882 | 0.508207218725546 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T16:27:21.112559Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c8f4f2df-2888-4e7a-8e3d-9fbf41ffef52 | 2026-08-19 13:43 | 2026-08-19 13:43 | 2026-08-19 13:43 | AA | AA260911P00051000 | put | 51.0000 | 2026-09-11 | 2.6600 | 2.6600 | 2.6700 | 50.1950 | 84601.00 | 3471.00 | 81130.00 | 318 | 31 | 320 | 2 | 160 | 0.455111507182682 | 0.455111507182682 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5a331ab8-3d62-4c8d-ba66-2a58b71b4ed8 | 2026-08-19 13:43 | 2026-08-19 13:43 | 2026-08-19 13:43 | AA | AA260911P00053000 | put | 53.0000 | 2026-09-11 | 3.9200 | 3.7000 | 3.9500 | 50.1950 | 83481.00 | 34670.00 | 48811.00 | 213 | 16 | 213 | 1024 | 0.2080078125 | 0.449582547575309 | 0.449582547575309 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T17:43:33.841762Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3c053985-1e5a-4f26-b119-8e5a1f60d9e1 | 2026-08-21 15:56 | 2026-08-21 15:56 | 2026-08-21 15:56 | AA | AA260918C00055000 | call | 55.0000 | 2026-09-18 | 1.7300 | 1.6800 | 1.7700 | 52.0000 | 22715.00 | 2800.00 | 6075.00 | 131 | 7 | 2381 | 13012 | 0.182984936981248 | 0.496180206507017 | 0.499385159978363 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T13:30:37.604261Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ae7d9925-992c-45e3-805b-02c7b1e4f405 | 2026-08-24 12:12 | 2026-08-24 12:12 | 2026-08-24 12:12 | AA | AA260828C00051000 | call | 51.0000 | 2026-08-28 | 0.7700 | 0.7300 | 0.7800 | 49.8600 | 58612.00 | 57637.00 | 975.00 | 762 | 20 | 947 | 232 | 4.08189655172414 | 0.589506962367448 | 0.583886935521345 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T16:14:40.561585Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 61f11e94-163b-4f7a-8d1f-6f59e97374f8 | 2026-08-31 12:01 | 2026-08-31 12:01 | 2026-08-31 12:01 | AA | AA260911C00050000 | call | 50.0000 | 2026-09-11 | 1.5700 | 1.5500 | 1.6500 | 49.8500 | 39164.00 | 0.00 | 39164.00 | 250 | 5 | 1264 | 113 | 11.1858407079646 | 0.46200594614825 | 0.467799825071005 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:06:41.823379Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 59c285ef-260e-4e75-bc28-2e7bab2296d2 | 2026-09-02 14:51 | 2026-09-02 14:51 | 2026-09-02 14:51 | AA | AA270416P00035000 | put | 35.0000 | 2027-04-16 | 1.6600 | 1.4200 | 1.9600 | 51.1050 | 18131.00 | 3987.00 | 14144.00 | 109 | 7 | 109 | 16 | 6.8125 | 0.546568928788272 | 0.550203884041863 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-02T19:08:56.003529Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f3f6fd4f-a30e-4324-8955-04870e9e153c | 2026-09-04 15:44 | 2026-09-04 15:43 | 2026-09-04 15:43 | AA | AA260911C00052000 | call | 52.0000 | 2026-09-11 | 0.4700 | 0.4600 | 0.5700 | 50.0300 | 23586.00 | 0.00 | 23586.00 | 497 | 25 | 692 | 294 | 2.35374149659864 | 0.422250121816659 | 0.428967871789358 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | 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 |
| c1f0e2ba-cf1a-466f-af91-0e1043c314cf | 2026-09-08 15:56 | 2026-09-08 15:56 | 2026-09-08 15:56 | AA | AA260918C00056000 | call | 56.0000 | 2026-09-18 | 0.5100 | 0.3300 | 0.6400 | 51.8390 | 16282.00 | 9310.00 | 6648.00 | 318 | 20 | 378 | 106 | 3.56603773584906 | 0.533117899781429 | 0.533117899781429 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T13:30:57.501605Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c318ea33-9de9-49a5-9b03-a3244ea98af2 | 2026-09-14 12:06 | 2026-09-14 12:06 | 2026-09-14 12:06 | AA | AA270617C00060000 | call | 60.0000 | 2027-06-17 | 5.0600 | 4.9000 | 5.5000 | 47.3900 | 51120.00 | 43040.00 | 8080.00 | 101 | 15 | 110 | 274 | 0.401459854014599 | 0.52289734312381 | 0.519265444738578 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12390548443.00 | 2026-10-28 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T16:23:59.234542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 168baa26-e9d2-4fd5-9b00-d37d54e2e612 | 2026-09-17 13:45 | 2026-09-17 13:45 | 2026-09-17 13:45 | AA | AA270115C00050000 | call | 50.0000 | 2027-01-15 | 4.4000 | 4.4000 | 4.6000 | 47.0300 | 59413.00 | 0.00 | 59413.00 | 135 | 27 | 167 | 1652 | 0.101089588377724 | 0.497626955774702 | 0.497626955774702 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Basic Materials | 12395826632.00 | 2026-10-15 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:13:15.605683Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |