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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

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

ceff17b0-6968-4c8c-9526-b86269f30d35	2026-09-01 11:44	2026-09-01 11:44	2026-09-01 11:44	XOP	XOP260904P00202500	put	202.5000	2026-09-04	12.0000	10.9500	12.0000	190.6400	19200.00	19200.00	0.00	16	8	38	0	0	0.429707231798941	0.429707231798941	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-01T15:45:30.323966Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e7e32b31-c81e-4f35-bac3-56184064b968	2026-09-01 11:02	2026-09-01 11:02	2026-09-01 11:02	XOP	XOP260904P00202500	put	202.5000	2026-09-04	11.4000	11.1000	13.4500	191.1700	12540.00	0.00	12540.00	11	5	22	0	0	0.379004822992206	0.379004822992206	false	false	false	true	false
4a917631-0490-4c74-bca7-c257962640c1	2026-09-01 10:01	2026-09-01 10:01	2026-09-01 10:01	XOP	XOP260925C00190000	call	190.0000	2026-09-25	5.9700	5.8500	6.4000	190.3600	20905.00	3000.00	17905.00	35	5	47	78	0.602564102564103	0.278973397634168	0.286712683640755	true	false	false	true	false
07777f5c-10b0-46ce-8682-b3c2b0d531d5	2026-08-31 14:42	2026-08-31 14:42	2026-08-31 14:42	XOP	XOP260904C00187500	call	187.5000	2026-09-04	2.2300	2.2300	2.7300	186.7700	39255.00	0.00	39255.00	176	18	543	22	24.6818181818182	0.326666564007027	0.325379901781855	true	false	false	true	false
215e8269-cb28-41e2-b70f-5d5118ef1a9e	2026-08-31 13:38	2026-08-31 13:38	2026-08-31 13:38	XOP	XOP281215P00138000	put	138.0000	2028-12-15	10.5100	8.6000	10.6500	187.4800	19975.00	17855.00	2120.00	19	6	54	273	0.197802197802198	0.345447062242867	0.346908749968775	true	false	false	true	false
68c1390b-5dfa-42b4-8bd3-949bc647b545	2026-08-31 10:42	2026-08-31 10:42	2026-08-31 10:42	XOP	XOP270319P00185000	put	185.0000	2027-03-19	15.4500	15.4500	15.7000	187.3400	52530.00	0.00	52530.00	34	10	45	2	22.5	0.335870434911762	0.335870434911762	false	false	false	true	false
81c6e4fe-4afe-4a20-98a2-4e59a822f5b0	2026-08-31 10:03	2026-08-31 10:03	2026-08-31 10:03	XOP	XOP281215P00119000	put	119.0000	2028-12-15	6.2500	4.5500	6.2500	188.6400	18125.00	18125.00	0.00	29	6	29	0	0	0.356643658798395	0.356643658798395	false	false	false	true	false
5d7e7934-1375-4cf0-a9ca-264922053fd5	2026-08-31 10:03	2026-08-31 10:03	2026-08-31 10:03	XOP	XOP281215P00121000	put	121.0000	2028-12-15	6.6800	4.8500	6.7000	188.6400	26725.00	24760.00	1965.00	40	7	40	0	0	0.356949413403308	0.355041436842194	false	false	false	true	false
d7135338-18f4-4c94-a8df-d298b830fa87	2026-08-28 13:51	2026-08-28 13:51	2026-08-28 13:51	XOP	XOP261218P00170000	put	170.0000	2026-12-18	5.7500	5.7500	6.0000	186.1100	25875.00	0.00	25875.00	45	6	135	3257	0.0414491863678232	0.328542997524712	0.328542997524712	false	false	false	true	false
9176c571-365e-4138-9b49-1f7732cbe787	2026-08-28 09:57	2026-08-28 09:57	2026-08-28 09:57	XOP	XOP261218P00170000	put	170.0000	2026-12-18	5.7500	5.7500	5.9000	185.9400	42550.00	0.00	42550.00	74	10	74	3257	0.0227202947497697	0.327227772799027	0.327227772799027	false	false	false	true	false
1c53e787-ad21-4882-8515-d1e96e84c6cc	2026-08-27 15:18	2026-08-27 15:18	2026-08-27 15:18	XOP	XOP261016P00182000	put	182.0000	2026-10-16	6.4000	6.4000	6.5000	185.0000	439723.00	0.00	439723.00	687	20	1626	0	0	0.315738091861917	0.315738091861917	false	false	false	true	false
b0210c53-ea04-4250-a0c5-f7f1a8a91657	2026-08-27 15:06	2026-08-27 15:06	2026-08-27 15:06	XOP	XOP260918P00175000	put	175.0000	2026-09-18	1.5800	1.5300	1.5800	185.6650	15958.00	15958.00	0.00	101	5	250	2228	0.112208258527828	0.30643744988012	0.30643744988012	false	false	false	true	false
4d2ca86b-6692-4fa8-9da0-5bfa55fc82ee	2026-08-27 15:06	2026-08-27 15:06	2026-08-27 15:06	XOP	XOP260918P00175000	put	175.0000	2026-09-18	1.5800	1.4700	1.5900	185.6300	17064.00	11850.00	1264.00	108	6	149	2228	0.0668761220825853	0.305892581325202	0.305892581325202	false	false	false	true	false
5f3d1c19-ee74-458d-8345-8f04ce832ac8	2026-08-27 15:00	2026-08-27 15:00	2026-08-27 15:00	XOP	XOP260904C00192000	call	192.0000	2026-09-04	1.0400	1.0400	1.2700	185.5400	32136.00	0.00	32136.00	309	31	323	2	161.5	0.293354271214623	0.293354271214623	false	false	false	true	false
19b0f62c-26b3-4811-9071-336793d6027f	2026-08-27 12:36	2026-08-27 12:36	2026-08-27 12:36	XOP	XOP260911P00178000	put	178.0000	2026-09-11	1.9200	1.9200	2.5500	183.9300	10563.00	0.00	10563.00	55	6	63	479	0.131524008350731	0.29650934512484	0.297314433821043	false	false	false	true	false
081a2b16-fd86-4d42-9640-f4d183db2c1d	2026-08-27 12:32	2026-08-27 12:32	2026-08-27 12:32	XOP	XOP261016P00182000	put	182.0000	2026-10-16	7.3500	7.0000	7.5500	183.5600	391755.00	18375.00	373380.00	533	12	928	0	0	0.317591992406105	0.317591992406105	false	false	false	true	false
457fce92-ba4c-47a4-967e-b0738bbdd053	2026-08-27 11:34	2026-08-27 11:34	2026-08-27 11:34	XOP	XOP270115P00185000	put	185.0000	2027-01-15	14.9000	14.0500	14.9000	182.9600	67050.00	67050.00	0.00	45	21	132	280	0.471428571428571	0.338006889386878	0.338006889386878	false	false	false	true	false
1b71254b-541c-48b0-b103-5dd59fd0c9e1	2026-08-27 11:25	2026-08-27 11:25	2026-08-27 11:25	XOP	XOP260904C00185000	call	185.0000	2026-09-04	2.4300	1.8800	2.4300	182.7700	11907.00	11907.00	0.00	49	6	52	81	0.641975308641975	0.31014550581889	0.31014550581889	false	false	false	true	false
b43c83fa-8832-43db-a973-4133083313c0	2026-08-27 11:09	2026-08-27 11:09	2026-08-27 11:09	XOP	XOP261016P00178000	put	178.0000	2026-10-16	6.2000	6.1000	6.5500	182.2300	296360.00	620.00	295740.00	478	64	650	3	216.666666666667	0.321792444772661	0.321792444772661	false	false	false	true	false
0334e802-946b-4f73-9313-3d0aa6a9e8c1	2026-08-27 11:09	2026-08-27 11:09	2026-08-27 11:09	XOP	XOP261016P00182000	put	182.0000	2026-10-16	8.1500	8.1000	8.7000	182.2300	13040.00	0.00	13040.00	16	10	319	0	0	0.325504778359518	0.325504778359518	true	false	false	true	false
e619677f-2ac0-4cb8-9e59-c823018a0929	2026-08-27 11:08	2026-08-27 11:08	2026-08-27 11:08	XOP	XOP261016P00178000	put	178.0000	2026-10-16	6.3000	6.1500	6.3000	182.0800	14490.00	6300.00	0.00	23	5	148	3	49.3333333333333	0.323443197525418	0.323443197525418	false	false	false	true	false
bd8f323e-560f-48c1-a312-b25bda33db5e	2026-08-27 11:06	2026-08-27 11:05	2026-08-27 11:05	XOP	XOP261016P00178000	put	178.0000	2026-10-16	6.3000	5.2500	6.3000	181.9750	14490.00	6300.00	0.00	23	6	23	3	7.66666666666667	0.321871565698906	0.321871565698906	false	false	false	true	false
da0a91b4-0455-404c-80df-2df70742dcaa	2026-08-27 11:03	2026-08-27 11:03	2026-08-27 11:03	XOP	XOP261016P00182000	put	182.0000	2026-10-16	8.3500	8.3500	8.4000	182.0100	214595.00	0.00	214595.00	257	29	263	0	0	0.329228728712689	0.329228728712689	false	false	false	true	false
24f58845-dd39-4052-bc5e-ee8b519f6f26	2026-08-27 10:49	2026-08-27 10:49	2026-08-27 10:49	XOP	XOP260918P00182000	put	182.0000	2026-09-18	5.1600	4.9000	5.2000	182.2450	12894.00	7750.00	5144.00	25	10	35	23	1.52173913043478	0.307321354401083	0.310132869279467	true	false	false	true	false
77469796-ec02-4de9-993c-fb5eb73d4f08	2026-08-27 10:45	2026-08-27 10:45	2026-08-27 10:45	XOP	XOP260918C00200000	call	200.0000	2026-09-18	0.8600	0.8600	1.1300	182.4600	23392.00	0.00	23392.00	272	32	277	4622	0.0599307659022068	0.31049374579829	0.31049374579829	true	false	false	true	false
767aa6ce-ef64-4dfc-b53e-af85209d1151	2026-08-27 10:45	2026-08-27 10:45	2026-08-27 10:45	XOP	XOP260918C00198000	call	198.0000	2026-09-18	1.1100	1.1000	1.8600	182.4600	73927.00	0.00	73704.00	666	60	666	3	222	0.310362442039764	0.310362442039764	false	false	false	true	false
3918e3eb-1f22-44bf-8c0e-c124823a9411	2026-08-27 10:44	2026-08-27 10:44	2026-08-27 10:44	XOP	XOP260918C00194000	call	194.0000	2026-09-18	1.7900	1.7900	1.9800	182.4950	202092.00	0.00	201912.00	1129	41	2453	2	1226.5	0.30916081335312	0.30916081335312	true	false	false	true	false
a42ea9e1-94bd-409c-af50-143ed4a50c40	2026-08-27 10:39	2026-08-27 10:38	2026-08-27 10:38	XOP	XOP270115P00185000	put	185.0000	2027-01-15	15.3500	13.9500	15.3500	182.8800	66005.00	66005.00	0.00	43	14	87	280	0.310714285714286	0.347205539680632	0.347205539680632	false	false	false	true	false
d887ac1c-14b1-473e-a6b2-d152e86aab18	2026-08-27 10:35	2026-08-27 10:34	2026-08-27 10:34	XOP	XOP260904P00184000	put	184.0000	2026-09-04	4.1500	3.4500	4.1500	182.5700	68060.00	68060.00	0.00	164	24	164	14	11.7142857142857	0.32111335061503	0.32111335061503	true	false	false	true	false
2a6e7f0d-95e8-43f1-9746-3c0418bff2c2	2026-08-27 10:27	2026-08-27 10:27	2026-08-27 10:27	XOP	XOP260918C00194000	call	194.0000	2026-09-18	1.9400	1.8800	2.0600	183.1500	253364.00	582.00	252782.00	1306	22	1316	2	658	0.308756933438568	0.308756933438568	false	false	false	true	false
a1d51998-6fb6-4e17-a727-f36aa8d1ab97	2026-08-27 10:12	2026-08-27 10:11	2026-08-27 10:11	XOP	XOP260918C00190000	call	190.0000	2026-09-18	2.8500	2.8500	3.0500	182.6650	79230.00	0.00	79230.00	278	41	278	3950	0.070379746835443	0.309596196012864	0.309596196012864	false	false	false	true	false
a9b02a4c-ae53-42ad-b16a-849ea9aada19	2026-08-27 09:38	2026-08-27 09:38	2026-08-27 09:38	XOP	XOP260904P00176000	put	176.0000	2026-09-04	0.8700	0.7500	1.5000	184.4600	126717.00	0.00	126717.00	1463	14	1463	2631	0.556062333713417	0.351484449693466	0.351484449693466	false	false	false	true	false
68b580e5-a2b3-4808-bf4f-8f43cc4a726e	2026-08-26 15:36	2026-08-26 15:36	2026-08-26 15:36	XOP	XOP270319C00180000	call	180.0000	2027-03-19	20.6500	20.3000	20.6500	184.2500	33040.00	33040.00	0.00	16	10	38	3504	0.0108447488584475	0.301263885355272	0.301263885355272	false	false	false	true	false
f09b88be-8092-4080-be8a-5ac31a602294	2026-08-26 14:50	2026-08-26 14:50	2026-08-26 14:50	XOP	XOP270319C00180000	call	180.0000	2027-03-19	20.6500	20.3000	20.6500	184.3650	33040.00	33040.00	0.00	16	5	22	3504	0.00627853881278539	0.299892932325114	0.299892932325114	false	false	false	true	false
9e388b5f-6cd9-4b1e-8cf0-753e7707a42e	2026-08-26 14:34	2026-08-26 14:34	2026-08-26 14:34	XOP	XOP260925P00183000	put	183.0000	2026-09-25	6.0000	5.3000	6.2000	184.6300	16200.00	13800.00	2400.00	27	11	33	0	0	0.335755520924779	0.335755520924779	true	false	false	true	false
2dfb674c-12cf-4d49-a08e-84316e95137d	2026-08-26 14:34	2026-08-26 14:33	2026-08-26 14:33	XOP	XOP260925P00184000	put	184.0000	2026-09-25	6.4500	5.7000	6.4500	184.6300	19995.00	19995.00	0.00	31	13	31	0	0	0.334355962583975	0.334355962583975	true	false	false	true	false
f663d3a1-f5f0-4bd4-b15c-7c5d0747ed66	2026-08-26 14:21	2026-08-26 14:21	2026-08-26 14:21	XOP	XOP260828C00185000	call	185.0000	2026-08-28	1.9000	1.9000	1.9800	184.8550	148200.00	0.00	148200.00	780	23	859	399	2.15288220551378	0.357636635065417	0.357636635065417	false	false	false	true	false
6fee5646-a1ea-4600-a1fd-2b84bb0d918d	2026-08-26 14:07	2026-08-26 14:07	2026-08-26 14:07	XOP	XOP260828C00195000	call	195.0000	2026-08-28	0.0900	0.0900	0.1600	185.1400	14706.00	0.00	14706.00	1634	28	3772	1482	2.54520917678812	0.398336445864217	0.398336445864217	false	false	false	true	false
bf02c0df-7b9d-48c1-8a25-5b37f2b3aee6	2026-08-26 12:48	2026-08-26 12:48	2026-08-26 12:48	XOP	XOP260828C00195000	call	195.0000	2026-08-28	0.1200	0.1000	0.1900	185.7000	14088.00	204.00	13884.00	1174	27	2116	1482	1.42780026990553	0.401289779884479	0.401289779884479	false	false	false	true	false
41337e53-faa6-43e9-9466-a00606287bf9	2026-08-26 12:26	2026-08-26 12:26	2026-08-26 12:26	XOP	XOP260828C00195000	call	195.0000	2026-08-28	0.1300	0.1300	0.1900	186.1800	11076.00	0.00	11076.00	852	53	941	1482	0.634952766531714	0.390631517832185	0.390631517832185	false	false	false	true	false
805a4b5d-cb9d-40d1-b1f7-1f0883e93ade	2026-08-26 12:15	2026-08-26 12:15	2026-08-26 12:15	XOP	XOP270115C00200000	call	200.0000	2027-01-15	9.8000	9.4500	9.8500	186.0300	38215.00	8820.00	29395.00	39	5	43	1670	0.025748502994012	0.307285862191391	0.307285862191391	false	false	false	true	false
daec872e-832d-47cd-bb1a-524c47a2c907	2026-08-26 12:04	2026-08-26 12:03	2026-08-26 12:03	XOP	XOP260904C00189000	call	189.0000	2026-09-04	2.5700	2.5700	2.6900	185.8400	73502.00	0.00	73502.00	286	12	286	5	57.2	0.330721731350753	0.330721731350753	false	false	false	true	false
f328c1f4-8a1a-415f-a84b-f44c006315a2	2026-08-26 11:55	2026-08-26 11:55	2026-08-26 11:55	XOP	XOP260904C00187000	call	187.0000	2026-09-04	3.1500	2.1500	3.1500	185.0100	21085.00	21085.00	0.00	67	18	67	3	22.3333333333333	0.342813253896601	0.338446471905418	false	false	false	true	false
6396ef62-55c0-4d1b-92b5-b7b7861bf29e	2026-08-26 11:42	2026-08-26 11:42	2026-08-26 11:42	XOP	XOP260828P00179000	put	179.0000	2026-08-28	0.4200	0.4200	0.5300	184.2250	21882.00	0.00	21882.00	521	38	544	585	0.92991452991453	0.385801777872419	0.385801777872419	false	false	false	true	false
dfebec75-9a58-414c-96bf-96283a2ee9d3	2026-08-25 15:58	2026-08-25 15:58	2026-08-25 15:58	XOP	XOP260904P00176000	put	176.0000	2026-09-04	1.6900	1.0900	1.6900	182.9800	128824.00	128824.00	0.00	763	23	2633	64	41.140625	0.364699357426114	0.365749979058343	true	false	false	true	false
7bef139f-74c0-4771-a315-d0e9cbfb290d	2026-08-25 15:58	2026-08-25 15:58	2026-08-25 15:58	XOP	XOP260918P00180000	put	180.0000	2026-09-18	4.5000	3.9500	4.5000	183.1600	326700.00	326700.00	0.00	726	43	797	8188	0.0973375671714704	0.330303089327295	0.330845346695872	false	false	false	true	false
816c902a-9321-447e-a0db-aae3ae686aac	2026-08-25 15:58	2026-08-25 15:58	2026-08-25 15:58	XOP	XOP260918P00182500	put	182.5000	2026-09-18	5.6000	5.6000	5.6500	183.0200	29680.00	0.00	29680.00	53	19	78	0	0	0.325417272947245	0.325417272947245	true	false	false	true	false
c8aa2410-7210-4d11-9bae-3b5ea2b1a8e4	2026-08-25 15:58	2026-08-25 15:57	2026-08-25 15:57	XOP	XOP260828P00179000	put	179.0000	2026-08-28	0.9600	0.9500	0.9600	183.0500	12960.00	12960.00	0.00	135	33	703	4	175.75	0.380925515314597	0.380925515314597	false	false	false	true	false
9105dea6-131c-4a8c-9c83-ddaa7c1871d2	2026-08-25 15:57	2026-08-25 15:57	2026-08-25 15:57	XOP	XOP260904P00175000	put	175.0000	2026-09-04	1.4000	1.4000	2.0000	183.1150	35140.00	0.00	35140.00	251	5	6339	34	186.441176470588	0.367815775195749	0.367815775195749	true	false	false	true	false
e3ea71a4-c4e1-43ad-9eeb-127b1447769e	2026-08-25 15:57	2026-08-25 15:57	2026-08-25 15:57	XOP	XOP260904P00175000	put	175.0000	2026-09-04	1.3500	1.1500	1.4700	183.1600	674788.00	106885.00	33978.00	5007	37	6088	34	179.058823529412	0.363214403354591	0.356313093298098	true	false	false	true	false