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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×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

83354507-824e-41dc-a6de-5e5fa025baf4	2026-09-09 09:41	2026-09-09 09:41	2026-09-09 09:41	CLMT	CLMT280121C00050000	call	50.0000	2028-01-21	19.0900	18.1000	19.7000	54.5600	80160.00	22860.00	57300.00	42	5	48	1442	0.0332871012482663	0.649963197900632	0.652279843303286	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	4970645133.00	2026-11-06	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T13:46:31.810255Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
ff595f54-78f9-4a7e-88bf-56ecf84b16ec	2026-09-08 14:49	2026-09-08 14:48	2026-09-08 14:48	PR	PR261016C00025000	call	25.0000	2026-10-16	0.6900	0.6500	0.7500	23.8800	10200.00	6490.00	1960.00	148	8	458	38163	0.0120011529491916	0.35577560918466	0.362586657912393	false	false	false	true
a7af347e-fa9d-4a12-bf57-1ad692565d55	2026-09-08 14:33	2026-09-08 14:33	2026-09-08 14:33	SM	SM260918C00040000	call	40.0000	2026-09-18	0.7700	0.6500	0.8500	38.1600	15260.00	15260.00	0.00	198	16	1571	1371	1.14587892049599	0.577877859869512	0.595291694190144	true	false	false	true
eee14f6d-69a1-4731-abff-3aa5108fb597	2026-09-08 14:27	2026-09-08 14:27	2026-09-08 14:27	SM	SM260918C00040000	call	40.0000	2026-09-18	0.7000	0.6500	0.7000	38.0000	11734.00	11734.00	0.00	168	5	1373	1371	1.00145878920496	0.565321245521915	0.574289523034958	false	false	false	true
93c95e35-ff65-4a54-ad54-df0435b28082	2026-09-08 13:57	2026-09-08 13:57	2026-09-08 13:57	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	8.7100	8.5500	9.0000	54.2250	30501.00	0.00	30501.00	35	6	165	322	0.512422360248447	0.668141075360869	0.668141075360869	false	false	false	true
3983b522-41ee-425e-a1fd-19bd9234386c	2026-09-08 11:04	2026-09-08 11:04	2026-09-08 11:04	PSX	PSX261218C00220000	call	220.0000	2026-12-18	47.4300	46.4000	48.5000	258.7400	109081.00	0.00	37906.00	23	10	37	855	0.0432748538011696	0.412071331163781	0.412071331163781	false	false	false	true
6897c6d3-c3ac-4ce4-ba7f-65fc12d850aa	2026-09-08 10:39	2026-09-08 10:39	2026-09-08 10:39	SEI	SEI261120P00042500	put	42.5000	2026-11-20	1.7500	1.2000	1.8000	63.1700	38272.00	38272.00	0.00	219	9	329	890	0.369662921348315	0.900859349806387	0.900859349806387	false	false	false	true
08b69e7c-b76b-4c4e-af84-7f4753a5a038	2026-09-08 10:21	2026-09-08 10:21	2026-09-08 10:21	SEI	SEI260918C00070000	call	70.0000	2026-09-18	1.0000	1.0000	1.3500	62.6963	66124.00	0.00	66124.00	661	47	3540	4871	0.72675015397249	0.797358778135338	0.797358778135338	true	false	false	true
c0b5f32a-e5d3-4622-a53d-0485ed87b4bc	2026-09-04 15:58	2026-09-04 15:58	2026-09-04 15:58	VLO	VLO260918P00340000	put	340.0000	2026-09-18	2.5700	1.9500	2.8000	371.0000	106577.00	106577.00	0.00	415	18	1024	695	1.47338129496403	0.446326147802958	0.448135081299121	false	false	false	true
5a932e3c-3f47-468b-b1a0-4395c9ff22ed	2026-09-04 15:23	2026-09-04 15:23	2026-09-04 15:23	PBF	PBF260918P00070000	put	70.0000	2026-09-18	2.3100	2.0500	2.4000	73.7117	162920.00	161745.00	0.00	706	40	1219	899	1.3559510567297	0.713556036521789	0.7081014019864	true	false	false	true
be5f797b-7330-4bf8-96f2-78c1412c36fe	2026-09-04 14:00	2026-09-04 14:00	2026-09-04 14:00	PBF	PBF260918C00080000	call	80.0000	2026-09-18	2.0000	2.0000	2.2000	74.5050	77225.00	0.00	77225.00	386	38	3380	12598	0.268296555008732	0.688256242922043	0.688256242922043	false	false	false	true
181dca2e-21ea-49b3-b132-bcb9eeff5498	2026-09-04 13:02	2026-09-04 13:02	2026-09-04 13:02	GLNG	GLNG270115C00065000	call	65.0000	2027-01-15	1.0000	0.9000	1.0000	52.1900	18652.00	18652.00	0.00	187	12	232	7042	0.032945186026697	0.340827978443509	0.335601912477094	false	false	false	true
7cff32e2-12f0-4bfd-a67e-a31bda68d9c1	2026-09-04 11:15	2026-09-04 11:15	2026-09-04 11:15	MPC	MPC270617C00400000	call	400.0000	2027-06-17	60.0400	59.9000	61.9000	388.0600	180120.00	36120.00	144000.00	30	14	38	138	0.27536231884058	0.437540073473125	0.438284341623301	true	false	false	true
4bf4ea90-fe1f-47df-a08e-b72980e251d3	2026-09-04 10:52	2026-09-04 10:52	2026-09-04 10:52	VLO	VLO260918P00345000	put	345.0000	2026-09-18	3.2400	2.8000	3.4000	371.0858	202602.00	202602.00	0.00	625	19	628	156	4.02564102564103	0.43642202397512	0.435898683272476	false	false	false	true
390c4029-b23b-4141-a0f4-c3d554b9add6	2026-09-04 09:53	2026-09-04 09:53	2026-09-04 09:53	LNG	LNG260918C00300000	call	300.0000	2026-09-18	5.3800	4.3000	5.6000	288.0800	107528.00	107528.00	0.00	200	20	242	5042	0.0479968266560889	0.425551021659181	0.450707136716605	false	false	false	true
81f027cb-0d51-4e59-86d0-d2b8d07636c4	2026-09-03 15:55	2026-09-03 15:55	2026-09-03 15:55	CCJ	CCJ280121P00090000	put	90.0000	2028-01-21	14.2000	13.6000	14.4500	100.4900	56810.00	56810.00	0.00	40	6	91	716	0.127094972067039	0.495232812301544	0.495232812301544	false	false	false	true
7e3d1db7-c9ba-4adc-93ce-05edf7478fd7	2026-09-03 15:55	2026-09-03 15:54	2026-09-03 15:54	CCJ	CCJ280121P00090000	put	90.0000	2028-01-21	14.1400	13.5000	14.3000	100.5490	56578.00	56578.00	0.00	40	16	40	716	0.0558659217877095	0.493382745455659	0.493382745455659	false	false	false	true
aed44498-b039-49c3-bfab-72ceff9bed57	2026-09-03 15:11	2026-09-03 15:11	2026-09-03 15:11	VLO	VLO261218P00390000	put	390.0000	2026-12-18	47.0400	46.5000	47.1000	370.5150	75259.00	65859.00	4700.00	16	10	57	271	0.210332103321033	0.482139729612836	0.483395421843817	true	false	false	true
97667367-d8b1-49c5-aa52-abff39443c27	2026-09-03 14:59	2026-09-03 14:59	2026-09-03 14:59	CLMT	CLMT270115C00050000	call	50.0000	2027-01-15	10.1800	9.9000	10.7000	53.2300	50883.00	0.00	50883.00	50	5	168	3136	0.0535714285714286	0.651542384291642	0.651542384291642	false	false	false	true
d50fb9aa-c522-43c4-8670-0f924591e4d6	2026-09-03 14:21	2026-09-03 14:21	2026-09-03 14:21	VLO	VLO261218P00380000	put	380.0000	2026-12-18	41.1900	41.1000	41.2000	370.4000	57660.00	49440.00	8220.00	14	6	87	40	2.175	0.48083101778182	0.48209043656688	false	false	false	true
6cf7616e-03e4-40c2-99fa-9be1242afaf8	2026-09-03 13:50	2026-09-03 13:50	2026-09-03 13:50	DINO	DINO261016P00110000	put	110.0000	2026-10-16	9.1000	9.1000	9.5000	106.4000	364008.00	0.00	364008.00	400	44	400	2	200	0.498935045214413	0.503720575029212	true	false	false	true
f22ed511-b263-4ab6-9cb7-aaf776b3b065	2026-09-03 13:31	2026-09-03 13:31	2026-09-03 13:31	MPC	MPC261218C00400000	call	400.0000	2026-12-18	38.2400	37.5000	38.3000	391.7550	76480.00	68840.00	7640.00	20	11	77	588	0.130952380952381	0.473750977792154	0.474943336698551	true	false	false	true
79b6c4bc-6b07-429d-9912-61b1be3097f1	2026-09-03 13:00	2026-09-03 13:00	2026-09-03 13:00	MUR	MUR261016P00037500	put	37.5000	2026-10-16	2.1000	2.0000	2.1000	37.3000	104932.00	104932.00	0.00	500	44	504	29	17.3793103448276	0.410630379344453	0.408539893683777	false	false	false	true
936cc7e5-d1c0-4b48-807b-7214ff5f99d6	2026-09-03 12:57	2026-09-03 12:57	2026-09-03 12:57	CLMT	CLMT271217C00075000	call	75.0000	2027-12-17	10.0800	10.0000	10.1000	53.1900	10079.00	9075.00	1004.00	10	5	301	538	0.559479553903346	0.640473057062486	0.640473057062486	false	false	false	true
5b8b233d-7d51-466d-906b-9b96e0dbc86b	2026-09-03 11:52	2026-09-03 11:52	2026-09-03 11:52	CLMT	CLMT270115C00055000	call	55.0000	2027-01-15	8.0800	7.9000	8.3000	53.4300	24242.00	4050.00	14522.00	30	11	58	1587	0.0365469439193447	0.652962190383264	0.656100374550036	false	false	false	true
ca03ade0-d6a7-421e-8524-723bc11bb65b	2026-09-03 11:41	2026-09-03 11:41	2026-09-03 11:41	OXY	OXY261120C00060000	call	60.0000	2026-11-20	4.2600	4.2500	4.4000	61.0150	85200.00	0.00	85200.00	200	9	627	10394	0.0603232634212045	0.30867072392943	0.313431617550693	false	false	false	true
3172f4d5-6693-4c39-912c-e871ac68e54c	2026-09-03 11:27	2026-09-03 11:27	2026-09-03 11:27	PBR	PBR261218C00022000	call	22.0000	2026-12-18	1.5400	1.4900	1.5700	20.8100	78345.00	72226.00	6119.00	510	6	536	30743	0.0174348632208958	0.420970983349956	0.432179367351244	false	false	false	true
45610411-e6bd-4d03-96de-0674cadb9f05	2026-09-03 11:23	2026-09-03 11:23	2026-09-03 11:23	CRK	CRK261016C00016000	call	16.0000	2026-10-16	0.9000	0.8000	0.9000	15.4000	26982.00	26982.00	0.00	300	6	559	704	0.794034090909091	0.525331001970427	0.534858354562251	false	false	false	true
fefb2e38-772b-4e93-929b-a724d1e4599b	2026-09-03 10:59	2026-09-03 10:59	2026-09-03 10:59	PSX	PSX260911C00257500	call	257.5000	2026-09-11	6.7100	6.1000	8.3000	259.8000	152940.00	51810.00	101130.00	228	6	374	18	20.7777777777778	0.350204232530817	0.350273570908346	false	false	false	true
570f8caa-50a6-4e00-8718-90a45308235b	2026-09-03 10:53	2026-09-03 10:53	2026-09-03 10:53	MPC	MPC270115C00460000	call	460.0000	2027-01-15	25.3700	24.4000	25.9000	398.2300	55810.00	40510.00	7650.00	22	11	22	23	0.956521739130435	0.469377987895722	0.471562611544504	true	false	false	true
fd3ba5c3-195b-4b7a-a53a-98fb8ab018c5	2026-09-03 10:49	2026-09-03 10:49	2026-09-03 10:49	CCJ	CCJ260911C00105000	call	105.0000	2026-09-11	1.1400	1.1000	1.3300	101.1400	11404.00	2070.00	9334.00	100	5	110	200	0.55	0.420045342325261	0.43172493949527	false	false	false	true
5242f579-ea53-4ef0-92e4-e46c4f835b46	2026-09-03 10:04	2026-09-03 10:04	2026-09-03 10:04	PBR	PBR270115C00022000	call	22.0000	2027-01-15	1.7700	1.7600	1.8000	21.2000	68018.00	18054.00	49964.00	384	5	898	30660	0.0292889758643183	0.387415244570045	0.388870752465779	false	false	false	true
02a14f09-e529-4b1d-9430-5987f7af1fe0	2026-09-03 09:37	2026-09-03 09:37	2026-09-03 09:37	NUAI	NUAI270219C00010000	call	10.0000	2027-02-19	0.9000	0.7500	0.9500	5.0950	21665.00	19865.00	1800.00	240	22	441	561	0.786096256684492	1.38418660159588	1.38418660159588	false	false	false	true
95b8c348-589a-4218-9bfd-0376882b8624	2026-09-02 15:23	2026-09-02 15:23	2026-09-02 15:23	MPC	MPC261218P00410000	put	410.0000	2026-12-18	48.2600	47.1000	48.6000	391.1813	135130.00	130300.00	0.00	28	16	42	0	0	0.475419687411646	0.480153794472847	true	false	false	true
7b0c2251-d009-413e-852d-c2480b64c07f	2026-09-02 15:23	2026-09-02 15:23	2026-09-02 15:23	MPC	MPC261218P00400000	put	400.0000	2026-12-18	42.4100	41.3000	42.6000	391.1813	203560.00	190890.00	8440.00	48	27	81	4	20.25	0.474180578430702	0.477744682227369	true	false	false	true
48adbce8-2322-451e-b3d5-1f2b18d5a76f	2026-09-02 15:05	2026-09-02 15:05	2026-09-02 15:05	CVE	CVE261218C00030000	call	30.0000	2026-12-18	4.5100	3.9000	5.0000	32.9000	90106.00	90106.00	0.00	200	15	200	820	0.24390243902439	0.372396058915759	0.372396058915759	false	false	false	true
e9fa91ed-f631-449f-b971-4446c932df57	2026-09-02 14:59	2026-09-02 14:59	2026-09-02 14:59	LNG	LNG260918C00310000	call	310.0000	2026-09-18	5.3000	4.4000	5.4000	297.5200	203450.00	3110.00	200340.00	384	19	470	262	1.79389312977099	0.401424738489821	0.406191432271902	true	false	false	true
fd7f2101-b2fb-45e0-8512-0eee922c5ef5	2026-09-02 14:54	2026-09-02 14:54	2026-09-02 14:54	OKE	OKE270319P00095000	put	95.0000	2027-03-19	7.1000	7.1000	7.6000	96.2733	83093.00	720.00	82373.00	117	9	117	40	2.925	0.313664291738634	0.314031047757257	false	false	false	true
a6ce48cb-a747-4538-8f17-d7627e5590fc	2026-09-02 14:28	2026-09-02 14:28	2026-09-02 14:28	COP	COP270219C00145000	call	145.0000	2027-02-19	9.1900	8.9000	9.2000	137.2800	137908.00	137908.00	0.00	150	6	158	171	0.923976608187134	0.303674333463489	0.303942546187825	false	false	false	true
e44f9668-47f7-43d1-8536-53cb7592060f	2026-09-02 14:23	2026-09-02 14:23	2026-09-02 14:23	TDW	TDW270115C00120000	call	120.0000	2027-01-15	5.2900	4.5000	5.4000	100.5800	49233.00	49233.00	0.00	93	24	93	186	0.5	0.457140752332905	0.45985014253557	true	false	false	true
85c9e44f-ec9a-41c0-b96f-9872af16c6c1	2026-09-02 14:02	2026-09-02 14:02	2026-09-02 14:02	CLMT	CLMT270115C00075000	call	75.0000	2027-01-15	2.9100	2.7500	2.9500	53.2200	28768.00	28768.00	0.00	99	14	112	324	0.345679012345679	0.657448834627721	0.657448834627721	false	false	false	true
73026dc1-a70d-4b36-804c-b756387d4cf3	2026-09-02 13:56	2026-09-02 13:56	2026-09-02 13:56	DINO	DINO270521C00140000	call	140.0000	2027-05-21	8.5000	8.0000	8.5000	106.1192	10198.00	10198.00	0.00	12	8	12	2	6	0.494434522297604	0.494734989079956	false	false	false	true
b9833db3-d0d6-47a1-a395-cfeb7b589301	2026-09-02 13:43	2026-09-02 13:43	2026-09-02 13:43	MPC	MPC270617P00420000	put	420.0000	2027-06-17	74.3700	72.4000	74.6000	389.4050	171040.00	171040.00	0.00	23	11	30	2	15	0.467707310464665	0.469893510771023	false	false	false	true
b8552cbb-66e1-41d0-b28a-0306f281105d	2026-09-02 13:35	2026-09-02 13:35	2026-09-02 13:35	REPX	REPX260918C00045000	call	45.0000	2026-09-18	0.2400	0.0500	0.2500	40.8400	18003.00	18003.00	0.00	750	8	1503	904	1.66261061946903	0.395297041511359	0.406329485165154	false	false	false	true
6aeab188-f693-4174-b6b4-727eaef9c123	2026-09-02 13:10	2026-09-02 13:10	2026-09-02 13:10	MPC	MPC260918P00350000	put	350.0000	2026-09-18	2.2200	2.1500	2.5500	388.3399	88623.00	7210.00	81413.00	400	55	854	777	1.0990990990991	0.441874416837985	0.452330601865766	true	false	false	true
f85e70db-40e8-4400-b120-d855d137deca	2026-09-02 12:59	2026-09-02 12:59	2026-09-02 12:59	WES	WES280121P00055000	put	55.0000	2028-01-21	9.7200	9.6000	10.3000	48.6400	48624.00	0.00	48624.00	50	7	100	112	0.892857142857143	0.339396576372489	0.34991436762093	false	false	false	true
384328c3-d4d9-4918-b9cc-8b4d05eabb02	2026-09-02 12:56	2026-09-02 12:56	2026-09-02 12:56	VLO	VLO261218P00290000	put	290.0000	2026-12-18	7.5800	6.6000	7.6000	365.7500	303339.00	303339.00	0.00	400	39	402	164	2.45121951219512	0.466143303377476	0.474574161215157	false	false	false	true
5765c264-db79-4f97-8578-66fe5c0861fc	2026-09-02 12:34	2026-09-02 12:34	2026-09-02 12:34	EQT	EQT261218C00062500	call	62.5000	2026-12-18	1.7500	1.6400	1.9800	55.6050	137476.00	14194.00	123282.00	786	15	809	415	1.94939759036145	0.325258303821677	0.323940559779009	false	false	false	true
713878aa-5811-43bd-b10b-a3b9ab3ff3ed	2026-09-02 11:53	2026-09-02 11:53	2026-09-02 11:53	COP	COP281215C00195000	call	195.0000	2028-12-15	10.6700	9.3000	10.8000	136.9100	83260.00	42640.00	2140.00	78	18	78	9	8.66666666666667	0.275381314914102	0.2766914732281	true	false	false	true
29ceecf8-ac60-46a1-a8d4-1dc102d867fd	2026-09-02 11:37	2026-09-02 11:37	2026-09-02 11:37	CLMT	CLMT261120C00055000	call	55.0000	2026-11-20	5.7100	5.4000	5.8000	52.7400	17134.00	17134.00	0.00	30	11	37	2262	0.0163572060123784	0.660455410635598	0.660455410635598	false	false	false	true