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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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 = CLX×

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

1a45b39c-e0c8-4097-a89e-08560560fa0a	2026-09-30 15:34	2026-09-30 15:34	2026-09-30 15:34	CLX	CLX261016C00085000	call	85.0000	2026-10-16	1.1000	1.0000	1.1500	81.3850	11329.00	8909.00	0.00	103	14	307	2793	0.109917651271035	0.353443575636814	0.353443575636814	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	9867970008.00	2026-11-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T19:37:24.384434Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
2bc6458e-2336-4155-8d68-578b15b0d3c0	2026-09-30 13:03	2026-09-30 13:03	2026-09-30 13:03	CLX	CLX270115P00080000	put	80.0000	2027-01-15	5.4000	5.4000	5.6000	81.6530	13510.00	0.00	13510.00	25	6	154	2995	0.0514190317195326	0.383613658960077	0.383613658960077	true	false	false
d3e95a5f-acc4-404d-8f45-22d149b9ed4b	2026-09-30 12:58	2026-09-30 12:58	2026-09-30 12:58	CLX	CLX270115P00080000	put	80.0000	2027-01-15	5.3000	5.3000	5.7000	81.0000	13260.00	0.00	13260.00	25	5	111	2995	0.0370617696160267	0.379992606691453	0.379992606691453	true	false	false
756422de-9299-4cac-8ee8-456414b47258	2026-09-30 12:47	2026-09-30 12:47	2026-09-30 12:47	CLX	CLX270416C00090000	call	90.0000	2027-04-16	5.3000	5.0000	5.7000	81.0000	14840.00	7950.00	6890.00	28	9	29	236	0.122881355932203	0.320573457130812	0.320573457130812	false	false	false
1e6daab4-25e2-4b8d-ba66-c89e45a72e40	2026-09-29 15:51	2026-09-29 15:51	2026-09-29 15:51	CLX	CLX280121P00075000	put	75.0000	2028-01-21	9.3000	9.3000	9.8000	81.2790	169261.00	0.00	169261.00	182	29	187	662	0.282477341389728	0.411874511342572	0.411874511342572	false	false	false
0c6af682-a4a8-4ef8-af04-57b78d9e743a	2026-09-29 14:31	2026-09-29 14:31	2026-09-29 14:31	CLX	CLX261120C00095000	call	95.0000	2026-11-20	0.8500	0.8500	0.9000	81.0000	11305.00	0.00	11305.00	133	16	267	568	0.470070422535211	0.364373779995123	0.364373779995123	false	false	false
7b72abeb-67ca-4eca-beb5-4fd5269e7f4e	2026-09-29 13:15	2026-09-29 13:15	2026-09-29 13:15	CLX	CLX280121C00080000	call	80.0000	2028-01-21	12.7000	11.9000	12.7000	81.5000	605790.00	605790.00	0.00	477	22	622	252	2.46825396825397	0.254984582419296	0.254984582419296	false	false	false
41f09621-73f7-470d-9c16-7a27e075bec8	2026-09-29 13:01	2026-09-29 13:00	2026-09-29 13:00	CLX	CLX261120P00080000	put	80.0000	2026-11-20	4.2000	4.1000	4.2000	81.0000	162540.00	162540.00	0.00	387	37	470	855	0.549707602339181	0.424145906995638	0.424145906995638	false	false	false
de8d393a-406f-49f9-bba7-9b8609abff43	2026-09-28 13:34	2026-09-28 13:34	2026-09-28 13:34	CLX	CLX261016P00080000	put	80.0000	2026-10-16	1.6000	1.4500	1.7000	81.0000	28960.00	28800.00	160.00	181	28	431	4165	0.103481392557023	0.331358141309793	0.331358141309793	false	false	false
de935720-37f4-4c01-8faa-897f5c6f9d1e	2026-09-28 11:21	2026-09-28 11:20	2026-09-28 11:20	CLX	CLX270115P00080000	put	80.0000	2027-01-15	5.6000	5.5000	5.6000	81.0000	42000.00	42000.00	0.00	75	6	82	2912	0.0281593406593407	0.385954115010735	0.385954115010735	false	false	false
8862c52c-db45-4967-a92f-fa08832650a9	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	CLX	CLX270115P00075000	put	75.0000	2027-01-15	3.3000	3.2000	3.3000	81.0000	16830.00	16830.00	0.00	51	13	81	1675	0.0483582089552239	0.382240998089913	0.382240998089913	false	false	false
f5cdeec0-8385-467a-87d9-0e8e50044e6f	2026-09-25 15:27	2026-09-25 15:27	2026-09-25 15:27	CLX	CLX270416C00095000	call	95.0000	2027-04-16	4.4000	4.3000	4.4000	83.0900	11000.00	11000.00	0.00	25	6	25	431	0.0580046403712297	0.319316297437639	0.319316297437639	false	false	false
8e5f5426-a345-4132-a9d9-87da224de6e6	2026-09-25 15:17	2026-09-25 15:17	2026-09-25 15:17	CLX	CLX270115P00080000	put	80.0000	2027-01-15	5.0000	4.9000	5.0000	82.9600	19000.00	19000.00	0.00	38	17	147	2860	0.0513986013986014	0.382053381221994	0.382053381221994	false	false	false
d3ea09de-04d6-492f-90cb-2ab34fa0e8a7	2026-09-25 14:49	2026-09-25 14:49	2026-09-25 14:49	CLX	CLX270115P00080000	put	80.0000	2027-01-15	5.0000	4.9000	5.1000	82.0000	15999.00	14999.00	500.00	32	15	109	2860	0.0381118881118881	0.380034820013107	0.379715283150698	false	false	false
b6c34863-f8f9-4d4b-96c5-6068cde63930	2026-09-24 13:19	2026-09-24 13:18	2026-09-24 13:18	CLX	CLX261120P00075000	put	75.0000	2026-11-20	1.8000	1.7000	1.8000	82.9539	22133.00	22133.00	0.00	123	30	143	430	0.332558139534884	0.396010425591031	0.396010425591031	false	false	false
2674cbc1-76a2-41be-94a5-247033557862	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	CLX	CLX261016C00085000	call	85.0000	2026-10-16	2.0000	1.7500	2.0000	83.0000	20000.00	20000.00	0.00	100	25	186	2092	0.0889101338432122	0.330391675943156	0.330391675943156	true	false	false
8de91c7a-dffc-4219-bb98-c70a6966fa27	2026-09-23 14:55	2026-09-23 14:55	2026-09-23 14:55	CLX	CLX261120P00080000	put	80.0000	2026-11-20	2.9500	2.9000	2.9500	84.7350	11504.00	11504.00	0.00	39	7	272	625	0.4352	0.395446998280434	0.395446998280434	false	false	false
86e804ca-0e1a-4f36-aa3b-61a436470e8f	2026-09-23 13:38	2026-09-23 13:38	2026-09-23 13:38	CLX	CLX261120P00080000	put	80.0000	2026-11-20	2.8000	2.7500	2.8000	85.2200	10640.00	10640.00	0.00	38	7	114	625	0.1824	0.395374562935844	0.395374562935844	false	false	false
e1a69e3d-6b4a-4a41-90bd-5f74fce69330	2026-09-23 10:41	2026-09-23 10:41	2026-09-23 10:41	CLX	CLX270416C00090000	call	90.0000	2027-04-16	7.1000	7.0000	7.6000	85.8700	33370.00	17750.00	15620.00	47	5	47	88	0.534090909090909	0.309746408911763	0.309746408911763	false	false	false
672a6507-d61e-4b75-bd54-453d73506a28	2026-09-22 14:37	2026-09-22 14:37	2026-09-22 14:37	CLX	CLX270416C00080000	call	80.0000	2027-04-16	12.1000	11.8000	12.1000	86.6100	39930.00	39930.00	0.00	33	13	52	49	1.06122448979592	0.283610173018095	0.283610173018095	false	false	false
c185dc63-be79-4828-ae47-9bfe74fb3b42	2026-09-22 14:32	2026-09-22 14:31	2026-09-22 14:31	CLX	CLX270416C00095000	call	95.0000	2027-04-16	5.5000	5.1000	5.7000	86.6800	28600.00	15950.00	12650.00	52	15	71	327	0.217125382262997	0.303551648836463	0.303551648836463	false	false	false
e0a9a76a-1e44-49d1-ac49-564f228fc594	2026-09-21 13:53	2026-09-21 13:53	2026-09-21 13:53	CLX	CLX270416C00090000	call	90.0000	2027-04-16	6.6000	6.2000	6.6000	85.2250	19800.00	19800.00	0.00	30	7	51	48	1.0625	0.30094559054528	0.30094559054528	false	false	false
173e275d-2db5-4757-8039-511cef6168e1	2026-09-21 11:48	2026-09-21 11:47	2026-09-21 11:47	CLX	CLX261016C00085000	call	85.0000	2026-10-16	2.4000	2.2500	2.4000	84.1000	35040.00	35040.00	0.00	146	15	1010	1192	0.847315436241611	0.308799142369297	0.308799142369297	false	false	false
bd9bdcf8-5a79-4b80-93bb-f0579e525f15	2026-09-18 15:53	2026-09-18 15:53	2026-09-18 15:53	CLX	CLX261120C00090000	call	90.0000	2026-11-20	2.3500	2.3000	2.3500	83.0000	11750.00	8930.00	0.00	50	11	543	429	1.26573426573427	0.332454044587478	0.332454044587478	false	false	false
13f2490f-e7ee-4488-bdc3-63267b7f2db9	2026-09-17 15:27	2026-09-17 15:27	2026-09-17 15:27	CLX	CLX261120C00090000	call	90.0000	2026-11-20	3.1000	2.9500	3.1000	85.2300	61993.00	61993.00	0.00	200	28	427	0	0	0.335392252312522	0.335392252312522	false	false	false
367b9cf9-eb98-4cae-83e2-f864e2f1c655	2026-09-17 15:12	2026-09-17 15:11	2026-09-17 15:11	CLX	CLX261120C00090000	call	90.0000	2026-11-20	3.1000	3.1000	3.2000	85.1100	12400.00	0.00	12400.00	40	8	97	0	0	0.338838054340423	0.338838054340423	false	false	false
20c8aea7-bfa1-46d4-af75-7437302eccc1	2026-09-17 14:59	2026-09-17 14:58	2026-09-17 14:58	CLX	CLX261120C00085000	call	85.0000	2026-11-20	5.0000	4.7000	5.0000	85.1300	50000.00	50000.00	0.00	100	17	193	0	0	0.326412486079354	0.326412486079354	false	false	false
fd39074d-644e-4989-8a2c-fe4d91811f06	2026-09-17 13:17	2026-09-17 13:17	2026-09-17 13:17	CLX	CLX261120C00085000	call	85.0000	2026-11-20	4.6000	4.5000	4.6000	84.4100	13800.00	13800.00	0.00	30	8	90	0	0	0.325639708202887	0.325639708202887	false	false	false
25a60745-f609-49cd-a2aa-c0d93eae267c	2026-09-16 14:01	2026-09-16 14:01	2026-09-16 14:01	CLX	CLX260918P00085000	put	85.0000	2026-09-18	0.5000	0.2000	0.5500	85.0000	12000.00	12000.00	0.00	240	8	326	1286	0.253499222395023	0.343238735765121	0.343238735765121	false	false	false
7832a4b9-c65f-466a-a21c-317fb7457deb	2026-09-16 13:28	2026-09-16 13:28	2026-09-16 13:28	CLX	CLX270416C00100000	call	100.0000	2027-04-16	4.2000	4.1000	4.3000	86.2800	27300.00	15120.00	12180.00	65	5	81	112	0.723214285714286	0.311644874662537	0.311644874662537	false	false	false
cec45d7c-3610-4ee4-b0c2-c05cb5d7120e	2026-09-16 10:45	2026-09-16 10:45	2026-09-16 10:45	CLX	CLX261016C00090000	call	90.0000	2026-10-16	1.9000	1.8500	1.9500	86.4300	57950.00	44650.00	8360.00	305	12	341	329	1.03647416413374	0.326032896020569	0.326032896020569	false	false	false
4164aacc-99ce-496b-89ab-b295652e47aa	2026-09-14 15:45	2026-09-14 15:45	2026-09-14 15:45	CLX	CLX270416P00075000	put	75.0000	2027-04-16	3.4000	3.3000	3.4000	89.0000	10200.00	10200.00	0.00	30	11	72	18	4	0.380164990758134	0.380164990758134	false	false	false
ee917a66-a0a3-4a06-812b-98f2f451e661	2026-09-14 10:20	2026-09-14 10:20	2026-09-14 10:20	CLX	CLX270319P00100000	put	100.0000	2027-03-19	16.0000	14.5000	16.8000	88.0000	302400.00	134400.00	168000.00	189	8	350	686	0.510204081632653	0.412835133890711	0.412835133890711	false	false	false
34ff0adb-61b1-46ea-afaa-b446d457dfbc	2026-09-11 14:18	2026-09-11 14:18	2026-09-11 14:18	CLX	CLX261016P00085000	put	85.0000	2026-10-16	2.0000	1.6500	2.1000	87.8700	196006.00	200.00	195806.00	980	47	1550	1806	0.858250276854928	0.312787903335415	0.315325091146624	false	false	false
6cb1c248-f265-4dd0-8495-f4df33d46f04	2026-09-11 11:23	2026-09-11 11:23	2026-09-11 11:23	CLX	CLX270115C00085000	call	85.0000	2027-01-15	7.3000	7.2000	7.5000	85.9100	67160.00	66430.00	730.00	92	17	185	178	1.03932584269663	0.315422612910933	0.315422612910933	false	false	false
296d9974-cd10-4fba-b595-f6e7595cfe5f	2026-09-11 11:05	2026-09-11 11:05	2026-09-11 11:05	CLX	CLX260918P00085000	put	85.0000	2026-09-18	1.1000	1.0000	1.2000	85.8400	19360.00	2420.00	16940.00	176	12	450	955	0.471204188481675	0.319901474600697	0.319901474600697	false	false	false
9c3af1ec-36de-48bd-b788-900b8aff29ba	2026-09-11 10:06	2026-09-11 10:06	2026-09-11 10:06	CLX	CLX260918P00085000	put	85.0000	2026-09-18	1.1000	0.9500	1.2000	85.8100	11550.00	110.00	11440.00	105	15	173	955	0.181151832460733	0.317296742923521	0.317296742923521	true	false	false
2da835fa-1667-45fe-8148-b2f1ba8c67de	2026-09-11 10:00	2026-09-11 10:00	2026-09-11 10:00	CLX	CLX260918C00085000	call	85.0000	2026-09-18	2.0000	2.0000	2.6500	85.8750	10600.00	0.00	10600.00	53	5	146	39	3.74358974358974	0.314459322163701	0.314459322163701	false	false	false
e0608c58-0e8c-4fda-bc92-34d920205afd	2026-09-11 09:53	2026-09-11 09:53	2026-09-11 09:53	CLX	CLX270115C00085000	call	85.0000	2027-01-15	7.4000	7.4000	7.8000	86.0000	44400.00	0.00	44400.00	60	5	66	178	0.370786516853933	0.303846404438006	0.303846404438006	false	false	false
b8773890-f074-4d13-b710-8cdb9e298b77	2026-09-10 15:22	2026-09-10 15:22	2026-09-10 15:22	CLX	CLX270115C00105000	call	105.0000	2027-01-15	2.1000	1.9000	2.1000	88.6400	32128.00	32128.00	0.00	153	33	206	1163	0.177128116938951	0.321248300684989	0.321248300684989	false	false	false
5fbde667-06cd-4b62-924e-0b7b838e3a39	2026-09-10 12:51	2026-09-10 12:50	2026-09-10 12:50	CLX	CLX280121C00110000	call	110.0000	2028-01-21	5.4000	5.4000	6.7000	89.0000	54000.00	0.00	54000.00	100	13	100	236	0.423728813559322	0.248116991779816	0.248116991779816	false	false	false
4645ce15-5c8b-44ce-93a6-f18435250748	2026-09-09 13:30	2026-09-09 13:30	2026-09-09 13:30	CLX	CLX260918C00090000	call	90.0000	2026-09-18	1.8000	1.8000	1.8500	89.9504	22860.00	0.00	22860.00	127	19	508	48	10.5833333333333	0.316423043032377	0.316423043032377	false	false	false
0e21dabc-e950-45bf-9ace-fc61ae3cb65f	2026-09-09 11:07	2026-09-09 11:07	2026-09-09 11:07	CLX	CLX260918C00090000	call	90.0000	2026-09-18	1.7000	1.6000	1.7500	89.6200	33830.00	33660.00	170.00	199	16	336	48	7	0.330530269814547	0.327943364954178	false	false	false
37b5e59d-badb-41d1-ab80-48ad7802b4d2	2026-09-09 10:44	2026-09-09 10:44	2026-09-09 10:44	CLX	CLX261016P00100000	put	100.0000	2026-10-16	10.5000	10.3000	10.6000	89.8700	11550.00	11550.00	0.00	11	6	16	788	0.0203045685279188	0.316849948061393	0.316849948061393	false	false	false
f5e4ef6b-447a-496c-bdd3-ae1ade3045b1	2026-09-09 10:41	2026-09-09 10:41	2026-09-09 10:41	CLX	CLX260918P00100000	put	100.0000	2026-09-18	10.3000	10.3000	10.5000	89.7900	11330.00	0.00	11330.00	11	5	21	8540	0.00245901639344262	0.4460696653434	0.4460696653434	false	false	false
14b9063d-a2ee-43ba-8c5c-49d40caf06a5	2026-09-08 11:24	2026-09-08 11:24	2026-09-08 11:24	CLX	CLX270416P00095000	put	95.0000	2027-04-16	10.1000	9.8000	11.0000	93.1600	170690.00	75750.00	94940.00	169	6	188	107	1.75700934579439	0.354220169286869	0.354220169286869	false	false	false
9a9d2680-afb9-41e8-a445-f4884b41c25c	2026-09-04 11:36	2026-09-04 11:36	2026-09-04 11:36	CLX	CLX261016P00105000	put	105.0000	2026-10-16	11.5000	11.4000	11.7000	93.7450	10350.00	9200.00	1150.00	9	5	13	443	0.0293453724604966	0.297822161187956	0.297822161187956	false	false	false
d598f2a3-c5df-4a31-8af3-863df5bb6b19	2026-09-04 09:53	2026-09-04 09:53	2026-09-04 09:53	CLX	CLX270319P00085000	put	85.0000	2027-03-19	5.1000	4.9000	6.0000	92.9000	16320.00	0.00	13770.00	32	11	35	175	0.2	0.357486738506743	0.357486738506743	false	false	false
4f6e86e4-8152-472d-8d58-a229a8106417	2026-09-02 11:32	2026-09-02 11:31	2026-09-02 11:31	CLX	CLX270416P00095000	put	95.0000	2027-04-16	9.2000	9.0000	9.2000	95.4800	14716.00	14716.00	0.00	16	10	51	6	8.5	0.361254658441503	0.360841656086368	false	false	false
5a009f3c-356a-4525-a602-04c5a089f09f	2026-09-01 15:39	2026-09-01 15:39	2026-09-01 15:39	CLX	CLX261016P00090000	put	90.0000	2026-10-16	1.8500	1.7000	1.8500	94.9600	58830.00	58830.00	0.00	318	35	559	1316	0.424772036474164	0.307977980656933	0.307977980656933	false	false	false