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: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

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	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	—	Energy	242265275.00	2026-11-12	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T15:25:06.221939Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
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
ab305763-1485-47e5-8a04-07ebb7a9fde8	2026-09-25 10:47	2026-09-25 10:47	2026-09-25 10:47	DK	DK261016C00060000	call	60.0000	2026-10-16	8.2000	8.2000	8.6000	66.4550	24600.00	0.00	24600.00	30	7	31	328	0.0945121951219512	0.67718930805093	0.67718930805093	false	false	false
1e0c32b4-055d-492d-b446-822743177693	2026-09-25 10:46	2026-09-25 10:46	2026-09-25 10:46	HAL	HAL261016C00032000	call	32.0000	2026-10-16	1.4500	1.4500	1.5200	32.6527	11311.00	146.00	11165.00	78	8	90	2646	0.0340136054421769	0.338935623355012	0.338935623355012	true	false	false
c398fc24-4306-4f11-8a24-c0239609deed	2026-09-25 10:45	2026-09-25 10:44	2026-09-25 10:44	VLO	VLO261023C00460000	call	460.0000	2026-10-23	2.5000	2.5000	3.5000	374.7400	27250.00	0.00	27250.00	109	33	109	41	2.65853658536585	0.538334086811791	0.538334086811791	false	false	false
37a1e56f-90d8-4d53-8d66-f8fe69f26256	2026-09-25 10:45	2026-09-25 10:44	2026-09-25 10:44	VLO	VLO261023C00490000	call	490.0000	2026-10-23	1.1000	1.1000	1.8500	374.7400	19030.00	0.00	19030.00	173	35	173	12	14.4166666666667	0.552153623353431	0.552153623353431	false	false	false
b97000f5-f12a-4b66-9c5b-449393cb56b3	2026-09-25 10:44	2026-09-25 10:44	2026-09-25 10:44	DVN	DVN261016C00048500	call	48.5000	2026-10-16	1.3300	1.2900	1.3900	47.6800	23142.00	14364.00	8778.00	174	7	185	392	0.471938775510204	0.36129587994418	0.36129587994418	true	false	false
bdab38a2-adcf-4848-8e14-d9bd7125e2af	2026-09-25 10:43	2026-09-25 10:43	2026-09-25 10:43	VLO	VLO261016P00370000	put	370.0000	2026-10-16	15.6500	15.6000	16.7000	374.4650	50087.00	0.00	50087.00	32	5	86	919	0.0935799782372144	0.518827364960706	0.518827364960706	false	false	false
8f2d60da-3e3a-4157-bf50-bf8b0ee1c5cf	2026-09-25 10:37	2026-09-25 10:37	2026-09-25 10:37	OXY	OXY270521C00060000	call	60.0000	2027-05-21	5.4900	5.2500	5.5000	57.0400	46649.00	46649.00	0.00	85	6	100	105	0.952380952380952	0.327863316832607	0.327863316832607	false	false	false
895631a2-a064-4324-87c3-ddba0f9bc2be	2026-09-25 10:37	2026-09-25 10:37	2026-09-25 10:37	VLO	VLO261009P00370000	put	370.0000	2026-10-09	13.1500	12.8000	13.4000	373.3800	14460.00	5260.00	9200.00	11	5	14	55	0.254545454545455	0.518582261885549	0.518582261885549	false	false	false
be1e2fc0-8c3e-428f-9273-c4385e49db64	2026-09-25 10:34	2026-09-25 10:33	2026-09-25 10:33	OKE	OKE261218C00110000	call	110.0000	2026-12-18	0.4000	0.4000	0.5000	89.4500	10925.00	0.00	10925.00	273	47	282	1388	0.203170028818444	0.277143509620755	0.277143509620755	false	false	false
372ca665-7cd3-446e-b221-0be59e6bf332	2026-09-25 10:33	2026-09-25 10:33	2026-09-25 10:33	DVN	DVN261120P00047500	put	47.5000	2026-11-20	2.5700	2.5700	2.6600	47.5900	10286.00	0.00	10286.00	40	7	40	9502	0.00420964007577352	0.377401427082557	0.373333078629836	false	false	false
1eb96868-41b8-4bd0-8cb9-e72a1888676b	2026-09-25 10:31	2026-09-25 10:30	2026-09-25 10:30	LNG	LNG261002C00280000	call	280.0000	2026-10-02	3.1000	3.1000	4.0000	272.4350	110980.00	0.00	110980.00	358	21	552	736	0.75	0.398739966669986	0.398739966669986	false	false	false
36e4e766-ef05-48a8-8f74-3023a7c50816	2026-09-25 10:30	2026-09-25 10:30	2026-09-25 10:30	VLO	VLO261002P00360000	put	360.0000	2026-10-02	5.3000	4.9000	5.9000	374.7150	10070.00	2120.00	2650.00	19	5	47	1155	0.0406926406926407	0.554303096640173	0.554303096640173	false	false	false
c44cd228-09c9-48d4-9219-2ca233ca8804	2026-09-25 10:28	2026-09-25 10:28	2026-09-25 10:28	BP	BP261120C00043000	call	43.0000	2026-11-20	2.8500	2.8200	2.9000	44.1000	14250.00	8550.00	5700.00	50	9	50	695	0.0719424460431655	0.308451959886707	0.308451959886707	false	false	false
ec8581b8-ba37-476a-8dd6-6f86e4643544	2026-09-25 10:27	2026-09-25 10:27	2026-09-25 10:27	VLO	VLO261023P00380000	put	380.0000	2026-10-23	25.2000	23.8000	25.9000	373.7500	30240.00	22680.00	7560.00	12	5	32	60	0.533333333333333	0.543292005204114	0.543292005204114	true	false	false
3676aa94-0b61-4c88-ab05-e824ced3fdc9	2026-09-25 10:26	2026-09-25 10:26	2026-09-25 10:26	OXY	OXY261120C00055000	call	55.0000	2026-11-20	4.4000	4.3000	4.4000	57.0000	18480.00	18480.00	0.00	42	7	74	2011	0.0367976131277971	0.353703363423405	0.353703363423405	false	false	false
d7271260-2b2e-4634-9e38-b613c7887078	2026-09-25 10:26	2026-09-25 10:26	2026-09-25 10:26	HAL	HAL261016C00031000	call	31.0000	2026-10-16	2.0900	2.0900	2.1900	32.5800	25289.00	0.00	25289.00	121	22	151	197	0.766497461928934	0.351371909460756	0.351371909460756	false	false	false
6606d3ad-c23b-433f-b0de-d02df4a1f208	2026-09-25 10:25	2026-09-25 10:25	2026-09-25 10:25	CVX	CVX270319P00220000	put	220.0000	2027-03-19	23.3000	23.0500	23.3500	205.5300	11650.00	9325.00	2325.00	5	5	8	293	0.0273037542662116	0.30835122432637	0.309237630260326	false	false	false
6a155663-6c98-4493-9d57-7e9f94538eaa	2026-09-25 10:22	2026-09-25 10:22	2026-09-25 10:22	OKE	OKE261016C00090000	call	90.0000	2026-10-16	2.4500	2.3500	2.5500	89.8189	11755.00	9310.00	240.00	48	8	73	1524	0.0479002624671916	0.283616136019867	0.283616136019867	false	false	false
2e30237d-a746-4198-a28d-f55ee787170a	2026-09-25 10:20	2026-09-25 10:20	2026-09-25 10:20	PSX	PSX260925P00250000	put	250.0000	2026-09-25	0.9000	0.7000	1.7000	251.4419	90000.00	0.00	90000.00	1000	4	1407	2415	0.582608695652174	0.595936903582631	0.595936903582631	false	true	false
1ad662c6-7cbc-44c3-a8f2-805e553504c8	2026-09-25 10:20	2026-09-25 10:20	2026-09-25 10:20	FRO	FRO270115P00050000	put	50.0000	2027-01-15	7.4000	6.8000	7.5000	47.9300	22200.00	740.00	21460.00	30	12	30	107	0.280373831775701	0.623840212868747	0.623840212868747	false	false	false
3b487aed-6885-41c8-bb0f-aa486f942750	2026-09-25 10:20	2026-09-25 10:20	2026-09-25 10:20	APA	APA261016C00042500	call	42.5000	2026-10-16	2.1500	2.0100	2.2000	43.0400	22575.00	1290.00	21285.00	105	5	112	4045	0.0276885043263288	0.443755138212946	0.443755138212946	false	false	false
cfddfb64-2587-4024-9fe8-d57fa383d060	2026-09-25 10:18	2026-09-25 10:18	2026-09-25 10:18	XOM	XOM280121C00175000	call	175.0000	2028-01-21	17.0500	16.4500	17.2750	160.8100	20460.00	10230.00	10230.00	12	8	12	4236	0.0028328611898017	0.250892687663149	0.250892687663149	false	false	false
81c8850e-588e-4569-9364-8d543728e794	2026-09-25 10:18	2026-09-25 10:18	2026-09-25 10:18	VLO	VLO260925P00375000	put	375.0000	2026-09-25	4.5000	2.6500	4.5000	372.0600	12600.00	12600.00	0.00	28	5	176	1001	0.175824175824176	0.735083317223258	0.735083317223258	false	false	false
3bbc1030-3e8b-4c9e-8da0-335c613ab739	2026-09-25 10:17	2026-09-25 10:17	2026-09-25 10:17	FRO	FRO270115P00049200	put	49.2000	2027-01-15	6.9000	6.9000	7.0000	47.9500	55890.00	0.00	55890.00	81	15	81	1944	0.0416666666666667	0.621599944986757	0.621599944986757	false	false	false
39c79e28-1d4e-4bb1-bc41-d0b5b4ec7eb9	2026-09-25 10:17	2026-09-25 10:17	2026-09-25 10:17	MPC	MPC261120C00390000	call	390.0000	2026-11-20	28.8000	27.5000	30.0000	384.0000	66240.00	57600.00	8640.00	23	5	48	43	1.11627906976744	0.507169740440611	0.507169740440611	false	false	false
a2c63a9c-bc79-492e-8136-04c65c8d39e7	2026-09-25 10:16	2026-09-25 10:16	2026-09-25 10:16	EXE	EXE270115P00075000	put	75.0000	2027-01-15	1.4600	1.3000	1.5000	87.1800	43409.00	14405.00	29004.00	298	33	298	590	0.505084745762712	0.327290132828437	0.327290132828437	false	false	false
29f46f71-b3dd-4bd0-af9e-2a5579c6246d	2026-09-25 10:15	2026-09-25 10:15	2026-09-25 10:15	EQT	EQT261120P00055000	put	55.0000	2026-11-20	5.0000	4.9000	5.2000	51.1250	11000.00	0.00	11000.00	22	6	42	71	0.591549295774648	0.351882383166665	0.351882383166665	false	false	false
38484b8d-657a-46c1-9932-b47883e86926	2026-09-25 10:13	2026-09-25 10:12	2026-09-25 10:12	EQT	EQT261218C00055000	call	55.0000	2026-12-18	1.9800	1.7300	1.9800	51.0099	19800.00	19800.00	0.00	100	9	219	3714	0.0589660743134087	0.340827608825134	0.340827608825134	true	false	false
8deaf101-f4c5-4352-872c-d48b0203e552	2026-09-25 10:12	2026-09-25 10:11	2026-09-25 10:11	APA	APA261218C00055000	call	55.0000	2026-12-18	0.7800	0.7800	0.8400	43.0600	10062.00	0.00	10062.00	129	36	129	301	0.428571428571429	0.459486797343412	0.459486797343412	false	false	false
f5b96ced-332b-4752-8992-5a2417cc5880	2026-09-25 10:11	2026-09-25 10:11	2026-09-25 10:11	VLO	VLO261120P00370000	put	370.0000	2026-11-20	28.0000	27.4000	29.0000	373.0200	28000.00	0.00	28000.00	10	5	13	135	0.0962962962962963	0.530042125398757	0.530042125398757	false	false	false
7552677f-1364-426b-b775-df673ad7426b	2026-09-25 10:11	2026-09-25 10:11	2026-09-25 10:11	VLO	VLO261218P00390000	put	390.0000	2026-12-18	44.9900	44.4000	47.5000	373.0200	202450.00	9010.00	193440.00	45	32	58	370	0.156756756756757	0.525028015156631	0.523627144383186	true	false	false
7079b3a4-97f8-4c58-a620-0baeaf5b1303	2026-09-25 10:08	2026-09-25 10:08	2026-09-25 10:08	SOC	SOC261030C00004000	call	4.0000	2026-10-30	0.5000	0.3900	0.5600	3.0000	25950.00	14900.00	11050.00	519	7	519	3	173	1.12210055541129	1.12210055541129	false	false	false	true
f7069219-e98d-421b-a21f-4f5f749f2fe6	2026-09-25 10:08	2026-09-25 10:08	2026-09-25 10:08	OKE	OKE261016P00095000	put	95.0000	2026-10-16	6.0800	5.7000	6.2000	89.0000	12169.00	12169.00	0.00	20	5	21	1332	0.0157657657657658	0.33145241701495	0.300120451037947	false	false	false