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

99bf11d1-6461-4e42-83dc-9732a6a9c48d	2026-09-22 14:50	2026-09-22 14:50	2026-09-22 14:50	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0900	1.0900	1.1400	170.0300	18203.00	0.00	5450.00	167	8	3974	9324	0.426211926211926	0.230480723073607	0.230480723073607	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-22T18:55:20.077577Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
b8f0fd79-e759-4cdb-8d65-7faf31d91831	2026-09-22 14:31	2026-09-22 14:31	2026-09-22 14:31	XLI	XLI261120P00171000	put	171.0000	2026-11-20	5.4000	5.3000	5.4000	169.8750	53460.00	53460.00	0.00	99	27	106	1072	0.0988805970149254	0.198325201804478	0.198325201804478	false	false	false	true	false
418bea62-3a8e-42e3-9069-480b77e1d8cc	2026-09-22 14:12	2026-09-22 14:12	2026-09-22 14:12	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.8500	4.7500	4.8500	170.0550	94090.00	94090.00	0.00	194	40	461	46187	0.00998116353086366	0.199403589605202	0.199403589605202	false	false	false	true	false
5e6fc665-8abd-4f8f-883e-6fd82bebbea0	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	XLI	XLI261002C00172000	call	172.0000	2026-10-02	1.1500	1.1000	1.1500	170.1500	117990.00	117990.00	0.00	1026	25	1084	14	77.4285714285714	0.165180339105315	0.165180339105315	false	false	false	true	false
0c4a0410-fcd3-4a81-92a0-f39038aeb126	2026-09-22 13:43	2026-09-22 13:43	2026-09-22 13:43	XLI	XLI261120P00168000	put	168.0000	2026-11-20	4.1000	4.0500	4.1500	169.7300	13120.00	0.00	6560.00	32	6	393	28098	0.0139867606235319	0.200219408258079	0.200143370437206	false	false	false	true	false
79a6b9b8-ac19-4ff4-8bce-36a31e64c527	2026-09-22 13:31	2026-09-22 13:30	2026-09-22 13:30	XLI	XLI261120C00183000	call	183.0000	2026-11-20	1.3800	1.3300	1.3800	169.0000	235014.00	235014.00	0.00	1703	24	1778	21	84.6666666666667	0.190847463880887	0.190847463880887	false	false	false	true	false
603f35c6-406f-4247-815d-2d2949d5c141	2026-09-22 13:10	2026-09-22 13:10	2026-09-22 13:10	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.1000	1.1000	1.1100	169.8800	10560.00	0.00	10560.00	96	5	3659	9324	0.392428142428142	0.229804607434533	0.229804607434533	false	false	false	true	false
07cd2d3a-5a29-4069-aa0d-5d7cdacf2ae1	2026-09-22 13:10	2026-09-22 13:10	2026-09-22 13:10	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.1000	1.0700	1.1000	169.8500	113410.00	113410.00	0.00	1031	30	3464	9324	0.371514371514371	0.229532390060834	0.229532390060834	false	false	false	true	false
1f382fbe-6899-4bca-92cc-c3925207497e	2026-09-22 13:09	2026-09-22 13:09	2026-09-22 13:09	XLI	XLI261120P00168000	put	168.0000	2026-11-20	4.0000	3.9500	4.0500	169.8400	13200.00	10400.00	2800.00	33	7	175	28098	0.00622820129546587	0.198016651031843	0.198016651031843	false	false	false	true	false
0fbf7afa-59f3-4afc-88ac-b500cc35bb5d	2026-09-22 13:09	2026-09-22 13:09	2026-09-22 13:09	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0900	1.0600	1.0900	169.8600	22018.00	22018.00	0.00	202	20	2244	9324	0.240669240669241	0.228942684882892	0.228942684882892	false	false	false	true	false
1c166e86-9f32-4ce1-bb38-5acdc918767e	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0800	1.0600	1.0800	169.8400	10476.00	10476.00	0.00	97	11	1905	9324	0.204311454311454	0.228078948046311	0.228078948046311	false	false	false	true	false
0c8e2cc3-cc2c-44f7-99dd-fe5662acecf5	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0800	1.0600	1.0800	169.8100	18252.00	18252.00	0.00	169	16	1808	9324	0.193908193908194	0.22780736942133	0.22780736942133	false	false	false	true	false
1cd8880e-1cf4-4d15-bb21-1ae376498cc9	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0800	1.0800	1.1000	169.8100	11016.00	0.00	1944.00	102	9	1639	9324	0.175782925782926	0.22780736942133	0.22780736942133	true	false	false	true	false
d5a6ab64-dcaa-4751-93b7-eac8ba51d775	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.8500	4.7500	4.8500	169.8101	22310.00	22310.00	0.00	46	10	94	46187	0.0020352047112824	0.195305061391158	0.195305061391158	true	false	false	true	false
3fa14358-43e1-4be3-a830-fad1a3fd6f44	2026-09-22 13:02	2026-09-22 13:02	2026-09-22 13:02	XLI	XLI261016P00159000	put	159.0000	2026-10-16	0.4500	0.3200	0.4800	169.0000	47250.00	225.00	47025.00	1050	21	1050	0	0	0.213596259889296	0.213596259889296	false	false	false	true	false
f3b5b5cb-e946-41da-b31d-3f0be7ffad07	2026-09-22 13:02	2026-09-22 13:02	2026-09-22 13:02	XLI	XLI280121C00175000	call	175.0000	2028-01-21	18.1300	18.0500	18.2000	169.0000	43500.00	23595.00	18100.00	24	8	61	244	0.25	0.197543115261176	0.196881450381106	false	false	false	true	false
4e2e17ea-64ca-470b-be13-2d376bd0fa02	2026-09-22 13:02	2026-09-22 13:02	2026-09-22 13:02	XLI	XLI280121C00175000	call	175.0000	2028-01-21	18.0700	17.8500	18.5500	169.0000	16265.00	3630.00	12635.00	9	7	9	244	0.0368852459016393	0.193914861634679	0.197543115261176	false	false	false	true	false
1ff42d00-bdf2-4cd3-bdfa-09bad88fe78c	2026-09-22 12:49	2026-09-22 12:49	2026-09-22 12:49	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0500	1.0200	1.0500	170.1450	13335.00	13335.00	0.00	127	15	1537	9324	0.164843414843415	0.228757328566967	0.228757328566967	false	false	false	true	false
06e8d124-ade3-49f6-af76-aa97d8ff8998	2026-09-22 12:49	2026-09-22 12:49	2026-09-22 12:49	XLI	XLI261016C00177000	call	177.0000	2026-10-16	0.8400	0.8200	0.8400	170.1050	34272.00	34272.00	0.00	408	42	431	2130	0.202347417840376	0.170970723876626	0.170970723876626	false	false	false	true	false
7cea6d76-320f-4e27-ac52-7af609cf81b7	2026-09-22 12:49	2026-09-22 12:49	2026-09-22 12:49	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.9000	2.8300	2.9000	170.1050	28990.00	26100.00	2890.00	100	11	479	9910	0.048335015136226	0.203391537685523	0.20297725758172	true	false	false	true	false
3836b001-a22d-4adc-824e-35cfceb6633d	2026-09-22 12:48	2026-09-22 12:48	2026-09-22 12:48	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0500	1.0200	1.0800	169.9300	20055.00	0.00	13335.00	191	7	1181	9324	0.126662376662377	0.226827365898377	0.226827365898377	false	false	false	true	false
11c25074-f683-499f-8e2b-6e981302a9ca	2026-09-22 12:46	2026-09-22 12:46	2026-09-22 12:46	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0500	1.0500	1.1000	169.8800	22575.00	0.00	22575.00	215	8	783	9324	0.083976833976834	0.226377489980237	0.226377489980237	false	false	false	true	false
4ef9fd20-1ffd-42fb-b731-44f71fbdb6bf	2026-09-22 12:46	2026-09-22 12:45	2026-09-22 12:45	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0500	1.0500	1.1000	169.8600	16590.00	0.00	16590.00	158	6	537	9324	0.0575933075933076	0.226197428268233	0.226197428268233	false	false	false	true	false
f6363061-652b-4879-934a-d576132edc58	2026-09-22 12:45	2026-09-22 12:45	2026-09-22 12:45	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0500	1.0500	1.1000	169.8750	20160.00	0.00	20160.00	192	13	379	9324	0.0406477906477907	0.226332480524196	0.226332480524196	false	false	false	true	false
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
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