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

7137d30c-181d-49c8-a18a-09aee1029644	2026-09-23 12:54	2026-09-23 12:54	2026-09-23 12:54	VLO	VLO261016P00380000	put	380.0000	2026-10-16	25.2000	24.1000	25.2000	369.3450	15120.00	12600.00	0.00	6	6	212	582	0.36426116838488	0.533414755869481	0.533414755869481	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	108214656942.00	2026-10-22	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T16:56:20.780869Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
8e9719b3-b51c-4089-93f8-bb087507e737	2026-09-23 12:53	2026-09-23 12:53	2026-09-23 12:53	VLO	VLO261016P00380000	put	380.0000	2026-10-16	25.0000	23.0000	26.2000	370.0000	22500.00	20000.00	2500.00	9	9	203	582	0.348797250859107	0.554779079197029	0.537728199555106	false	false	false	true
5f25c9e4-d4c0-4fc4-9a60-f056104f002f	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	SHEL	SHEL260925C00096000	call	96.0000	2026-09-25	0.3500	0.2000	0.5000	94.3600	14000.00	7000.00	7000.00	400	10	428	103	4.15533980582524	0.337164794488226	0.337164794488226	false	false	false	true
a7a105c7-4661-4425-9b46-512387ef92df	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	VLO	VLO261016P00380000	put	380.0000	2026-10-16	28.0000	25.5000	28.4000	365.9600	145600.00	145600.00	0.00	52	5	188	582	0.323024054982818	0.557365380894366	0.558158789890914	false	false	false	true
e54be3ee-1142-4333-9a48-b76b939e9c0c	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	OXY	OXY261030P00060000	put	60.0000	2026-10-30	3.9000	3.7000	3.9000	57.3400	99060.00	99060.00	0.00	254	29	349	23	15.1739130434783	0.338021952152236	0.338021952152236	false	false	false	true
bfe921b5-9127-4206-9430-a2a92e54681c	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	CLMT	CLMT261016P00048000	put	48.0000	2026-10-16	1.2500	1.0500	1.2500	52.8750	22000.00	22000.00	0.00	176	29	176	5	35.2	0.622460746632314	0.622460746632314	false	false	false	true
f54fd19f-30bf-4ba0-9fdc-4aa2f54a9ec9	2026-09-23 12:50	2026-09-23 12:50	2026-09-23 12:50	XOM	XOM260925P00160000	put	160.0000	2026-09-25	1.5700	1.3700	1.6300	160.3100	18997.00	18997.00	0.00	121	5	1235	1395	0.885304659498208	0.367308218319726	0.367308218319726	false	false	false	true
ef36ba7f-69d8-4041-be31-3b345ab7c767	2026-09-23 12:50	2026-09-23 12:49	2026-09-23 12:49	EQNR	EQNR261120P00045000	put	45.0000	2026-11-20	4.1000	3.9000	4.1000	42.6350	278389.00	278389.00	0.00	679	9	695	59	11.7796610169492	0.425053597408478	0.425053597408478	false	false	false	true
756d3425-e5ff-4d65-9ae1-2a0c8630c2f0	2026-09-23 12:50	2026-09-23 12:49	2026-09-23 12:49	EQNR	EQNR261120P00046000	put	46.0000	2026-11-20	4.8000	4.6000	4.8000	42.6350	222240.00	222240.00	0.00	463	6	482	0	0	0.43095521390021	0.43095521390021	false	false	false	true
c11e52b7-f3b8-45bf-8895-8ab9f19591f2	2026-09-23 12:49	2026-09-23 12:49	2026-09-23 12:49	PBF	PBF261016P00060000	put	60.0000	2026-10-16	1.5500	1.4500	1.6000	69.3100	64480.00	9920.00	54560.00	416	14	473	1021	0.463271302644466	0.758992710686959	0.758992710686959	false	false	false	true
c5f6d5e1-848f-4e83-99d2-81381c821d20	2026-09-23 12:49	2026-09-23 12:49	2026-09-23 12:49	OKE	OKE261016P00090000	put	90.0000	2026-10-16	1.8000	1.7000	1.8000	91.5750	10980.00	10980.00	0.00	61	22	167	2245	0.0743875278396437	0.28655631742682	0.28655631742682	false	false	false	true
64301f96-bb50-4ab3-9fa7-e2d9a7bcfd88	2026-09-23 12:47	2026-09-23 12:47	2026-09-23 12:47	MPC	MPC261016P00390000	put	390.0000	2026-10-16	20.4900	20.2000	21.0000	388.3100	47120.00	41000.00	6120.00	23	12	99	1061	0.0933081998114986	0.517801347507712	0.517801347507712	false	false	false	true
50f23dcf-05b8-4070-a19c-e6ec979617e3	2026-09-23 12:47	2026-09-23 12:47	2026-09-23 12:47	APA	APA261016P00042500	put	42.5000	2026-10-16	1.2300	1.1600	1.2300	43.9200	14514.00	14514.00	0.00	118	5	176	1312	0.134146341463415	0.439000402783732	0.439000402783732	false	false	false	true
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
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