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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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 = XLE270115C00065000×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

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	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-17T14:09:25.911404Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
cfe30f9f-5fd7-4985-bfc4-861704601094	2026-09-29 14:05	2026-09-29 14:05	2026-09-29 14:05	XLE	XLE270115C00065000	call	65.0000	2027-01-15	2.2300	2.2300	2.2500	61.5400	22746.00	0.00	22746.00	102	16	398	32521	0.0122382460563943	0.248358738279705	0.248358738279705	false	false	false	true