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: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	price

464cc36c-54ed-47c7-aed7-e68c52a2ff26	2026-09-22 12:43	2026-09-22 12:43	2026-09-22 12:43	XLI	XLI261023P00170000	put	170.0000	2026-10-23	3.2500	3.0500	3.2500	169.8500	17225.00	17225.00	0.00	53	13	53	8	6.625	0.17576460000192	0.17576460000192	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30417352821.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T16:48:50.097062Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
71d03c56-4f24-4180-a6e1-5a0b59206e28	2026-09-22 12:40	2026-09-22 12:40	2026-09-22 12:40	XLI	XLI261120C00180000	call	180.0000	2026-11-20	1.8900	1.8900	1.9300	169.9300	24030.00	0.00	24030.00	127	32	208	981	0.212028542303772	0.184567619655384	0.184567619655384	false	false	false	true	false
915191da-aa51-47d8-8f43-8d2d40e1064a	2026-09-22 12:25	2026-09-22 12:25	2026-09-22 12:25	XLI	XLI261016C00172000	call	172.0000	2026-10-16	2.1800	2.1100	2.2600	169.8900	15912.00	15695.00	217.00	73	12	101	1456	0.0693681318681319	0.168170227760733	0.167582651666127	true	false	false	true	false
2885632d-0d20-444c-86dc-3efda7cd4253	2026-09-22 12:18	2026-09-22 12:18	2026-09-22 12:18	XLI	XLI261009C00173000	call	173.0000	2026-10-09	1.2200	1.2200	1.4100	169.9700	19154.00	0.00	19154.00	157	5	238	60	3.96666666666667	0.157892557408896	0.157892557408896	false	false	false	true	false
fff4ecbc-7441-4f8a-9260-2370f6a6731e	2026-09-22 11:28	2026-09-22 11:28	2026-09-22 11:28	XLI	XLI261016P00168000	put	168.0000	2026-10-16	2.1700	2.0700	2.1700	169.0000	110019.00	110019.00	0.00	507	39	829	745	1.11275167785235	0.179422295826791	0.179422295826791	false	false	false	true	false
6f992b56-5abd-4830-938d-b7892538a93f	2026-09-22 11:24	2026-09-22 11:24	2026-09-22 11:24	XLI	XLI261016P00168000	put	168.0000	2026-10-16	2.1400	2.0700	2.1400	169.0000	22042.00	22042.00	0.00	103	30	322	745	0.432214765100671	0.178081769860191	0.178081769860191	false	false	false	true	false
f940ab6b-3e58-4ba0-a566-1b912c85f168	2026-09-22 11:21	2026-09-22 11:21	2026-09-22 11:21	XLI	XLI260925C00172500	call	172.5000	2026-09-25	0.2600	0.2000	0.2600	169.6875	10582.00	10582.00	0.00	407	40	432	129	3.34883720930233	0.185652658493955	0.185652658493955	false	false	false	true	false
790dc6b0-d8e1-4d23-aa9d-d22fb072941b	2026-09-22 11:07	2026-09-22 11:07	2026-09-22 11:07	XLI	XLI261023C00172000	call	172.0000	2026-10-23	2.5900	2.2500	2.6000	169.0000	26389.00	16295.00	10094.00	102	13	102	9	11.3333333333333	0.171886912873722	0.171886912873722	true	false	false	true	false
4ccdca56-2ee4-4d3f-92a9-6704f6ae66be	2026-09-22 10:44	2026-09-22 10:44	2026-09-22 10:44	XLI	XLI261016P00171000	put	171.0000	2026-10-16	3.7000	3.4000	3.7000	169.2850	20350.00	20350.00	0.00	55	16	55	414	0.132850241545894	0.173893360286814	0.173893360286814	false	false	false	true	false
2e429a45-a284-49c5-af3c-874fb566e989	2026-09-22 10:44	2026-09-22 10:44	2026-09-22 10:44	XLI	XLI261016P00170000	put	170.0000	2026-10-16	3.1500	3.0500	3.2000	169.2850	157500.00	156240.00	1260.00	500	25	506	1854	0.272923408845739	0.173776610025881	0.173776610025881	false	false	false	true	false
af3f0366-4144-4edb-93e5-a516a3e29c8a	2026-09-22 10:33	2026-09-22 10:33	2026-09-22 10:33	XLI	XLI261002C00175000	call	175.0000	2026-10-02	0.3800	0.3100	0.3800	169.6500	11665.00	11628.00	0.00	307	40	310	67	4.62686567164179	0.173637754630335	0.173637754630335	false	false	false	true	false
456cdb8f-7b5c-4d45-99aa-56cfb34654b9	2026-09-22 10:16	2026-09-22 10:16	2026-09-22 10:16	XLI	XLI260925P00167500	put	167.5000	2026-09-25	0.4300	0.3600	0.4300	169.4050	49450.00	49450.00	0.00	1150	21	1217	90	13.5222222222222	0.189581330573425	0.189581330573425	false	false	false	true	false
0595e85f-e5b9-4a24-8a5b-157192634136	2026-09-22 10:11	2026-09-22 10:11	2026-09-22 10:11	XLI	XLI261002P00163000	put	163.0000	2026-10-02	0.2800	0.2800	0.3000	169.6550	37940.00	0.00	37940.00	1355	27	1356	15	90.4	0.199361595061222	0.199361595061222	false	false	false	true	false
3005be9f-fb0d-4e4e-a7fb-df015f2675cf	2026-09-22 09:50	2026-09-22 09:50	2026-09-22 09:50	XLI	XLI261016P00160000	put	160.0000	2026-10-16	0.5500	0.5300	0.5900	169.8600	15895.00	11550.00	4345.00	289	26	900	15594	0.0577145055790689	0.211078060418175	0.211078060418175	false	false	false	true	false
7385333e-5fde-4738-8f95-843d6e52be7d	2026-09-22 09:50	2026-09-22 09:49	2026-09-22 09:49	XLI	XLI261016P00168000	put	168.0000	2026-10-16	2.0800	1.9400	2.2600	169.9300	37285.00	37285.00	0.00	179	23	187	745	0.251006711409396	0.190832267362803	0.180856616821125	true	false	false	true	false
333df164-e858-4657-9701-460959b01cb7	2026-09-22 09:50	2026-09-22 09:49	2026-09-22 09:49	XLI	XLI261016P00160000	put	160.0000	2026-10-16	0.5600	0.5500	0.6200	169.8900	17293.00	0.00	17293.00	311	50	422	15594	0.0270616903937412	0.212641690633417	0.211490070114873	false	false	false	true	false
854143cc-2dbc-4a79-ad7d-4808f82c5457	2026-09-22 09:48	2026-09-22 09:48	2026-09-22 09:48	XLI	XLI261009P00169000	put	169.0000	2026-10-09	2.1000	2.0200	2.1500	169.6700	19995.00	9939.00	10056.00	95	16	105	72	1.45833333333333	0.175127342018328	0.177211457395583	true	false	false	true	false
8497aba6-c576-4f5a-b84f-958a4ab10c35	2026-09-21 15:51	2026-09-21 15:51	2026-09-21 15:51	XLI	XLI261120P00168000	put	168.0000	2026-11-20	3.9500	3.9000	3.9500	169.9400	15010.00	15010.00	0.00	38	10	148	28000	0.00528571428571429	0.196268222944276	0.196268222944276	true	false	false	true	false
827663dd-44ba-4631-a0e7-99048ce0a4d9	2026-09-21 15:49	2026-09-21 15:49	2026-09-21 15:49	XLI	XLI261016P00170000	put	170.0000	2026-10-16	2.8600	2.7200	2.8600	170.0000	91234.00	91234.00	0.00	319	41	578	2129	0.271488961953969	0.175658483505076	0.175658483505076	false	false	false	true	false
46f9456e-90b4-40bd-a3fd-ac3de04d21ee	2026-09-21 15:33	2026-09-21 15:32	2026-09-21 15:32	XLI	XLI261009P00169000	put	169.0000	2026-10-09	1.9500	1.7700	1.9900	170.0000	12869.00	12674.00	195.00	66	10	66	10	6.6	0.174160978698341	0.174160978698341	true	false	false	true	false
55da88a1-2c7e-41f7-ba7e-47e6d7daa9fd	2026-09-21 14:10	2026-09-21 14:07	2026-09-21 14:10	XLI	XLI261016P00160000	put	160.0000	2026-10-16	0.6100	0.0000	0.0000	170.1650	477632.00	435392.00	27125.00	7844	50	15021	1418	10.5930888575458	0	0	true	true	false	true	false
c4dbdbe6-d0a6-41c7-a199-4cc0eddee75d	2026-09-21 14:07	2026-09-21 14:07	2026-09-21 14:07	XLI	XLI261016P00160000	put	160.0000	2026-10-16	0.6000	0.5300	0.5900	170.0000	55132.00	55132.00	0.00	921	22	2442	1418	1.72214386459803	0.217406176726922	0.216295356798558	true	false	false	true	false
633651b1-9694-4ac1-ad70-972cc4e92839	2026-09-21 13:43	2026-09-21 13:43	2026-09-21 13:43	XLI	XLI261016P00174000	put	174.0000	2026-10-16	5.1000	4.9000	5.1500	170.0000	158100.00	156060.00	510.00	310	8	434	1626	0.266912669126691	0.168682581499183	0.168682581499183	false	false	false	true	false
742b2721-26fe-4920-806b-d60d1d133242	2026-09-21 13:39	2026-09-21 13:39	2026-09-21 13:39	XLI	XLI261120C00165000	call	165.0000	2026-11-20	9.1500	9.1500	9.7500	169.0000	11895.00	0.00	11895.00	13	10	13	57	0.228070175438596	0.208069359011337	0.208069359011337	true	false	false	true	false
754f51c5-2573-482e-a758-0b2f7668ec06	2026-09-21 13:36	2026-09-21 13:36	2026-09-21 13:36	XLI	XLI261016P00171000	put	171.0000	2026-10-16	3.3500	3.2500	3.3500	170.0000	41205.00	41205.00	0.00	123	34	248	176	1.40909090909091	0.173704377939146	0.173704377939146	false	false	false	true	false
573a6ec5-81ae-4ded-99f7-ec9a57f604a0	2026-09-21 13:31	2026-09-21 13:31	2026-09-21 13:31	XLI	XLI261120P00168000	put	168.0000	2026-11-20	3.9000	3.7000	3.9500	170.1100	17550.00	16770.00	780.00	45	8	48	28000	0.00171428571428571	0.197262897888584	0.196895021406668	false	false	false	true	false
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
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false