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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = XLF261016P00053000×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

75c14397-53b0-49a9-ad9a-68692feaf319	2026-09-29 12:40	2026-09-29 12:40	2026-09-29 12:40	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.4900	0.4800	0.4900	53.8050	24500.00	24500.00	0.00	500	24	5152	42304	0.12178517397882	0.189063682943833	0.189063682943833	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	51971432488.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T16:44:24.816424Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
d7d00f7d-ee84-49bf-9df5-ae429a8a3c92	2026-09-29 11:03	2026-09-29 11:03	2026-09-29 11:03	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.4400	0.4400	0.4500	53.9150	12936.00	0.00	12936.00	294	9	605	42304	0.0143012481089259	0.185532789049273	0.185532789049273	false	false	false	true
aed79564-b204-4cd9-9d99-64752368d784	2026-09-28 15:17	2026-09-28 15:17	2026-09-28 15:17	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3800	0.3600	0.3900	54.1950	14516.00	14478.00	0.00	382	8	489	32465	0.0150623748652395	0.185929141080174	0.185929141080174	false	false	false	true
74e5017e-a1b9-473a-9cf1-c1a8ce33345a	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3600	0.3600	0.4100	54.0000	17280.00	0.00	17280.00	480	18	1086	31683	0.0342770570968658	0.182240663779112	0.182240663779112	true	false	false	true
771f95b1-75d6-4456-8a70-2f802cb4f51c	2026-09-24 10:33	2026-09-24 10:33	2026-09-24 10:33	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3600	0.3400	0.3600	54.4650	13068.00	13068.00	0.00	363	10	450	31683	0.0142032004545024	0.181076163385499	0.181076163385499	false	false	false	true
55c43f2c-11c8-4a23-96cf-ee8bcafd5836	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3000	0.2900	0.3000	54.0000	22500.00	22500.00	0.00	750	19	9320	33080	0.28174123337364	0.177331868555782	0.177331868555782	true	false	false	true
eca1148d-6871-449f-b386-bc5b4f9e13bc	2026-09-22 15:58	2026-09-22 15:58	2026-09-22 15:58	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3000	0.2900	0.3000	54.0000	22500.00	22500.00	0.00	750	8	8570	33080	0.25906892382104	0.17745596041011	0.17745596041011	true	false	false	true
729d8888-0d4b-4747-8bcc-a649f47c398e	2026-09-22 15:58	2026-09-22 15:58	2026-09-22 15:58	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3000	0.2800	0.3000	54.8000	22500.00	22500.00	0.00	750	8	7820	33080	0.23639661426844	0.177714371685996	0.177714371685996	true	false	false	true
282c120b-621e-4017-8567-7f36fec56495	2026-09-22 15:56	2026-09-22 15:56	2026-09-22 15:56	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3000	0.2900	0.3000	54.8150	22500.00	22500.00	0.00	750	24	7070	33080	0.21372430471584	0.178488689739037	0.178488689739037	true	false	false	true
68a43275-47df-4065-b323-9b61ba2b6c96	2026-09-22 15:56	2026-09-22 15:56	2026-09-22 15:56	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.3000	0.2900	0.3000	54.8150	22050.00	22050.00	0.00	735	8	6315	33080	0.19090084643289	0.178488689739037	0.178488689739037	true	false	false	true
27ef32b7-933c-4ae3-bfca-695e0a826e9e	2026-09-22 15:53	2026-09-22 15:53	2026-09-22 15:53	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2900	0.2800	0.2900	54.0000	21750.00	21750.00	0.00	750	14	5565	33080	0.16822853688029	0.178036434779847	0.178036434779847	true	false	false	true
120e8a73-984b-4887-9087-b022f63f4552	2026-09-22 15:49	2026-09-22 15:49	2026-09-22 15:49	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2800	0.2700	0.2800	54.9000	15456.00	15456.00	0.00	552	6	4815	33080	0.14555622732769	0.177778042418407	0.177778042418407	true	false	false	true
f542f480-2d22-4f2a-837b-b1f0a2b41795	2026-09-22 15:44	2026-09-22 15:44	2026-09-22 15:44	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2800	0.2700	0.2800	54.9050	15708.00	15708.00	0.00	561	8	4065	33080	0.122883917775091	0.178030161642526	0.178030161642526	true	false	false	true
70b1a646-facb-49ff-9808-1336babd8b6e	2026-09-22 15:36	2026-09-22 15:36	2026-09-22 15:36	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2800	0.2700	0.2800	54.9650	20748.00	20748.00	0.00	741	22	3296	33080	0.0996372430471584	0.181044610811969	0.181044610811969	true	false	false	true
b4898c02-29a3-401f-a450-81c5187cac5c	2026-09-22 15:28	2026-09-22 15:28	2026-09-22 15:28	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2900	0.2800	0.2900	54.0000	21750.00	21750.00	0.00	750	5	2555	33080	0.0772370012091898	0.181087219664153	0.181087219664153	true	false	false	true
c44e1576-95cd-4753-a3cc-e7346e87ca0a	2026-09-17 11:42	2026-09-17 11:42	2026-09-17 11:42	XLF	XLF261016P00053000	put	53.0000	2026-10-16	0.2600	0.2500	0.2800	55.9550	53274.00	0.00	50206.00	2049	16	25761	33196	0.77602723219665	0.203655454732932	0.203655454732932	false	false	false	true
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
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	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