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×sorted by created_at ↑×

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

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	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-14T19:19:00.930033Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
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	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	false
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
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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
d77dc038-2145-4653-91c6-1616d399f8a4	2026-09-16 10:30	2026-09-16 10:30	2026-09-16 10:30	XOP	XOP270115C00225000	call	225.0000	2027-01-15	5.4500	5.2000	5.4500	193.0000	86640.00	86640.00	0.00	159	21	163	144	1.13194444444444	0.330625230634394	0.330625230634394	false	false	false	true	false
38e785f6-3fbf-4ed9-a8f9-5b575995ef68	2026-09-16 10:48	2026-09-16 10:48	2026-09-16 10:48	XOP	XOP261016P00191000	put	191.0000	2026-10-16	6.9500	6.4500	7.0000	192.8400	36135.00	36135.00	0.00	52	14	55	44	1.25	0.370648403480063	0.370648403480063	false	false	false	true	false
69465d65-aad0-43d2-bc85-fce554ba4830	2026-09-16 10:56	2026-09-16 10:56	2026-09-16 10:56	XOP	XOP261016P00178000	put	178.0000	2026-10-16	2.3700	2.3700	2.6200	192.7200	11850.00	0.00	11850.00	50	14	50	788	0.0634517766497462	0.365344449572511	0.365344449572511	false	false	false	true	false
4fbdc061-ab0d-4be7-a983-183f5c0c7f64	2026-09-16 11:15	2026-09-16 11:15	2026-09-16 11:15	XOP	XOP261016P00189000	put	189.0000	2026-10-16	6.2500	6.1500	6.9000	191.8700	11250.00	0.00	11250.00	18	5	24	50	0.48	0.361971687093155	0.361971687093155	false	false	false	true	false
c3d066e5-8cdb-435e-b61b-a8afa479d89d	2026-09-16 11:47	2026-09-16 11:47	2026-09-16 11:47	XOP	XOP261016P00193000	put	193.0000	2026-10-16	8.3900	7.4500	8.5000	191.9000	13430.00	10920.00	2510.00	16	14	16	60	0.266666666666667	0.371451387437676	0.369172295095177	true	false	false	true	false
22c89eef-3067-4c25-9948-e7028867c90d	2026-09-16 12:33	2026-09-16 12:33	2026-09-16 12:33	XOP	XOP261016C00210000	call	210.0000	2026-10-16	2.1000	2.1000	2.4100	193.6300	96600.00	0.00	76860.00	460	32	500	1040	0.480769230769231	0.324226250596996	0.324226250596996	true	false	false	true	false
44d043c3-e184-4699-9ac2-ef89a77e5b26	2026-09-16 13:34	2026-09-16 13:34	2026-09-16 13:34	XOP	XOP270319C00210000	call	210.0000	2027-03-19	12.9000	12.9000	13.2500	194.1800	28380.00	0.00	28380.00	22	5	106	158	0.670886075949367	0.318057960376747	0.318057960376747	false	false	false	true	false
1e3c0ae1-a778-4f82-955d-4b9b9b6b42a5	2026-09-16 14:01	2026-09-16 14:01	2026-09-16 14:01	XOP	XOP261016C00210000	call	210.0000	2026-10-16	2.1100	2.1100	2.4000	193.0000	39035.00	0.00	34815.00	185	12	738	1040	0.709615384615385	0.32497614658236	0.32497614658236	true	false	false	true	false
25cbc2d4-5f55-4012-b8da-767d9ca4fbfd	2026-09-16 14:02	2026-09-16 14:01	2026-09-16 14:01	XOP	XOP261016P00185000	put	185.0000	2026-10-16	4.1000	3.8500	4.1000	193.0000	11480.00	11480.00	0.00	28	7	41	2965	0.0138279932546374	0.361747538571345	0.361747538571345	false	false	false	true	false
e4c94933-e8cf-4c0a-b186-67d985d0e207	2026-09-16 14:02	2026-09-16 14:02	2026-09-16 14:02	XOP	XOP261218P00185000	put	185.0000	2026-12-18	8.7000	8.0000	8.7000	193.0000	20880.00	20880.00	0.00	24	7	83	3694	0.0224688684353005	0.350199203509679	0.350199203509679	false	false	false	true	false
c2afe9ab-12b2-4b8e-86b8-353deb2e3dfc	2026-09-16 14:20	2026-09-16 14:20	2026-09-16 14:20	XOP	XOP261218P00185000	put	185.0000	2026-12-18	8.7000	8.5000	8.7000	194.0000	126148.00	126148.00	0.00	145	39	228	3694	0.0617217108825122	0.355626710160038	0.355626710160038	false	false	false	true	false
93d9576b-7d43-4a5c-a595-9785a0c515a8	2026-09-16 14:36	2026-09-16 14:36	2026-09-16 14:36	XOP	XOP261218P00185000	put	185.0000	2026-12-18	8.7000	8.2500	8.7000	193.4600	60900.00	60900.00	0.00	70	19	299	3694	0.0809420682187331	0.350486440729464	0.350486440729464	true	false	false	true	false
5f4dac60-38d7-4e79-99fb-51ee709eb8da	2026-09-16 14:36	2026-09-16 14:36	2026-09-16 14:36	XOP	XOP261218P00185000	put	185.0000	2026-12-18	8.7000	8.5500	8.7000	193.2400	25230.00	25230.00	0.00	29	11	328	3694	0.0887926367081754	0.348375891305795	0.348375891305795	false	false	false	true	false
f831d20e-dd8c-439a-a2f9-b66221db79ff	2026-09-16 14:49	2026-09-16 14:49	2026-09-16 14:49	XOP	XOP261016P00185000	put	185.0000	2026-10-16	4.1000	3.9500	4.1000	192.9700	10660.00	10660.00	0.00	26	9	158	2965	0.0532883642495784	0.353792469510972	0.353792469510972	false	false	false	true	false