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:alert_rule = RepeatedHitsAscendingFill×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	expiry

bc602f8c-6a41-484c-9235-731a11254d08	2026-08-25 10:38	2026-08-25 10:38	2026-08-25 10:38	XLP	XLP260911P00087000	put	87.0000	2026-09-11	1.4100	1.4000	1.5700	86.3300	28171.00	0.00	28171.00	200	5	608	2958	0.205544286680189	0.150625713267314	0.151989858300543	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	14406195892.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-25T14:42:01.576369Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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