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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	4332127978.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-16T19:03:15.749073Z"}	2026-09-16	2026-09-16 21:15	2026-09-16 21:15
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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
44b3c8b3-d700-499f-ae56-6d7246a318ed	2026-09-17 12:46	2026-09-17 12:46	2026-09-17 12:46	XOP	XOP260925P00183000	put	183.0000	2026-09-25	0.9300	0.9300	1.1600	192.3900	10137.00	0.00	10137.00	109	22	109	70	1.55714285714286	0.363373447937563	0.363373447937563	false	false	false	true	false
5b3b6db3-e09d-47d1-9bb9-7b1e7fa94277	2026-09-17 13:02	2026-09-17 13:02	2026-09-17 13:02	XOP	XOP261218C00205000	call	205.0000	2026-12-18	8.1000	8.1000	8.6500	192.4950	11340.00	0.00	11340.00	14	9	14	134	0.104477611940299	0.318562502143983	0.318562502143983	false	false	false	true	false
9f1936a1-fc92-4479-a67e-f144003d263e	2026-09-17 13:23	2026-09-17 13:23	2026-09-17 13:23	XOP	XOP261218C00200000	call	200.0000	2026-12-18	10.3000	10.3000	10.5000	192.6100	13390.00	0.00	13390.00	13	5	68	1494	0.0455153949129853	0.3266762417028	0.3266762417028	true	false	false	true	false
2a7e8090-aa97-41d0-a719-3b380f2ed9b3	2026-09-17 14:55	2026-09-17 14:55	2026-09-17 14:55	XOP	XOP261016P00190000	put	190.0000	2026-10-16	6.2000	6.0500	6.2000	192.5950	309997.00	309997.00	0.00	500	51	817	5150	0.158640776699029	0.358236257746621	0.358236257746621	false	false	false	true	false
bd2d9c44-36a3-4328-a52b-588b7405448f	2026-09-17 15:40	2026-09-17 15:40	2026-09-17 15:40	XOP	XOP270319C00200000	call	200.0000	2027-03-19	16.1500	15.7000	16.1500	192.7125	25840.00	25840.00	0.00	16	10	64	270	0.237037037037037	0.32069234034425	0.32069234034425	false	false	false	true	false
03469d90-9fd5-4d9e-838d-2f5f15659a46	2026-09-17 15:43	2026-09-17 15:43	2026-09-17 15:43	XOP	XOP261016C00210000	call	210.0000	2026-10-16	1.7300	1.6900	1.7400	192.5300	19761.00	17226.00	2535.00	114	6	239	1749	0.136649514008005	0.320957508277928	0.317540234983762	true	false	false	true	false
5ea0c43e-8090-4a5c-8bdf-bfbc36637aea	2026-09-17 15:43	2026-09-17 15:43	2026-09-17 15:43	XOP	XOP261016C00210000	call	210.0000	2026-10-16	1.7100	1.6900	1.7200	192.5500	12678.00	9788.00	2890.00	74	11	354	1749	0.202401372212693	0.319337224814777	0.319337224814777	true	false	false	true	false
cd0f8af1-5c68-4177-ad8c-1b10b9986301	2026-09-17 15:49	2026-09-17 15:49	2026-09-17 15:49	XOP	XOP261016C00210000	call	210.0000	2026-10-16	1.6900	1.5400	1.6900	192.5850	15041.00	13520.00	0.00	89	11	556	1749	0.31789594053745	0.316835430587365	0.316835430587365	false	false	false	true	false
407ecb94-d0e0-4a83-b31d-a840793034b2	2026-09-17 15:49	2026-09-17 15:49	2026-09-17 15:49	XOP	XOP261016C00210000	call	210.0000	2026-10-16	1.6700	1.5400	1.7400	192.0000	32899.00	32899.00	0.00	197	9	753	1749	0.430531732418525	0.316419994533445	0.316419994533445	false	false	false	true	false
9df8e942-ebf4-4bd6-bc6a-88b37bea15ee	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	XOP	XOP261120P00185000	put	185.0000	2026-11-20	6.5000	6.5000	0.0000	192.7900	78650.00	78650.00	0.00	121	6	121	3	40.3333333333333	0.334460040423235	0.334460040423235	false	false	false	true	false
33d03db8-86f9-4a0c-abc8-5a89d1a8a695	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	XOP	XOP261120P00185000	put	185.0000	2026-11-20	6.5000	6.5000	8.7500	192.7900	64365.00	0.00	64365.00	99	5	256	3	85.3333333333333	0.33480147173639	0.334460040423235	false	false	false	true	false
fa62f88a-9e9d-4dcf-a9c5-78c9cc48adad	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	XOP	XOP261120P00185000	put	185.0000	2026-11-20	7.3000	6.7500	7.3500	191.9850	13870.00	13870.00	0.00	19	19	389	3	129.666666666667	0.352145459474034	0.352145459474034	false	false	false	true	false
22757760-79af-4cb1-bb6f-73bf5519759e	2026-09-18 09:30	2026-09-18 09:30	2026-09-18 09:30	XOP	XOP261120P00185000	put	185.0000	2026-11-20	7.3500	7.1000	7.3500	191.7300	17640.00	17640.00	0.00	24	6	429	3	143	0.350777436064459	0.350777436064459	false	false	false	true	false
ff2c5f6a-b34d-4c5a-93e0-a1751c0defe0	2026-09-18 09:34	2026-09-18 09:34	2026-09-18 09:34	XOP	XOP261120P00185000	put	185.0000	2026-11-20	7.3500	7.0500	7.5500	191.7400	18375.00	17640.00	735.00	25	25	474	3	158	0.350897537953169	0.350897537953169	false	false	false	true	false
955bb9f4-e1e8-423b-9011-4f118f8cae8e	2026-09-18 09:50	2026-09-18 09:50	2026-09-18 09:50	XOP	XOP280121C00235000	call	235.0000	2028-01-21	16.4700	15.3500	16.7500	192.7000	46108.00	46108.00	0.00	28	10	28	5	5.6	0.298004654104855	0.298004654104855	false	false	false	true	false
e274a3c8-2f7c-4c6c-9c20-48229d93e8bb	2026-09-18 09:55	2026-09-18 09:55	2026-09-18 09:55	XOP	XOP260918C00170000	call	170.0000	2026-09-18	22.1000	22.1000	23.1000	192.2100	41990.00	0.00	41990.00	19	5	25	7449	0.00335615518861592	3.71663849949724	3.71663849949724	false	false	false	true	false
08325559-4da0-433c-ae75-b375eaad29e7	2026-09-18 10:02	2026-09-18 10:02	2026-09-18 10:02	XOP	XOP260918C00170000	call	170.0000	2026-09-18	22.3000	22.3000	23.0000	192.5900	15610.00	0.00	15610.00	7	5	32	7449	0.00429587864142838	3.12907944285016	3.12907944285016	false	false	false	true	false
387c6176-533f-48db-8f89-15b561a7944b	2026-09-18 10:37	2026-09-18 10:37	2026-09-18 10:37	XOP	XOP261016C00191000	call	191.0000	2026-10-16	7.5000	6.9000	7.5000	192.5300	28500.00	28500.00	0.00	38	5	75	44	1.70454545454545	0.302080562311511	0.302080562311511	true	false	false	true	false
55effd1a-36b5-40e3-b56c-8ef963ad52ab	2026-09-18 10:48	2026-09-18 10:48	2026-09-18 10:48	XOP	XOP261016P00190000	put	190.0000	2026-10-16	5.7000	5.5500	5.8500	193.0994	11408.00	7423.00	1705.00	20	7	29	5747	0.00504611101444232	0.349032048323938	0.349032048323938	false	false	false	true	false
c31d9ce8-af04-416e-bce6-8646d0801343	2026-09-18 11:03	2026-09-18 11:03	2026-09-18 11:03	XOP	XOP261120P00195000	put	195.0000	2026-11-20	11.7500	11.7500	11.8500	192.3600	327825.00	0.00	327825.00	279	6	289	39	7.41025641025641	0.347622993618265	0.347622993618265	false	false	false	true	false
3b85ad68-7925-4631-9f68-b4ca84008656	2026-09-18 12:53	2026-09-18 12:53	2026-09-18 12:53	XOP	XOP261023P00170000	put	170.0000	2026-10-23	1.3100	1.3100	1.5900	191.0450	37335.00	0.00	37335.00	285	21	295	57	5.17543859649123	0.350645370397037	0.350645370397037	false	false	false	true	false
62b81619-1756-4470-9054-a6181b76e80d	2026-09-18 13:02	2026-09-18 13:02	2026-09-18 13:02	XOP	XOP261218P00180000	put	180.0000	2026-12-18	7.3000	6.9000	7.3000	190.8800	29200.00	29200.00	0.00	40	13	41	235	0.174468085106383	0.345427864369631	0.345427864369631	true	false	false	true	false
5c94f942-c0ef-43dc-aa05-1c2dd50b1892	2026-09-18 13:06	2026-09-18 13:06	2026-09-18 13:06	XOP	XOP261218P00180000	put	180.0000	2026-12-18	7.3000	6.9000	7.3000	190.8400	22630.00	22630.00	0.00	31	9	72	235	0.306382978723404	0.345056990713739	0.345056990713739	false	false	false	true	false
2e8a7689-dd5d-4d55-ad77-4ee1b6940863	2026-09-18 15:08	2026-09-18 15:08	2026-09-18 15:08	XOP	XOP261016C00193000	call	193.0000	2026-10-16	5.8000	5.8000	6.3500	191.0300	32480.00	0.00	32480.00	56	7	64	43	1.48837209302326	0.305414892293434	0.305414892293434	true	false	false	true	false
4b77182f-aff4-4e4c-abcf-fd03a82704c1	2026-09-18 15:34	2026-09-18 15:33	2026-09-18 15:33	XOP	XOP261218P00180000	put	180.0000	2026-12-18	7.3000	7.0500	7.3000	190.8600	17520.00	17520.00	0.00	24	12	136	235	0.578723404255319	0.345242463478673	0.345242463478673	false	false	false	true	false
b4270454-26f0-4b8b-9386-96463fe28491	2026-09-18 15:56	2026-09-18 15:55	2026-09-18 15:55	XOP	XOP261218P00180000	put	180.0000	2026-12-18	7.3000	6.6000	7.3000	190.0000	27740.00	27740.00	0.00	38	9	174	235	0.740425531914894	0.342918858738442	0.342918858738442	false	false	false	true	false
c4175278-f0c3-4170-bee7-d5a7c16eeb00	2026-09-21 10:24	2026-09-21 10:23	2026-09-21 10:23	XOP	XOP261016P00165000	put	165.0000	2026-10-16	0.6800	0.6700	0.8200	186.0000	12036.00	0.00	12036.00	177	25	225	25307	0.0088908207215395	0.35119693761588	0.35119693761588	false	false	false	true	false
89aaed97-0419-49ac-a11b-e765cb54feea	2026-09-21 10:35	2026-09-21 10:34	2026-09-21 10:34	XOP	XOP270319C00190000	call	190.0000	2027-03-19	16.6100	16.5000	17.9500	185.6900	66455.00	26575.00	39880.00	40	7	85	288	0.295138888888889	0.327394644952035	0.324172323615952	false	false	false	true	false
54e92c38-ee77-492a-84a5-ec54036b8f8d	2026-09-21 10:35	2026-09-21 10:34	2026-09-21 10:34	XOP	XOP270319C00180000	call	180.0000	2027-03-19	21.1900	21.1000	23.4000	185.7400	10593.00	4230.00	6363.00	5	5	6	812	0.00738916256157635	0.318085527040262	0.319890695824505	false	false	false	true	false
6dd65fa0-d7ef-47be-b604-4444d6e74c82	2026-09-21 10:47	2026-09-21 10:47	2026-09-21 10:47	XOP	XOP261016P00185000	put	185.0000	2026-10-16	5.9300	5.2500	6.0500	185.3200	11860.00	8310.00	3550.00	20	9	120	3053	0.0393056010481494	0.329156881797451	0.326561131646649	false	false	false	true	false
e1d77160-6d5e-42ff-8728-1992152e5d0c	2026-09-21 10:47	2026-09-21 10:47	2026-09-21 10:47	XOP	XOP261016P00196000	put	196.0000	2026-10-16	13.0000	12.5000	13.2000	185.0085	29900.00	28595.00	1305.00	23	7	23	138	0.166666666666667	0.325898741418253	0.328995637711141	true	false	false	true	false
e537e74e-acaa-4151-8f54-2eb9047daf69	2026-09-21 11:12	2026-09-21 11:12	2026-09-21 11:12	XOP	XOP260925P00175000	put	175.0000	2026-09-25	0.2500	0.2500	0.4300	185.0000	12500.00	0.00	8300.00	500	51	502	42	11.952380952381	0.386434904456919	0.386434904456919	false	false	false	true	false
4d1cda48-e07f-4268-9e11-d96d1d6ca574	2026-09-21 12:13	2026-09-21 12:13	2026-09-21 12:13	XOP	XOP261218P00185000	put	185.0000	2026-12-18	11.4500	11.4000	11.6500	184.6150	53815.00	41220.00	12595.00	47	8	57	3746	0.0152162306460224	0.338032938794881	0.338032938794881	false	false	false	true	false
ae6cd02f-49ad-47b8-ac86-457ad9ec5290	2026-09-21 12:32	2026-09-21 12:32	2026-09-21 12:32	XOP	XOP270319C00225000	call	225.0000	2027-03-19	5.8500	5.8000	6.1500	184.6700	12870.00	1170.00	11700.00	22	5	32	25	1.28	0.327906810569294	0.327906810569294	false	false	false	true	false
f530b6f0-e022-4be7-a133-ea54de3e110f	2026-09-21 13:15	2026-09-21 13:15	2026-09-21 13:15	XOP	XOP270115P00145000	put	145.0000	2027-01-15	1.6300	1.6300	1.7600	184.5300	13366.00	0.00	13366.00	82	19	82	250	0.328	0.358945603216268	0.358945603216268	false	false	false	true	false