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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 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×er_time = unknown×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

a9794ceb-0ab7-46c7-b094-a728339424a4	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3500	1.3500	1.3900	43.7500	49815.00	0.00	49815.00	369	13	1589	1312	1.21112804878049	0.453205791199614	0.453205791199614	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	15310360987.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:54:40.302966Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
e630a69f-ad14-4fda-a041-ada50587b5b2	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3400	1.3400	1.3500	43.7450	16348.00	0.00	16348.00	122	17	1085	1312	0.826981707317073	0.450346865445716	0.450346865445716	true	false	false
7d55b6b2-8fac-49a6-b90a-ba1726b5375e	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3300	1.3300	1.3500	43.7500	24472.00	0.00	24472.00	184	10	855	1312	0.651676829268293	0.448377732451776	0.448377732451776	true	false	false
4a0401e6-9c79-478b-b852-aa1b8e15627f	2026-09-23 15:53	2026-09-23 15:53	2026-09-23 15:53	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3400	1.3400	1.3500	43.7450	14472.00	0.00	14472.00	108	16	963	1312	0.733993902439024	0.450346865445716	0.450346865445716	true	false	false
df1bf284-42c4-4f8a-a35e-357604b5d5ae	2026-09-23 15:52	2026-09-23 15:52	2026-09-23 15:52	APA	APA261016P00042500	put	42.5000	2026-10-16	1.3000	1.2600	1.3600	43.8050	63180.00	0.00	63180.00	486	10	668	1312	0.509146341463415	0.44599171673138	0.44599171673138	false	false	false
f991f401-e312-4c50-893f-ccf6c2f28b2a	2026-09-23 15:49	2026-09-23 15:49	2026-09-23 15:49	COP	COP261120P00120000	put	120.0000	2026-11-20	3.2000	3.1000	3.2000	128.1500	15360.00	15360.00	0.00	48	16	310	617	0.502431118314425	0.343308921394176	0.343308921394176	false	false	false
0bb71eea-e120-4b20-be8d-94241fc07cd8	2026-09-23 15:47	2026-09-23 15:47	2026-09-23 15:47	CLMT	CLMT261120C00055000	call	55.0000	2026-11-20	5.6900	5.5000	5.7000	54.0000	12520.00	11970.00	550.00	22	5	609	2070	0.294202898550725	0.677812261106266	0.689862892614875	false	false	false
1735a0e5-5101-4dcb-b8a0-080e3e2b9b84	2026-09-23 15:46	2026-09-23 15:45	2026-09-23 15:45	UUUU	UUUU260925P00011500	put	11.5000	2026-09-25	0.2200	0.1900	0.2400	11.0000	27698.00	22.00	27676.00	1259	18	1546	2706	0.571322985957132	0.830028702920385	0.830028702920385	false	false	false
ad114d77-7f87-4eb5-bdf6-e6aa4e0910a1	2026-09-23 15:44	2026-09-23 15:44	2026-09-23 15:44	CVX	CVX260925C00205000	call	205.0000	2026-09-25	2.0900	2.0900	2.2200	205.0000	55385.00	0.00	55385.00	265	38	637	642	0.992211838006231	0.319286889897177	0.319286889897177	false	false	false
c1c05817-0fda-4406-af37-b8c5e185058f	2026-09-23 15:42	2026-09-23 15:42	2026-09-23 15:42	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.0000	4.0000	4.1000	91.3200	10400.00	0.00	10400.00	26	12	873	3093	0.282250242483026	0.484261555229801	0.484261555229801	false	false	false
139dee0a-6f4f-4ffc-9ba4-f1cd542a2da8	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	XOM	XOM261016P00145000	put	145.0000	2026-10-16	0.4500	0.4500	0.5000	161.1450	20790.00	0.00	20790.00	462	39	595	9286	0.0640749515399526	0.31064082300174	0.31064082300174	false	false	false
7304c9be-dbdb-40fa-b06e-82b45d60e071	2026-09-23 15:38	2026-09-23 15:38	2026-09-23 15:38	WMB	WMB261120C00075000	call	75.0000	2026-11-20	2.2000	2.1500	2.2500	71.3150	32780.00	0.00	24860.00	149	7	1158	2631	0.440136830102623	0.308472674198919	0.308472674198919	false	false	false
a4a94e7b-0a14-459d-87ac-c87e420f817b	2026-09-23 15:38	2026-09-23 15:37	2026-09-23 15:37	WMB	WMB261120C00075000	call	75.0000	2026-11-20	2.2000	2.1000	2.2500	71.2800	16500.00	5940.00	0.00	75	19	887	2631	0.337134169517294	0.309709402959595	0.309709402959595	true	false	false
31192452-396e-43ba-99d9-423bef1314bd	2026-09-23 15:38	2026-09-23 15:37	2026-09-23 15:37	WMB	WMB261120C00075000	call	75.0000	2026-11-20	2.2000	2.1000	2.2000	71.2800	26840.00	26840.00	0.00	122	13	1009	2631	0.383504370961612	0.309709402959595	0.309709402959595	true	false	false
0d3d989c-50af-4a45-93e1-459f65a05a47	2026-09-23 15:38	2026-09-23 15:37	2026-09-23 15:37	WMB	WMB261120C00075000	call	75.0000	2026-11-20	2.2000	2.0500	2.2000	71.2400	141632.00	141632.00	0.00	644	71	770	2631	0.292664386164956	0.311121122400845	0.311121122400845	true	false	false
65d3872b-7eca-4c4e-af80-495800b0e93e	2026-09-23 15:33	2026-09-23 15:33	2026-09-23 15:33	CVX	CVX270115C00230000	call	230.0000	2027-01-15	4.4500	4.3000	4.4500	205.1500	18690.00	18690.00	0.00	42	10	291	5296	0.0549471299093656	0.258438999446795	0.258438999446795	false	false	false
cf9302ef-3575-48e4-9bf7-b8773df7738f	2026-09-23 15:32	2026-09-23 15:32	2026-09-23 15:32	WMB	WMB261218P00065000	put	65.0000	2026-12-18	1.6000	1.5000	1.6000	71.2400	26080.00	26080.00	0.00	163	12	205	1171	0.175064047822374	0.317844056198691	0.317844056198691	false	false	false
b5bf1833-58bb-4a3f-9336-2726769382c7	2026-09-23 15:32	2026-09-23 15:32	2026-09-23 15:32	CLMT	CLMT270319C00060000	call	60.0000	2027-03-19	8.0200	7.8000	8.2000	53.4100	28065.00	28065.00	0.00	35	6	686	1245	0.551004016064257	0.681616226010216	0.678244456310082	false	false	false
330ff7ef-d918-48ae-9725-effdbe32a142	2026-09-23 15:26	2026-09-23 15:26	2026-09-23 15:26	KGS	KGS261016P00052500	put	52.5000	2026-10-16	2.0500	2.0000	2.1500	53.0000	24395.00	20705.00	410.00	119	12	429	1829	0.234554401312192	0.452866267220865	0.452866267220865	false	false	false
4ecf57a5-4af1-4d2c-8792-7b51a3241cda	2026-09-23 15:26	2026-09-23 15:25	2026-09-23 15:25	KGS	KGS261016P00052500	put	52.5000	2026-10-16	1.9500	0.5500	2.0000	53.0000	44460.00	41925.00	2535.00	228	19	255	1829	0.139420448332422	0.434371657176785	0.43600801767421	false	false	false
df5e54f0-f5f8-4a11-8e2e-f1a7fd99e65a	2026-09-23 15:23	2026-09-23 15:23	2026-09-23 15:23	BKR	BKR270115C00050000	call	50.0000	2027-01-15	9.7000	9.6000	9.8000	57.7050	175570.00	2910.00	168780.00	181	9	211	1063	0.198494825964252	0.359773323528277	0.359773323528277	false	false	false
474f24f8-6785-4ddb-8fd4-4e4b64f02dcb	2026-09-23 15:21	2026-09-23 15:20	2026-09-23 15:20	XOM	XOM261218C00175000	call	175.0000	2026-12-18	4.2500	4.2000	4.2500	160.9500	12742.00	12742.00	0.00	30	5	86	4123	0.0208585981081737	0.282567532479001	0.281923277200818	false	false	false
3b411c5e-d2f0-4d11-9bdc-cee252661c49	2026-09-23 15:19	2026-09-23 15:19	2026-09-23 15:19	CCJ	CCJ280121P00095000	put	95.0000	2028-01-21	18.5000	18.2500	18.9000	91.4201	12950.00	5550.00	5550.00	7	6	246	328	0.75	0.477146618984504	0.477146618984504	true	false	false
c3c43d86-3014-4901-b07c-5bc7a2f989a6	2026-09-23 15:07	2026-09-23 15:07	2026-09-23 15:07	XOM	XOM261002P00155000	put	155.0000	2026-10-02	0.9000	0.9000	0.9900	161.0400	22770.00	0.00	22770.00	253	25	596	1020	0.584313725490196	0.30788644232992	0.30788644232992	false	false	false
789ff24e-bb6f-4e13-b765-6bcb076d1033	2026-09-23 15:04	2026-09-23 15:04	2026-09-23 15:04	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.5100	18.5000	18.6000	160.9100	24060.00	0.00	24060.00	13	5	1211	1049	1.15443279313632	0.293985277659049	0.293985277659049	false	false	false
30a596f3-2740-4e49-aa2f-c8c8eb9feca6	2026-09-23 14:59	2026-09-23 14:59	2026-09-23 14:59	OKE	OKE261016C00090000	call	90.0000	2026-10-16	2.9000	2.8000	2.9000	90.4100	16820.00	16820.00	0.00	58	10	85	1517	0.0560316413974951	0.284922910884315	0.284922910884315	false	false	false
b1d44bce-1749-49df-9f86-336ee894a5b4	2026-09-23 14:58	2026-09-23 14:58	2026-09-23 14:58	EQT	EQT280121P00050000	put	50.0000	2028-01-21	6.5900	6.3000	6.6000	50.9500	328250.00	328250.00	0.00	498	5	1498	2908	0.515130674002751	0.378163663765819	0.376774035518216	false	false	false
908d4af8-9d88-4ed3-ab14-e27cc73d9efe	2026-09-23 14:54	2026-09-23 14:54	2026-09-23 14:54	PAGP	PAGP261120C00027000	call	27.0000	2026-11-20	0.7000	0.6500	0.7500	26.7800	15050.00	14770.00	70.00	215	15	220	2912	0.0755494505494505	0.169496072220258	0.169496072220258	true	false	false
3391cecd-c1d5-4536-8549-701210cb5a93	2026-09-23 14:51	2026-09-23 14:51	2026-09-23 14:51	NXE	NXE270115C00012000	call	12.0000	2027-01-15	0.5000	0.5000	0.6000	9.6950	12500.00	0.00	12500.00	250	5	256	2073	0.123492522913652	0.545891487394677	0.545891487394677	false	false	false
d0fe8e3f-b4a8-44ec-a908-99f05e8ad2d9	2026-09-23 14:50	2026-09-23 14:50	2026-09-23 14:50	MTRX	MTRX270521C00010000	call	10.0000	2027-05-21	1.7000	1.6500	1.8500	9.7800	22100.00	0.00	22100.00	130	5	250	0	0	0.53258416059178	0.53258416059178	false	false	false
2b0d8ff8-1a6b-41c6-a8ea-268cf2bbf5f4	2026-09-23 14:45	2026-09-23 14:45	2026-09-23 14:45	OXY	OXY261009P00054000	put	54.0000	2026-10-09	0.4400	0.4300	0.4700	57.4000	55880.00	660.00	55220.00	1270	20	1286	191	6.73298429319372	0.349229831574779	0.349229831574779	false	false	false
17b512f6-fa76-4a6a-8a72-8cbe47868cc2	2026-09-23 14:37	2026-09-23 14:37	2026-09-23 14:37	LNG	LNG280121C00340000	call	340.0000	2028-01-21	27.0100	27.0000	29.5000	274.6500	27010.00	2710.00	24300.00	10	8	10	20	0.5	0.339126569484689	0.339126569484689	true	false	false
55c09e11-d19f-4bb4-b71d-d37d46d7572e	2026-09-23 14:36	2026-09-23 14:35	2026-09-23 14:35	EXE	EXE261120P00080000	put	80.0000	2026-11-20	1.5500	1.4500	1.6000	87.7400	23715.00	23560.00	0.00	153	27	181	19756	0.00916177363838834	0.341350233184566	0.341350233184566	false	false	false
9806df03-a10f-4de6-809d-cd3e8fed8adb	2026-09-23 14:35	2026-09-23 14:35	2026-09-23 14:35	PR	PR261016C00025000	call	25.0000	2026-10-16	0.1500	0.1000	0.2000	21.6950	15248.00	15116.00	72.00	1028	74	1902	35500	0.0535774647887324	0.453369816008882	0.46126002066118	false	false	false
65290167-cf74-4407-a271-3b8e52235ea6	2026-09-23 14:34	2026-09-23 14:34	2026-09-23 14:34	APA	APA261016C00050000	call	50.0000	2026-10-16	0.3200	0.2900	0.3400	43.7600	11552.00	32.00	11520.00	361	17	383	2167	0.176742039686202	0.449079414029445	0.449079414029445	false	false	false
c1c93bb4-19bb-4446-aa10-8679645c7341	2026-09-23 14:33	2026-09-23 14:33	2026-09-23 14:33	DHT	DHT261218P00020000	put	20.0000	2026-12-18	1.6000	1.6000	1.8000	21.2750	11200.00	0.00	5440.00	70	15	624	650	0.96	0.570084504287567	0.570084504287567	false	false	false
4613adc0-f011-4dc3-af77-9ed1a5997536	2026-09-23 14:30	2026-09-23 14:30	2026-09-23 14:30	COP	COP261218C00130000	call	130.0000	2026-12-18	7.5000	7.3000	7.5000	128.5300	31500.00	31500.00	0.00	42	15	155	1285	0.120622568093385	0.305411748600802	0.305411748600802	false	false	false
b30599ff-64f7-4e0a-ab76-6ac2ac5bced2	2026-09-23 14:23	2026-09-23 14:23	2026-09-23 14:23	CVX	CVX281215C00300000	call	300.0000	2028-12-15	10.5500	10.5500	10.9500	205.0000	42200.00	0.00	42200.00	40	16	102	215	0.474418604651163	0.238158126729153	0.238158126729153	true	false	false
848e6d45-7554-4d0b-86dc-ffd7844ec824	2026-09-23 14:23	2026-09-23 14:23	2026-09-23 14:23	CCJ	CCJ270617P00080000	put	80.0000	2027-06-17	7.3500	7.3500	7.6500	91.0000	26460.00	0.00	26460.00	36	10	160	124	1.29032258064516	0.463363369210051	0.463363369210051	false	false	false
3d76ff48-5465-4520-8329-55bdfe591a63	2026-09-23 14:22	2026-09-23 14:22	2026-09-23 14:22	CCJ	CCJ270617P00080000	put	80.0000	2027-06-17	7.4000	7.4000	7.4500	91.0000	11840.00	0.00	11840.00	16	7	34	124	0.274193548387097	0.464888821567086	0.464888821567086	false	false	false
201d2973-3d6b-48be-a47b-96587afa07bb	2026-09-23 14:19	2026-09-23 14:19	2026-09-23 14:19	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.8000	18.8000	18.8500	161.0000	35720.00	0.00	35720.00	19	6	630	1049	0.600571973307912	0.29758649809747	0.29758649809747	false	false	false
6b43d67f-1475-47cb-b850-35eb5e3441f5	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.8000	18.7500	18.8500	161.1400	16920.00	0.00	0.00	9	5	521	1049	0.496663489037178	0.300836012552709	0.300836012552709	false	false	false
6399a53b-da31-4b41-a399-9c451df1f0f0	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	XOM	XOM261120C00145000	call	145.0000	2026-11-20	18.7800	18.7500	18.8500	161.1800	37564.00	15052.00	22512.00	20	6	494	1049	0.470924690181125	0.296085759336721	0.299319763222368	false	false	false
149d41e2-4246-4dbf-942e-100d9cda38e4	2026-09-23 14:15	2026-09-23 14:15	2026-09-23 14:15	PBF	PBF261016P00070000	put	70.0000	2026-10-16	4.9000	4.9000	5.5000	70.2400	24500.00	0.00	24500.00	50	20	210	651	0.32258064516129	0.728878194514998	0.728878194514998	false	false	false
2bbb6407-2dee-4ccb-85e2-f53d9b7e128e	2026-09-23 14:15	2026-09-23 14:15	2026-09-23 14:15	LNG	LNG270115P00270000	put	270.0000	2027-01-15	15.9000	15.4000	15.9000	275.3600	87450.00	87450.00	0.00	55	10	55	629	0.0874403815580286	0.332454259425832	0.332454259425832	false	false	false
fec1ee35-5d08-47a1-8985-d1168e39b16a	2026-09-23 14:11	2026-09-23 14:11	2026-09-23 14:11	VNOM	VNOM261016C00042000	call	42.0000	2026-10-16	0.8000	0.6500	0.8000	41.1300	52640.00	52640.00	0.00	658	21	681	148	4.60135135135135	0.274759061905315	0.274759061905315	false	false	false
dfd210f3-ad2b-4474-a972-3cee3b08f16b	2026-09-23 14:03	2026-09-23 14:02	2026-09-23 14:02	FRO	FRO261120P00045000	put	45.0000	2026-11-20	2.5500	2.4500	2.6000	47.3400	20399.00	19889.00	0.00	80	23	136	2	68	0.50906261478408	0.50906261478408	false	false	false
8d74c5e1-b54d-4f9b-a0ac-6324ac637079	2026-09-23 14:02	2026-09-23 14:02	2026-09-23 14:02	XOM	XOM261218P00155000	put	155.0000	2026-12-18	6.2000	6.2000	6.2500	161.3200	16740.00	0.00	16740.00	27	6	315	2844	0.110759493670886	0.315736353387513	0.315736353387513	false	false	false
25e257cf-2d04-4eaf-9cc2-b170c01437f5	2026-09-23 14:02	2026-09-23 14:02	2026-09-23 14:02	CVX	CVX270115C00200000	call	200.0000	2027-01-15	16.0000	15.6500	16.0500	205.8938	19200.00	16000.00	3200.00	12	7	143	6554	0.0218187366493744	0.249795414985843	0.249795414985843	false	false	false
9ef36ea0-07fc-47dd-b976-1c62cf633f4d	2026-09-23 14:01	2026-09-23 14:01	2026-09-23 14:01	XOM	XOM261009C00165000	call	165.0000	2026-10-09	2.5200	2.4300	2.5400	161.2900	10085.00	10085.00	0.00	40	6	691	371	1.86253369272237	0.295462307816611	0.291566970326128	false	false	false