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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×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

301384c8-900d-4c5d-b634-c886aa6a2992	2026-09-23 13:26	2026-09-23 13:26	2026-09-23 13:26	XLE	XLE270617P00060000	put	60.0000	2027-06-17	3.7500	3.6000	3.7500	62.0000	21351.00	21351.00	0.00	57	5	60	4375	0.0137142857142857	0.273284881413603	0.273284881413603	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	39654329160.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T17:31:46.460740Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
22da21c0-d65e-48fe-9c77-d1ecbbf54ff5	2026-09-23 11:29	2026-09-23 11:29	2026-09-23 11:29	XLE	XLE260930C00063000	call	63.0000	2026-09-30	0.8300	0.8000	0.8400	62.0000	41701.00	41701.00	0.00	500	15	683	179	3.81564245810056	0.263014449889113	0.265902184044309	false	false	false	true
7a4ecabd-b916-4cc6-a875-d757d29cb56e	2026-09-23 09:45	2026-09-23 09:45	2026-09-23 09:45	XLE	XLE261030C00065000	call	65.0000	2026-10-30	1.1600	1.1300	1.1700	62.0000	31189.00	31189.00	0.00	268	22	536	75	7.14666666666667	0.263802349840153	0.263566260977156	false	false	false	true
0fb4e8eb-b0a0-4e79-9738-76d8c9ce880e	2026-09-22 14:19	2026-09-22 14:19	2026-09-22 14:19	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.0100	1.9800	2.0500	62.2000	21906.00	0.00	21906.00	109	8	16177	47499	0.340575591065075	0.258708633637008	0.260011125092252	true	false	false	true
7549d810-ffba-4f75-99f1-c647cb3168e4	2026-09-22 13:52	2026-09-22 13:51	2026-09-22 13:51	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.8800	1.8400	1.8900	62.2950	10156.00	10156.00	0.00	54	5	14860	47499	0.312848691551401	0.249220841834467	0.250798363919874	true	false	false	true
8f9964ee-cda5-4250-a33c-21468d9abc43	2026-09-22 10:39	2026-09-22 10:39	2026-09-22 10:39	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.0500	2.0000	2.0600	62.0600	17245.00	16835.00	0.00	84	33	11778	47499	0.247963115012948	0.257402250074973	0.257208551793215	true	false	false	true
d501f5fa-ec03-47f3-97d8-ebcb8dfebe7d	2026-09-22 10:09	2026-09-22 10:09	2026-09-22 10:09	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.9900	1.9800	2.0000	62.1600	39754.00	0.00	35376.00	200	8	9327	47499	0.196362028674288	0.253352737929453	0.254939405399468	false	false	false	true
57c26b3e-6ae0-4753-8ce8-9aebdecd55af	2026-09-22 09:38	2026-09-22 09:38	2026-09-22 09:38	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.3400	2.3400	2.3600	61.5800	12171.00	0.00	11936.00	52	6	5211	47499	0.109707572791006	0.257094134201947	0.25874149300459	false	false	false	true
c6d2187e-f654-4208-9845-f31e96d2585f	2026-09-22 09:38	2026-09-22 09:37	2026-09-22 09:37	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.4000	2.3800	2.4000	61.5100	11266.00	9600.00	1666.00	47	17	5094	47499	0.107244363039222	0.256634688779288	0.259948638510531	false	false	false	true
97e1d458-041b-4de5-b912-0f0bc85248c6	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.2800	2.2500	2.2800	61.7800	11151.00	11151.00	0.00	49	7	839	47499	0.0176635297585212	0.266087079185001	0.266759917265958	false	false	false	true
f373656e-ac5c-489a-b382-f7e6b940ecba	2026-09-21 15:48	2026-09-21 15:48	2026-09-21 15:48	XLE	XLE270617C00055000	call	55.0000	2027-06-17	10.6900	10.5000	10.9500	62.0000	10688.00	0.00	10688.00	10	6	120	7478	0.0160470714094678	0.234179542414012	0.234179542414012	false	false	false	true
07ca0933-3d1c-4b84-8ad9-9a3367570e9b	2026-09-21 15:29	2026-09-21 15:29	2026-09-21 15:29	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.0000	1.9700	2.0100	62.4150	12999.00	12999.00	0.00	65	13	3532	48625	0.0726375321336761	0.271593888892931	0.273130928873469	false	false	false	true
1d276100-dd07-42ae-b1ea-22adb86929cf	2026-09-21 15:21	2026-09-21 15:21	2026-09-21 15:21	XLE	XLE261231P00060000	put	60.0000	2026-12-31	2.1300	1.9900	2.1300	62.6750	12135.00	12135.00	0.00	57	6	342	312	1.09615384615385	0.278121224869993	0.278121224869993	false	false	false	true
c2120c66-6533-4ec0-ab0c-efc86c872974	2026-09-21 14:11	2026-09-21 14:11	2026-09-21 14:11	XLE	XLE260923C00063000	call	63.0000	2026-09-23	0.4000	0.3900	0.4100	62.8300	15968.00	15568.00	400.00	398	52	1717	345	4.9768115942029	0.255181136832624	0.260610051685188	false	false	false	true
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
9d91db02-db0a-474a-9e33-5b103940d207	2026-09-21 10:02	2026-09-21 10:02	2026-09-21 10:02	XLE	XLE261218P00067500	put	67.5000	2026-12-18	5.8000	5.2500	5.8000	62.8800	27240.00	27240.00	0.00	47	5	47	480	0.0979166666666667	0.272857020452599	0.272857020452599	false	false	false	true
7ca5b59e-6b0e-45b0-b7d9-39bde301524c	2026-09-18 15:59	2026-09-18 15:59	2026-09-18 15:59	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.7300	1.7300	1.7800	64.0000	19038.00	0.00	18864.00	110	25	2190	20908	0.104744595370193	0.276468901615744	0.277889622925114	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
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
9aa2ffac-dbe0-4582-906b-b9b065256786	2026-09-16 15:44	2026-09-16 15:44	2026-09-16 15:44	XLE	XLE271217C00060000	call	60.0000	2027-12-17	9.7500	9.7500	10.1000	63.8650	168758.00	0.00	168758.00	173	8	381	5297	0.0719275061355484	0.199457619829512	0.199457619829512	false	false	false	true
33772448-3883-4ec6-b2c4-0302bb74f0e5	2026-09-16 15:37	2026-09-16 15:37	2026-09-16 15:37	XLE	XLE271217C00060000	call	60.0000	2027-12-17	9.8200	9.8000	10.1000	63.8050	38292.00	0.00	38292.00	39	7	66	5297	0.0124598829526147	0.203544341797954	0.205696606270775	false	false	false	true
f6c14522-a29d-4b75-b9f8-99f58042d6ea	2026-09-16 13:01	2026-09-16 13:01	2026-09-16 13:01	XLE	XLE261231C00065000	call	65.0000	2026-12-31	3.6600	3.6500	3.8000	64.6550	18312.00	0.00	18312.00	50	9	105	1932	0.0543478260869565	0.247227470512541	0.248870570335238	false	false	false	true
e61c835c-9baa-43df-a1d4-0de08b2ba1db	2026-09-16 11:47	2026-09-16 11:47	2026-09-16 11:47	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.8500	0.8300	0.8500	64.5162	34172.00	34172.00	0.00	403	16	4198	19544	0.21479738027016	0.303627231319012	0.306124153199271	true	false	false	true
29b47256-fb85-407f-adfc-3141f77a75f8	2026-09-16 10:45	2026-09-16 10:45	2026-09-16 10:45	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.7500	3.7500	3.9000	64.3600	30035.00	2660.00	27375.00	80	14	350	33197	0.0105431213663885	0.245720326011331	0.245720326011331	false	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
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
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
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
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
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
b798d2bc-9b8a-4bac-8010-610753ec3895	2026-09-14 15:52	2026-09-14 15:52	2026-09-14 15:52	XLE	XLE270319C00067000	call	67.0000	2027-03-19	3.8900	3.8500	3.9000	64.0000	46333.00	46333.00	0.00	119	18	179	575	0.311304347826087	0.248699847222504	0.249246358021143	false	false	false	true
07bb72fd-be98-46de-b438-885afdf105e0	2026-09-14 14:04	2026-09-14 14:04	2026-09-14 14:04	XLE	XLE261120P00060000	put	60.0000	2026-11-20	1.1300	1.1000	1.1400	64.6550	11314.00	11314.00	0.00	100	7	566	8464	0.0668714555765595	0.284817439123164	0.284817439123164	false	false	false	true
cb26bb94-6d6e-4f00-9165-87e5c244eb4d	2026-09-14 12:49	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE260925C00065000	call	65.0000	2026-09-25	0.9500	0.9500	1.0800	64.6300	40963.00	0.00	20995.00	429	16	588	371	1.58490566037736	0.243341334512954	0.24558381581799	true	false	false	true
edca44d5-c26c-4645-b9d4-4942bb9d4e82	2026-09-14 11:31	2026-09-14 11:31	2026-09-14 11:31	XLE	XLE260930P00060000	put	60.0000	2026-09-30	0.2100	0.1700	0.2300	65.1950	64186.00	64186.00	0.00	3000	17	3148	1449	2.17253278122843	0.322075377739559	0.322075377739559	false	false	false	true
6dbb16ea-827a-4408-b7e1-90be71aab604	2026-09-11 15:55	2026-09-11 15:55	2026-09-11 15:55	XLE	XLE260914P00064000	put	64.0000	2026-09-14	0.1100	0.0900	0.1300	65.0750	68596.00	68561.00	0.00	6105	97	7052	293	24.0682593856655	0.200090784866967	0.206639501831278	true	false	false	true
5b289e62-8fba-4cb3-8ef6-233dd5cd7a42	2026-09-11 09:59	2026-09-11 09:59	2026-09-11 09:59	XLE	XLE260911C00065000	call	65.0000	2026-09-11	0.5900	0.5900	0.6400	65.0000	11826.00	0.00	11826.00	200	22	864	13305	0.0649379932356257	0.303450672102284	0.303450672102284	false	false	false	true
a3cda86f-7d1c-4ab9-a4dd-3e506b4aabc3	2026-09-11 09:34	2026-09-11 09:33	2026-09-11 09:33	XLE	XLE260911P00064500	put	64.5000	2026-09-11	0.1000	0.0600	0.1100	65.0000	65922.00	53565.00	8647.00	6636	104	6670	5054	1.3197467352592	0.447974911543173	0.469857927875461	true	false	false	true
818a8c89-8d10-4b2d-a877-5658ffa3404e	2026-09-10 11:00	2026-09-10 11:00	2026-09-10 11:00	XLE	XLE260911C00065000	call	65.0000	2026-09-11	0.3700	0.3500	0.3700	64.7900	18496.00	18496.00	0.00	500	8	1524	15800	0.0964556962025317	0.335341235507257	0.342837181214911	false	false	false	true
9dd00324-8365-4017-8148-85d521eb9fd5	2026-09-10 10:44	2026-09-10 10:44	2026-09-10 10:44	XLE	XLE270115C00065000	call	65.0000	2027-01-15	4.0000	3.9000	4.0000	64.6550	43993.00	43993.00	0.00	110	6	183	32878	0.00556603199708011	0.244151110091624	0.245477112409118	false	false	false	true
ca410f37-4c52-4648-adb8-04cd06907978	2026-09-09 15:01	2026-09-09 15:00	2026-09-09 15:00	XLE	XLE270319P00065000	put	65.0000	2027-03-19	4.3300	4.2500	4.4000	65.4800	12988.00	12124.00	864.00	30	8	131	838	0.156324582338902	0.274453118916613	0.274453118916613	false	false	false	true
0dab32e7-785e-4528-a709-06f76b823000	2026-09-09 10:18	2026-09-09 10:18	2026-09-09 10:18	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.3200	2.2500	2.3800	65.2650	66092.00	59624.00	6468.00	285	5	377	20011	0.0188396381989906	0.248557018920801	0.248557018920801	false	false	false	true
58bcaf66-b35e-469e-9802-183d0298d6f7	2026-09-08 12:26	2026-09-08 12:26	2026-09-08 12:26	XLE	XLE270319P00062000	put	62.0000	2027-03-19	3.1000	3.1000	3.2000	64.6950	50532.00	0.00	50532.00	163	24	267	4078	0.0654732712113781	0.267929315416805	0.26851468640798	false	false	false	true
5dd9a8de-cd65-4a70-9251-62c090984eb4	2026-09-08 10:11	2026-09-08 10:11	2026-09-08 10:11	XLE	XLE260918C00064000	call	64.0000	2026-09-18	1.8400	1.8300	1.8900	65.1971	136033.00	0.00	112792.00	740	17	2047	11322	0.180798445504328	0.254046646914551	0.25665826814574	true	false	false	true
6a7aeeb2-e141-4e6c-8344-383d26481a05	2026-09-08 10:02	2026-09-08 10:02	2026-09-08 10:02	XLE	XLE261120C00070000	call	70.0000	2026-11-20	1.3500	1.3100	1.3600	65.1076	390805.00	387450.00	3355.00	2895	48	3104	20686	0.150053176061104	0.249723915939346	0.253661759073246	false	false	false	true
2e7d0e9d-9dd1-4422-a8bd-59b3b42055d8	2026-09-08 09:30	2026-09-08 09:30	2026-09-08 09:30	XLE	XLE260918C00063500	call	63.5000	2026-09-18	2.0800	1.8800	2.0800	64.9500	24308.00	24308.00	0.00	117	15	117	801	0.146067415730337	0.27503071820034	0.275825925833261	true	false	false	true
b52765c0-69ec-4e47-b637-c72cef5ec119	2026-09-03 10:58	2026-09-03 10:58	2026-09-03 10:58	XLE	XLE261016C00065000	call	65.0000	2026-10-16	2.4100	2.4000	2.4800	65.3500	15904.00	241.00	15663.00	66	8	156	8182	0.0190662429723784	0.231445569902987	0.232578372132784	false	false	false	true
4d558fce-2b93-4858-804a-ea3fd70449cf	2026-09-03 10:17	2026-09-03 10:17	2026-09-03 10:17	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3500	1.3500	1.3600	65.1000	18969.00	9384.00	9585.00	140	21	10707	3115	3.43723916532905	0.268912665619715	0.269115166689389	true	false	false	true
5b5e9cba-2011-4f33-b09b-3bba63f53847	2026-09-03 10:05	2026-09-03 10:05	2026-09-03 10:05	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3500	1.3400	1.3500	65.1300	28340.00	27000.00	1340.00	210	6	6315	3115	2.02728731942215	0.269084714789706	0.270328288567014	true	false	false	true
35957296-373e-428c-9a6f-1717beab8df3	2026-09-03 10:04	2026-09-03 10:03	2026-09-03 10:03	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3700	1.3600	1.3700	65.1000	11496.00	9864.00	1632.00	84	12	4579	3115	1.46998394863563	0.270356493154601	0.270356493154601	true	false	false	true
1af5f5b7-0aeb-45d6-aee7-6ce540c99a2d	2026-09-03 10:04	2026-09-03 10:03	2026-09-03 10:03	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3600	1.3500	1.3700	65.0900	17171.00	9419.00	2720.00	126	7	4423	3115	1.4199036918138	0.269950964669312	0.269950964669312	true	false	false	true