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:alert_rule = RepeatedHits×ticker = CL×

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

d3265fee-1453-49e7-ab4a-c22d83310fad	2026-09-21 14:31	2026-09-21 14:31	2026-09-21 14:31	CL	CL261016P00086000	put	86.0000	2026-10-16	1.7000	1.6000	1.7000	86.0000	29580.00	29580.00	0.00	174	28	339	0	0	0.211652355542901	0.211652355542901	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Defensive	68764128230.00	2026-10-30	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T18:32:54.184324Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
164d0166-dddc-4ec2-ba66-0eca62a57536	2026-09-21 13:31	2026-09-21 13:31	2026-09-21 13:31	CL	CL261218P00085000	put	85.0000	2026-12-18	3.1000	2.7000	3.1000	86.3100	20460.00	20460.00	0.00	66	5	71	141	0.50354609929078	0.244954400857226	0.244954400857226	false	false	false	true
a21fe961-7f95-4d9c-a8c8-d08d4ca0a652	2026-09-21 11:50	2026-09-21 11:50	2026-09-21 11:50	CL	CL261218C00085000	call	85.0000	2026-12-18	5.0000	4.8000	5.0000	86.7400	13000.00	13000.00	0.00	26	5	35	72	0.486111111111111	0.212780077339842	0.212780077339842	false	false	false	true
b2124b11-677e-4d08-b5ab-5092b621e1c1	2026-09-21 11:25	2026-09-21 11:24	2026-09-21 11:24	CL	CL261016P00086000	put	86.0000	2026-10-16	1.5000	1.4000	1.5000	86.6800	22800.00	22800.00	0.00	152	26	159	0	0	0.213564345393565	0.213564345393565	false	false	false	true	false
4abe59a0-9b81-49c7-a8d9-47edb3bceb99	2026-09-10 13:09	2026-09-10 13:09	2026-09-10 13:09	CL	CL270115P00085000	put	85.0000	2027-01-15	3.1000	3.1000	3.3000	88.0500	67270.00	0.00	67270.00	217	28	220	653	0.336906584992343	0.24394621508882	0.24394621508882	false	false	false	true
5ed8d1f3-b98e-4c01-a11a-9add41bb4f20	2026-09-08 10:58	2026-09-08 10:58	2026-09-08 10:58	CL	CL270319P00087500	put	87.5000	2027-03-19	5.2000	4.7000	5.2000	88.4000	134680.00	134680.00	0.00	259	25	963	151	6.37748344370861	0.258415373776621	0.258415373776621	false	false	false	true
7d9cad7d-78d4-4fb4-b173-f7454c478b03	2026-09-08 10:51	2026-09-08 10:51	2026-09-08 10:51	CL	CL270319P00087500	put	87.5000	2027-03-19	5.0000	4.7000	5.3000	88.5700	111500.00	71500.00	25500.00	223	14	223	151	1.47682119205298	0.253022983355556	0.253022983355556	true	false	false	true
37a6d768-2878-4f84-83fe-acf853040766	2026-08-26 10:40	2026-08-26 10:40	2026-08-26 10:40	CL	CL261016P00090000	put	90.0000	2026-10-16	1.9000	1.9000	2.0500	91.9250	105450.00	0.00	105450.00	555	18	555	120	4.625	0.217852358730232	0.217852358730232	false	false	false	true
756a6a0d-44e0-4ae6-a9a4-b8464c33d1f9	2026-08-21 14:58	2026-08-21 14:58	2026-08-21 14:58	CL	CL261120C00095000	call	95.0000	2026-11-20	2.4500	2.4500	2.9500	91.1550	159250.00	0.00	159250.00	650	35	650	160	4.0625	0.202473334475806	0.202473334475806	false	false	false	true
6f0f2fd8-e80c-4820-945a-107c5b1bc451	2026-08-20 10:36	2026-08-20 10:36	2026-08-20 10:36	CL	CL270319C00105000	call	105.0000	2027-03-19	1.8000	1.8000	1.8500	89.6150	64080.00	0.00	64080.00	356	9	7369	8176	0.901296477495108	0.215478381457366	0.215478381457366	false	false	false	true
91f37094-ac62-44d0-afc0-4df681619bcb	2026-08-20 10:35	2026-08-20 10:35	2026-08-20 10:35	CL	CL270319C00105000	call	105.0000	2027-03-19	1.8000	1.8000	2.0500	89.6700	71640.00	0.00	71640.00	398	6	6018	8176	0.73605675146771	0.214868766545975	0.214868766545975	false	false	false	true
a8973749-622b-4cf9-9781-a4d064d6c2be	2026-08-20 10:35	2026-08-20 10:35	2026-08-20 10:35	CL	CL270319C00105000	call	105.0000	2027-03-19	1.8000	1.8000	1.8500	89.6605	66600.00	0.00	66600.00	370	7	5620	8176	0.687377690802348	0.214974066801078	0.214974066801078	false	false	false	true
a8e40fa7-1084-497c-978a-161454cf2e83	2026-08-20 10:35	2026-08-20 10:35	2026-08-20 10:35	CL	CL270319C00105000	call	105.0000	2027-03-19	1.8500	1.8000	1.8500	89.7150	72145.00	18500.00	180.00	390	16	5250	8176	0.642123287671233	0.216780358318331	0.214369957495093	false	false	false	true
4ebb93c2-ac1b-46d5-a5f8-669c0181994e	2026-08-20 10:35	2026-08-20 10:35	2026-08-20 10:35	CL	CL270319C00105000	call	105.0000	2027-03-19	1.8500	1.7500	1.8500	89.7210	66970.00	4625.00	0.00	362	14	4846	8176	0.592710371819961	0.216713457225209	0.216713457225209	false	false	false	true
a23b16e0-ed0f-4424-bd7f-31082d80af63	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	CL	CL270319C00105000	call	105.0000	2027-03-19	1.7500	1.7500	2.0000	89.6450	73150.00	0.00	73150.00	418	8	3872	8176	0.473581213307241	0.212712489726347	0.212712489726347	false	false	false	true
98ee014b-baf1-41c8-9414-b3ce4e62e6e7	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	CL	CL270319C00105000	call	105.0000	2027-03-19	1.7500	1.7500	2.0000	89.6400	50750.00	0.00	50750.00	290	6	3454	8176	0.422455968688845	0.212767577603761	0.212767577603761	false	false	false	true
0f53037c-a3f3-42ba-bf20-9d5a735a431b	2026-08-20 10:33	2026-08-20 10:33	2026-08-20 10:33	CL	CL270319C00105000	call	105.0000	2027-03-19	1.8500	1.7000	1.8500	89.6700	71780.00	51800.00	0.00	388	15	2641	8176	0.323018590998043	0.217282098901734	0.217282098901734	false	false	false	true
152a9c8c-3b52-4049-b91f-1a5452b0db42	2026-08-20 10:32	2026-08-20 10:32	2026-08-20 10:32	CL	CL270319C00105000	call	105.0000	2027-03-19	1.7000	1.5500	1.8500	89.6450	60030.00	13620.00	3400.00	353	20	1783	8176	0.218077299412916	0.210259744510852	0.210259744510852	false	false	false	true
466df523-330e-4bcc-a477-44acf23c4f34	2026-08-20 10:32	2026-08-20 10:32	2026-08-20 10:32	CL	CL270319C00105000	call	105.0000	2027-03-19	1.9500	0.8500	1.9500	89.8750	60645.00	14820.00	0.00	311	16	312	8176	0.038160469667319	0.219745047671608	0.219745047671608	false	false	false	true