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

b662823b-0425-437f-8b86-264edbc7dedf	2026-09-21 13:56	2026-09-21 13:56	2026-09-21 13:56	XOM	XOM270319P00125000	put	125.0000	2027-03-19	2.1600	2.1500	2.3600	158.8700	10563.00	880.00	9683.00	49	5	62	1582	0.0391908975979772	0.333062918255184	0.335567633322067	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	650915663268.00	2026-10-30	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T18:00:14.697100Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
52d59726-4f1f-4c45-8fe7-b6db5a035e26	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	BP	BP270617P00040000	put	40.0000	2027-06-17	2.9600	2.9500	2.9800	43.2250	10346.00	4440.00	4130.00	35	29	200	305	0.655737704918033	0.349301828682454	0.350074073400034	false	false	false	true
eb97aab1-cbc2-48be-901f-39b7e3bfa3bc	2026-09-21 13:41	2026-09-21 13:41	2026-09-21 13:41	BP	BP270617P00040000	put	40.0000	2027-06-17	2.9600	2.9100	2.9800	43.2250	28167.00	9498.00	594.00	95	36	165	305	0.540983606557377	0.350074073400034	0.350846127320155	false	false	false	true
8663a447-855a-4a0c-9ee5-6ae8a93ae725	2026-09-21 13:41	2026-09-21 13:40	2026-09-21 13:40	BP	BP270617P00040000	put	40.0000	2027-06-17	2.9700	2.9100	2.9800	43.2200	20814.00	7746.00	0.00	70	34	70	305	0.229508196721311	0.350729276771229	0.35150110644881	false	false	false	true
2bf70bc3-35b9-47ff-8f4e-ebb53f55cf2d	2026-09-21 13:25	2026-09-21 13:25	2026-09-21 13:25	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8400	1.7800	1.8500	47.2300	19157.00	18973.00	0.00	104	14	7124	18914	0.376652215290261	0.369959079291982	0.369959079291982	false	false	false	true
afc2ebd5-0ce2-44b0-b114-0aa9b8431170	2026-09-21 13:25	2026-09-21 13:24	2026-09-21 13:24	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8500	1.7800	1.8500	47.2300	18463.00	18463.00	0.00	100	18	7020	18914	0.371153642804272	0.369959079291982	0.371312838604245	false	false	false	true
13d9e035-181d-4d49-8fc3-1d60cf4d7fd6	2026-09-21 13:24	2026-09-21 13:24	2026-09-21 13:24	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8400	1.7800	1.8400	47.0000	18372.00	18372.00	0.00	100	26	6920	18914	0.365866553875436	0.369142231299499	0.370497094256356	false	false	false	true
d1fef59c-3696-491f-83d4-29f76754da17	2026-09-21 13:23	2026-09-21 13:23	2026-09-21 13:23	NEXT	NEXT261016C00007000	call	7.0000	2026-10-16	0.3700	0.3500	0.4500	6.0000	10235.00	0.00	10235.00	276	16	343	2812	0.121977240398293	0.526668615663265	0.533769279185583	false	false	false	true
d6fc20f7-dda1-464d-bbc6-e85f5d87159d	2026-09-21 13:19	2026-09-21 13:19	2026-09-21 13:19	CVX	CVX280121C00250000	call	250.0000	2028-01-21	11.8900	11.7500	12.0500	204.0000	34485.00	14340.00	20145.00	29	7	71	441	0.160997732426304	0.238228581549436	0.238228581549436	false	false	false	true
83215947-1199-4dbe-9766-f919b1962a2a	2026-09-21 13:19	2026-09-21 13:19	2026-09-21 13:19	CVX	CVX280121C00230000	call	230.0000	2028-01-21	16.9700	16.9000	17.7500	204.0000	22060.00	8500.00	13560.00	13	7	75	772	0.0971502590673575	0.229960075236906	0.23049222115118	false	false	false	true
7b5abed1-d1bc-4f35-9e03-206fbc062763	2026-09-21 13:15	2026-09-21 13:15	2026-09-21 13:15	OXY	OXY270115C00060000	call	60.0000	2027-01-15	3.2500	3.2500	3.3500	57.1450	73206.00	0.00	73206.00	225	29	744	33759	0.0220385674931129	0.321227640300633	0.322792186369701	false	false	false	true
c8662108-9ce0-48f7-bbea-3a2cd95c9008	2026-09-21 13:07	2026-09-21 13:07	2026-09-21 13:07	XOM	XOM281215C00220000	call	220.0000	2028-12-15	10.6500	10.6500	11.0500	158.2650	55390.00	1070.00	54320.00	52	6	144	228	0.631578947368421	0.244617642816152	0.245197516401791	false	false	false	true
020a3304-4c78-49e0-9f60-d93afc8a36e4	2026-09-21 13:02	2026-09-21 13:02	2026-09-21 13:02	EOG	EOG261016P00145000	put	145.0000	2026-10-16	7.4000	7.0000	7.5000	141.1100	113210.00	112470.00	740.00	153	22	157	454	0.345814977973568	0.360704957222298	0.367237731332938	false	false	false	true
ae88245f-741a-4cf7-bfd4-5587403a1bd2	2026-09-21 12:54	2026-09-21 12:54	2026-09-21 12:54	EQT	EQT261030C00051000	call	51.0000	2026-10-30	1.7000	1.6300	1.8000	49.0000	11907.00	343.00	11564.00	70	9	89	6	14.8333333333333	0.340993827956754	0.345682044770414	false	false	false	true
34067a8f-e1e7-4912-a295-845ac4e578a5	2026-09-21 12:23	2026-09-21 12:22	2026-09-21 12:22	XOM	XOM261218C00175000	call	175.0000	2026-12-18	3.5300	3.5000	3.6000	158.3400	19085.00	9585.00	5950.00	54	8	103	3962	0.0259969712266532	0.279848839476556	0.281760872742659	false	false	false	true
1fad091d-0fce-435d-99b7-8ae9a2548655	2026-09-21 12:20	2026-09-21 12:20	2026-09-21 12:20	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8100	1.7600	1.8100	47.0000	18070.00	18070.00	0.00	100	22	6816	18914	0.360367981389447	0.370954194913924	0.372317137253055	false	false	false	true
46c0568e-b8da-4fa7-af0e-2d67fc800c36	2026-09-21 12:14	2026-09-21 12:14	2026-09-21 12:14	CVX	CVX270115C00190000	call	190.0000	2027-01-15	21.8000	21.7000	22.5000	205.1250	74105.00	8760.00	65345.00	34	7	49	4248	0.0115348399246704	0.240603470806996	0.246241899468529	true	false	false	true
bf85cc7a-c7fa-4458-aea3-0495b99bdd88	2026-09-21 12:07	2026-09-21 12:07	2026-09-21 12:07	CVX	CVX280121C00250000	call	250.0000	2028-01-21	12.2800	12.2500	13.0000	205.3450	17185.00	3695.00	13490.00	14	7	21	441	0.0476190476190476	0.238966301055378	0.239526908368425	false	false	false	true
1f0b3867-1384-4e69-b9c7-983339d41e4f	2026-09-21 12:01	2026-09-21 12:01	2026-09-21 12:01	APA	APA260925P00047000	put	47.0000	2026-09-25	3.0000	2.9800	3.1000	44.0800	36609.00	1800.00	34809.00	122	16	901	1097	0.821330902461258	0.436965434851568	0.466810823385852	false	false	false	true
74d1e88b-e1ac-460d-a61d-f79038cb673e	2026-09-21 11:54	2026-09-21 11:54	2026-09-21 11:54	DVN	DVN261120C00050000	call	50.0000	2026-11-20	1.8800	1.8100	1.8800	47.2900	18769.00	18769.00	0.00	100	17	6615	18914	0.349740932642487	0.371857924807577	0.372125123105196	false	false	false	true
598bc770-55cd-456a-94f7-00e449192b72	2026-09-21 11:21	2026-09-21 11:21	2026-09-21 11:21	DVN	DVN261016C00047500	call	47.5000	2026-10-16	1.7300	1.6400	1.7300	47.2650	16423.00	16423.00	0.00	95	8	720	8634	0.0833912439193885	0.358910888728103	0.358910888728103	false	false	false	true
a670b87d-a621-4ad3-a22a-b5b5278a533b	2026-09-21 11:15	2026-09-21 11:15	2026-09-21 11:15	DVN	DVN261016C00047500	call	47.5000	2026-10-16	1.7100	1.6400	1.7100	47.2400	15374.00	15374.00	0.00	90	6	606	8634	0.0701876302988186	0.357431097930122	0.357431097930122	false	false	false	true
ae901486-a340-40a8-aea7-f9600a7f6e45	2026-09-21 11:14	2026-09-21 11:14	2026-09-21 11:14	DVN	DVN261016C00047500	call	47.5000	2026-10-16	1.7000	1.6300	1.7200	47.2300	16662.00	16662.00	0.00	98	5	516	8634	0.0597637248088951	0.358458139017624	0.358458139017624	false	false	false	true
251306bc-cb06-4e31-8ba5-ea8bab6606e8	2026-09-21 11:13	2026-09-21 11:13	2026-09-21 11:13	DVN	DVN261016C00047500	call	47.5000	2026-10-16	1.7200	1.6300	1.7300	47.2500	11840.00	11840.00	0.00	69	6	297	8634	0.0343988881167477	0.358430018492131	0.360457468077883	false	false	false	true
18373b93-7b87-4878-9744-b52258c823f7	2026-09-21 10:53	2026-09-21 10:53	2026-09-21 10:53	EQT	EQT270319C00045000	call	45.0000	2027-03-19	7.2400	7.0500	7.3000	49.0350	60846.00	60846.00	0.00	84	7	200	662	0.302114803625378	0.331829424978784	0.331829424978784	false	false	false	true
f2ecaa44-ee76-4b2f-8e41-152f948b2528	2026-09-21 10:46	2026-09-21 10:46	2026-09-21 10:46	COP	COP261016C00145000	call	145.0000	2026-10-16	0.3600	0.3300	0.4400	127.5800	10299.00	38.00	10261.00	286	41	330	1497	0.220440881763527	0.325020779778416	0.329139520512276	false	false	false	true
44cb3d10-7b8e-441b-aa53-e67193cf82c1	2026-09-21 10:22	2026-09-21 10:22	2026-09-21 10:22	CVX	CVX261009P00197500	put	197.5000	2026-10-09	1.6300	1.5200	1.9500	206.0000	13978.00	6705.00	7273.00	86	18	91	0	0	0.275996623478187	0.276743918504885	true	false	false	true
f6fec130-57e2-47fe-8b41-addf5318134d	2026-09-21 10:22	2026-09-21 10:22	2026-09-21 10:22	CVX	CVX260925P00200000	put	200.0000	2026-09-25	0.6500	0.6100	0.7400	206.4000	41420.00	924.00	40496.00	637	56	940	949	0.990516332982086	0.324748851712752	0.327505935656493	false	false	false	true
6489f309-2d37-42ef-b80d-acb9c45a48a6	2026-09-21 10:13	2026-09-21 10:12	2026-09-21 10:12	CVX	CVX270319P00230000	put	230.0000	2027-03-19	30.8500	28.5000	30.9000	205.5200	46274.00	46274.00	0.00	15	8	15	59	0.254237288135593	0.322733924459904	0.322733924459904	false	false	false	true
a255fd6d-17e3-4d0c-a66a-a3e86ba23eac	2026-09-21 10:12	2026-09-21 10:12	2026-09-21 10:12	EXE	EXE270416C00075000	call	75.0000	2027-04-16	15.6500	14.4000	15.9000	86.0000	39123.00	39123.00	0.00	25	5	450	100	4.5	0.316070138555699	0.316070138555699	true	false	false	true
4165b072-f1a6-4e5c-80bb-72daf3a9d222	2026-09-21 10:12	2026-09-21 10:11	2026-09-21 10:11	CVX	CVX270319C00210000	call	210.0000	2027-03-19	14.7000	14.2000	14.7000	205.0000	307161.00	307161.00	0.00	209	7	279	2010	0.138805970149254	0.255320673562244	0.255320673562244	false	false	false	true
7a849b47-7046-438e-9894-9a137bcf57d4	2026-09-21 10:07	2026-09-21 10:07	2026-09-21 10:07	VLO	VLO260925P00390000	put	390.0000	2026-09-25	4.1000	3.1000	4.9000	406.7300	204788.00	200487.00	4301.00	500	5	538	180	2.98888888888889	0.614121408576127	0.614121408576127	false	false	false	true
e1b48289-1643-4763-a5b8-c95ad5ebefbf	2026-09-18 15:52	2026-09-18 15:52	2026-09-18 15:52	CVX	CVX260918P00207500	put	207.5000	2026-09-18	0.3100	0.2900	0.3300	208.0000	71595.00	65775.00	5820.00	2283	27	3905	953	4.09758656873033	2.32882247736013	2.32882247736013	false	false	false	true
41190f3d-7508-4e55-9c27-06ad9b04b885	2026-09-18 15:41	2026-09-18 15:41	2026-09-18 15:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6400	1.6000	1.8300	91.6250	22429.00	21609.00	820.00	137	12	1935	10270	0.188412852969815	0.432110839691357	0.433383102390724	false	false	false	true
b2c789d6-ab97-4fce-98a8-2b46c6c1b17f	2026-09-18 14:33	2026-09-18 14:33	2026-09-18 14:33	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	4.6000	5.1000	92.6800	86010.00	63500.00	22005.00	172	53	463	538	0.860594795539034	0.495615540111808	0.495615540111808	true	false	false	true
fe4b329e-8777-47c3-8dff-b10dc0c0dd71	2026-09-18 14:33	2026-09-18 14:33	2026-09-18 14:33	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.9300	4.6000	5.0000	92.5200	72991.00	69526.00	0.00	148	15	290	538	0.539033457249071	0.493271234030009	0.496627684515941	false	false	false	true
0b47bcb2-a516-41bd-9e85-14436365984e	2026-09-18 13:49	2026-09-18 13:49	2026-09-18 13:49	CLMT	CLMT261120C00055000	call	55.0000	2026-11-20	8.5400	8.5000	9.0000	58.8100	298778.00	0.00	298778.00	350	12	473	2378	0.198906644238856	0.655315390867567	0.672701849841337	false	false	false	true
9bb5562b-f813-4c0b-acdd-1bb79525736a	2026-09-18 13:48	2026-09-18 13:48	2026-09-18 13:48	CCJ	CCJ270319C00100000	call	100.0000	2027-03-19	10.9600	10.3500	12.5500	93.5200	109580.00	0.00	109580.00	100	16	124	406	0.305418719211823	0.483304120259694	0.483304120259694	false	false	false	true
46ce1379-ecb3-4171-a64b-1895deab9e71	2026-09-18 12:28	2026-09-18 12:28	2026-09-18 12:28	CCJ	CCJ290119C00120000	call	120.0000	2029-01-19	21.3000	21.0000	23.0000	91.3600	14910.00	6420.00	8490.00	7	5	7	30	0.233333333333333	0.479009257434324	0.486262858638706	false	false	false	true
faec55f1-c06b-4e82-812d-822576da363b	2026-09-18 11:54	2026-09-18 11:54	2026-09-18 11:54	FRO	FRO261016P00044200	put	44.2000	2026-10-16	0.5500	0.5000	0.5500	51.2100	22345.00	22345.00	0.00	409	29	2115	0	0	0.522066535882521	0.528578224683167	false	false	false	true
e3a7eebf-df53-4ba3-ab63-584420c65a16	2026-09-18 10:19	2026-09-18 10:19	2026-09-18 10:19	COP	COP260918C00120000	call	120.0000	2026-09-18	13.0000	12.5000	13.5000	132.9300	616164.00	0.00	5164.00	474	6	496	3988	0.124373119358074	3.28979702618828	3.28979702618828	false	false	false	true
3182a20d-9d10-4f31-9337-3462ff640e0f	2026-09-18 10:02	2026-09-18 10:02	2026-09-18 10:02	XOM	XOM281215C00180000	call	180.0000	2028-12-15	23.1800	22.4000	23.3500	162.7100	254935.00	236475.00	18460.00	110	14	231	1183	0.195266272189349	0.235739013296201	0.237099775211483	true	false	false	true
b53f1976-4e1d-4545-8aab-f126536d7ef4	2026-09-18 10:02	2026-09-18 10:01	2026-09-18 10:01	XOM	XOM281215C00180000	call	180.0000	2028-12-15	23.1400	22.4000	23.3500	162.6900	141138.00	141138.00	0.00	61	6	121	1183	0.102282333051564	0.235754552253188	0.235754552253188	false	false	false	true
0e72fe8b-ebeb-433b-acc4-c2159de88f28	2026-09-18 09:33	2026-09-18 09:33	2026-09-18 09:33	XOM	XOM280121P00180000	put	180.0000	2028-01-21	28.3500	28.3500	29.0500	163.2500	144605.00	5685.00	138920.00	51	11	51	151	0.337748344370861	0.3319805139867	0.3319805139867	false	false	false	true
d8a877b3-20c0-4189-acbb-e41bc92b67ba	2026-09-17 15:06	2026-09-17 15:06	2026-09-17 15:06	VLO	VLO280121P00380000	put	380.0000	2028-01-21	62.1200	62.0000	63.8000	411.9400	205010.00	93310.00	111700.00	33	11	33	502	0.0657370517928287	0.49646873273692	0.497075338718341	true	false	false	true
d01c7e8e-f74e-4f28-998d-5b35acc0727d	2026-09-17 13:42	2026-09-17 13:42	2026-09-17 13:42	MPC	MPC270617P00380000	put	380.0000	2027-06-17	46.1800	45.0000	47.1000	421.7800	115450.00	46400.00	69050.00	25	5	31	27	1.14814814814815	0.517576278729119	0.518367556069928	false	false	false	true
4efcec8a-065e-4ebe-b51c-80d725e00f6d	2026-09-17 13:42	2026-09-17 13:42	2026-09-17 13:42	MPC	MPC270617P00440000	put	440.0000	2027-06-17	77.2900	77.1000	78.7000	421.8900	123661.00	31000.00	84941.00	16	11	76	62	1.2258064516129	0.519611408306381	0.521716480424428	true	false	false	true
ee2b4e02-9e6f-4d04-b821-8dcaea6a0821	2026-09-17 12:36	2026-09-17 12:36	2026-09-17 12:36	DINO	DINO261016C00115000	call	115.0000	2026-10-16	7.4000	7.4000	7.8000	115.0950	142087.00	0.00	142087.00	192	36	1263	1155	1.09350649350649	0.555621971056684	0.555621971056684	false	false	false	true
89b13afc-9f29-46d3-8db2-9798e156bcb4	2026-09-17 12:26	2026-09-17 12:26	2026-09-17 12:26	WES	WES261120C00045000	call	45.0000	2026-11-20	2.5000	2.5000	2.7000	46.4800	31506.00	0.00	31506.00	126	12	551	1735	0.317579250720461	0.181513103131055	0.187829870946085	false	false	false	true
19ec89ba-1d85-4072-8847-c8c0bf23c5f5	2026-09-17 11:54	2026-09-17 11:54	2026-09-17 11:54	CLMT	CLMT260918C00060000	call	60.0000	2026-09-18	0.4500	0.4000	0.6500	58.9000	10944.00	1125.00	9819.00	243	22	1094	2333	0.46892413201886	0.71877419057438	0.71877419057438	true	false	false	true