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×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	expiry

b699b6f0-2c98-4860-8f6d-07691cfcfb61	2026-09-25 15:31	2026-09-25 15:31	2026-09-25 15:31	XOM	XOM270115C00165000	call	165.0000	2027-01-15	8.6300	8.6000	8.8500	160.5900	129450.00	0.00	129450.00	150	2	191	5065	0.0377097729516288	0.27100251746253	0.27100251746253	false	true	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-25T19:35:55.847824Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
f6e05429-e5c2-455f-833b-74032166fbb5	2026-09-25 15:18	2026-09-25 15:18	2026-09-25 15:18	XOM	XOM261016C00170000	call	170.0000	2026-10-16	1.2200	1.2200	1.2900	160.7100	27938.00	0.00	27938.00	229	13	1359	22666	0.0599576458131122	0.270557838580921	0.270557838580921	false	false	false	true
c040c936-d251-4c6b-9c20-f49492804d26	2026-09-25 15:15	2026-09-25 15:15	2026-09-25 15:15	XOM	XOM261002C00175000	call	175.0000	2026-10-02	0.0900	0.0500	0.0900	160.7100	85000.00	85000.00	0.00	10000	2	10104	755	13.3827814569536	0.319288173370335	0.319288173370335	false	true	false	true
84488a8c-6e8e-468a-a631-ac2733d70272	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	XOM	XOM261106P00160000	put	160.0000	2026-11-06	5.8000	5.3500	6.0500	160.6500	69600.00	58000.00	11600.00	120	8	142	8	17.75	0.299708255150096	0.299708255150096	false	false	false	true
f673e7f2-a772-46d2-8b88-37fee4c8c406	2026-09-25 14:35	2026-09-25 14:35	2026-09-25 14:35	XOM	XOM270319C00180000	call	180.0000	2027-03-19	6.3400	6.1000	6.5500	160.3300	36138.00	36138.00	0.00	57	5	261	3065	0.0851549755301794	0.275177634290022	0.275177634290022	false	false	false	true
f2cee417-7dc6-4493-a75c-8d38cffd7936	2026-09-25 14:23	2026-09-25 14:23	2026-09-25 14:23	XOM	XOM270319P00160000	put	160.0000	2027-03-19	12.1900	12.0000	12.4000	160.4300	71921.00	0.00	71921.00	59	5	77	1336	0.0576347305389222	0.319679377316743	0.319679377316743	false	false	false	true
35fc5232-e8da-4b62-b916-6a0835769648	2026-09-25 14:20	2026-09-25 14:20	2026-09-25 14:20	XOM	XOM270319C00200000	call	200.0000	2027-03-19	2.7300	2.7300	2.9300	160.3100	11193.00	0.00	11193.00	41	8	99	10867	0.00911014999539891	0.281436007033126	0.281896027954934	false	false	false	true
e1150420-ff18-42e2-ab03-f42bd5901f39	2026-09-25 13:57	2026-09-25 13:57	2026-09-25 13:57	XOM	XOM270115C00170000	call	170.0000	2027-01-15	6.5500	6.4500	6.7500	160.1450	63535.00	23580.00	39955.00	97	32	99	7277	0.0136045073519307	0.273367363086988	0.273367363086988	false	false	false	true
25b3f9af-14de-444b-9749-54f4a3a1a913	2026-09-25 13:22	2026-09-25 13:22	2026-09-25 13:22	XOM	XOM261009P00157500	put	157.5000	2026-10-09	2.1900	2.0800	2.1900	160.0000	42048.00	42048.00	0.00	192	42	234	832	0.28125	0.27890547796835	0.27890547796835	false	false	false	true
0e6d6f5c-061a-49f4-9c50-eb38564decf5	2026-09-25 12:45	2026-09-25 12:45	2026-09-25 12:45	XOM	XOM261016C00175000	call	175.0000	2026-10-16	0.5600	0.5600	0.6400	160.3200	35336.00	0.00	35336.00	631	44	767	9551	0.0803057271489896	0.282132794676726	0.282132794676726	false	false	false	true
8cd23646-0737-4120-b4ec-d3da66e67e5c	2026-09-25 12:15	2026-09-25 12:15	2026-09-25 12:15	XOM	XOM261002C00167500	call	167.5000	2026-10-02	0.4500	0.4400	0.5000	160.4200	32715.00	3735.00	28980.00	727	33	1430	1929	0.741316744427164	0.281767272300661	0.281767272300661	false	false	false	true
cfddfb64-2587-4024-9fe8-d57fa383d060	2026-09-25 10:18	2026-09-25 10:18	2026-09-25 10:18	XOM	XOM280121C00175000	call	175.0000	2028-01-21	17.0500	16.4500	17.2750	160.8100	20460.00	10230.00	10230.00	12	8	12	4236	0.0028328611898017	0.250892687663149	0.250892687663149	false	false	false	true
35116101-c471-49d5-aef0-c680660159d5	2026-09-25 10:07	2026-09-25 10:07	2026-09-25 10:07	XOM	XOM261218P00165000	put	165.0000	2026-12-18	11.1500	10.8000	11.2000	161.0000	24525.00	22300.00	1110.00	22	12	24	892	0.0269058295964126	0.319399072106055	0.317776027558086	false	false	false	true
5f2b72c3-2131-4fd8-8f8d-5f256f75b3f5	2026-09-25 09:38	2026-09-25 09:38	2026-09-25 09:38	XOM	XOM260925P00167500	put	167.5000	2026-09-25	6.6000	6.4500	8.2500	160.0000	18480.00	660.00	17820.00	28	19	28	90	0.311111111111111	0.706059995910191	0.706059995910191	true	false	false	true
2c164a06-ca38-4fc6-bb17-c3018dcb47b0	2026-09-25 09:37	2026-09-25 09:37	2026-09-25 09:37	XOM	XOM261120P00160000	put	160.0000	2026-11-20	7.1500	6.9500	7.1500	160.9300	182325.00	182325.00	0.00	255	5	256	3830	0.0668407310704961	0.323843757750581	0.323843757750581	true	false	false	true
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
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
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
c9a0dbff-670c-44dd-bb60-fc1dd44d19c1	2026-09-24 13:57	2026-09-24 13:56	2026-09-24 13:56	XOM	XOM261009C00165000	call	165.0000	2026-10-09	2.7800	2.6800	2.7800	162.4900	47259.00	47259.00	0.00	170	32	834	820	1.01707317073171	0.287839201602376	0.286864510684082	false	false	false	true
2bfdde3a-f52e-4c14-a18f-3c705ac4d3ab	2026-09-24 13:29	2026-09-24 13:29	2026-09-24 13:29	XOM	XOM270319C00170000	call	170.0000	2027-03-19	10.5200	10.2000	10.8500	162.5450	21040.00	0.00	21040.00	20	5	53	2400	0.0220833333333333	0.272456836927869	0.272456836927869	false	false	false	true
692435a0-58bd-4c0c-bcdc-1d5aee7f6762	2026-09-24 12:44	2026-09-24 12:43	2026-09-24 12:43	XOM	XOM261016C00175000	call	175.0000	2026-10-16	0.9100	0.9000	0.9900	162.0150	26938.00	24388.00	2550.00	296	5	2944	11516	0.255644320944772	0.290271156453301	0.29236714958303	false	false	false	true
eeb18f93-a383-4f4d-be11-e18f4a27f175	2026-09-24 12:43	2026-09-24 12:43	2026-09-24 12:43	XOM	XOM261016C00175000	call	175.0000	2026-10-16	0.9200	0.9000	0.9900	161.9000	21988.00	9292.00	12696.00	239	5	2081	11516	0.180705105939562	0.29320763693663	0.29320763693663	true	false	false	true
df8df8ad-8bc8-4a2d-a65b-c29be87f0651	2026-09-24 12:36	2026-09-24 12:36	2026-09-24 12:36	XOM	XOM261120P00160000	put	160.0000	2026-11-20	6.7500	6.6000	6.8000	162.1150	311850.00	311175.00	675.00	462	59	518	3394	0.152622274602239	0.325203323738762	0.325120345512393	false	false	false	true
122d97ae-f185-44dc-a0f8-f6926d90beac	2026-09-24 12:21	2026-09-24 12:21	2026-09-24 12:21	XOM	XOM261023C00165000	call	165.0000	2026-10-23	4.5000	4.4500	4.9000	162.6800	92255.00	90905.00	1350.00	205	5	226	226	1	0.289961655510797	0.293723979529591	false	false	false	true
8b5f0608-cf9f-4dc9-821a-7992de751be8	2026-09-24 12:21	2026-09-24 12:21	2026-09-24 12:21	XOM	XOM261016C00170000	call	170.0000	2026-10-16	2.0200	2.0000	2.0200	162.7854	52924.00	52924.00	0.00	262	5	802	22858	0.0350861842680899	0.285931694878446	0.285931694878446	false	false	false	true
87b3ea7c-800d-407d-ab8d-d850fa736db0	2026-09-24 12:21	2026-09-24 12:21	2026-09-24 12:21	XOM	XOM270115C00175000	call	175.0000	2027-01-15	6.0700	6.0500	6.4000	162.8400	15180.00	0.00	8470.00	25	5	118	4877	0.0241952019684232	0.274998989777278	0.274998989777278	false	false	false	true
686b39e5-bb33-4aef-9dc4-7fe3b1cdfb5f	2026-09-24 12:21	2026-09-24 12:20	2026-09-24 12:20	XOM	XOM261009C00167500	call	167.5000	2026-10-09	2.0700	1.9200	2.2500	162.8050	158004.00	3375.00	140967.00	763	53	1072	351	3.05413105413105	0.291315176438834	0.297120296494591	true	false	false	true
1ada9726-be8c-43cf-bde4-3b9913e6782f	2026-09-24 12:21	2026-09-24 12:20	2026-09-24 12:20	XOM	XOM261009P00157500	put	157.5000	2026-10-09	1.6900	1.6900	2.0000	162.8050	43433.00	0.00	43433.00	257	38	304	604	0.503311258278146	0.297470287828092	0.297470287828092	false	false	false	true
e86ed0d0-50b3-4455-ae76-0be707ffe46e	2026-09-24 12:17	2026-09-24 12:17	2026-09-24 12:17	XOM	XOM261120C00145000	call	145.0000	2026-11-20	20.0000	20.0000	21.0000	162.6500	104000.00	0.00	104000.00	52	12	313	1924	0.162681912681913	0.298525831752363	0.298525831752363	false	false	false	true
73e6cd80-878c-44f2-b98b-2daca268f2db	2026-09-24 11:52	2026-09-24 11:52	2026-09-24 11:52	XOM	XOM260925P00165000	put	165.0000	2026-09-25	1.5700	1.3900	1.5700	164.3300	11616.00	11616.00	0.00	74	21	299	297	1.00673400673401	0.353762147622112	0.353762147622112	true	false	false	true
992556ed-7600-4e65-9c23-201274e432b9	2026-09-24 11:49	2026-09-24 11:49	2026-09-24 11:49	XOM	XOM261009C00165000	call	165.0000	2026-10-09	3.7500	3.7250	3.9000	164.4500	40875.00	0.00	40875.00	109	5	465	820	0.567073170731707	0.29214843591011	0.29214843591011	false	false	false	true
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
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