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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active: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	strikenumeric	expiry

07726eca-dc68-4baa-82d4-f1ad40710234	2026-09-18 11:11	2026-09-18 11:11	2026-09-18 11:11	XLE	XLE261016P00062000	put	62.0000	2026-10-16	0.8300	0.8300	0.8400	64.6800	10624.00	0.00	10624.00	128	11	463	22918	0.0202024609477267	0.277072904790212	0.277072904790212	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	41804540014.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T15:20:59.279522Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
e17f5232-7726-4e30-86ab-0cb44bd20883	2026-09-18 11:11	2026-09-18 11:10	2026-09-18 11:10	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.1700	1.1600	1.1700	64.6550	11700.00	11700.00	0.00	100	7	1896	46847	0.0404721753794266	0.277875805248985	0.277875805248985	true	false	false	true
51e9d92a-7143-4073-9f07-717da806ffa5	2026-09-18 11:02	2026-09-18 11:02	2026-09-18 11:02	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.5100	1.5100	1.5300	64.5200	23556.00	0.00	23556.00	156	10	5797	11441	0.506686478454681	0.230604109525323	0.230604109525323	true	false	false	true
659578a7-bb34-449b-bcdd-a350133357a9	2026-09-18 10:53	2026-09-18 10:53	2026-09-18 10:53	XLE	XLE261002P00064000	put	64.0000	2026-10-02	1.1600	1.1600	1.1800	64.4800	24128.00	0.00	24128.00	208	8	213	226	0.942477876106195	0.285198098941603	0.285198098941603	true	false	false	true
816c8cea-b4ba-42ee-8f06-a985dd89871e	2026-09-18 10:45	2026-09-18 10:44	2026-09-18 10:44	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.5900	1.5600	1.5900	64.6450	119250.00	119250.00	0.00	750	39	5134	11441	0.448736998514116	0.233202623528917	0.233202623528917	true	false	false	true
eb2451b9-cfcf-4e8c-8e42-1f241af39240	2026-09-18 10:40	2026-09-18 10:39	2026-09-18 10:39	XLE	XLE261218P00065000	put	65.0000	2026-12-18	3.5000	3.5000	3.5500	64.5400	18550.00	0.00	18550.00	53	10	123	2525	0.0487128712871287	0.281502360276606	0.281502360276606	false	false	false	true
5de3655a-7872-48a8-aa09-b62b64b8d3ac	2026-09-18 10:32	2026-09-18 10:32	2026-09-18 10:32	XLE	XLE261120C00060000	call	60.0000	2026-11-20	5.6500	5.5500	5.6500	64.5200	53110.00	53110.00	0.00	94	20	104	6185	0.0168148746968472	0.234860412757024	0.234860412757024	true	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
0bcba707-1e03-4324-8b60-2c674d1bfc42	2026-09-18 10:23	2026-09-18 10:23	2026-09-18 10:23	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.4600	1.4500	1.4700	64.4182	105850.00	88330.00	10804.00	725	27	4237	11441	0.37033476094747	0.230331503937903	0.230452013386362	true	false	false	true
ea8c0674-675c-40dd-b248-ca33545f6a56	2026-09-18 10:21	2026-09-18 10:21	2026-09-18 10:21	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.2600	1.2500	1.2700	64.3600	41328.00	41202.00	126.00	328	9	1343	46847	0.0286677908937605	0.275888880902595	0.275888880902595	false	false	false	true
0f7d6605-a0f5-4b7c-a56b-ed3a645a47c0	2026-09-18 10:21	2026-09-18 10:21	2026-09-18 10:21	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.7100	1.7000	1.7100	64.3600	26311.00	22401.00	3910.00	154	18	377	20908	0.0180313755500287	0.278983240581674	0.278983240581674	false	false	false	true
6dfe34e4-fd80-42f6-9b4a-03cfd85764a2	2026-09-18 10:18	2026-09-18 10:18	2026-09-18 10:18	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.4600	1.4000	1.4700	64.3950	79570.00	78402.00	1168.00	545	17	3474	11441	0.303644786294904	0.232002448367897	0.232002448367897	true	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
335c7e8d-024f-40fe-a5e4-9093a503864c	2026-09-18 09:55	2026-09-18 09:54	2026-09-18 09:54	XLE	XLE270115C00067500	call	67.5000	2027-01-15	2.6100	2.6100	2.7300	64.3000	12006.00	0.00	12006.00	46	8	136	9994	0.0136081648989394	0.244079717867362	0.244079717867362	false	false	false	true
55b2ed3d-d2f9-43de-b36b-90a64be8c79e	2026-09-18 09:54	2026-09-18 09:54	2026-09-18 09:54	XLE	XLE270115C00067500	call	67.5000	2027-01-15	2.6100	2.6100	2.7300	64.3250	11484.00	0.00	11484.00	44	8	90	9994	0.00900540324194517	0.24333582684471	0.24333582684471	false	false	false	true
5d136f84-d1ea-45ae-a1ab-eacd04fe108d	2026-09-18 09:54	2026-09-18 09:54	2026-09-18 09:54	XLE	XLE270115C00067500	call	67.5000	2027-01-15	2.6100	2.6100	2.7300	64.3300	10962.00	0.00	10962.00	42	5	46	9994	0.0046027616569942	0.243186963354734	0.243186963354734	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
6282b9cf-7db0-42c4-baba-703aacd783e9	2026-09-18 09:50	2026-09-18 09:50	2026-09-18 09:50	XLE	XLE290119C00070000	call	70.0000	2029-01-19	8.8000	8.4500	8.8500	64.4700	68666.00	68666.00	0.00	78	5	78	0	0	0.204161740244507	0.204161740244507	false	false	false	true
03b6bbac-f9b6-4c97-8bf7-4a81c1e35e58	2026-09-18 09:49	2026-09-18 09:49	2026-09-18 09:49	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.4700	2.4700	2.6100	64.4300	14576.00	0.00	14576.00	59	6	59	15668	0.00376563696706663	0.277500519588498	0.279447309426473	false	false	false	true
2ad5427b-f25b-4975-bbd6-9c951a09a446	2026-09-18 09:43	2026-09-18 09:43	2026-09-18 09:43	XLE	XLE261023C00065000	call	65.0000	2026-10-23	1.7000	1.6400	1.7200	64.4050	72080.00	72080.00	0.00	424	6	424	84	5.04761904761905	0.233878438907425	0.233878438907425	true	false	false	true
6c72e692-0ebb-48a5-a33c-3992a86c57fb	2026-09-18 09:35	2026-09-18 09:35	2026-09-18 09:35	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.2800	0.2700	0.2800	64.2700	60228.00	60228.00	0.00	2151	11	2232	27029	0.082577971808058	0.253862723528101	0.253862723528101	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
6d7059c8-4afc-48a1-a456-3ebe2c79526b	2026-09-17 15:54	2026-09-17 15:54	2026-09-17 15:54	XLE	XLE260918C00064500	call	64.5000	2026-09-18	0.3300	0.3200	0.3400	64.0000	33033.00	21285.00	0.00	1001	6	1690	2832	0.596751412429379	0.260676090026938	0.258983332687011	false	false	false	true
c9f8da59-0672-4b92-b530-2e212c93965c	2026-09-17 15:53	2026-09-17 15:53	2026-09-17 15:53	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.4200	2.4200	2.4800	64.0000	15488.00	0.00	15488.00	64	17	175	60252	0.00290446790148045	0.283198803489224	0.283198803489224	false	false	false	true
fc2a57da-b164-4e17-a8cc-47da87fb4d3c	2026-09-17 15:51	2026-09-17 15:51	2026-09-17 15:51	XLE	XLE260918P00064000	put	64.0000	2026-09-18	0.1800	0.1700	0.1800	64.0000	16974.00	16974.00	0.00	943	5	1905	18024	0.10569241011984	0.262114579634707	0.262114579634707	true	false	false	true
634bd772-4a5a-41fe-9070-39b0171c1356	2026-09-17 15:47	2026-09-17 15:47	2026-09-17 15:47	XLE	XLE260925P00064000	put	64.0000	2026-09-25	0.9400	0.9300	0.9400	64.4150	92966.00	92966.00	0.00	989	27	1299	1135	1.14449339207048	0.306077398018323	0.306077398018323	false	false	false	true
2bceeb8b-019e-4e16-8865-d6709ed63b1f	2026-09-17 15:40	2026-09-17 15:40	2026-09-17 15:40	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.4200	2.4200	2.4800	64.4450	12584.00	0.00	12584.00	52	12	102	60252	0.00169288986257718	0.282902222964536	0.282902222964536	false	false	false	true
7d850b62-01a2-408d-b31c-2caa3a20644f	2026-09-17 15:38	2026-09-17 15:38	2026-09-17 15:38	XLE	XLE260925P00063500	put	63.5000	2026-09-25	0.7200	0.7200	0.7300	64.4300	10656.00	0.00	10656.00	148	18	230	4267	0.0539020389032107	0.303452638957382	0.303452638957382	false	false	false	true
91e19a0f-edcf-4b7d-81ce-c279889c076e	2026-09-17 15:24	2026-09-17 15:24	2026-09-17 15:24	XLE	XLE261120C00065000	call	65.0000	2026-11-20	2.6300	2.6300	2.6600	64.3550	16043.00	0.00	16043.00	61	19	442	30654	0.0144189991518236	0.252459823703115	0.252459823703115	false	false	false	true
fe210dcd-fabc-4b97-9474-d5d326f79ba6	2026-09-17 15:23	2026-09-17 15:22	2026-09-17 15:22	XLE	XLE261218P00064000	put	64.0000	2026-12-18	3.1000	3.1000	3.1500	64.3750	11780.00	0.00	11780.00	38	13	48	2561	0.0187426786411558	0.281999384167147	0.281999384167147	false	false	false	true
e85ee2db-9a2e-463c-b1d4-6306fe9e9795	2026-09-17 15:23	2026-09-17 15:22	2026-09-17 15:22	XLE	XLE261218P00066000	put	66.0000	2026-12-18	4.2000	4.2000	4.2500	64.3750	16380.00	0.00	16380.00	39	7	53	3057	0.0173372587504089	0.286718067589981	0.286718067589981	false	false	false	true
d23e3f9b-c80e-4cd1-821a-9ef72ef2787b	2026-09-17 15:18	2026-09-17 15:18	2026-09-17 15:18	XLE	XLE261016P00061000	put	61.0000	2026-10-16	0.6900	0.6900	0.7100	64.4150	27600.00	0.00	27600.00	400	44	476	5946	0.0800538176925664	0.283657221152448	0.283657221152448	true	false	false	true
f3416ed4-b409-49c3-8de9-4e759d392d02	2026-09-17 15:00	2026-09-17 15:00	2026-09-17 15:00	XLE	XLE261009C00064000	call	64.0000	2026-10-09	1.7800	1.7300	1.8000	64.4350	28480.00	28480.00	0.00	160	8	191	99	1.92929292929293	0.233634821405857	0.233634821405857	true	false	false	true
6e031861-36e9-4782-8d4e-9df12c8123ab	2026-09-17 14:57	2026-09-17 14:57	2026-09-17 14:57	XLE	XLE260925P00063000	put	63.0000	2026-09-25	0.5400	0.5300	0.5400	64.4450	13230.00	13230.00	0.00	245	9	3617	4976	0.726889067524116	0.301956598208795	0.301956598208795	false	false	false	true
e579893a-fe9a-4ff4-97e1-2db6abd8ba55	2026-09-17 14:42	2026-09-17 14:42	2026-09-17 14:42	XLE	XLE261016P00064000	put	64.0000	2026-10-16	1.7800	1.7500	1.7800	64.3850	10858.00	10858.00	0.00	61	6	464	21532	0.021549321939439	0.285872689327487	0.285872689327487	false	false	false	true
40952764-1114-4a1e-94fb-6bd31adbf1be	2026-09-17 14:03	2026-09-17 14:03	2026-09-17 14:03	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.3000	0.2900	0.3000	64.4300	16170.00	16170.00	0.00	539	36	2790	19875	0.140377358490566	0.304138829331576	0.304138829331576	false	false	false	true
775fb23a-5097-4818-bd67-c0ba08a3cc93	2026-09-17 13:48	2026-09-17 13:48	2026-09-17 13:48	XLE	XLE261016P00062000	put	62.0000	2026-10-16	1.0100	1.0000	1.0100	64.3050	19089.00	19089.00	0.00	189	15	444	22647	0.019605245727911	0.284773590237027	0.284773590237027	false	false	false	true
1f2ec0b8-56cd-4c1f-923a-33d736c411cc	2026-09-17 13:20	2026-09-17 13:20	2026-09-17 13:20	XLE	XLE261016C00066000	call	66.0000	2026-10-16	1.1600	1.1400	1.1600	64.2950	46052.00	46052.00	0.00	397	6	4262	4745	0.898208640674394	0.247683608340537	0.247683608340537	false	false	false	true
541c7dee-12b7-40b7-848f-e49ec6701726	2026-09-17 13:20	2026-09-17 13:20	2026-09-17 13:20	XLE	XLE261016C00066000	call	66.0000	2026-10-16	1.1600	1.1400	1.1600	64.2950	64380.00	64380.00	0.00	555	8	3865	4745	0.814541622760801	0.247683608340537	0.247683608340537	false	false	false	true
f8eeb82f-a9f8-4f56-a9e9-12f36e2d1b8a	2026-09-17 13:20	2026-09-17 13:20	2026-09-17 13:20	XLE	XLE261016C00066000	call	66.0000	2026-10-16	1.1600	1.1400	1.1600	64.3250	19140.00	19140.00	0.00	165	18	3206	4745	0.675658587987355	0.246017215633973	0.246017215633973	false	false	false	true
84167af5-b35a-448b-8695-14b4c2aa81bd	2026-09-17 13:20	2026-09-17 13:20	2026-09-17 13:20	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3700	1.3600	1.3700	64.3250	13700.00	13700.00	0.00	100	13	13366	39644	0.33715064070225	0.285735062118068	0.285735062118068	true	false	false	true
db28b1eb-26c7-4b7e-a58f-da6076967654	2026-09-17 13:18	2026-09-17 13:18	2026-09-17 13:18	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.5300	1.5000	1.5300	64.3150	44676.00	44676.00	0.00	292	5	932	10077	0.0924878436042473	0.242490603198748	0.242490603198748	false	false	false	true
d1f678d5-c13c-46b1-98fc-f19acf93e32d	2026-09-17 13:18	2026-09-17 13:18	2026-09-17 13:18	XLE	XLE261016C00066000	call	66.0000	2026-10-16	1.1500	1.1400	1.1500	64.3200	248745.00	248745.00	0.00	2163	12	2873	4745	0.605479452054794	0.244852257783018	0.244852257783018	false	false	false	true
42ad3a9b-90b2-4769-8344-b383b7aec1d2	2026-09-17 13:18	2026-09-17 13:18	2026-09-17 13:18	XLE	XLE261016C00068000	call	68.0000	2026-10-16	0.6200	0.6100	0.6200	64.3200	18166.00	18166.00	0.00	293	20	429	8234	0.0521010444498421	0.250797009457586	0.250797009457586	false	false	false	true
5ae5463e-17df-4a91-82e9-99815034dd72	2026-09-17 13:08	2026-09-17 13:08	2026-09-17 13:08	XLE	XLE261016C00066000	call	66.0000	2026-10-16	1.1200	1.1000	1.1200	64.2600	13776.00	13776.00	0.00	123	11	660	4745	0.139093782929399	0.24382487613514	0.24382487613514	false	false	false	true
c5d447c8-6dcf-4f65-9fbe-9a0a65de96d2	2026-09-17 13:08	2026-09-17 13:08	2026-09-17 13:08	XLE	XLE261016C00066000	call	66.0000	2026-10-16	1.1200	1.1100	1.1300	64.2650	46592.00	39872.00	6720.00	416	28	537	4745	0.113171759747102	0.243549921557544	0.243549921557544	false	false	false	true
f2a2a0a9-cb52-4461-aab4-251a4aecbf16	2026-09-17 13:08	2026-09-17 13:07	2026-09-17 13:07	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.3300	0.2900	0.3400	64.2750	29666.00	29403.00	0.00	899	31	1759	19875	0.0885031446540881	0.304200730317847	0.304200730317847	false	false	false	true
e8f5f60a-4a0a-4b2b-baea-e3495b03fa4c	2026-09-17 13:08	2026-09-17 13:07	2026-09-17 13:07	XLE	XLE260925P00063000	put	63.0000	2026-09-25	0.5900	0.5500	0.5900	64.2750	188800.00	188800.00	0.00	3200	54	3360	4976	0.67524115755627	0.301572413672042	0.301572413672042	false	false	false	true
d1b48e2d-15c0-49ce-8e3a-16ce9ec04c6b	2026-09-17 13:06	2026-09-17 13:06	2026-09-17 13:06	XLE	XLE260918C00065000	call	65.0000	2026-09-18	0.1200	0.1100	0.1200	64.2700	13308.00	13308.00	0.00	1109	8	3067	41251	0.0743497127342367	0.278583920865269	0.278583920865269	true	false	false	true
3e3a5c3a-72b4-41c9-8eea-64a5beac8cbb	2026-09-17 12:49	2026-09-17 12:49	2026-09-17 12:49	XLE	XLE260930P00060000	put	60.0000	2026-09-30	0.1800	0.1800	0.2000	64.2200	48726.00	0.00	48726.00	2707	10	2845	4143	0.686700458604876	0.296835004420786	0.296835004420786	false	false	false	true