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

0521a807-e16a-41c5-9918-73ca2909315f	2026-09-25 15:00	2026-09-25 14:59	2026-09-25 14:59	XLE	XLE270115C00065000	call	65.0000	2027-01-15	2.5100	2.4900	2.5100	61.0000	27608.00	27359.00	249.00	110	13	131	32536	0.00402630931890829	0.248803681251742	0.250446647083147	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	40486178216.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:03:13.684497Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
dc8fe2a9-6f36-4ff9-994a-38a7d85fa8c5	2026-09-21 11:44	2026-09-21 11:44	2026-09-21 11:44	XLE	XLE270115C00065000	call	65.0000	2027-01-15	2.9500	2.9000	2.9500	62.7800	42775.00	42775.00	0.00	145	6	798	32845	0.0242959354544071	0.251399131003204	0.251399131003204	false	false	false	true
29b47256-fb85-407f-adfc-3141f77a75f8	2026-09-16 10:45	2026-09-16 10:45	2026-09-16 10:45	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.7500	3.7500	3.9000	64.3600	30035.00	2660.00	27375.00	80	14	350	33197	0.0105431213663885	0.245720326011331	0.245720326011331	false	false	false	true
c858ee2a-e3bb-48b1-a101-61c03704220c	2026-09-16 09:35	2026-09-16 09:35	2026-09-16 09:35	XLE	XLE270115C00065000	call	65.0000	2027-01-15	4.0500	3.9500	4.1000	64.9950	30408.00	10935.00	18663.00	75	7	116	33197	0.0034942916528602	0.242630114652692	0.242924561726832	false	false	false	true
ca1142b4-660f-4e8b-a395-8ecb894ab246	2026-09-10 15:52	2026-09-10 15:52	2026-09-10 15:52	XLE	XLE270115C00065000	call	65.0000	2027-01-15	4.1500	4.1500	4.2000	65.0450	41501.00	0.00	41501.00	100	10	520	32878	0.0158160472048178	0.24158524617866	0.240921961981834	false	false	false	true
9dd00324-8365-4017-8148-85d521eb9fd5	2026-09-10 10:44	2026-09-10 10:44	2026-09-10 10:44	XLE	XLE270115C00065000	call	65.0000	2027-01-15	4.0000	3.9000	4.0000	64.6550	43993.00	43993.00	0.00	110	6	183	32878	0.00556603199708011	0.244151110091624	0.245477112409118	false	false	false	true
0cf30bff-bece-4603-b8ad-907b62121788	2026-09-01 14:52	2026-09-01 14:52	2026-09-01 14:52	XLE	XLE270115C00065000	call	65.0000	2027-01-15	4.0000	4.0000	4.0500	64.6399	20000.00	0.00	20000.00	50	9	1507	21654	0.0695945321880484	0.235889154385312	0.235889154385312	false	false	false	true
3b96a3e1-e6c6-4bd5-8ab2-64fa2e889cbd	2026-09-01 14:52	2026-09-01 14:52	2026-09-01 14:52	XLE	XLE270115C00065000	call	65.0000	2027-01-15	4.0000	3.9500	4.0500	64.6350	95198.00	93998.00	400.00	238	42	1445	21654	0.0667313198485268	0.235422060365842	0.236063304278858	false	false	false	true
b3aad63b-173d-4e77-b3f6-e11753912a87	2026-09-01 13:28	2026-09-01 13:27	2026-09-01 13:27	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.9000	3.8500	3.9000	64.5869	16770.00	16770.00	0.00	43	7	1180	21654	0.0544933961392814	0.231356724792755	0.231356724792755	false	false	false	true
11f9d18a-77a6-4cdd-90ad-cc3241605052	2026-09-01 13:02	2026-09-01 13:02	2026-09-01 13:02	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.8000	3.8000	3.8500	64.4800	58140.00	0.00	58140.00	153	7	1087	21654	0.0501985776299991	0.22871180834637	0.22871180834637	true	false	false	true
1bda6667-4e55-4c76-af5a-2134202f0b87	2026-09-01 12:33	2026-09-01 12:32	2026-09-01 12:32	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.8000	3.7000	3.8000	64.3750	30400.00	30400.00	0.00	80	5	881	21654	0.0406853237277177	0.232382956088839	0.232382956088839	false	false	false	true
1c5c6463-d3b3-4b7c-8308-ba98397521ed	2026-09-01 11:17	2026-09-01 11:17	2026-09-01 11:17	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.7900	3.7000	3.8000	64.4200	28442.00	28442.00	0.00	75	13	574	21654	0.0265078045626674	0.230813079281861	0.22953011902842	false	false	false	true
2fb90802-4318-49bb-92b2-a2d24767364b	2026-08-24 12:27	2026-08-24 12:27	2026-08-24 12:27	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.1000	3.0500	3.1500	62.8050	15190.00	6510.00	8680.00	49	5	301	21474	0.0140169507311167	0.230857892695115	0.230857892695115	false	false	false	true
dad00fc9-94e4-4ba0-91e5-a05cd9c740f1	2026-08-18 15:42	2026-08-18 15:42	2026-08-18 15:42	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.6100	3.6000	3.6500	63.5900	22036.00	0.00	22036.00	61	8	672	21692	0.0309791628250046	0.23191581694814	0.23191581694814	false	false	false	true
cd98e960-bd63-4362-b7bd-7820ce052367	2026-08-18 15:42	2026-08-18 15:42	2026-08-18 15:42	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.6000	3.6000	3.6500	63.5900	68067.00	0.00	68067.00	189	20	861	21692	0.0396920523695372	0.232531115393228	0.23191581694814	false	false	false	true
e16904e2-a27d-45d8-af0c-7838e779f39f	2026-08-17 13:14	2026-08-17 13:13	2026-08-17 13:13	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.0000	3.0000	3.0500	62.4550	28500.00	0.00	28500.00	95	27	1651	20972	0.0787240129696739	0.228097853887893	0.228243564526352	false	false	false	true
393f3dfa-bf2c-4457-83b1-37aa6ae2f121	2026-08-17 11:17	2026-08-17 11:16	2026-08-17 11:16	XLE	XLE270115C00065000	call	65.0000	2027-01-15	2.8600	2.8600	2.9300	62.0950	58916.00	0.00	58916.00	206	14	1478	20972	0.0704749189395384	0.229803523498777	0.229803523498777	true	false	false	true
7fb5ce4f-fe2c-4cc0-b927-2c572141be93	2026-08-17 10:07	2026-08-17 10:07	2026-08-17 10:07	XLE	XLE270115C00065000	call	65.0000	2027-01-15	3.0500	2.9800	3.0500	62.3400	14945.00	14945.00	0.00	49	5	656	20972	0.0312798016402823	0.234725830620453	0.234725830620453	false	false	false	true