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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = XLE270115C00060000×ticker = XLE×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

015f08db-2a7f-4606-9bac-0784f2b06a1b	2026-08-17 13:57	2026-08-17 13:57	2026-08-17 13:57	XLE	XLE270115C00060000	call	60.0000	2027-01-15	5.5000	5.4000	5.5500	62.0000	14300.00	9900.00	0.00	26	5	190	28771	0.00660387195439853	0.221638971937731	0.221638971937731	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-17T18:13:23.978459Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c6e5795e-b130-4c12-8ff0-cb29a7ce7137	2026-08-18 11:34	2026-08-18 11:34	2026-08-18 11:34	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.3000	6.2000	6.3000	63.5200	188998.00	188998.00	0.00	300	5	477	28711	0.0166138413848351	0.230103495568017	0.231550948511406	false	false	false	true
07d36a74-508d-46c4-8718-a196f924c86c	2026-08-18 11:34	2026-08-18 11:34	2026-08-18 11:34	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.2000	6.0500	6.3000	63.5200	16120.00	620.00	15500.00	26	5	503	28711	0.0175194176448051	0.224291186294434	0.224291186294434	false	false	false	true
06f0e21a-8b81-4a3e-aea4-17df2a51ebbe	2026-08-19 11:36	2026-08-19 11:36	2026-08-19 11:36	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.5000	6.4500	6.6000	63.9200	130570.00	0.00	130570.00	201	8	411	29129	0.0141096501767998	0.22618356488822	0.225438674525139	false	false	false	true
7b16cb59-d9b4-4492-b4d0-fd6411b95e97	2026-08-19 11:37	2026-08-19 11:37	2026-08-19 11:37	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.4500	6.4500	6.6000	63.9201	129645.00	0.00	129645.00	201	11	685	29129	0.0235160836279996	0.222446165430699	0.222446165430699	false	false	false	true
6360b892-7a46-4a51-83d5-db273e8cd2ce	2026-08-20 12:23	2026-08-20 12:23	2026-08-20 12:23	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.7500	6.7500	6.9000	64.2550	37125.00	0.00	37125.00	55	7	321	29027	0.0110586695145899	0.227474359783236	0.227474359783236	false	false	false	true
a16cc427-073b-4a21-aef1-26165e90c085	2026-08-28 15:07	2026-08-28 15:07	2026-08-28 15:07	XLE	XLE270115C00060000	call	60.0000	2027-01-15	5.3000	5.2500	5.3000	62.5100	145220.00	145220.00	0.00	274	10	324	29377	0.0110290363209313	0.221232345467254	0.221232345467254	false	false	false	true
f60ab1d7-bd04-47b9-b539-9e58ff80168c	2026-08-28 15:56	2026-08-28 15:56	2026-08-28 15:56	XLE	XLE270115C00060000	call	60.0000	2027-01-15	5.4500	5.3500	5.5000	62.7050	109000.00	109000.00	0.00	200	7	525	29377	0.0178711236681758	0.222395332811981	0.222395332811981	false	false	false	true
f69dd431-8fd6-413c-923a-19d70259889f	2026-08-31 10:52	2026-08-31 10:52	2026-08-31 10:52	XLE	XLE270115C00060000	call	60.0000	2027-01-15	5.9500	5.9500	6.0500	63.5350	164220.00	0.00	164220.00	276	6	617	29103	0.0212005635157888	0.22290516866845	0.22290516866845	false	false	false	true
a2e8c19e-1bb9-405d-ae46-97994460238b	2026-08-31 10:52	2026-08-31 10:52	2026-08-31 10:52	XLE	XLE270115C00060000	call	60.0000	2027-01-15	5.9500	5.9500	6.0500	63.5350	24405.00	0.00	24405.00	41	11	341	29103	0.0117170051197471	0.223669728537906	0.22290516866845	false	false	false	true
3ff20d97-5f19-469c-95a0-49e85d884965	2026-08-31 10:52	2026-08-31 10:52	2026-08-31 10:52	XLE	XLE270115C00060000	call	60.0000	2027-01-15	5.9500	5.9500	6.0500	63.5350	148873.00	0.00	148873.00	250	23	300	29103	0.0103082156478714	0.22519680249529	0.224433603700024	false	false	false	true
9b404809-008a-48d8-bbf7-e10a3ee12dde	2026-09-02 13:41	2026-09-02 13:41	2026-09-02 13:41	XLE	XLE270115C00060000	call	60.0000	2027-01-15	7.1500	7.0500	7.1500	65.1000	10725.00	10725.00	0.00	15	5	314	28917	0.0108586644534357	0.227462387478569	0.227462387478569	false	false	false	true
00efa73c-5226-4993-a45b-9b4fa52c08ca	2026-09-09 13:59	2026-09-09 13:58	2026-09-09 13:58	XLE	XLE270115C00060000	call	60.0000	2027-01-15	7.3000	7.3000	7.4000	65.3950	69350.00	0.00	69350.00	95	14	283	28307	0.00999752711343484	0.229209852944142	0.229209852944142	false	false	false	true
8a953350-08c0-41af-99c9-77ac074d3596	2026-09-16 10:58	2026-09-16 10:58	2026-09-16 10:58	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.4500	6.4500	6.6000	64.2450	58050.00	0.00	58050.00	90	7	157	28129	0.00558142841906929	0.234373512281081	0.234373512281081	false	false	false	true
b50f5b3c-71bb-4f2a-924c-083c3e20233e	2026-09-18 09:57	2026-09-18 09:57	2026-09-18 09:57	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.3300	6.2500	6.6000	64.2100	35424.00	630.00	34794.00	56	5	69	28128	0.00245307167235495	0.225757869389575	0.225757869389575	false	false	false	true
9e2191e7-be8e-441a-88e5-218419a0463e	2026-09-18 10:26	2026-09-18 10:25	2026-09-18 10:25	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.4500	6.4000	6.4500	64.3900	868815.00	868815.00	0.00	1347	10	1449	28128	0.0515145051194539	0.226912022917125	0.226912022917125	false	false	false	true