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

04c47574-59c2-46e9-b094-65f166113361	2026-08-21 14:18	2026-08-21 14:17	2026-08-21 14:17	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6600	0.6600	0.6700	63.0000	12144.00	0.00	12144.00	184	7	457	3807	0.120042027843446	0.249894245840472	0.249894245840472	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	42266645050.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-21T18:26:00.268050Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
158bfeb2-7b42-43fa-b4e2-51c8b2977dd4	2026-09-09 10:51	2026-09-09 10:50	2026-09-09 10:50	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6400	0.6400	0.6500	65.1800	59584.00	0.00	59584.00	931	35	1190	4636	0.256686798964625	0.257689644514352	0.257689644514352	true	false	false	true
8aa578c5-9a7c-4c48-8c3e-0c8b54511eb2	2026-09-09 11:53	2026-09-09 11:53	2026-09-09 11:53	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6600	0.6500	0.6700	65.2000	28512.00	0.00	23100.00	432	5	1632	4636	0.352027610008628	0.260233735392415	0.260233735392415	false	false	false	true
027155cd-21a0-46a2-ba0c-b84e254bc147	2026-09-10 10:13	2026-09-10 10:13	2026-09-10 10:13	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6000	0.5800	0.6000	64.6800	59940.00	59940.00	0.00	999	5	1621	5646	0.287105915692526	0.272471700568198	0.272471700568198	false	false	false	true
fce90957-6a49-4f61-853f-23df9598832b	2026-09-10 11:04	2026-09-10 11:03	2026-09-10 11:03	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.5500	0.5400	0.5700	64.7300	14850.00	0.00	14850.00	270	15	2447	5646	0.433404179950407	0.261874823165414	0.261874823165414	false	false	false	true
784a9561-aac2-4504-b78b-01f0528bddfb	2026-09-11 10:54	2026-09-11 10:54	2026-09-11 10:54	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.5200	0.5200	0.5400	64.9050	94640.00	0.00	94640.00	1820	41	1890	7088	0.266647855530474	0.254058532151469	0.254058532151469	false	false	false	true
273c97ca-0980-4d63-bcf8-645179cc7ff9	2026-09-14 09:32	2026-09-14 09:32	2026-09-14 09:32	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6500	0.6500	0.6900	65.7400	32500.00	0.00	32500.00	500	21	573	8658	0.0661815661815662	0.258180538243856	0.258180538243856	false	false	false	true
a174a96f-0246-4446-997b-23471a0082af	2026-09-14 12:49	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.4400	0.4200	0.4500	64.6300	116204.00	264.00	115940.00	2641	60	3685	8658	0.425617925617926	0.260029278810465	0.26038102049771	false	false	false	true
8f2dc546-735c-4c06-96b1-713e16751cdf	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.3900	0.3700	0.4100	64.2600	15171.00	5460.00	0.00	389	5	4826	8658	0.557403557403557	0.262557790635213	0.262557790635213	false	false	false	true
58cd1729-e8ed-4667-9fd2-aca264d5e9a9	2026-09-15 10:18	2026-09-15 10:18	2026-09-15 10:18	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.5400	0.5400	0.5600	65.4400	119772.00	0.00	119772.00	2218	54	4270	11189	0.38162481008133	0.254620110357311	0.254620110357311	true	false	false	true
4f2e6002-f16d-4b2e-94a2-c14b9db52dce	2026-09-15 10:18	2026-09-15 10:18	2026-09-15 10:18	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.5400	0.5400	0.5500	65.4400	150228.00	0.00	150228.00	2782	8	7052	11189	0.630261864331039	0.254620110357311	0.254620110357311	true	false	false	true
ec1fa8fb-ab7c-43a3-a0a7-0c81b00d59b2	2026-09-15 10:18	2026-09-15 10:18	2026-09-15 10:18	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.5400	0.5400	0.5500	65.4499	143154.00	0.00	143154.00	2651	8	11125	11189	0.994280096523371	0.25424558891838	0.25424558891838	true	false	false	true
5fa8dd76-61ca-4ba3-94f2-5a5a39fbe4dc	2026-09-15 10:18	2026-09-15 10:18	2026-09-15 10:18	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.5400	0.5400	0.5500	65.4499	76788.00	0.00	76788.00	1422	13	8474	11189	0.757350969702386	0.25424558891838	0.25424558891838	true	false	false	true
063419dd-dbf2-4388-9a42-bf6550f0b786	2026-09-15 12:14	2026-09-15 12:14	2026-09-15 12:14	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6700	0.6500	0.6700	65.8300	59764.00	59764.00	0.00	892	18	12155	11189	1.08633479310037	0.262399248912239	0.262399248912239	true	false	false	true
689cbba4-81ab-42df-b3b1-9b9bb2bed76c	2026-09-15 13:20	2026-09-15 13:20	2026-09-15 13:20	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6800	0.6800	0.6900	65.8850	68000.00	0.00	68000.00	1000	20	13221	11189	1.18160693538297	0.261884992380119	0.261884992380119	false	false	false	true
994fb8e5-5040-4d5e-bf50-2d6e98ef4672	2026-09-15 13:45	2026-09-15 13:45	2026-09-15 13:45	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.7100	0.6900	0.7100	65.9907	239838.00	239838.00	0.00	3378	15	16685	11189	1.4911967110555	0.262615586009414	0.262615586009414	false	false	false	true
066ef1af-9143-4f54-b00c-05cbb9017626	2026-09-15 14:29	2026-09-15 14:29	2026-09-15 14:29	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.7000	0.6800	0.7000	65.8550	10500.00	10500.00	0.00	150	13	16949	11189	1.51479131289659	0.266443455317866	0.266443455317866	false	false	false	true
edf63dc2-29de-44c2-b3a3-076e03e12a13	2026-09-15 14:33	2026-09-15 14:33	2026-09-15 14:33	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6700	0.6700	0.6900	65.8150	17688.00	0.00	17688.00	264	12	17233	11189	1.54017338457414	0.262997946518063	0.262997946518063	false	false	false	true
9f60fceb-6c90-4ed5-aef2-01b2060ae082	2026-09-15 14:33	2026-09-15 14:33	2026-09-15 14:33	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.6700	0.6700	0.6900	65.8150	15812.00	0.00	15812.00	236	19	17469	11189	1.5612655286442	0.262997946518063	0.262997946518063	false	false	false	true
e065d26d-96db-4428-9fbb-e220dc9c8a81	2026-09-17 12:13	2026-09-17 12:13	2026-09-17 12:13	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.2700	0.2700	0.2800	64.0250	37530.00	0.00	37530.00	1390	36	1462	27641	0.0528924423863102	0.254785407403215	0.254785407403215	false	false	false	true
6c72e692-0ebb-48a5-a33c-3992a86c57fb	2026-09-18 09:35	2026-09-18 09:35	2026-09-18 09:35	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.2800	0.2700	0.2800	64.2700	60228.00	60228.00	0.00	2151	11	2232	27029	0.082577971808058	0.253862723528101	0.253862723528101	false	false	false	true
e3a09c7c-2b4b-46f4-a18f-7e63a2584c19	2026-09-18 14:44	2026-09-18 14:44	2026-09-18 14:44	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.2900	0.2900	0.3000	64.3600	15138.00	0.00	15138.00	522	20	5872	27029	0.217248140885715	0.253415391803059	0.253415391803059	false	false	false	true