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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = XOP261218P00185000×ticker = XOP×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

0416835d-9742-4ddd-9229-2c42328ae92a	2026-08-24 10:49	2026-08-24 10:49	2026-08-24 10:49	XOP	XOP261218P00185000	put	185.0000	2026-12-18	12.2500	11.1500	12.2500	186.1500	72275.00	72275.00	0.00	59	24	59	87	0.67816091954023	0.335542860699488	0.335542860699488	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4170340047.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
77d59cbd-4548-4269-b13e-4afa3cb08731	2026-08-24 10:49	2026-08-24 10:49	2026-08-24 10:49	XOP	XOP261218P00185000	put	185.0000	2026-12-18	12.2500	11.1500	12.2500	186.1500	13475.00	13475.00	0.00	11	6	78	87	0.896551724137931	0.335542860699488	0.335542860699488	false	false	false	true
74e1853b-cd11-4ad1-a654-d062127c7f32	2026-08-24 11:29	2026-08-24 11:29	2026-08-24 11:29	XOP	XOP261218P00185000	put	185.0000	2026-12-18	12.9500	12.0500	12.9500	184.5900	15540.00	15540.00	0.00	12	5	90	87	1.03448275862069	0.336168355558613	0.336168355558613	false	false	false	true
3b322e95-2189-4570-a630-906432d8313d	2026-09-08 13:55	2026-09-08 13:54	2026-09-08 13:54	XOP	XOP261218P00185000	put	185.0000	2026-12-18	8.7000	8.6000	8.7500	193.5900	74810.00	74810.00	0.00	86	19	2601	249	10.4457831325301	0.338298987723675	0.338298987723675	false	false	false	true
a787ddad-29f5-467b-9e3f-e8252f14f6a1	2026-09-15 10:14	2026-09-15 10:14	2026-09-15 10:14	XOP	XOP261218P00185000	put	185.0000	2026-12-18	7.4500	7.2000	8.3500	197.8550	530440.00	528950.00	1490.00	712	23	712	2894	0.246026261230131	0.353395280646461	0.353395280646461	false	false	false	true
84370d24-c0f1-4b70-ba8c-2cf046217970	2026-09-15 11:38	2026-09-15 11:38	2026-09-15 11:38	XOP	XOP261218P00185000	put	185.0000	2026-12-18	7.4000	7.2000	7.4000	198.7400	36260.00	36260.00	0.00	49	6	762	2894	0.263303386316517	0.359503173238413	0.359503173238413	false	false	false	true
9fcc3950-45f1-4d49-a78c-1434390293dc	2026-09-15 11:50	2026-09-15 11:50	2026-09-15 11:50	XOP	XOP261218P00185000	put	185.0000	2026-12-18	7.3500	7.0500	7.3500	198.8300	13965.00	13965.00	0.00	19	6	781	2894	0.269868693849343	0.358822328368442	0.358822328368442	false	false	false	true
5acf2ec6-8ff9-414a-b21d-50b7039e3758	2026-09-15 13:02	2026-09-15 13:02	2026-09-15 13:02	XOP	XOP261218P00185000	put	185.0000	2026-12-18	7.2000	7.0000	7.2000	199.6150	111600.00	111600.00	0.00	155	32	936	2894	0.323427781617139	0.361050810057203	0.361050810057203	false	false	false	true
79465445-5466-4812-a5e6-f8f7a10e2ee8	2026-09-15 15:26	2026-09-15 15:26	2026-09-15 15:26	XOP	XOP261218P00185000	put	185.0000	2026-12-18	7.1500	6.6000	7.1500	199.2900	12870.00	12870.00	0.00	18	5	956	2894	0.330338631651693	0.356896041870266	0.356896041870266	false	false	false	true
e4c94933-e8cf-4c0a-b186-67d985d0e207	2026-09-16 14:02	2026-09-16 14:02	2026-09-16 14:02	XOP	XOP261218P00185000	put	185.0000	2026-12-18	8.7000	8.0000	8.7000	193.0000	20880.00	20880.00	0.00	24	7	83	3694	0.0224688684353005	0.350199203509679	0.350199203509679	false	false	false	true
c2afe9ab-12b2-4b8e-86b8-353deb2e3dfc	2026-09-16 14:20	2026-09-16 14:20	2026-09-16 14:20	XOP	XOP261218P00185000	put	185.0000	2026-12-18	8.7000	8.5000	8.7000	194.0000	126148.00	126148.00	0.00	145	39	228	3694	0.0617217108825122	0.355626710160038	0.355626710160038	false	false	false	true
93d9576b-7d43-4a5c-a595-9785a0c515a8	2026-09-16 14:36	2026-09-16 14:36	2026-09-16 14:36	XOP	XOP261218P00185000	put	185.0000	2026-12-18	8.7000	8.2500	8.7000	193.4600	60900.00	60900.00	0.00	70	19	299	3694	0.0809420682187331	0.350486440729464	0.350486440729464	true	false	false	true
5f4dac60-38d7-4e79-99fb-51ee709eb8da	2026-09-16 14:36	2026-09-16 14:36	2026-09-16 14:36	XOP	XOP261218P00185000	put	185.0000	2026-12-18	8.7000	8.5500	8.7000	193.2400	25230.00	25230.00	0.00	29	11	328	3694	0.0887926367081754	0.348375891305795	0.348375891305795	false	false	false	true
a947ff77-d6a9-4aca-8046-84fd8f734276	2026-09-16 14:49	2026-09-16 14:49	2026-09-16 14:49	XOP	XOP261218P00185000	put	185.0000	2026-12-18	8.7000	8.4500	8.7000	192.9700	18270.00	18270.00	0.00	21	6	352	3694	0.0952896589063346	0.345772421697628	0.345772421697628	true	false	false	true
71f41587-9c31-4529-81a0-f29d0301939d	2026-09-17 12:21	2026-09-17 12:20	2026-09-17 12:20	XOP	XOP261218P00185000	put	185.0000	2026-12-18	9.2500	8.7000	9.2500	191.8700	85100.00	85100.00	0.00	92	18	92	3715	0.024764468371467	0.352114437475304	0.352114437475304	false	false	false	true
dcfde9bf-1401-4079-a67d-8c8a620bb56f	2026-09-17 12:34	2026-09-17 12:34	2026-09-17 12:34	XOP	XOP261218P00185000	put	185.0000	2026-12-18	9.1000	8.9500	9.1000	192.1800	90090.00	90090.00	0.00	99	19	211	3715	0.0567967698519515	0.351044390230808	0.351044390230808	false	false	false	true
4d1cda48-e07f-4268-9e11-d96d1d6ca574	2026-09-21 12:13	2026-09-21 12:13	2026-09-21 12:13	XOP	XOP261218P00185000	put	185.0000	2026-12-18	11.4500	11.4000	11.6500	184.6150	53815.00	41220.00	12595.00	47	8	57	3746	0.0152162306460224	0.338032938794881	0.338032938794881	false	false	false	true
111a5e6e-5ab9-4d9e-a0a9-9bf04bb4be8b	2026-09-24 12:19	2026-09-24 12:19	2026-09-24 12:19	XOP	XOP261218P00185000	put	185.0000	2026-12-18	11.8500	11.8500	12.3500	183.4700	46215.00	0.00	46215.00	39	7	50	3782	0.0132205182443152	0.339874800187187	0.339874800187187	true	false	false	true