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:alert_rule = RepeatedHits×ticker = XOP×

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

c8aa2410-7210-4d11-9bae-3b5ea2b1a8e4	2026-08-25 15:58	2026-08-25 15:57	2026-08-25 15:57	XOP	XOP260828P00179000	put	179.0000	2026-08-28	0.9600	0.9500	0.9600	183.0500	12960.00	12960.00	0.00	135	33	703	4	175.75	0.380925515314597	0.380925515314597	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-26T13:31:08.388238Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
9105dea6-131c-4a8c-9c83-ddaa7c1871d2	2026-08-25 15:57	2026-08-25 15:57	2026-08-25 15:57	XOP	XOP260904P00175000	put	175.0000	2026-09-04	1.4000	1.4000	2.0000	183.1150	35140.00	0.00	35140.00	251	5	6339	34	186.441176470588	0.367815775195749	0.367815775195749	true	false	false	true
7c9e0615-7ce3-4c19-81f5-9f5cd287c6b9	2026-08-25 15:44	2026-08-25 15:44	2026-08-25 15:44	XOP	XOP261016C00196000	call	196.0000	2026-10-16	4.3000	4.3000	4.3500	183.5100	187050.00	0.00	187050.00	435	17	455	0	0	0.311517139704899	0.311517139704899	false	false	false	true
165de746-d75a-4ac6-b209-12cbcdfa6657	2026-08-25 15:30	2026-08-25 15:30	2026-08-25 15:30	XOP	XOP260904P00188000	put	188.0000	2026-09-04	6.3500	6.0000	6.3500	183.8000	52705.00	52705.00	0.00	83	9	84	4	21	0.328953271733202	0.328953271733202	true	false	false	true
8c6e8b63-034e-4b7f-82fc-385c41d27e8e	2026-08-25 14:57	2026-08-25 14:57	2026-08-25 14:57	XOP	XOP270319C00185000	call	185.0000	2027-03-19	17.9500	17.7000	17.9500	183.8500	25130.00	25130.00	0.00	14	7	19	65	0.292307692307692	0.300661918156954	0.300661918156954	false	false	false	true
28f90534-de7e-451c-8ed2-5cb39cfe8811	2026-08-25 13:48	2026-08-25 13:48	2026-08-25 13:48	XOP	XOP260904P00175000	put	175.0000	2026-09-04	1.1000	1.1000	1.2900	184.0500	102080.00	0.00	102080.00	928	17	930	34	27.3529411764706	0.354242026722705	0.354242026722705	false	false	false	true
0d02bf48-2983-432b-8335-b86474eba01d	2026-08-25 13:07	2026-08-25 13:06	2026-08-25 13:06	XOP	XOP260925C00183000	call	183.0000	2026-09-25	7.4500	6.8500	7.4500	184.1400	19370.00	19370.00	0.00	26	13	247	0	0	0.307443525214486	0.307443525214486	false	false	false	true
317731de-5066-42a6-b12e-6abb898fe35c	2026-08-25 13:06	2026-08-25 13:06	2026-08-25 13:06	XOP	XOP260828C00195000	call	195.0000	2026-08-28	0.2000	0.2000	0.3500	184.0450	27600.00	0.00	27600.00	1380	22	1409	117	12.042735042735	0.41703951361063	0.41703951361063	false	false	false	true
24a93d4d-ffa5-49ae-8e2d-a468d22db859	2026-08-25 12:45	2026-08-25 12:45	2026-08-25 12:45	XOP	XOP261016C00185000	call	185.0000	2026-10-16	8.7000	8.4000	8.7500	184.0700	174000.00	130500.00	43500.00	200	12	315	212	1.48584905660377	0.312882274754268	0.312882274754268	false	false	false	true
6b900933-4ebe-4484-a592-4dd9f1821d4a	2026-08-25 11:57	2026-08-25 11:57	2026-08-25 11:57	XOP	XOP260828P00175000	put	175.0000	2026-08-28	0.2500	0.2500	0.3300	184.0500	11000.00	0.00	11000.00	440	21	463	158	2.93037974683544	0.404418922822453	0.404418922822453	false	false	false	true
0f6dd2a8-1af9-4ec4-8854-af8163d77049	2026-08-25 11:57	2026-08-25 11:57	2026-08-25 11:57	XOP	XOP261016P00180000	put	180.0000	2026-10-16	6.9500	6.9000	7.1500	184.0200	52820.00	1390.00	51430.00	76	11	78	686	0.113702623906706	0.337999370781776	0.337999370781776	true	false	false	true
67e56841-ed1e-4d5a-a192-6869a90d7af4	2026-08-25 11:47	2026-08-25 11:47	2026-08-25 11:47	XOP	XOP261218C00185000	call	185.0000	2026-12-18	13.1500	12.6500	13.2000	183.5050	78900.00	1315.00	77585.00	60	11	71	295	0.240677966101695	0.311668414604611	0.311668414604611	false	false	false	true
c501734b-3b84-4740-9913-5209cf2c2a33	2026-08-25 11:43	2026-08-25 11:43	2026-08-25 11:43	XOP	XOP260925P00182000	put	182.0000	2026-09-25	6.2500	5.3500	6.4500	183.3794	16885.00	16250.00	635.00	27	12	27	0	0	0.339203658409264	0.343952951544613	false	false	false	true
bcb9f6be-2687-44d9-abc0-1c5e74da95d3	2026-08-25 11:08	2026-08-25 11:08	2026-08-25 11:08	XOP	XOP260918P00160000	put	160.0000	2026-09-18	0.4500	0.4500	0.5000	184.5400	10485.00	0.00	10485.00	233	12	310	2729	0.113594723341883	0.370938033837099	0.370938033837099	false	false	false	true
d68b2309-e91c-45da-b313-20cbe6b82610	2026-08-25 10:35	2026-08-25 10:34	2026-08-25 10:34	XOP	XOP261218C00170000	call	170.0000	2026-12-18	22.0000	20.8500	22.0000	183.9750	17600.00	17600.00	0.00	8	8	8	2203	0.00363141171130277	0.314088786751153	0.314088786751153	false	false	false	true
47888cb8-334a-43bd-bda8-cd001cf2cbb9	2026-08-24 15:19	2026-08-24 15:18	2026-08-24 15:18	XOP	XOP261016C00165000	call	165.0000	2026-10-16	23.4500	22.6000	23.4500	186.1900	133665.00	133665.00	0.00	57	14	96	512	0.1875	0.299745132453697	0.299745132453697	false	false	false	true
8e0dcd4a-4928-4e61-8e84-54241e3b2739	2026-08-24 14:36	2026-08-24 14:36	2026-08-24 14:36	XOP	XOP261016C00210000	call	210.0000	2026-10-16	2.1800	2.0700	2.4300	185.6300	108782.00	95702.00	13080.00	499	9	522	269	1.94052044609665	0.322691371180564	0.322691371180564	false	false	false	true
e8bbe06c-53e7-40fe-87e6-ba4d855b5b2c	2026-08-24 11:31	2026-08-24 11:31	2026-08-24 11:31	XOP	XOP260918P00184000	put	184.0000	2026-09-18	5.9000	5.1500	5.9000	184.3800	22420.00	22420.00	0.00	38	10	38	0	0	0.329160387691304	0.329160387691304	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
f481be92-57b5-4429-a2f6-6aeb0d383a5c	2026-08-24 11:15	2026-08-24 11:15	2026-08-24 11:15	XOP	XOP260918P00175000	put	175.0000	2026-09-18	2.2500	2.0500	2.3700	185.2300	180000.00	180000.00	0.00	800	8	831	1471	0.564921821889871	0.329106179591464	0.329106179591464	false	false	false	true
661e408a-05dc-4365-96c0-fb9dc4ae09a9	2026-08-24 11:06	2026-08-24 11:06	2026-08-24 11:06	XOP	XOP261016P00189000	put	189.0000	2026-10-16	10.8500	9.7500	11.0500	185.7200	30378.00	27123.00	3255.00	28	13	31	0	0	0.341358334017963	0.341358334017963	false	false	false	true
32e2823e-ef0f-4b0c-bb66-c37d009c9766	2026-08-24 11:03	2026-08-24 11:03	2026-08-24 11:03	XOP	XOP261016C00194000	call	194.0000	2026-10-16	5.9000	5.5000	5.9500	185.9650	72570.00	72570.00	0.00	123	6	123	0	0	0.311182594076539	0.311182594076539	false	false	false	true
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
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
b2e9ac85-b566-43da-bd16-7b479f733318	2026-08-24 10:46	2026-08-24 10:46	2026-08-24 10:46	XOP	XOP260911C00192500	call	192.5000	2026-09-11	2.8500	2.8400	3.6500	186.1850	11400.00	0.00	11400.00	40	7	43	4	10.75	0.31659063238596	0.31659063238596	false	false	false	true
663bf53b-77bc-4c55-9e09-f45a58ceff7b	2026-08-24 10:45	2026-08-24 10:45	2026-08-24 10:45	XOP	XOP260911C00171000	call	171.0000	2026-09-11	16.6500	16.6500	18.4000	186.6300	91575.00	0.00	91575.00	55	6	55	6	9.16666666666667	0.329287855371527	0.329287855371527	true	false	false	true
25d444f8-31bc-4cfa-a0a5-af8b0ec3edb0	2026-08-24 10:01	2026-08-24 10:00	2026-08-24 10:00	XOP	XOP260828C00182000	call	182.0000	2026-08-28	6.1000	6.1000	7.8000	187.0600	10980.00	0.00	10980.00	18	5	18	31	0.580645161290323	0.365856367620562	0.365856367620562	false	false	false	true
4c9b881a-8288-4b85-9bc7-4db8d28d5ebe	2026-08-24 09:52	2026-08-24 09:52	2026-08-24 09:52	XOP	XOP261218C00195000	call	195.0000	2026-12-18	10.9500	10.9500	11.2500	187.7300	367920.00	0.00	367920.00	336	40	336	103	3.2621359223301	0.310029869556764	0.310029869556764	false	false	false	true
23495ec4-b316-4568-bddf-613e6ca31d91	2026-08-24 09:49	2026-08-24 09:48	2026-08-24 09:48	XOP	XOP261016C00199000	call	199.0000	2026-10-16	5.1000	5.1000	5.8000	188.3200	49478.00	0.00	49478.00	97	11	101	0	0	0.310247545918771	0.310247545918771	false	false	false	true
a76a86bb-ac3d-426f-b25d-639d10a87592	2026-08-24 09:46	2026-08-24 09:46	2026-08-24 09:46	XOP	XOP260918C00192500	call	192.5000	2026-09-18	4.7500	4.7000	5.0000	188.5300	17575.00	0.00	17575.00	37	12	39	0	0	0.318959704671012	0.318959704671012	true	false	false	true
ad14f6c7-28f0-4587-a7a1-e62f6ecf4cdb	2026-08-21 14:31	2026-08-21 14:31	2026-08-21 14:31	XOP	XOP260904C00205000	call	205.0000	2026-09-04	0.7700	0.6100	0.7700	189.7400	46200.00	44506.00	0.00	600	24	1201	6	200.166666666667	0.332224879210482	0.332224879210482	true	false	false	true
b8dd3aa6-b987-45bf-800d-ed73068ccaba	2026-08-21 13:55	2026-08-21 13:54	2026-08-21 13:54	XOP	XOP261016C00180000	call	180.0000	2026-10-16	14.9500	14.9000	15.2000	189.4150	816275.00	1500.00	814775.00	546	7	552	1813	0.304467733039162	0.304055061788833	0.306004369346584	false	false	false	true
6111f6dd-d9f2-4ee1-a2e4-7d039d93348e	2026-08-21 12:44	2026-08-21 12:44	2026-08-21 12:44	XOP	XOP260918C00220000	call	220.0000	2026-09-18	0.5800	0.5800	0.6900	190.2900	50634.00	0.00	50634.00	873	53	1200	4200	0.285714285714286	0.343949879941552	0.343949879941552	false	false	false	true
1ff16f72-6473-4b31-97b8-7a78641f0487	2026-08-21 12:42	2026-08-21 12:42	2026-08-21 12:42	XOP	XOP260918P00195000	put	195.0000	2026-09-18	9.0000	9.0000	9.5000	190.5050	14400.00	0.00	14400.00	16	5	16	86	0.186046511627907	0.32259737929005	0.32259737929005	true	false	false	true
63d80976-3deb-4f4d-b6ef-069d7d327a93	2026-08-21 11:54	2026-08-21 11:53	2026-08-21 11:53	XOP	XOP260925C00192500	call	192.5000	2026-09-25	6.1000	5.0500	6.1000	189.2850	12200.00	12200.00	0.00	20	7	20	0	0	0.309789996892319	0.309789996892319	true	false	false	true
4571c23a-fce5-42d8-81b8-a396ce1cf0a8	2026-08-21 11:53	2026-08-21 11:53	2026-08-21 11:53	XOP	XOP260925C00190000	call	190.0000	2026-09-25	7.1500	5.6000	7.1500	189.2850	32890.00	32890.00	0.00	46	19	46	3	15.3333333333333	0.306412385906663	0.306412385906663	true	false	false	true
1eb4240e-7d73-4332-a9be-e01d7cb4f546	2026-08-21 11:35	2026-08-21 11:35	2026-08-21 11:35	XOP	XOP260918P00190000	put	190.0000	2026-09-18	6.9000	6.9000	7.3500	189.0000	15180.00	0.00	15180.00	22	7	87	362	0.240331491712707	0.319315361202107	0.319315361202107	false	false	false	true
6aaca9da-7d36-4c68-99eb-265bcec6bc28	2026-08-21 11:07	2026-08-21 11:07	2026-08-21 11:07	XOP	XOP260828C00186000	call	186.0000	2026-08-28	4.3000	4.3000	5.3000	187.9500	53750.00	0.00	53750.00	125	9	125	14	8.92857142857143	0.304876581866265	0.304876581866265	true	false	false	true
1de4a030-27d9-497e-adff-29903c8d8794	2026-08-21 10:49	2026-08-21 10:49	2026-08-21 10:49	XOP	XOP260904C00205000	call	205.0000	2026-09-04	0.7500	0.6000	1.0900	188.4200	18225.00	0.00	18225.00	243	9	243	6	40.5	0.351218015118942	0.351218015118942	true	false	false	true
c0ee756f-800f-4e50-b4a7-a4ec08d0db8d	2026-08-21 10:38	2026-08-21 10:38	2026-08-21 10:38	XOP	XOP260918C00220000	call	220.0000	2026-09-18	0.5500	0.5500	0.7500	188.4300	11660.00	0.00	11660.00	212	10	212	4200	0.0504761904761905	0.358359772744995	0.358359772744995	false	false	false	true
8f28b1f9-e306-4dc7-b787-5125e34ac23d	2026-08-21 10:19	2026-08-21 10:18	2026-08-21 10:18	XOP	XOP260904P00170000	put	170.0000	2026-09-04	0.4000	0.2100	0.6400	188.4800	11203.00	43.00	11160.00	280	27	280	20016	0.0139888089528377	0.363653579116614	0.369862064603738	true	false	false	true
5e22857d-7c72-4f90-a3d5-9f66dd3d11e5	2026-08-21 10:14	2026-08-21 10:14	2026-08-21 10:14	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.2000	3.0500	3.2500	188.5600	10880.00	2880.00	2240.00	34	6	94	7468	0.0125870380289234	0.334534341930651	0.334534341930651	true	false	false	true
49cc3017-7eac-488f-8826-e32b72962e75	2026-08-20 15:51	2026-08-20 15:51	2026-08-20 15:51	XOP	XOP260925C00188000	call	188.0000	2026-09-25	7.4000	6.6000	7.5500	187.5850	24415.00	23675.00	740.00	33	15	33	0	0	0.309009166439874	0.309009166439874	false	false	false	true
ef5dfb42-9bae-47bd-a1e5-b53d63a51faf	2026-08-20 15:20	2026-08-20 15:20	2026-08-20 15:20	XOP	XOP261016P00190000	put	190.0000	2026-10-16	11.1500	11.0500	11.1500	187.0900	15610.00	15610.00	0.00	14	11	25	86	0.290697674418605	0.345592046712974	0.345592046712974	false	false	false	true
4426fa61-9af1-4693-8a28-166ab6a5801f	2026-08-20 15:07	2026-08-20 15:07	2026-08-20 15:07	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.7500	3.6500	3.7500	186.8600	28125.00	28125.00	0.00	75	17	3341	4325	0.772485549132948	0.331303837736142	0.331303837736142	true	false	false	true
2b5534aa-a5ba-4022-bfae-1770509abfdc	2026-08-20 15:07	2026-08-20 15:07	2026-08-20 15:07	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.7500	3.6500	3.7500	186.8600	11625.00	11625.00	0.00	31	8	3266	4325	0.75514450867052	0.331303837736142	0.331303837736142	true	false	false	true
0cccde7a-418e-4c0a-ad3e-d99d8b26a536	2026-08-20 13:07	2026-08-20 13:07	2026-08-20 13:07	XOP	XOP270115P00195000	put	195.0000	2027-01-15	18.8000	18.8000	19.0500	187.8500	45120.00	0.00	45120.00	24	6	42	61	0.688524590163934	0.346758726456812	0.346758726456812	false	false	false	true
ff2ef096-edd5-4d51-a095-60d97e2cdddc	2026-08-20 13:01	2026-08-20 13:01	2026-08-20 13:01	XOP	XOP260828C00190000	call	190.0000	2026-08-28	2.5500	2.2700	3.1500	187.8500	63750.00	7395.00	3825.00	250	19	266	166	1.60240963855422	0.309834421672701	0.309834421672701	false	false	false	true
ec430de1-d6b0-4279-83b5-ee485b897e37	2026-08-20 12:33	2026-08-20 12:33	2026-08-20 12:33	XOP	XOP261218P00190000	put	190.0000	2026-12-18	13.8500	12.9500	13.8500	188.6500	18005.00	18005.00	0.00	13	6	13	19	0.684210526315789	0.33451903834917	0.33451903834917	false	false	false	true
c8ce11d8-bc1b-4af4-aebe-e9ecded873c2	2026-08-20 12:32	2026-08-20 12:32	2026-08-20 12:32	XOP	XOP261218P00195000	put	195.0000	2026-12-18	16.6500	15.6500	16.6500	188.7050	19980.00	19980.00	0.00	12	5	12	68	0.176470588235294	0.336727981629054	0.336727981629054	false	false	false	true