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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	20716567207.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:30:11.536652Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
cbefa7e8-f15a-4763-9a0b-819e1b89b84c	2026-09-25 15:13	2026-09-25 15:13	2026-09-25 15:13	XLU	XLU261016C00041000	call	41.0000	2026-10-16	0.2500	0.2400	0.2600	39.4150	25540.00	23700.00	240.00	1022	26	27042	10375	2.6064578313253	0.199149648097435	0.202652140125126	false	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
60d865f7-772d-4c46-acbe-fbb8698826d0	2026-09-25 14:51	2026-09-25 14:51	2026-09-25 14:51	XLU	XLU261009C00040000	call	40.0000	2026-10-09	0.4200	0.3700	0.4300	39.0000	52500.00	52500.00	0.00	1250	1	31491	180	174.95	0.209829961277355	0.209829961277355	false	true	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
8667d257-693d-45dc-a17e-331350b9da32	2026-09-25 13:02	2026-09-25 13:02	2026-09-25 13:02	XLU	XLU261120C00041000	call	41.0000	2026-11-20	0.5700	0.5400	0.5800	39.3150	61835.00	40745.00	21090.00	1091	68	1465	485	3.02061855670103	0.181047273759369	0.182859353418012	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
bc3901f9-8a08-45bd-8a16-ee7606fd22b2	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.5200	0.6400	39.3250	37236.00	0.00	32132.00	642	10	2663	41	64.9512195121951	0.206550435686614	0.206550435686614	false	false	false	true
9daa33c9-2389-456b-80a3-384b159a4ccf	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.5200	0.5900	39.3250	16858.00	13785.00	3073.00	291	46	2021	41	49.2926829268293	0.206550435686614	0.206550435686614	false	false	false	true
e2331ffd-0f65-4e78-8208-10ff16953a13	2026-09-25 12:41	2026-09-25 12:41	2026-09-25 12:41	XLU	XLU261009C00039500	call	39.5000	2026-10-09	0.5500	0.5000	0.6100	39.3250	42730.00	41180.00	608.00	770	116	1619	41	39.4878048780488	0.196772378840994	0.203291345128161	false	false	false	true
9c650d77-552a-426c-a6ea-3400228ec297	2026-09-25 12:40	2026-09-25 12:40	2026-09-25 12:40	XLU	XLU261009C00039500	call	39.5000	2026-10-09	0.5400	0.4800	0.5500	39.3300	43186.00	36722.00	6464.00	802	104	812	41	19.8048780487805	0.192734061627519	0.195993018326609	false	false	false	true
72aecd6f-607c-4235-bb64-ed06ee8ebf48	2026-09-25 12:40	2026-09-25 12:40	2026-09-25 12:40	XLU	XLU261120C00043000	call	43.0000	2026-11-20	0.1900	0.1600	0.2000	39.3400	34127.00	34127.00	0.00	1828	87	2008	1392	1.44252873563218	0.182438625741908	0.188398581744017	false	false	false	true
e6b83e5a-caca-42b9-875b-064e1fa3ba76	2026-09-25 12:37	2026-09-25 12:37	2026-09-25 12:37	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.2000	0.1700	0.2300	39.3300	415787.00	406239.00	7848.00	20508	202	52785	5014	10.5275229357798	0.194204330338765	0.220937108001064	true	false	false
374c55ca-370e-4593-ad6a-fac5f22e6e83	2026-09-25 12:23	2026-09-25 12:23	2026-09-25 12:23	XLU	XLU261120C00040000	call	40.0000	2026-11-20	0.8700	0.8600	0.8700	39.3050	53070.00	53070.00	0.00	610	68	8094	3656	2.21389496717724	0.174153637899892	0.174153637899892	true	false	false	true
bf017b1d-c039-46d4-871f-7f636f222870	2026-09-25 12:20	2026-09-25 12:19	2026-09-25 12:19	XLU	XLU261120C00040000	call	40.0000	2026-11-20	0.8700	0.8600	0.8700	39.0000	43500.00	43500.00	0.00	500	16	7419	3656	2.02926695842451	0.174153637899892	0.174153637899892	true	false	false	true
71721d8c-b589-4915-9eb8-f798e725a947	2026-09-25 12:19	2026-09-25 12:19	2026-09-25 12:19	XLU	XLU261120C00040000	call	40.0000	2026-11-20	0.8600	0.8400	0.8700	39.0000	37582.00	32336.00	5246.00	437	60	6919	3656	1.89250547045952	0.17251172206769	0.17251172206769	true	false	false	true
4eb82cbe-4bcc-4024-a216-d7ee8c0057c9	2026-09-25 12:19	2026-09-25 12:19	2026-09-25 12:19	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.1500	0.1400	0.1500	39.0000	13695.00	13695.00	0.00	913	18	22115	5014	4.41065017949741	0.181200103840659	0.181200103840659	false	false	false	true
38a24c22-c731-4a65-9bb7-6c31884b66e7	2026-09-25 12:11	2026-09-25 12:10	2026-09-25 12:10	XLU	XLU261120C00040000	call	40.0000	2026-11-20	0.8500	0.8200	0.8500	39.0000	124610.00	124610.00	0.00	1466	21	5740	3656	1.57002188183807	0.170869401134062	0.170869401134062	false	false	false	true
22c65964-3bbb-4d94-8281-749f50ffc603	2026-09-25 12:10	2026-09-25 12:10	2026-09-25 12:10	XLU	XLU261120C00040000	call	40.0000	2026-11-20	0.8500	0.8100	0.8500	39.0000	42500.00	42500.00	0.00	500	41	4274	3656	1.16903719912473	0.171603312427338	0.171603312427338	true	false	false	true
1c42017a-b199-41dd-ac6c-09ffee265c47	2026-09-25 11:31	2026-09-25 11:31	2026-09-25 11:31	XLU	XLU261120C00040000	call	40.0000	2026-11-20	0.8300	0.7900	0.8300	39.0000	21497.00	21497.00	0.00	259	30	657	3656	0.179704595185996	0.174838350683912	0.174838350683912	false	false	false	true
e107de63-d399-4aa2-bccd-9cb5f459edcd	2026-09-25 11:08	2026-09-25 11:08	2026-09-25 11:08	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.4000	0.4000	0.4100	39.2450	80000.00	0.00	4240.00	2000	6	2668	3753	0.71089794830802	0.179754882865183	0.179754882865183	false	false	false	true
6296bb7a-5d1e-4285-aa69-2d7f5f5796c6	2026-09-25 10:18	2026-09-25 10:18	2026-09-25 10:18	XLU	XLU270115C00040000	call	40.0000	2027-01-15	1.3000	1.2500	1.3000	39.2500	12333.00	12333.00	0.00	95	8	226	3085	0.073257698541329	0.16079827462395	0.16079827462395	false	false	false	true
38d43f9c-a7de-4faa-bd12-a4454022a52e	2026-09-25 10:02	2026-09-25 10:02	2026-09-25 10:02	XLU	XLU261016C00040500	call	40.5000	2026-10-16	0.2500	0.2500	0.2600	39.0000	21950.00	0.00	21950.00	878	6	1916	1654	1.1584038694075	0.173818842968703	0.173818842968703	false	false	false	true
1e40583e-b321-43c3-a2a0-1f2a01fc2880	2026-09-25 09:49	2026-09-25 09:49	2026-09-25 09:49	XLU	XLU261016P00042000	put	42.0000	2026-10-16	2.7200	2.7200	2.7600	39.2900	11152.00	0.00	11152.00	41	5	41	9241	0.00443674926955957	0.215367376248943	0.215367376248943	true	false	false	true
4483ffe2-a6d4-4716-8852-fbafff89ca4b	2026-09-24 15:59	2026-09-24 15:59	2026-09-24 15:59	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.1700	0.1700	0.2000	39.0000	17000.00	0.00	17000.00	1000	46	8043	554	14.5180505415162	0.169554886496766	0.170269094170953	false	false	false	true
d1933999-d44e-40be-bf1a-18388745e8a7	2026-09-24 15:50	2026-09-24 15:50	2026-09-24 15:50	XLU	XLU270115C00040000	call	40.0000	2027-01-15	1.4200	1.4000	1.5600	39.4350	11644.00	7384.00	4260.00	82	5	581	2553	0.227575401488445	0.164251980240009	0.164251980240009	true	false	false	true
b02c13c6-dfea-43a0-a4b5-60e717a92006	2026-09-24 15:33	2026-09-24 15:33	2026-09-24 15:33	XLU	XLU281215P00036000	put	36.0000	2028-12-15	1.7000	1.4400	1.7800	39.4550	23800.00	2550.00	21250.00	140	8	327	185	1.76756756756757	0.206230015847773	0.206230015847773	false	false	false	true