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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×endpoint = /api/option-trades/flow-alerts×ticker = CCL×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strike

aca8c4b0-c1fb-4dd6-91f1-c9d63f00abe1	2026-10-01 15:56	2026-10-01 15:56	2026-10-01 15:56	CCL	CCL261218C00025000	call	25.0000	2026-12-18	2.0500	1.9500	2.0500	25.0350	26238.00	26238.00	0.00	128	14	8510	3071	2.7710843373494	0.418240611741288	0.416050120949378	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	33709375934.00	2026-12-18	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T19:58:45.768472Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
9d356432-6949-4f8d-bee6-1e962d460d75	2026-10-01 14:12	2026-10-01 14:11	2026-10-01 14:11	CCL	CCL261030C00025000	call	25.0000	2026-10-30	1.2000	1.1700	1.2100	24.9650	24000.00	23880.00	120.00	200	9	568	1419	0.400281888653982	0.420059735106961	0.420059735106961	false	false	false
e4b10e58-0b04-45d8-b211-ad5ae0c1ee2f	2026-10-01 13:37	2026-10-01 13:37	2026-10-01 13:37	CCL	CCL261023C00028000	call	28.0000	2026-10-23	0.1800	0.1600	0.1800	24.9750	12582.00	12582.00	0.00	699	20	723	913	0.791894852135816	0.411370396216576	0.411370396216576	false	false	false
c442988d-b15a-42e6-959e-88e4afa2aa40	2026-10-01 13:26	2026-10-01 13:26	2026-10-01 13:26	CCL	CCL270115C00027000	call	27.0000	2027-01-15	1.5400	1.5400	1.5800	25.0050	82544.00	0.00	82544.00	536	41	544	5343	0.101815459479693	0.410184645676545	0.410484440366102	false	false	false
ad2a6e12-be01-46bd-b29c-4e4e681a43d2	2026-10-01 13:26	2026-10-01 13:26	2026-10-01 13:26	CCL	CCL270115C00025000	call	25.0000	2027-01-15	2.3600	2.3600	2.4000	25.0050	33512.00	0.00	33512.00	142	25	278	4478	0.0620812862885217	0.412130690577439	0.41252639009724	false	false	false
f83524c7-e926-4266-85c6-2bbc96cbe970	2026-10-01 12:13	2026-10-01 12:13	2026-10-01 12:13	CCL	CCL261016P00024000	put	24.0000	2026-10-16	0.4900	0.4700	0.4900	24.6077	10290.00	10290.00	0.00	210	18	247	6455	0.0382649109217661	0.392600766456955	0.392600766456955	false	false	false
3ddd09a1-119e-4ba4-a826-1c7ca736737a	2026-10-01 12:09	2026-10-01 12:09	2026-10-01 12:09	CCL	CCL261218P00025000	put	25.0000	2026-12-18	2.0100	1.9400	2.0500	24.6781	13668.00	4824.00	8844.00	68	6	133	27132	0.00490196078431373	0.430587146991985	0.430587146991985	false	false	false
c5265217-15c1-46cf-90b4-06e93aec2736	2026-10-01 11:39	2026-10-01 11:39	2026-10-01 11:39	CCL	CCL270617C00025000	call	25.0000	2027-06-17	3.7000	3.5000	3.7500	24.7950	13690.00	740.00	12950.00	37	8	43	12702	0.00338529365454259	0.415688416426233	0.414826443721931	false	false	false
2a3dff0e-4d85-40ca-9895-250a566d8b6c	2026-10-01 11:00	2026-10-01 11:00	2026-10-01 11:00	CCL	CCL270115C00028000	call	28.0000	2027-01-15	1.0800	1.0800	1.1500	24.6950	18252.00	0.00	18252.00	169	6	174	2926	0.0594668489405332	0.402394325377756	0.402394325377756	false	false	false
d518f0fe-1e19-4713-91a6-cd9027a62e39	2026-10-01 10:55	2026-10-01 10:55	2026-10-01 10:55	CCL	CCL261218C00025000	call	25.0000	2026-12-18	1.7200	1.5800	1.7200	24.5650	1199012.00	1199012.00	0.00	6971	48	6973	3071	2.27059589710192	0.401441097985712	0.401441097985712	false	false	false
aa18f19d-7d99-4bf1-a58e-11c3c14c83d4	2026-10-01 10:55	2026-10-01 10:55	2026-10-01 10:55	CCL	CCL261218C00029000	call	29.0000	2026-12-18	0.5500	0.4900	0.5500	24.5650	25905.00	25905.00	0.00	471	18	483	1016	0.475393700787402	0.402973967009573	0.402973967009573	false	false	false
3e076d1b-b00a-4d21-bbfd-783bb95976db	2026-10-01 10:55	2026-10-01 10:55	2026-10-01 10:55	CCL	CCL261016P00025000	put	25.0000	2026-10-16	0.9600	0.9600	1.0100	24.5650	10368.00	0.00	10368.00	108	8	117	3475	0.0336690647482014	0.372949446033739	0.372949446033739	false	false	false
c80da5e9-d5a6-4bc3-aee2-c483fa83a315	2026-09-30 15:56	2026-09-30 15:56	2026-09-30 15:56	CCL	CCL261016C00025000	call	25.0000	2026-10-16	0.6500	0.6000	0.6500	24.6150	15600.00	15600.00	0.00	240	17	3174	8518	0.372622681380606	0.390886163058462	0.390886163058462	false	false	false
4764f299-44a4-4200-bf39-78e2f93fd37f	2026-09-30 15:29	2026-09-30 15:29	2026-09-30 15:29	CCL	CCL261120P00022500	put	22.5000	2026-11-20	0.5500	0.5100	0.5500	24.7850	11000.00	11000.00	0.00	200	10	367	3721	0.0986294006987369	0.412812300710288	0.412812300710288	false	false	false
f5ae4e68-8540-4bbd-bc7d-4437a26e6b95	2026-09-30 13:32	2026-09-30 13:31	2026-09-30 13:31	CCL	CCL261218C00022000	call	22.0000	2026-12-18	3.6500	3.5500	3.9000	24.8050	156950.00	0.00	156950.00	430	6	462	1476	0.313008130081301	0.406138947047126	0.406138947047126	true	false	false
a4965767-01d5-48ea-a8e5-d23b2c09f3e6	2026-09-30 13:25	2026-09-30 13:25	2026-09-30 13:25	CCL	CCL270319P00023000	put	23.0000	2027-03-19	1.9500	1.6200	1.9700	24.0000	25156.00	9750.00	15406.00	129	9	159	7283	0.0218316627763284	0.460116994831592	0.461759663840739	false	false	false
93000aa4-5a08-40a4-a75c-d6c2b7a011f4	2026-09-30 12:29	2026-09-30 12:29	2026-09-30 12:29	CCL	CCL261009P00024000	put	24.0000	2026-10-09	0.2900	0.2900	0.3000	24.9750	17313.00	0.00	17313.00	597	8	877	708	1.23870056497175	0.440476430747765	0.440476430747765	false	false	false
97eb5285-b9a1-4d26-a18f-61541341366c	2026-09-30 11:17	2026-09-30 11:17	2026-09-30 11:17	CCL	CCL261120P00024000	put	24.0000	2026-11-20	0.9100	0.9100	0.9400	25.2850	10465.00	0.00	10465.00	115	6	153	4634	0.0330168321104877	0.414552887798449	0.414552887798449	false	false	false
46ab175f-e6bb-4e67-886b-6ee41ccf3699	2026-09-30 10:18	2026-09-30 10:18	2026-09-30 10:18	CCL	CCL261002C00025000	call	25.0000	2026-10-02	0.6500	0.6500	0.6900	25.4050	14625.00	0.00	14625.00	225	6	1193	8190	0.145665445665446	0.554560740917018	0.554560740917018	false	false	false
a8dc9832-a6e7-42d1-a944-814839a042b5	2026-09-30 09:30	2026-09-30 09:30	2026-09-30 09:30	CCL	CCL261016C00025000	call	25.0000	2026-10-16	1.0200	1.1000	1.2500	25.3834	153556.00	0.00	153556.00	1500	13	1500	8518	0.176097675510683	0.408874140109121	0.384565809199201	true	true	false
1e70eecd-aa77-4350-99cd-5695e799fdb4	2026-09-29 15:35	2026-09-29 15:35	2026-09-29 15:35	CCL	CCL261218C00028000	call	28.0000	2026-12-18	1.0700	1.0400	1.0700	25.2250	10593.00	10593.00	0.00	99	8	870	1011	0.86053412462908	0.423739804229696	0.423739804229696	false	false	false
b3cc11b5-4006-4231-bbe7-ad745ecde1ef	2026-09-29 15:31	2026-09-29 15:31	2026-09-29 15:31	CCL	CCL261016C00026000	call	26.0000	2026-10-16	0.6200	0.6200	0.6600	25.2050	11532.00	0.00	11532.00	186	10	2031	4069	0.499139837797985	0.430049489906681	0.430049489906681	false	false	false
1511c54b-95e7-4189-ae92-82a363274f9b	2026-09-29 15:19	2026-09-29 15:19	2026-09-29 15:19	CCL	CCL261002P00025000	put	25.0000	2026-10-02	0.5000	0.4600	0.5000	25.0450	13900.00	13900.00	0.00	278	6	1971	443	4.44920993227991	0.581614552126797	0.581614552126797	false	false	false
ac4d15b0-bde6-42eb-8fa9-6af81d9fc15b	2026-09-29 15:17	2026-09-29 15:17	2026-09-29 15:17	CCL	CCL261023C00028000	call	28.0000	2026-10-23	0.2800	0.2600	0.3000	25.0550	19600.00	10836.00	1904.00	700	44	836	98	8.53061224489796	0.447469183095812	0.447469183095812	true	false	false
f2d0fefa-0736-43f7-a3a2-0ec6e3d043c1	2026-09-29 14:47	2026-09-29 14:47	2026-09-29 14:47	CCL	CCL261016P00025000	put	25.0000	2026-10-16	0.8600	0.8100	0.8700	25.1800	15136.00	15136.00	0.00	176	19	884	2907	0.304093567251462	0.449300098067025	0.449300098067025	false	false	false
2b71b092-2c23-42ad-896c-6035f0f07499	2026-09-29 14:47	2026-09-29 14:47	2026-09-29 14:47	CCL	CCL261016P00026000	put	26.0000	2026-10-16	1.4200	1.3700	1.4200	25.1800	109908.00	109908.00	0.00	774	34	873	1730	0.504624277456647	0.448560359121506	0.448560359121506	false	false	false
1629f679-5fae-4a79-b236-58c1216a7a8c	2026-09-29 14:39	2026-09-29 14:39	2026-09-29 14:39	CCL	CCL261009C00026500	call	26.5000	2026-10-09	0.3500	0.3200	0.3500	25.0000	12880.00	12880.00	0.00	368	14	821	6	136.833333333333	0.491410864349303	0.491410864349303	true	false	false
1e33c720-fa2c-4f64-9f99-2828f3b56ad1	2026-09-29 14:37	2026-09-29 14:37	2026-09-29 14:37	CCL	CCL261002C00026000	call	26.0000	2026-10-02	0.2500	0.2300	0.2500	25.0000	25750.00	25750.00	0.00	1030	8	16952	2514	6.74303898170247	0.635338630792069	0.635338630792069	true	false	false
ce708d31-7b9f-43ab-b653-e613229454cc	2026-09-29 14:37	2026-09-29 14:36	2026-09-29 14:36	CCL	CCL261002C00026000	call	26.0000	2026-10-02	0.2400	0.2300	0.2400	25.0000	69960.00	69960.00	0.00	2915	27	15918	2514	6.33174224343675	0.626021921597653	0.626021921597653	true	false	false
00a58bdc-8f82-452c-bdba-145d91d27399	2026-09-29 14:30	2026-09-29 14:30	2026-09-29 14:30	CCL	CCL261002C00025500	call	25.5000	2026-10-02	0.3500	0.3000	0.3500	25.0000	18445.00	18445.00	0.00	527	20	8902	653	13.6324655436447	0.600155340076748	0.591331907879848	false	false	false
1531f1c0-12cd-469e-b364-e4d55c27a445	2026-09-29 13:14	2026-09-29 13:14	2026-09-29 13:14	CCL	CCL261009C00025000	call	25.0000	2026-10-09	0.8200	0.7800	0.8200	25.0100	10004.00	10004.00	0.00	122	5	2898	3696	0.784090909090909	0.48711630038787	0.48711630038787	false	false	false
460ff2a2-d566-4c61-953e-77492021d4c7	2026-09-29 12:45	2026-09-29 12:45	2026-09-29 12:45	CCL	CCL290119C00032000	call	32.0000	2029-01-19	5.0100	4.6000	5.1000	24.0000	23560.00	5555.00	18005.00	47	5	60	40	1.5	0.423183891130022	0.423183891130022	false	false	false
8108a7d3-e56e-451c-9ce5-69da30f555fb	2026-09-29 12:39	2026-09-29 12:39	2026-09-29 12:39	CCL	CCL261016P00025500	put	25.5000	2026-10-16	1.2700	1.2400	1.2700	24.9250	151003.00	151003.00	0.00	1189	31	1192	23	51.8260869565217	0.453976427902014	0.453976427902014	false	false	false
42b54a41-e0a8-4c2b-a250-a96b5255d6e1	2026-09-29 12:38	2026-09-29 12:38	2026-09-29 12:38	CCL	CCL261120P00027000	put	27.0000	2026-11-20	2.8700	2.8400	3.1500	24.0000	26978.00	6888.00	20090.00	94	8	124	17316	0.00716100716100716	0.447697287113004	0.447697287113004	false	false	false
8e8a2896-ccaa-441c-8d3c-e1c04d03c541	2026-09-29 12:24	2026-09-29 12:24	2026-09-29 12:24	CCL	CCL261002C00025000	call	25.0000	2026-10-02	0.5200	0.5100	0.5200	24.9501	26000.00	26000.00	0.00	500	5	16707	3087	5.41205053449951	0.598586603246702	0.598586603246702	false	false	false
f234cb5d-92d3-4237-a357-5dca683878d2	2026-09-29 12:20	2026-09-29 12:20	2026-09-29 12:20	CCL	CCL261120C00028000	call	28.0000	2026-11-20	0.6000	0.5900	0.6000	24.8700	10380.00	10380.00	0.00	173	16	498	3704	0.134449244060475	0.4249287669647	0.4249287669647	true	false	false
c45f0edd-8bbe-4b03-9a25-20c705f90a55	2026-09-29 11:31	2026-09-29 11:31	2026-09-29 11:31	CCL	CCL261120C00024000	call	24.0000	2026-11-20	2.0800	2.0600	2.1100	24.0000	20801.00	208.00	20593.00	100	5	1053	8189	0.128587129075589	0.429911059167633	0.429911059167633	true	false	false
bd6e4bd9-70b7-48b7-afb9-5f4e028cee70	2026-09-29 11:19	2026-09-29 11:19	2026-09-29 11:19	CCL	CCL261002C00025500	call	25.5000	2026-10-02	0.2900	0.2700	0.2900	24.7150	20851.00	20851.00	0.00	719	23	3555	653	5.44410413476263	0.661019210031671	0.661019210031671	false	false	false
6e9eed26-4fa3-48bb-a05f-af5fe75b9db0	2026-09-29 11:19	2026-09-29 11:19	2026-09-29 11:19	CCL	CCL261002C00025000	call	25.0000	2026-10-02	0.4600	0.4300	0.5000	24.7150	271538.00	262568.00	8970.00	5903	56	14452	3087	4.68156786524133	0.654259862520707	0.654259862520707	false	false	false
83eb8d63-92ba-4d86-b8ba-8c07f2f107e9	2026-09-29 10:59	2026-09-29 10:59	2026-09-29 10:59	CCL	CCL261002C00022500	call	22.5000	2026-10-02	2.5300	2.4800	2.5300	24.9666	25300.00	6578.00	0.00	100	9	1929	4074	0.473490427098675	0.793820725921194	0.793820725921194	false	false	false
c88b4686-df57-4f96-9d45-cb33784a3635	2026-09-29 10:38	2026-09-29 10:38	2026-09-29 10:38	CCL	CCL270115C00025000	call	25.0000	2027-01-15	2.5000	2.4700	2.5000	24.9980	25000.00	25000.00	0.00	100	5	654	5190	0.126011560693642	0.434834426402407	0.434834426402407	false	false	false
39b8796d-47c6-4149-86e0-f067775f6b33	2026-09-29 10:37	2026-09-29 10:37	2026-09-29 10:37	CCL	CCL261218C00025000	call	25.0000	2026-12-18	2.0200	2.0200	2.0500	24.8799	12120.00	0.00	12120.00	60	5	496	3100	0.16	0.424059053280525	0.424059053280525	false	false	false
2dda26bb-7955-45df-ba3b-7174518e751d	2026-09-29 10:33	2026-09-29 10:33	2026-09-29 10:33	CCL	CCL270319C00022000	call	22.0000	2027-03-19	4.6000	4.6000	5.0000	24.8300	18410.00	0.00	18410.00	40	6	41	422	0.0971563981042654	0.419448680097542	0.419448680097542	false	false	false
26dc7c1d-7d65-44d1-93e8-4374ecf7e25f	2026-09-29 10:31	2026-09-29 10:31	2026-09-29 10:31	CCL	CCL261120P00026000	put	26.0000	2026-11-20	2.2500	2.1800	2.3100	24.8717	18450.00	3600.00	12600.00	82	10	98	1922	0.0509885535900104	0.450983883004819	0.450983883004819	false	false	false
ad2b980f-202f-423d-8fa0-7b9d76dd5c1d	2026-09-29 10:25	2026-09-29 10:25	2026-09-29 10:25	CCL	CCL261002C00025500	call	25.5000	2026-10-02	0.3600	0.3200	0.4100	24.8350	13140.00	684.00	12456.00	365	9	2336	653	3.57733537519142	0.697881541770891	0.697881541770891	false	false	false
874b8619-a27d-461f-8985-fd4112d2c8fe	2026-09-29 10:20	2026-09-29 10:20	2026-09-29 10:20	CCL	CCL261002C00022000	call	22.0000	2026-10-02	3.0000	2.9500	3.0500	24.9650	14100.00	10500.00	3600.00	47	6	849	2042	0.415768854064643	0.800399179106379	0.800399179106379	false	false	false
18b0978b-6981-441e-a2bf-6157393795ad	2026-09-29 10:10	2026-09-29 10:10	2026-09-29 10:10	CCL	CCL261002C00025000	call	25.0000	2026-10-02	0.6400	0.5800	0.6400	24.0000	12800.00	12800.00	0.00	200	6	6195	3087	2.00680272108844	0.745494047122064	0.745494047122064	false	false	false
f85e46f7-2dee-461e-84a5-40af0deccbd9	2026-09-29 10:09	2026-09-29 10:09	2026-09-29 10:09	CCL	CCL261218C00023000	call	23.0000	2026-12-18	3.1500	3.1500	3.3000	24.8950	13230.00	0.00	13230.00	42	15	1244	8814	0.141139096891309	0.43061701095422	0.43061701095422	false	false	false
e3bad245-139b-4995-b9e4-01ac2619c4df	2026-09-29 10:09	2026-09-29 10:09	2026-09-29 10:09	CCL	CCL261218C00023000	call	23.0000	2026-12-18	3.1500	3.1500	3.3000	24.9000	143955.00	0.00	143955.00	457	6	1701	8814	0.192988427501702	0.429738668300973	0.429738668300973	false	false	false
db9ab2d9-fc38-4f05-ac1b-d1bea6278481	2026-09-29 10:08	2026-09-29 10:08	2026-09-29 10:08	CCL	CCL261218C00023000	call	23.0000	2026-12-18	3.2000	3.1500	3.3000	24.9299	120960.00	78720.00	42240.00	378	14	1175	8814	0.1333106421602	0.43692865456479	0.43692865456479	true	false	false