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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = XOP261016P00175000×source = uw_flow_alerts×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

088f7155-4098-424a-a93d-df9ed13a6501	2026-09-25 15:49	2026-09-25 15:49	2026-09-25 15:49	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.2000	2.9500	3.2000	181.0000	263360.00	263360.00	0.00	823	40	1857	20895	0.088872936109117	0.363099038021588	0.363099038021588	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4078763579.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:51:07.574812Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
b0752fdd-ab18-4ced-877e-e5d5b2cd3c77	2026-09-25 14:46	2026-09-25 14:45	2026-09-25 14:45	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.2500	3.2000	3.2500	180.0000	42250.00	42250.00	0.00	130	7	955	20895	0.0457047140464226	0.34356416369195	0.34356416369195	true	false	false	true
4fb2aea4-c434-43b2-93c2-9c968b7d5347	2026-09-25 14:46	2026-09-25 14:45	2026-09-25 14:45	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.3000	3.2000	3.3000	180.8100	41580.00	41580.00	0.00	126	6	805	20895	0.0385259631490787	0.346678956023086	0.346678956023086	true	false	false	true
21ed0e4e-775f-40db-bcd3-61abdcb956c1	2026-09-25 14:45	2026-09-25 14:45	2026-09-25 14:45	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.3500	3.2500	3.3500	180.8250	55275.00	55275.00	0.00	165	7	679	20895	0.0324958123953099	0.350203062873536	0.350203062873536	false	false	false	true
7e4fb1bb-4cc4-409a-9635-c00a02e75e9d	2026-09-25 14:45	2026-09-25 14:45	2026-09-25 14:45	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.4000	3.3500	3.4000	180.8400	35675.00	34000.00	1675.00	105	8	373	20895	0.0178511605647284	0.350514149613939	0.353723332968772	true	false	false	true
81da39c1-24e2-4b7b-838c-83368aa2e52f	2026-09-25 14:45	2026-09-25 14:45	2026-09-25 14:45	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.5000	3.3500	3.5000	180.6000	90650.00	90650.00	0.00	259	26	268	20895	0.0128260349365877	0.355097858992281	0.355097858992281	false	false	false	true
9930c48b-c72d-4b95-85de-c11034585a87	2026-09-23 15:58	2026-09-23 15:58	2026-09-23 15:58	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.9200	2.8000	2.9200	182.0000	17520.00	17520.00	0.00	60	8	868	1815	0.478236914600551	0.344030300606019	0.344030300606019	false	false	false	true
3062e2c7-e6cb-4ef5-9760-d9a3fb647ea8	2026-09-23 15:58	2026-09-23 15:57	2026-09-23 15:57	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.9000	2.8000	2.9000	182.0000	25810.00	25810.00	0.00	89	7	697	1815	0.384022038567493	0.342195340675976	0.342195340675976	false	false	false	true
0daa161a-a66d-46f3-a008-66d7e5819aeb	2026-09-23 15:57	2026-09-23 15:57	2026-09-23 15:57	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.9000	2.9000	3.2000	182.7200	174000.00	0.00	174000.00	600	34	608	1815	0.334986225895317	0.343108106904421	0.343108106904421	true	false	false	true
1f7aa41b-49e2-48b2-ab20-1c1bb792fbb5	2026-09-22 11:40	2026-09-22 11:40	2026-09-22 11:40	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.3500	2.3500	2.3800	184.9600	19505.00	0.00	19505.00	83	8	1104	881	1.25312145289444	0.338398838397876	0.338398838397876	false	false	false	true
9fe45179-5820-41a0-af89-0af54e943244	2026-09-22 11:38	2026-09-22 11:38	2026-09-22 11:38	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.3700	2.3700	2.4600	184.7100	18249.00	0.00	18249.00	77	7	778	881	0.883087400681044	0.335682986212381	0.335682986212381	true	false	false	true
d4229543-613e-4ce3-989e-32491429b7db	2026-09-22 11:36	2026-09-22 11:36	2026-09-22 11:36	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.3600	2.3600	2.4800	184.6600	32568.00	0.00	31152.00	138	16	617	881	0.700340522133939	0.334188621399541	0.334188621399541	false	false	false	true
c993ad62-ff28-4178-abe1-0e6aa773ec3e	2026-09-22 11:36	2026-09-22 11:36	2026-09-22 11:36	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.3300	2.3300	2.4800	184.6600	13048.00	0.00	13048.00	56	11	342	881	0.388195232690125	0.332156620242018	0.332156620242018	true	false	false	true
2cebf29f-abec-4472-8017-ce0c8bf9b9fe	2026-09-22 11:36	2026-09-22 11:36	2026-09-22 11:36	XOP	XOP261016P00175000	put	175.0000	2026-10-16	2.2900	2.2900	2.7800	184.6600	40305.00	0.00	40305.00	176	21	286	881	0.324631101021566	0.329438815663157	0.329438815663157	true	false	false	true
616173cf-cd19-472d-b036-e84ea2cf192a	2026-09-22 09:42	2026-09-22 09:42	2026-09-22 09:42	XOP	XOP261016P00175000	put	175.0000	2026-10-16	3.0000	2.8900	3.4500	182.6000	30000.00	4800.00	300.00	100	19	103	881	0.116912599318956	0.340370038375726	0.340370038375726	false	false	false	true
a9346ebd-1817-4a70-8902-e511608f4df3	2026-08-18 15:28	2026-08-18 15:28	2026-08-18 15:28	XOP	XOP261016P00175000	put	175.0000	2026-10-16	5.0500	5.0500	5.4000	184.8400	21715.00	0.00	21715.00	43	8	85	647	0.131375579598145	0.331588895427497	0.331588895427497	false	false	false	true