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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_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	expirydate

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	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-24T19:29:28.297700Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
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
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
5b8e89d2-9d64-456b-babc-30a09fc5e901	2026-09-24 09:52	2026-09-24 09:52	2026-09-24 09:52	XOM	XOM261002C00167500	call	167.5000	2026-10-02	1.4400	1.4100	1.6000	163.8500	22611.00	146.00	22465.00	157	22	306	1145	0.267248908296943	0.290977330875696	0.294388100388525	true	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
bb66ee78-bdda-45f5-b98a-f1aa0bbe1f3c	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	XOM	XOM261120C00145000	call	145.0000	2026-11-20	19.7200	17.1000	20.0000	162.3700	27615.00	27615.00	0.00	14	9	14	1924	0.00727650727650728	0.314801629745125	0.29438343442529	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
74aee151-52ae-49a9-b1a6-26aab18367e9	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	XOM	XOM261016C00155000	call	155.0000	2026-10-16	9.2900	8.7000	12.9250	162.3200	115210.00	3760.00	111450.00	124	36	124	9247	0.0134097545149778	0.230060160466543	0.28972999316424	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
6399a53b-da31-4b41-a399-9c451df1f0f0	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.7800	18.7500	18.8500	161.1800	37564.00	15052.00	22512.00	20	6	494	1049	0.470924690181125	0.296085759336721	0.299319763222368	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