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.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cf9e9af2-3c00-4636-8509-83f526adbdf8 | 2026-09-11 13:41 | 2026-09-11 13:41 | 2026-09-11 13:41 | TGT | TGT261016P00150000 | put | 150.0000 | 2026-10-16 | 2.7300 | 2.6100 | 2.7300 | 156.9801 | 87906.00 | 87906.00 | 0.00 | 322 | 53 | 366 | 1331 | 0.274981217129977 | 0.30309934431155 | 0.30309934431155 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 72096892003.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f9087d3b-9e0e-4d45-8707-1746ff3f649f | 2026-09-11 14:25 | 2026-09-11 14:25 | 2026-09-11 14:25 | TGT | TGT270115C00155000 | call | 155.0000 | 2027-01-15 | 13.5000 | 13.5000 | 13.6500 | 156.4600 | 55350.00 | 0.00 | 55350.00 | 41 | 13 | 48 | 2173 | 0.0220892774965485 | 0.320464569561542 | 0.320464569561542 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 72096892003.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T18:33:12.425630Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 163c9997-9873-4a74-a7e1-4ec1dc9f161a | 2026-09-11 15:06 | 2026-09-11 15:05 | 2026-09-11 15:05 | TGT | TGT261218P00140000 | put | 140.0000 | 2026-12-18 | 4.5000 | 4.4000 | 4.5000 | 155.8201 | 54000.00 | 54000.00 | 0.00 | 120 | 25 | 213 | 986 | 0.216024340770791 | 0.365337850391728 | 0.365337850391728 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 72096892003.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 047275a8-02c3-4ab1-8a43-6add484adb6f | 2026-09-14 09:35 | 2026-09-14 09:35 | 2026-09-14 09:35 | TGT | TGT260918P00157500 | put | 157.5000 | 2026-09-18 | 2.0300 | 2.0300 | 3.4500 | 158.5400 | 84245.00 | 0.00 | 84245.00 | 415 | 8 | 416 | 831 | 0.500601684717208 | 0.385847703148883 | 0.385847703148883 | true | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 72096892003.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| fdd4e97f-c929-48e1-97ee-4ab504478073 | 2026-09-14 13:11 | 2026-09-14 13:11 | 2026-09-14 13:11 | TGT | TGT270617P00160000 | put | 160.0000 | 2027-06-17 | 18.5500 | 18.5000 | 18.8000 | 159.5400 | 90912.00 | 24115.00 | 66797.00 | 49 | 8 | 97 | 258 | 0.375968992248062 | 0.374128923813105 | 0.374314702037122 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 72096892003.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T17:17:14.116635Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 3667b898-0efb-43e9-a107-2c98a326fd1b | 2026-09-15 09:54 | 2026-09-15 09:54 | 2026-09-15 09:54 | TGT | TGT260918C00160000 | call | 160.0000 | 2026-09-18 | 0.9900 | 0.8700 | 0.9900 | 157.0700 | 96717.00 | 87407.00 | 9310.00 | 978 | 22 | 1366 | 2434 | 0.561216105176664 | 0.361018521649828 | 0.368915777584958 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Defensive | 72096892003.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T14:04:43.913092Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| f0eaee47-c4d0-411f-88f2-285a43eb00aa | 2026-09-15 13:47 | 2026-09-15 13:46 | 2026-09-15 13:46 | TGT | TGT260918C00155000 | call | 155.0000 | 2026-09-18 | 2.2800 | 2.0700 | 2.2800 | 155.4500 | 73188.00 | 73188.00 | 0.00 | 321 | 7 | 768 | 3594 | 0.213689482470785 | 0.376261762744008 | 0.359888515749102 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 72096892003.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T18:17:02.638750Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 18398f89-9350-4b51-9dcb-82439a90e8dc | 2026-09-15 15:00 | 2026-09-15 15:00 | 2026-09-15 15:00 | TGT | TGT261218P00145000 | put | 145.0000 | 2026-12-18 | 6.0000 | 6.0000 | 6.1500 | 155.8350 | 54606.00 | 0.00 | 54606.00 | 91 | 20 | 189 | 350 | 0.54 | 0.367550459156101 | 0.367550459156101 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 72096892003.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T19:24:32.787559Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 68864325-9746-4667-96d1-a0e7d3c59a05 | 2026-09-15 15:38 | 2026-09-15 15:37 | 2026-09-15 15:37 | TGT | TGT261016P00155000 | put | 155.0000 | 2026-10-16 | 5.5000 | 5.2500 | 5.5000 | 154.7500 | 99000.00 | 99000.00 | 0.00 | 180 | 6 | 497 | 2854 | 0.174141555711282 | 0.313908480412929 | 0.313908480412929 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 72096892003.00 | 2026-11-18 | 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 |
| fdfd75cd-999f-42f6-b4be-1adb8e2cb1d7 | 2026-09-16 11:04 | 2026-09-16 11:04 | 2026-09-16 11:04 | TGT | TGT261218C00150000 | call | 150.0000 | 2026-12-18 | 13.3000 | 13.1500 | 13.7000 | 154.1900 | 54530.00 | 26600.00 | 27930.00 | 41 | 8 | 41 | 1239 | 0.033091202582728 | 0.333489296351797 | 0.333489296351797 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70270619124.00 | 2026-11-18 | unknown | — | 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 |
| 5a2039aa-1420-4403-ad5f-10405c9f8408 | 2026-09-16 11:30 | 2026-09-16 11:30 | 2026-09-16 11:30 | TGT | TGT280121C00140000 | call | 140.0000 | 2028-01-21 | 33.9500 | 33.1500 | 34.3750 | 154.1300 | 67900.00 | 67900.00 | 0.00 | 20 | 5 | 20 | 309 | 0.0647249190938511 | 0.314870011998928 | 0.314870011998928 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 70270619124.00 | 2026-11-18 | 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 |
| ea3b08a6-1e25-4cca-859c-48baca02264d | 2026-09-17 14:48 | 2026-09-17 14:48 | 2026-09-17 14:48 | TGT | TGT261218C00160000 | call | 160.0000 | 2026-12-18 | 11.0500 | 10.9000 | 11.3000 | 159.3200 | 86190.00 | 47515.00 | 38675.00 | 78 | 11 | 97 | 1877 | 0.0516782099094299 | 0.33148743203938 | 0.33148743203938 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 72610247315.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T19:06:51.574572Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 1d3170a5-7a50-42a1-b317-d5a79b23c998 | 2026-09-18 10:57 | 2026-09-18 10:56 | 2026-09-18 10:56 | TGT | TGT270115C00170000 | call | 170.0000 | 2027-01-15 | 7.6500 | 7.6500 | 7.9000 | 157.4200 | 138470.00 | 770.00 | 137700.00 | 181 | 18 | 227 | 2246 | 0.10106856634016 | 0.327122657997955 | 0.328558945600411 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 71865200668.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T15:02:00.544193Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 64b06e35-1c7e-4d57-a877-e6b00b40be32 | 2026-09-18 12:50 | 2026-09-18 12:50 | 2026-09-18 12:50 | TGT | TGT270115C00175000 | call | 175.0000 | 2027-01-15 | 6.3000 | 6.0500 | 6.5500 | 157.9800 | 135450.00 | 0.00 | 131040.00 | 215 | 49 | 274 | 740 | 0.37027027027027 | 0.325974958630928 | 0.325974958630928 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 71865200668.00 | 2026-11-18 | unknown | — | 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 |
| 1392f0e0-84c3-479b-affe-64969843ce65 | 2026-09-18 14:01 | 2026-09-18 14:01 | 2026-09-18 14:01 | TGT | TGT261120C00160000 | call | 160.0000 | 2026-11-20 | 8.4500 | 8.2000 | 9.0000 | 157.6500 | 212105.00 | 845.00 | 211260.00 | 251 | 6 | 271 | 1029 | 0.263362487852284 | 0.345134141252948 | 0.347048026936084 | false | false | false | true | false | RepeatedHitsAscendingFill | a0979b52-28e4-4585-8f22-881faad2dd8e | 1 | Common Stock | Consumer Defensive | 71865200668.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| aa0587c8-3fbb-457a-80df-360f8a8fb176 | 2026-09-18 14:06 | 2026-09-18 14:06 | 2026-09-18 14:06 | TGT | TGT261120C00160000 | call | 160.0000 | 2026-11-20 | 8.4000 | 8.2000 | 8.5500 | 157.5300 | 57120.00 | 1680.00 | 55440.00 | 68 | 6 | 340 | 1029 | 0.33041788143829 | 0.345545490630471 | 0.345545490630471 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 71865200668.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T18:22:45.408265Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |
| 0099e1bc-7907-404b-ac73-a46fec9fa084 | 2026-09-18 14:59 | 2026-09-18 14:59 | 2026-09-18 14:59 | TGT | TGT261120C00165000 | call | 165.0000 | 2026-11-20 | 6.4000 | 6.1500 | 6.5000 | 157.7150 | 104960.00 | 8960.00 | 96000.00 | 164 | 5 | 347 | 808 | 0.429455445544554 | 0.343109229702477 | 0.343109229702477 | false | false | false | true | false | RepeatedHits | e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3 | 1 | Common Stock | Consumer Defensive | 71865200668.00 | 2026-11-18 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T19:03:43.854590Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |