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:er_time = premarket×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

18ee4c96-39f2-4a59-a9bf-c15a353c6af0	2026-09-23 11:47	2026-09-23 11:47	2026-09-23 11:47	PSX	PSX270319C00310000	call	310.0000	2027-03-19	14.9000	14.3000	14.9000	255.0000	10430.00	10430.00	0.00	7	5	12	25	0.48	0.433642833103241	0.433642833103241	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	102340884536.00	2026-10-28	premarket	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T15:47:22.680410Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
8117df17-8096-4ff9-9f56-3d329429fb28	2026-09-23 11:21	2026-09-23 11:21	2026-09-23 11:21	VLO	VLO261002P00370000	put	370.0000	2026-10-02	9.9600	8.9000	10.4000	375.9179	43830.00	17000.00	26830.00	44	10	98	184	0.532608695652174	0.552475731187647	0.548107159532465	true	false	false	true
159f322f-c6d0-4c4a-a07b-13d7a4ea9d15	2026-09-23 11:16	2026-09-23 11:16	2026-09-23 11:16	MPC	MPC270115C00520000	call	520.0000	2027-01-15	11.3000	10.2000	12.5000	389.5150	33900.00	19210.00	3390.00	30	9	30	102	0.294117647058824	0.511159569885631	0.511159569885631	false	false	false	true
28bb1d8c-eab7-4003-b3c5-614526c4af31	2026-09-23 11:13	2026-09-23 11:13	2026-09-23 11:13	VLO	VLO270617C00500000	call	500.0000	2027-06-17	30.1000	29.4000	30.1000	375.2450	60200.00	60200.00	0.00	20	5	20	34	0.588235294117647	0.495843296976813	0.495843296976813	false	false	false	true
8a8c00d0-9609-4547-98ea-b114e9cb02e2	2026-09-23 11:03	2026-09-23 11:03	2026-09-23 11:03	VLO	VLO260925P00357500	put	357.5000	2026-09-25	2.0000	1.6500	2.0000	374.2700	12000.00	12000.00	0.00	60	26	90	1335	0.0674157303370786	0.707942452668096	0.707942452668096	true	false	false	true
a43f21bd-66a7-4f20-bb5a-c2269d9bb08b	2026-09-23 10:40	2026-09-23 10:40	2026-09-23 10:40	HAL	HAL270917C00040000	call	40.0000	2027-09-17	2.7100	2.6700	2.7150	33.0200	39837.00	39837.00	0.00	147	5	187	183	1.02185792349727	0.349727416049746	0.349885468516848	false	false	false	true
2db15a70-1ff4-4aa8-987e-09027b27b479	2026-09-23 10:10	2026-09-23 10:10	2026-09-23 10:10	VLO	VLO260925C00382500	call	382.5000	2026-09-25	7.8200	6.5000	9.4000	381.9799	11735.00	0.00	11735.00	15	9	17	22	0.772727272727273	0.705027817691883	0.705027817691883	false	false	false	true
9aeea962-2f74-42cb-8982-db90315d9e07	2026-09-23 09:54	2026-09-23 09:51	2026-09-23 09:54	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.4000	0.0000	0.0000	33.0450	819477.00	816759.00	1908.00	5860	42	10121	605	16.7289256198347	0	0	true	true	false	true
f52c003a-70cf-4b01-afc8-c8f24b91a6be	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3800	1.3800	1.4500	33.0300	10764.00	0.00	10764.00	78	16	4631	605	7.65454545454545	0.39735782840825	0.39735782840825	false	false	false	true
7696f339-b92a-4cbd-83b9-e6469320ab4c	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3800	1.3800	1.4000	33.0250	255319.00	2641.00	252678.00	1850	38	4263	605	7.04628099173554	0.39735782840825	0.397753157393514	true	false	false	true
009e9f13-4903-4a11-87e0-4b0ec320c766	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3800	1.2700	1.4300	33.0300	154899.00	125159.00	17182.00	1125	121	2413	605	3.98842975206612	0.402883795799836	0.39735782840825	true	false	false	true
67e8e415-aebd-4765-a0a1-7a976b18bee6	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	MPC	MPC261016P00340000	put	340.0000	2026-10-16	2.8500	2.8500	2.9000	396.0200	22515.00	0.00	22515.00	79	13	98	3023	0.0324181276877274	0.525546287927828	0.525546287927828	false	false	false	true
ef6edc63-b6b9-418c-a493-c40e057f2098	2026-09-23 09:52	2026-09-23 09:52	2026-09-23 09:52	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3500	1.3500	1.4500	33.0400	10260.00	0.00	10260.00	76	16	1113	605	1.8396694214876	0.390679853705984	0.390679853705984	false	false	false	true
685e7466-1b28-49a9-b31b-f32b876476df	2026-09-23 09:52	2026-09-23 09:52	2026-09-23 09:52	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3500	1.3500	1.3800	33.0300	14040.00	0.00	14040.00	104	24	1011	605	1.67107438016529	0.391467389947004	0.391467389947004	true	false	false	true
d87301bc-f8a6-4227-851b-364a4da6ce05	2026-09-23 09:52	2026-09-23 09:51	2026-09-23 09:51	VLO	VLO261002P00377500	put	377.5000	2026-10-02	9.6400	8.8000	10.2000	386.0000	28920.00	2890.00	26030.00	30	8	52	21	2.47619047619048	0.568181390303519	0.568181390303519	true	false	false	true
395afb45-affe-45fa-bc25-fa34d6d051a3	2026-09-23 09:51	2026-09-23 09:51	2026-09-23 09:51	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3500	1.3500	1.4400	33.0300	73170.00	0.00	5400.00	542	119	544	605	0.899173553719008	0.394220709769058	0.391467389947004	true	false	false	true
528f5a2b-f0ec-43e7-8d0d-195e6983dbbe	2026-09-23 09:50	2026-09-23 09:50	2026-09-23 09:50	HAL	HAL261218C00037000	call	37.0000	2026-12-18	1.0500	0.9700	1.0700	33.0100	130935.00	130935.00	0.00	1247	6	1247	1407	0.886282871357498	0.363891342798842	0.363891342798842	false	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
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
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
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
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
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
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
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
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
85eb8385-090a-4b23-8911-88696ae34ca3	2026-09-22 15:16	2026-09-22 15:16	2026-09-22 15:16	PSX	PSX261218C00290000	call	290.0000	2026-12-18	11.6600	11.5000	12.0000	258.8150	19826.00	0.00	19826.00	17	7	147	737	0.199457259158752	0.436113326230839	0.436753191030947	false	false	false	true
b982d767-f8cc-4cf7-a617-7545510f7a80	2026-09-22 15:10	2026-09-22 15:10	2026-09-22 15:10	PSX	PSX261218C00290000	call	290.0000	2026-12-18	11.5900	11.4000	12.3000	258.6350	34768.00	0.00	34768.00	30	21	95	737	0.128900949796472	0.438317137816609	0.438317137816609	false	false	false	true
c60bc313-a753-448a-8f0e-4146429293d9	2026-09-22 14:59	2026-09-22 14:59	2026-09-22 14:59	VLO	VLO261016P00380000	put	380.0000	2026-10-16	17.3000	15.8000	17.3000	386.7350	17300.00	17300.00	0.00	10	5	738	796	0.92713567839196	0.534945016658212	0.534945016658212	false	false	false	true
d99b8b41-f0f7-420b-81fb-f666c63b5133	2026-09-22 14:58	2026-09-22 14:58	2026-09-22 14:58	VLO	VLO261016P00365000	put	365.0000	2026-10-16	10.9000	10.6000	11.3000	387.1550	28340.00	16350.00	11990.00	26	6	61	4	15.25	0.531632381747386	0.531632381747386	true	false	false	true
df266150-d5a4-4065-8299-c9dcfa23e290	2026-09-22 14:48	2026-09-22 14:48	2026-09-22 14:48	VLO	VLO260925P00362500	put	362.5000	2026-09-25	0.8000	0.7500	1.2500	389.8700	19845.00	80.00	19765.00	248	42	772	859	0.89871944121071	0.591412449992021	0.591412449992021	true	false	false	true
d5ff4c45-7e20-41da-a4ab-e668f53ef9e4	2026-09-22 14:47	2026-09-22 14:47	2026-09-22 14:47	VLO	VLO260925P00362500	put	362.5000	2026-09-25	0.9000	0.8500	1.2500	390.1200	12335.00	0.00	12335.00	137	23	488	859	0.568102444703143	0.613445007397676	0.613445007397676	false	false	false	true