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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/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	expiry

65fc8362-fb63-4f7e-a3f9-7b143e6f1a58	2026-09-16 10:21	2026-09-16 10:21	2026-09-16 10:21	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.7900	2.7900	2.8000	193.0000	13950.00	0.00	6696.00	50	6	4866	6429	0.756882874475035	0.361978463325793	0.361978463325793	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4332127978.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T14:33:33.962889Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
4fd108eb-6817-4722-a608-fbe956c77e4a	2026-09-16 10:20	2026-09-16 10:20	2026-09-16 10:20	XOP	XOP270319P00200000	put	200.0000	2027-03-19	21.1500	19.5500	21.2000	193.0000	44415.00	44415.00	0.00	21	10	21	293	0.0716723549488055	0.364966469920226	0.364966469920226	false	false	false	true
612d960e-a447-41fc-8ac8-debedf49cec4	2026-09-16 10:06	2026-09-16 10:06	2026-09-16 10:06	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.6300	2.6300	2.8700	194.2500	73640.00	0.00	73640.00	280	7	4816	6429	0.74910561518121	0.360054242961236	0.360054242961236	false	false	false	true
05db7641-572b-43b7-b7d2-794cfc09d4b8	2026-09-16 10:06	2026-09-16 10:06	2026-09-16 10:06	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.6300	2.6100	2.6300	194.3600	25248.00	25248.00	0.00	96	5	4479	6429	0.696686887540831	0.360932659066481	0.360932659066481	false	false	false	true
0491f5d9-f292-4ec5-8e8e-358e10cae707	2026-09-16 10:06	2026-09-16 10:05	2026-09-16 10:05	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.6400	2.6400	2.8700	194.2500	16368.00	0.00	16368.00	62	11	4383	6429	0.681754549696687	0.360558989394568	0.360558989394568	false	false	false	true
c781ed75-49fa-4b7d-9cd5-fe951ef05fdc	2026-09-16 10:04	2026-09-16 10:04	2026-09-16 10:04	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.6500	2.6500	2.8000	194.2400	11925.00	0.00	11925.00	45	7	3813	6429	0.593093793747083	0.360983118628027	0.360983118628027	false	false	false	true
82783dca-d76b-4d33-af8e-a853df540eaa	2026-09-16 10:00	2026-09-16 09:59	2026-09-16 09:59	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.7100	2.6700	2.7100	194.1900	25203.00	25203.00	0.00	93	5	3243	6429	0.50443303779748	0.363593619368806	0.363593619368806	false	false	false	true
7cb07f5f-5c5d-45ee-b1ce-2114d190b2d5	2026-09-16 09:55	2026-09-16 09:55	2026-09-16 09:55	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.7500	2.7200	2.8800	194.3342	463925.00	117700.00	341275.00	1687	44	2598	6429	0.40410639290714	0.366749959873138	0.366749959873138	false	false	false	true
ad7831bf-a41c-4c82-b5b8-69f281fa23db	2026-09-16 09:53	2026-09-16 09:53	2026-09-16 09:53	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.7800	2.7500	2.9200	194.1100	38706.00	20850.00	17856.00	139	5	689	6429	0.107170633068907	0.366434196850617	0.366929685033296	true	false	false	true
5be8795b-3f8b-43ee-ae04-7116c50817ae	2026-09-16 09:53	2026-09-16 09:53	2026-09-16 09:53	XOP	XOP261120P00170000	put	170.0000	2026-11-20	2.7300	2.5200	2.9200	194.3600	69644.00	33352.00	15892.00	255	5	342	6429	0.053196453569762	0.365459009759004	0.366458495518262	false	false	false	true
ca0bf781-2401-48da-949b-2ec8c7aedb50	2026-09-15 15:29	2026-09-15 15:29	2026-09-15 15:29	XOP	XOP270115C00200000	call	200.0000	2027-01-15	15.5100	15.4000	15.8000	199.2900	23262.00	0.00	23262.00	15	5	39	1995	0.0195488721804511	0.31763885788652	0.31763885788652	false	false	false	true
79465445-5466-4812-a5e6-f8f7a10e2ee8	2026-09-15 15:26	2026-09-15 15:26	2026-09-15 15:26	XOP	XOP261218P00185000	put	185.0000	2026-12-18	7.1500	6.6000	7.1500	199.2900	12870.00	12870.00	0.00	18	5	956	2894	0.330338631651693	0.356896041870266	0.356896041870266	false	false	false	true
dfbd490a-4565-4aaa-a1dd-4e893b84c51d	2026-09-15 14:41	2026-09-15 14:41	2026-09-15 14:41	XOP	XOP270115P00155000	put	155.0000	2027-01-15	1.9400	1.7500	1.9500	199.7200	93314.00	582.00	92732.00	481	6	485	1084	0.447416974169742	0.373144278793665	0.373144278793665	false	false	false	true
561edb7a-7544-46f3-9d5b-eef5fabd14b0	2026-09-15 13:55	2026-09-15 13:55	2026-09-15 13:55	XOP	XOP280121P00145000	put	145.0000	2028-01-21	6.7000	5.9500	7.4000	200.7600	67000.00	58960.00	8040.00	100	13	100	51	1.96078431372549	0.36384228804046	0.36384228804046	true	false	false	true
5acf2ec6-8ff9-414a-b21d-50b7039e3758	2026-09-15 13:02	2026-09-15 13:02	2026-09-15 13:02	XOP	XOP261218P00185000	put	185.0000	2026-12-18	7.2000	7.0000	7.2000	199.6150	111600.00	111600.00	0.00	155	32	936	2894	0.323427781617139	0.361050810057203	0.361050810057203	false	false	false	true
aa08eeda-e994-4dc0-8f34-dce3ac3efc82	2026-09-15 12:35	2026-09-15 12:35	2026-09-15 12:35	XOP	XOP261002P00174000	put	174.0000	2026-10-02	0.3100	0.3100	0.4900	199.0000	71920.00	0.00	71920.00	2320	63	2322	0	0	0.384272182506593	0.384272182506593	false	false	false	true
a0f5896c-117a-4279-a765-076b0cb9671a	2026-09-15 12:02	2026-09-15 12:02	2026-09-15 12:02	XOP	XOP261016C00197000	call	197.0000	2026-10-16	8.9000	8.8000	8.9000	199.1100	14240.00	14240.00	0.00	16	6	63	73	0.863013698630137	0.32303256719701	0.32303256719701	true	false	false	true
b21df3d6-d4d3-4a55-a8b4-a43c496297f7	2026-09-15 11:55	2026-09-15 11:55	2026-09-15 11:55	XOP	XOP261016P00200000	put	200.0000	2026-10-16	8.6500	8.3500	8.6500	199.3600	62280.00	62280.00	0.00	72	26	73	22	3.31818181818182	0.374468687603952	0.374468687603952	false	false	false	true
9fcc3950-45f1-4d49-a78c-1434390293dc	2026-09-15 11:50	2026-09-15 11:50	2026-09-15 11:50	XOP	XOP261218P00185000	put	185.0000	2026-12-18	7.3500	7.0500	7.3500	198.8300	13965.00	13965.00	0.00	19	6	781	2894	0.269868693849343	0.358822328368442	0.358822328368442	false	false	false	true
4d2d58bd-76c7-478d-890e-3d60b0f8fda3	2026-09-15 11:46	2026-09-15 11:46	2026-09-15 11:46	XOP	XOP261016C00199000	call	199.0000	2026-10-16	8.0000	7.3500	8.2000	199.0800	80000.00	60000.00	20000.00	100	11	148	163	0.907975460122699	0.329604955875379	0.329604955875379	false	false	false	true
939ac470-0f50-49df-ab24-a01bdc90c05c	2026-09-15 11:45	2026-09-15 11:45	2026-09-15 11:45	XOP	XOP270115C00200000	call	200.0000	2027-01-15	15.0000	14.2000	15.7500	199.1100	15000.00	10500.00	1500.00	10	6	15	1995	0.0075187969924812	0.307529255736741	0.307529255736741	false	false	false	true
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
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
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
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