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

cf9302ef-3575-48e4-9bf7-b8773df7738f	2026-09-23 15:32	2026-09-23 15:32	2026-09-23 15:32	WMB	WMB261218P00065000	put	65.0000	2026-12-18	1.6000	1.5000	1.6000	71.2400	26080.00	26080.00	0.00	163	12	205	1171	0.175064047822374	0.317844056198691	0.317844056198691	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	86979438934.00	2026-11-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:37:14.904379Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
842933b4-3d9c-44c9-b6d2-dccdd546a73c	2026-09-23 15:30	2026-09-23 15:30	2026-09-23 15:30	BP	BP261120P00043000	put	43.0000	2026-11-20	1.7700	1.7600	1.8300	44.0000	52569.00	177.00	52392.00	297	25	314	981	0.320081549439348	0.360384806498881	0.360384806498881	false	false	false	true
58710a83-b045-48ef-aaad-b4be9ec612f5	2026-09-23 15:30	2026-09-23 15:30	2026-09-23 15:30	BP	BP261120P00042000	put	42.0000	2026-11-20	1.3600	1.3600	1.4100	44.0000	20264.00	0.00	20264.00	149	32	224	1693	0.132309509746013	0.357544902537585	0.357544902537585	false	false	false	true
b92da36a-13ab-4332-8edd-7ca4c594da64	2026-09-23 15:30	2026-09-23 15:30	2026-09-23 15:30	MPC	MPC270115P00350000	put	350.0000	2027-01-15	23.5000	22.2000	24.0000	388.0000	42300.00	39950.00	2350.00	18	5	171	5445	0.031404958677686	0.509697896398287	0.509697896398287	false	false	false	true
330ff7ef-d918-48ae-9725-effdbe32a142	2026-09-23 15:26	2026-09-23 15:26	2026-09-23 15:26	KGS	KGS261016P00052500	put	52.5000	2026-10-16	2.0500	2.0000	2.1500	53.0000	24395.00	20705.00	410.00	119	12	429	1829	0.234554401312192	0.452866267220865	0.452866267220865	false	false	false	true
4ecf57a5-4af1-4d2c-8792-7b51a3241cda	2026-09-23 15:26	2026-09-23 15:25	2026-09-23 15:25	KGS	KGS261016P00052500	put	52.5000	2026-10-16	1.9500	0.5500	2.0000	53.0000	44460.00	41925.00	2535.00	228	19	255	1829	0.139420448332422	0.434371657176785	0.43600801767421	false	false	false	true
6224a09e-e13b-437c-a7bd-0efadd0d90b9	2026-09-23 15:25	2026-09-23 15:25	2026-09-23 15:25	DINO	DINO261016P00092500	put	92.5000	2026-10-16	1.4900	1.3000	1.5500	105.7000	37250.00	37250.00	0.00	250	2	1502	280	5.36428571428571	0.594648433934051	0.594648433934051	false	true	false	true
df5e54f0-f5f8-4a11-8e2e-f1a7fd99e65a	2026-09-23 15:23	2026-09-23 15:23	2026-09-23 15:23	BKR	BKR270115C00050000	call	50.0000	2027-01-15	9.7000	9.6000	9.8000	57.7050	175570.00	2910.00	168780.00	181	9	211	1063	0.198494825964252	0.359773323528277	0.359773323528277	false	false	false	true
474f24f8-6785-4ddb-8fd4-4e4b64f02dcb	2026-09-23 15:21	2026-09-23 15:20	2026-09-23 15:20	XOM	XOM261218C00175000	call	175.0000	2026-12-18	4.2500	4.2000	4.2500	160.9500	12742.00	12742.00	0.00	30	5	86	4123	0.0208585981081737	0.282567532479001	0.281923277200818	false	false	false	true
3b411c5e-d2f0-4d11-9bdc-cee252661c49	2026-09-23 15:19	2026-09-23 15:19	2026-09-23 15:19	CCJ	CCJ280121P00095000	put	95.0000	2028-01-21	18.5000	18.2500	18.9000	91.4201	12950.00	5550.00	5550.00	7	6	246	328	0.75	0.477146618984504	0.477146618984504	true	false	false	true
c3c43d86-3014-4901-b07c-5bc7a2f989a6	2026-09-23 15:07	2026-09-23 15:07	2026-09-23 15:07	XOM	XOM261002P00155000	put	155.0000	2026-10-02	0.9000	0.9000	0.9900	161.0400	22770.00	0.00	22770.00	253	25	596	1020	0.584313725490196	0.30788644232992	0.30788644232992	false	false	false	true
789ff24e-bb6f-4e13-b765-6bcb076d1033	2026-09-23 15:04	2026-09-23 15:04	2026-09-23 15:04	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.5100	18.5000	18.6000	160.9100	24060.00	0.00	24060.00	13	5	1211	1049	1.15443279313632	0.293985277659049	0.293985277659049	false	false	false	true
4e1add59-8523-493d-a3dc-6d76efb41917	2026-09-23 15:02	2026-09-23 15:02	2026-09-23 15:02	EOG	EOG270115P00130000	put	130.0000	2027-01-15	4.9000	4.9000	5.1000	141.4500	50470.00	0.00	50470.00	103	29	364	912	0.399122807017544	0.338488715291844	0.338488715291844	false	false	false	true
30a596f3-2740-4e49-aa2f-c8c8eb9feca6	2026-09-23 14:59	2026-09-23 14:59	2026-09-23 14:59	OKE	OKE261016C00090000	call	90.0000	2026-10-16	2.9000	2.8000	2.9000	90.4100	16820.00	16820.00	0.00	58	10	85	1517	0.0560316413974951	0.284922910884315	0.284922910884315	false	false	false	true
908d4af8-9d88-4ed3-ab14-e27cc73d9efe	2026-09-23 14:54	2026-09-23 14:54	2026-09-23 14:54	PAGP	PAGP261120C00027000	call	27.0000	2026-11-20	0.7000	0.6500	0.7500	26.7800	15050.00	14770.00	70.00	215	15	220	2912	0.0755494505494505	0.169496072220258	0.169496072220258	true	false	false	true
3391cecd-c1d5-4536-8549-701210cb5a93	2026-09-23 14:51	2026-09-23 14:51	2026-09-23 14:51	NXE	NXE270115C00012000	call	12.0000	2027-01-15	0.5000	0.5000	0.6000	9.6950	12500.00	0.00	12500.00	250	5	256	2073	0.123492522913652	0.545891487394677	0.545891487394677	false	false	false	true
d0fe8e3f-b4a8-44ec-a908-99f05e8ad2d9	2026-09-23 14:50	2026-09-23 14:50	2026-09-23 14:50	MTRX	MTRX270521C00010000	call	10.0000	2027-05-21	1.7000	1.6500	1.8500	9.7800	22100.00	0.00	22100.00	130	5	250	0	0	0.53258416059178	0.53258416059178	false	false	false	true
8409b12a-efd1-4080-835d-fe4f94e8890e	2026-09-23 14:46	2026-09-23 14:46	2026-09-23 14:46	VLO	VLO261009P00380000	put	380.0000	2026-10-09	19.3000	18.2000	19.3000	374.3000	34740.00	34740.00	0.00	18	7	28	73	0.383561643835616	0.529573327412976	0.529573327412976	false	false	false	true
2b0d8ff8-1a6b-41c6-a8ea-268cf2bbf5f4	2026-09-23 14:45	2026-09-23 14:45	2026-09-23 14:45	OXY	OXY261009P00054000	put	54.0000	2026-10-09	0.4400	0.4300	0.4700	57.4000	55880.00	660.00	55220.00	1270	20	1286	191	6.73298429319372	0.349229831574779	0.349229831574779	false	false	false	true
17b512f6-fa76-4a6a-8a72-8cbe47868cc2	2026-09-23 14:37	2026-09-23 14:37	2026-09-23 14:37	LNG	LNG280121C00340000	call	340.0000	2028-01-21	27.0100	27.0000	29.5000	274.6500	27010.00	2710.00	24300.00	10	8	10	20	0.5	0.339126569484689	0.339126569484689	true	false	false	true
55c09e11-d19f-4bb4-b71d-d37d46d7572e	2026-09-23 14:36	2026-09-23 14:35	2026-09-23 14:35	EXE	EXE261120P00080000	put	80.0000	2026-11-20	1.5500	1.4500	1.6000	87.7400	23715.00	23560.00	0.00	153	27	181	19756	0.00916177363838834	0.341350233184566	0.341350233184566	false	false	false	true
65290167-cf74-4407-a271-3b8e52235ea6	2026-09-23 14:34	2026-09-23 14:34	2026-09-23 14:34	APA	APA261016C00050000	call	50.0000	2026-10-16	0.3200	0.2900	0.3400	43.7600	11552.00	32.00	11520.00	361	17	383	2167	0.176742039686202	0.449079414029445	0.449079414029445	false	false	false	true
c1c93bb4-19bb-4446-aa10-8679645c7341	2026-09-23 14:33	2026-09-23 14:33	2026-09-23 14:33	DHT	DHT261218P00020000	put	20.0000	2026-12-18	1.6000	1.6000	1.8000	21.2750	11200.00	0.00	5440.00	70	15	624	650	0.96	0.570084504287567	0.570084504287567	false	false	false	true
4613adc0-f011-4dc3-af77-9ed1a5997536	2026-09-23 14:30	2026-09-23 14:30	2026-09-23 14:30	COP	COP261218C00130000	call	130.0000	2026-12-18	7.5000	7.3000	7.5000	128.5300	31500.00	31500.00	0.00	42	15	155	1285	0.120622568093385	0.305411748600802	0.305411748600802	false	false	false	true
1dca119a-6898-4d02-a64d-c9b3ac9692cd	2026-09-23 14:28	2026-09-23 14:28	2026-09-23 14:28	BP	BP261016P00043000	put	43.0000	2026-10-16	0.7700	0.7700	0.8200	44.2850	10087.00	0.00	10010.00	131	29	232	860	0.269767441860465	0.310246226648016	0.310246226648016	false	false	false	true
b30599ff-64f7-4e0a-ab76-6ac2ac5bced2	2026-09-23 14:23	2026-09-23 14:23	2026-09-23 14:23	CVX	CVX281215C00300000	call	300.0000	2028-12-15	10.5500	10.5500	10.9500	205.0000	42200.00	0.00	42200.00	40	16	102	215	0.474418604651163	0.238158126729153	0.238158126729153	true	false	false	true
848e6d45-7554-4d0b-86dc-ffd7844ec824	2026-09-23 14:23	2026-09-23 14:23	2026-09-23 14:23	CCJ	CCJ270617P00080000	put	80.0000	2027-06-17	7.3500	7.3500	7.6500	91.0000	26460.00	0.00	26460.00	36	10	160	124	1.29032258064516	0.463363369210051	0.463363369210051	false	false	false	true
3d76ff48-5465-4520-8329-55bdfe591a63	2026-09-23 14:22	2026-09-23 14:22	2026-09-23 14:22	CCJ	CCJ270617P00080000	put	80.0000	2027-06-17	7.4000	7.4000	7.4500	91.0000	11840.00	0.00	11840.00	16	7	34	124	0.274193548387097	0.464888821567086	0.464888821567086	false	false	false	true
201d2973-3d6b-48be-a47b-96587afa07bb	2026-09-23 14:19	2026-09-23 14:19	2026-09-23 14:19	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.8000	18.8000	18.8500	161.0000	35720.00	0.00	35720.00	19	6	630	1049	0.600571973307912	0.29758649809747	0.29758649809747	false	false	false	true
241ad59d-8956-4d94-b66e-d03906157743	2026-09-23 14:18	2026-09-23 14:18	2026-09-23 14:18	VLO	VLO261016P00350000	put	350.0000	2026-10-16	9.9000	9.6000	10.3000	372.6900	14850.00	2970.00	2970.00	15	5	1440	1466	0.982264665757162	0.53885362146613	0.53885362146613	false	false	false	true
6b43d67f-1475-47cb-b850-35eb5e3441f5	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.8000	18.7500	18.8500	161.1400	16920.00	0.00	0.00	9	5	521	1049	0.496663489037178	0.300836012552709	0.300836012552709	false	false	false	true
149d41e2-4246-4dbf-942e-100d9cda38e4	2026-09-23 14:15	2026-09-23 14:15	2026-09-23 14:15	PBF	PBF261016P00070000	put	70.0000	2026-10-16	4.9000	4.9000	5.5000	70.2400	24500.00	0.00	24500.00	50	20	210	651	0.32258064516129	0.728878194514998	0.728878194514998	false	false	false	true
2bbb6407-2dee-4ccb-85e2-f53d9b7e128e	2026-09-23 14:15	2026-09-23 14:15	2026-09-23 14:15	LNG	LNG270115P00270000	put	270.0000	2027-01-15	15.9000	15.4000	15.9000	275.3600	87450.00	87450.00	0.00	55	10	55	629	0.0874403815580286	0.332454259425832	0.332454259425832	false	false	false	true
5f170ff8-88ec-49e9-8d1c-a0bacbf1ca64	2026-09-23 14:14	2026-09-23 14:14	2026-09-23 14:14	VLO	VLO261016P00360000	put	360.0000	2026-10-16	14.3000	14.0000	14.9000	370.5050	11440.00	8580.00	2860.00	8	5	148	873	0.169530355097365	0.533470024826695	0.533470024826695	false	false	false	true
fec1ee35-5d08-47a1-8985-d1168e39b16a	2026-09-23 14:11	2026-09-23 14:11	2026-09-23 14:11	VNOM	VNOM261016C00042000	call	42.0000	2026-10-16	0.8000	0.6500	0.8000	41.1300	52640.00	52640.00	0.00	658	21	681	148	4.60135135135135	0.274759061905315	0.274759061905315	false	false	false	true
dfd210f3-ad2b-4474-a972-3cee3b08f16b	2026-09-23 14:03	2026-09-23 14:02	2026-09-23 14:02	FRO	FRO261120P00045000	put	45.0000	2026-11-20	2.5500	2.4500	2.6000	47.3400	20399.00	19889.00	0.00	80	23	136	2	68	0.50906261478408	0.50906261478408	false	false	false	true
8d74c5e1-b54d-4f9b-a0ac-6324ac637079	2026-09-23 14:02	2026-09-23 14:02	2026-09-23 14:02	XOM	XOM261218P00155000	put	155.0000	2026-12-18	6.2000	6.2000	6.2500	161.3200	16740.00	0.00	16740.00	27	6	315	2844	0.110759493670886	0.315736353387513	0.315736353387513	false	false	false	true
25e257cf-2d04-4eaf-9cc2-b170c01437f5	2026-09-23 14:02	2026-09-23 14:02	2026-09-23 14:02	CVX	CVX270115C00200000	call	200.0000	2027-01-15	16.0000	15.6500	16.0500	205.8938	19200.00	16000.00	3200.00	12	7	143	6554	0.0218187366493744	0.249795414985843	0.249795414985843	false	false	false	true
9ef36ea0-07fc-47dd-b976-1c62cf633f4d	2026-09-23 14:01	2026-09-23 14:01	2026-09-23 14:01	XOM	XOM261009C00165000	call	165.0000	2026-10-09	2.5200	2.4300	2.5400	161.2900	10085.00	10085.00	0.00	40	6	691	371	1.86253369272237	0.295462307816611	0.291566970326128	false	false	false	true
ef197903-1259-4a58-b710-073f7a452a31	2026-09-23 13:59	2026-09-23 13:59	2026-09-23 13:59	XOM	XOM261218P00155000	put	155.0000	2026-12-18	6.2500	6.2500	6.4000	161.2109	16250.00	0.00	16250.00	26	5	238	2844	0.0836849507735584	0.316165119170629	0.316165119170629	false	false	false	true
886b6da9-c365-4e77-b216-29cf643b107d	2026-09-23 13:54	2026-09-23 13:54	2026-09-23 13:54	XOM	XOM261023C00170000	call	170.0000	2026-10-23	2.2300	2.1000	2.2400	161.1600	113060.00	109270.00	3790.00	507	53	542	87	6.22988505747126	0.285230817178675	0.285230817178675	false	false	false	true
f0068488-e020-43a0-ba2e-6c96f19da0a4	2026-09-23 13:53	2026-09-23 13:53	2026-09-23 13:53	CVX	CVX261218P00200000	put	200.0000	2026-12-18	8.0500	7.9000	8.0500	205.8550	309120.00	309120.00	0.00	384	49	415	2900	0.143103448275862	0.295246416307165	0.295246416307165	false	false	false	true
31c1f23e-ebde-4c37-b249-d1e73fb5e623	2026-09-23 13:53	2026-09-23 13:53	2026-09-23 13:53	CVX	CVX261218P00195000	put	195.0000	2026-12-18	6.1500	6.0000	6.1500	205.8550	129765.00	129765.00	0.00	211	25	259	873	0.296678121420389	0.295789750907794	0.295789750907794	false	false	false	true
2323adb3-ea54-4854-b98c-87357e9c2d0b	2026-09-23 13:52	2026-09-23 13:52	2026-09-23 13:52	CLMT	CLMT270319C00050000	call	50.0000	2027-03-19	11.3000	11.0000	12.0000	52.4800	33900.00	0.00	19210.00	30	5	55	585	0.094017094017094	0.676713336131273	0.676713336131273	false	false	false	true
bca47052-e627-42b9-95eb-22801a636e15	2026-09-23 13:50	2026-09-23 13:50	2026-09-23 13:50	VLO	VLO260925P00375000	put	375.0000	2026-09-25	12.6000	10.6000	12.6000	367.0500	28980.00	28980.00	0.00	23	5	201	1093	0.183897529734675	0.736028332026071	0.736028332026071	false	false	false	true
09d2f12a-1c43-4462-b4a6-cb00dd96e139	2026-09-23 13:50	2026-09-23 13:50	2026-09-23 13:50	VLO	VLO260925P00375000	put	375.0000	2026-09-25	12.5000	10.0000	12.5000	367.0500	33750.00	33750.00	0.00	27	5	178	1093	0.162854528819762	0.726167670574571	0.726167670574571	false	false	false	true
960d5018-63d7-4cd6-9b9d-c49c832d46ae	2026-09-23 13:48	2026-09-23 13:48	2026-09-23 13:48	SHEL	SHEL270617P00097500	put	97.5000	2027-06-17	8.5000	8.5000	8.8000	95.0000	42500.00	0.00	42500.00	50	6	166	155	1.07096774193548	0.276641938910314	0.276641938910314	false	false	false	true
67b00618-7ed6-4527-9914-5d661d70e4f5	2026-09-23 13:47	2026-09-23 13:47	2026-09-23 13:47	PBF	PBF261218P00067500	put	67.5000	2026-12-18	8.4000	7.9000	8.4000	70.0000	70560.00	70560.00	0.00	84	18	85	61	1.39344262295082	0.753452866100439	0.753452866100439	false	false	false	true
38396193-f4bf-4646-bf8d-cd9c698d70a4	2026-09-23 13:45	2026-09-23 13:45	2026-09-23 13:45	XOM	XOM261218C00165000	call	165.0000	2026-12-18	7.7500	7.7500	7.9500	161.0000	10850.00	0.00	10850.00	14	14	169	6733	0.0251002524877469	0.278800410114062	0.278800410114062	true	false	false	true
6a6c7891-f753-431a-979d-69b3a91ca9e0	2026-09-23 13:45	2026-09-23 13:44	2026-09-23 13:44	DK	DK261016C00075000	call	75.0000	2026-10-16	3.7000	3.7000	3.8000	71.0000	32930.00	0.00	22200.00	89	24	202	1625	0.124307692307692	0.701935884756912	0.701935884756912	false	false	false	true