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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0f28ea11-9334-486a-b06c-1900a1a7888a | 2026-08-19 14:00 | 2026-08-19 14:00 | 2026-08-19 14:00 | WMT | WMT260911C00117000 | call | 117.0000 | 2026-09-11 | 2.9400 | 2.9400 | 3.1500 | 115.7000 | 293832.00 | 0.00 | 293832.00 | 1000 | 60 | 27680 | 99 | 279.59595959596 | 0.294504915630418 | 0.294504915630418 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T18:07:46.108768Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 57e2eabf-bc8a-40a4-81df-28c48e9ff7b5 | 2026-08-19 14:26 | 2026-08-19 14:26 | 2026-08-19 14:26 | WMT | WMT260821C00120000 | call | 120.0000 | 2026-08-21 | 1.1500 | 1.1400 | 1.1800 | 115.8100 | 115331.00 | 76590.00 | 37454.00 | 1000 | 40 | 7261 | 14669 | 0.494989433499216 | 0.794376976729068 | 0.788461660676668 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T18:37:13.611011Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 52557784-4964-463f-adc6-19bf18921ce2 | 2026-08-19 15:54 | 2026-08-19 15:53 | 2026-08-19 15:53 | WMT | WMT270917C00105000 | call | 105.0000 | 2027-09-17 | 19.9600 | 19.9500 | 20.6000 | 114.3999 | 283421.00 | 0.00 | 283421.00 | 142 | 10 | 157 | 20 | 7.85 | 0.262352108994155 | 0.26184185347314 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:30:24.310264Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a982148c-2086-4387-af6d-4af9cc440110 | 2026-08-20 09:32 | 2026-08-20 09:32 | 2026-08-20 09:32 | WMT | WMT260828P00115000 | put | 115.0000 | 2026-08-28 | 10.5700 | 9.6000 | 11.3500 | 104.6400 | 528416.00 | 528416.00 | 0.00 | 500 | 6 | 1068 | 5711 | 0.187007529329364 | 0.473642449069006 | 0.473642449069006 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e99ad1f6-7d6b-4b40-b55b-7df619075bfb | 2026-08-20 09:32 | 2026-08-20 09:32 | 2026-08-20 09:32 | WMT | WMT260828P00115000 | put | 115.0000 | 2026-08-28 | 10.6300 | 9.6000 | 11.3000 | 104.5200 | 531266.00 | 531266.00 | 0.00 | 500 | 5 | 1569 | 5711 | 0.274732971458589 | 0.485487275109039 | 0.485487275109039 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 71704dff-a4eb-4398-ac28-7b2baf1057bc | 2026-08-20 09:35 | 2026-08-20 09:35 | 2026-08-20 09:35 | WMT | WMT260821P00114000 | put | 114.0000 | 2026-08-21 | 8.6000 | 8.6000 | 9.3000 | 105.2850 | 146235.00 | 0.00 | 146235.00 | 170 | 11 | 454 | 2566 | 0.17692907248636 | 0.807342445762462 | 0.807342445762462 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:35:56.061771Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aaef91ef-a883-4a1b-94e1-d78a5d6fc60c | 2026-08-20 09:53 | 2026-08-20 09:53 | 2026-08-20 09:53 | WMT | WMT261120P00100000 | put | 100.0000 | 2026-11-20 | 3.3000 | 3.2500 | 3.3500 | 104.2600 | 145193.00 | 141893.00 | 3300.00 | 440 | 55 | 523 | 9784 | 0.053454619787408 | 0.271755544248156 | 0.271755544248156 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T13:54:26.267880Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d1040fae-2047-4efb-b7ff-886c964c57cd | 2026-08-20 10:10 | 2026-08-20 10:10 | 2026-08-20 10:10 | WMT | WMT270115C00105000 | call | 105.0000 | 2027-01-15 | 7.2500 | 7.1000 | 7.2500 | 104.3700 | 144901.00 | 144901.00 | 0.00 | 200 | 8 | 938 | 1797 | 0.521981079577073 | 0.255008122582735 | 0.255008122582735 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:18:56.683244Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 95ef4094-bc68-4fbf-be64-162152a9ef72 | 2026-08-25 09:39 | 2026-08-25 09:38 | 2026-08-25 09:38 | WMT | WMT260828C00105000 | call | 105.0000 | 2026-08-28 | 1.2100 | 1.1900 | 1.2600 | 105.1900 | 127504.00 | 41616.00 | 85888.00 | 1050 | 8 | 1243 | 6179 | 0.201165237093381 | 0.289361159915002 | 0.28550154280724 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | 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 |
| 9d99917d-247a-49d9-bc31-3b3de274bbe4 | 2026-08-26 11:17 | 2026-08-26 11:16 | 2026-08-26 11:16 | WMT | WMT261016C00105000 | call | 105.0000 | 2026-10-16 | 3.4000 | 3.3500 | 3.4500 | 104.1250 | 753369.00 | 753029.00 | 340.00 | 2216 | 75 | 2975 | 5376 | 0.553385416666667 | 0.230102742693952 | 0.228809321780008 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T15:22:15.766686Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| e79de27e-45b8-4300-a50e-20a95571e062 | 2026-08-26 11:22 | 2026-08-26 11:22 | 2026-08-26 11:22 | WMT | WMT261120C00105000 | call | 105.0000 | 2026-11-20 | 5.4500 | 5.4000 | 5.4500 | 104.2043 | 394564.00 | 394564.00 | 0.00 | 724 | 55 | 1203 | 3640 | 0.330494505494505 | 0.266611130144228 | 0.266611130144228 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | 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 |
| 519e594f-48fe-43e3-ae4c-faa993042944 | 2026-08-31 14:41 | 2026-08-31 14:41 | 2026-08-31 14:41 | WMT | WMT281215C00090000 | call | 90.0000 | 2028-12-15 | 29.3000 | 29.0500 | 29.4000 | 104.7350 | 588950.00 | 495190.00 | 0.00 | 201 | 6 | 243 | 452 | 0.537610619469027 | 0.269669669325175 | 0.269669669325175 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:01:22.528333Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| aad57f23-1242-4ed4-9c66-c02435a5bb84 | 2026-09-03 12:46 | 2026-09-03 12:45 | 2026-09-03 12:45 | WMT | WMT270319C00120000 | call | 120.0000 | 2027-03-19 | 5.2000 | 5.2000 | 5.3000 | 109.3300 | 203395.00 | 0.00 | 203395.00 | 391 | 36 | 689 | 3484 | 0.197761194029851 | 0.260788512126541 | 0.260591713075782 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | 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 |
| 0a1f1a8b-b71b-4842-8737-1c5d65258c96 | 2026-09-03 12:46 | 2026-09-03 12:45 | 2026-09-03 12:45 | WMT | WMT270319C00120000 | call | 120.0000 | 2027-03-19 | 5.2000 | 5.1500 | 5.3000 | 109.2905 | 340604.00 | 47840.00 | 292764.00 | 655 | 17 | 1389 | 3484 | 0.398679678530425 | 0.261366716997614 | 0.260445159834009 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | — | 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 |
| 5b456e6e-4539-4e34-af34-eef693197851 | 2026-09-15 10:59 | 2026-09-15 10:59 | 2026-09-15 10:59 | WMT | WMT270617C00115000 | call | 115.0000 | 2027-06-17 | 9.2500 | 9.1000 | 9.3500 | 108.0000 | 138698.00 | 122048.00 | 16650.00 | 150 | 6 | 155 | 2248 | 0.0689501779359431 | 0.273250763356991 | 0.272985492880006 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 865413039968.00 | 2026-11-19 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T15:09:54.469160Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |