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 = XLE270617C00070000×ticker = XLE×

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

5dc5c661-16ce-417b-8346-6bb0738a998f	2026-09-25 11:05	2026-09-25 11:05	2026-09-25 11:05	XLE	XLE270617C00070000	call	70.0000	2027-06-17	3.0000	2.9800	3.0500	62.0750	20400.00	6000.00	14400.00	68	10	94	3385	0.0277695716395864	0.243745580611454	0.243745580611454	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	40486178216.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T15:08:32.454345Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
5507fa51-07b5-4d7d-8569-8d3418b93b37	2026-09-18 14:45	2026-09-18 14:45	2026-09-18 14:45	XLE	XLE270617C00070000	call	70.0000	2027-06-17	3.8900	3.8500	3.9500	64.3650	38880.00	0.00	38880.00	100	5	101	3371	0.0299614357757342	0.236543318982524	0.23836743687841	false	false	false	true
1bc3d540-72ff-4d9d-a299-5276488b1f4c	2026-09-15 11:17	2026-09-15 11:17	2026-09-15 11:17	XLE	XLE270617C00070000	call	70.0000	2027-06-17	4.4500	4.4000	4.4500	65.5100	44500.00	44500.00	0.00	100	8	263	3262	0.0806253832004905	0.238417654523485	0.238417654523485	false	false	false	true
01d80cf4-7e73-4897-b62b-10e2983f3937	2026-09-10 09:35	2026-09-10 09:35	2026-09-10 09:35	XLE	XLE270617C00070000	call	70.0000	2027-06-17	4.4000	4.4000	4.5000	65.5805	11003.00	0.00	11003.00	25	5	1125	3142	0.358052196053469	0.234157250182346	0.2337200733937	false	false	false	true
da1690ec-b939-495a-9ee7-59616439e844	2026-08-31 12:12	2026-08-31 12:12	2026-08-31 12:12	XLE	XLE270617C00070000	call	70.0000	2027-06-17	3.3500	3.3500	3.5000	63.1950	335021.00	0.00	335021.00	1000	26	2026	5102	0.397099176793414	0.233687705469572	0.233687705469572	true	false	false	true
fd877cb4-101e-46e6-839e-06a9cc715008	2026-08-31 12:12	2026-08-31 12:12	2026-08-31 12:12	XLE	XLE270617C00070000	call	70.0000	2027-06-17	3.3500	3.3500	3.5000	63.1900	335130.00	0.00	335130.00	1000	9	1026	5102	0.20109760878087	0.234698333361503	0.234698333361503	false	false	false	true
aab880a6-640c-4500-9daa-058d235a7e92	2026-08-20 15:02	2026-08-20 15:02	2026-08-20 15:02	XLE	XLE270617C00070000	call	70.0000	2027-06-17	3.9000	3.8500	4.0000	63.8450	12870.00	390.00	12480.00	33	10	212	4746	0.044669195111673	0.236745455638561	0.236745455638561	false	false	false	true
6682ff96-623a-4879-b4c2-6adf95165947	2026-08-18 10:19	2026-08-18 10:19	2026-08-18 10:19	XLE	XLE270617C00070000	call	70.0000	2027-06-17	3.7000	3.5500	3.7000	63.3850	147988.00	147988.00	0.00	400	6	500	3779	0.132310134956338	0.235581957526384	0.235581957526384	false	false	false	true
25357061-6b26-4121-b535-31a1e61f35e8	2026-08-17 11:15	2026-08-17 11:15	2026-08-17 11:15	XLE	XLE270617C00070000	call	70.0000	2027-06-17	3.1500	3.1500	3.2500	62.1300	31500.00	0.00	31500.00	100	18	142	3679	0.038597444957869	0.233178385405136	0.233178385405136	false	false	false	true