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

be7d8af1-fc94-4feb-a6ba-09816aedb255	2026-09-16 09:54	2026-09-16 09:54	2026-09-16 09:54	XLI	XLI260918P00169000	put	169.0000	2026-09-18	1.0500	0.9600	1.0500	169.5100	13125.00	13125.00	0.00	125	40	125	1057	0.118259224219489	0.261128933540333	0.261128933540333	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30388493380.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T13:59:45.783389Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
53dca497-2e8a-458e-bac3-e58a69c508ea	2026-09-15 15:12	2026-09-15 15:11	2026-09-15 15:11	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.2000	1.1500	1.2300	168.9900	68760.00	59640.00	8400.00	573	47	1273	5	254.6	0.179958777560161	0.179958777560161	false	false	false	true
dd5d3630-d11b-4abd-a2d1-ef5a8d232819	2026-09-15 13:59	2026-09-15 13:59	2026-09-15 13:59	XLI	XLI261016P00164000	put	164.0000	2026-10-16	1.9500	1.8400	1.9700	169.1750	199680.00	197534.00	2146.00	1024	15	3946	972	4.059670781893	0.217914841872467	0.218514493967436	false	false	false	true
161e840a-1b7a-45c3-92b9-3648f3587517	2026-09-15 13:24	2026-09-15 13:24	2026-09-15 13:24	XLI	XLI260925P00169000	put	169.0000	2026-09-25	2.3500	2.2800	2.3600	168.9801	40184.00	40184.00	0.00	171	28	171	34	5.02941176470588	0.21792251421475	0.21792251421475	false	false	false	true
e489f29c-5e3d-4277-86ab-07e5e6320703	2026-09-15 13:22	2026-09-15 13:22	2026-09-15 13:22	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.2000	1.1400	1.2700	168.9700	10320.00	0.00	9960.00	86	31	314	5	62.8	0.180193405971989	0.180427934168364	false	false	false	true
35cc7f0c-73c3-46f6-a622-75f578f25b5e	2026-09-15 13:16	2026-09-15 13:15	2026-09-15 13:15	XLI	XLI261016P00170000	put	170.0000	2026-10-16	4.2000	3.8500	4.3000	169.0800	13860.00	13860.00	0.00	33	5	235	2022	0.1162215628091	0.204853886075757	0.204853886075757	false	false	false	true
ed47ec44-0f7c-458d-91de-c719f0456589	2026-09-15 12:52	2026-09-15 12:52	2026-09-15 12:52	XLI	XLI261218C00175000	call	175.0000	2026-12-18	4.7500	4.7000	4.7500	169.3700	14250.00	14250.00	0.00	30	7	30	226	0.132743362831858	0.186259721864856	0.186259721864856	false	false	false	true
347d8367-7233-4e1c-a0ab-8cff45b5445d	2026-09-15 12:40	2026-09-15 12:40	2026-09-15 12:40	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7400	1.7400	1.8200	169.0000	24012.00	0.00	24012.00	138	17	696	5706	0.121976866456362	0.217604725862897	0.217604725862897	true	false	false	true
4c2807db-7c4b-4bf1-9abd-87a477d99315	2026-09-15 12:39	2026-09-15 12:39	2026-09-15 12:39	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.7900	1.7200	1.7900	169.0000	14678.00	4654.00	0.00	82	5	545	5706	0.0955134945671223	0.224594429161775	0.224594429161775	false	false	false	true
1c08edc9-770f-41c0-89a5-78672391c1c9	2026-09-15 12:34	2026-09-15 12:33	2026-09-15 12:33	XLI	XLI261002C00171000	call	171.0000	2026-10-02	1.9300	1.6100	2.0100	169.0000	11001.00	10808.00	193.00	57	15	60	4	15	0.176656750010429	0.176656750010429	true	false	false	true
025b1716-7722-4298-bf32-c6d2f3c8f8a7	2026-09-15 12:28	2026-09-15 12:28	2026-09-15 12:28	XLI	XLI261218C00171000	call	171.0000	2026-12-18	6.5000	6.3500	6.5000	169.0000	36400.00	36400.00	0.00	56	19	56	2	28	0.189997326503842	0.189997326503842	false	false	false	true
dffead5e-fbc5-42d7-8618-26f3acb5bc9b	2026-09-15 12:26	2026-09-15 12:26	2026-09-15 12:26	XLI	XLI261016P00164000	put	164.0000	2026-10-16	1.9300	1.8900	1.9900	169.0000	10229.00	386.00	9843.00	53	11	2848	972	2.93004115226337	0.215782419318698	0.215782419318698	true	false	false	true
c0fdba91-3346-46f3-900f-a23a75f53731	2026-09-15 12:24	2026-09-15 12:24	2026-09-15 12:24	XLI	XLI261218C00173000	call	173.0000	2026-12-18	5.4500	5.1500	5.4500	168.0000	24525.00	24525.00	0.00	45	12	45	1042	0.0431861804222649	0.18816984429867	0.18816984429867	true	false	false	true
e6882408-58a0-4628-ba1d-ac4ab212a78b	2026-09-15 11:55	2026-09-15 11:55	2026-09-15 11:55	XLI	XLI260925P00168000	put	168.0000	2026-09-25	1.9400	1.7800	1.9400	168.8000	36472.00	36472.00	0.00	188	32	188	24	7.83333333333333	0.215843030039996	0.215843030039996	false	false	false	true
4098aa6d-0c4c-4b98-9bde-e934e66fbd0d	2026-09-15 11:21	2026-09-15 11:21	2026-09-15 11:21	XLI	XLI261016P00164000	put	164.0000	2026-10-16	2.1000	1.9900	2.1000	168.6200	142380.00	142380.00	0.00	678	47	1125	972	1.15740740740741	0.217228850516002	0.217228850516002	false	false	false	true
34840c1d-8ea9-4868-9cdf-f43d9b0e8ff4	2026-09-15 11:17	2026-09-15 11:17	2026-09-15 11:17	XLI	XLI270319C00189000	call	189.0000	2027-03-19	2.9800	2.9800	3.1000	168.6300	16390.00	0.00	16390.00	55	16	75	10	7.5	0.175927911728978	0.175927911728978	true	false	false	true
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
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
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
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
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