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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = XOM×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

a2b4ad06-eda7-47d9-84f7-27a433c4f50f	2026-09-24 11:39	2026-09-24 11:39	2026-09-24 11:39	XOM	XOM260925P00160000	put	160.0000	2026-09-25	0.2000	0.2000	0.2800	164.3200	64940.00	0.00	64940.00	3247	54	4065	2299	1.76816006959548	0.424214577719324	0.424214577719324	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	662963565311.00	2026-10-30	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T15:45:14.547721Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
012d3fa8-c28a-40c5-966f-732b7764857f	2026-09-24 11:23	2026-09-24 11:23	2026-09-24 11:23	XOM	XOM261120P00155000	put	155.0000	2026-11-20	4.1000	3.9500	4.1000	163.0000	10660.00	10660.00	0.00	26	15	104	2479	0.0419524001613554	0.324772303796811	0.324772303796811	false	false	false	true
ac05b465-ee2b-4450-976d-fdc1d161bb79	2026-09-24 11:09	2026-09-24 11:09	2026-09-24 11:09	XOM	XOM270115C00180000	call	180.0000	2027-01-15	5.1500	5.1000	5.1500	164.0000	10300.00	2060.00	0.00	20	19	79	35269	0.00223992741501035	0.277602687118268	0.277602687118268	false	false	false	true
1ee48489-9cca-46a8-bd5c-9ac28b15ddd7	2026-09-24 10:51	2026-09-24 10:51	2026-09-24 10:51	XOM	XOM260925C00160000	call	160.0000	2026-09-25	4.6000	4.5000	4.8000	164.3600	80500.00	18400.00	62100.00	175	6	341	1189	0.286795626576955	0.440431156214192	0.440431156214192	false	false	false	true
e7dfb8ed-9872-453f-9271-338b5de0ecb3	2026-09-24 10:22	2026-09-24 10:22	2026-09-24 10:22	XOM	XOM261120C00165000	call	165.0000	2026-11-20	7.6500	7.6000	7.9500	164.3600	32125.00	0.00	32125.00	42	6	76	3450	0.0220289855072464	0.287707682317791	0.285772047748716	true	false	false	true
6fefd341-874e-489a-aec6-9c8c720a42db	2026-09-24 10:19	2026-09-24 10:19	2026-09-24 10:19	XOM	XOM270319P00150000	put	150.0000	2027-03-19	6.5500	6.4500	6.5500	164.7350	22925.00	22925.00	0.00	35	6	38	1980	0.0191919191919192	0.317182479045708	0.317182479045708	false	false	false	true
1e833230-db40-47c9-9d91-08de6dc6f070	2026-09-24 10:18	2026-09-24 10:18	2026-09-24 10:18	XOM	XOM261120C00175000	call	175.0000	2026-11-20	3.9000	3.9000	4.1000	164.7500	10920.00	0.00	10920.00	28	5	649	4038	0.160723130262506	0.285336338379419	0.285336338379419	false	false	false	true
115d8b82-a7bc-4fe7-98e8-e764e047f154	2026-09-24 10:04	2026-09-24 10:04	2026-09-24 10:04	XOM	XOM261120P00165000	put	165.0000	2026-11-20	8.4100	8.2500	8.5000	163.3800	21865.00	3380.00	845.00	26	6	34	1044	0.0325670498084291	0.316593644577533	0.316593644577533	false	false	false	true
d317f09a-5416-48aa-933b-6b33f5f2204c	2026-09-24 09:56	2026-09-24 09:56	2026-09-24 09:56	XOM	XOM261016P00172500	put	172.5000	2026-10-16	10.0000	9.5000	11.2500	163.8800	23000.00	3000.00	20000.00	23	5	23	50	0.46	0.293567937609449	0.293567937609449	false	false	false	true
ba9f1d05-cd5d-4271-a9ef-da3d99868d2f	2026-09-24 09:55	2026-09-24 09:55	2026-09-24 09:55	XOM	XOM260925C00160000	call	160.0000	2026-09-25	4.1300	3.9000	4.3500	163.7500	12390.00	12390.00	0.00	30	6	108	1189	0.0908326324642557	0.467842000310885	0.467842000310885	false	false	false	true
a73f6367-eb09-4c8f-a470-156020a38a7c	2026-09-24 09:41	2026-09-24 09:41	2026-09-24 09:41	XOM	XOM261002C00165000	call	165.0000	2026-10-02	2.3300	2.2800	2.4300	163.6100	18600.00	4931.00	9280.00	80	6	206	1714	0.120186697782964	0.299038998475869	0.29799250268316	true	false	false	true
7f8be3a1-5e8d-45c3-9098-8670f472b3a8	2026-09-24 09:40	2026-09-24 09:40	2026-09-24 09:40	XOM	XOM260925P00162500	put	162.5000	2026-09-25	0.9700	0.8100	0.9700	163.7750	14550.00	14550.00	0.00	150	17	172	645	0.266666666666667	0.449253615016665	0.449253615016665	false	false	false	true
d7599df9-1518-4789-8967-823c32ad3724	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.7500	10.0000	162.8900	15000.00	15000.00	0.00	15	5	196	9247	0.0211960635881908	0.307169121326966	0.307169121326966	false	false	false	true
a058e0cb-5734-4bd5-ac39-38f53f3e0f1c	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	XOM	XOM261016C00155000	call	155.0000	2026-10-16	9.4400	9.1500	9.9500	162.3525	11333.00	0.00	11333.00	12	7	145	9247	0.0156807613279983	0.295830296735842	0.29015123212769	false	false	false	true
139dee0a-6f4f-4ffc-9ba4-f1cd542a2da8	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	XOM	XOM261016P00145000	put	145.0000	2026-10-16	0.4500	0.4500	0.5000	161.1450	20790.00	0.00	20790.00	462	39	595	9286	0.0640749515399526	0.31064082300174	0.31064082300174	false	false	false	true
474f24f8-6785-4ddb-8fd4-4e4b64f02dcb	2026-09-23 15:21	2026-09-23 15:20	2026-09-23 15:20	XOM	XOM261218C00175000	call	175.0000	2026-12-18	4.2500	4.2000	4.2500	160.9500	12742.00	12742.00	0.00	30	5	86	4123	0.0208585981081737	0.282567532479001	0.281923277200818	false	false	false	true
c3c43d86-3014-4901-b07c-5bc7a2f989a6	2026-09-23 15:07	2026-09-23 15:07	2026-09-23 15:07	XOM	XOM261002P00155000	put	155.0000	2026-10-02	0.9000	0.9000	0.9900	161.0400	22770.00	0.00	22770.00	253	25	596	1020	0.584313725490196	0.30788644232992	0.30788644232992	false	false	false	true
789ff24e-bb6f-4e13-b765-6bcb076d1033	2026-09-23 15:04	2026-09-23 15:04	2026-09-23 15:04	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.5100	18.5000	18.6000	160.9100	24060.00	0.00	24060.00	13	5	1211	1049	1.15443279313632	0.293985277659049	0.293985277659049	false	false	false	true
201d2973-3d6b-48be-a47b-96587afa07bb	2026-09-23 14:19	2026-09-23 14:19	2026-09-23 14:19	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.8000	18.8000	18.8500	161.0000	35720.00	0.00	35720.00	19	6	630	1049	0.600571973307912	0.29758649809747	0.29758649809747	false	false	false	true
6b43d67f-1475-47cb-b850-35eb5e3441f5	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.8000	18.7500	18.8500	161.1400	16920.00	0.00	0.00	9	5	521	1049	0.496663489037178	0.300836012552709	0.300836012552709	false	false	false	true
8d74c5e1-b54d-4f9b-a0ac-6324ac637079	2026-09-23 14:02	2026-09-23 14:02	2026-09-23 14:02	XOM	XOM261218P00155000	put	155.0000	2026-12-18	6.2000	6.2000	6.2500	161.3200	16740.00	0.00	16740.00	27	6	315	2844	0.110759493670886	0.315736353387513	0.315736353387513	false	false	false	true
9ef36ea0-07fc-47dd-b976-1c62cf633f4d	2026-09-23 14:01	2026-09-23 14:01	2026-09-23 14:01	XOM	XOM261009C00165000	call	165.0000	2026-10-09	2.5200	2.4300	2.5400	161.2900	10085.00	10085.00	0.00	40	6	691	371	1.86253369272237	0.295462307816611	0.291566970326128	false	false	false	true
ef197903-1259-4a58-b710-073f7a452a31	2026-09-23 13:59	2026-09-23 13:59	2026-09-23 13:59	XOM	XOM261218P00155000	put	155.0000	2026-12-18	6.2500	6.2500	6.4000	161.2109	16250.00	0.00	16250.00	26	5	238	2844	0.0836849507735584	0.316165119170629	0.316165119170629	false	false	false	true
886b6da9-c365-4e77-b216-29cf643b107d	2026-09-23 13:54	2026-09-23 13:54	2026-09-23 13:54	XOM	XOM261023C00170000	call	170.0000	2026-10-23	2.2300	2.1000	2.2400	161.1600	113060.00	109270.00	3790.00	507	53	542	87	6.22988505747126	0.285230817178675	0.285230817178675	false	false	false	true
38396193-f4bf-4646-bf8d-cd9c698d70a4	2026-09-23 13:45	2026-09-23 13:45	2026-09-23 13:45	XOM	XOM261218C00165000	call	165.0000	2026-12-18	7.7500	7.7500	7.9500	161.0000	10850.00	0.00	10850.00	14	14	169	6733	0.0251002524877469	0.278800410114062	0.278800410114062	true	false	false	true
f54fd19f-30bf-4ba0-9fdc-4aa2f54a9ec9	2026-09-23 12:50	2026-09-23 12:50	2026-09-23 12:50	XOM	XOM260925P00160000	put	160.0000	2026-09-25	1.5700	1.3700	1.6300	160.3100	18997.00	18997.00	0.00	121	5	1235	1395	0.885304659498208	0.367308218319726	0.367308218319726	false	false	false	true
d599325a-bf98-4027-8cc0-bdc9c98629ff	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	XOM	XOM261218C00155000	call	155.0000	2026-12-18	12.4100	12.4000	13.1500	160.9500	393256.00	0.00	393256.00	317	5	323	4346	0.0743212149102623	0.267278550066493	0.267630557797311	false	false	false	true
80fa7173-a827-4b91-86e4-d854c29addfd	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	XOM	XOM261218P00170000	put	170.0000	2026-12-18	14.6500	13.8500	14.6500	160.9500	147965.00	147965.00	0.00	101	5	101	434	0.232718894009217	0.331129059871229	0.331129059871229	false	false	false	true
3bf35c38-64d7-49c6-b37f-60ffc993a54c	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	XOM	XOM261120C00155000	call	155.0000	2026-11-20	10.9000	10.9000	11.8000	160.7100	331365.00	1095.00	330270.00	304	7	320	4156	0.0769971126082772	0.274523200602811	0.281499244759137	true	false	false	true
e10ffa58-18f1-4634-bef4-d18b2510091a	2026-09-23 12:40	2026-09-23 12:40	2026-09-23 12:40	XOM	XOM270319P00165000	put	165.0000	2027-03-19	14.5500	14.4500	14.6500	161.0000	17460.00	16005.00	1455.00	12	5	30	1846	0.0162513542795233	0.318595317353811	0.318595317353811	false	false	false	true
54a102c9-5036-433c-9639-e32194010b84	2026-09-23 12:34	2026-09-23 12:34	2026-09-23 12:34	XOM	XOM290119C00160000	call	160.0000	2029-01-19	30.6000	30.6000	31.7000	161.0500	21420.00	0.00	21420.00	7	6	18	67	0.26865671641791	0.223530691605535	0.223530691605535	false	false	false	true
e244dc19-b09d-4620-9147-7cfc68d1b75f	2026-09-23 12:10	2026-09-23 12:10	2026-09-23 12:10	XOM	XOM261009P00162500	put	162.5000	2026-10-09	4.6000	4.5500	4.8000	161.0250	24840.00	0.00	24840.00	54	10	76	216	0.351851851851852	0.291919165433402	0.294525896853861	true	false	false	true
52d297c2-da95-4538-a05f-d733c07a1b8c	2026-09-23 10:56	2026-09-23 10:56	2026-09-23 10:56	XOM	XOM260925P00157500	put	157.5000	2026-09-25	0.6400	0.5300	0.6400	160.4500	19455.00	19455.00	0.00	304	31	727	2124	0.342278719397363	0.370695082718025	0.367997987606918	true	false	false	true
5843def0-353b-4825-b2a7-502f1b9656de	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	XOM	XOM260925P00160000	put	160.0000	2026-09-25	1.1700	1.0200	1.1700	161.0200	11349.00	11349.00	0.00	97	14	379	1395	0.27168458781362	0.358764324623487	0.346846486324643	true	false	false	true
fd44ca18-58ae-4abb-82df-8831ce4a36ea	2026-09-23 10:46	2026-09-23 10:46	2026-09-23 10:46	XOM	XOM270319P00140000	put	140.0000	2027-03-19	4.4500	4.3500	4.4500	161.7750	18245.00	18245.00	0.00	41	15	54	3563	0.0151557676115633	0.321516195197525	0.321516195197525	false	false	false	true
ca963789-b7f6-413e-913a-2c6b77791f60	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	XOM	XOM280121C00165000	call	165.0000	2028-01-21	21.5500	21.1500	21.6500	161.0000	10775.00	10775.00	0.00	5	5	134	856	0.156542056074766	0.249354474651657	0.249354474651657	false	false	false	true
6637214a-21b3-4f89-b59f-7f295208c87b	2026-09-23 10:10	2026-09-23 10:10	2026-09-23 10:10	XOM	XOM261016C00160000	call	160.0000	2026-10-16	5.5500	5.3000	5.6500	161.2191	28860.00	4440.00	24420.00	52	8	123	5500	0.0223636363636364	0.292410179385592	0.292410179385592	false	false	false	true
7376a0f6-1aaf-44fc-8c46-682220ae2e4d	2026-09-23 10:09	2026-09-23 10:08	2026-09-23 10:08	XOM	XOM260925C00165000	call	165.0000	2026-09-25	0.4300	0.4300	0.5000	160.9600	15910.00	0.00	15910.00	370	41	973	3002	0.324117255163225	0.363573363357255	0.363573363357255	false	false	false	true
d7a5e58c-f402-4ea1-a4e9-ff0d0d8bfeab	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	XOM	XOM261016P00150000	put	150.0000	2026-10-16	1.0000	0.9900	1.0500	161.0000	28700.00	9300.00	19400.00	287	59	435	8970	0.048494983277592	0.300576616207422	0.300576616207422	false	false	false	true
27056b2b-d013-4089-b60d-05ad63176624	2026-09-23 09:51	2026-09-23 09:51	2026-09-23 09:51	XOM	XOM270319C00180000	call	180.0000	2027-03-19	6.8500	6.3000	6.8500	161.5700	36300.00	36300.00	0.00	53	5	53	2981	0.0177792687017779	0.275578656097816	0.275578656097816	false	false	false	true
a192b49f-14e2-4db9-b8ac-fa634e9183c9	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	XOM	XOM261009P00150000	put	150.0000	2026-10-09	1.0400	0.9800	1.0500	158.0000	30576.00	27456.00	3120.00	294	16	1293	143	9.04195804195804	0.305923451513398	0.305524751641646	true	false	false	true
83ab0bf9-f73c-4ce0-bea2-ef5c99c1bd0b	2026-09-22 15:29	2026-09-22 15:29	2026-09-22 15:29	XOM	XOM261120P00155000	put	155.0000	2026-11-20	5.7500	5.6500	5.7500	158.0000	25875.00	25875.00	0.00	45	15	146	2333	0.0625803686240892	0.317140811861572	0.317140811861572	false	false	false	true
c5a0489d-5b59-4300-9133-e11386e68a99	2026-09-22 14:20	2026-09-22 14:20	2026-09-22 14:20	XOM	XOM261016C00165000	call	165.0000	2026-10-16	2.5600	2.3800	2.6000	159.3000	47615.00	47104.00	511.00	186	6	970	9224	0.105160450997398	0.285990999463831	0.285324157093226	true	false	false	true
36c93622-8f66-4bd5-8e1d-b375269c9b39	2026-09-22 14:07	2026-09-22 14:07	2026-09-22 14:07	XOM	XOM260925P00157500	put	157.5000	2026-09-25	1.4200	1.2600	1.4200	158.8500	22720.00	22720.00	0.00	160	5	957	1608	0.595149253731343	0.357483281823812	0.357483281823812	false	false	false	true
b66eae3b-daaa-4502-942b-54ea3154ff25	2026-09-22 14:01	2026-09-22 14:01	2026-09-22 14:01	XOM	XOM260925P00157500	put	157.5000	2026-09-25	1.5000	1.5000	1.5900	158.4500	27600.00	0.00	27600.00	184	31	785	1608	0.48818407960199	0.343121205553626	0.343121205553626	true	false	false	true
8fde7afd-da4e-43cb-bd98-c7c20066879e	2026-09-22 13:56	2026-09-22 13:56	2026-09-22 13:56	XOM	XOM270115C00190000	call	190.0000	2027-01-15	2.0700	2.0700	2.2100	158.4300	19251.00	0.00	19251.00	93	23	340	2580	0.131782945736434	0.284812150460777	0.284812150460777	false	false	false	true
733f0e08-e718-41e3-bcb0-c0d3fd70d714	2026-09-22 13:56	2026-09-22 13:56	2026-09-22 13:56	XOM	XOM270115C00185000	call	185.0000	2027-01-15	2.7400	2.7400	2.9000	158.4300	154810.00	0.00	154810.00	565	42	605	7137	0.0847695109990192	0.282607015104048	0.282607015104048	false	false	false	true
067d9e5f-a5a5-4757-a7de-935055201a2a	2026-09-22 13:06	2026-09-22 13:06	2026-09-22 13:06	XOM	XOM261120C00175000	call	175.0000	2026-11-20	2.6000	2.5800	2.6300	159.5800	25220.00	24960.00	260.00	97	14	177	3823	0.0462987182840701	0.289282950721443	0.289282950721443	false	false	false	true
fc4fb849-cf12-4407-9b03-68743e36bd52	2026-09-22 12:36	2026-09-22 12:36	2026-09-22 12:36	XOM	XOM261218C00170000	call	170.0000	2026-12-18	5.2500	5.2500	5.5000	159.7500	36750.00	0.00	36750.00	70	8	103	8865	0.0116187253243091	0.278367196301505	0.278367196301505	false	false	false	true
d8811a78-527f-40a0-983d-0c7aa0f5c63c	2026-09-22 12:10	2026-09-22 12:10	2026-09-22 12:10	XOM	XOM270319P00150000	put	150.0000	2027-03-19	8.0500	7.9000	8.1500	159.7200	13685.00	12880.00	805.00	17	9	72	1950	0.0369230769230769	0.316883441372745	0.316883441372745	false	false	false	true