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

dd10dba7-2890-44eb-80af-13aed37162c2	2026-09-24 14:35	2026-09-24 14:35	2026-09-24 14:35	HAL	HAL270319P00037000	put	37.0000	2027-03-19	5.6000	5.5500	5.7500	32.9350	17360.00	0.00	17360.00	31	8	65	522	0.124521072796935	0.389382675943494	0.389382675943494	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	27501633415.00	2026-10-20	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T18:38:47.854858Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
cf406d64-315e-4a86-9f32-dfc8f4732a93	2026-09-24 14:25	2026-09-24 14:25	2026-09-24 14:25	VLO	VLO261016P00385000	put	385.0000	2026-10-16	18.2000	16.2000	18.4000	388.7900	20020.00	14570.00	5450.00	11	11	36	56	0.642857142857143	0.548097672426546	0.543931763196123	false	false	false	true
1de623ae-c6f0-4f58-b5a3-8fe4d0f59fd4	2026-09-24 14:25	2026-09-24 14:25	2026-09-24 14:25	VLO	VLO261120P00350000	put	350.0000	2026-11-20	15.0000	14.4000	15.0000	388.7900	150000.00	150000.00	0.00	100	16	368	111	3.31531531531532	0.54433934951206	0.54123980380855	false	false	false	true
c3156887-e758-4249-abae-71eba13c7054	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	MPC	MPC261016P00430000	put	430.0000	2026-10-16	40.5000	40.5000	40.8000	396.6500	218700.00	0.00	218700.00	54	13	56	261	0.21455938697318	0.521827615162514	0.505066648776263	true	false	false	true
802cafdc-f17a-4bf0-8b7c-7ba85a0740dd	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	DINO	DINO261120C00105000	call	105.0000	2026-11-20	11.6600	11.5000	11.7000	108.2700	143380.00	78380.00	60320.00	123	18	126	16	7.875	0.568144909688255	0.568144909688255	false	false	false	true
6f480217-4462-481e-8749-eec7eb7aded0	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	MPC	MPC261016C00380000	call	380.0000	2026-10-16	29.1800	28.9000	29.2000	397.4400	78780.00	61320.00	5780.00	27	6	31	392	0.0790816326530612	0.480973010441428	0.489525890283106	false	false	false	true
45e56be0-757a-4805-b129-c85053400990	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	PSX	PSX261009P00277500	put	277.5000	2026-10-09	19.4000	19.1000	20.1000	261.3700	36860.00	5820.00	31040.00	19	5	19	0	0	0.461419099020733	0.440898584727987	false	false	false	true
201973e0-6876-420b-bddb-9090d3fd9843	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	DINO	DINO261016P00115000	put	115.0000	2026-10-16	10.1000	10.1000	10.4000	108.2700	836280.00	0.00	836280.00	828	6	829	285	2.90877192982456	0.582955184978984	0.582955184978984	false	false	false	true
018143e5-953f-4c17-ac64-b4801345530a	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	PSX	PSX260925C00247500	call	247.5000	2026-09-25	13.9000	13.3000	16.6000	261.3700	93130.00	66720.00	16680.00	67	20	67	0	0	1.35888831115948	0.364149909014807	true	false	false	true
d9c90706-9f3f-4478-ac7b-e894770b1fbc	2026-09-24 14:03	2026-09-24 14:03	2026-09-24 14:03	BP	BP261002C00046000	call	46.0000	2026-10-02	0.3200	0.2900	0.4000	44.0000	12800.00	1664.00	11136.00	400	35	966	807	1.19702602230483	0.312234242779496	0.314670967400282	false	false	false	true
741de122-1589-43ba-867e-f160b346502a	2026-09-24 14:03	2026-09-24 14:03	2026-09-24 14:03	BP	BP270115P00035000	put	35.0000	2027-01-15	0.3200	0.3200	0.4500	44.0000	39232.00	0.00	39232.00	1226	19	1226	4344	0.282228360957643	0.344129906883199	0.344129906883199	false	false	false	true
11d2df4a-335e-4e5e-a5f3-a564910bd346	2026-09-24 14:03	2026-09-24 14:03	2026-09-24 14:03	BP	BP270115P00040000	put	40.0000	2027-01-15	1.1700	1.1700	1.3000	44.0000	62946.00	0.00	62946.00	538	20	540	2515	0.214711729622266	0.329284777617218	0.329284777617218	false	false	false	true
c072f440-e248-41a4-9df9-2b8d85b3e239	2026-09-24 14:00	2026-09-24 14:00	2026-09-24 14:00	MPC	MPC261218P00370000	put	370.0000	2026-12-18	24.7000	23.1000	24.7000	398.7900	61750.00	61750.00	0.00	25	7	50	244	0.204918032786885	0.527931703080555	0.527931703080555	false	false	false	true
e6a5c812-40e2-489b-8fab-8f84e82fb7ac	2026-09-24 13:59	2026-09-24 13:59	2026-09-24 13:59	TRMD	TRMD261120C00035000	call	35.0000	2026-11-20	2.4000	2.2500	2.5000	34.4800	21360.00	6720.00	14640.00	89	6	201	167	1.20359281437126	0.466948999390734	0.466948999390734	false	false	false	true
8b257e27-acaf-4553-94e1-3339e181c158	2026-09-24 13:58	2026-09-24 13:58	2026-09-24 13:58	VLO	VLO261218C00400000	call	400.0000	2026-12-18	37.0600	36.1000	37.5000	391.2400	48180.00	29680.00	18500.00	13	6	48	388	0.123711340206186	0.522430244434689	0.521098682945944	true	false	false	true
103fea5d-1ca7-4f1a-af85-cf81dca904be	2026-09-24 13:58	2026-09-24 13:58	2026-09-24 13:58	VLO	VLO261218C00390000	call	390.0000	2026-12-18	42.0000	40.5000	42.6000	391.2400	21000.00	12600.00	8400.00	5	5	32	4332	0.00738688827331487	0.528386784982643	0.528386784982643	false	false	false	true
6af08ea7-bb17-4950-a965-9642a75ac87f	2026-09-24 13:58	2026-09-24 13:58	2026-09-24 13:58	VLO	VLO261218C00440000	call	440.0000	2026-12-18	23.0000	21.8000	23.2000	391.2400	443907.00	437007.00	2310.00	193	62	201	280	0.717857142857143	0.523301413323842	0.524689951219457	true	false	false	true
38c6666f-5e36-449a-9c5b-6a41cc41f760	2026-09-24 13:58	2026-09-24 13:58	2026-09-24 13:58	VLO	VLO261218C00420000	call	420.0000	2026-12-18	29.4000	28.1000	29.5000	391.2400	376300.00	370420.00	5880.00	128	27	133	174	0.764367816091954	0.523467195972396	0.523467195972396	true	false	false	true
b376511f-f933-44ea-941b-1c03867ed8ff	2026-09-24 13:57	2026-09-24 13:57	2026-09-24 13:57	VLO	VLO260925P00400000	put	400.0000	2026-09-25	11.1000	8.9000	11.1000	390.9600	62150.00	62150.00	0.00	56	14	90	445	0.202247191011236	0.661705652189917	0.661705652189917	false	false	false	true
990dab46-ab2f-4278-b725-af40e22425b0	2026-09-24 13:57	2026-09-24 13:57	2026-09-24 13:57	VLO	VLO260925P00407500	put	407.5000	2026-09-25	17.3000	14.8000	17.3000	390.9600	128014.00	128014.00	0.00	74	12	74	59	1.25423728813559	0.66613039885059	0.66613039885059	false	false	false	true
9717b0af-4553-4636-9317-534e9eb702e9	2026-09-24 13:57	2026-09-24 13:57	2026-09-24 13:57	MPC	MPC261016C00340000	call	340.0000	2026-10-16	60.8000	60.8000	63.0000	397.6000	352650.00	6090.00	346560.00	58	28	58	327	0.17737003058104	0.519318115173302	0.519318115173302	false	false	false	true
87f662d9-d588-4ec0-8d4b-e5d0af053c6e	2026-09-24 13:57	2026-09-24 13:57	2026-09-24 13:57	PSX	PSX261009P00260000	put	260.0000	2026-10-09	8.1000	7.3000	8.1000	262.5050	38065.00	38065.00	0.00	47	18	48	54	0.888888888888889	0.449851485935191	0.449851485935191	false	false	false	true
67fe2ecf-697e-4711-ba2d-079835c170a9	2026-09-24 13:57	2026-09-24 13:57	2026-09-24 13:57	PSX	PSX261009P00270000	put	270.0000	2026-10-09	13.6000	12.4000	13.6000	262.4400	44880.00	44880.00	0.00	33	9	33	9	3.66666666666667	0.449500227522874	0.447613030471868	false	false	false	true
dc228814-9c9d-4b46-9f92-994025af8865	2026-09-24 13:56	2026-09-24 13:56	2026-09-24 13:56	VLO	VLO261120C00410000	call	410.0000	2026-11-20	26.2000	26.2000	26.9000	392.0100	41920.00	0.00	41920.00	16	11	97	841	0.115338882282996	0.529186187571509	0.529870716104036	false	false	false	true
4c020fbe-6cca-4ff6-bc71-21ee4306d7e0	2026-09-24 13:44	2026-09-24 13:44	2026-09-24 13:44	BP	BP261002C00046000	call	46.0000	2026-10-02	0.4500	0.2200	0.5000	44.0000	13500.00	13500.00	0.00	300	5	556	807	0.688971499380421	0.326758176539871	0.328793617274273	false	false	false	true
8d310027-f82e-43f5-b7fb-c7cf960378b0	2026-09-24 13:39	2026-09-24 13:39	2026-09-24 13:39	BP	BP260925C00045500	call	45.5000	2026-09-25	0.2700	0.1500	0.2700	45.1750	12339.00	12339.00	0.00	457	15	1532	939	1.63152289669862	0.433435437436981	0.433435437436981	true	false	false	true
db29f49a-13cd-4741-82c9-9e51213f150e	2026-09-24 13:13	2026-09-24 13:13	2026-09-24 13:13	PSX	PSX261120C00270000	call	270.0000	2026-11-20	15.3000	15.3000	16.2000	261.3800	13770.00	0.00	13770.00	9	5	27	317	0.0851735015772871	0.444770965636768	0.444770965636768	false	false	false	true
15563e63-919a-410c-a9a5-ec4688754ea5	2026-09-24 13:02	2026-09-24 13:02	2026-09-24 13:02	UEC	UEC280121C00010000	call	10.0000	2028-01-21	3.0700	3.0000	3.1000	9.4150	10120.00	3410.00	0.00	33	5	74	1800	0.0411111111111111	0.735152927916273	0.722503154905073	false	false	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
77902ec8-ff26-4b5d-940f-52ab462e0c66	2026-09-24 12:51	2026-09-24 12:50	2026-09-24 12:50	VLO	VLO261002P00345000	put	345.0000	2026-10-02	1.6400	1.1500	2.1000	387.3740	16354.00	14758.00	1596.00	100	11	206	52	3.96153846153846	0.61682593263128	0.61682593263128	false	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
56685fd2-118e-4450-8392-5280cfe1dd17	2026-09-24 12:42	2026-09-24 12:42	2026-09-24 12:42	BP	BP261023C00050000	call	50.0000	2026-10-23	0.2300	0.2100	0.6000	44.8600	10285.00	0.00	10285.00	445	10	445	114	3.90350877192982	0.310303201078708	0.314154714834279	false	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
98ce1702-d4ed-4bbd-b294-09c80020677c	2026-09-24 12:17	2026-09-24 12:17	2026-09-24 12:17	TRMD	TRMD261016P00035000	put	35.0000	2026-10-16	1.6500	1.4000	1.6500	34.7400	12193.00	12033.00	160.00	74	15	276	913	0.302300109529025	0.457697221909131	0.443001687404491	false	false	false	true
3e495831-7c8b-493d-873e-dbb18c7da6b0	2026-09-24 12:04	2026-09-24 12:04	2026-09-24 12:04	OBE	OBE270115C00012500	call	12.5000	2027-01-15	1.5800	1.5000	1.6500	11.5500	15828.00	15828.00	0.00	100	5	107	4944	0.0216423948220065	0.740017905968518	0.740017905968518	false	false	false	true
1d7bd4e1-4dc9-44be-a9f3-7d4af9d5eeb7	2026-09-24 12:00	2026-09-24 12:00	2026-09-24 12:00	PSX	PSX280121P00185000	put	185.0000	2028-01-21	13.6000	12.9000	14.3000	263.1800	74800.00	17680.00	57120.00	55	9	55	12	4.58333333333333	0.45941603608176	0.45941603608176	true	false	false	true
ec2f281c-732a-4589-a31b-bbf8eaa5b8f1	2026-09-24 11:50	2026-09-24 11:50	2026-09-24 11:50	MPC	MPC261016P00380000	put	380.0000	2026-10-16	11.0000	11.0000	11.1000	400.1000	34100.00	0.00	26400.00	31	14	66	1467	0.0449897750511247	0.518160347425775	0.518160347425775	false	false	false	true
b14aa8a1-6fc8-4b55-b700-2d571092c44e	2026-09-24 11:50	2026-09-24 11:50	2026-09-24 11:50	MPC	MPC261016P00380000	put	380.0000	2026-10-16	10.9000	10.9000	11.2000	400.1000	20710.00	0.00	20710.00	19	5	35	1467	0.0238582140422631	0.515284834348448	0.515284834348448	false	false	false	true
1b5f2fa9-e3a1-4eb9-b996-7559e92e0457	2026-09-24 11:47	2026-09-24 11:47	2026-09-24 11:47	VLO	VLO261002P00410000	put	410.0000	2026-10-02	23.7600	22.9000	24.6000	391.2150	11879.00	4750.00	4754.00	5	5	10	42	0.238095238095238	0.525509605130107	0.525509605130107	false	false	false	true
d45604cb-a2ce-4a91-a174-65c25be29655	2026-09-24 11:46	2026-09-24 11:46	2026-09-24 11:46	PSX	PSX270115C00280000	call	280.0000	2027-01-15	19.4000	19.2000	19.4000	262.9500	32980.00	15520.00	0.00	17	5	144	378	0.380952380952381	0.427497426075908	0.427497426075908	false	false	false	true
3e0b3291-e861-4ade-9c60-97e2d4c90d33	2026-09-24 11:46	2026-09-24 11:46	2026-09-24 11:46	PSX	PSX270115C00280000	call	280.0000	2027-01-15	19.5000	19.5000	20.1000	263.0408	42900.00	0.00	42900.00	22	5	127	378	0.335978835978836	0.428491167804661	0.428491167804661	false	false	false	true
2591a618-a802-4643-9e2c-7f68bf82b935	2026-09-24 11:46	2026-09-24 11:45	2026-09-24 11:45	PSX	PSX270115C00280000	call	280.0000	2027-01-15	19.6000	19.5000	20.1000	263.0000	31360.00	5880.00	5880.00	16	5	105	378	0.277777777777778	0.430536930836401	0.430536930836401	false	false	false	true
90126dac-6fe0-48f3-b668-d723673d7414	2026-09-24 11:45	2026-09-24 11:45	2026-09-24 11:45	PSX	PSX270115C00280000	call	280.0000	2027-01-15	19.5000	19.4000	20.1000	263.0000	42900.00	7800.00	27300.00	22	5	89	378	0.235449735449735	0.428817533054739	0.428817533054739	false	false	false	true
4350e70e-f7bd-48de-976f-b8a396116c93	2026-09-24 11:45	2026-09-24 11:45	2026-09-24 11:45	PSX	PSX270115C00280000	call	280.0000	2027-01-15	19.6000	19.5000	20.1000	263.0000	31360.00	3920.00	15680.00	16	7	67	378	0.177248677248677	0.430536930836401	0.430536930836401	false	false	false	true