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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	20716567207.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
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	true
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
a304a080-e0df-412f-81e8-72638f77a29b	2026-09-24 15:33	2026-09-24 15:32	2026-09-24 15:32	XLU	XLU290119P00034000	put	34.0000	2029-01-19	1.2000	1.2000	1.3100	39.4650	37441.00	121.00	37320.00	312	17	537	2	268.5	0.20448073117983	0.205163971328616	false	false	false	true
ffe2281e-b9a7-41cd-9c07-da4b18ddc9aa	2026-09-24 15:33	2026-09-24 15:32	2026-09-24 15:32	XLU	XLU290119P00034000	put	34.0000	2029-01-19	1.2000	1.1000	1.3100	39.4650	13680.00	0.00	13680.00	114	11	225	2	112.5	0.20448073117983	0.20448073117983	false	false	false	true
fe428e11-4443-409c-acf9-e751c07d5202	2026-09-24 15:33	2026-09-24 15:32	2026-09-24 15:32	XLU	XLU290119P00035000	put	35.0000	2029-01-19	1.4300	1.4300	1.5500	39.4650	41041.00	0.00	41041.00	287	15	289	8275	0.0349244712990937	0.204220968186922	0.204220968186922	false	false	false	true
36934d32-f1ff-4804-8f6f-4c4c3926a09a	2026-09-24 15:33	2026-09-24 15:32	2026-09-24 15:32	XLU	XLU290119P00036000	put	36.0000	2029-01-19	1.7000	1.4400	1.8400	39.4600	216410.00	48280.00	168130.00	1273	14	1273	2755	0.462068965517241	0.2046686812952	0.2046686812952	false	false	false	true
3d9706c1-cbf7-4189-ba5f-31e033909e67	2026-09-24 15:12	2026-09-24 15:12	2026-09-24 15:12	XLU	XLU270319P00040000	put	40.0000	2027-03-19	2.0000	1.9300	2.0000	39.4801	12000.00	12000.00	0.00	60	8	892	850	1.04941176470588	0.197310104401591	0.197310104401591	false	false	false	true
677dd754-4a8b-472d-8c0e-ac57bb66b0f8	2026-09-24 15:12	2026-09-24 15:12	2026-09-24 15:12	XLU	XLU270319P00040000	put	40.0000	2027-03-19	2.0000	1.9300	2.0000	39.4850	12000.00	12000.00	0.00	60	12	832	850	0.978823529411765	0.197513375514249	0.197513375514249	false	false	false	true
d9c660a8-4a69-4955-b463-c9c11cc7ec2e	2026-09-24 15:05	2026-09-24 15:05	2026-09-24 15:05	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.4700	0.4700	0.4900	39.4599	11750.00	0.00	11750.00	250	15	3858	722	5.34349030470914	0.172063838154413	0.172063838154413	false	false	false	true
434070e4-d3ae-4813-a0fc-ebfc17564915	2026-09-24 14:39	2026-09-24 14:39	2026-09-24 14:39	XLU	XLU261218P00045000	put	45.0000	2026-12-18	5.6000	5.3500	5.6000	39.5200	199360.00	199360.00	0.00	356	2	8567	11056	0.774873371924747	0.275648113264945	0.275648113264945	false	true	true	false
c4885d10-fb4e-498d-8115-b699040f54f3	2026-09-24 14:39	2026-09-24 14:38	2026-09-24 14:38	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.9800	1.9200	1.9800	39.4850	11880.00	11880.00	0.00	60	6	521	850	0.612941176470588	0.195670475465561	0.195670475465561	false	false	false	true
41bfbe4a-d735-40e8-a674-0044b7c9a41a	2026-09-24 14:16	2026-09-24 14:16	2026-09-24 14:16	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.9600	1.8900	1.9600	39.5100	11760.00	11760.00	0.00	60	8	435	850	0.511764705882353	0.194862249695076	0.194862249695076	false	false	false	true
5557e0eb-d2c2-4d06-b967-a5c65ec264f0	2026-09-24 14:16	2026-09-24 14:16	2026-09-24 14:16	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.9600	1.8600	1.9600	39.5050	11760.00	11760.00	0.00	60	8	371	850	0.436470588235294	0.194655665995536	0.194655665995536	false	false	false	true
78b42e4b-aa94-489b-b35d-165db2f9c76d	2026-09-24 14:15	2026-09-24 14:15	2026-09-24 14:15	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.9500	1.8600	1.9500	39.5050	11894.00	11894.00	0.00	61	24	311	850	0.365882352941176	0.193734256487675	0.193734256487675	false	false	false	true
adc8666a-b246-4e87-ae2a-c0469c650d63	2026-09-24 13:33	2026-09-24 13:33	2026-09-24 13:33	XLU	XLU290119P00040000	put	40.0000	2029-01-19	3.2500	3.2500	3.3500	39.5900	19500.00	0.00	19500.00	60	12	202	3363	0.0600654177817425	0.216824962577655	0.216824962577655	false	false	false	true
a6d2f00e-9691-4128-9376-b04a761b8de3	2026-09-24 13:33	2026-09-24 13:33	2026-09-24 13:33	XLU	XLU290119P00040000	put	40.0000	2029-01-19	3.2800	3.2500	3.5000	39.5900	19680.00	0.00	19680.00	60	6	142	3363	0.0422242045792447	0.218684410145904	0.216824962577655	false	false	false	true
481e4cac-96c6-4e62-b571-44ec9665151e	2026-09-24 13:32	2026-09-24 13:32	2026-09-24 13:32	XLU	XLU290119P00040000	put	40.0000	2029-01-19	3.2900	3.2500	3.5000	39.5915	19730.00	0.00	19730.00	60	7	82	3363	0.024382991376747	0.219171264263624	0.216847099090808	false	false	false	true
8bd21588-d70a-44f8-81d0-dc43d63b3747	2026-09-24 13:28	2026-09-24 13:28	2026-09-24 13:28	XLU	XLU290119P00039000	put	39.0000	2029-01-19	2.8500	2.6000	2.9200	39.5788	19380.00	2280.00	17100.00	68	8	175	32	5.46875	0.215796163901481	0.215796163901481	false	false	false	true
30c0813d-06d7-4395-9e9d-62ae62cffb78	2026-09-24 13:27	2026-09-24 13:27	2026-09-24 13:27	XLU	XLU290119P00039000	put	39.0000	2029-01-19	2.8700	2.8700	2.9000	39.5760	15498.00	0.00	15498.00	54	9	107	32	3.34375	0.21672418307644	0.21672418307644	false	false	false	true
8b08fb0f-470c-496d-aad3-47854db08323	2026-09-24 13:20	2026-09-24 13:20	2026-09-24 13:20	XLU	XLU261016C00040500	call	40.5000	2026-10-16	0.3800	0.3100	0.3900	39.5950	57000.00	57000.00	0.00	1500	5	1510	50	30.2	0.181809735584866	0.181809735584866	false	true	false	true
b08a83af-d6d5-44a0-8cdb-48f41d0cac45	2026-09-24 13:03	2026-09-24 13:03	2026-09-24 13:03	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.6700	0.6700	0.6800	39.6699	20502.00	0.00	20502.00	306	11	5017	5885	0.85250637213254	0.172658843143321	0.172658843143321	true	false	false	true
786cbf37-abca-4d15-9505-72487af3e481	2026-09-24 13:03	2026-09-24 13:03	2026-09-24 13:03	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.6700	0.6700	0.6800	39.6600	23383.00	0.00	23383.00	349	19	4709	5885	0.80016992353441	0.172058381005544	0.172058381005544	true	false	false	true
14c3145b-262e-4f5c-8a11-6e0a2fd694ea	2026-09-24 13:03	2026-09-24 13:03	2026-09-24 13:03	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.6800	0.6800	0.7000	39.6600	21896.00	0.00	21896.00	322	40	3969	5885	0.674426508071368	0.173773252903072	0.173773252903072	true	false	false	true
4660ee1b-3247-4367-b437-c2065b889d23	2026-09-24 13:03	2026-09-24 13:03	2026-09-24 13:03	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.7000	0.7000	0.7400	39.6600	38360.00	0.00	38360.00	548	43	3529	5885	0.599660152931181	0.177197335640309	0.177197335640309	true	false	false	true
1dd3d076-ff4a-43ba-ba78-3edcc05561c2	2026-09-24 12:39	2026-09-24 12:39	2026-09-24 12:39	XLU	XLU261218C00038000	call	38.0000	2026-12-18	2.5500	2.4300	2.6400	39.5600	25500.00	25500.00	0.00	100	8	200	257	0.778210116731518	0.184673947435462	0.185247614951248	false	false	false	true
817338fa-1432-4fb4-9a20-afb78e17a654	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.7000	0.7000	0.7100	39.0000	23380.00	0.00	23380.00	334	9	2958	5885	0.502633814783347	0.173200849324318	0.173200849324318	true	false	false	true
4fa44cae-9b6b-46fe-aeaf-f9dded19f1d3	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.7000	0.7000	0.7200	39.0000	16590.00	0.00	16590.00	237	25	2624	5885	0.445879354290569	0.173200849324318	0.173200849324318	true	false	false	true
50b6f182-13a6-46e6-bc53-f797b880e38f	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.7300	0.7300	0.7600	39.0000	34456.00	0.00	34456.00	472	16	2161	5885	0.367204757858963	0.17830141597093	0.17830141597093	true	false	false	true