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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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

b2ebef5a-a6b4-49f1-a391-f2a4b9cfb44a	2026-09-16 10:24	2026-09-16 10:24	2026-09-16 10:24	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4600	2.5500	64.0000	16830.00	16830.00	0.00	66	13	114	15647	0.00728574167572059	0.281310137069317	0.281310137069317	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	43018974758.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
756120c9-d866-48ad-8470-425f2089a4ae	2026-09-16 10:23	2026-09-16 10:22	2026-09-16 10:22	XLE	XLE260925P00063000	put	63.0000	2026-09-25	0.6500	0.6100	0.6900	64.0000	12675.00	12610.00	0.00	195	6	3553	1570	2.26305732484076	0.319540618983394	0.319540618983394	true	false	false	true
e8746b18-1a63-4403-acbd-22c3ac43fcb5	2026-09-16 10:18	2026-09-16 10:18	2026-09-16 10:18	XLE	XLE260918C00065000	call	65.0000	2026-09-18	0.4400	0.4400	0.4700	64.0000	11528.00	0.00	11528.00	262	10	849	47643	0.0178200365216296	0.319695545770611	0.319695545770611	false	false	false	true
8001d0d4-3006-4ce5-8956-cd239018ddb1	2026-09-16 10:16	2026-09-16 10:16	2026-09-16 10:16	XLE	XLE260918P00064000	put	64.0000	2026-09-18	0.3400	0.3300	0.3400	64.0000	26588.00	26588.00	0.00	782	13	2694	16718	0.161143677473382	0.319459387729415	0.319459387729415	false	false	false	true
91820537-617c-4d8f-a708-61908e19c208	2026-09-16 10:16	2026-09-16 10:16	2026-09-16 10:16	XLE	XLE260925P00063000	put	63.0000	2026-09-25	0.6000	0.5700	0.6000	64.0000	201000.00	201000.00	0.00	3350	44	3355	1570	2.13694267515924	0.322994019094698	0.322994019094698	false	false	false	true
c62a5f24-226b-46bc-a4f3-575116ee912e	2026-09-16 10:01	2026-09-16 10:01	2026-09-16 10:01	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.5300	0.5300	0.5400	64.7100	56763.00	0.00	56763.00	1071	5	1405	37787	0.0371820996639056	0.301862327673572	0.301862327673572	true	false	false	true
b0c2cc8f-1e1a-4620-b2ca-9c63823b44fd	2026-09-16 09:59	2026-09-16 09:59	2026-09-16 09:59	XLE	XLE261002C00066500	call	66.5000	2026-10-02	0.7100	0.7000	0.7400	64.7200	10863.00	71.00	10650.00	153	13	158	666	0.237237237237237	0.253274409821695	0.253274409821695	true	false	false	true
e7e8e413-0de2-4d9d-bcd1-ec979005e3b3	2026-09-16 09:43	2026-09-16 09:43	2026-09-16 09:43	XLE	XLE261218C00067500	call	67.5000	2026-12-18	2.4400	2.4400	2.5400	64.4950	61255.00	245.00	61010.00	251	21	254	6934	0.0366310931641188	0.262323950722664	0.263108936305276	true	false	false	true
80b4eadd-a788-4f21-bf53-cb5d600bad06	2026-09-16 09:43	2026-09-16 09:43	2026-09-16 09:43	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.4300	1.3800	1.4500	64.5050	57057.00	56914.00	143.00	399	8	823	44031	0.0186913765301719	0.299335963144436	0.299335963144436	false	false	false	true
0940f99e-975f-4df7-a49c-9ef63835f99b	2026-09-16 09:43	2026-09-16 09:43	2026-09-16 09:43	XLE	XLE260930P00063000	put	63.0000	2026-09-30	0.8600	0.7700	0.8600	64.5100	20382.00	20382.00	0.00	237	27	240	1	240	0.307529250082451	0.307529250082451	true	false	false	true
afb63129-4de4-4ccd-8616-98fd6701ee14	2026-09-16 09:43	2026-09-16 09:43	2026-09-16 09:43	XLE	XLE260930P00061000	put	61.0000	2026-09-30	0.3700	0.3600	0.3800	64.5150	146631.00	120250.00	15651.00	3963	40	4799	1	4799	0.316371878527119	0.316371878527119	false	false	false	true
a718e394-ab9f-4d38-8c45-cc8ab4586063	2026-09-16 09:41	2026-09-16 09:41	2026-09-16 09:41	XLE	XLE261218C00065000	call	65.0000	2026-12-18	3.5500	3.5000	3.5500	64.6600	306010.00	306010.00	0.00	862	16	865	38731	0.0223335312798533	0.259857283700591	0.259857283700591	false	false	false	true
9de2f8bf-cc06-46a9-8ce5-4ed02ed9aabf	2026-09-16 09:38	2026-09-16 09:38	2026-09-16 09:38	XLE	XLE260930P00061000	put	61.0000	2026-09-30	0.3000	0.2900	0.3000	64.7150	16200.00	16200.00	0.00	540	9	673	1	673	0.303778736023924	0.303778736023924	false	false	false	true
c1f3e0d3-13b9-4a2c-94af-e088ddccf874	2026-09-16 09:38	2026-09-16 09:38	2026-09-16 09:38	XLE	XLE260921C00068000	call	68.0000	2026-09-21	0.0600	0.0600	0.0700	64.7950	12372.00	0.00	12372.00	2062	17	2062	462	4.46320346320346	0.270036139474643	0.270036139474643	false	false	false	true
9d1a594a-33b0-438b-8067-cb4e24f3faad	2026-09-16 09:36	2026-09-16 09:36	2026-09-16 09:36	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.3100	0.3100	0.3200	65.0000	11284.00	0.00	11284.00	364	29	393	21744	0.0180739514348786	0.329204483057589	0.329204483057589	true	false	false	true
0eb4c331-df80-4d62-ad58-285783945175	2026-09-16 09:36	2026-09-16 09:36	2026-09-16 09:36	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.3100	0.3100	0.3200	65.0000	75175.00	0.00	75175.00	2425	12	2818	21744	0.129598969830758	0.329204483057589	0.329204483057589	true	false	false	true
c858ee2a-e3bb-48b1-a101-61c03704220c	2026-09-16 09:35	2026-09-16 09:35	2026-09-16 09:35	XLE	XLE270115C00065000	call	65.0000	2027-01-15	4.0500	3.9500	4.1000	64.9950	30408.00	10935.00	18663.00	75	7	116	33197	0.0034942916528602	0.242630114652692	0.242924561726832	false	false	false	true
fd9806fd-eacc-4708-b4ec-3a8bb31b9769	2026-09-16 09:32	2026-09-16 09:32	2026-09-16 09:32	XLE	XLE261016C00066000	call	66.0000	2026-10-16	1.4400	1.4400	1.5000	64.8200	32832.00	0.00	32832.00	228	22	270	4862	0.0555327025915261	0.249360951548375	0.252331030837395	true	false	false	true
ce86d457-ba7e-45c8-9915-92e9698dd5a3	2026-09-16 09:32	2026-09-16 09:32	2026-09-16 09:32	XLE	XLE260918P00064000	put	64.0000	2026-09-18	0.3200	0.2900	0.3500	64.8300	16000.00	2848.00	13152.00	500	8	970	16718	0.0580212944132073	0.345729037227288	0.345729037227288	false	false	false	true
aea3665d-2a34-4be5-9467-6f6d78e537d7	2026-09-16 09:31	2026-09-16 09:31	2026-09-16 09:31	XLE	XLE260918P00064500	put	64.5000	2026-09-18	0.4700	0.4600	0.5600	64.9400	12419.00	1833.00	10586.00	263	20	269	2710	0.0992619926199262	0.350003502613861	0.352028666836524	true	false	false	true
d1d9084f-ebf4-4372-8c6b-778be3d9a4fc	2026-09-16 09:31	2026-09-16 09:31	2026-09-16 09:31	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.7200	0.6900	0.8100	64.8950	12817.00	145.00	12672.00	178	10	355	19544	0.0181641424478101	0.351211130996901	0.351211130996901	false	false	false	true
9b7f61da-7af3-4539-a5e5-1ba7c34ec414	2026-09-16 09:31	2026-09-16 09:31	2026-09-16 09:31	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3000	1.3000	1.3200	64.8400	22230.00	0.00	22230.00	171	6	352	44031	0.00799436760464218	0.297451855495675	0.297451855495675	true	false	false	true
31503bfa-166c-4135-8d72-9c857d12c44c	2026-09-15 16:00	2026-09-15 16:00	2026-09-15 16:00	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.2600	1.2800	1.3400	65.0000	159643.00	0.00	159643.00	1265	14	5447	49728	0.109535875160875	0.297705821282808	0.282944662465492	true	false	false	true
dd4e503b-d467-40c3-9642-c314d20cbb6f	2026-09-15 15:58	2026-09-15 15:58	2026-09-15 15:58	XLE	XLE261016P00066000	put	66.0000	2026-10-16	2.2100	2.2000	2.3100	65.0000	42211.00	0.00	42211.00	191	5	844	2342	0.360375747224594	0.297669687929108	0.297669687929108	false	false	false	true
646c80fc-e559-4915-a246-cceafca81790	2026-09-15 15:58	2026-09-15 15:58	2026-09-15 15:58	XLE	XLE280121C00075000	call	75.0000	2028-01-21	5.1000	4.9000	5.1500	65.0000	23969.00	23969.00	0.00	47	11	102	4360	0.023394495412844	0.226547719027214	0.226547719027214	false	false	false	true
cf92da15-37fe-41c8-b0d1-31dc77693173	2026-09-15 15:58	2026-09-15 15:57	2026-09-15 15:57	XLE	XLE270617P00070000	put	70.0000	2027-06-17	7.7800	7.6000	8.0000	65.0000	77778.00	0.00	77778.00	100	5	100	525	0.19047619047619	0.29545316574291	0.295891448300104	false	false	false	true
c283af22-cce2-47e7-acd4-5f84e66bb836	2026-09-15 15:56	2026-09-15 15:56	2026-09-15 15:56	XLE	XLE260930C00065000	call	65.0000	2026-09-30	1.7500	1.6600	1.7500	65.0000	11550.00	11550.00	0.00	66	5	503	7353	0.0684074527403781	0.229469102023826	0.229469102023826	false	false	false	true
5b5f7c1d-2093-484f-8b2d-90fab03e4949	2026-09-15 15:42	2026-09-15 15:42	2026-09-15 15:42	XLE	XLE261002C00069000	call	69.0000	2026-10-02	0.4800	0.4400	0.4900	65.7850	12999.00	12999.00	0.00	270	6	801	179	4.47486033519553	0.271891499256862	0.271891499256862	false	false	false	true
b262fd37-9d18-4c7d-bd21-709721e1acc8	2026-09-15 15:38	2026-09-15 15:38	2026-09-15 15:38	XLE	XLE260925C00070000	call	70.0000	2026-09-25	0.1400	0.1400	0.1500	65.8350	20566.00	0.00	20566.00	1469	28	3791	2873	1.31952662721893	0.278410595066375	0.278410595066375	false	false	false	true
1b9ab57e-4457-44f8-a8e6-17743bc3837c	2026-09-15 15:25	2026-09-15 15:24	2026-09-15 15:24	XLE	XLE270617P00067500	put	67.5000	2027-06-17	6.2500	6.2500	6.4000	65.8100	88125.00	0.00	88125.00	141	14	214	271	0.789667896678967	0.286831455406788	0.286831455406788	false	false	false	true
26da9360-49ac-4b2b-b56b-1b5d13b19609	2026-09-15 15:24	2026-09-15 15:24	2026-09-15 15:24	XLE	XLE270617P00067500	put	67.5000	2027-06-17	6.3000	6.3000	6.4000	65.7950	11340.00	0.00	11340.00	18	10	61	271	0.225092250922509	0.288760049328911	0.288760049328911	false	false	false	true
edf63dc2-29de-44c2-b3a3-076e03e12a13	2026-09-15 14:33	2026-09-15 14:33	2026-09-15 14:33	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6700	0.6700	0.6900	65.8150	17688.00	0.00	17688.00	264	12	17233	11189	1.54017338457414	0.262997946518063	0.262997946518063	false	false	false	true
9f60fceb-6c90-4ed5-aef2-01b2060ae082	2026-09-15 14:33	2026-09-15 14:33	2026-09-15 14:33	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6700	0.6700	0.6900	65.8150	15812.00	0.00	15812.00	236	19	17469	11189	1.5612655286442	0.262997946518063	0.262997946518063	false	false	false	true
066ef1af-9143-4f54-b00c-05cbb9017626	2026-09-15 14:29	2026-09-15 14:29	2026-09-15 14:29	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.7000	0.6800	0.7000	65.8550	10500.00	10500.00	0.00	150	13	16949	11189	1.51479131289659	0.266443455317866	0.266443455317866	false	false	false	true
fbf9a85e-16ed-4fd4-ab0b-61c49a302271	2026-09-15 14:25	2026-09-15 14:25	2026-09-15 14:25	XLE	XLE261016P00059000	put	59.0000	2026-10-16	0.2900	0.2700	0.2900	65.8958	14500.00	14500.00	0.00	500	5	1074	14544	0.0738448844884489	0.31382522065969	0.31382522065969	false	false	false	true
e8af87c6-d383-4acf-98be-fdd333457dda	2026-09-15 14:18	2026-09-15 14:18	2026-09-15 14:18	XLE	XLE270319C00070000	call	70.0000	2027-03-19	3.6000	3.5500	3.6000	66.0000	35999.00	35999.00	0.00	100	5	122	751	0.162450066577896	0.248120568003702	0.247583266126891	false	false	false	true
08b426e7-d140-48c5-a770-4daed06da1f7	2026-09-15 14:18	2026-09-15 14:18	2026-09-15 14:18	XLE	XLE261016C00067000	call	67.0000	2026-10-16	1.6100	1.6100	1.6200	66.0000	16261.00	0.00	16261.00	101	5	1261	6140	0.205374592833876	0.255412516207934	0.255412516207934	true	false	false	true
4e40b242-e045-4827-b379-bae4623c503b	2026-09-15 14:08	2026-09-15 14:08	2026-09-15 14:08	XLE	XLE260918P00064000	put	64.0000	2026-09-18	0.1600	0.1500	0.1600	66.0200	12000.00	12000.00	0.00	750	21	2380	15590	0.152661962796665	0.339242579776517	0.339242579776517	false	false	false	true
ac105efd-b684-45bd-96c2-c0e461ac196a	2026-09-15 13:51	2026-09-15 13:51	2026-09-15 13:51	XLE	XLE261120C00070000	call	70.0000	2026-11-20	1.6400	1.6200	1.6400	66.0550	23616.00	23616.00	0.00	144	20	726	22245	0.0326365475387728	0.265691324421656	0.265691324421656	false	false	false	true
994fb8e5-5040-4d5e-bf50-2d6e98ef4672	2026-09-15 13:45	2026-09-15 13:45	2026-09-15 13:45	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.7100	0.6900	0.7100	65.9907	239838.00	239838.00	0.00	3378	15	16685	11189	1.4911967110555	0.262615586009414	0.262615586009414	false	false	false	true
139a7c7c-cda4-40c9-8d82-91b71615a1e6	2026-09-15 13:42	2026-09-15 13:41	2026-09-15 13:41	XLE	XLE261002C00063000	call	63.0000	2026-10-02	3.4000	3.2000	3.4000	65.9989	17336.00	17336.00	0.00	51	7	51	387	0.131782945736434	0.231642514726355	0.231642514726355	false	false	false	true
c24a379a-025e-4158-998b-95c9b7684211	2026-09-15 13:39	2026-09-15 13:39	2026-09-15 13:39	XLE	XLE261120P00065000	put	65.0000	2026-11-20	2.5400	2.5300	2.5900	65.9800	76186.00	0.00	76186.00	300	8	699	5102	0.137005096040768	0.28999476296585	0.290914965527272	false	false	false	true
01c828fe-ee08-4970-9410-7620182ccfe4	2026-09-15 13:35	2026-09-15 13:35	2026-09-15 13:35	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.4000	0.4000	0.4100	65.9450	86240.00	0.00	86240.00	2156	12	12115	26812	0.451849917947188	0.30961710393166	0.30961710393166	true	false	false	true
86a3454a-396c-4955-a205-1919d1bb2054	2026-09-15 13:34	2026-09-15 13:34	2026-09-15 13:34	XLE	XLE261016P00062000	put	62.0000	2026-10-16	0.7500	0.7400	0.7500	65.9695	73950.00	73950.00	0.00	986	40	5920	19103	0.309898968748364	0.303081824986276	0.303081824986276	false	false	false	true
9dbffd48-3e69-474a-a82c-b1d7fbd725f9	2026-09-15 13:29	2026-09-15 13:29	2026-09-15 13:29	XLE	XLE260925P00063000	put	63.0000	2026-09-25	0.3900	0.3800	0.3900	65.9400	17394.00	17394.00	0.00	446	8	778	817	0.952264381884945	0.332179975788596	0.332179975788596	false	false	false	true
91484ba4-5e7b-4b08-8c1b-5aeac4bf7bf7	2026-09-15 13:25	2026-09-15 13:25	2026-09-15 13:25	XLE	XLE261120C00061000	call	61.0000	2026-11-20	6.2000	5.5000	6.2500	65.9450	16120.00	16120.00	0.00	26	7	35	7	5	0.250124227307588	0.250124227307588	false	false	false	true
2e6c60a1-2a02-40c9-8027-d5740fa242de	2026-09-15 13:21	2026-09-15 13:21	2026-09-15 13:21	XLE	XLE261218C00070000	call	70.0000	2026-12-18	2.1800	2.1500	2.1800	65.9000	25942.00	25942.00	0.00	119	6	257	7485	0.0343353373413494	0.264168299821663	0.264168299821663	false	false	false	true
689cbba4-81ab-42df-b3b1-9b9bb2bed76c	2026-09-15 13:20	2026-09-15 13:20	2026-09-15 13:20	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6800	0.6800	0.6900	65.8850	68000.00	0.00	68000.00	1000	20	13221	11189	1.18160693538297	0.261884992380119	0.261884992380119	false	false	false	true
7d0df44b-d7ac-4423-a8e9-9b1a6a32cc53	2026-09-15 13:20	2026-09-15 13:20	2026-09-15 13:20	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.0000	1.0000	1.0200	65.8750	50072.00	0.00	43305.00	500	11	7499	38897	0.192791217831709	0.297258205860964	0.295695420893109	false	false	false	true
d168ced5-d798-44af-b680-4fd00c87e9b0	2026-09-15 13:16	2026-09-15 13:16	2026-09-15 13:16	XLE	XLE260925P00063500	put	63.5000	2026-09-25	0.5000	0.4900	0.5000	65.8950	11700.00	11700.00	0.00	234	15	421	2239	0.188030370701206	0.328041069470949	0.328041069470949	false	false	false	true