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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	5108645360.00	2026-11-06	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T18:53:27.633876Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
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	false
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	false
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	false
0b47bcb2-a516-41bd-9e85-14436365984e	2026-09-18 13:49	2026-09-18 13:49	2026-09-18 13:49	CLMT	CLMT261120C00055000	call	55.0000	2026-11-20	8.5400	8.5000	9.0000	58.8100	298778.00	0.00	298778.00	350	12	473	2378	0.198906644238856	0.655315390867567	0.672701849841337	false	false	false	true	false
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	false
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	false
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	false
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	false
19ec89ba-1d85-4072-8847-c8c0bf23c5f5	2026-09-17 11:54	2026-09-17 11:54	2026-09-17 11:54	CLMT	CLMT260918C00060000	call	60.0000	2026-09-18	0.4500	0.4000	0.6500	58.9000	10944.00	1125.00	9819.00	243	22	1094	2333	0.46892413201886	0.71877419057438	0.71877419057438	true	false	false	true	false
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	false
e550f388-59ca-40d1-99d1-c0cb6289e00c	2026-09-17 10:32	2026-09-17 10:32	2026-09-17 10:32	CLMT	CLMT270115C00065000	call	65.0000	2027-01-15	7.0900	6.8000	7.2000	58.5800	24800.00	24090.00	710.00	35	14	161	1249	0.128903122497998	0.686011184930338	0.689744345758341	false	false	false	true	false
d4051354-039d-490f-92ef-09d5adfab6cc	2026-09-17 10:31	2026-09-17 10:31	2026-09-17 10:31	CLMT	CLMT270115C00065000	call	65.0000	2027-01-15	6.9900	6.7000	7.0000	58.5150	64284.00	64284.00	0.00	92	17	126	1249	0.100880704563651	0.680184195899738	0.68463765495702	true	false	false	true	false
4370ac11-f6e8-48c3-891e-3ac0dec79102	2026-09-16 15:52	2026-09-16 15:51	2026-09-16 15:51	CLMT	CLMT260918C00060000	call	60.0000	2026-09-18	0.5000	0.5000	0.8500	58.0000	50060.00	0.00	50060.00	1000	24	1373	3485	0.393974175035868	0.66284848914036	0.676492138004237	true	false	false	true	false
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	false
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	false
a77b00dc-ac56-4e48-bdad-03f145a6524b	2026-09-16 11:52	2026-09-16 11:52	2026-09-16 11:52	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	3.8000	3.7000	4.0000	58.7150	52834.00	0.00	52834.00	139	24	516	5195	0.0993262752646776	0.591276930775187	0.591276930775187	true	false	false	true	false
a2ebc19c-5956-4511-bdd8-bd84575a1182	2026-09-16 11:51	2026-09-16 11:51	2026-09-16 11:51	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	4.0100	3.5000	4.3000	58.9000	114578.00	20000.00	94578.00	286	42	302	5195	0.0581328200192493	0.63971096984747	0.63971096984747	true	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
06996ec5-be14-4342-9c56-0a752baadd5a	2026-09-11 15:41	2026-09-11 15:41	2026-09-11 15:41	CLMT	CLMT270115C00065000	call	65.0000	2027-01-15	5.9400	5.7000	6.4000	56.1350	11872.00	0.00	11872.00	20	14	63	1198	0.0525876460767947	0.675370109906501	0.675370109906501	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
f754d5ab-053c-40a4-8eb5-f8fb4d798815	2026-09-11 11:40	2026-09-11 11:39	2026-09-11 11:39	CLMT	CLMT270115C00070000	call	70.0000	2027-01-15	5.5500	5.4000	5.8000	58.1150	22192.00	0.00	22192.00	40	6	76	57	1.33333333333333	0.684073398899	0.684073398899	false	false	false	true	false
efe50ea8-0006-4099-bdc0-b455f97c1957	2026-09-10 10:26	2026-09-10 10:26	2026-09-10 10:26	CLMT	CLMT271217C00075000	call	75.0000	2027-12-17	11.5900	11.2000	12.2000	55.6100	11594.00	9274.00	2320.00	10	6	16	1141	0.014022787028922	0.659574642203341	0.658773438183473	false	false	false	true	false
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	false
83354507-824e-41dc-a6de-5e5fa025baf4	2026-09-09 09:41	2026-09-09 09:41	2026-09-09 09:41	CLMT	CLMT280121C00050000	call	50.0000	2028-01-21	19.0900	18.1000	19.7000	54.5600	80160.00	22860.00	57300.00	42	5	48	1442	0.0332871012482663	0.649963197900632	0.652279843303286	false	false	false	true	false
93c95e35-ff65-4a54-ad54-df0435b28082	2026-09-08 13:57	2026-09-08 13:57	2026-09-08 13:57	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	8.7100	8.5500	9.0000	54.2250	30501.00	0.00	30501.00	35	6	165	322	0.512422360248447	0.668141075360869	0.668141075360869	false	false	false	true	false
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	false
e8182f78-a248-4b5e-8358-5526b273909b	2026-09-08 12:22	2026-09-08 12:21	2026-09-08 12:21	CLMT	CLMT271217C00075000	call	75.0000	2027-12-17	10.9000	10.3000	11.2000	54.2000	119900.00	119900.00	0.00	110	1	310	823	0.376670716889429	0.659337546479771	0.659337546479771	false	true	false	true	false
e6c97d09-3760-4397-9935-144575ea4d8b	2026-09-08 11:26	2026-09-08 11:26	2026-09-08 11:26	CLMT	CLMT261120C00060000	call	60.0000	2026-11-20	4.2500	4.1000	4.3000	53.8450	21255.00	21255.00	0.00	50	6	304	1149	0.264577893820714	0.669803326914215	0.669803326914215	false	false	false	true	false
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	false
97667367-d8b1-49c5-aa52-abff39443c27	2026-09-03 14:59	2026-09-03 14:59	2026-09-03 14:59	CLMT	CLMT270115C00050000	call	50.0000	2027-01-15	10.1800	9.9000	10.7000	53.2300	50883.00	0.00	50883.00	50	5	168	3136	0.0535714285714286	0.651542384291642	0.651542384291642	false	false	false	true	false
936cc7e5-d1c0-4b48-807b-7214ff5f99d6	2026-09-03 12:57	2026-09-03 12:57	2026-09-03 12:57	CLMT	CLMT271217C00075000	call	75.0000	2027-12-17	10.0800	10.0000	10.1000	53.1900	10079.00	9075.00	1004.00	10	5	301	538	0.559479553903346	0.640473057062486	0.640473057062486	false	false	false	true	false
5b8b233d-7d51-466d-906b-9b96e0dbc86b	2026-09-03 11:52	2026-09-03 11:52	2026-09-03 11:52	CLMT	CLMT270115C00055000	call	55.0000	2027-01-15	8.0800	7.9000	8.3000	53.4300	24242.00	4050.00	14522.00	30	11	58	1587	0.0365469439193447	0.652962190383264	0.656100374550036	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false