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×endpoint = /api/option-trades/flow-alerts×ticker = XLE×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strike

6b55b7df-5985-46ca-9cae-2994a73e98cd	2026-09-30 15:52	2026-09-30 15:52	2026-09-30 15:52	XLE	XLE270115C00060000	call	60.0000	2027-01-15	4.3000	4.3000	4.4000	61.0000	115670.00	0.00	115670.00	269	7	361	26325	0.013713200379867	0.232721179119952	0.232721179119952	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	39467823072.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T19:54:17.966040Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
d3f04fa2-226b-4e38-9cc4-dcc55a763689	2026-09-30 15:51	2026-09-30 15:51	2026-09-30 15:51	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	3.0000	3.0500	61.0000	15250.00	15250.00	0.00	50	11	819	17504	0.0467893053016453	0.259342612673438	0.259342612673438	true	false	false
87faca88-6762-42c0-ad04-2d3c9a4790a3	2026-09-30 15:51	2026-09-30 15:51	2026-09-30 15:51	XLE	XLE261218C00062500	call	62.5000	2026-12-18	2.7300	2.7300	2.7800	61.0000	14196.00	0.00	14196.00	52	7	432	36036	0.011988011988012	0.260234080974042	0.260234080974042	false	false	false
eb0bda83-e646-4d51-bfe4-274864978ab4	2026-09-30 15:51	2026-09-30 15:51	2026-09-30 15:51	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	3.0000	3.0500	61.0000	24095.00	24095.00	0.00	79	16	715	17504	0.0408478062157221	0.25910949925144	0.25910949925144	false	false	false
6b970b82-7fb0-48aa-8538-d26eeef82516	2026-09-30 15:51	2026-09-30 15:51	2026-09-30 15:51	XLE	XLE261218C00062500	call	62.5000	2026-12-18	2.7300	2.7300	2.7800	61.0000	12012.00	0.00	12012.00	44	9	380	36036	0.0105450105450105	0.260234080974042	0.260234080974042	false	false	false
b3c9788c-6298-492a-8501-68c3e06795d3	2026-09-30 15:50	2026-09-30 15:50	2026-09-30 15:50	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	3.0000	3.0500	61.0000	19215.00	19215.00	0.00	63	14	551	17504	0.0314785191956124	0.259691978585763	0.259691978585763	false	false	false
b38c17ca-3ddf-45e1-aca9-6ad9ccc50ccf	2026-09-30 15:50	2026-09-30 15:50	2026-09-30 15:50	XLE	XLE261218C00062500	call	62.5000	2026-12-18	2.7500	2.7200	2.7500	61.0000	15125.00	15125.00	0.00	55	8	336	36036	0.00932400932400932	0.260678199549316	0.260678199549316	false	false	false
248c4c64-7ff9-413f-8395-5c11e9c2079f	2026-09-30 15:49	2026-09-30 15:49	2026-09-30 15:49	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	3.0000	3.0500	61.5200	18605.00	18605.00	0.00	61	12	467	17504	0.0266796160877514	0.261433373335245	0.261433373335245	false	false	false
d79f92ca-275d-4210-a48b-6fc4027e22ab	2026-09-30 15:33	2026-09-30 15:33	2026-09-30 15:33	XLE	XLE270331C00069000	call	69.0000	2027-03-31	2.0200	2.0200	2.3300	61.4950	16362.00	0.00	16362.00	81	17	165	14	11.7857142857143	0.240753723210121	0.240753723210121	false	false	false
2d90dfd1-4f7b-4366-9e13-8e73ba3598c0	2026-09-30 15:33	2026-09-30 15:33	2026-09-30 15:33	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	3.0000	3.0500	61.4950	19215.00	19215.00	0.00	63	12	395	17504	0.0225662705667276	0.260853909949995	0.260853909949995	false	false	false
265229f0-1324-452b-b99d-76b29b5b5362	2026-09-30 15:32	2026-09-30 15:32	2026-09-30 15:32	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	2.9100	3.0500	61.5400	19215.00	19215.00	0.00	63	12	283	17504	0.0161677330895795	0.261896228054209	0.261896228054209	false	false	false
59ce4283-827c-4632-a326-cb04ab43fcb7	2026-09-30 15:32	2026-09-30 15:32	2026-09-30 15:32	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	2.9100	3.0500	61.5550	18910.00	18910.00	0.00	62	14	204	17504	0.011654478976234	0.262242953295358	0.262242953295358	false	false	false
98ac7272-a75f-4de6-975d-202a9e416831	2026-09-30 15:31	2026-09-30 15:31	2026-09-30 15:31	XLE	XLE261120C00058000	call	58.0000	2026-11-20	4.8500	4.8500	5.1000	61.5850	28130.00	0.00	28130.00	58	11	62	722	0.0858725761772853	0.269542432606728	0.269542432606728	false	false	false
2caa36d0-743a-4fab-a058-350e4837134b	2026-09-30 15:31	2026-09-30 15:31	2026-09-30 15:31	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	2.9000	3.0500	61.5850	19215.00	19215.00	0.00	63	13	128	17504	0.00731261425959781	0.262935339722244	0.262935339722244	false	false	false
9ccdcbcc-827f-452d-a530-14862e54d7d6	2026-09-30 15:30	2026-09-30 15:30	2026-09-30 15:30	XLE	XLE270319P00060000	put	60.0000	2027-03-19	3.0500	2.9000	3.0500	61.6300	19215.00	19215.00	0.00	63	13	65	17504	0.00371343692870201	0.263971276814313	0.263971276814313	false	false	false
02b05e47-883a-4625-8236-c606af86233e	2026-09-30 14:59	2026-09-30 14:59	2026-09-30 14:59	XLE	XLE261218C00062500	call	62.5000	2026-12-18	2.9500	2.9500	2.9600	61.8400	39530.00	0.00	39530.00	134	6	244	36036	0.00677100677100677	0.260803711893559	0.260803711893559	true	false	false
0d793a6e-bee1-4a68-aa0e-49b5c96f64c9	2026-09-30 13:36	2026-09-30 13:36	2026-09-30 13:36	XLE	XLE270115C00067500	call	67.5000	2027-01-15	1.5800	1.5800	1.6000	62.0000	74734.00	0.00	74734.00	473	33	619	9976	0.0620489174017642	0.245758007781165	0.245758007781165	false	false	false
f520c35d-7f5a-488b-873b-2cd5ea793213	2026-09-30 13:34	2026-09-30 13:34	2026-09-30 13:34	XLE	XLE270617C00067500	call	67.5000	2027-06-17	3.6000	3.5500	3.6000	62.0350	15120.00	15120.00	0.00	42	7	72	24208	0.00297422339722406	0.237344349069959	0.237344349069959	false	false	false
acada18b-6521-4351-9bfd-f9e4811e8048	2026-09-30 13:01	2026-09-30 13:01	2026-09-30 13:01	XLE	XLE261009C00063000	call	63.0000	2026-10-09	0.5700	0.5600	0.5900	62.0000	19551.00	0.00	18810.00	343	22	461	605	0.76198347107438	0.247187641412884	0.247187641412884	false	false	false
db59259a-ab49-4a89-b925-069dd4fac239	2026-09-30 12:55	2026-09-30 12:55	2026-09-30 12:55	XLE	XLE270115C00067500	call	67.5000	2027-01-15	1.5900	1.5900	1.6200	62.0000	20511.00	0.00	20511.00	129	7	146	9976	0.014635124298316	0.246593853278418	0.246593853278418	false	false	false
8882f033-0532-48f9-b588-624eb4d9c9e2	2026-09-30 12:06	2026-09-30 12:06	2026-09-30 12:06	XLE	XLE261016C00064000	call	64.0000	2026-10-16	0.5800	0.5700	0.5800	61.9950	29000.00	29000.00	0.00	500	42	3051	7951	0.383725317570117	0.250194036088598	0.250194036088598	true	false	false
b0ca89f3-9829-45f1-bf46-8ee06e9da843	2026-09-30 12:02	2026-09-30 12:02	2026-09-30 12:02	XLE	XLE261016C00064000	call	64.0000	2026-10-16	0.5700	0.5600	0.5800	61.9400	75582.00	27132.00	48450.00	1326	20	2551	7951	0.320840145893598	0.250879714054336	0.251530019048581	true	false	false
ecec6f11-beb6-44f1-98d4-e93fc89188c1	2026-09-30 11:55	2026-09-30 11:55	2026-09-30 11:55	XLE	XLE261009P00059500	put	59.5000	2026-10-09	0.2200	0.2200	0.2300	61.0000	20614.00	0.00	20614.00	937	15	1000	2509	0.398565165404544	0.26870983134581	0.26870983134581	false	false	false
2f9898da-057d-4fe8-8079-0a1db8a2ca56	2026-09-30 11:55	2026-09-30 11:55	2026-09-30 11:55	XLE	XLE261016C00064000	call	64.0000	2026-10-16	0.5700	0.5600	0.5800	61.0000	19266.00	5187.00	14079.00	338	7	1201	7951	0.151050182366998	0.25002705868367	0.25002705868367	true	false	false
c36817f9-8ce7-4e0d-bca8-10ca5536d60f	2026-09-30 11:53	2026-09-30 11:53	2026-09-30 11:53	XLE	XLE261016C00064000	call	64.0000	2026-10-16	0.5700	0.5600	0.5800	62.0000	23313.00	21717.00	1596.00	409	12	766	7951	0.0963400830084266	0.245986279037614	0.245986279037614	true	false	false
47c59f99-e53b-493c-a698-a111f48a8a34	2026-09-30 11:30	2026-09-30 11:30	2026-09-30 11:30	XLE	XLE270115P00062500	put	62.5000	2027-01-15	3.5000	3.5000	3.5500	61.9500	116550.00	0.00	116550.00	333	17	379	3322	0.114087898856111	0.270924926648012	0.270924926648012	false	false	false
3f4640db-bf7f-4fc9-aa19-cde61e8f8fb8	2026-09-30 10:49	2026-09-30 10:49	2026-09-30 10:49	XLE	XLE261009P00059000	put	59.0000	2026-10-09	0.2000	0.2000	0.2200	61.7350	14540.00	0.00	14540.00	727	43	732	3355	0.218181818181818	0.280267962432218	0.280267962432218	false	false	false
61dd7bc0-a652-4061-881b-d17beef330b1	2026-09-30 10:34	2026-09-30 10:34	2026-09-30 10:34	XLE	XLE261120C00066000	call	66.0000	2026-11-20	1.0400	1.0300	1.0700	61.8100	187096.00	14456.00	172640.00	1799	29	2132	1060	2.01132075471698	0.262737720319449	0.262737720319449	false	false	false
fb5f344d-18fa-4b63-8aa2-fb9bbc0f0799	2026-09-30 10:30	2026-09-30 10:30	2026-09-30 10:30	XLE	XLE270319P00062000	put	62.0000	2027-03-19	4.0000	3.7000	4.0000	61.7700	23200.00	23200.00	0.00	58	6	437	4209	0.103825136612022	0.269573769562432	0.269573769562432	false	false	false
4d29f35c-75e9-4a3a-b1a0-ed116711f2b7	2026-09-30 10:22	2026-09-30 10:22	2026-09-30 10:22	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.8700	1.8700	1.9700	61.8550	23001.00	0.00	23001.00	123	5	137	35590	0.00384939589772408	0.247224069243425	0.247224069243425	false	false	false
ed85aff4-ff3e-41c4-8ab1-597305a3a460	2026-09-30 10:15	2026-09-30 10:15	2026-09-30 10:15	XLE	XLE261120C00066000	call	66.0000	2026-11-20	1.0100	1.0000	1.0100	61.6550	10100.00	10100.00	0.00	100	19	310	1060	0.292452830188679	0.264537557401514	0.264537557401514	false	false	false
9ba72736-e12c-4ab0-92e7-246cc90773c9	2026-09-30 10:12	2026-09-30 10:12	2026-09-30 10:12	XLE	XLE270319P00062000	put	62.0000	2027-03-19	4.0500	4.0000	4.0500	61.0000	17010.00	17010.00	0.00	42	5	42	4209	0.00997861724875267	0.268432281811874	0.268432281811874	false	false	false
0dfa7710-b943-4dfa-a79d-dec2f6e89a3c	2026-09-30 10:10	2026-09-30 10:10	2026-09-30 10:10	XLE	XLE261218C00055000	call	55.0000	2026-12-18	7.8000	7.8000	8.1500	61.6400	91260.00	0.00	91260.00	117	6	117	4136	0.0282882011605416	0.274171405219545	0.274171405219545	false	false	false
344ded02-1772-46eb-9384-041ffcfdc858	2026-09-30 10:09	2026-09-30 10:09	2026-09-30 10:09	XLE	XLE261005P00061000	put	61.0000	2026-10-05	0.4000	0.4000	0.4300	61.0000	11360.00	0.00	11360.00	284	23	333	211	1.5781990521327	0.246297806824428	0.246297806824428	false	false	false
a6e7e863-57e0-4ee7-b241-9c7ab9ad0b9d	2026-09-30 09:50	2026-09-30 09:50	2026-09-30 09:50	XLE	XLE261016P00060500	put	60.5000	2026-10-16	0.6800	0.6700	0.6800	61.0000	20060.00	20060.00	0.00	295	16	372	2472	0.150485436893204	0.258648290906223	0.258648290906223	false	false	false
1dffd5c3-be85-4d5a-99a5-2a4c9df975b6	2026-09-30 09:32	2026-09-30 09:32	2026-09-30 09:32	XLE	XLE261120P00059000	put	59.0000	2026-11-20	1.1500	1.1500	1.1600	61.8200	13570.00	0.00	13570.00	118	22	119	25973	0.00458168097639857	0.26828962128194	0.26828962128194	false	false	false
a5accd82-f55f-464f-bcba-8b1f1529b864	2026-09-29 15:22	2026-09-29 15:22	2026-09-29 15:22	XLE	XLE270115C00070000	call	70.0000	2027-01-15	0.9900	0.9900	1.0400	61.0000	33264.00	0.00	33264.00	336	24	807	19869	0.0406160350294429	0.254373421954249	0.254373421954249	false	false	false
0c8adc44-7779-4fef-b770-06339bb96019	2026-09-29 15:13	2026-09-29 15:13	2026-09-29 15:13	XLE	XLE261016P00060500	put	60.5000	2026-10-16	0.9600	0.9500	0.9800	61.3300	14208.00	1056.00	12960.00	148	24	3577	3528	1.01388888888889	0.263577771612909	0.263577771612909	true	false	false
c9589df6-a585-47d3-9177-0d30b6c98775	2026-09-29 15:03	2026-09-29 15:03	2026-09-29 15:03	XLE	XLE270115C00070000	call	70.0000	2027-01-15	1.0000	1.0000	1.0100	61.3010	10800.00	0.00	10800.00	108	24	387	19869	0.019477578136796	0.25846960172269	0.25846960172269	false	false	false
7384671d-38ba-4111-bc2c-6b97930eb31f	2026-09-29 14:56	2026-09-29 14:55	2026-09-29 14:55	XLE	XLE261218C00066000	call	66.0000	2026-12-18	1.5100	1.5100	1.5600	61.2800	22650.00	0.00	22650.00	150	19	1016	3228	0.314745972738538	0.266159889005916	0.266159889005916	false	false	false
2429411b-e041-45bb-a223-89392f1b99dc	2026-09-29 14:51	2026-09-29 14:51	2026-09-29 14:51	XLE	XLE260930P00065000	put	65.0000	2026-09-30	3.7000	3.6000	3.7000	61.3000	18500.00	18500.00	0.00	50	19	53	587	0.0902896081771721	0.499016411870484	0.499016411870484	false	false	false
754e21b7-7892-4967-94f7-2932a3eda7b4	2026-09-29 14:40	2026-09-29 14:40	2026-09-29 14:40	XLE	XLE270319P00055000	put	55.0000	2027-03-19	1.4500	1.4400	1.4900	61.0000	46690.00	27115.00	19575.00	322	6	639	22627	0.0282405975162417	0.26603333789865	0.26603333789865	false	false	false
9047144e-9145-431e-9160-c1b6b855091f	2026-09-29 14:40	2026-09-29 14:40	2026-09-29 14:40	XLE	XLE270319P00055000	put	55.0000	2027-03-19	1.4500	1.4400	1.4500	61.0000	16385.00	16385.00	0.00	113	22	317	22627	0.0140098112874	0.266206542439209	0.266206542439209	false	false	false
fc373770-b192-45ef-81b3-6e92430dbce3	2026-09-29 14:39	2026-09-29 14:39	2026-09-29 14:39	XLE	XLE261016P00059000	put	59.0000	2026-10-16	0.5300	0.5100	0.5300	61.0000	35987.00	35987.00	0.00	679	54	1053	15775	0.0667511885895404	0.281599041607553	0.281599041607553	true	false	false
ea92d7e5-fb70-4473-b8af-580f1ae8f55d	2026-09-29 14:39	2026-09-29 14:39	2026-09-29 14:39	XLE	XLE261009P00061500	put	61.5000	2026-10-09	1.1200	1.0200	1.1300	61.0000	10304.00	2352.00	0.00	92	8	134	961	0.139438085327784	0.274060936671695	0.274060936671695	true	false	false
a3488366-b706-4b2d-ae63-87e203411014	2026-09-29 14:38	2026-09-29 14:38	2026-09-29 14:38	XLE	XLE261009P00059000	put	59.0000	2026-10-09	0.3100	0.3000	0.3100	61.0000	16120.00	16120.00	0.00	520	17	1954	1145	1.70655021834061	0.289419349733217	0.289419349733217	true	false	false
61b31c25-4e88-45c3-934a-30d352be583a	2026-09-29 14:37	2026-09-29 14:37	2026-09-29 14:37	XLE	XLE261218C00066000	call	66.0000	2026-12-18	1.5600	1.5500	1.5800	61.0000	14040.00	0.00	14040.00	90	29	790	3228	0.244733581164808	0.265615707152801	0.265615707152801	false	false	false
77a137c1-7159-49cd-a3e0-10102d0790c1	2026-09-29 14:20	2026-09-29 14:20	2026-09-29 14:20	XLE	XLE280121C00055000	call	55.0000	2028-01-21	11.4500	11.1500	11.4500	61.0000	13740.00	13740.00	0.00	12	11	27	1199	0.0225187656380317	0.189685175399984	0.189685175399984	false	false	false
56ab41b5-4278-4fc2-908f-cca9ad0e8d07	2026-09-29 14:06	2026-09-29 14:06	2026-09-29 14:06	XLE	XLE261218C00066000	call	66.0000	2026-12-18	1.5800	1.5700	1.6300	61.5300	36498.00	0.00	36498.00	231	37	640	3228	0.198265179677819	0.264982577563896	0.264982577563896	false	false	false
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