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 = RepeatedHitsAscendingFill×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	expiry

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	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	5185995806.00	2026-11-06	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T17:59:53.998874Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
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
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
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
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
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
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
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
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
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
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
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
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
85c9e44f-ec9a-41c0-b96f-9872af16c6c1	2026-09-02 14:02	2026-09-02 14:02	2026-09-02 14:02	CLMT	CLMT270115C00075000	call	75.0000	2027-01-15	2.9100	2.7500	2.9500	53.2200	28768.00	28768.00	0.00	99	14	112	324	0.345679012345679	0.657448834627721	0.657448834627721	false	false	false	true
29ceecf8-ac60-46a1-a8d4-1dc102d867fd	2026-09-02 11:37	2026-09-02 11:37	2026-09-02 11:37	CLMT	CLMT261120C00055000	call	55.0000	2026-11-20	5.7100	5.4000	5.8000	52.7400	17134.00	17134.00	0.00	30	11	37	2262	0.0163572060123784	0.660455410635598	0.660455410635598	false	false	false	true
c22bf81f-2081-4796-8e87-97a45dacca17	2026-09-02 10:00	2026-09-02 10:00	2026-09-02 10:00	CLMT	CLMT270115C00060000	call	60.0000	2027-01-15	5.6000	5.2000	5.6000	52.2750	35836.00	35836.00	0.00	64	7	101	741	0.136302294197031	0.639832827589281	0.639832827589281	false	false	false	true
2aefb22b-d293-4755-b665-434eb1f7c5d3	2026-09-02 09:48	2026-09-02 09:48	2026-09-02 09:48	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	7.8100	7.2000	8.7000	52.8050	11711.00	0.00	11711.00	15	6	23	132	0.174242424242424	0.641236980809456	0.641236980809456	false	false	false	true
67eb2f8c-4006-495f-a960-12052d111718	2026-08-31 15:49	2026-08-31 15:49	2026-08-31 15:49	CLMT	CLMT260918C00050000	call	50.0000	2026-09-18	2.3600	2.1000	2.4000	49.3700	18894.00	18894.00	0.00	80	8	196	898	0.21826280623608	0.591424465870023	0.591424465870023	false	false	false	true
89418d53-0f3b-4874-a6fc-a2eeaf203d99	2026-08-28 09:31	2026-08-28 09:31	2026-08-28 09:31	CLMT	CLMT261016C00045000	call	45.0000	2026-10-16	5.3500	4.5000	5.5000	47.0400	39578.00	38510.00	1068.00	74	8	74	3	24.6666666666667	0.6071513946961	0.619447211564403	false	false	false	true
a2a29d5a-dea4-4fa2-8c21-a1fa54b0af3c	2026-08-25 14:58	2026-08-25 14:58	2026-08-25 14:58	CLMT	CLMT270115C00050000	call	50.0000	2027-01-15	6.3600	6.3000	6.6000	47.1100	12714.00	0.00	12714.00	20	6	442	2349	0.188165176670924	0.611643397261001	0.617611989776164	false	false	false	true
951f91a5-365b-431c-ad35-deee2e2446b8	2026-08-24 13:41	2026-08-24 13:41	2026-08-24 13:41	CLMT	CLMT261120P00040000	put	40.0000	2026-11-20	2.6000	2.5000	2.6000	46.4700	25972.00	25972.00	0.00	100	5	110	378	0.291005291005291	0.6355756532769	0.6355756532769	false	false	false	true
e71bfc50-a1ff-4c59-94f4-0eeaf5ab521c	2026-08-24 11:24	2026-08-24 11:24	2026-08-24 11:24	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	0.8800	0.6500	0.9000	47.1250	43900.00	43900.00	0.00	500	10	2001	4474	0.44725078229772	0.639292426155099	0.639292426155099	false	false	false	true
4668287b-f1db-4097-ade5-32e7cc06c9b8	2026-08-24 10:36	2026-08-24 10:36	2026-08-24 10:36	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	0.7500	0.7500	0.9500	47.1700	37292.00	0.00	37292.00	497	36	1000	4474	0.223513634331694	0.606863730322191	0.610576767889031	true	false	false	true
474999b0-6972-4ca8-8336-ac540a4886d4	2026-08-21 12:52	2026-08-21 12:52	2026-08-21 12:52	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	1.2800	1.1000	1.3000	49.1600	27947.00	27947.00	0.00	219	5	239	3895	0.0613607188703466	0.588981987817252	0.588981987817252	false	false	false	true
c8c99c2e-5e96-4c1e-95d2-ccb0d83c84e4	2026-08-19 15:36	2026-08-19 15:36	2026-08-19 15:36	CLMT	CLMT270115C00060000	call	60.0000	2027-01-15	4.3000	4.3000	4.6000	48.9400	54626.00	0.00	54626.00	127	21	234	575	0.40695652173913	0.616335749642167	0.617169254511569	false	false	false	true