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

1de623ae-c6f0-4f58-b5a3-8fe4d0f59fd4	2026-09-24 14:25	2026-09-24 14:25	2026-09-24 14:25	VLO	VLO261120P00350000	put	350.0000	2026-11-20	15.0000	14.4000	15.0000	388.7900	150000.00	150000.00	0.00	100	16	368	111	3.31531531531532	0.54433934951206	0.54123980380855	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	108214656942.00	2026-10-22	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T18:26:21.590036Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
76001251-f75e-40c4-a8f3-6ee25a6181a0	2026-09-24 14:23	2026-09-24 14:23	2026-09-24 14:23	GLND	GLND261120C00005000	call	5.0000	2026-11-20	0.6000	0.5500	0.7500	4.5500	11400.00	60.00	10380.00	190	33	1551	414	3.7463768115942	1.06344601660665	1.06344601660665	true	false	false	true
4d1cebbb-71f8-4f19-8539-f024c30f667a	2026-09-24 14:22	2026-09-24 14:22	2026-09-24 14:22	GLND	GLND261016C00004000	call	4.0000	2026-10-16	1.0000	0.7500	1.0000	4.5587	10000.00	10000.00	0.00	100	5	5891	4398	1.33947248749432	1.63343647226267	1.63343647226267	false	false	false	true
d0a95fff-5ea4-4674-822f-a09401f0f945	2026-09-24 14:20	2026-09-24 14:20	2026-09-24 14:20	EQT	EQT261218P00045000	put	45.0000	2026-12-18	0.7800	0.7300	0.7800	51.2800	17862.00	17862.00	0.00	229	18	393	3993	0.0984222389181067	0.328528489960839	0.328528489960839	false	false	false	true
9cfcc4fc-2ea5-4f9f-826b-bc02e7d323c5	2026-09-24 14:19	2026-09-24 14:19	2026-09-24 14:19	CVX	CVX261002P00205000	put	205.0000	2026-10-02	2.6400	2.5400	2.8000	206.3600	38810.00	268.00	38542.00	147	46	215	306	0.702614379084967	0.276200211564898	0.279550140806983	true	false	false	true
c3156887-e758-4249-abae-71eba13c7054	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	MPC	MPC261016P00430000	put	430.0000	2026-10-16	40.5000	40.5000	40.8000	396.6500	218700.00	0.00	218700.00	54	13	56	261	0.21455938697318	0.521827615162514	0.505066648776263	true	false	false	true
45e56be0-757a-4805-b129-c85053400990	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	PSX	PSX261009P00277500	put	277.5000	2026-10-09	19.4000	19.1000	20.1000	261.3700	36860.00	5820.00	31040.00	19	5	19	0	0	0.461419099020733	0.440898584727987	false	false	false	true
30d80bd0-4b89-4be8-ab6f-313e066fc590	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	PBF	PBF261016P00080000	put	80.0000	2026-10-16	9.2000	9.2000	9.6000	73.6900	469200.00	0.00	469200.00	510	6	510	79	6.45569620253165	0.748980060720073	0.748980060720073	false	false	false	true
201973e0-6876-420b-bddb-9090d3fd9843	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	DINO	DINO261016P00115000	put	115.0000	2026-10-16	10.1000	10.1000	10.4000	108.2700	836280.00	0.00	836280.00	828	6	829	285	2.90877192982456	0.582955184978984	0.582955184978984	false	false	false	true
104a1663-77c4-4eab-9f0d-634f89f16197	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	PBF	PBF261016C00065000	call	65.0000	2026-10-16	10.7000	10.7000	11.6000	73.8275	49221.00	0.00	49221.00	46	12	63	205	0.307317073170732	0.733713589644487	0.733713589644487	false	false	false	true
018143e5-953f-4c17-ac64-b4801345530a	2026-09-24 14:13	2026-09-24 14:13	2026-09-24 14:13	PSX	PSX260925C00247500	call	247.5000	2026-09-25	13.9000	13.3000	16.6000	261.3700	93130.00	66720.00	16680.00	67	20	67	0	0	1.35888831115948	0.364149909014807	true	false	false	true
f63145d8-0ba6-47ea-951d-27ece8f2a6fe	2026-09-24 14:11	2026-09-24 14:11	2026-09-24 14:11	MTDR	MTDR261218C00055000	call	55.0000	2026-12-18	3.5000	3.5000	3.7000	52.8700	27650.00	0.00	27650.00	79	22	79	227	0.348017621145374	0.410903338807026	0.412084302391932	false	false	false	true
0d6a91be-7cad-408a-a21d-d839da2c1c32	2026-09-24 14:06	2026-09-24 14:06	2026-09-24 14:06	CVX	CVX270617P00185000	put	185.0000	2027-06-17	9.4000	8.7500	9.4000	206.6950	20680.00	20680.00	0.00	22	5	22	695	0.0316546762589928	0.310482765812428	0.310482765812428	false	false	false	true
d9c90706-9f3f-4478-ac7b-e894770b1fbc	2026-09-24 14:03	2026-09-24 14:03	2026-09-24 14:03	BP	BP261002C00046000	call	46.0000	2026-10-02	0.3200	0.2900	0.4000	44.0000	12800.00	1664.00	11136.00	400	35	966	807	1.19702602230483	0.312234242779496	0.314670967400282	false	false	false	true
741de122-1589-43ba-867e-f160b346502a	2026-09-24 14:03	2026-09-24 14:03	2026-09-24 14:03	BP	BP270115P00035000	put	35.0000	2027-01-15	0.3200	0.3200	0.4500	44.0000	39232.00	0.00	39232.00	1226	19	1226	4344	0.282228360957643	0.344129906883199	0.344129906883199	false	false	false	true
11d2df4a-335e-4e5e-a5f3-a564910bd346	2026-09-24 14:03	2026-09-24 14:03	2026-09-24 14:03	BP	BP270115P00040000	put	40.0000	2027-01-15	1.1700	1.1700	1.3000	44.0000	62946.00	0.00	62946.00	538	20	540	2515	0.214711729622266	0.329284777617218	0.329284777617218	false	false	false	true
c072f440-e248-41a4-9df9-2b8d85b3e239	2026-09-24 14:00	2026-09-24 14:00	2026-09-24 14:00	MPC	MPC261218P00370000	put	370.0000	2026-12-18	24.7000	23.1000	24.7000	398.7900	61750.00	61750.00	0.00	25	7	50	244	0.204918032786885	0.527931703080555	0.527931703080555	false	false	false	true
e6a5c812-40e2-489b-8fab-8f84e82fb7ac	2026-09-24 13:59	2026-09-24 13:59	2026-09-24 13:59	TRMD	TRMD261120C00035000	call	35.0000	2026-11-20	2.4000	2.2500	2.5000	34.4800	21360.00	6720.00	14640.00	89	6	201	167	1.20359281437126	0.466948999390734	0.466948999390734	false	false	false	true
c37a8e81-ac43-4438-bf87-165500a056ce	2026-09-24 13:58	2026-09-24 13:58	2026-09-24 13:58	DVN	DVN270115C00055000	call	55.0000	2027-01-15	2.0500	2.0500	2.1600	49.4550	41000.00	0.00	35055.00	200	5	342	8620	0.0396751740139211	0.348809943531187	0.348809943531187	false	false	false	true
103fea5d-1ca7-4f1a-af85-cf81dca904be	2026-09-24 13:58	2026-09-24 13:58	2026-09-24 13:58	VLO	VLO261218C00390000	call	390.0000	2026-12-18	42.0000	40.5000	42.6000	391.2400	21000.00	12600.00	8400.00	5	5	32	4332	0.00738688827331487	0.528386784982643	0.528386784982643	false	false	false	true
6af08ea7-bb17-4950-a965-9642a75ac87f	2026-09-24 13:58	2026-09-24 13:58	2026-09-24 13:58	VLO	VLO261218C00440000	call	440.0000	2026-12-18	23.0000	21.8000	23.2000	391.2400	443907.00	437007.00	2310.00	193	62	201	280	0.717857142857143	0.523301413323842	0.524689951219457	true	false	false	true
38c6666f-5e36-449a-9c5b-6a41cc41f760	2026-09-24 13:58	2026-09-24 13:58	2026-09-24 13:58	VLO	VLO261218C00420000	call	420.0000	2026-12-18	29.4000	28.1000	29.5000	391.2400	376300.00	370420.00	5880.00	128	27	133	174	0.764367816091954	0.523467195972396	0.523467195972396	true	false	false	true
f3347431-35f8-4fda-a813-dd975bc8d89f	2026-09-24 13:57	2026-09-24 13:57	2026-09-24 13:57	SHEL	SHEL261218C00095000	call	95.0000	2026-12-18	5.2000	5.0000	5.2000	96.0600	21319.00	21319.00	0.00	41	12	93	1746	0.0532646048109966	0.226453047998561	0.225954261932781	false	false	false	true
b376511f-f933-44ea-941b-1c03867ed8ff	2026-09-24 13:57	2026-09-24 13:57	2026-09-24 13:57	VLO	VLO260925P00400000	put	400.0000	2026-09-25	11.1000	8.9000	11.1000	390.9600	62150.00	62150.00	0.00	56	14	90	445	0.202247191011236	0.661705652189917	0.661705652189917	false	false	false	true
9717b0af-4553-4636-9317-534e9eb702e9	2026-09-24 13:57	2026-09-24 13:57	2026-09-24 13:57	MPC	MPC261016C00340000	call	340.0000	2026-10-16	60.8000	60.8000	63.0000	397.6000	352650.00	6090.00	346560.00	58	28	58	327	0.17737003058104	0.519318115173302	0.519318115173302	false	false	false	true
67fe2ecf-697e-4711-ba2d-079835c170a9	2026-09-24 13:57	2026-09-24 13:57	2026-09-24 13:57	PSX	PSX261009P00270000	put	270.0000	2026-10-09	13.6000	12.4000	13.6000	262.4400	44880.00	44880.00	0.00	33	9	33	9	3.66666666666667	0.449500227522874	0.447613030471868	false	false	false	true
c9a0dbff-670c-44dd-bb60-fc1dd44d19c1	2026-09-24 13:57	2026-09-24 13:56	2026-09-24 13:56	XOM	XOM261009C00165000	call	165.0000	2026-10-09	2.7800	2.6800	2.7800	162.4900	47259.00	47259.00	0.00	170	32	834	820	1.01707317073171	0.287839201602376	0.286864510684082	false	false	false	true
dc228814-9c9d-4b46-9f92-994025af8865	2026-09-24 13:56	2026-09-24 13:56	2026-09-24 13:56	VLO	VLO261120C00410000	call	410.0000	2026-11-20	26.2000	26.2000	26.9000	392.0100	41920.00	0.00	41920.00	16	11	97	841	0.115338882282996	0.529186187571509	0.529870716104036	false	false	false	true
c7c8c09b-cae7-4f6e-8026-41a2ed28e6e6	2026-09-24 13:55	2026-09-24 13:55	2026-09-24 13:55	DVN	DVN261002C00050000	call	50.0000	2026-10-02	0.8400	0.7700	0.8900	49.2692	63168.00	45360.00	17808.00	752	9	1572	743	2.1157469717362	0.392884569822039	0.392884569822039	true	false	false	true
23c24dd3-bc0e-4ca0-9766-0e8d70a64898	2026-09-24 13:54	2026-09-24 13:54	2026-09-24 13:54	KMI	KMI261218C00035000	call	35.0000	2026-12-18	0.3300	0.3300	0.3500	31.0000	30888.00	0.00	30888.00	936	42	5315	2804	1.89550641940086	0.225214059957038	0.225214059957038	false	false	false	true
ae3ea47d-a629-4b9b-a8b6-4cce5fe28fad	2026-09-24 13:53	2026-09-24 13:53	2026-09-24 13:53	CVX	CVX261120P00210000	put	210.0000	2026-11-20	11.0000	10.8500	11.0000	206.0000	15400.00	15400.00	0.00	14	5	39	1066	0.0365853658536585	0.308624784360668	0.308624784360668	false	false	false	true
c571ab46-0af3-484b-a458-5e26c4da9cca	2026-09-24 13:51	2026-09-24 13:51	2026-09-24 13:51	OKE	OKE261218P00090000	put	90.0000	2026-12-18	4.6000	4.5000	4.6000	91.0000	78200.00	78200.00	0.00	170	5	171	393	0.435114503816794	0.319868736502599	0.319868736502599	true	false	false	true
c486355c-083b-4cad-9416-aac92d167681	2026-09-24 13:49	2026-09-24 13:49	2026-09-24 13:49	OKE	OKE261120C00095000	call	95.0000	2026-11-20	2.5000	2.4500	2.5000	91.0000	28750.00	28750.00	0.00	115	34	166	299	0.555183946488294	0.268168706407705	0.268168706407705	false	false	false	true
63d1fb72-328a-4373-9fa9-c2683c1769a7	2026-09-24 13:49	2026-09-24 13:49	2026-09-24 13:49	CVX	CVX261002C00215000	call	215.0000	2026-10-02	0.8100	0.7700	1.0000	207.0000	18629.00	18468.00	161.00	230	20	549	1036	0.52992277992278	0.268611891766002	0.268611891766002	true	false	false	true
3746b3e3-b93b-441c-8118-c99ed7ca6039	2026-09-24 13:48	2026-09-24 13:47	2026-09-24 13:47	KMI	KMI261218C00035000	call	35.0000	2026-12-18	0.3500	0.3500	0.3700	31.0000	26425.00	0.00	26425.00	755	22	1878	2804	0.669757489300999	0.228710622267399	0.228710622267399	false	false	false	true
52945937-424e-4a8d-9ccd-78577c80e16e	2026-09-24 13:45	2026-09-24 13:45	2026-09-24 13:45	GLNG	GLNG261218C00055000	call	55.0000	2026-12-18	1.8500	1.7500	1.8500	50.0000	18500.00	18500.00	0.00	100	8	1298	487	2.6652977412731	0.35389768720284	0.35389768720284	true	false	false	true
4c020fbe-6cca-4ff6-bc71-21ee4306d7e0	2026-09-24 13:44	2026-09-24 13:44	2026-09-24 13:44	BP	BP261002C00046000	call	46.0000	2026-10-02	0.4500	0.2200	0.5000	44.0000	13500.00	13500.00	0.00	300	5	556	807	0.688971499380421	0.326758176539871	0.328793617274273	false	false	false	true
2f1188c5-08e2-4e4f-a56d-ce2792e0e0d0	2026-09-24 13:39	2026-09-24 13:39	2026-09-24 13:39	DVN	DVN261120C00050000	call	50.0000	2026-11-20	2.7200	2.6100	2.7300	49.2500	18224.00	18224.00	0.00	67	11	354	26189	0.0135171255107106	0.376120216663125	0.376120216663125	true	false	false	true
8d310027-f82e-43f5-b7fb-c7cf960378b0	2026-09-24 13:39	2026-09-24 13:39	2026-09-24 13:39	BP	BP260925C00045500	call	45.5000	2026-09-25	0.2700	0.1500	0.2700	45.1750	12339.00	12339.00	0.00	457	15	1532	939	1.63152289669862	0.433435437436981	0.433435437436981	true	false	false	true
2bfdde3a-f52e-4c14-a18f-3c705ac4d3ab	2026-09-24 13:29	2026-09-24 13:29	2026-09-24 13:29	XOM	XOM270319C00170000	call	170.0000	2027-03-19	10.5200	10.2000	10.8500	162.5450	21040.00	0.00	21040.00	20	5	53	2400	0.0220833333333333	0.272456836927869	0.272456836927869	false	false	false	true
abc7a46c-08cf-4acc-aa6e-c34dfe3ea7df	2026-09-24 13:28	2026-09-24 13:28	2026-09-24 13:28	AR	AR270115C00038000	call	38.0000	2027-01-15	2.3000	2.2000	2.3000	35.6450	10108.00	10108.00	0.00	44	6	134	582	0.230240549828179	0.387591409871543	0.387591409871543	false	false	false	true
ae299e60-5d58-4882-a52d-c0b323c4f449	2026-09-24 13:27	2026-09-24 13:26	2026-09-24 13:26	COP	COP270319P00120000	put	120.0000	2027-03-19	6.5500	6.5000	7.0500	129.6150	11795.00	655.00	11140.00	18	12	76	903	0.0841638981173865	0.340045209800964	0.340045209800964	false	false	false	true
29d7e933-8d36-4795-96c8-15c62f054c12	2026-09-24 13:21	2026-09-24 13:20	2026-09-24 13:20	PBR	PBR261009P00021000	put	21.0000	2026-10-09	0.9100	0.8700	1.0000	20.9750	94822.00	79716.00	15106.00	1042	5	1110	1732	0.640877598152425	0.53960890975956	0.53960890975956	true	false	false	true
fd51ed45-f412-453a-a903-6a37bfcaa394	2026-09-24 13:18	2026-09-24 13:18	2026-09-24 13:18	GLND	GLND261120C00005000	call	5.0000	2026-11-20	0.7500	0.7500	0.8000	4.7999	35805.00	0.00	35805.00	477	23	1288	414	3.11111111111111	1.0844286307046	1.08819458143073	true	false	false	true
db29f49a-13cd-4741-82c9-9e51213f150e	2026-09-24 13:13	2026-09-24 13:13	2026-09-24 13:13	PSX	PSX261120C00270000	call	270.0000	2026-11-20	15.3000	15.3000	16.2000	261.3800	13770.00	0.00	13770.00	9	5	27	317	0.0851735015772871	0.444770965636768	0.444770965636768	false	false	false	true
d3ec8b36-babb-4891-aff1-ac554fd46426	2026-09-24 13:06	2026-09-24 13:06	2026-09-24 13:06	OKE	OKE261120C00100000	call	100.0000	2026-11-20	1.1400	1.0500	1.2500	90.9500	215540.00	0.00	62590.00	1899	2	3034	561	5.40819964349376	0.269331803006452	0.269331803006452	false	true	false	true
ec22f1cb-4c45-4056-a7b5-c470e3267c13	2026-09-24 13:04	2026-09-24 13:04	2026-09-24 13:04	OKE	OKE261120C00100000	call	100.0000	2026-11-20	1.1500	1.1500	1.3000	90.9600	57528.00	0.00	57528.00	500	62	568	561	1.01247771836007	0.267785843116593	0.269125738601249	false	false	false	true
569dd0b7-abbe-4972-9ae2-55bed55ae410	2026-09-24 13:03	2026-09-24 13:03	2026-09-24 13:03	RIG	RIG261120C00006000	call	6.0000	2026-11-20	0.2600	0.2600	0.2700	5.4750	11050.00	0.00	11050.00	425	8	536	9520	0.0563025210084034	0.515052373873718	0.515052373873718	false	false	false	true
6b46a8a0-ff1f-4d76-8892-7a3d0f219714	2026-09-24 13:02	2026-09-24 13:01	2026-09-24 13:01	GLND	GLND261016C00006000	call	6.0000	2026-10-16	0.3500	0.2500	0.4500	4.7150	17430.00	35.00	17360.00	498	19	1068	18	59.3333333333333	1.61376612939005	1.61376612939005	true	false	false	true
67efae2d-08c3-4bba-b872-fa350a18cbed	2026-09-24 13:01	2026-09-24 13:01	2026-09-24 13:01	CCJ	CCJ270319P00075000	put	75.0000	2027-03-19	4.4100	4.0500	4.5500	89.2250	50715.00	50715.00	0.00	115	2	116	184	0.630434782608696	0.469723163786678	0.469723163786678	false	true	false	true