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

eceab7b7-893e-494d-bf64-2d3cb75eae7c	2026-09-18 15:14	2026-09-18 15:14	2026-09-18 15:14	XLI	XLI261218C00173000	call	173.0000	2026-12-18	5.4500	5.3000	5.4500	169.5000	15260.00	15260.00	0.00	28	5	128	1079	0.118628359592215	0.184450345844278	0.184450345844278	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30543164756.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T19:21:35.220831Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
8a6d1ecf-0f97-4470-b824-2d4e7bac17d7	2026-09-18 14:37	2026-09-18 14:37	2026-09-18 14:37	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.4000	5.3000	5.4000	169.2800	53458.00	53458.00	0.00	99	30	195	55346	0.0035232898493116	0.201331286585907	0.201331286585907	false	false	false	true
f8dffb68-1dc6-47b5-ae92-c4c879ce4301	2026-09-18 14:19	2026-09-18 14:18	2026-09-18 14:18	XLI	XLI260925C00174000	call	174.0000	2026-09-25	0.2200	0.2200	0.2700	169.1100	26664.00	0.00	26664.00	1212	11	1217	521	2.33589251439539	0.166429130831807	0.166429130831807	false	false	false	true
ba4b22b0-a823-4f26-9dcd-7d6c69db5eb4	2026-09-18 13:38	2026-09-18 13:38	2026-09-18 13:38	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.5500	5.5000	5.5500	168.8599	43845.00	43845.00	0.00	79	25	88	55346	0.00158999747045857	0.199550308320612	0.199550308320612	false	false	false	true
b98aad7e-c860-4294-b380-bd2ba47aff34	2026-09-18 13:38	2026-09-18 13:37	2026-09-18 13:37	XLI	XLI261016C00167000	call	167.0000	2026-10-16	4.4500	4.4500	4.6000	168.8650	16465.00	0.00	16465.00	37	10	58	24	2.41666666666667	0.168475962941977	0.168475962941977	true	false	false	true
763f4ca0-e9eb-4762-b430-021fc54c64ae	2026-09-18 12:55	2026-09-18 12:55	2026-09-18 12:55	XLI	XLI270319P00168000	put	168.0000	2027-03-19	7.7500	7.5500	7.7500	168.9650	31000.00	31000.00	0.00	40	12	40	51	0.784313725490196	0.210747605317896	0.210747605317896	true	false	false	true
6b9cd79c-566f-4245-aab5-364d07aa0dcd	2026-09-18 12:53	2026-09-18 12:53	2026-09-18 12:53	XLI	XLI280121P00125000	put	125.0000	2028-01-21	2.3700	2.3700	2.6400	169.0000	40290.00	0.00	40290.00	170	18	443	8	55.375	0.261667257387384	0.261667257387384	false	false	false	true
aff691b4-2dc2-49e9-9d3e-4c8967893ff6	2026-09-18 12:50	2026-09-18 12:50	2026-09-18 12:50	XLI	XLI280121P00125000	put	125.0000	2028-01-21	2.3800	2.3700	2.6400	168.8900	17620.00	1198.00	16422.00	74	13	229	8	28.625	0.26167683003552	0.26167683003552	false	false	false	true
12cd96a1-e211-45c5-9428-efbad7503b43	2026-09-18 11:45	2026-09-18 11:45	2026-09-18 11:45	XLI	XLI260925P00162000	put	162.0000	2026-09-25	0.2200	0.2200	0.2400	168.5800	29524.00	0.00	29524.00	1342	28	1383	23	60.1304347826087	0.22157008689743	0.22157008689743	false	false	false	true
0001a9af-183e-4a86-9f23-c677a544676c	2026-09-18 11:03	2026-09-18 11:03	2026-09-18 11:03	XLI	XLI261016C00166000	call	166.0000	2026-10-16	5.0000	4.9500	5.4500	168.6550	19500.00	0.00	18000.00	39	16	39	24	1.625	0.17189472019836	0.17189472019836	true	false	false	true
4d5be73c-5e82-4a28-a29d-a6fbb6e07d37	2026-09-18 10:04	2026-09-18 10:04	2026-09-18 10:04	XLI	XLI270115C00195000	call	195.0000	2027-01-15	0.8500	0.7200	0.8500	168.6500	22355.00	22355.00	0.00	263	36	515	545	0.944954128440367	0.178243398471036	0.178243398471036	false	false	false	true
cf556166-c4fe-4e7d-b666-7a37106ffd84	2026-09-18 09:52	2026-09-18 09:52	2026-09-18 09:52	XLI	XLI261016C00176000	call	176.0000	2026-10-16	0.9300	0.9300	0.9700	168.9500	12276.00	0.00	12276.00	132	14	453	166	2.7289156626506	0.16720785858936	0.16720785858936	true	false	false	true
887b1546-81d5-42ad-aae1-dc101305a269	2026-09-18 09:45	2026-09-18 09:45	2026-09-18 09:45	XLI	XLI261016P00172000	put	172.0000	2026-10-16	4.8500	4.8000	4.8500	169.2300	25705.00	25705.00	0.00	53	6	97	108	0.898148148148148	0.192126914992861	0.192126914992861	false	false	false	true
5a64172f-2928-47d3-868e-ad322b418ee7	2026-09-18 09:44	2026-09-18 09:44	2026-09-18 09:44	XLI	XLI261016C00176000	call	176.0000	2026-10-16	0.9600	0.9600	1.0600	169.2399	21888.00	0.00	21888.00	228	38	303	166	1.82530120481928	0.164810805974472	0.164810805974472	true	false	false	true
10a0d917-a1a5-42bb-9a4f-d17569d915ae	2026-09-17 14:52	2026-09-17 14:52	2026-09-17 14:52	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.5500	3.4500	3.5500	169.0850	14910.00	14910.00	0.00	42	6	386	9187	0.0420158920213345	0.20910403842003	0.20910403842003	false	false	false	true
e5548e91-5f01-4f4d-96fd-487cc740c01f	2026-09-17 14:52	2026-09-17 14:51	2026-09-17 14:51	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.5500	3.5000	3.5500	169.0900	30175.00	30175.00	0.00	85	30	344	9187	0.0374442146511375	0.209169844192427	0.209169844192427	false	false	false	true
7eaa3ca4-f4c3-45e0-93bd-51b79ce80596	2026-09-17 14:49	2026-09-17 14:49	2026-09-17 14:49	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.5000	3.5000	3.7000	169.1800	24500.00	0.00	24500.00	70	5	232	9187	0.0252530749972788	0.208426399606442	0.208426399606442	false	false	false	true
d89cc3d7-693d-420f-ad4e-851b57bb294a	2026-09-17 12:20	2026-09-17 12:20	2026-09-17 12:20	XLI	XLI261218P00182000	put	182.0000	2026-12-18	14.1000	14.1000	14.7000	169.3000	16920.00	0.00	16920.00	12	8	12	230	0.0521739130434783	0.215218699869649	0.215218699869649	true	false	false	true
e4dd72a3-843f-45e4-a333-a66e954280ab	2026-09-17 11:42	2026-09-17 11:42	2026-09-17 11:42	XLI	XLI261016P00172000	put	172.0000	2026-10-16	5.0600	5.0500	5.3000	169.1800	10125.00	0.00	10125.00	20	5	20	58	0.344827586206897	0.198534207259575	0.2012206703028	false	false	false	true
6f3152e0-62ff-4d03-95c5-d9c25901faf7	2026-09-17 11:40	2026-09-17 11:39	2026-09-17 11:39	XLI	XLI260925C00174000	call	174.0000	2026-09-25	0.3600	0.3600	0.4300	169.0000	18468.00	0.00	18468.00	513	30	519	16	32.4375	0.183775918895005	0.183775918895005	false	false	false	true
a5c036b5-0270-47ee-b3c8-b00c1128d804	2026-09-17 11:33	2026-09-17 11:33	2026-09-17 11:33	XLI	XLI260918C00169000	call	169.0000	2026-09-18	0.9300	0.9300	1.0500	168.9700	10044.00	0.00	10044.00	108	26	135	73	1.84931506849315	0.265221155454407	0.265221155454407	false	false	false	true
eac9bb5d-83e2-488f-8051-615deced58de	2026-09-17 10:34	2026-09-17 10:34	2026-09-17 10:34	XLI	XLI260918P00169000	put	169.0000	2026-09-18	0.7300	0.7300	0.8400	169.3900	10147.00	0.00	10147.00	139	29	145	1321	0.109765329295988	0.260351113699539	0.260351113699539	false	false	false	true
790a4aac-b5cb-418c-b523-8fff9f958d80	2026-09-17 10:28	2026-09-17 10:28	2026-09-17 10:28	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.4000	5.2500	5.4000	169.5399	141480.00	141480.00	0.00	262	46	273	55368	0.00493064586042479	0.204487219783487	0.204487219783487	false	false	false	true
f85e6c96-0c81-4e64-a870-92668efce997	2026-09-17 10:21	2026-09-17 10:21	2026-09-17 10:21	XLI	XLI260925C00170000	call	170.0000	2026-09-25	1.6900	1.5900	1.7800	169.7900	12675.00	12675.00	0.00	75	5	160	209	0.76555023923445	0.171597536548661	0.171597536548661	false	false	false	true
86baeb40-4fa6-4d36-b6af-d9a3a7e5ee49	2026-09-17 10:18	2026-09-17 10:18	2026-09-17 10:18	XLI	XLI261120C00168000	call	168.0000	2026-11-20	6.9500	6.5000	6.9500	169.6950	12509.00	12509.00	0.00	18	13	18	18	1	0.191122602186563	0.191122602186563	false	false	false	true
7e361a3e-40ac-4337-92aa-20913ff5bfbb	2026-09-16 15:50	2026-09-16 15:50	2026-09-16 15:50	XLI	XLI261016P00182000	put	182.0000	2026-10-16	13.9500	13.9500	14.7000	168.0000	23715.00	0.00	23715.00	17	5	17	16	1.0625	0.255779300730781	0.255779300730781	true	false	false	true
8af48f11-9f66-4ab7-a82c-2e3d4bcccd99	2026-09-16 15:33	2026-09-16 15:33	2026-09-16 15:33	XLI	XLI260925C00172000	call	172.0000	2026-09-25	0.6500	0.6500	0.7500	168.1000	29835.00	0.00	29835.00	459	35	610	232	2.62931034482759	0.186160396515674	0.186160396515674	false	false	false	true
80ecb744-e6f7-4a4a-98a1-cb48d9af301e	2026-09-16 15:33	2026-09-16 15:33	2026-09-16 15:33	XLI	XLI261120C00168000	call	168.0000	2026-11-20	6.2500	5.7500	6.3000	168.2400	12495.00	11875.00	620.00	20	12	20	0	0	0.194604143436627	0.194604143436627	false	false	false	true
51d5d2fc-351e-4d14-a916-9515beaaf925	2026-09-16 14:20	2026-09-16 14:20	2026-09-16 14:20	XLI	XLI270115C00185000	call	185.0000	2027-01-15	2.4500	2.3900	2.4500	169.7500	20090.00	20090.00	0.00	82	5	153	8609	0.0177720989661982	0.174636968216733	0.174636968216733	false	false	false	true
509a379e-447a-406e-b9b6-e91c86a309bc	2026-09-16 14:14	2026-09-16 14:14	2026-09-16 14:14	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.3500	1.2800	1.4000	170.0600	34425.00	34425.00	0.00	255	9	1258	1255	1.00239043824701	0.170993971271564	0.170993971271564	false	false	false	true
157002fa-9af5-483d-8b11-f9c919217a1b	2026-09-16 14:14	2026-09-16 14:14	2026-09-16 14:14	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.3500	1.2400	1.4000	170.0600	57645.00	57645.00	0.00	427	23	903	1255	0.719521912350598	0.170993971271564	0.170993971271564	true	false	false	true
6fd96af4-3487-40e5-ae6a-76e63ba2148b	2026-09-16 14:07	2026-09-16 14:07	2026-09-16 14:07	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.4000	1.2400	1.5200	170.0900	15540.00	15540.00	0.00	111	19	389	1255	0.30996015936255	0.174031693362987	0.174031693362987	false	false	false	true
6e2e98ff-8399-413b-976b-f83e8c62e96f	2026-09-16 13:39	2026-09-16 13:39	2026-09-16 13:39	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.6400	1.5200	1.6400	170.2150	18860.00	18860.00	0.00	115	36	384	436	0.880733944954128	0.244137681925356	0.244137681925356	false	false	false	true
6c7cf8d6-6544-472b-91df-48e8341dece6	2026-09-16 13:22	2026-09-16 13:22	2026-09-16 13:22	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1800	1.0800	1.2200	170.0700	20532.00	20532.00	0.00	174	36	1468	4817	0.304753996263234	0.245497370404006	0.245497370404006	false	false	false	true
deebdb2c-6c24-4e34-b161-9200b5b877ec	2026-09-16 13:11	2026-09-16 13:11	2026-09-16 13:11	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1200	1.0200	1.1200	170.1100	10640.00	10640.00	0.00	95	17	1179	4817	0.244758148225036	0.237362586699559	0.237362586699559	false	false	false	true
4d87f652-d035-46bc-be91-38333bb370c5	2026-09-16 13:11	2026-09-16 13:11	2026-09-16 13:11	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.7100	1.5600	1.7100	170.1100	10089.00	10089.00	0.00	59	15	218	436	0.5	0.245603721267682	0.245603721267682	false	false	false	true
161ed94a-a986-49d8-b01a-5e158faa1b9e	2026-09-16 13:11	2026-09-16 13:11	2026-09-16 13:11	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1200	1.0200	1.1200	170.1100	11088.00	11088.00	0.00	99	19	1286	4817	0.266971143865476	0.237362586699559	0.237362586699559	false	false	false	true
a601ac2a-231d-4c77-8426-70824f4d6cbe	2026-09-16 12:58	2026-09-16 12:58	2026-09-16 12:58	XLI	XLI261016P00170000	put	170.0000	2026-10-16	3.5000	3.4000	3.5000	170.2500	28700.00	28700.00	0.00	82	25	190	1869	0.101658640984484	0.200068989813787	0.200068989813787	false	false	false	true
70cc63bb-5d48-42e0-8745-bafae50430b4	2026-09-16 12:58	2026-09-16 12:58	2026-09-16 12:58	XLI	XLI261016P00169000	put	169.0000	2026-10-16	3.1000	3.0000	3.1000	170.2500	35030.00	35030.00	0.00	113	26	239	376	0.63563829787234	0.203056323903053	0.203056323903053	false	false	false	true
f1dfd433-ae73-4cc8-99b5-6a5ab93a579b	2026-09-16 12:06	2026-09-16 12:06	2026-09-16 12:06	XLI	XLI260925P00169000	put	169.0000	2026-09-25	1.7000	1.6600	1.7700	170.2900	258740.00	258400.00	340.00	1522	25	2289	177	12.9322033898305	0.221794303461701	0.221794303461701	false	false	false	true
803701f9-3739-4826-bd60-6142c2cd6245	2026-09-16 11:55	2026-09-16 11:54	2026-09-16 11:54	XLI	XLI260925P00169000	put	169.0000	2026-09-25	1.6700	1.5500	1.6700	170.3473	127588.00	127588.00	0.00	764	23	766	177	4.32768361581921	0.221073177837231	0.221073177837231	false	false	false	true
a5d97744-5a1d-43c4-88bb-ac6b33420ee7	2026-09-16 11:54	2026-09-16 11:54	2026-09-16 11:54	XLI	XLI261016P00170000	put	170.0000	2026-10-16	3.4500	3.2000	3.5000	170.4000	10350.00	10350.00	0.00	30	6	86	1869	0.0460139111824505	0.200996698439735	0.200996698439735	true	false	false	true
f537c03c-abc4-4557-a43d-482f060f9ae9	2026-09-16 11:51	2026-09-16 11:51	2026-09-16 11:51	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.4800	1.2800	1.4800	170.5000	23384.00	23384.00	0.00	158	20	159	436	0.364678899082569	0.244873957600107	0.244873957600107	false	false	false	true
b3765bb6-4341-42fa-8cb5-930dd7a0dcd6	2026-09-16 11:50	2026-09-16 11:50	2026-09-16 11:50	XLI	XLI270319P00163000	put	163.0000	2027-03-19	5.4500	5.1000	5.4500	170.5450	41965.00	41965.00	0.00	77	20	77	246	0.313008130081301	0.215200113177791	0.215200113177791	false	false	false	true
d8880186-2082-4550-bf36-cb8d5416d88e	2026-09-16 11:44	2026-09-16 11:44	2026-09-16 11:44	XLI	XLI260925P00163000	put	163.0000	2026-09-25	0.4000	0.3600	0.4600	170.3000	40520.00	40240.00	280.00	1013	13	1013	197	5.14213197969543	0.24748394635559	0.24748394635559	false	false	false	true
804ef78f-6840-4095-8aa3-fb5c4f83b14d	2026-09-16 11:26	2026-09-16 11:26	2026-09-16 11:26	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1100	1.0300	1.1100	170.2900	24753.00	24753.00	0.00	223	44	1049	4817	0.217770396512352	0.252113993569704	0.252113993569704	false	false	false	true
83ef983a-2cd9-45ea-9aa8-205d41d543d0	2026-09-16 10:38	2026-09-16 10:38	2026-09-16 10:38	XLI	XLI260918P00169000	put	169.0000	2026-09-18	1.0600	0.9700	1.0600	169.4600	10706.00	10706.00	0.00	101	31	461	1057	0.436140018921476	0.258771433293129	0.258771433293129	false	false	false	true
8f763f91-f7e3-4355-959b-3e204b4b3148	2026-09-16 10:02	2026-09-16 10:01	2026-09-16 10:01	XLI	XLI260918C00171000	call	171.0000	2026-09-18	0.6600	0.6000	0.6600	169.3700	23562.00	23562.00	0.00	357	10	501	235	2.13191489361702	0.259652619734153	0.259652619734153	false	false	false	true
b096f9b6-4354-4781-860c-3a8832cf892c	2026-09-16 09:59	2026-09-16 09:59	2026-09-16 09:59	XLI	XLI260918P00169000	put	169.0000	2026-09-18	1.1000	0.9600	1.1000	169.4200	25850.00	25850.00	0.00	235	31	360	1057	0.340586565752129	0.263316591574376	0.263316591574376	false	false	false	true
87e5efc0-c6b7-46d9-ba4d-2f107ec903f5	2026-09-16 09:59	2026-09-16 09:59	2026-09-16 09:59	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5800	1.4100	1.5800	169.4200	11850.00	11850.00	0.00	75	15	325	4817	0.0674693792817106	0.257455231682971	0.257455231682971	false	false	false	true