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: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	expirydate	price

2d3903f2-7688-4170-9b7f-e61d2c391a71	2026-09-21 12:19	2026-09-21 12:19	2026-09-21 12:19	XLE	XLE261016P00058000	put	58.0000	2026-10-16	0.3200	0.3100	0.3200	62.0000	30368.00	30368.00	0.00	949	40	5672	12693	0.446860474277161	0.280726885590774	0.280726885590774	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	41312140321.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T16:21:14.001426Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
3d9792c8-7e40-4e63-825d-2aeeffb80173	2026-09-21 12:16	2026-09-21 12:16	2026-09-21 12:16	XLE	XLE261016C00064000	call	64.0000	2026-10-16	1.1900	1.1700	1.1900	62.6250	61730.00	61730.00	0.00	520	19	1577	3746	0.42098238120662	0.261288477058135	0.261288477058135	true	false	false	true	false
d70f3e10-b93d-475f-9ddd-b93a525cb216	2026-09-21 12:12	2026-09-21 12:12	2026-09-21 12:12	XLE	XLE280121C00057500	call	57.5000	2028-01-21	10.7000	10.6500	10.9000	62.5500	71691.00	0.00	70621.00	67	11	133	1223	0.10874897792314	0.199855230145117	0.199855230145117	false	false	false	true	false
8e6bcbdb-a2e5-4200-868f-7c86562d06e3	2026-09-21 12:12	2026-09-21 12:12	2026-09-21 12:12	XLE	XLE280121P00057500	put	57.5000	2028-01-21	3.9900	3.8000	4.0000	62.5500	25560.00	25560.00	0.00	64	8	64	1126	0.0568383658969805	0.281320892205546	0.281320892205546	false	false	false	true	false
791dcc58-9d7b-40ef-a7bf-6c40cfe7d65c	2026-09-21 12:11	2026-09-21 12:11	2026-09-21 12:11	XLE	XLE260925C00063500	call	63.5000	2026-09-25	0.4100	0.4000	0.4100	62.5700	12669.00	12669.00	0.00	309	8	673	497	1.35412474849095	0.2961864705155	0.2961864705155	true	false	false	true	false
84737558-9bc5-4441-9b4a-22de7c2d33f5	2026-09-21 12:11	2026-09-21 12:11	2026-09-21 12:11	XLE	XLE260923P00062000	put	62.0000	2026-09-23	0.3200	0.3000	0.3200	62.5950	96000.00	96000.00	0.00	3000	29	8731	6594	1.32408249924173	0.311848913822321	0.311848913822321	true	false	false	true	false
3737f028-4d34-4279-b21c-95eda9ed1c1b	2026-09-21 12:06	2026-09-21 12:06	2026-09-21 12:06	XLE	XLE261002C00065000	call	65.0000	2026-10-02	0.4000	0.4000	0.4100	62.7500	64920.00	0.00	64920.00	1623	16	6439	362	17.7872928176796	0.267391714768482	0.267391714768482	false	false	false	true	false
ecf6331b-c669-4964-8c59-1e6f904a092a	2026-09-21 12:04	2026-09-21 12:04	2026-09-21 12:04	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.8200	1.8100	1.8200	62.7300	225862.00	225862.00	0.00	1241	17	2590	51079	0.0507057694943127	0.268839961664293	0.268839961664293	true	false	false	true	false
ba22b8c4-730c-484f-a316-f3eba7f0d25d	2026-09-21 12:01	2026-09-21 12:01	2026-09-21 12:01	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.8000	1.7600	1.8000	62.8050	189180.00	189180.00	0.00	1051	13	1340	51079	0.0262338730202236	0.269168167305068	0.269168167305068	true	false	false	true	false
18d0026f-19db-4e41-a0d5-537e9f010358	2026-09-21 12:01	2026-09-21 12:01	2026-09-21 12:01	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.8000	1.7600	1.8000	62.8050	35820.00	35820.00	0.00	199	34	289	51079	0.00565790246480941	0.269168167305068	0.269168167305068	true	false	false	true	false
a3332f4a-0452-496b-8eaa-475c398ff729	2026-09-21 11:55	2026-09-21 11:55	2026-09-21 11:55	XLE	XLE281215P00046000	put	46.0000	2028-12-15	1.9500	1.8700	1.9500	62.8200	11700.00	11700.00	0.00	60	13	128	1500	0.0853333333333333	0.290434741540824	0.290434741540824	false	false	false	true	false
c901ed5f-3539-42f8-87d6-19ebfb26ab1a	2026-09-21 11:55	2026-09-21 11:55	2026-09-21 11:55	XLE	XLE270115P00062500	put	62.5000	2027-01-15	3.3000	3.2500	3.3000	62.8250	14850.00	14850.00	0.00	45	8	142	2827	0.050229925716307	0.275517658532876	0.275517658532876	false	false	false	true	false
8b5c3747-d1fb-4d93-80c8-f7949f4c57aa	2026-09-21 11:54	2026-09-21 11:54	2026-09-21 11:54	XLE	XLE281215P00046000	put	46.0000	2028-12-15	1.9400	1.8700	1.9400	62.8250	13192.00	13192.00	0.00	68	10	68	1500	0.0453333333333333	0.289930901944058	0.289930901944058	false	false	false	true	false
25a5cfc3-82c1-471e-9b8b-c1d938f01eaf	2026-09-21 11:50	2026-09-21 11:50	2026-09-21 11:50	XLE	XLE261120P00063000	put	63.0000	2026-11-20	2.5700	2.5600	2.6000	62.8100	11308.00	0.00	11308.00	44	5	593	421	1.40855106888361	0.264903981144961	0.264903981144961	true	false	false	true	false
f1f69f75-2f39-4534-9747-387103f6a726	2026-09-21 11:47	2026-09-21 11:47	2026-09-21 11:47	XLE	XLE261016C00066500	call	66.5000	2026-10-16	0.5200	0.5100	0.5300	62.7600	217724.00	0.00	183248.00	4187	14	4753	0	0	0.26048719133862	0.26048719133862	false	false	false	true	false
dc8fe2a9-6f36-4ff9-994a-38a7d85fa8c5	2026-09-21 11:44	2026-09-21 11:44	2026-09-21 11:44	XLE	XLE270115C00065000	call	65.0000	2027-01-15	2.9500	2.9000	2.9500	62.7800	42775.00	42775.00	0.00	145	6	798	32845	0.0242959354544071	0.251399131003204	0.251399131003204	false	false	false	true	false
257c3eae-18d8-442d-90d0-0936173e2ebb	2026-09-21 11:42	2026-09-21 11:42	2026-09-21 11:42	XLE	XLE270115P00062500	put	62.5000	2027-01-15	3.3500	3.3000	3.3500	62.7100	15075.00	15075.00	0.00	45	10	97	2827	0.0343119915104351	0.27560789588031	0.27560789588031	false	false	false	true	false
4a3beb4f-efc4-42b7-9eba-a58d59581d87	2026-09-21 11:37	2026-09-21 11:37	2026-09-21 11:37	XLE	XLE261016P00058000	put	58.0000	2026-10-16	0.3200	0.3100	0.3200	62.0000	32000.00	32000.00	0.00	1000	40	4702	12693	0.370440400220594	0.28165338733027	0.28165338733027	true	false	false	true	false
f68f973b-9dcd-4363-a45e-316886c63e40	2026-09-21 11:31	2026-09-21 11:31	2026-09-21 11:31	XLE	XLE261016P00058000	put	58.0000	2026-10-16	0.3200	0.3000	0.3200	62.6300	31680.00	31680.00	0.00	990	34	3692	12693	0.290868982903963	0.282427664564214	0.282427664564214	true	false	false	true	false
99db43ac-dbf1-46e1-9479-921723e282f3	2026-09-21 11:25	2026-09-21 11:25	2026-09-21 11:25	XLE	XLE261016P00058000	put	58.0000	2026-10-16	0.3100	0.2900	0.3100	62.7300	27466.00	27466.00	0.00	886	34	2588	12693	0.20389190892618	0.283314992406026	0.283314992406026	true	false	false	true	false
725aedaf-5145-4583-a6de-a1541b940a83	2026-09-21 11:23	2026-09-21 11:23	2026-09-21 11:23	XLE	XLE261002P00065000	put	65.0000	2026-10-02	2.5900	2.5900	2.6200	62.7050	323491.00	0.00	323491.00	1249	28	1616	1853	0.87209929843497	0.262381282283704	0.262381282283704	false	false	false	true	false
47edc4b9-ae12-44d6-84bc-9886723e3900	2026-09-21 11:23	2026-09-21 11:23	2026-09-21 11:23	XLE	XLE261002P00065000	put	65.0000	2026-10-02	2.6000	2.5700	2.6000	62.6950	52780.00	52780.00	0.00	203	9	319	1853	0.172153264975715	0.263076368029563	0.263076368029563	true	false	false	true	false
d30440fd-80a3-4543-89df-fd8cb14a52a1	2026-09-21 11:23	2026-09-21 11:23	2026-09-21 11:23	XLE	XLE261016P00058000	put	58.0000	2026-10-16	0.3100	0.2900	0.3100	62.7050	30969.00	30969.00	0.00	999	40	1701	12693	0.134010872134247	0.282380752355516	0.282380752355516	true	false	false	true	false
f879cc51-08cc-4ad7-9680-f013771c08b6	2026-09-21 11:19	2026-09-21 11:19	2026-09-21 11:19	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.8900	2.8300	2.8900	62.6300	13005.00	13005.00	0.00	45	6	84	60583	0.00138652757374181	0.266829573303972	0.266829573303972	false	false	false	true	false
3943ab1c-f050-4845-957b-ee1056b7ee1b	2026-09-21 11:17	2026-09-21 11:17	2026-09-21 11:17	XLE	XLE261002C00065000	call	65.0000	2026-10-02	0.3800	0.3800	0.3900	62.6750	167466.00	0.00	167466.00	4407	19	4811	362	13.2900552486188	0.266671720362654	0.266671720362654	false	false	false	true	false
ba953b5e-4592-4679-a593-a6252c2e1319	2026-09-21 11:16	2026-09-21 11:16	2026-09-21 11:16	XLE	XLE260923P00062000	put	62.0000	2026-09-23	0.2600	0.2600	0.2700	62.7150	27300.00	0.00	27300.00	1050	20	4537	6594	0.68804974218987	0.298212753123741	0.298212753123741	false	false	false	true	false
1ff4c3c8-3909-473d-bf2c-115c2e688557	2026-09-21 11:16	2026-09-21 11:16	2026-09-21 11:16	XLE	XLE260923P00062000	put	62.0000	2026-09-23	0.2600	0.2600	0.2700	62.7063	35516.00	0.00	35516.00	1366	54	3487	6594	0.528814073400061	0.296610087231271	0.296610087231271	false	false	false	true	false
d49a5445-b2fb-48fb-8ae4-ee3f80fb4c22	2026-09-21 11:13	2026-09-21 11:12	2026-09-21 11:12	XLE	XLE261016P00060500	put	60.5000	2026-10-16	0.7800	0.7700	0.7800	62.7050	70044.00	70044.00	0.00	898	28	3047	0	0	0.266283780121969	0.266283780121969	false	false	false	true	false
6bbcb4c2-ed41-42fa-9416-5a2334106753	2026-09-21 11:12	2026-09-21 11:11	2026-09-21 11:11	XLE	XLE260930C00065000	call	65.0000	2026-09-30	0.2700	0.2700	0.2800	62.0000	156924.00	0.00	156924.00	5812	23	5927	7379	0.803225369291232	0.257741336167126	0.257741336167126	false	false	false	true	false
08969441-3bd8-4536-8a84-f74f137d16d6	2026-09-21 11:11	2026-09-21 11:11	2026-09-21 11:11	XLE	XLE261016P00060500	put	60.5000	2026-10-16	0.7800	0.7700	0.7800	62.0000	57954.00	57954.00	0.00	743	16	1810	0	0	0.264765405494887	0.264765405494887	false	false	false	true	false
961c51ab-b18d-485c-80a3-fd10f3c0ae69	2026-09-21 11:11	2026-09-21 11:11	2026-09-21 11:11	XLE	XLE261016P00060500	put	60.5000	2026-10-16	0.7800	0.7700	0.7800	62.0000	37596.00	37596.00	0.00	482	19	1067	0	0	0.264765405494887	0.264765405494887	false	false	false	true	false
e8dd1569-1a47-4036-9c31-2be4ec97e203	2026-09-21 11:11	2026-09-21 11:11	2026-09-21 11:11	XLE	XLE260923P00062000	put	62.0000	2026-09-23	0.2900	0.2900	0.3000	62.0000	32451.00	0.00	32451.00	1119	39	2104	6594	0.319077949651198	0.307360673523922	0.307360673523922	false	false	false	true	false
a06023a0-d878-4d2b-8b40-31d9a75ace0c	2026-09-21 11:11	2026-09-21 11:10	2026-09-21 11:10	XLE	XLE261016P00060500	put	60.5000	2026-10-16	0.7800	0.7700	0.7800	62.0000	36816.00	36816.00	0.00	472	16	585	0	0	0.264258294264958	0.264258294264958	false	false	false	true	false
06cb3943-a9f9-4628-8ccd-06808db7078b	2026-09-21 11:08	2026-09-21 11:08	2026-09-21 11:08	XLE	XLE261120C00064000	call	64.0000	2026-11-20	2.3000	2.3000	2.3200	62.6900	13800.00	0.00	13800.00	60	7	331	128	2.5859375	0.266254124554303	0.266254124554303	false	false	false	true	false
4fa94ff9-27b6-4f83-b851-e0a967ab1a66	2026-09-21 10:56	2026-09-21 10:56	2026-09-21 10:56	XLE	XLE270319P00067000	put	67.0000	2027-03-19	6.6000	6.5000	6.7000	62.6500	50160.00	23100.00	660.00	76	7	601	1404	0.428062678062678	0.278075700280681	0.278075700280681	false	false	false	true	false
54e3c5ec-55c3-466b-b0f8-c08a112f3ef7	2026-09-21 10:41	2026-09-21 10:41	2026-09-21 10:41	XLE	XLE260925P00063500	put	63.5000	2026-09-25	1.1200	1.0700	1.1200	62.8150	17920.00	17920.00	0.00	160	11	365	4258	0.0857209957726632	0.282772770826782	0.282772770826782	true	false	false	true	false
2fdbd72d-b24a-4467-9282-86884232c606	2026-09-21 10:38	2026-09-21 10:38	2026-09-21 10:38	XLE	XLE261218P00055000	put	55.0000	2026-12-18	0.6100	0.6100	0.6300	62.8050	12200.00	0.00	12200.00	200	15	202	40979	0.00492935405939628	0.278185093927535	0.278185093927535	false	false	false	true	false
3a5195b0-84e7-44a3-96b6-5a313d5fa39d	2026-09-21 10:35	2026-09-21 10:35	2026-09-21 10:35	XLE	XLE260925P00062500	put	62.5000	2026-09-25	0.5800	0.5500	0.5800	62.8700	116000.00	116000.00	0.00	2000	63	2488	745	3.33959731543624	0.291214720435025	0.291214720435025	false	false	false	true	false
4d782f80-12ee-4b18-98aa-9abf2cc5475b	2026-09-21 10:33	2026-09-21 10:33	2026-09-21 10:33	XLE	XLE261120P00063000	put	63.0000	2026-11-20	2.5800	2.5600	2.5800	62.7850	14964.00	14964.00	0.00	58	7	304	421	0.72209026128266	0.264742050768974	0.264742050768974	true	false	false	true	false
bf5544e2-9f19-41d6-906f-3b0fb2561110	2026-09-21 10:31	2026-09-21 10:31	2026-09-21 10:31	XLE	XLE261002C00062000	call	62.0000	2026-10-02	1.6500	1.6500	1.7200	62.8200	16830.00	0.00	16830.00	102	10	107	40	2.675	0.265775009564197	0.265775009564197	true	false	false	true	false
0c1cd56b-5213-4b14-bd04-1b59a1812dd3	2026-09-21 10:25	2026-09-21 10:25	2026-09-21 10:25	XLE	XLE270617C00067500	call	67.5000	2027-06-17	4.1500	4.1000	4.2000	62.8450	19920.00	415.00	7885.00	48	6	123	23939	0.00513805923388613	0.241882564398974	0.241882564398974	false	false	false	true	false
62f462b8-385f-4f2d-b45a-fb230197f690	2026-09-21 10:21	2026-09-21 10:21	2026-09-21 10:21	XLE	XLE261016C00064000	call	64.0000	2026-10-16	1.2500	1.2400	1.2600	62.8350	12125.00	6250.00	5875.00	97	6	343	3746	0.091564335290977	0.25712551292436	0.25712551292436	false	false	false	true	false
c4eb327f-cee6-4374-a9e2-5584282da0d8	2026-09-21 10:15	2026-09-21 10:15	2026-09-21 10:15	XLE	XLE261218C00066000	call	66.0000	2026-12-18	2.2000	2.1600	2.2000	62.0000	22006.00	3086.00	1100.00	100	19	104	3528	0.0294784580498866	0.266459951368317	0.266459951368317	false	false	false	true	false
29410f0d-84a4-4caf-82a3-65ee8b01f946	2026-09-21 10:15	2026-09-21 10:15	2026-09-21 10:15	XLE	XLE261009P00061500	put	61.5000	2026-10-09	0.8700	0.8600	0.8800	62.0000	27405.00	0.00	26535.00	315	18	345	232	1.48706896551724	0.262388644612891	0.262388644612891	true	false	false	true	false
6235b606-7ff9-4ddd-8fdc-ec171495c1cd	2026-09-21 10:09	2026-09-21 10:09	2026-09-21 10:09	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.6900	1.6900	1.7100	62.8150	14027.00	0.00	14027.00	83	7	1119	48625	0.023012853470437	0.25664215274657	0.25664215274657	false	false	false	true	false
c5e5a972-f32b-4fa4-a1d5-416c3c322820	2026-09-21 10:08	2026-09-21 10:08	2026-09-21 10:08	XLE	XLE261120C00075000	call	75.0000	2026-11-20	0.2600	0.2500	0.2600	62.8050	26000.00	26000.00	0.00	1000	29	1266	11911	0.106288304928218	0.289363455367488	0.289363455367488	false	false	false	true	false
765e858d-7a46-4577-9a84-792e13bc1c90	2026-09-21 10:08	2026-09-21 10:08	2026-09-21 10:08	XLE	XLE261016P00058000	put	58.0000	2026-10-16	0.3100	0.3000	0.3100	62.7950	15500.00	15500.00	0.00	500	14	660	12693	0.0519971637910659	0.285738158237887	0.285738158237887	false	false	false	true	false
f2a87ba6-3266-41a3-95db-78569878e017	2026-09-21 10:07	2026-09-21 10:07	2026-09-21 10:07	XLE	XLE261009C00063000	call	63.0000	2026-10-09	1.4100	1.3700	1.4200	62.7950	10716.00	10575.00	141.00	76	23	85	119	0.714285714285714	0.260601839252694	0.260601839252694	true	false	false	true	false
893c2d20-d903-4c1e-ad00-5c90b4b66aed	2026-09-21 10:07	2026-09-21 10:07	2026-09-21 10:07	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.6400	0.6300	0.6500	62.7916	158528.00	153856.00	4544.00	2477	30	4184	44137	0.0947957495978431	0.270462076564703	0.270462076564703	true	false	false	true	false
7391c44c-6dc7-465b-9b7c-53187e2908e7	2026-09-21 10:07	2026-09-21 10:07	2026-09-21 10:07	XLE	XLE261023P00066000	put	66.0000	2026-10-23	3.8000	3.5500	3.8500	62.7950	20900.00	20520.00	380.00	55	9	66	16	4.125	0.25961994483866	0.25961994483866	true	false	false	true	false