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

fe1e2ac4-c5e6-4677-b0b3-48a7f0890d3d	2026-09-18 14:32	2026-09-18 14:32	2026-09-18 14:32	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.5000	1.4700	1.5100	64.4397	377400.00	360600.00	16800.00	2516	27	2790	49000	0.0569387755102041	0.280957406796229	0.280957406796229	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	41804540014.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T18:43:10.830314Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
a7ac74eb-141b-488e-8809-21bc3f166517	2026-09-18 14:31	2026-09-18 14:31	2026-09-18 14:31	XLE	XLE261218P00057500	put	57.5000	2026-12-18	0.8900	0.8700	0.8900	64.4550	11659.00	11659.00	0.00	131	6	221	34766	0.00635678536501179	0.28352930214506	0.28352930214506	false	false	false	true
74383fa6-cfd9-46c8-9c0f-63eb00e8e436	2026-09-18 14:07	2026-09-18 14:07	2026-09-18 14:07	XLE	XLE261218P00059000	put	59.0000	2026-12-18	1.2300	1.2100	1.2300	64.3500	198030.00	198030.00	0.00	1610	26	1649	1323	1.2464096749811	0.279957739169416	0.279957739169416	false	false	false	true
95c7af30-7dfc-4124-bf28-06830d824a92	2026-09-18 14:06	2026-09-18 14:06	2026-09-18 14:06	XLE	XLE260925C00061500	call	61.5000	2026-09-25	2.8800	2.7800	2.9600	64.3250	30250.00	30250.00	0.00	105	2	113	117	0.965811965811966	0.155306413927995	0.155306413927995	false	true	false	true
5ddaf10a-4169-4c19-9207-71d2bdbc9f63	2026-09-18 14:06	2026-09-18 14:06	2026-09-18 14:06	XLE	XLE261016C00055000	call	55.0000	2026-10-16	9.4000	9.2500	9.5000	64.3275	1870600.00	1870600.00	0.00	1990	1	1990	1991	0.999497739829232	0.22138629962805	0.22138629962805	false	true	false	true
a41ed0a4-4a1a-4645-a818-75217b5e3060	2026-09-18 14:02	2026-09-18 14:02	2026-09-18 14:02	XLE	XLE261218P00064000	put	64.0000	2026-12-18	3.0500	3.0500	3.1000	64.3550	23790.00	0.00	23790.00	78	9	105	2586	0.0406032482598608	0.278558738030428	0.278558738030428	false	false	false	true
2d5a8ed6-4761-4391-aba7-7df27f0a4c61	2026-09-18 13:51	2026-09-18 13:51	2026-09-18 13:51	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.4700	1.4500	1.4800	64.4200	41160.00	39690.00	1470.00	280	14	7735	11441	0.676077265973254	0.231738947588653	0.231738947588653	true	false	false	true
f6710750-7c4a-4f1a-a8e3-9dbe21f81f96	2026-09-18 13:46	2026-09-18 13:45	2026-09-18 13:45	XLE	XLE261218P00066000	put	66.0000	2026-12-18	4.1000	4.1000	4.1500	64.3950	28290.00	0.00	28290.00	69	7	96	3079	0.031178954205911	0.280878640078144	0.280878640078144	false	false	false	true
89a5e291-f868-4ea5-b8af-051e598e90ef	2026-09-18 13:46	2026-09-18 13:45	2026-09-18 13:45	XLE	XLE261218P00065000	put	65.0000	2026-12-18	3.5500	3.5500	3.6000	64.3950	15620.00	0.00	15620.00	44	9	199	2525	0.0788118811881188	0.280134938622796	0.280134938622796	false	false	false	true
846aa503-84e8-4be4-a59f-ba1391e13f81	2026-09-18 13:37	2026-09-18 13:37	2026-09-18 13:37	XLE	XLE261002P00059000	put	59.0000	2026-10-02	0.1000	0.1000	0.1100	64.4400	14450.00	0.00	14450.00	1445	19	1499	367	4.08446866485014	0.300206338076303	0.300206338076303	false	false	false	true
48b4fec7-e6e3-4cbc-aad0-42f1aa295944	2026-09-18 13:31	2026-09-18 13:31	2026-09-18 13:31	XLE	XLE261231P00065000	put	65.0000	2026-12-31	3.8500	3.7000	3.8500	64.4250	11935.00	11935.00	0.00	31	5	34	35	0.971428571428571	0.288730054496177	0.288730054496177	false	false	false	true
e9d71383-051d-4eb1-abe8-e1f6d257b1fb	2026-09-18 13:14	2026-09-18 13:14	2026-09-18 13:14	XLE	XLE260925P00060500	put	60.5000	2026-09-25	0.0800	0.0700	0.0800	64.3556	40000.00	40000.00	0.00	5000	28	7019	319	22.0031347962382	0.304427730672411	0.304427730672411	false	false	false	true
9f8250a5-cb09-4bb3-a7b2-eb0551855e20	2026-09-18 13:13	2026-09-18 13:13	2026-09-18 13:13	XLE	XLE260925P00060500	put	60.5000	2026-09-25	0.0800	0.0700	0.0800	64.3550	16000.00	16000.00	0.00	2000	44	2019	319	6.32915360501567	0.304393073417619	0.304393073417619	false	false	false	true
e067960a-b2b4-4500-a2bb-d2f53029a4f8	2026-09-18 13:12	2026-09-18 13:12	2026-09-18 13:12	XLE	XLE260923C00066000	call	66.0000	2026-09-23	0.1100	0.1100	0.1200	64.3100	24013.00	0.00	24013.00	2183	5	2201	148	14.8716216216216	0.201313730040489	0.201313730040489	false	false	false	true
a7343f6e-feaf-40d4-ac42-18f638ddbfb4	2026-09-18 13:06	2026-09-18 13:06	2026-09-18 13:06	XLE	XLE260921C00065000	call	65.0000	2026-09-21	0.0800	0.0800	0.0900	64.3350	28656.00	0.00	28656.00	3582	16	4793	415	11.5493975903614	0.127179941111728	0.127179941111728	false	false	false	true
ef47f3a1-87ac-4056-9b20-139a6e26c308	2026-09-18 12:52	2026-09-18 12:52	2026-09-18 12:52	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.4100	4.3000	4.4500	64.3850	55110.00	55110.00	0.00	125	17	427	54198	0.00787851950256467	2.33833848121036	1.79127374611761	false	false	false	true
e2b515db-b397-423e-a8ab-75ead24df697	2026-09-18 12:51	2026-09-18 12:51	2026-09-18 12:51	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.2700	1.2500	1.2700	64.3750	63500.00	63500.00	0.00	500	46	3360	46847	0.0717228424445535	0.278197832099933	0.278197832099933	false	false	false	true
f0668c2e-6823-47d3-bc3d-a2c3ea9e0a8e	2026-09-18 12:50	2026-09-18 12:50	2026-09-18 12:50	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.2600	1.2500	1.2600	64.3850	63000.00	63000.00	0.00	500	26	2860	46847	0.061049800414114	0.277237283495061	0.277237283495061	false	false	false	true
1dc30797-c958-4e95-a7d8-828dc3e3200a	2026-09-18 12:39	2026-09-18 12:38	2026-09-18 12:38	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.4600	1.4300	1.4600	64.4950	15622.00	15622.00	0.00	107	14	157	49000	0.00320408163265306	0.278449401392427	0.278449401392427	false	false	false	true
4fcac932-f252-427e-9183-e3662b3cd91d	2026-09-18 12:27	2026-09-18 12:27	2026-09-18 12:27	XLE	XLE261218C00072500	call	72.5000	2026-12-18	1.0600	1.0600	1.1300	64.5450	12190.00	0.00	12190.00	115	11	126	4758	0.0264817150063052	0.262604352747323	0.262604352747323	false	false	false	true
999b5110-a0bd-4670-8e3c-18817ccc68e8	2026-09-18 12:08	2026-09-18 12:08	2026-09-18 12:08	XLE	XLE270331P00064000	put	64.0000	2027-03-31	4.3000	4.2000	4.3000	64.0000	31820.00	31820.00	0.00	74	11	74	23	3.21739130434783	0.286629617728799	0.286629617728799	false	false	false	true
66404e7f-7aff-440d-a146-5e44618e95cd	2026-09-18 12:03	2026-09-18 12:03	2026-09-18 12:03	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.5900	1.5600	1.5900	64.0000	23850.00	23850.00	0.00	150	31	6512	11441	0.569181015645486	0.231106554447756	0.231106554447756	false	false	false	true
14d88554-9088-48fe-8c01-df8fca697a02	2026-09-18 12:00	2026-09-18 12:00	2026-09-18 12:00	XLE	XLE261016P00062000	put	62.0000	2026-10-16	0.8300	0.8200	0.8400	64.7000	25066.00	22742.00	0.00	302	9	935	22918	0.0407976263199232	0.277974582963958	0.277974582963958	false	false	false	true
1e1da5e6-51d6-4066-9a19-f10056006ad0	2026-09-18 11:59	2026-09-18 11:59	2026-09-18 11:59	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.6700	4.5500	4.7000	64.6850	18688.00	18688.00	0.00	40	5	281	54198	0.0051846931621093	1.66486797085075	1.66486797085075	false	false	false	true
97348629-e924-4aea-b7b4-f359cc15edaa	2026-09-18 11:59	2026-09-18 11:59	2026-09-18 11:59	XLE	XLE260925C00065000	call	65.0000	2026-09-25	0.5700	0.5500	0.5700	64.6852	14250.00	14250.00	0.00	250	8	596	1723	0.345908299477655	0.193977153980482	0.193977153980482	false	false	false	true
46e60e6e-1980-4eb9-8408-522c13dd7696	2026-09-18 11:57	2026-09-18 11:57	2026-09-18 11:57	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.2900	2.2900	2.3100	64.6500	15572.00	0.00	15572.00	68	15	75	60387	0.00124198916985444	0.279362096150957	0.279362096150957	true	false	false	true
39944943-82c3-496f-a603-074861f09ed0	2026-09-18 11:18	2026-09-18 11:18	2026-09-18 11:18	XLE	XLE261016C00068000	call	68.0000	2026-10-16	0.6400	0.6300	0.6400	64.6950	153024.00	153024.00	0.00	2391	7	2578	8306	0.310378039971105	0.242648510378521	0.242648510378521	true	false	false	true
07726eca-dc68-4baa-82d4-f1ad40710234	2026-09-18 11:11	2026-09-18 11:11	2026-09-18 11:11	XLE	XLE261016P00062000	put	62.0000	2026-10-16	0.8300	0.8300	0.8400	64.6800	10624.00	0.00	10624.00	128	11	463	22918	0.0202024609477267	0.277072904790212	0.277072904790212	false	false	false	true
e17f5232-7726-4e30-86ab-0cb44bd20883	2026-09-18 11:11	2026-09-18 11:10	2026-09-18 11:10	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.1700	1.1600	1.1700	64.6550	11700.00	11700.00	0.00	100	7	1896	46847	0.0404721753794266	0.277875805248985	0.277875805248985	true	false	false	true
51e9d92a-7143-4073-9f07-717da806ffa5	2026-09-18 11:02	2026-09-18 11:02	2026-09-18 11:02	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.5100	1.5100	1.5300	64.5200	23556.00	0.00	23556.00	156	10	5797	11441	0.506686478454681	0.230604109525323	0.230604109525323	true	false	false	true
659578a7-bb34-449b-bcdd-a350133357a9	2026-09-18 10:53	2026-09-18 10:53	2026-09-18 10:53	XLE	XLE261002P00064000	put	64.0000	2026-10-02	1.1600	1.1600	1.1800	64.4800	24128.00	0.00	24128.00	208	8	213	226	0.942477876106195	0.285198098941603	0.285198098941603	true	false	false	true
816c8cea-b4ba-42ee-8f06-a985dd89871e	2026-09-18 10:45	2026-09-18 10:44	2026-09-18 10:44	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.5900	1.5600	1.5900	64.6450	119250.00	119250.00	0.00	750	39	5134	11441	0.448736998514116	0.233202623528917	0.233202623528917	true	false	false	true
eb2451b9-cfcf-4e8c-8e42-1f241af39240	2026-09-18 10:40	2026-09-18 10:39	2026-09-18 10:39	XLE	XLE261218P00065000	put	65.0000	2026-12-18	3.5000	3.5000	3.5500	64.5400	18550.00	0.00	18550.00	53	10	123	2525	0.0487128712871287	0.281502360276606	0.281502360276606	false	false	false	true
5de3655a-7872-48a8-aa09-b62b64b8d3ac	2026-09-18 10:32	2026-09-18 10:32	2026-09-18 10:32	XLE	XLE261120C00060000	call	60.0000	2026-11-20	5.6500	5.5500	5.6500	64.5200	53110.00	53110.00	0.00	94	20	104	6185	0.0168148746968472	0.234860412757024	0.234860412757024	true	false	false	true
9e2191e7-be8e-441a-88e5-218419a0463e	2026-09-18 10:26	2026-09-18 10:25	2026-09-18 10:25	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.4500	6.4000	6.4500	64.3900	868815.00	868815.00	0.00	1347	10	1449	28128	0.0515145051194539	0.226912022917125	0.226912022917125	false	false	false	true
0bcba707-1e03-4324-8b60-2c674d1bfc42	2026-09-18 10:23	2026-09-18 10:23	2026-09-18 10:23	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.4600	1.4500	1.4700	64.4182	105850.00	88330.00	10804.00	725	27	4237	11441	0.37033476094747	0.230331503937903	0.230452013386362	true	false	false	true
ea8c0674-675c-40dd-b248-ca33545f6a56	2026-09-18 10:21	2026-09-18 10:21	2026-09-18 10:21	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.2600	1.2500	1.2700	64.3600	41328.00	41202.00	126.00	328	9	1343	46847	0.0286677908937605	0.275888880902595	0.275888880902595	false	false	false	true
0f7d6605-a0f5-4b7c-a56b-ed3a645a47c0	2026-09-18 10:21	2026-09-18 10:21	2026-09-18 10:21	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.7100	1.7000	1.7100	64.3600	26311.00	22401.00	3910.00	154	18	377	20908	0.0180313755500287	0.278983240581674	0.278983240581674	false	false	false	true
6dfe34e4-fd80-42f6-9b4a-03cfd85764a2	2026-09-18 10:18	2026-09-18 10:18	2026-09-18 10:18	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.4600	1.4000	1.4700	64.3950	79570.00	78402.00	1168.00	545	17	3474	11441	0.303644786294904	0.232002448367897	0.232002448367897	true	false	false	true
b50f5b3c-71bb-4f2a-924c-083c3e20233e	2026-09-18 09:57	2026-09-18 09:57	2026-09-18 09:57	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.3300	6.2500	6.6000	64.2100	35424.00	630.00	34794.00	56	5	69	28128	0.00245307167235495	0.225757869389575	0.225757869389575	false	false	false	true
335c7e8d-024f-40fe-a5e4-9093a503864c	2026-09-18 09:55	2026-09-18 09:54	2026-09-18 09:54	XLE	XLE270115C00067500	call	67.5000	2027-01-15	2.6100	2.6100	2.7300	64.3000	12006.00	0.00	12006.00	46	8	136	9994	0.0136081648989394	0.244079717867362	0.244079717867362	false	false	false	true
55b2ed3d-d2f9-43de-b36b-90a64be8c79e	2026-09-18 09:54	2026-09-18 09:54	2026-09-18 09:54	XLE	XLE270115C00067500	call	67.5000	2027-01-15	2.6100	2.6100	2.7300	64.3250	11484.00	0.00	11484.00	44	8	90	9994	0.00900540324194517	0.24333582684471	0.24333582684471	false	false	false	true
5d136f84-d1ea-45ae-a1ab-eacd04fe108d	2026-09-18 09:54	2026-09-18 09:54	2026-09-18 09:54	XLE	XLE270115C00067500	call	67.5000	2027-01-15	2.6100	2.6100	2.7300	64.3300	10962.00	0.00	10962.00	42	5	46	9994	0.0046027616569942	0.243186963354734	0.243186963354734	false	false	false	true
dbc1a753-a298-40b8-81dd-272f8fa6d3f4	2026-09-18 09:52	2026-09-18 09:52	2026-09-18 09:52	XLE	XLE281215C00065000	call	65.0000	2028-12-15	10.6600	10.2500	10.7000	64.4500	58623.00	58623.00	0.00	55	6	96	2358	0.0407124681933842	0.200230498249977	0.199940383609416	false	false	false	true
6282b9cf-7db0-42c4-baba-703aacd783e9	2026-09-18 09:50	2026-09-18 09:50	2026-09-18 09:50	XLE	XLE290119C00070000	call	70.0000	2029-01-19	8.8000	8.4500	8.8500	64.4700	68666.00	68666.00	0.00	78	5	78	0	0	0.204161740244507	0.204161740244507	false	false	false	true
03b6bbac-f9b6-4c97-8bf7-4a81c1e35e58	2026-09-18 09:49	2026-09-18 09:49	2026-09-18 09:49	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.4700	2.4700	2.6100	64.4300	14576.00	0.00	14576.00	59	6	59	15668	0.00376563696706663	0.277500519588498	0.279447309426473	false	false	false	true
2ad5427b-f25b-4975-bbd6-9c951a09a446	2026-09-18 09:43	2026-09-18 09:43	2026-09-18 09:43	XLE	XLE261023C00065000	call	65.0000	2026-10-23	1.7000	1.6400	1.7200	64.4050	72080.00	72080.00	0.00	424	6	424	84	5.04761904761905	0.233878438907425	0.233878438907425	true	false	false	true
6c72e692-0ebb-48a5-a33c-3992a86c57fb	2026-09-18 09:35	2026-09-18 09:35	2026-09-18 09:35	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.2800	0.2700	0.2800	64.2700	60228.00	60228.00	0.00	2151	11	2232	27029	0.082577971808058	0.253862723528101	0.253862723528101	false	false	false	true
a45ac9c4-019d-4fe9-b6f4-22cc80a615c2	2026-09-18 09:33	2026-09-18 09:33	2026-09-18 09:33	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.7500	1.7400	1.7800	64.3300	12066.00	0.00	12066.00	69	18	107	20908	0.00511765831260761	0.282157326302907	0.281365842102624	true	false	false	true
6d7059c8-4afc-48a1-a456-3ebe2c79526b	2026-09-17 15:54	2026-09-17 15:54	2026-09-17 15:54	XLE	XLE260918C00064500	call	64.5000	2026-09-18	0.3300	0.3200	0.3400	64.0000	33033.00	21285.00	0.00	1001	6	1690	2832	0.596751412429379	0.260676090026938	0.258983332687011	false	false	false	true