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

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	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-25T14:52:00.220874Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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	true
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
35116101-c471-49d5-aef0-c680660159d5	2026-09-25 10:07	2026-09-25 10:07	2026-09-25 10:07	XOM	XOM261218P00165000	put	165.0000	2026-12-18	11.1500	10.8000	11.2000	161.0000	24525.00	22300.00	1110.00	22	12	24	892	0.0269058295964126	0.319399072106055	0.317776027558086	false	false	false	true
4bc67256-19d5-4996-88a3-38bf0a87cdc0	2026-09-25 10:04	2026-09-25 10:04	2026-09-25 10:04	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.9700	1.8900	2.0300	88.0000	50235.00	50235.00	0.00	255	12	1029	18544	0.0554896462467645	0.405578346787245	0.405578346787245	true	false	false	true
9a24c823-d634-43d6-985a-9eeed48f4f9c	2026-09-25 10:04	2026-09-25 10:04	2026-09-25 10:04	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.9900	1.8800	1.9900	88.0000	12139.00	12139.00	0.00	61	8	540	18544	0.0291199309749784	0.405369151461026	0.405369151461026	false	false	false	true
3e5cc377-be1d-4b6b-8d0d-af353cac7b29	2026-09-25 10:03	2026-09-25 10:03	2026-09-25 10:03	EQT	EQT261106C00052000	call	52.0000	2026-11-06	1.9500	1.9500	2.1900	51.0399	16185.00	0.00	16185.00	83	17	100	26	3.84615384615385	0.329102101932829	0.329102101932829	false	false	false	true
ff4d4296-805d-44f5-95d0-92cd09f72766	2026-09-25 09:58	2026-09-25 09:58	2026-09-25 09:58	FANG	FANG270319P00180000	put	180.0000	2027-03-19	14.3000	14.2000	14.7000	187.2250	11440.00	0.00	8580.00	8	6	10	65	0.153846153846154	0.385143750268624	0.385143750268624	false	false	false	true
77989b31-81c0-4c9b-bf2c-dada3eff3507	2026-09-25 09:58	2026-09-25 09:58	2026-09-25 09:58	FANG	FANG270319P00180000	put	180.0000	2027-03-19	14.2000	14.2000	14.7000	187.2250	21300.00	0.00	21300.00	15	5	25	65	0.384615384615385	0.383081370302744	0.383081370302744	false	false	false	true
3196443e-3462-47e1-86a9-53d4955a391a	2026-09-25 09:57	2026-09-25 09:57	2026-09-25 09:57	PSX	PSX260925P00250000	put	250.0000	2026-09-25	1.3000	1.3000	1.8500	250.9150	13910.00	0.00	13910.00	107	31	370	2415	0.153209109730849	0.656266325153398	0.656266325153398	false	false	false	true
b6793e46-4639-4988-9875-60831996429c	2026-09-25 09:57	2026-09-25 09:57	2026-09-25 09:57	MPLX	MPLX270115P00060000	put	60.0000	2027-01-15	4.1000	4.1000	4.2000	57.5750	328000.00	0.00	87330.00	800	6	800	997	0.802407221664995	0.249574953812299	0.249574953812299	false	false	false	true
21987b5e-e323-400b-b6b2-9da5625549d5	2026-09-25 09:55	2026-09-25 09:55	2026-09-25 09:55	OXY	OXY260925P00057000	put	57.0000	2026-09-25	0.2800	0.2800	0.4100	57.0700	11620.00	0.00	11620.00	415	47	573	1569	0.365200764818356	0.524573403420743	0.524573403420743	false	false	false	true
c7f85ed8-e00a-4ba0-8dd0-cf57f8da73b7	2026-09-25 09:55	2026-09-25 09:54	2026-09-25 09:54	PSX	PSX261016C00300000	call	300.0000	2026-10-16	0.6000	0.6000	1.1000	251.2900	12060.00	0.00	12060.00	201	45	203	435	0.466666666666667	0.441957662188734	0.441957662188734	false	false	false	true
c42a983b-9b9d-44bf-bbc4-37b3826d9de1	2026-09-25 09:54	2026-09-25 09:54	2026-09-25 09:54	SU	SU261218C00075000	call	75.0000	2026-12-18	1.8500	1.6500	2.0000	67.5800	12950.00	12950.00	0.00	70	5	83	2054	0.0404089581304771	0.325602242029629	0.325602242029629	false	false	false	true
dbfe89cc-9f75-4ff4-a963-0b27ada75882	2026-09-25 09:50	2026-09-25 09:50	2026-09-25 09:50	EQT	EQT261218C00055000	call	55.0000	2026-12-18	2.0600	1.8500	2.0600	51.3100	10300.00	10300.00	0.00	50	8	60	3714	0.0161550888529887	0.337165249326582	0.337165249326582	true	false	false	true
aae413b8-63ad-473f-8149-4e50d64a3a70	2026-09-25 09:50	2026-09-25 09:50	2026-09-25 09:50	VLO	VLO261016C00420000	call	420.0000	2026-10-16	4.7000	4.7000	6.2000	370.8400	14100.00	0.00	14100.00	30	5	32	463	0.0691144708423326	0.538849318384932	0.538849318384932	false	false	false	true
86f5d315-9ab8-40ea-9385-512deacf14ee	2026-09-25 09:47	2026-09-25 09:47	2026-09-25 09:47	LNG	LNG261016C00275000	call	275.0000	2026-10-16	8.8000	8.3000	8.8000	273.1100	88000.00	88000.00	0.00	100	6	240	494	0.48582995951417	0.359532222172564	0.359532222172564	true	false	false	true
9050dcfa-67af-4409-86cd-033d419bc95f	2026-09-25 09:41	2026-09-25 09:41	2026-09-25 09:41	VLO	VLO261016C00395000	call	395.0000	2026-10-16	11.6000	11.6000	14.0000	374.8100	375840.00	0.00	375840.00	324	52	324	368	0.880434782608696	0.537653440142218	0.537653440142218	false	false	false	true
bbd256b0-a48c-413e-bd27-7b79f9976f19	2026-09-25 09:39	2026-09-25 09:39	2026-09-25 09:39	GLND	GLND261016C00006000	call	6.0000	2026-10-16	0.7000	0.6000	0.8000	5.0000	16660.00	14980.00	1680.00	238	6	575	1444	0.398199445983379	1.88287153775988	1.88287153775988	false	false	false	true
5f2b72c3-2131-4fd8-8f8d-5f256f75b3f5	2026-09-25 09:38	2026-09-25 09:38	2026-09-25 09:38	XOM	XOM260925P00167500	put	167.5000	2026-09-25	6.6000	6.4500	8.2500	160.0000	18480.00	660.00	17820.00	28	19	28	90	0.311111111111111	0.706059995910191	0.706059995910191	true	false	false	true
428ca3cd-5873-4cdf-b0e6-9663e618eed2	2026-09-25 09:37	2026-09-25 09:37	2026-09-25 09:37	WMB	WMB261030P00064000	put	64.0000	2026-10-30	0.4300	0.3000	0.4500	70.2850	294550.00	294550.00	0.00	6850	2	6850	181	37.8453038674033	0.295995826894214	0.295995826894214	false	true	false	true
2c164a06-ca38-4fc6-bb17-c3018dcb47b0	2026-09-25 09:37	2026-09-25 09:37	2026-09-25 09:37	XOM	XOM261120P00160000	put	160.0000	2026-11-20	7.1500	6.9500	7.1500	160.9300	182325.00	182325.00	0.00	255	5	256	3830	0.0668407310704961	0.323843757750581	0.323843757750581	true	false	false	true
4b4d3e34-994d-4c56-9360-cc880485c8cd	2026-09-25 09:34	2026-09-25 09:34	2026-09-25 09:34	TRMD	TRMD261120C00035000	call	35.0000	2026-11-20	2.3500	2.1000	2.3500	34.0000	29375.00	29375.00	0.00	125	7	147	420	0.35	0.476586536862431	0.476586536862431	false	false	false	true