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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×sector = Energy×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

ada45986-ed86-446f-b3f4-3ca3b952886b	2026-09-24 10:13	2026-09-24 10:13	2026-09-24 10:13	PBR	PBR270115C00026000	call	26.0000	2027-01-15	0.6500	0.6100	0.6500	21.3250	15210.00	15210.00	0.00	234	19	234	203	1.15270935960591	0.416113341866848	0.416113341866848	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Energy	78664385708.00	2026-11-10	postmarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T14:14:26.159357Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
cfaa53e5-7fc2-4fa3-9339-4ac970d8ca25	2026-09-24 10:13	2026-09-24 10:13	2026-09-24 10:13	WFRD	WFRD270416P00080000	put	80.0000	2027-04-16	7.4000	6.6000	7.8000	84.6650	33300.00	19240.00	14060.00	45	5	45	45	1	0.430243891746675	0.430243891746675	false	false	false	true
e278ba59-c886-4534-a48b-eab10ef3eb5c	2026-09-24 10:12	2026-09-24 10:12	2026-09-24 10:12	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7500	1.9000	89.1600	27737.00	27377.00	360.00	154	7	2979	13788	0.216057441253264	0.419949392452041	0.420103134407521	true	false	false	true
9cb19591-b5ec-4252-9120-81246634f603	2026-09-24 10:12	2026-09-24 10:12	2026-09-24 10:12	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7800	1.8000	89.2200	10800.00	10800.00	0.00	60	5	2796	13788	0.202785030461271	0.421117804696029	0.421117804696029	false	false	false	true
d4e896bb-1474-450d-9a27-d9a643a37d27	2026-09-24 10:11	2026-09-24 10:11	2026-09-24 10:11	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8500	1.7900	1.8500	89.1000	11470.00	11470.00	0.00	62	6	2422	13788	0.175659994197853	0.423033279953437	0.423033279953437	false	false	false	true
2f0001be-9217-4866-9ac6-a26c0768a2d2	2026-09-24 10:08	2026-09-24 10:08	2026-09-24 10:08	EXE	EXE261120C00085000	call	85.0000	2026-11-20	5.2000	5.2000	6.1000	86.2300	52000.00	0.00	39000.00	100	13	100	332	0.301204819277108	0.316474593551387	0.316474593551387	false	false	false	true
cb86a424-3c4d-41ca-8225-db9e566c4d0b	2026-09-24 10:06	2026-09-24 10:06	2026-09-24 10:06	LNG	LNG261016C00287500	call	287.5000	2026-10-16	6.3000	6.3000	6.8000	277.6950	25200.00	0.00	25200.00	40	11	171	1	171	0.369738184213021	0.369738184213021	true	false	false	true
115d8b82-a7bc-4fe7-98e8-e764e047f154	2026-09-24 10:04	2026-09-24 10:04	2026-09-24 10:04	XOM	XOM261120P00165000	put	165.0000	2026-11-20	8.4100	8.2500	8.5000	163.3800	21865.00	3380.00	845.00	26	6	34	1044	0.0325670498084291	0.316593644577533	0.316593644577533	false	false	false	true
ddf1cc51-5b0a-4d98-9126-f5c04c1db329	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	SHEL	SHEL261218C00100000	call	100.0000	2026-12-18	3.2000	3.1000	3.3000	96.5850	24960.00	24640.00	320.00	78	5	165	3508	0.0470353477765108	0.229141285236529	0.229141285236529	false	false	false	true
47726a2e-1739-4281-bd43-951ebb7c6033	2026-09-24 09:59	2026-09-24 09:59	2026-09-24 09:59	SHEL	SHEL261218C00095000	call	95.0000	2026-12-18	5.5000	5.5000	5.6000	96.5750	11000.00	0.00	11000.00	20	9	22	1746	0.0126002290950745	0.22525978362923	0.22525978362923	true	false	false	true
ccccb893-8061-4092-af49-50a4f00b154a	2026-09-24 09:57	2026-09-24 09:57	2026-09-24 09:57	APA	APA261016C00042500	call	42.5000	2026-10-16	3.1000	2.8800	3.2500	44.4300	30070.00	310.00	29760.00	97	5	101	3956	0.025530839231547	0.450645542658576	0.450645542658576	false	false	false	true
d317f09a-5416-48aa-933b-6b33f5f2204c	2026-09-24 09:56	2026-09-24 09:56	2026-09-24 09:56	XOM	XOM261016P00172500	put	172.5000	2026-10-16	10.0000	9.5000	11.2500	163.8800	23000.00	3000.00	20000.00	23	5	23	50	0.46	0.293567937609449	0.293567937609449	false	false	false	true
ba9f1d05-cd5d-4271-a9ef-da3d99868d2f	2026-09-24 09:55	2026-09-24 09:55	2026-09-24 09:55	XOM	XOM260925C00160000	call	160.0000	2026-09-25	4.1300	3.9000	4.3500	163.7500	12390.00	12390.00	0.00	30	6	108	1189	0.0908326324642557	0.467842000310885	0.467842000310885	false	false	false	true
fa4a6150-de92-43a0-9a86-1673c380c45d	2026-09-24 09:51	2026-09-24 09:51	2026-09-24 09:51	BP	BP260925C00045500	call	45.5000	2026-09-25	0.3800	0.3000	0.4700	45.4700	19000.00	3800.00	15200.00	500	8	504	939	0.536741214057508	0.413156048805395	0.413156048805395	false	false	false	true
b3bfd880-1e4e-43c4-af70-a39359106ecf	2026-09-24 09:46	2026-09-24 09:46	2026-09-24 09:46	SU	SU270115C00070000	call	70.0000	2027-01-15	4.7000	4.2000	4.7000	69.3500	172960.00	172960.00	0.00	368	23	368	3518	0.104604889141558	0.297203449129898	0.297203449129898	false	false	false	true
f4aabd4b-cd07-4a72-960b-076c64c2c293	2026-09-24 09:46	2026-09-24 09:46	2026-09-24 09:46	CLMT	CLMT271217P00035000	put	35.0000	2027-12-17	4.6000	4.3000	4.9000	55.0100	11500.00	0.00	9200.00	25	6	25	226	0.110619469026549	0.681946992943073	0.681946992943073	false	false	false	true
db0c85ec-4838-4b3e-a264-7ed5062a63dd	2026-09-24 09:46	2026-09-24 09:46	2026-09-24 09:46	APA	APA261002C00047000	call	47.0000	2026-10-02	0.3900	0.1900	0.4700	44.2800	31395.00	1170.00	30225.00	805	18	825	160	5.15625	0.489631813169391	0.489631813169391	false	false	false	true
4dd32d71-8a74-41fa-96d0-a5ed03c3c15e	2026-09-24 09:44	2026-09-24 09:44	2026-09-24 09:44	SHEL	SHEL270319C00090000	call	90.0000	2027-03-19	10.6000	9.9000	10.7000	96.5350	39220.00	25440.00	13780.00	37	11	37	337	0.109792284866469	0.21154638451738	0.21154638451738	false	false	false	true
6bbbeaf9-83be-47cb-a37b-993251129007	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	CNQ	CNQ261016C00050000	call	50.0000	2026-10-16	0.7500	0.6500	0.7500	48.2400	12825.00	12825.00	0.00	171	24	171	687	0.248908296943231	0.296040707950744	0.296040707950744	false	false	false	true
2ce13927-9b28-418d-b069-dd6e7e8a8ee3	2026-09-24 09:41	2026-09-24 09:41	2026-09-24 09:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6100	1.5900	1.6900	90.0300	11592.00	9660.00	1932.00	72	5	2068	13788	0.149985494633014	0.426036664997892	0.426036664997892	true	false	false	true
08b76fcf-669d-438a-b593-0986e5c7b06b	2026-09-24 09:41	2026-09-24 09:41	2026-09-24 09:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.5700	1.6700	90.0300	31231.00	23711.00	7520.00	195	14	1881	13788	0.136422976501305	0.424657308638253	0.426036664997892	true	false	false	true
a73f6367-eb09-4c8f-a470-156020a38a7c	2026-09-24 09:41	2026-09-24 09:41	2026-09-24 09:41	XOM	XOM261002C00165000	call	165.0000	2026-10-02	2.3300	2.2800	2.4300	163.6100	18600.00	4931.00	9280.00	80	6	206	1714	0.120186697782964	0.299038998475869	0.29799250268316	true	false	false	true
7f8be3a1-5e8d-45c3-9098-8670f472b3a8	2026-09-24 09:40	2026-09-24 09:40	2026-09-24 09:40	XOM	XOM260925P00162500	put	162.5000	2026-09-25	0.9700	0.8100	0.9700	163.7750	14550.00	14550.00	0.00	150	17	172	645	0.266666666666667	0.449253615016665	0.449253615016665	false	false	false	true
5908f621-9fd2-44a7-9352-921506c29924	2026-09-24 09:38	2026-09-24 09:38	2026-09-24 09:38	STNG	STNG261016P00080000	put	80.0000	2026-10-16	2.6000	2.0000	2.8000	80.7850	26520.00	26520.00	0.00	102	24	102	634	0.160883280757098	0.389728635278137	0.389728635278137	false	false	false	true
9c58071b-b912-4ae6-8da2-347ea27b9ab2	2026-09-24 09:38	2026-09-24 09:38	2026-09-24 09:38	WFRD	WFRD261016C00080000	call	80.0000	2026-10-16	5.8000	5.4000	6.6000	83.6200	15080.00	7540.00	7540.00	26	9	45	45	1	0.447024526236964	0.447024526236964	false	false	false	true
54abc708-2d3c-4dfc-9aed-546414d69e72	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.5200	1.6000	90.2000	18080.00	18080.00	0.00	113	7	1282	13788	0.0929794023788802	0.430859688274142	0.430859688274142	false	false	false	true
a8eff127-564e-4e80-a099-03246f6b042f	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	SHEL	SHEL270319C00087500	call	87.5000	2027-03-19	12.1000	11.6000	12.2000	96.2300	15730.00	15730.00	0.00	13	5	13	394	0.032994923857868	0.208136210493997	0.208136210493997	false	false	false	true
d6854a42-cd0e-4bbb-8aac-617e6e50fc02	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6500	1.6000	1.7100	89.9500	12375.00	9735.00	2640.00	75	12	967	13788	0.0701334493762692	0.428588399716794	0.428588399716794	true	false	false	true
5859c465-71dc-42e4-acaf-7359bbe37677	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	BP	BP280121C00050000	call	50.0000	2028-01-21	4.2500	4.0500	4.2500	45.1000	17425.00	17425.00	0.00	41	6	41	4255	0.00963572267920094	0.241857422729777	0.241857422729777	false	false	false	true
7fbb3e27-d5e0-435c-981d-2cafa072835a	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.5000	1.6400	90.3600	17600.00	16000.00	640.00	110	16	705	13788	0.0511314186248912	0.436651680858952	0.436651680858952	true	false	false	true
d7599df9-1518-4789-8967-823c32ad3724	2026-09-24 09:35	2026-09-24 09:35	2026-09-24 09:35	XOM	XOM261016C00155000	call	155.0000	2026-10-16	10.0000	9.7500	10.0000	162.8900	15000.00	15000.00	0.00	15	5	196	9247	0.0211960635881908	0.307169121326966	0.307169121326966	false	false	false	true
b8c56a26-0000-4a02-a900-e91fb02abaf3	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.5000	1.6000	90.2650	18080.00	18080.00	0.00	113	7	595	13788	0.0431534667827096	0.433217938228747	0.433217938228747	false	false	false	true
a058e0cb-5734-4bd5-ac39-38f53f3e0f1c	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	XOM	XOM261016C00155000	call	155.0000	2026-10-16	9.4400	9.1500	9.9500	162.3525	11333.00	0.00	11333.00	12	7	145	9247	0.0156807613279983	0.295830296735842	0.29015123212769	false	false	false	true
ee8f134a-fb34-42e1-a965-84222b7abf69	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.4900	1.6000	90.4699	10080.00	10080.00	0.00	63	5	481	13788	0.0348854076008123	0.440605117889087	0.440605117889087	false	false	false	true
9f8b0f52-4c63-497a-8d93-9b8199d7affd	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.4900	1.6000	90.4699	10240.00	10240.00	0.00	64	8	418	13788	0.0303162170002901	0.440605117889087	0.440605117889087	false	false	false	true
a9794ceb-0ab7-46c7-b094-a728339424a4	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3500	1.3500	1.3900	43.7500	49815.00	0.00	49815.00	369	13	1589	1312	1.21112804878049	0.453205791199614	0.453205791199614	true	false	false	true
e630a69f-ad14-4fda-a041-ada50587b5b2	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3400	1.3400	1.3500	43.7450	16348.00	0.00	16348.00	122	17	1085	1312	0.826981707317073	0.450346865445716	0.450346865445716	true	false	false	true
7d55b6b2-8fac-49a6-b90a-ba1726b5375e	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3300	1.3300	1.3500	43.7500	24472.00	0.00	24472.00	184	10	855	1312	0.651676829268293	0.448377732451776	0.448377732451776	true	false	false	true
4a0401e6-9c79-478b-b852-aa1b8e15627f	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3400	1.3400	1.3500	43.7450	14472.00	0.00	14472.00	108	16	963	1312	0.733993902439024	0.450346865445716	0.450346865445716	true	false	false	true
df1bf284-42c4-4f8a-a35e-357604b5d5ae	2026-09-23 15:52	2026-09-23 15:52	2026-09-23 15:52	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3000	1.2600	1.3600	43.8050	63180.00	0.00	63180.00	486	10	668	1312	0.509146341463415	0.44599171673138	0.44599171673138	false	false	false	true
f991f401-e312-4c50-893f-ccf6c2f28b2a	2026-09-23 15:49	2026-09-23 15:49	2026-09-23 15:49	COP	COP261120P00120000	put	120.0000	2026-11-20	3.2000	3.1000	3.2000	128.1500	15360.00	15360.00	0.00	48	16	310	617	0.502431118314425	0.343308921394176	0.343308921394176	false	false	false	true
1735a0e5-5101-4dcb-b8a0-080e3e2b9b84	2026-09-23 15:46	2026-09-23 15:45	2026-09-23 15:45	UUUU	UUUU260925P00011500	put	11.5000	2026-09-25	0.2200	0.1900	0.2400	11.0000	27698.00	22.00	27676.00	1259	18	1546	2706	0.571322985957132	0.830028702920385	0.830028702920385	false	false	false	true
ad114d77-7f87-4eb5-bdf6-e6aa4e0910a1	2026-09-23 15:44	2026-09-23 15:44	2026-09-23 15:44	CVX	CVX260925C00205000	call	205.0000	2026-09-25	2.0900	2.0900	2.2200	205.0000	55385.00	0.00	55385.00	265	38	637	642	0.992211838006231	0.319286889897177	0.319286889897177	false	false	false	true
c1c05817-0fda-4406-af37-b8c5e185058f	2026-09-23 15:42	2026-09-23 15:42	2026-09-23 15:42	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.0000	4.0000	4.1000	91.3200	10400.00	0.00	10400.00	26	12	873	3093	0.282250242483026	0.484261555229801	0.484261555229801	false	false	false	true
139dee0a-6f4f-4ffc-9ba4-f1cd542a2da8	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	XOM	XOM261016P00145000	put	145.0000	2026-10-16	0.4500	0.4500	0.5000	161.1450	20790.00	0.00	20790.00	462	39	595	9286	0.0640749515399526	0.31064082300174	0.31064082300174	false	false	false	true
7304c9be-dbdb-40fa-b06e-82b45d60e071	2026-09-23 15:38	2026-09-23 15:38	2026-09-23 15:38	WMB	WMB261120C00075000	call	75.0000	2026-11-20	2.2000	2.1500	2.2500	71.3150	32780.00	0.00	24860.00	149	7	1158	2631	0.440136830102623	0.308472674198919	0.308472674198919	false	false	false	true
a4a94e7b-0a14-459d-87ac-c87e420f817b	2026-09-23 15:38	2026-09-23 15:37	2026-09-23 15:37	WMB	WMB261120C00075000	call	75.0000	2026-11-20	2.2000	2.1000	2.2500	71.2800	16500.00	5940.00	0.00	75	19	887	2631	0.337134169517294	0.309709402959595	0.309709402959595	true	false	false	true
31192452-396e-43ba-99d9-423bef1314bd	2026-09-23 15:38	2026-09-23 15:37	2026-09-23 15:37	WMB	WMB261120C00075000	call	75.0000	2026-11-20	2.2000	2.1000	2.2000	71.2800	26840.00	26840.00	0.00	122	13	1009	2631	0.383504370961612	0.309709402959595	0.309709402959595	true	false	false	true
36a25341-c825-4356-9024-b3921c86ab47	2026-09-23 15:34	2026-09-23 15:34	2026-09-23 15:34	VLO	VLO260925P00355000	put	355.0000	2026-09-25	1.2500	1.2500	2.0000	376.6400	55752.00	0.00	55752.00	446	64	1590	675	2.35555555555556	0.711416527494722	0.711416527494722	false	false	false	true
65d3872b-7eca-4c4e-af80-495800b0e93e	2026-09-23 15:33	2026-09-23 15:33	2026-09-23 15:33	CVX	CVX270115C00230000	call	230.0000	2027-01-15	4.4500	4.3000	4.4500	205.1500	18690.00	18690.00	0.00	42	10	291	5296	0.0549471299093656	0.258438999446795	0.258438999446795	false	false	false	true