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

6f757733-7dfd-465e-bbe4-62db4b5353ff	2026-09-15 09:30	2026-09-15 09:30	2026-09-15 09:30	XLE	XLE261016P00059000	put	59.0000	2026-10-16	0.3700	0.2300	0.3800	64.9100	14800.00	2664.00	1665.00	400	15	500	14544	0.0343784378437844	0.305742411808339	0.305742411808339	false	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-09-15T13:35:39.189623Z"}	2026-09-15	2026-09-15 21:15	2026-09-15 21:15
3c468918-442f-428e-b385-efa0bd9c237a	2026-09-14 15:59	2026-09-14 15:59	2026-09-14 15:59	XLE	XLE270319P00055000	put	55.0000	2027-03-19	1.1900	1.1500	1.2000	64.0000	23869.00	23869.00	0.00	200	5	262	21078	0.0124300218237024	0.279021704072449	0.279021704072449	false	false	false	true
ea61d221-0455-42fc-aaac-25df5e123c2d	2026-09-14 15:52	2026-09-14 15:52	2026-09-14 15:52	XLE	XLE270319P00065000	put	65.0000	2027-03-19	4.8500	4.8000	4.9000	64.0000	15520.00	14550.00	485.00	32	8	285	1222	0.233224222585925	0.278533196471772	0.278533196471772	false	false	false	true
b798d2bc-9b8a-4bac-8010-610753ec3895	2026-09-14 15:52	2026-09-14 15:52	2026-09-14 15:52	XLE	XLE270319C00067000	call	67.0000	2027-03-19	3.8900	3.8500	3.9000	64.0000	46333.00	46333.00	0.00	119	18	179	575	0.311304347826087	0.248699847222504	0.249246358021143	false	false	false	true
29a23732-47f4-460a-8339-5d0a28fe9e2e	2026-09-14 15:52	2026-09-14 15:52	2026-09-14 15:52	XLE	XLE270319P00066000	put	66.0000	2027-03-19	5.4000	5.3000	5.4000	64.0000	41580.00	41580.00	0.00	77	7	117	488	0.239754098360656	0.279839055553133	0.279839055553133	false	false	false	true
4f8433c2-55a7-4d05-bd4f-7c4011ffc48d	2026-09-14 15:49	2026-09-14 15:49	2026-09-14 15:49	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.4600	2.4300	2.4700	64.0000	64452.00	64452.00	0.00	262	7	2930	46301	0.0632815705924278	0.280427872837472	0.280427872837472	true	false	false	true
d1303d7d-5208-4d93-ac55-20d02855f392	2026-09-14 15:48	2026-09-14 15:47	2026-09-14 15:47	XLE	XLE260918C00065000	call	65.0000	2026-09-18	0.5900	0.5600	0.5900	64.0000	147087.00	147087.00	0.00	2493	56	4609	50387	0.0914720066683867	0.315250563806597	0.315250563806597	false	false	false	true
73f2fd2d-eeea-4f67-8bfa-42330bd7a525	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.9000	64.3950	10120.00	0.00	10120.00	115	6	1569	201	7.80597014925373	0.279115084190667	0.279115084190667	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
eed814c0-3618-425f-8ae9-4a5cb9b27f74	2026-09-14 15:23	2026-09-14 15:23	2026-09-14 15:23	XLE	XLE270617P00065000	put	65.0000	2027-06-17	5.4600	5.4500	5.7000	64.3900	19665.00	0.00	19665.00	36	5	77	1193	0.0645431684828164	0.273152944804021	0.270873252513896	false	false	false	true
14be4b59-b6a2-42ef-baec-31531ecb4627	2026-09-14 15:18	2026-09-14 15:18	2026-09-14 15:18	XLE	XLE260918P00064500	put	64.5000	2026-09-18	0.8700	0.8700	0.9000	64.3650	21750.00	0.00	21750.00	250	10	962	2799	0.343694176491604	0.303048324154298	0.303048324154298	true	false	false	true
8f2dc546-735c-4c06-96b1-713e16751cdf	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.3900	0.3700	0.4100	64.2600	15171.00	5460.00	0.00	389	5	4826	8658	0.557403557403557	0.262557790635213	0.262557790635213	false	false	false	true
510278a1-3ac2-4d69-a739-ca1c4a29e71f	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.5000	1.4500	1.5000	64.2600	10200.00	10200.00	0.00	68	7	5033	36173	0.139136925331048	0.288134769927412	0.288134769927412	true	false	false	true
37ea6357-ef12-4630-a0c4-58c8098fa910	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	XLE	XLE260916P00064000	put	64.0000	2026-09-16	0.4000	0.3700	0.4000	64.3500	14080.00	14080.00	0.00	352	25	2876	564	5.09929078014184	0.297269284835092	0.297269284835092	true	false	false	true
dbe2559d-9139-44fa-8e1c-1f0440fa3354	2026-09-14 14:59	2026-09-14 14:58	2026-09-14 14:58	XLE	XLE260916P00064000	put	64.0000	2026-09-16	0.4000	0.3800	0.4000	64.3300	11120.00	11120.00	0.00	278	11	2523	564	4.47340425531915	0.292952174953486	0.292952174953486	false	false	false	true
5342b340-a10b-4584-883a-d07d60a543af	2026-09-14 14:49	2026-09-14 14:49	2026-09-14 14:49	XLE	XLE260918P00064000	put	64.0000	2026-09-18	0.5800	0.5800	0.6100	64.4700	14500.00	0.00	14500.00	250	14	11693	9768	1.19707207207207	0.299934421356462	0.299934421356462	false	false	false	true
b66b918a-fec1-42cf-9147-0808d160fb41	2026-09-14 14:46	2026-09-14 14:46	2026-09-14 14:46	XLE	XLE260918P00065000	put	65.0000	2026-09-18	1.0800	1.0700	1.1200	64.4800	19548.00	3132.00	16308.00	181	10	5098	11833	0.430829037437674	0.296401792305115	0.299787353744941	true	false	false	true
9468b3e8-4910-4e91-86f4-5e593a673540	2026-09-14 14:32	2026-09-14 14:32	2026-09-14 14:32	XLE	XLE260925C00070000	call	70.0000	2026-09-25	0.0900	0.0900	0.1000	64.6550	12573.00	0.00	12573.00	1397	24	1458	1400	1.04142857142857	0.291881224265229	0.291881224265229	false	false	false	true
c60f1b7a-9005-4f61-ab4e-df299886e7ab	2026-09-14 14:29	2026-09-14 14:29	2026-09-14 14:29	XLE	XLE260925P00064000	put	64.0000	2026-09-25	1.0600	1.0200	1.0700	64.6800	26924.00	26924.00	0.00	254	10	770	86	8.95348837209302	0.315403826279854	0.315403826279854	true	false	false	true
a4ae54a7-2657-4be0-ab95-7be55b2377cc	2026-09-14 14:28	2026-09-14 14:28	2026-09-14 14:28	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.3300	2.3200	2.3300	64.7350	15611.00	15611.00	0.00	67	8	1733	46301	0.0374289972138831	0.279640910378264	0.279640910378264	true	false	false	true
2f49c9b1-d056-4f0f-90da-2c01c91d2766	2026-09-14 14:25	2026-09-14 14:25	2026-09-14 14:25	XLE	XLE261016P00062000	put	62.0000	2026-10-16	1.0100	1.0100	1.0300	64.6800	19897.00	0.00	19897.00	197	8	851	18895	0.0450383699391373	0.288915088960462	0.288915088960462	true	false	false	true
799d1c0e-56f9-4cf6-9401-d88310d72f41	2026-09-14 14:25	2026-09-14 14:25	2026-09-14 14:25	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.3500	2.3300	2.3600	64.6900	11515.00	705.00	1410.00	49	9	1462	46301	0.0315759918792251	0.279996570459871	0.279996570459871	true	false	false	true
3ce2bd84-cece-45f6-979c-e7709b960b8c	2026-09-14 14:23	2026-09-14 14:23	2026-09-14 14:23	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.4200	0.4100	0.4200	64.7500	10542.00	10542.00	0.00	251	12	12548	1906	6.58342077649528	0.319537955749367	0.319537955749367	false	false	false	true
07bb72fd-be98-46de-b438-885afdf105e0	2026-09-14 14:04	2026-09-14 14:04	2026-09-14 14:04	XLE	XLE261120P00060000	put	60.0000	2026-11-20	1.1300	1.1000	1.1400	64.6550	11314.00	11314.00	0.00	100	7	566	8464	0.0668714555765595	0.284817439123164	0.284817439123164	false	false	false	true
50e22cbd-4acb-41fc-a5fe-470be9ae54ac	2026-09-14 13:50	2026-09-14 13:50	2026-09-14 13:50	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.4500	2.4100	2.4500	64.6600	17395.00	17395.00	0.00	71	7	126	15521	0.00811803363185362	0.272139560699524	0.272139560699524	false	false	false	true
fd3d18c8-b1b5-481f-bf4b-4a64486feb8d	2026-09-14 13:48	2026-09-14 13:48	2026-09-14 13:48	XLE	XLE261218C00065000	call	65.0000	2026-12-18	3.5000	3.4500	3.5500	64.6600	10850.00	3500.00	5250.00	31	6	101	38985	0.00259074002821598	0.25298339508789	0.25298339508789	false	false	false	true
89a379af-e675-423b-bb9f-bf4c50b29e11	2026-09-14 13:46	2026-09-14 13:46	2026-09-14 13:46	XLE	XLE261120P00062000	put	62.0000	2026-11-20	1.7400	1.7200	1.7400	64.6750	15834.00	15834.00	0.00	91	5	333	27	12.3333333333333	0.28351078332934	0.28351078332934	false	false	false	true
746c33f6-d408-4eca-b180-83467921fbab	2026-09-14 13:43	2026-09-14 13:43	2026-09-14 13:43	XLE	XLE261218P00062500	put	62.5000	2026-12-18	2.3500	2.3400	2.3700	64.6850	10105.00	9870.00	235.00	43	6	1085	46301	0.0234336191442949	0.279853657926332	0.279853657926332	false	false	false	true
4d3906be-f850-4890-a318-55df5f3bb6ca	2026-09-14 13:29	2026-09-14 13:28	2026-09-14 13:28	XLE	XLE270331P00073000	put	73.0000	2027-03-31	10.1000	10.0500	10.1000	64.6301	10100.00	10100.00	0.00	10	5	21	0	0	0.299034322043099	0.299034322043099	false	false	false	true
18fee9d5-b49b-48d7-913f-60a49f93e97d	2026-09-14 13:19	2026-09-14 13:19	2026-09-14 13:19	XLE	XLE261120P00061000	put	61.0000	2026-11-20	1.4200	1.4000	1.4200	64.6900	10366.00	10366.00	0.00	73	5	73	58	1.25862068965517	0.285751909204423	0.285751909204423	false	false	false	true
01a8366e-02f7-4347-8e3e-23e0c1bf29cd	2026-09-14 13:19	2026-09-14 13:19	2026-09-14 13:19	XLE	XLE261120P00062000	put	62.0000	2026-11-20	1.7500	1.7100	1.7500	64.6900	36400.00	36400.00	0.00	208	20	220	27	8.14814814814815	0.285004543091287	0.285004543091287	false	false	false	true
1aafbe6b-83b9-4391-b207-757d8229ed52	2026-09-14 12:55	2026-09-14 12:55	2026-09-14 12:55	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.4800	0.4600	0.4800	64.5500	39120.00	39120.00	0.00	815	5	4597	1906	2.41185729275971	0.32488409280521	0.32488409280521	false	false	false	true
71641233-bc4b-4f93-b1b1-61f3bb5c5a5b	2026-09-14 12:55	2026-09-14 12:55	2026-09-14 12:55	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.4900	0.4800	0.5000	64.5100	29596.00	29547.00	0.00	604	9	3601	1906	1.88929695697796	0.325188567946745	0.325188567946745	false	false	false	true
ee0a9388-00f7-4df6-a006-cb12f723cfab	2026-09-14 12:55	2026-09-14 12:55	2026-09-14 12:55	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.4900	0.4700	0.4900	64.5150	11025.00	11025.00	0.00	225	22	2962	1906	1.55403987408185	0.325524220672143	0.325524220672143	false	false	false	true
4d660b31-8df0-4a33-8a90-b01478af9130	2026-09-14 12:55	2026-09-14 12:54	2026-09-14 12:54	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.4800	0.4700	0.4800	64.5450	93600.00	93600.00	0.00	1950	32	2239	1906	1.17471143756558	0.324550743047765	0.324550743047765	false	false	false	true
622c8816-45cb-4756-abf9-f8926926355b	2026-09-14 12:51	2026-09-14 12:51	2026-09-14 12:51	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.5200	0.5100	0.5300	64.7100	124644.00	3328.00	120588.00	2397	22	8526	16922	0.503841153527952	0.290968367584793	0.290968367584793	true	false	false	true
f1cdf7d5-2745-4a55-86a6-ddb33095f695	2026-09-14 12:50	2026-09-14 12:50	2026-09-14 12:50	XLE	XLE260918P00064000	put	64.0000	2026-09-18	0.6000	0.5700	0.6100	64.5750	53640.00	35940.00	17700.00	894	60	9895	9768	1.01300163800164	0.323461363621196	0.323461363621196	true	false	false	true
85666793-173a-49cc-a743-4a8372449605	2026-09-14 12:49	2026-09-14 12:49	2026-09-14 12:49	XLE	XLE261120C00065000	call	65.0000	2026-11-20	2.8200	2.8000	2.8950	64.6000	283128.00	271284.00	11844.00	1004	5	1098	30353	0.0361743484993246	0.251869265237049	0.251869265237049	false	false	false
f0e081e6-2a84-49e3-8681-13ed924f27cc	2026-09-14 12:49	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE260925C00066000	call	66.0000	2026-09-25	0.6100	0.6100	0.7000	64.6300	20984.00	0.00	20984.00	344	13	497	445	1.11685393258427	0.252768265829119	0.252768265829119	true	false	false	true
cb26bb94-6d6e-4f00-9165-87e5c244eb4d	2026-09-14 12:49	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE260925C00065000	call	65.0000	2026-09-25	0.9500	0.9500	1.0800	64.6300	40963.00	0.00	20995.00	429	16	588	371	1.58490566037736	0.243341334512954	0.24558381581799	true	false	false	true
a174a96f-0246-4446-997b-23471a0082af	2026-09-14 12:49	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.4400	0.4200	0.4500	64.6300	116204.00	264.00	115940.00	2641	60	3685	8658	0.425617925617926	0.260029278810465	0.26038102049771	false	false	false	true
21d7e5fa-728c-4f49-99af-5dcd44878946	2026-09-14 12:49	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261016C00067000	call	67.0000	2026-10-16	1.0600	1.0600	1.1600	64.6300	43036.00	0.00	43036.00	406	15	5016	2791	1.79720530275887	0.249956808367159	0.250445676273861	false	false	false	true
06bb317e-d47c-4937-ad38-fc2261dc61d6	2026-09-14 12:49	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261016C00069000	call	69.0000	2026-10-16	0.6000	0.6000	0.6400	64.6300	11340.00	0.00	11340.00	189	10	1176	6186	0.190106692531523	0.257405295934996	0.257793553542813	false	false	false	true
903ade22-6b42-4f1e-9297-e8454a1b5731	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261016P00068000	put	68.0000	2026-10-16	4.3000	4.0500	4.3000	64.7600	81270.00	81270.00	0.00	189	10	192	249	0.771084337349398	0.322391285686405	0.322391285686405	false	false	false	true
78404f26-adbd-4b5d-91ab-94c004937deb	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261016P00067000	put	67.0000	2026-10-16	3.5500	3.3500	3.5500	64.7600	53605.00	53605.00	0.00	151	7	156	176	0.886363636363636	0.311404895007607	0.311404895007607	false	false	false	true
2efefade-2ded-4875-aaaf-9193fa60e1f3	2026-09-14 12:48	2026-09-14 12:48	2026-09-14 12:48	XLE	XLE261120C00066000	call	66.0000	2026-11-20	2.4500	2.4500	2.5500	64.7600	24500.00	0.00	24500.00	100	14	156	141	1.1063829787234	0.252394866174578	0.252394866174578	false	false	false	true
859e53d6-3b94-4b1a-a40e-e4126432ece5	2026-09-14 12:47	2026-09-14 12:47	2026-09-14 12:47	XLE	XLE261002P00063000	put	63.0000	2026-10-02	0.8600	0.7800	0.8700	64.8800	14964.00	14878.00	86.00	174	21	253	149	1.69798657718121	0.295876470124792	0.295876470124792	true	false	false	true
cb5d219d-9bbb-4475-b04c-034aa664f627	2026-09-14 12:38	2026-09-14 12:38	2026-09-14 12:38	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.8000	0.7700	0.8000	65.0439	22800.00	22800.00	0.00	285	19	4381	11833	0.370235781289614	0.307931884323996	0.307737350860057	false	false	false	true
70826b76-29c8-43bc-8896-7af2ed636511	2026-09-14 12:36	2026-09-14 12:35	2026-09-14 12:35	XLE	XLE261016C00066000	call	66.0000	2026-10-16	1.5500	1.5500	1.6200	65.0800	42625.00	0.00	42625.00	275	10	3425	2053	1.668290306868	0.24242794332507	0.24242794332507	false	false	false	true
812e7b0e-3636-41cb-9525-59254158d997	2026-09-14 12:21	2026-09-14 12:21	2026-09-14 12:21	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.4800	0.4800	0.5100	64.9550	50400.00	0.00	50400.00	1050	56	1836	16922	0.108497813497223	0.290939729388239	0.290939729388239	true	false	false	true