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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

2e7d0e9d-9dd1-4422-a8bd-59b3b42055d8	2026-09-08 09:30	2026-09-08 09:30	2026-09-08 09:30	XLE	XLE260918C00063500	call	63.5000	2026-09-18	2.0800	1.8800	2.0800	64.9500	24308.00	24308.00	0.00	117	15	117	801	0.146067415730337	0.27503071820034	0.275825925833261	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	42266645050.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-08T13:33:29.575205Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b52765c0-69ec-4e47-b637-c72cef5ec119	2026-09-03 10:58	2026-09-03 10:58	2026-09-03 10:58	XLE	XLE261016C00065000	call	65.0000	2026-10-16	2.4100	2.4000	2.4800	65.3500	15904.00	241.00	15663.00	66	8	156	8182	0.0190662429723784	0.231445569902987	0.232578372132784	false	false	false	true
4d558fce-2b93-4858-804a-ea3fd70449cf	2026-09-03 10:17	2026-09-03 10:17	2026-09-03 10:17	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3500	1.3500	1.3600	65.1000	18969.00	9384.00	9585.00	140	21	10707	3115	3.43723916532905	0.268912665619715	0.269115166689389	true	false	false	true
5b5e9cba-2011-4f33-b09b-3bba63f53847	2026-09-03 10:05	2026-09-03 10:05	2026-09-03 10:05	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3500	1.3400	1.3500	65.1300	28340.00	27000.00	1340.00	210	6	6315	3115	2.02728731942215	0.269084714789706	0.270328288567014	true	false	false	true
35957296-373e-428c-9a6f-1717beab8df3	2026-09-03 10:04	2026-09-03 10:03	2026-09-03 10:03	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3700	1.3600	1.3700	65.1000	11496.00	9864.00	1632.00	84	12	4579	3115	1.46998394863563	0.270356493154601	0.270356493154601	true	false	false	true
1af5f5b7-0aeb-45d6-aee7-6ce540c99a2d	2026-09-03 10:04	2026-09-03 10:03	2026-09-03 10:03	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3600	1.3500	1.3700	65.0900	17171.00	9419.00	2720.00	126	7	4423	3115	1.4199036918138	0.269950964669312	0.269950964669312	true	false	false	true
68dcd170-d19c-4ebf-a627-29d4ec6e67da	2026-09-03 10:03	2026-09-03 10:03	2026-09-03 10:03	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3700	1.3500	1.3700	65.0800	14076.00	13668.00	0.00	103	19	3989	3115	1.28057784911717	0.269545075035797	0.269545075035797	true	false	false	true
ffaf2e75-02a6-4b44-8fd3-153d0c133f3a	2026-09-03 10:03	2026-09-03 10:03	2026-09-03 10:03	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.3700	1.3500	1.3700	65.0800	13797.00	13525.00	136.00	101	11	3837	3115	1.23178170144462	0.269545075035797	0.270784625805083	true	false	false	true
4b5ea30f-7b00-4bba-b845-9b76f9ab0bd1	2026-09-03 09:43	2026-09-03 09:43	2026-09-03 09:43	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.9100	1.9100	1.9900	65.0300	191195.00	0.00	191195.00	1001	29	1030	8424	0.122269705603039	0.250816417546615	0.250816417546615	true	false	false	true
fcee5451-4228-4826-9efb-c893756a14e0	2026-09-02 10:01	2026-09-02 10:01	2026-09-02 10:01	XLE	XLE261120C00065000	call	65.0000	2026-11-20	2.9400	2.8900	2.9800	64.4950	17615.00	0.00	1445.00	60	5	369	34930	0.0105639851130833	0.23978944834298	0.243974597925236	false	false	false	true
3b96a3e1-e6c6-4bd5-8ab2-64fa2e889cbd	2026-09-01 14:52	2026-09-01 14:52	2026-09-01 14:52	XLE	XLE270115C00065000	call	65.0000	2027-01-15	4.0000	3.9500	4.0500	64.6350	95198.00	93998.00	400.00	238	42	1445	21654	0.0667313198485268	0.235422060365842	0.236063304278858	false	false	false	true
a300fe54-44a8-4e4d-b346-c90872dbe4bd	2026-09-01 10:25	2026-09-01 10:25	2026-09-01 10:25	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.0200	1.0200	1.0800	64.1800	20912.00	0.00	20912.00	205	7	630	54508	0.0115579364496955	0.241668267124177	0.243508236582823	false	false	false	true
da1690ec-b939-495a-9ee7-59616439e844	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.1950	335021.00	0.00	335021.00	1000	26	2026	5102	0.397099176793414	0.233687705469572	0.233687705469572	true	false	false	true
d6bbb4d8-3903-42ce-ba5a-3167f1bd9114	2026-08-31 11:49	2026-08-31 11:48	2026-08-31 11:48	XLE	XLE261218C00067500	call	67.5000	2026-12-18	1.9600	1.9400	2.0200	63.3450	11766.00	6169.00	5597.00	60	5	2180	6979	0.312365668433873	0.236307310600688	0.240897947921896	false	false	false	true
903d503c-fe44-40bc-b21a-9af83dfb4221	2026-08-31 11:18	2026-08-31 11:18	2026-08-31 11:18	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.3300	1.3200	1.3700	63.2000	26595.00	0.00	26595.00	200	8	329	8656	0.0380083179297597	0.245279081289792	0.246151301488592	false	false	false	true
0bcaafe0-96dd-45ae-9989-a8fff02af3c6	2026-08-31 10:08	2026-08-31 10:08	2026-08-31 10:08	XLE	XLE270319C00060000	call	60.0000	2027-03-19	7.1200	7.0000	7.5500	63.8100	28484.00	0.00	28484.00	40	8	70	18092	0.00386911342029626	0.230618091592156	0.230618091592156	false	false	false	true
c969b132-8c05-4229-82f2-3a2d51a9aa47	2026-08-27 13:05	2026-08-27 13:05	2026-08-27 13:05	XLE	XLE260918C00063000	call	63.0000	2026-09-18	1.1800	1.1200	1.1800	62.1800	75635.00	75520.00	115.00	641	21	8465	246	34.4105691056911	0.238989552559992	0.243973349210574	true	false	false	true
c05fe149-75e0-4fd9-8ac7-983f036fee9a	2026-08-27 11:25	2026-08-27 11:24	2026-08-27 11:24	XLE	XLE280121P00045500	put	45.5000	2028-01-21	1.2400	1.2400	1.3500	61.7800	33695.00	635.00	33060.00	271	10	471	70	6.72857142857143	0.285873946651396	0.288098501016178	true	false	false	true
4320906c-be29-4603-9dac-2fa44dbaa4e5	2026-08-26 12:01	2026-08-26 12:01	2026-08-26 12:01	XLE	XLE260918C00064000	call	64.0000	2026-09-18	1.2000	1.1800	1.2000	62.9650	54623.00	43080.00	11543.00	456	12	2069	1095	1.88949771689498	0.250828943840705	0.252443328437074	true	false	false	true
175d160e-4c8e-45f9-8e61-664820f7382e	2026-08-26 12:01	2026-08-26 12:01	2026-08-26 12:01	XLE	XLE260918C00064000	call	64.0000	2026-09-18	1.1800	1.1500	1.1800	62.9500	31846.00	16519.00	15327.00	271	13	1058	1095	0.9662100456621	0.248624218382657	0.250240855062276	true	false	false	true
d3991947-7407-47f9-ace4-b412d9325be9	2026-08-26 09:41	2026-08-26 09:40	2026-08-26 09:40	XLE	XLE260828C00062500	call	62.5000	2026-08-28	0.3600	0.3200	0.3700	62.0900	18413.00	701.00	17676.00	511	54	1001	357	2.80392156862745	0.290988777392534	0.290988777392534	false	false	false	true
50e4630a-91a0-431f-bc9a-f33a8f000c47	2026-08-26 09:39	2026-08-26 09:38	2026-08-26 09:38	XLE	XLE260828C00062500	call	62.5000	2026-08-28	0.3500	0.3400	0.3600	61.9450	15231.00	391.00	14840.00	435	44	435	357	1.21848739495798	0.316367775610345	0.316367775610345	false	false	false	true
8733ed08-69f3-40fd-8deb-30de2dd0ff79	2026-08-25 15:59	2026-08-25 15:58	2026-08-25 15:58	XLE	XLE260828C00062000	call	62.0000	2026-08-28	0.7100	0.6800	0.7100	62.1150	118474.00	97614.00	20860.00	1678	29	11822	26475	0.446534466477809	0.282195495624066	0.280992022254722	true	false	false	true
cdda13dd-21ff-47a7-b29b-8c46803280dc	2026-08-25 11:27	2026-08-25 11:27	2026-08-25 11:27	XLE	XLE260831P00063000	put	63.0000	2026-08-31	0.8100	0.8000	0.8900	62.6950	21595.00	0.00	2560.00	267	7	372	1916	0.194154488517745	0.204948762064301	0.204948762064301	false	false	false	true
d7101869-55dc-4b58-b16b-7993c21ff206	2026-08-25 10:36	2026-08-25 10:35	2026-08-25 10:35	XLE	XLE270115C00067500	call	67.5000	2027-01-15	2.0800	2.0800	2.1900	62.6550	145820.00	0.00	145820.00	701	20	1309	6903	0.189627698102274	0.228138926580982	0.228816317587406	true	false	false	true
30564f1d-a593-4a85-9291-e6a0eda779b1	2026-08-25 09:58	2026-08-25 09:58	2026-08-25 09:58	XLE	XLE260828P00062500	put	62.5000	2026-08-28	0.6700	0.6700	0.7600	62.3850	10010.00	0.00	10010.00	150	7	313	925	0.338378378378378	0.270612114435467	0.275049504485552	false	false	false	true
b427910f-ddbf-42e7-be33-fa0895ff5191	2026-08-24 11:42	2026-08-24 11:42	2026-08-24 11:42	XLE	XLE260828P00063500	put	63.5000	2026-08-28	1.2100	1.2000	1.2300	62.6750	13309.00	0.00	13309.00	110	7	913	887	1.0293122886133	0.278093481426124	0.282260960138949	false	false	false	true
2ac05b06-a936-4adb-9059-b5527a6e0826	2026-08-24 11:02	2026-08-24 11:02	2026-08-24 11:02	XLE	XLE260828P00064000	put	64.0000	2026-08-28	1.3800	1.3700	1.4700	62.9400	68800.00	0.00	68800.00	500	11	1107	965	1.14715025906736	0.279850268198156	0.284244160503022	false	false	false	true
79db89e6-ce1d-4f20-b1c5-f0e825970800	2026-08-21 10:22	2026-08-21 10:22	2026-08-21 10:22	XLE	XLE260918C00065000	call	65.0000	2026-09-18	1.3600	1.3600	1.4000	64.0050	16907.00	0.00	16907.00	124	10	558	51300	0.0108771929824561	0.243583359309738	0.243583359309738	false	false	false	true
661cde70-4910-4889-af9a-107fd41f6956	2026-08-21 09:57	2026-08-21 09:57	2026-08-21 09:57	XLE	XLE260821P00063000	put	63.0000	2026-08-21	0.0300	0.0200	0.0400	63.9450	16137.00	14673.00	3.00	5000	64	5130	7581	0.676691729323308	0.425785533828706	0.46006285037299	false	false	false	true
da03b7ee-fe41-49b8-8acc-05a2ccf96df8	2026-08-20 15:57	2026-08-20 15:57	2026-08-20 15:57	XLE	XLE260918C00062500	call	62.5000	2026-09-18	2.6100	2.6000	2.6600	63.7850	26136.00	13362.00	12774.00	100	6	1182	27003	0.0437729141206533	0.249342213233236	0.252323256277197	false	false	false	true
952bdab9-e5c4-40b7-b66a-adb3265f74af	2026-08-20 11:58	2026-08-20 11:58	2026-08-20 11:58	XLE	XLE260828P00065000	put	65.0000	2026-08-28	1.2000	1.1700	1.2000	64.4450	14998.00	14998.00	0.00	125	5	820	110	7.45454545454545	0.240166003459561	0.240166003459561	false	false	false	true
0eb9b090-04e7-447a-a8b0-7022b773e308	2026-08-19 15:40	2026-08-19 15:40	2026-08-19 15:40	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.6400	1.6300	1.7000	63.5000	16395.00	0.00	16395.00	100	5	304	7681	0.039578179924489	0.24917942527344	0.249843998152482	false	false	false	true
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
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
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
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
78629008-dd0d-4f6f-bb08-bcdd4bb432d9	2026-08-17 15:23	2026-08-17 15:23	2026-08-17 15:23	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.5800	2.5700	2.6500	62.5200	51543.00	0.00	51543.00	200	23	7751	64458	0.120248844208632	0.229624446146803	0.245430490733844	false	false	false	true
ba7248e5-34a5-4b45-a87b-795b43d0381b	2026-08-17 13:12	2026-08-17 13:12	2026-08-17 13:12	XLE	XLE260821C00060000	call	60.0000	2026-08-21	2.4900	2.3900	2.5000	62.4200	122012.00	122012.00	0.00	490	5	6076	64458	0.0942629309007416	0.251180605652369	0.251180605652369	false	false	false	true
8022efe7-6c7e-444a-8f26-685e9e0d8480	2026-08-17 13:12	2026-08-17 13:12	2026-08-17 13:12	XLE	XLE271217P00065000	put	65.0000	2027-12-17	7.7600	7.7000	7.9000	62.4200	83779.00	29529.00	7750.00	108	13	108	407	0.265356265356265	0.288937251844263	0.290715257563358	false	false	false	true
72b7c1b7-8f77-4e2d-bd82-928d596d743b	2026-08-14 15:58	2026-08-14 15:58	2026-08-14 15:58	XLE	XLE260821C00061000	call	61.0000	2026-08-21	1.2900	1.2500	1.3000	61.8850	147041.00	146912.00	129.00	1136	40	5541	22363	0.247775343200823	0.215099248681403	0.219543910074668	false	false	false	true