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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×ticker = XLP×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

0f657011-44a4-4fda-81d9-cbbf75d3a916	2026-08-18 09:39	2026-08-18 09:38	2026-08-18 09:38	XLP	XLP260904C00085000	call	85.0000	2026-09-04	1.3700	1.3400	1.4000	85.0000	21647.00	18222.00	3425.00	158	8	518	580	0.893103448275862	0.159676048631754	0.158297314237467	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	14406195892.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T13:50:18.630361Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
6992175d-e300-4038-ac97-8cc10f4462e7	2026-09-01 15:56	2026-09-01 15:56	2026-09-01 15:56	XLP	XLP260918C00078000	call	78.0000	2026-09-18	7.4700	7.3000	7.5000	85.1850	35090.00	24000.00	8840.00	47	7	47	264	0.178030303030303	0.291187359090178	0.291187359090178	false	false	false	true
b4db8f88-8c1f-49e4-8ec2-d571fd48b2aa	2026-09-08 10:17	2026-09-08 10:17	2026-09-08 10:17	XLP	XLP270617C00089000	call	89.0000	2027-06-17	2.9900	2.7400	2.9900	84.0300	11360.00	11062.00	298.00	38	12	38	92	0.41304347826087	0.133541094214864	0.133541094214864	false	false	false	true
bed6414e-90ca-423c-b350-eb1392261af9	2026-09-09 15:45	2026-09-09 15:45	2026-09-09 15:45	XLP	XLP261016C00080000	call	80.0000	2026-10-16	3.5900	3.5500	3.6000	83.0500	15795.00	10440.00	5355.00	44	6	44	208	0.211538461538462	0.122247192784379	0.117006791437074	false	false	false	true