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:source = uw_flow_alerts×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

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	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30796170295.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T15:43:05.796155Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
afd943aa-8695-492d-9c8e-69a0457c6fa8	2026-09-01 12:45	2026-09-01 12:44	2026-09-01 12:44	XLI	XLI261016P00173000	put	173.0000	2026-10-16	4.1500	4.1500	4.3500	172.4100	16603.00	0.00	16603.00	40	23	190	4	47.5	0.176820243967566	0.176820243967566	false	false	false	true
bc84b80f-da1b-48c0-ad23-5d4a762c7cc9	2026-09-01 12:44	2026-09-01 12:44	2026-09-01 12:44	XLI	XLI261218P00173000	put	173.0000	2026-12-18	6.0500	6.0500	6.4000	172.4100	24200.00	0.00	24200.00	40	5	100	52	1.92307692307692	0.180930480148608	0.180930480148608	false	false	false	true
749459c6-533d-488c-824a-bcd4f4badc5a	2026-09-01 12:25	2026-09-01 12:25	2026-09-01 12:25	XLI	XLI260918C00181000	call	181.0000	2026-09-18	0.3300	0.3300	0.4200	172.7600	10791.00	0.00	10791.00	327	32	1179	301	3.91694352159468	0.167457919259274	0.167457919259274	false	false	false	true
9985532b-a174-4612-b286-01f57281b72e	2026-09-01 11:58	2026-09-01 11:57	2026-09-01 11:57	XLI	XLI260918C00181000	call	181.0000	2026-09-18	0.3600	0.3600	0.4200	173.0750	28189.00	0.00	28152.00	783	58	852	301	2.83056478405316	0.166591729980743	0.166591729980743	true	false	false	true
c7fc9998-4a53-477a-8770-cb59a5cdce85	2026-09-01 10:03	2026-09-01 10:03	2026-09-01 10:03	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.8300	0.7900	0.8300	173.9200	12581.00	9711.00	1886.00	152	26	3367	44	76.5227272727273	0.202491315479288	0.200822199327036	false	false	false	true
aba422f4-bd2e-4285-9ff0-9f3cfc87b29e	2026-09-01 10:02	2026-09-01 10:02	2026-09-01 10:02	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.8500	0.8000	0.8500	174.0200	26265.00	26265.00	0.00	309	14	2654	44	60.3181818181818	0.199450381653173	0.199450381653173	false	false	false	true
01f8c97b-4e2f-4c60-ad0c-795a5efd1330	2026-09-01 09:58	2026-09-01 09:58	2026-09-01 09:58	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.8000	0.7500	0.8100	173.9064	22229.00	11022.00	8363.00	279	24	1715	44	38.9772727272727	0.198331460452917	0.196656192401807	false	false	false	true
9a12f9c5-b489-46e0-af75-1ac7f1508b98	2026-09-01 09:56	2026-09-01 09:56	2026-09-01 09:56	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.8000	0.7200	0.8200	173.9200	10400.00	2080.00	8320.00	130	6	1273	44	28.9318181818182	0.197479594843768	0.197479594843768	false	false	false	true
da090df8-7a73-4fe0-8593-03209d7a4be8	2026-09-01 09:54	2026-09-01 09:54	2026-09-01 09:54	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.7800	0.6900	0.7900	173.8600	11545.00	2341.00	4602.00	148	7	477	44	10.8409090909091	0.199544538580585	0.197861769338316	false	false	false	true
31ca0bf4-cc13-4e8d-84e5-5d5e558d0a07	2026-09-01 09:54	2026-09-01 09:54	2026-09-01 09:54	XLI	XLI260904C00175000	call	175.0000	2026-09-04	0.7900	0.6900	0.7900	173.8600	11053.00	10897.00	78.00	140	26	266	44	6.04545454545455	0.199544538580585	0.197861769338316	false	false	false	true
2cd6cc60-bc77-4e2b-83b5-cd1ab9e503f1	2026-09-01 09:36	2026-09-01 09:36	2026-09-01 09:36	XLI	XLI260918P00165000	put	165.0000	2026-09-18	0.3900	0.2900	0.4100	174.5800	14664.00	14586.00	40.00	376	45	391	53397	0.00732250875517351	0.214422515712251	0.215926443193317	false	false	false	true