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

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

50ab3954-5128-4523-a640-1dcb4e617de1	2026-09-21 10:02	2026-09-21 10:02	2026-09-21 10:02	XLE	XLE270115P00060000	put	60.0000	2027-01-15	2.2200	2.1400	2.2300	62.9050	11321.00	11321.00	0.00	51	11	56	26981	0.00207553463548423	0.276309964603398	0.276309964603398	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	41312140321.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T14:02:45.816631Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
38b486e3-e1ff-42ee-bb18-29c538f1cb7b	2026-09-18 15:06	2026-09-18 15:06	2026-09-18 15:06	XLE	XLE270115P00060000	put	60.0000	2027-01-15	1.9700	1.9300	1.9700	64.3300	328990.00	328990.00	0.00	1670	58	2012	26751	0.0752121416021831	0.287205971095054	0.287205971095054	false	false	false	true	false
17d09547-b8a4-4882-ae3f-7c2bfc77d702	2026-09-16 10:28	2026-09-16 10:28	2026-09-16 10:28	XLE	XLE270115P00060000	put	60.0000	2027-01-15	2.0100	1.9000	2.0400	64.0000	649834.00	649633.00	201.00	3233	46	3241	26658	0.121577012529072	0.289436555664029	0.29001735298211	true	false	false	true	false
f736cc5b-2072-4fa9-836c-dec15f98e511	2026-09-11 13:07	2026-09-11 13:07	2026-09-11 13:07	XLE	XLE270115P00060000	put	60.0000	2027-01-15	1.7800	1.7600	1.7900	65.0850	15130.00	15130.00	0.00	85	7	15908	6207	2.56291284034155	0.280353075315297	0.280353075315297	false	false	false	true	false
88be0997-ad8f-4efe-8a2b-435b00d9447a	2026-09-11 09:43	2026-09-11 09:42	2026-09-11 09:42	XLE	XLE270115P00060000	put	60.0000	2027-01-15	1.7800	1.7800	1.8500	65.0500	431828.00	0.00	431828.00	2426	55	2426	6207	0.390849041404865	0.279419043388984	0.279626785564442	false	false	false	true	false
ae79c373-1764-49fe-9f3a-f7debd2c65ab	2026-08-17 13:55	2026-08-17 13:55	2026-08-17 13:55	XLE	XLE270115P00060000	put	60.0000	2027-01-15	2.6200	2.6200	2.7200	62.0000	31964.00	0.00	31964.00	122	14	500	6033	0.0828775070445881	0.265237463881253	0.265237463881253	false	false	false	true	false
7bc67a03-198e-4909-bec9-43831d1e6035	2026-08-17 13:18	2026-08-17 13:17	2026-08-17 13:17	XLE	XLE270115P00060000	put	60.0000	2027-01-15	2.6500	2.6500	2.7100	62.4770	12455.00	0.00	12455.00	47	7	73	6033	0.0121001160285099	0.266521649884664	0.266521649884664	false	false	false	true	false