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:alert_rule = RepeatedHits×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

0c826a23-f8f0-474f-8585-0264266c8ded	2026-09-25 09:33	2026-09-25 09:33	2026-09-25 09:33	XOM	XOM261120C00145000	call	145.0000	2026-11-20	17.8800	17.7000	18.1000	160.0100	16095.00	5415.00	10680.00	9	6	28	2225	0.0125842696629213	0.303099744733655	0.318407900273478	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	660331941656.00	2026-10-30	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T13:33:47.828400Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
220787f8-5ab7-442b-acb7-7c433fa8f299	2026-09-25 09:32	2026-09-25 09:32	2026-09-25 09:32	VLO	VLO260925P00370000	put	370.0000	2026-09-25	1.5000	1.2500	1.5000	376.3433	12600.00	2250.00	0.00	84	34	88	1078	0.0816326530612245	0.95911954120921	0.95911954120921	false	false	false	true
7deaa30e-9491-4809-9de0-048782dd6466	2026-09-25 09:30	2026-09-25 09:30	2026-09-25 09:30	RIG	RIG261218P00004500	put	4.5000	2026-12-18	0.1400	0.1100	0.2200	5.3900	10920.00	0.00	3080.00	780	5	780	375	2.08	0.496398160249202	0.496398160249202	false	false	false	true
4588bdcb-8062-4231-9330-21a6cd628227	2026-09-24 15:59	2026-09-24 15:59	2026-09-24 15:59	CVX	CVX261016P00207500	put	207.5000	2026-10-16	6.1500	5.6500	6.2000	205.0000	15990.00	14760.00	1230.00	26	11	248	174	1.42528735632184	0.266199911576762	0.266199911576762	false	false	false	true
7b6c3573-d852-4dfd-bd95-4a9da2c58d0b	2026-09-24 15:54	2026-09-24 15:53	2026-09-24 15:53	COP	COP261218C00150000	call	150.0000	2026-12-18	1.7900	1.7800	2.2500	129.2750	63023.00	0.00	29192.00	353	7	383	3267	0.117232935414754	0.29875858512173	0.29875858512173	false	false	false	true
5eec6660-ea3c-4e47-aa12-05f427c77d8a	2026-09-24 15:53	2026-09-24 15:52	2026-09-24 15:52	GLNG	GLNG261218C00055000	call	55.0000	2026-12-18	1.7500	1.7500	1.8500	50.0800	87500.00	0.00	87500.00	500	5	1942	487	3.98767967145791	0.350041955364095	0.350041955364095	false	false	false	true
c6f57368-fbed-41ad-9c37-f17d2095c075	2026-09-24 15:44	2026-09-24 15:44	2026-09-24 15:44	VLO	VLO261023P00370000	put	370.0000	2026-10-23	16.4000	15.3000	16.4000	383.7400	78720.00	78720.00	0.00	48	8	53	25	2.12	0.546384771689168	0.546384771689168	false	false	false	true
dcf6589f-c113-4e24-a628-5d9f9d270056	2026-09-24 15:41	2026-09-24 15:41	2026-09-24 15:41	ASC	ASC261016P00017500	put	17.5000	2026-10-16	0.6000	0.5500	0.8500	17.0000	18000.00	2160.00	15840.00	300	5	300	747	0.401606425702811	0.420155961073713	0.420155961073713	true	false	false	true
9931d1e3-61b3-4162-9b0d-0d3be7aece6c	2026-09-24 15:40	2026-09-24 15:40	2026-09-24 15:40	DINO	DINO270115P00110000	put	110.0000	2027-01-15	14.6000	14.5000	14.9000	106.0000	86140.00	1460.00	84680.00	59	20	104	351	0.296296296296296	0.568866325438234	0.568866325438234	false	false	false	true
ce27fc3e-8714-46c4-93fe-60ea4813df76	2026-09-24 15:37	2026-09-24 15:37	2026-09-24 15:37	MPC	MPC261016P00380000	put	380.0000	2026-10-16	14.0000	13.6000	14.0000	390.0000	11199.00	11199.00	0.00	8	8	176	1467	0.119972733469666	0.512982548108139	0.512982548108139	false	false	false	true
83488e47-1277-41b2-b3b8-37111c17606a	2026-09-24 15:37	2026-09-24 15:37	2026-09-24 15:37	CCJ	CCJ261120C00120000	call	120.0000	2026-11-20	0.7500	0.5000	0.7500	88.0000	22500.00	22500.00	0.00	300	14	1032	2032	0.507874015748031	0.53573361608072	0.53573361608072	false	false	false	true
1f251273-094e-43a6-907b-eacd307c3408	2026-09-24 15:37	2026-09-24 15:37	2026-09-24 15:37	MPC	MPC261016P00380000	put	380.0000	2026-10-16	13.8000	13.5000	13.8000	390.0000	11040.00	11040.00	0.00	8	7	156	1467	0.106339468302658	0.507038725489263	0.507038725489263	false	false	false	true
7eab8e39-bce3-44d7-95cd-82f56ecbfe64	2026-09-24 15:34	2026-09-24 15:34	2026-09-24 15:34	PBR	PBR261120C00022000	call	22.0000	2026-11-20	1.2600	1.1900	1.3100	20.8950	18541.00	1008.00	17407.00	147	14	949	44592	0.0212818442770004	0.505018714315207	0.505018714315207	false	false	false	true
7de74ac7-547f-4645-a106-0c5663b6d537	2026-09-24 15:33	2026-09-24 15:33	2026-09-24 15:33	COP	COP270115C00150000	call	150.0000	2027-01-15	3.1000	2.9900	3.1000	129.4700	13950.00	13950.00	0.00	45	8	134	2636	0.050834597875569	0.314988682821912	0.314988682821912	false	false	false	true
7e2e32f8-ed58-4302-8206-448250aab27c	2026-09-24 15:28	2026-09-24 15:28	2026-09-24 15:28	CVX	CVX261120C00210000	call	210.0000	2026-11-20	7.6000	7.5500	7.9500	206.3950	16720.00	15200.00	1520.00	22	6	246	1963	0.125318390219052	0.265593536655136	0.265593536655136	false	false	false	true
0fe6de04-51d8-48ba-b32d-164aa61e76e8	2026-09-24 15:24	2026-09-24 15:24	2026-09-24 15:24	XOM	XOM261120C00165000	call	165.0000	2026-11-20	6.7000	6.5000	6.7000	162.2651	20100.00	20100.00	0.00	30	5	327	3450	0.0947826086956522	0.292260278641159	0.292260278641159	false	false	false	true
38d9e87a-f74e-4ddf-a0c3-67c81ce0fb7a	2026-09-24 15:23	2026-09-24 15:23	2026-09-24 15:23	OXY	OXY261002P00057000	put	57.0000	2026-10-02	0.6800	0.6700	0.7300	58.1200	82280.00	0.00	82280.00	1210	11	2510	1368	1.83479532163743	0.3453269737297	0.3453269737297	true	false	false	true
4eeb9124-fd8c-4cfb-9cbf-50d093901488	2026-09-24 15:22	2026-09-24 15:22	2026-09-24 15:22	CVX	CVX270115P00200000	put	200.0000	2027-01-15	8.8500	8.8500	8.9500	206.4900	16815.00	0.00	16815.00	19	7	34	2588	0.0131375579598145	0.288264098404584	0.288305868955588	false	false	false	true
eae3092a-5da9-4cc8-8b58-6d13b77c531a	2026-09-24 15:22	2026-09-24 15:22	2026-09-24 15:22	OXY	OXY260925C00059000	call	59.0000	2026-09-25	0.1700	0.1300	0.1900	58.0800	12410.00	12223.00	187.00	730	8	3161	10519	0.300503850175872	0.408567009122999	0.408567009122999	true	false	false	true
e09c18ba-2642-4bfa-a869-2817d5831812	2026-09-24 15:14	2026-09-24 15:14	2026-09-24 15:14	EQT	EQT261120P00047500	put	47.5000	2026-11-20	0.9900	0.9200	0.9900	51.4950	11484.00	11484.00	0.00	116	25	456	328	1.39024390243902	0.33358941734073	0.33358941734073	false	false	false	true
d0c71464-e750-4224-b508-86a1d84d1220	2026-09-24 15:12	2026-09-24 15:12	2026-09-24 15:12	OKE	OKE261120C00095000	call	95.0000	2026-11-20	2.4500	2.3000	2.6000	90.9800	53155.00	50950.00	2205.00	217	32	391	299	1.30769230769231	0.268614193055831	0.268614193055831	false	false	false	true
19dc5414-4ef4-4958-8675-2ebea87bcac1	2026-09-24 15:12	2026-09-24 15:12	2026-09-24 15:12	DNN	DNN270115C00004500	call	4.5000	2027-01-15	0.0500	0.0500	0.1000	2.6350	15000.00	0.00	15000.00	3000	17	6064	19780	0.306572295247725	0.683330567728755	0.683330567728755	false	false	false	true
1ac74359-7b9a-4ec5-b0bf-7802eb941a8e	2026-09-24 15:03	2026-09-24 15:03	2026-09-24 15:03	VLO	VLO260925C00385000	call	385.0000	2026-09-25	5.3000	5.0000	6.3000	384.4100	42400.00	0.00	42400.00	80	8	536	136	3.94117647058824	0.682944631220987	0.693402821404999	false	false	false	true
4e656405-07a9-4c80-be26-53cbcfdbdf69	2026-09-24 14:59	2026-09-24 14:59	2026-09-24 14:59	DVN	DVN261016C00048000	call	48.0000	2026-10-16	2.0500	1.9000	2.1300	48.4450	61500.00	61500.00	0.00	300	6	625	35	17.8571428571429	0.372294368036087	0.372294368036087	false	false	false	true
1af42314-afb7-4a84-99d6-a99f4b48f69d	2026-09-24 14:59	2026-09-24 14:59	2026-09-24 14:59	CVX	CVX270319C00230000	call	230.0000	2027-03-19	7.4000	7.3500	7.6000	205.7550	11840.00	7400.00	2220.00	16	7	61	1237	0.0493128536782538	0.255217908727695	0.255217908727695	true	false	false	true
fa898b2e-00fc-4280-89ab-1f9ab3886edf	2026-09-24 14:58	2026-09-24 14:58	2026-09-24 14:58	CCJ	CCJ260925C00091000	call	91.0000	2026-09-25	0.2000	0.2000	0.3000	88.4000	15280.00	0.00	15280.00	764	41	822	67	12.2686567164179	0.537650809488105	0.537650809488105	false	false	false	true
b3867161-b0fc-47b1-a9eb-4fd3f243c97a	2026-09-24 14:58	2026-09-24 14:58	2026-09-24 14:58	SU	SU270115C00075000	call	75.0000	2027-01-15	2.7500	2.6500	2.7500	68.7600	20900.00	20900.00	0.00	76	11	94	8434	0.0111453640028456	0.312081519321507	0.312081519321507	false	false	false	true
e9adb53a-4866-4eac-8a15-3eb5e72aba06	2026-09-24 14:54	2026-09-24 14:54	2026-09-24 14:54	DVN	DVN261016C00048000	call	48.0000	2026-10-16	2.1400	2.0200	2.2000	48.5750	42800.00	7918.00	21828.00	200	7	325	35	9.28571428571429	0.375581921892346	0.375581921892346	false	false	false	true
fc0baea1-1922-43ae-aa1e-6edc6306d890	2026-09-24 14:53	2026-09-24 14:52	2026-09-24 14:52	VLO	VLO261030P00385000	put	385.0000	2026-10-30	26.0000	23.2000	26.0000	384.3700	122200.00	122200.00	0.00	47	14	72	6	12	0.550779188714556	0.550779188714556	false	false	false	true
b50713aa-f8e6-44bd-9aa9-ff22f26f1f52	2026-09-24 14:53	2026-09-24 14:52	2026-09-24 14:52	VLO	VLO261030P00380000	put	380.0000	2026-10-30	23.4000	21.1000	23.4000	384.3700	273780.00	273780.00	0.00	117	28	119	18	6.61111111111111	0.549917938351175	0.549917938351175	false	false	false	true
795af004-cb03-4d04-98f5-4c3fb2b306da	2026-09-24 14:51	2026-09-24 14:51	2026-09-24 14:51	DVN	DVN261002C00050000	call	50.0000	2026-10-02	0.5700	0.5100	0.6200	48.0000	50331.00	47367.00	2964.00	883	5	2662	743	3.58277254374159	0.399206210415999	0.399206210415999	true	false	false	true
2493f0eb-9b21-431c-a5d9-7f65e5bdbb6f	2026-09-24 14:51	2026-09-24 14:51	2026-09-24 14:51	ENB	ENB270115C00050000	call	50.0000	2027-01-15	1.0000	0.9500	1.0500	47.0000	10200.00	10100.00	0.00	102	5	273	3702	0.0737439222042139	0.167957657842315	0.167957657842315	true	false	false	true
71c2efb2-8dab-4e52-aac9-0a011ac24a35	2026-09-24 14:49	2026-09-24 14:49	2026-09-24 14:49	MPC	MPC261016P00390000	put	390.0000	2026-10-16	17.0000	15.6000	17.6000	392.0000	25500.00	25500.00	0.00	15	6	41	1104	0.0371376811594203	0.491663453948287	0.491663453948287	false	false	false	true
df9d7552-ad67-488c-b275-ad4823e3870c	2026-09-24 14:48	2026-09-24 14:48	2026-09-24 14:48	CVX	CVX261002C00212500	call	212.5000	2026-10-02	1.0500	0.9900	1.0900	205.0000	26880.00	26670.00	210.00	256	44	414	233	1.77682403433476	0.268288698325247	0.268288698325247	true	false	false	true
10f53675-f1be-4792-9b17-06fb78d3e64a	2026-09-24 14:48	2026-09-24 14:48	2026-09-24 14:48	CVX	CVX261002P00202500	put	202.5000	2026-10-02	1.8200	1.7300	2.0150	205.0000	15652.00	12922.00	2730.00	86	6	268	338	0.792899408284024	0.27448845344204	0.27448845344204	false	false	false	true
ebadd867-0092-44b0-879f-647e7e6ea047	2026-09-24 14:45	2026-09-24 14:45	2026-09-24 14:45	FRO	FRO270115P00049200	put	49.2000	2027-01-15	6.8000	6.8000	7.0000	48.0000	26520.00	0.00	26520.00	39	22	847	1006	0.841948310139165	0.619925996699116	0.619925996699116	true	false	false	true
0fb9db0d-f724-440c-b2ae-9976e72b15b8	2026-09-24 14:40	2026-09-24 14:40	2026-09-24 14:40	MPC	MPC261218P00370000	put	370.0000	2026-12-18	26.3000	23.7000	26.3000	393.3500	65750.00	65750.00	0.00	25	7	75	244	0.307377049180328	0.524932537659066	0.524932537659066	false	false	false	true
863cd99c-945c-4059-bfa0-1f4793c986e9	2026-09-24 14:39	2026-09-24 14:39	2026-09-24 14:39	STNG	STNG261016C00077500	call	77.5000	2026-10-16	5.3000	5.3000	5.9000	81.5000	169070.00	0.00	169070.00	319	20	319	309	1.03236245954693	0.348326613943307	0.348326613943307	false	false	false	true
509b3788-53e1-4a4e-a634-2c85f167bcbc	2026-09-24 14:39	2026-09-24 14:39	2026-09-24 14:39	DHT	DHT261016P00022000	put	22.0000	2026-10-16	1.1500	1.1000	1.2000	21.7550	12995.00	12650.00	0.00	113	21	138	1500	0.092	0.49144403540697	0.49144403540697	false	false	false	true
47007a2b-c03c-4507-8e9f-540130de3961	2026-09-24 14:39	2026-09-24 14:39	2026-09-24 14:39	DHT	DHT261120P00024000	put	24.0000	2026-11-20	3.9000	3.8000	3.9000	21.7550	93600.00	93600.00	0.00	240	10	240	33	7.27272727272727	0.76214897509649	0.76214897509649	false	false	false	true
16e642aa-4535-45ce-a961-21574bfeaf1c	2026-09-24 14:39	2026-09-24 14:39	2026-09-24 14:39	STNG	STNG261016C00080000	call	80.0000	2026-10-16	3.8000	3.7000	4.2000	81.5000	86268.00	760.00	85128.00	227	25	238	539	0.441558441558442	0.364083973440386	0.364083973440386	false	false	false	true
8d0de043-3647-4e78-8e06-c6321850c660	2026-09-24 14:39	2026-09-24 14:39	2026-09-24 14:39	VLO	VLO261218P00420000	put	420.0000	2026-12-18	59.0000	56.5000	59.0000	384.5100	47200.00	47200.00	0.00	8	6	19	45	0.422222222222222	0.539275209556851	0.539275209556851	false	false	false	true
32e05081-50d7-42f7-8949-c1212c9fdd68	2026-09-24 14:39	2026-09-24 14:38	2026-09-24 14:38	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.9500	18.9500	19.4500	161.4450	64430.00	0.00	64430.00	34	7	451	1924	0.234407484407484	0.297162390859557	0.297162390859557	false	false	false	true
957405dd-1918-4d5f-b634-6cb197289b5d	2026-09-24 14:36	2026-09-24 14:36	2026-09-24 14:36	CVX	CVX260925C00205000	call	205.0000	2026-09-25	2.0000	1.9900	2.5200	206.2500	17401.00	201.00	17200.00	87	9	386	858	0.44988344988345	0.294201250575477	0.294201250575477	false	false	false	true
f20faaba-e425-4542-8d6b-43f74ef0532a	2026-09-24 14:35	2026-09-24 14:35	2026-09-24 14:35	OXY	OXY261120C00060000	call	60.0000	2026-11-20	2.4600	2.4300	2.4900	57.8650	21156.00	5166.00	0.00	86	6	1382	10918	0.126579959699579	0.352490032705023	0.352490032705023	false	false	false	true
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
bd646b96-f78f-41d5-a8c8-d6f8a21f24e7	2026-09-24 14:34	2026-09-24 14:33	2026-09-24 14:33	LNG	LNG280121P00300000	put	300.0000	2028-01-21	49.4000	49.4000	51.0000	276.0900	39520.00	0.00	39520.00	8	5	16	35	0.457142857142857	0.367813817069986	0.367813817069986	false	false	false	true
f56b07a9-9040-45df-9a61-d33edc4ce1cc	2026-09-24 14:33	2026-09-24 14:33	2026-09-24 14:33	LNG	LNG280121P00300000	put	300.0000	2028-01-21	49.4000	49.4000	51.0000	276.0200	39520.00	0.00	39520.00	8	5	8	35	0.228571428571429	0.367571098960439	0.367571098960439	false	false	false	true
68f06b36-ca58-413a-9af2-7b9bd7321444	2026-09-24 14:25	2026-09-24 14:25	2026-09-24 14:25	CNQ	CNQ270115C00050000	call	50.0000	2027-01-15	2.6000	2.5000	2.6000	48.0950	47060.00	47060.00	0.00	181	21	442	10187	0.0433886325709237	0.294717116859848	0.294717116859848	false	false	false	true
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