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
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| e6116112-32b4-48e8-8143-550893ea238f | 2026-09-21 12:30 | 2026-09-21 12:30 | 2026-09-21 12:30 | CCL | CCL280121C00032000 | call | 32.0000 | 2028-01-21 | 2.2000 | 2.0000 | 2.2000 | 22.0000 | 750135.00 | 750135.00 | 0.00 | 3410 | 14 | 3415 | 1150 | 2.9695652173913 | 0.435756964695964 | 0.432192341235711 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30556871845.00 | 2026-09-29 | premarket | true | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-21T16:32:17.927421Z"} | 2026-09-21 | 2026-09-21 21:15 | 2026-09-21 21:15 |
| 013a1e48-07f8-40b3-9007-c0f6c7f99187 | 2026-09-18 10:02 | 2026-09-18 10:02 | 2026-09-18 10:02 | CCL | CCL260918P00022000 | put | 22.0000 | 2026-09-18 | 0.2200 | 0.2200 | 0.2700 | 21.8950 | 73289.00 | 0.00 | 73289.00 | 3329 | 46 | 4015 | 6930 | 0.579365079365079 | 0.846640977542918 | 0.711570160510961 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 29913136759.00 | 2026-09-29 | premarket | — | 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 |
| 9f1f1525-1b50-4ed2-a2de-92ed915d2bf4 | 2026-09-15 12:00 | 2026-09-15 12:00 | 2026-09-15 12:00 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.7600 | 1.6900 | 1.7700 | 22.0250 | 89211.00 | 87285.00 | 1750.00 | 507 | 41 | 2270 | 1400 | 1.62142857142857 | 0.480950233313789 | 0.480573109611527 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T16:20:08.530678Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| 16f9f37f-b88e-42e0-9826-dd4af34167c5 | 2026-09-15 10:07 | 2026-09-15 10:07 | 2026-09-15 10:07 | CCL | CCL270115P00021000 | put | 21.0000 | 2027-01-15 | 1.6300 | 1.5400 | 1.6600 | 22.2786 | 26184.00 | 21150.00 | 3088.00 | 161 | 26 | 262 | 1400 | 0.187142857142857 | 0.471947049193547 | 0.471947049193547 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | 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 |
| 2787c661-9908-4300-87f1-262daf87257c | 2026-09-15 09:46 | 2026-09-15 09:46 | 2026-09-15 09:46 | CCL | CCL261218P00021000 | put | 21.0000 | 2026-12-18 | 1.3700 | 1.1900 | 1.4100 | 22.4200 | 44436.00 | 40900.00 | 3536.00 | 325 | 56 | 325 | 618 | 0.52588996763754 | 0.479857252312291 | 0.47703355197246 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-15T13:48:14.023311Z"} | 2026-09-15 | 2026-09-15 21:15 | 2026-09-15 21:15 |
| a4fc7256-60df-489e-9402-be8f2f2def54 | 2026-09-14 09:33 | 2026-09-14 09:32 | 2026-09-14 09:32 | CCL | CCL261016C00022000 | call | 22.0000 | 2026-10-16 | 1.6100 | 1.0800 | 1.7400 | 22.4700 | 10954.00 | 8644.00 | 2310.00 | 68 | 21 | 68 | 194 | 0.350515463917526 | 0.52007800797459 | 0.475990531263644 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | 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 |
| 5f42fbad-197d-4d2c-8464-bf820304c5a3 | 2026-09-10 11:18 | 2026-09-10 11:18 | 2026-09-10 11:18 | CCL | CCL261016P00023000 | put | 23.0000 | 2026-10-16 | 1.4500 | 1.4250 | 1.4700 | 22.6350 | 41010.00 | 146.00 | 40864.00 | 283 | 35 | 321 | 3215 | 0.0998444790046656 | 0.457663787644986 | 0.454137234915055 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-10T15:21:12.723015Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 4cd22568-45e9-4916-b72d-71a56a9b3a95 | 2026-09-03 13:48 | 2026-09-03 13:48 | 2026-09-03 13:48 | CCL | CCL280121C00032000 | call | 32.0000 | 2028-01-21 | 2.5600 | 2.4400 | 2.5600 | 23.3800 | 25324.00 | 25324.00 | 0.00 | 99 | 17 | 99 | 1081 | 0.091581868640148 | 0.425303518513525 | 0.424361515677624 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | 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 |
| c343d5e4-01f6-4751-b675-6bb65a88d46d | 2026-09-03 12:25 | 2026-09-03 12:25 | 2026-09-03 12:25 | CCL | CCL261218C00025000 | call | 25.0000 | 2026-12-18 | 1.6000 | 1.6000 | 1.6600 | 23.3550 | 49563.00 | 1449.00 | 48114.00 | 309 | 26 | 328 | 4266 | 0.0768870135958744 | 0.431142906833242 | 0.42913507928286 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-09-03T16:31:32.213825Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 7de9b993-ebcf-4ca7-a9a7-70615dfa3221 | 2026-08-31 15:31 | 2026-08-31 15:31 | 2026-08-31 15:31 | CCL | CCL280121C00025000 | call | 25.0000 | 2028-01-21 | 4.8300 | 4.7000 | 4.9500 | 23.9450 | 34746.00 | 34746.00 | 0.00 | 72 | 6 | 134 | 2143 | 0.0625291647223518 | 0.41786839787262 | 0.416945242080616 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T19:31:33.694739Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 8a86e20c-31a9-4577-82e3-43c1fad2ab84 | 2026-08-31 12:37 | 2026-08-31 12:37 | 2026-08-31 12:37 | CCL | CCL280121P00015000 | put | 15.0000 | 2028-01-21 | 1.1500 | 1.1300 | 1.2000 | 24.0850 | 11530.00 | 0.00 | 11530.00 | 100 | 6 | 1201 | 3006 | 0.399534264803726 | 0.5190150236307 | 0.5190150236307 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 216bc21c-b147-471c-a0e6-f18b5569fdaf | 2026-08-31 12:36 | 2026-08-31 12:36 | 2026-08-31 12:36 | CCL | CCL280121P00015000 | put | 15.0000 | 2028-01-21 | 1.1500 | 1.1300 | 1.2000 | 24.0750 | 11530.00 | 0.00 | 11530.00 | 100 | 6 | 1001 | 3006 | 0.333000665335995 | 0.518804166517348 | 0.518804166517348 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-31T16:39:59.140702Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d7959320-4b8e-490a-9179-34a793a840a4 | 2026-08-28 10:36 | 2026-08-28 10:35 | 2026-08-28 10:35 | CCL | CCL270115P00022000 | put | 22.0000 | 2027-01-15 | 1.2800 | 1.2800 | 1.3400 | 25.0850 | 11550.00 | 0.00 | 11550.00 | 90 | 6 | 427 | 10190 | 0.0419038272816487 | 0.460181736758121 | 0.458185732417486 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-28T14:38:22.875878Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ad504839-5d0d-4eaf-ab54-940eee393daa | 2026-08-27 15:10 | 2026-08-27 15:09 | 2026-08-27 15:09 | CCL | CCL270319C00030000 | call | 30.0000 | 2027-03-19 | 1.8800 | 1.5200 | 1.8800 | 25.0400 | 28161.00 | 20868.00 | 7293.00 | 150 | 8 | 154 | 1226 | 0.125611745513866 | 0.450734754472942 | 0.450734754472942 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T19:12:42.953166Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| ae72067b-326f-4a86-8b96-3edfd9b9a636 | 2026-08-27 13:13 | 2026-08-27 13:13 | 2026-08-27 13:13 | CCL | CCL261218C00030000 | call | 30.0000 | 2026-12-18 | 0.9500 | 0.9400 | 1.0100 | 25.2450 | 62998.00 | 0.00 | 62998.00 | 660 | 6 | 692 | 9448 | 0.0732430143945809 | 0.426275648140945 | 0.426275648140945 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-27T17:21:32.961774Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 40aece82-f0b3-4a2c-8e37-c6822fefc298 | 2026-08-26 14:22 | 2026-08-26 14:22 | 2026-08-26 14:22 | CCL | CCL261218C00031000 | call | 31.0000 | 2026-12-18 | 0.9500 | 0.9200 | 0.9600 | 25.7950 | 18141.00 | 15006.00 | 3135.00 | 191 | 33 | 4209 | 10925 | 0.385263157894737 | 0.433629075320211 | 0.432479641096947 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 5b877700-df30-4f41-abde-0b1a39d6756c | 2026-08-24 10:25 | 2026-08-24 10:25 | 2026-08-24 10:25 | CCL | CCL270115P00023000 | put | 23.0000 | 2027-01-15 | 1.4700 | 1.4200 | 1.4800 | 25.8300 | 12479.00 | 12332.00 | 0.00 | 85 | 5 | 801 | 1839 | 0.435562805872757 | 0.458968829137964 | 0.457640661046452 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-24T14:35:34.147296Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 23f21c96-f948-4b28-bdbb-e1a2fc4b8058 | 2026-08-20 15:54 | 2026-08-20 15:54 | 2026-08-20 15:54 | CCL | CCL270319C00030000 | call | 30.0000 | 2027-03-19 | 1.8900 | 1.7500 | 2.0300 | 25.3250 | 95009.00 | 94635.00 | 374.00 | 502 | 45 | 556 | 980 | 0.56734693877551 | 0.430237657442661 | 0.430237657442661 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T19:59:19.634890Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 54f79b64-1fde-4f76-a4ba-d836306d8f55 | 2026-08-20 11:16 | 2026-08-20 11:16 | 2026-08-20 11:16 | CCL | CCL270319C00032000 | call | 32.0000 | 2027-03-19 | 1.5600 | 1.5000 | 1.5600 | 25.8100 | 74042.00 | 40872.00 | 18135.00 | 476 | 19 | 1985 | 4070 | 0.487714987714988 | 0.426400591739532 | 0.42453120628595 | false | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-20T15:16:49.821442Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| d76077b5-b2c4-4804-bf48-5f311c1e3a77 | 2026-08-19 15:37 | 2026-08-19 15:37 | 2026-08-19 15:37 | CCL | CCL270115C00030000 | call | 30.0000 | 2027-01-15 | 1.8800 | 1.8600 | 1.9300 | 26.8000 | 36631.00 | 11520.00 | 25111.00 | 195 | 5 | 264 | 7847 | 0.0336434306104244 | 0.424373907685331 | 0.432473077099132 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-19T19:47:06.720571Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |
| 2e639742-fbc3-44cc-b337-15bcc95b29fd | 2026-08-18 10:04 | 2026-08-18 10:04 | 2026-08-18 10:04 | CCL | CCL260918P00028000 | put | 28.0000 | 2026-09-18 | 1.5100 | 1.3800 | 1.5100 | 27.4101 | 820229.00 | 820080.00 | 149.00 | 5432 | 67 | 5438 | 9554 | 0.569185681389994 | 0.397320060716831 | 0.387207635082202 | true | false | false | true | false | RepeatedHitsDescendingFill | 5ce5ec11-087c-4c00-b164-08106b015856 | 1 | Common Stock | Consumer Cyclical | 30899284125.00 | 2026-10-05 | unknown | — | uw_flow_alerts | /api/option-trades/flow-alerts | {"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"} | 2026-09-15 | 2026-09-15 08:45 | 2026-09-15 08:45 |