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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 075c2acf-44ad-46ec-9f9c-c7bc73560ff7 | 2026-09-18 12:55 | 2026-09-18 12:55 | 2026-09-18 12:55 | AA | AA261218C00047000 | call | 47.0000 | 2026-12-18 | 3.7000 | 3.5000 | 3.7500 | 44.7799 | 39960.00 | 39960.00 | 0.00 | 108 | 5 | 109 | 568 | 0.191901408450704 | 0.497482850354132 | 0.497482850354132 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 11725496641.00 | 2026-10-15 | postmarket | — | 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 |
| fce62a37-a63d-4253-8c97-6c2b05b1cfe6 | 2026-09-18 11:24 | 2026-09-18 11:24 | 2026-09-18 11:24 | AA | AA270319P00040000 | put | 40.0000 | 2027-03-19 | 3.4000 | 3.3500 | 3.5000 | 45.1200 | 50660.00 | 15640.00 | 35020.00 | 149 | 34 | 318 | 742 | 0.428571428571429 | 0.50090418078113 | 0.500380187796372 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 11725496641.00 | 2026-10-15 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| fbc4bd63-9b63-4239-bc7f-aacda7631f00 | 2026-09-18 11:24 | 2026-09-18 11:24 | 2026-09-18 11:24 | AA | AA270319P00040000 | put | 40.0000 | 2027-03-19 | 3.4000 | 3.4000 | 3.5000 | 45.1200 | 12920.00 | 0.00 | 12920.00 | 38 | 10 | 63 | 742 | 0.0849056603773585 | 0.500642254796398 | 0.500380187796372 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 11725496641.00 | 2026-10-15 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| f97f5b0c-f457-494f-bbff-616c51b03919 | 2026-09-18 11:24 | 2026-09-18 11:24 | 2026-09-18 11:24 | AA | AA270319P00040000 | put | 40.0000 | 2027-03-19 | 3.4000 | 3.4000 | 3.5000 | 45.1000 | 13940.00 | 0.00 | 13940.00 | 41 | 9 | 104 | 742 | 0.140161725067385 | 0.500380187796372 | 0.499855629990374 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 11725496641.00 | 2026-10-15 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| ceeb8ce6-c270-4bd7-ac68-888f5266483f | 2026-09-18 11:24 | 2026-09-18 11:24 | 2026-09-18 11:24 | AA | AA270319P00040000 | put | 40.0000 | 2027-03-19 | 3.4000 | 3.3500 | 3.5000 | 45.1400 | 19040.00 | 0.00 | 19040.00 | 56 | 21 | 169 | 742 | 0.227762803234501 | 0.499855629990374 | 0.50090418078113 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 11725496641.00 | 2026-10-15 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 222b2d10-ef04-4df4-870f-c2295cd46074 | 2026-09-18 10:00 | 2026-09-18 10:00 | 2026-09-18 10:00 | AA | AA260925C00045500 | call | 45.5000 | 2026-09-25 | 1.7200 | 1.7200 | 1.9500 | 46.4400 | 13760.00 | 0.00 | 13760.00 | 80 | 20 | 80 | 3 | 26.6666666666667 | 0.460662162060279 | 0.460662162060279 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 11725496641.00 | 2026-10-15 | postmarket | — | 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 |
| 232b7c8f-3a15-4ca7-9be0-abb18177565b | 2026-09-17 15:16 | 2026-09-17 15:16 | 2026-09-17 15:16 | AA | AA270115C00050000 | call | 50.0000 | 2027-01-15 | 4.4000 | 4.4000 | 4.6500 | 47.1020 | 179520.00 | 0.00 | 179520.00 | 408 | 41 | 578 | 1652 | 0.349878934624697 | 0.494339556763436 | 0.494339556763436 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-17T19:28:01.580099Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| f2ae5ca7-8a72-4a0e-bdc9-8ac87bfe1f27 | 2026-09-17 13:47 | 2026-09-17 13:47 | 2026-09-17 13:47 | AA | AA280121C00060000 | call | 60.0000 | 2028-01-21 | 7.9000 | 7.6000 | 7.9000 | 47.0500 | 43450.00 | 43450.00 | 0.00 | 55 | 9 | 108 | 1791 | 0.0603015075376884 | 0.508759770341975 | 0.508759770341975 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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 |
| e751bafb-9ad7-4846-8fb0-d7b696823e74 | 2026-09-17 13:46 | 2026-09-17 13:46 | 2026-09-17 13:46 | AA | AA280121C00055000 | call | 55.0000 | 2028-01-21 | 9.2500 | 9.0500 | 9.2500 | 47.0400 | 16650.00 | 16650.00 | 0.00 | 18 | 5 | 43 | 482 | 0.0892116182572614 | 0.506469774558401 | 0.506469774558401 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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 |
| 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 |
| 3b66afbf-f2f3-4a24-9ef1-7c2c889fecc0 | 2026-09-17 13:26 | 2026-09-17 13:26 | 2026-09-17 13:26 | AA | AA280121C00045000 | call | 45.0000 | 2028-01-21 | 12.9000 | 12.5500 | 12.9000 | 47.1000 | 32250.00 | 32250.00 | 0.00 | 25 | 5 | 26 | 506 | 0.0513833992094862 | 0.504909728963949 | 0.504909728963949 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-17T17:42:16.071983Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 3f33c55e-e3c8-4d1d-9fa1-5232c3fdf724 | 2026-09-17 12:20 | 2026-09-17 12:19 | 2026-09-17 12:19 | AA | AA260925C00046000 | call | 46.0000 | 2026-09-25 | 1.9400 | 1.9400 | 2.0600 | 47.0800 | 12804.00 | 0.00 | 12804.00 | 66 | 16 | 72 | 34 | 2.11764705882353 | 0.474817549512543 | 0.474817549512543 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-17T16:22:15.429007Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| a77c084e-06bc-4794-ac3e-13d75639ce75 | 2026-09-17 12:10 | 2026-09-17 12:10 | 2026-09-17 12:10 | AA | AA280121P00038000 | put | 38.0000 | 2028-01-21 | 5.2000 | 5.1500 | 5.6000 | 47.0900 | 255840.00 | 34320.00 | 221520.00 | 492 | 31 | 8847 | 831 | 10.6462093862816 | 0.527766499582257 | 0.527766499582257 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-17T16:22:15.429007Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 63ce324c-7be0-4a5f-a292-c4dd7f4b9b1e | 2026-09-17 11:30 | 2026-09-17 11:30 | 2026-09-17 11:30 | AA | AA260918C00047000 | call | 47.0000 | 2026-09-18 | 0.6100 | 0.6100 | 0.7300 | 47.0100 | 17767.00 | 992.00 | 16775.00 | 291 | 31 | 304 | 611 | 0.497545008183306 | 0.613810399954209 | 0.613810399954209 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-17T15:37:51.418712Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| eaa32305-1ccb-435b-af60-7b952e8c61de | 2026-09-17 10:53 | 2026-09-17 10:53 | 2026-09-17 10:53 | AA | AA270617P00040000 | put | 40.0000 | 2027-06-17 | 4.1500 | 4.1500 | 4.3000 | 46.9950 | 51875.00 | 0.00 | 51875.00 | 125 | 21 | 126 | 2454 | 0.0513447432762836 | 0.519457796159261 | 0.519457796159261 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-17T15:02:25.509626Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| de0bb97e-20ef-4a65-8588-c7e014514fc1 | 2026-09-17 09:54 | 2026-09-17 09:54 | 2026-09-17 09:54 | AA | AA260925P00046000 | put | 46.0000 | 2026-09-25 | 0.7600 | 0.7600 | 0.9700 | 47.3700 | 16492.00 | 0.00 | 16492.00 | 217 | 28 | 224 | 68 | 3.29411764705882 | 0.489741147457984 | 0.489741147457984 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 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-17T13:57:31.198579Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| d5aac405-c0d0-41bc-9962-b242ebf572d0 | 2026-09-16 11:38 | 2026-09-16 11:38 | 2026-09-16 11:38 | AA | AA280121C00045000 | call | 45.0000 | 2028-01-21 | 13.3000 | 13.0000 | 13.3000 | 47.3700 | 22610.00 | 22610.00 | 0.00 | 17 | 6 | 17 | 502 | 0.0338645418326693 | 0.516244381719841 | 0.516244381719841 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 12208450926.00 | 2026-10-15 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |
| 3808a9b0-6243-43fb-969c-928249693a79 | 2026-09-16 11:00 | 2026-09-16 11:00 | 2026-09-16 11:00 | AA | AA260918P00050000 | put | 50.0000 | 2026-09-18 | 2.9000 | 2.8600 | 2.9000 | 47.2400 | 60030.00 | 60030.00 | 0.00 | 207 | 29 | 251 | 1528 | 0.164267015706806 | 0.667660114099596 | 0.667660114099596 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Basic Materials | 12208450926.00 | 2026-10-15 | postmarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"} | 2026-09-16 | 2026-09-16 21:15 | 2026-09-16 21:15 |