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

2f415f54-7702-4dc7-b3c4-df0ee7147d01	2026-09-17 12:35	2026-09-17 12:35	2026-09-17 12:35	XLE	XLE260918P00065000	put	65.0000	2026-09-18	0.9000	0.8800	0.9000	64.1800	10620.00	10620.00	0.00	118	24	632	17267	0.0366016100075288	0.263098166108625	0.263098166108625	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	41841409082.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
5856bdee-f1cf-4d2c-a116-61e2c72740fc	2026-09-17 12:22	2026-09-17 12:22	2026-09-17 12:22	XLE	XLE270319P00058000	put	58.0000	2027-03-19	1.9600	1.9200	1.9600	64.0950	35084.00	35084.00	0.00	179	26	860	492	1.7479674796748	0.280181849685547	0.280181849685547	false	false	false	true
4670187f-5326-4aea-8c95-04b7a9513f68	2026-09-17 12:22	2026-09-17 12:22	2026-09-17 12:22	XLE	XLE270319P00058000	put	58.0000	2027-03-19	1.9600	1.9200	1.9700	64.0950	47236.00	47236.00	0.00	241	15	681	492	1.38414634146341	0.280351020757609	0.280181849685547	false	false	false	true
e67464d5-e1ef-4c0c-8a27-1ce0272578df	2026-09-17 12:21	2026-09-17 12:20	2026-09-17 12:20	XLE	XLE270319P00058000	put	58.0000	2027-03-19	1.9700	1.9200	1.9700	64.0550	15957.00	15957.00	0.00	81	13	381	492	0.774390243902439	0.28021691778709	0.28021691778709	false	false	false	true
7045f8e9-5d17-492b-a56f-8b81b36f4a47	2026-09-17 12:18	2026-09-17 12:17	2026-09-17 12:17	XLE	XLE270319P00058000	put	58.0000	2027-03-19	1.9500	1.9000	1.9500	64.1000	11895.00	11895.00	0.00	61	11	210	492	0.426829268292683	0.279552697364628	0.279552697364628	false	false	false	true
52442028-861e-4051-8096-4ed8134a292a	2026-09-17 12:18	2026-09-17 12:17	2026-09-17 12:17	XLE	XLE270319P00058000	put	58.0000	2027-03-19	1.9500	1.9000	1.9500	64.1000	11310.00	11310.00	0.00	58	15	149	492	0.302845528455285	0.279552697364628	0.279552697364628	false	false	false	true
e065d26d-96db-4428-9fbb-e220dc9c8a81	2026-09-17 12:13	2026-09-17 12:13	2026-09-17 12:13	XLE	XLE261016C00070000	call	70.0000	2026-10-16	0.2700	0.2700	0.2800	64.0250	37530.00	0.00	37530.00	1390	36	1462	27641	0.0528924423863102	0.254785407403215	0.254785407403215	false	false	false	true
21375631-9dc7-43d2-89be-210c4ba2fbb7	2026-09-17 11:50	2026-09-17 11:50	2026-09-17 11:50	XLE	XLE260925C00062000	call	62.0000	2026-09-25	2.2300	2.1100	2.2400	64.0150	11161.00	2464.00	0.00	50	6	163	164	0.99390243902439	0.22139515910233	0.216905236557063	false	false	false	true
7d5820e6-0efa-491f-82ec-62d07d25faf2	2026-09-17 11:41	2026-09-17 11:41	2026-09-17 11:41	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.3600	0.3600	0.3700	64.0546	20520.00	0.00	20520.00	570	22	846	19875	0.0425660377358491	0.298336161783066	0.298336161783066	false	false	false	true
75d18f54-3279-40e7-b8e7-15eb8ed8cf16	2026-09-17 11:41	2026-09-17 11:41	2026-09-17 11:41	XLE	XLE261016C00063000	call	63.0000	2026-10-16	2.3600	2.3500	2.3600	64.0499	12036.00	12036.00	0.00	51	5	260	4462	0.0582698341550874	0.233088142466037	0.233088142466037	false	false	false	true
d546323e-d794-40bb-9eaf-ede3cf71548e	2026-09-17 11:30	2026-09-17 11:30	2026-09-17 11:30	XLE	XLE260928P00061000	put	61.0000	2026-09-28	0.2500	0.2500	0.3100	64.1000	11675.00	0.00	11675.00	467	32	497	4	124.25	0.286933899659134	0.286933899659134	false	false	false	true
f6ae475a-c252-432b-8617-c60c77553e0e	2026-09-17 11:30	2026-09-17 11:29	2026-09-17 11:29	XLE	XLE261016C00061000	call	61.0000	2026-10-16	3.7000	3.5500	3.7000	64.0550	22940.00	22940.00	0.00	62	5	96	1932	0.0496894409937888	0.223875569610721	0.223875569610721	false	false	false	true
339fe097-a7d2-4ce9-9b63-883b59d951cc	2026-09-17 11:17	2026-09-17 11:16	2026-09-17 11:16	XLE	XLE271217P00046500	put	46.5000	2027-12-17	0.9800	0.9800	1.0500	64.0100	10584.00	0.00	10584.00	108	13	212	1555	0.136334405144695	0.286763375756274	0.286763375756274	false	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
4dbbcde5-c413-447b-be7e-57a45aebeb21	2026-09-17 11:04	2026-09-17 11:04	2026-09-17 11:04	XLE	XLE260925C00062000	call	62.0000	2026-09-25	2.1700	2.0600	2.2200	63.9300	10872.00	6882.00	3990.00	50	6	63	164	0.384146341463415	0.242519043809982	0.242519043809982	false	false	false	true
a266a097-c176-4e23-8519-657ea635530c	2026-09-17 10:51	2026-09-17 10:50	2026-09-17 10:50	XLE	XLE261016C00067000	call	67.0000	2026-10-16	0.7400	0.7400	0.7800	64.0000	14800.00	0.00	14800.00	200	10	296	21733	0.0136198407951042	0.24507493291107	0.24507493291107	false	false	false	true
40eb4f2b-dde7-490a-9f53-615c8e0e7f95	2026-09-17 10:42	2026-09-17 10:42	2026-09-17 10:42	XLE	XLE270617P00067500	put	67.5000	2027-06-17	7.2000	7.2000	7.4500	63.9650	33120.00	0.00	33120.00	46	5	54	485	0.111340206185567	0.293012673230255	0.293012673230255	false	false	false	true
178cae98-e42a-4a07-8886-7c38206a8569	2026-09-17 10:11	2026-09-17 10:11	2026-09-17 10:11	XLE	XLE261016C00064000	call	64.0000	2026-10-16	1.7200	1.6900	1.7300	63.7400	24596.00	24596.00	0.00	143	5	170	3796	0.0447839831401475	0.243993926340236	0.243993926340236	false	false	false	true
2a4b4942-adc5-4ee1-b77d-e2003411ac81	2026-09-17 09:58	2026-09-17 09:58	2026-09-17 09:58	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.5100	1.4500	1.5100	64.1050	10567.00	10567.00	0.00	70	9	2376	39644	0.0599334073251942	0.294033309587402	0.289691989008652	false	false	false	true
d1e43128-54e9-476b-bf39-b172f37629be	2026-09-17 09:45	2026-09-17 09:45	2026-09-17 09:45	XLE	XLE261016P00062000	put	62.0000	2026-10-16	1.1100	1.1100	1.1600	64.0900	19980.00	0.00	19980.00	180	26	196	22647	0.00865456793394269	0.290192301158963	0.290192301158963	false	false	false	true
b3bab5b8-1ec3-4125-8c28-4f49f40b794c	2026-09-17 09:45	2026-09-17 09:45	2026-09-17 09:45	XLE	XLE261016P00063000	put	63.0000	2026-10-16	1.5000	1.5000	1.5400	64.0900	315300.00	0.00	315300.00	2102	11	2260	39644	0.0570073655534255	0.291748509455705	0.291748509455705	false	false	false	true
50963ce1-1241-4fd4-90df-619fb131df7a	2026-09-17 09:30	2026-09-17 09:30	2026-09-17 09:30	XLE	XLE260918P00065000	put	65.0000	2026-09-18	1.4500	1.3400	1.4500	63.6300	14500.00	14500.00	0.00	100	24	100	17267	0.00579139398853304	0.370856284626845	0.370856284626845	true	false	false	true
51949e7f-7e85-4399-b622-51144e43aea9	2026-09-16 15:56	2026-09-16 15:56	2026-09-16 15:56	XLE	XLE260918P00065000	put	65.0000	2026-09-18	1.0900	1.0900	1.1400	64.0000	10246.00	0.00	10246.00	94	5	9624	19544	0.492427343430209	0.277805886189005	0.277805886189005	false	false	false	true
8de5fa82-fe05-4886-8ee8-61b5c50bbb83	2026-09-16 15:52	2026-09-16 15:51	2026-09-16 15:51	XLE	XLE261016C00065000	call	65.0000	2026-10-16	1.5400	1.5400	1.5700	64.0000	11088.00	0.00	11088.00	72	8	1357	9514	0.142631910868194	0.253693199653613	0.253693199653613	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
7c0917e1-e39e-41b0-950b-268a9db6146f	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	19712.00	1008.00	2912.00	176	12	8695	19544	0.444893573475235	0.292521597093496	0.292521597093496	false	false	false	true
3e58f6b2-422e-4f07-922a-47d5397ad7ce	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.1200	1.1400	64.0000	20160.00	0.00	20160.00	180	12	8875	19544	0.454103561195252	0.292521597093496	0.292521597093496	false	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
9aa2ffac-dbe0-4582-906b-b9b065256786	2026-09-16 15:44	2026-09-16 15:44	2026-09-16 15:44	XLE	XLE271217C00060000	call	60.0000	2027-12-17	9.7500	9.7500	10.1000	63.8650	168758.00	0.00	168758.00	173	8	381	5297	0.0719275061355484	0.199457619829512	0.199457619829512	false	false	false	true
c8925176-f9ef-4bdc-bf24-f0c4565dd9f2	2026-09-16 15:37	2026-09-16 15:37	2026-09-16 15:37	XLE	XLE260918P00063000	put	63.0000	2026-09-18	0.3000	0.2900	0.3000	63.8050	30000.00	30000.00	0.00	1000	41	10512	16390	0.641366687004271	0.334381056152431	0.334381056152431	false	false	false	true
33772448-3883-4ec6-b2c4-0302bb74f0e5	2026-09-16 15:37	2026-09-16 15:37	2026-09-16 15:37	XLE	XLE271217C00060000	call	60.0000	2027-12-17	9.8200	9.8000	10.1000	63.8050	38292.00	0.00	38292.00	39	7	66	5297	0.0124598829526147	0.203544341797954	0.205696606270775	false	false	false	true
f379eea0-87ed-4295-bb31-12273990e125	2026-09-16 15:36	2026-09-16 15:36	2026-09-16 15:36	XLE	XLE260918C00065000	call	65.0000	2026-09-18	0.2000	0.1800	0.2000	63.8250	40000.00	40000.00	0.00	2000	36	7434	47643	0.156035514136389	0.322589067894173	0.322589067894173	false	false	false	true
b3699ff6-1fb7-40b1-9837-936d7ba44e0a	2026-09-16 15:27	2026-09-16 15:26	2026-09-16 15:26	XLE	XLE260925P00063500	put	63.5000	2026-09-25	1.1900	1.1800	1.2300	63.7350	31416.00	0.00	31416.00	264	42	3689	2453	1.50387280880554	0.334681559135807	0.334681559135807	false	false	false	true
2cdf78c5-a3f1-4a52-9ad1-86e8689d71dd	2026-09-16 15:27	2026-09-16 15:26	2026-09-16 15:26	XLE	XLE260925P00063500	put	63.5000	2026-09-25	1.2000	1.2000	1.2300	63.7450	28800.00	0.00	28800.00	240	17	3413	2453	1.39135752140236	0.338347011127566	0.338347011127566	false	false	false	true
809c691a-c03f-48f7-9755-57569da91b88	2026-09-16 15:26	2026-09-16 15:26	2026-09-16 15:26	XLE	XLE260925P00063500	put	63.5000	2026-09-25	1.2000	1.1900	1.2000	63.7450	21000.00	21000.00	0.00	175	7	3173	2453	1.29351814105177	0.338347011127566	0.338347011127566	true	false	false	true
2626f848-60b1-4baf-b262-f97c27233da9	2026-09-16 15:26	2026-09-16 15:26	2026-09-16 15:26	XLE	XLE260918C00066000	call	66.0000	2026-09-18	0.0600	0.0500	0.0700	63.7350	18336.00	0.00	11130.00	3056	19	8823	17990	0.490439132851584	0.33635105701725	0.33635105701725	false	false	false	true
a7419ac3-83be-4fa4-a572-b9f6b45b7d8b	2026-09-16 15:26	2026-09-16 15:26	2026-09-16 15:26	XLE	XLE260918P00065000	put	65.0000	2026-09-18	1.3900	1.3800	1.3900	63.7750	11259.00	11259.00	0.00	81	22	7821	19544	0.400173966434711	0.315499730289885	0.315499730289885	true	false	false	true
dc8bbb7f-630e-46d3-9e13-3363d2897a2b	2026-09-16 15:22	2026-09-16 15:22	2026-09-16 15:22	XLE	XLE261218C00072500	call	72.5000	2026-12-18	1.0000	0.9900	1.0700	63.7350	10100.00	100.00	10000.00	101	6	122	4831	0.0252535706892983	0.272007137943993	0.272007137943993	true	false	false	true
7375a16d-a2c5-4095-b323-c2384f785ff8	2026-09-16 15:22	2026-09-16 15:22	2026-09-16 15:22	XLE	XLE261016P00064000	put	64.0000	2026-10-16	2.1400	2.1400	2.2500	63.7350	21400.00	0.00	21400.00	100	12	3988	22373	0.178250569883342	0.289482393537435	0.289482393537435	false	false	false	true
33973b8d-c671-413d-b66f-71e989b84ed6	2026-09-16 15:12	2026-09-16 15:12	2026-09-16 15:12	XLE	XLE261009C00070000	call	70.0000	2026-10-09	0.2200	0.2200	0.2800	63.9700	27566.00	0.00	27566.00	1253	37	1294	165	7.84242424242424	0.2735995328444	0.2735995328444	false	false	false	true
1d8035fe-8f1d-44c0-9573-76bb7e92cb82	2026-09-16 15:12	2026-09-16 15:12	2026-09-16 15:12	XLE	XLE261009C00067000	call	67.0000	2026-10-09	0.6600	0.6600	0.6900	63.9700	227502.00	0.00	227502.00	3447	21	3458	625	5.5328	0.263828422546374	0.263828422546374	false	false	false	true
0091190b-8f37-44bb-a350-108ffa3aa64d	2026-09-16 15:10	2026-09-16 15:10	2026-09-16 15:10	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.5500	1.5400	1.6000	64.0350	31620.00	10540.00	21080.00	204	13	363	7792	0.0465862422997947	0.266318448033975	0.266318448033975	false	false	false	true
b06736d9-dec8-4708-a489-4756ece387e7	2026-09-16 15:07	2026-09-16 15:07	2026-09-16 15:07	XLE	XLE260925C00066000	call	66.0000	2026-09-25	0.3800	0.3800	0.4000	64.1350	174800.00	0.00	174800.00	4600	37	5790	922	6.27982646420824	0.2558467463971	0.2558467463971	false	false	false	true
6b67c090-dbfe-45cf-8606-8c0a2d4e634a	2026-09-16 15:07	2026-09-16 15:07	2026-09-16 15:07	XLE	XLE260925C00065000	call	65.0000	2026-09-25	0.6600	0.6600	0.7100	64.1350	48906.00	0.00	48906.00	741	29	2139	1387	1.54217736121125	0.250040467595917	0.250040467595917	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
536ab777-d07e-47bb-a4b0-914adbeab31f	2026-09-16 15:04	2026-09-16 15:04	2026-09-16 15:04	XLE	XLE261016P00060000	put	60.0000	2026-10-16	0.6300	0.6000	0.6300	64.1900	17640.00	17640.00	0.00	280	9	6762	37787	0.178950432688491	0.302896326202258	0.302896326202258	false	false	false	true
bb898c67-a322-442f-ab8b-4ff7dd2f8075	2026-09-16 15:01	2026-09-16 15:01	2026-09-16 15:01	XLE	XLE260925C00067000	call	67.0000	2026-09-25	0.2400	0.2400	0.2600	64.3300	11448.00	0.00	11448.00	477	23	742	3308	0.224304715840387	0.261872740930608	0.261872740930608	false	false	false	true
e9905f5f-d8cc-45a1-be61-4c3a74116639	2026-09-16 14:54	2026-09-16 14:54	2026-09-16 14:54	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5600	2.5000	2.5600	64.2700	10496.00	10496.00	0.00	41	10	986	15647	0.0630152744935131	0.279094546212962	0.279094546212962	false	false	false	true
c9606b1f-b4d0-4c04-a328-48a58e345df3	2026-09-16 14:49	2026-09-16 14:49	2026-09-16 14:49	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5400	2.4900	2.5400	64.3400	12192.00	12192.00	0.00	48	12	937	15647	0.0598836837732473	0.279102985136957	0.279102985136957	false	false	false	true
e782617f-62db-449f-bd7c-9e3600451bf2	2026-09-16 14:46	2026-09-16 14:46	2026-09-16 14:46	XLE	XLE270319P00060000	put	60.0000	2027-03-19	2.5400	2.4400	2.5400	64.3700	13970.00	13970.00	0.00	55	17	886	15647	0.0566242730235828	0.279931520999164	0.279655546760572	false	false	false	true