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

dcfde9bf-1401-4079-a67d-8c8a620bb56f	2026-09-17 12:34	2026-09-17 12:34	2026-09-17 12:34	XOP	XOP261218P00185000	put	185.0000	2026-12-18	9.1000	8.9500	9.1000	192.1800	90090.00	90090.00	0.00	99	19	211	3715	0.0567967698519515	0.351044390230808	0.351044390230808	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4265140147.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-17T16:46:55.190867Z"}	2026-09-17	2026-09-17 21:15	2026-09-17 21:15
a5d53a08-c4cf-4b47-9eae-a44091beba67	2026-09-17 12:21	2026-09-17 12:21	2026-09-17 12:21	XOP	XOP260918P00190000	put	190.0000	2026-09-18	0.7200	0.7200	0.8500	191.7600	11880.00	0.00	11880.00	165	32	1330	788	1.68781725888325	0.360895333205612	0.360895333205612	false	false	false	true
71f41587-9c31-4529-81a0-f29d0301939d	2026-09-17 12:21	2026-09-17 12:20	2026-09-17 12:20	XOP	XOP261218P00185000	put	185.0000	2026-12-18	9.2500	8.7000	9.2500	191.8700	85100.00	85100.00	0.00	92	18	92	3715	0.024764468371467	0.352114437475304	0.352114437475304	false	false	false	true
b7fde79c-982e-45ba-a9f6-18bac7753291	2026-09-17 12:17	2026-09-17 12:17	2026-09-17 12:17	XOP	XOP261218P00174000	put	174.0000	2026-12-18	5.3500	4.9000	5.4500	191.9800	103209.00	85034.00	18175.00	193	9	399	44	9.06818181818182	0.354988006322807	0.354988006322807	true	false	false	true
c22c45af-a466-4413-a329-3b0e5e818992	2026-09-17 12:16	2026-09-17 12:16	2026-09-17 12:16	XOP	XOP261218P00174000	put	174.0000	2026-12-18	5.3500	5.1250	5.4500	191.7750	85065.00	17120.00	67945.00	159	5	206	44	4.68181818181818	0.353338064409713	0.353338064409713	false	false	false	true
846a6058-faa9-4b5c-bcec-4819628c86fb	2026-09-17 12:08	2026-09-17 12:08	2026-09-17 12:08	XOP	XOP261016P00190000	put	190.0000	2026-10-16	6.6000	6.6000	6.8000	191.4600	31020.00	0.00	31020.00	47	17	74	5150	0.014368932038835	0.354312166428295	0.354312166428295	false	false	false	true
8db51530-84a5-4e75-92de-44dc076bcba9	2026-09-17 12:01	2026-09-17 12:01	2026-09-17 12:01	XOP	XOP260918P00190000	put	190.0000	2026-09-18	0.8300	0.8300	0.9300	191.5300	10541.00	0.00	10541.00	127	31	1136	788	1.44162436548223	0.37098038324506	0.37098038324506	false	false	false	true
5f544641-11fc-4ccb-8e07-c98d034ea623	2026-09-17 12:01	2026-09-17 12:01	2026-09-17 12:01	XOP	XOP270319C00205000	call	205.0000	2027-03-19	13.6000	13.6000	13.7500	191.6950	38080.00	0.00	38080.00	28	6	65	227	0.286343612334802	0.319274648302256	0.319274648302256	false	false	false	true
bff0c5bd-39c2-4acf-b4dd-b44d790c369a	2026-09-17 10:37	2026-09-17 10:37	2026-09-17 10:37	XOP	XOP260918P00194000	put	194.0000	2026-09-18	3.2500	3.1000	4.4500	191.2900	11700.00	0.00	11700.00	36	10	76	371	0.204851752021563	0.384852654516642	0.384852654516642	false	false	false	true
bbae78d0-a981-43c1-99ad-6eaef43c82a8	2026-09-17 10:37	2026-09-17 10:37	2026-09-17 10:37	XOP	XOP260918P00194000	put	194.0000	2026-09-18	3.2500	3.1500	4.4500	191.2900	13000.00	0.00	13000.00	40	9	40	371	0.107816711590297	0.384852654516642	0.384852654516642	true	false	false	true
89bc1ad6-d42a-40d2-9764-07817162ce49	2026-09-17 10:17	2026-09-17 10:17	2026-09-17 10:17	XOP	XOP261016P00186000	put	186.0000	2026-10-16	5.5000	4.9500	5.5000	190.7800	549935.00	549935.00	0.00	1000	51	1000	61	16.3934426229508	0.373396967802564	0.373396967802564	false	false	false	true
e588e3ee-ad37-4c1b-b294-1b07bf9adfa5	2026-09-16 15:48	2026-09-16 15:48	2026-09-16 15:48	XOP	XOP261016P00187000	put	187.0000	2026-10-16	5.2500	5.2500	6.0000	192.0000	42000.00	0.00	42000.00	80	12	132	1142	0.115586690017513	0.360432411997392	0.360960312347781	true	false	false	true
72e60fe2-a361-4726-baf7-4777e7ad3543	2026-09-16 15:48	2026-09-16 15:48	2026-09-16 15:48	XOP	XOP261016P00185000	put	185.0000	2026-10-16	4.5000	4.4500	5.1000	192.0000	44550.00	0.00	44550.00	99	6	333	2965	0.112310286677909	0.361201610447481	0.361201610447481	false	false	false	true
10fdc80a-4b02-4f89-b041-e7daceb53a28	2026-09-16 15:42	2026-09-16 15:42	2026-09-16 15:42	XOP	XOP260918P00194000	put	194.0000	2026-09-18	3.6000	3.3500	4.5000	191.6400	19809.00	0.00	19809.00	55	19	66	338	0.195266272189349	0.39586074560567	0.39586074560567	true	false	false	true
a947ff77-d6a9-4aca-8046-84fd8f734276	2026-09-16 14:49	2026-09-16 14:49	2026-09-16 14:49	XOP	XOP261218P00185000	put	185.0000	2026-12-18	8.7000	8.4500	8.7000	192.9700	18270.00	18270.00	0.00	21	6	352	3694	0.0952896589063346	0.345772421697628	0.345772421697628	true	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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