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

5d073929-8704-4d0f-bb54-c27b2e1910ae	2026-09-09 10:33	2026-09-09 10:33	2026-09-09 10:33	XLI	XLI260925P00176000	put	176.0000	2026-09-25	4.8500	4.6000	4.9000	172.0000	13090.00	13090.00	0.00	27	15	27	28	0.964285714285714	0.216162985781948	0.216162985781948	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	31280067977.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T14:40:24.011597Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
713cae57-429f-4b7e-bfec-45473260ff85	2026-09-09 10:30	2026-09-09 10:30	2026-09-09 10:30	XLI	XLI261016C00174000	call	174.0000	2026-10-16	3.8000	3.5500	3.8500	172.0000	22800.00	22800.00	0.00	60	21	60	50	1.2	0.183185520882476	0.183185520882476	true	false	false	true
1d17fbef-945a-448b-aaa6-f67202041e33	2026-09-09 10:25	2026-09-09 10:24	2026-09-09 10:24	XLI	XLI261120C00170000	call	170.0000	2026-11-20	7.9000	7.9000	8.4000	172.0000	20545.00	795.00	19750.00	26	13	26	119	0.218487394957983	0.192568457221756	0.192568457221756	false	false	false	true
5759c67c-43ce-408e-a47c-25eff35a4f6f	2026-09-09 10:22	2026-09-09 10:22	2026-09-09 10:22	XLI	XLI261016P00166000	put	166.0000	2026-10-16	1.7700	1.6900	1.7700	172.5650	12567.00	12567.00	0.00	71	8	75	295	0.254237288135593	0.20912167535188	0.20912167535188	false	false	false	true
4daadeb2-2d43-4f5f-8079-0f0b1f2b7695	2026-09-09 10:22	2026-09-09 10:21	2026-09-09 10:21	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1400	0.9800	1.1400	172.5500	26334.00	26334.00	0.00	231	35	382	4659	0.0819918437432925	0.208769388598449	0.208769388598449	true	false	false	true
4ab33f8d-c936-446f-829d-0e3d71568ec0	2026-09-09 09:46	2026-09-09 09:46	2026-09-09 09:46	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.3000	0.9500	1.3100	173.0050	19018.00	19018.00	0.00	146	18	146	461	0.316702819956616	0.205815693974954	0.206817251127122	true	false	false	true
5aff50f1-4cdb-43e5-b336-182454840c36	2026-09-08 15:22	2026-09-08 15:22	2026-09-08 15:22	XLI	XLI261016C00181000	call	181.0000	2026-10-16	1.9500	1.9500	2.0900	174.9700	29445.00	0.00	29445.00	151	29	152	56	2.71428571428571	0.177638451601807	0.177638451601807	false	false	false	true
dc551a44-d0e3-48e4-9988-309756dae5a8	2026-09-08 14:33	2026-09-08 14:33	2026-09-08 14:33	XLI	XLI260918P00182000	put	182.0000	2026-09-18	6.9000	6.8500	6.9500	175.3250	23460.00	0.00	4140.00	34	7	250	485	0.515463917525773	0.200961056339111	0.200961056339111	false	false	false	true
f44618c9-4b96-4170-9376-2e7f98deebc1	2026-09-08 14:33	2026-09-08 14:33	2026-09-08 14:33	XLI	XLI260918P00182000	put	182.0000	2026-09-18	6.9000	6.9000	6.9500	175.3300	57960.00	0.00	57960.00	84	5	203	485	0.418556701030928	0.201620484898286	0.201620484898286	false	false	false	true
381fc66f-9027-4da5-bcf9-8d6c0e83b239	2026-09-08 14:33	2026-09-08 14:33	2026-09-08 14:33	XLI	XLI260918P00182000	put	182.0000	2026-09-18	6.9000	6.8500	7.3000	175.3400	69000.00	13110.00	24840.00	100	6	119	485	0.245360824742268	0.202927644815432	0.202927644815432	false	false	false	true
16db9ee2-b4fd-4864-8551-c4bb84808894	2026-09-08 13:38	2026-09-08 13:38	2026-09-08 13:38	XLI	XLI260918P00175000	put	175.0000	2026-09-18	2.0400	2.0400	2.1500	175.1450	33048.00	0.00	33048.00	162	18	208	4556	0.0456540825285338	0.190360143613824	0.190360143613824	false	false	false	true
96eaa445-7624-4f6a-a8ee-951233b360e3	2026-09-08 12:38	2026-09-08 12:38	2026-09-08 12:38	XLI	XLI261016C00175000	call	175.0000	2026-10-16	4.4500	4.4000	4.6000	175.0300	19135.00	0.00	19135.00	43	12	77	255	0.301960784313725	0.181043191867134	0.181043191867134	true	false	false	true
bff9c1c0-ac1d-4372-a835-2a8728d3a2cd	2026-09-08 10:09	2026-09-08 10:09	2026-09-08 10:09	XLI	XLI261120P00175000	put	175.0000	2026-11-20	5.6500	5.6000	5.6500	174.6900	11300.00	11300.00	0.00	20	11	486	12877	0.0377417100256271	0.198381889472834	0.198381889472834	false	false	false	true
f0b83bea-4f3c-401b-ba9a-f489e08b5d94	2026-09-08 10:06	2026-09-08 10:06	2026-09-08 10:06	XLI	XLI261120P00175000	put	175.0000	2026-11-20	5.6500	5.5500	5.6500	174.8200	198315.00	198315.00	0.00	351	25	422	12877	0.0327716082938573	0.20028609255016	0.20028609255016	false	false	false	true
2ad8974a-ab27-41a7-8d6f-7f26974dcba5	2026-09-08 10:01	2026-09-08 10:01	2026-09-08 10:01	XLI	XLI261120P00175000	put	175.0000	2026-11-20	5.6500	5.5500	5.6500	175.1000	16950.00	16950.00	0.00	30	17	34	12877	0.00264036654500272	0.204344089767973	0.204344089767973	false	false	false	true
0ee8a2f9-39c3-42b1-8bf4-d800de4414d9	2026-09-08 09:41	2026-09-08 09:41	2026-09-08 09:41	XLI	XLI260911P00174000	put	174.0000	2026-09-11	0.9900	0.8500	0.9900	174.7100	10197.00	10197.00	0.00	103	29	257	41	6.26829268292683	0.21213397544566	0.21213397544566	false	false	false	true
4095c3a5-1826-4e97-8c0a-a409dd9a3463	2026-09-08 09:41	2026-09-08 09:41	2026-09-08 09:41	XLI	XLI260911P00174000	put	174.0000	2026-09-11	0.9300	0.7000	0.9350	174.7600	13856.00	13764.00	92.00	149	8	149	41	3.63414634146341	0.205621034207178	0.203984208414911	true	false	false	true
2a76f0ea-cf81-4da4-8188-367decc6aadf	2026-09-04 13:43	2026-09-04 13:43	2026-09-04 13:43	XLI	XLI261120C00180000	call	180.0000	2026-11-20	4.1000	4.0000	4.3000	174.8000	19680.00	18860.00	820.00	48	12	54	469	0.115138592750533	0.178421133152967	0.178421133152967	false	false	false	true
115d2aaa-6742-4ded-b09d-e186d3ca6366	2026-09-04 13:04	2026-09-04 13:03	2026-09-04 13:03	XLI	XLI261120P00180000	put	180.0000	2026-11-20	8.1500	7.6500	8.1500	175.1800	36675.00	36675.00	0.00	45	12	45	8951	0.00502737124343649	0.195566068224599	0.195566068224599	true	false	false	true
8d7cca04-d656-4c9c-92b9-fb1bf3c3c7c8	2026-09-04 12:59	2026-09-04 12:59	2026-09-04 12:59	XLI	XLI270115C00185000	call	185.0000	2027-01-15	4.3500	4.3000	4.4000	175.2800	11745.00	4350.00	0.00	27	11	79	8248	0.00957807953443259	0.172714746570183	0.172714746570183	false	false	false	true
a1819751-07d5-4a23-94c2-b7d7eb6464c1	2026-09-04 12:59	2026-09-04 12:59	2026-09-04 12:59	XLI	XLI270115C00185000	call	185.0000	2027-01-15	4.3500	4.3000	4.4500	175.2700	13050.00	435.00	12615.00	30	12	34	8248	0.00412221144519884	0.172806879596742	0.172806879596742	false	false	false	true
667d3ea2-27d6-4622-86e5-dc0039d7856b	2026-09-04 12:52	2026-09-04 12:52	2026-09-04 12:52	XLI	XLI261120C00195000	call	195.0000	2026-11-20	0.8300	0.7600	0.8300	175.2800	31954.00	31954.00	0.00	385	43	419	11157	0.0375548982701443	0.177529899008229	0.177529899008229	false	false	false	true
8477b1b4-07d4-445a-8f8a-d1326773096f	2026-09-04 11:31	2026-09-04 11:31	2026-09-04 11:31	XLI	XLI260918P00170000	put	170.0000	2026-09-18	0.7100	0.6300	0.7300	174.8250	106500.00	21797.00	12780.00	1500	22	1508	3959	0.380904268754736	0.182591540425864	0.182591540425864	false	false	false	true
f8c2834a-6922-40be-b458-e14314fdefed	2026-09-04 10:49	2026-09-04 10:49	2026-09-04 10:49	XLI	XLI261002C00174000	call	174.0000	2026-10-02	3.9000	3.9000	4.3000	174.9900	22230.00	0.00	22230.00	57	14	58	1	58	0.160615631635851	0.160615631635851	false	false	false	true
8c6729fd-4aff-4d5a-bab7-1e8ecd4669f5	2026-09-04 10:49	2026-09-04 10:49	2026-09-04 10:49	XLI	XLI261002C00175000	call	175.0000	2026-10-02	3.3500	3.3500	3.4000	174.9900	13065.00	0.00	13065.00	39	14	39	1	39	0.160144858190071	0.160144858190071	true	false	false	true
c74913d9-3fd2-4437-a1ce-a2c1f2def4ae	2026-09-04 10:47	2026-09-04 10:47	2026-09-04 10:47	XLI	XLI261016P00175000	put	175.0000	2026-10-16	4.0500	3.9000	4.1000	175.1400	13770.00	9720.00	4050.00	34	5	43	80	0.5375	0.190299222082514	0.190299222082514	false	false	false	true
90e5b2cd-0572-4afd-b151-baf724b802be	2026-09-04 10:41	2026-09-04 10:41	2026-09-04 10:41	XLI	XLI261218C00200000	call	200.0000	2026-12-18	0.8200	0.7500	0.8400	175.3200	37228.00	37228.00	0.00	454	19	454	587	0.773424190800681	0.17455065592527	0.17455065592527	false	false	false	true
f8a69a8a-05c8-4048-9775-a1efd45e4cae	2026-09-04 09:39	2026-09-04 09:39	2026-09-04 09:39	XLI	XLI261120P00195000	put	195.0000	2026-11-20	21.0000	20.6000	21.0000	174.5503	205800.00	205800.00	0.00	98	5	101	69	1.46376811594203	0.250060199667839	0.250060199667839	false	false	false	true
be71cd71-2d80-49f8-8b8c-203e49d5cc75	2026-09-03 15:10	2026-09-03 15:10	2026-09-03 15:10	XLI	XLI260918P00170000	put	170.0000	2026-09-18	0.8800	0.8700	1.0000	174.2650	12760.00	0.00	12760.00	145	29	208	3795	0.0548089591567852	0.181549410752825	0.18061898805369	true	false	false	true
6bd69113-957d-4946-929e-3ebd16deb0d3	2026-09-03 14:25	2026-09-03 14:25	2026-09-03 14:25	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.4200	0.4200	0.4400	174.2300	10416.00	0.00	10416.00	248	21	505	4090	0.123471882640587	0.20173426102955	0.20173426102955	false	false	false	true
e1f32568-b9c1-4599-a209-d8025625d8dc	2026-09-03 14:09	2026-09-03 14:09	2026-09-03 14:09	XLI	XLI261120P00168000	put	168.0000	2026-11-20	3.1000	3.1000	3.2000	174.1900	19221.00	0.00	19221.00	62	28	62	27570	0.00224882118244469	0.19633740048902	0.19633740048902	true	false	false	true
10ee9baa-f412-4201-885c-798121902fa8	2026-09-03 14:09	2026-09-03 14:09	2026-09-03 14:09	XLI	XLI261120P00168000	put	168.0000	2026-11-20	3.1000	3.0500	3.2000	174.1900	54250.00	310.00	53940.00	175	5	237	27570	0.00859630032644178	0.19633740048902	0.19633740048902	true	false	false	true
cfda6baf-59ff-43ec-bebc-ec15ea9b8f79	2026-09-03 13:38	2026-09-03 13:38	2026-09-03 13:38	XLI	XLI260911P00172500	put	172.5000	2026-09-11	0.8600	0.8600	0.9300	174.3476	12987.00	87.00	12900.00	151	32	327	509	0.642436149312377	0.163083081951009	0.164265083154108	false	false	false	true
19256eaa-53a3-4aff-a4c7-34b2b5678ab9	2026-09-03 13:33	2026-09-03 13:33	2026-09-03 13:33	XLI	XLI261016P00160000	put	160.0000	2026-10-16	0.6100	0.6000	0.6500	174.3150	29646.00	183.00	29463.00	486	8	488	544	0.897058823529412	0.210555268260867	0.210555268260867	false	false	false	true
8583bc6a-303e-4e9c-8ae7-6708fce7c48d	2026-09-03 13:28	2026-09-03 13:28	2026-09-03 13:28	XLI	XLI260911P00172500	put	172.5000	2026-09-11	0.8800	0.8800	0.9600	174.2700	13200.00	0.00	13200.00	150	10	176	509	0.345776031434185	0.162680584364225	0.162680584364225	false	false	false	true
a7152292-5a79-4401-ae33-08ab8c355afe	2026-09-03 12:53	2026-09-03 12:53	2026-09-03 12:53	XLI	XLI261120P00162000	put	162.0000	2026-11-20	1.7700	1.7000	1.7900	174.1100	78588.00	9912.00	68676.00	444	12	444	217	2.04608294930876	0.20618261251268	0.20618261251268	false	false	false	true
6b48cf27-d20e-463b-a6ed-f3a45c6cc1c2	2026-09-03 12:04	2026-09-03 12:04	2026-09-03 12:04	XLI	XLI261120C00175000	call	175.0000	2026-11-20	5.7000	5.6500	5.9500	173.8600	28502.00	570.00	27932.00	50	13	95	267	0.355805243445693	0.172943903559109	0.172943903559109	false	false	false	true
544cf8a2-1638-4335-8ea4-d8ddbdf225d4	2026-09-03 11:44	2026-09-03 11:44	2026-09-03 11:44	XLI	XLI261016P00170000	put	170.0000	2026-10-16	2.4800	2.4300	2.5000	174.0350	24552.00	11656.00	12896.00	99	9	1001	457	2.19037199124726	0.190721173096223	0.190721173096223	true	false	false	true
e7338328-9d4a-4dc3-9f91-211025169235	2026-09-03 11:33	2026-09-03 11:33	2026-09-03 11:33	XLI	XLI260925P00177500	put	177.5000	2026-09-25	5.0500	4.6500	5.3500	174.0750	10100.00	9090.00	1010.00	20	8	22	0	0	0.193678251850203	0.196583714413358	true	false	false	true
50c193de-a046-4d28-ae50-71853a438892	2026-09-03 11:29	2026-09-03 11:29	2026-09-03 11:29	XLI	XLI261120C00200000	call	200.0000	2026-11-20	0.4000	0.3100	0.4000	174.0700	18399.00	18360.00	0.00	460	46	714	1058	0.674858223062382	0.181288404847412	0.181288404847412	false	false	false	true
c3fc88f5-9e7f-4687-9276-d248fc68a3b0	2026-09-03 10:39	2026-09-03 10:39	2026-09-03 10:39	XLI	XLI261218C00180000	call	180.0000	2026-12-18	4.2000	4.0000	4.2000	172.7100	219240.00	219240.00	0.00	522	47	526	3364	0.156361474435196	0.171753400147031	0.171753400147031	false	false	false	true
66dafc68-d986-42f6-9e82-0e0df71cc6b7	2026-09-03 10:20	2026-09-03 10:20	2026-09-03 10:20	XLI	XLI261120C00175000	call	175.0000	2026-11-20	5.0000	4.7000	5.0000	172.6200	20000.00	20000.00	0.00	40	14	41	267	0.153558052434457	0.170714278089072	0.170714278089072	true	false	false	true
077671ed-e68c-4232-b440-7b7b351acf0b	2026-09-03 10:14	2026-09-03 10:14	2026-09-03 10:14	XLI	XLI270319C00176000	call	176.0000	2027-03-19	9.2000	8.9500	9.2000	172.1900	16560.00	16560.00	0.00	18	10	45	4	11.25	0.181515480566637	0.181515480566637	false	false	false	true
48f4dbfa-cc2c-4ee0-a468-f840ce1a2956	2026-09-03 09:54	2026-09-03 09:54	2026-09-03 09:54	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.4200	2.3700	2.4200	173.6577	107690.00	107690.00	0.00	445	11	507	635	0.798425196850394	0.198999229227511	0.198999229227511	false	false	false	true
88fc708e-5d8b-4e55-82c9-a1360f62f812	2026-09-02 15:15	2026-09-02 15:15	2026-09-02 15:15	XLI	XLI261218P00164000	put	164.0000	2026-12-18	2.9500	2.9500	3.1000	172.8200	39235.00	0.00	39235.00	133	33	133	49	2.71428571428571	0.195078927073002	0.195078927073002	false	false	false	true
58c1bb0f-e4f4-402c-8fb1-b23092b4c5c5	2026-09-02 14:24	2026-09-02 14:24	2026-09-02 14:24	XLI	XLI270319P00172000	put	172.0000	2027-03-19	8.1000	7.9000	8.1000	172.6850	44550.00	44550.00	0.00	55	16	96	8	12	0.198536084139193	0.198536084139193	true	false	false	true
fbed7feb-7c5f-4788-8a0c-ff2a530d89f9	2026-09-02 13:54	2026-09-02 13:53	2026-09-02 13:53	XLI	XLI260918P00168000	put	168.0000	2026-09-18	0.8300	0.8300	0.9000	172.7800	25647.00	0.00	25647.00	309	23	457	766	0.596605744125326	0.18420968818358	0.18420968818358	false	false	false	true
14d22ce4-f5a1-435f-8a2d-a4858cdd8c72	2026-09-02 13:35	2026-09-02 13:35	2026-09-02 13:35	XLI	XLI261016C00175000	call	175.0000	2026-10-16	3.2500	3.2500	3.3500	172.6600	37050.00	0.00	37050.00	114	33	139	12	11.5833333333333	0.165057651489048	0.165057651489048	false	false	false	true
5fb189fe-78fd-42d6-b662-dff6add2ac48	2026-09-02 13:04	2026-09-02 13:04	2026-09-02 13:04	XLI	XLI261016P00164000	put	164.0000	2026-10-16	1.2800	1.2700	1.3700	172.8500	11648.00	0.00	11648.00	91	28	141	767	0.183833116036506	0.196211770205335	0.196211770205335	false	false	false	true
6cd60b99-c241-491e-b19e-057ea900bc7a	2026-09-02 13:01	2026-09-02 13:01	2026-09-02 13:01	XLI	XLI261016P00167000	put	167.0000	2026-10-16	1.9400	1.9400	2.0500	172.7550	19594.00	0.00	19594.00	101	27	109	52	2.09615384615385	0.190384801352934	0.190384801352934	false	false	false	true