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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = CLMT260918C00055000×

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

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	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	5098976554.00	2026-11-06	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
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
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
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
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
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
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	false
dbf4c55a-8287-4e1a-998e-833538c03e6b	2026-09-01 10:28	2026-09-01 10:28	2026-09-01 10:28	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	0.9900	0.8500	1.1000	50.3550	19728.00	16072.00	3656.00	200	11	404	6027	0.0670316907250705	0.592752713159261	0.592752713159261	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	false
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	false
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	false
cfc0e9b8-f204-42c3-b500-e882b14f4663	2026-08-18 13:09	2026-08-18 13:09	2026-08-18 13:09	CLMT	CLMT260918C00055000	call	55.0000	2026-09-18	1.6500	1.5500	1.7000	49.7750	28380.00	24750.00	3630.00	172	33	219	3343	0.0655100209392761	0.598014882851317	0.598014882851317	true	false	false	true