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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active: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	expirydate

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
a23a2bff-2c51-4c36-994f-bca18fbe7019	2026-08-19 15:37	2026-08-19 15:37	2026-08-19 15:37	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.1600	4.1500	4.3500	63.4900	208182.00	0.00	208182.00	501	34	4048	58209	0.0695425106083252	0.255619397801748	0.24445610243858	true	false	false	true
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
1e1da5e6-51d6-4066-9a19-f10056006ad0	2026-09-18 11:59	2026-09-18 11:59	2026-09-18 11:59	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.6700	4.5500	4.7000	64.6850	18688.00	18688.00	0.00	40	5	281	54198	0.0051846931621093	1.66486797085075	1.66486797085075	false	false	false	true
ef47f3a1-87ac-4056-9b20-139a6e26c308	2026-09-18 12:52	2026-09-18 12:52	2026-09-18 12:52	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.4100	4.3000	4.4500	64.3850	55110.00	55110.00	0.00	125	17	427	54198	0.00787851950256467	2.33833848121036	1.79127374611761	false	false	false	true