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

316157ff-21f9-45ff-b0a1-074ac5d6c4b2	2026-08-18 10:29	2026-08-18 10:29	2026-08-18 10:29	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.8500	1.8200	1.8900	63.3350	22200.00	19055.00	3145.00	120	5	479	20577	0.0232784176507751	0.23861914066417	0.23861914066417	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-18T14:32:52.256663Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
1acafe9c-242c-4e60-a036-f32b92652885	2026-08-18 12:04	2026-08-18 12:04	2026-08-18 12:04	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.8800	1.8800	1.9500	63.5150	37600.00	0.00	37600.00	200	6	969	20577	0.0470914127423823	0.236710227696204	0.236710227696204	false	false	false	true
77a1aa71-9062-4fd9-a41a-7f4323bf4871	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.1100	2.1000	2.1200	63.9200	13926.00	4220.00	9706.00	66	13	420	20052	0.0209455415918612	0.24506474608614	0.24506474608614	true	false	false	true
a635b15b-92bd-4646-8128-50611a5a8bc3	2026-08-24 10:55	2026-08-24 10:55	2026-08-24 10:55	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.6500	1.6500	1.7400	62.8550	110833.00	0.00	110833.00	670	39	1457	20127	0.072390321458737	0.242071846834066	0.240609256052738	true	false	false	true
7d500a11-9258-41ef-b51d-8640e9da2cf3	2026-08-25 10:35	2026-08-25 10:35	2026-08-25 10:35	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.4800	1.4800	1.5700	62.6500	113960.00	0.00	113960.00	770	9	951	19999	0.0475523776188809	0.233277960823446	0.233277960823446	false	false	false	true
5786e47f-16ef-41ae-8e38-da9faf4a032d	2026-08-26 10:08	2026-08-26 10:07	2026-08-26 10:07	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.4700	1.4700	1.5100	62.3350	36456.00	0.00	36456.00	248	9	390	20560	0.0189688715953307	0.240210726928839	0.240210726928839	false	false	false	true
5262644f-f540-43e5-b525-a1c03afaea66	2026-08-31 11:20	2026-08-31 11:20	2026-08-31 11:20	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.5500	1.5500	1.6300	63.2050	31000.00	0.00	31000.00	200	8	481	20184	0.0238307570352755	0.234017555177328	0.234017555177328	false	false	false	true
0d2f8132-4c90-4cec-920f-784a4901b909	2026-08-31 11:45	2026-08-31 11:45	2026-08-31 11:45	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.6100	1.6100	1.6500	63.3290	16100.00	0.00	16100.00	100	9	581	20184	0.0287851763773286	0.235759755715285	0.235759755715285	false	false	false	true
7643ece2-374f-4f72-88cc-6af0fcfc37b0	2026-08-31 15:55	2026-08-31 15:55	2026-08-31 15:55	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.8200	1.7300	1.8200	63.9200	36400.00	36400.00	0.00	200	20	2276	20184	0.112762584225129	0.237654829863223	0.237654829863223	false	false	false	true
2eff5b61-6d09-4935-add8-f4f89c56a011	2026-09-01 15:38	2026-09-01 15:38	2026-09-01 15:38	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.2000	2.1400	2.2100	64.6200	44087.00	19227.00	24860.00	200	6	704	20478	0.0343783572614513	0.247142207879905	0.246464959148474	false	false	false	true
f7a32cd4-b5ed-4c36-83d9-07409f26f0de	2026-09-03 15:01	2026-09-03 15:01	2026-09-03 15:01	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.1300	2.1200	2.1800	64.8650	21303.00	0.00	1920.00	100	9	458	20722	0.0221021136955892	0.238454081236929	0.237095618089241	false	false	false	true
e3faf1cb-0643-41bb-9e30-0227eca0cc96	2026-09-03 15:21	2026-09-03 15:21	2026-09-03 15:21	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.1200	2.1200	2.1700	64.8500	21200.00	0.00	21200.00	100	8	1159	20722	0.0559308947012837	0.237463356235239	0.237463356235239	false	false	false	true
74e013ef-dcc2-4927-a095-aba6ebd66897	2026-09-04 13:51	2026-09-04 13:51	2026-09-04 13:51	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.8600	1.8500	1.8800	64.1000	20460.00	0.00	20460.00	110	11	386	20134	0.0191715506109069	0.240400776680428	0.240400776680428	false	false	false	true
aceac8d6-c12c-466f-9754-b8421b276c0d	2026-09-04 13:53	2026-09-04 13:53	2026-09-04 13:53	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.8500	1.8500	1.8600	64.1250	30340.00	0.00	30340.00	164	22	556	20134	0.0276149796364359	0.23909892353996	0.23909892353996	false	false	false	true
ec5e885c-91be-4ad0-8ebc-1e6a3a447f95	2026-09-08 15:31	2026-09-08 15:30	2026-09-08 15:30	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.1800	2.1700	2.2000	64.9450	133198.00	0.00	133198.00	611	6	1105	19907	0.0555081127241674	0.244701595490666	0.244701595490666	false	false	false	true
0dab32e7-785e-4528-a709-06f76b823000	2026-09-09 10:18	2026-09-09 10:18	2026-09-09 10:18	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.3200	2.2500	2.3800	65.2650	66092.00	59624.00	6468.00	285	5	377	20011	0.0188396381989906	0.248557018920801	0.248557018920801	false	false	false	true
1104b019-f7a4-415e-87e8-bac8af24b5a2	2026-09-09 11:39	2026-09-09 11:39	2026-09-09 11:39	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.3200	2.2900	2.3600	65.2900	23665.00	465.00	23200.00	102	13	518	20011	0.0258857628304433	0.248597185091866	0.248597185091866	false	false	false	true
d70bf239-3419-47af-9c98-c7538c69ce0b	2026-09-09 15:03	2026-09-09 15:03	2026-09-09 15:03	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.3900	2.3000	2.4000	65.4901	47826.00	47826.00	0.00	200	6	1607	20011	0.0803058317925141	0.248852481775247	0.248177818995886	false	false	false	true
a62d0c89-a673-4209-9be7-b9ffe7b941c0	2026-09-10 13:10	2026-09-10 13:10	2026-09-10 13:10	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.3000	2.3000	2.3200	65.2050	31280.00	0.00	31280.00	136	5	936	19908	0.0470162748643761	0.248426271009846	0.248426271009846	false	false	false	true
dce2dee4-96cc-4f4f-be33-a2fa064ee6f6	2026-09-10 13:51	2026-09-10 13:50	2026-09-10 13:50	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.2800	2.2600	2.3100	65.1250	73644.00	0.00	73644.00	323	13	1300	19908	0.065300381756078	0.249111122282091	0.249111122282091	false	false	false	true
1d0c6e6c-cb25-4292-8491-d7de409b9bff	2026-09-10 15:00	2026-09-10 15:00	2026-09-10 15:00	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.2800	2.2700	2.3200	65.1200	47424.00	0.00	47424.00	208	5	1621	19908	0.0814245529435403	0.249239458605005	0.249239458605005	false	false	false	true
de1ef57e-fb33-4f27-95e5-01e62ca26b41	2026-09-10 15:22	2026-09-10 15:21	2026-09-10 15:21	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.2800	2.2700	2.3000	65.1350	259236.00	2736.00	256500.00	1137	28	2760	19908	0.138637733574442	0.248854404520629	0.248854404520629	false	false	false	true
4566b61f-9afd-4704-8e61-9264b20a0c88	2026-09-11 11:18	2026-09-11 11:18	2026-09-11 11:18	XLE	XLE270115C00070000	call	70.0000	2027-01-15	2.1000	2.1000	2.1800	64.9100	42000.00	0.00	42000.00	200	7	471	22012	0.0213974195893149	0.242915088165195	0.242915088165195	false	false	false	true
919ba3d2-207e-4407-b0e5-36e1da9d80e3	2026-09-21 14:17	2026-09-21 14:17	2026-09-21 14:17	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.5000	1.4800	1.5000	62.8850	97050.00	97050.00	0.00	647	19	1597	19916	0.0801867844948785	0.257900779638143	0.257900779638143	false	false	false	true
245e4a18-ef03-4d47-91dd-4f0e3e93fc1e	2026-09-21 15:09	2026-09-21 15:09	2026-09-21 15:09	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.5000	1.4700	1.5000	62.7500	168600.00	168600.00	0.00	1124	7	2749	19916	0.138029724844346	0.261087571771111	0.261087571771111	false	false	false	true