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

c0e3dfac-5373-4844-9eed-c14019563a23	2026-09-22 13:31	2026-09-22 13:31	2026-09-22 13:31	XOM	XOM261120C00160000	call	160.0000	2026-11-20	7.7400	7.7000	7.8500	159.0000	38714.00	0.00	38714.00	50	5	205	3468	0.0591118800461361	0.285628414471943	0.285628414471943	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Energy	652601547172.00	2026-10-30	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T17:40:26.166069Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
8db27cc7-5e8c-459d-b17c-953b3ed38a1d	2026-09-22 12:34	2026-09-22 12:34	2026-09-22 12:34	XOM	XOM261016P00150000	put	150.0000	2026-10-16	1.2400	1.1800	1.2700	159.8800	18659.00	18659.00	0.00	150	5	621	9119	0.0680995723215265	0.297475530059184	0.297475530059184	false	false	false	true
5978f328-b777-4948-948e-29a3fe482832	2026-09-22 12:15	2026-09-22 12:14	2026-09-22 12:14	XOM	XOM270319P00160000	put	160.0000	2027-03-19	12.3600	12.2500	12.6000	159.9500	16067.00	0.00	16067.00	13	5	208	1273	0.163393558523174	0.316542076339589	0.316542076339589	false	false	false	true
9c618fe1-3770-4471-8e06-d1fe83a611f8	2026-09-22 11:23	2026-09-22 11:23	2026-09-22 11:23	XOM	XOM261023P00150000	put	150.0000	2026-10-23	1.8100	1.8000	2.0000	159.0000	25825.00	372.00	13033.00	143	7	180	1973	0.0912316269640142	0.296980035156922	0.295524020322975	true	false	false	true
a3e2bda5-9b49-455f-b52e-516497f9b4ca	2026-09-22 11:20	2026-09-22 11:20	2026-09-22 11:20	XOM	XOM261009C00165000	call	165.0000	2026-10-09	1.8600	1.7100	1.9000	159.0600	10044.00	9859.00	185.00	54	5	91	336	0.270833333333333	0.293960622093251	0.292289821664318	false	false	false	true
7e8a53ed-2165-457f-881b-1c681cd4259d	2026-09-22 11:20	2026-09-22 11:20	2026-09-22 11:20	XOM	XOM261009C00162500	call	162.5000	2026-10-09	2.6500	2.4800	2.7500	159.0600	20120.00	11967.00	8153.00	76	10	85	514	0.165369649805447	0.293512399769761	0.291235242138674	false	false	false	true
b7d31945-16b3-4fbf-9487-50fc26bcf331	2026-09-22 11:04	2026-09-22 11:04	2026-09-22 11:04	XOM	XOM280121C00170000	call	170.0000	2028-01-21	18.3600	18.0000	19.0000	159.3400	14686.00	7336.00	7350.00	8	6	8	1361	0.00587803085966201	0.254289900408037	0.2523776568792	false	false	false	true
11546c53-7274-4f31-948c-d737bca8f6ca	2026-09-22 11:02	2026-09-22 11:02	2026-09-22 11:02	XOM	XOM281215C00145000	call	145.0000	2028-12-15	36.0300	35.7000	36.0500	159.1900	36034.00	36034.00	0.00	10	5	87	7749	0.0112272551296942	0.211323567330473	0.211179566143129	false	false	false	true
a73fad1d-09d8-4919-be35-87e8ed32b776	2026-09-22 10:47	2026-09-22 10:47	2026-09-22 10:47	XOM	XOM281215C00170000	call	170.0000	2028-12-15	25.1000	24.5000	25.2000	159.5400	25102.00	25102.00	0.00	10	6	196	6766	0.0289683712681052	0.233235390400722	0.233125504454257	true	false	false	true
a7c31265-3b53-474b-a1bd-5d01f3a6c136	2026-09-22 10:28	2026-09-22 10:28	2026-09-22 10:28	XOM	XOM281215C00155000	call	155.0000	2028-12-15	30.7200	30.2000	31.0500	158.9100	21505.00	18440.00	3065.00	7	7	10	1274	0.00784929356357928	0.221788758661812	0.21869613717229	false	false	false	true
05c4687b-14bc-4fd0-ab8f-d7248a23362d	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	XOM	XOM260925P00155000	put	155.0000	2026-09-25	1.2900	0.9500	1.7300	156.6150	19012.00	18038.00	494.00	147	12	147	2108	0.0697343453510436	0.345893325130338	0.351863124308608	true	false	false	true
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
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
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
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
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
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
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
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
010f6803-5b5c-4fb1-bbd8-e5acb5b7b996	2026-09-11 14:14	2026-09-11 14:14	2026-09-11 14:14	XOM	XOM261016P00165000	put	165.0000	2026-10-16	5.5000	5.4000	5.5500	165.2800	673182.00	672632.00	0.00	1224	60	1289	711	1.81293952180028	0.293665650245137	0.292091012617809	false	false	false	true
bf82243b-e5f5-4156-b955-812a6f57fc2d	2026-08-31 14:46	2026-08-31 14:46	2026-08-31 14:46	XOM	XOM260918C00160000	call	160.0000	2026-09-18	4.3000	4.2000	4.4500	160.4600	590802.00	580912.00	9890.00	1374	66	1669	10490	0.159103908484271	0.275906614452762	0.275522418400753	false	false	false	true
85f63c1f-dc42-460e-b912-e6b117538027	2026-08-24 14:26	2026-08-24 14:26	2026-08-24 14:26	XOM	XOM260918P00165000	put	165.0000	2026-09-18	5.3000	5.1500	5.3500	163.5600	644992.00	633862.00	11130.00	1217	66	1302	1152	1.13020833333333	0.279266585495844	0.278959344751033	false	false	false	true
c8bcfa12-a4ce-445c-ab1b-64e45c69e1c3	2026-08-19 13:35	2026-08-19 13:35	2026-08-19 13:35	XOM	XOM261218C00155000	call	155.0000	2026-12-18	17.8700	17.4500	18.1000	166.0000	359182.00	341282.00	17900.00	201	27	1437	4948	0.290420371867421	0.275790680128725	0.275790680128725	true	false	false	true
594b20d3-9767-406e-a3e0-c9eaad4380e2	2026-08-18 10:09	2026-08-18 10:09	2026-08-18 10:09	XOM	XOM261016P00150000	put	150.0000	2026-10-16	2.0800	1.9300	2.1300	164.2700	124974.00	118143.00	6831.00	601	46	614	2857	0.214910745537277	0.290634460716043	0.290070623976938	false	false	false	true
ea64ca41-b586-4781-8c19-9233d80f8710	2026-08-17 10:56	2026-08-17 10:55	2026-08-17 10:55	XOM	XOM270617P00160000	put	160.0000	2027-06-17	15.2900	15.1000	15.3000	160.2900	302779.00	232399.00	0.00	198	8	198	600	0.33	0.313511242609646	0.313511242609646	true	false	false	true