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 = XLF×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

d8aae814-5e07-4dcf-819f-ad15b233a015	2026-09-17 11:14	2026-09-17 11:14	2026-09-17 11:14	XLF	XLF270630C00058000	call	58.0000	2027-06-30	2.9500	2.9000	3.1000	55.8000	247210.00	217415.00	29795.00	838	13	838	2070	0.404830917874396	0.154865202005154	0.154865202005154	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	54292614098.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T15:18:48.953485Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
e61e2508-40e7-4969-aa97-3d82f6d7c431	2026-09-17 10:48	2026-09-17 10:48	2026-09-17 10:48	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2800	0.2800	0.2900	55.7350	56000.00	0.00	56000.00	2000	52	23707	33196	0.714152307506929	0.199774141712288	0.199774141712288	false	false	false	true
2de65098-fc97-41df-9255-6ff2637d4faa	2026-09-17 10:20	2026-09-17 10:20	2026-09-17 10:20	XLF	XLF260918C00056000	call	56.0000	2026-09-18	0.1500	0.1400	0.1600	55.7150	54315.00	54300.00	15.00	3621	16	4013	29999	0.13377112570419	0.228555364187611	0.228555364187611	false	false	false	true
1f23fb5e-80f7-4507-ad5b-56f3cca4e0e6	2026-09-17 09:31	2026-09-17 09:31	2026-09-17 09:31	XLF	XLF261016C00057000	call	57.0000	2026-10-16	0.6300	0.5800	0.8100	56.1650	151074.00	819.00	150255.00	2398	53	2398	37173	0.0645091867753477	0.144997001449058	0.144997001449058	false	false	false	true
523b0212-8bad-42e9-b14b-89506c5b77b2	2026-09-16 15:41	2026-09-16 15:41	2026-09-16 15:41	XLF	XLF270319P00057000	put	57.0000	2027-03-19	3.0000	3.0000	3.1000	55.6950	120000.00	0.00	120000.00	400	10	559	6372	0.0877275580665411	0.188383589800152	0.188383589800152	false	false	false	true
ed8500a7-cbe6-44df-8b45-8fd55dc72cb8	2026-09-16 15:36	2026-09-16 15:35	2026-09-16 15:35	XLF	XLF261120P00054000	put	54.0000	2026-11-20	0.9400	0.9400	0.9900	55.6950	424598.00	0.00	424598.00	4517	59	4700	21456	0.219052945563013	0.195098947587845	0.195098947587845	false	false	false	true
ca330c93-47f0-4441-a926-8db95267b556	2026-09-16 15:36	2026-09-16 15:35	2026-09-16 15:35	XLF	XLF261023P00056000	put	56.0000	2026-10-23	1.3400	1.3400	1.4300	55.6950	72494.00	0.00	72494.00	541	32	545	94	5.79787234042553	0.18397227791121	0.18397227791121	false	false	false	true
9ffa0095-d32b-40c7-ae0a-5673615522dd	2026-09-16 15:35	2026-09-16 15:35	2026-09-16 15:35	XLF	XLF261009P00055000	put	55.0000	2026-10-09	0.6900	0.6800	0.7800	55.6959	144278.00	0.00	144278.00	2091	41	2102	512	4.10546875	0.190724866843571	0.188539294057472	true	false	false	true
32ab9408-a5b8-472b-8a73-9d720f82f335	2026-09-16 15:22	2026-09-16 15:22	2026-09-16 15:22	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3800	0.3600	0.3800	55.4750	144438.00	144438.00	0.00	3801	43	7131	28490	0.25029835029835	0.209180336575969	0.209180336575969	false	false	false	true
dbb4d974-afc8-4cfb-9471-cfaed4eedeb8	2026-09-16 15:21	2026-09-16 15:21	2026-09-16 15:21	XLF	XLF260916P00055500	put	55.5000	2026-09-16	0.1700	0.1500	0.1800	55.5050	59058.00	58429.00	612.00	3474	77	5750	417	13.78896882494	0.909830230250232	0.909830230250232	false	false	false	true
d149eea5-51da-4e36-847d-4b489dd14819	2026-09-16 15:08	2026-09-16 15:08	2026-09-16 15:08	XLF	XLF270319P00058000	put	58.0000	2027-03-19	3.5000	3.4500	3.5000	55.8000	65450.00	65450.00	0.00	187	8	1589	10859	0.146330232986463	0.189295836511298	0.189130401204834	false	false	false	true
b109612e-6fce-476a-b463-0af849b821ce	2026-09-16 14:30	2026-09-16 14:30	2026-09-16 14:30	XLF	XLF270617P00054000	put	54.0000	2027-06-17	2.0700	1.9900	2.1800	56.3800	1035000.00	196650.00	838350.00	5000	22	5010	15534	0.322518346852066	0.201794877922987	0.201794877922987	true	false	false	true
8e1e50ca-8331-4b11-b68f-34b1a1a559fb	2026-09-16 10:40	2026-09-16 10:39	2026-09-16 10:39	XLF	XLF261016C00058000	call	58.0000	2026-10-16	0.4800	0.4700	0.4800	56.6400	146544.00	146544.00	0.00	3053	13	5254	32880	0.159793187347932	0.145765102372176	0.145765102372176	false	false	false	true
58f51ace-56d3-47f8-adb7-c9382b2107a7	2026-09-16 10:17	2026-09-16 10:17	2026-09-16 10:17	XLF	XLF261016P00056000	put	56.0000	2026-10-16	0.8300	0.8100	0.8400	56.0000	329427.00	216879.00	0.00	3969	27	4717	203334	0.0231982845957882	0.17720199380403	0.17720199380403	false	false	false	true
d1892711-1bdf-4016-9429-a146751cf29d	2026-09-15 15:54	2026-09-15 15:54	2026-09-15 15:54	XLF	XLF260930P00056000	put	56.0000	2026-09-30	0.4900	0.4400	0.4900	56.0000	196000.00	196000.00	0.00	4000	31	5406	2227	2.42748091603053	0.188214558092219	0.188214558092219	false	false	false	true
3671a3b2-cb8f-44a3-ad75-9d7ce0fc04eb	2026-09-15 15:47	2026-09-15 15:47	2026-09-15 15:47	XLF	XLF260918P00056000	put	56.0000	2026-09-18	0.1400	0.1300	0.1500	56.0000	55706.00	55300.00	0.00	3979	48	19282	73869	0.261029660615414	0.218564706066389	0.218564706066389	true	false	false	true
03a72b5e-1ac5-4cb1-b965-56d0b74ea116	2026-09-15 15:39	2026-09-15 15:39	2026-09-15 15:39	XLF	XLF261016C00057000	call	57.0000	2026-10-16	0.9800	0.9700	1.0000	56.8559	74970.00	4116.00	70854.00	765	10	7526	30214	0.249089825908519	0.144354816162262	0.144354816162262	false	false	false	true
8c84b97e-8d9d-4463-baff-932dd27d59c3	2026-09-15 15:35	2026-09-15 15:35	2026-09-15 15:35	XLF	XLF260930P00055000	put	55.0000	2026-09-30	0.2400	0.2200	0.2500	56.8950	57263.00	52752.00	48.00	2386	70	2396	17601	0.136128629055167	0.200648355108092	0.200648355108092	true	false	false	true
19dbdce4-bb7e-495d-9cae-d4cf49d957b0	2026-09-15 10:05	2026-09-15 10:05	2026-09-15 10:05	XLF	XLF260918P00056000	put	56.0000	2026-09-18	0.1200	0.1200	0.1400	56.8450	120000.00	0.00	120000.00	10000	72	11025	73869	0.149250700564513	0.20435177097894	0.20435177097894	false	false	false	true
62180845-aecc-4a7a-a772-9a7db65c4604	2026-09-14 09:46	2026-09-14 09:46	2026-09-14 09:46	XLF	XLF270319P00057000	put	57.0000	2027-03-19	2.2500	2.1900	2.2800	57.0000	93825.00	22500.00	71100.00	417	10	504	6371	0.0791084602103281	0.179957672423702	0.179957672423702	false	false	false	true
1d2fd440-021b-4d29-ba4d-ef3cee1cb11c	2026-09-11 15:16	2026-09-11 15:16	2026-09-11 15:16	XLF	XLF261016C00058000	call	58.0000	2026-10-16	0.7300	0.7300	0.7500	57.2650	51100.00	0.00	51100.00	700	52	902	25362	0.0355650185316615	0.135758544126765	0.135758544126765	false	false	false	true
cfc9495e-5df0-4994-825e-9ecd97865124	2026-09-11 10:24	2026-09-11 10:24	2026-09-11 10:24	XLF	XLF260925P00056000	put	56.0000	2026-09-25	0.3000	0.2700	0.3000	57.0950	85650.00	85650.00	0.00	2855	30	2860	1183	2.41758241758242	0.168966976987588	0.168966976987588	false	false	false	true
829de776-c931-442a-80b6-a3860cf3985d	2026-09-11 09:48	2026-09-11 09:48	2026-09-11 09:48	XLF	XLF260918P00057000	put	57.0000	2026-09-18	0.4300	0.4100	0.4500	57.0000	135149.00	68929.00	2150.00	3143	17	3259	68932	0.0472784773399872	0.156657279094427	0.156657279094427	false	false	false	true
c0b6d83c-43aa-43a1-acba-9d88defdbc41	2026-09-11 09:42	2026-09-11 09:42	2026-09-11 09:42	XLF	XLF260924P00057500	put	57.5000	2026-09-24	0.8400	0.7200	0.9600	57.2501	56363.00	56280.00	83.00	671	25	671	0	0	0.174215454775019	0.171889022915964	true	false	false	true
0bc5629c-ecea-4ef5-ae61-fa6679430ac4	2026-09-10 12:31	2026-09-10 12:31	2026-09-10 12:31	XLF	XLF280121P00055000	put	55.0000	2028-01-21	3.4000	3.3000	3.4000	56.8850	68000.00	68000.00	0.00	200	31	200	723	0.276625172890733	0.221478667015686	0.221478667015686	true	false	false	true
27bd251f-2226-4ebc-acb5-4ce18a40f9ed	2026-09-10 12:30	2026-09-10 12:30	2026-09-10 12:30	XLF	XLF280121P00050000	put	50.0000	2028-01-21	2.0200	1.9700	2.0200	56.8650	65650.00	65650.00	0.00	325	9	325	8249	0.0393987149957571	0.23305632608518	0.23305632608518	true	false	false	true
a4c37845-b07d-4970-9aa3-4a297520f68f	2026-09-08 15:52	2026-09-08 15:52	2026-09-08 15:52	XLF	XLF260911P00057000	put	57.0000	2026-09-11	0.2100	0.2000	0.2100	57.3050	57813.00	57813.00	0.00	2753	22	3000	4327	0.693321007626531	0.168289653470693	0.168289653470693	true	false	false	true
af2089eb-c228-42a7-b0c2-3c79e37086ca	2026-09-08 14:49	2026-09-08 14:48	2026-09-08 14:48	XLF	XLF261016P00058000	put	58.0000	2026-10-16	1.4500	1.3800	1.4500	57.4300	50895.00	50895.00	0.00	351	8	758	8966	0.0845416016060674	0.172061425114329	0.172061425114329	true	false	false	true
f01b2499-8aab-4338-b72d-6a2b063bd30d	2026-09-08 13:19	2026-09-08 13:19	2026-09-08 13:19	XLF	XLF261120P00059000	put	59.0000	2026-11-20	2.3800	2.2800	2.3800	57.5100	112098.00	112098.00	0.00	471	46	471	538	0.87546468401487	0.17571169010488	0.17571169010488	false	false	false	true
d59c0ae1-ae91-46b1-b366-82fa7997b100	2026-09-08 11:21	2026-09-08 11:21	2026-09-08 11:21	XLF	XLF260918P00058000	put	58.0000	2026-09-18	0.8000	0.7800	0.8000	57.5450	325360.00	325360.00	0.00	4067	21	5258	101256	0.0519277869953386	0.152483654699673	0.152483654699673	false	false	false	true
551fce4a-8a13-4294-950b-aff02c25ef14	2026-09-08 10:30	2026-09-08 10:30	2026-09-08 10:30	XLF	XLF260918P00058000	put	58.0000	2026-09-18	0.8000	0.8000	0.8300	57.5200	63120.00	0.00	63120.00	789	38	1128	101256	0.011140080587817	0.148341213145193	0.148341213145193	true	false	false	true
6dbcf6e4-25c5-4950-8e64-1ea5baacf048	2026-09-08 09:42	2026-09-08 09:42	2026-09-08 09:42	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.4600	0.4500	0.4900	57.6308	69000.00	0.00	69000.00	1500	34	2807	59194	0.0474203466567557	0.157842348224818	0.157751580587332	false	false	false	true
19c5ebc8-c219-4958-b2f7-722cfd71faa4	2026-09-04 11:38	2026-09-04 11:38	2026-09-04 11:38	XLF	XLF260930C00054000	call	54.0000	2026-09-30	4.1500	4.0500	4.2000	58.0100	147325.00	146910.00	0.00	355	6	391	462	0.846320346320346	0.162571784623736	0.178252736330169	true	false	false	true
2945e38b-54d0-497b-b4fa-622fb05f102a	2026-09-04 10:16	2026-09-04 10:16	2026-09-04 10:16	XLF	XLF260911P00058500	put	58.5000	2026-09-11	0.7100	0.6600	0.7400	57.9700	57581.00	71.00	57510.00	811	6	866	987	0.877406281661601	0.131262683156668	0.131262683156668	false	false	false	true
8f6828a2-f7db-4341-8f08-fb55e4deac17	2026-09-03 12:48	2026-09-03 12:47	2026-09-03 12:47	XLF	XLF260918C00060000	call	60.0000	2026-09-18	0.1900	0.1800	0.1900	58.4462	73188.00	73188.00	0.00	3852	12	4855	31688	0.153212572582681	0.143493087421996	0.143493087421996	true	false	false	true
02615ee1-e39c-4b71-a73f-82519c85c552	2026-09-03 12:38	2026-09-03 12:38	2026-09-03 12:38	XLF	XLF260918C00058000	call	58.0000	2026-09-18	1.0100	0.9600	1.0100	58.4350	149985.00	149985.00	0.00	1485	60	2171	56975	0.0381044317683194	0.152272642939284	0.152272642939284	true	false	false	true
f7f16839-1d4b-4733-868b-42aa3f655941	2026-09-03 12:29	2026-09-03 12:29	2026-09-03 12:29	XLF	XLF270115C00060000	call	60.0000	2027-01-15	1.6800	1.6600	1.7100	58.4100	84000.00	8400.00	75600.00	500	7	518	60956	0.00849793293523197	0.142070193206738	0.142070193206738	false	false	false	true
ba2e6844-5fcd-4d4f-af5c-8266947cf507	2026-09-03 10:00	2026-09-03 10:00	2026-09-03 10:00	XLF	XLF260925P00058000	put	58.0000	2026-09-25	0.6900	0.6200	0.7500	58.3800	150903.00	147453.00	3450.00	2187	53	2207	616	3.58279220779221	0.162364535911328	0.162364535911328	false	false	false	true
4956f994-9598-4b54-9426-784f210902ae	2026-09-03 09:39	2026-09-03 09:39	2026-09-03 09:39	XLF	XLF260918P00058000	put	58.0000	2026-09-18	0.5200	0.5000	0.5200	58.2850	88036.00	88036.00	0.00	1693	26	1762	98780	0.0178376189512047	0.147263416466698	0.147263416466698	false	false	false	true
2e2974cf-364f-4ca6-a2e8-eba5823da502	2026-09-02 11:38	2026-09-02 11:38	2026-09-02 11:38	XLF	XLF260918P00058000	put	58.0000	2026-09-18	0.7300	0.7100	0.7300	57.8245	209583.00	209583.00	0.00	2871	13	5160	95795	0.0538650242705778	0.142864648747366	0.142864648747366	false	false	false	true
e0b03a63-4193-403d-ac83-1089882a9e6e	2026-09-02 10:43	2026-09-02 10:43	2026-09-02 10:43	XLF	XLF260918P00058000	put	58.0000	2026-09-18	0.5900	0.5900	0.6100	58.0988	111746.00	0.00	111746.00	1894	32	2180	95795	0.0227569288584999	0.141154596413137	0.141154596413137	true	false	false	true
d24d7436-7e03-4c38-bc26-a71f2b65dbc1	2026-09-01 15:40	2026-09-01 15:40	2026-09-01 15:40	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.4100	0.4100	0.4200	57.1724	95530.00	0.00	95530.00	2330	11	8719	55176	0.158021603595766	0.144203676393996	0.144203676393996	true	false	false	true
0879732e-11c0-4101-8a3e-0190b249f85f	2026-09-01 11:29	2026-09-01 11:29	2026-09-01 11:29	XLF	XLF270319P00057000	put	57.0000	2027-03-19	2.2900	2.1300	2.3000	57.5350	68757.00	13110.00	0.00	300	6	337	5947	0.0566672271733647	0.187396670452899	0.187396670452899	false	false	false	true
0ffc2de5-def5-4f5e-b6df-0dd76193ed08	2026-09-01 10:23	2026-09-01 10:23	2026-09-01 10:23	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.7200	0.6900	0.7200	57.9300	347616.00	347616.00	0.00	4828	25	4958	55176	0.0898579092358997	0.140979222457485	0.140979222457485	false	false	false	true
5a99db1b-5a62-43b5-bb13-fdd6b95c4758	2026-08-31 10:12	2026-08-31 10:12	2026-08-31 10:12	XLF	XLF260918C00058000	call	58.0000	2026-09-18	0.6800	0.6800	0.7000	57.8050	136000.00	0.00	136000.00	2000	50	2020	55762	0.0362253864639001	0.140854003756408	0.140854003756408	false	false	false	true
99324bf5-c6d2-424f-a025-121082e13624	2026-08-28 15:30	2026-08-28 15:29	2026-08-28 15:29	XLF	XLF261002C00060500	call	60.5000	2026-10-02	0.2400	0.2200	0.2400	58.1750	55488.00	55488.00	0.00	2312	7	5411	13932	0.388386448463968	0.128567025414429	0.128567025414429	true	false	false	true
faf62cae-5b88-40b6-9d0f-cf18b10b1346	2026-08-28 13:10	2026-08-28 13:10	2026-08-28 13:10	XLF	XLF271217C00052000	call	52.0000	2027-12-17	10.2000	10.2000	10.3500	58.0600	67320.00	0.00	67320.00	66	14	145	357	0.406162464985994	0.183276668850121	0.183276668850121	false	false	false	true
5d31893b-02a6-492b-a808-2a4d45910034	2026-08-28 12:02	2026-08-28 12:02	2026-08-28 12:02	XLF	XLF260918P00058000	put	58.0000	2026-09-18	0.5600	0.5500	0.5900	58.0000	106680.00	106624.00	56.00	1905	5	2391	96445	0.0247913318471668	0.136092889337262	0.13646520077109	false	false	false	true
da0beb14-c1ae-484b-904b-3414bc775de8	2026-08-27 11:18	2026-08-27 11:18	2026-08-27 11:18	XLF	XLF260930P00055000	put	55.0000	2026-09-30	0.2200	0.2200	0.2300	58.0300	64658.00	0.00	64658.00	2939	29	3014	1061	2.84071630537229	0.17524236043478	0.17524236043478	false	false	false	true
b5444daf-efaf-4880-b434-8af6479c818c	2026-08-26 12:52	2026-08-26 12:51	2026-08-26 12:51	XLF	XLF261016C00060000	call	60.0000	2026-10-16	0.6300	0.6200	0.6300	58.1999	166320.00	166320.00	0.00	2640	45	2870	40208	0.0713788300835655	0.140178628807588	0.140178628807588	false	false	false	true