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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×sector = Energy×

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

a6157d47-ec3d-43a3-973f-1e2601bf9b2c	2026-09-25 12:09	2026-09-25 12:09	2026-09-25 12:09	XOM	XOM261002P00160000	put	160.0000	2026-10-02	2.3400	2.2700	2.3800	160.2550	26715.00	24141.00	2574.00	114	20	901	559	1.61180679785331	0.287756524266549	0.285490457448264	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Energy	660331941656.00	2026-10-30	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T16:10:39.655295Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
d4df021b-8541-4c96-8891-1074d090be48	2026-09-25 12:09	2026-09-25 12:08	2026-09-25 12:08	HAL	HAL261120P00033000	put	33.0000	2026-11-20	2.0400	1.9800	2.0400	32.6000	16116.00	16116.00	0.00	79	9	103	788	0.130710659898477	0.380864872211992	0.380864872211992	true	false	false
9c8d4503-85c3-4a00-9379-4bd85408cace	2026-09-25 12:07	2026-09-25 12:07	2026-09-25 12:07	UEC	UEC270115P00009000	put	9.0000	2027-01-15	0.9800	0.9800	1.0000	9.6500	16366.00	0.00	16366.00	167	21	991	3783	0.261961406291303	0.653047032313204	0.653047032313204	false	false	false
0fc224a3-ae37-4f7b-bcd9-28d288385f20	2026-09-25 12:06	2026-09-25 12:06	2026-09-25 12:06	UEC	UEC270115P00009000	put	9.0000	2027-01-15	0.9900	0.9900	1.0800	9.6250	10098.00	0.00	10098.00	102	16	824	3783	0.217816547713455	0.653785399703567	0.653785399703567	false	false	false
5ad82508-2598-4f9e-b6d3-cdd531ee1e83	2026-09-25 12:03	2026-09-25 12:03	2026-09-25 12:03	UUUU	UUUU270115C00013000	call	13.0000	2027-01-15	1.3600	1.1800	1.3600	11.5350	136000.00	136000.00	0.00	1000	17	1001	745	1.34362416107383	0.72559415774482	0.72559415774482	true	false	false
1bd9564d-8eef-4c5b-972b-131438beaa72	2026-09-25 12:03	2026-09-25 12:03	2026-09-25 12:03	VLO	VLO270319P00250000	put	250.0000	2027-03-19	6.2000	5.8000	6.6000	375.9250	12400.00	620.00	620.00	20	5	20	77	0.25974025974026	0.520533293917089	0.520533293917089	false	false	false
7ee07f55-c7a2-4058-b172-eeba3f335f69	2026-09-25 12:03	2026-09-25 12:02	2026-09-25 12:02	GLND	GLND261016C00006000	call	6.0000	2026-10-16	0.9000	0.9000	1.1000	5.9033	21520.00	0.00	21520.00	238	13	3690	1444	2.55540166204986	1.66617282279824	1.68290339657111	false	false	false
26c89369-7c25-4da2-9f6a-a6a0230b6bf0	2026-09-25 11:58	2026-09-25 11:58	2026-09-25 11:58	CCJ	CCJ261218C00100000	call	100.0000	2026-12-18	4.1500	3.9500	4.1500	88.6100	128235.00	128235.00	0.00	309	20	322	1752	0.1837899543379	0.467777818474758	0.466221835299739	false	false	false
bd8bb11d-aab2-4dba-a282-292a28b619b2	2026-09-25 11:58	2026-09-25 11:58	2026-09-25 11:58	UEC	UEC270115P00009000	put	9.0000	2027-01-15	1.0000	1.0000	1.0300	9.6000	10500.00	0.00	10500.00	105	6	628	3783	0.166005815490352	0.654489699537094	0.654489699537094	false	false	false
5bc37b2e-3b5c-4a54-b15f-c8e2f0f8689e	2026-09-25 11:58	2026-09-25 11:58	2026-09-25 11:58	CVX	CVX270617C00220000	call	220.0000	2027-06-17	13.6500	13.6500	14.3500	205.6050	28665.00	0.00	28665.00	21	5	21	2544	0.00825471698113208	0.240211345853448	0.240211345853448	false	false	false
99317039-c5a4-49e8-be69-75419c31c7fa	2026-09-25 11:57	2026-09-25 11:57	2026-09-25 11:57	ENB	ENB270115C00050000	call	50.0000	2027-01-15	0.8000	0.7000	0.8000	46.7450	48000.00	48000.00	0.00	600	5	1009	3902	0.258585340850846	0.170506273717034	0.170506273717034	false	true	false
a524eca1-76a6-4498-8cad-6638021887ce	2026-09-25 11:57	2026-09-25 11:57	2026-09-25 11:57	XOM	XOM261002P00160000	put	160.0000	2026-10-02	1.9100	1.7500	1.9500	161.0750	26351.00	13371.00	12980.00	138	20	478	559	0.855098389982111	0.280855992884028	0.277798520234927	true	false	false
04459936-1956-4d67-ad6a-201ad5373242	2026-09-25 11:57	2026-09-25 11:57	2026-09-25 11:57	OXY	OXY280121C00080000	call	80.0000	2028-01-21	3.4000	3.4000	3.6000	57.0900	12240.00	0.00	12240.00	36	11	59	2027	0.0291070547607301	0.329945865669882	0.329945865669882	false	false	false
cc4026ac-1572-42a5-a928-91bac9cdcdf8	2026-09-25 11:52	2026-09-25 11:52	2026-09-25 11:52	CVX	CVX261002P00202500	put	202.5000	2026-10-02	1.4300	1.2500	1.4600	206.0000	179316.00	178760.00	556.00	1255	85	1316	512	2.5703125	0.272523733436797	0.267532173925662	false	false	false
888285c7-f74a-4456-b251-b0dc4042af77	2026-09-25 11:49	2026-09-25 11:49	2026-09-25 11:49	SLB	SLB261016C00052000	call	52.0000	2026-10-16	1.7400	1.3300	1.8100	51.8000	41795.00	11867.00	29928.00	240	35	242	312	0.775641025641026	0.360396602440452	0.358893476012447	false	false	false
6d7b5ff0-9381-4705-9536-881f4fddefbc	2026-09-25 11:49	2026-09-25 11:49	2026-09-25 11:49	OXY	OXY261030C00058000	call	58.0000	2026-10-30	2.1100	1.9400	2.2400	57.3897	36885.00	35631.00	0.00	175	5	176	102	1.72549019607843	0.322663261300991	0.322663261300991	false	false	false
44d86a5f-ada1-4866-a75a-eab5684df68b	2026-09-25 11:46	2026-09-25 11:46	2026-09-25 11:46	NUAI	NUAI261009C00008000	call	8.0000	2026-10-09	0.2300	0.0500	0.4000	6.7750	16200.00	16200.00	0.00	700	8	710	1689	0.420367081113085	1.16438503337241	1.16438503337241	false	false	false
4037cc68-6d51-4036-acde-94d2f319f5df	2026-09-25 11:45	2026-09-25 11:45	2026-09-25 11:45	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.2000	11.2000	11.9000	88.3600	77280.00	0.00	77280.00	69	6	74	1935	0.0382428940568475	0.465834305850774	0.465834305850774	false	false	false
bd59cf1c-3c65-4f5e-bdf7-75c2790689e3	2026-09-25 11:44	2026-09-25 11:44	2026-09-25 11:44	WMB	WMB261218P00065000	put	65.0000	2026-12-18	1.9500	1.9000	1.9500	69.5500	20263.00	20263.00	0.00	104	10	253	1379	0.18346627991298	0.313310361341217	0.313310361341217	false	false	false
39196900-7868-4bcf-a7d3-8d1f0f329a82	2026-09-25 11:44	2026-09-25 11:44	2026-09-25 11:44	WMB	WMB261218P00065000	put	65.0000	2026-12-18	1.9500	1.8500	1.9500	69.5300	28442.00	28442.00	0.00	146	9	149	1379	0.108049311094996	0.313707279529659	0.313707279529659	false	false	false
e65622c7-270f-4e2b-a1f1-aed9a6f5c0d1	2026-09-25 11:43	2026-09-25 11:43	2026-09-25 11:43	AR	AR261120P00033000	put	33.0000	2026-11-20	1.1000	1.1000	1.1500	35.0200	17490.00	0.00	17490.00	159	9	636	1813	0.350799779371208	0.382290853144212	0.382290853144212	false	false	false
f13876b3-298c-4e84-9844-d0c37101651d	2026-09-25 11:43	2026-09-25 11:42	2026-09-25 11:42	AR	AR261120P00033000	put	33.0000	2026-11-20	1.1000	1.1000	1.2000	34.9900	48070.00	0.00	48070.00	437	27	476	1813	0.262548262548263	0.38038864896654	0.38038864896654	false	false	false
7080f4e2-ba0d-4ae8-9cb1-60b488e39872	2026-09-25 11:42	2026-09-25 11:42	2026-09-25 11:42	EQT	EQT261218C00052500	call	52.5000	2026-12-18	2.6200	2.5800	2.6600	50.9300	24366.00	5502.00	18864.00	93	6	169	718	0.235376044568245	0.317265314260945	0.317265314260945	false	false	false
0957eec5-c316-4e75-871b-348c5769a447	2026-09-25 11:42	2026-09-25 11:42	2026-09-25 11:42	WMB	WMB290119C00080000	call	80.0000	2029-01-19	9.4000	9.4000	10.3000	69.0000	36660.00	0.00	36660.00	39	8	330	2	165	0.242188048135301	0.242188048135301	false	false	false	true
a22b1862-50ef-4cb7-b930-d7ee28d1a2a5	2026-09-25 11:41	2026-09-25 11:41	2026-09-25 11:41	WMB	WMB290119C00080000	call	80.0000	2029-01-19	9.3000	9.3000	10.3000	69.0000	55800.00	0.00	55800.00	60	5	241	2	120.5	0.24045584935453	0.24045584935453	false	false	false	true
d12437c8-5a10-42e3-98db-549727497cdd	2026-09-25 11:41	2026-09-25 11:41	2026-09-25 11:41	WMB	WMB290119C00080000	call	80.0000	2029-01-19	9.3200	9.3000	10.3000	69.0000	55898.00	0.00	55898.00	60	6	181	2	90.5	0.243723907042958	0.240389910771785	false	false	false	true
ada320c3-ec66-43b0-82aa-5e4cdbec1662	2026-09-25 11:40	2026-09-25 11:40	2026-09-25 11:40	SLB	SLB261016P00052000	put	52.0000	2026-10-16	1.8600	1.7600	1.8600	51.0000	29574.00	29574.00	0.00	159	33	159	5	31.8	0.365943168215976	0.365943168215976	false	false	false	true
3899e7fb-c090-4ab2-8c8f-18b3a28bbb91	2026-09-25 11:36	2026-09-25 11:36	2026-09-25 11:36	GLND	GLND261120C00006000	call	6.0000	2026-11-20	1.4500	1.2500	1.4500	6.4750	13195.00	13195.00	0.00	91	13	1188	1433	0.829030006978367	1.22202067637742	1.22202067637742	false	false	false
fb40e144-3db3-4789-b7c6-a7f11d934d83	2026-09-25 11:35	2026-09-25 11:35	2026-09-25 11:35	YPF	YPF261016P00050000	put	50.0000	2026-10-16	1.1000	1.0000	1.1500	52.4200	28930.00	28820.00	110.00	263	5	733	2990	0.245150501672241	0.435186832442864	0.435872493011103	false	false	false
254b587f-849f-4148-a652-991e23b1d65e	2026-09-25 11:35	2026-09-25 11:35	2026-09-25 11:35	VLO	VLO270319C00500000	call	500.0000	2027-03-19	20.0000	18.3000	20.0000	378.0150	22000.00	22000.00	0.00	11	11	11	31	0.354838709677419	0.50622561080863	0.50622561080863	false	false	false
f1dbb740-bf63-4c8a-9ad7-d0a9e264d48c	2026-09-25 11:33	2026-09-25 11:33	2026-09-25 11:33	EQT	EQT261016C00053000	call	53.0000	2026-10-16	0.7100	0.7100	0.7600	50.0000	15549.00	0.00	15549.00	219	16	496	1952	0.254098360655738	0.303446734176347	0.303446734176347	false	false	false
6d2c6624-12e5-4077-b62e-f94ca23c6528	2026-09-25 11:30	2026-09-25 11:30	2026-09-25 11:30	OBE	OBE270115C00012500	call	12.5000	2027-01-15	1.1100	1.1000	1.4000	10.0000	18810.00	960.00	17850.00	169	17	221	5016	0.0440590111642743	0.676012396592226	0.719769466482619	false	false	false
09eeeb72-7745-41ce-9eda-3b5eab21b10d	2026-09-25 11:27	2026-09-25 11:27	2026-09-25 11:27	GLND	GLND261016C00007000	call	7.0000	2026-10-16	0.9900	0.9000	1.2000	6.0000	34605.00	24415.00	10095.00	350	26	2459	642	3.83021806853583	1.90604434415747	1.9705277015001	true	false	false
f304328f-99c2-4b49-b674-747300b4ec47	2026-09-25 11:24	2026-09-25 11:24	2026-09-25 11:24	GLND	GLND261016C00006000	call	6.0000	2026-10-16	1.0500	0.9750	1.0500	6.1745	10500.00	10500.00	0.00	100	20	2698	1444	1.86842105263158	1.64851248734178	1.64851248734178	false	false	false
52a2237a-141b-4aa5-a5c4-5d0e1ddad9c0	2026-09-25 11:24	2026-09-25 11:24	2026-09-25 11:24	VLO	VLO260925P00375000	put	375.0000	2026-09-25	3.0000	2.1500	3.7000	373.1700	14700.00	900.00	12000.00	49	5	343	1001	0.342657342657343	0.572227609232129	0.572227609232129	false	false	false
b14e6eba-e40f-4aad-98fa-456665f34a97	2026-09-25 11:24	2026-09-25 11:24	2026-09-25 11:24	VLO	VLO260925P00375000	put	375.0000	2026-09-25	3.0000	1.9500	4.2000	373.5500	13500.00	12900.00	600.00	45	6	288	1001	0.287712287712288	0.644612703728699	0.644612703728699	false	false	false
ee5f7ffb-ae00-4e02-a0b0-69effc027769	2026-09-25 11:23	2026-09-25 11:23	2026-09-25 11:23	CLMT	CLMT270319C00045000	call	45.0000	2027-03-19	14.1400	13.6000	15.2000	52.9300	14142.00	8482.00	2830.00	10	5	10	372	0.0268817204301075	0.682905200464645	0.682905200464645	false	false	false
1a89efbb-da21-49d1-877f-bf359fd65fb6	2026-09-25 11:20	2026-09-25 11:20	2026-09-25 11:20	BP	BP261218C00047000	call	47.0000	2026-12-18	1.6500	1.6000	1.6500	44.3500	16483.00	13695.00	2788.00	100	27	100	1847	0.0541418516513265	0.299353144151284	0.299353144151284	false	false	false
f3b62c24-5d4a-4c54-aa85-e332c1555f0e	2026-09-25 11:18	2026-09-25 11:18	2026-09-25 11:18	KMI	KMI270319P00031000	put	31.0000	2027-03-19	2.1400	2.1300	2.1700	30.8100	32526.00	3638.00	28888.00	152	7	256	598	0.42809364548495	0.278266185031744	0.279458757807845	true	false	false
5e1550fa-c846-4e57-a795-242f8376b127	2026-09-25 11:15	2026-09-25 11:15	2026-09-25 11:15	EXE	EXE261120C00105000	call	105.0000	2026-11-20	0.4500	0.4500	0.5500	86.7850	12960.00	0.00	12960.00	288	16	338	21	16.0952380952381	0.334275563420577	0.334275563420577	false	false	false
e6a89422-472a-4f5d-a695-e58718ba3c98	2026-09-25 11:13	2026-09-25 11:13	2026-09-25 11:13	COP	COP261120C00150000	call	150.0000	2026-11-20	1.0000	0.8200	1.0000	128.3500	10000.00	10000.00	0.00	100	5	100	12389	0.00807167648720639	0.321270992232059	0.321270992232059	false	false	false
1e67f636-214e-48b0-9bb4-0b69eefde53f	2026-09-25 11:05	2026-09-25 11:05	2026-09-25 11:05	CLMT	CLMT270115C00080000	call	80.0000	2027-01-15	1.8000	1.8000	1.8500	53.2100	17640.00	0.00	17640.00	98	19	101	417	0.24220623501199	0.675527889295594	0.675527889295594	false	false	false
b2f126a9-f386-480b-9321-c719414fcd7a	2026-09-25 11:05	2026-09-25 11:05	2026-09-25 11:05	VLO	VLO261009P00370000	put	370.0000	2026-10-09	12.9900	12.2000	13.5000	373.7900	25976.00	25976.00	0.00	20	5	116	55	2.10909090909091	0.519234972950026	0.519234972950026	false	false	false
27483a81-cdb6-4d34-9f26-dbb8fc765513	2026-09-25 11:05	2026-09-25 11:05	2026-09-25 11:05	WMB	WMB261016P00070000	put	70.0000	2026-10-16	1.8500	1.7500	1.8500	69.7400	39960.00	39960.00	0.00	216	25	240	5067	0.0473653049141504	0.269612683107121	0.269612683107121	false	false	false
5479ebe6-efb7-4893-b28a-8a16c9b4b9f1	2026-09-25 10:54	2026-09-25 10:54	2026-09-25 10:54	VLO	VLO261009P00370000	put	370.0000	2026-10-09	12.8700	12.2000	13.5000	373.0000	25749.00	25749.00	0.00	20	5	86	55	1.56363636363636	0.514511668427054	0.514164499017695	false	false	false
ed747f01-a882-40b0-b866-8ca290407ecd	2026-09-25 10:54	2026-09-25 10:54	2026-09-25 10:54	GLND	GLND270521C00005000	call	5.0000	2027-05-21	1.5000	1.5000	1.6000	5.0000	18450.00	0.00	18450.00	123	19	678	833	0.813925570228091	0.54541507452278	0.54541507452278	false	false	false
cd145dbf-a682-4d73-bc73-f6033a8039a4	2026-09-25 10:49	2026-09-25 10:49	2026-09-25 10:49	GLND	GLND270521C00005000	call	5.0000	2027-05-21	1.5000	1.4500	1.6000	5.8750	18450.00	0.00	10800.00	123	11	533	833	0.639855942376951	0.525988786643809	0.525988786643809	false	false	false
0aa58dc6-be9a-4c71-9bc0-0f6a87df5bb8	2026-09-25 10:49	2026-09-25 10:49	2026-09-25 10:49	DK	DK261016C00060000	call	60.0000	2026-10-16	8.2000	7.7000	8.7000	66.6500	304221.00	3280.00	300941.00	371	20	402	328	1.22560975609756	0.64591561835525	0.64591561835525	false	false	false
b04d2614-c4be-4d35-bc98-fad791124c21	2026-09-25 10:48	2026-09-25 10:48	2026-09-25 10:48	GLND	GLND270521C00005000	call	5.0000	2027-05-21	1.5000	1.4500	1.5500	5.8250	18450.00	0.00	14550.00	123	10	410	833	0.492196878751501	0.550216855156881	0.550216855156881	false	false	false
cfcb23e0-1714-4907-a3bc-5f4b559cb255	2026-09-25 10:48	2026-09-25 10:48	2026-09-25 10:48	KMI	KMI270115C00035000	call	35.0000	2027-01-15	0.4000	0.4000	0.4400	30.9150	14760.00	0.00	14760.00	369	6	370	14783	0.0250287492389907	0.221532353601965	0.221532353601965	false	false	false