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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

64ee355f-2f57-4644-9c9c-447aa3516ad4	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.7400	0.7100	0.7400	62.4250	93832.00	93832.00	0.00	1268	57	18175	44137	0.411786029861567	0.272032519824827	0.272032519824827	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	41312140321.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:59:07.811004Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
2e919087-261e-456c-b124-fa2f23a12e52	2026-09-21 15:58	2026-09-21 15:58	2026-09-21 15:58	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.7400	0.7100	0.7400	62.4210	89984.00	89984.00	0.00	1216	11	19391	44137	0.439336611006638	0.271834675172785	0.271834675172785	true	false	false	true
cfcebd4c-6edf-45b3-aa53-ad0de227d2de	2026-09-21 15:57	2026-09-21 15:57	2026-09-21 15:57	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.7300	0.7100	0.7300	62.4200	182500.00	182500.00	0.00	2500	56	16907	44137	0.383057298864898	0.269912039482488	0.269912039482488	true	false	false	true
45ee7b5b-05c1-423f-9a13-b5071d3107b2	2026-09-21 15:57	2026-09-21 15:57	2026-09-21 15:57	XLE	XLE261120C00075000	call	75.0000	2026-11-20	0.2600	0.2400	0.2600	62.4450	26000.00	26000.00	0.00	1000	17	3761	11911	0.315758542523718	0.296907849332273	0.297007739080376	false	false	false	true
f2cfdce0-3824-4a12-8f2d-8620ec934963	2026-09-21 15:57	2026-09-21 15:56	2026-09-21 15:56	XLE	XLE261218C00075000	call	75.0000	2026-12-18	0.5100	0.5100	0.5600	62.4900	17646.00	0.00	17646.00	346	7	657	11331	0.0579825258141382	0.286742869348268	0.286742869348268	false	false	false	true
ffb9008f-1996-4913-91bc-225255c3119c	2026-09-21 15:56	2026-09-21 15:56	2026-09-21 15:56	XLE	XLE261218C00065000	call	65.0000	2026-12-18	2.5100	2.5000	2.5400	62.4850	13303.00	251.00	12801.00	53	6	436	40186	0.0108495495943861	0.270872143039428	0.270872143039428	false	false	false	true
06f40cb5-8660-4720-a2e0-65535c1aa87a	2026-09-21 15:55	2026-09-21 15:55	2026-09-21 15:55	XLE	XLE261120C00075000	call	75.0000	2026-11-20	0.2600	0.2500	0.2600	62.0000	26000.00	26000.00	0.00	1000	6	2761	11911	0.231802535471413	0.295307819493836	0.295307819493836	false	false	false	true
97d9147b-bf4e-441a-9322-f2907f2e690a	2026-09-21 15:51	2026-09-21 15:51	2026-09-21 15:51	XLE	XLE261016C00066000	call	66.0000	2026-10-16	0.6100	0.6000	0.6100	62.5099	39711.00	39711.00	0.00	651	34	2713	8006	0.338870846864851	0.269079485022151	0.269079485022151	true	false	false	true
4c5356ab-6794-46cf-9581-c3b5e08d92bf	2026-09-21 15:40	2026-09-21 15:40	2026-09-21 15:40	XLE	XLE261030C00063500	call	63.5000	2026-10-30	1.9100	1.8900	1.9500	62.5900	29987.00	191.00	29796.00	157	9	273	1	273	0.269716987434971	0.269716987434971	true	false	false	true
d4922a62-5d9f-46fd-8ae0-0f85eefae7c4	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.5500	0.5500	0.5600	62.5850	34210.00	0.00	34210.00	622	9	3421	7746	0.441647301833204	0.315246110513564	0.315246110513564	false	false	false	true
6777d363-ad23-4c78-8dfc-0db2592608fc	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	XLE	XLE260930P00061000	put	61.0000	2026-09-30	0.4500	0.4400	0.5100	62.5850	20205.00	90.00	20115.00	449	24	460	5066	0.0908014212396368	0.278844006738419	0.278844006738419	true	false	false	true
c379ea10-57e0-44ff-b8a2-eeb7cb45c7ae	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	XLE	XLE261016P00060500	put	60.5000	2026-10-16	0.8500	0.8500	0.8800	62.5850	45645.00	0.00	45645.00	537	10	3590	0	0	0.272713621269526	0.272713621269526	false	false	false	true
bd76827c-52eb-4520-9da2-05d52b87c3ab	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	XLE	XLE261016P00061000	put	61.0000	2026-10-16	1.0100	1.0100	1.0400	62.5850	43026.00	0.00	43026.00	426	11	1053	6279	0.167701863354037	0.271315341553182	0.271315341553182	false	false	false	true
75613d4a-36f2-43bd-88fe-983c2bf3d95d	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	XLE	XLE261016P00062500	put	62.5000	2026-10-16	1.6300	1.6300	1.6600	62.5850	31622.00	0.00	31622.00	194	17	1581	0	0	0.269093933574497	0.269093933574497	false	false	false	true
67b91120-c5c4-4ed5-8ce8-f4d8fb958fad	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.8800	1.8800	1.8900	62.5850	55460.00	0.00	55460.00	295	6	3861	48625	0.0794035989717224	0.268164811121975	0.268164811121975	false	false	false	true
23139af4-3fd7-4c22-ad4a-d2fe9733d711	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	XLE	XLE261009P00061000	put	61.0000	2026-10-09	0.7900	0.7900	0.8000	62.5850	28756.00	0.00	28756.00	364	13	550	329	1.67173252279635	0.27242933056942	0.27242933056942	false	false	false	true
907ed73e-8cc4-4ae4-8f22-27986e822a9d	2026-09-21 15:33	2026-09-21 15:33	2026-09-21 15:33	XLE	XLE261002P00057000	put	57.0000	2026-10-02	0.0700	0.0500	0.0800	62.0000	31052.00	31045.00	7.00	4436	61	4530	13	348.461538461538	0.324157651426527	0.324157651426527	false	false	false	true
ecc2e353-e65e-45e4-b925-24da98360152	2026-09-21 15:32	2026-09-21 15:32	2026-09-21 15:32	XLE	XLE260923C00063000	call	63.0000	2026-09-23	0.3800	0.3800	0.3900	62.0000	14858.00	0.00	14858.00	391	16	3143	345	9.11014492753623	0.330993768216889	0.330993768216889	true	false	false	true
70b38374-3b49-4f0d-bee4-5d8cf495dbb4	2026-09-21 15:32	2026-09-21 15:32	2026-09-21 15:32	XLE	XLE260923P00062000	put	62.0000	2026-09-23	0.4300	0.3900	0.4400	62.0000	35948.00	43.00	35905.00	836	27	17065	6594	2.58795875037913	0.344538336555942	0.344538336555942	true	false	false	true
1aa3be15-9bdc-427b-97c4-b5a0837ba26d	2026-09-21 15:32	2026-09-21 15:32	2026-09-21 15:32	XLE	XLE261120C00064000	call	64.0000	2026-11-20	2.2500	2.2400	2.2800	62.0000	21600.00	4950.00	16650.00	96	18	636	128	4.96875	0.271929688138785	0.271929688138785	false	false	false	true
c610305a-7988-45c5-bea3-d2104a05c1cb	2026-09-21 15:31	2026-09-21 15:31	2026-09-21 15:31	XLE	XLE260923P00062000	put	62.0000	2026-09-23	0.4600	0.4500	0.4600	62.0000	12190.00	12190.00	0.00	265	8	16183	6594	2.45420078859569	0.354945023876962	0.354945023876962	true	false	false	true
f854b434-0c58-4cea-9c0f-39cc41c69c7b	2026-09-21 15:31	2026-09-21 15:31	2026-09-21 15:31	XLE	XLE260923P00062000	put	62.0000	2026-09-23	0.4600	0.4400	0.4600	62.0000	10258.00	10258.00	0.00	223	11	15529	6594	2.35501971489233	0.354945023876962	0.354945023876962	true	false	false	true
d8a9b02d-5bd6-4119-9ebe-21e72f85df3c	2026-09-21 15:31	2026-09-21 15:31	2026-09-21 15:31	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.7800	0.7700	0.7800	62.0000	156000.00	156000.00	0.00	2000	27	13308	44137	0.301515735097537	0.278234259690338	0.278234259690338	true	false	false	true
8b716147-b9e5-4d44-a1be-3fb00aeede03	2026-09-21 15:31	2026-09-21 15:30	2026-09-21 15:30	XLE	XLE260923P00062000	put	62.0000	2026-09-23	0.4500	0.4300	0.4500	62.0000	22860.00	22860.00	0.00	508	15	14833	6594	2.24946921443737	0.343783127414057	0.343783127414057	true	false	false	true
cf08c28b-f5cf-4327-9a42-7ee2e6944176	2026-09-21 15:27	2026-09-21 15:27	2026-09-21 15:27	XLE	XLE260923P00062000	put	62.0000	2026-09-23	0.4000	0.3800	0.4000	62.4890	11120.00	11120.00	0.00	278	17	11825	6594	1.79329693660904	0.336836223613995	0.336836223613995	true	false	false	true
a7ed4107-2654-4317-b6ac-93310d5dbbd8	2026-09-21 15:25	2026-09-21 15:25	2026-09-21 15:25	XLE	XLE261009C00063000	call	63.0000	2026-10-09	1.3700	1.3400	1.3800	62.5200	17810.00	12604.00	0.00	130	16	557	119	4.68067226890756	0.279336101867304	0.277618585837002	true	false	false	true
eee63fff-8b2c-45b3-a5a2-864d21329247	2026-09-21 15:25	2026-09-21 15:25	2026-09-21 15:25	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.7500	0.7300	0.7500	62.4990	133800.00	133800.00	0.00	1784	9	11304	44137	0.256111652355167	0.277557460428021	0.277557460428021	true	false	false	true
5cc4a8cc-53d8-43a3-97b5-82df194a8c9d	2026-09-21 15:25	2026-09-21 15:25	2026-09-21 15:25	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.7500	0.7300	0.7500	62.4990	16200.00	16200.00	0.00	216	23	9520	44137	0.215692049754174	0.277557460428021	0.277557460428021	true	false	false	true
a0f2e70f-0851-4926-bd96-bc9dda9458d6	2026-09-21 15:25	2026-09-21 15:25	2026-09-21 15:25	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.7400	0.7300	0.7400	62.4950	48914.00	48914.00	0.00	661	30	8763	44137	0.198540906722251	0.275483248025739	0.275483248025739	true	false	false	true
5cc265db-7ad8-456f-b039-847fa4ff1834	2026-09-21 15:25	2026-09-21 15:25	2026-09-21 15:25	XLE	XLE261030P00062500	put	62.5000	2026-10-30	2.0600	2.0200	2.0600	62.4950	279542.00	279542.00	0.00	1357	8	1471	1	1471	0.269570458357346	0.269570458357346	false	false	false	true
3b5ac222-7d0c-4e70-99fb-4cc3863f9b65	2026-09-21 15:25	2026-09-21 15:24	2026-09-21 15:24	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.7300	0.7000	0.7300	62.5050	48764.00	48764.00	0.00	668	26	7471	44137	0.169268414255613	0.274091418082951	0.274091418082951	true	false	false	true
774b157d-b9b9-4ad3-96d0-1141331bdd82	2026-09-21 15:22	2026-09-21 15:22	2026-09-21 15:22	XLE	XLE261016C00065000	call	65.0000	2026-10-16	0.9200	0.9100	0.9200	62.6250	88044.00	88044.00	0.00	957	5	5629	18261	0.308252560100761	0.272265784306224	0.272265784306224	true	false	false	true
1841a046-56ff-43fa-a4ff-ab166aef3071	2026-09-21 15:21	2026-09-21 15:21	2026-09-21 15:21	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.5200	0.5000	0.5200	62.6650	101296.00	101296.00	0.00	1948	29	2709	7746	0.349728892331526	0.315062085439232	0.315062085439232	true	false	false	true
245e4a18-ef03-4d47-91dd-4f0e3e93fc1e	2026-09-21 15:09	2026-09-21 15:09	2026-09-21 15:09	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.5000	1.4700	1.5000	62.7500	168600.00	168600.00	0.00	1124	7	2749	19916	0.138029724844346	0.261087571771111	0.261087571771111	false	false	false	true
b8eb19a9-66d7-4cbe-94e3-b900749883cf	2026-09-21 15:09	2026-09-21 15:08	2026-09-21 15:08	XLE	XLE261016C00065000	call	65.0000	2026-10-16	0.9600	0.9500	0.9600	62.7850	30336.00	30336.00	0.00	316	33	3937	18261	0.215596079075626	0.270048453905935	0.270048453905935	true	false	false	true
3a99655e-e2a3-45ec-8122-999186c6dca3	2026-09-21 15:08	2026-09-21 15:08	2026-09-21 15:08	XLE	XLE260925C00063000	call	63.0000	2026-09-25	0.7100	0.7100	0.7200	62.7950	10792.00	0.00	10792.00	152	5	1076	128	8.40625	0.302974370523673	0.302974370523673	false	false	false	true
327753ab-2fc7-4fc9-b4d4-6ba25f083ba7	2026-09-21 15:08	2026-09-21 15:08	2026-09-21 15:08	XLE	XLE260925C00063000	call	63.0000	2026-09-25	0.7100	0.7100	0.7200	62.7950	13703.00	0.00	13703.00	193	8	924	128	7.21875	0.302974370523673	0.302974370523673	false	false	false	true
df1d55f3-2126-48ef-906f-b20102ffc96f	2026-09-21 15:07	2026-09-21 15:07	2026-09-21 15:07	XLE	XLE261218C00066000	call	66.0000	2026-12-18	2.3000	2.3000	2.3400	62.8350	10350.00	0.00	10350.00	45	10	152	3528	0.0430839002267574	0.271758739010003	0.271758739010003	false	false	false	true
13bbab3d-4b7e-4831-87e1-6cc327883ab9	2026-09-21 15:07	2026-09-21 15:07	2026-09-21 15:07	XLE	XLE270115P00045000	put	45.0000	2027-01-15	0.1000	0.0900	0.1000	62.8324	19190.00	19190.00	0.00	1919	21	8362	55846	0.149733194857286	0.320888906402384	0.320888906402384	true	false	false	true
1f08ffb5-5c82-4288-94f7-3faca3e449dc	2026-09-21 15:07	2026-09-21 15:06	2026-09-21 15:06	XLE	XLE270115P00045000	put	45.0000	2027-01-15	0.1000	0.0800	0.1000	62.8750	18900.00	18900.00	0.00	1890	35	6410	55846	0.114779930523225	0.321393494071119	0.321393494071119	true	false	false	true
dc32551c-9fb7-472b-b680-3167fe5fc959	2026-09-21 15:06	2026-09-21 15:06	2026-09-21 15:06	XLE	XLE261016C00065000	call	65.0000	2026-10-16	0.9700	0.9600	0.9700	62.8650	44135.00	43553.00	0.00	455	10	3553	18261	0.194567657850063	0.267185399957587	0.267185399957587	true	false	false	true
b67d3cd6-11f2-4ead-8188-f7a027e498a9	2026-09-21 15:06	2026-09-21 15:06	2026-09-21 15:06	XLE	XLE261016C00065000	call	65.0000	2026-10-16	0.9700	0.9600	0.9700	62.8699	47724.00	47724.00	0.00	492	46	3098	18261	0.169651169158316	0.266907387174649	0.266907387174649	true	false	false	true
4a8c4e33-3908-4244-a5b1-c59ad3971a17	2026-09-21 14:59	2026-09-21 14:59	2026-09-21 14:59	XLE	XLE261030P00063000	put	63.0000	2026-10-30	2.0800	2.0400	2.0800	62.8900	98800.00	98800.00	0.00	475	30	597	157	3.80254777070064	0.264010835014374	0.264010835014374	false	false	false	true
6bef7cfa-c2c9-4085-bdce-d5c7fad7ad1f	2026-09-21 14:55	2026-09-21 14:55	2026-09-21 14:55	XLE	XLE270115P00062500	put	62.5000	2027-01-15	3.3000	3.2500	3.3000	62.9300	39600.00	39600.00	0.00	120	15	442	2827	0.156349487088787	0.278698074862914	0.278698074862914	false	false	false	true
1fdc79a3-2c15-4e1f-b592-ea7b816fc6c9	2026-09-21 14:51	2026-09-21 14:51	2026-09-21 14:51	XLE	XLE270115P00045000	put	45.0000	2027-01-15	0.0900	0.0800	0.0900	62.9550	12357.00	12357.00	0.00	1373	13	3374	55846	0.060416144397092	0.316812290643725	0.316812290643725	true	false	false	true
6bd7768a-551f-469a-b2c8-ce40000b6b92	2026-09-21 14:49	2026-09-21 14:49	2026-09-21 14:49	XLE	XLE270115P00045000	put	45.0000	2027-01-15	0.0900	0.0900	0.1000	62.0000	13869.00	0.00	36.00	1541	95	1572	55846	0.0281488378755864	0.316987425675548	0.316987425675548	false	false	false	true
5eece057-910f-42bd-bb09-05ad31842064	2026-09-21 14:43	2026-09-21 14:43	2026-09-21 14:43	XLE	XLE261016C00064500	call	64.5000	2026-10-16	1.1500	1.1200	1.1500	62.9600	19665.00	19665.00	0.00	171	5	387	0	0	0.263173297950229	0.263173297950229	false	false	false	true
832ae459-a757-4c8f-8326-6859c7747ad4	2026-09-21 14:33	2026-09-21 14:33	2026-09-21 14:33	XLE	XLE261218P00064000	put	64.0000	2026-12-18	3.6000	3.5500	3.6000	62.9150	118080.00	118080.00	0.00	328	26	361	2887	0.1250432975407	0.272721542285465	0.272721542285465	true	false	false	true
919ba3d2-207e-4407-b0e5-36e1da9d80e3	2026-09-21 14:17	2026-09-21 14:17	2026-09-21 14:17	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.5000	1.4800	1.5000	62.8850	97050.00	97050.00	0.00	647	19	1597	19916	0.0801867844948785	0.257900779638143	0.257900779638143	false	false	false	true
d640bf37-c8ab-4e1e-a649-aca513fdf77c	2026-09-21 14:12	2026-09-21 14:12	2026-09-21 14:12	XLE	XLE261016P00059000	put	59.0000	2026-10-16	0.4300	0.4300	0.4400	62.8350	10750.00	0.00	10750.00	250	21	534	15627	0.0341716260318679	0.275208780377168	0.275208780377168	true	false	false	true