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

6d99e2f4-455f-41b6-a457-7a91197cb9b6	2026-09-10 09:54	2026-09-10 09:54	2026-09-10 09:54	XLI	XLI261218P00162000	put	162.0000	2026-12-18	3.3200	3.3000	3.3500	170.2100	102535.00	37855.00	64680.00	309	15	309	88	3.51136363636364	0.212209796700862	0.212209796700862	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	31280067977.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-10T14:06:33.692120Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d78924a6-7653-4617-a1bd-90a90004f58a	2026-09-09 15:43	2026-09-09 15:43	2026-09-09 15:43	XLI	XLI261120C00175000	call	175.0000	2026-11-20	4.9500	4.9000	5.1000	172.0300	37125.00	0.00	37125.00	75	21	127	277	0.458483754512635	0.186877531603348	0.186877531603348	false	false	false	true	false
0dacd640-6868-48f9-94e4-d8b5488d9fc9	2026-09-09 15:34	2026-09-09 15:34	2026-09-09 15:34	XLI	XLI270319C00176000	call	176.0000	2027-03-19	9.2500	9.0500	9.2500	172.1000	16650.00	16650.00	0.00	18	7	44	61	0.721311475409836	0.192775967492711	0.192775967492711	false	false	false	true	false
5d82e7d0-97fe-4676-b199-d2bf4882ab06	2026-09-09 14:20	2026-09-09 14:20	2026-09-09 14:20	XLI	XLI261120P00165000	put	165.0000	2026-11-20	2.9300	2.9200	2.9800	172.0950	58600.00	0.00	58307.00	200	10	987	10554	0.0935190449118817	0.209976670051296	0.209976670051296	false	false	false	true	false
9b38a09c-8748-4de6-a94f-108d3c535f98	2026-09-09 13:19	2026-09-09 13:19	2026-09-09 13:19	XLI	XLI261120P00175000	put	175.0000	2026-11-20	6.8500	6.6500	6.9000	172.4650	13695.00	12330.00	1365.00	20	9	104	12891	0.00806764409277791	0.203643786287411	0.203643786287411	true	false	false	true	false
b526ae96-f7f9-42a9-bf37-353781631b1d	2026-09-09 12:25	2026-09-09 12:25	2026-09-09 12:25	XLI	XLI261120P00171000	put	171.0000	2026-11-20	5.0000	4.9500	5.1500	172.1600	11500.00	1000.00	8000.00	23	12	25	1089	0.0229568411386593	0.203558909550011	0.203558909550011	false	false	false	true	false
5d05580f-20fc-4a99-8e2d-0efdee5b458d	2026-09-09 12:25	2026-09-09 12:25	2026-09-09 12:25	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.6000	4.5500	4.7500	172.1600	29440.00	1380.00	28060.00	64	8	155	55377	0.00279899597305741	0.204843728206309	0.204843728206309	false	false	false	true	false
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
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	false
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	false
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	false
cf3743d7-bd85-48a8-b707-e2392d04f029	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	109667.00	109667.00	0.00	962	14	1344	4659	0.28847392144237	0.207720881838775	0.208769388598449	true	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
3fad432f-89fd-4ccf-941c-d9b4a1f4b381	2026-09-08 09:46	2026-09-08 09:46	2026-09-08 09:46	XLI	XLI261016C00166000	call	166.0000	2026-10-16	10.8100	10.1500	10.8500	175.2800	22710.00	22710.00	0.00	21	5	21	0	0	0.186258409504183	0.182559490323791	false	false	false	true	false
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	false
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	false
e39ddb31-e847-460b-b6f5-38556f32eac6	2026-09-08 09:37	2026-09-08 09:37	2026-09-08 09:37	XLI	XLI261016C00185000	call	185.0000	2026-10-16	1.2700	0.8100	1.2700	175.2800	177800.00	177800.00	0.00	1400	2	1400	277	5.05415162454874	0.188713389323388	0.188713389323388	false	true	true	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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
c85bd094-ada1-4fa1-9e56-32ca1e5d2fd8	2026-09-03 15:55	2026-09-03 15:55	2026-09-03 15:55	XLI	XLI261016C00169000	call	169.0000	2026-10-16	7.8100	7.5500	8.1500	174.3900	13280.00	12495.00	785.00	17	14	19	1	19	0.172416415503052	0.169843497779337	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
e774829a-d03f-4d89-afdd-32c2e3c7c63f	2026-09-03 11:33	2026-09-03 11:33	2026-09-03 11:33	XLI	XLI260925P00179000	put	179.0000	2026-09-25	6.1900	5.7500	6.2000	174.0800	17340.00	16730.00	610.00	28	12	28	15	1.86666666666667	0.203674716975083	0.202315084214175	true	false	false	true	false