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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 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 = XLF×

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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	55126892241.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
5dfaca84-7f50-4872-8c4d-e21585c74bf6	2026-09-15 15:55	2026-09-15 15:55	2026-09-15 15:55	XLF	XLF260930P00056000	put	56.0000	2026-09-30	0.4900	0.4200	0.4900	56.0000	282484.00	282484.00	0.00	5771	12	15178	2227	6.81544678940278	0.1874160649372	0.1874160649372	false	false	false	true
91bf766e-4865-4fac-a5a7-bd4e60fc138d	2026-09-15 15:55	2026-09-15 15:55	2026-09-15 15:55	XLF	XLF260930P00056000	put	56.0000	2026-09-30	0.4900	0.4200	0.4900	56.0000	196047.00	195999.00	48.00	4001	27	9407	2227	4.2240682532555	0.189410677242924	0.187019518422767	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
8652e299-3340-4df8-ba60-0e15e8585e41	2026-09-11 09:57	2026-09-11 09:57	2026-09-11 09:57	XLF	XLF270319P00058000	put	58.0000	2027-03-19	2.8000	2.7900	2.9100	57.0000	64917.00	0.00	64917.00	232	22	260	11061	0.023506012114637	0.18472340385218	0.184109339374123	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
1f71c380-fa76-4a8e-a991-77afe40f612a	2026-09-08 12:30	2026-09-08 12:30	2026-09-08 12:30	XLF	XLF281215C00070000	call	70.0000	2028-12-15	3.2500	3.1000	3.2500	57.5523	56177.00	56177.00	0.00	173	5	199	2198	0.0905368516833485	0.15691719457112	0.157218563154456	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
84fcd7bb-4e53-4908-bef9-dce715dc9f0a	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.4600	0.4900	57.6601	77669.00	5076.00	72593.00	1671	62	4478	59194	0.0756495590769335	0.157087487823271	0.154409137754973	false	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
a5f17a36-af9a-4530-8f89-41a1f95db5b4	2026-09-03 09:38	2026-09-03 09:38	2026-09-03 09:38	XLF	XLF260930P00061000	put	61.0000	2026-09-30	2.8500	2.6300	2.8600	58.4150	62983.00	62699.00	284.00	221	28	221	59	3.74576271186441	0.201608448146142	0.20363381942437	true	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
d4606e22-4776-4963-8bb6-67980e727f1e	2026-08-28 15:31	2026-08-28 15:29	2026-08-28 15:31	XLF	XLF261002C00060500	call	60.5000	2026-10-02	0.2400	0.0000	0.0000	58.1350	560880.00	104880.00	384.00	23370	34	29347	13932	2.1064455928797	0	0	true	true	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
0daeb7d3-bb27-48ae-865d-5841ddae9df4	2026-08-26 12:44	2026-08-26 12:44	2026-08-26 12:44	XLF	XLF260918P00058000	put	58.0000	2026-09-18	0.6700	0.6500	0.6700	58.2000	97954.00	97686.00	0.00	1462	14	11613	92553	0.125474052704937	0.14251919207587	0.14251919207587	false	false	false	true
1508bd3c-00af-4b69-ba92-0d123d9bc687	2026-08-26 11:34	2026-08-26 11:34	2026-08-26 11:34	XLF	XLF270319P00058000	put	58.0000	2027-03-19	2.5100	2.5000	2.5500	58.1650	75300.00	251.00	75049.00	300	6	309	12965	0.0238333976089472	0.185659780712747	0.185659780712747	false	false	false	true
43fd7617-bb5f-4e43-b32d-fbffb7ee77df	2026-08-25 14:02	2026-08-25 14:01	2026-08-25 14:01	XLF	XLF271217C00061000	call	61.0000	2027-12-17	4.7000	4.5500	4.7000	58.0000	66270.00	66270.00	0.00	141	8	171	1369	0.12490869247626	0.167244016519039	0.167244016519039	false	false	false	true
463ff99d-97da-44d9-b698-47fd7dec3f29	2026-08-25 12:25	2026-08-25 12:25	2026-08-25 12:25	XLF	XLF260925P00057500	put	57.5000	2026-09-25	0.6800	0.6700	0.7200	58.1350	105060.00	1088.00	103972.00	1545	54	1548	71	21.8028169014085	0.154833044278913	0.154833044278913	false	false	false	true
fc79c14d-829d-4d0b-95fc-7e9ac3e565d5	2026-08-25 11:35	2026-08-25 11:35	2026-08-25 11:35	XLF	XLF280121C00055000	call	55.0000	2028-01-21	8.2500	8.0000	8.4000	58.0700	67648.00	67648.00	0.00	82	5	88	4890	0.0179959100204499	0.171051369791155	0.171051369791155	false	false	false	true
6be21723-0378-46d4-856f-1d0f4017c96f	2026-08-25 11:19	2026-08-25 11:19	2026-08-25 11:19	XLF	XLF270617C00058000	call	58.0000	2027-06-17	4.6000	4.4500	4.6000	58.1700	51980.00	51980.00	0.00	113	15	113	8185	0.0138057422113622	0.16995666067547	0.16995666067547	false	false	false	true