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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c47db3ab-d77c-4ad6-a63e-73ce54c7b90a | 2026-08-17 13:25 | 2026-08-17 13:25 | 2026-08-17 13:25 | BG | BG260821C00105000 | call | 105.0000 | 2026-08-21 | 9.5000 | 7.8000 | 10.3000 | 114.6100 | 275500.00 | 275500.00 | 0.00 | 290 | 1 | 290 | 42 | 6.90476190476191 | 0.781756026156931 | 0.781756026156931 | false | true | false | true | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 23290601281.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 033c1c10-7ca2-4864-871a-6b22dddbbb0b | 2026-08-17 13:25 | 2026-08-17 13:25 | 2026-08-17 13:25 | BG | BG260821C00110000 | call | 110.0000 | 2026-08-21 | 4.5000 | 3.7000 | 4.9000 | 114.6100 | 135000.00 | 135000.00 | 0.00 | 300 | 1 | 361 | 354 | 1.01977401129944 | 0.341539489254825 | 0.341539489254825 | false | true | false | true | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 23290601281.00 | 2026-11-04 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-17T17:44:03.146928Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2202262b-ad90-48da-8672-e1fdb982879a | 2026-08-18 13:46 | 2026-08-18 13:46 | 2026-08-18 13:46 | BJ | BJ260821P00095000 | put | 95.0000 | 2026-08-21 | 3.1500 | 2.8500 | 3.6000 | 93.7400 | 236250.00 | 0.00 | 236250.00 | 750 | 2 | 751 | 1004 | 0.74800796812749 | 0.728758247695355 | 0.728758247695355 | false | true | true | false | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 2 | Common Stock | Consumer Defensive | 12039053295.00 | 2026-11-20 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 62681907-11f4-4981-967e-2cf77c30ace0 | 2026-08-19 11:17 | 2026-08-19 11:16 | 2026-08-19 11:16 | LRN | LRN260918P00090000 | put | 90.0000 | 2026-09-18 | 7.1800 | 6.5000 | 7.6000 | 84.6800 | 538500.00 | 538500.00 | 0.00 | 750 | 2 | 750 | 58 | 12.9310344827586 | 0.411000679263933 | 0.411000679263933 | false | true | false | true | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 3436999182.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T15:17:48.302096Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 97f3e809-1594-46af-a5fe-20ee8c2d3da1 | 2026-08-20 10:38 | 2026-08-20 10:38 | 2026-08-20 10:38 | AGRO | AGRO260918C00012500 | call | 12.5000 | 2026-09-18 | 0.2600 | 0.1500 | 0.3000 | 10.8900 | 65000.00 | 65000.00 | 0.00 | 2500 | 2 | 2500 | 2297 | 1.08837614279495 | 0.613226669368781 | 0.613226669368781 | false | true | false | true | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 1670999932.00 | 2026-11-10 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T14:48:30.894899Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 02a02de5-fb3c-4c14-84de-ebdace965b67 | 2026-08-20 13:05 | 2026-08-20 13:05 | 2026-08-20 13:05 | KDP | KDP261016C00033000 | call | 33.0000 | 2026-10-16 | 0.7100 | 0.7000 | 2.1000 | 31.9850 | 193262.00 | 0.00 | 193262.00 | 2722 | 1 | 2722 | 418 | 6.51196172248804 | 0.209601743804269 | 0.209601743804269 | false | true | true | false | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 42974886280.00 | 2026-10-26 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T17:13:28.834542Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5db9cf3c-18f8-464b-9c60-20ed5eb373cd | 2026-08-21 15:20 | 2026-08-21 15:20 | 2026-08-21 15:20 | PRMB | PRMB260918C00025000 | call | 25.0000 | 2026-09-18 | 0.2300 | 0.2000 | 0.3000 | 22.9300 | 230000.00 | 0.00 | 230000.00 | 10000 | 4 | 10002 | 240 | 41.675 | 0.339183132247829 | 0.339183132247829 | false | true | true | false | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 2 | Common Stock | Consumer Defensive | 7645670350.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-21T19:32:44.160800Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| a591f673-a67e-4c78-b337-b4cadae9a70f | 2026-08-24 10:02 | 2026-08-24 10:02 | 2026-08-24 10:02 | SJM | SJM270416P00135000 | put | 135.0000 | 2027-04-16 | 16.6700 | 15.2000 | 17.9000 | 125.6150 | 3810762.00 | 3810762.00 | 0.00 | 2286 | 2 | 2286 | 0 | 0 | 0.32900119952038 | 0.32900119952038 | false | true | true | false | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 12957652098.00 | 2026-11-24 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:08:32.927735Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| c74f1118-181d-4717-951c-3a72b2f12519 | 2026-08-24 11:06 | 2026-08-24 11:06 | 2026-08-24 11:06 | FRPT | FRPT261218C00085000 | call | 85.0000 | 2026-12-18 | 5.7500 | 5.4000 | 6.9000 | 75.7100 | 360530.00 | 0.00 | 360530.00 | 627 | 2 | 627 | 9 | 69.6666666666667 | 0.523066308372874 | 0.523066308372874 | false | true | false | true | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 3064663379.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T15:09:19.758040Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 56c91904-c02a-4d1d-a0d3-314fdc57060c | 2026-08-26 10:28 | 2026-08-26 10:28 | 2026-08-26 10:28 | MDLZ | MDLZ260911P00064000 | put | 64.0000 | 2026-09-11 | 1.5800 | 1.0000 | 2.1500 | 63.4400 | 197500.00 | 120000.00 | 77500.00 | 1250 | 2 | 1250 | 1 | 1250 | 0.246487904910328 | 0.246487904910328 | false | true | false | true | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 79628859676.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T14:42:05.005742Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| b011795a-61d0-4f2c-8572-d24a4b7105c1 | 2026-08-27 10:09 | 2026-08-27 10:09 | 2026-08-27 10:09 | DAR | DAR260918P00060000 | put | 60.0000 | 2026-09-18 | 2.0000 | 1.3500 | 2.4500 | 61.2200 | 600000.00 | 600000.00 | 0.00 | 3000 | 1 | 3001 | 414 | 7.2487922705314 | 0.442581457613014 | 0.442581457613014 | false | true | false | true | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 10244565307.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T14:11:49.813441Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 25bd41c6-4f57-44cd-ba94-3c01e75284c4 | 2026-08-27 10:59 | 2026-08-27 10:59 | 2026-08-27 10:59 | DAR | DAR270115C00072500 | call | 72.5000 | 2027-01-15 | 2.8500 | 2.3000 | 2.8500 | 60.6700 | 285000.00 | 285000.00 | 0.00 | 1000 | 1 | 1150 | 1936 | 0.59400826446281 | 0.425747512718519 | 0.425747512718519 | false | true | false | true | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 10244565307.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T15:06:04.251678Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ec0993ef-17be-4ad3-88cf-9366a527c2cf | 2026-09-03 13:33 | 2026-09-03 13:33 | 2026-09-03 13:33 | MDLZ | MDLZ260911P00064000 | put | 64.0000 | 2026-09-11 | 2.6300 | 1.9000 | 3.3000 | 61.2200 | 328750.00 | 328750.00 | 0.00 | 1250 | 2 | 1250 | 1250 | 1 | 0.426430920637416 | 0.426430920637416 | false | true | true | false | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 79628859676.00 | 2026-10-27 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 1576e4a3-48ee-428d-bdf4-cbfd2690a499 | 2026-09-04 10:46 | 2026-09-04 10:46 | 2026-09-04 10:46 | PRMB | PRMB260918C00023000 | call | 23.0000 | 2026-09-18 | 0.3500 | 0.0500 | 0.4000 | 22.0900 | 122500.00 | 122500.00 | 0.00 | 3500 | 1 | 3500 | 900 | 3.88888888888889 | 0.399517985597896 | 0.399517985597896 | false | true | false | true | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 7645670350.00 | 2026-11-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d5f13514-9f47-4eae-83cf-db33b1a7e15b | 2026-09-10 10:45 | 2026-09-10 10:45 | 2026-09-10 10:45 | COUR | COUR270115P00005000 | put | 5.0000 | 2027-01-15 | 0.5500 | 0.5000 | 0.6500 | 5.3800 | 137500.00 | 0.00 | 137500.00 | 2500 | 1 | 3000 | 1404 | 2.13675213675214 | 0.624943352413912 | 0.624943352413912 | false | true | false | true | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 1433048000.00 | 2026-10-22 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T14:57:03.898045Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2e4fadab-ed32-4aa2-b645-fa6c88ef25ad | 2026-09-14 10:21 | 2026-09-14 10:21 | 2026-09-14 10:21 | GO | GO261016C00010000 | call | 10.0000 | 2026-10-16 | 1.7500 | 1.7000 | 1.9000 | 11.0000 | 52500.00 | 0.00 | 52500.00 | 300 | 1 | 304 | 2642 | 0.115064345193036 | 0.524222671176482 | 0.524222671176482 | false | true | false | true | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 1155325177.00 | 2026-11-03 | unknown | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-14T14:26:55.719155Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| f9e659fc-0493-4871-a9c0-967ab9ba5a4a | 2026-09-17 10:14 | 2026-09-17 10:14 | 2026-09-17 10:14 | FRPT | FRPT260918P00062500 | put | 62.5000 | 2026-09-18 | 1.0300 | 0.0500 | 2.4000 | 62.9100 | 82400.00 | 0.00 | 82400.00 | 800 | 2 | 800 | 13 | 61.5384615384615 | 0.914205455634129 | 0.914205455634129 | false | true | false | true | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 2958935616.00 | 2026-11-02 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T14:19:06.318420Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 684fa173-66ee-4413-9da6-08b72a57c518 | 2026-09-17 14:39 | 2026-09-17 14:39 | 2026-09-17 14:39 | CALM | CALM260918P00085000 | put | 85.0000 | 2026-09-18 | 11.1000 | 10.0000 | 11.2000 | 74.5400 | 129870.00 | 129870.00 | 0.00 | 117 | 2 | 118 | 78 | 1.51282051282051 | 2.27717977717747 | 2.27717977717747 | false | true | true | false | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 3476086457.00 | 2026-09-30 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-17T18:42:11.317744Z"} | 2026-09-17 | 2026-09-17 21:15 | 2026-09-17 21:15 |
| 4defd27d-3d73-4828-a68a-61e791ddb7a8 | 2026-09-17 14:42 | 2026-09-17 14:42 | 2026-09-17 14:42 | KVUE | KVUE260918P00020000 | put | 20.0000 | 2026-09-18 | 2.0000 | 2.0000 | 2.3100 | 17.8850 | 136800.00 | 0.00 | 136800.00 | 684 | 1 | 684 | 456 | 1.5 | 2.22103579449473 | 2.22103579449473 | false | true | true | false | true | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 34324221855.00 | 2026-11-02 | 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 |
| 3bef91ff-8c41-45bf-b1bc-03810c89b783 | 2026-09-18 09:52 | 2026-09-18 09:52 | 2026-09-18 09:52 | LW | LW261016P00037500 | put | 37.5000 | 2026-10-16 | 0.2100 | 0.2000 | 0.3500 | 46.1200 | 296730.00 | 0.00 | 296730.00 | 14130 | 2 | 14130 | 240 | 58.875 | 0.524699014693951 | 0.524699014693951 | false | true | false | true | false | LowHistoricVolumeFloor | b356ec2b-92e1-458a-934a-7719f71c40bc | 1 | Common Stock | Consumer Defensive | 6416238783.00 | 2026-10-06 | premarket | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-18T13:59:27.968934Z"} | 2026-09-18 | 2026-09-18 21:15 | 2026-09-18 21:15 |