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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×ticker = XLE×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

21aad1d4-4807-4a76-ad14-f6f66703b2c3	2026-09-11 14:43	2026-09-11 14:43	2026-09-11 14:43	XLE	XLE261120P00060000	put	60.0000	2026-11-20	1.0600	1.0600	1.0900	65.0396	41552.00	0.00	41552.00	392	8	1299	7749	0.167634533488192	0.280938290875462	0.280938290875462	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	42699711298.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-11T19:04:54.864587Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
647b8ee8-d560-4eec-8218-35e70178e5c4	2026-09-11 14:42	2026-09-11 14:42	2026-09-11 14:42	XLE	XLE261120P00060000	put	60.0000	2026-11-20	1.0600	1.0600	1.0900	65.0250	34132.00	0.00	34132.00	322	5	906	7749	0.116918312040263	0.280558856880007	0.280558856880007	false	false	false	true
358a9106-0b38-4537-9ffc-e0fa83a8eac7	2026-09-11 14:41	2026-09-11 14:41	2026-09-11 14:41	XLE	XLE261120C00071000	call	71.0000	2026-11-20	1.1000	1.1000	1.1300	65.0250	56650.00	0.00	56650.00	515	10	829	100	8.29	0.260929020341039	0.260929020341039	false	false	false	true
9bceacad-6fcf-4b32-bb36-ebf269963adf	2026-09-11 14:29	2026-09-11 14:29	2026-09-11 14:29	XLE	XLE260918P00063000	put	63.0000	2026-09-18	0.2400	0.2300	0.2400	65.0450	10176.00	10176.00	0.00	424	17	4757	5680	0.8375	0.265090499620886	0.265090499620886	true	false	false	true
1fd3822b-e10e-4eea-840c-0c584d26d58b	2026-09-11 14:25	2026-09-11 14:25	2026-09-11 14:25	XLE	XLE260914C00066000	call	66.0000	2026-09-14	0.1400	0.1400	0.1500	65.1500	26908.00	0.00	26908.00	1922	10	2385	669	3.56502242152466	0.183138952375814	0.183138952375814	false	false	false	true
68c6e753-3354-42c8-9b61-6754067ba580	2026-09-11 14:22	2026-09-11 14:22	2026-09-11 14:22	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.4100	1.3700	1.4100	65.1750	38493.00	38493.00	0.00	273	16	899	48754	0.0184395126553719	0.280141452943478	0.280141452943478	false	false	false	true
5c362b3f-54e5-4172-bbef-05a58e9426b8	2026-09-11 13:54	2026-09-11 13:54	2026-09-11 13:54	XLE	XLE261218P00065000	put	65.0000	2026-12-18	3.4000	3.3500	3.5000	65.0400	28220.00	7140.00	21080.00	83	5	227	1916	0.118475991649269	0.281892803904862	0.281892803904862	false	false	false	true
602bcfc5-7075-461c-ad6d-c3ea0c037bd3	2026-09-11 13:43	2026-09-11 13:43	2026-09-11 13:43	XLE	XLE261016C00060000	call	60.0000	2026-10-16	5.5500	5.4000	5.6000	65.1875	12765.00	12210.00	555.00	23	6	59	29406	0.0020063932530776	0.196779220801867	0.196779220801867	true	false	false	true
3f10ec65-02ee-4e0c-a710-52f171de3221	2026-09-11 13:31	2026-09-11 13:31	2026-09-11 13:31	XLE	XLE260918C00066000	call	66.0000	2026-09-18	0.5600	0.5500	0.5600	65.1250	52920.00	52920.00	0.00	945	32	1678	19735	0.0850266024828984	0.252465333410206	0.252465333410206	true	false	false	true
f1e730f7-ba32-4505-a1e0-86d9a6dcb5e0	2026-09-11 13:30	2026-09-11 13:30	2026-09-11 13:30	XLE	XLE260918P00063000	put	63.0000	2026-09-18	0.2300	0.2100	0.2300	65.1300	57270.00	57270.00	0.00	2490	33	2648	5680	0.466197183098592	0.26727469494343	0.26727469494343	true	false	false	true
7ebd0bfd-cd4a-4e13-ba8b-cfc378522ca6	2026-09-11 13:21	2026-09-11 13:21	2026-09-11 13:21	XLE	XLE260918P00062000	put	62.0000	2026-09-18	0.1100	0.1100	0.1200	65.1450	14311.00	0.00	14311.00	1301	26	1357	28585	0.0474724505859717	0.277853008252125	0.277853008252125	false	false	false	true
8fe83b12-8ef5-4997-8940-aca292d7fc15	2026-09-11 13:13	2026-09-11 13:13	2026-09-11 13:13	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.9000	1.9000	1.9200	64.9650	12920.00	0.00	12920.00	68	14	868	7878	0.11018024879411	0.262921078862274	0.262921078862274	false	false	false	true
f736cc5b-2072-4fa9-836c-dec15f98e511	2026-09-11 13:07	2026-09-11 13:07	2026-09-11 13:07	XLE	XLE270115P00060000	put	60.0000	2027-01-15	1.7800	1.7600	1.7900	65.0850	15130.00	15130.00	0.00	85	7	15908	6207	2.56291284034155	0.280353075315297	0.280353075315297	false	false	false	true
0fd26f4f-5452-4e37-aeef-ab21c3a47636	2026-09-11 13:01	2026-09-11 13:01	2026-09-11 13:01	XLE	XLE260925C00070000	call	70.0000	2026-09-25	0.1300	0.1200	0.1400	65.1250	14183.00	0.00	13156.00	1091	20	1110	496	2.23790322580645	0.260369480503399	0.260369480503399	false	false	false	true
e334d85c-195e-42b2-adcd-beb0d3cfe053	2026-09-11 12:44	2026-09-11 12:44	2026-09-11 12:44	XLE	XLE261002P00065000	put	65.0000	2026-10-02	1.6600	1.6000	1.7300	65.1450	248994.00	233224.00	15770.00	1500	32	1550	289	5.36332179930796	0.289740369785558	0.289740369785558	false	false	false	true
bc9f9c0f-f6c4-43ee-9cb9-31176b70a8a9	2026-09-11 12:40	2026-09-11 12:40	2026-09-11 12:40	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.9300	1.9300	1.9400	65.0700	15826.00	0.00	15826.00	82	18	661	7878	0.0839045443005839	0.2624036451798	0.2624036451798	false	false	false	true
cf8b52ad-6124-409a-9225-741621419717	2026-09-11 12:40	2026-09-11 12:40	2026-09-11 12:40	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.9300	1.9300	2.0000	65.0700	21037.00	0.00	21037.00	109	16	549	7878	0.0696877380045697	0.2624036451798	0.2624036451798	false	false	false	true
edcc0fab-ccd1-4aa2-ab19-acc067509e7e	2026-09-11 12:40	2026-09-11 12:40	2026-09-11 12:40	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.9300	1.9300	2.0000	65.1100	12738.00	0.00	12738.00	66	14	416	7878	0.0528052805280528	0.261284116892587	0.261284116892587	false	false	false	true
2d397a22-df6a-4b1d-94a0-07220edee064	2026-09-11 12:31	2026-09-11 12:30	2026-09-11 12:30	XLE	XLE260918C00066000	call	66.0000	2026-09-18	0.6200	0.6000	0.6200	65.3050	11160.00	11098.00	0.00	180	5	665	19735	0.0336964783379782	0.250009438523123	0.250009438523123	false	false	false	true
1b4bac07-9b9e-477e-bb1e-5968255c5ccb	2026-09-11 12:29	2026-09-11 12:29	2026-09-11 12:29	XLE	XLE260918C00057500	call	57.5000	2026-09-18	7.9000	7.7000	7.9500	65.3300	45055.00	45055.00	0.00	57	6	600	11901	0.0504159314343332	0.535559961498652	0.448496988392536	false	false	false	true
116e8355-ce66-4e4a-bbd7-7bba383832b2	2026-09-11 12:17	2026-09-11 12:17	2026-09-11 12:17	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.9300	1.9300	1.9900	65.1150	22388.00	0.00	22388.00	116	21	339	7878	0.043031226199543	0.261144102481921	0.261144102481921	false	false	false	true
e09d56f8-cc86-4a6c-b70d-796f86a488c8	2026-09-11 12:09	2026-09-11 12:09	2026-09-11 12:09	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.9300	1.9300	1.9900	65.1400	12545.00	0.00	12545.00	65	14	207	7878	0.0262757044935263	0.26044378363231	0.26044378363231	false	false	false	true
d72a283f-62d4-40e4-a66a-f8caa62ad6ac	2026-09-11 11:55	2026-09-11 11:54	2026-09-11 11:54	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.2200	2.1800	2.2200	65.2150	56610.00	56610.00	0.00	255	33	743	43793	0.0169661818098783	0.280036438974399	0.280036438974399	true	false	false	true
6c9af845-eec8-4df0-a513-7bc6f89313ff	2026-09-11 11:55	2026-09-11 11:54	2026-09-11 11:54	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.2200	2.1800	2.2200	65.2150	225996.00	225996.00	0.00	1018	5	1761	43793	0.0402119060123764	0.280036438974399	0.280036438974399	true	false	false	true
410abd56-1f11-41c0-8b5d-099351f2510a	2026-09-11 11:55	2026-09-11 11:55	2026-09-11 11:55	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.2200	2.1800	2.2300	65.2150	74960.00	74960.00	0.00	338	7	2412	43793	0.0550772954581783	0.280036438974399	0.280036438974399	true	false	false	true
b337dc4c-db5f-4d46-9a0b-d0be289feac7	2026-09-11 11:47	2026-09-11 11:47	2026-09-11 11:47	XLE	XLE260918P00066000	put	66.0000	2026-09-18	1.3700	1.3700	1.4200	65.1650	13700.00	0.00	13700.00	100	6	540	363	1.48760330578512	0.255305580344207	0.255305580344207	false	false	false	true
4566b61f-9afd-4704-8e61-9264b20a0c88	2026-09-11 11:18	2026-09-11 11:18	2026-09-11 11:18	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.1000	2.1000	2.1800	64.9100	42000.00	0.00	42000.00	200	7	471	22012	0.0213974195893149	0.242915088165195	0.242915088165195	false	false	false	true
add88e77-4e80-4572-92e0-432e23e90b1a	2026-09-11 11:01	2026-09-11 11:01	2026-09-11 11:01	XLE	XLE261016P00065000	put	65.0000	2026-10-16	2.1700	2.1400	2.1900	64.9950	417725.00	1519.00	416206.00	1925	7	3388	2424	1.3976897689769	0.285855584668208	0.285855584668208	false	false	false	true
82b144b2-4ab5-4b63-93b4-f8a53d126eff	2026-09-11 10:57	2026-09-11 10:57	2026-09-11 10:57	XLE	XLE270319P00059000	put	59.0000	2027-03-19	2.0900	2.0900	2.1600	64.8700	13794.00	0.00	13794.00	66	10	67	3983	0.0168214913381873	0.276645991576838	0.276645991576838	false	false	false	true
fdbd29e9-eb0b-4665-aa2b-e43a67377953	2026-09-11 10:54	2026-09-11 10:54	2026-09-11 10:54	XLE	XLE270617C00075000	call	75.0000	2027-06-17	2.7300	2.7300	2.8500	64.9050	16926.00	0.00	16926.00	62	7	120	2072	0.0579150579150579	0.241599171895298	0.241599171895298	false	false	false	true
784a9561-aac2-4504-b78b-01f0528bddfb	2026-09-11 10:54	2026-09-11 10:54	2026-09-11 10:54	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.5200	0.5200	0.5400	64.9050	94640.00	0.00	94640.00	1820	41	1890	7088	0.266647855530474	0.254058532151469	0.254058532151469	false	false	false	true
aeb5bc72-e1f8-4e32-b948-dac865a19972	2026-09-11 10:43	2026-09-11 10:43	2026-09-11 10:43	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.3000	2.2500	2.3000	64.9250	98662.00	96830.00	1832.00	429	33	487	43793	0.0111204987098395	0.278646853719129	0.277835540959024	true	false	false	true
790506e7-f2d5-4276-8ecb-5cabbbb2ea11	2026-09-11 10:39	2026-09-11 10:39	2026-09-11 10:39	XLE	XLE270617C00080000	call	80.0000	2027-06-17	1.8400	1.8200	1.8700	65.0850	20608.00	16376.00	4232.00	112	11	147	5647	0.0260315211616788	0.247919575545419	0.247919575545419	false	false	false	true
03815e49-bf68-4550-800b-813140c96c1f	2026-09-11 10:24	2026-09-11 10:23	2026-09-11 10:23	XLE	XLE261016C00059000	call	59.0000	2026-10-16	6.5000	6.3500	6.5000	65.2500	15599.00	15599.00	0.00	24	12	24	10479	0.00229029487546522	0.164828733072569	0.164828733072569	false	false	false	true
bcc157e0-84dd-4606-96df-16287cf29d4a	2026-09-11 10:11	2026-09-11 10:11	2026-09-11 10:11	XLE	XLE261023C00067500	call	67.5000	2026-10-23	1.4200	1.4200	1.4900	65.3550	19596.00	0.00	19596.00	138	12	142	1	142	0.247339779471871	0.247339779471871	true	false	false	true
db662eb5-2508-4b38-bce3-c0fac5a6f336	2026-09-11 10:11	2026-09-11 10:11	2026-09-11 10:11	XLE	XLE261120C00070000	call	70.0000	2026-11-20	1.4300	1.4300	1.4400	65.3900	21593.00	0.00	21593.00	151	16	159	18761	0.00847502798358296	0.258097370993222	0.258563281194298	true	false	false	true
4abbfe28-575c-430f-b95c-64167ef39d19	2026-09-11 10:03	2026-09-11 10:02	2026-09-11 10:02	XLE	XLE261120P00065000	put	65.0000	2026-11-20	2.6500	2.6000	2.6500	65.6901	73670.00	73670.00	0.00	278	17	282	4693	0.0600894949925421	0.282308822974381	0.282308822974381	true	false	false	true
5b289e62-8fba-4cb3-8ef6-233dd5cd7a42	2026-09-11 09:59	2026-09-11 09:59	2026-09-11 09:59	XLE	XLE260911C00065000	call	65.0000	2026-09-11	0.5900	0.5900	0.6400	65.0000	11826.00	0.00	11826.00	200	22	864	13305	0.0649379932356257	0.303450672102284	0.303450672102284	false	false	false	true
55e87dc2-43da-45de-88a6-7eade6a2f2f9	2026-09-11 09:48	2026-09-11 09:47	2026-09-11 09:47	XLE	XLE261016P00065000	put	65.0000	2026-10-16	2.0700	2.0500	2.1400	65.0000	22563.00	8280.00	14283.00	109	5	610	2424	0.251650165016502	0.283969451985465	0.283969451985465	false	false	false	true
88be0997-ad8f-4efe-8a2b-435b00d9447a	2026-09-11 09:43	2026-09-11 09:42	2026-09-11 09:42	XLE	XLE270115P00060000	put	60.0000	2027-01-15	1.7800	1.7800	1.8500	65.0500	431828.00	0.00	431828.00	2426	55	2426	6207	0.390849041404865	0.279419043388984	0.279626785564442	false	false	false	true
a3cda86f-7d1c-4ab9-a4dd-3e506b4aabc3	2026-09-11 09:34	2026-09-11 09:33	2026-09-11 09:33	XLE	XLE260911P00064500	put	64.5000	2026-09-11	0.1000	0.0600	0.1100	65.0000	65922.00	53565.00	8647.00	6636	104	6670	5054	1.3197467352592	0.447974911543173	0.469857927875461	true	false	false	true
ce8edce2-8524-4c40-820d-cd1c7f6e31f5	2026-09-11 09:31	2026-09-11 09:31	2026-09-11 09:31	XLE	XLE270115C00075000	call	75.0000	2027-01-15	1.1600	1.0600	1.2300	65.0000	36192.00	5800.00	19488.00	312	6	312	8694	0.0358868184955141	0.255586170480634	0.255586170480634	false	false	false	true
b201ae17-7497-4ef2-bcfd-2084664410b6	2026-09-11 09:30	2026-09-11 09:30	2026-09-11 09:30	XLE	XLE270617C00067500	call	67.5000	2027-06-17	5.1000	4.9500	5.1000	65.0000	10200.00	1020.00	0.00	20	18	20	23913	0.000836365157027558	0.229093664936706	0.229093664936706	false	false	false	true
d83c3cc2-15e3-4530-b342-ebd5198a29cc	2026-09-10 15:56	2026-09-10 15:56	2026-09-10 15:56	XLE	XLE260918P00065000	put	65.0000	2026-09-18	1.0700	0.9900	1.0700	64.9600	36487.00	36487.00	0.00	341	7	1470	10441	0.140791111962456	0.280792633222378	0.280792633222378	true	false	false	true
ca1142b4-660f-4e8b-a395-8ecb894ab246	2026-09-10 15:52	2026-09-10 15:52	2026-09-10 15:52	XLE	XLE270115C00065000	call	65.0000	2027-01-15	4.1500	4.1500	4.2000	65.0450	41501.00	0.00	41501.00	100	10	520	32878	0.0158160472048178	0.24158524617866	0.240921961981834	false	false	false	true
80fa9b58-2246-4496-8e05-e26becacf45e	2026-09-10 15:42	2026-09-10 15:42	2026-09-10 15:42	XLE	XLE260911P00065000	put	65.0000	2026-09-11	0.4100	0.3900	0.4100	65.0200	12300.00	12300.00	0.00	300	21	2802	1691	1.65700768775872	0.311808724558077	0.311808724558077	false	false	false	true
1b595f2e-3fd3-492e-8faf-514f141c6e91	2026-09-10 15:31	2026-09-10 15:31	2026-09-10 15:31	XLE	XLE261120P00060000	put	60.0000	2026-11-20	1.1100	1.0900	1.1300	65.0600	31857.00	6327.00	25530.00	287	11	524	7707	0.0679901388348255	0.28539393320196	0.28539393320196	false	false	false	true
def09af7-e918-49fa-9a34-2984c884d826	2026-09-10 15:31	2026-09-10 15:31	2026-09-10 15:31	XLE	XLE260916P00064000	put	64.0000	2026-09-16	0.5000	0.4600	0.5000	65.0550	12500.00	12500.00	0.00	250	13	294	164	1.79268292682927	0.287546837801548	0.287546837801548	false	false	false	true
cc4b4317-2772-474b-a6eb-5bee32d22e32	2026-09-10 15:30	2026-09-10 15:30	2026-09-10 15:30	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.1200	1.1200	1.1400	65.0350	44688.00	0.00	44688.00	399	24	4889	48089	0.10166566158581	0.280023074902637	0.280023074902637	false	false	false	true
a965b3c5-2d92-487b-92b9-544a1f2f074c	2026-09-10 15:30	2026-09-10 15:30	2026-09-10 15:30	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.1200	1.1200	1.1500	65.0300	23632.00	0.00	23632.00	211	14	4150	48089	0.0862983218615484	0.280702373198009	0.280702373198009	false	false	false	true