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

0001a9af-183e-4a86-9f23-c677a544676c	2026-09-18 11:03	2026-09-18 11:03	2026-09-18 11:03	XLI	XLI261016C00166000	call	166.0000	2026-10-16	5.0000	4.9500	5.4500	168.6550	19500.00	0.00	18000.00	39	16	39	24	1.625	0.17189472019836	0.17189472019836	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30543164756.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
4d5be73c-5e82-4a28-a29d-a6fbb6e07d37	2026-09-18 10:04	2026-09-18 10:04	2026-09-18 10:04	XLI	XLI270115C00195000	call	195.0000	2027-01-15	0.8500	0.7200	0.8500	168.6500	22355.00	22355.00	0.00	263	36	515	545	0.944954128440367	0.178243398471036	0.178243398471036	false	false	false	true	false
cf556166-c4fe-4e7d-b666-7a37106ffd84	2026-09-18 09:52	2026-09-18 09:52	2026-09-18 09:52	XLI	XLI261016C00176000	call	176.0000	2026-10-16	0.9300	0.9300	0.9700	168.9500	12276.00	0.00	12276.00	132	14	453	166	2.7289156626506	0.16720785858936	0.16720785858936	true	false	false	true	false
887b1546-81d5-42ad-aae1-dc101305a269	2026-09-18 09:45	2026-09-18 09:45	2026-09-18 09:45	XLI	XLI261016P00172000	put	172.0000	2026-10-16	4.8500	4.8000	4.8500	169.2300	25705.00	25705.00	0.00	53	6	97	108	0.898148148148148	0.192126914992861	0.192126914992861	false	false	false	true	false
5a64172f-2928-47d3-868e-ad322b418ee7	2026-09-18 09:44	2026-09-18 09:44	2026-09-18 09:44	XLI	XLI261016C00176000	call	176.0000	2026-10-16	0.9600	0.9600	1.0600	169.2399	21888.00	0.00	21888.00	228	38	303	166	1.82530120481928	0.164810805974472	0.164810805974472	true	false	false	true	false
10a0d917-a1a5-42bb-9a4f-d17569d915ae	2026-09-17 14:52	2026-09-17 14:52	2026-09-17 14:52	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.5500	3.4500	3.5500	169.0850	14910.00	14910.00	0.00	42	6	386	9187	0.0420158920213345	0.20910403842003	0.20910403842003	false	false	false	true	false
e5548e91-5f01-4f4d-96fd-487cc740c01f	2026-09-17 14:52	2026-09-17 14:51	2026-09-17 14:51	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.5500	3.5000	3.5500	169.0900	30175.00	30175.00	0.00	85	30	344	9187	0.0374442146511375	0.209169844192427	0.209169844192427	false	false	false	true	false
77230d8e-7144-46af-94a2-07da958cde85	2026-09-17 14:50	2026-09-17 14:50	2026-09-17 14:50	XLI	XLI260918P00177000	put	177.0000	2026-09-18	7.9500	7.5500	7.9500	169.1500	1710045.00	1710045.00	0.00	2151	2	2153	1434	1.50139470013947	0.545752207454251	0.545752207454251	false	true	true	false	true
7eaa3ca4-f4c3-45e0-93bd-51b79ce80596	2026-09-17 14:49	2026-09-17 14:49	2026-09-17 14:49	XLI	XLI261120P00165000	put	165.0000	2026-11-20	3.5000	3.5000	3.7000	169.1800	24500.00	0.00	24500.00	70	5	232	9187	0.0252530749972788	0.208426399606442	0.208426399606442	false	false	false	true	false
d89cc3d7-693d-420f-ad4e-851b57bb294a	2026-09-17 12:20	2026-09-17 12:20	2026-09-17 12:20	XLI	XLI261218P00182000	put	182.0000	2026-12-18	14.1000	14.1000	14.7000	169.3000	16920.00	0.00	16920.00	12	8	12	230	0.0521739130434783	0.215218699869649	0.215218699869649	true	false	false	true	false
e4dd72a3-843f-45e4-a333-a66e954280ab	2026-09-17 11:42	2026-09-17 11:42	2026-09-17 11:42	XLI	XLI261016P00172000	put	172.0000	2026-10-16	5.0600	5.0500	5.3000	169.1800	10125.00	0.00	10125.00	20	5	20	58	0.344827586206897	0.198534207259575	0.2012206703028	false	false	false	true	false
6f3152e0-62ff-4d03-95c5-d9c25901faf7	2026-09-17 11:40	2026-09-17 11:39	2026-09-17 11:39	XLI	XLI260925C00174000	call	174.0000	2026-09-25	0.3600	0.3600	0.4300	169.0000	18468.00	0.00	18468.00	513	30	519	16	32.4375	0.183775918895005	0.183775918895005	false	false	false	true	false
a5c036b5-0270-47ee-b3c8-b00c1128d804	2026-09-17 11:33	2026-09-17 11:33	2026-09-17 11:33	XLI	XLI260918C00169000	call	169.0000	2026-09-18	0.9300	0.9300	1.0500	168.9700	10044.00	0.00	10044.00	108	26	135	73	1.84931506849315	0.265221155454407	0.265221155454407	false	false	false	true	false
a2f2ad4d-0b64-4403-a275-301b29f34824	2026-09-17 11:18	2026-09-17 11:17	2026-09-17 11:17	XLI	XLI270917P00145000	put	145.0000	2027-09-17	4.5400	3.9500	5.4000	169.0200	58160.00	6675.00	9495.00	128	59	157	0	0	0.248824533116495	0.244272747023521	true	false	false	true	false
2d5bedba-bc5a-4517-a0d8-f4fb17d32321	2026-09-17 11:18	2026-09-17 11:17	2026-09-17 11:17	XLI	XLI270917P00145000	put	145.0000	2027-09-17	4.3800	3.9500	4.4000	169.0200	55156.00	55156.00	0.00	126	47	283	0	0	0.244272747023521	0.243126380136538	true	false	false	true	false
d19b058f-9061-4094-bf68-99f81adf1009	2026-09-17 11:17	2026-09-17 11:17	2026-09-17 11:17	XLI	XLI270917P00130000	put	130.0000	2027-09-17	2.2900	1.5600	3.7000	169.0200	39006.00	35076.00	1334.00	170	108	170	0	0	0.265954464552855	0.259394210652841	true	false	false	true	false
eac9bb5d-83e2-488f-8051-615deced58de	2026-09-17 10:34	2026-09-17 10:34	2026-09-17 10:34	XLI	XLI260918P00169000	put	169.0000	2026-09-18	0.7300	0.7300	0.8400	169.3900	10147.00	0.00	10147.00	139	29	145	1321	0.109765329295988	0.260351113699539	0.260351113699539	false	false	false	true	false
790a4aac-b5cb-418c-b523-8fff9f958d80	2026-09-17 10:28	2026-09-17 10:28	2026-09-17 10:28	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.4000	5.2500	5.4000	169.5399	141480.00	141480.00	0.00	262	46	273	55368	0.00493064586042479	0.204487219783487	0.204487219783487	false	false	false	true	false
f85e6c96-0c81-4e64-a870-92668efce997	2026-09-17 10:21	2026-09-17 10:21	2026-09-17 10:21	XLI	XLI260925C00170000	call	170.0000	2026-09-25	1.6900	1.5900	1.7800	169.7900	12675.00	12675.00	0.00	75	5	160	209	0.76555023923445	0.171597536548661	0.171597536548661	false	false	false	true	false
86baeb40-4fa6-4d36-b6af-d9a3a7e5ee49	2026-09-17 10:18	2026-09-17 10:18	2026-09-17 10:18	XLI	XLI261120C00168000	call	168.0000	2026-11-20	6.9500	6.5000	6.9500	169.6950	12509.00	12509.00	0.00	18	13	18	18	1	0.191122602186563	0.191122602186563	false	false	false	true	false
82875680-a0c9-4c98-9f5a-8cd1fa99bee5	2026-09-17 09:51	2026-09-17 09:51	2026-09-17 09:51	XLI	XLI261218P00157000	put	157.0000	2026-12-18	1.9400	1.9400	2.2100	170.8700	99730.00	2730.00	97000.00	514	57	514	68	7.55882352941176	0.220424597724844	0.220869135630682	false	false	false	true	false
7e361a3e-40ac-4337-92aa-20913ff5bfbb	2026-09-16 15:50	2026-09-16 15:50	2026-09-16 15:50	XLI	XLI261016P00182000	put	182.0000	2026-10-16	13.9500	13.9500	14.7000	168.0000	23715.00	0.00	23715.00	17	5	17	16	1.0625	0.255779300730781	0.255779300730781	true	false	false	true	false
8af48f11-9f66-4ab7-a82c-2e3d4bcccd99	2026-09-16 15:33	2026-09-16 15:33	2026-09-16 15:33	XLI	XLI260925C00172000	call	172.0000	2026-09-25	0.6500	0.6500	0.7500	168.1000	29835.00	0.00	29835.00	459	35	610	232	2.62931034482759	0.186160396515674	0.186160396515674	false	false	false	true	false
80ecb744-e6f7-4a4a-98a1-cb48d9af301e	2026-09-16 15:33	2026-09-16 15:33	2026-09-16 15:33	XLI	XLI261120C00168000	call	168.0000	2026-11-20	6.2500	5.7500	6.3000	168.2400	12495.00	11875.00	620.00	20	12	20	0	0	0.194604143436627	0.194604143436627	false	false	false	true	false
38ccf1ee-eec5-4343-9634-9d88884ce353	2026-09-16 15:24	2026-09-16 15:24	2026-09-16 15:24	XLI	XLI261016P00160000	put	160.0000	2026-10-16	1.3700	1.1000	1.3800	167.6600	16968.00	16968.00	0.00	124	25	142	1422	0.09985935302391	0.229004421891174	0.22685379604193	true	false	false	true	false
51d5d2fc-351e-4d14-a916-9515beaaf925	2026-09-16 14:20	2026-09-16 14:20	2026-09-16 14:20	XLI	XLI270115C00185000	call	185.0000	2027-01-15	2.4500	2.3900	2.4500	169.7500	20090.00	20090.00	0.00	82	5	153	8609	0.0177720989661982	0.174636968216733	0.174636968216733	false	false	false	true	false
509a379e-447a-406e-b9b6-e91c86a309bc	2026-09-16 14:14	2026-09-16 14:14	2026-09-16 14:14	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.3500	1.2800	1.4000	170.0600	34425.00	34425.00	0.00	255	9	1258	1255	1.00239043824701	0.170993971271564	0.170993971271564	false	false	false	true	false
157002fa-9af5-483d-8b11-f9c919217a1b	2026-09-16 14:14	2026-09-16 14:14	2026-09-16 14:14	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.3500	1.2400	1.4000	170.0600	57645.00	57645.00	0.00	427	23	903	1255	0.719521912350598	0.170993971271564	0.170993971271564	true	false	false	true	false
6fd96af4-3487-40e5-ae6a-76e63ba2148b	2026-09-16 14:07	2026-09-16 14:07	2026-09-16 14:07	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.4000	1.2400	1.5200	170.0900	15540.00	15540.00	0.00	111	19	389	1255	0.30996015936255	0.174031693362987	0.174031693362987	false	false	false	true	false
a3ef1a31-7b68-4d0c-91b0-a3c94055b839	2026-09-16 14:07	2026-09-16 14:07	2026-09-16 14:07	XLI	XLI261002C00173000	call	173.0000	2026-10-02	1.4000	1.1200	1.4100	170.0600	32473.00	32473.00	0.00	232	24	232	1255	0.184860557768924	0.174819199151633	0.174819199151633	false	false	false	true	false
6e2e98ff-8399-413b-976b-f83e8c62e96f	2026-09-16 13:39	2026-09-16 13:39	2026-09-16 13:39	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.6400	1.5200	1.6400	170.2150	18860.00	18860.00	0.00	115	36	384	436	0.880733944954128	0.244137681925356	0.244137681925356	false	false	false	true	false
6c7cf8d6-6544-472b-91df-48e8341dece6	2026-09-16 13:22	2026-09-16 13:22	2026-09-16 13:22	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1800	1.0800	1.2200	170.0700	20532.00	20532.00	0.00	174	36	1468	4817	0.304753996263234	0.245497370404006	0.245497370404006	false	false	false	true	false
deebdb2c-6c24-4e34-b161-9200b5b877ec	2026-09-16 13:11	2026-09-16 13:11	2026-09-16 13:11	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1200	1.0200	1.1200	170.1100	10640.00	10640.00	0.00	95	17	1179	4817	0.244758148225036	0.237362586699559	0.237362586699559	false	false	false	true	false
4d87f652-d035-46bc-be91-38333bb370c5	2026-09-16 13:11	2026-09-16 13:11	2026-09-16 13:11	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.7100	1.5600	1.7100	170.1100	10089.00	10089.00	0.00	59	15	218	436	0.5	0.245603721267682	0.245603721267682	false	false	false	true	false
161ed94a-a986-49d8-b01a-5e158faa1b9e	2026-09-16 13:11	2026-09-16 13:11	2026-09-16 13:11	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1200	1.0200	1.1200	170.1100	11088.00	11088.00	0.00	99	19	1286	4817	0.266971143865476	0.237362586699559	0.237362586699559	false	false	false	true	false
a601ac2a-231d-4c77-8426-70824f4d6cbe	2026-09-16 12:58	2026-09-16 12:58	2026-09-16 12:58	XLI	XLI261016P00170000	put	170.0000	2026-10-16	3.5000	3.4000	3.5000	170.2500	28700.00	28700.00	0.00	82	25	190	1869	0.101658640984484	0.200068989813787	0.200068989813787	false	false	false	true	false
70cc63bb-5d48-42e0-8745-bafae50430b4	2026-09-16 12:58	2026-09-16 12:58	2026-09-16 12:58	XLI	XLI261016P00169000	put	169.0000	2026-10-16	3.1000	3.0000	3.1000	170.2500	35030.00	35030.00	0.00	113	26	239	376	0.63563829787234	0.203056323903053	0.203056323903053	false	false	false	true	false
f1dfd433-ae73-4cc8-99b5-6a5ab93a579b	2026-09-16 12:06	2026-09-16 12:06	2026-09-16 12:06	XLI	XLI260925P00169000	put	169.0000	2026-09-25	1.7000	1.6600	1.7700	170.2900	258740.00	258400.00	340.00	1522	25	2289	177	12.9322033898305	0.221794303461701	0.221794303461701	false	false	false	true	false
803701f9-3739-4826-bd60-6142c2cd6245	2026-09-16 11:55	2026-09-16 11:54	2026-09-16 11:54	XLI	XLI260925P00169000	put	169.0000	2026-09-25	1.6700	1.5500	1.6700	170.3473	127588.00	127588.00	0.00	764	23	766	177	4.32768361581921	0.221073177837231	0.221073177837231	false	false	false	true	false
a5d97744-5a1d-43c4-88bb-ac6b33420ee7	2026-09-16 11:54	2026-09-16 11:54	2026-09-16 11:54	XLI	XLI261016P00170000	put	170.0000	2026-10-16	3.4500	3.2000	3.5000	170.4000	10350.00	10350.00	0.00	30	6	86	1869	0.0460139111824505	0.200996698439735	0.200996698439735	true	false	false	true	false
f537c03c-abc4-4557-a43d-482f060f9ae9	2026-09-16 11:51	2026-09-16 11:51	2026-09-16 11:51	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.4800	1.2800	1.4800	170.5000	23384.00	23384.00	0.00	158	20	159	436	0.364678899082569	0.244873957600107	0.244873957600107	false	false	false	true	false
b3765bb6-4341-42fa-8cb5-930dd7a0dcd6	2026-09-16 11:50	2026-09-16 11:50	2026-09-16 11:50	XLI	XLI270319P00163000	put	163.0000	2027-03-19	5.4500	5.1000	5.4500	170.5450	41965.00	41965.00	0.00	77	20	77	246	0.313008130081301	0.215200113177791	0.215200113177791	false	false	false	true	false
d8880186-2082-4550-bf36-cb8d5416d88e	2026-09-16 11:44	2026-09-16 11:44	2026-09-16 11:44	XLI	XLI260925P00163000	put	163.0000	2026-09-25	0.4000	0.3600	0.4600	170.3000	40520.00	40240.00	280.00	1013	13	1013	197	5.14213197969543	0.24748394635559	0.24748394635559	false	false	false	true	false
804ef78f-6840-4095-8aa3-fb5c4f83b14d	2026-09-16 11:26	2026-09-16 11:26	2026-09-16 11:26	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.1100	1.0300	1.1100	170.2900	24753.00	24753.00	0.00	223	44	1049	4817	0.217770396512352	0.252113993569704	0.252113993569704	false	false	false	true	false
db3117e5-ca47-486f-aa1f-50bc41d213a1	2026-09-16 11:25	2026-09-16 11:25	2026-09-16 11:25	XLI	XLI261009P00164000	put	164.0000	2026-10-09	1.2100	1.2100	1.4300	170.2350	18200.00	0.00	18200.00	150	16	152	93	1.63440860215054	0.215991185230828	0.215206859000893	true	false	false	true	false
83ef983a-2cd9-45ea-9aa8-205d41d543d0	2026-09-16 10:38	2026-09-16 10:38	2026-09-16 10:38	XLI	XLI260918P00169000	put	169.0000	2026-09-18	1.0600	0.9700	1.0600	169.4600	10706.00	10706.00	0.00	101	31	461	1057	0.436140018921476	0.258771433293129	0.258771433293129	false	false	false	true	false
8f763f91-f7e3-4355-959b-3e204b4b3148	2026-09-16 10:02	2026-09-16 10:01	2026-09-16 10:01	XLI	XLI260918C00171000	call	171.0000	2026-09-18	0.6600	0.6000	0.6600	169.3700	23562.00	23562.00	0.00	357	10	501	235	2.13191489361702	0.259652619734153	0.259652619734153	false	false	false	true	false
b096f9b6-4354-4781-860c-3a8832cf892c	2026-09-16 09:59	2026-09-16 09:59	2026-09-16 09:59	XLI	XLI260918P00169000	put	169.0000	2026-09-18	1.1000	0.9600	1.1000	169.4200	25850.00	25850.00	0.00	235	31	360	1057	0.340586565752129	0.263316591574376	0.263316591574376	false	false	false	true	false
87e5efc0-c6b7-46d9-ba4d-2f107ec903f5	2026-09-16 09:59	2026-09-16 09:59	2026-09-16 09:59	XLI	XLI260918P00170000	put	170.0000	2026-09-18	1.5800	1.4100	1.5800	169.4200	11850.00	11850.00	0.00	75	15	325	4817	0.0674693792817106	0.257455231682971	0.257455231682971	false	false	false	true	false
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