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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	652601547172.00	2026-10-30	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:33:11.786837Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
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
e880da9f-a3ea-4d66-b1c5-322f4dde7eeb	2026-09-22 12:06	2026-09-22 12:06	2026-09-22 12:06	XOM	XOM270319P00160000	put	160.0000	2027-03-19	12.4500	12.1500	12.4500	159.8250	22410.00	22410.00	0.00	18	6	130	1273	0.102120974076984	0.31717174853566	0.31717174853566	false	false	false	true
b61e13d9-3aae-40b9-ae8d-0205bfa063e6	2026-09-22 12:03	2026-09-22 12:03	2026-09-22 12:03	XOM	XOM270319P00160000	put	160.0000	2027-03-19	12.4000	12.1500	12.4000	159.9600	24800.00	24800.00	0.00	20	6	88	1273	0.0691280439905734	0.3173254457316	0.3173254457316	false	false	false	true
3b26931a-3643-42fa-8074-f59e61f78481	2026-09-22 12:00	2026-09-22 12:00	2026-09-22 12:00	XOM	XOM270319P00160000	put	160.0000	2027-03-19	12.5500	12.4500	12.5500	159.6499	25100.00	25100.00	0.00	20	7	48	1273	0.0377062058130401	0.317770878602749	0.317770878602749	false	false	false	true
9f9007a2-fd57-43ac-aba3-ab2b33be1a27	2026-09-22 11:18	2026-09-22 11:18	2026-09-22 11:18	XOM	XOM261009P00160000	put	160.0000	2026-10-09	4.3000	4.2500	4.4000	159.0300	12040.00	3010.00	9030.00	28	10	86	197	0.436548223350254	0.2881614936189	0.2881614936189	true	false	false	true
1e19cdeb-35db-4da1-b30c-9f500a8d4b8f	2026-09-22 11:02	2026-09-22 11:02	2026-09-22 11:02	XOM	XOM281215C00180000	call	180.0000	2028-12-15	21.2000	20.7500	21.2000	159.2800	12720.00	12720.00	0.00	6	5	81	1240	0.0653225806451613	0.235886350333498	0.235886350333498	false	false	false	true
cb702cbc-399f-4f86-89c8-5e846beae6fe	2026-09-22 10:59	2026-09-22 10:59	2026-09-22 10:59	XOM	XOM261016C00165000	call	165.0000	2026-10-16	2.5500	2.4900	2.6100	159.1350	15300.00	0.00	13260.00	60	5	343	9224	0.0371856027753686	0.289074890178197	0.289074890178197	false	false	false	true
413dcae8-47bb-44ed-9c23-c8ce84e641a9	2026-09-22 10:58	2026-09-22 10:58	2026-09-22 10:58	XOM	XOM261009P00150000	put	150.0000	2026-10-09	0.9400	0.9400	0.9900	159.0300	19740.00	0.00	19740.00	210	29	215	143	1.5034965034965	0.299230295704905	0.299230295704905	false	false	false	true
94183bc6-cc4a-4169-a260-21a0dd9b6e7c	2026-09-22 10:50	2026-09-22 10:50	2026-09-22 10:50	XOM	XOM260925C00160000	call	160.0000	2026-09-25	1.7200	1.6600	1.7500	159.3900	17200.00	17200.00	0.00	100	7	1271	803	1.58281444582814	0.344004256034582	0.344004256034582	false	false	false	true
fbff7fa6-d0db-4002-9751-6750d5a8ddff	2026-09-22 10:39	2026-09-22 10:39	2026-09-22 10:39	XOM	XOM281215C00170000	call	170.0000	2028-12-15	24.5100	24.1500	24.7000	158.6600	24510.00	14706.00	9804.00	10	5	84	6766	0.0124150162577594	0.232576469863346	0.232576469863346	false	false	false	true
e6cf38e3-cb42-4743-87d9-51618123f26b	2026-09-22 10:35	2026-09-22 10:35	2026-09-22 10:35	XOM	XOM260925P00160000	put	160.0000	2026-09-25	2.5200	2.5200	2.6500	158.9450	86688.00	0.00	61488.00	344	6	406	1192	0.340604026845638	0.343045543351463	0.343045543351463	false	false	false	true
018c2dfa-b2bd-41db-8948-717cc65f859d	2026-09-22 10:14	2026-09-22 10:14	2026-09-22 10:14	XOM	XOM281215P00150000	put	150.0000	2028-12-15	18.3700	18.1500	18.6500	158.4700	12859.00	0.00	12859.00	7	5	26	1550	0.0167741935483871	0.331552217363648	0.331552217363648	false	false	false	true
6d44290c-52d8-4c63-adc8-e3d49fae2c11	2026-09-22 09:50	2026-09-22 09:50	2026-09-22 09:50	XOM	XOM260925P00155000	put	155.0000	2026-09-25	0.8300	0.8200	0.9900	157.9000	61504.00	581.00	60923.00	741	54	1137	2108	0.539373814041746	0.346894439694036	0.346894439694036	false	false	false	true
0753e15e-21a7-4306-a463-a3515e4fe56f	2026-09-21 15:59	2026-09-21 15:59	2026-09-21 15:59	XOM	XOM270319P00160000	put	160.0000	2027-03-19	13.3000	12.8500	13.3000	158.0000	21280.00	21280.00	0.00	16	5	84	1222	0.0687397708674304	0.318387058294266	0.318387058294266	false	false	false	true
ac778887-d8f6-4bb9-b81f-6ad6deee48b7	2026-09-21 15:50	2026-09-21 15:50	2026-09-21 15:50	XOM	XOM260925P00162500	put	162.5000	2026-09-25	4.5500	4.4500	5.1000	158.6850	25951.00	0.00	25951.00	57	7	390	667	0.584707646176912	0.326120646243436	0.326120646243436	false	false	false	true
2f8d17de-5bf7-4abf-95a0-ad925e09eee8	2026-09-21 15:27	2026-09-21 15:27	2026-09-21 15:27	XOM	XOM261002P00155000	put	155.0000	2026-10-02	1.7000	1.5800	1.7800	158.6600	18360.00	18190.00	170.00	108	17	1099	625	1.7584	0.302174302564283	0.301217683927202	false	false	false	true
291021fd-1cb1-4ebf-b66a-c76cf8643363	2026-09-21 15:27	2026-09-21 15:27	2026-09-21 15:27	XOM	XOM260925P00157500	put	157.5000	2026-09-25	1.6200	1.4600	1.6800	158.6600	47953.00	47628.00	164.00	296	36	1706	1215	1.40411522633745	0.332084102756521	0.333309502342241	false	false	false	true
f7cfe187-6021-4c11-98ca-8bbc09663db8	2026-09-21 15:26	2026-09-21 15:26	2026-09-21 15:26	XOM	XOM260925C00157500	call	157.5000	2026-09-25	2.9700	2.7800	3.0000	158.9181	22872.00	22872.00	0.00	77	17	211	178	1.18539325842697	0.33886475898475	0.329480430605783	true	false	false	true
23b31cdc-f94f-4de3-8802-ea5012ad23ff	2026-09-21 15:14	2026-09-21 15:14	2026-09-21 15:14	XOM	XOM260925C00167500	call	167.5000	2026-09-25	0.2200	0.2000	0.2200	159.5000	11000.00	11000.00	0.00	500	44	1551	2292	0.676701570680628	0.335736839665818	0.335736839665818	false	false	false	true
346c7cca-3c15-42ac-87a1-d30934366fcd	2026-09-21 15:11	2026-09-21 15:11	2026-09-21 15:11	XOM	XOM281215C00160000	call	160.0000	2028-12-15	29.1500	28.5500	29.2000	159.3150	355590.00	343955.00	8720.00	122	9	919	7709	0.119211311454145	0.227961410752309	0.228548964560897	true	false	false	true
a650df55-f6d7-4a3f-84b0-e3e462aef8de	2026-09-21 14:01	2026-09-21 14:01	2026-09-21 14:01	XOM	XOM261218P00145000	put	145.0000	2026-12-18	3.5000	3.5000	3.6000	159.0000	331450.00	0.00	331450.00	947	47	1426	31269	0.0456042726022578	0.313338111275123	0.313338111275123	false	false	false	true
452dabd0-542f-4c66-8002-7da1a6f15fda	2026-09-21 14:00	2026-09-21 13:59	2026-09-21 13:59	XOM	XOM281215C00160000	call	160.0000	2028-12-15	28.7700	28.1000	28.9000	158.8300	466025.00	233665.00	232360.00	162	6	692	7709	0.089765209495395	0.22595862554025	0.226545818749544	false	false	false	true
01c31146-2f6a-407b-ad33-da45182428ad	2026-09-21 14:00	2026-09-21 13:59	2026-09-21 13:59	XOM	XOM280121C00160000	call	160.0000	2028-01-21	22.2400	21.2500	22.3000	158.8300	22235.00	2225.00	20010.00	10	10	26	6303	0.00412501983182611	0.247736954218214	0.245565877167446	false	false	false	true
c1fd17db-227c-426f-923d-db5dadc0e942	2026-09-21 13:56	2026-09-21 13:56	2026-09-21 13:56	XOM	XOM261218P00155000	put	155.0000	2026-12-18	7.1000	7.0000	7.1000	158.8700	24140.00	24140.00	0.00	34	5	77	2732	0.0281844802342606	0.312924541242633	0.312924541242633	false	false	false	true
9bdc49bb-c88d-47c7-9857-0b90b17d8b2e	2026-09-21 13:56	2026-09-21 13:56	2026-09-21 13:56	XOM	XOM270617P00160000	put	160.0000	2027-06-17	15.2000	15.2000	15.7500	158.8500	126160.00	0.00	126160.00	83	17	85	3756	0.0226304579339723	0.319831333119305	0.319831333119305	false	false	false	true
1da03354-e2e3-49c1-9246-989bdf742714	2026-09-21 13:51	2026-09-21 13:51	2026-09-21 13:51	XOM	XOM271217C00160000	call	160.0000	2027-12-17	21.1000	20.3000	21.1500	158.6500	50640.00	44310.00	6330.00	24	5	32	851	0.0376028202115159	0.246965469991909	0.246965469991909	false	false	false	true
4bbd11ca-5248-4d67-8a4e-82136b570593	2026-09-21 13:49	2026-09-21 13:49	2026-09-21 13:49	XOM	XOM281215C00150000	call	150.0000	2028-12-15	33.3300	32.1500	33.4000	158.6000	43330.00	3335.00	39995.00	13	13	13	3617	0.0035941387890517	0.220702085954224	0.217418885784435	false	false	false	true
03c2a008-d4ba-4ae8-bfa1-0654dddcc8cb	2026-09-21 13:49	2026-09-21 13:49	2026-09-21 13:49	XOM	XOM290119C00145000	call	145.0000	2029-01-19	36.4800	34.8500	36.6000	158.6000	21885.00	3655.00	18230.00	6	6	218	3	72.6666666666667	0.214641578933028	0.208313782705869	false	false	false	true
cac04495-5f34-4512-ae4d-1ce7519e021c	2026-09-21 13:24	2026-09-21 13:24	2026-09-21 13:24	XOM	XOM281215C00160000	call	160.0000	2028-12-15	27.9000	27.7000	28.2000	158.0000	44640.00	0.00	5580.00	16	14	63	7709	0.00817226618238423	0.22290651067593	0.22290651067593	false	false	false	true
3965778e-0dcc-4e1e-9be5-47f25fbfd4f6	2026-09-21 13:21	2026-09-21 13:21	2026-09-21 13:21	XOM	XOM260925P00157500	put	157.5000	2026-09-25	1.7600	1.6800	1.7800	158.0000	17600.00	17600.00	0.00	100	6	1162	1215	0.956378600823045	0.317971709383321	0.317971709383321	true	false	false	true
ede98e2b-81f0-49e0-bdaa-b3866446d29f	2026-09-21 13:13	2026-09-21 13:13	2026-09-21 13:13	XOM	XOM261016P00155000	put	155.0000	2026-10-16	3.0100	3.0000	3.2000	158.1100	15052.00	0.00	15052.00	50	5	383	3060	0.12516339869281	0.278754877659839	0.278754877659839	false	false	false	true
4f12b264-2f76-4cce-b73c-f368e1262636	2026-09-21 13:00	2026-09-21 13:00	2026-09-21 13:00	XOM	XOM270115C00165000	call	165.0000	2027-01-15	7.9000	7.7500	7.9500	158.4800	50560.00	49770.00	790.00	64	15	159	5109	0.0311215502055197	0.274510240127293	0.274510240127293	false	false	false	true
49c412a2-f759-456c-9c72-0f405d852b97	2026-09-21 12:44	2026-09-21 12:44	2026-09-21 12:44	XOM	XOM270416C00170000	call	170.0000	2027-04-16	9.7000	9.7000	9.9000	158.3200	11640.00	0.00	11640.00	12	6	47	417	0.112709832134293	0.269387990472996	0.269387990472996	false	false	false	true
994f68d9-5553-4ede-94bc-38a21787f129	2026-09-21 12:37	2026-09-21 12:37	2026-09-21 12:37	XOM	XOM270319P00140000	put	140.0000	2027-03-19	5.3000	5.1000	5.4500	158.4600	10600.00	6890.00	3710.00	20	8	225	3161	0.0711800063271117	0.324415643588729	0.324415643588729	true	false	false	true
ad15eb6e-382e-4fcf-b390-91587a5adcff	2026-09-21 12:13	2026-09-21 12:13	2026-09-21 12:13	XOM	XOM261120P00150000	put	150.0000	2026-11-20	3.9500	3.9500	4.1000	158.4700	47005.00	0.00	47005.00	119	29	356	2931	0.121460252473559	0.313538179908614	0.313538179908614	true	false	false	true
fab61993-05f5-41f5-ac80-a3d4e976df8f	2026-09-21 10:50	2026-09-21 10:50	2026-09-21 10:50	XOM	XOM270115P00160000	put	160.0000	2027-01-15	10.1500	10.1500	10.4000	159.4400	358295.00	0.00	358295.00	353	39	353	3261	0.108249003373198	0.306504824694425	0.306504824694425	false	false	false	true
3d0b183c-f918-4ab0-bf93-ef4a79c80fd9	2026-09-21 10:33	2026-09-21 10:33	2026-09-21 10:33	XOM	XOM261016C00185000	call	185.0000	2026-10-16	0.2100	0.1600	0.2100	159.5300	14868.00	14868.00	0.00	708	24	2107	2929	0.719358142710823	0.31206806558655	0.31206806558655	true	false	false	true
aab8eb45-09f2-4ca4-899d-fa1408c0a0b0	2026-09-18 14:41	2026-09-18 14:41	2026-09-18 14:41	XOM	XOM260918P00175000	put	175.0000	2026-09-18	12.3000	12.1500	12.3000	162.7100	123000.00	123000.00	0.00	100	5	202	378	0.534391534391534	2.41269954420559	2.41269954420559	false	false	false	true
fe08ef1f-c04d-4ce7-9952-e97bdcc8d563	2026-09-18 13:24	2026-09-18 13:24	2026-09-18 13:24	XOM	XOM260918C00155000	call	155.0000	2026-09-18	7.7500	7.3000	7.7500	162.4900	414615.00	414615.00	0.00	535	12	2328	7034	0.330963889678703	2.0994130964194	2.0994130964194	false	false	false	true
81e53382-78dd-41d1-a250-8d9e0470a6ae	2026-09-18 13:12	2026-09-18 13:11	2026-09-18 13:11	XOM	XOM271217P00165000	put	165.0000	2027-12-17	19.8000	19.8000	19.9500	162.5300	104940.00	0.00	104940.00	53	53	53	393	0.134860050890585	0.327385602967586	0.327385602967586	false	false	false	true
940e2882-8ac7-4a12-9a4a-62c5c472f19f	2026-09-18 12:56	2026-09-18 12:56	2026-09-18 12:56	XOM	XOM270115P00165000	put	165.0000	2027-01-15	11.4500	11.4500	11.6500	162.6200	503800.00	0.00	503800.00	440	48	471	2092	0.225143403441683	0.307754812790341	0.307754812790341	false	false	false	true