Simplify AnalyticsOptions 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.
281,039 rowsexport restricted — no row in this table may be redistributed
Sources in this table
uw_flow_alerts281,039 rowsrestricted — hover for the licence
active:ticker = SYY×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b3ff9bb5-ed9b-4b1c-8a14-1494fd765adf | 2026-09-18 15:36 | 2026-09-18 15:36 | 2026-09-18 15:36 | SYY | SYY260918P00082500 | put | 82.5000 | 2026-09-18 | 2.7500 | 2.7500 | 3.2000 | 79.6600 | 55275.00 | 0.00 | 55275.00 | 201 | 18 | 242 | 867 | 0.279123414071511 | 6.05958584058283 | 6.05958584058283 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 37872540065.00 | 2026-10-27 | unknown | — | 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 |
| 0a0e6d57-1cb0-40a8-b512-9bfe7e93611a | 2026-09-16 11:29 | 2026-09-16 11:29 | 2026-09-16 11:29 | SYY | SYY261016P00077500 | put | 77.5000 | 2026-10-16 | 1.4500 | 1.4500 | 1.6000 | 78.8100 | 10877.00 | 0.00 | 10877.00 | 75 | 24 | 80 | 65 | 1.23076923076923 | 0.239856351169802 | 0.239856351169802 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 37709647419.00 | 2026-10-27 | unknown | — | 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 |
| 61c98686-ec26-400d-bb68-76dfe8f507c0 | 2026-09-15 15:59 | 2026-09-15 15:59 | 2026-09-15 15:59 | SYY | SYY260918P00082500 | put | 82.5000 | 2026-09-18 | 2.9500 | 2.8500 | 3.4000 | 79.0000 | 17700.00 | 0.00 | 17700.00 | 60 | 6 | 540 | 1954 | 0.276356192425793 | 0.272133952860546 | 0.272133952860546 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| d433f418-43a6-44fd-adc8-7707519c0d04 | 2026-09-15 15:52 | 2026-09-15 15:52 | 2026-09-15 15:52 | SYY | SYY260918P00082500 | put | 82.5000 | 2026-09-18 | 2.9000 | 2.5000 | 3.4000 | 79.0000 | 14500.00 | 2900.00 | 11600.00 | 50 | 5 | 200 | 1954 | 0.102354145342886 | 0.299279697174911 | 0.276935286286364 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 9ff66478-c107-40e1-b123-ee27d4632d7d | 2026-09-15 15:41 | 2026-09-15 15:41 | 2026-09-15 15:41 | SYY | SYY260918P00085000 | put | 85.0000 | 2026-09-18 | 5.5000 | 5.5000 | 6.1000 | 79.4700 | 17604.00 | 0.00 | 17604.00 | 32 | 7 | 281 | 538 | 0.522304832713755 | 0.314900412896584 | 0.314900412896584 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:44:55.237483Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| cbcc9fdb-a7ea-438b-9893-aed42e74f934 | 2026-09-15 14:45 | 2026-09-15 14:45 | 2026-09-15 14:45 | SYY | SYY260918C00080000 | call | 80.0000 | 2026-09-18 | 0.7500 | 0.7000 | 0.7500 | 79.6300 | 10725.00 | 10725.00 | 0.00 | 143 | 19 | 220 | 564 | 0.390070921985816 | 0.315896817956107 | 0.315896817956107 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:59:21.919987Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| be39f7de-d3b7-4920-be1d-cf314ac0ba82 | 2026-09-15 10:18 | 2026-09-15 10:17 | 2026-09-15 10:17 | SYY | SYY260918P00087500 | put | 87.5000 | 2026-09-18 | 6.8400 | 5.0000 | 7.0000 | 81.3850 | 21890.00 | 21890.00 | 0.00 | 32 | 22 | 32 | 0 | 0 | 0.900824936571716 | 0.900824936571716 | true | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:18:51.832385Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 69653c70-6fef-42fe-a5c0-d19396ed0df1 | 2026-09-14 15:35 | 2026-09-14 15:35 | 2026-09-14 15:35 | SYY | SYY260918P00082500 | put | 82.5000 | 2026-09-18 | 0.4000 | 0.3000 | 0.4000 | 83.7000 | 20000.00 | 20000.00 | 0.00 | 500 | 19 | 1502 | 611 | 2.4582651391162 | 0.256624797941107 | 0.254715349905735 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a734e948-3261-4506-80f5-7631013235e8 | 2026-09-14 15:32 | 2026-09-14 15:32 | 2026-09-14 15:32 | SYY | SYY260918P00085000 | put | 85.0000 | 2026-09-18 | 1.6000 | 0.4500 | 1.6000 | 83.6800 | 21120.00 | 21120.00 | 0.00 | 132 | 16 | 255 | 400 | 0.6375 | 0.227123705899541 | 0.227123705899541 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6b8f3f49-d282-4101-9ccb-9f72dfc28699 | 2026-09-14 15:22 | 2026-09-14 15:22 | 2026-09-14 15:22 | SYY | SYY260918P00085000 | put | 85.0000 | 2026-09-18 | 1.4500 | 1.3500 | 1.6000 | 83.8750 | 13630.00 | 11455.00 | 2175.00 | 94 | 15 | 99 | 400 | 0.2475 | 0.223880870359965 | 0.223880870359965 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T19:44:36.941159Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8f14620f-38a1-427c-9786-ccb512f6b25b | 2026-09-14 14:04 | 2026-09-14 14:04 | 2026-09-14 14:04 | SYY | SYY280121C00095000 | call | 95.0000 | 2028-01-21 | 5.7000 | 4.2000 | 5.8000 | 84.2400 | 61550.00 | 60980.00 | 0.00 | 108 | 25 | 108 | 560 | 0.192857142857143 | 0.209185494063821 | 0.209185494063821 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T18:18:53.599003Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| de6314aa-0310-49fd-8692-5dcce20c7f9d | 2026-09-09 10:19 | 2026-09-09 10:19 | 2026-09-09 10:19 | SYY | SYY270115P00082500 | put | 82.5000 | 2027-01-15 | 4.8000 | 4.7000 | 5.0000 | 81.7575 | 12960.00 | 9600.00 | 3360.00 | 27 | 7 | 27 | 134 | 0.201492537313433 | 0.259804050923313 | 0.259804050923313 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-09T14:24:00.331334Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6b8b68e3-66ad-4c87-8e9a-de7c06fd3802 | 2026-09-04 15:49 | 2026-09-04 15:49 | 2026-09-04 15:49 | SYY | SYY261218C00080000 | call | 80.0000 | 2026-12-18 | 4.1000 | 4.0000 | 4.8000 | 80.2440 | 11890.00 | 6970.00 | 4920.00 | 29 | 8 | 29 | 117 | 0.247863247863248 | 0.204904447003566 | 0.204904447003566 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T20:00:02.053596Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4c1097f4-da30-487b-a585-48842e11f94a | 2026-09-03 15:01 | 2026-09-03 15:00 | 2026-09-03 15:00 | SYY | SYY260918C00082500 | call | 82.5000 | 2026-09-18 | 0.8500 | 0.8500 | 0.9500 | 81.4200 | 10030.00 | 0.00 | 10030.00 | 118 | 29 | 131 | 3194 | 0.041014402003757 | 0.191600667743209 | 0.191600667743209 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T19:09:41.417490Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6275f89a-4d80-4b09-987a-5ac7a4828c23 | 2026-08-31 11:33 | 2026-08-31 11:33 | 2026-08-31 11:33 | SYY | SYY261120C00080000 | call | 80.0000 | 2026-11-20 | 4.5000 | 4.4000 | 4.7000 | 81.6100 | 13050.00 | 7650.00 | 5400.00 | 29 | 8 | 29 | 67 | 0.432835820895522 | 0.213084550554939 | 0.213084550554939 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T15:33:38.203445Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a9bd2f11-d5cb-44f4-ac13-5e7b3bbfa129 | 2026-08-28 11:49 | 2026-08-28 11:49 | 2026-08-28 11:49 | SYY | SYY270115C00082500 | call | 82.5000 | 2027-01-15 | 4.3000 | 4.1000 | 4.6000 | 81.0000 | 12470.00 | 8600.00 | 3870.00 | 29 | 7 | 29 | 211 | 0.137440758293839 | 0.205854748982912 | 0.205854748982912 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T15:52:06.240394Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b64bd6ab-7d1a-4fa9-a1ad-9c07588063ca | 2026-08-25 11:56 | 2026-08-25 11:56 | 2026-08-25 11:56 | SYY | SYY270115P00087500 | put | 87.5000 | 2027-01-15 | 6.8000 | 6.4000 | 6.9000 | 83.2800 | 19720.00 | 6800.00 | 12920.00 | 29 | 8 | 29 | 12 | 2.41666666666667 | 0.247911193366384 | 0.247911193366384 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T16:00:53.835343Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c97be1de-3594-4cd6-a517-22eb3378bf25 | 2026-08-25 11:32 | 2026-08-25 11:32 | 2026-08-25 11:32 | SYY | SYY261120C00082500 | call | 82.5000 | 2026-11-20 | 4.2000 | 4.1000 | 4.4000 | 83.1700 | 11340.00 | 6300.00 | 5040.00 | 27 | 7 | 27 | 202 | 0.133663366336634 | 0.214249307898204 | 0.214249307898204 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-25T15:37:01.391907Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 6b817f91-7d31-407e-9d01-b8ae120d70dd | 2026-08-21 15:39 | 2026-08-21 15:39 | 2026-08-21 15:39 | SYY | SYY260918C00082500 | call | 82.5000 | 2026-09-18 | 2.5500 | 2.5500 | 3.0000 | 83.7100 | 36985.00 | 0.00 | 36985.00 | 145 | 22 | 322 | 2648 | 0.121601208459215 | 0.188591764101727 | 0.188591764101727 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 20f9d068-b2c5-497b-8d68-4a422837ff00 | 2026-08-21 15:34 | 2026-08-21 15:34 | 2026-08-21 15:34 | SYY | SYY270115P00082500 | put | 82.5000 | 2027-01-15 | 4.0000 | 3.9000 | 4.1000 | 83.6400 | 10800.00 | 2800.00 | 8000.00 | 27 | 8 | 36 | 130 | 0.276923076923077 | 0.245887920948983 | 0.245984480572645 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 40023681177.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:48:47.460535Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |