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:ticker = CLMT×sorted by created_at ↑×

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

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	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	5185995806.00	2026-11-06	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T15:40:17.489597Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
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
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
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
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
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
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
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	false
e5a946bb-4372-4169-91f1-b1aa8a3d3cbd	2026-09-22 10:11	2026-09-22 10:11	2026-09-22 10:11	CLMT	CLMT270115C00060000	call	60.0000	2027-01-15	7.6100	7.3000	8.4000	57.4400	304500.00	0.00	304500.00	400	20	423	1409	0.300212916962385	0.657000608432219	0.657000608432219	false	false	false	true	false
2257dd36-b91c-49f6-b262-71c5baae74c5	2026-09-22 15:32	2026-09-22 15:32	2026-09-22 15:32	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	9.5000	9.3000	10.0000	56.0000	23741.00	0.00	23741.00	25	10	112	1090	0.102752293577982	0.676144124083227	0.676144124083227	false	false	false	true	false
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	false
ec845ad8-d268-4a49-8b9a-bba577d0899e	2026-09-22 15:33	2026-09-22 15:33	2026-09-22 15:33	CLMT	CLMT270115C00065000	call	65.0000	2027-01-15	5.4600	5.3000	6.0000	56.0000	13640.00	0.00	13640.00	25	12	115	1557	0.0738599871547848	0.667111566195031	0.667111566195031	false	false	false	true	false
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
f95de1a6-39ca-428a-aba5-6a4bfff0ffc9	2026-09-22 15:52	2026-09-22 15:52	2026-09-22 15:52	CLMT	CLMT270115C00060000	call	60.0000	2027-01-15	6.9200	6.5000	7.3000	56.0200	10381.00	8312.00	689.00	15	10	495	1409	0.351312987934705	0.657711243259971	0.657711243259971	false	false	false	true	false