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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×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	expiry

0bb71eea-e120-4b20-be8d-94241fc07cd8	2026-09-23 15:47	2026-09-23 15:47	2026-09-23 15:47	CLMT	CLMT261120C00055000	call	55.0000	2026-11-20	5.6900	5.5000	5.7000	54.0000	12520.00	11970.00	550.00	22	5	609	2070	0.294202898550725	0.677812261106266	0.689862892614875	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	4779905965.00	2026-11-06	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:47:37.737983Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
5e641dec-56c7-42f6-9b77-db07d4a30c84	2026-09-23 15:32	2026-09-23 15:32	2026-09-23 15:32	VLO	VLO261016P00320000	put	320.0000	2026-10-16	3.2500	2.5500	3.5000	375.9900	74186.00	73886.00	300.00	228	57	417	3935	0.105972045743329	0.563378532795089	0.563943014696501	false	false	false	true
c3d5926e-31a8-43d0-bd86-86e30458818d	2026-09-23 14:41	2026-09-23 14:41	2026-09-23 14:41	VLO	VLO260925P00355000	put	355.0000	2026-09-25	2.1200	1.4500	2.3500	373.8800	159069.00	153909.00	5160.00	750	70	1137	675	1.68444444444444	0.746294962282867	0.785969962315488	false	false	false	true
9806df03-a10f-4de6-809d-cd3e8fed8adb	2026-09-23 14:35	2026-09-23 14:35	2026-09-23 14:35	PR	PR261016C00025000	call	25.0000	2026-10-16	0.1500	0.1000	0.2000	21.6950	15248.00	15116.00	72.00	1028	74	1902	35500	0.0535774647887324	0.453369816008882	0.46126002066118	false	false	false	true
f2e5eaa8-1fad-45b5-b73d-3da6b9d6cd4a	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	VLO	VLO261023C00400000	call	400.0000	2026-10-23	12.8900	11.3000	13.2000	371.4555	387920.00	274100.00	113820.00	301	42	505	33	15.3030303030303	0.543726070044696	0.550790570671916	true	false	false	true
47720602-60c6-4570-a037-464b10c20040	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	VLO	VLO261023C00400000	call	400.0000	2026-10-23	12.8900	11.3000	13.2000	371.4555	113453.00	113453.00	0.00	88	9	593	33	17.969696969697	0.544736392178394	0.544736392178394	false	false	false	true
6399a53b-da31-4b41-a399-9c451df1f0f0	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.7800	18.7500	18.8500	161.1800	37564.00	15052.00	22512.00	20	6	494	1049	0.470924690181125	0.296085759336721	0.299319763222368	false	false	false	true
b0afff14-7e49-4625-91a7-d42edc8f9f8f	2026-09-23 13:59	2026-09-23 13:59	2026-09-23 13:59	PBF	PBF261120C00080000	call	80.0000	2026-11-20	4.5600	4.5000	5.1000	70.1750	71590.00	25300.00	46290.00	157	7	181	423	0.42789598108747	0.704082728866763	0.713454493664618	false	false	false	true
94593b84-eeaa-45ce-a150-a886b57517d4	2026-09-23 13:43	2026-09-23 13:42	2026-09-23 13:42	MPC	MPC261016P00350000	put	350.0000	2026-10-16	5.9000	5.6000	6.1000	386.0000	18286.00	18286.00	0.00	31	6	301	856	0.351635514018692	0.518666503577614	0.519037226060504	false	false	false	true
9649b5ec-5fe4-401b-9c74-a5bd8615dbbd	2026-09-23 13:20	2026-09-23 13:20	2026-09-23 13:20	MPC	MPC270617P00310000	put	310.0000	2027-06-17	25.1300	24.9000	26.5000	384.2200	781603.00	20480.00	761123.00	311	60	312	37	8.43243243243243	0.500132017743344	0.500132017743344	true	false	false	true
64d77565-80c2-4d57-9655-e95cc8cd82d0	2026-09-23 13:18	2026-09-23 13:18	2026-09-23 13:18	CVX	CVX261016P00197500	put	197.5000	2026-10-16	2.3600	2.3000	2.5700	205.0000	31177.00	478.00	30699.00	132	33	201	149	1.3489932885906	0.276626348691255	0.278407069333352	true	false	false	true
4e213c82-463d-4747-962c-3de2076ebb0d	2026-09-23 13:18	2026-09-23 13:18	2026-09-23 13:18	XOM	XOM261009P00157500	put	157.5000	2026-10-09	2.5400	2.5100	2.7200	160.0000	22604.00	3052.00	19552.00	89	21	616	106	5.81132075471698	0.297687930514319	0.297687930514319	true	false	false	true
07de7f2f-a4f8-4f2b-af50-7f091e4fbceb	2026-09-23 13:08	2026-09-23 13:08	2026-09-23 13:08	CVX	CVX261002P00202500	put	202.5000	2026-10-02	2.3000	2.3000	2.5200	205.5450	32895.00	234.00	32661.00	143	30	242	161	1.50310559006211	0.289467878714154	0.292795369022896	true	false	false	true
4e82c784-5d19-40e1-8b93-8de5d26f3445	2026-09-23 13:04	2026-09-23 13:04	2026-09-23 13:04	CVX	CVX261002P00202500	put	202.5000	2026-10-02	2.3800	2.3200	2.5900	205.4150	16153.00	5238.00	10203.00	68	36	98	161	0.608695652173913	0.291418807772728	0.291418807772728	true	false	false	true
b766a6ca-857d-4301-83d4-14fe8cdf495e	2026-09-23 12:47	2026-09-23 12:47	2026-09-23 12:47	MPC	MPC261016P00370000	put	370.0000	2026-10-16	11.3100	11.3000	11.9000	388.3100	48650.00	1160.00	47490.00	43	6	339	1493	0.227059611520429	0.512558027426994	0.521119686507634	false	false	false	true
93a6eddd-3644-4d9c-8010-08ff81e5fb30	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261120C00057500	call	57.5000	2026-11-20	3.4900	3.4500	3.5000	57.7110	24785.00	20300.00	4485.00	71	8	108	2320	0.046551724137931	0.345202789582032	0.345202789582032	false	false	false	true
8b44e120-2e89-4f97-9c23-e90d3f4c9bae	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	CVI	CVI261016C00047500	call	47.5000	2026-10-16	5.4000	5.4000	6.7000	51.0000	36183.00	0.00	36183.00	67	15	67	18	3.72222222222222	0.580008766376436	0.666457952085916	false	false	false	true
78315797-e53d-4049-ab0e-f6df6d4417af	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	PR	PR261016C00021000	call	21.0000	2026-10-16	1.3000	1.3000	1.3500	21.8450	23022.00	0.00	23022.00	177	22	185	2057	0.0899368011667477	0.359266649935938	0.359266649935938	false	false	false	true
72408673-ea43-4e79-bdc4-f54c72b89fc1	2026-09-23 12:10	2026-09-23 12:10	2026-09-23 12:10	XOM	XOM261009P00157500	put	157.5000	2026-10-09	2.3400	2.2900	2.4300	160.9600	103899.00	236.00	103663.00	444	44	522	106	4.92452830188679	0.295640820506023	0.297258325059752	false	false	false	true
94ef04f9-fd70-408e-894e-63d6a0b68a82	2026-09-23 12:04	2026-09-23 12:04	2026-09-23 12:04	VLO	VLO260925P00370000	put	370.0000	2026-09-25	3.2200	3.0000	3.7000	381.1300	31880.00	10020.00	21860.00	99	9	201	1346	0.149331352154532	0.669409522514213	0.677498962879839	false	false	false	true
a5fea08c-460e-4e54-a02e-ddebec8e20fb	2026-09-23 11:19	2026-09-23 11:19	2026-09-23 11:19	SEI	SEI261016C00070000	call	70.0000	2026-10-16	3.6500	3.4000	3.7000	66.6000	18626.00	18626.00	0.00	51	7	175	3078	0.0568551007147498	0.746469564865179	0.746469564865179	false	false	false	true
61b1ca7f-bad1-44f9-9a6f-84f273e88d11	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	CVX	CVX261016C00212500	call	212.5000	2026-10-16	2.8400	2.8200	2.8400	205.5700	29788.00	25276.00	4512.00	105	5	115	485	0.237113402061856	0.259799409768146	0.260867962805663	false	false	false	true
9aee1d61-d6eb-4744-9785-7648746db9e2	2026-09-23 10:22	2026-09-23 10:22	2026-09-23 10:22	XOM	XOM270617C00190000	call	190.0000	2027-06-17	7.3200	7.2000	7.4500	161.7700	11710.00	2940.00	8770.00	16	5	89	818	0.10880195599022	0.272291877774805	0.273287118723791	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
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
14b90a56-222e-4cd4-879a-48f45df18040	2026-09-23 09:50	2026-09-23 09:50	2026-09-23 09:50	CVX	CVX270617C00260000	call	260.0000	2027-06-17	4.7900	4.0000	4.9500	205.7700	11975.00	1440.00	10535.00	25	6	25	468	0.0534188034188034	0.25495779053641	0.255948921165218	false	false	false	true
97524fc6-9295-42df-81ac-ec0bb3525e67	2026-09-23 09:43	2026-09-23 09:43	2026-09-23 09:43	CVX	CVX260925P00205000	put	205.0000	2026-09-25	2.1000	2.0500	2.4300	204.8322	15513.00	6527.00	8986.00	74	26	75	675	0.111111111111111	0.335141817816888	0.335141817816888	true	false	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
3dc199dc-2eb5-4132-ae81-b0f77e220e8b	2026-09-22 15:37	2026-09-22 15:37	2026-09-22 15:37	WMB	WMB270115C00085000	call	85.0000	2027-01-15	0.9100	0.9000	1.1000	71.0200	18013.00	0.00	18013.00	198	6	732	1277	0.573218480814409	0.279779837729974	0.280794386736621	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
6dc31be5-4cb9-4d9c-8ca4-035e762df585	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	XOM	XOM261009P00150000	put	150.0000	2026-10-09	1.0100	0.9600	1.0200	158.0000	30581.00	30480.00	101.00	302	19	943	143	6.59440559440559	0.304329521843277	0.305461340538056	false	false	false	true
ff4d6277-0ab1-4e6a-8dcd-ca7f3e7fdc83	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	EXE	EXE270115C00110000	call	110.0000	2027-01-15	1.1900	1.1000	1.2000	87.0000	21494.00	21494.00	0.00	180	6	202	9108	0.0221783047870004	0.335143298802033	0.335143298802033	false	false	false	true
2e345497-12e4-4a9d-8131-95757ded7549	2026-09-22 15:19	2026-09-22 15:19	2026-09-22 15:19	CVX	CVX261016C00210000	call	210.0000	2026-10-16	2.9300	2.8900	3.0500	202.9500	54213.00	19737.00	34476.00	185	42	619	18776	0.032967618236046	0.264565708614218	0.264565708614218	true	false	false	true
e42bc70e-46ff-42f6-a5c6-1d125e948236	2026-09-22 15:19	2026-09-22 15:19	2026-09-22 15:19	CVX	CVX261016C00202500	call	202.5000	2026-10-16	6.0600	6.0000	6.3000	202.9500	30315.00	7930.00	22385.00	50	28	138	0	0	0.267924817474869	0.267924817474869	true	false	false	true
ac9e7089-ea4c-406b-bf0b-90349f23a058	2026-09-22 15:16	2026-09-22 15:16	2026-09-22 15:16	OKE	OKE280121C00125000	call	125.0000	2028-01-21	3.2900	3.0000	3.3000	90.6896	18075.00	18075.00	0.00	55	5	100	219	0.45662100456621	0.258446146308653	0.258446146308653	false	false	false	true
45c469b4-1eb3-4f1b-bfbe-3c8e38513322	2026-09-22 14:55	2026-09-22 14:55	2026-09-22 14:55	CVX	CVX261016C00215000	call	215.0000	2026-10-16	1.7300	1.6500	1.7300	203.2600	12792.00	12792.00	0.00	74	8	180	144	1.25	0.263652403709845	0.264293017652584	false	false	false	true
12d5bc2d-0e26-4be1-a019-984b0b964e0d	2026-09-22 14:28	2026-09-22 14:28	2026-09-22 14:28	VLO	VLO261002C00405000	call	405.0000	2026-10-02	8.4400	7.9000	8.9000	390.2550	16030.00	5950.00	10080.00	19	5	56	119	0.470588235294118	0.550489308410619	0.550489308410619	true	false	false	true
a37ab44d-60e0-4d01-bc32-3999873e771f	2026-09-22 14:19	2026-09-22 14:19	2026-09-22 14:19	MPC	MPC261218C00380000	call	380.0000	2026-12-18	51.3400	50.1000	52.5000	399.8200	56478.00	56478.00	0.00	11	7	42	274	0.153284671532847	0.509208123285302	0.509208123285302	false	false	false	true
03b09f63-3979-4b87-b64f-9a3be8c35985	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	CVX	CVX261002C00210000	call	210.0000	2026-10-02	1.2800	1.2700	1.2800	203.5000	38651.00	38016.00	635.00	302	9	1012	460	2.2	0.261058963533584	0.261996458585407	true	false	false	true
02824c22-44da-47c0-a3bf-d61a38be9f74	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	VLO	VLO261016P00385000	put	385.0000	2026-10-16	19.7400	18.3000	21.4000	385.7050	98710.00	65730.00	32980.00	50	10	66	5	13.2	0.516146722642029	0.529798225323376	false	false	false	true
42bd72a9-2bc3-42cd-8cc3-2f2f48454270	2026-09-22 13:52	2026-09-22 13:51	2026-09-22 13:51	VLO	VLO261009P00385000	put	385.0000	2026-10-09	17.8600	14.6000	18.3000	385.7708	39286.00	21686.00	0.00	22	7	41	33	1.24242424242424	0.560770134803408	0.571128434873134	true	false	false	true
48a44cfe-427a-4ebc-b8d9-8e7a2430b8d7	2026-09-22 13:52	2026-09-22 13:51	2026-09-22 13:51	VLO	VLO260925P00392500	put	392.5000	2026-09-25	12.2600	9.8000	13.0000	386.2650	17170.00	11010.00	6160.00	14	6	23	63	0.365079365079365	0.644730846394466	0.603709868219667	false	false	false	true
a18e20ef-aa40-4c64-b242-55cca3d09cff	2026-09-22 13:45	2026-09-22 13:45	2026-09-22 13:45	ET	ET270115C00020000	call	20.0000	2027-01-15	1.3200	1.3200	1.4000	20.8250	66135.00	134.00	66001.00	501	36	768	98973	0.00775969203722227	0.136455114348882	0.144175297747343	false	false	false	true
263abca6-bf12-4a4b-844f-6a8806620674	2026-09-22 13:02	2026-09-22 13:02	2026-09-22 13:02	PBR	PBR270617C00022000	call	22.0000	2027-06-17	2.1000	2.0300	2.1400	20.0000	105160.00	44680.00	60480.00	500	75	500	20955	0.0238606537819136	0.338875420083262	0.340294661364676	false	false	false	true
51606dda-7de2-45a8-b5ca-dfba90835933	2026-09-22 12:44	2026-09-22 12:44	2026-09-22 12:44	OXY	OXY261120C00057500	call	57.5000	2026-11-20	3.2000	3.1500	3.2000	57.1150	18866.00	18866.00	0.00	59	11	188	2106	0.0892687559354226	0.34877032808241	0.349864564904085	false	false	false	true
27c7dde3-e433-4bec-9267-0981345afdaf	2026-09-22 12:43	2026-09-22 12:43	2026-09-22 12:43	EXE	EXE270115C00105000	call	105.0000	2027-01-15	1.7000	1.6000	1.7500	87.3500	17474.00	14924.00	2550.00	103	12	222	6237	0.0355940355940356	0.328713903527177	0.330157093974577	false	false	false	true
7e2795e7-b747-44df-b892-3623711f9275	2026-09-22 12:02	2026-09-22 12:02	2026-09-22 12:02	XOM	XOM270115C00190000	call	190.0000	2027-01-15	2.3200	2.2800	2.4200	159.8550	45242.00	233.00	45009.00	195	31	245	2580	0.0949612403100775	0.284993905294125	0.285418583518275	false	false	false	true
8add02d9-e65a-43d9-8a40-bfb433e813b9	2026-09-22 12:01	2026-09-22 12:00	2026-09-22 12:00	VLO	VLO261002P00360000	put	360.0000	2026-10-02	3.1700	2.6000	3.4000	392.0450	93838.00	61198.00	32640.00	296	57	1067	584	1.82705479452055	0.541344383035309	0.554055711169344	true	false	false	true
3d8e3d27-1da0-4139-9b8e-e8725e493e34	2026-09-22 11:59	2026-09-22 11:59	2026-09-22 11:59	OVV	OVV261016P00055000	put	55.0000	2026-10-16	0.6100	0.5500	0.6500	59.8000	175440.00	0.00	0.00	2856	13	2860	3813	0.750065565171781	0.386226256491365	0.398567626581675	false	false	false	true
2cb089f8-1c8b-4109-8e76-cb31579bca68	2026-09-22 11:36	2026-09-22 11:36	2026-09-22 11:36	CVX	CVX270319P00210000	put	210.0000	2027-03-19	18.5800	18.4000	18.6500	203.6800	20435.00	9290.00	9285.00	11	8	41	650	0.0630769230769231	0.308124882408276	0.309007755115468	true	false	false	true