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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×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

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	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	650915663268.00	2026-10-30	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T18:00:14.697100Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
4a7f2964-41f9-418a-b490-b7bd57df18ef	2026-09-16 11:04	2026-09-16 11:04	2026-09-16 11:04	XOM	XOM261120C00175000	call	175.0000	2026-11-20	4.3000	4.2500	4.5500	163.6700	102380.00	3480.00	98900.00	238	27	266	2916	0.0912208504801097	0.295538989813941	0.297515824733116	false	false	false	true
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
162b459a-549a-4fb8-b30b-d8f7bc69c7eb	2026-09-15 15:58	2026-09-15 15:58	2026-09-15 15:58	XOM	XOM261120C00170000	call	170.0000	2026-11-20	8.7500	8.7500	9.0000	169.0000	161875.00	0.00	161875.00	185	15	396	4006	0.0988517224163754	0.29896625441453	0.29896625441453	true	false	false	true
4b7c7cf4-1eda-4039-be39-5488fc55989a	2026-09-15 14:25	2026-09-15 14:25	2026-09-15 14:25	XOM	XOM270115C00185000	call	185.0000	2027-01-15	6.2000	6.1000	6.3000	169.0200	123936.00	102856.00	14880.00	200	6	458	7338	0.0624148269283183	0.289253797716753	0.288978768316811	false	false	false	true
cfc69e11-5b5e-4ca1-b6e3-10aca74597ff	2026-09-15 13:20	2026-09-15 13:20	2026-09-15 13:20	XOM	XOM261016C00185000	call	185.0000	2026-10-16	1.3500	1.3000	1.4300	169.1700	131761.00	3240.00	128521.00	974	34	1258	1854	0.678532901833873	0.301888073844499	0.301888073844499	true	false	false	true
4630f616-b5d4-4694-87c9-05dbb9bf32a5	2026-09-15 10:34	2026-09-15 10:34	2026-09-15 10:34	XOM	XOM270319C00200000	call	200.0000	2027-03-19	4.4700	4.3000	4.9000	167.4500	4470000.00	0.00	4470000.00	10000	2	10181	2630	3.87110266159696	0.279232947287392	0.279232947287392	false	true	false	true
eb2fd49c-c51e-4b25-af0d-cd90541d9c7e	2026-09-15 09:57	2026-09-15 09:57	2026-09-15 09:57	XOM	XOM261016C00155000	call	155.0000	2026-10-16	14.9800	14.5000	14.8000	167.3850	7250975.00	7250975.00	0.00	4839	37	5307	6437	0.824452384651235	0.340232228949867	0.340232228949867	true	true	false	true
43bb967a-5f2f-4fe3-9d47-3f972dc6219a	2026-09-15 09:44	2026-09-15 09:44	2026-09-15 09:44	XOM	XOM261016C00155000	call	155.0000	2026-10-16	14.2500	14.2500	14.8000	166.8900	229425.00	0.00	229425.00	161	6	411	6437	0.0638496193879136	0.328948078379863	0.328948078379863	false	false	false	true
9fe00b40-16a5-43f6-9324-50456f7dc6cd	2026-09-14 15:29	2026-09-14 15:28	2026-09-14 15:28	XOM	XOM270115C00170000	call	170.0000	2027-01-15	9.3500	9.1000	9.3500	164.2800	112200.00	112200.00	0.00	120	20	241	6983	0.0345123872261206	0.288523352550263	0.288523352550263	false	false	false	true
a28348a3-396b-4a3d-94de-e18c72ee174a	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	XOM	XOM261120C00160000	call	160.0000	2026-11-20	11.3100	11.3000	11.6000	164.6100	235251.00	0.00	235251.00	208	5	287	1915	0.149869451697128	0.292945832162553	0.292190384630898	false	false	false	true
95fc3972-eebe-4fbd-a3b6-b09c4a4ae0c6	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	XOM	XOM260918P00165000	put	165.0000	2026-09-18	2.5500	2.3000	2.5500	164.6100	138720.00	138720.00	0.00	544	28	2059	2380	0.865126050420168	0.346920765362514	0.346920765362514	false	false	false	true
7ef2497b-c0f0-4a86-9815-2c9d2ed5ebf7	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	XOM	XOM260925C00165000	call	165.0000	2026-09-25	3.7500	3.7000	3.7500	165.1700	122625.00	122625.00	0.00	327	7	416	690	0.602898550724638	0.312308669024937	0.312308669024937	true	false	false	true
a87d33a7-fb11-4f89-a6b4-3af613ed4fa1	2026-09-14 11:10	2026-09-14 11:10	2026-09-14 11:10	XOM	XOM261016C00175000	call	175.0000	2026-10-16	2.6500	2.5500	2.8900	166.0600	375359.00	107444.00	253340.00	1415	44	1578	10067	0.156749776497467	0.293587978346317	0.295336142239812	true	false	false	true