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×

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

63d80976-3deb-4f4d-b6ef-069d7d327a93	2026-08-21 11:54	2026-08-21 11:53	2026-08-21 11:53	XOP	XOP260925C00192500	call	192.5000	2026-09-25	6.1000	5.0500	6.1000	189.2850	12200.00	12200.00	0.00	20	7	20	0	0	0.309789996892319	0.309789996892319	true	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-08-21T15:55:19.311132Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4571c23a-fce5-42d8-81b8-a396ce1cf0a8	2026-08-21 11:53	2026-08-21 11:53	2026-08-21 11:53	XOP	XOP260925C00190000	call	190.0000	2026-09-25	7.1500	5.6000	7.1500	189.2850	32890.00	32890.00	0.00	46	19	46	3	15.3333333333333	0.306412385906663	0.306412385906663	true	false	false	true	false
1eb4240e-7d73-4332-a9be-e01d7cb4f546	2026-08-21 11:35	2026-08-21 11:35	2026-08-21 11:35	XOP	XOP260918P00190000	put	190.0000	2026-09-18	6.9000	6.9000	7.3500	189.0000	15180.00	0.00	15180.00	22	7	87	362	0.240331491712707	0.319315361202107	0.319315361202107	false	false	false	true	false
6aaca9da-7d36-4c68-99eb-265bcec6bc28	2026-08-21 11:07	2026-08-21 11:07	2026-08-21 11:07	XOP	XOP260828C00186000	call	186.0000	2026-08-28	4.3000	4.3000	5.3000	187.9500	53750.00	0.00	53750.00	125	9	125	14	8.92857142857143	0.304876581866265	0.304876581866265	true	false	false	true	false
1de4a030-27d9-497e-adff-29903c8d8794	2026-08-21 10:49	2026-08-21 10:49	2026-08-21 10:49	XOP	XOP260904C00205000	call	205.0000	2026-09-04	0.7500	0.6000	1.0900	188.4200	18225.00	0.00	18225.00	243	9	243	6	40.5	0.351218015118942	0.351218015118942	true	false	false	true	false
c0ee756f-800f-4e50-b4a7-a4ec08d0db8d	2026-08-21 10:38	2026-08-21 10:38	2026-08-21 10:38	XOP	XOP260918C00220000	call	220.0000	2026-09-18	0.5500	0.5500	0.7500	188.4300	11660.00	0.00	11660.00	212	10	212	4200	0.0504761904761905	0.358359772744995	0.358359772744995	false	false	false	true	false
8f28b1f9-e306-4dc7-b787-5125e34ac23d	2026-08-21 10:19	2026-08-21 10:18	2026-08-21 10:18	XOP	XOP260904P00170000	put	170.0000	2026-09-04	0.4000	0.2100	0.6400	188.4800	11203.00	43.00	11160.00	280	27	280	20016	0.0139888089528377	0.363653579116614	0.369862064603738	true	false	false	true	false
5e22857d-7c72-4f90-a3d5-9f66dd3d11e5	2026-08-21 10:14	2026-08-21 10:14	2026-08-21 10:14	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.2000	3.0500	3.2500	188.5600	10880.00	2880.00	2240.00	34	6	94	7468	0.0125870380289234	0.334534341930651	0.334534341930651	true	false	false	true	false
49cc3017-7eac-488f-8826-e32b72962e75	2026-08-20 15:51	2026-08-20 15:51	2026-08-20 15:51	XOP	XOP260925C00188000	call	188.0000	2026-09-25	7.4000	6.6000	7.5500	187.5850	24415.00	23675.00	740.00	33	15	33	0	0	0.309009166439874	0.309009166439874	false	false	false	true	false
ef5dfb42-9bae-47bd-a1e5-b53d63a51faf	2026-08-20 15:20	2026-08-20 15:20	2026-08-20 15:20	XOP	XOP261016P00190000	put	190.0000	2026-10-16	11.1500	11.0500	11.1500	187.0900	15610.00	15610.00	0.00	14	11	25	86	0.290697674418605	0.345592046712974	0.345592046712974	false	false	false	true	false
4426fa61-9af1-4693-8a28-166ab6a5801f	2026-08-20 15:07	2026-08-20 15:07	2026-08-20 15:07	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.7500	3.6500	3.7500	186.8600	28125.00	28125.00	0.00	75	17	3341	4325	0.772485549132948	0.331303837736142	0.331303837736142	true	false	false	true	false
2b5534aa-a5ba-4022-bfae-1770509abfdc	2026-08-20 15:07	2026-08-20 15:07	2026-08-20 15:07	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.7500	3.6500	3.7500	186.8600	11625.00	11625.00	0.00	31	8	3266	4325	0.75514450867052	0.331303837736142	0.331303837736142	true	false	false	true	false
9a5e4542-568c-4980-8639-924af28f69b8	2026-08-20 13:16	2026-08-20 13:15	2026-08-20 13:15	XOP	XOP281215P00170000	put	170.0000	2028-12-15	21.8900	19.5500	21.9000	187.5700	45975.00	43795.00	2180.00	21	5	21	2004	0.0104790419161677	0.353255768101993	0.352114110197892	false	false	false	true	false
0cccde7a-418e-4c0a-ad3e-d99d8b26a536	2026-08-20 13:07	2026-08-20 13:07	2026-08-20 13:07	XOP	XOP270115P00195000	put	195.0000	2027-01-15	18.8000	18.8000	19.0500	187.8500	45120.00	0.00	45120.00	24	6	42	61	0.688524590163934	0.346758726456812	0.346758726456812	false	false	false	true	false
ff2ef096-edd5-4d51-a095-60d97e2cdddc	2026-08-20 13:01	2026-08-20 13:01	2026-08-20 13:01	XOP	XOP260828C00190000	call	190.0000	2026-08-28	2.5500	2.2700	3.1500	187.8500	63750.00	7395.00	3825.00	250	19	266	166	1.60240963855422	0.309834421672701	0.309834421672701	false	false	false	true	false
ec430de1-d6b0-4279-83b5-ee485b897e37	2026-08-20 12:33	2026-08-20 12:33	2026-08-20 12:33	XOP	XOP261218P00190000	put	190.0000	2026-12-18	13.8500	12.9500	13.8500	188.6500	18005.00	18005.00	0.00	13	6	13	19	0.684210526315789	0.33451903834917	0.33451903834917	false	false	false	true	false
c8ce11d8-bc1b-4af4-aebe-e9ecded873c2	2026-08-20 12:32	2026-08-20 12:32	2026-08-20 12:32	XOP	XOP261218P00195000	put	195.0000	2026-12-18	16.6500	15.6500	16.6500	188.7050	19980.00	19980.00	0.00	12	5	12	68	0.176470588235294	0.336727981629054	0.336727981629054	false	false	false	true	false
dcf2a855-dd15-4a45-b555-13f8c5a0bd8d	2026-08-20 11:21	2026-08-20 11:21	2026-08-20 11:21	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.1000	3.1000	3.1500	188.9300	310000.00	0.00	310000.00	1000	10	2314	4325	0.535028901734104	0.329118570612228	0.329118570612228	false	false	false	true	false
57d1a7c3-3193-4651-9449-51ed5fa5436d	2026-08-20 11:20	2026-08-20 11:20	2026-08-20 11:20	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.1000	2.8600	3.1000	188.8700	380934.00	380934.00	0.00	1229	68	1301	4325	0.300809248554913	0.328190918229441	0.328190918229441	false	false	false	true	false
e8f1917f-63fe-4512-b6c0-017666042464	2026-08-20 11:10	2026-08-20 11:10	2026-08-20 11:10	XOP	XOP260821P00190000	put	190.0000	2026-08-21	1.7800	1.2700	1.7800	189.5900	23140.00	23140.00	0.00	130	14	132	101	1.30693069306931	0.397968954029598	0.397968954029598	false	false	false	true	false
c1365419-fffd-4032-b795-be462ee0da84	2026-08-20 09:51	2026-08-20 09:51	2026-08-20 09:51	XOP	XOP260918C00170000	call	170.0000	2026-09-18	21.5000	21.0000	22.3000	190.0700	107500.00	51600.00	6450.00	50	31	50	7562	0.00661200740544829	0.334738018177994	0.334738018177994	false	false	false	true	false
e76f5e61-453f-42fd-8c91-4cd3221d53f8	2026-08-20 09:44	2026-08-20 09:44	2026-08-20 09:44	XOP	XOP260918P00190000	put	190.0000	2026-09-18	6.3000	6.0000	6.3000	190.5050	134186.00	134186.00	0.00	213	35	218	121	1.80165289256198	0.319515706436539	0.319515706436539	false	false	false	true	false
e9962cba-9900-4214-8cb5-23c49acdfd11	2026-08-19 15:43	2026-08-19 15:43	2026-08-19 15:43	XOP	XOP260918P00185000	put	185.0000	2026-09-18	5.8500	5.2500	5.8500	185.8400	18720.00	18720.00	0.00	32	14	85	351	0.242165242165242	0.308618283217988	0.308618283217988	false	false	false	true	false
1e2e0afb-681e-463c-a7c9-497d253c7f51	2026-08-19 15:09	2026-08-19 15:09	2026-08-19 15:09	XOP	XOP260904P00170000	put	170.0000	2026-09-04	0.7300	0.0300	1.0000	186.3900	730000.00	730000.00	0.00	10000	1	10000	9	1111.11111111111	0.366107859253869	0.366107859253869	false	true	false	true	true
0a94e91f-6045-4f2e-b452-9504e246d3cc	2026-08-19 14:32	2026-08-19 14:31	2026-08-19 14:31	XOP	XOP260821C00187000	call	187.0000	2026-08-21	1.4700	1.4700	1.6300	186.3600	13083.00	0.00	13083.00	89	27	101	325	0.310769230769231	0.318253678095941	0.318253678095941	false	false	false	true	false
fbcabea9-bcdc-49a6-93b1-2c50fdd85c41	2026-08-19 13:51	2026-08-19 13:51	2026-08-19 13:51	XOP	XOP260918P00180000	put	180.0000	2026-09-18	3.6000	3.5000	3.6500	186.9250	36000.00	28800.00	6480.00	100	13	208	4242	0.049033474776049	0.319278101760917	0.319278101760917	false	false	false	true	false
5a831a65-7ab3-4c37-8ef4-9da1589f51a0	2026-08-19 13:07	2026-08-19 13:07	2026-08-19 13:07	XOP	XOP260918P00175000	put	175.0000	2026-09-18	2.0600	2.0600	2.1200	187.4100	238754.00	0.00	238754.00	1159	16	1214	2431	0.499382969971205	0.319894236575161	0.319894236575161	false	false	false	true	false
989019a8-da0d-4c72-a301-c599a417794b	2026-08-19 12:47	2026-08-19 12:47	2026-08-19 12:47	XOP	XOP260821C00180000	call	180.0000	2026-08-21	7.2000	6.8000	7.7000	186.8300	37440.00	0.00	37440.00	52	6	55	4833	0.0113800951789779	0.426003796041276	0.426003796041276	false	false	false	true	false
e80a5197-c2ca-4698-89f5-901f66792d1b	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	XOP	XOP261016C00175000	call	175.0000	2026-10-16	16.9000	15.5500	16.9000	187.1500	89570.00	89570.00	0.00	53	5	63	810	0.0777777777777778	0.305280532906057	0.305280532906057	false	false	false	true	false
8f252f7b-8bc6-4e03-aee3-ec42868fd160	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	XOP	XOP260918P00170000	put	170.0000	2026-09-18	1.2800	1.2800	1.4400	187.0400	13568.00	0.00	13568.00	106	21	127	5530	0.0229656419529837	0.328945572885383	0.328945572885383	false	false	false	true	false
fd09e2da-c5d9-4163-9554-2376fe815063	2026-08-19 10:54	2026-08-19 10:53	2026-08-19 10:53	XOP	XOP261016P00185000	put	185.0000	2026-10-16	8.4800	8.3500	8.8500	186.8650	15260.00	4235.00	11025.00	18	5	32	18	1.77777777777778	0.336793784907049	0.335081511134913	true	false	false	true	false
18df4a9c-07c1-42f6-af18-d1a0eb0d5a11	2026-08-19 10:50	2026-08-19 10:50	2026-08-19 10:50	XOP	XOP261016P00190000	put	190.0000	2026-10-16	10.9500	10.9500	11.5000	187.1699	49275.00	0.00	49275.00	45	12	45	15	3	0.337644679686563	0.337644679686563	false	false	false	true	false
c2719a57-df91-4c6b-858f-912254b16b9f	2026-08-19 10:36	2026-08-19 10:36	2026-08-19 10:36	XOP	XOP260918C00190000	call	190.0000	2026-09-18	5.8000	5.5000	5.8000	187.6300	28415.00	27840.00	575.00	49	5	182	3445	0.0528301886792453	0.30863266681922	0.30863266681922	false	false	false	true	false
6ab79d1f-e637-4fca-b8f6-943a2fc83356	2026-08-19 10:30	2026-08-19 10:30	2026-08-19 10:30	XOP	XOP270319P00195000	put	195.0000	2027-03-19	21.6000	21.3000	21.6000	187.1000	140400.00	140400.00	0.00	65	13	69	3	23	0.346546971473689	0.346546971473689	false	false	false	true	false
5b82a358-61f0-4999-98c4-639f8c71496c	2026-08-19 10:28	2026-08-19 10:28	2026-08-19 10:28	XOP	XOP260918C00190000	call	190.0000	2026-09-18	5.8000	5.3000	5.8500	187.3900	11600.00	11600.00	0.00	20	10	112	3445	0.032510885341074	0.313935498287141	0.313935498287141	false	false	false	true	false
f3cb5b75-ca46-4d47-b88f-77097b6a1128	2026-08-19 10:28	2026-08-19 10:27	2026-08-19 10:27	XOP	XOP270115P00200000	put	200.0000	2027-01-15	22.0500	22.0500	23.7500	187.4200	50715.00	0.00	50715.00	23	6	23	3	7.66666666666667	0.346778178843985	0.346778178843985	false	false	false	true	false
af240f82-82be-4a19-9c0d-500b8e23ce1c	2026-08-19 10:16	2026-08-19 10:15	2026-08-19 10:15	XOP	XOP260918C00190000	call	190.0000	2026-09-18	5.5000	5.2500	5.7500	186.7900	18150.00	15400.00	2750.00	33	11	79	3445	0.0229317851959361	0.31290027476913	0.31290027476913	true	false	false	true	false
f95f847f-d963-4bf5-b215-68742e87a47e	2026-08-19 10:02	2026-08-19 10:02	2026-08-19 10:02	XOP	XOP270319C00190000	call	190.0000	2027-03-19	17.2500	16.5500	18.1000	186.3800	177675.00	98325.00	79350.00	103	7	103	11	9.36363636363636	0.299134497087571	0.299134497087571	false	false	false	true	false
0a89023b-006c-4fc9-abc8-4fbe15e08508	2026-08-19 09:53	2026-08-19 09:53	2026-08-19 09:53	XOP	XOP261016C00180000	call	180.0000	2026-10-16	13.3000	12.0500	13.3000	186.6700	14630.00	14630.00	0.00	11	5	12	1808	0.00663716814159292	0.305941558633501	0.305941558633501	false	false	false	true	false
65237e3b-8241-4fce-b130-902845b9bdff	2026-08-18 15:40	2026-08-18 15:40	2026-08-18 15:40	XOP	XOP270115P00175000	put	175.0000	2027-01-15	9.7600	9.7500	10.7000	185.2600	47835.00	5880.00	41955.00	49	6	49	2598	0.018860662047729	0.338050467625003	0.339216012193078	false	false	false	true	false
68dc95f5-46ef-4aef-8336-40a68b757039	2026-08-18 15:37	2026-08-18 15:37	2026-08-18 15:37	XOP	XOP261218P00175000	put	175.0000	2026-12-18	8.3600	8.3000	8.9000	185.1100	14206.00	1671.00	12535.00	17	9	21	552	0.0380434782608696	0.331493557851846	0.330529748686463	true	false	false	true	false
a9346ebd-1817-4a70-8902-e511608f4df3	2026-08-18 15:28	2026-08-18 15:28	2026-08-18 15:28	XOP	XOP261016P00175000	put	175.0000	2026-10-16	5.0500	5.0500	5.4000	184.8400	21715.00	0.00	21715.00	43	8	85	647	0.131375579598145	0.331588895427497	0.331588895427497	false	false	false	true	false
c1972cb7-c1f5-4508-a955-a092aeda3e8a	2026-08-18 12:21	2026-08-18 12:21	2026-08-18 12:21	XOP	XOP270115P00185000	put	185.0000	2027-01-15	14.8000	14.4500	14.8000	184.7400	25160.00	25160.00	0.00	17	14	74	176	0.420454545454545	0.344486016486976	0.344486016486976	false	false	false	true	false
4cc8ce86-d900-44cc-b0fe-786e7a18c723	2026-08-18 12:21	2026-08-18 12:21	2026-08-18 12:21	XOP	XOP270115P00185000	put	185.0000	2027-01-15	14.7500	14.4500	14.8000	184.7400	10325.00	8850.00	1475.00	7	6	57	176	0.323863636363636	0.343410937358305	0.343410937358305	false	false	false	true	false
2959dcb1-db90-4628-aea3-3302df5bb959	2026-08-18 11:28	2026-08-18 11:27	2026-08-18 11:27	XOP	XOP260918P00185000	put	185.0000	2026-09-18	6.9000	6.7000	6.9000	184.3200	24150.00	24150.00	0.00	35	10	51	277	0.184115523465704	0.320140513844155	0.320140513844155	false	false	false	true	false
532599bb-bdf9-43d7-ba16-0c3c91af7a01	2026-08-18 10:25	2026-08-18 10:25	2026-08-18 10:25	XOP	XOP260918C00190000	call	190.0000	2026-09-18	4.6500	3.9500	4.7000	184.3600	28810.00	28360.00	450.00	62	7	125	3363	0.0371691941718704	0.316426606800409	0.318829910934915	true	false	false	true	false
450b9555-be0f-4886-8720-9468ccfb02ec	2026-08-18 10:22	2026-08-18 10:22	2026-08-18 10:22	XOP	XOP260918P00180000	put	180.0000	2026-09-18	4.7000	4.5000	4.7000	184.1400	69530.00	69530.00	0.00	148	31	1804	743	2.42799461641992	0.321993373156745	0.321993373156745	false	false	false	true	false
1d5a34fb-4429-4faa-afdc-ba394a723b01	2026-08-18 10:21	2026-08-18 10:21	2026-08-18 10:21	XOP	XOP260918P00180000	put	180.0000	2026-09-18	4.6500	4.6500	4.7000	184.0200	93930.00	0.00	93930.00	202	5	1436	743	1.93270524899058	0.317325830070857	0.317325830070857	true	false	false	true	false
c538bab4-abfa-4077-b15c-fe634d2534bd	2026-08-18 10:21	2026-08-18 10:20	2026-08-18 10:20	XOP	XOP260918P00180000	put	180.0000	2026-09-18	4.6000	4.5500	4.8000	183.9000	503700.00	373520.00	73600.00	1095	10	1098	743	1.47779273216689	0.312652493976055	0.312652493976055	true	false	false	true	false
2e11f864-e85f-4cad-a87a-43a063dd51d9	2026-08-18 09:48	2026-08-18 09:48	2026-08-18 09:48	XOP	XOP260918C00185000	call	185.0000	2026-09-18	5.7000	5.7000	6.6500	182.0000	11400.00	0.00	11400.00	20	7	22	1096	0.0200729927007299	0.305847281230465	0.305847281230465	false	false	false	true	false