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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = XLU×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

ff38e6f1-56ac-48b0-b804-80614ddd7921	2026-09-23 10:17	2026-09-23 10:17	2026-09-23 10:17	XLU	XLU270115C00040500	call	40.5000	2027-01-15	1.3900	1.3600	1.3900	40.0200	68805.00	68805.00	0.00	495	16	499	610	0.818032786885246	0.152817141299959	0.152817141299959	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	21200900909.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T14:18:11.787457Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
a77f36af-5804-4417-8699-2552eb9d6a0a	2026-09-23 10:13	2026-09-23 10:13	2026-09-23 10:13	XLU	XLU270319C00040000	call	40.0000	2027-03-19	2.1500	1.9700	2.1500	39.0000	18705.00	18705.00	0.00	87	20	91	510	0.17843137254902	0.15830222306213	0.15830222306213	false	false	false	true
2c2a1c6b-dc54-4fcf-b784-aa4d541e4d1b	2026-09-23 10:13	2026-09-23 10:13	2026-09-23 10:13	XLU	XLU261218C00040500	call	40.5000	2026-12-18	1.2100	1.1500	1.2100	39.9399	21175.00	21175.00	0.00	175	27	195	115	1.69565217391304	0.166602163965469	0.166602163965469	false	false	false	true
848c89bc-d6b5-4892-972d-6361d757e8a3	2026-09-23 10:09	2026-09-23 10:09	2026-09-23 10:09	XLU	XLU261002C00040500	call	40.5000	2026-10-02	0.2300	0.1900	0.2300	39.9100	92000.00	92000.00	0.00	4000	8	4158	126	33	0.179953769776798	0.179953769776798	false	false	false	true
b49253c1-abde-4721-aa27-0fbef3e27fe5	2026-09-23 09:56	2026-09-23 09:56	2026-09-23 09:56	XLU	XLU260925P00039500	put	39.5000	2026-09-25	0.1100	0.0700	0.1100	39.8526	20592.00	20592.00	0.00	1872	11	4006	316	12.6772151898734	0.213578509104633	0.213578509104633	true	false	false	true
649375b3-a729-47a0-8dcd-5ef3ae4b30d5	2026-09-23 09:52	2026-09-23 09:52	2026-09-23 09:52	XLU	XLU260925P00039500	put	39.5000	2026-09-25	0.0800	0.0700	0.0800	39.9550	13928.00	13928.00	0.00	1741	6	2001	316	6.33227848101266	0.208999900739662	0.208999900739662	true	false	false	true
b707be64-8bc1-41e2-9f8d-fb003480e9ae	2026-09-23 09:51	2026-09-23 09:51	2026-09-23 09:51	XLU	XLU260925P00040000	put	40.0000	2026-09-25	0.2300	0.0800	0.2300	39.9800	17709.00	17709.00	0.00	770	8	773	1180	0.655084745762712	0.189958872278486	0.189958872278486	true	false	false	true
e4e94a68-70d1-4844-8827-21b428d07dd7	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	XLU	XLU261016C00041000	call	41.0000	2026-10-16	0.3000	0.2700	0.3100	40.0000	65490.00	37530.00	21060.00	2183	15	4687	2432	1.92722039473684	0.157347772745026	0.157347772745026	true	false	false	true
7a1e1b78-d434-4136-a567-2fe5da6f7fd3	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	XLU	XLU261016C00041000	call	41.0000	2026-10-16	0.3100	0.2700	0.3100	40.0000	77500.00	3224.00	0.00	2500	7	2504	2432	1.02960526315789	0.161488516258329	0.161488516258329	false	false	false	true
eedf4bfe-68b6-432b-aac3-8dc07540dbfc	2026-09-22 14:08	2026-09-22 14:08	2026-09-22 14:08	XLU	XLU270115P00040000	put	40.0000	2027-01-15	1.1100	1.0600	1.1100	40.6250	11100.00	11100.00	0.00	100	5	286	32798	0.00872004390511617	0.181171430101225	0.181171430101225	false	false	false	true
40ce3990-1c7c-4065-800f-e81606140766	2026-09-22 13:36	2026-09-22 13:36	2026-09-22 13:36	XLU	XLU270115P00036000	put	36.0000	2027-01-15	0.2100	0.1800	0.2100	40.0000	17885.00	17885.00	0.00	852	39	862	4387	0.196489628447686	0.193839556364946	0.193839556364946	false	false	false	true
8d8c1e15-0b51-40be-8dad-e637c553b840	2026-09-22 12:16	2026-09-22 12:16	2026-09-22 12:16	XLU	XLU261120C00043000	call	43.0000	2026-11-20	0.3700	0.3700	0.3900	40.7600	18500.00	0.00	18500.00	500	5	784	440	1.78181818181818	0.160943961102496	0.160943961102496	false	false	false	true
0e317ce2-fca5-48e5-92f4-e15dae3f9606	2026-09-22 12:15	2026-09-22 12:15	2026-09-22 12:15	XLU	XLU261218C00043000	call	43.0000	2026-12-18	0.5900	0.5900	0.6400	40.7999	111274.00	0.00	111274.00	1886	10	2411	1939	1.24342444559051	0.158630249290387	0.158630249290387	true	false	false	true
35ac0184-00ed-41af-884e-c725a65b181b	2026-09-22 12:12	2026-09-22 12:11	2026-09-22 12:11	XLU	XLU261218P00040500	put	40.5000	2026-12-18	0.9600	0.9600	0.9900	40.7900	210048.00	0.00	210048.00	2188	76	2207	2518	0.87648927720413	0.161982511436056	0.161982511436056	true	false	false	true
96be1fa2-3b6e-4880-ab32-1c5349db4541	2026-09-22 12:03	2026-09-22 12:03	2026-09-22 12:03	XLU	XLU261218P00042000	put	42.0000	2026-12-18	1.7600	1.7600	1.8200	40.8100	40832.00	0.00	40832.00	232	18	756	5584	0.135386819484241	0.166693474850103	0.166693474850103	true	false	false	true
dcf7e84a-1932-421b-96d1-6a70be8712e2	2026-09-22 12:01	2026-09-22 12:01	2026-09-22 12:01	XLU	XLU261218P00042000	put	42.0000	2026-12-18	1.7600	1.7600	1.7800	40.7950	84304.00	0.00	84304.00	479	13	503	5584	0.0900787965616046	0.165584336803019	0.165584336803019	true	false	false	true
974907b0-7493-4464-a774-1499f1d8cd1a	2026-09-22 11:59	2026-09-22 11:59	2026-09-22 11:59	XLU	XLU261016C00042000	call	42.0000	2026-10-16	0.2400	0.2400	0.2500	40.7701	53712.00	0.00	53712.00	2238	14	8374	21327	0.392647817320767	0.154463898828869	0.154463898828869	true	false	false	true
b839faa6-c883-477d-a49d-7e33e1b0b41a	2026-09-22 11:55	2026-09-22 11:55	2026-09-22 11:55	XLU	XLU260925P00041000	put	41.0000	2026-09-25	0.3600	0.3600	0.3900	40.7750	22176.00	0.00	22176.00	616	47	717	4317	0.166087560806115	0.161937564544168	0.161937564544168	true	false	false	true
7bc7d118-b2a2-41dd-be68-471db481ae37	2026-09-22 11:55	2026-09-22 11:55	2026-09-22 11:55	XLU	XLU260925P00041000	put	41.0000	2026-09-25	0.3600	0.3600	0.4200	40.7750	83412.00	0.00	83412.00	2317	10	3034	4317	0.702802872365068	0.161937564544168	0.161937564544168	true	false	false	true
2a1e02d6-f3e7-4c6d-bb8e-bb448f6939ae	2026-09-22 11:51	2026-09-22 11:51	2026-09-22 11:51	XLU	XLU261016P00041000	put	41.0000	2026-10-16	0.6900	0.6900	0.7400	40.7850	89148.00	0.00	89148.00	1292	12	1577	3443	0.45803078710427	0.151845097060137	0.151845097060137	true	false	false	true
b4f7e3cb-6aae-47fa-8379-cac78bf97f90	2026-09-22 11:51	2026-09-22 11:50	2026-09-22 11:50	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.3000	0.3000	0.3400	40.7900	137430.00	0.00	137430.00	4581	60	4641	16994	0.273096386960104	0.157949265576933	0.157949265576933	true	false	false	true
75e12bdf-d046-4ca5-af2e-99d1399e4e6e	2026-09-22 11:51	2026-09-22 11:50	2026-09-22 11:50	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.3000	0.3000	0.3400	40.7900	30240.00	0.00	30240.00	1008	10	5649	16994	0.332411439331529	0.157949265576933	0.157949265576933	true	false	false	true
4320228b-c809-49de-8403-dbd3a2059ccf	2026-09-22 10:30	2026-09-22 10:30	2026-09-22 10:30	XLU	XLU261023C00042500	call	42.5000	2026-10-23	0.2000	0.1400	0.2500	40.6600	51980.00	20.00	51960.00	2599	20	2602	91	28.5934065934066	0.158919060826103	0.158919060826103	false	false	false	true
df525def-7d8c-4b04-be24-ee0f6359af6d	2026-09-22 09:47	2026-09-22 09:47	2026-09-22 09:47	XLU	XLU261016C00042000	call	42.0000	2026-10-16	0.1900	0.1900	0.2100	40.4500	85709.00	0.00	85709.00	4511	23	5762	21327	0.27017395789375	0.161808497612446	0.161808497612446	false	false	false	true
a5e67e3b-8b34-4cc0-889a-a2ead6a8d75f	2026-09-21 15:28	2026-09-21 15:28	2026-09-21 15:28	XLU	XLU270115P00036000	put	36.0000	2027-01-15	0.2100	0.1800	0.2100	40.7250	15477.00	15477.00	0.00	737	21	3274	1590	2.05911949685535	0.194041167283639	0.194041167283639	false	false	false	true
7916ca66-f950-43cd-ba80-4f9d0da18d77	2026-09-21 14:59	2026-09-21 14:59	2026-09-21 14:59	XLU	XLU261218C00044000	call	44.0000	2026-12-18	0.3600	0.3600	0.3800	40.6950	12672.00	0.00	12672.00	352	5	894	43243	0.0206738662904979	0.161284653109556	0.161284653109556	false	false	false	true
cbd4f841-341c-4fca-839f-9e21912b6320	2026-09-21 14:03	2026-09-21 14:03	2026-09-21 14:03	XLU	XLU270617P00041000	put	41.0000	2027-06-17	2.1500	2.1100	2.1600	40.0000	13760.00	6880.00	6880.00	64	11	181	2844	0.0636427566807314	0.192534958888886	0.192534958888886	false	false	false	true
0b1d8c43-bfda-47b6-bfa3-f057d8707b9a	2026-09-21 14:02	2026-09-21 14:02	2026-09-21 14:02	XLU	XLU261023P00039000	put	39.0000	2026-10-23	0.1800	0.1800	0.1900	40.0000	61308.00	0.00	61308.00	3406	20	3455	19	181.842105263158	0.167851422863807	0.167851422863807	false	false	false	true
828a06fa-6244-4f1e-97ab-0d8f16e9af6f	2026-09-21 13:40	2026-09-21 13:40	2026-09-21 13:40	XLU	XLU261218P00037500	put	37.5000	2026-12-18	0.2400	0.2200	0.2600	40.7800	55776.00	24.00	55752.00	2324	19	2371	8754	0.270847612519991	0.17697877400344	0.176671780167062	false	false	false	true
28d02ab0-7210-4d9b-8630-442ec3ebfc42	2026-09-21 12:18	2026-09-21 12:18	2026-09-21 12:18	XLU	XLU281215C00040000	call	40.0000	2028-12-15	5.7500	5.7000	5.8500	40.0000	12650.00	0.00	10350.00	22	6	24	189	0.126984126984127	0.114662379273165	0.114662379273165	false	false	false	true
58c83c58-e334-4eee-9004-f3128d65eadb	2026-09-21 12:03	2026-09-21 12:03	2026-09-21 12:03	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.3400	0.3400	0.3600	40.8750	25772.00	0.00	25772.00	758	30	814	87	9.35632183908046	0.169596337400326	0.169596337400326	false	false	false	true
4641a154-42b9-40ec-ba3a-a9df1de4e0c7	2026-09-21 11:45	2026-09-21 11:45	2026-09-21 11:45	XLU	XLU270319P00041000	put	41.0000	2027-03-19	1.7400	1.6600	1.7400	40.8750	12871.00	12871.00	0.00	74	6	236	423	0.557919621749409	0.183858732658702	0.183858732658702	false	false	false	true
39f9dbd4-e376-4002-9353-183a7071c1f7	2026-09-21 11:17	2026-09-21 11:17	2026-09-21 11:17	XLU	XLU261016P00039000	put	39.0000	2026-10-16	0.1300	0.1200	0.1400	40.8648	17433.00	0.00	17290.00	1341	20	1431	2964	0.482793522267206	0.174779826378363	0.174779826378363	false	false	false	true
8c5614a7-3181-47a7-839e-d8c0a6fdd779	2026-09-21 11:01	2026-09-21 11:00	2026-09-21 11:00	XLU	XLU261030P00038000	put	38.0000	2026-10-30	0.1200	0.1200	0.1600	40.7650	37716.00	0.00	37716.00	3143	9	3146	5	629.2	0.183235200484733	0.183235200484733	false	false	false	true
fb0b2050-a0af-48a3-9e45-c85ee01df18f	2026-09-21 10:38	2026-09-21 10:38	2026-09-21 10:38	XLU	XLU270115P00036000	put	36.0000	2027-01-15	0.2000	0.1900	0.2200	40.7450	11480.00	20.00	11460.00	574	10	576	1590	0.362264150943396	0.191941809898079	0.191941809898079	false	false	false	true
9c340906-5a37-4138-82b9-d50ad69f5cd1	2026-09-21 10:06	2026-09-21 10:06	2026-09-21 10:06	XLU	XLU261023P00039500	put	39.5000	2026-10-23	0.2900	0.2900	0.3600	40.6100	14500.00	0.00	14500.00	500	9	501	316	1.58544303797468	0.160272683589835	0.160272683589835	false	false	false	true
93de0015-6a8a-4201-ad44-b830fe52ed52	2026-09-18 14:54	2026-09-18 14:53	2026-09-18 14:53	XLU	XLU261016P00041000	put	41.0000	2026-10-16	0.6700	0.6700	0.6800	41.2550	11323.00	0.00	11323.00	169	14	999	2834	0.352505292872265	0.186538858761364	0.186538858761364	false	false	false	true
69f67eb3-7364-4c8f-a00e-1e898e2e21cf	2026-09-18 14:52	2026-09-18 14:52	2026-09-18 14:52	XLU	XLU270319C00042000	call	42.0000	2027-03-19	1.7100	1.6200	1.7200	41.2300	15224.00	15224.00	0.00	89	19	253	60	4.21666666666667	0.14135464295713	0.142218682227471	false	false	false	true
24ec4cb5-b4b4-4f6f-a16d-bf1b05c70d68	2026-09-18 13:51	2026-09-18 13:51	2026-09-18 13:51	XLU	XLU270617P00040000	put	40.0000	2027-06-17	1.6500	1.6100	1.6800	41.2150	19140.00	9240.00	9900.00	116	11	3344	34430	0.0971246006389776	0.198025495273265	0.198025495273265	true	false	false	true
f1572fd4-e40f-43ba-8393-a994f29413d1	2026-09-18 13:49	2026-09-18 13:48	2026-09-18 13:48	XLU	XLU270617P00040000	put	40.0000	2027-06-17	1.6500	1.6200	1.6500	41.2150	17160.00	17160.00	0.00	104	8	3117	34430	0.0905315132152193	0.198025495273265	0.198025495273265	false	false	false	true
6a301899-5c5f-413e-99c3-b21f8eceaeda	2026-09-18 13:36	2026-09-18 13:36	2026-09-18 13:36	XLU	XLU261218C00041000	call	41.0000	2026-12-18	1.5400	1.5100	1.5400	41.2150	88088.00	88088.00	0.00	572	45	805	714	1.12745098039216	0.146089933783559	0.146089933783559	false	false	false	true
70a54302-f909-4d4e-8fa3-3c57165d6c41	2026-09-18 13:34	2026-09-18 13:34	2026-09-18 13:34	XLU	XLU261016P00039000	put	39.0000	2026-10-16	0.1500	0.1500	0.1700	41.1700	34245.00	0.00	34245.00	2283	28	2362	182	12.978021978022	0.190715617008171	0.190715617008171	false	false	false	true
4798c670-6b50-450c-a865-83b97cd72f3a	2026-09-18 13:12	2026-09-18 13:12	2026-09-18 13:12	XLU	XLU270115C00042500	call	42.5000	2027-01-15	0.9600	0.9400	1.0000	41.1101	12192.00	96.00	12096.00	127	10	152	5517	0.0275512053652347	0.140150807446615	0.140146234353942	false	false	false	true
a2fd39b1-53ce-442e-8532-0207cfa0391e	2026-09-18 10:33	2026-09-18 10:33	2026-09-18 10:33	XLU	XLU261218P00036500	put	36.5000	2026-12-18	0.1700	0.1500	0.1700	41.2694	18309.00	18309.00	0.00	1077	33	1079	475	2.27157894736842	0.202328431117509	0.202328431117509	false	false	false	true
e4ecdd81-61be-4d2f-b05b-2309f454f0a2	2026-09-18 10:14	2026-09-18 10:14	2026-09-18 10:14	XLU	XLU281215P00030000	put	30.0000	2028-12-15	0.5500	0.3500	0.5600	41.2050	10890.00	1155.00	9735.00	198	18	198	9197	0.0215287593780581	0.223837175227294	0.223837175227294	false	false	false	true
eb0c9c0d-15b8-4146-a348-e995ce43f086	2026-09-18 10:11	2026-09-18 10:11	2026-09-18 10:11	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.3400	0.3400	0.3700	41.2100	52632.00	0.00	52632.00	1548	30	7824	10371	0.754411339311542	0.188415906457136	0.188415906457136	false	false	false	true
12dbc120-01e7-487f-b8c6-a19fba201210	2026-09-18 10:09	2026-09-18 10:09	2026-09-18 10:09	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.3500	0.3400	0.3600	41.1950	20405.00	20090.00	0.00	583	13	6265	10371	0.604088323208948	0.190078291612468	0.190078291612468	true	false	false	true
c1001258-060e-489c-bb93-e47451a5ffc6	2026-09-18 10:07	2026-09-18 10:07	2026-09-18 10:07	XLU	XLU261009C00042500	call	42.5000	2026-10-09	0.1600	0.1600	0.1900	41.2000	14400.00	0.00	14400.00	900	19	912	43	21.2093023255814	0.14273009712137	0.14273009712137	false	false	false	true
c8c664ed-118b-4550-84ca-3e694fa70b3b	2026-09-18 09:57	2026-09-18 09:57	2026-09-18 09:57	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.3500	0.3100	0.3500	41.1550	13790.00	13790.00	0.00	394	30	3076	10371	0.296596278083116	0.187258454137214	0.187258454137214	true	false	false	true
b2371f57-5e58-4bad-95be-4d6da98d8b19	2026-09-18 09:57	2026-09-18 09:57	2026-09-18 09:57	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.3500	0.2100	0.3500	41.1550	91210.00	91210.00	0.00	2606	14	5682	10371	0.547873879085913	0.187258454137214	0.187258454137214	true	false	false	true