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

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	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	19006871297.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T17:55:09.170571Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
c858fb87-224a-4ff4-b08a-70caadf9064b	2026-09-02 11:07	2026-09-02 11:07	2026-09-02 11:07	BTU	BTU261120P00027000	put	27.0000	2026-11-20	1.7800	1.7800	1.8300	29.7000	11598.00	0.00	11598.00	65	14	112	97	1.15463917525773	0.579970241813655	0.580795539962249	false	false	false	true
4a9d4d64-abdd-4092-9f23-7a28ad0f0e0f	2026-09-02 10:54	2026-09-02 10:54	2026-09-02 10:54	CVX	CVX260918C00210000	call	210.0000	2026-09-18	5.8000	5.7000	6.1000	211.9200	435886.00	0.00	435886.00	751	41	1053	12027	0.0875530057370915	0.259790643272904	0.26037011571944	true	false	false	true
e0e7b9a3-f520-43d5-b4dc-c38c077100ac	2026-09-02 10:37	2026-09-02 10:37	2026-09-02 10:37	OXY	OXY261016C00065000	call	65.0000	2026-10-16	1.0800	1.0700	1.1300	60.4800	830552.00	16633.00	813919.00	7690	24	20815	21401	0.972618101957852	0.308564039205968	0.308962250304035	false	false	false	true
c22bf81f-2081-4796-8e87-97a45dacca17	2026-09-02 10:00	2026-09-02 10:00	2026-09-02 10:00	CLMT	CLMT270115C00060000	call	60.0000	2027-01-15	5.6000	5.2000	5.6000	52.2750	35836.00	35836.00	0.00	64	7	101	741	0.136302294197031	0.639832827589281	0.639832827589281	false	false	false	true
2aefb22b-d293-4755-b665-434eb1f7c5d3	2026-09-02 09:48	2026-09-02 09:48	2026-09-02 09:48	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	7.8100	7.2000	8.7000	52.8050	11711.00	0.00	11711.00	15	6	23	132	0.174242424242424	0.641236980809456	0.641236980809456	false	false	false	true
10b1b6de-43c6-4a00-bbc6-27f55e79154e	2026-09-02 09:37	2026-09-02 09:36	2026-09-02 09:36	MTDR	MTDR260918C00055000	call	55.0000	2026-09-18	5.2000	4.0000	5.4000	59.5850	10400.00	10400.00	0.00	20	10	20	366	0.0546448087431694	0.427801633071436	0.427801633071436	false	false	false	true
e2bb97ac-74b7-4e2b-b64d-40a352d7664a	2026-09-01 15:31	2026-09-01 15:30	2026-09-01 15:30	VLO	VLO270617P00390000	put	390.0000	2027-06-17	68.2700	66.5000	68.4000	361.8100	61440.00	61440.00	0.00	9	7	57	168	0.339285714285714	0.461397334250514	0.462962835390622	false	false	false	true
8ab585de-dcd4-48d5-825d-8aeaacd55454	2026-09-01 15:26	2026-09-01 15:26	2026-09-01 15:26	STNG	STNG261016C00085000	call	85.0000	2026-10-16	2.0900	1.9000	2.1500	79.4800	51526.00	51526.00	0.00	246	22	246	649	0.37904468412943	0.36006336162375	0.363016145098407	false	false	false	true
66016a50-f52b-4583-abb3-bfdb945cd583	2026-09-01 15:11	2026-09-01 15:11	2026-09-01 15:11	SOC	SOC261016P00005000	put	5.0000	2026-10-16	0.8700	0.8700	0.9000	4.7150	33076.00	1408.00	31668.00	380	20	398	984	0.404471544715447	1.08527636469269	1.10043716456972	false	false	false	true
a5012dcd-5aa0-4d0a-b013-65960c32b12a	2026-09-01 15:07	2026-09-01 15:07	2026-09-01 15:07	CVX	CVX270115C00230000	call	230.0000	2027-01-15	6.7600	6.7000	6.8500	209.9900	50675.00	0.00	50675.00	75	6	240	2848	0.0842696629213483	0.255471358507375	0.255684873357143	false	false	false	true
4fc85f46-66ff-48d9-b6e8-e217dc5fc6c4	2026-09-01 15:01	2026-09-01 15:01	2026-09-01 15:01	CRK	CRK261120C00015000	call	15.0000	2026-11-20	2.1000	2.0000	2.1500	15.8800	17636.00	17636.00	0.00	84	13	1152	1906	0.604407135362015	0.52841647167468	0.539239477032457	false	false	false	true
a6983a99-d115-4df8-8d9a-ea57cefffa4a	2026-09-01 14:58	2026-09-01 14:57	2026-09-01 14:57	VNOM	VNOM261016C00047000	call	47.0000	2026-10-16	1.0600	0.9500	1.7000	45.3300	11319.00	2310.00	9009.00	107	5	163	93	1.75268817204301	0.259683476108545	0.261329600007983	false	false	false	true
592059a3-6509-47a4-a7ff-0581bb24dd61	2026-09-01 14:36	2026-09-01 14:35	2026-09-01 14:35	PBR	PBR270617C00022000	call	22.0000	2027-06-17	1.9400	1.7700	1.9400	20.2750	387800.00	387800.00	0.00	2000	31	8332	252	33.0634920634921	0.330992882704058	0.333773257323824	false	false	false	true
6edf61ad-9f97-4b5d-b349-197671245e6f	2026-09-01 14:35	2026-09-01 14:35	2026-09-01 14:35	PBR	PBR270617C00022000	call	22.0000	2027-06-17	1.9400	1.7500	1.9500	20.2750	401815.00	358747.00	41904.00	2076	38	6131	252	24.3293650793651	0.333397494641857	0.335163350722239	false	false	false	true
1069fb3e-e1f0-4a8c-a95f-61cb50978568	2026-09-01 14:12	2026-09-01 14:12	2026-09-01 14:12	VLO	VLO260911P00342500	put	342.5000	2026-09-11	3.1500	2.4000	3.4000	361.4050	207984.00	207984.00	0.00	660	14	663	12	55.25	0.425851727503873	0.427016507162793	false	false	false	true
fb100abd-ec24-4649-9ba1-559c363e21b4	2026-09-01 13:39	2026-09-01 13:39	2026-09-01 13:39	APA	APA261016C00045000	call	45.0000	2026-10-16	2.4000	2.3700	2.5300	44.3450	130106.00	8894.00	121212.00	541	44	1640	16396	0.100024396194194	0.419549338446396	0.415934570727046	true	false	false	true
681ea4f2-b87a-4d97-a19e-4b28bc311a50	2026-09-01 13:19	2026-09-01 13:19	2026-09-01 13:19	CRK	CRK260918C00014000	call	14.0000	2026-09-18	1.8500	1.8000	1.8500	15.7200	10359.00	10359.00	0.00	56	7	10786	22023	0.489760704717795	0.475356611385934	0.49020584095283	false	false	false	true
32bb7ed7-0956-4d39-827d-00e0851a32da	2026-09-01 12:31	2026-09-01 12:31	2026-09-01 12:31	STNG	STNG260918C00082500	call	82.5000	2026-09-18	1.0000	0.9000	1.1000	78.6600	10036.00	3636.00	0.00	100	6	104	242	0.429752066115702	0.347746690387597	0.347746690387597	false	false	false	true
0898b542-61ba-4885-806b-a0f7fe4a2dac	2026-09-01 12:15	2026-09-01 12:15	2026-09-01 12:15	FRO	FRO260918C00047000	call	47.0000	2026-09-18	0.7500	0.7500	0.9000	44.6500	44045.00	0.00	44045.00	587	31	588	475	1.23789473684211	0.416379625403852	0.416379625403852	false	false	false	true
2fa45ee3-2c5e-44e0-ad62-8d5f52e53771	2026-09-01 11:54	2026-09-01 11:54	2026-09-01 11:54	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	0.5100	0.4700	0.6500	96.9550	64518.00	564.00	57069.00	1265	60	1933	21812	0.0886209426004034	0.4591065498689	0.4591065498689	true	false	false	true