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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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

17eb9266-920a-4667-91ac-d40d3ffd2329	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	XLU	XLU280121C00039500	call	39.5000	2028-01-21	3.7000	3.7000	4.2000	39.0000	40330.00	0.00	40330.00	109	7	109	191	0.570680628272251	0.127176260198049	0.127176260198049	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	20934668387.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T16:16:49.777231Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
b8a0bc7d-ee93-45c7-a695-108eada0f4fa	2026-09-24 11:47	2026-09-24 11:47	2026-09-24 11:47	XLU	XLU261120P00038000	put	38.0000	2026-11-20	0.4400	0.4400	0.4700	39.4250	63316.00	0.00	63316.00	1439	11	2008	144	13.9444444444444	0.176606799676109	0.176606799676109	true	false	false	true
0061f62a-a17f-47f8-a2f2-70ea75b2d58d	2026-09-24 11:47	2026-09-24 11:47	2026-09-24 11:47	XLU	XLU261120P00038000	put	38.0000	2026-11-20	0.4400	0.4400	0.4700	39.4250	24684.00	0.00	24684.00	561	44	569	144	3.95138888888889	0.176606799676109	0.176606799676109	true	false	false	true
24d03e45-385f-4425-9a2e-6d817ad7d30b	2026-09-24 11:41	2026-09-24 11:40	2026-09-24 11:40	XLU	XLU261120P00040000	put	40.0000	2026-11-20	1.2500	1.2300	1.2500	39.4550	28500.00	28500.00	0.00	228	29	1665	2912	0.571771978021978	0.176084843774921	0.176084843774921	false	false	false	true
02a161b4-bba2-4eff-9317-2e80e2ae06f6	2026-09-24 11:37	2026-09-24 11:37	2026-09-24 11:37	XLU	XLU261002C00040500	call	40.5000	2026-10-02	0.1100	0.1100	0.1200	39.0000	15378.00	0.00	15378.00	1398	49	8790	4191	2.09735146743021	0.181388751204494	0.181388751204494	true	false	false	true
924e6a03-a1f7-41ef-a69a-0517cff84c33	2026-09-24 11:36	2026-09-24 11:36	2026-09-24 11:36	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.2500	0.2200	0.2500	39.0000	11000.00	11000.00	0.00	440	33	6655	554	12.0126353790614	0.185348815380898	0.185348815380898	false	false	false	true
aca34649-89ab-4cac-9914-984921d2164f	2026-09-24 11:35	2026-09-24 11:35	2026-09-24 11:35	XLU	XLU261002C00040500	call	40.5000	2026-10-02	0.1100	0.1100	0.1200	39.0000	30811.00	0.00	30811.00	2801	37	7392	4191	1.76377952755906	0.181376766496987	0.181376766496987	true	false	false	true
5235b98a-c81b-4888-a5b9-eb403daeda20	2026-09-24 11:19	2026-09-24 11:19	2026-09-24 11:19	XLU	XLU261120C00039000	call	39.0000	2026-11-20	1.5200	1.5000	1.5200	39.5100	39976.00	39976.00	0.00	263	13	390	202	1.93069306930693	0.178207778579869	0.178207778579869	false	false	false	true
cea13b67-db7d-4561-93af-9d77fd0a1ae2	2026-09-24 10:59	2026-09-24 10:59	2026-09-24 10:59	XLU	XLU261002C00040000	call	40.0000	2026-10-02	0.2300	0.2300	0.2600	39.4950	10672.00	0.00	10672.00	464	11	5660	554	10.2166064981949	0.180800304203756	0.180800304203756	false	false	false	true
3f244f36-30e5-45fb-87a9-40a88b8594e6	2026-09-24 10:51	2026-09-24 10:50	2026-09-24 10:50	XLU	XLU270115P00042500	put	42.5000	2027-01-15	3.3000	3.1000	3.3500	39.5100	21780.00	5610.00	16170.00	66	25	76	12326	0.00616582833035859	0.203307231764358	0.203307231764358	false	false	false	true
fa214dbb-2f36-434b-80d6-53f049d3a594	2026-09-24 10:42	2026-09-24 10:42	2026-09-24 10:42	XLU	XLU261120C00040000	call	40.0000	2026-11-20	1.0100	0.9800	1.0100	39.5650	36966.00	36966.00	0.00	366	27	3637	712	5.10814606741573	0.175590214802496	0.175590214802496	false	false	false	true
685911ea-8d3e-447e-8869-7d0b5cbef197	2026-09-24 10:30	2026-09-24 10:30	2026-09-24 10:30	XLU	XLU261218P00043500	put	43.5000	2026-12-18	3.9000	3.6000	3.9000	39.6341	15210.00	15210.00	0.00	39	6	39	2079	0.0187590187590188	0.205166917405345	0.205166917405345	true	false	false	true
13e7fa83-85ff-4a8c-909d-0a0b84312849	2026-09-24 10:27	2026-09-24 10:27	2026-09-24 10:27	XLU	XLU261120C00042000	call	42.0000	2026-11-20	0.3600	0.3500	0.3600	39.6550	57888.00	57888.00	0.00	1608	27	1741	1004	1.73406374501992	0.171607146335306	0.171607146335306	false	false	false	true
f2bbc217-9007-4030-ba31-a73c39b8329e	2026-09-24 09:55	2026-09-24 09:55	2026-09-24 09:55	XLU	XLU261016C00041000	call	41.0000	2026-10-16	0.2400	0.2400	0.2800	39.7023	25056.00	0.00	25056.00	1044	10	1301	9976	0.130412991178829	0.171620657973507	0.171620657973507	true	false	false	true
acd96347-b2ba-4325-b368-1daaaaf32ac3	2026-09-24 09:54	2026-09-24 09:54	2026-09-24 09:54	XLU	XLU261016C00040000	call	40.0000	2026-10-16	0.6100	0.5600	0.6100	39.7100	152500.00	5307.00	0.00	2500	7	2513	722	3.48060941828255	0.180250029812679	0.180250029812679	false	false	false	true
ec14da48-9d7f-4c7f-a5b7-a7a3996b5e55	2026-09-24 09:53	2026-09-24 09:53	2026-09-24 09:53	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.6100	0.6100	0.7200	39.7550	47763.00	0.00	47763.00	783	15	1002	5885	0.170263381478335	0.167362418575843	0.167362418575843	true	false	false	true
1c0afbc8-bc71-4b76-a847-9fee1a5878db	2026-09-24 09:53	2026-09-24 09:53	2026-09-24 09:53	XLU	XLU261120P00039000	put	39.0000	2026-11-20	0.6100	0.6100	0.6300	39.7550	13237.00	0.00	13237.00	217	29	219	5885	0.0372132540356839	0.167362418575843	0.167362418575843	true	false	false	true
d4e565ce-6550-49fe-ac8a-5c3df5f7a85a	2026-09-24 09:53	2026-09-24 09:53	2026-09-24 09:53	XLU	XLU261120P00040000	put	40.0000	2026-11-20	1.0400	1.0200	1.0500	39.7600	26000.00	1560.00	24440.00	250	18	1414	2912	0.485576923076923	0.167194565829191	0.167194565829191	true	false	false	true
b4f877e4-cafd-41c0-aa03-b7bbcc358899	2026-09-24 09:53	2026-09-24 09:53	2026-09-24 09:53	XLU	XLU261120P00040000	put	40.0000	2026-11-20	1.0500	1.0400	1.0500	39.7600	12495.00	12495.00	0.00	119	18	1164	2912	0.399725274725275	0.16879111624823	0.16879111624823	false	false	false	true
7fdedf96-a924-4c57-8dde-e63993682d0d	2026-09-24 09:52	2026-09-24 09:52	2026-09-24 09:52	XLU	XLU261120P00040000	put	40.0000	2026-11-20	1.0600	1.0500	1.0800	39.7581	75578.00	26076.00	49502.00	713	32	818	2912	0.280906593406593	0.170240726979612	0.170240726979612	true	false	false	true
5d4facc5-733a-44fb-a273-1a53c893fe72	2026-09-24 09:52	2026-09-24 09:52	2026-09-24 09:52	XLU	XLU281215C00038000	call	38.0000	2028-12-15	6.0500	6.0500	6.2000	39.7500	15125.00	0.00	15125.00	25	5	25	63	0.396825396825397	0.0979348116953397	0.0979348116953397	false	false	false	true
1dcbb1d2-8f5b-40fe-8cf7-fcec343039b6	2026-09-24 09:46	2026-09-24 09:46	2026-09-24 09:46	XLU	XLU270115C00039000	call	39.0000	2027-01-15	2.1000	2.0500	2.3000	39.7200	57960.00	55860.00	2100.00	276	26	285	601	0.474209650582363	0.160899655682075	0.160899655682075	false	false	false	true
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
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	true
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
b141b851-7ada-49b8-ac75-0d1c6a9aff2f	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.4200	0.4400	39.8250	52373.00	46612.00	42.00	1218	13	2806	13	215.846153846154	0.201139051757216	0.2026326797481	true	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	true
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
54ca7166-41ce-4b83-a8d7-e72723eb4a08	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.4700	0.5100	39.8800	12368.00	11968.00	400.00	244	27	853	515	1.65631067961165	0.166394079680995	0.167966046601946	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	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