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

e8a2e336-473c-46f4-be72-2fb951dd8954	2026-09-24 15:35	2026-09-24 15:34	2026-09-24 15:34	XLI	XLI261218C00180000	call	180.0000	2026-12-18	2.7800	2.6200	2.7800	169.0700	49762.00	49762.00	0.00	179	28	237	3896	0.0608316221765914	0.189789953446028	0.189789953446028	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30374218340.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T19:37:02.882742Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
bf92cc0a-7090-4dc0-82ae-6e65ef19d145	2026-09-24 14:02	2026-09-24 14:02	2026-09-24 14:02	XLI	XLI261120P00179000	put	179.0000	2026-11-20	11.0000	10.4500	11.0000	168.0000	12100.00	12100.00	0.00	11	10	39	0	0	0.198413812494628	0.198413812494628	true	false	false	true
67cd4e7c-eeb7-4b84-a74b-aa2d8c2116a8	2026-09-24 13:36	2026-09-24 13:36	2026-09-24 13:36	XLI	XLI261120P00163000	put	163.0000	2026-11-20	2.4800	2.0900	2.5800	169.1700	15373.00	12152.00	3221.00	62	6	62	227	0.273127753303965	0.20416749639267	0.203723672797225	false	false	false	true
319041ff-2164-446f-9b78-70d4fe3b0416	2026-09-24 13:36	2026-09-24 13:36	2026-09-24 13:36	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.0900	2.7500	3.1000	169.1700	22570.00	18910.00	3660.00	73	11	1084	14055	0.0771255780860904	0.202203961997109	0.200143844319063	false	false	false	true
54795c16-1694-4a22-9d0e-f564ba6e135e	2026-09-24 13:17	2026-09-24 13:17	2026-09-24 13:17	XLI	XLI261016P00157000	put	157.0000	2026-10-16	0.3300	0.3300	0.4000	169.6800	20196.00	0.00	20196.00	612	47	614	2	307	0.230981759357702	0.230981759357702	false	false	false	true
0d9a126c-e749-401d-b1e2-230813fc770b	2026-09-24 13:07	2026-09-24 13:07	2026-09-24 13:07	XLI	XLI261120C00160000	call	160.0000	2026-11-20	12.5000	12.2000	12.5000	169.6600	45000.00	45000.00	0.00	36	6	36	360	0.1	0.216938817170559	0.216938817170559	false	false	false	true
e4b9fd05-cb61-499a-8685-3f04cb634b5e	2026-09-24 12:45	2026-09-24 12:45	2026-09-24 12:45	XLI	XLI261016P00168000	put	168.0000	2026-10-16	2.1600	2.0300	2.1600	169.5300	39096.00	39096.00	0.00	181	24	621	1385	0.448375451263538	0.183490961547081	0.183490961547081	false	false	false	true
efd828db-8eb8-4d76-bac1-268c050849c1	2026-09-24 12:41	2026-09-24 12:41	2026-09-24 12:41	XLI	XLI261120P00169000	put	169.0000	2026-11-20	4.1500	4.1500	4.2500	169.9900	50630.00	0.00	50630.00	122	21	540	844	0.639810426540284	0.192349280248881	0.192189060886232	true	false	false	true
458321f5-0ac8-4aaf-96b1-886d6d58c7fe	2026-09-24 12:27	2026-09-24 12:27	2026-09-24 12:27	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.0500	5.0000	5.1500	169.2600	26765.00	0.00	26765.00	53	5	55	43922	0.00125221984426939	0.195894886240414	0.195894886240414	true	false	false	true
b9c68088-9cb9-419e-b492-51c47e023a95	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	XLI	XLI270115P00175000	put	175.0000	2027-01-15	9.2500	9.0500	10.1000	169.4500	28680.00	1850.00	25900.00	31	13	31	1460	0.0212328767123288	0.198185658496895	0.198185658496895	false	false	false	true
c7e6d3e3-ebbe-42c3-96c3-3f233d669cf9	2026-09-24 12:12	2026-09-24 12:12	2026-09-24 12:12	XLI	XLI261120P00169000	put	169.0000	2026-11-20	5.0000	5.0000	5.1000	168.0000	31000.00	0.00	31000.00	62	20	318	844	0.376777251184834	0.196123000906463	0.196123000906463	true	false	false	true
b8e83115-9d7f-488b-aee9-14edc9dbb036	2026-09-24 12:10	2026-09-24 12:10	2026-09-24 12:10	XLI	XLI261120P00169000	put	169.0000	2026-11-20	5.0000	4.9500	5.1500	168.0000	14000.00	0.00	14000.00	28	9	247	844	0.292654028436019	0.19665777753347	0.19665777753347	true	false	false	true
4faa4e8f-1567-453f-955f-73bd8ddc11e5	2026-09-24 11:38	2026-09-24 11:38	2026-09-24 11:38	XLI	XLI261218C00186000	call	186.0000	2026-12-18	1.3700	1.3700	1.8200	168.0000	12057.00	0.00	12057.00	88	17	90	369	0.24390243902439	0.188696222458015	0.188696222458015	false	false	false	true
13b64899-c1d0-4887-9219-291501e1a924	2026-09-24 11:32	2026-09-24 11:32	2026-09-24 11:32	XLI	XLI261016C00169000	call	169.0000	2026-10-16	2.8500	2.8500	3.1000	168.3600	41325.00	0.00	41325.00	145	14	329	623	0.528089887640449	0.179732243662832	0.179732243662832	false	false	false	true
badb3448-bb73-43a8-ae9d-345364dd3b35	2026-09-24 11:31	2026-09-24 11:31	2026-09-24 11:31	XLI	XLI261016P00168000	put	168.0000	2026-10-16	2.6100	2.5200	2.6300	168.4000	91350.00	85869.00	5481.00	350	45	385	1385	0.277978339350181	0.182012178125476	0.182012178125476	false	false	false	true
24d311a4-4ab1-4603-a3aa-3d3497735101	2026-09-24 11:29	2026-09-24 11:29	2026-09-24 11:29	XLI	XLI261023P00172500	put	172.5000	2026-10-23	5.5000	5.0500	5.5000	168.3900	14849.00	14849.00	0.00	27	15	29	48	0.604166666666667	0.179123426557003	0.179123426557003	true	false	false	true
588ccc44-f0eb-4819-890e-f2bb91117cb6	2026-09-24 11:29	2026-09-24 11:29	2026-09-24 11:29	XLI	XLI261016C00168000	call	168.0000	2026-10-16	3.4000	3.4000	3.6500	168.4000	30260.00	0.00	30260.00	89	29	92	79	1.16455696202532	0.181184149608754	0.181184149608754	false	false	false	true
951da792-7f8c-452d-915e-3df4877a9bff	2026-09-24 11:12	2026-09-24 11:12	2026-09-24 11:12	XLI	XLI261023P00171000	put	171.0000	2026-10-23	4.4000	3.9500	4.4000	168.0000	11880.00	11880.00	0.00	27	6	27	14	1.92857142857143	0.1781460396042	0.1781460396042	false	false	false	true
c9809b6b-2025-4081-91e1-9b6355c85107	2026-09-24 11:12	2026-09-24 11:12	2026-09-24 11:12	XLI	XLI261016C00169000	call	169.0000	2026-10-16	3.0000	3.0000	3.3000	168.0000	28200.00	0.00	28200.00	94	19	97	623	0.15569823434992	0.180274231396029	0.180274231396029	false	false	false	true
6c4a7e09-da30-4dec-9a00-5306c4b07128	2026-09-24 11:12	2026-09-24 11:12	2026-09-24 11:12	XLI	XLI261016C00172000	call	172.0000	2026-10-16	1.7100	1.7100	1.9600	168.0000	15048.00	0.00	15048.00	88	18	99	1474	0.0671641791044776	0.177218004798634	0.177218004798634	false	false	false	true
509f2d5d-6a2c-4190-ab50-bb56ccf2ea0e	2026-09-24 10:59	2026-09-24 10:58	2026-09-24 10:58	XLI	XLI261016C00170000	call	170.0000	2026-10-16	2.5400	2.5400	2.6000	168.6900	17526.00	0.00	17526.00	69	13	263	754	0.348806366047745	0.179238839062218	0.179238839062218	true	false	false	true
1214e7f0-eaf0-4c5d-8531-3d933362b3fb	2026-09-24 10:53	2026-09-24 10:53	2026-09-24 10:53	XLI	XLI260925C00170000	call	170.0000	2026-09-25	0.4400	0.4400	0.5000	168.8100	16896.00	0.00	16896.00	384	44	467	232	2.01293103448276	0.256710011121861	0.256710011121861	false	false	false	true
54d1afce-ffa0-4257-90fa-a1f2cf13286f	2026-09-24 10:52	2026-09-24 10:52	2026-09-24 10:52	XLI	XLI261023P00172000	put	172.0000	2026-10-23	4.8500	4.4000	4.9000	168.8400	23280.00	23280.00	0.00	48	5	48	6	8	0.176808885234006	0.176808885234006	false	false	false	true
d91a088c-f1c2-40af-8a70-7db0440b19c5	2026-09-24 10:44	2026-09-24 10:44	2026-09-24 10:44	XLI	XLI261120P00185000	put	185.0000	2026-11-20	16.1500	15.3500	16.1500	169.0300	17765.00	17765.00	0.00	11	11	11	978	0.0112474437627812	0.219815915819972	0.219815915819972	true	false	false	true
2204899e-4ad7-4e49-b3bc-87a96262524d	2026-09-24 10:39	2026-09-24 10:39	2026-09-24 10:39	XLI	XLI261009P00171000	put	171.0000	2026-10-09	3.2000	3.2000	3.2500	169.2850	10560.00	0.00	10560.00	33	8	83	53	1.56603773584906	0.175666588609757	0.175666588609757	true	false	false	true
e8c44fa7-884b-4546-a667-48ca91789ff6	2026-09-24 10:37	2026-09-24 10:36	2026-09-24 10:36	XLI	XLI261009C00185000	call	185.0000	2026-10-09	0.0900	0.0900	0.1300	169.2800	10845.00	0.00	10845.00	1205	49	1206	108	11.1666666666667	0.226443214274857	0.226443214274857	false	false	false	true
629e6616-b74a-4362-b1fc-57886bde5ff8	2026-09-24 10:35	2026-09-24 10:35	2026-09-24 10:35	XLI	XLI270115C00175000	call	175.0000	2027-01-15	5.5000	5.3000	5.5000	169.2400	78100.00	78100.00	0.00	142	9	202	3391	0.0595694485402536	0.186919426971315	0.186919426971315	true	false	false	true
85cc9cd6-1065-48ac-83cb-f110deb43bd7	2026-09-24 10:01	2026-09-24 10:01	2026-09-24 10:01	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.0500	3.0500	3.1500	169.1600	67479.00	0.00	67479.00	221	33	485	14055	0.0345072927783707	0.200007166585474	0.200007166585474	false	false	false	true
6839fa4a-91b4-4400-8341-4512bfccc208	2026-09-24 09:50	2026-09-24 09:50	2026-09-24 09:50	XLI	XLI261016C00170000	call	170.0000	2026-10-16	2.7900	2.1300	2.7900	169.1300	16181.00	16181.00	0.00	58	15	58	754	0.0769230769230769	0.181787906981957	0.181183773414111	true	false	false	true
0798138b-9ce5-400f-9335-90ddef2921df	2026-09-23 15:59	2026-09-23 15:59	2026-09-23 15:59	XLI	XLI261016C00180000	call	180.0000	2026-10-16	0.4700	0.4100	0.4700	170.0000	14099.00	14099.00	0.00	300	34	755	899	0.839822024471635	0.182916037286013	0.182916037286013	false	false	false	true
a1935b21-f829-4708-8697-c98a944f0712	2026-09-23 14:38	2026-09-23 14:38	2026-09-23 14:38	XLI	XLI261016C00159000	call	159.0000	2026-10-16	12.2500	12.2500	12.8000	170.3300	13475.00	0.00	13475.00	11	5	11	2	5.5	0.233627655016002	0.233627655016002	false	false	false	true
44399d10-e3ac-4b07-9d5a-c2e197a6e812	2026-09-23 14:31	2026-09-23 14:31	2026-09-23 14:31	XLI	XLI261002P00171000	put	171.0000	2026-10-02	1.9900	1.6700	1.9900	170.4800	10945.00	10945.00	0.00	55	17	59	14	4.21428571428571	0.169140713238565	0.169140713238565	true	false	false	true
2771c31f-113c-4ea2-a0f0-e94d9e8c3863	2026-09-23 14:28	2026-09-23 14:28	2026-09-23 14:28	XLI	XLI261120P00169000	put	169.0000	2026-11-20	4.1000	3.9500	4.1000	170.5100	145550.00	145550.00	0.00	355	27	834	118	7.06779661016949	0.197046927254227	0.197046927254227	false	false	false	true
16aacccf-a588-4842-82fe-97b7b92e129d	2026-09-23 14:20	2026-09-23 14:20	2026-09-23 14:20	XLI	XLI261120P00169000	put	169.0000	2026-11-20	4.0500	4.0000	4.0500	170.0000	95175.00	95175.00	0.00	235	39	459	118	3.88983050847458	0.197912860479518	0.197912860479518	false	false	false	true
b06857e5-869e-4789-a962-e24b8eacc2ff	2026-09-23 14:15	2026-09-23 14:15	2026-09-23 14:15	XLI	XLI261120C00180000	call	180.0000	2026-11-20	2.1100	2.0500	2.1100	170.7300	31650.00	31650.00	0.00	150	7	178	1393	0.127781765972721	0.18663773402632	0.18663773402632	false	false	false	true
69e2cd9d-896e-4399-bdbd-18814eaf8d6e	2026-09-23 13:59	2026-09-23 13:59	2026-09-23 13:59	XLI	XLI261120C00156000	call	156.0000	2026-11-20	17.0500	17.0000	17.1000	170.8200	23870.00	22165.00	1705.00	14	5	37	3022	0.0122435473196559	0.237635201706113	0.237635201706113	true	false	false	true
63fe3c9b-1537-4ee7-bb1f-84f9b94348c4	2026-09-23 13:50	2026-09-23 13:50	2026-09-23 13:50	XLI	XLI261120C00175000	call	175.0000	2026-11-20	3.8000	3.6500	3.8000	170.7100	20900.00	20900.00	0.00	55	12	110	501	0.219560878243513	0.190833861094735	0.190833861094735	false	false	false	true
193c7fab-7c57-4859-b9a5-ca74f8a0f606	2026-09-23 13:47	2026-09-23 13:47	2026-09-23 13:47	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.7000	2.7000	2.7400	170.0000	16470.00	0.00	16470.00	61	11	7427	10591	0.701255783212161	0.202937496889993	0.202937496889993	false	false	false	true
9743b994-eae2-4adf-a039-77614ab464b0	2026-09-23 13:43	2026-09-23 13:43	2026-09-23 13:43	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6900	2.6800	2.6900	170.0000	147950.00	147950.00	0.00	550	22	6812	10591	0.643187612123501	0.201313469308235	0.201313469308235	false	false	false	true
c228fa58-e7a5-498a-ad9a-bd7aff82bee6	2026-09-23 13:32	2026-09-23 13:32	2026-09-23 13:32	XLI	XLI261016C00175000	call	175.0000	2026-10-16	1.3700	1.3600	1.3700	170.5300	62472.00	62472.00	0.00	456	25	488	735	0.663945578231293	0.171295244078048	0.171295244078048	false	false	false	true
f8976059-efef-4dfa-b7cd-d29934eafcc8	2026-09-23 13:03	2026-09-23 13:03	2026-09-23 13:03	XLI	XLI261023P00172500	put	172.5000	2026-10-23	4.2000	3.8500	4.2000	170.3500	11760.00	11760.00	0.00	28	7	28	21	1.33333333333333	0.17096606019638	0.17096606019638	true	false	false	true
d5378c56-4f33-4d79-bc12-589901ef8f7d	2026-09-23 12:59	2026-09-23 12:59	2026-09-23 12:59	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6700	2.6300	2.7400	170.6250	52660.00	0.00	52660.00	197	8	4237	10591	0.400056651874233	0.201786910738247	0.200934725123527	false	false	false	true
22dcb77d-2cd2-47ea-9f71-9f7cebf0ae7d	2026-09-23 12:56	2026-09-23 12:56	2026-09-23 12:56	XLI	XLI261030P00170000	put	170.0000	2026-10-30	3.3000	3.1500	3.3000	170.5700	54450.00	54450.00	0.00	165	26	166	5	33.2	0.180880903233172	0.180880903233172	false	false	false	true
4ba86c31-b603-4b5f-b75a-e22eed85aea6	2026-09-23 12:40	2026-09-23 12:40	2026-09-23 12:40	XLI	XLI261002P00165000	put	165.0000	2026-10-02	0.3400	0.3300	0.3800	170.0000	39542.00	34.00	39508.00	1163	17	3067	2173	1.41141279337322	0.196168735822697	0.196168735822697	false	false	false	true
5a6c67f6-a5b7-4184-9d3f-f0dd8e7826c8	2026-09-23 11:51	2026-09-23 11:51	2026-09-23 11:51	XLI	XLI261030P00168000	put	168.0000	2026-10-30	2.5700	2.4400	2.5700	170.0000	39321.00	39321.00	0.00	153	28	171	10	17.1	0.182854430204968	0.182854430204968	false	false	false	true
93695f27-2664-4824-a9ed-dc3699243799	2026-09-23 11:32	2026-09-23 11:32	2026-09-23 11:32	XLI	XLI261009P00167000	put	167.0000	2026-10-09	1.0800	0.9400	1.0800	170.6200	50868.00	50868.00	0.00	471	37	473	13	36.3846153846154	0.182933834192665	0.182933834192665	false	false	false	true
6de457d0-1926-4d73-a29e-729ac54d70bc	2026-09-23 11:29	2026-09-23 11:29	2026-09-23 11:29	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.5900	2.5100	2.5900	170.0000	33670.00	33670.00	0.00	130	6	2398	10591	0.226418657350581	0.199684634705009	0.199684634705009	true	false	false	true
97d9c007-27c3-4420-b76f-018def6b87d3	2026-09-23 11:25	2026-09-23 11:25	2026-09-23 11:25	XLI	XLI261002P00165000	put	165.0000	2026-10-02	0.3200	0.3200	0.3600	170.9800	60544.00	0.00	60544.00	1892	21	1897	2173	0.872986654394846	0.200414076869581	0.200414076869581	false	false	false	true
d5696e7c-2ee9-49ae-8e57-8d4a3ac169fb	2026-09-23 11:10	2026-09-23 11:10	2026-09-23 11:10	XLI	XLI261009C00173000	call	173.0000	2026-10-09	1.5100	1.3500	1.5100	170.7000	67648.00	67648.00	0.00	448	35	449	297	1.51178451178451	0.165756110015379	0.165756110015379	false	false	false	true
e78a726a-96eb-430b-a406-0ec8ea7dfedb	2026-09-23 11:06	2026-09-23 11:06	2026-09-23 11:06	XLI	XLI261023P00166000	put	166.0000	2026-10-23	1.6100	1.4700	1.7600	170.4401	51842.00	50715.00	1127.00	322	53	323	1	323	0.186033625564345	0.185355797648408	true	false	false	true