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

8c7a0c63-57f8-499a-9205-0dcf73524c5e	2026-09-04 10:55	2026-09-04 10:54	2026-09-04 10:54	VLO	VLO261016P00340000	put	340.0000	2026-10-16	9.3000	8.5000	9.4000	370.1300	107852.00	106922.00	930.00	116	26	507	856	0.592289719626168	0.449693625364775	0.449693625364775	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Energy	110261821190.00	2026-10-22	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T15:01:23.801406Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
78b50d9c-0cae-436b-9a61-c415657f0f14	2026-09-04 10:55	2026-09-04 10:54	2026-09-04 10:54	VLO	VLO261016P00380000	put	380.0000	2026-10-16	27.1000	25.8000	27.1000	370.1300	119240.00	119240.00	0.00	44	10	44	43	1.02325581395349	0.450394013257324	0.450394013257324	false	false	false	true
daff5c1e-481a-4787-92aa-18833fa027cd	2026-09-04 10:52	2026-09-04 10:52	2026-09-04 10:52	VLO	VLO260911P00355000	put	355.0000	2026-09-11	2.5200	2.5000	2.6500	370.7250	152860.00	28860.00	124000.00	607	18	614	82	7.48780487804878	0.411375365039613	0.404606114123973	false	false	false	true
4bf4ea90-fe1f-47df-a08e-b72980e251d3	2026-09-04 10:52	2026-09-04 10:52	2026-09-04 10:52	VLO	VLO260918P00345000	put	345.0000	2026-09-18	3.2400	2.8000	3.4000	371.0858	202602.00	202602.00	0.00	625	19	628	156	4.02564102564103	0.43642202397512	0.435898683272476	false	false	false	true
903df49b-c415-483f-ada0-a351cb5c73ef	2026-09-04 09:33	2026-09-04 09:33	2026-09-04 09:33	VLO	VLO260918P00340000	put	340.0000	2026-09-18	3.6700	2.6000	4.0000	364.1250	211189.00	211189.00	0.00	575	15	576	695	0.828776978417266	0.446549520404947	0.444034767572291	false	false	false	true
ff95a0e9-28d8-4563-a233-77943943debc	2026-09-03 15:56	2026-09-03 15:56	2026-09-03 15:56	BP	BP261016C00040000	call	40.0000	2026-10-16	4.2900	4.2500	4.5000	43.6050	61820.00	51500.00	10320.00	144	13	284	500	0.568	0.314096335100794	0.317148932782617	true	false	false	true
aed44498-b039-49c3-bfab-72ceff9bed57	2026-09-03 15:11	2026-09-03 15:11	2026-09-03 15:11	VLO	VLO261218P00390000	put	390.0000	2026-12-18	47.0400	46.5000	47.1000	370.5150	75259.00	65859.00	4700.00	16	10	57	271	0.210332103321033	0.482139729612836	0.483395421843817	true	false	false	true
4f542122-b1f3-4be3-8141-85dcb73f7d88	2026-09-03 14:26	2026-09-03 14:25	2026-09-03 14:25	BP	BP260918C00043500	call	43.5000	2026-09-18	1.1400	1.1400	1.2000	43.7050	97698.00	0.00	97698.00	857	24	912	675	1.35111111111111	0.283088309926345	0.283088309926345	false	false	false	true
d50fb9aa-c522-43c4-8670-0f924591e4d6	2026-09-03 14:21	2026-09-03 14:21	2026-09-03 14:21	VLO	VLO261218P00380000	put	380.0000	2026-12-18	41.1900	41.1000	41.2000	370.4000	57660.00	49440.00	8220.00	14	6	87	40	2.175	0.48083101778182	0.48209043656688	false	false	false	true
5f41900b-ff42-4c58-b26e-4af66006c154	2026-09-03 13:31	2026-09-03 13:31	2026-09-03 13:31	VLO	VLO261218P00390000	put	390.0000	2026-12-18	46.6000	46.2500	46.8000	371.1800	102520.00	13980.00	88540.00	22	5	23	271	0.0848708487084871	0.481356805082631	0.481356805082631	false	false	false	true
0d28ad30-ff78-45d7-a646-6919cdaf9022	2026-09-03 11:30	2026-09-03 11:30	2026-09-03 11:30	VLO	VLO280121C00320000	call	320.0000	2028-01-21	107.0000	104.5000	108.3000	372.9125	214000.00	171200.00	42800.00	20	7	30	63	0.476190476190476	0.416035121598842	0.416035121598842	false	false	false	true
63b08219-5452-4903-9b19-a82d2450c34e	2026-09-03 11:14	2026-09-03 11:14	2026-09-03 11:14	VLO	VLO270617C00450000	call	450.0000	2027-06-17	36.8000	35.5000	36.9000	374.3000	312800.00	301760.00	3680.00	85	34	96	30	3.2	0.441458248628398	0.441458248628398	true	false	false	true
c5949a4c-e125-4736-a11d-d05f93044a6a	2026-09-03 11:08	2026-09-03 11:08	2026-09-03 11:08	VLO	VLO261009P00330000	put	330.0000	2026-10-09	5.0000	4.5000	5.7000	373.9800	50000.00	7500.00	42500.00	100	6	102	5	20.4	0.454928323164481	0.454928323164481	false	false	false	true
8b87261e-82b4-4e7f-8448-05f317db4a14	2026-09-02 14:41	2026-09-02 14:41	2026-09-02 14:41	VLO	VLO261218P00390000	put	390.0000	2026-12-18	47.8000	46.8000	47.8000	368.1302	1175870.00	1175870.00	0.00	246	47	264	8	33	0.474413767445017	0.474413767445017	false	false	false	true
af33581f-41b8-4e21-aa43-47ce651a0e68	2026-09-02 14:33	2026-09-02 14:33	2026-09-02 14:33	VLO	VLO270617P00400000	put	400.0000	2027-06-17	71.6400	70.2000	71.8000	368.3850	78800.00	64520.00	14280.00	11	5	18	13	1.38461538461538	0.466902499426076	0.463826735845221	false	false	false	true
1f776e91-f847-49fc-8540-abb111eebd59	2026-09-02 14:33	2026-09-02 14:33	2026-09-02 14:33	VLO	VLO270617P00410000	put	410.0000	2027-06-17	78.1000	76.5000	78.1000	368.3850	62480.00	62480.00	0.00	8	6	8	0	0	0.467789844801809	0.467789844801809	false	false	false	true
762d0ce3-c8f2-4364-94a4-0859ab46a5d8	2026-09-02 12:56	2026-09-02 12:56	2026-09-02 12:56	VLO	VLO261218P00270000	put	270.0000	2026-12-18	4.4000	4.1000	4.5000	365.2300	80960.00	4840.00	76120.00	184	6	204	282	0.723404255319149	0.478150155776588	0.478150155776588	false	false	false	true
384328c3-d4d9-4918-b9cc-8b4d05eabb02	2026-09-02 12:56	2026-09-02 12:56	2026-09-02 12:56	VLO	VLO261218P00290000	put	290.0000	2026-12-18	7.5800	6.6000	7.6000	365.7500	303339.00	303339.00	0.00	400	39	402	164	2.45121951219512	0.466143303377476	0.474574161215157	false	false	false	true
9c4079dd-f62e-4176-8128-55c393f1589e	2026-09-02 10:13	2026-09-02 10:13	2026-09-02 10:13	VLO	VLO261016C00380000	call	380.0000	2026-10-16	17.4300	16.6000	17.6000	365.7750	172590.00	139660.00	32930.00	99	27	109	190	0.573684210526316	0.452631048147856	0.448647026797709	true	false	false	true
e2bb97ac-74b7-4e2b-b64d-40a352d7664a	2026-09-01 15:31	2026-09-01 15:30	2026-09-01 15:30	VLO	VLO270617P00390000	put	390.0000	2027-06-17	68.2700	66.5000	68.4000	361.8100	61440.00	61440.00	0.00	9	7	57	168	0.339285714285714	0.461397334250514	0.462962835390622	false	false	false	true
48a83596-3d72-40f5-a2a0-35ec6bf384ed	2026-09-01 15:31	2026-09-01 15:30	2026-09-01 15:30	VLO	VLO270617P00400000	put	400.0000	2027-06-17	74.5700	72.9000	74.7000	361.8100	74570.00	74570.00	0.00	10	6	18	0	0	0.46435174671918	0.4635724351604	true	false	false	true
7b4a5fe8-c53f-4d00-a99f-d0d8bbc8f9b6	2026-09-01 14:48	2026-09-01 14:47	2026-09-01 14:47	VLO	VLO260911P00342500	put	342.5000	2026-09-11	3.3500	3.0000	3.6000	360.8300	221133.00	168168.00	52965.00	660	9	1332	12	111	0.436576361500207	0.436010684598479	false	false	false	true
a3d93928-dc03-4aa4-b783-d8ada3df2ac3	2026-09-01 14:34	2026-09-01 14:34	2026-09-01 14:34	VLO	VLO270617P00390000	put	390.0000	2027-06-17	69.4800	67.4000	69.5000	359.1850	62530.00	62530.00	0.00	9	6	47	168	0.279761904761905	0.462071870086882	0.462071870086882	true	false	false	true
1069fb3e-e1f0-4a8c-a95f-61cb50978568	2026-09-01 14:12	2026-09-01 14:12	2026-09-01 14:12	VLO	VLO260911P00342500	put	342.5000	2026-09-11	3.1500	2.4000	3.4000	361.4050	207984.00	207984.00	0.00	660	14	663	12	55.25	0.425851727503873	0.427016507162793	false	false	false	true
cc6b2663-c4eb-4faa-90f5-3ea3772ec29c	2026-09-01 13:49	2026-09-01 13:49	2026-09-01 13:49	VLO	VLO270617P00390000	put	390.0000	2027-06-17	67.9900	65.8000	68.4000	361.9500	251550.00	203950.00	47600.00	37	17	38	168	0.226190476190476	0.460335109963165	0.460335109963165	true	false	false	true
5fe60749-f83d-484a-91e0-eab590b0b1fb	2026-09-01 13:40	2026-09-01 13:40	2026-09-01 13:40	BP	BP261218C00046000	call	46.0000	2026-12-18	2.2400	2.1600	2.2400	44.2650	122752.00	122752.00	0.00	548	25	554	141	3.9290780141844	0.289415187938466	0.289415187938466	false	false	false	true
025e8fe3-9123-46e0-96e6-c74a10f09198	2026-09-01 13:25	2026-09-01 13:25	2026-09-01 13:25	VLO	VLO261218P00340000	put	340.0000	2026-12-18	22.6000	21.8000	22.6000	363.5650	189838.00	189838.00	0.00	84	25	89	479	0.18580375782881	0.45770000903036	0.45770000903036	false	false	false	true
beea6a43-36b2-4173-824e-101b86a68585	2026-09-01 11:34	2026-09-01 11:33	2026-09-01 11:33	BP	BP260925P00045000	put	45.0000	2026-09-25	1.7800	1.7300	1.7800	44.1200	58740.00	58740.00	0.00	330	35	330	1	330	0.299414397718072	0.299414397718072	false	false	false	true
eda30ef6-3dcb-4452-8c5d-d09760b093ae	2026-09-01 10:04	2026-09-01 10:04	2026-09-01 10:04	VLO	VLO261218C00370000	call	370.0000	2026-12-18	33.4000	32.1000	33.8000	361.5000	531070.00	524370.00	6700.00	159	52	161	169	0.952662721893491	0.450486031204918	0.453042848353297	false	false	false	true
76e20e71-2464-4606-b4f2-be81bcdc147c	2026-08-31 14:32	2026-08-31 14:32	2026-08-31 14:32	BP	BP261120P00043000	put	43.0000	2026-11-20	2.7100	2.6400	2.7100	42.7150	50135.00	50135.00	0.00	185	6	248	259	0.957528957528958	0.343605403243524	0.343605403243524	false	false	false	true
a3aeb50b-f912-4fde-8655-e1f841a407ab	2026-08-31 13:12	2026-08-31 13:12	2026-08-31 13:12	VLO	VLO261218C00400000	call	400.0000	2026-12-18	19.4000	19.2000	19.9000	355.4950	164900.00	124160.00	27160.00	85	6	90	240	0.375	0.439484375130948	0.439484375130948	false	false	false	true
d9cb4354-2b45-4011-a926-ba4509e1e95d	2026-08-28 15:34	2026-08-28 15:34	2026-08-28 15:34	BP	BP261218C00045000	call	45.0000	2026-12-18	1.6700	1.6000	1.6700	42.0350	155644.00	155644.00	0.00	932	46	954	17973	0.0530796194291437	0.28437817243213	0.28437817243213	false	false	false	true
962e9071-31b3-49c1-bb35-62dba9a323d1	2026-08-27 13:53	2026-08-27 13:53	2026-08-27 13:53	VLO	VLO261218C00470000	call	470.0000	2026-12-18	7.1000	5.6000	7.1000	348.4150	122110.00	122110.00	0.00	172	51	172	20	8.6	0.46868959222205	0.46868959222205	false	false	false	true
13d3b2d5-ac78-4fad-8ace-b4f654f2e33a	2026-08-27 12:13	2026-08-27 12:13	2026-08-27 12:13	BP	BP260925C00043000	call	43.0000	2026-09-25	1.0000	0.9500	1.0000	42.0400	52200.00	52200.00	0.00	522	37	534	138	3.8695652173913	0.288201363433538	0.288201363433538	false	false	false	true
fa4c7d96-24ba-46ae-b006-4eb53428a697	2026-08-27 10:24	2026-08-27 10:24	2026-08-27 10:24	VLO	VLO261218P00290000	put	290.0000	2026-12-18	10.1000	10.1000	10.8000	346.1750	67670.00	0.00	67670.00	67	11	77	137	0.562043795620438	0.447032719670216	0.447032719670216	false	false	false	true
4865e1a0-00b8-4ac3-af7c-29f7a2d1c271	2026-08-27 10:02	2026-08-27 10:02	2026-08-27 10:02	VLO	VLO261016P00340000	put	340.0000	2026-10-16	17.5000	15.5000	17.5000	347.3350	113725.00	113725.00	0.00	65	7	68	125	0.544	0.429812446254611	0.429812446254611	true	false	false	true
9f21e4b5-a510-471d-98cf-017a76ac93e4	2026-08-26 15:51	2026-08-26 15:51	2026-08-26 15:51	VLO	VLO260904C00337500	call	337.5000	2026-09-04	15.8000	15.8000	16.8000	347.9900	88480.00	0.00	88480.00	56	5	180	5	36	0.439463281750469	0.439463281750469	true	false	false	true
a01e5f8e-b347-4e21-82f0-801ba0e3063d	2026-08-26 10:43	2026-08-26 10:43	2026-08-26 10:43	VLO	VLO260918C00342500	call	342.5000	2026-09-18	14.0000	12.8000	14.0000	341.5000	105000.00	84000.00	0.00	75	5	75	1	75	0.412107559096925	0.412107559096925	false	false	false	true
017d36d0-8059-4703-a259-3d9b7558a427	2026-08-26 09:32	2026-08-26 09:32	2026-08-26 09:32	VLO	VLO261218P00340000	put	340.0000	2026-12-18	31.7300	31.1000	34.0000	340.3950	72986.00	0.00	72986.00	23	12	23	418	0.0550239234449761	0.452230922827424	0.452230922827424	false	false	false	true
e71bc43b-7921-4987-a0c8-d945ce03de6f	2026-08-26 09:31	2026-08-26 09:31	2026-08-26 09:31	VLO	VLO261218P00360000	put	360.0000	2026-12-18	44.7200	43.7000	46.9000	338.1700	89436.00	0.00	89436.00	20	10	40	82	0.48780487804878	0.457362499374842	0.457362499374842	false	false	false	true
654fdc27-72de-46d9-8b71-6e4d927311f0	2026-08-26 09:30	2026-08-26 09:30	2026-08-26 09:30	VLO	VLO261218P00360000	put	360.0000	2026-12-18	44.7200	44.0000	47.0000	337.8200	89430.00	0.00	89430.00	20	12	20	82	0.24390243902439	0.457562659476786	0.457562659476786	false	false	false	true
c30ca7ab-02dd-42ea-a444-cbaa7a06d8c0	2026-08-25 14:11	2026-08-25 14:11	2026-08-25 14:11	VLO	VLO270617P00390000	put	390.0000	2027-06-17	77.4000	76.5000	77.9000	343.0000	92880.00	85140.00	7740.00	12	8	183	0	0	0.460012980688186	0.460012980688186	false	false	false	true
bb4681f6-4ddf-4228-958a-0cdbe4ccd2cb	2026-08-25 11:02	2026-08-25 11:02	2026-08-25 11:02	VLO	VLO261218P00250000	put	250.0000	2026-12-18	3.6000	3.6000	4.3000	342.9800	52560.00	0.00	52560.00	146	36	146	163	0.895705521472393	0.459745350789192	0.459745350789192	false	false	false	true
a2743c3e-edda-41c2-bd7e-785e28eb5272	2026-08-25 10:04	2026-08-25 10:04	2026-08-25 10:04	VLO	VLO261218C00380000	call	380.0000	2026-12-18	23.4000	21.3000	23.4000	345.1300	652837.00	652837.00	0.00	279	61	280	399	0.701754385964912	0.454485273080753	0.453164628136533	false	false	false	true
054cc132-eb47-425c-ae66-418d9dc09497	2026-08-25 10:04	2026-08-25 10:04	2026-08-25 10:04	VLO	VLO261218C00370000	call	370.0000	2026-12-18	26.1700	23.5000	26.7000	345.5000	62800.00	62800.00	0.00	24	9	24	130	0.184615384615385	0.446845491394574	0.452427597527122	false	false	false	true
2e0b05ee-8969-4ee1-b044-ddce6c9d89d6	2026-08-24 11:57	2026-08-24 11:57	2026-08-24 11:57	VLO	VLO270115C00400000	call	400.0000	2027-01-15	20.6000	20.6000	22.0000	344.8500	82403.00	0.00	82403.00	40	5	41	1169	0.0350727117194183	0.439415086956234	0.439169595710181	false	false	false	true
24c060c6-7adc-4d69-92ed-134dcbee8cda	2026-08-21 12:57	2026-08-21 12:57	2026-08-21 12:57	VLO	VLO261218P00350000	put	350.0000	2026-12-18	34.1900	34.0000	35.2000	349.1300	85464.00	0.00	85464.00	25	6	70	49	1.42857142857143	0.455584141270081	0.455584141270081	false	false	false	true
bc27b3fc-2f80-431c-bd87-81a4b0d8a1b2	2026-08-20 14:57	2026-08-20 14:57	2026-08-20 14:57	VLO	VLO260904C00370000	call	370.0000	2026-09-04	3.4000	3.0000	3.4000	343.0000	59160.00	59160.00	0.00	174	7	190	27	7.03703703703704	0.429929336736575	0.429929336736575	false	false	false	true
4c9be4fe-b87d-4e58-a516-9bf2e32036d3	2026-08-20 13:20	2026-08-20 13:20	2026-08-20 13:20	VLO	VLO260918P00330000	put	330.0000	2026-09-18	9.2100	9.1000	9.7000	344.7150	85660.00	50600.00	35060.00	93	16	1463	1332	1.09834834834835	0.418137717363143	0.418137717363143	true	false	false	true
b0a8a385-6b8e-4b9a-843c-59b27c7f7a6c	2026-08-20 12:42	2026-08-20 12:42	2026-08-20 12:42	IMO	IMO260821C00130000	call	130.0000	2026-08-21	7.6000	6.0000	8.9000	137.2500	380000.00	380000.00	0.00	500	1	501	630	0.795238095238095	0.863515895819726	0.863515895819726	false	true	false	true