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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×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

89829d47-f94e-4a69-b325-364a6e7342a8	2026-09-21 13:26	2026-09-21 13:26	2026-09-21 13:26	XLI	XLI261009C00167500	call	167.5000	2026-10-09	4.5500	4.5500	4.9500	170.2550	10471.00	0.00	10471.00	23	14	26	0	0	0.183130593628344	0.183130593628344	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	30592678197.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T17:29:25.525905Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
37719b36-5905-437d-a9e1-85c0d1cedab0	2026-09-21 13:26	2026-09-21 13:26	2026-09-21 13:26	XLI	XLI261009C00172000	call	172.0000	2026-10-09	1.9500	1.9100	2.1800	170.2432	13265.00	192.00	13073.00	68	22	80	172	0.465116279069767	0.171256921400555	0.169563725145637	true	false	false	true
1c63773e-8d32-4388-bb23-763eed17f5c6	2026-09-21 13:03	2026-09-21 13:03	2026-09-21 13:03	XLI	XLI261016P00171000	put	171.0000	2026-10-16	3.2000	3.1000	3.3000	170.3300	36800.00	36480.00	320.00	115	33	121	176	0.6875	0.174005847987127	0.174005847987127	false	false	false	true
baf641a6-9772-420f-9763-d234b036f5ea	2026-09-21 12:41	2026-09-21 12:41	2026-09-21 12:41	XLI	XLI270115C00185000	call	185.0000	2027-01-15	2.6000	2.3600	2.6500	170.4100	20280.00	20280.00	0.00	78	16	110	8439	0.0130347197535253	0.178178556306301	0.178178556306301	false	false	false	true
d8eaa080-eca3-4ac9-96d6-8c96141a371e	2026-09-21 12:17	2026-09-21 12:17	2026-09-21 12:17	XLI	XLI261016P00175000	put	175.0000	2026-10-16	5.6000	5.4000	5.6000	170.0000	71120.00	71120.00	0.00	127	30	128	194	0.65979381443299	0.171986841424504	0.171986841424504	false	false	false	true
ee746d55-27f7-4a50-a9cc-7fdb8aa20a83	2026-09-21 11:50	2026-09-21 11:50	2026-09-21 11:50	XLI	XLI270319P00170000	put	170.0000	2027-03-19	7.9000	7.7500	7.9000	170.1900	33180.00	33180.00	0.00	42	9	43	1668	0.025779376498801	0.204981585176936	0.204981585176936	false	false	false	true
63600d61-fc52-4570-b0b9-6c455d260f7a	2026-09-21 11:39	2026-09-21 11:39	2026-09-21 11:39	XLI	XLI261016P00172000	put	172.0000	2026-10-16	3.8500	3.7500	3.8500	170.0600	65450.00	65450.00	0.00	170	30	194	310	0.625806451612903	0.171456986892295	0.171456986892295	false	false	false	true
8d978425-a904-4300-9495-65ab055d923f	2026-09-21 11:03	2026-09-21 11:03	2026-09-21 11:03	XLI	XLI261002P00167500	put	167.5000	2026-10-02	1.2200	1.1800	1.3900	169.6000	18301.00	122.00	18179.00	150	9	162	2	81	0.186855854376041	0.186855854376041	true	false	false	true	false
fea6d958-c6c0-4079-903d-c855ab6f7bd3	2026-09-21 10:31	2026-09-21 10:31	2026-09-21 10:31	XLI	XLI261002P00176000	put	176.0000	2026-10-02	6.7000	6.7000	7.3500	169.4700	10050.00	0.00	10050.00	15	5	30	8	3.75	0.189608083011696	0.189608083011696	true	false	false	true	false
e36ecc53-3eaf-4716-ad61-56cf9d590aa2	2026-09-21 10:29	2026-09-21 10:29	2026-09-21 10:29	XLI	XLI261016P00174000	put	174.0000	2026-10-16	5.6000	5.5500	5.6500	169.4500	42560.00	38080.00	0.00	76	7	76	1626	0.046740467404674	0.175974779058102	0.175974779058102	false	false	false	true
a59f8324-5ca0-4d80-a8b7-94710d4244ae	2026-09-21 10:04	2026-09-21 10:04	2026-09-21 10:04	XLI	XLI270115P00145000	put	145.0000	2027-01-15	1.1000	1.1000	1.1600	168.8800	11220.00	0.00	11220.00	102	8	250	43	5.81395348837209	0.239045975677852	0.239045975677852	false	false	false	true
e9d13553-5550-4d9e-8a6c-524c3de3ce6d	2026-09-18 15:33	2026-09-18 15:33	2026-09-18 15:33	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.2100	5.1500	5.4000	169.4550	11722500.00	0.00	11722500.00	22500	2	22695	55346	0.41005673400065	0.197462360913692	0.197462360913692	false	true	true	false
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
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
4a4d2622-1d79-4820-ae7e-275ba68f0f10	2026-09-18 12:53	2026-09-18 12:53	2026-09-18 12:53	XLI	XLI280121P00125000	put	125.0000	2028-01-21	2.4000	2.3700	2.6400	169.0000	13205.00	0.00	13205.00	55	8	498	8	62.25	0.261695398382697	0.262624069708162	false	false	false	true
6e628f50-7b20-47b1-9025-d9eef61d425c	2026-09-18 12:50	2026-09-18 12:50	2026-09-18 12:50	XLI	XLI280121P00175000	put	175.0000	2028-01-21	15.6200	15.6000	16.3000	168.8900	12500.00	3130.00	9370.00	8	7	8	89	0.0898876404494382	0.231430348740274	0.232088818828735	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
ca950eeb-2046-415a-91d0-59bb93ef1e0e	2026-09-18 12:50	2026-09-18 12:50	2026-09-18 12:50	XLI	XLI280121P00125000	put	125.0000	2028-01-21	2.4300	2.3800	2.8200	168.8800	12156.00	0.00	12156.00	50	10	50	8	6.25	0.261648639534876	0.263868456028277	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
77230d8e-7144-46af-94a2-07da958cde85	2026-09-17 14:50	2026-09-17 14:50	2026-09-17 14:50	XLI	XLI260918P00177000	put	177.0000	2026-09-18	7.9500	7.5500	7.9500	169.1500	1710045.00	1710045.00	0.00	2151	2	2153	1434	1.50139470013947	0.545752207454251	0.545752207454251	false	true	true	false
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
a2f2ad4d-0b64-4403-a275-301b29f34824	2026-09-17 11:18	2026-09-17 11:17	2026-09-17 11:17	XLI	XLI270917P00145000	put	145.0000	2027-09-17	4.5400	3.9500	5.4000	169.0200	58160.00	6675.00	9495.00	128	59	157	0	0	0.248824533116495	0.244272747023521	true	false	false	true
2d5bedba-bc5a-4517-a0d8-f4fb17d32321	2026-09-17 11:18	2026-09-17 11:17	2026-09-17 11:17	XLI	XLI270917P00145000	put	145.0000	2027-09-17	4.3800	3.9500	4.4000	169.0200	55156.00	55156.00	0.00	126	47	283	0	0	0.244272747023521	0.243126380136538	true	false	false	true	false
d19b058f-9061-4094-bf68-99f81adf1009	2026-09-17 11:17	2026-09-17 11:17	2026-09-17 11:17	XLI	XLI270917P00130000	put	130.0000	2027-09-17	2.2900	1.5600	3.7000	169.0200	39006.00	35076.00	1334.00	170	108	170	0	0	0.265954464552855	0.259394210652841	true	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
82875680-a0c9-4c98-9f5a-8cd1fa99bee5	2026-09-17 09:51	2026-09-17 09:51	2026-09-17 09:51	XLI	XLI261218P00157000	put	157.0000	2026-12-18	1.9400	1.9400	2.2100	170.8700	99730.00	2730.00	97000.00	514	57	514	68	7.55882352941176	0.220424597724844	0.220869135630682	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
38ccf1ee-eec5-4343-9634-9d88884ce353	2026-09-16 15:24	2026-09-16 15:24	2026-09-16 15:24	XLI	XLI261016P00160000	put	160.0000	2026-10-16	1.3700	1.1000	1.3800	167.6600	16968.00	16968.00	0.00	124	25	142	1422	0.09985935302391	0.229004421891174	0.22685379604193	true	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