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:alert_rule = RepeatedHitsDescendingFill×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	strike

54a2e7b5-8ed0-42fe-9c0e-d2e210d58a8d	2026-09-28 10:40	2026-09-28 10:40	2026-09-28 10:40	XLF	XLF261007P00054000	put	54.0000	2026-10-07	0.3700	0.2800	0.3700	54.4750	17832.00	17796.00	36.00	482	33	507	164	3.09146341463415	0.176516131862324	0.175957313999312	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	52165249909.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T14:42:23.543990Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
30d7e9a3-d0c4-4efd-8e53-b27ba29c2ce5	2026-09-28 10:33	2026-09-28 10:33	2026-09-28 10:33	XLF	XLF270115C00054000	call	54.0000	2027-01-15	2.6700	2.5000	2.9100	54.5150	68546.00	38874.00	13177.00	257	32	257	17724	0.0145001128413451	0.174770064406417	0.16485534562894	true	false
b89d1849-2f00-4734-a2b4-ca1c770adf84	2026-09-28 10:28	2026-09-28 10:28	2026-09-28 10:28	XLF	XLF261007P00055000	put	55.0000	2026-10-07	0.8100	0.7000	0.8100	54.0000	11538.00	11298.00	160.00	143	27	143	10	14.3	0.175169907771401	0.173373194138663	true	false	false
2f2c43f2-fb85-473f-8c63-ab99abf066e1	2026-09-24 10:05	2026-09-24 10:05	2026-09-24 10:05	XLF	XLF270617C00062000	call	62.0000	2027-06-17	1.1200	1.1200	1.1300	54.6200	13012.00	0.00	10752.00	116	6	116	1436	0.0807799442896936	0.159473214480366	0.158820068857718	false	false
5a655f12-da0b-4e06-b071-b514b9435005	2026-09-23 15:37	2026-09-23 15:37	2026-09-23 15:37	XLF	XLF270115P00055000	put	55.0000	2027-01-15	1.9600	1.9500	1.9700	54.6350	39602.00	39602.00	0.00	202	6	1313	44736	0.0293499642346209	0.176841848810042	0.176015295508076	false	false
690baa0e-d4e5-4821-a533-7af6ac3ef74f	2026-09-23 13:13	2026-09-23 13:13	2026-09-23 13:13	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.2400	1.2400	1.3200	54.0000	310066.00	0.00	310066.00	2500	44	21379	20012	1.06830901459125	1.05103768223835	1.05103768223835	false	false
ff863131-f700-4f28-ae9f-53f1b919d6bb	2026-09-23 11:23	2026-09-23 11:23	2026-09-23 11:23	XLF	XLF261016C00056000	call	56.0000	2026-10-16	0.4500	0.4200	0.4600	54.8100	11255.00	11255.00	0.00	250	7	584	18378	0.0317771248231581	0.160264669218188	0.158244377385567	false	false
82d7034d-3694-4b00-aec3-34da5ae98455	2026-09-23 10:28	2026-09-23 10:28	2026-09-23 10:28	XLF	XLF260923P00056000	put	56.0000	2026-09-23	1.0400	1.0400	1.0500	54.9350	35794.00	1890.00	33904.00	344	12	3745	20012	0.187137717369578	0.263442926253347	0.263442926253347	false	false
0e7a0c92-39f0-4268-8b9c-0f9fd954acf3	2026-09-23 09:47	2026-09-23 09:46	2026-09-23 09:46	XLF	XLF260924P00055000	put	55.0000	2026-09-24	0.3600	0.3600	0.3700	54.0000	10879.00	1591.00	9288.00	301	5	301	532	0.565789473684211	0.254978611657703	0.247418214139445	false	false
fae320b1-b2a7-41dd-84a3-020d31294b13	2026-09-22 11:53	2026-09-22 11:53	2026-09-22 11:53	XLF	XLF260930P00056000	put	56.0000	2026-09-30	1.3600	1.3600	1.5100	54.6667	340782.00	0.00	340782.00	2500	53	2506	15490	0.161781794706262	0.150137881098721	0.145490491222235	false	false
971bdb88-44c6-4e64-ad78-5f7c35e28a63	2026-09-22 11:29	2026-09-22 11:29	2026-09-22 11:29	XLF	XLF270115C00055000	call	55.0000	2027-01-15	2.1300	2.1300	2.2100	54.0000	11930.00	0.00	11930.00	56	6	210	83795	0.00250611611671341	0.162179951743172	0.160533678220491	false	false
ec956393-5585-4fce-b1bb-ae3a63d77abd	2026-09-22 09:58	2026-09-22 09:58	2026-09-22 09:58	XLF	XLF270617C00075000	call	75.0000	2027-06-17	0.1800	0.1700	0.2400	55.3850	122961.00	117198.00	5763.00	6850	47	8738	1478	5.91204330175913	0.184893011111594	0.182872843382516	false	false
61500978-543d-4226-8586-e58ec4a1d8d7	2026-09-22 09:50	2026-09-22 09:49	2026-09-22 09:49	XLF	XLF260923P00056000	put	56.0000	2026-09-23	0.6300	0.5500	0.6600	55.4893	50190.00	39054.00	11136.00	793	28	9610	715	13.4405594405594	0.281565065786263	0.271113942465106	false	false
6e9e7336-eb77-4e94-84da-5f03e56ff4d8	2026-09-21 13:18	2026-09-21 13:18	2026-09-21 13:18	XLF	XLF261030P00056000	put	56.0000	2026-10-30	1.0100	1.0100	1.0400	56.0000	14268.00	0.00	14268.00	141	9	259	257	1.00778210116732	0.157784198320163	0.156405616860232	false	false
b93dca97-08b7-4b20-b96c-16d902b18e36	2026-09-18 10:17	2026-09-18 10:17	2026-09-18 10:17	XLF	XLF261016P00054000	put	54.0000	2026-10-16	0.3800	0.3800	0.4200	55.7450	95300.00	0.00	95300.00	2500	11	2616	52327	0.0499933112924494	0.179830047620413	0.177713044404277	false	false
b03410f2-c90a-4570-b249-cf3ce7f69a45	2026-09-17 10:26	2026-09-17 10:26	2026-09-17 10:26	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2800	0.2800	0.3000	55.7650	112300.00	0.00	103629.00	4000	63	21705	33196	0.65384383660682	0.203605682516106	0.201039534790288	false	false
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
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
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
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
39f6fa03-12a1-4902-a86c-40a16567d824	2026-08-18 12:03	2026-08-18 12:03	2026-08-18 12:03	XLF	XLF270115C00053000	call	53.0000	2027-01-15	6.2000	6.0500	6.3500	57.7700	489712.00	476050.00	13662.00	790	54	790	7575	0.104290429042904	0.173177518324314	0.172082680703298	true	false
cf68064e-5b6c-43d9-b5d1-94480dcd73cb	2026-08-17 10:42	2026-08-17 10:42	2026-08-17 10:42	XLF	XLF260826P00058000	put	58.0000	2026-08-26	0.4200	0.3400	0.4300	57.9403	17626.00	17626.00	0.00	419	8	419	408	1.02696078431373	0.117702150103584	0.117702150103584	true	false