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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_flow_alerts×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

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	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-08T16:21:42.633253Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
b86ea243-146b-43f4-b283-d4f5e93b2cb2	2026-09-08 11:32	2026-09-08 11:31	2026-09-08 11:31	XOP	XOP260918P00194000	put	194.0000	2026-09-18	3.9000	3.5000	3.9000	194.2100	59260.00	59260.00	0.00	152	34	153	5	30.6	0.320267257255316	0.320267257255316	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	false
fc1b97b6-ef4b-4f64-a9f2-5e63fa7102a9	2026-09-08 11:22	2026-09-08 11:22	2026-09-08 11:22	XOP	XOP260918C00195000	call	195.0000	2026-09-18	4.0000	3.7500	4.0500	194.8399	252780.00	250780.00	2000.00	632	27	664	952	0.697478991596639	0.312491215109965	0.309320058891583	false	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
a2002265-2cc6-4173-948d-a4b51e770fde	2026-09-08 11:06	2026-09-08 11:05	2026-09-08 11:05	XOP	XOP260918C00196000	call	196.0000	2026-09-18	3.4500	3.1000	3.4500	194.4874	61050.00	61050.00	0.00	177	37	187	406	0.460591133004926	0.315974831685745	0.315974831685745	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
0cb07930-3a9c-43c3-af99-be00f626884a	2026-09-03 11:34	2026-09-03 11:34	2026-09-03 11:34	XOP	XOP260904P00192500	put	192.5000	2026-09-04	1.3700	0.6900	1.3700	192.7900	20961.00	20961.00	0.00	153	20	153	0	0	0.377894511039781	0.377894511039781	true	false	false	true	false
8b0bdd8c-ae2e-4b38-b796-12261b81010f	2026-09-03 11:30	2026-09-03 11:30	2026-09-03 11:30	XOP	XOP260911P00194000	put	194.0000	2026-09-11	3.4500	2.8000	3.4500	193.5400	14815.00	14815.00	0.00	43	6	43	5	8.6	0.287552945945408	0.287552945945408	false	false	false	true	false
83fb6f6b-c5db-4411-8c4d-3ae82a146faa	2026-09-03 10:45	2026-09-03 10:45	2026-09-03 10:45	XOP	XOP261016C00220000	call	220.0000	2026-10-16	1.3200	1.3100	1.5100	194.0600	89367.00	0.00	89367.00	677	22	677	56	12.0892857142857	0.304550908737143	0.305242139528843	false	false	false	true
41ccfb48-46d7-42ef-864f-6401e202344f	2026-09-02 15:26	2026-09-02 15:26	2026-09-02 15:26	XOP	XOP270319C00168000	call	168.0000	2027-03-19	34.9000	32.7500	35.2000	194.7400	38390.00	38390.00	0.00	11	8	11	0	0	0.296053063112543	0.296053063112543	false	false	false	true
a6560113-c6e2-48be-9f7c-ec88c435c6a8	2026-09-02 13:49	2026-09-02 13:49	2026-09-02 13:49	XOP	XOP260925P00186000	put	186.0000	2026-09-25	2.8000	2.8000	3.1500	193.8550	267400.00	0.00	267400.00	955	32	956	0	0	0.319512981455246	0.319512981455246	false	false	false	true
8c23ad34-b3d8-44d1-90d2-80527c25c6f5	2026-09-02 13:00	2026-09-02 13:00	2026-09-02 13:00	XOP	XOP261218P00195000	put	195.0000	2026-12-18	13.5900	13.3500	13.6000	193.5300	16310.00	14960.00	1350.00	12	12	82	82	1	0.335802280360819	0.333394751177084	false	false	false	true
4530285d-a011-4271-8f3c-b94cb4f316c3	2026-09-02 10:15	2026-09-02 10:15	2026-09-02 10:15	XOP	XOP270115P00185000	put	185.0000	2027-01-15	10.8000	10.7500	11.5000	192.7600	15120.00	1080.00	14040.00	14	6	14	288	0.0486111111111111	0.338264699449284	0.338264699449284	false	false	false	true
c3d2f14f-5342-439e-90d2-c23766f7ea22	2026-09-01 15:05	2026-09-01 15:05	2026-09-01 15:05	XOP	XOP270115C00200000	call	200.0000	2027-01-15	11.8500	11.8000	12.1500	192.0300	11850.00	0.00	10665.00	10	8	37	1633	0.0226576852418861	0.300572123436336	0.300572123436336	false	false	false	true
b1f9aaaf-384a-4839-9137-f4dec8cc892f	2026-09-01 13:53	2026-09-01 13:53	2026-09-01 13:53	XOP	XOP261016P00172000	put	172.0000	2026-10-16	1.6900	1.5400	1.7100	192.1850	10153.00	9318.00	835.00	60	11	554	15	36.9333333333333	0.324587108590546	0.325246692650621	true	false	false	true
61f9ac99-da47-4a0c-9e57-684fc240a850	2026-09-01 13:51	2026-09-01 13:51	2026-09-01 13:51	XOP	XOP270115P00190000	put	190.0000	2027-01-15	13.4500	12.9000	13.4500	192.1450	21520.00	21520.00	0.00	16	6	39	315	0.123809523809524	0.342747105668407	0.342747105668407	false	false	false	true
cc605c86-be39-4b3c-a5af-7124112f1ac2	2026-09-01 13:24	2026-09-01 13:24	2026-09-01 13:24	XOP	XOP270319P00195000	put	195.0000	2027-03-19	18.8900	18.4000	18.9000	191.6900	18890.00	18890.00	0.00	10	6	61	71	0.859154929577465	0.345938370699627	0.345042956756702	false	false	false	true
bdfbcfd0-c0d4-4fb2-801e-57e548e3f39b	2026-09-01 12:08	2026-09-01 12:08	2026-09-01 12:08	XOP	XOP261016P00170000	put	170.0000	2026-10-16	1.6200	1.4700	1.6200	189.5300	18306.00	18306.00	0.00	113	21	173	243	0.711934156378601	0.318558242584198	0.318558242584198	true	false	false	true
ceff17b0-6968-4c8c-9526-b86269f30d35	2026-09-01 11:44	2026-09-01 11:44	2026-09-01 11:44	XOP	XOP260904P00202500	put	202.5000	2026-09-04	12.0000	10.9500	12.0000	190.6400	19200.00	19200.00	0.00	16	8	38	0	0	0.429707231798941	0.429707231798941	false	false	false	true	false
e7e32b31-c81e-4f35-bac3-56184064b968	2026-09-01 11:02	2026-09-01 11:02	2026-09-01 11:02	XOP	XOP260904P00202500	put	202.5000	2026-09-04	11.4000	11.1000	13.4500	191.1700	12540.00	0.00	12540.00	11	5	22	0	0	0.379004822992206	0.379004822992206	false	false	false	true	false
4a917631-0490-4c74-bca7-c257962640c1	2026-09-01 10:01	2026-09-01 10:01	2026-09-01 10:01	XOP	XOP260925C00190000	call	190.0000	2026-09-25	5.9700	5.8500	6.4000	190.3600	20905.00	3000.00	17905.00	35	5	47	78	0.602564102564103	0.278973397634168	0.286712683640755	true	false	false	true
07777f5c-10b0-46ce-8682-b3c2b0d531d5	2026-08-31 14:42	2026-08-31 14:42	2026-08-31 14:42	XOP	XOP260904C00187500	call	187.5000	2026-09-04	2.2300	2.2300	2.7300	186.7700	39255.00	0.00	39255.00	176	18	543	22	24.6818181818182	0.326666564007027	0.325379901781855	true	false	false	true
215e8269-cb28-41e2-b70f-5d5118ef1a9e	2026-08-31 13:38	2026-08-31 13:38	2026-08-31 13:38	XOP	XOP281215P00138000	put	138.0000	2028-12-15	10.5100	8.6000	10.6500	187.4800	19975.00	17855.00	2120.00	19	6	54	273	0.197802197802198	0.345447062242867	0.346908749968775	true	false	false	true
68c1390b-5dfa-42b4-8bd3-949bc647b545	2026-08-31 10:42	2026-08-31 10:42	2026-08-31 10:42	XOP	XOP270319P00185000	put	185.0000	2027-03-19	15.4500	15.4500	15.7000	187.3400	52530.00	0.00	52530.00	34	10	45	2	22.5	0.335870434911762	0.335870434911762	false	false	false	true
81c6e4fe-4afe-4a20-98a2-4e59a822f5b0	2026-08-31 10:03	2026-08-31 10:03	2026-08-31 10:03	XOP	XOP281215P00119000	put	119.0000	2028-12-15	6.2500	4.5500	6.2500	188.6400	18125.00	18125.00	0.00	29	6	29	0	0	0.356643658798395	0.356643658798395	false	false	false	true	false
5d7e7934-1375-4cf0-a9ca-264922053fd5	2026-08-31 10:03	2026-08-31 10:03	2026-08-31 10:03	XOP	XOP281215P00121000	put	121.0000	2028-12-15	6.6800	4.8500	6.7000	188.6400	26725.00	24760.00	1965.00	40	7	40	0	0	0.356949413403308	0.355041436842194	false	false	false	true	false
d7135338-18f4-4c94-a8df-d298b830fa87	2026-08-28 13:51	2026-08-28 13:51	2026-08-28 13:51	XOP	XOP261218P00170000	put	170.0000	2026-12-18	5.7500	5.7500	6.0000	186.1100	25875.00	0.00	25875.00	45	6	135	3257	0.0414491863678232	0.328542997524712	0.328542997524712	false	false	false	true
9176c571-365e-4138-9b49-1f7732cbe787	2026-08-28 09:57	2026-08-28 09:57	2026-08-28 09:57	XOP	XOP261218P00170000	put	170.0000	2026-12-18	5.7500	5.7500	5.9000	185.9400	42550.00	0.00	42550.00	74	10	74	3257	0.0227202947497697	0.327227772799027	0.327227772799027	false	false	false	true
1c53e787-ad21-4882-8515-d1e96e84c6cc	2026-08-27 15:18	2026-08-27 15:18	2026-08-27 15:18	XOP	XOP261016P00182000	put	182.0000	2026-10-16	6.4000	6.4000	6.5000	185.0000	439723.00	0.00	439723.00	687	20	1626	0	0	0.315738091861917	0.315738091861917	false	false	false	true
b0210c53-ea04-4250-a0c5-f7f1a8a91657	2026-08-27 15:06	2026-08-27 15:06	2026-08-27 15:06	XOP	XOP260918P00175000	put	175.0000	2026-09-18	1.5800	1.5300	1.5800	185.6650	15958.00	15958.00	0.00	101	5	250	2228	0.112208258527828	0.30643744988012	0.30643744988012	false	false	false	true
4d2ca86b-6692-4fa8-9da0-5bfa55fc82ee	2026-08-27 15:06	2026-08-27 15:06	2026-08-27 15:06	XOP	XOP260918P00175000	put	175.0000	2026-09-18	1.5800	1.4700	1.5900	185.6300	17064.00	11850.00	1264.00	108	6	149	2228	0.0668761220825853	0.305892581325202	0.305892581325202	false	false	false	true
5f3d1c19-ee74-458d-8345-8f04ce832ac8	2026-08-27 15:00	2026-08-27 15:00	2026-08-27 15:00	XOP	XOP260904C00192000	call	192.0000	2026-09-04	1.0400	1.0400	1.2700	185.5400	32136.00	0.00	32136.00	309	31	323	2	161.5	0.293354271214623	0.293354271214623	false	false	false	true
19b0f62c-26b3-4811-9071-336793d6027f	2026-08-27 12:36	2026-08-27 12:36	2026-08-27 12:36	XOP	XOP260911P00178000	put	178.0000	2026-09-11	1.9200	1.9200	2.5500	183.9300	10563.00	0.00	10563.00	55	6	63	479	0.131524008350731	0.29650934512484	0.297314433821043	false	false	false	true
081a2b16-fd86-4d42-9640-f4d183db2c1d	2026-08-27 12:32	2026-08-27 12:32	2026-08-27 12:32	XOP	XOP261016P00182000	put	182.0000	2026-10-16	7.3500	7.0000	7.5500	183.5600	391755.00	18375.00	373380.00	533	12	928	0	0	0.317591992406105	0.317591992406105	false	false	false	true
457fce92-ba4c-47a4-967e-b0738bbdd053	2026-08-27 11:34	2026-08-27 11:34	2026-08-27 11:34	XOP	XOP270115P00185000	put	185.0000	2027-01-15	14.9000	14.0500	14.9000	182.9600	67050.00	67050.00	0.00	45	21	132	280	0.471428571428571	0.338006889386878	0.338006889386878	false	false	false	true
1b71254b-541c-48b0-b103-5dd59fd0c9e1	2026-08-27 11:25	2026-08-27 11:25	2026-08-27 11:25	XOP	XOP260904C00185000	call	185.0000	2026-09-04	2.4300	1.8800	2.4300	182.7700	11907.00	11907.00	0.00	49	6	52	81	0.641975308641975	0.31014550581889	0.31014550581889	false	false	false	true