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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×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

496d746b-3ccc-4313-b5ab-214b0d821d59	2026-09-22 12:23	2026-09-22 12:23	2026-09-22 12:23	XLE	XLE261016P00062000	put	62.0000	2026-10-16	1.2800	1.2700	1.2800	62.5600	118619.00	65152.00	53467.00	930	30	1344	23072	0.058252427184466	0.253870689622065	0.253870689622065	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	40021937894.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T16:27:20.551854Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
1bbbb05f-4a79-4cd3-8f40-22eea9fdb494	2026-09-22 09:32	2026-09-22 09:31	2026-09-22 09:31	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.2800	2.2800	2.3100	61.7600	137267.00	458.00	136809.00	602	17	1552	47499	0.032674372092044	0.262655039161346	0.264861343457474	false	false	false	true
ae3a91d9-b25e-40bf-8356-5575d189bf97	2026-09-21 14:43	2026-09-21 14:43	2026-09-21 14:43	XLE	XLE261016P00061500	put	61.5000	2026-10-16	1.0400	1.0200	1.0500	62.9600	10729.00	10729.00	0.00	103	7	6287	0	0	0.269147562334123	0.267211600355058	false	false	false	true
ef47f3a1-87ac-4056-9b20-139a6e26c308	2026-09-18 12:52	2026-09-18 12:52	2026-09-18 12:52	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.4100	4.3000	4.4500	64.3850	55110.00	55110.00	0.00	125	17	427	54198	0.00787851950256467	2.33833848121036	1.79127374611761	false	false	false	true
1e1da5e6-51d6-4066-9a19-f10056006ad0	2026-09-18 11:59	2026-09-18 11:59	2026-09-18 11:59	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.6700	4.5500	4.7000	64.6850	18688.00	18688.00	0.00	40	5	281	54198	0.0051846931621093	1.66486797085075	1.66486797085075	false	false	false	true
dbc1a753-a298-40b8-81dd-272f8fa6d3f4	2026-09-18 09:52	2026-09-18 09:52	2026-09-18 09:52	XLE	XLE281215C00065000	call	65.0000	2028-12-15	10.6600	10.2500	10.7000	64.4500	58623.00	58623.00	0.00	55	6	96	2358	0.0407124681933842	0.200230498249977	0.199940383609416	false	false	false	true
a45ac9c4-019d-4fe9-b6f4-22cc80a615c2	2026-09-18 09:33	2026-09-18 09:33	2026-09-18 09:33	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.7500	1.7400	1.7800	64.3300	12066.00	0.00	12066.00	69	18	107	20908	0.00511765831260761	0.282157326302907	0.281365842102624	true	false	false	true
73d61f13-5c38-45ac-b1ae-cf03ff580604	2026-09-17 11:15	2026-09-17 11:15	2026-09-17 11:15	XLE	XLE260925C00062000	call	62.0000	2026-09-25	2.1700	2.0700	2.1800	63.9250	10858.00	9592.00	1266.00	50	6	113	164	0.689024390243902	0.227982507152337	0.196876041007038	false	false	false	true
89e29de0-5eea-4325-b290-1885a29a545a	2026-09-16 15:51	2026-09-16 15:51	2026-09-16 15:51	XLE	XLE260918P00065000	put	65.0000	2026-09-18	1.1200	1.1100	1.1400	64.0000	26853.00	12208.00	14645.00	240	20	9519	19544	0.487054850593533	0.292521597093496	0.286031056119285	true	false	false	true
d23359a4-79e4-4005-8475-6e24376604c6	2026-09-16 15:44	2026-09-16 15:44	2026-09-16 15:44	XLE	XLE260918P00065000	put	65.0000	2026-09-18	1.2900	1.2700	1.3100	63.8600	31635.00	4038.00	27597.00	246	19	8370	19544	0.428264428980761	0.308494128654614	0.291384309920827	false	false	false	true
cf089307-1e78-4592-ae73-8214a46e32e9	2026-09-16 15:04	2026-09-16 15:04	2026-09-16 15:04	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5900	2.5200	2.6000	64.1650	13733.00	7258.00	5439.00	53	13	1049	15647	0.0670416054195692	0.279705905242321	0.279066176067639	false	false	false	true
847ad8f7-8123-4e98-a6b0-bcacadad07cf	2026-09-16 12:14	2026-09-16 12:13	2026-09-16 12:13	XLE	XLE260918P00063000	put	63.0000	2026-09-18	0.1300	0.1300	0.1400	64.6500	34399.00	14.00	34385.00	2646	19	9308	16390	0.56790726052471	0.353401203495021	0.34457040708934	false	false	false	true
06b2a2a7-5f79-4093-8685-c44f752cbb66	2026-09-16 11:00	2026-09-16 11:00	2026-09-16 11:00	XLE	XLE270319P00059000	put	59.0000	2027-03-19	2.2300	2.1200	2.2300	64.0850	19176.00	18954.00	222.00	86	20	154	4122	0.0373605046094129	0.276261464156683	0.276261464156683	false	false	false	true
aea3665d-2a34-4be5-9467-6f6d78e537d7	2026-09-16 09:31	2026-09-16 09:31	2026-09-16 09:31	XLE	XLE260918P00064500	put	64.5000	2026-09-18	0.4700	0.4600	0.5600	64.9400	12419.00	1833.00	10586.00	263	20	269	2710	0.0992619926199262	0.350003502613861	0.352028666836524	true	false	false	true
139a7c7c-cda4-40c9-8d82-91b71615a1e6	2026-09-15 13:42	2026-09-15 13:41	2026-09-15 13:41	XLE	XLE261002C00063000	call	63.0000	2026-10-02	3.4000	3.2000	3.4000	65.9989	17336.00	17336.00	0.00	51	7	51	387	0.131782945736434	0.231642514726355	0.231642514726355	false	false	false	true
7d0df44b-d7ac-4423-a8e9-9b1a6a32cc53	2026-09-15 13:20	2026-09-15 13:20	2026-09-15 13:20	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.0000	1.0000	1.0200	65.8750	50072.00	0.00	43305.00	500	11	7499	38897	0.192791217831709	0.297258205860964	0.295695420893109	false	false	false	true
3fd6e97c-8168-4f29-964d-522df62a3ed6	2026-09-15 12:54	2026-09-15 12:53	2026-09-15 12:53	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.3600	1.3400	1.3700	65.8750	27261.00	27261.00	0.00	200	10	3204	19751	0.162219634448889	0.300655749985885	0.299233545070067	false	false	false	true
a5e6c49a-ed5a-49fe-a24d-2c51b33c4f16	2026-09-15 12:19	2026-09-15 12:19	2026-09-15 12:19	XLE	XLE261023C00066000	call	66.0000	2026-10-23	2.1200	2.1200	2.1900	65.7850	54707.00	0.00	54707.00	258	11	650	1271	0.51140833988985	0.247959403474861	0.246776894293707	false	false	false	true
ce84d2ab-3765-4260-95f2-511264c6ee14	2026-09-14 15:24	2026-09-14 15:24	2026-09-14 15:24	XLE	XLE260916P00065000	put	65.0000	2026-09-16	0.8800	0.8800	0.9500	64.3800	44002.00	0.00	44002.00	500	5	1454	201	7.23383084577114	0.279093723585108	0.279093723585108	false	false	false	true
e334d85c-195e-42b2-adcd-beb0d3cfe053	2026-09-11 12:44	2026-09-11 12:44	2026-09-11 12:44	XLE	XLE261002P00065000	put	65.0000	2026-10-02	1.6600	1.6000	1.7300	65.1450	248994.00	233224.00	15770.00	1500	32	1550	289	5.36332179930796	0.289740369785558	0.289740369785558	false	false	false	true
1b4bac07-9b9e-477e-bb1e-5968255c5ccb	2026-09-11 12:29	2026-09-11 12:29	2026-09-11 12:29	XLE	XLE260918C00057500	call	57.5000	2026-09-18	7.9000	7.7000	7.9500	65.3300	45055.00	45055.00	0.00	57	6	600	11901	0.0504159314343332	0.535559961498652	0.448496988392536	false	false	false	true
410abd56-1f11-41c0-8b5d-099351f2510a	2026-09-11 11:55	2026-09-11 11:55	2026-09-11 11:55	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.2200	2.1800	2.2300	65.2150	74960.00	74960.00	0.00	338	7	2412	43793	0.0550772954581783	0.280036438974399	0.280036438974399	true	false	false	true
aeb5bc72-e1f8-4e32-b948-dac865a19972	2026-09-11 10:43	2026-09-11 10:43	2026-09-11 10:43	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.3000	2.2500	2.3000	64.9250	98662.00	96830.00	1832.00	429	33	487	43793	0.0111204987098395	0.278646853719129	0.277835540959024	true	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
2edd5b02-98cf-4350-8a33-ebe11df4f11c	2026-09-10 13:45	2026-09-10 13:45	2026-09-10 13:45	XLE	XLE260911C00064500	call	64.5000	2026-09-11	0.8100	0.8000	0.9100	65.1450	26952.00	0.00	21039.00	332	24	2386	313	7.62300319488818	0.306836047233875	0.297794509125099	false	false	false	true
6abaeba9-6f55-44e1-8296-052e91ac000c	2026-09-10 11:40	2026-09-10 11:40	2026-09-10 11:40	XLE	XLE260911C00065000	call	65.0000	2026-09-11	0.4500	0.4200	0.4500	65.0090	13448.00	13448.00	0.00	300	18	2245	15800	0.142088607594937	0.327188671028167	0.318321907115013	false	false	false	true
a7f44d00-edad-4411-a1dd-791d9f3e9a86	2026-09-10 11:04	2026-09-10 11:03	2026-09-10 11:03	XLE	XLE260911C00064500	call	64.5000	2026-09-11	0.6200	0.5500	0.6200	64.7300	12354.00	9548.00	0.00	200	15	997	313	3.185303514377	0.365118949890012	0.365118949890012	false	false	false	true
1d5455db-f823-4c9a-a34f-ce2075a97936	2026-09-10 10:56	2026-09-10 10:56	2026-09-10 10:56	XLE	XLE260911C00064500	call	64.5000	2026-09-11	0.6100	0.5500	0.6200	64.7700	18414.00	18414.00	0.00	300	31	345	313	1.10223642172524	0.347283918179232	0.339660882241027	false	false	false	true
01d80cf4-7e73-4897-b62b-10e2983f3937	2026-09-10 09:35	2026-09-10 09:35	2026-09-10 09:35	XLE	XLE270617C00070000	call	70.0000	2027-06-17	4.4000	4.4000	4.5000	65.5805	11003.00	0.00	11003.00	25	5	1125	3142	0.358052196053469	0.234157250182346	0.2337200733937	false	false	false	true
a39664b9-e3b2-4eab-85b5-f157d3bcd5e6	2026-09-10 09:30	2026-09-10 09:30	2026-09-10 09:30	XLE	XLE261218P00060000	put	60.0000	2026-12-18	1.3100	1.0000	1.3200	66.0600	26229.00	11557.00	0.00	200	9	200	48512	0.00412269129287599	0.28937863562855	0.288384825581349	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
a80244e9-4eff-40e7-b6aa-49c754ff7c85	2026-09-09 14:56	2026-09-09 14:56	2026-09-09 14:56	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.3400	1.3100	1.3400	65.4200	53807.00	53807.00	0.00	401	8	1889	47742	0.0395668384231913	0.26762607864195	0.265138011715037	false	false	false	true
f8456c81-22d3-4d88-8ca4-f3d0401f8096	2026-09-09 10:46	2026-09-09 10:45	2026-09-09 10:45	XLE	XLE261016P00062000	put	62.0000	2026-10-16	0.9500	0.9300	0.9500	65.2500	42456.00	23750.00	18706.00	449	18	1637	10633	0.153954669425374	0.28344191408962	0.281944995978245	false	false	false	true
0402860a-310c-498e-87b0-da73b647d9ab	2026-09-09 10:05	2026-09-09 10:05	2026-09-09 10:05	XLE	XLE260911C00065000	call	65.0000	2026-09-11	0.8600	0.8600	0.9200	65.4950	430106.00	0.00	430106.00	5000	12	15511	17790	0.871894322653176	0.30141335938123	0.30141335938123	false	false	false	true
1bc9758f-b7c4-4e6f-abae-c3269c206905	2026-09-08 11:47	2026-09-08 11:46	2026-09-08 11:46	XLE	XLE270319C00066000	call	66.0000	2027-03-19	4.4000	4.4000	4.5500	64.7150	18922.00	0.00	18922.00	43	9	184	594	0.30976430976431	0.23298728517322	0.231914199663403	false	false	false	true
10fd7926-ac12-4f50-bcd1-a9c6df265a10	2026-09-08 10:02	2026-09-08 10:02	2026-09-08 10:02	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.6800	1.6400	1.6900	65.1200	35263.00	35096.00	167.00	210	7	398	696	0.57183908045977	0.279181054807028	0.276697228989457	false	false	false	true
efad0eb6-708e-4183-92f7-557f322b1af0	2026-09-08 09:36	2026-09-08 09:36	2026-09-08 09:36	XLE	XLE261016C00067000	call	67.0000	2026-10-16	1.3300	1.2100	1.3300	65.0700	30189.00	30189.00	0.00	227	11	230	3839	0.0599114352696015	0.242163617434505	0.242163617434505	true	false	false	true
5eb5a209-5a27-4a1d-8b45-c2ef5c09e9de	2026-09-08 09:30	2026-09-08 09:30	2026-09-08 09:30	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.1700	1.0200	1.1800	64.9520	13315.00	12739.00	576.00	114	30	117	48435	0.00241560854753794	0.270818103095133	0.265914454620142	true	false	false	true
7a2177e1-91c5-445c-a6d2-6109ab171f56	2026-09-04 10:33	2026-09-04 10:33	2026-09-04 10:33	XLE	XLE260930P00065000	put	65.0000	2026-09-30	2.2500	2.2000	2.3500	64.1150	11266.00	903.00	3368.00	50	50	102	583	0.174957118353345	0.27760832523838	0.27023666429294	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
98e9f194-a284-4c04-beeb-7dbfb11ea130	2026-09-03 10:18	2026-09-03 10:18	2026-09-03 10:18	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3500	1.3500	1.3600	65.1050	22546.00	136.00	22410.00	167	31	10966	3115	3.52038523274478	0.270356493154601	0.269317577759388	true	false	false	true
256f2bff-b48a-4f47-b602-4a6e9a60f914	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3400	1.3400	1.3500	65.1150	13403.00	405.00	12998.00	100	10	5520	3115	1.77207062600321	0.269722130525043	0.268479217600098	false	false	false	true
ffcb8641-977e-4d8c-9929-d840037b8e18	2026-09-02 15:52	2026-09-02 15:52	2026-09-02 15:52	XLE	XLE261120C00065000	call	65.0000	2026-11-20	3.2500	3.2500	3.3000	65.0800	14629.00	0.00	14629.00	45	5	938	34930	0.0268537074148297	0.245111842404619	0.243439202127309	false	false	false	true
0d984ab9-ea1e-42ab-86dd-9530ae1a27fa	2026-09-01 10:41	2026-09-01 10:41	2026-09-01 10:41	XLE	XLE260918P00063000	put	63.0000	2026-09-18	0.7700	0.7300	0.7800	64.2750	15384.00	15384.00	0.00	200	12	835	2210	0.377828054298643	0.249028136458426	0.245053482116282	false	false	false	true
b4d1409d-d97d-4154-98aa-b81bcbdf8ebb	2026-09-01 10:09	2026-09-01 10:09	2026-09-01 10:09	XLE	XLE261218C00065000	call	65.0000	2026-12-18	3.4600	3.4000	3.5000	64.3300	279887.00	9315.00	270572.00	809	7	905	38566	0.0234662656225691	0.244981098293581	0.244342721723587	false	false	false	true
f25e9073-b92f-45df-8d5f-8dc5baeb91cb	2026-09-01 09:32	2026-09-01 09:31	2026-09-01 09:31	XLE	XLE270115P00057500	put	57.5000	2027-01-15	1.2100	1.0900	1.2200	64.6450	10673.00	10555.00	118.00	88	7	89	4892	0.018192968111202	0.271434730429135	0.27236889916321	true	false	false	true
fd877cb4-101e-46e6-839e-06a9cc715008	2026-08-31 12:12	2026-08-31 12:12	2026-08-31 12:12	XLE	XLE270617C00070000	call	70.0000	2027-06-17	3.3500	3.3500	3.5000	63.1900	335130.00	0.00	335130.00	1000	9	1026	5102	0.20109760878087	0.234698333361503	0.234698333361503	false	false	false	true
b4a5619e-8be7-46d8-9328-da46c124da75	2026-08-31 11:17	2026-08-31 11:17	2026-08-31 11:17	XLE	XLE261120C00070000	call	70.0000	2026-11-20	0.9400	0.9400	1.0000	63.2050	18853.00	0.00	18853.00	200	9	613	18465	0.0331979420525318	0.25029524346535	0.249191864449663	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