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:alert_rule = RepeatedHits×option_symbol = XLE260918C00060000×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

f18bcdb0-ad4b-4d38-994f-ac41a94d6cd2	2026-08-18 13:02	2026-08-18 13:02	2026-08-18 13:02	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.2000	4.1000	4.3000	63.4600	12600.00	2100.00	8400.00	30	11	192	58448	0.00328497125650151	0.253785108500431	0.253785108500431	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	42266645050.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T17:20:11.917066Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8bcd4e8f-a163-4ae0-a266-2247bcf98b8e	2026-08-31 10:16	2026-08-31 10:16	2026-08-31 10:16	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.1200	4.1000	4.3000	63.7600	20204.00	0.00	20204.00	49	6	105	58696	0.00178887828812866	0.251477251115198	0.261521571937397	false	false	false	true
b19879df-5c21-4d32-9db9-a48b23073358	2026-09-01 15:06	2026-09-01 15:05	2026-09-01 15:05	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.9500	4.9000	5.0000	64.6550	49500.00	14850.00	7920.00	100	16	759	58572	0.0129584101618521	0.281530215614997	0.281530215614997	false	false	false	true
c2dfde5a-c518-4783-a226-9ca1d8ce1d59	2026-09-01 15:22	2026-09-01 15:22	2026-09-01 15:22	XLE	XLE260918C00060000	call	60.0000	2026-09-18	5.0000	4.9000	5.0000	64.7050	13500.00	13500.00	0.00	27	10	886	58572	0.0151266816909103	0.283561553354897	0.283561553354897	true	false	false	true
d46245cf-7dad-49a1-94a6-7c6584504bc0	2026-09-14 10:14	2026-09-14 10:14	2026-09-14 10:14	XLE	XLE260918C00060000	call	60.0000	2026-09-18	5.8500	5.8500	6.0000	65.0000	12870.00	0.00	12870.00	22	7	81	55290	0.00146500271296799	0.572007909191029	0.572007909191029	false	false	false	true