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:option_symbol = XLI261120P00170000×ticker = XLI×sorted by created_at ↑×

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

5d05580f-20fc-4a99-8e2d-0efdee5b458d	2026-09-09 12:25	2026-09-09 12:25	2026-09-09 12:25	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.6000	4.5500	4.7500	172.1600	29440.00	1380.00	28060.00	64	8	155	55377	0.00279899597305741	0.204843728206309	0.204843728206309	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	31280067977.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T16:45:40.179334Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e9a47069-81c8-46ac-b1cb-530dfcf6a23a	2026-09-11 13:38	2026-09-11 13:38	2026-09-11 13:38	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.2000	4.2000	4.2500	172.6450	21000.00	0.00	21000.00	50	10	60	55407	0.00108289566300287	0.200145647447189	0.200145647447189	true	false	false	true
790a4aac-b5cb-418c-b523-8fff9f958d80	2026-09-17 10:28	2026-09-17 10:28	2026-09-17 10:28	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.4000	5.2500	5.4000	169.5399	141480.00	141480.00	0.00	262	46	273	55368	0.00493064586042479	0.204487219783487	0.204487219783487	false	false	false	true
ba4b22b0-a823-4f26-9dcd-7d6c69db5eb4	2026-09-18 13:38	2026-09-18 13:38	2026-09-18 13:38	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.5500	5.5000	5.5500	168.8599	43845.00	43845.00	0.00	79	25	88	55346	0.00158999747045857	0.199550308320612	0.199550308320612	false	false	false	true
8a6d1ecf-0f97-4470-b824-2d4e7bac17d7	2026-09-18 14:37	2026-09-18 14:37	2026-09-18 14:37	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.4000	5.3000	5.4000	169.2800	53458.00	53458.00	0.00	99	30	195	55346	0.0035232898493116	0.201331286585907	0.201331286585907	false	false	false	true
e9d13553-5550-4d9e-8a6c-524c3de3ce6d	2026-09-18 15:33	2026-09-18 15:33	2026-09-18 15:33	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.2100	5.1500	5.4000	169.4550	11722500.00	0.00	11722500.00	22500	2	22695	55346	0.41005673400065	0.197462360913692	0.197462360913692	false	true	true	false
d5a6ab64-dcaa-4751-93b7-eac8ba51d775	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.8500	4.7500	4.8500	169.8101	22310.00	22310.00	0.00	46	10	94	46187	0.0020352047112824	0.195305061391158	0.195305061391158	true	false	false	true
418bea62-3a8e-42e3-9069-480b77e1d8cc	2026-09-22 14:12	2026-09-22 14:12	2026-09-22 14:12	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.8500	4.7500	4.8500	170.0550	94090.00	94090.00	0.00	194	40	461	46187	0.00998116353086366	0.199403589605202	0.199403589605202	false	false	false	true
95452d34-9bba-457b-b35b-15c813b0e0f2	2026-09-22 15:46	2026-09-22 15:46	2026-09-22 15:46	XLI	XLI261120P00170000	put	170.0000	2026-11-20	4.7500	4.7000	4.8000	170.2700	47025.00	10450.00	30875.00	99	18	577	46187	0.0124926927490419	0.199255040193396	0.199255040193396	false	false	false	true
458321f5-0ac8-4aaf-96b1-886d6d58c7fe	2026-09-24 12:27	2026-09-24 12:27	2026-09-24 12:27	XLI	XLI261120P00170000	put	170.0000	2026-11-20	5.0500	5.0000	5.1500	169.2600	26765.00	0.00	26765.00	53	5	55	43922	0.00125221984426939	0.195894886240414	0.195894886240414	true	false	false	true