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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×source = uw_flow_alerts×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	expiry

58fca1ba-a84a-4526-8701-1c0eaa48d045	2026-09-23 15:02	2026-09-23 15:02	2026-09-23 15:02	XLU	XLU270115C00040500	call	40.5000	2027-01-15	1.3300	1.3100	1.3400	39.7900	76608.00	76475.00	0.00	576	51	1090	610	1.78688524590164	0.158996496428114	0.1592773679855	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-23T19:05:07.702473Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
b4806350-be57-40e8-9e9c-bcc030dca0b1	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	XLU	XLU270115P00043000	put	43.0000	2027-01-15	3.4000	3.4000	3.4500	39.8600	15640.00	0.00	15640.00	46	8	64	10583	0.00604743456486819	0.200149084315187	0.200149084315187	false	false	false	true
cabed1fb-3af5-4cc8-8b0a-15b6cbe81377	2026-09-23 13:39	2026-09-23 13:39	2026-09-23 13:39	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.6100	0.5800	0.6100	39.0000	310063.00	310063.00	0.00	5083	64	5129	1097	4.67547857793984	0.17645362873714	0.176177484303661	true	false	false	true
a1c9746b-7a92-4c9b-986a-0ceb207a78f0	2026-09-23 12:10	2026-09-23 12:10	2026-09-23 12:10	XLU	XLU270115C00042000	call	42.0000	2027-01-15	0.7300	0.7100	0.8200	39.8299	12410.00	12191.00	219.00	170	15	183	8872	0.0206266907123535	0.153581296200865	0.153581296200865	false	false	false
fc671a69-e7ff-4e11-8f8e-5fe2b3cc8c98	2026-09-23 12:05	2026-09-23 12:05	2026-09-23 12:05	XLU	XLU261016C00041000	call	41.0000	2026-10-16	0.2800	0.2700	0.2800	39.8350	14000.00	14000.00	0.00	500	24	7202	2432	2.96134868421053	0.16921866602456	0.16921866602456	false	false	false	true
53b8c2c8-2ba4-48ee-8683-5154ec7fa948	2026-09-23 12:00	2026-09-23 12:00	2026-09-23 12:00	XLU	XLU270617P00034000	put	34.0000	2027-06-17	0.4300	0.3700	0.4300	39.8300	60114.00	60114.00	0.00	1398	12	1500	13	115.384615384615	0.202720247480894	0.202720247480894	true	false	false	true
863121e6-2605-4d40-ba80-6b866d919a01	2026-09-23 11:58	2026-09-23 11:58	2026-09-23 11:58	XLU	XLU261016P00040000	put	40.0000	2026-10-16	0.6900	0.6500	0.7000	39.8600	89700.00	14145.00	73485.00	1300	22	1496	13103	0.114172326948027	0.167718536035812	0.167718536035812	false	false	false
6ef476a6-afca-4188-bce9-1c590a47cf5c	2026-09-23 11:45	2026-09-23 11:45	2026-09-23 11:45	XLU	XLU261030P00039000	put	39.0000	2026-10-30	0.4300	0.4200	0.4300	39.0000	38098.00	38098.00	0.00	886	8	950	67	14.1791044776119	0.169280947727806	0.169280947727806	false	false	false	true
e16715c4-e111-4e87-bee5-9a30a3a458fb	2026-09-23 11:35	2026-09-23 11:35	2026-09-23 11:35	XLU	XLU270617P00039000	put	39.0000	2027-06-17	1.6200	1.5700	1.6200	39.8350	15228.00	15228.00	0.00	94	17	130	1443	0.0900900900900901	0.190951617017106	0.190951617017106	false	false	false	true
def07c12-0e01-44ee-be14-b0ac16685c46	2026-09-23 11:26	2026-09-23 11:26	2026-09-23 11:26	XLU	XLU261218C00042500	call	42.5000	2026-12-18	0.5100	0.5000	0.5200	39.9000	22950.00	18360.00	0.00	450	14	567	515	1.10097087378641	0.167125315518904	0.167125315518904	false	false	false	true
1d99904e-f468-41ec-9ed6-d8af74bbd145	2026-09-23 11:25	2026-09-23 11:25	2026-09-23 11:25	XLU	XLU270115P00042500	put	42.5000	2027-01-15	2.9600	2.8600	3.0000	39.9050	18944.00	7696.00	11248.00	64	6	75	12250	0.00612244897959184	0.192998896723119	0.192998896723119	false	false	false	true
5c69b747-a5f4-497c-a288-cbfcd25bc090	2026-09-23 11:13	2026-09-23 11:13	2026-09-23 11:13	XLU	XLU261218P00038500	put	38.5000	2026-12-18	0.5600	0.5400	0.5700	39.9592	13048.00	13048.00	0.00	233	12	236	2995	0.0787979966611018	0.16838467691004	0.16838467691004	false	false	false	true
8145cde7-bc2a-4c89-b08b-3583bd4d3083	2026-09-23 11:10	2026-09-23 11:10	2026-09-23 11:10	XLU	XLU261016C00041000	call	41.0000	2026-10-16	0.3000	0.2900	0.3000	39.9150	15000.00	15000.00	0.00	500	44	6174	2432	2.53865131578947	0.168455979895934	0.168455979895934	false	false	false	true
d82e180a-595b-481b-b799-22560f8aaa61	2026-09-23 10:30	2026-09-23 10:30	2026-09-23 10:30	XLU	XLU261120C00039000	call	39.0000	2026-11-20	1.8700	1.8500	1.8900	40.0550	35343.00	23936.00	8976.00	189	7	400	6	66.6666666666667	0.174663759459822	0.174663759459822	false	false	false	true
9a5cf003-ec74-4c68-b633-96d95ad5a53d	2026-09-23 10:22	2026-09-23 10:22	2026-09-23 10:22	XLU	XLU261016C00041000	call	41.0000	2026-10-16	0.3100	0.2900	0.3100	40.0200	15469.00	15469.00	0.00	499	42	5578	2432	2.29358552631579	0.162355053571249	0.162355053571249	false	false	false	true
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
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
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
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
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
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