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

451f95c2-4c3f-4fa7-8965-7c382e0fb3c3	2026-09-24 13:00	2026-09-24 12:59	2026-09-24 12:59	CCJ	CCJ280121P00070000	put	70.0000	2028-01-21	7.1500	7.1000	7.3000	89.3400	15015.00	14300.00	715.00	21	6	812	403	2.01488833746898	0.46818845126236	0.46818845126236	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	39539584402.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T17:03:43.722265Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
07d8a53c-de9e-4053-9910-5ca64830ff8b	2026-09-24 12:59	2026-09-24 12:59	2026-09-24 12:59	CVX	CVX270319P00195000	put	195.0000	2027-03-19	10.1000	9.9500	10.1500	206.1650	14140.00	10100.00	4040.00	14	5	62	895	0.0692737430167598	0.302380339188659	0.302380339188659	false	false	false	true
e35f7d25-aa2f-4df7-b47e-1c0c52401ea9	2026-09-24 12:56	2026-09-24 12:56	2026-09-24 12:56	CVX	CVX270319P00220000	put	220.0000	2027-03-19	23.2000	22.7500	23.2000	206.0000	46400.00	46400.00	0.00	20	5	53	270	0.196296296296296	0.311716624945907	0.311716624945907	false	false	false	true
c4115397-7eaf-4f8f-81b4-973eceff5f32	2026-09-24 12:56	2026-09-24 12:56	2026-09-24 12:56	SHEL	SHEL261016C00095000	call	95.0000	2026-10-16	3.0000	3.0000	3.1000	96.0000	30600.00	0.00	30600.00	102	12	233	7798	0.0298794562708387	0.248638011518845	0.248638011518845	false	false	false	true
64da24ed-202b-4e71-a6fd-20426f40ef89	2026-09-24 12:53	2026-09-24 12:53	2026-09-24 12:53	EOG	EOG261120C00155000	call	155.0000	2026-11-20	2.7100	2.5500	3.3000	141.0000	359770.00	0.00	359770.00	1330	2	1330	300	4.43333333333333	0.309000080543631	0.311689227217346	false	true	false	true
ca4f494e-c178-4b1f-ab3d-b8681eba6924	2026-09-24 12:52	2026-09-24 12:52	2026-09-24 12:52	OBE	OBE270115C00015000	call	15.0000	2027-01-15	0.7500	0.7000	0.8000	11.0000	22425.00	4275.00	18150.00	299	13	557	4251	0.131027993413315	0.709044313400196	0.713271725250038	true	false	false	true
c3848713-a826-45b1-ae84-d93a9d939eab	2026-09-24 12:50	2026-09-24 12:50	2026-09-24 12:50	CVX	CVX261016P00202500	put	202.5000	2026-10-16	3.7500	3.7500	3.9500	205.8200	10130.00	380.00	9750.00	27	9	31	342	0.0906432748538012	0.271391973412869	0.275176266776085	false	false	false	true
5ab316b6-b0a7-40bd-9708-79cc51504b8a	2026-09-24 12:50	2026-09-24 12:50	2026-09-24 12:50	CVX	CVX261016P00207500	put	207.5000	2026-10-16	6.0500	5.9500	6.3000	205.8200	31460.00	1210.00	30250.00	52	18	130	174	0.747126436781609	0.267518874011227	0.269076431308082	true	false	false	true
f2b27182-7faa-4330-a627-1f048256899b	2026-09-24 12:50	2026-09-24 12:50	2026-09-24 12:50	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	3.4500	3.2000	3.4500	89.5400	17250.00	17250.00	0.00	50	15	1149	3985	0.288331242158093	0.494098670505194	0.494098670505194	false	false	false	true
0f7dcad5-38da-4bae-93cb-fcdae40a7855	2026-09-24 12:50	2026-09-24 12:49	2026-09-24 12:49	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	3.4000	3.2000	3.4000	89.5400	17000.00	17000.00	0.00	50	9	1099	3985	0.275784190715182	0.490200181547919	0.490200181547919	false	false	false	true
1b9dd530-fd9c-4d23-a374-8dd1f4d0801d	2026-09-24 12:50	2026-09-24 12:49	2026-09-24 12:49	EQT	EQT270115C00052500	call	52.5000	2027-01-15	3.3500	3.2000	3.3500	51.0000	10050.00	10050.00	0.00	30	7	55	522	0.10536398467433	0.328158702246607	0.328158702246607	false	false	false	true
22fb7017-e360-438b-9d5d-14b8cd186404	2026-09-24 12:48	2026-09-24 12:48	2026-09-24 12:48	CNQ	CNQ270115C00050000	call	50.0000	2027-01-15	2.7000	2.6000	2.8500	48.1000	16740.00	7020.00	9720.00	62	9	138	10187	0.0135466771375282	0.303884717405726	0.303884717405726	false	false	false	true
f95c870d-08ea-48f7-8a5a-ef53c30b44f4	2026-09-24 12:46	2026-09-24 12:46	2026-09-24 12:46	DK	DK261016C00080000	call	80.0000	2026-10-16	1.3000	1.1000	1.4500	68.2900	19225.00	15715.00	3510.00	148	9	151	578	0.261245674740484	0.709318791342759	0.709318791342759	false	false	false	true
692435a0-58bd-4c0c-bcdc-1d5aee7f6762	2026-09-24 12:44	2026-09-24 12:43	2026-09-24 12:43	XOM	XOM261016C00175000	call	175.0000	2026-10-16	0.9100	0.9000	0.9900	162.0150	26938.00	24388.00	2550.00	296	5	2944	11516	0.255644320944772	0.290271156453301	0.29236714958303	false	false	false	true
7f329756-51d0-4798-9eac-b0b177bfb3f5	2026-09-24 12:43	2026-09-24 12:43	2026-09-24 12:43	DHT	DHT261016C00023000	call	23.0000	2026-10-16	0.5800	0.5000	0.6000	21.5850	542415.00	336660.00	0.00	9352	2	11078	12591	0.879834802636804	0.530072869480074	0.530072869480074	false	true	false	true
eeb18f93-a383-4f4d-be11-e18f4a27f175	2026-09-24 12:43	2026-09-24 12:43	2026-09-24 12:43	XOM	XOM261016C00175000	call	175.0000	2026-10-16	0.9200	0.9000	0.9900	161.9000	21988.00	9292.00	12696.00	239	5	2081	11516	0.180705105939562	0.29320763693663	0.29320763693663	true	false	false	true
f9bd0951-819c-420d-aa12-4e787755d058	2026-09-24 12:43	2026-09-24 12:43	2026-09-24 12:43	MPC	MPC270319P00340000	put	340.0000	2027-03-19	25.7000	25.5000	26.0000	393.6650	15420.00	7710.00	7710.00	6	6	68	22	3.09090909090909	0.503653497238243	0.503653497238243	true	false	false	true
b3af033a-5603-4592-8b8f-cc347ddf399c	2026-09-24 12:40	2026-09-24 12:40	2026-09-24 12:40	CVX	CVX270617P00210000	put	210.0000	2027-06-17	20.6900	20.4000	20.8500	205.3600	10345.00	6205.00	4140.00	5	5	8	302	0.0264900662251656	0.313443527527857	0.313443527527857	false	false	false	true
9226eec8-03af-4cb7-b470-e686b770ffcf	2026-09-24 12:40	2026-09-24 12:40	2026-09-24 12:40	CVX	CVX270319P00180000	put	180.0000	2027-03-19	5.7000	5.6500	5.9500	205.4550	12540.00	10830.00	1710.00	22	6	41	2135	0.0192037470725995	0.309349499144177	0.309349499144177	false	false	false	true
d7ebcdf8-d09c-4cb8-9c5b-fdfdadc8695e	2026-09-24 12:36	2026-09-24 12:36	2026-09-24 12:36	EQNR	EQNR261016P00040000	put	40.0000	2026-10-16	0.5500	0.5500	0.6500	43.0400	19250.00	0.00	19195.00	350	5	7551	695	10.8647482014388	0.411553867035504	0.411553867035504	true	false	false	true
f218f44d-cdb5-4aff-a4ae-df3d4359472d	2026-09-24 12:36	2026-09-24 12:36	2026-09-24 12:36	EQNR	EQNR261016P00040000	put	40.0000	2026-10-16	0.5500	0.3000	0.6500	43.0400	104610.00	70620.00	17050.00	1902	40	7201	695	10.3611510791367	0.414318566122849	0.411553867035504	true	false	false	true
df8df8ad-8bc8-4a2d-a65b-c29be87f0651	2026-09-24 12:36	2026-09-24 12:36	2026-09-24 12:36	XOM	XOM261120P00160000	put	160.0000	2026-11-20	6.7500	6.6000	6.8000	162.1150	311850.00	311175.00	675.00	462	59	518	3394	0.152622274602239	0.325203323738762	0.325120345512393	false	false	false	true
baf6fa23-4275-4be8-ac42-d63d5c384b09	2026-09-24 12:35	2026-09-24 12:35	2026-09-24 12:35	UUUU	UUUU270115P00012000	put	12.0000	2027-01-15	2.1200	2.0500	2.1200	11.3050	223024.00	223024.00	0.00	1052	51	2970	2138	1.38914873713751	0.720952884864441	0.720952884864441	true	false	false	true
c83a2e0d-67b4-4ecb-8a71-0b7de6b1e681	2026-09-24 12:35	2026-09-24 12:35	2026-09-24 12:35	UUUU	UUUU270115P00012000	put	12.0000	2027-01-15	2.1000	2.1000	2.1100	11.3000	13230.00	0.00	13230.00	63	15	1840	2138	0.860617399438728	0.712019848572905	0.712019848572905	false	false	false	true
5770d936-bbec-4067-88fb-17706928395e	2026-09-24 12:34	2026-09-24 12:34	2026-09-24 12:34	UUUU	UUUU270115P00012000	put	12.0000	2027-01-15	2.0900	2.0300	2.0900	11.3300	43054.00	43054.00	0.00	206	14	969	2138	0.453227315247895	0.713617913067935	0.713617913067935	true	false	false	true
2b9ac25c-8247-41ed-8bc8-727572986ff9	2026-09-24 12:34	2026-09-24 12:34	2026-09-24 12:34	UUUU	UUUU270115P00012000	put	12.0000	2027-01-15	2.0900	2.0300	2.1300	11.3150	163436.00	152361.00	9612.00	782	25	1751	2138	0.818989710009354	0.713617913067935	0.710826046777488	true	false	false	true
f9c3b0d8-3ebc-4101-970a-eebceab66ac4	2026-09-24 12:34	2026-09-24 12:34	2026-09-24 12:34	UUUU	UUUU270115P00012000	put	12.0000	2027-01-15	2.0800	2.0800	2.0900	11.3350	15808.00	0.00	15808.00	76	19	758	2138	0.354536950420954	0.710555689651187	0.710555689651187	false	false	false	true
5d090193-a93e-4291-9d24-52fdf54e8b44	2026-09-24 12:34	2026-09-24 12:34	2026-09-24 12:34	UUUU	UUUU270115P00012000	put	12.0000	2027-01-15	2.0600	2.0200	2.0600	11.3399	16068.00	16068.00	0.00	78	16	251	2138	0.117399438727783	0.703489030499191	0.703489030499191	true	false	false	true
565857b9-92e7-4b38-96fa-ecadb1585a25	2026-09-24 12:33	2026-09-24 12:33	2026-09-24 12:33	UUUU	UUUU270115P00012000	put	12.0000	2027-01-15	2.0500	2.0000	2.0500	11.3499	13940.00	13940.00	0.00	68	20	94	2138	0.0439663236669785	0.701359893668638	0.701359893668638	true	false	false	true
d729529c-209f-46d0-8e03-1d4ef1c6cd85	2026-09-24 12:32	2026-09-24 12:32	2026-09-24 12:32	KGS	KGS270115P00047500	put	47.5000	2027-01-15	3.3000	2.9000	3.3000	52.2300	20790.00	20790.00	0.00	63	5	1415	44	32.1590909090909	0.50897635334367	0.50897635334367	false	false	false	true
fdc22849-afce-4d64-bc61-5562cf525953	2026-09-24 12:32	2026-09-24 12:32	2026-09-24 12:32	KGS	KGS270115P00047500	put	47.5000	2027-01-15	3.3000	2.6500	3.3000	52.3500	96690.00	96690.00	0.00	293	25	1063	44	24.1590909090909	0.5125292253234	0.5125292253234	false	false	false	true
f9fae5b1-60bc-4462-bc96-b6902f909854	2026-09-24 12:32	2026-09-24 12:32	2026-09-24 12:32	KGS	KGS270115P00047500	put	47.5000	2027-01-15	3.3000	2.6500	3.3000	52.3500	14520.00	14520.00	0.00	44	13	770	44	17.5	0.5125292253234	0.5125292253234	false	false	false	true
05680c0c-f554-4706-8330-ec239b13a995	2026-09-24 12:32	2026-09-24 12:32	2026-09-24 12:32	OXY	OXY261120C00050000	call	50.0000	2026-11-20	8.7100	8.4500	9.4000	57.8800	21765.00	0.00	21765.00	25	7	25	429	0.0582750582750583	0.28721280172457	0.380567241869729	false	false	false	true
3ac6e7c0-4544-462d-a07c-ad03451e88f9	2026-09-24 12:25	2026-09-24 12:25	2026-09-24 12:25	CVX	CVX270319C00210000	call	210.0000	2027-03-19	14.4000	14.3500	14.8500	205.9450	14400.00	7200.00	4320.00	10	5	77	1927	0.0399584846912299	0.250554416458439	0.250554416458439	true	false	false	true
4e39e46e-5c9c-4711-88bb-0bfd788e8ca3	2026-09-24 12:24	2026-09-24 12:24	2026-09-24 12:24	OXY	OXY261002P00057000	put	57.0000	2026-10-02	0.7700	0.7300	0.7900	57.8400	14630.00	12936.00	1694.00	190	12	1258	1368	0.919590643274854	0.342553136716205	0.342553136716205	true	false	false	true
a0688f2d-2c4c-490a-9f83-6cea81f44810	2026-09-24 12:24	2026-09-24 12:24	2026-09-24 12:24	VLO	VLO261009P00355000	put	355.0000	2026-10-09	6.1900	5.2000	6.2000	384.8800	22920.00	21700.00	1220.00	37	16	279	12	23.25	0.580629084544373	0.576335045963924	false	false	false	true
de83c8e5-5794-49e6-8888-5beca9ccaed6	2026-09-24 12:24	2026-09-24 12:24	2026-09-24 12:24	VLO	VLO261009P00355000	put	355.0000	2026-10-09	6.1000	5.2000	6.1000	385.1700	53680.00	53680.00	0.00	88	19	241	12	20.0833333333333	0.579105797594035	0.579105797594035	false	false	false	true
c379c861-6db2-4c0c-a947-389f1f64b34c	2026-09-24 12:24	2026-09-24 12:24	2026-09-24 12:24	VLO	VLO261009P00355000	put	355.0000	2026-10-09	5.8000	5.4000	5.8000	386.0150	27260.00	27260.00	0.00	47	7	119	12	9.91666666666667	0.574065960091257	0.574065960091257	false	false	false	true
d16b3f0a-9510-4fdc-863d-f2ec1120bcad	2026-09-24 12:23	2026-09-24 12:23	2026-09-24 12:23	VLO	VLO261002P00380000	put	380.0000	2026-10-02	10.0000	8.9000	10.2000	385.6301	10000.00	10000.00	0.00	10	5	68	100	0.68	0.564780206299905	0.564780206299905	false	false	false	true
dc9edd9e-2478-4743-bcf6-5abfcc23d2cc	2026-09-24 12:23	2026-09-24 12:23	2026-09-24 12:23	VLO	VLO260925C00387500	call	387.5000	2026-09-25	5.1000	5.1000	5.8000	386.0200	55080.00	0.00	55080.00	108	5	151	57	2.64912280701754	0.717061146529169	0.717061146529169	false	false	false	true
c553312a-33fb-45e0-a367-7eeff5e829d4	2026-09-24 12:23	2026-09-24 12:23	2026-09-24 12:23	VLO	VLO260925C00382500	call	382.5000	2026-09-25	7.8000	7.8000	9.0000	386.0200	120120.00	0.00	120120.00	154	8	177	38	4.65789473684211	0.728817039746737	0.728817039746737	true	false	false	true
7524eb8c-c9b8-4d00-95fe-a05fbdf1df61	2026-09-24 12:23	2026-09-24 12:23	2026-09-24 12:23	VLO	VLO260925C00385000	call	385.0000	2026-09-25	6.4000	6.4000	7.2000	386.0200	169600.00	0.00	169600.00	265	8	386	136	2.83823529411765	0.727237333686163	0.727237333686163	false	false	false	true
af3defb5-816d-4042-81e8-dc2faa483e2c	2026-09-24 12:23	2026-09-24 12:23	2026-09-24 12:23	CLMT	CLMT261016C00055000	call	55.0000	2026-10-16	3.0000	3.0000	3.4000	54.8100	30000.00	0.00	30000.00	100	7	109	757	0.143989431968296	0.564367334579191	0.564367334579191	false	false	false	true
122d97ae-f185-44dc-a0f8-f6926d90beac	2026-09-24 12:21	2026-09-24 12:21	2026-09-24 12:21	XOM	XOM261023C00165000	call	165.0000	2026-10-23	4.5000	4.4500	4.9000	162.6800	92255.00	90905.00	1350.00	205	5	226	226	1	0.289961655510797	0.293723979529591	false	false	false	true
8b5f0608-cf9f-4dc9-821a-7992de751be8	2026-09-24 12:21	2026-09-24 12:21	2026-09-24 12:21	XOM	XOM261016C00170000	call	170.0000	2026-10-16	2.0200	2.0000	2.0200	162.7854	52924.00	52924.00	0.00	262	5	802	22858	0.0350861842680899	0.285931694878446	0.285931694878446	false	false	false	true
87b3ea7c-800d-407d-ab8d-d850fa736db0	2026-09-24 12:21	2026-09-24 12:21	2026-09-24 12:21	XOM	XOM270115C00175000	call	175.0000	2027-01-15	6.0700	6.0500	6.4000	162.8400	15180.00	0.00	8470.00	25	5	118	4877	0.0241952019684232	0.274998989777278	0.274998989777278	false	false	false	true
686b39e5-bb33-4aef-9dc4-7fe3b1cdfb5f	2026-09-24 12:21	2026-09-24 12:20	2026-09-24 12:20	XOM	XOM261009C00167500	call	167.5000	2026-10-09	2.0700	1.9200	2.2500	162.8050	158004.00	3375.00	140967.00	763	53	1072	351	3.05413105413105	0.291315176438834	0.297120296494591	true	false	false	true
1ada9726-be8c-43cf-bde4-3b9913e6782f	2026-09-24 12:21	2026-09-24 12:20	2026-09-24 12:20	XOM	XOM261009P00157500	put	157.5000	2026-10-09	1.6900	1.6900	2.0000	162.8050	43433.00	0.00	43433.00	257	38	304	604	0.503311258278146	0.297470287828092	0.297470287828092	false	false	false	true
e86ed0d0-50b3-4455-ae76-0be707ffe46e	2026-09-24 12:17	2026-09-24 12:17	2026-09-24 12:17	XOM	XOM261120C00145000	call	145.0000	2026-11-20	20.0000	20.0000	21.0000	162.6500	104000.00	0.00	104000.00	52	12	313	1924	0.162681912681913	0.298525831752363	0.298525831752363	false	false	false	true
e7b62c57-f704-4880-8b75-aec534efafc6	2026-09-24 12:17	2026-09-24 12:17	2026-09-24 12:17	SLB	SLB280121P00045000	put	45.0000	2028-01-21	4.6500	4.4000	4.6500	51.7400	29758.00	29758.00	0.00	64	33	65	5078	0.012800315084679	0.403145343207814	0.403145343207814	true	false	false	true