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×

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

1a6196f7-e14e-4c53-8823-0a5a0212ccf7	2026-09-08 09:37	2026-09-08 09:37	2026-09-08 09:37	XLP	XLP261016P00083000	put	83.0000	2026-10-16	1.2200	1.0500	1.2200	84.1600	25620.00	25620.00	0.00	210	30	213	570	0.373684210526316	0.174552562712622	0.174552562712622	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-09-08T13:39:51.680537Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
8f6b1337-b5e5-4eb4-a055-0db1efacc2c2	2026-09-04 15:03	2026-09-04 15:03	2026-09-04 15:03	XLP	XLP261016P00083000	put	83.0000	2026-10-16	1.0200	0.9900	1.0200	84.6800	19380.00	19380.00	0.00	190	19	266	384	0.692708333333333	0.165196289740492	0.165196289740492	false	false	false	true	false
be1793a1-cea9-4f2e-b171-2ca681520189	2026-09-04 13:23	2026-09-04 13:23	2026-09-04 13:23	XLP	XLP261016P00085000	put	85.0000	2026-10-16	1.8600	1.8000	1.8600	84.7700	91698.00	91698.00	0.00	493	41	1462	3228	0.452912019826518	0.168835073154317	0.168835073154317	false	false	false	true	false
d58bfb21-3f0a-46fc-9c1a-e917a10cf131	2026-09-04 13:18	2026-09-04 13:17	2026-09-04 13:17	XLP	XLP261016P00085000	put	85.0000	2026-10-16	1.8000	1.7600	1.8000	84.8200	12060.00	12060.00	0.00	67	9	393	3228	0.121747211895911	0.165665148143204	0.165665148143204	false	false	false	true	false
9536b7c0-53e7-48c2-ad56-10ad76b70ed7	2026-09-04 13:00	2026-09-04 13:00	2026-09-04 13:00	XLP	XLP261016P00085000	put	85.0000	2026-10-16	1.7800	1.7800	1.8000	84.9100	39338.00	0.00	39338.00	221	10	319	3228	0.0988228004956629	0.167599169472514	0.167599169472514	false	false	false	true	false
d9e5b36f-0591-40cd-aa24-3b150f41234a	2026-09-04 10:44	2026-09-04 10:44	2026-09-04 10:44	XLP	XLP270617C00092000	call	92.0000	2027-06-17	2.4100	2.3500	2.4100	84.8550	300783.00	298383.00	1200.00	1249	10	1249	48	26.0208333333333	0.140732283920363	0.140732283920363	false	false	false	true	false
cc95ff1d-b03a-4dd8-b73f-1e5788d8655e	2026-09-04 10:44	2026-09-04 10:44	2026-09-04 10:44	XLP	XLP280121C00092000	call	92.0000	2028-01-21	3.9500	3.9500	4.2000	84.8550	372487.00	0.00	372487.00	943	64	1180	76	15.5263157894737	0.128362195641344	0.128362195641344	false	false	false	true	false
dc429d96-e8d6-43c0-9175-8cdd0b5d3162	2026-09-04 10:43	2026-09-04 10:42	2026-09-04 10:42	XLP	XLP260904P00085000	put	85.0000	2026-09-04	0.2000	0.1900	0.2000	84.8000	42240.00	42240.00	0.00	2112	26	3971	6091	0.651945493350846	0.0549961294242754	0.0549961294242754	false	false	false	true	false
4c87c9ff-b75f-4639-b6d8-411afd95588f	2026-09-04 10:42	2026-09-04 10:42	2026-09-04 10:42	XLP	XLP260904P00085000	put	85.0000	2026-09-04	0.2000	0.1800	0.2000	84.8300	10160.00	4420.00	0.00	508	78	632	6091	0.103759645378427	0.111394775278499	0.111397574862211	true	false	false	true	false
8813fb68-c542-42f3-815c-35ee846a4a81	2026-09-04 10:07	2026-09-04 10:07	2026-09-04 10:07	XLP	XLP261016C00080000	call	80.0000	2026-10-16	5.4000	5.1500	5.4000	85.1150	110160.00	110160.00	0.00	204	6	204	11	18.5454545454545	0.142757606535994	0.142757606535994	true	false	false	true	false
e1311735-c85e-4bcc-be4e-a51a7ba5a3ca	2026-09-03 12:22	2026-09-03 12:22	2026-09-03 12:22	XLP	XLP270319P00083000	put	83.0000	2027-03-19	2.6900	2.6900	2.7300	85.4700	11567.00	0.00	11567.00	43	11	43	6	7.16666666666667	0.185417433071859	0.185417433071859	false	false	false	true	false
51aa577d-124f-480b-8bd7-85465b1e785c	2026-09-03 10:25	2026-09-03 10:25	2026-09-03 10:25	XLP	XLP260918P00085000	put	85.0000	2026-09-18	0.9500	0.9500	0.9700	84.9350	25840.00	0.00	25840.00	272	12	814	7883	0.103260180134467	0.143308615301878	0.143308615301878	false	false	false	true	false
45f8752c-81da-4d3d-9564-7be3acf21f40	2026-09-03 10:22	2026-09-03 10:22	2026-09-03 10:22	XLP	XLP260925P00087500	put	87.5000	2026-09-25	3.2000	2.9900	3.2500	84.9500	11840.00	11840.00	0.00	37	6	37	16	2.3125	0.211721513379433	0.211721513379433	true	false	false	true	false
a534078a-135f-465d-a23b-197426f91360	2026-09-02 15:36	2026-09-02 15:36	2026-09-02 15:36	XLP	XLP260918C00078000	call	78.0000	2026-09-18	7.7500	7.7000	7.7500	85.5700	36425.00	36425.00	0.00	47	6	47	324	0.145061728395062	0.240301007333427	0.240301007333427	false	false	false	true	false
e102357f-1f44-4968-8999-efc97647ac95	2026-09-02 14:55	2026-09-02 14:54	2026-09-02 14:54	XLP	XLP280121C00085000	call	85.0000	2028-01-21	7.8000	7.8000	8.0500	85.8300	17940.00	0.00	17940.00	23	7	26	1010	0.0257425742574257	0.125884363049768	0.125884363049768	false	false	false	true	false
fde61691-7519-40af-83f0-7e1052b6f2ba	2026-09-02 14:49	2026-09-02 14:49	2026-09-02 14:49	XLP	XLP261120P00090000	put	90.0000	2026-11-20	5.1000	4.8500	5.2000	85.8650	15300.00	13770.00	1530.00	30	18	42	4	10.5	0.192540654698429	0.192540654698429	true	false	false	true	false
de2fa5ee-c53a-4d72-80b0-0c2e8dd51d9e	2026-09-02 14:23	2026-09-02 14:23	2026-09-02 14:23	XLP	XLP260911C00086500	call	86.5000	2026-09-11	0.5300	0.5200	0.5800	86.0000	10593.00	0.00	10593.00	200	10	1245	1427	0.872459705676244	0.131485393259908	0.133388522673172	false	false	false	true	false
f60be4e8-16a0-463d-91d1-b498e0da93b2	2026-09-02 14:22	2026-09-02 14:22	2026-09-02 14:22	XLP	XLP260911C00086500	call	86.5000	2026-09-11	0.5400	0.5400	0.5800	86.0250	10800.00	0.00	10800.00	200	29	1045	1427	0.732305536089699	0.133317704177621	0.133317704177621	false	false	false	true	false
1031aa86-4934-4506-b828-a1d852fa60f0	2026-09-02 14:04	2026-09-02 14:04	2026-09-02 14:04	XLP	XLP261016C00086000	call	86.0000	2026-10-16	1.7400	1.7300	1.7500	86.0350	229680.00	0.00	228810.00	1320	12	1333	2519	0.529178245335451	0.127150706579529	0.127150706579529	false	false	false	true	false
06d039e3-1b91-4c05-a4b2-20a8eb9c3d71	2026-09-02 11:04	2026-09-02 11:04	2026-09-02 11:04	XLP	XLP260911P00084000	put	84.0000	2026-09-11	0.2200	0.2200	0.2400	85.5600	32714.00	0.00	32714.00	1487	9	1632	292	5.58904109589041	0.147013362797981	0.147013362797981	false	false	false	true	false
006c0c43-4a92-4ea3-b8ac-b7a3acf47ecb	2026-09-02 10:24	2026-09-02 10:24	2026-09-02 10:24	XLP	XLP261218P00077000	put	77.0000	2026-12-18	0.5600	0.5600	0.6000	85.2700	10136.00	0.00	10136.00	181	25	194	8585	0.0225975538730344	0.189704282109163	0.189704282109163	false	false	false	true	false
6992175d-e300-4038-ac97-8cc10f4462e7	2026-09-01 15:56	2026-09-01 15:56	2026-09-01 15:56	XLP	XLP260918C00078000	call	78.0000	2026-09-18	7.4700	7.3000	7.5000	85.1850	35090.00	24000.00	8840.00	47	7	47	264	0.178030303030303	0.291187359090178	0.291187359090178	false	false	false	true	false
23c75e05-bf45-40e1-8251-533a775536bd	2026-09-01 14:50	2026-09-01 14:50	2026-09-01 14:50	XLP	XLP261016C00086000	call	86.0000	2026-10-16	1.4300	1.4200	1.4900	85.2400	348920.00	143.00	348777.00	2440	32	2539	40	63.475	0.133631676076001	0.133631676076001	false	false	false	true	false
1a39e1c0-9d44-4331-b2ea-b1583f0f2c2b	2026-09-01 14:49	2026-09-01 14:49	2026-09-01 14:49	XLP	XLP260918P00089000	put	89.0000	2026-09-18	3.7500	3.7500	3.8000	85.2600	12375.00	0.00	12375.00	33	7	372	988	0.376518218623482	0.159416299060608	0.159416299060608	true	false	false	true	false
0b5ad603-6c84-4f98-986a-1b521f7591b1	2026-09-01 14:12	2026-09-01 14:12	2026-09-01 14:12	XLP	XLP260918C00086000	call	86.0000	2026-09-18	0.8700	0.8700	0.9400	85.4208	87000.00	0.00	87000.00	1000	52	1263	9541	0.132376061209517	0.145017999782239	0.145017999782239	false	false	false	true	false
2812e70d-bf00-4527-b7e7-3f78e195595d	2026-09-01 14:00	2026-09-01 14:00	2026-09-01 14:00	XLP	XLP260918P00089000	put	89.0000	2026-09-18	3.6000	3.6000	3.6500	85.4350	11520.00	0.00	11520.00	32	13	339	988	0.343117408906883	0.160191786369498	0.160191786369498	true	false	false	true	false
9bb2f4ca-b4bd-4813-8700-f04a219d3eb6	2026-09-01 12:31	2026-09-01 12:30	2026-09-01 12:30	XLP	XLP260918P00089000	put	89.0000	2026-09-18	3.5500	3.4500	3.6000	85.4900	11715.00	4260.00	2130.00	33	6	241	988	0.243927125506073	0.159593360587858	0.159593360587858	false	false	false	true	false
7148b7fe-9925-475a-a65d-f9bfdd682ee9	2026-09-01 11:00	2026-09-01 11:00	2026-09-01 11:00	XLP	XLP260918P00089000	put	89.0000	2026-09-18	3.3500	3.3000	3.3500	85.7400	11055.00	11055.00	0.00	33	6	143	988	0.144736842105263	0.162653248185037	0.162653248185037	false	false	false	true	false
ad6aed7d-18fd-4eab-85cd-4b10b264b379	2026-09-01 10:00	2026-09-01 10:00	2026-09-01 10:00	XLP	XLP260918P00089000	put	89.0000	2026-09-18	3.3000	3.3000	3.3500	85.7700	10230.00	0.00	10230.00	31	16	71	988	0.0718623481781376	0.157095298389084	0.157095298389084	true	false	false	true	false
c78a4aec-4f73-44f7-8738-1a9b1a38c32f	2026-09-01 09:56	2026-09-01 09:56	2026-09-01 09:56	XLP	XLP260918C00085000	call	85.0000	2026-09-18	1.6000	1.5900	1.6500	85.7250	18240.00	160.00	18080.00	114	10	116	2879	0.0402917679749913	0.150692923650372	0.150692923650372	false	false	false	true	false
d6761ce7-b922-4ca4-b350-e87facfc346e	2026-08-31 15:33	2026-08-31 15:32	2026-08-31 15:32	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.0700	2.0400	2.0700	85.0000	28152.00	28152.00	0.00	136	12	775	9268	0.0836210617177384	0.186194161252242	0.186194161252242	false	false	false	true	false
a1c6a30f-ee64-4101-99bf-255406b7c6ed	2026-08-31 15:33	2026-08-31 15:32	2026-08-31 15:32	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.0700	2.0400	2.0800	85.0000	13248.00	7038.00	1863.00	64	16	512	9268	0.0552438498057833	0.186194161252242	0.186194161252242	false	false	false	true	false
43b88bca-71fe-416e-aee4-9b8d245fc57b	2026-08-31 12:46	2026-08-31 12:46	2026-08-31 12:46	XLP	XLP260918P00086000	put	86.0000	2026-09-18	1.5400	1.5200	1.5600	85.0350	298452.00	296912.00	1540.00	1938	21	2083	4861	0.428512651717754	0.144317262743732	0.144317262743732	true	false	false	true	false
c484d531-dc2f-49eb-8026-133ca9b602fa	2026-08-31 09:50	2026-08-31 09:50	2026-08-31 09:50	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.0900	2.0700	2.1400	85.0650	37202.00	1254.00	1254.00	178	6	178	9268	0.0192058696590419	0.188379390933632	0.188379390933632	false	false	false	true	false
4597fb4a-dfec-4724-8c59-47d630ca3ed4	2026-08-28 13:24	2026-08-28 13:24	2026-08-28 13:24	XLP	XLP260918C00087000	call	87.0000	2026-09-18	0.5600	0.5500	0.5600	85.3750	11424.00	11424.00	0.00	204	36	409	6131	0.066710161474474	0.137912221393072	0.137912221393072	false	false	false	true	false
f3a5dc22-5cbd-4f06-9db6-09cfbf6b56dd	2026-08-28 12:43	2026-08-28 12:43	2026-08-28 12:43	XLP	XLP261218C00093000	call	93.0000	2026-12-18	0.7500	0.7400	0.7700	85.2850	10500.00	0.00	10500.00	140	14	147	122	1.20491803278689	0.150779821525459	0.150779821525459	false	false	false	true	false
ffec6050-7c75-49ee-9153-b81531685900	2026-08-28 11:45	2026-08-28 11:45	2026-08-28 11:45	XLP	XLP261218P00075000	put	75.0000	2026-12-18	0.4000	0.4000	0.4300	85.0000	10960.00	0.00	10960.00	274	46	278	1837	0.151333696243876	0.196293057249163	0.196293057249163	false	false	false	true	false
ac221721-b20a-471f-929e-a23d91f53d6c	2026-08-28 09:47	2026-08-28 09:47	2026-08-28 09:47	XLP	XLP270115P00082000	put	82.0000	2027-01-15	1.9900	1.9200	2.0100	85.4250	99500.00	99500.00	0.00	500	6	504	8770	0.0574686431014823	0.18921062581844	0.18921062581844	false	false	false	true	false
8bc5a7af-e6bf-4dd1-ab5d-a15e6afaf780	2026-08-27 15:58	2026-08-27 15:58	2026-08-27 15:58	XLP	XLP260918P00086000	put	86.0000	2026-09-18	1.5500	1.5400	1.5800	85.0795	21080.00	0.00	21080.00	136	10	844	4199	0.201000238151941	0.13768380639187	0.13768380639187	false	false	false	true	false
13eea358-85a6-4ee1-a536-5904af54fcaa	2026-08-27 15:57	2026-08-27 15:57	2026-08-27 15:57	XLP	XLP260918P00086000	put	86.0000	2026-09-18	1.5500	1.5500	1.5900	85.0750	22940.00	0.00	22940.00	148	23	593	4199	0.141224100976423	0.137354714786134	0.137354714786134	false	false	false	true	false
7c09a267-207a-4de2-b8fd-9ebf154a52e3	2026-08-27 15:00	2026-08-27 15:00	2026-08-27 15:00	XLP	XLP260828P00085000	put	85.0000	2026-08-28	0.1600	0.1600	0.1800	85.3550	31424.00	0.00	31424.00	1964	11	3668	1101	3.33151680290645	0.173388874671673	0.173388874671673	false	false	false	true	false
9e522b62-0dad-4967-b65c-8a369496a814	2026-08-27 13:53	2026-08-27 13:53	2026-08-27 13:53	XLP	XLP270617P00088000	put	88.0000	2027-06-17	5.7300	5.6000	5.9500	85.4200	10895.00	570.00	10325.00	19	7	19	46	0.41304347826087	0.190488680247177	0.1921318936871	false	false	false	true	false
f0c67221-abf4-47db-a024-62323f52ba28	2026-08-27 13:18	2026-08-27 13:17	2026-08-27 13:17	XLP	XLP260828P00085000	put	85.0000	2026-08-28	0.1300	0.1300	0.1500	85.4950	19006.00	0.00	19006.00	1462	11	1571	1101	1.42688465031789	0.180315891403051	0.180315891403051	false	false	false	true	false
05436ca7-ac98-4471-809a-451939f7bd2f	2026-08-27 12:21	2026-08-27 12:21	2026-08-27 12:21	XLP	XLP260918P00085500	put	85.5000	2026-09-18	1.0700	1.0200	1.0700	85.5300	10700.00	10700.00	0.00	100	5	152	16	9.5	0.140978163691062	0.140978163691062	false	false	false	true	false
4c1b8b49-ad2d-4fcf-ae67-7dc4bcc6b6c3	2026-08-27 11:31	2026-08-27 11:31	2026-08-27 11:31	XLP	XLP261002P00082000	put	82.0000	2026-10-02	0.4900	0.4900	0.5000	85.6650	98539.00	0.00	98539.00	2011	25	2175	81	26.8518518518519	0.174570371580653	0.174570371580653	false	false	false	true	false
66839167-010b-48c9-a1fb-9193a502b6a4	2026-08-27 09:53	2026-08-27 09:53	2026-08-27 09:53	XLP	XLP261218C00088000	call	88.0000	2026-12-18	2.2200	2.1700	2.2200	85.4800	223998.00	223998.00	0.00	1009	9	1010	1424	0.709269662921348	0.151348882185955	0.151348882185955	false	false	false	true	false
1d8a8313-6915-4e76-83cc-50f0e8160b4b	2026-08-26 11:38	2026-08-26 11:37	2026-08-26 11:37	XLP	XLP261016P00082000	put	82.0000	2026-10-16	0.6200	0.6200	0.6500	86.3600	120962.00	0.00	120962.00	1951	21	1962	266	7.37593984962406	0.179762430222465	0.179762430222465	false	false	false	true	false
36b5196a-a364-490f-8a2b-d85f00d72f0c	2026-08-25 13:44	2026-08-25 13:44	2026-08-25 13:44	XLP	XLP260918P00084500	put	84.5000	2026-09-18	0.5400	0.5400	0.5800	86.4600	11394.00	0.00	11394.00	211	24	244	218	1.11926605504587	0.155525456217444	0.155525456217444	false	false	false	true	false
645f15fe-d007-44ee-8ca1-57b6ddcbe407	2026-08-25 13:40	2026-08-25 13:40	2026-08-25 13:40	XLP	XLP260918P00085000	put	85.0000	2026-09-18	0.7000	0.7000	0.7300	86.4050	22120.00	0.00	22120.00	316	22	367	5940	0.0617845117845118	0.155095986069995	0.155095986069995	false	false	false	true	false
d41e6722-8df3-4df4-b542-e0e20fbbc45f	2026-08-25 12:39	2026-08-25 12:39	2026-08-25 12:39	XLP	XLP261218P00080000	put	80.0000	2026-12-18	0.9900	0.9900	1.0300	86.4950	31185.00	0.00	31185.00	315	42	330	3944	0.0836713995943205	0.191253118985496	0.191253118985496	false	false	false	true	false