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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active: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	expirydate	pricenumeric

37125753-011d-4a90-8d6d-bda371dfa662	2026-08-18 09:30	2026-08-18 09:30	2026-08-18 09:30	XLE	XLE261016C00068000	call	68.0000	2026-10-16	1.0000	1.0000	1.0500	63.4500	40000.00	0.00	40000.00	400	13	500	3367	0.148500148500149	0.242293470180043	0.242940096451775	true	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-18T13:38:24.498702Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c56c948c-ed75-465a-a021-b9180974827c	2026-08-18 09:36	2026-08-18 09:36	2026-08-18 09:36	XLE	XLE260821C00061000	call	61.0000	2026-08-21	2.4800	2.4800	2.5800	63.4100	13888.00	0.00	13888.00	56	5	1655	23626	0.070049944975874	0.291995121422123	0.291995121422123	false	false	false	true	false
47e05c90-80e1-4e13-9e26-c42ae751afad	2026-08-18 09:36	2026-08-18 09:36	2026-08-18 09:36	XLE	XLE260918C00062500	call	62.5000	2026-09-18	2.4500	2.3600	2.4500	63.4650	17885.00	17885.00	0.00	73	7	272	26956	0.0100905178809912	0.247170043383551	0.247170043383551	true	false	false	true	false
ad8ed633-15f8-4977-8a7e-1da244748913	2026-08-18 09:41	2026-08-18 09:41	2026-08-18 09:41	XLE	XLE260821P00063000	put	63.0000	2026-08-21	0.5000	0.4600	0.5000	63.0000	27750.00	27750.00	0.00	555	14	560	19	29.4736842105263	0.274057048157052	0.274057048157052	true	false	false	true	false
f8390292-4331-4202-a728-d418e5072145	2026-08-18 09:46	2026-08-18 09:46	2026-08-18 09:46	XLE	XLE260821C00063500	call	63.5000	2026-08-21	0.5200	0.5000	0.5200	63.0000	163332.00	163332.00	0.00	3141	10	3204	917	3.49400218102508	0.280088080556232	0.280088080556232	false	false	false	true	false
98cd9f39-946e-45da-b1f8-22e5030180c1	2026-08-18 09:47	2026-08-18 09:47	2026-08-18 09:47	XLE	XLE260821C00063000	call	63.0000	2026-08-21	0.8200	0.7600	0.8200	63.0000	20500.00	20500.00	0.00	250	30	521	7333	0.0710486840310923	0.288795573564655	0.288795573564655	false	false	false	true	false
4a59e573-5a35-4285-a3a6-38bd2306eeca	2026-08-18 09:50	2026-08-18 09:50	2026-08-18 09:50	XLE	XLE260821C00064000	call	64.0000	2026-08-21	0.3200	0.3200	0.3400	63.2100	16000.00	0.00	16000.00	500	46	931	7461	0.124782200777376	0.274683954426304	0.274683954426304	false	false	false	true	false
0586db5c-9399-4aaa-b9d3-f20a56d64c0a	2026-08-18 09:52	2026-08-18 09:52	2026-08-18 09:52	XLE	XLE280121C00065000	call	65.0000	2028-01-21	7.5000	7.2500	7.5500	63.3050	30000.00	30000.00	0.00	40	10	47	4865	0.00966084275436793	0.21651229870852	0.21651229870852	false	false	false	true	false
7fa59a22-567a-4aaa-8963-c3901093d3b4	2026-08-18 10:03	2026-08-18 10:03	2026-08-18 10:03	XLE	XLE260821C00061000	call	61.0000	2026-08-21	2.3200	2.2800	2.4500	63.2415	324800.00	149872.00	174928.00	1400	16	4758	23626	0.201388301024295	0.27747366189623	0.287131741599003	false	false	false	true	false
3f3ee0fb-cbd4-4a4f-aa79-b8e89e465460	2026-08-18 10:18	2026-08-18 10:18	2026-08-18 10:18	XLE	XLE260821C00064000	call	64.0000	2026-08-21	0.3600	0.3400	0.3700	63.3400	124560.00	123300.00	0.00	3460	19	4462	7461	0.598043157753652	0.27315000931104	0.27315000931104	false	false	false	true	false
6682ff96-623a-4879-b4c2-6adf95165947	2026-08-18 10:19	2026-08-18 10:19	2026-08-18 10:19	XLE	XLE270617C00070000	call	70.0000	2027-06-17	3.7000	3.5500	3.7000	63.3850	147988.00	147988.00	0.00	400	6	500	3779	0.132310134956338	0.235581957526384	0.235581957526384	false	false	false	true	false
5ca4ae42-3389-4f4c-9987-a57b168bc55d	2026-08-18 10:20	2026-08-18 10:19	2026-08-18 10:19	XLE	XLE270617C00067500	call	67.5000	2027-06-17	4.4500	4.4000	4.5500	63.3400	44945.00	17355.00	19135.00	101	20	626	20637	0.0303338663565441	0.230187526892906	0.230187526892906	false	false	false	true	false
93763f9c-b968-4a8b-a962-fbaa8540b534	2026-08-18 10:29	2026-08-18 10:29	2026-08-18 10:29	XLE	XLE270617C00067500	call	67.5000	2027-06-17	4.4500	4.4000	4.5000	63.3350	22250.00	6230.00	16020.00	50	14	762	20637	0.0369239715074866	0.23029271745828	0.23029271745828	false	false	false	true	false
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
56c2c2f6-b1c6-4be5-af88-61e87e7176a6	2026-08-18 10:34	2026-08-18 10:34	2026-08-18 10:34	XLE	XLE260821C00060000	call	60.0000	2026-08-21	3.3700	3.3500	3.5000	63.3700	23600.00	0.00	23600.00	70	7	269	58943	0.00456373106221265	0.458538774805522	0.323312904952659	false	false	false	true	false
1dd06316-b302-4198-bd09-31642cf574b9	2026-08-18 10:46	2026-08-18 10:46	2026-08-18 10:46	XLE	XLE260918C00061000	call	61.0000	2026-09-18	3.1500	3.1500	3.3500	63.1550	22050.00	0.00	22050.00	70	7	456	18321	0.0248894710987392	0.239384540981596	0.239384540981596	false	false	false	true	false
d55aab66-ab2b-461d-8ad1-080f287aa81a	2026-08-18 11:08	2026-08-18 11:08	2026-08-18 11:08	XLE	XLE261120C00065000	call	65.0000	2026-11-20	2.6500	2.5400	2.6500	63.2700	13225.00	6625.00	6600.00	50	6	365	11941	0.0305669541914413	0.244892267017839	0.244892267017839	false	false	false	true	false
fd28cc1f-e935-4f87-9b9c-b39f72463a0e	2026-08-18 11:10	2026-08-18 11:10	2026-08-18 11:10	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.2100	1.1900	1.2100	63.3000	244541.00	244541.00	0.00	2021	21	4339	52434	0.0827516496929473	0.249948895784449	0.249948895784449	false	false	false	true	false
58df9fa0-8cb5-41dc-b618-46de42785a82	2026-08-18 11:31	2026-08-18 11:31	2026-08-18 11:31	XLE	XLE260918C00061000	call	61.0000	2026-09-18	3.5000	3.4000	3.5500	63.5250	285235.00	285235.00	0.00	815	40	1291	18321	0.0704655859396321	0.252560348716274	0.250905217808507	false	false	false	true	false
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	false
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	false
a10565e9-eeac-4995-bf2b-abcaed1f43a7	2026-08-18 11:40	2026-08-18 11:40	2026-08-18 11:40	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.2200	1.2000	1.2200	63.3300	263398.00	263398.00	0.00	2159	7	7264	52434	0.138536064385704	0.249709486195521	0.249709486195521	false	false	false	true	false
e9dfb32c-2b54-44eb-b658-e00ee045847c	2026-08-18 11:46	2026-08-18 11:46	2026-08-18 11:46	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.2500	1.2400	1.2500	63.4000	90875.00	90875.00	0.00	727	17	8012	52434	0.152801617271236	0.250049916555444	0.250049916555444	false	false	false	true	false
44dd0fe0-afcf-4770-b346-799c92b37e2d	2026-08-18 11:53	2026-08-18 11:53	2026-08-18 11:53	XLE	XLE261218P00064000	put	64.0000	2026-12-18	3.7500	3.7500	3.8000	63.4850	15750.00	0.00	15750.00	42	8	122	6	20.3333333333333	0.267988404653951	0.267988404653951	false	false	false	true	false
c58a06d8-bd21-4e5e-ae48-d060a2f5753a	2026-08-18 12:01	2026-08-18 12:01	2026-08-18 12:01	XLE	XLE260904P00063500	put	63.5000	2026-09-04	1.2800	1.2700	1.2900	63.5100	145024.00	64640.00	0.00	1133	10	1199	0	0	0.245346082943485	0.245346082943485	false	false	false	true	false
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	false
789ca7a9-c004-48f3-913b-e1cee598e690	2026-08-18 13:02	2026-08-18 13:02	2026-08-18 13:02	XLE	XLE261218C00065000	call	65.0000	2026-12-18	3.2500	3.2000	3.3000	63.4700	64025.00	325.00	62725.00	197	21	849	39260	0.0216250636780438	0.243356618159515	0.243356618159515	true	false	false	true	false
f18bcdb0-ad4b-4d38-994f-ac41a94d6cd2	2026-08-18 13:02	2026-08-18 13:02	2026-08-18 13:02	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.2000	4.1000	4.3000	63.4600	12600.00	2100.00	8400.00	30	11	192	58448	0.00328497125650151	0.253785108500431	0.253785108500431	false	false	false	true	false
ebd361dd-4f18-4640-b9c3-cd9db21c5fe4	2026-08-18 13:03	2026-08-18 13:03	2026-08-18 13:03	XLE	XLE261218C00065000	call	65.0000	2026-12-18	3.2500	3.2000	3.3000	63.4800	55900.00	0.00	55575.00	172	12	1207	39260	0.0307437595517066	0.243016357528456	0.243016357528456	true	false	false	true	false
32bc8c15-555c-45be-846a-a696e0adbb2d	2026-08-18 13:04	2026-08-18 13:03	2026-08-18 13:03	XLE	XLE261218C00065000	call	65.0000	2026-12-18	3.2500	3.2500	3.3000	63.4850	187200.00	0.00	187200.00	576	27	1890	39260	0.0481406011207336	0.242846154009789	0.242846154009789	true	false	false	true	false
431ee081-becd-4291-a1c3-d272cab48ddf	2026-08-18 13:08	2026-08-18 13:08	2026-08-18 13:08	XLE	XLE261218C00065000	call	65.0000	2026-12-18	3.2500	3.2500	3.3000	63.4850	104000.00	0.00	104000.00	320	16	2332	39260	0.0593988792664289	0.242846154009789	0.242846154009789	true	false	false	true	false
395c9a72-06ca-403a-8c99-87b6d705cf46	2026-08-18 13:15	2026-08-18 13:15	2026-08-18 13:15	XLE	XLE260821P00062000	put	62.0000	2026-08-21	0.1300	0.1100	0.1400	63.5050	30667.00	24583.00	4953.00	2359	32	4195	4800	0.873958333333333	0.270167347109441	0.270167347109441	true	false	false	true	false
a27ddda6-2150-4b61-becc-f656774114ad	2026-08-18 13:29	2026-08-18 13:29	2026-08-18 13:29	XLE	XLE260824P00063000	put	63.0000	2026-08-24	0.5000	0.4500	0.5100	63.4750	37500.00	37500.00	0.00	750	11	760	0	0	0.225278405395178	0.225278405395178	true	false	false	true	false
8cf183dd-e964-4e91-a667-9c3900715296	2026-08-18 13:54	2026-08-18 13:53	2026-08-18 13:53	XLE	XLE260918C00070000	call	70.0000	2026-09-18	0.2800	0.2700	0.2800	63.5400	10780.00	10780.00	0.00	385	8	738	14083	0.0524036071859689	0.264603268969285	0.264603268969285	false	false	false	true	false
f65b0a6a-bc96-48d2-834f-7e830753b297	2026-08-18 13:56	2026-08-18 13:56	2026-08-18 13:56	XLE	XLE260831P00063000	put	63.0000	2026-08-31	0.8400	0.8300	0.8500	63.4900	110880.00	109872.00	0.00	1320	17	1495	0	0	0.231971897228205	0.231971897228205	false	false	false	true	false
cce11cd1-b7fb-4364-9b9f-135609b10c0b	2026-08-18 14:01	2026-08-18 14:01	2026-08-18 14:01	XLE	XLE260925C00070000	call	70.0000	2026-09-25	0.3500	0.3000	0.4000	63.5250	12810.00	0.00	12775.00	366	12	368	28	13.1428571428571	0.254368984147169	0.254368984147169	true	false	false	true	false
49f64f4d-aea5-4553-bacf-f846909f79d0	2026-08-18 15:10	2026-08-18 15:09	2026-08-18 15:09	XLE	XLE260821P00062000	put	62.0000	2026-08-21	0.1400	0.1300	0.1400	63.5800	42000.00	42000.00	0.00	3000	41	7241	4800	1.50854166666667	0.285877648107219	0.285877648107219	false	false	false	true	false
94b13e02-e264-429d-a398-f1553e19ba20	2026-08-18 15:23	2026-08-18 15:23	2026-08-18 15:23	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.3700	1.3500	1.3700	63.6250	13700.00	13700.00	0.00	100	7	13586	52434	0.259106686501125	0.253995821882715	0.253995821882715	false	false	false	true	false
3216c948-61ca-4911-9643-9c243bcd1041	2026-08-18 15:24	2026-08-18 15:24	2026-08-18 15:24	XLE	XLE260821P00062000	put	62.0000	2026-08-21	0.1500	0.1400	0.1500	63.6100	20340.00	20340.00	0.00	1356	27	8600	4800	1.79166666666667	0.296391008106825	0.296391008106825	false	false	false	true	false
827eb64f-908d-46c1-b07d-3fad621046b0	2026-08-18 15:26	2026-08-18 15:26	2026-08-18 15:26	XLE	XLE260918P00061000	put	61.0000	2026-09-18	0.7800	0.7700	0.7800	63.5800	49218.00	49218.00	0.00	631	17	1116	9275	0.120323450134771	0.255381383212764	0.255381383212764	false	false	false	true	false
2cffb970-1e45-4e6e-8208-16affaa3ba6b	2026-08-18 15:28	2026-08-18 15:28	2026-08-18 15:28	XLE	XLE260918P00059000	put	59.0000	2026-09-18	0.3700	0.3500	0.3700	63.6200	182244.00	182244.00	0.00	4920	53	5151	10765	0.478495123084069	0.262470056959329	0.262640984324955	true	false	false	true	false
177a51c9-11da-428c-96ed-8198a2cd3fd5	2026-08-18 15:32	2026-08-18 15:32	2026-08-18 15:32	XLE	XLE260918P00060000	put	60.0000	2026-09-18	0.5600	0.5300	0.5600	63.5600	132327.00	132272.00	55.00	2363	61	3232	22389	0.144356603689312	0.26041334024593	0.26041334024593	false	false	false	true	false
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	false
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	false
e6fe8229-0ad9-4a66-b806-07abdef9cd53	2026-08-18 15:43	2026-08-18 15:43	2026-08-18 15:43	XLE	XLE261120C00065000	call	65.0000	2026-11-20	2.8500	2.7700	2.8500	63.6181	17364.00	17080.00	284.00	61	16	16348	11941	1.36906456745666	0.246694157986168	0.246694157986168	true	false	false	true	false
3a8c08c4-06db-49c9-b497-2ff2d322db58	2026-08-18 15:45	2026-08-18 15:45	2026-08-18 15:45	XLE	XLE260821C00061000	call	61.0000	2026-08-21	2.7100	2.7100	2.7300	63.6450	13279.00	0.00	13279.00	49	5	5666	23626	0.239820536696859	0.305905226028225	0.305905226028225	false	false	false	true	false
6388b27c-bc21-4e9f-a001-93641382a5bf	2026-08-18 15:46	2026-08-18 15:46	2026-08-18 15:46	XLE	XLE260821C00061000	call	61.0000	2026-08-21	2.7100	2.6400	2.8500	63.0000	16260.00	0.00	11382.00	60	6	5726	23626	0.242360111741302	0.305905226028225	0.305905226028225	false	false	false	true	false
06eddbf7-b259-4b5b-88ba-b6cd2b857fb9	2026-08-18 15:49	2026-08-18 15:49	2026-08-18 15:49	XLE	XLE261218C00060000	call	60.0000	2026-12-18	6.1000	6.0000	6.1000	63.0000	91500.00	91500.00	0.00	150	5	561	59300	0.00946037099494098	0.241592503950793	0.241592503950793	false	false	false	true	false
db254f55-d6e1-49ee-acd8-1075c9da772f	2026-08-18 15:56	2026-08-18 15:56	2026-08-18 15:56	XLE	XLE261016C00060000	call	60.0000	2026-10-16	4.8800	4.7500	4.9500	63.0000	21472.00	21472.00	0.00	44	6	201	29197	0.00688426893173956	0.231559424474347	0.231559424474347	false	false	false	true	false
a35141e3-aef8-46f3-b1e7-1aae944243c6	2026-08-19 09:33	2026-08-19 09:33	2026-08-19 09:33	XLE	XLE261120C00065000	call	65.0000	2026-11-20	2.8800	2.8800	2.9300	63.7600	13536.00	0.00	13536.00	47	5	128	26800	0.00477611940298507	0.245989904394069	0.245989904394069	false	false	false	true	false