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:alert_rule = RepeatedHits×ticker = XLP×

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

189c1720-ab08-47b6-8f1f-2dd08a9c3893	2026-09-24 10:51	2026-09-24 10:50	2026-09-24 10:50	XLP	XLP261016P00082500	put	82.5000	2026-10-16	1.0900	1.0500	1.0900	82.5300	16350.00	16350.00	0.00	150	24	185	580	0.318965517241379	0.148747426646816	0.148747426646816	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	13976543520.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T14:53:28.868411Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
0c957848-f244-453e-9137-a4c3ef364d61	2026-09-24 09:38	2026-09-24 09:38	2026-09-24 09:38	XLP	XLP261016P00084000	put	84.0000	2026-10-16	1.7200	1.5800	1.7200	82.8800	48504.00	48504.00	0.00	282	30	282	1082	0.260628465804067	0.147716529265529	0.147716529265529	false	false	false	true
6d58966b-db60-4170-aa10-ba5cbe961a26	2026-09-23 15:08	2026-09-23 15:08	2026-09-23 15:08	XLP	XLP261120P00078000	put	78.0000	2026-11-20	0.5200	0.4900	0.5200	82.2800	97864.00	97864.00	0.00	1882	22	1923	150	12.82	0.165384532659738	0.165384532659738	false	false	false	true
00233641-9406-47a7-816b-775963028f8c	2026-09-23 14:17	2026-09-23 14:17	2026-09-23 14:17	XLP	XLP261120P00087000	put	87.0000	2026-11-20	4.8500	4.6000	5.0500	82.3203	44135.00	43650.00	485.00	91	17	121	1	121	0.164609138544375	0.164609138544375	false	false	false	true
803af347-ed1e-4b77-acff-ee894a8ff5ee	2026-09-23 14:15	2026-09-23 14:15	2026-09-23 14:15	XLP	XLP290119P00083000	put	83.0000	2029-01-19	6.1500	5.0000	6.3500	82.3750	11070.00	9840.00	1230.00	18	13	117	0	0	0.202716785366432	0.202716785366432	false	false	false	true
ec36dfe9-61d7-4b81-94b2-160cf04a5afe	2026-09-23 14:08	2026-09-23 14:08	2026-09-23 14:08	XLP	XLP261218P00085000	put	85.0000	2026-12-18	3.4500	3.3500	3.4500	82.4850	132135.00	132135.00	0.00	383	31	390	4463	0.0873851669280753	0.156071543683783	0.156071543683783	false	false	false	true
b942e7f1-a790-465e-94e6-26a40ca796db	2026-09-23 13:16	2026-09-23 13:16	2026-09-23 13:16	XLP	XLP261030P00083000	put	83.0000	2026-10-30	1.7300	1.6300	1.7300	82.0000	44980.00	44980.00	0.00	260	40	260	284	0.915492957746479	0.149267911528274	0.149267911528274	false	false	false	true
dc38a946-6504-41be-93f2-515f90a0c24f	2026-09-23 11:26	2026-09-23 11:26	2026-09-23 11:26	XLP	XLP261218P00089000	put	89.0000	2026-12-18	6.7500	6.1500	6.7500	82.3250	27675.00	27675.00	0.00	41	25	87	101	0.861386138613861	0.181410566668511	0.181410566668511	true	false	false	true
257c12fd-a396-482f-b2e1-ffdd7a390acb	2026-09-23 10:55	2026-09-23 10:55	2026-09-23 10:55	XLP	XLP261218P00088000	put	88.0000	2026-12-18	5.6500	5.3000	5.7000	82.5450	10170.00	9605.00	0.00	18	8	40	344	0.116279069767442	0.16837314708953	0.16837314708953	true	false	false	true
687f11f3-2b44-4dee-abef-92c4a101a344	2026-09-23 10:55	2026-09-23 10:55	2026-09-23 10:55	XLP	XLP261016P00082500	put	82.5000	2026-10-16	1.0400	1.0000	1.1500	82.5900	10920.00	10816.00	104.00	105	13	128	421	0.304038004750594	0.143194553625182	0.143194553625182	true	false	false	true
e47bb0f9-09f2-4638-a773-a0ef743bf2d5	2026-09-23 10:39	2026-09-23 10:39	2026-09-23 10:39	XLP	XLP261218C00082000	call	82.0000	2026-12-18	3.3000	3.2500	3.4500	82.7100	25410.00	0.00	25410.00	77	14	82	183	0.448087431693989	0.155807745100582	0.155807745100582	true	false	false	true
2f338417-4b62-428e-9062-ca471be7c66e	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	XLP	XLP261009C00083000	call	83.0000	2026-10-09	0.9600	0.9600	1.0600	82.0000	23040.00	0.00	23040.00	240	10	240	73	3.28767123287671	0.145258224413226	0.145258224413226	true	false	false	true
5c366e84-bcf4-4170-96e9-bb27f258271e	2026-09-23 10:09	2026-09-23 10:09	2026-09-23 10:09	XLP	XLP270115C00084000	call	84.0000	2027-01-15	2.3300	2.2100	2.3300	82.5100	66172.00	66172.00	0.00	284	27	284	1487	0.190988567585743	0.13645155099864	0.13645155099864	false	false	false	true
3d448312-2dc5-43d7-9590-0dbcecc2fc22	2026-09-23 10:09	2026-09-23 10:09	2026-09-23 10:09	XLP	XLP270115C00082000	call	82.0000	2027-01-15	3.4000	3.3000	3.4000	82.5100	69020.00	69020.00	0.00	203	30	208	605	0.343801652892562	0.138548873389787	0.138548873389787	false	false	false	true
c6dde8a8-e62e-4bb1-8267-a1b1160e6e70	2026-09-23 09:51	2026-09-23 09:51	2026-09-23 09:51	XLP	XLP261218P00089000	put	89.0000	2026-12-18	6.6000	6.0500	6.6000	82.4800	26400.00	26400.00	0.00	40	18	40	101	0.396039603960396	0.178859095713298	0.178859095713298	false	false	false	true
de9c466d-0339-4d18-9bea-a927ca750122	2026-09-22 15:45	2026-09-22 15:45	2026-09-22 15:45	XLP	XLP260925C00083000	call	83.0000	2026-09-25	0.4300	0.3900	0.4300	82.8400	39388.00	39388.00	0.00	916	49	1370	267	5.1310861423221	0.164629378038233	0.164629378038233	true	false	false	true
eee6d2c7-c9cb-4600-90bb-5aec5a751141	2026-09-22 14:47	2026-09-22 14:46	2026-09-22 14:46	XLP	XLP290119C00075000	call	75.0000	2029-01-19	14.4100	14.3000	14.6500	82.7201	72050.00	0.00	72050.00	50	7	464	0	0	0.21064857285983	0.21064857285983	false	false	false	true
1d826374-3106-4fc2-ba8f-93b88be10eb0	2026-09-22 12:30	2026-09-22 12:30	2026-09-22 12:30	XLP	XLP260925P00081000	put	81.0000	2026-09-25	0.0600	0.0600	0.0700	82.7300	13470.00	0.00	13470.00	2245	23	2420	461	5.24945770065076	0.180880075071805	0.180880075071805	false	false	false	true
b7067f9c-da2c-4693-95ac-a2bfc2791ac6	2026-09-22 11:33	2026-09-22 11:33	2026-09-22 11:33	XLP	XLP261218C00083000	call	83.0000	2026-12-18	2.6400	2.6300	2.7000	82.0000	13728.00	0.00	13728.00	52	5	65	206	0.315533980582524	0.150395393991081	0.150395393991081	true	false	false	true
0149bc6d-a1da-45b9-b835-24fbff91ef25	2026-09-21 15:49	2026-09-21 15:49	2026-09-21 15:49	XLP	XLP261120P00085000	put	85.0000	2026-11-20	3.5000	3.3500	3.5000	82.0000	39200.00	39200.00	0.00	112	5	114	47	2.42553191489362	0.154053158869321	0.154053158869321	false	false	false	true
d8644b3d-e174-4559-a5cd-c63575fce6a8	2026-09-21 15:32	2026-09-21 15:32	2026-09-21 15:32	XLP	XLP261120C00083000	call	83.0000	2026-11-20	1.8300	1.8300	1.8400	82.0000	11712.00	0.00	11712.00	64	6	89	4	22.25	0.151335855328135	0.151335855328135	false	false	false	true
419d8c65-3f62-4128-b26a-7696d7bd7cbd	2026-09-21 14:44	2026-09-21 14:43	2026-09-21 14:43	XLP	XLP261002P00083000	put	83.0000	2026-10-02	1.2900	1.2600	1.2900	82.1150	10707.00	10707.00	0.00	83	23	96	661	0.145234493192133	0.146876243732647	0.146876243732647	false	false	false	true
ad6246d4-54a9-4675-b8be-875417cb1fce	2026-09-21 14:03	2026-09-21 14:03	2026-09-21 14:03	XLP	XLP261016C00082500	call	82.5000	2026-10-16	1.1700	1.1600	1.2700	82.0000	94070.00	119.00	93951.00	804	36	826	0	0	0.145529154656	0.147863116160807	true	false	false	true
5457477e-d8c1-4724-80b9-aa084159fd30	2026-09-21 14:03	2026-09-21 14:03	2026-09-21 14:03	XLP	XLP261016C00082000	call	82.0000	2026-10-16	1.4400	1.4400	1.4900	82.0000	90720.00	0.00	90720.00	630	20	647	86	7.52325581395349	0.147744129642144	0.147744129642144	false	false	false	true
90eb2162-9c93-42e4-b278-b2d31d928d90	2026-09-21 13:49	2026-09-21 13:49	2026-09-21 13:49	XLP	XLP261218P00087000	put	87.0000	2026-12-18	5.2000	5.0000	5.2500	82.0950	47320.00	46800.00	520.00	91	11	116	163	0.711656441717791	0.164814401984709	0.164814401984709	true	false	false	true
09286dbd-a285-49a1-a9f1-63372b20ca99	2026-09-21 13:42	2026-09-21 13:41	2026-09-21 13:41	XLP	XLP261016P00083000	put	83.0000	2026-10-16	1.5800	1.5300	1.5800	82.1600	414118.00	414118.00	0.00	2621	17	3059	2374	1.28854254422915	0.145033858584425	0.145033858584425	false	false	false	true
708484b2-ba57-4e25-b4b9-9b15049867e7	2026-09-21 12:34	2026-09-21 12:34	2026-09-21 12:34	XLP	XLP261016P00083000	put	83.0000	2026-10-16	1.5500	1.5400	1.5500	82.2300	15345.00	15345.00	0.00	99	13	427	2374	0.179865206402696	0.14616758697493	0.14616758697493	false	false	false	true
7f50f02f-9998-40eb-9e7f-37f1012494f4	2026-09-21 11:30	2026-09-21 11:30	2026-09-21 11:30	XLP	XLP261218P00080000	put	80.0000	2026-12-18	1.3000	1.2500	1.3600	81.9950	13000.00	0.00	13000.00	100	13	152	4592	0.0331010452961672	0.154967539824405	0.154967539824405	false	false	false	true
abe00b95-5163-4bef-b574-096ef629837f	2026-09-21 10:10	2026-09-21 10:09	2026-09-21 10:09	XLP	XLP261218P00078000	put	78.0000	2026-12-18	0.8200	0.8200	0.8800	81.8050	64206.00	0.00	64206.00	783	51	783	112703	0.00694746368774567	0.15809722539416	0.15809722539416	false	false	false	true
2c59f4f7-e28f-41a6-bc01-05a178806e51	2026-09-18 14:59	2026-09-18 14:59	2026-09-18 14:59	XLP	XLP260918P00084000	put	84.0000	2026-09-18	0.9000	0.9000	0.9400	83.1200	31500.00	0.00	1800.00	350	6	1229	16724	0.0734872040181775	0.681695259852771	0.681695259852771	false	false	false	true
c3128289-9efa-48f9-a83f-2636339bac6f	2026-09-18 14:54	2026-09-18 14:54	2026-09-18 14:54	XLP	XLP261016P00081000	put	81.0000	2026-10-16	0.6100	0.5600	0.6400	83.1300	40138.00	40138.00	0.00	658	31	689	676	1.01923076923077	0.166796113549955	0.166796113549955	false	false	false	true
893cc240-0086-494e-9569-e21349c93b68	2026-09-18 14:54	2026-09-18 14:54	2026-09-18 14:54	XLP	XLP261016P00082000	put	82.0000	2026-10-16	0.9300	0.8800	0.9300	83.1300	144801.00	144801.00	0.00	1557	45	2099	5038	0.416633584755855	0.167015899251156	0.167015899251156	false	false	false	true
a807a69d-1a4c-48de-9122-9b2e8d7d48dd	2026-09-18 14:51	2026-09-18 14:51	2026-09-18 14:51	XLP	XLP260925C00083500	call	83.5000	2026-09-25	0.2700	0.2500	0.3100	83.0900	37503.00	27.00	37476.00	1389	30	1594	190	8.38947368421053	0.0914608803416918	0.0914608803416918	false	false	false	true
9a5e338e-60ee-42b2-91d0-f5f224b8654b	2026-09-18 14:29	2026-09-18 14:29	2026-09-18 14:29	XLP	XLP261120P00080000	put	80.0000	2026-11-20	0.8800	0.8800	0.9200	83.1100	17952.00	0.00	17952.00	204	14	212	211	1.00473933649289	0.167697569004554	0.167697569004554	true	false	false	true
3a5b9dd8-8562-4d7d-9f07-0585ea03806c	2026-09-18 14:06	2026-09-18 14:06	2026-09-18 14:06	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.3500	2.2900	2.3500	83.0800	204450.00	204450.00	0.00	870	48	875	12187	0.0717978173463527	0.178756700566052	0.178756700566052	false	false	false	true
f07bfe39-40bf-4f67-b29d-1b0734a7a11d	2026-09-18 13:59	2026-09-18 13:59	2026-09-18 13:59	XLP	XLP261218P00080000	put	80.0000	2026-12-18	1.1800	1.0400	1.2200	83.1300	28908.00	234.00	28674.00	245	11	287	4356	0.0658861340679523	0.16769488537407	0.167351043580859	true	false	false	true
d768f277-d094-4b1d-99d7-0973f9c9dbf6	2026-09-18 13:14	2026-09-18 13:14	2026-09-18 13:14	XLP	XLP261120C00085000	call	85.0000	2026-11-20	1.2600	1.2600	1.2900	83.0800	28098.00	0.00	28098.00	223	29	228	763	0.298820445609436	0.132912773527838	0.132912773527838	true	false	false	true
cfd560a0-2ed0-4911-85df-67c6889299ae	2026-09-18 13:12	2026-09-18 13:12	2026-09-18 13:12	XLP	XLP261002C00082000	call	82.0000	2026-10-02	1.3000	1.2900	1.3600	83.0950	18330.00	0.00	18330.00	141	7	242	0	0	0.0698085272828938	0.0698085272828938	false	false	false	true
f3607604-3907-4eea-90e3-7e994ef27ded	2026-09-18 11:56	2026-09-18 11:56	2026-09-18 11:56	XLP	XLP261016C00083000	call	83.0000	2026-10-16	1.1800	1.1200	1.2700	83.0101	91922.00	118.00	91804.00	779	36	1037	540	1.92037037037037	0.113899220540673	0.113953188585167	true	false	false	true
17bc1ccf-c0a1-4dbf-a4d3-3a2b7798e019	2026-09-18 11:56	2026-09-18 11:56	2026-09-18 11:56	XLP	XLP260925C00082500	call	82.5000	2026-09-25	0.6800	0.6300	0.7700	83.0101	17205.00	9929.00	7276.00	253	71	256	25	10.24	0.0684693356558729	0.071489722657573	true	false	false	true
fb22c8c4-b097-44c8-94bf-3255c5876d22	2026-09-18 11:38	2026-09-18 11:38	2026-09-18 11:38	XLP	XLP261016P00082000	put	82.0000	2026-10-16	0.9900	0.9500	1.1600	83.0600	39996.00	39897.00	99.00	404	50	430	5038	0.0853513298928146	0.171118030474372	0.171118030474372	false	false	false	true
cdb47599-0f89-4838-8391-143132027806	2026-09-18 09:53	2026-09-18 09:53	2026-09-18 09:53	XLP	XLP261016C00084000	call	84.0000	2026-10-16	0.8000	0.7500	0.8000	83.0500	16800.00	16800.00	0.00	210	21	212	1048	0.202290076335878	0.120784403688149	0.120784403688149	false	false	false	true
c54b5d02-87f7-4e29-a444-bf3476c3a225	2026-09-18 09:53	2026-09-18 09:53	2026-09-18 09:53	XLP	XLP270115C00085000	call	85.0000	2027-01-15	2.0500	1.8900	2.0500	83.0600	17425.00	17425.00	0.00	85	17	85	3331	0.0255178625037526	0.127240439582266	0.127240439582266	false	false	false	true
a6bf0c3c-21cc-492b-b211-69fa21677be2	2026-09-18 09:53	2026-09-18 09:53	2026-09-18 09:53	XLP	XLP270115C00083000	call	83.0000	2027-01-15	2.9700	2.8000	2.9700	83.0600	23463.00	23463.00	0.00	79	25	79	984	0.0802845528455285	0.123680935673274	0.123680935673274	false	false	false	true
c9e3cf25-d556-42eb-9cb9-23e6be78b9b0	2026-09-17 15:57	2026-09-17 15:57	2026-09-17 15:57	XLP	XLP260918P00084000	put	84.0000	2026-09-18	0.5400	0.5400	0.6000	83.0000	89046.00	0.00	486.00	1649	49	4820	18630	0.258722490606549	0.136046319258577	0.136046319258577	true	false	false	true
e45c3254-fcc0-4641-b315-e6dcb3d80982	2026-09-17 15:57	2026-09-17 15:57	2026-09-17 15:57	XLP	XLP260918P00084000	put	84.0000	2026-09-18	0.5400	0.5400	0.6000	83.0000	27378.00	0.00	27378.00	507	11	3155	18630	0.16935050993022	0.136046319258577	0.136046319258577	false	false	false	true
6d8fa26e-8e05-42ef-84c3-f65c6824a31c	2026-09-17 15:24	2026-09-17 15:24	2026-09-17 15:24	XLP	XLP270115C00084000	call	84.0000	2027-01-15	2.6900	2.6900	2.7700	83.5350	11567.00	0.00	11567.00	43	19	85	1418	0.0599435825105783	0.12218142628523	0.12218142628523	false	false	false	true
1ee3a2a0-7be3-4cfa-95c0-712b527e130b	2026-09-17 10:28	2026-09-17 10:28	2026-09-17 10:28	XLP	XLP261120P00089000	put	89.0000	2026-11-20	6.3500	5.3000	6.3500	83.2500	27940.00	27940.00	0.00	44	16	44	0	0	0.220782347554803	0.220782347554803	true	false	false	true
bbe5bcdd-e7ca-4a3b-8742-64e0a1ed079a	2026-09-16 15:19	2026-09-16 15:19	2026-09-16 15:19	XLP	XLP261009C00082000	call	82.0000	2026-10-09	1.9700	1.9700	2.0700	83.4200	239946.00	0.00	239946.00	1218	30	1218	0	0	0.11425374604463	0.11425374604463	false	false	false	true
7cc7a62b-61fb-4103-bdbd-c53751c4a466	2026-09-16 13:33	2026-09-16 13:33	2026-09-16 13:33	XLP	XLP270115C00085000	call	85.0000	2027-01-15	2.5500	2.4900	2.5500	83.9650	28305.00	28305.00	0.00	111	11	159	3238	0.0491043854231007	0.128897844197359	0.128897844197359	false	false	false	true