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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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

9e7cfdd7-45ce-48d6-937a-b78592915cb2	2026-09-23 11:00	2026-09-23 11:00	2026-09-23 11:00	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1600	2.1600	2.3100	62.0000	11880.00	0.00	11880.00	55	9	1574	2809	0.560341758632965	0.267058460437729	0.267058460437729	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	39654329160.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T15:00:57.901243Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
3068cfdb-001c-4527-8608-5b4ab60e383e	2026-09-23 10:56	2026-09-23 10:56	2026-09-23 10:56	XLE	XLE261218P00062500	put	62.5000	2026-12-18	3.0000	3.0000	3.0500	62.2310	120300.00	0.00	120300.00	401	8	1951	62585	0.0311736038986978	0.263736192760159	0.263736192760159	false	false	false	true
2769ddbd-ea43-454e-a832-3f91704f5f22	2026-09-23 10:55	2026-09-23 10:55	2026-09-23 10:55	XLE	XLE261016C00063500	call	63.5000	2026-10-16	1.1800	1.1400	1.1800	62.2950	11210.00	11210.00	0.00	95	15	195	878	0.222095671981777	0.262443665923208	0.262443665923208	true	false	false	true
2f43a075-56f1-42b3-8294-c62669b8dbd7	2026-09-23 10:55	2026-09-23 10:55	2026-09-23 10:55	XLE	XLE261120P00064000	put	64.0000	2026-11-20	3.4000	3.2000	3.4000	62.3100	14280.00	14280.00	0.00	42	7	42	563	0.0746003552397869	0.271331305015141	0.271331305015141	false	false	false	true
5319eb72-f2db-41cc-9cde-27028e25c8f2	2026-09-23 10:55	2026-09-23 10:54	2026-09-23 10:55	XLE	XLE260925P00061500	put	61.5000	2026-09-25	0.3300	0.2700	0.3400	62.0000	18644.00	13298.00	2574.00	565	63	2770	942	2.94055201698514	0.364895595581341	0.366774965364319	true	false	false	true
54c33ec2-6527-466a-b6c3-d1f4c5ff7f9d	2026-09-23 10:55	2026-09-23 10:54	2026-09-23 10:54	XLE	XLE260925C00062500	call	62.5000	2026-09-25	0.5800	0.5400	0.6000	62.0000	11541.00	11426.00	115.00	199	22	381	1142	0.333625218914186	0.354265468479555	0.354265468479555	true	false	false	true
4cd423b6-c211-4dfe-bf33-9cb869e33690	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1600	2.1700	62.0000	66402.00	66402.00	0.00	306	50	1421	2809	0.505873976504094	0.265658277721717	0.265764887335764	false	false	false	true
d5564c83-7466-48a1-8f2f-09f0ecb6d97b	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1100	2.1700	62.0000	20398.00	20398.00	0.00	94	14	967	2809	0.344250622997508	0.266240448901323	0.266240448901323	false	false	false	true
a6cae1d9-0f6a-4851-8de8-edd3a19de224	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1100	2.1700	62.0000	11935.00	11935.00	0.00	55	6	1022	2809	0.363830544677821	0.265860048538026	0.265860048538026	false	false	false	true
688dae57-fbb1-4e43-a9ca-6e3135d85888	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1100	2.1700	62.0000	11935.00	11935.00	0.00	55	12	854	2809	0.304022783908864	0.266810318230172	0.266810318230172	false	false	false	true
5ce0ee00-d180-4244-b176-6275027e45de	2026-09-23 10:52	2026-09-23 10:52	2026-09-23 10:52	XLE	XLE260928P00062000	put	62.0000	2026-09-28	0.5100	0.5000	0.5100	62.4695	29325.00	29325.00	0.00	575	37	788	229	3.4410480349345	0.252782803964203	0.252782803964203	false	false	false	true
15cb5129-a8cf-40b9-b062-2c8f8b858c7b	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1600	2.1700	62.3500	12369.00	12369.00	0.00	57	10	778	2809	0.276966892132431	0.266810318230172	0.266050297570141	false	false	false	true
b9cdd72e-968b-41aa-820e-7ed623df9c5b	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1600	2.1700	62.3514	26474.00	26474.00	0.00	122	26	707	2809	0.251690993236027	0.266715400799292	0.266076924634568	false	false	false	true
44eac754-76e3-418e-9c1c-b4ee8d566a77	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1600	2.1700	62.3950	14322.00	14322.00	0.00	66	7	582	2809	0.207191171235315	0.266810318230172	0.266905211389455	false	false	false	true
d8dd93f9-c459-474c-adda-c2210c879921	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1600	2.1700	62.3900	10416.00	10416.00	0.00	48	7	512	2809	0.182271270914916	0.266810318230172	0.266810318230172	false	false	false	true
9eac2cfd-56aa-419c-a56e-a75c40dd6c05	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1600	2.1700	62.4250	26691.00	26691.00	0.00	123	24	450	2809	0.160199359202563	0.268231177731309	0.267474061707738	false	false	false	true
3afb8181-5202-4fec-a297-fa3fee0d951f	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1600	2.1700	62.4250	11935.00	11935.00	0.00	55	7	327	2809	0.116411534353863	0.267474061707738	0.267474061707738	false	false	false	true
cf529c3a-72fe-4910-8d88-6ffc9d38bf28	2026-09-23 10:51	2026-09-23 10:51	2026-09-23 10:51	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1500	2.1700	62.4500	23436.00	23436.00	0.00	108	21	264	2809	0.0939836240655037	0.2679474396509	0.2679474396509	false	false	false	true
b618875c-a05e-48c5-9965-c5c394b77703	2026-09-23 10:48	2026-09-23 10:48	2026-09-23 10:48	XLE	XLE270319P00058000	put	58.0000	2027-03-19	2.1700	2.1600	2.1700	62.4900	11718.00	11718.00	0.00	54	9	102	2809	0.036311854752581	0.268703595010822	0.268703595010822	false	false	false	true
b00474c4-3612-4ff7-9ec2-3a75dde77a78	2026-09-23 10:48	2026-09-23 10:48	2026-09-23 10:48	XLE	XLE261016P00062000	put	62.0000	2026-10-16	1.2700	1.2600	1.2700	62.4950	29083.00	29083.00	0.00	229	16	469	25120	0.0186703821656051	0.25279836693262	0.25279836693262	false	false	false	true
3cec4716-0031-4ef4-8b70-f285b00e4b55	2026-09-23 10:48	2026-09-23 10:48	2026-09-23 10:48	XLE	XLE261218P00059000	put	59.0000	2026-12-18	1.5000	1.4300	1.5300	62.5200	20255.00	455.00	19800.00	135	22	135	2772	0.0487012987012987	0.269606785373567	0.267646776366109	true	false	false	true
268e6b26-507a-4606-9078-fd73a8c09d80	2026-09-23 10:43	2026-09-23 10:43	2026-09-23 10:43	XLE	XLE261002P00062000	put	62.0000	2026-10-02	0.6800	0.6500	0.6800	62.7250	16660.00	16660.00	0.00	245	7	396	496	0.798387096774194	0.262595337718404	0.262595337718404	false	false	false	true
d577653e-ba1f-4980-bbb8-6ea18c4e269e	2026-09-23 10:43	2026-09-23 10:43	2026-09-23 10:43	XLE	XLE260923C00063000	call	63.0000	2026-09-23	0.1100	0.0900	0.1200	62.7450	55319.00	54120.00	319.00	5029	88	6465	1835	3.52316076294278	0.346401722125627	0.346401722125627	true	false	false	true
73829c48-d98c-4de3-9d02-3275efa7c8ec	2026-09-23 10:30	2026-09-23 10:30	2026-09-23 10:30	XLE	XLE260925P00063000	put	63.0000	2026-09-25	0.6800	0.6700	0.6800	62.7550	38692.00	38692.00	0.00	569	24	672	8615	0.0780034822983169	0.296783660980846	0.299861873948098	true	false	false	true
4f258c32-fe7e-4403-84e9-a5e6870e0ab8	2026-09-23 10:24	2026-09-23 10:24	2026-09-23 10:24	XLE	XLE261218C00066000	call	66.0000	2026-12-18	2.2000	2.2000	2.2900	62.7450	11440.00	0.00	11440.00	52	7	363	3451	0.105186902347146	0.269892540093142	0.269892540093142	false	false	false	true
280bdd6f-7a95-455a-a720-5ad4d0fb63d2	2026-09-23 10:15	2026-09-23 10:15	2026-09-23 10:15	XLE	XLE260930C00064000	call	64.0000	2026-09-30	0.4200	0.4200	0.4500	62.8200	21000.00	0.00	21000.00	500	5	1180	19651	0.0600478347157905	0.248827513591832	0.248827513591832	false	false	false	true
597eecfd-baf0-4598-8027-4f591b0b84ab	2026-09-23 10:09	2026-09-23 10:09	2026-09-23 10:09	XLE	XLE261023P00063000	put	63.0000	2026-10-23	1.9700	1.9200	1.9700	62.5200	58312.00	58312.00	0.00	296	18	307	118	2.60169491525424	0.255325509648296	0.255325509648296	false	false	false	true
3c364779-626a-4cd7-9586-013e734b12b1	2026-09-23 09:59	2026-09-23 09:59	2026-09-23 09:59	XLE	XLE270115C00062500	call	62.5000	2027-01-15	4.0500	4.0000	4.1000	62.6900	405000.00	149445.00	405.00	1000	5	3520	4388	0.802187784867821	0.254020621875798	0.254020621875798	false	false	false	true
cbf5d11a-254c-4a4a-9efe-d86e7b93c75e	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	XLE	XLE260925P00061500	put	61.5000	2026-09-25	0.2400	0.2400	0.2600	62.0000	46344.00	0.00	46344.00	1931	31	1942	942	2.06157112526539	0.356850237305862	0.356850237305862	false	false	false	true
bf304c51-46ea-4500-88e3-cb886b043a79	2026-09-23 09:46	2026-09-23 09:46	2026-09-23 09:46	XLE	XLE261120C00067000	call	67.0000	2026-11-20	1.2000	1.1600	1.2200	62.0000	19200.00	18000.00	1200.00	160	8	162	1150	0.140869565217391	0.270955130823473	0.270955130823473	true	false	false	true
45214c8f-f206-4405-862b-b6f58a3cfb4e	2026-09-23 09:46	2026-09-23 09:45	2026-09-23 09:45	XLE	XLE261016C00062500	call	62.5000	2026-10-16	1.6700	1.6000	1.6700	62.0000	16199.00	16199.00	0.00	97	14	104	127	0.818897637795276	0.255773620187265	0.255773620187265	true	false	false	true
7a4ecabd-b916-4cc6-a875-d757d29cb56e	2026-09-23 09:45	2026-09-23 09:45	2026-09-23 09:45	XLE	XLE261030C00065000	call	65.0000	2026-10-30	1.1600	1.1300	1.1700	62.0000	31189.00	31189.00	0.00	268	22	536	75	7.14666666666667	0.263802349840153	0.263566260977156	false	false	false	true
738906f6-64e8-46ea-9248-4a325dc2d567	2026-09-23 09:44	2026-09-23 09:44	2026-09-23 09:44	XLE	XLE261030C00065000	call	65.0000	2026-10-30	1.1400	1.1200	1.1400	62.0000	17100.00	17100.00	0.00	150	5	267	75	3.56	0.263465771092771	0.263465771092771	false	false	false	true
6807a530-207b-49d2-b2d5-75100ae76c9d	2026-09-23 09:42	2026-09-23 09:42	2026-09-23 09:42	XLE	XLE270115C00062500	call	62.5000	2027-01-15	3.8500	3.8000	3.9000	62.3100	311850.00	234850.00	7700.00	810	12	2201	4388	0.501595259799453	0.255100800024537	0.255100800024537	false	false	false	true
d5c8b9ab-7e32-4387-b3c7-718f17c85cab	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	XLE	XLE260930P00065000	put	65.0000	2026-09-30	3.3000	3.2000	3.3000	61.0000	16170.00	16170.00	0.00	49	18	134	635	0.211023622047244	0.269555051178736	0.269555051178736	false	false	false	true
fbebe756-b399-407a-bc4d-cb126be49919	2026-09-22 15:55	2026-09-22 15:54	2026-09-22 15:54	XLE	XLE261002P00059000	put	59.0000	2026-10-02	0.2600	0.2400	0.2600	61.0000	68380.00	68380.00	0.00	2630	24	2855	1624	1.75800492610837	0.297027158677334	0.297027158677334	true	false	false	true
92b3da17-c146-4ae0-b364-d9ee2946f26d	2026-09-22 15:49	2026-09-22 15:49	2026-09-22 15:49	XLE	XLE261218C00065000	call	65.0000	2026-12-18	2.2000	2.2000	2.2500	61.8000	41140.00	0.00	41140.00	187	17	1585	40354	0.0392773950537741	0.27072445525306	0.27072445525306	false	false	false	true
d2c65f12-0e9d-4173-96ee-82855e4cae4c	2026-09-22 15:40	2026-09-22 15:39	2026-09-22 15:39	XLE	XLE261218C00065000	call	65.0000	2026-12-18	2.2400	2.1900	2.2500	61.8400	15232.00	6496.00	8736.00	68	13	1354	40354	0.0335530554591862	0.27275256038932	0.27275256038932	false	false	false	true
c4c1ddfc-48b4-4f0a-bd91-88cc98a96413	2026-09-22 15:38	2026-09-22 15:38	2026-09-22 15:38	XLE	XLE260928C00062000	call	62.0000	2026-09-28	0.7100	0.6400	0.7200	61.7850	16826.00	16614.00	212.00	237	27	300	22	13.6363636363636	0.250987978980662	0.250987978980662	true	false	false	true
a082b7f1-759f-4824-b3df-7e33e8d91375	2026-09-22 15:38	2026-09-22 15:38	2026-09-22 15:38	XLE	XLE260928P00062000	put	62.0000	2026-09-28	0.8800	0.8200	0.8900	61.7850	15224.00	15224.00	0.00	173	21	1117	219	5.10045662100457	0.249511599354749	0.249511599354749	true	false	false	true
87e24af6-1c9f-4b5a-8767-4933cf5cebbd	2026-09-22 15:36	2026-09-22 15:36	2026-09-22 15:36	XLE	XLE260925P00061000	put	61.0000	2026-09-25	0.3600	0.3300	0.4150	61.8100	94896.00	94860.00	36.00	2636	46	6236	1078	5.7847866419295	0.315067141693422	0.314279917972653	false	false	false	true
a2d4cc53-cba0-46f0-9196-0357ab8c90ce	2026-09-22 15:35	2026-09-22 15:35	2026-09-22 15:35	XLE	XLE260925P00061500	put	61.5000	2026-09-25	0.5100	0.4800	0.5200	61.8200	21165.00	21063.00	102.00	415	8	749	447	1.67561521252796	0.298807553681038	0.298807553681038	false	false	false	true
5fa42ee0-88f4-4ea8-b9a8-58b8dafa8f8f	2026-09-22 15:01	2026-09-22 15:00	2026-09-22 15:00	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.0000	1.9600	2.0200	62.1200	11400.00	11400.00	0.00	57	7	16572	47499	0.348891555611697	0.253001162825277	0.253001162825277	false	false	false	true
665a0df2-5f95-42f8-91fe-5294d9c6d9e9	2026-09-22 15:00	2026-09-22 15:00	2026-09-22 15:00	XLE	XLE261218C00065000	call	65.0000	2026-12-18	2.3500	2.3500	2.4300	62.1200	10340.00	0.00	10340.00	44	5	1164	40354	0.0288447241909104	0.272242219750572	0.272242219750572	false	false	false	true
59b3293d-f998-4500-899c-8e56a3b1870a	2026-09-22 14:51	2026-09-22 14:51	2026-09-22 14:51	XLE	XLE261016C00065000	call	65.0000	2026-10-16	0.6500	0.6500	0.6600	62.1850	73970.00	0.00	73970.00	1138	44	5022	19760	0.25414979757085	0.253371242418182	0.253371242418182	true	false	false	true
fc47c435-6c8d-458d-8b6c-9b637c92a7b7	2026-09-22 14:47	2026-09-22 14:47	2026-09-22 14:47	XLE	XLE261016C00065000	call	65.0000	2026-10-16	0.6700	0.6700	0.6800	62.1950	99227.00	0.00	99227.00	1481	8	3812	19760	0.192914979757085	0.256627500570966	0.256627500570966	true	false	false	true
dd053e4f-2a8c-40ed-ae8e-1aeeedd616f8	2026-09-22 14:46	2026-09-22 14:46	2026-09-22 14:46	XLE	XLE261120P00060000	put	60.0000	2026-11-20	1.5400	1.5000	1.5400	62.2200	376376.00	376376.00	0.00	2444	65	2890	9239	0.312804416062344	0.270887807132595	0.270887807132595	true	false	false	true
f2ff381e-859b-41f3-9f9f-8f7a1956ad36	2026-09-22 14:39	2026-09-22 14:39	2026-09-22 14:39	XLE	XLE261009P00060000	put	60.0000	2026-10-09	0.5400	0.5200	0.5500	62.1800	21222.00	21168.00	54.00	393	7	744	240	3.1	0.265827441981521	0.265827441981521	false	false	false	true
6c03e46b-bce1-42f3-b33a-029209f9ff16	2026-09-22 14:20	2026-09-22 14:20	2026-09-22 14:20	XLE	XLE261016C00064000	call	64.0000	2026-10-16	1.0300	1.0000	1.0300	62.2900	77250.00	77250.00	0.00	750	41	2276	7101	0.320518236868047	0.262168045201689	0.262168045201689	true	false	false	true
0fb4e8eb-b0a0-4e79-9738-76d8c9ce880e	2026-09-22 14:19	2026-09-22 14:19	2026-09-22 14:19	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.0100	1.9800	2.0500	62.2000	21906.00	0.00	21906.00	109	8	16177	47499	0.340575591065075	0.258708633637008	0.260011125092252	true	false	false	true