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.

708,051 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts708,051 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/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	expiry

6f616a59-77fd-42bb-b8a5-b2ed5ef243e7	2026-09-15 11:03	2026-09-15 11:03	2026-09-15 11:03	XLI	XLI270319C00170000	call	170.0000	2027-03-19	10.1000	9.9000	10.2500	168.0000	21210.00	15150.00	6060.00	21	5	21	102	0.205882352941176	0.187373840021	0.187373840021	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30796170295.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-15T15:09:54.469160Z"}	2026-09-15	2026-09-15 21:15	2026-09-15 21:15
6fd89592-94f3-4bdb-a5b0-0d99e0b14cfa	2026-09-15 10:58	2026-09-15 10:58	2026-09-15 10:58	XLI	XLI260925P00164000	put	164.0000	2026-09-25	0.7800	0.6800	0.7800	168.0000	11154.00	11154.00	0.00	143	20	155	11	14.0909090909091	0.224792546732199	0.224265526398428	false	false	false	true
6bfa9a6e-e6ac-4944-bb01-bc5ede0ccb29	2026-09-15 10:50	2026-09-15 10:50	2026-09-15 10:50	XLI	XLI260925P00166000	put	166.0000	2026-09-25	1.2200	1.1000	1.2200	168.7300	18788.00	18788.00	0.00	154	23	159	4	39.75	0.217222217116478	0.217222217116478	false	false	false	true
c90060bd-d56c-4035-a919-d63da16c7a8d	2026-09-15 10:43	2026-09-15 10:42	2026-09-15 10:42	XLI	XLI260925C00169000	call	169.0000	2026-09-25	1.9200	1.9200	2.1400	168.7700	22464.00	0.00	22464.00	117	9	117	2	58.5	0.174394823935282	0.174394823935282	true	false	false	true
e0c25a77-7fcf-49cd-8f4e-4d0623707479	2026-09-15 10:39	2026-09-15 10:39	2026-09-15 10:39	XLI	XLI261016P00164000	put	164.0000	2026-10-16	1.9500	1.8500	1.9500	168.8700	54210.00	54210.00	0.00	278	35	431	972	0.443415637860082	0.212713555542038	0.212713555542038	false	false	false	true
5f3c0a2b-4940-48f0-b000-15ae524297e7	2026-09-15 10:29	2026-09-15 10:29	2026-09-15 10:29	XLI	XLI261016P00164000	put	164.0000	2026-10-16	1.9000	1.7900	1.9000	168.9500	28689.00	28689.00	0.00	151	17	152	972	0.156378600823045	0.211095260115362	0.210496060926604	false	false	false	true
1593209d-4076-4113-a74b-354d008e62d7	2026-09-15 10:11	2026-09-15 10:11	2026-09-15 10:11	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.8100	1.6200	1.8100	169.1800	27874.00	27874.00	0.00	154	24	427	5706	0.0748335085874518	0.227351063769589	0.227351063769589	false	false	false	true
5c4dedfc-d6d1-4a03-9e21-ac7d655333e9	2026-09-15 10:06	2026-09-15 10:06	2026-09-15 10:06	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7400	1.7400	1.8100	169.1600	16008.00	0.00	16008.00	92	23	261	5706	0.0457413249211356	0.213669443476598	0.213669443476598	true	false	false	true
acea9c70-0d88-4c12-a1b5-6fd0dde24698	2026-09-15 10:06	2026-09-15 10:06	2026-09-15 10:06	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7300	1.5500	1.8100	169.1600	17300.00	5017.00	2768.00	100	6	109	5706	0.0191026989134245	0.211991048610781	0.211991048610781	false	false	false	true
b91a1d07-1591-46bc-aefa-c24cf512a1f3	2026-09-15 09:33	2026-09-15 09:33	2026-09-15 09:33	XLI	XLI261016C00170000	call	170.0000	2026-10-16	3.6600	3.6500	3.9000	169.8158	21975.00	0.00	21975.00	60	6	60	302	0.198675496688742	0.174753892065331	0.177292904677353	false	false	false	true
d5bd2a33-b943-48b3-b099-cab4427d46ae	2026-09-14 14:56	2026-09-14 14:56	2026-09-14 14:56	XLI	XLI290119C00170000	call	170.0000	2029-01-19	29.4600	27.4500	30.7000	170.0550	20620.00	14730.00	5890.00	7	5	7	0	0	0.219950054491755	0.219950054491755	true	false	false	true
d0da4e93-ada0-45e2-8195-a4c99ef68262	2026-09-14 14:52	2026-09-14 14:52	2026-09-14 14:52	XLI	XLI261016C00174000	call	174.0000	2026-10-16	2.0500	1.7700	2.0600	169.9500	19475.00	19270.00	205.00	95	18	119	562	0.211743772241993	0.172732341094502	0.172732341094502	true	false	false	true
3a34d02c-76cc-4b94-8bb6-83713bcf278a	2026-09-14 13:49	2026-09-14 13:49	2026-09-14 13:49	XLI	XLI260918C00175000	call	175.0000	2026-09-18	0.1300	0.1200	0.1500	169.6900	15431.00	0.00	15379.00	1187	17	2954	407	7.25798525798526	0.204642799301686	0.204642799301686	false	false	false	true
4c6d11db-823c-46db-8d90-1ff274e726c7	2026-09-14 13:41	2026-09-14 13:41	2026-09-14 13:41	XLI	XLI261016P00160000	put	160.0000	2026-10-16	1.0000	0.9300	1.0000	169.7400	37100.00	37100.00	0.00	371	39	377	1074	0.351024208566108	0.223284270793273	0.223284270793273	false	false	false	true
be46a813-6114-4a9f-890f-310dc65c41cb	2026-09-14 12:56	2026-09-14 12:55	2026-09-14 12:55	XLI	XLI261009P00165000	put	165.0000	2026-10-09	1.5000	1.3600	1.5000	169.9500	57750.00	57750.00	0.00	385	38	389	23	16.9130434782609	0.203963967208664	0.203963967208664	false	false	false	true
7f4cad8d-5b66-48d1-b94e-93b6aac25b74	2026-09-14 12:46	2026-09-14 12:46	2026-09-14 12:46	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.4000	3.4000	3.5000	169.6800	15980.00	0.00	15980.00	47	12	118	9251	0.0127553777969949	0.206723958815761	0.206723958815761	true	false	false	true
3fe23849-04fc-4556-b508-c703bf2b912f	2026-09-14 12:40	2026-09-14 12:40	2026-09-14 12:40	XLI	XLI260918C00175000	call	175.0000	2026-09-18	0.1500	0.1500	0.2200	169.6600	23820.00	0.00	23820.00	1588	23	1732	407	4.25552825552826	0.212908567099121	0.212908567099121	false	false	false	true
0c83d697-cc7c-4c5d-9eaa-ea80de2aca2c	2026-09-14 12:16	2026-09-14 12:16	2026-09-14 12:16	XLI	XLI261120C00175000	call	175.0000	2026-11-20	3.7000	3.6500	3.8000	170.0000	30710.00	29230.00	1480.00	83	8	85	429	0.198135198135198	0.182075394511938	0.182075394511938	false	false	false	true
912a5829-8089-438f-b356-9a96e8c03c91	2026-09-14 11:50	2026-09-14 11:49	2026-09-14 11:49	XLI	XLI261009P00164000	put	164.0000	2026-10-09	1.3900	1.2200	1.3900	169.6700	10425.00	10425.00	0.00	75	21	89	1	89	0.210290231325991	0.210290231325991	false	false	false	true
7d35f6b6-79c3-4fa7-83c7-ffd60a68419a	2026-09-14 11:43	2026-09-14 11:43	2026-09-14 11:43	XLI	XLI270319C00173000	call	173.0000	2027-03-19	9.3000	9.1000	9.3000	169.7550	74400.00	74400.00	0.00	80	15	80	33	2.42424242424242	0.194093274272817	0.194093274272817	false	false	false	true
790dd0af-aa89-4510-bdfb-bb00ab8a3f73	2026-09-14 11:00	2026-09-14 11:00	2026-09-14 11:00	XLI	XLI261218P00174000	put	174.0000	2026-12-18	8.7500	8.0500	8.7500	168.9500	19250.00	19250.00	0.00	22	15	22	90	0.244444444444444	0.203085472461007	0.203085472461007	true	false	false	true
9d2c664e-76fe-4323-b4b7-3020c9c773b9	2026-09-14 10:56	2026-09-14 10:56	2026-09-14 10:56	XLI	XLI261023C00164000	call	164.0000	2026-10-23	7.5500	7.2500	8.3000	169.0100	34720.00	745.00	33975.00	46	10	46	0	0	0.18994509524786	0.184554086771783	false	false	false	true
462ba414-9666-47a2-8c66-f89047ab7c56	2026-09-14 10:50	2026-09-14 10:50	2026-09-14 10:50	XLI	XLI261030C00150000	call	150.0000	2026-10-30	19.9500	19.0500	22.3500	169.1200	107745.00	2010.00	105735.00	54	22	54	0	0	0.169798184199453	0.169798184199453	true	false	false	true
0cc2eb29-4fda-410f-aae4-eab08dd5c263	2026-09-14 10:47	2026-09-14 10:47	2026-09-14 10:47	XLI	XLI261218C00167000	call	167.0000	2026-12-18	8.7500	8.7500	9.3500	169.2600	16625.00	0.00	16625.00	19	7	19	45	0.422222222222222	0.191745602521169	0.191745602521169	true	false	false	true
2d26c1d3-2728-4675-9030-447b08310f9c	2026-09-14 10:18	2026-09-14 10:18	2026-09-14 10:18	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7000	1.6100	1.7000	169.0000	17000.00	11050.00	0.00	100	6	191	5272	0.0362291350531108	0.231311267775408	0.231311267775408	false	false	false	true
20c9f33a-7727-4c52-84f7-bdff1148c368	2026-09-14 10:18	2026-09-14 10:18	2026-09-14 10:18	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7000	1.6600	1.8100	169.0000	25500.00	510.00	24990.00	150	32	341	5272	0.0646813353566009	0.231311267775408	0.231311267775408	true	false	false	true
0d04178c-0381-4d97-85f8-63a9735ca9eb	2026-09-14 10:17	2026-09-14 10:17	2026-09-14 10:17	XLI	XLI261120C00171000	call	171.0000	2026-11-20	5.5000	5.3500	5.7500	169.0000	49500.00	20350.00	29150.00	90	10	90	144	0.625	0.187983824669725	0.187983824669725	true	false	false	true
a29c12e5-6e18-4a93-8ec9-499877fef377	2026-09-14 09:32	2026-09-14 09:32	2026-09-14 09:32	XLI	XLI260918P00170000	put	170.0000	2026-09-18	2.5300	2.1100	2.8000	168.4800	12634.00	12634.00	0.00	50	6	73	5272	0.0138467374810319	0.242011161340439	0.242011161340439	false	false	false	true
4073d53f-8ab4-4a38-a4a5-1cbacc7ec78e	2026-09-11 14:31	2026-09-11 14:30	2026-09-11 14:30	XLI	XLI261016P00175000	put	175.0000	2026-10-16	5.0000	4.8000	5.0000	172.6212	42500.00	42500.00	0.00	85	20	91	121	0.752066115702479	0.19087022162784	0.19087022162784	true	false	false	true
987b52bf-2a08-4c12-bfe3-59c9ca412853	2026-09-11 14:26	2026-09-11 14:26	2026-09-11 14:26	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0700	1.0300	1.0700	172.6700	49541.00	49541.00	0.00	463	40	3769	10063	0.374540395508298	0.233184758668986	0.233184758668986	false	false	false	true
db6cb6b2-bb06-4c8f-a5b2-c2c741b5b1ec	2026-09-11 14:26	2026-09-11 14:26	2026-09-11 14:26	XLI	XLI261016C00174000	call	174.0000	2026-10-16	3.2000	3.2000	3.3500	172.6650	109768.00	0.00	109768.00	343	44	461	109	4.22935779816514	0.164888029872303	0.164888029872303	false	false	false	true
044bde53-8c43-471e-a57a-ce7fbe12ffc2	2026-09-11 14:26	2026-09-11 14:26	2026-09-11 14:26	XLI	XLI261016C00173000	call	173.0000	2026-10-16	3.7000	3.7000	3.8500	172.6650	25530.00	0.00	25530.00	69	17	228	1362	0.167400881057269	0.165811497207414	0.165811497207414	false	false	false	true
3e021e67-9598-4b75-8929-217ab4026d33	2026-09-11 14:24	2026-09-11 14:23	2026-09-11 14:23	XLI	XLI270319C00190000	call	190.0000	2027-03-19	4.0700	3.7500	4.1000	172.7000	11790.00	5715.00	6075.00	29	5	29	454	0.0638766519823789	0.17930188131196	0.178155814859665	false	false	false	true
a00a05d8-b2ab-4ef1-9c8e-8d07fd4adee8	2026-09-11 14:20	2026-09-11 14:20	2026-09-11 14:20	XLI	XLI261016C00174000	call	174.0000	2026-10-16	3.3000	3.3000	3.4000	172.8100	36300.00	0.00	36300.00	110	20	118	109	1.08256880733945	0.16629013804783	0.16629013804783	false	false	false	true
66f26187-72e3-4722-a2d8-43030a1cfbf1	2026-09-11 14:20	2026-09-11 14:20	2026-09-11 14:20	XLI	XLI261016C00173000	call	173.0000	2026-10-16	3.8000	3.8000	3.9000	172.8100	15960.00	0.00	15960.00	42	14	159	1362	0.116740088105727	0.166910892027781	0.166910892027781	false	false	false	true
e9a47069-81c8-46ac-b1cb-530dfcf6a23a	2026-09-11 13:38	2026-09-11 13:38	2026-09-11 13:38	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.2000	4.2000	4.2500	172.6450	21000.00	0.00	21000.00	50	10	60	55407	0.00108289566300287	0.200145647447189	0.200145647447189	true	false	false	true
44c89499-8d27-4af0-a289-d5c4b2b95052	2026-09-11 13:34	2026-09-11 13:34	2026-09-11 13:34	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6000	2.6000	2.7100	172.6900	12740.00	0.00	12740.00	49	15	1818	9478	0.191812618695927	0.206030032796259	0.206030032796259	false	false	false	true
c5332f68-f6ea-498a-965a-da604a7632dd	2026-09-11 13:27	2026-09-11 13:27	2026-09-11 13:27	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6000	2.6000	2.6800	172.7400	10141.00	0.00	10141.00	39	13	1722	9478	0.181683899556869	0.206562302651902	0.20696800113098	false	false	false	true
376bd388-a487-42ed-a9d0-d97cbaa7ab4f	2026-09-11 13:23	2026-09-11 13:23	2026-09-11 13:23	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.1700	0.1700	0.2000	172.7400	15181.00	0.00	15181.00	893	17	906	53263	0.0170099318476241	0.229569578008406	0.229569578008406	false	false	false	true
0c853c80-ca3a-4ee5-ab40-b697bbc451f2	2026-09-11 13:15	2026-09-11 13:15	2026-09-11 13:15	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6500	2.6300	2.6500	172.6900	11395.00	11395.00	0.00	43	5	822	9478	0.0867271576281916	0.208054077247043	0.208054077247043	false	false	false	true
99c96dba-2c61-4800-b12f-7ed4147e28f4	2026-09-11 13:14	2026-09-11 13:13	2026-09-11 13:13	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6500	2.6200	2.6500	172.6900	11130.00	11130.00	0.00	42	6	721	9478	0.0760709010339734	0.208054077247043	0.208054077247043	true	false	false	true
0731b57e-9dbc-4d8b-b67e-c389af0c4f3c	2026-09-11 13:12	2026-09-11 13:11	2026-09-11 13:11	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0700	1.0300	1.0700	172.6794	25252.00	25252.00	0.00	236	6	1443	10063	0.14339660141111	0.233259018414961	0.233259018414961	false	false	false	true
c1b5aa5b-a323-4bda-ba01-ebc0e05ce8cc	2026-09-11 13:11	2026-09-11 13:11	2026-09-11 13:11	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.6600	2.6600	2.7400	172.6650	20216.00	0.00	20216.00	76	27	483	9478	0.05096011816839	0.20819064199202	0.20819064199202	false	false	false	true
5c1bfe49-32fa-48e2-89bb-95a43bef1393	2026-09-11 13:08	2026-09-11 13:08	2026-09-11 13:08	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0800	1.0000	1.0800	172.5700	23588.00	16740.00	6848.00	219	20	718	10063	0.0713504919010235	0.233059323206901	0.232394084351916	false	false	false	true
835e1e4b-c2c4-4bc2-a84f-5e4e67d6a22e	2026-09-11 13:07	2026-09-11 13:07	2026-09-11 13:07	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.7000	2.6600	2.7000	172.5350	20250.00	20250.00	0.00	75	5	282	9478	0.0297531124709854	0.208406188968236	0.208406188968236	false	false	false	true
3eb391ba-aa9a-4958-b927-aec24310cd0d	2026-09-11 13:01	2026-09-11 13:01	2026-09-11 13:01	XLI	XLI261120P00155000	put	155.0000	2026-11-20	1.0600	1.0600	1.2100	172.6452	24698.00	0.00	24698.00	233	36	235	10063	0.0233528768756832	0.232320203795709	0.232320203795709	false	false	false	true
bac3e5f2-c991-4e38-adf8-a2844f4a0aa9	2026-09-11 13:00	2026-09-11 13:00	2026-09-11 13:00	XLI	XLI260918C00178000	call	178.0000	2026-09-18	0.2300	0.2300	0.2900	172.5950	17457.00	0.00	17457.00	759	21	766	215	3.56279069767442	0.177503232368179	0.177503232368179	false	false	false	true
79f0e0d9-9db9-44c7-a178-757c82973c6e	2026-09-11 12:51	2026-09-11 12:51	2026-09-11 12:51	XLI	XLI270319P00163000	put	163.0000	2027-03-19	5.0500	4.9000	5.0500	172.6100	37370.00	37370.00	0.00	74	17	148	98	1.51020408163265	0.217098268453738	0.217098268453738	false	false	false	true
e39375cf-caa3-4e33-9eee-7b4b3cb69676	2026-09-11 12:44	2026-09-11 12:44	2026-09-11 12:44	XLI	XLI261016C00178000	call	178.0000	2026-10-16	1.7400	1.7400	1.8000	172.5600	25926.00	0.00	25926.00	149	24	159	1577	0.100824350031706	0.168175548952241	0.168175548952241	false	false	false	true
b4b2ef20-d7b6-4357-bd28-8762edf81495	2026-09-11 12:44	2026-09-11 12:44	2026-09-11 12:44	XLI	XLI261016C00173000	call	173.0000	2026-10-16	3.7500	3.7500	3.9000	172.5600	25500.00	0.00	25500.00	68	19	72	1362	0.052863436123348	0.17073785836624	0.17073785836624	false	false	false	true