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

fb7684c6-255d-43b6-96c5-cae0ac4cb37b	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	DVN	DVN261002P00048000	put	48.0000	2026-10-02	0.8700	0.7500	1.0000	48.5150	12354.00	12006.00	348.00	142	25	144	1085	0.132718894009217	0.380512057214489	0.373630764231846	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	52844000000.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T16:47:02.093743Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
ea021909-e2c3-4cf9-b06f-d7cac6624483	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	EOG	EOG261002P00144000	put	144.0000	2026-10-02	3.8000	3.7000	3.8000	142.4200	13680.00	13680.00	0.00	36	11	36	5	7.2	0.337520497304203	0.337520497304203	false	false	false	true
d9b809f8-683e-4bf6-b1ab-2429efcfec88	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	DINO	DINO261218C00095000	call	95.0000	2026-12-18	16.7000	16.7000	19.1000	105.6300	502670.00	0.00	502670.00	301	10	301	447	0.67337807606264	0.511987159397715	0.511987159397715	false	false	false	true
d93b324f-4cf0-489c-827e-8f109c1f4ce5	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	DK	DK270115C00077500	call	77.5000	2027-01-15	7.9000	7.9000	8.8000	71.3100	103490.00	0.00	103490.00	131	8	139	52	2.67307692307692	0.627248764035197	0.627248764035197	false	false	false	true
d599325a-bf98-4027-8cc0-bdc9c98629ff	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	XOM	XOM261218C00155000	call	155.0000	2026-12-18	12.4100	12.4000	13.1500	160.9500	393256.00	0.00	393256.00	317	5	323	4346	0.0743212149102623	0.267278550066493	0.267630557797311	false	false	false	true
d34b7979-7542-4363-b205-ce4cdee18731	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	CVX	CVX261016P00207500	put	207.5000	2026-10-16	5.9500	5.6000	5.9500	205.9900	64260.00	64260.00	0.00	108	6	112	9	12.4444444444444	0.270299545865438	0.26311680371855	false	false	false	true
cfc394ad-382f-45f9-8b8b-6f217e3b49dd	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261009P00059000	put	59.0000	2026-10-09	2.3500	2.1900	2.3500	57.6300	71431.00	69325.00	2106.00	304	9	312	124	2.51612903225806	0.347317102200392	0.334696072524633	true	false	false	true
c993c9b6-2f26-4621-b61b-fb4ce9b59522	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	PBF	PBF261016C00060000	call	60.0000	2026-10-16	11.6000	11.6000	13.5000	70.5019	133400.00	0.00	133400.00	115	13	115	78	1.47435897435897	0.668494147819132	0.668494147819132	false	false	false	true
c32bef40-d047-457f-81ac-d6357502caf2	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	MPC	MPC261016C00340000	call	340.0000	2026-10-16	51.9000	51.9000	54.4000	388.8200	228360.00	0.00	228360.00	44	10	175	172	1.01744186046512	0.448734672280319	0.448734672280319	false	false	false	true
bb4372e6-dc10-40f1-83c4-4fcfbdd00544	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261002P00058000	put	58.0000	2026-10-02	1.3800	1.2700	1.3800	57.7110	10350.00	10350.00	0.00	75	6	104	86	1.2093023255814	0.347993215855464	0.347993215855464	false	false	false	true
b0d12066-e459-4822-9cae-7aebf9a24d91	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	VIST	VIST261120C00080000	call	80.0000	2026-11-20	2.0000	2.0000	2.3000	69.4000	247400.00	0.00	247400.00	1237	7	1510	3739	0.403851297138272	0.480562191156901	0.480562191156901	false	false	false	true
80fa7173-a827-4b91-86e4-d854c29addfd	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	XOM	XOM261218P00170000	put	170.0000	2026-12-18	14.6500	13.8500	14.6500	160.9500	147965.00	147965.00	0.00	101	5	101	434	0.232718894009217	0.331129059871229	0.331129059871229	false	false	false	true
7a8b4442-0e9a-430b-a92e-5440443a047e	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	CVX	CVX261016P00220000	put	220.0000	2026-10-16	15.1000	14.0500	15.1000	206.2800	332200.00	332200.00	0.00	220	5	224	433	0.517321016166282	0.305072035594472	0.305072035594472	false	false	false	true
74e54e9d-68c3-4aca-af15-ccd36e0c702e	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	DVN	DVN261002P00049500	put	49.5000	2026-10-02	1.6800	1.5000	1.6800	48.5150	31920.00	31920.00	0.00	190	11	190	31	6.12903225806452	0.385817595530768	0.375367354512501	false	false	false	true
7349e51f-0684-410d-a1c1-d46b92310aab	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	PR	PR261120C00020000	call	20.0000	2026-11-20	2.5500	2.5500	2.6000	21.8450	21930.00	0.00	21930.00	86	15	86	1	86	0.403865537741409	0.403865537741409	false	false	false	true
5ec6f0c6-843a-4a27-92df-bcb24d593d82	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	DK	DK270115C00075000	call	75.0000	2027-01-15	8.7000	8.7000	10.0000	71.3100	144420.00	0.00	144420.00	166	13	166	59	2.8135593220339	0.619921447217755	0.619921447217755	false	false	false	true
5737cbe1-46ce-4603-907a-849e8e2a295a	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	VLO	VLO270319C00410000	call	410.0000	2027-03-19	41.3000	41.3000	44.6000	376.1500	1061410.00	0.00	1061410.00	257	24	266	215	1.23720930232558	0.485885685846576	0.493764013298648	true	false	false	true
5642c705-64f9-4348-94f2-2df4006aacea	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	CVE	CVE261016P00035000	put	35.0000	2026-10-16	3.9000	3.5000	3.9000	31.2900	58490.00	58490.00	0.00	150	10	150	736	0.203804347826087	0.444894104414147	0.424294091245781	false	false	false	true
4ec0fba3-0476-497d-aaae-8286a67db818	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261002P00057000	put	57.0000	2026-10-02	0.9100	0.8300	0.9100	57.7110	17654.00	17654.00	0.00	194	7	213	1214	0.175453047775947	0.349876790014241	0.349876790014241	false	false	false	true
42b3511f-002a-4c6a-b7fc-5ed7150195fb	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	CVX	CVX261002P00210000	put	210.0000	2026-10-02	5.8000	5.1000	5.8000	206.2800	347420.00	347420.00	0.00	599	17	622	345	1.80289855072464	0.290540885233524	0.290540885233524	true	false	false	true
3bf35c38-64d7-49c6-b37f-60ffc993a54c	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	XOM	XOM261120C00155000	call	155.0000	2026-11-20	10.9000	10.9000	11.8000	160.7100	331365.00	1095.00	330270.00	304	7	320	4156	0.0769971126082772	0.274523200602811	0.281499244759137	true	false	false	true
33ee7f67-fca3-4c2b-8f14-fdd014b91e2e	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261016P00059000	put	59.0000	2026-10-16	2.6100	2.4800	2.6100	57.7110	119538.00	119538.00	0.00	458	19	472	0	0	0.340594452024208	0.340594452024208	false	false	false	true
2f3cb287-0d5a-4ec1-9b77-10787779fa94	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	CNQ	CNQ261002P00047000	put	47.0000	2026-10-02	0.5500	0.4500	0.7000	48.0150	10780.00	10120.00	660.00	196	9	201	16	12.5625	0.342290152328372	0.333365101461538	false	false	false	true
2b50c3e7-f314-4cca-b509-a0b311ac3e18	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	EOG	EOG261016P00146000	put	146.0000	2026-10-16	7.2000	7.1000	7.2000	142.4200	24480.00	24480.00	0.00	34	9	34	3	11.3333333333333	0.377449920888682	0.377449920888682	false	false	false	true
27726d80-3784-4c38-9a2b-11940f0b111d	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	CVX	CVX260925P00207500	put	207.5000	2026-09-25	2.7600	1.9800	2.7600	206.2800	312984.00	312984.00	0.00	1134	32	1178	312	3.77564102564103	0.347200763649255	0.347200763649255	true	false	false	true
26187898-b6d6-4cf1-8413-c925546339a2	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	OXY	OXY261016P00060000	put	60.0000	2026-10-16	3.2500	3.2000	3.2500	57.7110	34770.00	34450.00	320.00	107	5	147	1856	0.0792025862068965	0.340104058778011	0.340104058778011	false	false	false	true
1f5d94d3-320a-414b-a5ae-b300f8bb8f6b	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	CVX	CVX261120C00210000	call	210.0000	2026-11-20	7.5500	7.5500	7.7000	205.9900	12835.00	0.00	12835.00	17	9	128	1877	0.068193926478423	0.263179341133203	0.267394244974595	false	false	false	true
0cd2e05a-6039-451d-a581-a2c2b7e8dcbb	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	CVE	CVE261016P00036000	put	36.0000	2026-10-16	4.9000	3.9000	4.9000	31.3401	340060.00	340060.00	0.00	694	21	694	600	1.15666666666667	0.517134084074077	0.517134084074077	false	false	false	true
62c670c7-79cf-4369-9900-a8630107dbe9	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	EOG	EOG270319P00135000	put	135.0000	2027-03-19	8.8000	8.5000	9.1000	142.4700	21120.00	20240.00	0.00	24	8	44	349	0.126074498567335	0.349394161860552	0.349394161860552	false	false	false	true
7f7231e1-a69e-4c4b-b06d-c8accc5ea742	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	PBR	PBR261016C00023000	call	23.0000	2026-10-16	0.4500	0.4300	0.4700	21.1900	29700.00	28305.00	1395.00	660	10	1113	15429	0.0721368850865254	0.503811710198515	0.504602895146587	true	false	false	true
f692b4aa-e6ad-42b1-bae9-2efdbefbadba	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	PSX	PSX261120C00220000	call	220.0000	2026-11-20	41.7000	40.9000	41.8000	255.8700	154290.00	154290.00	0.00	37	10	38	449	0.0846325167037862	0.428160705941791	0.449315929206658	true	false	false	true
7469747a-0843-4822-aaf5-a49a7ec458de	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	MPC	MPC261016P00430000	put	430.0000	2026-10-16	46.5000	43.8000	47.2000	389.2400	55800.00	46500.00	4660.00	12	7	17	254	0.0669291338582677	0.511942521055483	0.515194367691546	true	false	false	true
d6629307-5a1c-4492-b9f2-6db46ae913df	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	PSX	PSX261016P00270000	put	270.0000	2026-10-16	18.9800	18.8000	19.3000	257.0600	58850.00	3820.00	55030.00	31	7	56	154	0.363636363636364	0.454920450933191	0.44249769709977	false	false	false	true
b70c5f96-b4bb-47bf-af89-9761f7fcef92	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	PSX	PSX260925C00245000	call	245.0000	2026-09-25	12.3000	12.0000	12.3000	256.6900	100860.00	100860.00	0.00	82	13	82	18	4.55555555555556	0.529341559727517	0.529341559727517	false	false	false	true
8b6474e2-b2c2-453d-ba6c-f2c559aa736c	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	MPC	MPC261016C00340000	call	340.0000	2026-10-16	53.8000	53.1000	53.8000	389.4800	581040.00	581040.00	0.00	108	6	117	172	0.680232558139535	0.517786467102924	0.517786467102924	false	false	false	true
473ff9fa-124b-44ee-88d1-b74e45d3aba2	2026-09-23 12:46	2026-09-23 12:46	2026-09-23 12:46	DINO	DINO261016P00120000	put	120.0000	2026-10-16	15.8000	15.6000	16.2000	105.8200	18960.00	1580.00	17380.00	12	7	15	136	0.110294117647059	0.593815306415126	0.593815306415126	false	false	false	true
e10ffa58-18f1-4634-bef4-d18b2510091a	2026-09-23 12:40	2026-09-23 12:40	2026-09-23 12:40	XOM	XOM270319P00165000	put	165.0000	2027-03-19	14.5500	14.4500	14.6500	161.0000	17460.00	16005.00	1455.00	12	5	30	1846	0.0162513542795233	0.318595317353811	0.318595317353811	false	false	false	true
225ad487-8858-4cc1-a59d-ce50fdc02c3f	2026-09-23 12:38	2026-09-23 12:37	2026-09-23 12:37	DINO	DINO270115C00120000	call	120.0000	2027-01-15	8.7000	8.7000	9.1000	106.4600	16530.00	0.00	16530.00	19	6	20	173	0.115606936416185	0.555829077824587	0.555829077824587	false	false	false	true
ef2518ef-39a3-4ae1-bd0b-b9b35fa27233	2026-09-23 12:35	2026-09-23 12:35	2026-09-23 12:35	LNG	LNG261002C00277500	call	277.5000	2026-10-02	6.8000	6.8000	7.6000	277.5200	42160.00	0.00	42160.00	62	17	63	541	0.11645101663586	0.38295416900477	0.38295416900477	false	false	false	true
54a102c9-5036-433c-9639-e32194010b84	2026-09-23 12:34	2026-09-23 12:34	2026-09-23 12:34	XOM	XOM290119C00160000	call	160.0000	2029-01-19	30.6000	30.6000	31.7000	161.0500	21420.00	0.00	21420.00	7	6	18	67	0.26865671641791	0.223530691605535	0.223530691605535	false	false	false	true
e5cbc2eb-a9ff-4e3b-81ad-b909981485ac	2026-09-23 12:29	2026-09-23 12:29	2026-09-23 12:29	HAL	HAL270115P00033000	put	33.0000	2027-01-15	2.3600	2.1700	2.3800	33.3650	26668.00	1416.00	25252.00	113	7	113	217	0.52073732718894	0.373776842221853	0.373776842221853	false	false	false	true
ddac5961-1c8f-4dd1-8efe-b6ac78636248	2026-09-23 12:27	2026-09-23 12:27	2026-09-23 12:27	CCJ	CCJ261016P00090000	put	90.0000	2026-10-16	2.9000	2.8300	2.9700	92.0900	13050.00	0.00	12760.00	45	6	1286	3014	0.426675514266755	0.433994800933427	0.433994800933427	false	false	false	true
6f999fee-71e4-4677-8366-0eec50bded30	2026-09-23 12:21	2026-09-23 12:21	2026-09-23 12:21	CVX	CVX281215C00250000	call	250.0000	2028-12-15	20.2500	20.0500	20.6500	206.4200	48600.00	14175.00	34425.00	24	13	112	180	0.622222222222222	0.223793554906145	0.223793554906145	true	false	false	true
c0b3e7d5-7c7e-4330-93b8-a6b2b70eb756	2026-09-23 12:21	2026-09-23 12:20	2026-09-23 12:20	CVX	CVX281215C00250000	call	250.0000	2028-12-15	20.2500	20.0500	20.4500	206.3800	10125.00	8100.00	0.00	5	5	85	180	0.472222222222222	0.22394493078437	0.22394493078437	true	false	false	true
2890cc80-1e01-4367-af9d-a271a30c5ea1	2026-09-23 12:20	2026-09-23 12:20	2026-09-23 12:20	CVX	CVX281215C00250000	call	250.0000	2028-12-15	20.3000	20.2500	20.8000	206.3801	42630.00	0.00	38570.00	21	10	61	180	0.338888888888889	0.224352918992415	0.224352918992415	true	false	false	true
af62d327-08f6-4f23-b0f5-93e73c44bd74	2026-09-23 12:20	2026-09-23 12:20	2026-09-23 12:20	CVX	CVX281215C00250000	call	250.0000	2028-12-15	20.3000	20.2500	20.8000	206.3801	69025.00	2035.00	64960.00	34	11	40	180	0.222222222222222	0.224352918992415	0.224352918992415	true	false	false	true
414a9afa-8693-4900-b33e-3cc21917eb58	2026-09-23 12:16	2026-09-23 12:16	2026-09-23 12:16	BP	BP261016P00045000	put	45.0000	2026-10-16	1.6500	1.6400	1.7000	44.3700	30195.00	0.00	30030.00	183	25	214	8902	0.0240395416760279	0.307900351516616	0.307900351516616	false	false	false	true
044a02ab-9cbf-4c24-9ae9-bc08326b105e	2026-09-23 12:14	2026-09-23 12:14	2026-09-23 12:14	CVX	CVX281215C00200000	call	200.0000	2028-12-15	38.0000	37.7500	38.5500	206.5100	114000.00	106400.00	7600.00	30	7	30	955	0.031413612565445	0.194864624066243	0.194864624066243	true	false	false	true
6133be6c-5016-4035-9d34-723721b89ef3	2026-09-23 12:13	2026-09-23 12:13	2026-09-23 12:13	PBR	PBR261016C00022000	call	22.0000	2026-10-16	0.7600	0.7500	0.7700	21.2450	13680.00	9728.00	3952.00	180	21	1664	32817	0.0507054270652406	0.496941232836587	0.496941232836587	true	false	false	true
e244dc19-b09d-4620-9147-7cfc68d1b75f	2026-09-23 12:10	2026-09-23 12:10	2026-09-23 12:10	XOM	XOM261009P00162500	put	162.5000	2026-10-09	4.6000	4.5500	4.8000	161.0250	24840.00	0.00	24840.00	54	10	76	216	0.351851851851852	0.291919165433402	0.294525896853861	true	false	false	true