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

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	false	false	LowHistoricVolumeFloor	b356ec2b-92e1-458a-934a-7719f71c40bc	1	Common Stock	Energy	17890218139.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T18:27:02.000981Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
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
d3452340-d228-4c71-be1e-02337e21ffd5	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	VLO	VLO261009C00370000	call	370.0000	2026-10-09	19.9000	19.9000	21.5000	377.0000	49750.00	0.00	49750.00	25	10	128	21	6.09523809523809	0.525599661890213	0.525599661890213	false	false	false
a8d6d113-49ac-479a-b3f6-a6bbb122d2c0	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	MPC	MPC261016P00410000	put	410.0000	2026-10-16	31.4900	31.3000	31.6000	386.0000	488030.00	18960.00	184670.00	155	34	157	725	0.216551724137931	0.464831300634754	0.464831300634754	false	false	false
9459b3f8-c1c0-456d-bd30-fce836503d44	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	MPC	MPC261016P00440000	put	440.0000	2026-10-16	55.4500	55.4000	55.7000	386.0000	138620.00	22280.00	116340.00	25	9	29	125	0.232	0.459384430430129	0.459384430430129	false	false	false
8b4e12e5-0c5d-4382-964b-167827b5a97a	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	MPC	MPC261120P00430000	put	430.0000	2026-11-20	57.0000	55.6000	57.0000	387.0000	142500.00	142500.00	0.00	25	6	25	36	0.694444444444444	0.513220533188376	0.525278191308781	true	false	false
7c0f82d1-5d28-430d-a1e2-2169e2199c64	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	MPC	MPC261016P00430000	put	430.0000	2026-10-16	46.9000	46.9000	47.2000	386.0000	253267.00	0.00	253267.00	54	15	55	285	0.192982456140351	0.465062800664826	0.465062800664826	false	false	false
4afbb2fc-da31-4048-a634-63cf25a69f3f	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	VLO	VLO261002C00357500	call	357.5000	2026-10-02	24.1000	24.1000	25.5000	377.0000	36150.00	0.00	36150.00	15	7	15	0	0	0.508673537704412	0.508673537704412	false	false	false	true
134d20c6-1be9-46d1-9f1a-cde0011f22e9	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	DINO	DINO261016C00092500	call	92.5000	2026-10-16	13.4300	13.3000	13.8000	104.0000	173304.00	71544.00	101760.00	129	20	129	6	21.5	0.609128276401477	0.604188238960699	false	false	false
12471bbf-0832-4cd4-b17d-5adc044d99e2	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	DINO	DINO261120P00115000	put	115.0000	2026-11-20	15.9000	15.9000	16.0000	104.0000	41340.00	0.00	41340.00	26	8	26	3	8.66666666666667	0.590219560387358	0.590219560387358	false	false	false
00166f11-6f76-4e8c-8383-915f7addee31	2026-09-25 14:04	2026-09-25 14:04	2026-09-25 14:04	VLO	VLO261009C00370000	call	370.0000	2026-10-09	19.9000	18.1000	20.2000	378.0000	199000.00	19900.00	179100.00	100	10	103	21	4.90476190476191	0.515954878583396	0.515954878583396	false	false	false
b4778570-d134-4b37-b9ce-1a2525f7f707	2026-09-25 14:03	2026-09-25 14:03	2026-09-25 14:03	CVE	CVE261218C00038000	call	38.0000	2026-12-18	0.4000	0.4000	0.6000	30.0000	12120.00	0.00	12120.00	303	6	303	260	1.16538461538462	0.37704319890552	0.37704319890552	false	false	false
5b156772-2551-400f-b347-5cd1b58f59df	2026-09-25 14:00	2026-09-25 14:00	2026-09-25 14:00	XOM	XOM261023C00175000	call	175.0000	2026-10-23	0.8700	0.8700	0.9000	160.0000	11411.00	1232.00	10179.00	131	13	431	742	0.580862533692722	0.27882485832887	0.277827184900838	true	false	false
5b3ede7d-ec42-42d2-966d-a44d3e171f6e	2026-09-25 13:59	2026-09-25 13:59	2026-09-25 13:59	LEU	LEU261120P00130000	put	130.0000	2026-11-20	9.2000	8.5000	9.4000	147.2400	202400.00	920.00	201480.00	220	8	226	18	12.5555555555556	0.777538203506222	0.777538203506222	false	false	false
e1150420-ff18-42e2-ab03-f42bd5901f39	2026-09-25 13:57	2026-09-25 13:57	2026-09-25 13:57	XOM	XOM270115C00170000	call	170.0000	2027-01-15	6.5500	6.4500	6.7500	160.1450	63535.00	23580.00	39955.00	97	32	99	7277	0.0136045073519307	0.273367363086988	0.273367363086988	false	false	false
e7d6f914-7fe5-4162-a2f2-a00262ffb812	2026-09-25 13:56	2026-09-25 13:56	2026-09-25 13:56	CVX	CVX261218P00195000	put	195.0000	2026-12-18	6.7500	6.5000	6.7500	203.6050	265943.00	265943.00	0.00	394	34	421	1071	0.393090569561158	0.296060372907268	0.296060372907268	false	false	false
a3c0a9b3-1623-47c4-8cb6-fdd217a9676a	2026-09-25 13:56	2026-09-25 13:56	2026-09-25 13:56	CVX	CVX261218P00200000	put	200.0000	2026-12-18	8.8000	8.5500	8.8000	203.6050	793694.00	793694.00	0.00	902	60	924	3111	0.297010607521697	0.295789857724191	0.295789857724191	false	false	false
f589d692-023d-4dba-99e0-308f5be1ff9d	2026-09-25 13:53	2026-09-25 13:52	2026-09-25 13:52	BP	BP261023C00043000	call	43.0000	2026-10-23	2.0200	1.9600	2.0200	43.8450	47672.00	47672.00	0.00	236	26	251	20	12.55	0.309133523442284	0.309133523442284	false	false	false	true
4ff9638a-5a28-424a-b85f-f3fafc999fc1	2026-09-25 13:53	2026-09-25 13:52	2026-09-25 13:52	BP	BP261023C00044000	call	44.0000	2026-10-23	1.4800	1.4200	1.4800	43.8450	10360.00	10360.00	0.00	70	14	72	53	1.35849056603774	0.307559748121429	0.307559748121429	false	false	false
c4dad69d-01dd-42b6-b2ba-86068561e868	2026-09-25 13:48	2026-09-25 13:48	2026-09-25 13:48	PSX	PSX261218C00290000	call	290.0000	2026-12-18	8.6400	8.0000	9.0000	251.7800	15560.00	15560.00	0.00	18	2	19	631	0.0301109350237718	0.428357639521496	0.428357639521496	false	true	false
05fffc47-dbbc-47e4-aa66-043e4aab07d1	2026-09-25 13:45	2026-09-25 13:45	2026-09-25 13:45	OXY	OXY281215P00055000	put	55.0000	2028-12-15	8.2500	7.4500	8.2500	56.6750	96525.00	7425.00	0.00	117	11	117	137	0.854014598540146	0.37120715691324	0.37120715691324	true	false	false
9b71adc7-af2f-4b65-bed1-2f757cafc2e9	2026-09-25 13:43	2026-09-25 13:43	2026-09-25 13:43	OKE	OKE261016P00090000	put	90.0000	2026-10-16	3.2000	3.0000	3.2000	88.2600	48640.00	48640.00	0.00	152	36	269	2639	0.101932550208412	0.276469014413406	0.276469014413406	false	false	false
08c4ec9a-b4cd-4294-a223-e4e776c747e8	2026-09-25 13:43	2026-09-25 13:42	2026-09-25 13:42	LNG	LNG261016C00290000	call	290.0000	2026-10-16	2.4000	2.4000	2.6000	268.0800	43201.00	0.00	43201.00	180	34	182	2270	0.0801762114537445	0.355097009559883	0.355097009559883	false	false	false
4cd8a1e2-3295-4590-b570-28394fcb257b	2026-09-25 13:41	2026-09-25 13:41	2026-09-25 13:41	CVX	CVX261016P00200000	put	200.0000	2026-10-16	3.2000	3.2000	3.4500	203.0000	14400.00	0.00	14400.00	45	12	152	3415	0.0445095168374817	0.259826364623436	0.259826364623436	false	false	false
1ccd01da-1d27-4372-bf73-f2963b405b1b	2026-09-25 13:41	2026-09-25 13:41	2026-09-25 13:41	ET	ET270115C00020000	call	20.0000	2027-01-15	0.8900	0.8200	0.8900	20.0000	17800.00	17800.00	0.00	200	24	2822	85365	0.0330580448661629	0.159543304276818	0.159543304276818	false	false	false
10ad8e15-6184-402b-bc77-96cf3d10121e	2026-09-25 13:40	2026-09-25 13:40	2026-09-25 13:40	BORR	BORR280121C00007500	call	7.5000	2028-01-21	0.6000	0.4500	0.6500	4.0000	12600.00	12600.00	0.00	210	26	321	3588	0.0894648829431438	0.686127309624289	0.686127309624289	true	false	false
e54e2555-419f-4acc-b39f-fa3bde7d848f	2026-09-25 13:39	2026-09-25 13:39	2026-09-25 13:39	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	10.9500	10.9500	11.4500	88.0000	139097.00	3315.00	135782.00	127	30	1554	1935	0.803100775193798	0.461902554985101	0.464420682844522	false	false	false
9b1d2a62-8baa-446a-b7b7-c49883b7a2fc	2026-09-25 13:37	2026-09-25 13:37	2026-09-25 13:37	UEC	UEC270115P00009000	put	9.0000	2027-01-15	1.0000	1.0000	1.0200	9.0000	22000.00	0.00	22000.00	220	20	3573	3783	0.944488501189532	0.639303976136446	0.639303976136446	false	false	false
fcbeb83b-6f90-4a57-b63b-b8b52b90df88	2026-09-25 13:35	2026-09-25 13:35	2026-09-25 13:35	NUAI	NUAI261120C00007500	call	7.5000	2026-11-20	1.1000	1.1000	1.2000	6.0000	26180.00	0.00	26180.00	238	7	365	11192	0.0326125804145818	1.2556034391164	1.2556034391164	true	false	false
1d9cbd03-c905-4608-baf9-b76ecbb6e11e	2026-09-25 13:35	2026-09-25 13:35	2026-09-25 13:35	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0300	11.0000	11.5000	88.0000	61740.00	1105.00	60635.00	56	24	1427	1935	0.737467700258398	0.462361422134017	0.462361422134017	false	false	false
5d0f1634-dcbc-45ac-973f-536c74f6f33a	2026-09-25 13:34	2026-09-25 13:34	2026-09-25 13:34	UUUU	UUUU280121C00010000	call	10.0000	2028-01-21	4.7400	4.6500	4.8000	11.0000	47400.00	47400.00	0.00	100	5	161	3124	0.0515364916773367	0.781547682515183	0.781547682515183	false	false	false
1b65ba8e-4245-4ecc-83a3-64bb7c250139	2026-09-25 13:32	2026-09-25 13:31	2026-09-25 13:31	CVX	CVX261016C00210000	call	210.0000	2026-10-16	2.7300	2.7000	2.8200	203.9000	21800.00	0.00	21800.00	80	13	217	18783	0.0115530000532396	0.253631123110959	0.255864734809911	false	false	false
6026f7df-aa18-42c2-993c-ab6850e2202d	2026-09-25 13:32	2026-09-25 13:31	2026-09-25 13:31	CCJ	CCJ270115P00090000	put	90.0000	2027-01-15	8.9000	8.9000	9.2000	88.3150	32040.00	0.00	32040.00	36	13	1146	5153	0.222394721521444	0.443033461215459	0.443033461215459	false	false	false
eff0d542-f963-4ca6-a889-38a1561add49	2026-09-25 13:30	2026-09-25 13:30	2026-09-25 13:30	UEC	UEC270115P00009000	put	9.0000	2027-01-15	0.9900	0.9900	1.0200	9.5400	17127.00	0.00	17127.00	173	21	3353	3783	0.886333597673804	0.63871369544262	0.63871369544262	false	false	false
3d2daf23-1f81-490e-a67d-9576f5c23489	2026-09-25 13:30	2026-09-25 13:29	2026-09-25 13:29	VLO	VLO260925P00385000	put	385.0000	2026-09-25	8.0000	7.6000	9.2000	376.9700	16000.00	800.00	800.00	20	19	240	395	0.607594936708861	1.00812783000009	1.00812783000009	false	false	false
c9329f8b-2ead-45ce-b37b-ac074133e286	2026-09-25 13:28	2026-09-25 13:28	2026-09-25 13:28	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0000	11.0000	11.4000	88.2400	82500.00	0.00	82500.00	75	14	1345	1935	0.695090439276486	0.462094716754276	0.462094716754276	false	false	false
1435e3fe-ac7a-4243-88b0-e8bfb64607c5	2026-09-25 13:27	2026-09-25 13:27	2026-09-25 13:27	COP	COP270115P00125000	put	125.0000	2027-01-15	7.3500	7.2000	7.3500	127.2600	49980.00	49980.00	0.00	68	30	74	1748	0.0423340961098398	0.331739996331527	0.331739996331527	false	false	false
b3181770-2fa2-49e2-bbdc-cb42b6dafed2	2026-09-25 13:25	2026-09-25 13:25	2026-09-25 13:25	CCJ	CCJ270115P00090000	put	90.0000	2027-01-15	8.9000	8.9000	9.1000	88.2700	52510.00	0.00	52510.00	59	19	1073	5153	0.20822821657287	0.441965721532518	0.441965721532518	false	false	false
9305eafe-8d99-4a1c-8091-b3f87b8f1578	2026-09-25 13:25	2026-09-25 13:25	2026-09-25 13:25	UEC	UEC270115P00009000	put	9.0000	2027-01-15	1.0000	1.0000	1.0200	9.5250	17400.00	0.00	17400.00	174	14	3180	3783	0.840602696272799	0.641110563546703	0.641110563546703	false	false	false
4890e266-cd33-455f-bf5b-b0dde4f8730a	2026-09-25 13:24	2026-09-25 13:23	2026-09-25 13:23	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0600	11.0000	11.4000	88.3100	88495.00	7770.00	80725.00	80	21	1270	1935	0.656330749354005	0.461348223096318	0.463860188543935	false	false	false
25b3f9af-14de-444b-9749-54f4a3a1a913	2026-09-25 13:22	2026-09-25 13:22	2026-09-25 13:22	XOM	XOM261009P00157500	put	157.5000	2026-10-09	2.1900	2.0800	2.1900	160.0000	42048.00	42048.00	0.00	192	42	234	832	0.28125	0.27890547796835	0.27890547796835	false	false	false