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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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

1867f97a-d3f9-4771-8560-b1dce2b35af9	2026-09-18 15:53	2026-09-18 15:53	2026-09-18 15:53	XLE	XLE260928C00065000	call	65.0000	2026-09-28	0.5600	0.5600	0.5700	64.0000	23409.00	57.00	23352.00	418	5	433	69	6.27536231884058	0.193864424715641	0.196308385229202	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	41804540014.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
72622ef6-2b04-40a6-8741-56d024b57acb	2026-09-18 15:49	2026-09-18 15:49	2026-09-18 15:49	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3900	1.3900	1.4100	64.3050	12927.00	0.00	12927.00	93	14	3846	46847	0.0820970392981408	0.292294056997722	0.292294056997722	true	false	false	true
cf6b689a-3d94-4d3b-a952-54a305ff1190	2026-09-18 15:45	2026-09-18 15:45	2026-09-18 15:45	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.4000	1.3800	1.4200	64.2750	14000.00	2800.00	11200.00	100	5	3718	46847	0.0793647405383482	0.292125043904583	0.292125043904583	false	false	false	true
d2fc6e81-e4af-4058-a89e-703053d1ec11	2026-09-18 15:45	2026-09-18 15:45	2026-09-18 15:45	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.5300	0.5100	0.5300	64.3100	104251.00	104251.00	0.00	1967	55	2652	43118	0.0615056356973886	0.296814059101774	0.296814059101774	false	false	false	true
f3b2f839-a7fb-4c10-ac70-28d60bdc9d0c	2026-09-18 15:42	2026-09-18 15:42	2026-09-18 15:42	XLE	XLE261016P00062000	put	62.0000	2026-10-16	1.0200	1.0100	1.0200	64.3050	42432.00	42432.00	0.00	416	8	1626	22918	0.0709485993542194	0.291106853859343	0.291106853859343	false	false	false	true
f7fd4cc9-93b0-4b01-865f-85b07955501e	2026-09-18 15:29	2026-09-18 15:29	2026-09-18 15:29	XLE	XLE261218P00064000	put	64.0000	2026-12-18	3.2500	3.2000	3.2500	64.2350	16250.00	16250.00	0.00	50	5	215	2586	0.0831399845320959	0.290335261746811	0.290335261746811	false	false	false	true
6b819e6a-09a5-44ee-a203-98ce555cd42c	2026-09-18 15:26	2026-09-18 15:26	2026-09-18 15:26	XLE	XLE260921C00064000	call	64.0000	2026-09-21	0.3400	0.3100	0.3600	64.2350	14756.00	13634.00	1122.00	434	8	880	124	7.09677419354839	0.0795828846752358	0.0795828846752358	true	false	false	true
3f08717d-b2c8-40b2-96b0-ee58aa73fa37	2026-09-18 15:26	2026-09-18 15:26	2026-09-18 15:26	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.5200	0.5200	0.5300	64.2250	10400.00	0.00	10400.00	200	8	626	43118	0.0145182986223851	0.291396133301359	0.291396133301359	false	false	false	true
08a3d1a5-c91f-45ca-808b-e8c5a0b3eef5	2026-09-18 15:17	2026-09-18 15:17	2026-09-18 15:17	XLE	XLE260921P00065000	put	65.0000	2026-09-21	1.1500	1.1200	1.1900	64.2990	57500.00	0.00	57500.00	500	23	561	244	2.29918032786885	0.326111814490003	0.326111814490003	true	false	false	true
62c7d3f5-c2f7-49d6-8af1-036a2ae0a2a1	2026-09-18 15:11	2026-09-18 15:11	2026-09-18 15:11	XLE	XLE271217P00065000	put	65.0000	2027-12-17	6.6500	6.4500	6.8000	64.3250	184205.00	173565.00	10640.00	277	7	277	539	0.5139146567718	0.289400143221185	0.289400143221185	false	false	false	true
e1337b19-12b6-48f0-bc96-d6025f07c244	2026-09-18 15:10	2026-09-18 15:10	2026-09-18 15:10	XLE	XLE261218C00066000	call	66.0000	2026-12-18	2.8700	2.8600	2.8700	64.3400	27839.00	27839.00	0.00	97	11	195	2663	0.0732256853173113	0.258181867779294	0.258181867779294	false	false	false	true
38b486e3-e1ff-42ee-bb18-29c538f1cb7b	2026-09-18 15:06	2026-09-18 15:06	2026-09-18 15:06	XLE	XLE270115P00060000	put	60.0000	2027-01-15	1.9700	1.9300	1.9700	64.3300	328990.00	328990.00	0.00	1670	58	2012	26751	0.0752121416021831	0.287205971095054	0.287205971095054	false	false	false	true
b8b62d2e-fe93-4428-8b1d-d5f1ef246c8e	2026-09-18 14:49	2026-09-18 14:49	2026-09-18 14:49	XLE	XLE260930C00060000	call	60.0000	2026-09-30	4.3500	4.2500	4.5000	64.3950	783000.00	0.00	783000.00	1800	1	25236	6962	3.62482045389256	0.209953925144515	0.209953925144515	false	true	false	true
a96803af-b983-402c-aa95-b095fe8587d0	2026-09-18 14:49	2026-09-18 14:49	2026-09-18 14:49	XLE	XLE260930C00055000	call	55.0000	2026-09-30	9.4500	9.2500	9.4500	64.3950	170100.00	170100.00	0.00	180	1	2530	612	4.13398692810458	0.262168848448778	0.262168848448778	false	true	false	true
3f33f954-336a-40e9-bc44-f40b3a503078	2026-09-18 14:49	2026-09-18 14:49	2026-09-18 14:49	XLE	XLE260930C00057500	call	57.5000	2026-09-30	6.9000	6.7500	7.0000	64.3950	703800.00	703800.00	0.00	1020	1	14381	3410	4.21730205278592	0.316624414453299	0.316624414453299	false	true	false	true
7afdd58c-acff-4159-b1cf-0c7bc729d33e	2026-09-18 14:48	2026-09-18 14:48	2026-09-18 14:48	XLE	XLE260930C00057500	call	57.5000	2026-09-30	6.9000	6.7500	7.0000	64.3900	703800.00	703800.00	0.00	1020	1	13361	3410	3.91818181818182	0.324369829790968	0.324369829790968	false	true	false	true
51c4560f-5175-4b3f-b157-40234a1795b8	2026-09-18 14:48	2026-09-18 14:48	2026-09-18 14:48	XLE	XLE260930C00060000	call	60.0000	2026-09-30	4.3500	4.2500	4.5000	64.3900	783000.00	0.00	783000.00	1800	1	23436	6962	3.3662740591784	0.216077066472558	0.216077066472558	false	true	false	true
3e806739-cbe0-4b34-82bf-05a9282f51f1	2026-09-18 14:48	2026-09-18 14:48	2026-09-18 14:48	XLE	XLE260930C00055000	call	55.0000	2026-09-30	9.4500	9.2500	9.5000	64.3900	170100.00	170100.00	0.00	180	1	2350	612	3.83986928104575	0.435049743329363	0.435049743329363	false	true	false	true
debaa98c-edf2-4b25-983f-6b33f2fe9774	2026-09-18 14:48	2026-09-18 14:48	2026-09-18 14:48	XLE	XLE260930C00055000	call	55.0000	2026-09-30	9.4500	9.2500	9.5000	64.4101	170100.00	170100.00	0.00	180	1	2170	612	3.54575163398693	0.391327081294488	0.391327081294488	false	true	false	true
d0a9c13f-d162-45af-a147-4c72c5bfb23d	2026-09-18 14:48	2026-09-18 14:48	2026-09-18 14:48	XLE	XLE260930C00060000	call	60.0000	2026-09-30	4.3500	4.2500	4.5000	64.4101	783000.00	0.00	783000.00	1800	1	21636	6962	3.10772766446423	0.185045033060456	0.185045033060456	false	true	false	true
7722676c-2e19-467b-a1ce-b12f4f410e18	2026-09-18 14:48	2026-09-18 14:48	2026-09-18 14:48	XLE	XLE260930C00057500	call	57.5000	2026-09-30	6.9000	6.7500	7.0000	64.4101	703800.00	703800.00	0.00	1020	1	12341	3410	3.61906158357771	0.286201042152707	0.286201042152707	false	true	false	true
784b281d-0096-4d83-8f98-c596c115e20c	2026-09-18 14:48	2026-09-18 14:47	2026-09-18 14:47	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.7300	1.7200	1.7700	64.4100	26469.00	4498.00	21971.00	153	21	681	20908	0.0325712645877176	0.284947289080533	0.284947289080533	false	false	false	true
eab6e7e8-11dd-46a8-aeac-60ad5004b447	2026-09-18 14:47	2026-09-18 14:47	2026-09-18 14:47	XLE	XLE261002C00064500	call	64.5000	2026-10-02	1.1300	1.1200	1.1300	64.4151	17176.00	17176.00	0.00	152	16	398	155	2.56774193548387	0.223246882148794	0.223246882148794	false	false	false	true
5507fa51-07b5-4d7d-8569-8d3418b93b37	2026-09-18 14:45	2026-09-18 14:45	2026-09-18 14:45	XLE	XLE270617C00070000	call	70.0000	2027-06-17	3.8900	3.8500	3.9500	64.3650	38880.00	0.00	38880.00	100	5	101	3371	0.0299614357757342	0.236543318982524	0.23836743687841	false	false	false	true
e3a09c7c-2b4b-46f4-a18f-7e63a2584c19	2026-09-18 14:44	2026-09-18 14:44	2026-09-18 14:44	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.2900	0.2900	0.3000	64.3600	15138.00	0.00	15138.00	522	20	5872	27029	0.217248140885715	0.253415391803059	0.253415391803059	false	false	false	true
7937a81b-dea8-4055-8d52-340b4a563bb4	2026-09-18 14:44	2026-09-18 14:44	2026-09-18 14:44	XLE	XLE261218C00060000	call	60.0000	2026-12-18	6.2500	6.1000	6.2500	64.3950	1250000.00	1250000.00	0.00	2000	20	4022	58699	0.0685190548390944	0.252928816106837	0.252928816106837	false	false	false
5c37412d-550c-47cb-b482-2e092cfdda14	2026-09-18 14:41	2026-09-18 14:41	2026-09-18 14:41	XLE	XLE261218C00060000	call	60.0000	2026-12-18	6.2000	6.0500	6.2000	64.3850	929998.00	929998.00	0.00	1500	43	2022	58699	0.034446924138401	0.248674700697528	0.248674700697528	false	false	false	true
b2e60273-0c76-4f05-aa72-fee2ef9f50b0	2026-09-18 14:40	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260925C00061500	call	61.5000	2026-09-25	2.9400	2.7500	3.0000	64.3800	16150.00	16150.00	0.00	55	2	216	117	1.84615384615385	0.169593180443777	0.169593180443777	false	true	false	true
9745b4a5-3c77-4a67-8e1a-6d07a6ccd28c	2026-09-18 14:40	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE261016C00055000	call	55.0000	2026-10-16	9.3000	9.3000	9.5500	64.3800	283650.00	0.00	283650.00	305	1	2690	1991	1.35107985936715	0.208194916503627	0.208194916503627	false	true	false	true
4126769f-d6d4-4f9c-97f0-d4d3a97454a2	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE261016C00055000	call	55.0000	2026-10-16	9.3000	9.3000	9.5500	64.3800	362700.00	0.00	362700.00	390	1	2385	1991	1.19789050728277	0.208194916503627	0.208194916503627	false	true	false	true
fb1a87b7-cd5b-4019-bdd4-c3db3bd5c96e	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00060000	call	60.0000	2026-09-30	4.3500	4.3000	4.5000	64.3850	783000.00	0.00	783000.00	1800	1	16234	6962	2.33180120654984	0.221625618074311	0.221625618074311	false	true	false	true
e4cc0020-f664-49ab-aff7-1dc466f3c8e4	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00055000	call	55.0000	2026-09-30	9.5000	9.3000	9.5000	64.3850	171000.00	171000.00	0.00	180	1	1270	612	2.07516339869281	0.443383442988961	0.443383442988961	false	true	false	true
d14f7ece-531b-4329-abe1-bc40502823fe	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00055000	call	55.0000	2026-09-30	9.5000	9.3000	9.5000	64.3850	171000.00	171000.00	0.00	180	1	1630	612	2.66339869281046	0.443383442988961	0.443383442988961	false	true	false	true
849d4952-349e-438a-b3c1-9a24816e89eb	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00060000	call	60.0000	2026-09-30	4.3500	4.3000	4.5000	64.3850	783000.00	0.00	783000.00	1800	1	12634	6962	1.81470841712152	0.221625618074311	0.221625618074311	false	true	false	true
835d5928-e7bd-439f-87b7-434fdece41e9	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00057500	call	57.5000	2026-09-30	6.9500	6.8000	6.9500	64.3850	708900.00	708900.00	0.00	1020	1	7239	3410	2.12287390029326	0.190217066355706	0.190217066355706	false	true	false	true
5e7a181b-46a8-45bd-8c92-ac4299374b80	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00057500	call	57.5000	2026-09-30	6.9500	6.8000	6.9500	64.3850	708900.00	708900.00	0.00	1020	1	9279	3410	2.72111436950147	0.190217066355706	0.190217066355706	false	true	false	true
e20c2bee-fccc-4c3b-8833-98b35c94b5e0	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00055000	call	55.0000	2026-09-30	9.5000	9.3000	9.5000	64.3850	171000.00	171000.00	0.00	180	1	910	612	1.48692810457516	0.443383442988961	0.443383442988961	false	true	false	true
9d00b9ea-02f8-42fb-9a28-59c5d85a4289	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00060000	call	60.0000	2026-09-30	4.3500	4.3000	4.5000	64.3850	783000.00	0.00	783000.00	1800	1	9034	6962	1.29761562769319	0.221625618074311	0.221625618074311	false	true	false	true
00d09064-7b60-4c65-bd72-9bea8b678adf	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00057500	call	57.5000	2026-09-30	6.9500	6.8000	6.9500	64.3850	708900.00	708900.00	0.00	1020	1	5199	3410	1.52463343108504	0.190217066355706	0.190217066355706	false	true	false	true
d714b9b9-b5da-4ae5-ba85-f91ca6b6a455	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00057500	call	57.5000	2026-09-30	6.9500	6.8000	6.9500	64.3850	708900.00	708900.00	0.00	1020	1	4179	3410	1.22551319648094	0.190217066355706	0.190217066355706	false	true	false	true
a263a8e8-5c50-4334-bb16-166fe2f6a959	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00055000	call	55.0000	2026-09-30	9.5000	9.3000	9.5000	64.3850	171000.00	171000.00	0.00	180	1	730	612	1.19281045751634	0.443383442988961	0.443383442988961	false	true	false	true
91a8b5ff-3a18-4e9a-9112-daa7e8f4201f	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00060000	call	60.0000	2026-09-30	4.3500	4.3000	4.5000	64.3850	783000.00	0.00	783000.00	1800	1	7234	6962	1.03906923297903	0.221625618074311	0.221625618074311	false	true	false	true
5991ec07-37e5-4dda-8f69-00f4a2ffaf4f	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00057500	call	57.5000	2026-09-30	6.9500	6.8000	7.0000	64.3850	708900.00	708900.00	0.00	1020	1	2139	3410	0.627272727272727	0.331436217786023	0.331436217786023	false	true	false	true
3124d4d9-8d23-406f-a821-5b3402c0768e	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00055000	call	55.0000	2026-09-30	9.5000	9.3000	9.5000	64.3850	171000.00	171000.00	0.00	180	1	370	612	0.604575163398693	0.443383442988961	0.443383442988961	false	true	false	true
0d4de68e-4d97-47c8-b4c8-fe39af7119e5	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00060000	call	60.0000	2026-09-30	4.3500	4.3000	4.5000	64.3850	783000.00	0.00	783000.00	1800	1	3634	6962	0.521976443550704	0.221625618074311	0.221625618074311	false	true	false	true
dc0ebd35-51f8-4e08-88fd-e87d96c9b282	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00055000	call	55.0000	2026-09-30	9.5000	9.3000	9.5000	64.3850	171000.00	171000.00	0.00	180	1	190	612	0.310457516339869	0.443383442988961	0.443383442988961	false	true	false	true
44f985e0-1800-4537-9d6f-988a1211776c	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00057500	call	57.5000	2026-09-30	7.0000	6.8000	7.0000	64.3850	714000.00	714000.00	0.00	1020	1	1119	3410	0.328152492668622	0.331436217786023	0.331436217786023	false	true	false	true
1787bc3c-87fe-4617-a206-da0deedc4f7f	2026-09-18 14:39	2026-09-18 14:39	2026-09-18 14:39	XLE	XLE260930C00060000	call	60.0000	2026-09-30	4.3000	4.3000	4.5000	64.3850	774000.00	0.00	774000.00	1800	1	1834	6962	0.263430048836541	0.221625618074311	0.221625618074311	false	true	false	true
b83b2be2-6e42-4476-b014-e39f696289b3	2026-09-18 14:37	2026-09-18 14:37	2026-09-18 14:37	XLE	XLE260925C00063500	call	63.5000	2026-09-25	1.2000	1.1700	1.2000	64.3800	16320.00	16320.00	0.00	136	5	169	395	0.427848101265823	0.178420898913862	0.178420898913862	false	false	false	true
fab613cb-c5c8-4f1a-98b4-86ec85b6bbbf	2026-09-18 14:35	2026-09-18 14:35	2026-09-18 14:35	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5200	2.4800	2.5300	64.3750	17136.00	16884.00	252.00	68	17	152	15668	0.00970130201684963	0.279728042151088	0.279728042151088	false	false	false	true