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: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	price

de87502a-e5ee-4c67-9685-58f960a232df	2026-09-14 09:40	2026-09-14 09:40	2026-09-14 09:40	XLP	XLP270115C00087000	call	87.0000	2027-01-15	2.2400	2.1700	2.2400	84.0000	39872.00	39872.00	0.00	178	26	194	630	0.307936507936508	0.140460948703526	0.140460948703526	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	14428366003.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-14T13:48:00.043994Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
625f5e82-eb86-44c6-8f28-ab88a8de2dea	2026-09-14 10:38	2026-09-14 10:38	2026-09-14 10:38	XLP	XLP270319C00086000	call	86.0000	2027-03-19	3.4000	3.3500	3.6500	84.5950	26860.00	7820.00	19040.00	79	12	84	63	1.33333333333333	0.138613304541242	0.138613304541242	false	false	false	true	false
79a02605-d097-4823-9069-c85a198d4d75	2026-09-14 13:25	2026-09-14 13:25	2026-09-14 13:25	XLP	XLP260918C00086000	call	86.0000	2026-09-18	0.1500	0.1300	0.1500	84.4950	10935.00	10935.00	0.00	729	51	803	9440	0.0850635593220339	0.176922119406025	0.176922119406025	false	false	false	true	false
f1777097-cc55-4596-8b5a-660307cd9d50	2026-09-15 12:25	2026-09-15 12:25	2026-09-15 12:25	XLP	XLP270115C00082000	call	82.0000	2027-01-15	4.0500	4.0500	4.1000	83.0000	10126.00	0.00	10126.00	25	6	25	595	0.0420168067226891	0.124880205039102	0.125470776431109	false	false	false	true	false
d6765c51-83b1-44eb-9d21-e2903f6f85f1	2026-09-15 12:25	2026-09-15 12:25	2026-09-15 12:25	XLP	XLP270115C00083000	call	83.0000	2027-01-15	3.4500	3.4500	3.6500	83.0000	83490.00	0.00	83490.00	242	20	242	453	0.534216335540839	0.126545805079496	0.126545805079496	false	false	false	true	false
4ec9a2d3-8085-42f4-9c90-6a235c5617fd	2026-09-15 12:25	2026-09-15 12:25	2026-09-15 12:25	XLP	XLP261218C00084000	call	84.0000	2026-12-18	2.7000	2.7000	2.7100	83.0000	13500.00	0.00	13500.00	50	8	50	679	0.0736377025036819	0.141645104188375	0.141645104188375	false	false	false	true	false
6614e3ae-9f53-4a29-9a1a-579376789469	2026-09-15 12:26	2026-09-15 12:26	2026-09-15 12:26	XLP	XLP261218P00078000	put	78.0000	2026-12-18	0.7100	0.7100	0.8000	83.0000	887500.00	0.00	887500.00	12500	1	12538	120176	0.104330315537212	0.176191649742622	0.176191649742622	false	true	false	true	false
1ec4150d-1669-462d-9639-8cffadd1e8a9	2026-09-15 12:28	2026-09-15 12:28	2026-09-15 12:28	XLP	XLP270115C00075000	call	75.0000	2027-01-15	9.4500	9.4500	9.5000	83.0000	53865.00	0.00	53865.00	57	13	57	213	0.267605633802817	0.219357040144091	0.219357040144091	false	false	false	true	false
742b7957-4d3e-439b-bfe5-6e072b2ef38d	2026-09-15 12:39	2026-09-15 12:39	2026-09-15 12:39	XLP	XLP270115C00083000	call	83.0000	2027-01-15	3.4000	3.4000	3.4500	83.0000	122740.00	0.00	122740.00	361	32	604	453	1.33333333333333	0.125537505820568	0.125537505820568	false	false	false	true	false
7f6a311a-5026-40e8-8e69-b363b7b157f0	2026-09-15 14:24	2026-09-15 14:24	2026-09-15 14:24	XLP	XLP260918P00085000	put	85.0000	2026-09-18	1.2000	1.2000	1.2500	83.9400	168000.00	0.00	168000.00	1400	14	2165	6826	0.317169645473191	0.174086199949611	0.174086199949611	false	false	false	true	false
9a12fe18-1027-4fe0-9a56-e63e89782891	2026-09-15 14:28	2026-09-15 14:28	2026-09-15 14:28	XLP	XLP260918P00085000	put	85.0000	2026-09-18	1.1400	1.1200	1.1700	84.0150	49134.00	36822.00	12312.00	431	6	2641	6826	0.386903017872839	0.173126850524968	0.173126850524968	true	false	false	true	false
fb61efaf-7f9f-4631-a710-289fe8ae3b74	2026-09-15 14:30	2026-09-15 14:29	2026-09-15 14:29	XLP	XLP260918P00085000	put	85.0000	2026-09-18	1.1400	1.1100	1.1500	84.0300	42066.00	42066.00	0.00	369	17	3126	6826	0.457954878406094	0.177900243201892	0.177900243201892	false	false	false	true	false
56d3c62d-ab7e-4706-972f-22073b71404e	2026-09-15 14:30	2026-09-15 14:29	2026-09-15 14:29	XLP	XLP260918P00085000	put	85.0000	2026-09-18	1.1400	1.1400	1.1700	84.0100	38874.00	0.00	38874.00	341	12	3745	6826	0.54863756226194	0.171498088618554	0.171498088618554	false	false	false	true	false
2f07dcd8-5cd4-4a7f-a7c7-ffee3aca9115	2026-09-15 14:30	2026-09-15 14:29	2026-09-15 14:29	XLP	XLP260918P00085000	put	85.0000	2026-09-18	1.1400	1.1200	1.1400	84.0300	23598.00	23598.00	0.00	207	8	3404	6826	0.498681511866393	0.177900243201892	0.177900243201892	false	false	false	true	false
369bbf48-05c5-4f80-87f9-858aa374ebe9	2026-09-15 15:16	2026-09-15 15:16	2026-09-15 15:16	XLP	XLP260918C00088000	call	88.0000	2026-09-18	0.0200	0.0100	0.0200	83.9100	5000.00	5000.00	0.00	2500	1	2500	5931	0.421514078570224	0.266950661980443	0.266950661980443	false	true	false	true	false
a9bfbb12-f8bb-4ae8-8b1a-2e375e420b31	2026-09-16 13:33	2026-09-16 13:33	2026-09-16 13:33	XLP	XLP270115C00085000	call	85.0000	2027-01-15	2.4500	2.4000	2.5800	83.9650	11531.00	6856.00	4675.00	47	7	48	3238	0.0148239654107474	0.122146088157022	0.12630097895301	false	false	false	true	false
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	false
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	false
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	false
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	false
fb80879b-d01c-44c2-96e4-3996e90e8205	2026-09-17 15:55	2026-09-17 15:55	2026-09-17 15:55	XLP	XLP261016C00080000	call	80.0000	2026-10-16	3.6200	3.4500	3.6500	83.0000	17368.00	4344.00	13024.00	48	8	49	264	0.185606060606061	0.11194330619466	0.11194330619466	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
d8190fca-1ba6-49e6-a9d5-8e1ddf3871d8	2026-09-18 13:12	2026-09-18 13:12	2026-09-18 13:12	XLP	XLP261002C00082000	call	82.0000	2026-10-02	1.3100	1.3000	1.4400	83.1000	12575.00	131.00	12444.00	96	6	98	0	0	0.0685892605246406	0.0713799016018775	true	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
0287360b-4f9b-493f-b67c-8601793b940b	2026-09-18 15:24	2026-09-18 15:24	2026-09-18 15:24	XLP	XLP261120C00082000	call	82.0000	2026-11-20	2.6400	2.6300	2.7700	83.0300	14783.00	0.00	14783.00	56	6	56	0	0	0.125107520480517	0.125895290625497	true	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false