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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = XLU270319P00040000×ticker = XLU×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	expiry

5b57911b-2c8d-4ff7-b1d7-7099c43a9f5f	2026-09-16 11:27	2026-09-16 11:27	2026-09-16 11:27	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.1900	1.1300	1.1900	41.5799	20111.00	20111.00	0.00	169	33	171	466	0.366952789699571	0.192993683177032	0.192993683177032	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	21523085036.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T15:39:18.643032Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
a876e6c8-15a5-4608-9255-eca751408f98	2026-09-21 12:45	2026-09-21 12:45	2026-09-21 12:45	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.2900	1.2200	1.2900	40.8850	13278.00	13278.00	0.00	103	29	248	610	0.40655737704918	0.181735884626427	0.181735884626427	false	false	false	true
78b42e4b-aa94-489b-b35d-165db2f9c76d	2026-09-24 14:15	2026-09-24 14:15	2026-09-24 14:15	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.9500	1.8600	1.9500	39.5050	11894.00	11894.00	0.00	61	24	311	850	0.365882352941176	0.193734256487675	0.193734256487675	false	false	false	true
5557e0eb-d2c2-4d06-b967-a5c65ec264f0	2026-09-24 14:16	2026-09-24 14:16	2026-09-24 14:16	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.9600	1.8600	1.9600	39.5050	11760.00	11760.00	0.00	60	8	371	850	0.436470588235294	0.194655665995536	0.194655665995536	false	false	false	true
41bfbe4a-d735-40e8-a674-0044b7c9a41a	2026-09-24 14:16	2026-09-24 14:16	2026-09-24 14:16	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.9600	1.8900	1.9600	39.5100	11760.00	11760.00	0.00	60	8	435	850	0.511764705882353	0.194862249695076	0.194862249695076	false	false	false	true
c4885d10-fb4e-498d-8115-b699040f54f3	2026-09-24 14:39	2026-09-24 14:38	2026-09-24 14:38	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.9800	1.9200	1.9800	39.4850	11880.00	11880.00	0.00	60	6	521	850	0.612941176470588	0.195670475465561	0.195670475465561	false	false	false	true
677dd754-4a8b-472d-8c0e-ac57bb66b0f8	2026-09-24 15:12	2026-09-24 15:12	2026-09-24 15:12	XLU	XLU270319P00040000	put	40.0000	2027-03-19	2.0000	1.9300	2.0000	39.4850	12000.00	12000.00	0.00	60	12	832	850	0.978823529411765	0.197513375514249	0.197513375514249	false	false	false	true
3d9706c1-cbf7-4189-ba5f-31e033909e67	2026-09-24 15:12	2026-09-24 15:12	2026-09-24 15:12	XLU	XLU270319P00040000	put	40.0000	2027-03-19	2.0000	1.9300	2.0000	39.4801	12000.00	12000.00	0.00	60	8	892	850	1.04941176470588	0.197310104401591	0.197310104401591	false	false	false	true
ab6a76d9-d2da-48a8-ae3d-069f991d8c51	2026-09-30 14:10	2026-09-30 14:10	2026-09-30 14:10	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.9900	1.9200	1.9900	39.5850	40795.00	40795.00	0.00	205	14	268	1760	0.152272727272727	0.203344751392871	0.203344751392871	false	false	false	true
840e23e1-080e-4590-a2e6-79aaa274482c	2026-10-01 12:17	2026-10-01 12:17	2026-10-01 12:17	XLU	XLU270319P00040000	put	40.0000	2027-03-19	2.0900	2.0800	2.1400	39.4750	22154.00	209.00	21945.00	106	23	645	1993	0.323632714500753	0.207802553352152	0.208228271338986	false	false	false	true
1edf6be0-8f9f-4b81-b791-67402c13eddf	2026-10-02 10:59	2026-10-02 10:59	2026-10-02 10:59	XLU	XLU270319P00040000	put	40.0000	2027-03-19	1.9000	1.8800	1.9600	39.9800	15753.00	15564.00	189.00	83	8	83	2600	0.0319230769230769	0.210005604828953	0.210949474174783	false	false	false	true