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: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

84370d24-c0f1-4b70-ba8c-2cf046217970	2026-09-15 11:38	2026-09-15 11:38	2026-09-15 11:38	XOP	XOP261218P00185000	put	185.0000	2026-12-18	7.4000	7.2000	7.4000	198.7400	36260.00	36260.00	0.00	49	6	762	2894	0.263303386316517	0.359503173238413	0.359503173238413	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-09-15T15:54:17.138635Z"}	2026-09-15	2026-09-15 21:15	2026-09-15 21:15
c67c83a9-5ff8-4c8f-8da1-9ac2117d03d8	2026-09-15 11:13	2026-09-15 11:12	2026-09-15 11:12	XOP	XOP261016P00190000	put	190.0000	2026-10-16	4.7000	4.6500	5.1000	197.7800	292810.00	291870.00	470.00	623	6	1410	4266	0.330520393811533	0.366356081071799	0.366356081071799	false	false	false	true
6eb92d30-414a-41ed-abf3-02faf0246fce	2026-09-15 10:39	2026-09-15 10:39	2026-09-15 10:39	XOP	XOP261016P00187000	put	187.0000	2026-10-16	4.1500	3.8000	4.1500	196.6350	31113.00	31113.00	0.00	75	7	1084	48	22.5833333333333	0.371877795738601	0.372894905762349	false	false	false	true
ab587068-ff19-4f1a-8a09-858484f39d11	2026-09-15 10:35	2026-09-15 10:35	2026-09-15 10:35	XOP	XOP260925C00215000	call	215.0000	2026-09-25	0.4600	0.2700	0.5600	196.1400	22980.00	22796.00	184.00	500	18	1005	103	9.75728155339806	0.386038666873251	0.386038666873251	true	false	false	true
a787ddad-29f5-467b-9e3f-e8252f14f6a1	2026-09-15 10:14	2026-09-15 10:14	2026-09-15 10:14	XOP	XOP261218P00185000	put	185.0000	2026-12-18	7.4500	7.2000	8.3500	197.8550	530440.00	528950.00	1490.00	712	23	712	2894	0.246026261230131	0.353395280646461	0.353395280646461	false	false	false	true
095dd1c0-0f10-4c14-bc45-3fdce4729509	2026-09-15 09:50	2026-09-15 09:50	2026-09-15 09:50	XOP	XOP261016P00187000	put	187.0000	2026-10-16	4.1500	3.2500	4.7000	197.6700	415000.00	8715.00	41500.00	1000	5	1000	48	20.8333333333333	0.388063183709643	0.388063183709643	false	false	false	true
f717bf36-af99-44a3-bc96-90139267bacc	2026-09-15 09:49	2026-09-15 09:49	2026-09-15 09:49	XOP	XOP261218P00175000	put	175.0000	2026-12-18	4.5500	4.0500	4.5500	197.3500	45536.00	45536.00	0.00	100	7	301	590	0.510169491525424	0.356249055834554	0.355551086325828	false	false	false	true
2ad9bdc4-3e39-48dd-8e8c-c1c60d3794d9	2026-09-14 15:52	2026-09-14 15:52	2026-09-14 15:52	XOP	XOP270115C00220000	call	220.0000	2027-01-15	6.0000	6.0000	7.1000	193.0000	15000.00	0.00	15000.00	25	6	25	275	0.0909090909090909	0.318735793799735	0.318735793799735	false	false	false	true
6531f205-b783-49de-a8e0-bb5c37bed72b	2026-09-14 15:18	2026-09-14 15:18	2026-09-14 15:18	XOP	XOP261120P00195000	put	195.0000	2026-11-20	11.3500	10.3500	11.4000	193.5600	12485.00	11350.00	1135.00	11	6	11	24	0.458333333333333	0.343559620250377	0.343559620250377	false	false	false	true
f2f15e44-15cb-4a54-8782-90f5215e2b99	2026-09-14 15:18	2026-09-14 15:18	2026-09-14 15:18	XOP	XOP261120P00199000	put	199.0000	2026-11-20	13.6500	12.5500	13.6500	193.6095	12285.00	12285.00	0.00	9	9	25	0	0	0.347079532189218	0.347079532189218	false	false	false	true	false
881963ab-014c-41da-a4d9-3591da48816f	2026-09-14 15:18	2026-09-14 15:18	2026-09-14 15:18	XOP	XOP261120P00199000	put	199.0000	2026-11-20	13.7000	12.5000	13.7250	193.6095	13700.00	13700.00	0.00	10	10	10	0	0	0.348593143507501	0.348593143507501	false	false	false	true
8deffb56-19c7-490f-9a95-f1f2e06e7344	2026-09-14 15:18	2026-09-14 15:18	2026-09-14 15:18	XOP	XOP261120C00199000	call	199.0000	2026-11-20	8.8500	8.8500	8.9000	193.6250	981465.00	0.00	981465.00	1109	34	1120	0	0	0.319880540707787	0.319880540707787	false	false	false	true
73a32e83-e817-4acd-9a5a-8a180d6acf01	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	XOP	XOP261120P00197000	put	197.0000	2026-11-20	13.0000	11.3000	13.0000	193.1600	130000.00	130000.00	0.00	100	14	100	0	0	0.354820819202933	0.354820819202933	true	false	false	true
4c566cb4-66c3-4d05-acca-77e0592ee572	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	XOP	XOP281215C00235000	call	235.0000	2028-12-15	24.8500	24.8000	24.8500	193.1800	17395.00	12425.00	0.00	7	7	39	10	3.9	0.290672648341826	0.290672648341826	false	false	false	true
5f6db578-e30c-4a85-b347-d76d566adbed	2026-09-14 15:04	2026-09-14 15:04	2026-09-14 15:04	XOP	XOP270319C00169000	call	169.0000	2027-03-19	32.8000	32.8000	35.0000	193.2500	137760.00	0.00	134480.00	42	12	42	10	4.2	0.304238274701245	0.304238274701245	false	false	false	true
2062b20e-de4d-4495-8c0a-959201f808ac	2026-09-14 14:57	2026-09-14 14:57	2026-09-14 14:57	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.7100	2.7100	2.8800	193.5850	60777.00	0.00	40921.00	224	8	2518	6296	0.399936467598475	0.353571895415707	0.354061424161518	true	false	false	true
c319412b-d01b-4bb2-8916-ecbeb0349296	2026-09-14 14:21	2026-09-14 14:20	2026-09-14 14:20	XOP	XOP260925P00185000	put	185.0000	2026-09-25	1.4000	1.4000	1.4700	194.9500	70000.00	0.00	70000.00	500	7	558	25	22.32	0.372050972460073	0.372050972460073	false	false	false	true
f5edcdf2-e83f-42f0-8894-b5b51ea0f84e	2026-09-14 13:25	2026-09-14 13:24	2026-09-14 13:24	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.4800	2.0600	2.5500	195.1300	10168.00	10168.00	0.00	41	5	1322	6296	0.20997458703939	0.354177440002656	0.354177440002656	false	false	false	true
b6f458fe-1580-4791-a164-cbae0fef160a	2026-09-14 11:48	2026-09-14 11:48	2026-09-14 11:48	XOP	XOP261016C00197000	call	197.0000	2026-10-16	6.7500	6.3500	6.9500	195.2200	18225.00	13500.00	4725.00	27	7	27	17	1.58823529411765	0.314855333914991	0.314855333914991	true	false	false	true
6bfbdcdf-3adf-4457-9cf0-ef4ece86e4b5	2026-09-14 11:48	2026-09-14 11:48	2026-09-14 11:48	XOP	XOP261016C00196000	call	196.0000	2026-10-16	7.2000	6.8500	7.4000	195.2200	16560.00	10800.00	5760.00	23	7	23	493	0.0466531440162272	0.31411698292007	0.31411698292007	true	false	false	true
701dedd0-3331-4064-a8fb-34c0f7adeb7b	2026-09-14 11:04	2026-09-14 11:04	2026-09-14 11:04	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.1800	1.9300	2.1800	198.2000	18094.00	18094.00	0.00	83	5	396	6296	0.0628970775095299	0.361238556840476	0.361238556840476	true	false	false	true
6127aef9-2900-40d0-9d92-5e94fce7b3b3	2026-09-14 10:28	2026-09-14 10:27	2026-09-14 10:27	XOP	XOP261016P00190000	put	190.0000	2026-10-16	4.5000	3.9500	4.5000	198.4100	404985.00	404985.00	0.00	900	64	903	3528	0.255952380952381	0.360895848057873	0.360895848057873	true	false	false	true
0a8fc6d7-1e59-47c7-b65a-d3ed4e419798	2026-09-14 09:35	2026-09-14 09:35	2026-09-14 09:35	XOP	XOP270319C00210000	call	210.0000	2027-03-19	14.5700	14.1000	15.0000	198.4700	14572.00	14572.00	0.00	10	6	30	147	0.204081632653061	0.316670158307683	0.316670158307683	false	false	false	true
a704898a-ae36-4113-8cff-93c375e1833d	2026-09-11 13:40	2026-09-11 13:39	2026-09-11 13:39	XOP	XOP260918P00185000	put	185.0000	2026-09-18	0.5300	0.5200	0.6600	195.8800	65031.00	0.00	64925.00	1227	10	1231	679	1.81296023564065	0.351310758970811	0.351310758970811	false	false	false	true
9d61d858-5b7c-4cfc-83df-dfe367989591	2026-09-11 12:15	2026-09-11 12:15	2026-09-11 12:15	XOP	XOP260918P00180000	put	180.0000	2026-09-18	0.1900	0.1900	0.3900	196.4000	28215.00	0.00	27930.00	1485	49	1491	8214	0.181519357195033	0.378468952358366	0.378468952358366	false	false	false	true
47c23cb9-27ae-4bf7-8eb9-06e25d5dad41	2026-09-11 11:45	2026-09-11 11:45	2026-09-11 11:45	XOP	XOP261016P00198000	put	198.0000	2026-10-16	8.9000	8.8500	9.1000	196.2000	342650.00	13350.00	329300.00	385	9	396	0	0	0.344562916330662	0.344562916330662	false	false	false	true
973eb68d-26d8-4aaf-b42a-9d2fd3c3b2af	2026-09-11 11:45	2026-09-11 11:44	2026-09-11 11:44	XOP	XOP260918P00195000	put	195.0000	2026-09-18	2.9900	2.9900	3.8500	196.2000	12558.00	0.00	12558.00	42	15	51	124	0.411290322580645	0.335453818284284	0.335453818284284	false	false	false	true
04823348-9189-44a6-b413-f665d307906e	2026-09-11 11:43	2026-09-11 11:43	2026-09-11 11:43	XOP	XOP261016P00197000	put	197.0000	2026-10-16	8.4500	7.7000	8.8500	196.1450	40560.00	36335.00	4225.00	48	7	48	0	0	0.346757482201557	0.346757482201557	false	false	false	true	false
9d8f5cb1-6aaf-4105-9d37-fbfef0ad03ec	2026-09-11 11:32	2026-09-11 11:32	2026-09-11 11:32	XOP	XOP261016C00195000	call	195.0000	2026-10-16	8.2500	8.0500	8.2500	195.8650	13200.00	13200.00	0.00	16	6	75	371	0.202156334231806	0.307849990976133	0.307849990976133	true	false	false	true
6fceabfd-81ad-47aa-9db5-11829c47c138	2026-09-11 11:00	2026-09-11 10:59	2026-09-11 10:59	XOP	XOP261016C00196000	call	196.0000	2026-10-16	8.0000	7.2500	8.1000	195.9600	24800.00	24800.00	0.00	31	5	31	462	0.0670995670995671	0.316237339581556	0.316237339581556	true	false	false	true
2f96a0c1-4e9b-4628-a87f-506c42598fab	2026-09-11 10:49	2026-09-11 10:49	2026-09-11 10:49	XOP	XOP260918P00196000	put	196.0000	2026-09-18	4.3000	3.2500	4.3000	195.0400	34830.00	34830.00	0.00	81	12	152	20	7.6	0.35935706127358	0.35935706127358	true	false	false	true	false
59aef2d3-3af4-4308-8370-d2fb67b92a6a	2026-09-11 10:38	2026-09-11 10:37	2026-09-11 10:37	XOP	XOP261016C00210000	call	210.0000	2026-10-16	3.1500	3.1500	3.4000	196.0600	13230.00	0.00	13230.00	42	15	64	912	0.0701754385964912	0.322798836377872	0.322798836377872	false	false	false	true
65221554-2c39-46f7-836e-d4ebe44686b1	2026-09-11 10:11	2026-09-11 10:11	2026-09-11 10:11	XOP	XOP260918P00196000	put	196.0000	2026-09-18	3.5500	2.8000	3.5500	196.7100	16330.00	16330.00	0.00	46	14	71	20	3.55	0.365559910459922	0.365559910459922	false	false	false	true
7c877694-3240-43f6-b189-617070c87b4c	2026-09-10 15:56	2026-09-10 15:55	2026-09-10 15:55	XOP	XOP261016C00195000	call	195.0000	2026-10-16	8.6000	8.6000	9.2000	195.8450	64500.00	0.00	64500.00	75	31	131	314	0.417197452229299	0.318262087605696	0.318262087605696	true	false	false	true
c48d3104-60c4-4f2d-a057-1d4edc4b0d5c	2026-09-10 15:26	2026-09-10 15:26	2026-09-10 15:26	XOP	XOP261016P00196000	put	196.0000	2026-10-16	8.3500	7.8500	8.3500	196.3500	95188.00	95188.00	0.00	114	17	119	4	29.75	0.361903352710896	0.36272097652482	false	false	false	true
84d8ec86-b7be-4aaa-86b3-f3c87befd233	2026-09-10 15:23	2026-09-10 15:23	2026-09-10 15:23	XOP	XOP270115C00225000	call	225.0000	2027-01-15	6.3500	6.1000	6.7000	196.6000	25400.00	14605.00	7620.00	40	7	60	89	0.674157303370786	0.323677773759485	0.323677773759485	false	false	false	true
f88f9559-faec-49df-a779-24d52288c6e2	2026-09-10 15:04	2026-09-10 15:04	2026-09-10 15:04	XOP	XOP261009C00192500	call	192.5000	2026-10-09	9.7500	7.5500	9.7500	196.9300	173478.00	173478.00	0.00	178	22	178	5	35.6	0.318413323308279	0.318413323308279	false	false	false	true
a3d92c3e-12d9-4455-9353-7bcd12fc2dab	2026-09-10 15:04	2026-09-10 15:04	2026-09-10 15:04	XOP	XOP261009C00191000	call	191.0000	2026-10-09	10.7000	9.5500	10.7000	196.9300	111280.00	111280.00	0.00	104	16	104	0	0	0.320092015743686	0.320092015743686	false	false	false	true
f6e76c76-fef8-4ce4-8278-b1d68684c126	2026-09-10 15:04	2026-09-10 15:03	2026-09-10 15:03	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.8500	55080.00	0.00	55080.00	102	7	2606	132	19.7424242424242	0.358665738187727	0.358665738187727	false	false	false	true
7f07c645-6562-4422-b9a9-68abeff5e906	2026-09-10 15:01	2026-09-10 15:01	2026-09-10 15:01	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.8700	102600.00	0.00	102600.00	190	11	1852	132	14.030303030303	0.358364000398094	0.358967313290698	false	false	false	true
a706a5e4-43d0-4a8a-8968-6b0941b2c34c	2026-09-10 15:00	2026-09-10 15:00	2026-09-10 15:00	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.5750	67500.00	0.00	67500.00	125	5	1509	132	11.4318181818182	0.354502440937502	0.354502440937502	false	false	false	true
c161cf34-ada4-4cfc-a721-0229f8876fa5	2026-09-10 15:00	2026-09-10 15:00	2026-09-10 15:00	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.5750	75600.00	0.00	75600.00	140	5	1384	132	10.4848484848485	0.354502440937502	0.354502440937502	false	false	false	true
8ab9d5f3-0d85-4b96-a78e-e74f35f3a8f0	2026-09-10 15:00	2026-09-10 14:59	2026-09-10 14:59	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.4000	5.4000	5.4500	196.5750	99900.00	0.00	99900.00	185	7	1221	132	9.25	0.354502440937502	0.354502440937502	false	false	false	true
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
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
f303adaf-f963-4966-917a-01bcc441dd72	2026-09-10 14:01	2026-09-10 14:01	2026-09-10 14:01	XOP	XOP261016P00180000	put	180.0000	2026-10-16	2.2200	2.1900	2.3800	196.7500	111010.00	0.00	110353.00	500	9	2513	2373	1.05899705014749	0.343888474770894	0.344503922467426	true	false	false	true