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×sorted by created_at ↑×

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

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	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	30796170295.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T13:30:32.030452Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
fa984539-0a8a-4b01-8b9a-58e776e1a6f3	2026-09-10 09:54	2026-09-10 09:54	2026-09-10 09:54	XLI	XLI261218P00167000	put	167.0000	2026-12-18	4.9500	4.9000	5.0500	170.2100	75735.00	74745.00	990.00	153	27	153	102	1.5	0.206489166469547	0.206489166469547	false	false	false	true	false
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
e357fcad-5440-4f51-abdc-8e59c176e84e	2026-09-10 10:08	2026-09-10 10:08	2026-09-10 10:08	XLI	XLI261120P00150000	put	150.0000	2026-11-20	0.8700	0.6400	0.8700	170.4000	65250.00	65250.00	0.00	750	37	752	254	2.96062992125984	0.245190503991472	0.245190503991472	false	false	false	true	false
416d4d2e-4f26-446d-9408-064520cbe848	2026-09-10 10:08	2026-09-10 10:08	2026-09-10 10:08	XLI	XLI261120P00150000	put	150.0000	2026-11-20	0.8700	0.6400	0.8700	170.4000	61770.00	61770.00	0.00	710	23	1462	254	5.75590551181102	0.245190503991472	0.245190503991472	false	false	false	true	false
5c3c20b8-092f-4b89-ab8b-cf99e2a6b1b6	2026-09-10 10:09	2026-09-10 10:09	2026-09-10 10:09	XLI	XLI261120C00171000	call	171.0000	2026-11-20	6.1500	6.0000	6.1500	170.3200	44280.00	44280.00	0.00	72	15	96	57	1.68421052631579	0.19496649257848	0.19496649257848	true	false	false	true	false
3bb23a4f-5551-4a6f-8828-b9ca79701f2b	2026-09-10 10:17	2026-09-10 10:17	2026-09-10 10:17	XLI	XLI261023C00170000	call	170.0000	2026-10-23	5.1500	4.6500	5.1500	170.7500	13390.00	13390.00	0.00	26	7	26	0	0	0.186460444695591	0.186460444695591	false	false	false	true	false
77001dc0-429c-48f1-8a60-e7a899adcf80	2026-09-10 10:23	2026-09-10 10:23	2026-09-10 10:23	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5600	1.4900	1.5600	170.8700	15600.00	10452.00	0.00	100	6	113	5418	0.0208564045773348	0.201344933328471	0.201344933328471	false	false	false	true	false
af9af478-6d0c-4e58-ba32-862450b25f24	2026-09-10 10:23	2026-09-10 10:23	2026-09-10 10:23	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5600	1.5400	1.7000	170.8700	22688.00	3140.00	19548.00	145	26	258	5418	0.0476190476190476	0.201344933328471	0.202358710376772	true	false	false	true	false
2d847728-673c-4ea7-894e-a1db69091a6a	2026-09-10 10:23	2026-09-10 10:23	2026-09-10 10:23	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5600	1.5400	1.5600	170.9000	11544.00	8424.00	0.00	74	5	398	5418	0.0734588409007014	0.202605581393321	0.202605581393321	false	false	false	true	false
48a7a560-22ba-426b-8345-aa19ab1733c1	2026-09-10 10:25	2026-09-10 10:25	2026-09-10 10:25	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.3800	1.2500	1.3800	171.3300	10074.00	10074.00	0.00	73	6	471	5418	0.0869324473975637	0.201651473855499	0.201651473855499	false	false	false	true	false
0282e9a0-3dcc-4307-9278-1e5c91a31a1e	2026-09-10 10:26	2026-09-10 10:25	2026-09-10 10:25	XLI	XLI261120P00163000	put	163.0000	2026-11-20	2.6900	2.5500	2.6900	171.5300	23134.00	23134.00	0.00	86	22	87	173	0.502890173410405	0.219473309872681	0.219473309872681	false	false	false	true	false
76c68a70-6980-48e5-a9f7-fc8c6f442fc1	2026-09-10 10:29	2026-09-10 10:29	2026-09-10 10:29	XLI	XLI261120P00161000	put	161.0000	2026-11-20	2.2800	2.1200	2.2800	171.3600	23028.00	23028.00	0.00	101	27	101	8	12.625	0.223177250520999	0.223177250520999	false	false	false	true	false