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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = XOP260918C00200000×source = uw_flow_alerts×

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

77469796-ec02-4de9-993c-fb5eb73d4f08	2026-08-27 10:45	2026-08-27 10:45	2026-08-27 10:45	XOP	XOP260918C00200000	call	200.0000	2026-09-18	0.8600	0.8600	1.1300	182.4600	23392.00	0.00	23392.00	272	32	277	4622	0.0599307659022068	0.31049374579829	0.31049374579829	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4170340047.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-27T14:49:52.356548Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8153c7cb-cfdb-467e-a6c5-46956741d156	2026-08-17 14:08	2026-08-17 14:08	2026-08-17 14:08	XOP	XOP260918C00200000	call	200.0000	2026-09-18	1.6300	1.4600	1.6300	182.0000	195437.00	195437.00	0.00	1199	24	1525	5369	0.284037995902403	0.31666898106683	0.31666898106683	false	false	false	true
8046647d-e56d-479f-aa54-f734a72832e5	2026-08-17 11:22	2026-08-17 11:22	2026-08-17 11:22	XOP	XOP260918C00200000	call	200.0000	2026-09-18	1.3800	1.2300	1.3800	180.8750	42642.00	42642.00	0.00	309	40	313	5369	0.058297634568821	0.316476551482336	0.316476551482336	false	false	false	true