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

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

c5332f68-f6ea-498a-965a-da604a7632dd	2026-09-11 13:27	2026-09-11 13:27	2026-09-11 13:27	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6000	2.6000	2.6800	172.7400	10141.00	0.00	10141.00	39	13	1722	9478	0.181683899556869	0.206562302651902	0.20696800113098	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	31280067977.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-11T18:02:32.717866Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
376bd388-a487-42ed-a9d0-d97cbaa7ab4f	2026-09-11 13:23	2026-09-11 13:23	2026-09-11 13:23	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.1700	0.1700	0.2000	172.7400	15181.00	0.00	15181.00	893	17	906	53263	0.0170099318476241	0.229569578008406	0.229569578008406	false	false	false	true
0c853c80-ca3a-4ee5-ab40-b697bbc451f2	2026-09-11 13:15	2026-09-11 13:15	2026-09-11 13:15	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6500	2.6300	2.6500	172.6900	11395.00	11395.00	0.00	43	5	822	9478	0.0867271576281916	0.208054077247043	0.208054077247043	false	false	false	true
99c96dba-2c61-4800-b12f-7ed4147e28f4	2026-09-11 13:14	2026-09-11 13:13	2026-09-11 13:13	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6500	2.6200	2.6500	172.6900	11130.00	11130.00	0.00	42	6	721	9478	0.0760709010339734	0.208054077247043	0.208054077247043	true	false	false	true
0731b57e-9dbc-4d8b-b67e-c389af0c4f3c	2026-09-11 13:12	2026-09-11 13:11	2026-09-11 13:11	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0700	1.0300	1.0700	172.6794	25252.00	25252.00	0.00	236	6	1443	10063	0.14339660141111	0.233259018414961	0.233259018414961	false	false	false	true
c1b5aa5b-a323-4bda-ba01-ebc0e05ce8cc	2026-09-11 13:11	2026-09-11 13:11	2026-09-11 13:11	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6600	2.6600	2.7400	172.6650	20216.00	0.00	20216.00	76	27	483	9478	0.05096011816839	0.20819064199202	0.20819064199202	false	false	false	true
835e1e4b-c2c4-4bc2-a84f-5e4e67d6a22e	2026-09-11 13:07	2026-09-11 13:07	2026-09-11 13:07	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.7000	2.6600	2.7000	172.5350	20250.00	20250.00	0.00	75	5	282	9478	0.0297531124709854	0.208406188968236	0.208406188968236	false	false	false	true
3eb391ba-aa9a-4958-b927-aec24310cd0d	2026-09-11 13:01	2026-09-11 13:01	2026-09-11 13:01	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0600	1.0600	1.2100	172.6452	24698.00	0.00	24698.00	233	36	235	10063	0.0233528768756832	0.232320203795709	0.232320203795709	false	false	false	true
bac3e5f2-c991-4e38-adf8-a2844f4a0aa9	2026-09-11 13:00	2026-09-11 13:00	2026-09-11 13:00	XLI	XLI260918C00178000	call	178.0000	2026-09-18	0.2300	0.2300	0.2900	172.5950	17457.00	0.00	17457.00	759	21	766	215	3.56279069767442	0.177503232368179	0.177503232368179	false	false	false	true
79f0e0d9-9db9-44c7-a178-757c82973c6e	2026-09-11 12:51	2026-09-11 12:51	2026-09-11 12:51	XLI	XLI270319P00163000	put	163.0000	2027-03-19	5.0500	4.9000	5.0500	172.6100	37370.00	37370.00	0.00	74	17	148	98	1.51020408163265	0.217098268453738	0.217098268453738	false	false	false	true
e39375cf-caa3-4e33-9eee-7b4b3cb69676	2026-09-11 12:44	2026-09-11 12:44	2026-09-11 12:44	XLI	XLI261016C00178000	call	178.0000	2026-10-16	1.7400	1.7400	1.8000	172.5600	25926.00	0.00	25926.00	149	24	159	1577	0.100824350031706	0.168175548952241	0.168175548952241	false	false	false	true
b4b2ef20-d7b6-4357-bd28-8762edf81495	2026-09-11 12:44	2026-09-11 12:44	2026-09-11 12:44	XLI	XLI261016C00173000	call	173.0000	2026-10-16	3.7500	3.7500	3.9000	172.5600	25500.00	0.00	25500.00	68	19	72	1362	0.052863436123348	0.17073785836624	0.17073785836624	false	false	false	true
d17e20c5-f68e-4af7-af40-b01f16996b42	2026-09-11 12:44	2026-09-11 12:44	2026-09-11 12:44	XLI	XLI261016P00170000	put	170.0000	2026-10-16	2.8000	2.7900	2.8000	172.5650	26320.00	26320.00	0.00	94	7	145	1858	0.0780409041980624	0.19960538462435	0.19960538462435	false	false	false	true
86934c09-e8d7-4ea1-b9ee-b25799d7c3dc	2026-09-11 11:42	2026-09-11 11:42	2026-09-11 11:42	XLI	XLI261218P00170000	put	170.0000	2026-12-18	5.1500	5.1500	5.2500	172.5000	106605.00	0.00	106605.00	207	34	220	8644	0.025451180009255	0.2023587672501	0.2023587672501	false	false	false	true
6903e1b0-34e1-4a3f-b2c3-3ae9c36e9568	2026-09-11 11:40	2026-09-11 11:40	2026-09-11 11:40	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.7800	2.7400	3.0500	172.4850	13615.00	560.00	13055.00	49	14	49	9478	0.0051698670605613	0.211071229875123	0.209871650960744	true	false	false	true
3bf7eb75-3164-4701-b9a2-c650c1ba276f	2026-09-11 11:14	2026-09-11 11:14	2026-09-11 11:14	XLI	XLI261023C00180000	call	180.0000	2026-10-23	1.4600	1.4500	1.6000	172.0350	14016.00	730.00	13286.00	96	28	115	8	14.375	0.171375425992624	0.171375425992624	true	false	false	true
82005220-7f68-4259-b972-1fc698383507	2026-09-11 10:31	2026-09-11 10:31	2026-09-11 10:31	XLI	XLI261218C00170000	call	170.0000	2026-12-18	8.9500	8.9500	9.4000	172.1300	17005.00	0.00	17005.00	19	11	69	1366	0.0505124450951684	0.192451070903632	0.192451070903632	false	false	false	true
4555b57d-d67a-4364-8eaf-0229bddc0aad	2026-09-11 10:29	2026-09-11 10:29	2026-09-11 10:29	XLI	XLI261120C00180000	call	180.0000	2026-11-20	2.9900	2.9900	3.1500	172.3200	196443.00	0.00	196443.00	657	55	657	497	1.32193158953722	0.182259017138594	0.182259017138594	false	false	false	true
c630b9b4-103a-4f0b-9394-ccf57d89b321	2026-09-11 10:22	2026-09-11 10:21	2026-09-11 10:21	XLI	XLI261016C00180000	call	180.0000	2026-10-16	1.3300	1.3300	1.4700	172.5000	38703.00	0.00	38703.00	291	42	298	237	1.25738396624473	0.175087223645528	0.175087223645528	false	false	false	true
59cf0a59-53ce-4bba-bf1b-24d2a693c9eb	2026-09-11 10:20	2026-09-11 10:19	2026-09-11 10:19	XLI	XLI261120P00161000	put	161.0000	2026-11-20	1.9800	1.9800	1.9900	172.5100	18216.00	0.00	18216.00	92	9	92	106	0.867924528301887	0.222181639939114	0.222181639939114	false	false	false	true
dd90a316-202d-4acb-9c98-cdd8ad2c7d55	2026-09-11 10:17	2026-09-11 10:16	2026-09-11 10:16	XLI	XLI261120C00175000	call	175.0000	2026-11-20	5.1000	5.1000	5.3000	172.4000	39270.00	0.00	39270.00	77	17	106	353	0.30028328611898	0.188911340116966	0.188911340116966	false	false	false	true
3354e905-5137-41aa-bcbc-8a3e80d099ef	2026-09-11 10:13	2026-09-11 10:13	2026-09-11 10:13	XLI	XLI261016C00170000	call	170.0000	2026-10-16	5.6000	5.3500	5.6000	172.5000	28000.00	28000.00	0.00	50	16	56	11	5.09090909090909	0.180869652769746	0.180869652769746	true	false	false	true
a7949d73-05b4-4d0e-938e-eeb8f9d454d6	2026-09-11 09:33	2026-09-11 09:33	2026-09-11 09:33	XLI	XLI261218C00170000	call	170.0000	2026-12-18	9.0000	8.8500	9.7000	172.0000	35105.00	1805.00	33300.00	39	16	39	1366	0.0285505124450952	0.191577676298373	0.192298715919438	false	false	false	true
1c264ca9-30f4-4552-a4d3-642e704fab2b	2026-09-11 09:33	2026-09-11 09:33	2026-09-11 09:33	XLI	XLI261218C00169000	call	169.0000	2026-12-18	9.6000	9.6000	9.8000	172.0000	12480.00	0.00	12480.00	13	6	13	1	13	0.192108265880617	0.192108265880617	false	false	false	true
ca948467-a602-4e48-961a-271ca9a27cb0	2026-09-10 15:05	2026-09-10 15:05	2026-09-10 15:05	XLI	XLI261016P00170000	put	170.0000	2026-10-16	4.0000	3.9000	4.0000	170.0210	32399.00	32399.00	0.00	81	29	249	1589	0.156702328508496	0.203751399003134	0.203751399003134	true	false	false	true
27c1b8cf-864c-4b44-97c1-c01f80a6ed84	2026-09-10 15:05	2026-09-10 15:05	2026-09-10 15:05	XLI	XLI261016P00170000	put	170.0000	2026-10-16	3.9500	3.9000	4.0000	170.0200	43845.00	38710.00	0.00	111	18	137	1589	0.0862177470106986	0.201371844726593	0.201371844726593	true	false	false	true
67f9e529-f1e7-4a16-9dbe-73f13dc1133a	2026-09-10 14:44	2026-09-10 14:44	2026-09-10 14:44	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.4500	3.4500	3.6000	170.2393	57960.00	0.00	57960.00	168	6	1508	10004	0.150739704118353	0.209861546543365	0.209861546543365	false	false	false	true
11140250-b3b9-4da7-bb94-d429d41ea911	2026-09-10 14:44	2026-09-10 14:44	2026-09-10 14:44	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.4500	3.4500	3.6000	170.2393	38985.00	0.00	38985.00	113	16	1340	10004	0.133946421431427	0.209861546543365	0.209861546543365	false	false	false	true
e07d7eaa-b49b-48c0-8712-bc5c959aefb6	2026-09-10 13:21	2026-09-10 13:21	2026-09-10 13:21	XLI	XLI260925C00180000	call	180.0000	2026-09-25	0.2300	0.2300	0.3600	170.4900	10097.00	0.00	10097.00	439	20	444	35	12.6857142857143	0.183520088849977	0.183520088849977	false	false	false	true
5ef4263e-74a1-4636-af06-0e1c7857a2ba	2026-09-10 12:16	2026-09-10 12:16	2026-09-10 12:16	XLI	XLI270115C00190000	call	190.0000	2027-01-15	1.9300	1.8100	1.9300	170.6400	28950.00	28950.00	0.00	150	20	312	497	0.627766599597586	0.178479621726625	0.178479621726625	false	false	false	true
7e9ed0da-26a6-4dfa-8580-6100abfde58f	2026-09-10 11:59	2026-09-10 11:58	2026-09-10 11:58	XLI	XLI270319C00183000	call	183.0000	2027-03-19	5.7500	5.5500	5.7500	170.6600	29893.00	29893.00	0.00	52	17	54	5	10.8	0.186145173465647	0.186145173465647	false	false	false	true
5d00301f-db77-4c3e-9e86-e08d926e1301	2026-09-10 10:57	2026-09-10 10:57	2026-09-10 10:57	XLI	XLI261009P00172000	put	172.0000	2026-10-09	3.9500	3.7000	4.0000	171.1750	104270.00	103490.00	0.00	264	14	319	5	63.8	0.197030559411347	0.197030559411347	false	false	false	true
cfcf5264-5416-4a6a-8cf6-f8887cd2674a	2026-09-10 10:48	2026-09-10 10:47	2026-09-10 10:47	XLI	XLI261016C00167000	call	167.0000	2026-10-16	6.6000	6.6000	7.0500	170.8750	15180.00	0.00	15180.00	23	9	23	5	4.6	0.186209425988935	0.186209425988935	true	false	false	true
76c68a70-6980-48e5-a9f7-fc8c6f442fc1	2026-09-10 10:29	2026-09-10 10:29	2026-09-10 10:29	XLI	XLI261120P00161000	put	161.0000	2026-11-20	2.2800	2.1200	2.2800	171.3600	23028.00	23028.00	0.00	101	27	101	8	12.625	0.223177250520999	0.223177250520999	false	false	false	true
0282e9a0-3dcc-4307-9278-1e5c91a31a1e	2026-09-10 10:26	2026-09-10 10:25	2026-09-10 10:25	XLI	XLI261120P00163000	put	163.0000	2026-11-20	2.6900	2.5500	2.6900	171.5300	23134.00	23134.00	0.00	86	22	87	173	0.502890173410405	0.219473309872681	0.219473309872681	false	false	false	true
48a7a560-22ba-426b-8345-aa19ab1733c1	2026-09-10 10:25	2026-09-10 10:25	2026-09-10 10:25	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.3800	1.2500	1.3800	171.3300	10074.00	10074.00	0.00	73	6	471	5418	0.0869324473975637	0.201651473855499	0.201651473855499	false	false	false	true
2d847728-673c-4ea7-894e-a1db69091a6a	2026-09-10 10:23	2026-09-10 10:23	2026-09-10 10:23	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5600	1.5400	1.5600	170.9000	11544.00	8424.00	0.00	74	5	398	5418	0.0734588409007014	0.202605581393321	0.202605581393321	false	false	false	true
77001dc0-429c-48f1-8a60-e7a899adcf80	2026-09-10 10:23	2026-09-10 10:23	2026-09-10 10:23	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5600	1.4900	1.5600	170.8700	15600.00	10452.00	0.00	100	6	113	5418	0.0208564045773348	0.201344933328471	0.201344933328471	false	false	false	true
3bb23a4f-5551-4a6f-8828-b9ca79701f2b	2026-09-10 10:17	2026-09-10 10:17	2026-09-10 10:17	XLI	XLI261023C00170000	call	170.0000	2026-10-23	5.1500	4.6500	5.1500	170.7500	13390.00	13390.00	0.00	26	7	26	0	0	0.186460444695591	0.186460444695591	false	false	false	true
5c3c20b8-092f-4b89-ab8b-cf99e2a6b1b6	2026-09-10 10:09	2026-09-10 10:09	2026-09-10 10:09	XLI	XLI261120C00171000	call	171.0000	2026-11-20	6.1500	6.0000	6.1500	170.3200	44280.00	44280.00	0.00	72	15	96	57	1.68421052631579	0.19496649257848	0.19496649257848	true	false	false	true
416d4d2e-4f26-446d-9408-064520cbe848	2026-09-10 10:08	2026-09-10 10:08	2026-09-10 10:08	XLI	XLI261120P00150000	put	150.0000	2026-11-20	0.8700	0.6400	0.8700	170.4000	61770.00	61770.00	0.00	710	23	1462	254	5.75590551181102	0.245190503991472	0.245190503991472	false	false	false	true
e357fcad-5440-4f51-abdc-8e59c176e84e	2026-09-10 10:08	2026-09-10 10:08	2026-09-10 10:08	XLI	XLI261120P00150000	put	150.0000	2026-11-20	0.8700	0.6400	0.8700	170.4000	65250.00	65250.00	0.00	750	37	752	254	2.96062992125984	0.245190503991472	0.245190503991472	false	false	false	true
fa984539-0a8a-4b01-8b9a-58e776e1a6f3	2026-09-10 09:54	2026-09-10 09:54	2026-09-10 09:54	XLI	XLI261218P00167000	put	167.0000	2026-12-18	4.9500	4.9000	5.0500	170.2100	75735.00	74745.00	990.00	153	27	153	102	1.5	0.206489166469547	0.206489166469547	false	false	false	true
6d99e2f4-455f-41b6-a457-7a91197cb9b6	2026-09-10 09:54	2026-09-10 09:54	2026-09-10 09:54	XLI	XLI261218P00162000	put	162.0000	2026-12-18	3.3200	3.3000	3.3500	170.2100	102535.00	37855.00	64680.00	309	15	309	88	3.51136363636364	0.212209796700862	0.212209796700862	false	false	false	true
d78924a6-7653-4617-a1bd-90a90004f58a	2026-09-09 15:43	2026-09-09 15:43	2026-09-09 15:43	XLI	XLI261120C00175000	call	175.0000	2026-11-20	4.9500	4.9000	5.1000	172.0300	37125.00	0.00	37125.00	75	21	127	277	0.458483754512635	0.186877531603348	0.186877531603348	false	false	false	true
0dacd640-6868-48f9-94e4-d8b5488d9fc9	2026-09-09 15:34	2026-09-09 15:34	2026-09-09 15:34	XLI	XLI270319C00176000	call	176.0000	2027-03-19	9.2500	9.0500	9.2500	172.1000	16650.00	16650.00	0.00	18	7	44	61	0.721311475409836	0.192775967492711	0.192775967492711	false	false	false	true
5d82e7d0-97fe-4676-b199-d2bf4882ab06	2026-09-09 14:20	2026-09-09 14:20	2026-09-09 14:20	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.9300	2.9200	2.9800	172.0950	58600.00	0.00	58307.00	200	10	987	10554	0.0935190449118817	0.209976670051296	0.209976670051296	false	false	false	true
9b38a09c-8748-4de6-a94f-108d3c535f98	2026-09-09 13:19	2026-09-09 13:19	2026-09-09 13:19	XLI	XLI261120P00175000	put	175.0000	2026-11-20	6.8500	6.6500	6.9000	172.4650	13695.00	12330.00	1365.00	20	9	104	12891	0.00806764409277791	0.203643786287411	0.203643786287411	true	false	false	true
b526ae96-f7f9-42a9-bf37-353781631b1d	2026-09-09 12:25	2026-09-09 12:25	2026-09-09 12:25	XLI	XLI261120P00171000	put	171.0000	2026-11-20	5.0000	4.9500	5.1500	172.1600	11500.00	1000.00	8000.00	23	12	25	1089	0.0229568411386593	0.203558909550011	0.203558909550011	false	false	false	true
5d05580f-20fc-4a99-8e2d-0efdee5b458d	2026-09-09 12:25	2026-09-09 12:25	2026-09-09 12:25	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.6000	4.5500	4.7500	172.1600	29440.00	1380.00	28060.00	64	8	155	55377	0.00279899597305741	0.204843728206309	0.204843728206309	false	false	false	true