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

cf5540ba-67f2-4822-a91e-8f50dead5a47	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	LNG	LNG261002C00282500	call	282.5000	2026-10-02	4.2000	3.6000	4.3000	273.0000	33180.00	10920.00	12600.00	79	10	242	0	0	0.420433922677172	0.420639840493268	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	56375563768.00	2026-10-29	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
92654d23-daf3-4961-a0aa-ea8bc6a882ef	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	LNG	LNG261002C00282500	call	282.5000	2026-10-02	4.1000	3.6000	4.4000	273.0000	44280.00	43050.00	820.00	108	14	158	0	0	0.415855368837396	0.415855368837396	true	false	false	true
9616d7a3-d744-4388-82a1-d386faac3f93	2026-09-22 15:57	2026-09-22 15:56	2026-09-22 15:56	VLO	VLO261016P00380000	put	380.0000	2026-10-16	22.0000	20.7000	22.0000	376.8000	13200.00	13200.00	0.00	6	6	865	796	1.08668341708543	0.540419858525296	0.540419858525296	false	false	false	true
aaf97a7f-0129-48de-8965-deb7143f1990	2026-09-22 15:56	2026-09-22 15:56	2026-09-22 15:56	VLO	VLO261016C00380000	call	380.0000	2026-10-16	20.0000	20.0000	20.1000	377.2500	34000.00	0.00	34000.00	17	11	81	204	0.397058823529412	0.539932418353774	0.539932418353774	false	false	false	true
8b078431-b22c-4bed-8df6-501306415db7	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	VLO	VLO261002P00360000	put	360.0000	2026-10-02	6.4000	5.8000	6.4000	376.6800	17920.00	17920.00	0.00	28	5	1733	584	2.96746575342466	0.544042259768013	0.544042259768013	true	false	false	true
67394fd5-165b-4887-a345-9e03e2900c98	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	VLO	VLO261002P00360000	put	360.0000	2026-10-02	6.3000	5.8000	6.3000	376.6800	21420.00	21420.00	0.00	34	6	1767	584	3.02568493150685	0.539333910478075	0.539333910478075	true	false	false	true
29b73ec6-3450-4adb-aa76-0a6b27453955	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	VLO	VLO260925P00375000	put	375.0000	2026-09-25	7.3000	6.7000	7.4000	376.8600	17520.00	17520.00	0.00	24	6	1786	1308	1.36544342507645	0.607177641031568	0.607177641031568	false	false	false	true
f9c5a848-697c-48ac-ad58-5d0075e74d4e	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	VLO	VLO260925P00375000	put	375.0000	2026-09-25	7.3000	6.6000	7.3000	377.0000	20440.00	20440.00	0.00	28	8	1762	1308	1.34709480122324	0.611832840340821	0.611832840340821	false	false	false	true
cd0dc591-b108-434b-9c86-3afef78c0c45	2026-09-22 15:55	2026-09-22 15:55	2026-09-22 15:55	FRO	FRO270115C00055000	call	55.0000	2027-01-15	2.5500	2.1500	2.7500	47.0000	13005.00	13005.00	0.00	51	30	100	0	0	0.445754832408263	0.445754832408263	false	false	false	true
4d769b07-3346-4234-8a59-0a5dc1c8fd79	2026-09-22 15:51	2026-09-22 15:51	2026-09-22 15:51	VLO	VLO261016P00380000	put	380.0000	2026-10-16	22.1000	20.9000	22.1000	376.8000	33150.00	30940.00	0.00	15	6	852	796	1.07035175879397	0.54301512486764	0.54301512486764	false	false	false	true
e57650a2-5d7b-4172-aac4-24de1d74039d	2026-09-22 15:49	2026-09-22 15:49	2026-09-22 15:49	CNQ	CNQ270115P00045000	put	45.0000	2027-01-15	2.0000	2.0000	2.1000	47.7624	157800.00	0.00	157800.00	789	38	801	1246	0.642857142857143	0.332206791408019	0.332206791408019	false	false	false	true
987fb677-df1f-49aa-898c-185f0d90afd7	2026-09-22 15:49	2026-09-22 15:49	2026-09-22 15:49	PSX	PSX261120P00260000	put	260.0000	2026-11-20	19.5000	19.5000	20.1000	257.4300	21450.00	0.00	21450.00	11	5	79	256	0.30859375	0.461766638859179	0.461766638859179	false	false	false	true
caa6a7cf-2a05-4fb8-9d90-df03a175bc7d	2026-09-22 15:48	2026-09-22 15:48	2026-09-22 15:48	VLO	VLO261016P00380000	put	380.0000	2026-10-16	21.8000	21.4000	21.8000	377.6200	13080.00	6540.00	0.00	6	6	822	796	1.03266331658291	0.545565376408013	0.545565376408013	false	false	false	true
dd7b88df-bb8b-4ad4-8e0b-03ffd2877e34	2026-09-22 15:48	2026-09-22 15:48	2026-09-22 15:48	VLO	VLO261016P00380000	put	380.0000	2026-10-16	21.6000	21.3000	21.6000	377.5550	21600.00	6480.00	0.00	10	10	816	796	1.0251256281407	0.539569322505196	0.539569322505196	false	false	false	true
8871ac3e-9087-4c1a-99c5-03b75643a865	2026-09-22 15:47	2026-09-22 15:47	2026-09-22 15:47	VLO	VLO261016P00300000	put	300.0000	2026-10-16	1.2800	0.8500	1.7000	377.9800	211200.00	128700.00	82500.00	1650	2	5200	2658	1.95635816403311	0.580844262841976	0.580844262841976	false	true	false	true
64e18697-b0fd-4e97-9acb-7af83821a0aa	2026-09-22 15:47	2026-09-22 15:47	2026-09-22 15:47	EQT	EQT261120C00052500	call	52.5000	2026-11-20	2.2800	2.2500	2.3400	51.1401	41496.00	16644.00	24852.00	182	5	292	674	0.433234421364985	0.333073888366968	0.333073888366968	false	false	false	true
331d9ad3-f68a-4d57-a1a1-7852877f81a2	2026-09-22 15:42	2026-09-22 15:42	2026-09-22 15:42	SU	SU261120P00065000	put	65.0000	2026-11-20	2.6000	2.4500	2.6000	67.0350	129998.00	129998.00	0.00	500	46	540	179	3.01675977653631	0.351124811380626	0.351124811380626	true	false	false	true
eabb078b-5ca7-4458-974b-3524a86430f9	2026-09-22 15:42	2026-09-22 15:42	2026-09-22 15:42	VLO	VLO261016P00380000	put	380.0000	2026-10-16	21.7000	21.2000	21.7000	377.5600	23870.00	10850.00	0.00	11	11	776	796	0.974874371859296	0.542223292257428	0.542223292257428	false	false	false	true
f63e96f7-0f5a-4b98-8ea7-6a130c9e1aa1	2026-09-22 15:41	2026-09-22 15:41	2026-09-22 15:41	MPC	MPC261218P00330000	put	330.0000	2026-12-18	13.1000	12.6000	13.2000	391.4500	10480.00	10480.00	0.00	8	5	26	760	0.0342105263157895	0.528221479878426	0.528221479878426	false	false	false	true
6917fb46-49e1-4a64-8cd7-638168a79ae9	2026-09-22 15:40	2026-09-22 15:40	2026-09-22 15:40	VLO	VLO261016P00360000	put	360.0000	2026-10-16	12.8000	12.2000	12.8000	377.1900	47360.00	47360.00	0.00	37	15	359	784	0.457908163265306	0.547767398579948	0.547767398579948	false	false	false	true
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
6d2bcfbe-0053-40fe-b5bd-9293e998bdb6	2026-09-22 15:38	2026-09-22 15:37	2026-09-22 15:37	VLO	VLO261016C00390000	call	390.0000	2026-10-16	15.5000	14.9000	16.6000	376.5300	26350.00	20150.00	6200.00	17	6	89	298	0.298657718120805	0.540550195010671	0.540550195010671	true	false	false	true
248f1115-af1c-400f-925e-6ed79ad24cc8	2026-09-22 15:37	2026-09-22 15:37	2026-09-22 15:37	VLO	VLO261016P00340000	put	340.0000	2026-10-16	6.5000	6.3000	6.8000	376.7650	17550.00	14300.00	3250.00	27	7	177	1972	0.0897565922920893	0.54480563306411	0.54480563306411	true	false	false	true
7688efc1-0213-4124-8361-5bfe4da5cfd0	2026-09-22 15:37	2026-09-22 15:37	2026-09-22 15:37	PSX	PSX270617C00300000	call	300.0000	2027-06-17	24.8000	23.6000	25.2000	257.3750	96720.00	81840.00	12400.00	39	11	40	14	2.85714285714286	0.420384156439677	0.420384156439677	false	false	false	true
ae1e6587-93d9-41b2-a21b-edc80874df6b	2026-09-22 15:37	2026-09-22 15:36	2026-09-22 15:36	HAL	HAL261120P00029000	put	29.0000	2026-11-20	0.5200	0.5000	0.5400	32.9100	10718.00	52.00	318.00	206	43	783	140	5.59285714285714	0.386785602199875	0.389707154424185	false	false	false	true
4895b005-659c-4e87-8ad3-6c6c998bdbb8	2026-09-22 15:36	2026-09-22 15:36	2026-09-22 15:36	VLO	VLO260925P00372500	put	372.5000	2026-09-25	6.3100	5.2000	6.8000	377.4500	37880.00	32760.00	5120.00	60	15	170	126	1.34920634920635	0.634224256548137	0.641806726808655	true	false	false	true
09bd96c5-3913-4987-b34b-415e5ecf13c1	2026-09-22 15:36	2026-09-22 15:36	2026-09-22 15:36	CVX	CVX260925P00200000	put	200.0000	2026-09-25	1.3000	1.1700	1.3400	202.4200	131559.00	130650.00	909.00	1012	61	1765	1554	1.13577863577864	0.322441370227058	0.320952586600184	false	false	false	true
875a190e-c760-4044-a2b1-0faa4083ce71	2026-09-22 15:36	2026-09-22 15:36	2026-09-22 15:36	CVX	CVX261002C00205000	call	205.0000	2026-10-02	2.6200	2.3500	2.6200	202.4000	17292.00	17292.00	0.00	66	16	1352	203	6.66009852216749	0.274320911486711	0.274320911486711	false	false	false	true
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
3a77c06a-ad64-45a5-a98d-4131488c59d7	2026-09-22 15:30	2026-09-22 15:30	2026-09-22 15:30	VLO	VLO261002P00360000	put	360.0000	2026-10-02	6.0000	6.0000	6.1000	379.0000	51000.00	0.00	51000.00	85	17	1189	584	2.03595890410959	0.555725081036759	0.555725081036759	false	false	false	true
a192b49f-14e2-4db9-b8ac-fa634e9183c9	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	XOM	XOM261009P00150000	put	150.0000	2026-10-09	1.0400	0.9800	1.0500	158.0000	30576.00	27456.00	3120.00	294	16	1293	143	9.04195804195804	0.305923451513398	0.305524751641646	true	false	false	true
83ab0bf9-f73c-4ce0-bea2-ef5c99c1bd0b	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	XOM	XOM261120P00155000	put	155.0000	2026-11-20	5.7500	5.6500	5.7500	158.0000	25875.00	25875.00	0.00	45	15	146	2333	0.0625803686240892	0.317140811861572	0.317140811861572	false	false	false	true
073346fc-373a-44c8-af85-d2dfef0c8abc	2026-09-22 15:27	2026-09-22 15:27	2026-09-22 15:27	BP	BP280121P00035000	put	35.0000	2028-01-21	2.4500	2.3500	2.4500	43.1450	10535.00	10535.00	0.00	43	6	120	1663	0.0721587492483464	0.365368047195712	0.365368047195712	false	false	false	true
f864f274-9fd3-4905-8e05-8948ce1ede40	2026-09-22 15:27	2026-09-22 15:27	2026-09-22 15:27	BP	BP270115P00034000	put	34.0000	2027-01-15	0.3400	0.3400	0.4600	43.1400	34782.00	0.00	34782.00	1023	23	1023	41	24.9512195121951	0.346316712012522	0.346316712012522	false	false	false	true
6f4acf3f-2106-47c6-bd34-ad388a69e0c7	2026-09-22 15:27	2026-09-22 15:26	2026-09-22 15:26	CVX	CVX270319P00210000	put	210.0000	2027-03-19	18.9500	18.5500	18.9500	202.8709	11370.00	11370.00	0.00	6	5	121	650	0.186153846153846	0.308596296965714	0.308347746361181	false	false	false	true
0a854936-3f84-4e2e-9afc-ca5024ea8d7b	2026-09-22 15:24	2026-09-22 15:24	2026-09-22 15:24	WMB	WMB261120C00075000	call	75.0000	2026-11-20	2.1500	2.0000	2.1500	71.0700	22998.00	22998.00	0.00	107	16	1397	1593	0.876961707470182	0.309503950697943	0.309503950697943	true	false	false	true
6b5f7447-952d-4db6-88ad-b1fb6ba5052e	2026-09-22 15:23	2026-09-22 15:23	2026-09-22 15:23	TRGP	TRGP261120C00290000	call	290.0000	2026-11-20	13.1600	13.0000	15.4000	284.9200	92104.00	0.00	92104.00	70	8	70	3	23.3333333333333	0.315597134351454	0.321602337908725	false	false	false	true
7635a1f6-39da-445f-9f9e-5e8d536eca11	2026-09-22 15:23	2026-09-22 15:23	2026-09-22 15:23	OXY	OXY261023P00053000	put	53.0000	2026-10-23	0.7500	0.6800	0.7600	56.6050	11100.00	11100.00	0.00	148	10	264	145	1.82068965517241	0.335051351829786	0.335051351829786	false	false	false	true
62869730-5f12-4ef4-b6be-8fc2c88d6f0d	2026-09-22 15:23	2026-09-22 15:23	2026-09-22 15:23	DHT	DHT261218C00028000	call	28.0000	2026-12-18	0.4500	0.3500	0.4500	21.5250	12015.00	12015.00	0.00	267	37	276	241	1.14522821576763	0.496027809258997	0.496027809258997	false	false	false	true
c23492b5-2341-4835-b2e8-e74fa8667649	2026-09-22 15:23	2026-09-22 15:23	2026-09-22 15:23	VLO	VLO260925P00375000	put	375.0000	2026-09-25	6.5000	5.5000	6.5000	379.2000	18850.00	18850.00	0.00	29	8	1490	1308	1.13914373088685	0.622412328441227	0.622412328441227	false	false	false	true
8028d964-3e56-4e33-b170-57f351ca335f	2026-09-22 15:23	2026-09-22 15:23	2026-09-22 15:23	OVV	OVV270115P00055000	put	55.0000	2027-01-15	2.9700	2.9000	3.0000	59.2100	231955.00	93600.00	0.00	781	2	959	217	4.41935483870968	0.397813115255761	0.397813115255761	false	true	false	true
c74e71d4-de80-475b-82eb-3a000d5140c5	2026-09-22 15:19	2026-09-22 15:19	2026-09-22 15:19	CVX	CVX261016C00202500	call	202.5000	2026-10-16	6.0500	6.0000	6.2000	202.9500	32695.00	3050.00	29645.00	54	7	460	0	0	0.267924817474869	0.267924817474869	false	false	false	true
fd45f5d6-e4e5-4796-a241-94a7e347abbd	2026-09-22 15:19	2026-09-22 15:19	2026-09-22 15:19	CVX	CVX261016C00202500	call	202.5000	2026-10-16	6.0500	6.0000	6.2000	202.9500	53240.00	605.00	52635.00	88	8	406	0	0	0.267924817474869	0.267924817474869	false	false	false	true
ba9b3dba-84cf-46e6-88ec-c1470dd65909	2026-09-22 15:19	2026-09-22 15:19	2026-09-22 15:19	CVX	CVX261016C00202500	call	202.5000	2026-10-16	6.0500	6.0000	6.2500	202.9500	63530.00	15125.00	48405.00	105	19	318	0	0	0.267924817474869	0.267924817474869	false	false	false	true
fabe4c84-9295-4353-8b03-312f73a11653	2026-09-22 15:19	2026-09-22 15:19	2026-09-22 15:19	CVX	CVX261016P00197500	put	197.5000	2026-10-16	3.0500	3.0000	3.2500	202.9500	11895.00	915.00	10980.00	39	11	171	54	3.16666666666667	0.270284837255004	0.270284837255004	false	false	false	true
ef72d42e-9ace-49d1-832a-32412119b554	2026-09-22 15:19	2026-09-22 15:19	2026-09-22 15:19	CVX	CVX261002C00202500	call	202.5000	2026-10-02	4.1000	4.0000	4.1500	202.9500	18860.00	5330.00	7380.00	46	12	572	17	33.6470588235294	0.280734887073561	0.280734887073561	false	false	false	true
e9a36096-f8f5-4f11-9ae3-dfedeb9eb3d2	2026-09-22 15:19	2026-09-22 15:19	2026-09-22 15:19	CVX	CVX261002C00205000	call	205.0000	2026-10-02	2.9100	2.8600	3.0500	202.9500	73624.00	588.00	73036.00	253	37	1271	203	6.26108374384236	0.278833586560007	0.275046620577824	true	false	false	true
1c47d25b-374a-4828-9a1a-a6d50289faf3	2026-09-22 15:19	2026-09-22 15:19	2026-09-22 15:19	CVX	CVX261002P00200000	put	200.0000	2026-10-02	2.3500	2.3100	2.5100	202.9500	15274.00	235.00	14804.00	65	17	461	991	0.46518668012109	0.279869227722654	0.279869227722654	true	false	false	true
13b44113-8751-47cc-83a0-6318e2bca5a7	2026-09-22 15:19	2026-09-22 15:19	2026-09-22 15:19	CVX	CVX261016P00200000	put	200.0000	2026-10-16	4.0000	3.9000	4.1000	202.9500	34800.00	2400.00	32400.00	87	19	592	3209	0.184481146774696	0.270353368770642	0.270353368770642	true	false	false	true
84cae91f-4d5d-41ae-8669-d66312c9b5c4	2026-09-22 15:18	2026-09-22 15:18	2026-09-22 15:18	EQT	EQT260925C00050000	call	50.0000	2026-09-25	1.3900	1.3900	1.7200	51.3850	13900.00	0.00	13900.00	100	5	174	263	0.661596958174905	0.45823460417769	0.45823460417769	false	false	false	true