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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:ticker = XLE×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	pricenumeric

c7912aaf-29be-4727-bc20-12c4a6db53a7	2026-08-19 09:38	2026-08-19 09:38	2026-08-19 09:38	XLE	XLE260828C00064000	call	64.0000	2026-08-28	0.9700	0.9500	1.0200	63.8552	19400.00	14550.00	4850.00	200	7	206	447	0.460850111856823	0.252840121279579	0.252840121279579	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-08-19T13:40:44.275238Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
dba2458a-fb61-453f-92a7-42a4e5d2c8e0	2026-08-19 10:09	2026-08-19 10:09	2026-08-19 10:09	XLE	XLE271217C00080000	call	80.0000	2027-12-17	3.1000	3.1000	3.1500	63.9900	53630.00	0.00	53630.00	173	30	206	8820	0.0233560090702948	0.236219136913179	0.236219136913179	false	false	false	true	false
7fb0264a-9d08-4acd-8f77-111f70dd7b79	2026-08-19 10:10	2026-08-19 10:10	2026-08-19 10:10	XLE	XLE271217C00080000	call	80.0000	2027-12-17	3.1500	3.1500	3.2000	63.9879	29610.00	0.00	14490.00	94	30	4037	8820	0.457709750566893	0.238147849429855	0.238147849429855	false	false	false	true	false
1593df49-007f-4291-8bf4-e6a4ac397ecb	2026-08-19 10:10	2026-08-19 10:10	2026-08-19 10:10	XLE	XLE271217C00080000	call	80.0000	2027-12-17	3.1500	3.0000	3.2000	63.9879	1177154.00	1125179.00	48195.00	3737	77	3943	8820	0.447052154195011	0.238303764497068	0.237767598610863	true	false	false	true	false
4a453cba-c8c8-460c-8f28-c9a6fbdf8073	2026-08-19 10:10	2026-08-19 10:10	2026-08-19 10:10	XLE	XLE271217C00080000	call	80.0000	2027-12-17	3.1500	3.1500	3.2000	64.0250	24885.00	0.00	24885.00	79	16	4257	8820	0.48265306122449	0.237699479742314	0.237699479742314	false	false	false	true	false
11afaa03-8f3f-4f43-8210-1d14aee05a3d	2026-08-19 10:49	2026-08-19 10:49	2026-08-19 10:49	XLE	XLE261016P00065000	put	65.0000	2026-10-16	3.1000	3.1000	3.1500	64.0050	17980.00	0.00	17980.00	58	16	150	133	1.12781954887218	0.272844994053823	0.272844994053823	false	false	false	true	false
e79efeb4-e9e6-4c70-a41b-49bfdcb3b7cf	2026-08-19 11:02	2026-08-19 11:02	2026-08-19 11:02	XLE	XLE261016C00075000	call	75.0000	2026-10-16	0.2600	0.2600	0.2700	64.0550	14457.00	27.00	14430.00	556	13	561	595	0.942857142857143	0.270751129894333	0.268282498002377	false	false	false	true	false
3347d7ac-3156-4c3e-b0bf-536b668bc47d	2026-08-19 11:32	2026-08-19 11:32	2026-08-19 11:32	XLE	XLE260930C00075000	call	75.0000	2026-09-30	0.1400	0.1400	0.1800	63.9650	23072.00	0.00	23072.00	1648	11	1651	331	4.98791540785498	0.279108108439091	0.279108108439091	false	false	false	true	false
06f0e21a-8b81-4a3e-aea4-17df2a51ebbe	2026-08-19 11:36	2026-08-19 11:36	2026-08-19 11:36	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.5000	6.4500	6.6000	63.9200	130570.00	0.00	130570.00	201	8	411	29129	0.0141096501767998	0.22618356488822	0.225438674525139	false	false	false	true	false
7b16cb59-d9b4-4492-b4d0-fd6411b95e97	2026-08-19 11:37	2026-08-19 11:37	2026-08-19 11:37	XLE	XLE270115C00060000	call	60.0000	2027-01-15	6.4500	6.4500	6.6000	63.9201	129645.00	0.00	129645.00	201	11	685	29129	0.0235160836279996	0.222446165430699	0.222446165430699	false	false	false	true	false
15d1f2de-b097-4b89-9996-88fa82431d89	2026-08-19 11:46	2026-08-19 11:46	2026-08-19 11:46	XLE	XLE261016C00068000	call	68.0000	2026-10-16	1.0900	1.0800	1.1200	63.7950	48723.00	109.00	7957.00	447	10	483	3933	0.12280701754386	0.244299862705772	0.244299862705772	true	false	false	true	false
0b528c0d-3c05-4c0a-87bb-4d307c69c368	2026-08-19 11:49	2026-08-19 11:49	2026-08-19 11:49	XLE	XLE260930C00070000	call	70.0000	2026-09-30	0.4000	0.4000	0.4600	63.7400	40197.00	0.00	40197.00	1000	6	1119	4053	0.276091783863805	0.245089354996492	0.245089354996492	false	false	false	true	false
92e43902-7021-4319-bd24-1246848279b6	2026-08-19 11:51	2026-08-19 11:51	2026-08-19 11:51	XLE	XLE260828C00059000	call	59.0000	2026-08-28	4.9000	4.9000	4.9500	63.7550	12250.00	0.00	3430.00	25	18	25	1829	0.0136686714051394	0.329871621129149	0.329871621129149	false	false	false	true	false
e327a544-7fdc-4310-bbc6-4e2001b761b5	2026-08-19 11:51	2026-08-19 11:51	2026-08-19 11:51	XLE	XLE260911C00062500	call	62.5000	2026-09-11	2.2800	2.2800	2.4400	63.7401	13680.00	0.00	13680.00	60	9	97	112	0.866071428571429	0.234980151857658	0.234980151857658	false	false	false	true	false
4700ac08-31bd-4cee-ae81-603ce85d4f8e	2026-08-19 11:58	2026-08-19 11:58	2026-08-19 11:58	XLE	XLE280121P00067500	put	67.5000	2028-01-21	8.9000	8.6500	8.9000	63.7500	56960.00	56960.00	0.00	64	5	192	77	2.49350649350649	0.297772460911568	0.297772460911568	false	false	false	true	false
7af5724b-27f6-4ff5-990a-62f9e907541c	2026-08-19 11:58	2026-08-19 11:58	2026-08-19 11:58	XLE	XLE281215P00050000	put	50.0000	2028-12-15	3.0500	2.8500	3.0500	63.7500	27755.00	27755.00	0.00	91	7	93	2078	0.0447545717035611	0.293257656162173	0.293257656162173	false	false	false	true	false
8e4f08ab-1cc7-46e0-afdc-8b99a2426fb6	2026-08-19 11:58	2026-08-19 11:58	2026-08-19 11:58	XLE	XLE281215P00050000	put	50.0000	2028-12-15	3.0500	2.8500	3.0500	63.7500	30195.00	30195.00	0.00	99	5	192	2078	0.0923965351299326	0.293257656162173	0.293257656162173	false	false	false	true	false
bcc81fad-451b-4a6a-9aca-5198531fd567	2026-08-19 11:59	2026-08-19 11:58	2026-08-19 11:58	XLE	XLE281215P00050000	put	50.0000	2028-12-15	3.0500	2.8500	3.0500	63.7550	22265.00	22265.00	0.00	73	5	372	2078	0.179018286814244	0.293291645070099	0.293291645070099	false	false	false	true	false
efe92eb5-6a71-4aa1-8a1f-6be7b749a421	2026-08-19 11:59	2026-08-19 11:58	2026-08-19 11:58	XLE	XLE281215P00045000	put	45.0000	2028-12-15	1.9800	1.6900	1.9900	63.7550	19022.00	18640.00	382.00	96	11	97	16295	0.00595274624117828	0.299046399359786	0.294752722110098	true	false	false	true	false
e32b4fdc-413b-45ce-b3ca-ca684acc587c	2026-08-19 12:02	2026-08-19 12:02	2026-08-19 12:02	XLE	XLE261218C00062500	call	62.5000	2026-12-18	4.7000	4.5500	4.7000	63.7850	47000.00	47000.00	0.00	100	10	319	25171	0.0126733145286242	0.246860535948995	0.246860535948995	false	false	false	true	false
e91c4b55-42c3-4f11-8631-d94142f2c9c1	2026-08-19 12:35	2026-08-19 12:35	2026-08-19 12:35	XLE	XLE261016C00065000	call	65.0000	2026-10-16	2.0100	2.0000	2.0300	63.7401	466923.00	603.00	466320.00	2323	25	2507	3438	0.729203025014543	0.237083076018384	0.237083076018384	false	false	false	true	false
e2976e58-2a11-4f7e-9643-b8c3f971dbcb	2026-08-19 12:46	2026-08-19 12:46	2026-08-19 12:46	XLE	XLE260821C00064000	call	64.0000	2026-08-21	0.3600	0.3600	0.3800	63.7550	50076.00	0.00	50076.00	1391	71	3621	13859	0.261274262212281	0.247460381977926	0.247460381977926	false	false	false	true	false
800bcb51-0522-4d09-a84d-c94150f6f219	2026-08-19 12:47	2026-08-19 12:47	2026-08-19 12:47	XLE	XLE260821C00064000	call	64.0000	2026-08-21	0.3600	0.3500	0.3800	63.7750	42444.00	2196.00	40248.00	1179	78	4819	13859	0.34771628544628	0.241679813786485	0.242841553976251	false	false	false	true	false
32192056-ec34-421f-9436-cce759198c17	2026-08-19 12:48	2026-08-19 12:48	2026-08-19 12:48	XLE	XLE260821C00064000	call	64.0000	2026-08-21	0.3600	0.3600	0.3800	63.7850	14400.00	0.00	14400.00	400	18	5230	13859	0.377372104769464	0.240515185284441	0.240515185284441	false	false	false	true	false
58434df2-a0b2-4c6b-9d3e-fe6fb1d62501	2026-08-19 13:25	2026-08-19 13:25	2026-08-19 13:25	XLE	XLE260821C00064000	call	64.0000	2026-08-21	0.3500	0.3200	0.3500	63.7150	26110.00	26110.00	0.00	746	64	6011	13859	0.433725377011328	0.251128788489624	0.251128788489624	true	false	false	true	false
801e3024-d71c-4ca4-bc92-82d1ace31889	2026-08-19 13:26	2026-08-19 13:26	2026-08-19 13:26	XLE	XLE260821C00060000	call	60.0000	2026-08-21	3.7500	3.7500	3.8000	63.7300	15375.00	0.00	15375.00	41	6	300	58693	0.005111342068049	0.366930332704089	0.366930332704089	false	false	false	true	false
3a54563d-6aaa-403f-ac9e-7dfb79017ca5	2026-08-19 13:30	2026-08-19 13:30	2026-08-19 13:30	XLE	XLE261218C00080000	call	80.0000	2026-12-18	0.4300	0.4300	0.4500	63.6550	133558.00	0.00	133558.00	3106	27	3128	1572	1.98982188295165	0.272279176606603	0.272279176606603	false	false	false	true	false
c62627a1-dc71-44b4-9e70-01cc7799d799	2026-08-19 13:31	2026-08-19 13:31	2026-08-19 13:31	XLE	XLE260918P00061000	put	61.0000	2026-09-18	0.7000	0.6900	0.7000	63.6650	123760.00	123760.00	0.00	1768	21	2275	10173	0.223631180576035	0.249264045731048	0.249264045731048	false	false	false	true	false
21d36730-5462-4acc-ace3-bc233edd97f0	2026-08-19 13:39	2026-08-19 13:38	2026-08-19 13:38	XLE	XLE260918P00060000	put	60.0000	2026-09-18	0.4900	0.4800	0.4900	63.6350	15141.00	15141.00	0.00	309	10	801	25283	0.0316813669263932	0.2532859562044	0.2532859562044	false	false	false	true	false
682a7ce6-4240-4377-ae1d-f13f2e07ed57	2026-08-19 13:41	2026-08-19 13:41	2026-08-19 13:41	XLE	XLE260828C00065000	call	65.0000	2026-08-28	0.4600	0.4600	0.4700	63.6750	24426.00	0.00	24426.00	531	22	994	670	1.48358208955224	0.239080349663685	0.239080349663685	false	false	false	true	false
17b91a8f-5604-405c-b733-e31ee4b1495f	2026-08-19 13:42	2026-08-19 13:41	2026-08-19 13:41	XLE	XLE260828C00066000	call	66.0000	2026-08-28	0.2400	0.2400	0.2500	63.6550	11688.00	0.00	11688.00	487	11	512	594	0.861952861952862	0.243880256044081	0.243880256044081	false	false	false	true	false
798eadd3-f6ea-4790-80a1-258c0558422d	2026-08-19 13:50	2026-08-19 13:50	2026-08-19 13:50	XLE	XLE260821P00063000	put	63.0000	2026-08-21	0.2200	0.2100	0.2200	63.6950	10384.00	10384.00	0.00	472	15	1368	1076	1.27137546468401	0.264982300019922	0.264982300019922	false	false	false	true	false
6b48f18f-6edb-41da-b400-236f94f0cd0d	2026-08-19 13:52	2026-08-19 13:52	2026-08-19 13:52	XLE	XLE260821P00063000	put	63.0000	2026-08-21	0.2300	0.2200	0.2300	63.6700	15755.00	15755.00	0.00	685	14	2068	1076	1.92193308550186	0.266777439580521	0.266777439580521	false	false	false	true	false
93ca19f0-b879-494b-a333-aeb54c0aa06f	2026-08-19 13:52	2026-08-19 13:52	2026-08-19 13:52	XLE	XLE260918P00061000	put	61.0000	2026-09-18	0.7100	0.6800	0.7100	63.6750	17750.00	17750.00	0.00	250	10	2536	10173	0.249287329204758	0.251420440710252	0.251420440710252	false	false	false	true	false
5d7d4b03-0149-4fd7-9e5e-8b5e2014590b	2026-08-19 13:54	2026-08-19 13:54	2026-08-19 13:54	XLE	XLE260828P00063500	put	63.5000	2026-08-28	0.8500	0.7800	0.8500	63.7000	12750.00	12750.00	0.00	150	5	426	171	2.49122807017544	0.244618712699744	0.244618712699744	false	false	false	true	false
052f6247-32c4-4e43-8eb0-29138979337b	2026-08-19 14:05	2026-08-19 14:04	2026-08-19 14:04	XLE	XLE260828C00067000	call	67.0000	2026-08-28	0.1300	0.1300	0.1500	63.7000	13221.00	0.00	13221.00	1017	27	1113	822	1.35401459854015	0.252042041826336	0.252042041826336	false	false	false	true	false
22f5cbb9-3b97-4e49-806f-030e6c3fb3d3	2026-08-19 14:07	2026-08-19 14:07	2026-08-19 14:07	XLE	XLE260821P00062000	put	62.0000	2026-08-21	0.0700	0.0500	0.0700	63.6950	10563.00	10563.00	0.00	1509	39	1920	11651	0.164792721654794	0.294776515525807	0.294776515525807	false	false	false	true	false
9302b168-eaf9-4bfc-a24c-a7c2f2012c01	2026-08-19 14:30	2026-08-19 14:30	2026-08-19 14:30	XLE	XLE260918P00059000	put	59.0000	2026-09-18	0.3400	0.3200	0.3500	63.6400	17000.00	15912.00	1020.00	500	14	8939	14236	0.627915144703568	0.259972131178947	0.259972131178947	false	false	false	true	false
dc5720b6-c26c-4c30-b0b2-a7c802a0577e	2026-08-19 15:09	2026-08-19 15:09	2026-08-19 15:09	XLE	XLE261120C00060000	call	60.0000	2026-11-20	5.5000	5.4500	5.5000	63.6750	33000.00	33000.00	0.00	60	12	164	6145	0.0266883645240033	0.232502259525573	0.232502259525573	false	false	false	true	false
de40764f-5b9c-4117-84e1-ba9bcbe7f5de	2026-08-19 15:20	2026-08-19 15:20	2026-08-19 15:20	XLE	XLE261218P00057500	put	57.5000	2026-12-18	1.2500	1.2000	1.2500	63.6657	20750.00	20750.00	0.00	166	18	759	19635	0.038655462184874	0.270338666588875	0.270338666588875	false	false	false	true	false
6e91373f-f501-4d9f-9a78-ae6ffc3a987e	2026-08-19 15:20	2026-08-19 15:20	2026-08-19 15:20	XLE	XLE261218P00059000	put	59.0000	2026-12-18	1.6500	1.5900	1.6500	63.6657	18810.00	18810.00	0.00	114	7	211	964	0.218879668049793	0.26885146969986	0.26885146969986	false	false	false	true	false
d80d4eca-88b1-41de-ad1a-23441d212207	2026-08-19 15:30	2026-08-19 15:30	2026-08-19 15:30	XLE	XLE261218C00075000	call	75.0000	2026-12-18	0.8100	0.8100	0.8400	63.5900	56700.00	0.00	56700.00	700	8	1467	14620	0.100341997264022	0.25788170721473	0.25788170721473	false	false	false	true	false
a23a2bff-2c51-4c36-994f-bca18fbe7019	2026-08-19 15:37	2026-08-19 15:37	2026-08-19 15:37	XLE	XLE260918C00060000	call	60.0000	2026-09-18	4.1600	4.1500	4.3500	63.4900	208182.00	0.00	208182.00	501	34	4048	58209	0.0695425106083252	0.255619397801748	0.24445610243858	true	false	false	true	false
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	false
166997d3-9f6d-40dc-8c7e-1e4599209eeb	2026-08-19 15:50	2026-08-19 15:50	2026-08-19 15:50	XLE	XLE260918C00062500	call	62.5000	2026-09-18	2.3500	2.3200	2.4400	63.4350	12224.00	0.00	12224.00	52	9	2016	25430	0.0792764451435313	0.241689081237913	0.23592806688443	false	false	false	true	false
970fed8a-d27a-4817-a901-6dd58082337b	2026-08-19 15:52	2026-08-19 15:51	2026-08-19 15:51	XLE	XLE261120P00055000	put	55.0000	2026-11-20	0.5800	0.5100	0.5800	63.4250	11600.00	11600.00	0.00	200	5	251	10783	0.023277381062784	0.277894327356406	0.277894327356406	false	false	false	true	false
4a1c5ee7-49de-40bf-a9d1-ab40a6bd8b71	2026-08-20 09:34	2026-08-20 09:34	2026-08-20 09:34	XLE	XLE260821C00059000	call	59.0000	2026-08-21	5.2500	5.2500	5.6000	64.3999	10500.00	0.00	10500.00	20	8	20	12257	0.00163172064942482	1.29719182024142	1.29719182024142	false	false	false	true	false
8ffa57a2-a73e-4d4f-a308-2550db68f768	2026-08-20 09:36	2026-08-20 09:36	2026-08-20 09:36	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.4500	4.4500	4.6000	64.4600	61420.00	0.00	61420.00	138	18	400	58525	0.00683468603161042	1.01339497512572	1.01339497512572	false	false	false	true	false
178871a7-e709-4fff-aa48-810b7f9dd5b1	2026-08-20 09:36	2026-08-20 09:36	2026-08-20 09:36	XLE	XLE260821C00060000	call	60.0000	2026-08-21	4.4500	4.3500	4.4500	64.4500	110360.00	110360.00	0.00	248	22	262	58525	0.00447671935070483	0.614797841752708	0.614797841752708	true	false	false	true	false
1ce8bfd5-9983-4441-87e4-03b2c77a3d0e	2026-08-20 09:38	2026-08-20 09:38	2026-08-20 09:38	XLE	XLE261218C00070000	call	70.0000	2026-12-18	1.8900	1.8900	1.9900	64.3900	37800.00	0.00	37800.00	200	12	226	7677	0.0294385827797317	0.248710090015657	0.248710090015657	false	false	false	true	false