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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×ticker = XLP×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

7a058803-aeb6-4ac1-9879-1e56a261b814	2026-08-17 11:32	2026-08-17 11:31	2026-08-17 11:31	XLP	XLP260918P00083000	put	83.0000	2026-09-18	0.6900	0.6700	0.6900	84.8450	55821.00	55821.00	0.00	809	28	902	12785	0.0705514274540477	0.153734800356299	0.153734800356299	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	14406195892.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
49da184c-33f0-4937-a5bd-429e40e701f8	2026-08-17 12:14	2026-08-17 12:14	2026-08-17 12:14	XLP	XLP260911C00083500	call	83.5000	2026-09-11	2.2600	2.0800	2.2600	84.8600	10169.00	10169.00	0.00	45	13	46	2	23	0.15099459156273	0.149718054523727	true	false	false	true
503f26ea-7cc0-48bb-b2c6-42d09a7957b1	2026-08-17 12:16	2026-08-17 12:16	2026-08-17 12:16	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.1800	2.0200	2.1800	84.8900	24416.00	24416.00	0.00	112	8	283	5889	0.0480556970623196	0.185400033738064	0.185400033738064	false	false	false	true
7aa77da9-86aa-4da2-a9c9-d0fdab7738aa	2026-08-17 12:19	2026-08-17 12:19	2026-08-17 12:19	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.1700	2.1600	2.1700	84.9000	25172.00	25172.00	0.00	116	18	705	5889	0.119714722363729	0.185044678171241	0.185044678171241	false	false	false	true
049ae7db-ab18-4b85-84bc-16f011dc7660	2026-08-17 12:19	2026-08-17 12:19	2026-08-17 12:19	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.1700	2.1600	2.1700	84.9000	26474.00	26474.00	0.00	122	9	827	5889	0.140431312616743	0.185044678171241	0.185044678171241	false	false	false	true
2666cf2f-7a08-4df2-b8d0-b6f582d9b13f	2026-08-17 12:20	2026-08-17 12:20	2026-08-17 12:20	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.1800	2.1300	2.1800	84.8800	49486.00	49486.00	0.00	227	19	1077	5889	0.182883341823739	0.185238150915326	0.185238150915326	false	false	false	true
3d293bc7-0786-47d0-838d-207585fdc4f7	2026-08-17 13:05	2026-08-17 13:05	2026-08-17 13:05	XLP	XLP260828P00085500	put	85.5000	2026-08-28	1.1500	1.1200	1.1500	84.8800	242995.00	242995.00	0.00	2113	19	2170	280	7.75	0.146492971605519	0.146492971605519	false	false	false	true
0cb4e63c-3f56-4c18-a606-86df3a18ca40	2026-08-17 13:19	2026-08-17 13:18	2026-08-17 13:18	XLP	XLP260918C00090000	call	90.0000	2026-09-18	0.2000	0.1800	0.2000	84.7324	12800.00	12800.00	0.00	640	11	816	4604	0.177237185056473	0.153722411652021	0.153722411652021	false	false	false	true
9bb75b36-3d3b-4d6f-84ca-23d0ab8b93e8	2026-08-17 14:47	2026-08-17 14:47	2026-08-17 14:47	XLP	XLP261218P00084000	put	84.0000	2026-12-18	2.6100	2.5300	2.6100	84.6850	76473.00	76473.00	0.00	293	29	605	374	1.61764705882353	0.177025978443332	0.177025978443332	false	false	false	true
909b9143-b380-40f2-9c14-2642623e1283	2026-08-17 15:05	2026-08-17 15:05	2026-08-17 15:05	XLP	XLP260918P00086000	put	86.0000	2026-09-18	2.1000	1.9400	2.1000	84.6300	21630.00	21630.00	0.00	103	22	145	3908	0.0371033776867963	0.148751874715599	0.148751874715599	false	false	false	true
0f657011-44a4-4fda-81d9-cbbf75d3a916	2026-08-18 09:39	2026-08-18 09:38	2026-08-18 09:38	XLP	XLP260904C00085000	call	85.0000	2026-09-04	1.3700	1.3400	1.4000	85.0000	21647.00	18222.00	3425.00	158	8	518	580	0.893103448275862	0.159676048631754	0.158297314237467	false	false	false	true
184d841b-36b1-44d9-bf91-d41c332a9d30	2026-08-18 10:28	2026-08-18 10:28	2026-08-18 10:28	XLP	XLP260911P00087000	put	87.0000	2026-09-11	2.0200	1.8400	2.0200	85.6100	11716.00	11716.00	0.00	58	11	61	12	5.08333333333333	0.153461383374871	0.153461383374871	true	false	false	true
40f8cb09-c42a-4009-81fd-bdbc4fb2a802	2026-08-18 10:47	2026-08-18 10:47	2026-08-18 10:47	XLP	XLP260918C00086000	call	86.0000	2026-09-18	1.6800	1.6800	1.7300	85.9900	16296.00	0.00	16296.00	97	10	1216	4287	0.283648238861675	0.154492290189753	0.154492290189753	false	false	false	true
4ed38eb1-138c-480b-b1bd-0f5d00f903ad	2026-08-18 10:48	2026-08-18 10:48	2026-08-18 10:48	XLP	XLP270115C00092000	call	92.0000	2027-01-15	1.4000	1.3600	1.5200	85.9650	151900.00	0.00	0.00	1085	7	1093	295	3.70508474576271	0.140550078883664	0.140550078883664	false	false	false	true
176d14f8-ce9f-43eb-b508-bac59eded6ae	2026-08-18 10:52	2026-08-18 10:51	2026-08-18 10:51	XLP	XLP270115P00082000	put	82.0000	2027-01-15	1.9600	1.9600	1.9700	86.0600	15484.00	0.00	15484.00	79	5	140	7775	0.0180064308681672	0.192526236034333	0.192526236034333	false	false	false	true
260b82da-e77e-4000-9448-268078726742	2026-08-18 10:52	2026-08-18 10:52	2026-08-18 10:52	XLP	XLP260911C00091000	call	91.0000	2026-09-11	0.1700	0.1300	0.1700	86.0800	11730.00	11730.00	0.00	690	16	1500	5	300	0.160711081404602	0.160711081404602	false	false	false	true
6cff1c37-3b4a-4a33-9fcb-a0a42e2a7dd7	2026-08-18 11:07	2026-08-18 11:07	2026-08-18 11:07	XLP	XLP270617P00091000	put	91.0000	2027-06-17	7.4000	6.9500	7.4500	86.1250	23680.00	19240.00	4440.00	32	12	132	103	1.28155339805825	0.202615037538563	0.202615037538563	false	false	false	true
f901714b-81ee-4f1c-b22d-b9312cac9c6d	2026-08-18 11:48	2026-08-18 11:48	2026-08-18 11:48	XLP	XLP280121C00095000	call	95.0000	2028-01-21	3.6700	3.4500	3.9000	85.8050	1101000.00	0.00	1101000.00	3000	2	3000	1020	2.94117647058824	0.127209354310861	0.127209354310861	false	true	true	false
ed4d8166-2114-4b60-b78d-bc5929f7c7de	2026-08-18 12:27	2026-08-18 12:27	2026-08-18 12:27	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.0000	1.9400	2.0100	85.9500	40800.00	37800.00	3000.00	204	8	2015	7775	0.259163987138264	0.193013243123071	0.193013243123071	false	false	false	true
49f1ba5b-e9ae-4aaa-9523-a41be14abfbf	2026-08-18 12:28	2026-08-18 12:28	2026-08-18 12:28	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.0000	1.9400	2.0100	85.9350	17000.00	17000.00	0.00	85	9	2100	7775	0.270096463022508	0.192785370210155	0.192785370210155	false	false	false	true
bc669413-cec6-4cc6-8526-ca5b3abcb798	2026-08-19 13:07	2026-08-19 13:07	2026-08-19 13:07	XLP	XLP260821C00086500	call	86.5000	2026-08-21	0.6100	0.5600	0.6100	86.5577	14701.00	14701.00	0.00	241	8	830	1148	0.722996515679443	0.223639316459463	0.223639316459463	false	false	false	true
ba209b10-bb98-4c51-bea3-a4afbc7edcfe	2026-08-19 13:07	2026-08-19 13:07	2026-08-19 13:07	XLP	XLP260821C00086500	call	86.5000	2026-08-21	0.6100	0.5900	0.6100	86.5750	14640.00	14640.00	0.00	240	21	589	1148	0.513066202090592	0.220065298589229	0.220065298589229	false	false	false	true
6ab97a39-4bcd-44cb-8b93-317040d69790	2026-08-19 13:08	2026-08-19 13:08	2026-08-19 13:08	XLP	XLP260821C00086500	call	86.5000	2026-08-21	0.6000	0.5800	0.6000	86.5450	19980.00	19980.00	0.00	333	8	1243	1148	1.08275261324042	0.222321589037533	0.222321589037533	false	false	false	true
2ae62e6a-b30d-4441-869c-0ef97608e980	2026-08-19 13:34	2026-08-19 13:34	2026-08-19 13:34	XLP	XLP260918P00084000	put	84.0000	2026-09-18	0.5500	0.5500	0.5600	86.6100	10835.00	0.00	10835.00	197	18	539	12625	0.0426930693069307	0.163222129502261	0.163222129502261	false	false	false	true
1508f919-50d0-44f9-8ecf-4a28c8f5ad87	2026-08-19 14:05	2026-08-19 14:05	2026-08-19 14:05	XLP	XLP260821C00086500	call	86.5000	2026-08-21	0.7200	0.7000	0.7200	86.7700	14040.00	14040.00	0.00	195	25	1502	1148	1.30836236933798	0.220628409148725	0.220628409148725	false	false	false	true
b120601c-502f-4b26-b3cf-a8ecf4c4cdf9	2026-08-19 14:09	2026-08-19 14:09	2026-08-19 14:09	XLP	XLP260821C00086500	call	86.5000	2026-08-21	0.7800	0.7400	0.7800	86.8500	10062.00	10062.00	0.00	129	17	2066	1148	1.79965156794425	0.225643377159124	0.225643377159124	false	false	false	true
084f2900-9e4d-4524-b82c-e96b7f272eb9	2026-08-19 14:09	2026-08-19 14:09	2026-08-19 14:09	XLP	XLP260821C00086500	call	86.5000	2026-08-21	0.7700	0.7400	0.7700	86.8500	11473.00	11473.00	0.00	149	17	2215	1148	1.9294425087108	0.221605334001268	0.221605334001268	false	false	false	true
232d1e8b-12c4-461a-a058-ab9076040af6	2026-08-19 14:35	2026-08-19 14:35	2026-08-19 14:35	XLP	XLP261016P00085000	put	85.0000	2026-10-16	1.4000	1.3500	1.4000	86.9850	228480.00	228480.00	0.00	1632	20	2701	432	6.25231481481481	0.179707168555501	0.179707168555501	false	false	false	true
25814ecc-720a-4270-96d4-0871276e181b	2026-08-20 09:36	2026-08-20 09:36	2026-08-20 09:36	XLP	XLP260828P00083500	put	83.5000	2026-08-28	0.2200	0.2200	0.2400	85.5600	27830.00	0.00	27830.00	1265	12	1266	264	4.79545454545455	0.183775073125782	0.183775073125782	false	false	false	true
68ef47f7-b77b-4b8e-99ce-edd0674980f5	2026-08-20 10:32	2026-08-20 10:32	2026-08-20 10:32	XLP	XLP260821C00085000	call	85.0000	2026-08-21	0.6800	0.6200	0.7300	85.3050	17000.00	16388.00	612.00	250	9	277	8881	0.0311901812858912	0.285576420828984	0.285576420828984	false	false	false	true
9a9dd953-01ac-43f3-8c2d-2c78f9b775c9	2026-08-20 10:38	2026-08-20 10:38	2026-08-20 10:38	XLP	XLP260918P00085000	put	85.0000	2026-09-18	1.2600	1.2600	1.3800	85.2500	29862.00	0.00	29862.00	237	15	681	3098	0.219819238218205	0.156805300846244	0.156805300846244	false	false	false	true
63f9e69f-ca4e-4b51-993a-fb681fc4cdee	2026-08-20 10:52	2026-08-20 10:52	2026-08-20 10:52	XLP	XLP260918C00086000	call	86.0000	2026-09-18	1.2600	1.2600	1.2800	85.2150	351918.00	0.00	351918.00	2793	29	2806	5000	0.5612	0.157025612599877	0.157025612599877	false	false	false	true
ca900cb0-c2a4-4eb6-be39-7570a9b18775	2026-08-20 12:03	2026-08-20 12:03	2026-08-20 12:03	XLP	XLP260821P00086000	put	86.0000	2026-08-21	0.5500	0.5500	0.6100	85.7150	10010.00	0.00	10010.00	182	31	305	2048	0.14892578125	0.221307732499785	0.221307732499785	false	false	false	true
ca81e7cf-3bc3-4353-9893-830931148927	2026-08-20 12:34	2026-08-20 12:34	2026-08-20 12:34	XLP	XLP260925C00082000	call	82.0000	2026-09-25	4.4500	4.4500	4.6500	85.8200	10235.00	0.00	10235.00	23	11	23	10	2.3	0.153555651916653	0.153555651916653	false	false	false	true
b84c576e-4ea0-4802-9a47-723ca333c856	2026-08-20 14:15	2026-08-20 14:15	2026-08-20 14:15	XLP	XLP260918P00086000	put	86.0000	2026-09-18	1.5200	1.5200	1.5500	85.6600	24624.00	0.00	24624.00	162	16	225	3958	0.0568468923698838	0.153400841037642	0.153400841037642	false	false	false	true
85593378-3627-4fc4-b38b-20e96358b156	2026-08-20 15:37	2026-08-20 15:37	2026-08-20 15:37	XLP	XLP260918P00085000	put	85.0000	2026-09-18	1.1600	1.0900	1.1700	85.4850	366792.00	363080.00	3712.00	3162	83	4114	3098	1.32795351839897	0.156808453444926	0.156808453444926	true	false	false	true
8da050eb-025e-456b-9be3-bd173d7573f5	2026-08-21 10:05	2026-08-21 10:05	2026-08-21 10:05	XLP	XLP260918C00087000	call	87.0000	2026-09-18	1.0200	0.9100	1.0300	85.6200	18063.00	17961.00	102.00	177	15	177	5668	0.031227946365561	0.159345442915023	0.159345442915023	true	false	false	true
18605a9f-e35c-448d-8464-cec461ff8dac	2026-08-21 11:49	2026-08-21 11:48	2026-08-21 11:48	XLP	XLP260918P00082000	put	82.0000	2026-09-18	0.3100	0.3000	0.3600	85.7900	15500.00	0.00	15500.00	500	6	946	5497	0.1720938693833	0.169041624044021	0.169041624044021	false	false	false	true
6cf8ea38-93ce-46e9-a836-84a41a276a7b	2026-08-21 13:37	2026-08-21 13:37	2026-08-21 13:37	XLP	XLP260918P00083000	put	83.0000	2026-09-18	0.4400	0.4400	0.4700	85.8050	10780.00	0.00	10780.00	245	17	715	13400	0.0533582089552239	0.160527319899534	0.160527319899534	false	false	false	true
bc3171e3-ce2d-453e-85c6-9b0025eb6589	2026-08-21 13:50	2026-08-21 13:50	2026-08-21 13:50	XLP	XLP260918P00084000	put	84.0000	2026-09-18	0.6500	0.6500	0.6900	85.8400	18525.00	0.00	18525.00	285	12	845	13002	0.0649900015382249	0.156044437392786	0.156044437392786	false	false	false	true
a7fab0b5-afee-46b0-9855-d51375d0dd15	2026-08-24 09:37	2026-08-24 09:37	2026-08-24 09:37	XLP	XLP261016P00085000	put	85.0000	2026-10-16	1.3500	1.3000	1.3600	86.9200	45495.00	45495.00	0.00	337	8	348	2715	0.12817679558011	0.180654556896392	0.180654556896392	false	false	false	true
8c19a29e-ffb9-4eb5-9537-ce676015bec2	2026-08-24 11:02	2026-08-24 11:02	2026-08-24 11:02	XLP	XLP261218C00095000	call	95.0000	2026-12-18	0.9700	0.9000	0.9700	87.2550	61885.00	61885.00	0.00	638	54	644	2204	0.292196007259528	0.159921088068812	0.159921088068812	false	false	false	true
a807ae13-f584-484b-a084-d452185ad88a	2026-08-24 11:53	2026-08-24 11:53	2026-08-24 11:53	XLP	XLP260918P00084500	put	84.5000	2026-09-18	0.5000	0.5000	0.5300	87.1700	10650.00	0.00	10650.00	213	19	218	0	0	0.170966934947072	0.170966934947072	false	false	false	true
5b0aa0f7-f952-4d93-9c50-025b1b6f4ea5	2026-08-24 12:12	2026-08-24 12:12	2026-08-24 12:12	XLP	XLP260911P00087000	put	87.0000	2026-09-11	1.0500	1.0400	1.0500	87.3200	245175.00	245175.00	0.00	2335	14	2919	64	45.609375	0.165532834062281	0.165532834062281	false	false	false	true
9daed568-16b1-44ff-bcbd-43860d3a4712	2026-08-24 12:40	2026-08-24 12:40	2026-08-24 12:40	XLP	XLP260918C00087000	call	87.0000	2026-09-18	1.7400	1.7400	1.7700	87.2450	22446.00	0.00	22446.00	129	40	188	5686	0.0330636651424552	0.164316305327627	0.164316305327627	false	false	false	true
9d3e5a51-faec-4ce6-9dc4-4082996e7544	2026-08-24 13:14	2026-08-24 13:14	2026-08-24 13:14	XLP	XLP260918P00087000	put	87.0000	2026-09-18	1.2800	1.2800	1.3100	87.1450	13440.00	0.00	13440.00	105	22	137	5277	0.0259617206746257	0.160604552484079	0.160604552484079	false	false	false	true
ea645153-9e02-4cf3-b1a6-452c388ef651	2026-08-24 13:19	2026-08-24 13:19	2026-08-24 13:19	XLP	XLP260918P00087500	put	87.5000	2026-09-18	1.5100	1.5100	1.5400	87.1700	21744.00	0.00	21744.00	144	24	167	0	0	0.160131696442215	0.160131696442215	false	false	false	true
6edda250-3f80-40f6-b783-fca0fd4bb030	2026-08-24 13:25	2026-08-24 13:24	2026-08-24 13:24	XLP	XLP260904C00088000	call	88.0000	2026-09-04	0.6800	0.6800	0.7300	87.1050	16184.00	0.00	16184.00	238	29	252	66	3.81818181818182	0.169760692713797	0.169760692713797	false	false	false	true
b6b31e96-af90-4d48-83fe-efac0e3eb829	2026-08-24 15:44	2026-08-24 15:44	2026-08-24 15:44	XLP	XLP260828P00086500	put	86.5000	2026-08-28	0.3500	0.3100	0.3500	87.2700	17290.00	17290.00	0.00	494	15	911	2154	0.422934076137419	0.186939723452994	0.186939723452994	true	false	false	true
ad6d9f6a-7071-4084-adef-3dbab807c719	2026-08-24 15:59	2026-08-24 15:59	2026-08-24 15:59	XLP	XLP260918C00088000	call	88.0000	2026-09-18	1.3200	1.3000	1.3200	87.4350	11616.00	11616.00	0.00	88	6	368	5154	0.0714008537058595	0.162048877861179	0.162048877861179	false	false	false	true