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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = CLMT×

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

8003a110-4bff-4722-9a78-a3afaf80ce29	2026-09-22 15:39	2026-09-22 15:39	2026-09-22 15:39	CLMT	CLMT261120C00050000	call	50.0000	2026-11-20	9.1000	9.0000	9.5000	55.5400	48230.00	39130.00	9100.00	53	5	247	3199	0.0772116286339481	0.677103321852667	0.677103321852667	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	4959218362.00	2026-11-06	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:40:59.804437Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
ff8065f0-63c8-4441-9a5f-a3c16c2366ae	2026-09-22 15:32	2026-09-22 15:32	2026-09-22 15:32	CLMT	CLMT261120P00060000	put	60.0000	2026-11-20	8.1000	7.9000	8.4000	56.0000	23490.00	7290.00	16200.00	29	5	93	266	0.349624060150376	0.671212477731635	0.671212477731635	false	false	false	true
4922a0d3-08a0-4898-bcce-ab69b4d240fa	2026-09-22 10:06	2026-09-22 10:06	2026-09-22 10:06	CLMT	CLMT270115C00055000	call	55.0000	2027-01-15	9.7000	9.7000	10.3000	57.0600	508280.00	0.00	508280.00	524	12	524	2065	0.253753026634383	0.656318726212805	0.664068261280031	false	false	false	true
6472a036-0d5f-4778-a129-7bc2a147e911	2026-09-21 14:51	2026-09-21 14:51	2026-09-21 14:51	CLMT	CLMT270319C00050000	call	50.0000	2027-03-19	15.1500	14.8000	15.6000	57.8700	15150.00	0.00	12120.00	10	5	37	605	0.0611570247933884	0.68356340644315	0.68356340644315	false	false	false	true
30c12718-813c-49fc-a26e-13f288de7df6	2026-09-21 14:50	2026-09-21 14:50	2026-09-21 14:50	CLMT	CLMT261120C00060000	call	60.0000	2026-11-20	5.6000	5.5000	5.8000	57.0000	70000.00	56560.00	13440.00	125	5	159	1824	0.0871710526315789	0.679486045213739	0.678117322905297	false	false	false	true
6c7481e1-a831-4613-bbb7-257a5827c704	2026-09-21 13:51	2026-09-21 13:51	2026-09-21 13:51	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	10.7000	10.5000	10.7000	57.8950	12840.00	12840.00	0.00	12	5	169	883	0.191392978482446	0.689625553104728	0.689625553104728	false	false	false	true
b3885837-2792-4681-952c-b87ecb3ca7dd	2026-09-21 12:30	2026-09-21 12:30	2026-09-21 12:30	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	10.3000	9.9000	10.3000	57.0000	13390.00	13390.00	0.00	13	5	77	883	0.087202718006795	0.68464421368428	0.68464421368428	false	false	false	true
8fdf36f1-f13d-43a8-b7da-88f9cddefc11	2026-09-18 13:19	2026-09-18 13:19	2026-09-18 13:19	CLMT	CLMT270115C00065000	call	65.0000	2027-01-15	7.0400	6.7000	7.1000	58.7850	70361.00	70361.00	0.00	100	8	109	1400	0.0778571428571429	0.677905919192086	0.681641457588561	true	false	false	true
bdc1a932-6787-4bc3-9f02-8bc1c03e1121	2026-09-18 11:32	2026-09-18 11:32	2026-09-18 11:32	CLMT	CLMT261016C00070000	call	70.0000	2026-10-16	1.0500	1.0500	1.1500	59.0950	27615.00	0.00	27615.00	263	45	319	361	0.883656509695291	0.637389158798337	0.637389158798337	false	false	false	true
085593b0-ed78-412d-9856-5ebc20734d16	2026-09-17 12:38	2026-09-17 12:37	2026-09-17 12:37	CLMT	CLMT261120P00060000	put	60.0000	2026-11-20	7.1000	6.9000	7.1000	59.0650	36920.00	36920.00	0.00	52	17	86	113	0.761061946902655	0.693389154907681	0.693389154907681	false	false	false	true
239b9060-da32-4cb8-8a18-c51fdc13dedd	2026-09-17 12:21	2026-09-17 12:20	2026-09-17 12:20	CLMT	CLMT270115C00065000	call	65.0000	2027-01-15	7.2200	7.0000	7.3000	58.8300	18061.00	18061.00	0.00	25	5	191	1249	0.152922337870296	0.695500572935379	0.688811620780792	false	false	false	true
39b7907a-787e-425a-ab0f-5b02c8269b21	2026-09-17 11:26	2026-09-17 11:26	2026-09-17 11:26	CLMT	CLMT260918C00060000	call	60.0000	2026-09-18	0.6000	0.5500	0.6000	59.0000	21120.00	21120.00	0.00	352	5	518	2333	0.222031718816974	0.821686059110323	0.821686059110323	false	false	false	true
1502df1e-9ba7-4232-83e6-7f166ef6edaf	2026-09-16 15:51	2026-09-16 15:51	2026-09-16 15:51	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	3.5000	3.4000	3.5000	58.0000	211400.00	78750.00	0.00	604	8	1548	5195	0.297978825794033	0.475046794822065	0.475046794822065	false	false	false	true
aa5a8f62-33d4-4f86-ad85-9c9f5ac69571	2026-09-16 14:45	2026-09-16 14:45	2026-09-16 14:45	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	4.1000	4.1000	4.7000	58.9450	61500.00	0.00	61500.00	150	21	943	5195	0.181520692974013	0.728476528985909	0.728476528985909	true	false	false	true
0559d6be-f5d6-4f52-90ba-7aa1c0c949e0	2026-09-16 09:41	2026-09-16 09:41	2026-09-16 09:41	CLMT	CLMT261120C00060000	call	60.0000	2026-11-20	5.9000	5.5000	6.4000	57.3700	11800.00	2360.00	9440.00	20	6	22	1748	0.0125858123569794	0.707900077379503	0.707900077379503	false	false	false	true
7da06c89-30c1-4cae-b883-bbc80d52799b	2026-09-15 15:58	2026-09-15 15:58	2026-09-15 15:58	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	3.1000	3.0000	3.5000	57.0000	22320.00	620.00	21700.00	72	11	558	5231	0.106671764480979	0.752604357374302	0.757184001335692	true	false	false	true
6568d801-50cf-42b3-82bc-89544b0f065c	2026-09-15 15:24	2026-09-15 15:23	2026-09-15 15:23	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	3.2000	3.1000	3.5000	57.6500	46428.00	8000.00	38428.00	145	16	486	5231	0.0929076658382718	0.738979525759211	0.738979525759211	true	false	false	true
c5324927-4474-4979-8c46-fd0b40a67194	2026-09-15 14:53	2026-09-15 14:53	2026-09-15 14:53	CLMT	CLMT260918C00060000	call	60.0000	2026-09-18	0.7000	0.6000	0.7500	57.5200	14000.00	7980.00	2520.00	200	6	305	3451	0.0883801796580701	0.778111823154088	0.774880084930978	false	false	false	true
7b536d99-3dcc-4bfc-960f-9901cab9d4a9	2026-09-15 14:17	2026-09-15 14:17	2026-09-15 14:17	CLMT	CLMT270115C00070000	call	70.0000	2027-01-15	5.4000	5.2000	5.4000	57.3200	13500.00	13500.00	0.00	25	5	75	1068	0.0702247191011236	0.707174362639389	0.707174362639389	false	false	false	true
fc58ca69-113e-4e6b-8a5c-7c63adc3d83b	2026-09-14 11:07	2026-09-14 11:07	2026-09-14 11:07	CLMT	CLMT261016C00065000	call	65.0000	2026-10-16	1.4500	1.4500	1.6000	55.6900	10295.00	0.00	10295.00	71	15	77	163	0.47239263803681	0.655132818347116	0.655132818347116	false	false	false	true
e1591c04-dddf-460f-94ac-d0ce66caf0d0	2026-09-11 15:57	2026-09-11 15:57	2026-09-11 15:57	CLMT	CLMT281215C00080000	call	80.0000	2028-12-15	16.8000	15.8000	17.7000	56.6500	42000.00	36960.00	5040.00	25	6	35	0	0	0.652455215010514	0.652455215010514	false	false	false	true
9debcfed-6d24-487c-9674-a14e4a99f1e2	2026-09-11 14:46	2026-09-11 14:46	2026-09-11 14:46	CLMT	CLMT261016C00049000	call	49.0000	2026-10-16	9.4000	9.4000	10.1000	57.2300	46060.00	0.00	46060.00	49	11	51	2	25.5	0.581368974596249	0.581368974596249	false	false	false	true
04650062-cffa-45f2-a4d4-0b8851460773	2026-09-11 12:04	2026-09-11 12:04	2026-09-11 12:04	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	3.5000	3.3000	3.5000	57.7200	99750.00	99750.00	0.00	285	13	1701	5913	0.287671232876712	0.555007873606191	0.57563394968238	false	false	false	true
5e68167e-dbc7-4c2a-98f0-737b97c476c9	2026-09-11 11:56	2026-09-11 11:55	2026-09-11 11:55	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	3.6000	3.4000	3.8000	57.8700	107640.00	9000.00	98640.00	299	14	1216	5913	0.205648570945375	0.570738779833978	0.570738779833978	true	false	false	true
48f335d7-8fed-4e7f-9246-98418e70b2cd	2026-09-11 11:51	2026-09-11 11:50	2026-09-11 11:50	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	3.7000	3.6000	3.8000	58.0222	141340.00	66230.00	75110.00	382	15	792	5913	0.133942161339422	0.564304692792038	0.564304692792038	true	false	false	true
fa3b6191-9d1c-484b-b5aa-9c7479d109b7	2026-09-11 11:50	2026-09-11 11:50	2026-09-11 11:50	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	3.8000	3.6000	3.9000	58.2500	48640.00	9500.00	39140.00	128	11	360	5913	0.060882800608828	0.531340956564338	0.531340956564338	true	false	false	true
4a8a5656-efd0-47e2-b63f-23402283042d	2026-09-11 11:50	2026-09-11 11:50	2026-09-11 11:50	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	4.0000	3.5000	4.1000	58.3200	86000.00	20000.00	62400.00	215	20	232	5913	0.039235582614578	0.593052622872193	0.593052622872193	true	false	false	true
ce82bdcf-e2b8-4216-8bb4-0c3149986f4d	2026-09-10 10:13	2026-09-10 10:13	2026-09-10 10:13	CLMT	CLMT261016C00055000	call	55.0000	2026-10-16	4.6000	4.6000	4.9000	55.5550	15180.00	0.00	15180.00	33	5	70	482	0.145228215767635	0.610073770984863	0.610073770984863	false	false	false	true
052d88e5-685c-4e60-be24-e7a29eb6c2b1	2026-09-08 13:42	2026-09-08 13:42	2026-09-08 13:42	CLMT	CLMT270115C00050000	call	50.0000	2027-01-15	10.8000	10.3000	11.0000	54.2850	10800.00	2160.00	8640.00	10	5	34	3099	0.0109712810584059	0.661254797709091	0.661254797709091	false	false	false	true
f36a83c8-de0a-44a4-b7ab-cef1453314b9	2026-09-04 11:53	2026-09-04 11:52	2026-09-04 11:52	CLMT	CLMT270319C00075000	call	75.0000	2027-03-19	4.8000	4.7000	4.8000	53.4900	96000.00	96000.00	0.00	200	11	212	223	0.95067264573991	0.673362822161973	0.673362822161973	true	false	false	true
9c2a9d71-7986-4ab7-b379-99f58736c842	2026-09-03 11:19	2026-09-03 11:19	2026-09-03 11:19	CLMT	CLMT261120C00055000	call	55.0000	2026-11-20	6.6000	6.1000	6.7000	54.3800	62040.00	58080.00	3960.00	94	15	214	2291	0.0934089917066783	0.667764962690067	0.667764962690067	false	false	false	true
373451e1-7c59-47e3-8bad-3244b15ed7b2	2026-09-03 11:16	2026-09-03 11:15	2026-09-03 11:15	CLMT	CLMT260918P00055000	put	55.0000	2026-09-18	3.1000	3.0000	3.1000	54.1300	31000.00	31000.00	0.00	100	5	105	20	5.25	0.610486085686113	0.610486085686113	false	false	false	true
e1434cf4-8689-4c81-84cc-4bf133f8b489	2026-09-03 11:15	2026-09-03 11:15	2026-09-03 11:15	CLMT	CLMT270115C00075000	call	75.0000	2027-01-15	3.2000	3.0500	3.3000	53.9250	31360.00	31360.00	0.00	98	5	233	1337	0.174270755422588	0.672510226357074	0.672510226357074	false	false	false	true
700a4567-ee82-4ea7-bc42-5808fbc5b54b	2026-09-03 11:08	2026-09-03 11:08	2026-09-03 11:08	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	8.5000	8.0000	9.0000	54.1200	10200.00	2550.00	5950.00	12	5	37	147	0.251700680272109	0.648933129651921	0.648933129651921	false	false	false	true
4fe4cc17-29b7-4788-829a-6ae6776f9657	2026-09-03 10:54	2026-09-03 10:54	2026-09-03 10:54	CLMT	CLMT261120C00055000	call	55.0000	2026-11-20	6.7000	6.3000	6.7000	54.4950	14070.00	14070.00	0.00	21	8	78	2291	0.0340462680052379	0.671361145943007	0.671361145943007	false	false	false	true
82f2f153-2d4d-4ec7-a9a8-7a4ccc53e645	2026-09-02 15:35	2026-09-02 15:34	2026-09-02 15:34	CLMT	CLMT260918P00048000	put	48.0000	2026-09-18	0.7500	0.6500	0.7500	53.3500	13275.00	13275.00	0.00	177	32	454	388	1.17010309278351	0.619640021219174	0.619640021219174	false	false	false	true
ca006a6d-a357-404e-a7a0-689bbaeb9303	2026-09-02 15:00	2026-09-02 15:00	2026-09-02 15:00	CLMT	CLMT271217C00075000	call	75.0000	2027-12-17	10.3000	9.5000	10.3000	53.8950	103000.00	103000.00	0.00	100	14	413	1	413	0.636184615683372	0.636184615683372	false	false	false	true
8e4c733a-74a2-408f-8e70-81ca05e506a4	2026-09-02 14:59	2026-09-02 14:59	2026-09-02 14:59	CLMT	CLMT271217C00075000	call	75.0000	2027-12-17	10.0000	8.9000	10.0000	53.6700	58000.00	58000.00	0.00	58	6	172	1	172	0.628397246679148	0.628397246679148	false	false	false	true
acd860a4-ef96-419d-ae88-a3a52a7f70c4	2026-09-02 14:23	2026-09-02 14:22	2026-09-02 14:22	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	2.0900	2.0500	2.1500	53.3100	32620.00	26880.00	5740.00	156	12	1616	6684	0.241771394374626	0.614653694806283	0.614653694806283	false	false	false	true
f525389e-0f9b-43d0-91a0-65feb0da3b31	2026-09-02 14:08	2026-09-02 14:07	2026-09-02 14:07	CLMT	CLMT270115C00050000	call	50.0000	2027-01-15	10.2000	10.1000	10.3000	53.3900	10200.00	0.00	8160.00	10	5	103	3233	0.031858954531395	0.64432239849008	0.64432239849008	false	false	false	true
e5e86948-5a83-4eb4-a65e-7aeab3f8c2da	2026-09-02 14:07	2026-09-02 14:07	2026-09-02 14:07	CLMT	CLMT270115C00075000	call	75.0000	2027-01-15	2.9500	2.7000	2.9500	53.2400	29500.00	29500.00	0.00	100	15	812	324	2.50617283950617	0.664430062069972	0.664430062069972	true	false	false	true
dcb79b5f-ba78-4203-bb7a-c8bac61e0b28	2026-09-02 13:56	2026-09-02 13:55	2026-09-02 13:55	CLMT	CLMT270115C00050000	call	50.0000	2027-01-15	10.0000	9.7000	10.0000	53.1550	10000.00	10000.00	0.00	10	5	92	3233	0.0284565419115373	0.640443135318546	0.640443135318546	false	false	false	true
6a9987b3-7606-4c18-a73c-c91675f3a3e8	2026-09-02 13:36	2026-09-02 13:35	2026-09-02 13:35	CLMT	CLMT261120C00075000	call	75.0000	2026-11-20	1.5000	1.5000	1.6000	53.1800	45000.00	0.00	45000.00	300	7	735	70	10.5	0.685318550467235	0.685318550467235	false	false	false	true
a6b34c71-7118-42b6-9e93-388be1737d8c	2026-09-02 12:06	2026-09-02 12:06	2026-09-02 12:06	CLMT	CLMT261016P00050000	put	50.0000	2026-10-16	3.1000	2.8500	3.1000	52.6100	41535.00	41535.00	0.00	134	23	151	79	1.91139240506329	0.618491146784189	0.618491146784189	false	false	false	true
111fe659-5661-4abd-9196-547be7a49ea2	2026-09-02 10:39	2026-09-02 10:39	2026-09-02 10:39	CLMT	CLMT270219C00075000	call	75.0000	2027-02-19	3.5000	3.1000	3.5000	52.5100	35350.00	35350.00	0.00	101	5	151	4	37.75	0.650378162418607	0.650378162418607	false	false	false	true
3da6d2bb-e8c8-4935-951d-b8810900f63d	2026-09-01 13:23	2026-09-01 13:23	2026-09-01 13:23	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	1.4000	1.1500	1.4000	50.8600	31920.00	31920.00	0.00	228	7	1004	6027	0.166583706653393	0.659193988020699	0.659193988020699	true	false	false	true
79661c2b-a4b6-4a61-b462-682ab6252c6f	2026-09-01 13:17	2026-09-01 13:17	2026-09-01 13:17	CLMT	CLMT260918P00050000	put	50.0000	2026-09-18	2.2000	2.0500	2.2000	50.6450	44660.00	44660.00	0.00	203	18	259	260	0.996153846153846	0.589599903310796	0.589599903310796	false	false	false	true
61a1506b-5700-490f-b1d3-b01440f333f1	2026-08-31 13:53	2026-08-31 13:53	2026-08-31 13:53	CLMT	CLMT261120P00043000	put	43.0000	2026-11-20	3.1000	3.1000	3.4000	47.0000	71920.00	0.00	71920.00	232	25	653	1667	0.391721655668866	0.6078972258728	0.6078972258728	true	false	false	true
05b247a7-7fc1-4fea-a216-de3f922eda47	2026-08-31 13:17	2026-08-31 13:17	2026-08-31 13:17	CLMT	CLMT261120P00043000	put	43.0000	2026-11-20	3.2000	3.2000	3.4000	47.0950	22400.00	0.00	22400.00	70	12	171	1667	0.102579484103179	0.610620119081354	0.610620119081354	true	false	false	true
c94bd07f-c6ba-4da2-b33a-8d8ff718fdb9	2026-08-31 10:22	2026-08-31 10:22	2026-08-31 10:22	CLMT	CLMT270115C00055000	call	55.0000	2027-01-15	4.5400	4.1000	4.9000	46.8250	11343.00	3608.00	5460.00	25	5	25	1514	0.0165125495376486	0.626477874327287	0.626477874327287	false	false	false	true