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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = XOM×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	pricenumeric

3f16b4f1-61e1-4a73-89ec-a71c15a70a31	2026-09-16 11:04	2026-09-16 11:04	2026-09-16 11:04	XOM	XOM261120C00180000	call	180.0000	2026-11-20	3.0500	3.0000	3.2500	163.6700	438330.00	4315.00	429440.00	1437	62	1506	4770	0.315723270440252	0.29669345442276	0.29669345442276	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	671557461307.00	2026-10-30	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T15:13:34.724907Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
861fc30f-0695-4c88-a668-cbdf167b40f0	2026-09-16 11:47	2026-09-16 11:47	2026-09-16 11:47	XOM	XOM260918P00165000	put	165.0000	2026-09-18	2.4500	2.4400	2.4800	163.8500	113545.00	77910.00	11235.00	464	10	2187	3491	0.626468060727585	0.378848576074088	0.378848576074088	false	false	false	true	false
d9c33287-0f5e-4245-9287-da2fd88523e6	2026-09-16 12:32	2026-09-16 12:32	2026-09-16 12:32	XOM	XOM271217C00200000	call	200.0000	2027-12-17	10.7000	10.5000	10.8000	164.4650	122030.00	74900.00	46060.00	114	29	114	260	0.438461538461538	0.262309222294971	0.262309222294971	false	false	false	true	false
80a69c29-bb40-4f0e-ba66-83d7f33b5785	2026-09-16 14:23	2026-09-16 14:23	2026-09-16 14:23	XOM	XOM270617C00150000	call	150.0000	2027-06-17	25.8000	25.8000	26.3000	164.8500	366388.00	0.00	366388.00	142	21	152	1381	0.110065170166546	0.257625060893465	0.257625060893465	false	false	false	true	false
7c567637-bbf6-4711-ac2d-74e64fea9485	2026-09-17 10:03	2026-09-17 10:03	2026-09-17 10:03	XOM	XOM260918C00150000	call	150.0000	2026-09-18	12.1000	12.0500	13.1000	162.1000	139150.00	0.00	139150.00	115	5	394	5547	0.0710293852532901	1.47147263799072	1.47147263799072	false	false	false	true	false
1c49b0af-d288-4ff8-b719-541821529122	2026-09-17 11:07	2026-09-17 11:07	2026-09-17 11:07	XOM	XOM270115P00160000	put	160.0000	2027-01-15	9.3500	9.3500	9.5500	162.1600	689095.00	0.00	689095.00	737	49	750	2942	0.254928619986404	0.312082362532814	0.312082362532814	false	false	false	true	false
46acd91c-ec3b-4cba-b533-37c091e8d316	2026-09-17 12:33	2026-09-17 12:33	2026-09-17 12:33	XOM	XOM261218C00175000	call	175.0000	2026-12-18	5.0500	4.9000	5.0500	162.4665	505954.00	505954.00	0.00	1002	52	1086	3023	0.359245782335428	0.281278598260399	0.281278598260399	true	false	false	true	false
68b26634-d679-4735-88ee-35b518e728f9	2026-09-17 13:15	2026-09-17 13:15	2026-09-17 13:15	XOM	XOM260918C00155000	call	155.0000	2026-09-18	7.7900	7.2500	8.0000	162.6800	228247.00	228247.00	0.00	293	5	375	7433	0.0504506928561819	0.557567081753958	0.557567081753958	false	false	false	true	false
b379636c-310b-4401-b8d4-7df21f346eef	2026-09-17 13:38	2026-09-17 13:38	2026-09-17 13:38	XOM	XOM261023P00150000	put	150.0000	2026-10-23	1.4100	1.3300	1.5800	162.6600	169200.00	0.00	169200.00	1200	8	1212	739	1.64005412719892	0.295582457124398	0.295582457124398	false	true	false	true	false
97bfb8bd-1477-4271-9514-94770de2b99d	2026-09-17 14:34	2026-09-17 14:34	2026-09-17 14:34	XOM	XOM261120P00160000	put	160.0000	2026-11-20	6.6000	6.4500	6.6000	162.7701	145200.00	145200.00	0.00	220	8	320	3050	0.104918032786885	0.313617898783497	0.313617898783497	false	false	false	true	false
b70d3a2c-3f62-4b25-a886-0d7eb736362d	2026-09-17 15:44	2026-09-17 15:44	2026-09-17 15:44	XOM	XOM270319P00140000	put	140.0000	2027-03-19	4.5000	4.3500	4.5000	163.0200	122400.00	122400.00	0.00	272	8	376	2785	0.135008976660682	0.327321107854364	0.327321107854364	false	false	false	true	false
0e72fe8b-ebeb-433b-acc4-c2159de88f28	2026-09-18 09:33	2026-09-18 09:33	2026-09-18 09:33	XOM	XOM280121P00180000	put	180.0000	2028-01-21	28.3500	28.3500	29.0500	163.2500	144605.00	5685.00	138920.00	51	11	51	151	0.337748344370861	0.3319805139867	0.3319805139867	false	false	false	true	false
b53f1976-4e1d-4545-8aab-f126536d7ef4	2026-09-18 10:02	2026-09-18 10:01	2026-09-18 10:01	XOM	XOM281215C00180000	call	180.0000	2028-12-15	23.1400	22.4000	23.3500	162.6900	141138.00	141138.00	0.00	61	6	121	1183	0.102282333051564	0.235754552253188	0.235754552253188	false	false	false	true	false
3182a20d-9d10-4f31-9337-3462ff640e0f	2026-09-18 10:02	2026-09-18 10:02	2026-09-18 10:02	XOM	XOM281215C00180000	call	180.0000	2028-12-15	23.1800	22.4000	23.3500	162.7100	254935.00	236475.00	18460.00	110	14	231	1183	0.195266272189349	0.235739013296201	0.237099775211483	true	false	false	true	false
009a07f5-892a-4a80-b569-cc2f7f0a3749	2026-09-18 10:02	2026-09-18 10:02	2026-09-18 10:02	XOM	XOM281215C00165000	call	165.0000	2028-12-15	29.1000	27.8000	29.1000	162.6500	206582.00	206582.00	0.00	71	29	71	2088	0.0340038314176245	0.230706128549392	0.229575350859718	false	false	false	true	false
981ebb75-dbc0-4908-a1f2-8b7c09bf6683	2026-09-18 11:17	2026-09-18 11:17	2026-09-18 11:17	XOM	XOM260925C00150000	call	150.0000	2026-09-25	13.5000	12.9000	13.6000	163.3000	346950.00	284850.00	62100.00	257	5	257	25	10.28	0.331114286276077	0.331114286276077	false	false	false	true	false
9c6d5a6e-5053-48ea-8c37-3cedf2718f5c	2026-09-18 11:21	2026-09-18 11:21	2026-09-18 11:21	XOM	XOM270115C00165000	call	165.0000	2027-01-15	10.3000	10.3000	10.7000	163.2550	515000.00	0.00	515000.00	500	24	507	4624	0.109645328719723	0.270687138146048	0.270687138146048	false	false	false	true	false
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	false
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	false
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	false
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	false
91532f5d-433a-4161-9933-7d7429d4f589	2026-09-18 15:40	2026-09-18 15:39	2026-09-18 15:39	XOM	XOM261016C00170000	call	170.0000	2026-10-16	2.3200	2.2000	2.4000	162.3150	111358.00	110664.00	694.00	480	55	733	21654	0.0338505587882146	0.280739145687001	0.279138455114196	false	false	false	true	false
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	false
7d5c9cd3-2457-4731-9d03-789355a5f73d	2026-09-21 10:40	2026-09-21 10:40	2026-09-21 10:40	XOM	XOM270319C00190000	call	190.0000	2027-03-19	4.1900	4.1500	4.4500	159.6275	43595.00	1680.00	41915.00	104	9	105	1905	0.0551181102362205	0.282002565104003	0.279172365140538	false	false	false	true	false
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	false
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	false
34067a8f-e1e7-4912-a295-845ac4e578a5	2026-09-21 12:23	2026-09-21 12:22	2026-09-21 12:22	XOM	XOM261218C00175000	call	175.0000	2026-12-18	3.5300	3.5000	3.6000	158.3400	19085.00	9585.00	5950.00	54	8	103	3962	0.0259969712266532	0.279848839476556	0.281760872742659	false	false	false	true	false
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	false
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	false
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	false
c8662108-9ce0-48f7-bbea-3a2cd95c9008	2026-09-21 13:07	2026-09-21 13:07	2026-09-21 13:07	XOM	XOM281215C00220000	call	220.0000	2028-12-15	10.6500	10.6500	11.0500	158.2650	55390.00	1070.00	54320.00	52	6	144	228	0.631578947368421	0.244617642816152	0.245197516401791	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
b662823b-0425-437f-8b86-264edbc7dedf	2026-09-21 13:56	2026-09-21 13:56	2026-09-21 13:56	XOM	XOM270319P00125000	put	125.0000	2027-03-19	2.1600	2.1500	2.3600	158.8700	10563.00	880.00	9683.00	49	5	62	1582	0.0391908975979772	0.333062918255184	0.335567633322067	false	false	false	true	false
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	false
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	false
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	false
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	false
a74caf75-2f35-422b-b3ca-2b57bc372b15	2026-09-21 14:53	2026-09-21 14:53	2026-09-21 14:53	XOM	XOM290119C00200000	call	200.0000	2029-01-19	16.1500	16.1000	17.0000	159.3150	11305.00	1620.00	9685.00	7	5	246	6	41	0.242392764890813	0.241353510158618	false	false	false	true	false
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	false
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	false
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	false
9404a6e2-b313-498a-ac40-f52cd3d0c4da	2026-09-21 15:27	2026-09-21 15:27	2026-09-21 15:27	XOM	XOM260925P00155000	put	155.0000	2026-09-25	0.8000	0.7300	0.8200	158.6600	27720.00	24561.00	3159.00	346	33	2038	1317	1.54745634016705	0.333439462421073	0.333969467466245	false	false	false	true	false
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	false
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	false