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:endpoint = /api/option-trades/flow-alerts×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
5b156772-2551-400f-b347-5cd1b58f59df	2026-09-25 14:00	2026-09-25 14:00	2026-09-25 14:00	XOM	XOM261023C00175000	call	175.0000	2026-10-23	0.8700	0.8700	0.9000	160.0000	11411.00	1232.00	10179.00	131	13	431	742	0.580862533692722	0.27882485832887	0.277827184900838	true	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
a6157d47-ec3d-43a3-973f-1e2601bf9b2c	2026-09-25 12:09	2026-09-25 12:09	2026-09-25 12:09	XOM	XOM261002P00160000	put	160.0000	2026-10-02	2.3400	2.2700	2.3800	160.2550	26715.00	24141.00	2574.00	114	20	901	559	1.61180679785331	0.287756524266549	0.285490457448264	true	false	false	true
a524eca1-76a6-4498-8cad-6638021887ce	2026-09-25 11:57	2026-09-25 11:57	2026-09-25 11:57	XOM	XOM261002P00160000	put	160.0000	2026-10-02	1.9100	1.7500	1.9500	161.0750	26351.00	13371.00	12980.00	138	20	478	559	0.855098389982111	0.280855992884028	0.277798520234927	true	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
2671844c-c84c-4501-9478-8f1b0f798789	2026-09-25 10:01	2026-09-25 10:01	2026-09-25 10:01	XOM	XOM261002P00162500	put	162.5000	2026-10-02	3.1900	2.9000	3.2000	161.0000	12106.00	12106.00	0.00	38	14	62	970	0.0639175257731959	0.285396534187511	0.296721927878117	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
325bade7-b9df-4fd7-8e24-c1e61ae2e4ae	2026-09-25 09:33	2026-09-25 09:33	2026-09-25 09:33	XOM	XOM261120C00145000	call	145.0000	2026-11-20	17.7000	17.5000	18.3000	160.0500	33635.00	3600.00	30035.00	19	5	19	2225	0.00853932584269663	0.291477092402208	0.291477092402208	false	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
681d7f45-b1af-40e7-a8f8-f7a8fda060a7	2026-09-24 14:32	2026-09-24 14:32	2026-09-24 14:32	XOM	XOM270917P00140000	put	140.0000	2027-09-17	8.0800	7.8500	8.1000	161.8050	120355.00	119550.00	805.00	149	17	178	161	1.1055900621118	0.323691160584062	0.324726146734205	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
7b9544d3-8e55-438b-b9bf-a3b2b1d7fc5a	2026-09-24 12:21	2026-09-24 12:20	2026-09-24 12:20	XOM	XOM261009P00160000	put	160.0000	2026-10-09	2.5000	2.4700	2.8400	162.8050	55403.00	27515.00	27888.00	222	10	303	390	0.776923076923077	0.293683919375358	0.296911126386856	true	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
1542cf69-a9c6-4c54-843a-3f4ab42959a2	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	XOM	XOM260925P00162500	put	162.5000	2026-09-25	1.1400	1.0000	1.1700	162.0000	17392.00	8421.00	7831.00	152	24	1039	645	1.61085271317829	0.403213758985847	0.409158740906868	true	false	false	true
014794d8-994a-4953-81da-104f1220abd6	2026-09-24 12:15	2026-09-24 12:15	2026-09-24 12:15	XOM	XOM261002P00162500	put	162.5000	2026-10-02	2.3800	2.0500	2.3900	163.4600	11429.00	11429.00	0.00	48	9	131	868	0.150921658986175	0.299088055038874	0.302243010094203	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
705baa82-5f58-40e8-9f3c-06f141fc5026	2026-09-24 11:01	2026-09-24 11:01	2026-09-24 11:01	XOM	XOM261120C00165000	call	165.0000	2026-11-20	7.5700	7.5500	7.9000	164.3700	22695.00	0.00	22695.00	30	7	127	3450	0.0368115942028985	0.283630738885993	0.285566299269288	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
3c48e697-adf8-4aec-a46a-44a9a3056c02	2026-09-24 10:17	2026-09-24 10:17	2026-09-24 10:17	XOM	XOM260925C00165000	call	165.0000	2026-09-25	1.3200	1.2200	1.3200	164.8201	15832.00	15832.00	0.00	120	9	1975	3748	0.526947705442903	0.400606288494942	0.406421108755267	false	false	false	true
357a1f1e-81df-4c95-81e0-a588d3d9ec8d	2026-09-24 10:13	2026-09-24 10:13	2026-09-24 10:13	XOM	XOM261120C00175000	call	175.0000	2026-11-20	3.8000	3.6000	3.8500	164.3700	221144.00	216964.00	4180.00	582	62	604	4038	0.149578999504705	0.286461263841322	0.286461263841322	false	false	false	true