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:alert_rule = RepeatedHits×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

b2f57cc6-41be-4f0c-9562-12899026f826	2026-08-17 11:27	2026-08-17 11:27	2026-08-17 11:27	XOM	XOM261218C00180000	call	180.0000	2026-12-18	4.1000	3.9500	4.2000	160.5800	133660.00	127100.00	6560.00	326	14	735	4005	0.183520599250936	0.268402542670387	0.268402542670387	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	678794426357.00	2026-10-30	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1ede3d99-b8e0-4df4-ab39-a815ff9991ad	2026-08-17 13:31	2026-08-17 13:30	2026-08-17 13:30	XOM	XOM270115P00125000	put	125.0000	2027-01-15	1.2000	1.2000	1.2400	161.7800	171720.00	0.00	171720.00	1431	53	1456	5914	0.246195468380115	0.317883087590857	0.318076324100013	false	false	false	true
128d0275-a24e-4a68-abc7-01f794f2c37e	2026-08-17 13:52	2026-08-17 13:52	2026-08-17 13:52	XOM	XOM260828C00165000	call	165.0000	2026-08-28	1.9200	1.8300	1.9900	161.0000	100031.00	99648.00	192.00	521	36	660	1431	0.461215932914046	0.284278795158498	0.284278795158498	false	false	false	true
7b51ddd9-9a66-4748-b711-c55884adae45	2026-08-18 09:52	2026-08-18 09:52	2026-08-18 09:52	XOM	XOM260918C00165000	call	165.0000	2026-09-18	5.1000	5.1000	5.2500	164.0350	109140.00	0.00	109140.00	214	25	414	11224	0.0368852459016393	0.278270553688196	0.278270553688196	true	false	false	true
1529c201-c63f-49fc-bfd5-75242622cfed	2026-08-18 11:49	2026-08-18 11:49	2026-08-18 11:49	XOM	XOM261016P00150000	put	150.0000	2026-10-16	2.0600	1.9700	2.1300	164.6301	253997.00	253173.00	618.00	1233	64	2105	2857	0.736786839341967	0.293958715028029	0.29328109441992	true	false	false	true
9a8e8092-44a5-4abf-9174-6e39dc1fcff3	2026-08-19 12:37	2026-08-19 12:37	2026-08-19 12:37	XOM	XOM261120P00170000	put	170.0000	2026-11-20	11.0000	10.9500	11.2000	166.5550	232105.00	1100.00	231005.00	211	46	265	39	6.79487179487179	0.299497633386445	0.299497633386445	false	false	false	true
89e23377-fa72-4341-830d-81b29145081f	2026-08-19 13:36	2026-08-19 13:35	2026-08-19 13:35	XOM	XOM270319C00180000	call	180.0000	2027-03-19	9.3500	9.3000	9.3500	166.0990	178585.00	74800.00	0.00	191	10	1415	1067	1.3261480787254	0.263784704412712	0.263784704412712	false	false	false	true
a871d49e-eea5-4606-88db-0e0ed550880b	2026-08-19 13:38	2026-08-19 13:38	2026-08-19 13:38	XOM	XOM270319C00180000	call	180.0000	2027-03-19	9.3100	9.3000	9.5500	165.9500	113555.00	17765.00	95790.00	122	6	1537	1067	1.44048734770384	0.264056920533586	0.26506543183936	false	false	false	true
b9153204-0c20-4e7f-9610-9f4c7dca443e	2026-08-20 12:33	2026-08-20 12:33	2026-08-20 12:33	XOM	XOM261120P00160000	put	160.0000	2026-11-20	5.9500	5.9500	6.0500	167.4350	110670.00	0.00	110670.00	186	28	248	705	0.35177304964539	0.300545438714268	0.300545438714268	false	false	false	true
48dec495-7402-496c-bc5c-59a5da0276af	2026-08-20 12:38	2026-08-20 12:38	2026-08-20 12:38	XOM	XOM261120C00190000	call	190.0000	2026-11-20	3.0000	2.8300	3.0000	167.3800	300000.00	300000.00	0.00	1000	30	1338	2704	0.494822485207101	0.286786426518843	0.286786426518843	false	false	false	true
f2a4f9c5-2946-4401-99f2-a8fba2fb9258	2026-08-20 12:46	2026-08-20 12:45	2026-08-20 12:45	XOM	XOM261120C00200000	call	200.0000	2026-11-20	1.6500	1.4800	1.6500	167.5285	165000.00	141900.00	0.00	1000	11	1129	1372	0.822886297376093	0.290252690476757	0.290252690476757	false	false	false	true
7d860aeb-b742-4f47-85c8-1690b133820c	2026-08-27 13:01	2026-08-27 13:01	2026-08-27 13:01	XOM	XOM270617C00180000	call	180.0000	2027-06-17	8.3000	8.3000	8.7500	157.5800	145250.00	0.00	145250.00	175	29	269	1284	0.209501557632399	0.256787901842022	0.256787901842022	true	false	false	true
7af5ff75-ac6d-491a-9477-63ab85bad86b	2026-08-27 13:01	2026-08-27 13:01	2026-08-27 13:01	XOM	XOM270319C00175000	call	175.0000	2027-03-19	6.9000	6.9000	7.2000	157.6000	211140.00	0.00	211140.00	306	5	438	1023	0.428152492668622	0.255790793222219	0.255790793222219	true	false	false	true
1ec56652-db34-4c8b-bfe2-3424c0caa2a3	2026-08-27 13:01	2026-08-27 13:01	2026-08-27 13:01	XOM	XOM270115C00170000	call	170.0000	2027-01-15	6.3000	6.2500	6.4500	157.5100	102690.00	44730.00	56070.00	163	36	308	6353	0.0484810325830316	0.261330809316124	0.261639068413791	true	false	false	true
92153681-3d9c-49ab-9012-bd8cc68fe45c	2026-08-31 09:54	2026-08-31 09:54	2026-08-31 09:54	XOM	XOM260911C00160000	call	160.0000	2026-09-11	3.7500	3.6500	4.3500	160.8800	123000.00	750.00	122250.00	328	26	384	438	0.876712328767123	0.285821299035516	0.287357961201023	false	false	false	true
2382489a-18d5-41f4-bf67-eb99d5d17863	2026-09-01 09:39	2026-09-01 09:39	2026-09-01 09:39	XOM	XOM261218C00150000	call	150.0000	2026-12-18	18.6000	17.9000	18.6000	163.4200	120900.00	120900.00	0.00	65	6	100	8224	0.01215953307393	0.268639313650886	0.268639313650886	false	false	false	true
82b2d9a5-cb7e-4e2d-96ee-751abf12633f	2026-09-03 11:19	2026-09-03 11:19	2026-09-03 11:19	XOM	XOM261218P00160000	put	160.0000	2026-12-18	7.3000	7.2500	7.5500	165.1800	217540.00	1460.00	216080.00	298	28	329	1329	0.247554552294959	0.300766823180636	0.300860365081799	false	false	false	true
8ee160ed-3474-4a3c-9fb9-c7562f75d6e0	2026-09-04 09:34	2026-09-04 09:34	2026-09-04 09:34	XOM	XOM281215C00200000	call	200.0000	2028-12-15	14.7500	14.7500	15.8000	160.2560	191750.00	0.00	191750.00	130	5	130	554	0.234657039711191	0.241811895037767	0.241811895037767	false	false	false	true
67139bd3-37a8-41d7-b399-0338a10ccdb5	2026-09-10 11:46	2026-09-10 11:45	2026-09-10 11:45	XOM	XOM260918C00165000	call	165.0000	2026-09-18	2.9100	2.7600	2.9100	164.6900	146955.00	146955.00	0.00	505	20	941	12807	0.0734754431170454	0.307809377136698	0.307809377136698	false	false	false	true
7c46cebf-1aca-4abc-a0f0-9464b2cd5797	2026-09-10 13:53	2026-09-10 13:53	2026-09-10 13:53	XOM	XOM270617P00140000	put	140.0000	2027-06-17	6.2000	5.9000	6.4500	165.2100	148155.00	145675.00	2480.00	239	14	240	3871	0.0619994833376389	0.327114721194216	0.327114721194216	false	false	false	true
42814647-0bb1-46dc-bfa4-6295ad530521	2026-09-10 15:32	2026-09-10 15:32	2026-09-10 15:32	XOM	XOM261016C00175000	call	175.0000	2026-10-16	2.6900	2.6700	2.7200	165.3000	163014.00	8339.00	154406.00	606	19	1564	8880	0.176126126126126	0.29074396339602	0.29074396339602	true	false	false	true
50a18db5-4d4d-4ea7-99f0-1f396770809c	2026-09-11 13:18	2026-09-11 13:18	2026-09-11 13:18	XOM	XOM270115P00165000	put	165.0000	2027-01-15	10.7000	10.7000	10.9500	165.2600	157290.00	0.00	157290.00	147	28	207	907	0.228224917309813	0.311014727152212	0.311014727152212	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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