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 = XLI260918P00175000×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

9e8793e7-4780-4f7d-9bd9-74ff7073354a	2026-08-18 11:17	2026-08-18 11:17	2026-08-18 11:17	XLI	XLI260918P00175000	put	175.0000	2026-09-18	0.9400	0.8200	0.9400	184.1800	34686.00	34686.00	0.00	369	42	372	3931	0.0946324090562198	0.196464893686987	0.196464893686987	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	30796170295.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T15:23:23.944279Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b27c4963-5fe2-4c4b-81e9-6ecbec70db49	2026-08-18 14:52	2026-08-18 14:52	2026-08-18 14:52	XLI	XLI260918P00175000	put	175.0000	2026-09-18	0.9900	0.9300	0.9900	183.7400	15444.00	15444.00	0.00	156	30	539	3931	0.137115237852964	0.194683713030896	0.194683713030896	false	false	false	true
39cc6e6d-2a38-4ff3-bfed-b4895d01403c	2026-08-20 11:22	2026-08-20 11:22	2026-08-20 11:22	XLI	XLI260918P00175000	put	175.0000	2026-09-18	1.2200	1.1300	1.2300	181.5700	12566.00	12322.00	244.00	103	28	172	4486	0.0383415069103879	0.187162489805252	0.187162489805252	true	false	false	true
691d1a34-aeb1-47a1-b46c-4779e46176e7	2026-08-20 11:31	2026-08-20 11:31	2026-08-20 11:31	XLI	XLI260918P00175000	put	175.0000	2026-09-18	1.2300	1.1600	1.2400	181.6100	34071.00	33948.00	123.00	277	33	463	4486	0.103209986625056	0.188404641810106	0.188404641810106	true	false	false	true
c5dcb81a-9bc3-4e9b-94b4-6ee207dff3c5	2026-08-20 13:08	2026-08-20 13:08	2026-08-20 13:08	XLI	XLI260918P00175000	put	175.0000	2026-09-18	1.4700	1.3800	1.4700	180.3110	18081.00	18081.00	0.00	123	23	769	4486	0.17142220240749	0.184191313199969	0.184191313199969	false	false	false	true
6ecf2583-c5ff-455e-ad4a-286fd0a53713	2026-08-20 14:06	2026-08-20 14:06	2026-08-20 14:06	XLI	XLI260918P00175000	put	175.0000	2026-09-18	1.5800	1.5800	1.6200	179.9300	10902.00	0.00	10902.00	69	10	1104	4486	0.246098974587606	0.18481421917917	0.18481421917917	true	false	false	true
96010497-d36f-4733-8376-09d46a8a22e2	2026-08-20 14:16	2026-08-20 14:16	2026-08-20 14:16	XLI	XLI260918P00175000	put	175.0000	2026-09-18	1.6600	1.6100	1.6600	179.7100	21414.00	21414.00	0.00	129	37	1328	4486	0.296032099866251	0.185995391699108	0.185995391699108	false	false	false	true
16db9ee2-b4fd-4864-8551-c4bb84808894	2026-09-08 13:38	2026-09-08 13:38	2026-09-08 13:38	XLI	XLI260918P00175000	put	175.0000	2026-09-18	2.0400	2.0400	2.1500	175.1450	33048.00	0.00	33048.00	162	18	208	4556	0.0456540825285338	0.190360143613824	0.190360143613824	false	false	false	true