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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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	expiry

81e7cf50-3f60-483d-80a4-b1407e065fed	2026-09-25 15:44	2026-09-25 15:44	2026-09-25 15:44	PBR	PBR261120C00021000	call	21.0000	2026-11-20	1.3600	1.3600	1.4400	20.0000	13600.00	0.00	13600.00	100	6	2951	144878	0.0203688620770579	0.486032810007653	0.486032810007653	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Energy	75799126626.00	2026-11-10	postmarket	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:44:21.808017Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
f7996f77-ca7f-423d-b5ba-67eee08020d5	2026-09-25 15:39	2026-09-25 15:39	2026-09-25 15:39	COP	COP261002C00127000	call	127.0000	2026-10-02	2.2600	2.2600	2.4400	127.0000	19679.00	0.00	19679.00	87	6	104	31	3.35483870967742	0.286480187447992	0.286480187447992	false	false	false
4b271d7b-dfa4-4baa-a2d7-8447c02ec99a	2026-09-25 15:39	2026-09-25 15:39	2026-09-25 15:39	CVX	CVX261002C00205000	call	205.0000	2026-10-02	2.6300	2.6300	2.7900	204.0000	34206.00	0.00	34206.00	130	8	415	754	0.550397877984085	0.251098761857946	0.252871297966741	false	false	false
eab40bac-631a-4a63-9ec2-341d3a74a34b	2026-09-25 15:35	2026-09-25 15:35	2026-09-25 15:35	PBR	PBR261030C00022000	call	22.0000	2026-10-30	0.8100	0.7600	0.8700	20.3950	74196.00	57510.00	16686.00	916	5	927	291	3.18556701030928	0.553274377160525	0.553274377160525	false	false	false
b699b6f0-2c98-4860-8f6d-07691cfcfb61	2026-09-25 15:31	2026-09-25 15:31	2026-09-25 15:31	XOM	XOM270115C00165000	call	165.0000	2027-01-15	8.6300	8.6000	8.8500	160.5900	129450.00	0.00	129450.00	150	2	191	5065	0.0377097729516288	0.27100251746253	0.27100251746253	false	true	false
d6e01b24-e204-43dd-a8ae-0c17b6557d36	2026-09-25 15:23	2026-09-25 15:23	2026-09-25 15:23	OKE	OKE261120P00085000	put	85.0000	2026-11-20	2.7500	2.6500	2.8000	88.5750	13200.00	13200.00	0.00	48	7	314	131	2.3969465648855	0.3341508836429	0.3341508836429	false	false	false
11dd5968-08b0-4870-a820-f63757b22a71	2026-09-25 15:20	2026-09-25 15:20	2026-09-25 15:20	SOC	SOC280121C00010000	call	10.0000	2028-01-21	0.7700	0.6100	0.7700	3.7950	15400.00	15400.00	0.00	200	29	457	7262	0.0629303222252823	1.00147420602472	1.00147420602472	false	false	false
5ecbba2e-fa52-4fde-890b-614169bc24c2	2026-09-25 15:20	2026-09-25 15:20	2026-09-25 15:20	FRO	FRO270521C00050000	call	50.0000	2027-05-21	5.4000	3.7000	5.4000	47.4800	27000.00	27000.00	0.00	50	6	90	0	0	0.38428468226792	0.38428468226792	false	false	false	true
7379129f-63fc-4dc8-8443-dd4d5fbc00b7	2026-09-25 15:20	2026-09-25 15:20	2026-09-25 15:20	COP	COP261016C00129000	call	129.0000	2026-10-16	3.1000	3.1000	3.2500	127.4900	10230.00	0.00	10230.00	33	14	66	63	1.04761904761905	0.299841589282965	0.299841589282965	true	false	false
f6e05429-e5c2-455f-833b-74032166fbb5	2026-09-25 15:18	2026-09-25 15:18	2026-09-25 15:18	XOM	XOM261016C00170000	call	170.0000	2026-10-16	1.2200	1.2200	1.2900	160.7100	27938.00	0.00	27938.00	229	13	1359	22666	0.0599576458131122	0.270557838580921	0.270557838580921	false	false	false
fd6a76fe-dbd4-49ca-bce2-279968096808	2026-09-25 15:16	2026-09-25 15:16	2026-09-25 15:16	ET	ET270115C00020000	call	20.0000	2027-01-15	0.9100	0.8500	0.9100	20.0950	24570.00	24570.00	0.00	270	6	3187	85365	0.0373338019094477	0.162800375501804	0.162800375501804	false	false	false
c040c936-d251-4c6b-9c20-f49492804d26	2026-09-25 15:15	2026-09-25 15:15	2026-09-25 15:15	XOM	XOM261002C00175000	call	175.0000	2026-10-02	0.0900	0.0500	0.0900	160.7100	85000.00	85000.00	0.00	10000	2	10104	755	13.3827814569536	0.319288173370335	0.319288173370335	false	true	false
84488a8c-6e8e-468a-a631-ac2733d70272	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	XOM	XOM261106P00160000	put	160.0000	2026-11-06	5.8000	5.3500	6.0500	160.6500	69600.00	58000.00	11600.00	120	8	142	8	17.75	0.299708255150096	0.299708255150096	false	false	false
200bb566-7a2c-4adc-b05d-cf3fcf35027b	2026-09-25 15:12	2026-09-25 15:12	2026-09-25 15:12	CVX	CVX261009P00195000	put	195.0000	2026-10-09	1.1000	0.9500	1.1300	204.5600	26949.00	26307.00	642.00	245	22	961	291	3.30240549828179	0.279934199012933	0.277376682121845	false	false	false
7d8dbce8-806c-4f51-bb72-cc1c90388b3a	2026-09-25 15:12	2026-09-25 15:12	2026-09-25 15:12	CVX	CVX261009P00195000	put	195.0000	2026-10-09	1.0900	1.0200	1.0900	204.5400	25155.00	23871.00	1284.00	231	17	695	291	2.38831615120275	0.278971537350077	0.277038039644509	false	false	false
90f1b073-6706-4b07-9317-ab2565557312	2026-09-25 15:12	2026-09-25 15:12	2026-09-25 15:12	CVX	CVX261009P00195000	put	195.0000	2026-10-09	1.0700	1.0000	1.1300	204.5350	22958.00	4613.00	8426.00	214	13	281	291	0.965635738831615	0.274007141702551	0.273052961944906	true	false	false
ee74ccf4-b28e-45eb-86b8-b84f862d2e95	2026-09-25 15:06	2026-09-25 15:06	2026-09-25 15:06	CVX	CVX261002C00220000	call	220.0000	2026-10-02	0.1300	0.0900	0.1200	204.0000	129897.00	129897.00	0.00	10000	18	10218	898	11.3786191536748	0.287996029224446	0.296769284355024	true	false	false
bb28dd2f-af7a-46e3-bec0-1171c41a4c94	2026-09-25 15:04	2026-09-25 15:04	2026-09-25 15:04	VLO	VLO260925C00387500	call	387.5000	2026-09-25	1.3500	0.2500	1.6000	386.0000	12680.00	12550.00	130.00	94	39	183	173	1.05780346820809	1.14474811991461	1.11249196648693	true	false	false
4a76a1da-e12f-4d57-b763-6656768ce57d	2026-09-25 15:01	2026-09-25 15:01	2026-09-25 15:01	NBR	NBR261016P00080000	put	80.0000	2026-10-16	3.1000	2.7500	3.2000	81.0000	15190.00	9300.00	5890.00	49	6	76	158	0.481012658227848	0.48395338125791	0.48395338125791	false	false	false
7f05a301-4119-4296-b288-c7cdb9c35530	2026-09-25 15:00	2026-09-25 15:00	2026-09-25 15:00	MPC	MPC261016C00420000	call	420.0000	2026-10-16	8.0000	7.3000	8.0000	392.0000	172000.00	172000.00	0.00	215	14	532	674	0.789317507418398	0.472123088850043	0.472123088850043	false	false	false
8674f54d-bd8b-45c0-8806-13dcd7875376	2026-09-25 14:59	2026-09-25 14:59	2026-09-25 14:59	MPC	MPC261218C00440000	call	440.0000	2026-12-18	21.1400	19.8000	21.4000	392.0000	71860.00	69750.00	2110.00	34	21	35	88	0.397727272727273	0.494197453644927	0.495600930043659	true	false	false
58eec470-4643-4b04-bd50-43cb005302c0	2026-09-25 14:59	2026-09-25 14:58	2026-09-25 14:58	OXY	OXY261218P00060000	put	60.0000	2026-12-18	5.3500	5.2500	5.4000	56.0000	32635.00	32100.00	0.00	61	11	76	3573	0.0212706409179961	0.351917116628411	0.351917116628411	false	false	false
9fb7d9f5-f67b-413a-bbec-ed67d9304b77	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	GLND	GLND261120C00006000	call	6.0000	2026-11-20	0.9900	0.9000	1.0000	5.0000	10019.00	10019.00	0.00	101	5	2148	1433	1.49895324494068	1.24195803634633	1.20795515425586	false	false	false
2b77cbd4-808d-4ea3-a7d1-0326ffd8fb4f	2026-09-25 14:58	2026-09-25 14:57	2026-09-25 14:57	PAA	PAA261120C00024000	call	24.0000	2026-11-20	0.8500	0.7000	0.9500	24.0000	15210.00	15125.00	85.00	179	16	180	10152	0.0177304964539007	0.168770998511091	0.168770998511091	true	false	false
250577a1-e3c5-4a1e-a0ed-e16db05ac657	2026-09-25 14:55	2026-09-25 14:55	2026-09-25 14:55	VLO	VLO261002P00370000	put	370.0000	2026-10-02	5.9300	4.9000	6.3000	383.0000	148325.00	148325.00	0.00	250	28	317	233	1.36051502145923	0.563191507795179	0.563191507795179	false	false	false
a23f7f77-919f-4e19-969d-ac7523c26ff8	2026-09-25 14:54	2026-09-25 14:54	2026-09-25 14:54	OXY	OXY261120C00065000	call	65.0000	2026-11-20	0.8000	0.7800	0.8000	56.0000	18320.00	18320.00	0.00	229	7	275	7358	0.0373742864908943	0.355519093060341	0.355519093060341	false	false	false
b2218cad-8cbe-4f48-be0a-3fdffd6e7be2	2026-09-25 14:53	2026-09-25 14:53	2026-09-25 14:53	VLO	VLO260925C00385000	call	385.0000	2026-09-25	1.6500	0.2000	1.9000	385.0000	15009.00	14844.00	165.00	91	26	431	477	0.90356394129979	1.05302706781201	0.938012845872961	true	false	false
d2dcece5-4780-4fba-9c94-2a443f981ad5	2026-09-25 14:50	2026-09-25 14:50	2026-09-25 14:50	VLO	VLO261218C00380000	call	380.0000	2026-12-18	41.0600	38.6000	41.2000	383.0000	20530.00	16420.00	0.00	5	5	14	817	0.0171358629130967	0.514823781478642	0.516213888869244	false	false	false
afaabf67-c2c3-40a5-9475-3e635d65d10f	2026-09-25 14:42	2026-09-25 14:42	2026-09-25 14:42	CLMT	CLMT290119P00050000	put	50.0000	2029-01-19	14.6000	14.3000	15.0000	53.0100	14600.00	5840.00	8760.00	10	5	40	45	0.888888888888889	0.649677573192089	0.649677573192089	false	false	false
bdfdddf8-0f7b-4f95-aa54-db5c8bdb6149	2026-09-25 14:37	2026-09-25 14:37	2026-09-25 14:37	NGL	NGL270115C00020000	call	20.0000	2027-01-15	0.5500	0.4500	0.5500	15.1700	11000.00	8800.00	0.00	200	8	200	1118	0.178890876565295	0.551884312896256	0.545495123983994	false	false	false
4dfcbd0f-6915-4ed4-831d-cb9178613048	2026-09-25 14:36	2026-09-25 14:36	2026-09-25 14:36	HAL	HAL261016C00032000	call	32.0000	2026-10-16	1.3200	1.3200	1.3400	32.4520	24948.00	0.00	24948.00	189	10	485	2646	0.183295540438398	0.336427641846128	0.336427641846128	true	false	false
f673e7f2-a772-46d2-8b88-37fee4c8c406	2026-09-25 14:35	2026-09-25 14:35	2026-09-25 14:35	XOM	XOM270319C00180000	call	180.0000	2027-03-19	6.3400	6.1000	6.5500	160.3300	36138.00	36138.00	0.00	57	5	261	3065	0.0851549755301794	0.275177634290022	0.275177634290022	false	false	false
b6c2f321-e531-4929-bf62-67b07a9b6a6e	2026-09-25 14:35	2026-09-25 14:34	2026-09-25 14:34	PBR	PBR261009P00019500	put	19.5000	2026-10-09	0.4900	0.4600	0.5000	20.3750	17003.00	16905.00	0.00	347	44	474	769	0.616384915474642	0.558332934126991	0.558332934126991	true	false	false
9f88b5cf-a4cc-44a4-b819-41153b97b272	2026-09-25 14:29	2026-09-25 14:28	2026-09-25 14:28	OKE	OKE261120P00085000	put	85.0000	2026-11-20	2.8500	2.8000	2.8500	88.2600	64692.00	64692.00	0.00	227	52	247	131	1.88549618320611	0.333621106225883	0.333621106225883	false	false	false
29cadd53-dc14-49d0-9a12-68c47d48a510	2026-09-25 14:28	2026-09-25 14:28	2026-09-25 14:28	VLO	VLO261023C00400000	call	400.0000	2026-10-23	13.9600	13.9000	14.5000	379.2025	180068.00	0.00	180068.00	129	14	505	512	0.986328125	0.524638225456529	0.520424220153231	false	false	false
3dadfd0d-d27d-4935-88fe-51ad7640a69a	2026-09-25 14:28	2026-09-25 14:28	2026-09-25 14:28	GLND	GLND261016C00005000	call	5.0000	2026-10-16	1.0000	1.0000	1.1500	5.5700	15800.00	0.00	15800.00	158	9	4382	2743	1.59752096244987	1.33213871200866	1.33213871200866	false	false	false
401c38a5-e2db-47e4-b179-321689cbcc7d	2026-09-25 14:26	2026-09-25 14:26	2026-09-25 14:26	VLO	VLO260925P00385000	put	385.0000	2026-09-25	5.0000	4.1000	5.4000	380.3250	10000.00	10000.00	0.00	20	19	311	395	0.787341772151899	0.86430525358645	0.86430525358645	false	false	false
b0726c32-97cb-4544-949e-0a76fdd4aa35	2026-09-25 14:24	2026-09-25 14:24	2026-09-25 14:24	WMB	WMB270115P00065000	put	65.0000	2027-01-15	2.4500	2.3500	2.4500	69.0800	56595.00	56595.00	0.00	231	21	240	6168	0.0389105058365759	0.305794656143165	0.305794656143165	false	false	false
f2cee417-7dc6-4493-a75c-8d38cffd7936	2026-09-25 14:23	2026-09-25 14:23	2026-09-25 14:23	XOM	XOM270319P00160000	put	160.0000	2027-03-19	12.1900	12.0000	12.4000	160.4300	71921.00	0.00	71921.00	59	5	77	1336	0.0576347305389222	0.319679377316743	0.319679377316743	false	false	false
22b4d110-9369-4820-9014-08e55d1bd71a	2026-09-25 14:22	2026-09-25 14:22	2026-09-25 14:22	PR	PR261016P00023000	put	23.0000	2026-10-16	1.7500	1.7500	1.9500	21.3750	350000.00	0.00	350000.00	2000	2	2000	2647	0.755572346052135	0.330639415213473	0.330639415213473	false	true	true
2a4accae-db61-45eb-af8e-cd839a2bb3d1	2026-09-25 14:21	2026-09-25 14:21	2026-09-25 14:21	KMI	KMI261218P00031000	put	31.0000	2026-12-18	1.6400	1.6000	1.6400	30.6600	79704.00	79704.00	0.00	486	26	486	2005	0.242394014962594	0.27618371661374	0.27618371661374	false	false	false
35fc5232-e8da-4b62-b916-6a0835769648	2026-09-25 14:20	2026-09-25 14:20	2026-09-25 14:20	XOM	XOM270319C00200000	call	200.0000	2027-03-19	2.7300	2.7300	2.9300	160.3100	11193.00	0.00	11193.00	41	8	99	10867	0.00911014999539891	0.281436007033126	0.281896027954934	false	false	false
99372c13-3814-464f-9e32-eefa6f808055	2026-09-25 14:13	2026-09-25 14:13	2026-09-25 14:13	VLO	VLO261002P00380000	put	380.0000	2026-10-02	11.0000	10.4000	11.0000	379.5000	102300.00	102300.00	0.00	93	25	122	144	0.847222222222222	0.519645682057409	0.519645682057409	false	false	false
13b51aa5-a502-4e63-9ed8-d71c293f55f2	2026-09-25 14:13	2026-09-25 14:13	2026-09-25 14:13	VLO	VLO261002P00377500	put	377.5000	2026-10-02	9.8000	9.1000	9.8000	379.5000	51940.00	51940.00	0.00	53	18	58	73	0.794520547945205	0.521895270607886	0.521895270607886	false	false	false
8445cfb4-8d7a-4997-bd9d-efdabee49725	2026-09-25 14:06	2026-09-25 14:06	2026-09-25 14:06	GLND	GLND261120C00006000	call	6.0000	2026-11-20	0.7500	0.7500	0.8000	5.0000	13275.00	0.00	13275.00	177	9	1820	1433	1.27006280530356	1.0784093219329	1.0784093219329	false	false	false
d3d24653-51c7-43f0-bf06-bdeb79b9dd7f	2026-09-25 14:06	2026-09-25 14:06	2026-09-25 14:06	PSX	PSX261002C00245000	call	245.0000	2026-10-02	10.7000	10.5000	10.7000	252.0000	44940.00	44940.00	0.00	42	13	43	11	3.90909090909091	0.438926980761256	0.438926980761256	false	false	false
aaae27b2-c80a-439e-97f5-57bd01eaa6be	2026-09-25 14:06	2026-09-25 14:06	2026-09-25 14:06	PSX	PSX261009P00260000	put	260.0000	2026-10-09	11.9600	11.4000	12.0000	252.0000	35880.00	22790.00	13090.00	30	9	39	100	0.39	0.395200460317785	0.395200460317785	false	false	false
b78a7cbc-974c-486c-a0b0-68899f3fc71a	2026-09-25 14:06	2026-09-25 14:06	2026-09-25 14:06	MPC	MPC261120C00370000	call	370.0000	2026-11-20	40.7000	40.7000	41.0000	386.0000	370370.00	0.00	44770.00	91	6	95	8	11.875	0.511164281044585	0.511164281044585	true	false	false
4f352002-8d99-4eb7-9329-35b2ddedbc05	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	PSX	PSX260925P00265000	put	265.0000	2026-09-25	12.1000	11.8000	12.1000	252.0000	67760.00	67760.00	0.00	56	8	70	73	0.958904109589041	1.3834909263578	1.3834909263578	true	false	false
e62ec295-fa34-4c0d-bd47-7530e20972ce	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	MPC	MPC261016C00370000	call	370.0000	2026-10-16	28.0000	28.0000	28.3000	387.0000	117600.00	0.00	117600.00	42	6	45	448	0.100446428571429	0.501502759675454	0.480411210048731	true	false	false