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 = 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	price

6fee5646-a1ea-4600-a1fd-2b84bb0d918d	2026-08-26 14:07	2026-08-26 14:07	2026-08-26 14:07	XOP	XOP260828C00195000	call	195.0000	2026-08-28	0.0900	0.0900	0.1600	185.1400	14706.00	0.00	14706.00	1634	28	3772	1482	2.54520917678812	0.398336445864217	0.398336445864217	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-26T18:39:51.047298Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bf02c0df-7b9d-48c1-8a25-5b37f2b3aee6	2026-08-26 12:48	2026-08-26 12:48	2026-08-26 12:48	XOP	XOP260828C00195000	call	195.0000	2026-08-28	0.1200	0.1000	0.1900	185.7000	14088.00	204.00	13884.00	1174	27	2116	1482	1.42780026990553	0.401289779884479	0.401289779884479	false	false	false	true	false
41337e53-faa6-43e9-9466-a00606287bf9	2026-08-26 12:26	2026-08-26 12:26	2026-08-26 12:26	XOP	XOP260828C00195000	call	195.0000	2026-08-28	0.1300	0.1300	0.1900	186.1800	11076.00	0.00	11076.00	852	53	941	1482	0.634952766531714	0.390631517832185	0.390631517832185	false	false	false	true	false
805a4b5d-cb9d-40d1-b1f7-1f0883e93ade	2026-08-26 12:15	2026-08-26 12:15	2026-08-26 12:15	XOP	XOP270115C00200000	call	200.0000	2027-01-15	9.8000	9.4500	9.8500	186.0300	38215.00	8820.00	29395.00	39	5	43	1670	0.025748502994012	0.307285862191391	0.307285862191391	false	false	false	true	false
daec872e-832d-47cd-bb1a-524c47a2c907	2026-08-26 12:04	2026-08-26 12:03	2026-08-26 12:03	XOP	XOP260904C00189000	call	189.0000	2026-09-04	2.5700	2.5700	2.6900	185.8400	73502.00	0.00	73502.00	286	12	286	5	57.2	0.330721731350753	0.330721731350753	false	false	false	true	false
f328c1f4-8a1a-415f-a84b-f44c006315a2	2026-08-26 11:55	2026-08-26 11:55	2026-08-26 11:55	XOP	XOP260904C00187000	call	187.0000	2026-09-04	3.1500	2.1500	3.1500	185.0100	21085.00	21085.00	0.00	67	18	67	3	22.3333333333333	0.342813253896601	0.338446471905418	false	false	false	true	false
6396ef62-55c0-4d1b-92b5-b7b7861bf29e	2026-08-26 11:42	2026-08-26 11:42	2026-08-26 11:42	XOP	XOP260828P00179000	put	179.0000	2026-08-28	0.4200	0.4200	0.5300	184.2250	21882.00	0.00	21882.00	521	38	544	585	0.92991452991453	0.385801777872419	0.385801777872419	false	false	false	true	false
dfebec75-9a58-414c-96bf-96283a2ee9d3	2026-08-25 15:58	2026-08-25 15:58	2026-08-25 15:58	XOP	XOP260904P00176000	put	176.0000	2026-09-04	1.6900	1.0900	1.6900	182.9800	128824.00	128824.00	0.00	763	23	2633	64	41.140625	0.364699357426114	0.365749979058343	true	false	false	true	false
7bef139f-74c0-4771-a315-d0e9cbfb290d	2026-08-25 15:58	2026-08-25 15:58	2026-08-25 15:58	XOP	XOP260918P00180000	put	180.0000	2026-09-18	4.5000	3.9500	4.5000	183.1600	326700.00	326700.00	0.00	726	43	797	8188	0.0973375671714704	0.330303089327295	0.330845346695872	false	false	false	true	false
816c902a-9321-447e-a0db-aae3ae686aac	2026-08-25 15:58	2026-08-25 15:58	2026-08-25 15:58	XOP	XOP260918P00182500	put	182.5000	2026-09-18	5.6000	5.6000	5.6500	183.0200	29680.00	0.00	29680.00	53	19	78	0	0	0.325417272947245	0.325417272947245	true	false	false	true	false
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
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	false
e3ea71a4-c4e1-43ad-9eeb-127b1447769e	2026-08-25 15:57	2026-08-25 15:57	2026-08-25 15:57	XOP	XOP260904P00175000	put	175.0000	2026-09-04	1.3500	1.1500	1.4700	183.1600	674788.00	106885.00	33978.00	5007	37	6088	34	179.058823529412	0.363214403354591	0.356313093298098	true	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
a1e9f07f-ea85-4851-9d0e-133c79e0a57d	2026-08-25 11:47	2026-08-25 11:47	2026-08-25 11:47	XOP	XOP260904P00176000	put	176.0000	2026-09-04	1.4800	0.9200	1.6000	183.4900	103250.00	103250.00	0.00	700	9	700	64	10.9375	0.35609640512453	0.361558740813079	false	false	false	true	false
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	false
0dacc968-c899-4756-bf11-5be311674789	2026-08-25 11:47	2026-08-25 11:47	2026-08-25 11:47	XOP	XOP260925C00183000	call	183.0000	2026-09-25	7.0200	6.4500	8.3000	183.5050	153700.00	82290.00	71410.00	219	12	219	0	0	0.302753227300535	0.30511149764662	true	false	false	true	false
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	false
9224a854-f7c3-45b3-a1f6-733f45724221	2026-08-25 11:43	2026-08-25 11:43	2026-08-25 11:43	XOP	XOP260904P00183000	put	183.0000	2026-09-04	3.8500	3.0000	3.8500	183.4000	43868.00	43868.00	0.00	114	17	116	0	0	0.342305091687459	0.342305091687459	true	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
9ff895e0-4148-434b-ae5d-05c79f609de1	2026-08-24 11:06	2026-08-24 11:06	2026-08-24 11:06	XOP	XOP261016P00188000	put	188.0000	2026-10-16	10.2900	9.3000	10.3000	185.7200	14405.00	12355.00	2050.00	14	6	28	0	0	0.339635537378255	0.341406659766184	false	false	false	true	false
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	false
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	false
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	false
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
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
25cd678f-d1f1-41e0-a7d4-a1e2668ff2ef	2026-08-21 12:33	2026-08-21 12:33	2026-08-21 12:33	XOP	XOP260918P00180000	put	180.0000	2026-09-18	2.7200	2.6800	2.7700	189.7900	21511.00	10671.00	10840.00	79	5	459	7468	0.0614622388859132	0.325155397628759	0.325750234387379	false	false	false	true	false