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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×option_symbol = XLE270319P00060000×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

bac5b538-73b8-4cf5-bf23-1eb21a9d6bad	2026-08-26 14:24	2026-08-26 14:24	2026-08-26 14:24	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.2000	3.1500	3.2000	62.4850	15679.00	15679.00	0.00	49	7	506	14056	0.0359988616960729	0.269681258795846	0.269681258795846	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	42266645050.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-26T18:39:51.047298Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4fdaff22-95c0-4736-81a9-a2146212b22e	2026-08-27 13:58	2026-08-27 13:58	2026-08-27 13:58	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.1000	3.0500	3.1000	62.6250	12710.00	12710.00	0.00	41	6	287	14142	0.0202941592419743	0.267174711011273	0.267174711011273	false	false	false	true
b40fc773-f618-4159-9d76-c64935f4af64	2026-08-28 14:22	2026-08-28 14:22	2026-08-28 14:22	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.1500	3.1000	3.1500	62.5050	28979.00	28979.00	0.00	92	10	668	14226	0.0469562772388584	0.268397547586129	0.268397547586129	false	false	false	true
fa54c9e3-765d-408d-81cb-203dcc284dfa	2026-09-03 13:21	2026-09-03 13:20	2026-09-03 13:20	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.3200	2.2800	2.3200	65.1750	28536.00	28536.00	0.00	123	13	140	14661	0.0095491439874497	0.27079001435102	0.27079001435102	false	false	false	true
ca88197c-ec93-4b90-8bfc-d5955900ac43	2026-09-10 13:39	2026-09-10 13:38	2026-09-10 13:38	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.3600	2.3300	2.3600	65.1900	15812.00	15812.00	0.00	67	6	100	15293	0.00653893938403191	0.277633481235847	0.277633481235847	false	false	false	true
76b4b3c2-7743-4640-ba1b-044a3bb2186c	2026-09-10 14:52	2026-09-10 14:51	2026-09-10 14:51	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.3900	2.3300	2.3900	64.9700	15057.00	15057.00	0.00	63	14	205	15293	0.0134048257372654	0.275749786835817	0.275749786835817	false	false	false	true
50e22cbd-4acb-41fc-a5fe-470be9ae54ac	2026-09-14 13:50	2026-09-14 13:50	2026-09-14 13:50	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.4500	2.4100	2.4500	64.6600	17395.00	17395.00	0.00	71	7	126	15521	0.00811803363185362	0.272139560699524	0.272139560699524	false	false	false	true
b2ebef5a-a6b4-49f1-a391-f2a4b9cfb44a	2026-09-16 10:24	2026-09-16 10:24	2026-09-16 10:24	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4600	2.5500	64.0000	16830.00	16830.00	0.00	66	13	114	15647	0.00728574167572059	0.281310137069317	0.281310137069317	false	false	false	true
c02731e4-15ca-4708-b946-ba315a9fbaf3	2026-09-16 10:45	2026-09-16 10:45	2026-09-16 10:45	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4800	2.5500	64.3600	16575.00	16575.00	0.00	65	14	211	15647	0.013485013101553	0.280114503175654	0.280114503175654	false	false	false	true
4792a2f4-e7c4-42cb-b122-90f616ef45f0	2026-09-16 10:46	2026-09-16 10:46	2026-09-16 10:46	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4800	2.5500	64.3250	17595.00	17595.00	0.00	69	11	307	15647	0.0196203745126861	0.279469111673	0.279469111673	false	false	false	true
6386f3a2-215b-41c1-9d0b-7827c9baba4f	2026-09-16 10:50	2026-09-16 10:50	2026-09-16 10:50	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4800	2.5500	64.2700	17340.00	17340.00	0.00	68	15	405	15647	0.0258835559532179	0.27845266081762	0.27845266081762	false	false	false	true
dc6432d6-b0ef-4ef3-a4b1-dfecd2daa7f6	2026-09-16 10:58	2026-09-16 10:58	2026-09-16 10:58	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4800	2.5500	64.2650	17595.00	17595.00	0.00	69	14	483	15647	0.0308685370997635	0.278360118315113	0.278360118315113	false	false	false	true
f3a5062c-fe15-4bac-b3da-af1d2eabb5b9	2026-09-16 10:58	2026-09-16 10:58	2026-09-16 10:58	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5500	2.4800	2.5500	64.2450	22440.00	22440.00	0.00	88	17	571	15647	0.0364926183933022	0.277989717580038	0.277989717580038	false	false	false	true
f6ab8ee4-75d2-406e-b6f8-6839dad8c544	2026-09-16 14:39	2026-09-16 14:39	2026-09-16 14:39	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5400	2.4400	2.5400	64.4150	11938.00	11938.00	0.00	47	10	817	15647	0.0522144820093309	0.280482858609991	0.280482858609991	false	false	false	true
e782617f-62db-449f-bd7c-9e3600451bf2	2026-09-16 14:46	2026-09-16 14:46	2026-09-16 14:46	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5400	2.4400	2.5400	64.3700	13970.00	13970.00	0.00	55	17	886	15647	0.0566242730235828	0.279931520999164	0.279655546760572	false	false	false	true
c9606b1f-b4d0-4c04-a328-48a58e345df3	2026-09-16 14:49	2026-09-16 14:49	2026-09-16 14:49	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5400	2.4900	2.5400	64.3400	12192.00	12192.00	0.00	48	12	937	15647	0.0598836837732473	0.279102985136957	0.279102985136957	false	false	false	true
e9905f5f-d8cc-45a1-be61-4c3a74116639	2026-09-16 14:54	2026-09-16 14:54	2026-09-16 14:54	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5600	2.5000	2.5600	64.2700	10496.00	10496.00	0.00	41	10	986	15647	0.0630152744935131	0.279094546212962	0.279094546212962	false	false	false	true
03b6bbac-f9b6-4c97-8bf7-4a81c1e35e58	2026-09-18 09:49	2026-09-18 09:49	2026-09-18 09:49	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.4700	2.4700	2.6100	64.4300	14576.00	0.00	14576.00	59	6	59	15668	0.00376563696706663	0.277500519588498	0.279447309426473	false	false	false	true
fab613cb-c5c8-4f1a-98b4-86ec85b6bbbf	2026-09-18 14:35	2026-09-18 14:35	2026-09-18 14:35	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5200	2.4800	2.5300	64.3750	17136.00	16884.00	252.00	68	17	152	15668	0.00970130201684963	0.279728042151088	0.279728042151088	false	false	false	true
9ccdcbcc-827f-452d-a530-14862e54d7d6	2026-09-30 15:30	2026-09-30 15:30	2026-09-30 15:30	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	2.9000	3.0500	61.6300	19215.00	19215.00	0.00	63	13	65	17504	0.00371343692870201	0.263971276814313	0.263971276814313	false	false	false	true
2caa36d0-743a-4fab-a058-350e4837134b	2026-09-30 15:31	2026-09-30 15:31	2026-09-30 15:31	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	2.9000	3.0500	61.5850	19215.00	19215.00	0.00	63	13	128	17504	0.00731261425959781	0.262935339722244	0.262935339722244	false	false	false	true
59ce4283-827c-4632-a326-cb04ab43fcb7	2026-09-30 15:32	2026-09-30 15:32	2026-09-30 15:32	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	2.9100	3.0500	61.5550	18910.00	18910.00	0.00	62	14	204	17504	0.011654478976234	0.262242953295358	0.262242953295358	false	false	false	true
265229f0-1324-452b-b99d-76b29b5b5362	2026-09-30 15:32	2026-09-30 15:32	2026-09-30 15:32	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	2.9100	3.0500	61.5400	19215.00	19215.00	0.00	63	12	283	17504	0.0161677330895795	0.261896228054209	0.261896228054209	false	false	false	true
2d90dfd1-4f7b-4366-9e13-8e73ba3598c0	2026-09-30 15:33	2026-09-30 15:33	2026-09-30 15:33	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	3.0000	3.0500	61.4950	19215.00	19215.00	0.00	63	12	395	17504	0.0225662705667276	0.260853909949995	0.260853909949995	false	false	false	true
248c4c64-7ff9-413f-8395-5c11e9c2079f	2026-09-30 15:49	2026-09-30 15:49	2026-09-30 15:49	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	3.0000	3.0500	61.5200	18605.00	18605.00	0.00	61	12	467	17504	0.0266796160877514	0.261433373335245	0.261433373335245	false	false	false	true
b3c9788c-6298-492a-8501-68c3e06795d3	2026-09-30 15:50	2026-09-30 15:50	2026-09-30 15:50	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	3.0000	3.0500	61.0000	19215.00	19215.00	0.00	63	14	551	17504	0.0314785191956124	0.259691978585763	0.259691978585763	false	false	false	true
eb0bda83-e646-4d51-bfe4-274864978ab4	2026-09-30 15:51	2026-09-30 15:51	2026-09-30 15:51	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	3.0000	3.0500	61.0000	24095.00	24095.00	0.00	79	16	715	17504	0.0408478062157221	0.25910949925144	0.25910949925144	false	false	false	true
d3f04fa2-226b-4e38-9cc4-dcc55a763689	2026-09-30 15:51	2026-09-30 15:51	2026-09-30 15:51	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	3.0000	3.0500	61.0000	15250.00	15250.00	0.00	50	11	819	17504	0.0467893053016453	0.259342612673438	0.259342612673438	true	false	false	true
ad0f3892-c7da-4c7a-beec-c178656cc76d	2026-10-01 10:50	2026-10-01 10:50	2026-10-01 10:50	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.8100	2.7900	3.0500	62.2500	42431.00	0.00	42431.00	151	5	151	17500	0.00862857142857143	0.262960013885108	0.262960013885108	false	false	false	true