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:sector = Energy×source = uw_flow_alerts×

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
f95de1a6-39ca-428a-aba5-6a4bfff0ffc9	2026-09-22 15:52	2026-09-22 15:52	2026-09-22 15:52	CLMT	CLMT270115C00060000	call	60.0000	2027-01-15	6.9200	6.5000	7.3000	56.0200	10381.00	8312.00	689.00	15	10	495	1409	0.351312987934705	0.657711243259971	0.657711243259971	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
d70bcc14-0082-4920-baed-4b87b16346c1	2026-09-22 15:50	2026-09-22 15:50	2026-09-22 15:50	CVX	CVX261016C00212500	call	212.5000	2026-10-16	2.1100	1.8100	2.2500	202.6800	12464.00	6355.00	6109.00	59	24	552	81	6.81481481481481	0.265641152520677	0.260954197036292	true	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
10950924-cde1-4d7f-a15a-dc0a81b632b5	2026-09-22 15:47	2026-09-22 15:40	2026-09-22 15:47	VLO	VLO261016P00300000	put	300.0000	2026-10-16	1.3000	0.0000	0.0000	377.9800	275901.00	137020.00	87661.00	2148	39	5200	2658	1.95635816403311	0	0	true	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
d876e914-e6c2-45b9-aa7a-8ba2608003d6	2026-09-22 15:42	2026-09-22 15:42	2026-09-22 15:42	VLO	VLO261016C00390000	call	390.0000	2026-10-16	16.2500	16.0000	16.3000	377.7900	21120.00	21120.00	0.00	13	6	103	298	0.345637583892617	0.544386860457642	0.544386860457642	false	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
a36332bd-8d31-4c8c-9a65-d76e059c07f7	2026-09-22 15:40	2026-09-22 15:40	2026-09-22 15:40	VLO	VLO261016P00300000	put	300.0000	2026-10-16	1.3000	0.7000	1.3000	377.1900	141401.00	3510.00	5031.00	1088	45	1268	2658	0.477050413844996	0.58179937978757	0.58179937978757	true	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
3dc199dc-2eb5-4132-ae81-b0f77e220e8b	2026-09-22 15:37	2026-09-22 15:37	2026-09-22 15:37	WMB	WMB270115C00085000	call	85.0000	2027-01-15	0.9100	0.9000	1.1000	71.0200	18013.00	0.00	18013.00	198	6	732	1277	0.573218480814409	0.279779837729974	0.280794386736621	false	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
eb9efda7-8021-425b-9a16-febb3d6e6735	2026-09-22 15:36	2026-09-22 15:36	2026-09-22 15:36	VLO	VLO260925P00375000	put	375.0000	2026-09-25	7.3400	6.4000	7.9000	377.4500	58700.00	55660.00	2300.00	80	28	1657	1308	1.26681957186544	0.626641491963645	0.671061386282922	true	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
ec845ad8-d268-4a49-8b9a-bba577d0899e	2026-09-22 15:33	2026-09-22 15:33	2026-09-22 15:33	CLMT	CLMT270115C00065000	call	65.0000	2027-01-15	5.4600	5.3000	6.0000	56.0000	13640.00	0.00	13640.00	25	12	115	1557	0.0738599871547848	0.667111566195031	0.667111566195031	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
2257dd36-b91c-49f6-b262-71c5baae74c5	2026-09-22 15:32	2026-09-22 15:32	2026-09-22 15:32	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	9.5000	9.3000	10.0000	56.0000	23741.00	0.00	23741.00	25	10	112	1090	0.102752293577982	0.676144124083227	0.676144124083227	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
6dc31be5-4cb9-4d9c-8ca4-035e762df585	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	XOM	XOM261009P00150000	put	150.0000	2026-10-09	1.0100	0.9600	1.0200	158.0000	30581.00	30480.00	101.00	302	19	943	143	6.59440559440559	0.304329521843277	0.305461340538056	false	false	false	true
ff4d6277-0ab1-4e6a-8dcd-ca7f3e7fdc83	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	EXE	EXE270115C00110000	call	110.0000	2027-01-15	1.1900	1.1000	1.2000	87.0000	21494.00	21494.00	0.00	180	6	202	9108	0.0221783047870004	0.335143298802033	0.335143298802033	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
8c14981a-8aab-4533-9b66-ba848c17af9c	2026-09-22 15:24	2026-09-22 15:24	2026-09-22 15:24	SHEL	SHEL261016P00090000	put	90.0000	2026-10-16	0.7800	0.7500	0.9000	93.9500	12388.00	0.00	12388.00	158	5	212	1237	0.171382376717866	0.245061121525374	0.245061121525374	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