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

75854198-a98b-4f31-b4ab-196f4a458ddc	2026-09-21 13:13	2026-09-21 13:13	2026-09-21 13:13	VLO	VLO260925C00417500	call	417.5000	2026-09-25	4.2000	4.2000	5.0000	402.7250	178920.00	0.00	178920.00	426	43	480	72	6.66666666666667	0.573597797197845	0.573597797197845	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	113233232587.00	2026-10-22	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T17:16:02.178873Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
f8a37f4f-edd1-475c-9a95-d57c95d43678	2026-09-21 12:39	2026-09-21 12:39	2026-09-21 12:39	MPC	MPC261120C00440000	call	440.0000	2026-11-20	25.9000	25.4000	25.9000	415.0499	15540.00	15540.00	0.00	6	6	38	160	0.2375	0.520991649384938	0.520991649384938	true	false	false	true
9b9efb22-4342-475b-b924-2296acbf0bb5	2026-09-21 12:30	2026-09-21 12:30	2026-09-21 12:30	HAL	HAL270115P00030000	put	30.0000	2027-01-15	1.2400	1.2400	1.2700	33.0000	11160.00	0.00	11160.00	90	16	90	2797	0.0321773328566321	0.381738889012368	0.381738889012368	false	false	false	true
2bd04150-1293-4612-a33f-dce231896663	2026-09-21 12:22	2026-09-21 12:21	2026-09-21 12:21	PSX	PSX261218C00290000	call	290.0000	2026-12-18	14.1500	13.8000	14.4000	265.7550	42450.00	25470.00	0.00	30	5	49	600	0.0816666666666667	0.431115289483578	0.431115289483578	false	false	false	true
bdd474a5-1226-49a3-86b1-618f8e779bad	2026-09-21 12:06	2026-09-21 12:06	2026-09-21 12:06	VLO	VLO261016C00450000	call	450.0000	2026-10-16	7.9800	7.3000	8.1000	405.3006	11965.00	11965.00	0.00	15	6	180	196	0.918367346938776	0.534222083526497	0.523298731919447	false	false	false	true
99998b86-a629-468c-bd40-ea25be07e173	2026-09-21 12:06	2026-09-21 12:06	2026-09-21 12:06	HAL	HAL270115C00032000	call	32.0000	2027-01-15	3.5000	3.5000	3.6000	33.2650	11200.00	0.00	11200.00	32	5	43	9723	0.00442250334258974	0.352451180622665	0.352451180622665	false	false	false	true
f0f32ab1-c5b4-413d-8725-e023a59b66f1	2026-09-21 11:28	2026-09-21 11:28	2026-09-21 11:28	MPC	MPC261016P00380000	put	380.0000	2026-10-16	8.5000	8.0000	8.5000	414.5400	34850.00	34850.00	0.00	41	5	552	2102	0.262607040913416	0.527731946544718	0.527731946544718	false	false	false	true
252c2cd7-1203-4b01-b460-6acecd7d1bf2	2026-09-21 11:26	2026-09-21 11:26	2026-09-21 11:26	MPC	MPC261016P00410000	put	410.0000	2026-10-16	19.5000	19.0000	19.7000	415.0400	42890.00	42890.00	0.00	22	16	158	257	0.614785992217899	0.522186857958894	0.519842440147675	false	false	false	true
1ae86ef7-e4c7-4ca4-9fd4-5c00afeb887c	2026-09-21 11:25	2026-09-21 11:25	2026-09-21 11:25	VLO	VLO280121P00230000	put	230.0000	2028-01-21	11.8500	10.0000	13.5000	405.2300	11845.00	1180.00	10665.00	10	5	10	8	1.25	0.502494689756426	0.50865923506573	false	false	false	true
e6a803b8-146c-4716-a899-5dab5afea0a3	2026-09-21 11:10	2026-09-21 11:10	2026-09-21 11:10	VLO	VLO261023P00410000	put	410.0000	2026-10-23	26.2000	25.4000	26.2000	405.0000	23580.00	23580.00	0.00	9	5	19	13	1.46153846153846	0.517956661748172	0.517956661748172	false	false	false	true
2cae9d63-3937-4252-a487-eeb2a4f7be5b	2026-09-21 10:49	2026-09-21 10:49	2026-09-21 10:49	PSX	PSX260925P00250000	put	250.0000	2026-09-25	0.8000	0.7000	1.0000	266.9800	48560.00	0.00	40960.00	607	50	613	104	5.89423076923077	0.526833857306581	0.526833857306581	false	false	false	true
5cc9721c-62c5-4d88-b417-ce0ea6b11ea2	2026-09-21 10:46	2026-09-21 10:46	2026-09-21 10:46	VLO	VLO261016C00520000	call	520.0000	2026-10-16	1.1000	1.1000	1.4500	405.7800	21015.00	0.00	21015.00	191	50	191	106	1.80188679245283	0.541487471793019	0.541487471793019	false	false	false	true
625582e3-aec2-4ae2-a08b-c91562e93f71	2026-09-21 10:42	2026-09-21 10:42	2026-09-21 10:42	PSX	PSX260925C00280000	call	280.0000	2026-09-25	1.4000	1.3000	1.8000	268.2970	11480.00	1680.00	8400.00	82	13	654	553	1.18264014466546	0.462518026111492	0.462518026111492	true	false	false	true
f240acd8-d02f-4b0a-8eef-4bc96058d740	2026-09-21 10:29	2026-09-21 10:29	2026-09-21 10:29	PSX	PSX260925C00275000	call	275.0000	2026-09-25	2.4000	2.4000	2.6500	267.7450	12960.00	0.00	12960.00	54	11	119	116	1.02586206896552	0.459755218619182	0.459755218619182	true	false	false	true
6967428c-f597-42bb-87ab-ad44acfef335	2026-09-21 10:19	2026-09-21 10:19	2026-09-21 10:19	MPC	MPC261016C00530000	call	530.0000	2026-10-16	1.4000	1.2000	2.4500	415.9950	14285.00	140.00	14145.00	102	9	102	206	0.495145631067961	0.554445018185275	0.554445018185275	false	false	false	true
1f0a41d9-c6b6-4c95-9b1f-dbba640d7985	2026-09-21 10:18	2026-09-21 10:18	2026-09-21 10:18	VLO	VLO260925C00425000	call	425.0000	2026-09-25	3.3000	3.1000	4.5000	404.3400	11220.00	2640.00	8580.00	34	5	48	175	0.274285714285714	0.607465371231078	0.607554533973121	true	false	false	true
caaf5ab7-da56-4437-97e6-9292b566b241	2026-09-21 10:18	2026-09-21 10:18	2026-09-21 10:18	MPC	MPC261016P00380000	put	380.0000	2026-10-16	8.2000	8.1000	8.5000	415.9300	49200.00	37720.00	11480.00	60	5	213	2102	0.101332064700285	0.528433478036388	0.528433478036388	false	false	false	true
b96c7885-ee4e-488e-88c7-7667050498af	2026-09-21 10:13	2026-09-21 10:13	2026-09-21 10:13	HAL	HAL270115C00040000	call	40.0000	2027-01-15	0.7500	0.7100	0.7900	32.8800	11925.00	75.00	11850.00	159	27	174	5440	0.0319852941176471	0.363214010274661	0.363214010274661	false	false	false	true
accca491-eb7f-409e-9d33-5e6b6ed83fe9	2026-09-21 10:12	2026-09-21 10:12	2026-09-21 10:12	MPC	MPC261016C00420000	call	420.0000	2026-10-16	21.8000	21.3000	21.8000	416.0000	15260.00	15260.00	0.00	7	7	63	644	0.0978260869565217	0.526807178705155	0.526807178705155	false	false	false	true
8339e69f-9b84-49a2-a904-a24889560f11	2026-09-21 10:12	2026-09-21 10:12	2026-09-21 10:12	MPC	MPC261016C00420000	call	420.0000	2026-10-16	21.8000	21.3000	21.8000	416.0000	34880.00	34880.00	0.00	16	9	56	644	0.0869565217391304	0.523347005128181	0.523347005128181	false	false	false	true
ca0cdfc8-46df-4c12-9e38-29aa5c16969b	2026-09-21 10:08	2026-09-21 10:08	2026-09-21 10:08	VLO	VLO270115C00430000	call	430.0000	2027-01-15	39.5000	38.5000	39.5000	406.8400	146150.00	146150.00	0.00	37	11	37	87	0.425287356321839	0.512225018003639	0.512225018003639	false	false	false	true
7a849b47-7046-438e-9894-9a137bcf57d4	2026-09-21 10:07	2026-09-21 10:07	2026-09-21 10:07	VLO	VLO260925P00390000	put	390.0000	2026-09-25	4.1000	3.1000	4.9000	406.7300	204788.00	200487.00	4301.00	500	5	538	180	2.98888888888889	0.614121408576127	0.614121408576127	false	false	false	true
ad57be0d-6811-45fb-932c-b0824ece08c1	2026-09-21 10:03	2026-09-21 10:03	2026-09-21 10:03	VLO	VLO261016P00410000	put	410.0000	2026-10-16	23.5000	23.3000	24.0000	406.2550	47000.00	0.00	47000.00	20	5	47	140	0.335714285714286	0.521143697329092	0.521143697329092	false	false	false	true
74057409-f753-4472-aed0-529bcfa50408	2026-09-21 10:02	2026-09-21 10:02	2026-09-21 10:02	BP	BP261016C00046000	call	46.0000	2026-10-16	0.7200	0.7100	0.7900	43.8700	62208.00	72.00	62136.00	864	38	879	5871	0.149718957588145	0.323028552766608	0.323799487418471	false	false	false	true
e5440ccd-fdd3-47a2-a328-817eb0724c25	2026-09-18 14:38	2026-09-18 14:38	2026-09-18 14:38	HAL	HAL261016C00034000	call	34.0000	2026-10-16	1.2200	1.2200	1.2400	33.7300	15372.00	0.00	15372.00	126	20	536	1705	0.314369501466276	0.348513550563249	0.348513550563249	false	false	false	true
d5d6f62d-caad-4552-9d7f-a86c3c7b1298	2026-09-18 14:32	2026-09-18 14:32	2026-09-18 14:32	HAL	HAL261016C00034000	call	34.0000	2026-10-16	1.2500	1.2500	1.2700	33.7850	37922.00	0.00	32000.00	303	23	410	1705	0.240469208211144	0.351829083609956	0.349150041850173	false	false	false	true
c0ede211-73c5-41d6-bc03-cc1719f7bde9	2026-09-18 13:56	2026-09-18 13:56	2026-09-18 13:56	MPC	MPC261016P00420000	put	420.0000	2026-10-16	21.2000	20.9000	21.2000	423.5200	116600.00	116600.00	0.00	55	7	200	52	3.84615384615385	0.505896015209389	0.505896015209389	true	false	false	true
65276bbf-3341-4e19-a798-55fa0ffe200b	2026-09-18 13:46	2026-09-18 13:46	2026-09-18 13:46	PSX	PSX261120C00270000	call	270.0000	2026-11-20	21.5000	20.7000	21.5000	271.7400	51593.00	51593.00	0.00	24	12	39	297	0.131313131313131	0.439170796997983	0.439170796997983	false	false	false	true
6ddef9ac-2c43-49da-ac60-3fa7d758507b	2026-09-18 13:40	2026-09-18 13:40	2026-09-18 13:40	VLO	VLO270115C00420000	call	420.0000	2027-01-15	45.0100	44.6000	47.4000	410.3900	184540.00	0.00	184540.00	41	5	82	180	0.455555555555556	0.496787807790568	0.511857130667709	false	false	false	true
e6258dae-0752-486d-b9e6-0adf86035b12	2026-09-18 13:21	2026-09-18 13:21	2026-09-18 13:21	HAL	HAL270115P00030000	put	30.0000	2027-01-15	1.1800	1.1800	1.2500	33.6950	14514.00	0.00	14514.00	123	27	308	2557	0.120453656628862	0.384336721790331	0.384336721790331	false	false	false	true
b8ed300f-fe8d-47ce-aefe-88fb1a420868	2026-09-18 12:29	2026-09-18 12:29	2026-09-18 12:29	VLO	VLO260918C00380000	call	380.0000	2026-09-18	30.0000	30.0000	32.4000	410.0000	75000.00	0.00	75000.00	25	7	66	2245	0.0293986636971047	3.73830940592835	3.73830940592835	false	false	false	true
bf7e2d53-17c3-4745-b71d-47ba0e0afaf9	2026-09-18 11:49	2026-09-18 11:49	2026-09-18 11:49	FTI	FTI270319P00070000	put	70.0000	2027-03-19	6.2000	5.8000	6.2000	71.1700	128960.00	128960.00	0.00	208	24	208	0	0	0.380827905764739	0.380827905764739	false	false	false	true
0753d0f7-8a0d-4607-b827-c312533f2feb	2026-09-18 11:31	2026-09-18 11:31	2026-09-18 11:31	HAL	HAL270115P00030000	put	30.0000	2027-01-15	1.1800	1.1800	1.2100	33.7450	21712.00	0.00	21712.00	184	39	184	2557	0.0719593273367227	0.38634434529052	0.38634434529052	false	false	false	true
b49528f6-5916-4ba3-a16f-d8e066114ca5	2026-09-18 10:39	2026-09-18 10:39	2026-09-18 10:39	VLO	VLO270617P00450000	put	450.0000	2027-06-17	87.3200	86.4000	88.6000	414.0000	52390.00	17460.00	34930.00	6	6	7	75	0.0933333333333333	0.525348575266603	0.524642547482461	false	false	false	true
d0357b43-f881-4300-b6b1-f03229766f7e	2026-09-18 09:51	2026-09-18 09:51	2026-09-18 09:51	VLO	VLO261030C00410000	call	410.0000	2026-10-30	34.3000	32.2000	34.3000	414.8500	68600.00	68600.00	0.00	20	6	20	20	1	0.553853390794285	0.553853390794285	false	false	false	true
413a727d-9ab1-43de-80c1-ca34d174f9dc	2026-09-18 09:40	2026-09-18 09:40	2026-09-18 09:40	MPC	MPC260918P00420000	put	420.0000	2026-09-18	3.7000	3.7000	5.3000	420.4700	102500.00	0.00	102500.00	277	14	277	198	1.3989898989899	0.829013206949294	0.873637785218065	false	false	false	true
ded8f430-e979-4ad5-b7fa-9ec42f8656e4	2026-09-17 15:34	2026-09-17 15:34	2026-09-17 15:34	HAL	HAL261120C00032000	call	32.0000	2026-11-20	3.5500	3.4500	3.5500	33.9950	44375.00	44375.00	0.00	125	6	988	4655	0.212244897959184	0.412978269612406	0.412978269612406	false	false	false	true
f0b100de-a025-4de8-bcc1-e09d7eb33d1f	2026-09-17 15:25	2026-09-17 15:25	2026-09-17 15:25	PSX	PSX261120P00270000	put	270.0000	2026-11-20	18.3000	17.8000	18.8000	272.2700	65880.00	64050.00	1830.00	36	10	165	122	1.35245901639344	0.451409077652092	0.451409077652092	false	false	false	true
7f184655-87c1-4b4a-9046-0f5f9d8e2b8f	2026-09-17 15:22	2026-09-17 15:22	2026-09-17 15:22	VLO	VLO270617P00450000	put	450.0000	2027-06-17	88.5500	87.2000	88.9000	411.7550	487030.00	487030.00	0.00	55	25	65	9	7.22222222222222	0.528719040061481	0.525887472340034	false	false	false	true
0e0c4004-2def-45bd-9c21-2fcf3c9dfe68	2026-09-17 15:06	2026-09-17 15:06	2026-09-17 15:06	VLO	VLO280121C00580000	call	580.0000	2028-01-21	49.1100	46.0000	49.3000	412.3450	137500.00	117860.00	19640.00	28	11	30	24	1.25	0.468258562189794	0.469337010132845	false	false	false	true
d8a877b3-20c0-4189-acbb-e41bc92b67ba	2026-09-17 15:06	2026-09-17 15:06	2026-09-17 15:06	VLO	VLO280121P00380000	put	380.0000	2028-01-21	62.1200	62.0000	63.8000	411.9400	205010.00	93310.00	111700.00	33	11	33	502	0.0657370517928287	0.49646873273692	0.497075338718341	true	false	false	true
c4b29c30-7ba0-4e75-a7b5-69297d43bd32	2026-09-17 14:52	2026-09-17 14:51	2026-09-17 14:51	BP	BP270115C00044000	call	44.0000	2027-01-15	4.1000	4.1000	4.2500	45.5500	61910.00	0.00	61910.00	151	23	258	1874	0.137673425827108	0.284784253932571	0.284784253932571	false	false	false	true
1c002e76-afe0-486f-b1d7-8e995c866d54	2026-09-17 13:19	2026-09-17 13:19	2026-09-17 13:19	HAL	HAL260918C00035000	call	35.0000	2026-09-18	0.1000	0.0500	0.1200	34.0350	24809.00	23810.00	569.00	2481	90	2538	28806	0.0881066444490731	0.587516559583042	0.575950234678137	true	false	false	true
a7bc55b6-a2ee-4513-b1fe-1c3aa0417743	2026-09-17 13:04	2026-09-17 13:03	2026-09-17 13:03	VLO	VLO261218C00370000	call	370.0000	2026-12-18	66.0000	65.9000	66.3000	410.4850	1650000.00	6600.00	1643400.00	250	19	253	296	0.85472972972973	0.515337622042055	0.515337622042055	false	false	false	true
0b925bfb-272a-4dbd-9aa1-52bb933286f4	2026-09-17 12:54	2026-09-17 12:54	2026-09-17 12:54	HAL	HAL261218C00040000	call	40.0000	2026-12-18	0.8200	0.7800	0.8300	34.0000	36490.00	33538.00	492.00	445	25	780	9031	0.0863691728490754	0.375266361204747	0.375266361204747	false	false	false	true
847c841c-433c-436b-8e84-cbfd0343a6ec	2026-09-17 12:51	2026-09-17 12:51	2026-09-17 12:51	VLO	VLO261120P00420000	put	420.0000	2026-11-20	40.0000	40.0000	41.3000	409.8700	52000.00	0.00	52000.00	13	13	22	0	0	0.52732934514942	0.52732934514942	false	false	false	true
add2345a-c411-4b54-8d2c-eb3417889f44	2026-09-17 12:40	2026-09-17 12:40	2026-09-17 12:40	VLO	VLO261218P00410000	put	410.0000	2026-12-18	41.1000	40.1000	41.1000	409.7050	1031610.00	1031610.00	0.00	251	36	287	762	0.376640419947507	0.529419796400719	0.529419796400719	false	false	false	true
59fcf275-a82c-4e3b-9d87-b9009ed44e4e	2026-09-17 12:12	2026-09-17 12:12	2026-09-17 12:12	HAL	HAL270115P00032000	put	32.0000	2027-01-15	1.8800	1.8800	1.9300	33.9250	19928.00	0.00	19928.00	106	13	127	2402	0.0528726061615321	0.389808183006552	0.389808183006552	false	false	false	true
a8e212d1-cdb1-49f8-8218-172403947f07	2026-09-17 12:03	2026-09-17 12:03	2026-09-17 12:03	HAL	HAL261120C00036000	call	36.0000	2026-11-20	1.4500	1.3500	1.4500	33.9000	14500.00	145.00	0.00	100	24	115	344	0.334302325581395	0.387540718401389	0.387540718401389	false	false	false	true
5af18dcb-e347-43e4-8e5e-9f736fec15c2	2026-09-17 12:02	2026-09-17 12:02	2026-09-17 12:02	VLO	VLO260925C00432500	call	432.5000	2026-09-25	3.8000	3.7000	4.3000	407.3450	79040.00	0.00	78660.00	208	51	208	3	69.3333333333333	0.502970736376909	0.502970736376909	false	false	false	true