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

e112d6a1-7474-4467-ba64-98db87e60004	2026-09-15 13:06	2026-09-15 13:06	2026-09-15 13:06	XLE	XLE261120C00070000	call	70.0000	2026-11-20	1.5800	1.5500	1.5900	65.8850	28756.00	27808.00	948.00	182	6	512	22245	0.0230164081816138	0.265537174804242	0.265537174804242	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	42266645050.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-15T17:17:02.017770Z"}	2026-09-15	2026-09-15 21:15	2026-09-15 21:15
76a07db3-438e-4731-a647-dc026b1049a1	2026-09-15 12:54	2026-09-15 12:54	2026-09-15 12:54	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.3600	1.3400	1.3600	65.8700	14688.00	14688.00	0.00	108	10	3312	19751	0.167687712014582	0.298992105254311	0.298992105254311	false	false	false	true
3fd6e97c-8168-4f29-964d-522df62a3ed6	2026-09-15 12:54	2026-09-15 12:53	2026-09-15 12:53	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.3600	1.3400	1.3700	65.8750	27261.00	27261.00	0.00	200	10	3204	19751	0.162219634448889	0.300655749985885	0.299233545070067	false	false	false	true
cb960ad8-e9d4-4b08-9af6-0b0f299784f0	2026-09-15 12:45	2026-09-15 12:45	2026-09-15 12:45	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.3400	1.3000	1.3400	65.0000	13400.00	13400.00	0.00	100	6	3825	49728	0.0769184362934363	0.333176633905927	0.333176633905927	false	false	false	true
a5e6c49a-ed5a-49fe-a24d-2c51b33c4f16	2026-09-15 12:19	2026-09-15 12:19	2026-09-15 12:19	XLE	XLE261023C00066000	call	66.0000	2026-10-23	2.1200	2.1200	2.1900	65.7850	54707.00	0.00	54707.00	258	11	650	1271	0.51140833988985	0.247959403474861	0.246776894293707	false	false	false	true
072266a9-b2e3-4fe8-8e03-8f76c7f254c2	2026-09-15 12:19	2026-09-15 12:19	2026-09-15 12:19	XLE	XLE261023C00066000	call	66.0000	2026-10-23	2.1200	2.0700	2.1900	65.7850	47726.00	26924.00	20802.00	225	9	375	1271	0.295043273013375	0.246468923012709	0.247959403474861	false	false	false	true
063419dd-dbf2-4388-9a42-bf6550f0b786	2026-09-15 12:14	2026-09-15 12:14	2026-09-15 12:14	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6700	0.6500	0.6700	65.8300	59764.00	59764.00	0.00	892	18	12155	11189	1.08633479310037	0.262399248912239	0.262399248912239	true	false	false	true
7b9c40e2-e3aa-4cbc-be8d-963450af1dae	2026-09-15 12:05	2026-09-15 12:05	2026-09-15 12:05	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.4700	0.4600	0.4700	65.6651	22325.00	22325.00	0.00	475	8	2856	15793	0.180839612486545	0.323641491567387	0.323641491567387	false	false	false	true
59d8d9ea-c559-4622-800f-ae801025ed57	2026-09-15 12:05	2026-09-15 12:05	2026-09-15 12:05	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.4700	0.4600	0.4700	65.6651	23923.00	23923.00	0.00	509	12	2381	15793	0.150762996264168	0.323641491567387	0.323641491567387	false	false	false	true
d4d45770-d280-407d-bd0c-ef769d27f755	2026-09-15 11:37	2026-09-15 11:37	2026-09-15 11:37	XLE	XLE261120P00065000	put	65.0000	2026-11-20	2.6400	2.6000	2.6400	65.7050	10560.00	10560.00	0.00	40	5	135	5102	0.0264602116816935	0.289730772912177	0.289730772912177	false	false	false	true
10095002-74bd-484a-a67b-abcb7e2814a4	2026-09-15 11:31	2026-09-15 11:31	2026-09-15 11:31	XLE	XLE260916P00065000	put	65.0000	2026-09-16	0.1900	0.1900	0.2100	65.7150	78983.00	0.00	78983.00	4157	14	5417	1188	4.55976430976431	0.340336062552223	0.340336062552223	false	false	false	true
8a39ddcf-0e62-4df3-a17a-444da4dbdc27	2026-09-15 11:30	2026-09-15 11:30	2026-09-15 11:30	XLE	XLE260921P00066000	put	66.0000	2026-09-21	1.2700	1.2500	1.2700	65.6950	15621.00	4572.00	0.00	123	6	352	20	17.6	0.336053431140815	0.336841989460398	true	false	false	true
25a1bd5c-31d7-464a-8e57-136152a3f9f0	2026-09-15 11:28	2026-09-15 11:28	2026-09-15 11:28	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.4000	0.4000	0.4200	65.7050	138680.00	0.00	138680.00	3467	6	9886	26812	0.368715500522154	0.301915667660148	0.301915667660148	true	false	false	true
10652a9b-f6e6-4849-a5a3-b52bb41d891b	2026-09-15 11:28	2026-09-15 11:28	2026-09-15 11:28	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.4000	0.4000	0.4200	65.7050	61320.00	0.00	61320.00	1533	53	6419	26812	0.239407727883037	0.301915667660148	0.301915667660148	true	false	false	true
c1db6b41-6fad-4182-8f72-83d856fe383d	2026-09-15 11:25	2026-09-15 11:25	2026-09-15 11:25	XLE	XLE261002C00070000	call	70.0000	2026-10-02	0.2900	0.2800	0.2900	65.6750	15399.00	15399.00	0.00	531	27	540	69	7.82608695652174	0.269645222270093	0.269645222270093	false	false	false	true
b493d3c7-2038-42ec-b1c0-41e2eca9c31f	2026-09-15 11:22	2026-09-15 11:22	2026-09-15 11:22	XLE	XLE261218C00062500	call	62.5000	2026-12-18	5.5000	5.0000	5.5000	65.6100	51150.00	51150.00	0.00	93	11	95	35930	0.00264403005844698	0.253629739885197	0.253629739885197	false	false	false	true
1bc3d540-72ff-4d9d-a299-5276488b1f4c	2026-09-15 11:17	2026-09-15 11:17	2026-09-15 11:17	XLE	XLE270617C00070000	call	70.0000	2027-06-17	4.4500	4.4000	4.4500	65.5100	44500.00	44500.00	0.00	100	8	263	3262	0.0806253832004905	0.238417654523485	0.238417654523485	false	false	false	true
68615f2b-d3e3-4220-babf-bb846b1335e5	2026-09-15 11:11	2026-09-15 11:10	2026-09-15 11:10	XLE	XLE261120P00066000	put	66.0000	2026-11-20	3.2500	3.2500	3.3000	65.3700	17225.00	0.00	17225.00	53	13	75	133	0.56390977443609	0.286519431524566	0.286519431524566	false	false	false	true
2dc710b1-ea30-4a55-8128-2de53e29cfeb	2026-09-15 11:11	2026-09-15 11:10	2026-09-15 11:10	XLE	XLE261120P00066000	put	66.0000	2026-11-20	3.2500	3.2000	3.3000	65.3850	18525.00	0.00	18200.00	57	13	132	133	0.992481203007519	0.287172451033917	0.287172451033917	false	false	false	true
9804b34b-00c4-4fdb-bdc1-447446b83405	2026-09-15 11:01	2026-09-15 11:01	2026-09-15 11:01	XLE	XLE261016C00067000	call	67.0000	2026-10-16	1.2600	1.2200	1.2700	65.0000	39438.00	39312.00	0.00	313	22	508	6140	0.0827361563517915	0.250633624856465	0.250633624856465	false	false	false	true
06206f90-8736-488a-abcd-9eb40b789650	2026-09-15 10:58	2026-09-15 10:58	2026-09-15 10:58	XLE	XLE261016C00062000	call	62.0000	2026-10-16	3.9500	3.8000	3.9500	65.0000	11455.00	11455.00	0.00	29	21	40	7214	0.00554477405045744	0.232872628276819	0.232872628276819	true	false	false	true
1c13ad3c-a949-40c3-bb45-7b6f1770bfed	2026-09-15 10:44	2026-09-15 10:44	2026-09-15 10:44	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.4500	0.4500	0.4700	65.0800	20520.00	0.00	20520.00	456	13	4881	26812	0.182045352827092	0.292958779819975	0.292958779819975	false	false	false	true
db3160ee-d6cd-4519-94e0-61a96186d592	2026-09-15 10:35	2026-09-15 10:35	2026-09-15 10:35	XLE	XLE260925P00065000	put	65.0000	2026-09-25	1.3100	1.2800	1.3100	65.1050	12183.00	12183.00	0.00	93	8	111	156	0.711538461538462	0.325152500465062	0.325152500465062	false	false	false	true
60c4f555-8271-45eb-9088-eee8c30f160b	2026-09-15 10:35	2026-09-15 10:35	2026-09-15 10:35	XLE	XLE260918P00066000	put	66.0000	2026-09-18	1.2100	1.2100	1.3400	65.0800	14520.00	0.00	14520.00	120	16	327	458	0.713973799126638	0.281241464395546	0.281241464395546	false	false	false	true
46ad9fde-d28d-462e-addd-429d452fd773	2026-09-15 10:35	2026-09-15 10:34	2026-09-15 10:34	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.7100	0.6700	0.7200	65.0550	28258.00	28258.00	0.00	398	9	1485	15793	0.0940290001899576	0.317849392751328	0.317849392751328	false	false	false	true
89df859d-0b22-4530-b828-beca21e0b7d6	2026-09-15 10:29	2026-09-15 10:29	2026-09-15 10:29	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.5500	1.4600	1.5500	65.1200	13164.00	13164.00	0.00	85	9	1778	19751	0.0900207584426105	0.288315054102873	0.287572919984179	false	false	false	true
0747e729-319b-4e9b-a70c-592687ee49b5	2026-09-15 10:27	2026-09-15 10:26	2026-09-15 10:26	XLE	XLE261016C00068000	call	68.0000	2026-10-16	0.9800	0.9700	1.0000	65.4100	17150.00	0.00	17150.00	175	5	379	7791	0.0486458734437171	0.249891207388975	0.249891207388975	false	false	false	true
6f924aa2-3fb1-4844-9293-b38fe25ba959	2026-09-15 10:20	2026-09-15 10:20	2026-09-15 10:20	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.0400	1.0400	1.0500	65.5000	196144.00	0.00	196144.00	1886	6	5566	38897	0.143095868575983	0.285514867809219	0.285514867809219	true	false	false	true
0009ba64-cea1-423c-a9dd-41f4434eded8	2026-09-15 10:20	2026-09-15 10:20	2026-09-15 10:20	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.0400	1.0400	1.0500	65.4900	11856.00	0.00	11856.00	114	19	3680	38897	0.0946088387279225	0.285070117580308	0.285070117580308	true	false	false	true
741e0cf4-283b-4dd7-8343-0dd16ec1b539	2026-09-15 10:19	2026-09-15 10:19	2026-09-15 10:19	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.4000	0.4000	0.4100	65.4900	129320.00	0.00	129320.00	3233	18	3471	26812	0.129456959570342	0.294942401822687	0.294942401822687	true	false	false	true
ec1fa8fb-ab7c-43a3-a0a7-0c81b00d59b2	2026-09-15 10:18	2026-09-15 10:18	2026-09-15 10:18	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.5400	0.5400	0.5500	65.4499	143154.00	0.00	143154.00	2651	8	11125	11189	0.994280096523371	0.25424558891838	0.25424558891838	true	false	false	true
5fa8dd76-61ca-4ba3-94f2-5a5a39fbe4dc	2026-09-15 10:18	2026-09-15 10:18	2026-09-15 10:18	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.5400	0.5400	0.5500	65.4499	76788.00	0.00	76788.00	1422	13	8474	11189	0.757350969702386	0.25424558891838	0.25424558891838	true	false	false	true
58cd1729-e8ed-4667-9fd2-aca264d5e9a9	2026-09-15 10:18	2026-09-15 10:18	2026-09-15 10:18	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.5400	0.5400	0.5600	65.4400	119772.00	0.00	119772.00	2218	54	4270	11189	0.38162481008133	0.254620110357311	0.254620110357311	true	false	false	true
4f2e6002-f16d-4b2e-94a2-c14b9db52dce	2026-09-15 10:18	2026-09-15 10:18	2026-09-15 10:18	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.5400	0.5400	0.5500	65.4400	150228.00	0.00	150228.00	2782	8	7052	11189	0.630261864331039	0.254620110357311	0.254620110357311	true	false	false	true
dd174abe-5045-4356-b075-182b505084ca	2026-09-15 10:12	2026-09-15 10:12	2026-09-15 10:12	XLE	XLE261120C00067000	call	67.0000	2026-11-20	2.3400	2.3200	2.3400	65.4300	54288.00	54288.00	0.00	232	9	309	948	0.325949367088608	0.25433397984903	0.25433397984903	false	false	false	true
220756a0-27e7-490c-8029-979d2308a4bd	2026-09-15 10:11	2026-09-15 10:11	2026-09-15 10:11	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.0000	1.0000	1.0400	65.4250	252500.00	0.00	252500.00	2525	48	3180	49728	0.0639478764478764	0.320649798975425	0.320649798975425	false	false	false	true
2a1d1d14-f643-4c11-a9d3-ea539208d07e	2026-09-15 10:11	2026-09-15 10:11	2026-09-15 10:11	XLE	XLE260916P00065000	put	65.0000	2026-09-16	0.2900	0.2800	0.2900	65.4350	11774.00	11774.00	0.00	406	12	579	1188	0.487373737373737	0.351683961408805	0.351683961408805	true	false	false	true
3a0efbd6-d1dd-4ab1-8334-c2e5836bc81d	2026-09-15 09:54	2026-09-15 09:54	2026-09-15 09:54	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.0800	1.0800	1.0900	65.4000	161676.00	0.00	161676.00	1497	5	3333	38897	0.085687842250045	0.287119120662102	0.287119120662102	true	false	false	true
fd8964ad-a007-4791-bc08-b6fa6874f1c0	2026-09-15 09:54	2026-09-15 09:54	2026-09-15 09:54	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.0800	1.0800	1.1200	65.4000	55836.00	0.00	55836.00	517	48	884	38897	0.0227266884335553	0.287119120662102	0.287119120662102	true	false	false	true
cf3179ae-eb66-4a92-9ce9-cd16b78b0dff	2026-09-15 09:54	2026-09-15 09:54	2026-09-15 09:54	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.0800	1.0800	1.1200	65.4000	102492.00	0.00	102492.00	949	8	1833	38897	0.0471244568989896	0.287119120662102	0.287119120662102	true	false	false	true
7e5c10f1-94a3-49ff-a9be-06c430d64fb9	2026-09-15 09:54	2026-09-15 09:53	2026-09-15 09:53	XLE	XLE260918C00066000	call	66.0000	2026-09-18	0.5300	0.5200	0.5300	65.4350	73140.00	73140.00	0.00	1380	16	1709	17746	0.0963033923137609	0.324666583465603	0.324666583465603	false	false	false	true
1c2e4899-4d5b-4b12-ab5f-f733bd192578	2026-09-15 09:53	2026-09-15 09:53	2026-09-15 09:53	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.4600	1.4600	1.4700	65.4100	21754.00	0.00	21754.00	149	10	1268	19751	0.0641992810490608	0.290218947973405	0.290218947973405	true	false	false	true
c03e3ba5-e6f4-4f41-8afb-692521def67c	2026-09-15 09:48	2026-09-15 09:47	2026-09-15 09:47	XLE	XLE260925C00066000	call	66.0000	2026-09-25	0.8000	0.7900	0.8800	65.3250	10320.00	80.00	10240.00	129	9	282	767	0.367666232073012	0.24808801105193	0.24808801105193	false	false	false	true
eafc9d65-1d90-48f3-b18c-02cd76005497	2026-09-15 09:47	2026-09-15 09:47	2026-09-15 09:47	XLE	XLE261016P00062000	put	62.0000	2026-10-16	0.8000	0.8000	0.8200	65.3599	78720.00	0.00	78720.00	984	24	4063	19103	0.212689106423075	0.287772564578406	0.287772564578406	true	false	false	true
9547060d-1005-4d6e-bc37-b3e08bf1a265	2026-09-15 09:47	2026-09-15 09:46	2026-09-15 09:46	XLE	XLE261016P00062000	put	62.0000	2026-10-16	0.8000	0.8000	0.8200	65.3850	34880.00	0.00	34880.00	436	22	2010	19103	0.105219075537874	0.288785386346325	0.288785386346325	true	false	false	true
292d6ae1-bb7c-46d4-b846-804421fa0b45	2026-09-15 09:47	2026-09-15 09:46	2026-09-15 09:46	XLE	XLE261016P00062000	put	62.0000	2026-10-16	0.8000	0.8000	0.8200	65.3850	85120.00	0.00	85120.00	1064	5	3074	19103	0.160917133434539	0.288785386346325	0.288785386346325	true	false	false	true
646a79a7-6ee5-47ee-ab94-8dad5dd26fc1	2026-09-15 09:46	2026-09-15 09:46	2026-09-15 09:46	XLE	XLE261016P00062000	put	62.0000	2026-10-16	0.8000	0.8000	0.8200	65.4000	119200.00	0.00	119200.00	1490	29	1574	19103	0.0823954352719468	0.289389805150888	0.289389805150888	true	false	false	true
ee1e3536-3e66-4746-935d-55d229c69f51	2026-09-15 09:46	2026-09-15 09:46	2026-09-15 09:46	XLE	XLE260918P00063500	put	63.5000	2026-09-18	0.1800	0.1800	0.1900	65.3900	33426.00	0.00	33426.00	1857	6	3084	8950	0.344581005586592	0.341519140184953	0.341519140184953	true	false	false	true
3692f0f7-58b3-46d7-9535-6f9725e9dde0	2026-09-15 09:46	2026-09-15 09:46	2026-09-15 09:46	XLE	XLE260918P00063500	put	63.5000	2026-09-18	0.1800	0.1800	0.2000	65.3900	20394.00	0.00	20394.00	1133	38	1227	8950	0.137094972067039	0.341519140184953	0.341519140184953	true	false	false	true
666e85e9-a0cc-4f71-b16f-aa25ffa25c37	2026-09-15 09:34	2026-09-15 09:34	2026-09-15 09:34	XLE	XLE261016P00061000	put	61.0000	2026-10-16	0.6500	0.6200	0.7100	65.2050	16250.00	1690.00	195.00	250	44	251	5702	0.0440196422307962	0.298285830375232	0.298285830375232	false	false	false	true