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.

728,802 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts728,802 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

d80058c0-595e-4325-99bb-6d3588b363e2	2026-09-30 10:21	2026-09-30 10:21	2026-09-30 10:21	EXE	EXE261120C00085000	call	85.0000	2026-11-20	3.4000	3.4000	3.7000	83.5900	26520.00	0.00	26520.00	78	15	179	995	0.179899497487437	0.3065618421074	0.3065618421074	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	19487988958.00	2026-10-27	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T14:23:56.441043Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
f3fcdcc0-cf33-455f-a0e8-56cd6506a8e8	2026-09-30 10:15	2026-09-30 10:15	2026-09-30 10:15	OXY	OXY261120P00055000	put	55.0000	2026-11-20	2.6600	2.6600	2.9100	54.9400	29260.00	0.00	29260.00	110	23	116	3638	0.0318856514568444	0.341361097218786	0.341361097218786	false	false	false
d47ffa20-18bb-468e-b8d9-ef1659545323	2026-09-30 10:15	2026-09-30 10:15	2026-09-30 10:15	UUUU	UUUU270115P00011000	put	11.0000	2027-01-15	1.4500	1.4200	1.4600	11.4250	83955.00	83085.00	0.00	579	40	599	1415	0.423321554770318	0.717861833774677	0.717861833774677	false	false	false
52ce37d6-241a-42fa-a95c-8018eb049eb3	2026-09-30 10:14	2026-09-30 10:14	2026-09-30 10:14	EXE	EXE261023P00082000	put	82.0000	2026-10-23	1.4000	1.1000	2.0000	83.7000	33616.00	0.00	33616.00	240	11	240	90	2.66666666666667	0.228062174815522	0.278820803016119	false	false	false
5faa45b1-6976-4bc6-a78f-28a2f31daa8f	2026-09-30 10:14	2026-09-30 10:14	2026-09-30 10:14	CLMT	CLMT261120C00060000	call	60.0000	2026-11-20	2.9900	2.7500	3.4000	53.0000	11970.00	0.00	11970.00	40	7	151	1765	0.0855524079320113	0.666456797449764	0.666456797449764	false	false	false
43c681a0-bdf7-4cc7-b8f8-2b1724e88a6d	2026-09-30 10:13	2026-09-30 10:12	2026-09-30 10:12	WMB	WMB261016C00070000	call	70.0000	2026-10-16	0.9000	0.8000	0.9500	68.0000	60660.00	90.00	60570.00	674	25	674	1273	0.529457973291438	0.271616573086768	0.274273373422308	false	false	false
8a12fde9-d4df-49cb-a24a-d6992964de17	2026-09-30 10:12	2026-09-30 10:12	2026-09-30 10:12	DVN	DVN261009C00049000	call	49.0000	2026-10-09	0.3000	0.2700	0.3600	46.0000	22501.00	31.00	22470.00	750	38	758	247	3.06882591093117	0.389831042609493	0.394773454528108	false	false	false
cdaf20b9-9035-4ee1-a311-9120388a938d	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	EXE	EXE261120P00090000	put	90.0000	2026-11-20	8.0000	8.0000	8.6000	83.6900	20000.00	0.00	20000.00	25	5	50	116	0.431034482758621	0.35135180313797	0.35135180313797	false	false	false
775f698e-b337-4f44-bd1c-b5bf72d180b7	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	EXE	EXE261120P00090000	put	90.0000	2026-11-20	8.0000	8.0000	8.6000	83.6900	20000.00	0.00	17600.00	25	7	25	116	0.21551724137931	0.35135180313797	0.35135180313797	false	false	false
11de3118-84cd-426f-9a5e-49f51dda4137	2026-09-30 10:06	2026-09-30 10:06	2026-09-30 10:06	CCJ	CCJ261002P00090000	put	90.0000	2026-10-02	1.8000	1.8000	2.3700	89.4450	12061.00	0.00	12061.00	67	5	68	1086	0.0626151012891344	0.572825605761327	0.572825605761327	true	false	false
ad2f0215-4a41-4ecb-89ae-fa5834011957	2026-09-30 10:02	2026-09-30 10:02	2026-09-30 10:02	UUUU	UUUU261016C00011000	call	11.0000	2026-10-16	0.8500	0.7400	0.8900	11.3800	15300.00	13430.00	1870.00	180	6	188	902	0.208425720620843	0.675505230110208	0.675505230110208	false	false	false
cdc1fe34-1b74-4701-904d-0702bf14de03	2026-09-30 09:59	2026-09-30 09:59	2026-09-30 09:59	VLO	VLO261218P00360000	put	360.0000	2026-12-18	19.2000	18.7000	19.2000	396.0001	38400.00	38400.00	0.00	20	6	205	513	0.399610136452242	0.508956475309834	0.508956475309834	false	false	false
10ee2b0b-aa51-4aab-a947-f5cf82f54089	2026-09-30 09:53	2026-09-30 09:53	2026-09-30 09:53	CVX	CVX261002C00210000	call	210.0000	2026-10-02	0.4700	0.4600	0.6000	205.5050	19176.00	47.00	19129.00	408	47	471	4146	0.113603473227207	0.314954938992856	0.314954938992856	false	false	false
cc76c272-8188-4400-8c76-5982beae9817	2026-09-30 09:52	2026-09-30 09:52	2026-09-30 09:52	VLO	VLO261218P00360000	put	360.0000	2026-12-18	18.9000	18.4000	18.9000	397.5200	71820.00	71820.00	0.00	38	5	130	513	0.253411306042885	0.511087866094351	0.511087866094351	false	false	false
bb53ef8d-56c6-4f2e-8287-006c5aae97e5	2026-09-30 09:52	2026-09-30 09:52	2026-09-30 09:52	VLO	VLO261218P00360000	put	360.0000	2026-12-18	18.9000	18.5000	18.9000	397.3750	62370.00	62370.00	0.00	33	6	163	513	0.317738791423002	0.510431987726385	0.510431987726385	false	false	false
9594fc30-55af-47de-aec5-df6e6b868848	2026-09-30 09:52	2026-09-30 09:52	2026-09-30 09:52	VLO	VLO261016C00410000	call	410.0000	2026-10-16	11.7000	11.6000	13.2000	397.3750	16380.00	0.00	15210.00	14	14	21	394	0.0532994923857868	0.504627057434588	0.504627057434588	true	false	false
d923cefa-b591-46e0-8a4c-91292170487e	2026-09-30 09:52	2026-09-30 09:52	2026-09-30 09:52	CCJ	CCJ261002C00089000	call	89.0000	2026-10-02	1.1900	1.0000	1.4200	88.0000	21926.00	11338.00	10468.00	185	18	365	147	2.48299319727891	0.572803862763416	0.568931333454818	true	false	false
e8210a50-9f60-4967-97ca-35e64b20ffae	2026-09-30 09:52	2026-09-30 09:52	2026-09-30 09:52	CCJ	CCJ261002C00089000	call	89.0000	2026-10-02	1.2500	1.0000	1.4400	88.0000	13375.00	13375.00	0.00	107	10	178	147	1.2108843537415	0.575308274008927	0.575308274008927	false	false	false
d7a329b0-98b2-4237-b4c9-f178d08938c2	2026-09-30 09:52	2026-09-30 09:51	2026-09-30 09:51	UUUU	UUUU261120C00013000	call	13.0000	2026-11-20	0.6400	0.6100	0.7500	11.0000	12682.00	9152.00	3530.00	199	18	267	1510	0.17682119205298	0.741830452667588	0.739561932752701	false	false	false
ce1ff616-0e95-49c6-a324-7f47ccc2ce00	2026-09-30 09:52	2026-09-30 09:51	2026-09-30 09:51	UUUU	UUUU261120C00011000	call	11.0000	2026-11-20	1.2900	1.2800	1.3000	11.0000	38055.00	21543.00	16512.00	296	7	786	784	1.00255102040816	0.718656973757562	0.712513551172985	false	false	false
8fe9b9a6-32cb-43fd-bec2-6e67cb440a05	2026-09-30 09:52	2026-09-30 09:51	2026-09-30 09:51	UUUU	UUUU261106C00012000	call	12.0000	2026-11-06	0.7200	0.6900	0.7200	11.0000	141552.00	141552.00	0.00	1966	37	2205	48	45.9375	0.73308732138716	0.73308732138716	false	false	false
3e113604-c85a-4b1e-9f22-f137114e7cd5	2026-09-30 09:52	2026-09-30 09:51	2026-09-30 09:51	UUUU	UUUU261120C00010000	call	10.0000	2026-11-20	1.8400	1.4600	1.8400	11.0000	24840.00	24840.00	0.00	135	7	135	972	0.138888888888889	0.72474207393684	0.72474207393684	false	false	false
2f474cf6-ab0d-4c6a-a36a-8a0f839bc574	2026-09-30 09:52	2026-09-30 09:51	2026-09-30 09:51	UUUU	UUUU261106C00010000	call	10.0000	2026-11-06	1.6900	1.3000	1.6900	11.0000	11492.00	11492.00	0.00	68	7	68	10	6.8	0.734040032825065	0.734040032825065	false	false	false
dcbbfc65-09d9-4ffd-af20-bd9a6b6e6761	2026-09-30 09:51	2026-09-30 09:51	2026-09-30 09:51	UUUU	UUUU261120C00011000	call	11.0000	2026-11-20	1.2600	1.2600	1.2900	11.0000	61617.00	381.00	49140.00	489	9	490	784	0.625	0.725060937173159	0.724147769740826	false	false	false
ed4d7688-ce95-4820-9893-8974f1913ea8	2026-09-30 09:48	2026-09-30 09:48	2026-09-30 09:48	PBF	PBF261016C00077500	call	77.5000	2026-10-16	5.7200	4.7000	6.1000	78.0000	1144000.00	1144000.00	0.00	2000	1	2003	2071	0.967165620473201	0.783052735065917	0.783052735065917	false	true	true
835ecec0-5b86-4e3b-9103-c6548b987fe5	2026-09-30 09:48	2026-09-30 09:48	2026-09-30 09:48	PBF	PBF261016C00080000	call	80.0000	2026-10-16	4.6800	4.2000	4.7000	78.0000	1170000.00	1170000.00	0.00	2500	1	2616	6049	0.432468176558109	0.801877893020901	0.801877893020901	false	true	true
75ef647c-5cf0-419f-b717-38e58a16f4a1	2026-09-30 09:48	2026-09-30 09:48	2026-09-30 09:48	CLMT	CLMT270319P00050000	put	50.0000	2027-03-19	6.5200	6.4000	6.8000	54.3350	13046.00	0.00	13046.00	20	6	20	294	0.0680272108843537	0.642506514131178	0.642506514131178	false	false	false
05ac056a-70b2-41a7-bdb8-6bd9a3c348e4	2026-09-30 09:48	2026-09-30 09:48	2026-09-30 09:48	XOM	XOM261030P00145000	put	145.0000	2026-10-30	0.6400	0.6400	0.8800	162.6883	15872.00	0.00	15872.00	248	20	252	413	0.610169491525424	0.318344575717188	0.318344575717188	false	false	false
f19152d9-30c0-4f6c-bdfc-7add12de3402	2026-09-30 09:46	2026-09-30 09:46	2026-09-30 09:46	VLO	VLO261218P00360000	put	360.0000	2026-12-18	18.9000	18.5000	18.9000	398.0000	68040.00	68040.00	0.00	36	10	89	513	0.173489278752437	0.513254151344544	0.513254151344544	false	false	false
edb99bcb-e21e-446d-8d9d-6311ecc5be7a	2026-09-30 09:46	2026-09-30 09:46	2026-09-30 09:46	DVN	DVN261016C00047000	call	47.0000	2026-10-16	1.3300	1.3300	1.4600	46.6000	10507.00	0.00	10507.00	79	10	502	662	0.758308157099698	0.379825677936081	0.379825677936081	false	false	false
24f41723-b58f-4165-a672-2b6170f2fe97	2026-09-30 09:44	2026-09-30 09:44	2026-09-30 09:44	EQT	EQT261120P00047500	put	47.5000	2026-11-20	1.5700	1.5700	1.8000	49.0000	55422.00	0.00	55422.00	353	32	356	664	0.536144578313253	0.328896236409556	0.328896236409556	true	false	false
32a77597-eb95-4e46-aa50-5c05b76dd03c	2026-09-30 09:44	2026-09-30 09:44	2026-09-30 09:44	WFRD	WFRD261016C00080000	call	80.0000	2026-10-16	2.9000	2.9000	4.7000	79.0000	13050.00	0.00	2320.00	45	6	45	86	0.523255813953488	0.466492042329709	0.466492042329709	false	false	false
79e9baa9-1c4e-430d-8a7e-0105854f75e1	2026-09-30 09:42	2026-09-30 09:42	2026-09-30 09:42	CLMT	CLMT270115C00080000	call	80.0000	2027-01-15	1.6300	1.5000	1.9500	54.3500	19550.00	5220.00	14330.00	120	11	320	706	0.453257790368272	0.636490042795959	0.645457511692992	false	false	false
4fceb346-4ec2-4900-bea2-ea858187d186	2026-09-30 09:40	2026-09-30 09:40	2026-09-30 09:40	CMBT	CMBT261016P00020000	put	20.0000	2026-10-16	1.5400	1.5500	1.8000	19.1600	30704.00	0.00	27604.00	200	13	401	900	0.445555555555556	0.661807007017449	0.674621935960818	true	false	false
2d2382d2-9ca4-422e-907e-ab19bc072fc5	2026-09-30 09:39	2026-09-30 09:39	2026-09-30 09:39	VLO	VLO261218P00370000	put	370.0000	2026-12-18	22.1000	22.1000	24.9000	397.4100	114920.00	0.00	114920.00	52	16	52	799	0.065081351689612	0.500504392784142	0.500504392784142	false	false	false
615e2639-959f-47f8-9217-c795d59df9a1	2026-09-30 09:39	2026-09-30 09:39	2026-09-30 09:39	BP	BP261016P00043000	put	43.0000	2026-10-16	0.8600	0.8600	0.9200	43.6500	38528.00	0.00	38528.00	448	12	449	1020	0.440196078431373	0.328620467072558	0.328620467072558	false	false	false
e41ac06c-6a1d-4426-aaa8-932af3b641bc	2026-09-30 09:30	2026-09-30 09:30	2026-09-30 09:30	STNG	STNG270115C00087500	call	87.5000	2027-01-15	6.0000	4.2000	6.0000	85.6250	11400.00	11400.00	0.00	19	6	67	176	0.380681818181818	0.343996307551799	0.343996307551799	false	false	false
77f24ecd-57f0-4bfe-b7a8-0455e13a142f	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	PBR	PBR261218C00021000	call	21.0000	2026-12-18	1.5900	1.5600	1.5900	20.0000	19875.00	19875.00	0.00	125	5	1482	5582	0.26549623790756	0.431729795916645	0.431729795916645	false	false	false
70d95ada-d08e-4654-8e67-9b566fc7f05d	2026-09-29 15:55	2026-09-29 15:55	2026-09-29 15:55	CVX	CVX280121C00260000	call	260.0000	2028-01-21	9.8000	9.2000	9.8000	204.3300	18615.00	18615.00	0.00	19	7	21	510	0.0411764705882353	0.242209936296471	0.242209936296471	true	false	false
ff5d7fc6-62d4-4eec-a9bc-d74f5dbc5956	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	PBR	PBR261009C00021500	call	21.5000	2026-10-09	0.5000	0.4800	0.5100	20.6100	49150.00	48250.00	900.00	983	23	1771	3048	0.581036745406824	0.622855369152115	0.622855369152115	true	false	false
02495af5-2d29-4e61-b495-67e2a9c8b59b	2026-09-29 15:47	2026-09-29 15:46	2026-09-29 15:46	KGS	KGS261016P00050000	put	50.0000	2026-10-16	1.3000	1.0500	1.3500	51.6050	13000.00	5850.00	260.00	100	12	106	115	0.921739130434783	0.466567762397269	0.466567762397269	false	false	false
656a5a90-dcf0-4934-8eb2-1af63ccf382f	2026-09-29 15:46	2026-09-29 15:46	2026-09-29 15:46	CNQ	CNQ261009P00046000	put	46.0000	2026-10-09	0.5500	0.4500	0.5500	47.0450	20790.00	20790.00	0.00	378	6	4517	4006	1.12755866200699	0.327135209410426	0.327135209410426	false	false	false
a581f10d-f08b-4a9b-9d98-2ec8c42527b8	2026-09-29 15:45	2026-09-29 15:45	2026-09-29 15:45	VLO	VLO261218P00370000	put	370.0000	2026-12-18	26.7000	26.2000	26.7000	386.9850	120150.00	120150.00	0.00	45	6	293	992	0.295362903225806	0.512950605392289	0.512950605392289	false	false	false
46127719-624e-4a5a-8d2b-e378d4a6a5ab	2026-09-29 15:41	2026-09-29 15:41	2026-09-29 15:41	VLO	VLO261218P00370000	put	370.0000	2026-12-18	26.5000	26.1000	26.5000	387.0000	108650.00	108650.00	0.00	41	8	211	992	0.212701612903226	0.513429153966585	0.513429153966585	false	false	false
2d03c4d7-d6ff-4d61-b5d8-ee7029c0de58	2026-09-29 15:40	2026-09-29 15:39	2026-09-29 15:39	MPC	MPC270115C00420000	call	420.0000	2027-01-15	31.7000	31.7000	33.1000	392.0000	34870.00	0.00	34870.00	11	9	11	358	0.0307262569832402	0.477084412062779	0.477084412062779	false	false	false
74c7a861-cdfa-4cd7-a15e-d680abd4bc31	2026-09-29 15:39	2026-09-29 15:38	2026-09-29 15:38	PBR	PBR261030P00018500	put	18.5000	2026-10-30	0.5000	0.5000	0.5400	20.0000	22000.00	0.00	22000.00	440	15	608	839	0.724672228843862	0.57615131400372	0.57615131400372	false	false	false
d3ccbb28-b6c9-47f5-8d70-378b797cdd84	2026-09-29 15:36	2026-09-29 15:36	2026-09-29 15:36	PBR	PBR261030C00022000	call	22.0000	2026-10-30	0.8700	0.8100	0.8700	20.0000	24795.00	24795.00	0.00	285	10	318	2495	0.127454909819639	0.580587147612063	0.580587147612063	true	false	false
8eea2439-40f9-4642-a763-1ce48a323697	2026-09-29 15:33	2026-09-29 15:33	2026-09-29 15:33	VLO	VLO261218P00380000	put	380.0000	2026-12-18	30.5000	30.1000	30.5000	389.3050	70150.00	70150.00	0.00	23	5	326	830	0.392771084337349	0.512635879081931	0.512635879081931	false	false	false
e0f5e682-7209-4254-80d5-265e56f9a6c3	2026-09-29 15:33	2026-09-29 15:33	2026-09-29 15:33	COP	COP270115C00145000	call	145.0000	2027-01-15	2.7600	2.6900	2.7700	125.5400	17388.00	17112.00	276.00	63	22	102	3320	0.0307228915662651	0.307405819111808	0.307405819111808	false	false	false
d705c364-6675-45f6-9f88-72a9798d7929	2026-09-29 15:33	2026-09-29 15:33	2026-09-29 15:33	CVX	CVX270115P00190000	put	190.0000	2027-01-15	5.9000	5.8000	5.9000	204.0700	12390.00	12390.00	0.00	21	10	133	2065	0.0644067796610169	0.293344478619009	0.293344478619009	false	false	false