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: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

515ef6bd-0535-476b-bc38-822e201fcb8d	2026-09-25 15:58	2026-09-25 15:58	2026-09-25 15:58	XLU	XLU261009C00040000	call	40.0000	2026-10-09	0.4600	0.4600	0.5300	39.0000	13938.00	0.00	13938.00	303	34	31909	180	177.272222222222	0.207372848008608	0.207372848008608	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	20716567207.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
9026491d-7e48-474c-a523-be46e262ac2f	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.6100	0.5900	0.6100	39.5750	25132.00	25132.00	0.00	412	25	19763	3753	5.26592059685585	0.201160019079844	0.201160019079844	false	false	false	true
27a79636-c918-4901-85e4-5068c037625a	2026-09-25 15:51	2026-09-25 15:50	2026-09-25 15:50	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.3300	0.3300	0.3500	39.0000	23925.00	0.00	23925.00	725	43	90384	5014	18.0263262863981	0.226965060087891	0.226965060087891	false	false	false	true
260843fa-346f-48a7-8b30-42cac6f686bd	2026-09-25 15:50	2026-09-25 15:50	2026-09-25 15:50	XLU	XLU270115C00040000	call	40.0000	2027-01-15	1.5800	1.5100	1.5800	39.0000	39500.00	39500.00	0.00	250	6	1566	3085	0.507617504051864	0.17470399536991	0.17470399536991	false	false	false	true
19c096a1-a4f9-46a7-8f21-34f3117131a8	2026-09-25 15:50	2026-09-25 15:50	2026-09-25 15:50	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.6100	0.5800	0.6100	39.0000	11224.00	11224.00	0.00	184	18	18917	3753	5.04050093258726	0.199981839062328	0.199981839062328	false	false	false	true
4edaf5a7-e144-4e7a-a9c8-1bb6404cdf0b	2026-09-25 15:45	2026-09-25 15:45	2026-09-25 15:45	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5900	0.5800	0.5900	39.0000	18467.00	18467.00	0.00	313	6	18305	3753	4.87743138822275	0.200478481227721	0.200478481227721	false	false	false	true
10f3b6f0-9687-47e5-ba70-5b5415618f91	2026-09-25 15:45	2026-09-25 15:45	2026-09-25 15:45	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5900	0.5800	0.5900	39.0000	18290.00	18290.00	0.00	310	15	17992	3753	4.79403144151346	0.201057540547675	0.201057540547675	false	false	false	true
a8dc39f9-4a95-41c6-a4d1-58ea5fccff62	2026-09-25 15:45	2026-09-25 15:44	2026-09-25 15:44	XLU	XLU261120C00040000	call	40.0000	2026-11-20	1.1100	1.1000	1.1100	39.0000	16650.00	16650.00	0.00	150	9	9990	3656	2.73249452954048	0.198040321537057	0.198040321537057	false	false	false	true
e10c9012-5d9f-4611-a7ee-fb1cc0e61ac1	2026-09-25 15:44	2026-09-25 15:44	2026-09-25 15:44	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5700	0.5600	0.5700	39.0000	19209.00	19209.00	0.00	337	19	17640	3753	4.70023980815348	0.197985765715581	0.197985765715581	false	false	false	true
72baa755-53a6-4c9b-aaac-ab66deda7ef9	2026-09-25 15:44	2026-09-25 15:44	2026-09-25 15:44	XLU	XLU261120C00040000	call	40.0000	2026-11-20	1.1100	1.1000	1.1100	39.0000	11100.00	11100.00	0.00	100	10	9818	3656	2.68544857768053	0.198040321537057	0.198040321537057	false	false	false	true
14e700d5-0e4f-4c33-b977-49cd887ac144	2026-09-25 15:44	2026-09-25 15:44	2026-09-25 15:44	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5700	0.5600	0.5700	39.0000	23655.00	23655.00	0.00	415	38	17303	3753	4.61044497735145	0.198558379756237	0.198558379756237	false	false	false	true
9ce7447b-5cc2-4584-8afb-5a67369f7335	2026-09-25 15:37	2026-09-25 15:37	2026-09-25 15:37	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.5600	0.5100	0.5600	39.0000	11200.00	11200.00	0.00	200	14	16339	3753	4.35358379962697	0.19927623004758	0.19927623004758	false	false	false	true
e562961b-6362-4881-b402-7682d9cce195	2026-09-25 15:37	2026-09-25 15:37	2026-09-25 15:37	XLU	XLU261002P00039000	put	39.0000	2026-10-02	0.2400	0.2300	0.2400	39.0000	13872.00	13872.00	0.00	578	6	741	2410	0.30746887966805	0.20672311894577	0.20672311894577	true	false	false	true
5fc05787-368d-4b4a-80a5-bf28dfbe65c3	2026-09-25 15:35	2026-09-25 15:35	2026-09-25 15:35	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.6900	0.6900	0.7100	39.4600	37812.00	0.00	37812.00	548	17	18295	485	37.7216494845361	0.195454409709353	0.195454409709353	true	false	false	true
b7a66618-f8b7-452c-bc50-20cafabbdc95	2026-09-25 15:34	2026-09-25 15:34	2026-09-25 15:34	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.7000	0.6900	0.7000	39.4450	14000.00	14000.00	0.00	200	5	17721	485	36.5381443298969	0.1981183195214	0.1981183195214	false	false	false	true
9a40cda8-d9f4-48e6-8986-de7361efffcb	2026-09-25 15:32	2026-09-25 15:32	2026-09-25 15:32	XLU	XLU261016C00039000	call	39.0000	2026-10-16	1.0500	1.0300	1.0500	39.4550	26145.00	26145.00	0.00	249	31	930	336	2.76785714285714	0.199017409532966	0.199017409532966	false	false	false	true
d572b681-8f24-4561-9f2b-1276e8345140	2026-09-25 15:31	2026-09-25 15:31	2026-09-25 15:31	XLU	XLU261120C00043000	call	43.0000	2026-11-20	0.2700	0.2600	0.2800	39.4500	14256.00	0.00	13527.00	528	26	21766	1392	15.6364942528736	0.203141437981762	0.202925170840427	false	false	false	true
12098273-c8dc-44e3-b899-c8db509c0bf4	2026-09-25 15:31	2026-09-25 15:31	2026-09-25 15:31	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.2700	0.2700	0.2900	39.4500	53190.00	0.00	53190.00	1970	39	89054	5014	17.761069006781	0.221606292230973	0.221606292230973	true	false	false	true
6e5adb15-db55-4ced-b2fd-08f976291554	2026-09-25 15:29	2026-09-25 15:29	2026-09-25 15:29	XLU	XLU261016C00039500	call	39.5000	2026-10-16	0.7700	0.7400	0.7800	39.4400	14014.00	14014.00	0.00	182	14	693	534	1.29775280898876	0.199984134616284	0.199984134616284	false	false	false	true
cfe52e4c-b6d6-4b6a-bd56-5e04f743c62d	2026-09-25 15:27	2026-09-25 15:27	2026-09-25 15:27	XLU	XLU281215C00040000	call	40.0000	2028-12-15	4.6500	4.6500	4.8000	39.4500	64635.00	0.00	64635.00	139	15	477	229	2.08296943231441	0.110641505548064	0.110641505548064	false	false	false	true
1ea04efc-0717-49cb-b14c-187d615fe336	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.6700	0.6700	0.6950	39.4550	10720.00	0.00	10720.00	160	13	16864	485	34.7711340206186	0.192270627916258	0.192270627916258	true	false	false	true
bbc89c0c-40c1-42a7-80a8-e1db24be79f7	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.6700	0.6700	0.7200	39.4550	97820.00	0.00	97820.00	1460	34	16704	485	34.4412371134021	0.192270627916258	0.192270627916258	true	false	false	true
d9956f7d-fcf7-4063-9f99-2df47d5a6f6a	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.6800	0.6700	0.6900	39.4550	52904.00	0.00	52836.00	778	12	15244	485	31.4309278350515	0.194017452978398	0.194017452978398	true	false	false	true
91f0f7d5-1367-484a-a27b-017b7ebe37ad	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.6800	0.6800	0.6900	39.4550	11832.00	0.00	11832.00	174	24	14466	485	29.8268041237113	0.194017452978398	0.194017452978398	true	false	false	true
f2ae2900-18dd-4999-8289-9865ab8b220c	2026-09-25 15:12	2026-09-25 15:12	2026-09-25 15:12	XLU	XLU261009C00042000	call	42.0000	2026-10-09	0.0700	0.0100	0.0800	39.4150	31262.00	31059.00	140.00	4466	67	9486	112	84.6964285714286	0.229384278084381	0.229384278084381	false	false	false	true
87959eb2-73dc-4e22-a427-b39159613acc	2026-09-25 15:11	2026-09-25 15:11	2026-09-25 15:11	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.6700	0.6600	0.6700	39.3999	13400.00	13400.00	0.00	200	12	13863	485	28.5835051546392	0.195625996968422	0.195625996968422	false	false	false	true
32317540-ece0-4290-9eb2-1b781a971a2d	2026-09-25 15:10	2026-09-25 15:10	2026-09-25 15:10	XLU	XLU261016P00040000	put	40.0000	2026-10-16	1.0300	1.0300	1.0500	39.0000	51500.00	0.00	51500.00	500	28	945	11496	0.0822025052192067	0.193248465413425	0.193248465413425	false	false	false	true
6e67ed32-90bd-4c2d-a0a3-de3e683b26fd	2026-09-25 15:09	2026-09-25 15:09	2026-09-25 15:09	XLU	XLU261009C00042000	call	42.0000	2026-10-09	0.0600	0.0500	0.0700	39.0000	20244.00	7614.00	10392.00	3374	23	3394	112	30.3035714285714	0.223358033285629	0.223358033285629	false	false	false	true
0edb259f-f6a0-499e-9ba4-c2cdec772668	2026-09-25 15:07	2026-09-25 15:07	2026-09-25 15:07	XLU	XLU261016P00040000	put	40.0000	2026-10-16	1.0300	1.0200	1.0500	39.0000	11124.00	0.00	11124.00	108	17	307	11496	0.026704940848991	0.194327646078924	0.194327646078924	false	false	false	true
0adefdab-6913-4a10-a31e-2c3761030aba	2026-09-25 15:05	2026-09-25 15:05	2026-09-25 15:05	XLU	XLU261120C00040000	call	40.0000	2026-11-20	1.0300	1.0100	1.0500	39.0000	39655.00	11124.00	28531.00	385	11	9288	3656	2.54048140043764	0.195084408707141	0.195084408707141	true	false	false	true
ee56fc78-f335-4997-92b7-b95dd174d019	2026-09-25 14:52	2026-09-25 14:52	2026-09-25 14:52	XLU	XLU271217C00040000	call	40.0000	2027-12-17	3.4500	3.3000	3.4500	39.0000	34500.00	34500.00	0.00	100	11	126	545	0.231192660550459	0.146896631897887	0.146896631897887	false	false	false	true
a5287dd0-c1bf-4625-a063-d37738ad819c	2026-09-25 14:48	2026-09-25 14:48	2026-09-25 14:48	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.8800	0.8600	0.8900	39.0000	29216.00	27984.00	0.00	332	15	2381	8746	0.272238737708667	0.191010179461672	0.191010179461672	false	false	false	true
f36f1c41-184c-4e32-8e4e-7b460f26e422	2026-09-25 14:42	2026-09-25 14:42	2026-09-25 14:42	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.2500	0.2400	0.2500	39.4050	20575.00	20575.00	0.00	823	27	85209	5014	16.994216194655	0.219075836214775	0.219075836214775	true	false	false	true
bda74ea9-61f6-4441-9e79-86da78a0d1cf	2026-09-25 14:25	2026-09-25 14:25	2026-09-25 14:25	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.6300	0.6200	0.6800	39.3650	56322.00	52668.00	3654.00	894	60	13479	485	27.7917525773196	0.190661115633861	0.190661115633861	false	false	false	true
3659aaf5-bebe-4009-807a-94ffab423afe	2026-09-25 14:25	2026-09-25 14:25	2026-09-25 14:25	XLU	XLU261120C00040000	call	40.0000	2026-11-20	0.9900	0.9800	1.0500	39.3650	25839.00	25740.00	99.00	261	43	8701	3656	2.37992341356674	0.189315917606584	0.189315917606584	false	false	false	true
310346ca-973b-4108-8f11-f66d027ba5f7	2026-09-25 14:14	2026-09-25 14:14	2026-09-25 14:14	XLU	XLU261016C00041500	call	41.5000	2026-10-16	0.1500	0.1500	0.1600	39.3950	12270.00	0.00	12270.00	818	23	12781	1251	10.2166266986411	0.199849855758953	0.199849855758953	false	false	false	true
fccf968f-4ae2-42b9-9924-b00975575f1f	2026-09-25 14:13	2026-09-25 14:13	2026-09-25 14:13	XLU	XLU261016P00038000	put	38.0000	2026-10-16	0.2400	0.2000	0.2400	39.3950	11064.00	11064.00	0.00	461	25	1270	1357	0.935887988209285	0.206279078055866	0.206279078055866	false	false	false	true
b40d0ce6-2908-45b7-9eb4-c6680a32841c	2026-09-25 14:02	2026-09-25 14:01	2026-09-25 14:01	XLU	XLU261016C00041000	call	41.0000	2026-10-16	0.2200	0.2100	0.2300	39.0000	11836.00	0.00	11770.00	538	42	24933	10375	2.40318072289157	0.196306211433058	0.195536533616207	false	false	false	true
3389a797-ede3-4309-8f99-9f3ce0b5fb09	2026-09-25 13:56	2026-09-25 13:56	2026-09-25 13:56	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.5900	0.5800	0.6000	39.3450	21122.00	16461.00	885.00	358	21	12156	485	25.0639175257732	0.184704772879751	0.184704772879751	false	false	false	true
7a6938d9-3561-4932-88bb-d2b8c726ce3e	2026-09-25 13:49	2026-09-25 13:49	2026-09-25 13:49	XLU	XLU270319C00043000	call	43.0000	2027-03-19	0.8500	0.7700	0.8500	39.3550	11050.00	11050.00	0.00	130	14	155	699	0.221745350500715	0.171057340977772	0.171057340977772	true	false	false	true
b90b03a2-cf9c-4fd4-8ea2-6aebb336e590	2026-09-25 13:49	2026-09-25 13:48	2026-09-25 13:48	XLU	XLU270319C00045000	call	45.0000	2027-03-19	0.4600	0.4500	0.5300	39.3450	182000.00	0.00	182000.00	4000	2	35898	490	73.2612244897959	0.171845383537794	0.171845383537794	false	true	false	true
8b11a79d-6eae-4dc5-b774-f4f7800d352a	2026-09-25 13:48	2026-09-25 13:48	2026-09-25 13:48	XLU	XLU270319C00045000	call	45.0000	2027-03-19	0.4600	0.4600	0.5300	39.3350	17112.00	0.00	17112.00	372	32	31520	490	64.3265306122449	0.173468675831654	0.173468675831654	false	false	false	true
399886be-b3f4-4499-8a89-b79d8aa80710	2026-09-25 13:48	2026-09-25 13:48	2026-09-25 13:48	XLU	XLU270319C00045000	call	45.0000	2027-03-19	0.4600	0.4600	0.5300	39.3350	17388.00	0.00	17388.00	378	15	31898	490	65.0979591836735	0.173468675831654	0.173468675831654	true	false	false	true
e6ba0074-be86-4121-b27e-684ceb4cf3ef	2026-09-25 13:48	2026-09-25 13:48	2026-09-25 13:48	XLU	XLU270319C00045000	call	45.0000	2027-03-19	0.4600	0.4600	0.4700	39.3301	11500.00	0.00	11500.00	250	7	31148	490	63.5673469387755	0.173594016518611	0.173594016518611	false	false	false	true
60c600df-1c0b-4d8a-9ff4-a3d12d59b227	2026-09-25 13:48	2026-09-25 13:48	2026-09-25 13:48	XLU	XLU270319C00045000	call	45.0000	2027-03-19	0.4700	0.4600	0.4700	39.3350	23500.00	23500.00	0.00	500	24	30897	490	63.0551020408163	0.174827695400145	0.174827695400145	false	false	false	true
13f55dd8-7b73-422f-88c1-78cf2ef1bedc	2026-09-25 13:45	2026-09-25 13:45	2026-09-25 13:45	XLU	XLU261016C00039000	call	39.0000	2026-10-16	0.9300	0.8600	0.9400	39.3100	45384.00	45384.00	0.00	488	11	610	336	1.81547619047619	0.190338241035981	0.190338241035981	true	false	false	true
bd13658f-a685-450b-a475-a36121ca3502	2026-09-25 13:38	2026-09-25 13:38	2026-09-25 13:38	XLU	XLU270319C00045000	call	45.0000	2027-03-19	0.4600	0.3800	0.4700	39.0000	1365000.00	1365000.00	0.00	30000	2	30013	490	61.2510204081633	0.172746903316364	0.172746903316364	false	true	false	true
6fd33f27-1c5b-4262-a5a7-0df9683a0bea	2026-09-25 13:35	2026-09-25 13:35	2026-09-25 13:35	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.8700	0.8700	0.8800	39.0000	17313.00	0.00	17313.00	199	13	1703	8746	0.194717585181797	0.182538171058491	0.182538171058491	true	false	false	true
45ad77f0-bd5d-4a85-a336-88c8542c813e	2026-09-25 12:58	2026-09-25 12:58	2026-09-25 12:58	XLU	XLU261016C00041000	call	41.0000	2026-10-16	0.1900	0.1900	0.2000	39.3050	17917.00	0.00	17917.00	943	26	21939	10375	2.11460240963855	0.189316807185865	0.189316807185865	false	false	false	true
7f874215-1060-4acd-9951-46d5d4343a6c	2026-09-25 12:41	2026-09-25 12:41	2026-09-25 12:41	XLU	XLU261009C00039500	call	39.5000	2026-10-09	0.5800	0.5800	0.5900	39.3300	14442.00	0.00	14442.00	249	5	3059	41	74.609756097561	0.205768363821778	0.205768363821778	true	false	false	true