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

8d56d2ff-c688-44f6-8129-8fda773dc037	2026-09-10 14:44	2026-09-10 14:43	2026-09-10 14:43	XOP	XOP260918C00185000	call	185.0000	2026-09-18	12.5000	11.8500	12.5000	196.4500	25000.00	25000.00	0.00	20	8	20	948	0.0210970464135021	0.400754814580694	0.400754814580694	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4238179533.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-10T19:03:59.290358Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
05108d42-273d-4f9a-8ffa-6524bda5bb75	2026-09-10 14:37	2026-09-10 14:37	2026-09-10 14:37	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.4550	54000.00	0.00	54000.00	100	5	813	132	6.15909090909091	0.352675869592309	0.352675869592309	false	false	false	true
d64253f6-904d-4004-93bb-8194094e8b89	2026-09-10 14:33	2026-09-10 14:33	2026-09-10 14:33	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.5000	196.4600	54540.00	0.00	54540.00	101	6	425	132	3.21969696969697	0.352752097938454	0.352752097938454	false	false	false	true
a4a0f7b3-3c82-4be2-85b1-60916323d0b7	2026-09-10 14:32	2026-09-10 14:32	2026-09-10 14:32	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.1500	5.4500	196.4950	11880.00	2700.00	1620.00	22	10	281	132	2.12878787878788	0.353285400437013	0.353285400437013	false	false	false	true
49337207-5441-43ca-9284-cb751176ac08	2026-09-10 14:32	2026-09-10 14:31	2026-09-10 14:31	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.1500	5.4000	196.4650	13500.00	13500.00	0.00	25	10	237	132	1.79545454545455	0.352828315704932	0.352828315704932	false	false	false	true
786fd77d-c33a-420b-8120-95ef7892af4c	2026-09-10 14:31	2026-09-10 14:31	2026-09-10 14:31	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.1500	5.4000	196.4650	13500.00	13500.00	0.00	25	6	212	132	1.60606060606061	0.352828315704932	0.352828315704932	false	false	false	true
796785aa-1332-4baa-8621-e8b70721005f	2026-09-10 13:16	2026-09-10 13:16	2026-09-10 13:16	XOP	XOP260918C00194000	call	194.0000	2026-09-18	5.8500	5.8500	5.9500	197.0800	18720.00	0.00	18720.00	32	7	80	2638	0.0303260045489007	0.348524435216949	0.348524435216949	true	false	false	true
864c1661-8c83-462c-b36b-24a671885691	2026-09-10 12:06	2026-09-10 12:06	2026-09-10 12:06	XOP	XOP270319P00195000	put	195.0000	2027-03-19	16.9500	16.5500	16.9500	196.5200	15255.00	15255.00	0.00	9	7	63	254	0.248031496062992	0.35388616320857	0.35388616320857	false	false	false	true
69e9b0b5-b0e0-4603-ad1f-4ac256cee281	2026-09-10 11:48	2026-09-10 11:48	2026-09-10 11:48	XOP	XOP260911P00194000	put	194.0000	2026-09-11	0.7300	0.7300	0.8200	196.4600	41756.00	0.00	41756.00	572	19	574	62	9.25806451612903	0.414136425052663	0.414136425052663	false	false	false	true
55d2cb38-6cf3-4cd8-bfe3-d51e849017d3	2026-09-10 11:35	2026-09-10 11:35	2026-09-10 11:35	XOP	XOP270319P00200000	put	200.0000	2027-03-19	19.9000	19.6000	20.5000	195.9700	11940.00	7960.00	3980.00	6	5	88	150	0.586666666666667	0.356355012916687	0.356355012916687	false	false	false	true
9c427c59-888d-4dae-89da-1c34a5149a0c	2026-09-10 11:09	2026-09-10 11:09	2026-09-10 11:09	XOP	XOP261016P00185000	put	185.0000	2026-10-16	3.8500	3.6500	3.8500	195.0300	86240.00	86240.00	0.00	224	5	232	2571	0.0902372617658499	0.341821518172391	0.341821518172391	false	false	false	true
65bcacc7-fc45-45e8-84f7-ebea5c611c9c	2026-09-10 09:42	2026-09-10 09:42	2026-09-10 09:42	XOP	XOP270319C00210000	call	210.0000	2027-03-19	13.6000	13.6000	14.8500	196.3400	48960.00	0.00	48960.00	36	13	36	74	0.486486486486487	0.308528083535787	0.308528083535787	false	false	false	true
9af60694-4a08-46d7-9ddf-2f53a56f67b9	2026-09-09 15:49	2026-09-09 15:49	2026-09-09 15:49	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.5900	2.3400	2.6600	195.1600	161875.00	89096.00	29008.00	625	35	5002	22	227.363636363636	0.347750388841124	0.347750388841124	false	false	false	true
ad6672f1-da59-4dc1-a8d8-9037b92c9332	2026-09-09 15:31	2026-09-09 15:31	2026-09-09 15:31	XOP	XOP270319P00200000	put	200.0000	2027-03-19	20.0000	19.7000	20.0500	194.9900	36000.00	36000.00	0.00	18	8	121	30	4.03333333333333	0.342987360545851	0.342987360545851	false	false	false	true
c8f5b0ba-035f-4910-9df4-5f8f3dab74b0	2026-09-09 15:14	2026-09-09 15:14	2026-09-09 15:14	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.5900	2.5200	2.5900	195.0500	15022.00	15022.00	0.00	58	5	2437	22	110.772727272727	0.346926883062108	0.346926883062108	false	false	false	true
bcc8bc8f-4a8e-4293-85a2-7fc562fc94e0	2026-09-09 15:11	2026-09-09 15:11	2026-09-09 15:11	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.5500	2.3500	2.5800	195.0900	25500.00	4335.00	21165.00	100	14	1982	22	90.0909090909091	0.345274517992913	0.345274517992913	false	false	false	true
1574e6b2-2b1f-463e-90e4-9c5421f95a24	2026-09-09 15:09	2026-09-09 15:09	2026-09-09 15:09	XOP	XOP270319P00200000	put	200.0000	2027-03-19	19.9000	19.6500	20.2000	194.9950	59700.00	57710.00	1990.00	30	14	68	30	2.26666666666667	0.341243327959834	0.341243327959834	false	false	false	true
38329b89-8b56-4224-a038-420274a7117f	2026-09-09 15:04	2026-09-09 15:04	2026-09-09 15:04	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.5800	2.4700	2.5800	194.8300	101652.00	101652.00	0.00	394	14	1571	22	71.4090909090909	0.344790567212284	0.344790567212284	false	false	false	true
8a47440f-b15e-4431-86bf-f41069111cac	2026-09-09 15:04	2026-09-09 15:04	2026-09-09 15:04	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.5800	2.4000	2.6000	194.8600	78432.00	36378.00	21930.00	304	6	1177	22	53.5	0.345015762650641	0.345015762650641	true	false	false	true
b4d87d6d-75bd-4d4e-8a0f-9da563f35137	2026-09-09 15:04	2026-09-09 15:04	2026-09-09 15:04	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.5600	2.4400	2.5600	194.8600	50176.00	12544.00	0.00	196	5	812	22	36.9090909090909	0.344041986762784	0.344041986762784	false	false	false	true
43ddd808-f5ae-4aa0-8520-962f135af072	2026-09-09 15:04	2026-09-09 15:04	2026-09-09 15:04	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.5500	2.5500	2.5600	194.8600	85425.00	0.00	85425.00	335	6	616	22	28	0.343554183460323	0.343554183460323	false	false	false	true
cf81a2fb-8bdd-4b4b-a77b-c1aae510f543	2026-09-09 15:04	2026-09-09 15:04	2026-09-09 15:04	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.5600	2.4100	2.6300	194.8750	71680.00	768.00	42240.00	280	8	281	22	12.7727272727273	0.344154408507716	0.344154408507716	false	false	false	true
4184c5bc-8186-4d66-8333-09599f60229f	2026-09-09 12:35	2026-09-09 12:35	2026-09-09 12:35	XOP	XOP261016P00195000	put	195.0000	2026-10-16	8.4000	7.7000	8.5000	194.3400	19320.00	17640.00	1680.00	23	10	27	28	0.964285714285714	0.342811962445069	0.342811962445069	false	false	false	true
e52e6d8c-0c35-436b-88bf-b32d0aca5f4b	2026-09-09 10:01	2026-09-09 10:01	2026-09-09 10:01	XOP	XOP261218C00210000	call	210.0000	2026-12-18	7.7500	7.5000	7.7500	194.5000	37200.00	37200.00	0.00	48	23	48	254	0.188976377952756	0.317736391774568	0.317736391774568	false	false	false	true
7b2f9533-9b3d-46c2-b6e5-de6001fd12da	2026-09-08 15:43	2026-09-08 15:43	2026-09-08 15:43	XOP	XOP270115C00250000	call	250.0000	2027-01-15	2.2000	1.9800	2.2300	194.3600	110880.00	110880.00	0.00	504	7	524	205	2.55609756097561	0.324071726207438	0.324071726207438	false	false	false	true
0a2772b7-680a-4eef-899f-c517ed52ea7e	2026-09-08 14:52	2026-09-08 14:52	2026-09-08 14:52	XOP	XOP260918C00196000	call	196.0000	2026-09-18	3.8000	3.4000	3.9000	195.0500	29265.00	15205.00	13680.00	77	11	310	406	0.763546798029557	0.322612581584818	0.326498428950087	true	false	false	true
4396dca9-57ce-4391-85f6-bec11307fa50	2026-09-08 14:47	2026-09-08 14:47	2026-09-08 14:47	XOP	XOP261016P00180000	put	180.0000	2026-10-16	2.7000	2.6400	2.7400	194.3400	191160.00	25920.00	165240.00	708	5	2478	764	3.2434554973822	0.337242854749785	0.337242854749785	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
d582f450-a48a-4977-9cb4-81494657fe60	2026-09-08 13:51	2026-09-08 13:51	2026-09-08 13:51	XOP	XOP261218C00195000	call	195.0000	2026-12-18	13.1500	12.8000	13.1500	193.7500	94680.00	94680.00	0.00	72	13	77	441	0.174603174603175	0.313345980768194	0.313345980768194	false	false	false	true
e8fc4d2f-c5a0-40f4-bbb6-78ab749a4403	2026-09-08 13:36	2026-09-08 13:35	2026-09-08 13:35	XOP	XOP261218P00177000	put	177.0000	2026-12-18	5.8000	5.6000	6.0500	193.3400	23200.00	22620.00	580.00	40	7	42	345	0.121739130434783	0.335470936581292	0.335470936581292	false	false	false	true
e4f73da0-89ef-4325-91ef-de73baefdbf1	2026-09-08 13:05	2026-09-08 13:05	2026-09-08 13:05	XOP	XOP260918P00191000	put	191.0000	2026-09-18	3.1000	2.8500	3.1500	192.9101	66025.00	65410.00	305.00	213	40	215	4	53.75	0.322250104125065	0.317068884867783	false	false	false	true
141b7535-fe03-4d45-a9c8-f80e76a2e4e2	2026-09-08 12:40	2026-09-08 12:40	2026-09-08 12:40	XOP	XOP261218P00200000	put	200.0000	2026-12-18	16.3000	16.1000	16.3000	193.3600	22820.00	22820.00	0.00	14	6	158	12	13.1666666666667	0.340806409235709	0.340806409235709	false	false	false	true
7607dde3-e3e4-4997-81b1-d0bd985de52b	2026-09-08 12:37	2026-09-08 12:37	2026-09-08 12:37	XOP	XOP260918P00194000	put	194.0000	2026-09-18	4.2500	4.0000	4.2500	193.5250	58225.00	58225.00	0.00	137	32	290	5	58	0.321563749100744	0.321563749100744	false	false	false	true
b65f16c9-dab0-421f-b060-1ae91e790d0a	2026-09-08 12:18	2026-09-08 12:18	2026-09-08 12:18	XOP	XOP261218C00235000	call	235.0000	2026-12-18	2.6600	2.5300	3.0500	193.9850	10640.00	10374.00	266.00	40	8	40	127	0.31496062992126	0.323309815360249	0.323309815360249	false	false	false	true
b6d66b83-0e3b-4ad2-af50-e1b673e28aba	2026-09-08 11:41	2026-09-08 11:41	2026-09-08 11:41	XOP	XOP261218P00200000	put	200.0000	2026-12-18	15.9500	15.5500	15.9500	194.1600	207350.00	207350.00	0.00	130	35	144	12	12	0.342232835090041	0.342232835090041	false	false	false	true
c2c3a8b9-dcd3-48db-bb7e-4434bddfd4c7	2026-09-08 11:40	2026-09-08 11:40	2026-09-08 11:40	XOP	XOP261218P00200000	put	200.0000	2026-12-18	15.6800	15.5500	16.1500	194.1300	21955.00	10965.00	10990.00	14	5	14	12	1.16666666666667	0.335723311289043	0.334495804600019	false	false	false	true
3145bb23-f5ac-4866-bcdd-cdcf25badf79	2026-09-08 11:26	2026-09-08 11:26	2026-09-08 11:26	XOP	XOP261016P00193000	put	193.0000	2026-10-16	7.1000	6.2000	7.2000	194.6400	18460.00	16330.00	0.00	26	15	26	0	0	0.331686979991839	0.331686979991839	true	false	false	true
5edb719d-f0bc-418b-836c-0c5bea51a81e	2026-09-08 11:15	2026-09-08 11:15	2026-09-08 11:15	XOP	XOP260918P00192500	put	192.5000	2026-09-18	2.8800	2.5800	2.8800	194.8600	125568.00	125568.00	0.00	436	47	436	52	8.38461538461539	0.315405188444772	0.315405188444772	false	false	false	true
ff526ab2-4c56-471c-b5f4-f188564c74a1	2026-09-08 10:50	2026-09-08 10:50	2026-09-08 10:50	XOP	XOP270115C00200000	call	200.0000	2027-01-15	12.7500	12.6500	13.3000	194.7100	63750.00	0.00	63750.00	50	18	69	1960	0.0352040816326531	0.300837665022555	0.300837665022555	false	false	false	true
18032efd-d763-4a77-bce4-a2fbf2c15ce8	2026-09-08 10:06	2026-09-08 10:06	2026-09-08 10:06	XOP	XOP270115P00190000	put	190.0000	2027-01-15	11.5000	11.4000	11.5000	195.3400	57500.00	1150.00	0.00	50	18	51	328	0.155487804878049	0.334724531386659	0.334724531386659	false	false	false	true
1a208741-85c9-4dc0-bdb3-4280a85de542	2026-09-08 09:42	2026-09-08 09:41	2026-09-08 09:41	XOP	XOP261016C00195000	call	195.0000	2026-10-16	7.9000	6.7500	8.5500	194.8650	158000.00	118500.00	39500.00	200	6	200	153	1.30718954248366	0.302336181697868	0.302336181697868	false	false	false	true
f4c1e4e6-6816-465b-bbb2-f46d1494484b	2026-09-08 09:40	2026-09-08 09:40	2026-09-08 09:40	XOP	XOP270115C00200000	call	200.0000	2027-01-15	13.0000	13.0000	13.5000	195.0300	11700.00	0.00	11700.00	9	5	10	1960	0.00510204081632653	0.302721253028822	0.302721253028822	false	false	false	true
67b49f83-7c5c-42be-82e9-918a4d922db5	2026-09-04 12:27	2026-09-04 12:27	2026-09-04 12:27	XOP	XOP270319C00190000	call	190.0000	2027-03-19	19.0300	18.6500	19.7000	190.7700	13320.00	1890.00	11430.00	7	7	76	147	0.517006802721088	0.305205416811907	0.302453138587016	true	false	false	true
ac4c17b0-9ea7-49a2-87ca-c70edd9e4744	2026-09-04 09:48	2026-09-04 09:48	2026-09-04 09:48	XOP	XOP260918C00196000	call	196.0000	2026-09-18	1.6800	1.4900	1.6800	189.0950	43680.00	43680.00	0.00	260	12	260	147	1.7687074829932	0.2782539975571	0.2782539975571	true	false	false	true
0225be9d-9fb4-403e-84e1-bbf14082a64e	2026-09-03 15:47	2026-09-03 15:47	2026-09-03 15:47	XOP	XOP260918C00198000	call	198.0000	2026-09-18	2.2900	2.2900	2.9200	192.2800	164492.00	16100.00	148392.00	718	49	720	695	1.03597122302158	0.284476735023113	0.284476735023113	false	false	false	true
8bc51c44-fdfb-430f-ad8d-fe6ace796b61	2026-09-03 15:35	2026-09-03 15:35	2026-09-03 15:35	XOP	XOP260911C00207500	call	207.5000	2026-09-11	0.2400	0.2200	0.2500	192.2050	10848.00	10320.00	528.00	452	9	3225	2	1612.5	0.325793892695596	0.325793892695596	true	false	false	true
729d7cb7-f550-40cc-8a1e-c60f64532fd2	2026-09-03 15:20	2026-09-03 15:20	2026-09-03 15:20	XOP	XOP260911C00207500	call	207.5000	2026-09-11	0.2500	0.2200	0.2700	192.5200	11975.00	10400.00	1050.00	479	16	2752	2	1376	0.323038298709491	0.323038298709491	true	false	false	true
fe303ee4-6f65-45aa-8c81-8ea8823657e7	2026-09-03 15:19	2026-09-03 15:19	2026-09-03 15:19	XOP	XOP260911C00207500	call	207.5000	2026-09-11	0.2600	0.1900	0.2600	192.5450	26000.00	25376.00	0.00	1000	15	2003	2	1001.5	0.325374114625788	0.325374114625788	true	false	false	true
e24b2f6e-12f8-4fa3-9b77-0bd0f753bdce	2026-09-03 14:15	2026-09-03 14:15	2026-09-03 14:15	XOP	XOP270319P00172000	put	172.0000	2027-03-19	8.2000	7.9000	8.2500	192.6300	11485.00	10670.00	815.00	14	7	162	3	54	0.338406306601493	0.339514459550291	false	false	false	true
58c771e2-687d-47ce-b7f0-84f10c5fe69a	2026-09-03 13:37	2026-09-03 13:37	2026-09-03 13:37	XOP	XOP260904C00195000	call	195.0000	2026-09-04	0.5000	0.5000	0.6300	192.4500	30250.00	0.00	30250.00	605	9	777	297	2.61616161616162	0.351230280560532	0.351230280560532	false	false	false	true