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 = 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

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	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-23T19:42:45.926021Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
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
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