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

fb529655-6a91-4618-8c16-3c442951b139	2026-09-01 12:59	2026-09-01 12:59	2026-09-01 12:59	XLI	XLI261120P00175000	put	175.0000	2026-11-20	6.4500	6.3000	6.6500	172.3500	12900000.00	0.00	12900000.00	20000	1	20008	55796	0.358592013764428	0.18128892228922	0.18128892228922	false	true	true	false	false	LowHistoricVolumeFloor	b356ec2b-92e1-458a-934a-7719f71c40bc	1	ETF	—	30796170295.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T17:20:15.685951Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bf9d542d-254c-4715-94ef-75fc9e7b2f07	2026-09-01 12:59	2026-09-01 12:59	2026-09-01 12:59	XLI	XLI261120P00168000	put	168.0000	2026-11-20	3.4400	3.1500	3.6500	172.3500	9460000.00	9460000.00	0.00	27500	1	27500	139	197.841726618705	0.18602423446567	0.18602423446567	false	true	true	false	true
5875dca0-8e2c-4974-8238-551db0e9b55d	2026-09-01 13:15	2026-09-01 13:15	2026-09-01 13:15	XLI	XLI260911C00178000	call	178.0000	2026-09-11	0.3100	0.3100	0.4300	172.3700	38626.00	0.00	38626.00	1246	21	1255	38	33.0263157894737	0.165981108309369	0.165981108309369	false	false	false	true	false
82b4cdeb-eb35-418f-ba01-d79d6b18c9f1	2026-09-01 14:06	2026-09-01 14:05	2026-09-01 14:05	XLI	XLI261016P00173000	put	173.0000	2026-10-16	4.1200	4.0000	4.3000	172.6750	20583.00	0.00	20583.00	50	5	255	4	63.75	0.179954668306804	0.179954668306804	false	false	false	true	false
4fc9a578-b1d0-46b6-984e-1cd9e578c472	2026-09-01 14:45	2026-09-01 14:45	2026-09-01 14:45	XLI	XLI260918P00171000	put	171.0000	2026-09-18	1.7600	1.5800	1.7600	172.4300	14784.00	14784.00	0.00	84	17	86	212	0.405660377358491	0.171569837323417	0.171569837323417	false	false	false	true	false
50dd1aed-7b65-4a26-84e3-190d4b97b295	2026-09-01 14:48	2026-09-01 14:48	2026-09-01 14:48	XLI	XLI260911P00168000	put	168.0000	2026-09-11	0.5200	0.3800	0.5200	172.3200	16692.00	16692.00	0.00	321	29	321	1	321	0.179932518488635	0.179932518488635	false	false	false	true	false
c50a183a-cc69-41e5-b8f2-115d03373b33	2026-09-02 09:34	2026-09-02 09:33	2026-09-02 09:33	XLI	XLI260918C00177500	call	177.5000	2026-09-18	0.7500	0.6700	0.7600	172.2800	34575.00	34500.00	75.00	461	36	631	36	17.5277777777778	0.169144173484228	0.169144173484228	false	false	false	true	false
98a72505-dc2d-4135-8c86-ec4bdc07b036	2026-09-02 09:34	2026-09-02 09:34	2026-09-02 09:34	XLI	XLI260918C00177500	call	177.5000	2026-09-18	0.8200	0.7300	0.8200	172.3964	13448.00	13448.00	0.00	164	40	1216	36	33.7777777777778	0.173212006202081	0.173212006202081	false	false	false	true	false
23f48a3f-fedf-4b2a-a58b-3b9ae6606a01	2026-09-02 09:35	2026-09-02 09:34	2026-09-02 09:34	XLI	XLI260918C00177500	call	177.5000	2026-09-18	0.8400	0.7300	0.8400	172.3500	18480.00	18480.00	0.00	220	46	1454	36	40.3888888888889	0.176009680043962	0.176009680043962	false	false	false	true	false
cf0976e1-d3e8-4a56-90e1-c942cda022c9	2026-09-02 09:35	2026-09-02 09:35	2026-09-02 09:35	XLI	XLI260904P00172000	put	172.0000	2026-09-04	1.0100	0.5800	1.0100	172.1300	13028.00	13028.00	0.00	129	38	131	54	2.42592592592593	0.214760099429173	0.214760099429173	true	false	false	true	false
9f68e233-f57a-4624-a3c8-870d3f21a914	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	XLI	XLI261016C00173000	call	173.0000	2026-10-16	3.9000	3.9000	4.2000	172.0500	36270.00	0.00	36270.00	93	5	93	5	18.6	0.166540916533808	0.166540916533808	true	false	false	true	false
27d04877-d517-4905-ba3a-d57b05ad1b08	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	XLI	XLI261016P00165000	put	165.0000	2026-10-16	1.6000	1.5100	1.6000	172.0200	125120.00	125120.00	0.00	782	24	786	157	5.00636942675159	0.191287734760524	0.191287734760524	false	false	false	true	false
cce82d88-97dd-47ef-82a2-5051f0f2aef4	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	XLI	XLI261016C00173000	call	173.0000	2026-10-16	3.9000	3.9000	3.9500	172.0000	352170.00	0.00	352170.00	903	6	1000	5	200	0.167600591455739	0.167600591455739	false	false	false	true	false
72aac84e-10f1-4217-b585-d56f2ba27b67	2026-09-02 09:45	2026-09-02 09:45	2026-09-02 09:45	XLI	XLI261120P00169000	put	169.0000	2026-11-20	4.0500	3.7000	4.0500	171.9300	12150.00	12150.00	0.00	30	8	30	48	0.625	0.189810920414103	0.189810920414103	true	false	false	true	false
459249fc-cffb-4759-a688-10084a70c6e4	2026-09-02 10:02	2026-09-02 10:02	2026-09-02 10:02	XLI	XLI260925C00179000	call	179.0000	2026-09-25	0.6700	0.6700	0.8000	171.9500	39396.00	0.00	39396.00	588	17	628	1	628	0.161324976040565	0.161324976040565	false	false	false	true	false
08b505b2-1a77-4d07-95f2-6fcc63bf7952	2026-09-02 10:05	2026-09-02 10:05	2026-09-02 10:05	XLI	XLI260925C00170000	call	170.0000	2026-09-25	4.3500	3.8000	4.3500	172.2000	15225.00	15225.00	0.00	35	15	35	0	0	0.167193450252643	0.167193450252643	true	false	false	true	false
cf740fc8-07e0-4044-8c06-d2a9ed1fdbe0	2026-09-02 10:18	2026-09-02 10:18	2026-09-02 10:18	XLI	XLI270319P00173000	put	173.0000	2027-03-19	8.5000	8.3500	8.5000	172.8550	14450.00	14450.00	0.00	17	7	28	8	3.5	0.1986733227478	0.1986733227478	false	false	false	true	false
5bcd866e-55c2-43ab-8f0b-eb9b00eede7d	2026-09-02 10:45	2026-09-02 10:45	2026-09-02 10:45	XLI	XLI260918C00177000	call	177.0000	2026-09-18	1.0600	1.0600	1.1900	173.1500	10706.00	0.00	10706.00	101	27	141	194	0.72680412371134	0.166654269754453	0.166654269754453	false	false	false	true	false
0f52606d-5541-4199-8d06-d1ceea02315d	2026-09-02 10:55	2026-09-02 10:55	2026-09-02 10:55	XLI	XLI260904C00171000	call	171.0000	2026-09-04	2.4100	2.4100	2.5400	172.9600	13496.00	0.00	13496.00	56	11	56	2	28	0.225653728639471	0.225653728639471	false	false	false	true	false
b0536770-68f8-4b9c-8aec-832ef828615a	2026-09-02 11:01	2026-09-02 11:01	2026-09-02 11:01	XLI	XLI260904C00172000	call	172.0000	2026-09-04	1.6700	1.6700	1.8000	172.9650	13694.00	0.00	13694.00	82	19	128	21	6.09523809523809	0.215483701831606	0.215483701831606	false	false	false	true	false
2f712b10-81cf-4515-9319-4bfabb79f1e9	2026-09-02 11:32	2026-09-02 11:32	2026-09-02 11:32	XLI	XLI260911P00170000	put	170.0000	2026-09-11	0.7000	0.7000	0.8400	173.0850	14910.00	0.00	14910.00	213	23	218	35	6.22857142857143	0.176589815868251	0.176589815868251	false	false	false	true	false
1a3bb92c-fb10-4401-992f-2833e9a893f2	2026-09-02 11:39	2026-09-02 11:39	2026-09-02 11:39	XLI	XLI270319P00172000	put	172.0000	2027-03-19	8.0000	7.8000	8.0000	173.1100	14400.00	14400.00	0.00	18	11	38	8	4.75	0.200000799193424	0.200000799193424	false	false	false	true	false
9d0cfe25-5cc1-46d0-a173-8beb83c93bd9	2026-09-02 12:11	2026-09-02 12:11	2026-09-02 12:11	XLI	XLI261016C00168000	call	168.0000	2026-10-16	7.5000	7.5000	7.6500	172.9600	43500.00	0.00	43500.00	58	18	58	0	0	0.16920403441709	0.16920403441709	false	false	false	true	false
04d6f601-0c25-4e86-9dd2-4c3512f28df3	2026-09-02 12:30	2026-09-02 12:30	2026-09-02 12:30	XLI	XLI261016C00177000	call	177.0000	2026-10-16	2.5200	2.5200	2.6000	172.7000	150444.00	0.00	150444.00	597	15	600	6	100	0.166394161387271	0.166394161387271	false	false	false	true	false
3a25c082-c64c-4cb0-a5e9-c323de84e722	2026-09-02 12:30	2026-09-02 12:30	2026-09-02 12:30	XLI	XLI270319C00173000	call	173.0000	2027-03-19	11.2000	10.8000	11.2500	172.7001	25760.00	24640.00	1120.00	23	12	33	3	11	0.191709994250068	0.191709994250068	true	false	false	true	false
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	false
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	false
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	false
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	false
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	false
4e6520ab-4649-4cc5-9a42-00c8a868f50c	2026-09-02 14:56	2026-09-02 14:56	2026-09-02 14:56	XLI	XLI261120C00156000	call	156.0000	2026-11-20	18.5000	17.9000	20.0500	172.6400	3700000.00	0.00	3700000.00	2000	2	3000	5	600	0.174767579912051	0.174767579912051	false	true	true	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	false
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	false
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	false
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	false
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	false
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	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
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	false
5eb712a3-ca4c-4a10-b659-2c72233b6d1a	2026-09-03 11:33	2026-09-03 11:33	2026-09-03 11:33	XLI	XLI260925P00180000	put	180.0000	2026-09-25	6.9000	6.4500	7.3000	174.0750	20005.00	9730.00	9590.00	29	6	29	62	0.467741935483871	0.204244171174356	0.196931408551572	true	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
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
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
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
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
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
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
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
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