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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	39654329160.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T14:53:23.630136Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
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
840bbc6f-f387-4f56-8f9f-643be75b2827	2026-09-22 14:03	2026-09-22 14:03	2026-09-22 14:03	XLE	XLE260925P00062000	put	62.0000	2026-09-25	0.6500	0.6500	0.6800	62.1350	13910.00	0.00	13910.00	214	15	3284	9883	0.332287766872407	0.324028889616478	0.323000977012383	false	false	false	true
9b9b018c-ad9a-47e5-89dd-b59bca3bdba2	2026-09-22 13:59	2026-09-22 13:59	2026-09-22 13:59	XLE	XLE260928P00062000	put	62.0000	2026-09-28	0.8000	0.7900	0.8800	61.9600	30080.00	3920.00	26160.00	376	5	661	219	3.01826484018265	0.252495407238694	0.252495407238694	false	false	false	true
e4e2e1f7-8756-4bcb-8105-702536c21418	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.2000	2.1900	2.2200	61.8494	27500.00	27280.00	220.00	125	7	15843	47499	0.333543864081349	0.26036560004277	0.26036560004277	false	false	false	true
960e65c2-960e-473e-b406-3dfa21910c1e	2026-09-22 13:57	2026-09-22 13:56	2026-09-22 13:56	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.2000	2.1100	2.2000	61.8600	42020.00	42020.00	0.00	191	12	15635	47499	0.329164824522622	0.261357225261912	0.261357225261912	false	false	false	true
1d08773d-5d10-46e6-b782-3e912665b433	2026-09-22 13:56	2026-09-22 13:56	2026-09-22 13:56	XLE	XLE261016P00060500	put	60.5000	2026-10-16	1.0000	0.9700	1.0100	61.8900	14800.00	11100.00	0.00	148	19	312	3018	0.10337972166998	0.26560904723002	0.26560904723002	true	false	false	true
d08d1923-1ba3-4e50-b1e8-d44a00c13b2c	2026-09-22 13:56	2026-09-22 13:56	2026-09-22 13:56	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.1500	2.1000	2.1800	61.9300	12040.00	12040.00	0.00	56	6	15401	47499	0.324238405019053	0.259803221169774	0.259803221169774	false	false	false	true
f3702319-6fef-4c17-b800-ae0d47adaa5a	2026-09-22 13:55	2026-09-22 13:54	2026-09-22 13:54	XLE	XLE261016P00063000	put	63.0000	2026-10-16	2.1000	2.0000	2.1200	61.9800	47670.00	47670.00	0.00	227	6	15306	47499	0.322238362912903	0.256367687572425	0.256367687572425	false	false	false	true
0b6dc4fe-60a4-4906-913d-03881838a113	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	XLE	XLE261016P00062000	put	62.0000	2026-10-16	1.4700	1.4400	1.4700	62.1900	22491.00	22491.00	0.00	153	18	1848	23072	0.0800970873786408	0.258502600314459	0.258502600314459	true	false	false	true
adc3faa7-cf04-4159-a7f9-ba273eb0d759	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	XLE	XLE261016P00062000	put	62.0000	2026-10-16	1.4600	1.4600	1.4800	62.2050	30660.00	0.00	11242.00	210	35	1684	23072	0.0729889042995839	0.257277753711347	0.257992983567856	false	false	false	true
bf080eb3-99cc-4686-ac41-9c3adf8fdbf5	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	XLE	XLE261030P00062000	put	62.0000	2026-10-30	1.8300	1.6800	1.8300	62.2450	10065.00	10065.00	0.00	55	12	104	178	0.584269662921348	0.260067242801453	0.260067242801453	true	false	false	true
c1642831-5924-4dcd-b946-60ee1c56b3e8	2026-09-22 13:52	2026-09-22 13:51	2026-09-22 13:51	XLE	XLE261218P00062500	put	62.5000	2026-12-18	3.0500	2.9200	3.1000	62.2738	16165.00	15860.00	305.00	53	6	82	62566	0.00131061598951507	0.269143049242454	0.268344011324968	true	false	false	true