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

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	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	14406195892.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-04T17:34:11.817020Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
f5805133-5f4f-4236-9380-d14f994821e8	2026-09-08 09:50	2026-09-08 09:50	2026-09-08 09:50	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.2300	2.2300	2.2800	84.1200	89200.00	0.00	89200.00	400	7	400	10212	0.0391696043869957	0.185745473440336	0.185745473440336	false	false	false	true	false
6eacdf9b-5723-4d30-a344-887aa24d7b18	2026-09-08 09:50	2026-09-08 09:50	2026-09-08 09:50	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.2300	2.2200	2.2400	84.1000	31443.00	13380.00	13603.00	141	9	541	10212	0.0529768899334117	0.185374453414448	0.185374453414448	false	false	false	true	false
8b72c0e0-465f-41c2-98f2-20999dba4d50	2026-09-08 09:50	2026-09-08 09:50	2026-09-08 09:50	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.2300	2.1800	2.2400	84.1100	244631.00	239502.00	4906.00	1097	45	1638	10212	0.160399529964747	0.185745473440336	0.185560022274631	false	false	false	true	false
3880792c-b883-4363-8fa4-dc04ce3463c7	2026-09-08 09:53	2026-09-08 09:53	2026-09-08 09:53	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.2300	2.2300	2.2600	84.0800	35680.00	0.00	35680.00	160	8	1821	10212	0.178319623971798	0.185002961492583	0.185002961492583	false	false	false	true	false
9c582d46-6063-47a7-b332-41684a2ad772	2026-09-08 09:56	2026-09-08 09:56	2026-09-08 09:56	XLP	XLP270115P00082000	put	82.0000	2027-01-15	2.2200	2.0300	2.2300	84.1500	21756.00	21756.00	0.00	98	6	2033	10212	0.199079514296906	0.185754662886841	0.185754662886841	false	false	false	true	false
b4db8f88-8c1f-49e4-8ec2-d571fd48b2aa	2026-09-08 10:17	2026-09-08 10:17	2026-09-08 10:17	XLP	XLP270617C00089000	call	89.0000	2027-06-17	2.9900	2.7400	2.9900	84.0300	11360.00	11062.00	298.00	38	12	38	92	0.41304347826087	0.133541094214864	0.133541094214864	false	false	false	true	false
e45b0b8b-4f1d-4531-ad4b-5570e39cddf0	2026-09-08 10:18	2026-09-08 10:18	2026-09-08 10:18	XLP	XLP260925P00086500	put	86.5000	2026-09-25	3.1000	2.9200	3.1000	84.0150	44020.00	44020.00	0.00	142	7	142	10	14.2	0.229505996430445	0.229505996430445	false	false	false	true	false
b1167b51-218e-4d0e-98dc-55099e2ecd97	2026-09-08 10:50	2026-09-08 10:50	2026-09-08 10:50	XLP	XLP261016C00086000	call	86.0000	2026-10-16	0.8200	0.7900	0.8200	84.1800	62812.00	62812.00	0.00	766	13	932	3847	0.242266701325708	0.131527655426379	0.131527655426379	false	false	false	true	false
b40694b5-61e3-4d6c-9ab7-e6f1a95cbeac	2026-09-08 11:23	2026-09-08 11:23	2026-09-08 11:23	XLP	XLP260925P00085000	put	85.0000	2026-09-25	2.0000	1.8500	2.1000	83.8900	54000.00	54000.00	0.00	270	43	392	1436	0.272980501392758	0.202433712364077	0.202433712364077	false	false	false	true	false
0e2a083d-710d-4181-87f9-62f249497902	2026-09-08 12:13	2026-09-08 12:13	2026-09-08 12:13	XLP	XLP261218C00085000	call	85.0000	2026-12-18	2.5200	2.4700	2.5200	83.9900	42840.00	42840.00	0.00	170	32	170	2463	0.0690215184734064	0.145042001171018	0.145042001171018	false	false	false	true	false
017dac8c-b2f7-477a-baee-365b262a3b80	2026-09-08 12:47	2026-09-08 12:47	2026-09-08 12:47	XLP	XLP261016P00084000	put	84.0000	2026-10-16	1.6800	1.6800	1.7100	84.0400	41664.00	0.00	41664.00	248	20	344	272	1.26470588235294	0.172722224059432	0.172722224059432	false	false	false	true	false
55993bb3-8398-418b-8dac-ac8a892d19d3	2026-09-08 13:08	2026-09-08 13:08	2026-09-08 13:08	XLP	XLP261016P00083000	put	83.0000	2026-10-16	1.2700	1.2500	1.2700	83.9800	42672.00	42672.00	0.00	336	26	623	570	1.09298245614035	0.172913771612325	0.172913771612325	false	false	false	true	false
9d964b77-1aee-40fd-a423-0be44e9ba959	2026-09-08 14:26	2026-09-08 14:26	2026-09-08 14:26	XLP	XLP261016P00084000	put	84.0000	2026-10-16	1.7100	1.6700	1.7100	84.0300	49590.00	49590.00	0.00	290	30	856	272	3.14705882352941	0.175086761198043	0.175086761198043	false	false	false	true	false
f56a5280-5cf5-4bf8-936f-1bf0b791c354	2026-09-08 15:24	2026-09-08 15:24	2026-09-08 15:24	XLP	XLP270115P00084000	put	84.0000	2027-01-15	3.0500	3.0500	3.1000	84.1400	21655.00	0.00	21655.00	71	7	74	2570	0.0287937743190661	0.185419111055117	0.185419111055117	false	false	false	true	false
3d26bf67-0495-41eb-b2d1-1d9a3b62fbaf	2026-09-08 15:35	2026-09-08 15:35	2026-09-08 15:35	XLP	XLP270115C00084000	call	84.0000	2027-01-15	3.4000	3.3500	3.4000	84.2350	324360.00	324360.00	0.00	954	11	960	359	2.67409470752089	0.133106066682598	0.133106066682598	false	false	false	true	false
a0c1a93c-01f5-45a2-9c9d-bfc6ca5f278a	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	XLP	XLP260918P00085000	put	85.0000	2026-09-18	1.6800	1.4500	1.7600	83.4900	11738.00	11592.00	146.00	70	10	70	8406	0.00832738520104687	0.131233497583483	0.151580254003592	false	false	false	true	false
99b6116b-54fd-4ea0-bbe1-504f08c4eb69	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	XLP	XLP260918P00088000	put	88.0000	2026-09-18	4.8500	4.3500	4.8500	83.1700	22310.00	22310.00	0.00	46	9	46	489	0.0940695296523517	0.241222430746871	0.241222430746871	true	false	false	true	false
93f676f0-f254-447a-b823-7b44c2f07885	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	XLP	XLP260918P00089000	put	89.0000	2026-09-18	5.8500	5.3000	5.8500	83.1700	13455.00	13455.00	0.00	23	9	23	452	0.0508849557522124	0.278591586294352	0.278591586294352	true	false	false	true	false
69643708-2cff-4393-8bf8-cd21447e4499	2026-09-09 09:30	2026-09-09 09:30	2026-09-09 09:30	XLP	XLP260918P00085000	put	85.0000	2026-09-18	2.0000	1.9200	2.0100	83.1700	16802.00	16802.00	0.00	84	8	248	8406	0.0295027361408518	0.162313407979426	0.164951614659894	true	false	false	true	false
ebdaf35e-b8d4-4fc6-9fb3-b0a361f854cb	2026-09-09 09:46	2026-09-09 09:46	2026-09-09 09:46	XLP	XLP261009C00080000	call	80.0000	2026-10-09	3.5500	3.3500	3.6000	83.1800	11005.00	11005.00	0.00	31	5	31	0	0	0.113373391636329	0.113373391636329	true	false	false	true	false
caa985d5-cd6b-4762-92db-151556838ed1	2026-09-09 10:09	2026-09-09 10:09	2026-09-09 10:09	XLP	XLP260918C00084000	call	84.0000	2026-09-18	0.5700	0.5700	0.6000	83.3200	15732.00	0.00	15732.00	276	34	314	2653	0.11835657745948	0.159675256907627	0.159675256907627	false	false	false	true	false
0e1883cc-e110-440f-872d-8747434a0079	2026-09-09 10:24	2026-09-09 10:24	2026-09-09 10:24	XLP	XLP260911P00085000	put	85.0000	2026-09-11	1.8400	1.6600	1.8400	83.0000	18400.00	18400.00	0.00	100	10	508	691	0.735166425470333	0.1959828250426	0.1959828250426	true	false	false	true	false
dc36b908-469a-4c8b-b932-fd522e92539f	2026-09-09 10:37	2026-09-09 10:37	2026-09-09 10:37	XLP	XLP270319P00084000	put	84.0000	2027-03-19	4.0000	4.0000	4.1500	83.0000	27600.00	0.00	27600.00	69	5	242	6	40.3333333333333	0.180402074460275	0.180402074460275	false	false	false	true	false
506f6ec2-2b9f-4966-869e-c504b2068fea	2026-09-09 11:14	2026-09-09 11:13	2026-09-09 11:13	XLP	XLP260918C00084500	call	84.5000	2026-09-18	0.3000	0.2700	0.3100	82.9550	76140.00	30.00	74790.00	2538	18	2557	57	44.859649122807	0.15954250332818	0.15954250332818	false	false	false	true	false
e485adec-4514-41f9-b2a4-2eb7d90af2ff	2026-09-09 12:49	2026-09-09 12:49	2026-09-09 12:49	XLP	XLP261016C00088000	call	88.0000	2026-10-16	0.2400	0.2300	0.2500	83.0000	12000.00	48.00	11952.00	500	42	539	567	0.950617283950617	0.146696500058921	0.146696500058921	true	false	false	true	false
c9593c0e-94ee-4eb4-b4fa-ec71eba63187	2026-09-09 12:56	2026-09-09 12:56	2026-09-09 12:56	XLP	XLP261016C00083000	call	83.0000	2026-10-16	1.5500	1.5500	1.6100	82.0000	18755.00	0.00	18755.00	121	7	145	34	4.26470588235294	0.132691010562839	0.132691010562839	false	false	false	true	false
e0804319-7fae-4437-a7d6-c63eac80abf9	2026-09-09 14:07	2026-09-09 14:07	2026-09-09 14:07	XLP	XLP261120C00085000	call	85.0000	2026-11-20	1.6800	1.6600	1.6800	83.2350	16800.00	16800.00	0.00	100	9	341	59	5.77966101694915	0.147479156003874	0.147479156003874	false	false	false	true	false
c1b80ec8-1a07-4e7f-bcd4-873b4a7fdbd8	2026-09-09 14:11	2026-09-09 14:11	2026-09-09 14:11	XLP	XLP260918C00084500	call	84.5000	2026-09-18	0.3500	0.3200	0.3500	83.2300	14770.00	14770.00	0.00	422	6	3085	57	54.1228070175439	0.154235687730355	0.154235687730355	true	false	false	true	false
c4e7e54d-3185-4575-9f9c-3da2531027f6	2026-09-09 15:29	2026-09-09 15:29	2026-09-09 15:29	XLP	XLP261023P00083000	put	83.0000	2026-10-23	1.8200	1.7500	1.8200	83.1500	51687.00	51687.00	0.00	284	33	306	2	153	0.180345652128108	0.180345652128108	true	false	false	true	false
bed6414e-90ca-423c-b350-eb1392261af9	2026-09-09 15:45	2026-09-09 15:45	2026-09-09 15:45	XLP	XLP261016C00080000	call	80.0000	2026-10-16	3.5900	3.5500	3.6000	83.0500	15795.00	10440.00	5355.00	44	6	44	208	0.211538461538462	0.122247192784379	0.117006791437074	false	false	false	true	false
5827af88-19d2-422f-8e3a-07f25b279c5f	2026-09-10 09:32	2026-09-10 09:32	2026-09-10 09:32	XLP	XLP260918C00083000	call	83.0000	2026-09-18	1.2000	1.0000	1.3900	83.5600	48120.00	15840.00	32280.00	401	23	405	1095	0.36986301369863	0.172580252646905	0.172580252646905	false	false	false	true	false
c94e6ded-fc90-4bd3-bb7c-17165ca95479	2026-09-10 10:17	2026-09-10 10:17	2026-09-10 10:17	XLP	XLP261218C00091000	call	91.0000	2026-12-18	0.6600	0.6600	0.7000	83.5500	30096.00	0.00	30096.00	456	35	478	600	0.796666666666667	0.153705552669623	0.153705552669623	false	false	false	true	false
7fea049d-ee63-4053-af81-e4efcf3c7ad9	2026-09-10 10:18	2026-09-10 10:18	2026-09-10 10:18	XLP	XLP261016C00087000	call	87.0000	2026-10-16	0.4500	0.4500	0.4900	83.5150	11250.00	0.00	11250.00	250	6	396	280	1.41428571428571	0.144300951578855	0.144300951578855	false	false	false	true	false
a39294da-fca9-4470-a662-b907f3361397	2026-09-10 11:10	2026-09-10 11:10	2026-09-10 11:10	XLP	XLP261120C00085000	call	85.0000	2026-11-20	1.6700	1.6700	1.7200	83.2400	78824.00	0.00	78824.00	472	40	1213	734	1.65258855585831	0.147882056591239	0.147882056591239	false	false	false	true	false
33e706d2-c0ea-4cb4-b3d2-5a30ef53e32f	2026-09-10 11:42	2026-09-10 11:42	2026-09-10 11:42	XLP	XLP261002C00086000	call	86.0000	2026-10-02	0.3200	0.3200	0.3300	83.3200	55392.00	0.00	55392.00	1731	17	1739	80	21.7375	0.140500432764735	0.140500432764735	false	false	false	true	false
0d48715a-6539-4eeb-b128-61271e162c5b	2026-09-10 14:14	2026-09-10 14:14	2026-09-10 14:14	XLP	XLP260918C00083500	call	83.5000	2026-09-18	0.7200	0.7200	0.7500	83.2402	49032.00	0.00	49032.00	681	22	684	32	21.375	0.164879657084752	0.164879657084752	false	false	false	true	false
35b00abd-2155-4572-b7ca-3d991a5aa6e9	2026-09-10 15:56	2026-09-10 15:55	2026-09-10 15:55	XLP	XLP261016C00085000	call	85.0000	2026-10-16	0.8100	0.7600	0.8100	83.0950	96876.00	96876.00	0.00	1196	9	1284	1712	0.75	0.13942850792605	0.13942850792605	true	false	false	true	false
e3e2cf64-02bd-40d8-b6a4-c73e615fbe8e	2026-09-11 09:49	2026-09-11 09:49	2026-09-11 09:49	XLP	XLP260918P00084000	put	84.0000	2026-09-18	1.0700	1.0550	1.0700	83.0000	12626.00	12626.00	0.00	118	5	558	13403	0.0416324703424606	0.161483091599156	0.161483091599156	false	false	false	true	false
590bf14f-95e3-46fe-a741-4e74263f1d08	2026-09-11 10:03	2026-09-11 10:03	2026-09-11 10:03	XLP	XLP261016P00089000	put	89.0000	2026-10-16	6.2000	6.2000	6.4000	83.2100	14260.00	0.00	14260.00	23	8	23	5	4.6	0.247271979873049	0.247271979873049	true	false	false	true	false
227c1f2b-f76b-4bd2-8b39-a775580ca117	2026-09-11 10:03	2026-09-11 10:03	2026-09-11 10:03	XLP	XLP260918P00083500	put	83.5000	2026-09-18	0.7800	0.7800	0.8800	83.2100	13650.00	0.00	13650.00	175	11	176	265	0.664150943396226	0.14338913212249	0.14338913212249	true	false	false	true	false
a8b109ec-2c6b-4703-9ca5-4a0649c59a97	2026-09-11 10:33	2026-09-11 10:33	2026-09-11 10:33	XLP	XLP261016P00083000	put	83.0000	2026-10-16	1.5400	1.5000	1.5900	83.3650	232078.00	0.00	232078.00	1507	13	1518	1131	1.342175066313	0.182189340834568	0.181553084943846	false	false	false	true	false
9708c229-5fcf-45be-8597-b35d43053d02	2026-09-11 10:49	2026-09-11 10:49	2026-09-11 10:49	XLP	XLP260918P00085000	put	85.0000	2026-09-18	1.8500	1.8400	1.8500	83.2600	16280.00	16280.00	0.00	88	5	127	6946	0.0182839044054132	0.155578683994428	0.155578683994428	true	false	false	true	false
46b4b994-dcad-424f-bb18-a264af48cf77	2026-09-11 11:25	2026-09-11 11:24	2026-09-11 11:24	XLP	XLP261016C00084000	call	84.0000	2026-10-16	1.1000	1.1000	1.1400	83.1700	42020.00	0.00	42020.00	382	24	383	130	2.94615384615385	0.129887730112787	0.129887730112787	false	false	false	true	false
478a2eca-1747-4561-8845-1318e9b16890	2026-09-11 13:06	2026-09-11 13:05	2026-09-11 13:05	XLP	XLP261023C00086500	call	86.5000	2026-10-23	0.6000	0.6000	0.6400	83.5500	166740.00	0.00	166740.00	2779	22	2794	10	279.4	0.13538260295844	0.13538260295844	false	false	false	true	false
90120afb-e10a-4773-9e6b-6cfd068d6200	2026-09-11 15:12	2026-09-11 15:12	2026-09-11 15:12	XLP	XLP280121C00081000	call	81.0000	2028-01-21	8.4000	8.2500	8.4000	83.4150	11760.00	11760.00	0.00	14	5	39	84	0.464285714285714	0.09851984915548	0.09851984915548	false	false	false	true	false
9cefc719-84df-4d88-b29c-3ab95b359b3a	2026-09-14 09:37	2026-09-14 09:37	2026-09-14 09:37	XLP	XLP270617C00080000	call	80.0000	2027-06-17	8.3000	7.9500	8.3500	84.8600	18260.00	13280.00	4980.00	22	8	22	92	0.239130434782609	0.136748937424359	0.136748937424359	false	false	false	true	false