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.

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

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×ticker = CCL×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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