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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 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×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

7c5014e9-50b9-43d6-8dba-65d48f1273db	2026-09-28 13:41	2026-09-28 13:41	2026-09-28 13:41	OXY	OXY290119C00052500	call	52.5000	2029-01-19	14.6400	14.1500	15.0500	56.0000	83420.00	24870.00	58550.00	57	12	76	0	0	0.289434008162883	0.291224315521974	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	56079656513.00	2026-11-09	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T17:41:35.586557Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
11f9f593-3b3c-40dd-a4aa-e74754c09c7c	2026-09-28 13:41	2026-09-28 13:41	2026-09-28 13:41	OXY	OXY290119C00052500	call	52.5000	2029-01-19	14.6700	14.1500	14.9500	56.0000	35210.00	2935.00	32275.00	24	5	100	0	0	0.291091972736615	0.292881050262301	false	false	false	true
6daaf8e7-2254-46b0-afa1-e1ef98f7b6b2	2026-09-28 13:33	2026-09-28 13:33	2026-09-28 13:33	SU	SU270115C00080000	call	80.0000	2027-01-15	1.6500	1.6500	1.7500	69.0000	27555.00	0.00	27555.00	167	23	167	2678	0.0623599701269604	0.318489273206089	0.318489273206089	false	false	false
698b6c7e-6655-4430-b855-74072c00ee83	2026-09-28 13:33	2026-09-28 13:33	2026-09-28 13:33	SU	SU270115C00070000	call	70.0000	2027-01-15	4.8000	4.8000	5.0000	69.0000	105120.00	0.00	105120.00	219	29	246	3415	0.0720351390922401	0.31662049329314	0.31662049329314	false	false	false
30096223-3296-4fad-8734-2a74368af9c2	2026-09-28 13:29	2026-09-28 13:29	2026-09-28 13:29	CLMT	CLMT290119C00085000	call	85.0000	2029-01-19	13.8000	13.5000	14.8000	52.8150	34500.00	26220.00	8280.00	25	5	25	175	0.142857142857143	0.634806725928557	0.634806725928557	false	false	false
6bd92459-8f90-4239-85c2-6784212deb93	2026-09-28 13:26	2026-09-28 13:26	2026-09-28 13:26	SLB	SLB261016P00050000	put	50.0000	2026-10-16	1.0800	1.0700	1.1400	51.1150	11016.00	0.00	11016.00	102	21	271	1804	0.150221729490022	0.36106461070897	0.358724268578568	false	false	false
59361f74-c83c-4f12-bf2f-f8c8606a20b4	2026-09-28 13:21	2026-09-28 13:21	2026-09-28 13:21	CVX	CVX261002P00190000	put	190.0000	2026-10-02	0.1000	0.0200	0.1200	206.4850	15629.00	15629.00	0.00	1563	43	1615	1621	0.996298581122764	0.423193626256809	0.423193626256809	false	false	false
aaf721c3-a7cf-46a3-9e7c-1d25d4c8c889	2026-09-28 13:15	2026-09-28 13:14	2026-09-28 13:14	BP	BP261106C00046000	call	46.0000	2026-11-06	1.3700	1.3400	1.7400	44.4400	10935.00	5496.00	5439.00	80	6	243	0	0	0.333862856202944	0.333862856202944	true	false	false	true
fe038849-9bff-4ac3-9f66-f75f6f3ecd38	2026-09-28 13:14	2026-09-28 13:14	2026-09-28 13:14	PBR	PBR261009C00021500	call	21.5000	2026-10-09	0.5700	0.5600	0.5700	20.7300	28500.00	28500.00	0.00	500	6	1449	1770	0.81864406779661	0.611435301589683	0.611435301589683	true	false	false
67aceaee-f291-4756-8031-85b893892dc1	2026-09-28 13:13	2026-09-28 13:13	2026-09-28 13:13	PSX	PSX270617P00250000	put	250.0000	2027-06-17	32.2000	31.6000	33.7000	252.9200	61180.00	3220.00	57960.00	19	5	31	76	0.407894736842105	0.449662673100698	0.449662673100698	false	false	false
3b1da4dd-b12e-4103-8e41-4e49a5856748	2026-09-28 13:12	2026-09-28 13:11	2026-09-28 13:11	LPG	LPG261218C00055000	call	55.0000	2026-12-18	4.5100	4.4000	5.0000	54.5000	11275.00	4950.00	6325.00	25	6	455	45	10.1111111111111	0.444365484429678	0.439456625810005	false	false	false
7caaec0e-ef47-4cc2-bcd6-e2788205239c	2026-09-28 13:12	2026-09-28 13:11	2026-09-28 13:11	VLO	VLO261002P00392500	put	392.5000	2026-10-02	13.5000	10.8000	13.5000	387.0000	10800.00	10800.00	0.00	8	8	9	7	1.28571428571429	0.653042532214736	0.653042532214736	false	false	false
fed797b3-aaca-466e-9f30-2e1b0885640e	2026-09-28 13:11	2026-09-28 13:11	2026-09-28 13:11	FRO	FRO261016P00050000	put	50.0000	2026-10-16	3.4000	3.3000	3.4000	48.0850	17000.00	17000.00	0.00	50	9	52	6996	0.00743281875357347	0.54943676559381	0.54943676559381	false	false	false
fcd67069-87d1-4add-b37f-bd8f507cf8cf	2026-09-28 13:11	2026-09-28 13:11	2026-09-28 13:11	DHT	DHT261016C00019000	call	19.0000	2026-10-16	3.1000	3.1000	3.4000	21.9400	17360.00	0.00	17360.00	56	15	56	1007	0.0556107249255213	0.510938951486744	0.527789266122234	false	false	false
d6d032d5-5cfb-429e-9ba6-9b822c0267e2	2026-09-28 13:11	2026-09-28 13:11	2026-09-28 13:11	DHT	DHT261120P00023000	put	23.0000	2026-11-20	3.0000	2.7000	3.1000	21.9400	246300.00	46200.00	200100.00	821	6	822	115	7.14782608695652	0.742827912204135	0.740574923085986	true	false	false
46aedabb-2bf7-4bdc-bd95-99d68b12958d	2026-09-28 13:11	2026-09-28 13:11	2026-09-28 13:11	STNG	STNG261016C00080000	call	80.0000	2026-10-16	5.3000	4.9000	5.3000	83.8050	20140.00	20140.00	0.00	38	5	143	711	0.20112517580872	0.399792867776755	0.399792867776755	false	false	false
021fe8ba-f1f4-40e3-93b7-d360c215ff39	2026-09-28 13:11	2026-09-28 13:11	2026-09-28 13:11	DHT	DHT261016P00023000	put	23.0000	2026-10-16	1.7000	1.6500	1.7000	21.9400	18699.00	18699.00	0.00	110	12	292	388	0.752577319587629	0.568930180757754	0.563972853630863	false	false	false
fb6b5b8d-1997-4bab-8442-0325c248a50d	2026-09-28 13:06	2026-09-28 13:06	2026-09-28 13:06	DNN	DNN261120C00003000	call	3.0000	2026-11-20	0.1100	0.1000	0.1500	2.5850	33000.00	9000.00	24000.00	3000	2	3230	195	16.5641025641026	0.733087351114749	0.733087351114749	false	true	false
a64eec68-fce7-4fe1-83fb-10082a18762b	2026-09-28 13:03	2026-09-28 13:03	2026-09-28 13:03	XOM	XOM270416P00145000	put	145.0000	2027-04-16	6.2500	6.2500	6.5500	162.3900	21250.00	0.00	21250.00	34	6	64	46	1.39130434782609	0.32109157156309	0.32109157156309	false	false	false
52e26440-9240-4eab-9dfe-80816252cf65	2026-09-28 13:01	2026-09-28 13:01	2026-09-28 13:01	EXE	EXE261120C00085000	call	85.0000	2026-11-20	4.7300	4.6000	5.5000	85.9400	47316.00	0.00	47316.00	100	7	200	660	0.303030303030303	0.308148823231909	0.308148823231909	false	false	false
1c6555d6-42c7-458f-8fab-eed1e8121475	2026-09-28 12:54	2026-09-28 12:53	2026-09-28 12:53	PUMP	PUMP261218C00012500	call	12.5000	2026-12-18	0.4500	0.4000	0.5000	9.4450	18000.00	13500.00	4500.00	400	15	402	6012	0.0668662674650699	0.727958167962675	0.727958167962675	false	false	false
19653789-c435-4c5e-a078-9ea204fc9b32	2026-09-28 12:53	2026-09-28 12:53	2026-09-28 12:53	CVX	CVX261120P00210000	put	210.0000	2026-11-20	10.7000	10.5500	10.7000	207.0800	46003.00	46003.00	0.00	43	14	90	1075	0.0837209302325581	0.312051692804453	0.312051692804453	false	false	false
458785d3-1596-4617-a226-512e086ec413	2026-09-28 12:52	2026-09-28 12:52	2026-09-28 12:52	DVN	DVN261120C00045000	call	45.0000	2026-11-20	4.1000	4.1000	4.2000	47.2500	10256.00	0.00	10256.00	25	7	302	1013	0.298124383020731	0.379356861184449	0.382438941808321	false	false	false
42181082-f89d-470c-91e8-015082146b2e	2026-09-28 12:49	2026-09-28 12:49	2026-09-28 12:49	COP	COP261120C00130000	call	130.0000	2026-11-20	5.1500	5.1250	5.3500	127.1043	37595.00	0.00	37595.00	73	26	136	1837	0.0740337506804573	0.315626663338931	0.315626663338931	true	false	false
e987b180-33c6-497c-843b-41b422c776cd	2026-09-28 12:47	2026-09-28 12:46	2026-09-28 12:46	DVN	DVN261120C00045000	call	45.0000	2026-11-20	4.1000	4.1000	4.1500	47.0000	10250.00	0.00	10250.00	25	8	102	1013	0.100691016781836	0.381432193088787	0.381432193088787	false	false	false
b1311a88-e640-4b28-9617-123a08c21709	2026-09-28 12:47	2026-09-28 12:46	2026-09-28 12:46	CLMT	CLMT290119P00050000	put	50.0000	2029-01-19	14.5000	14.0000	15.0000	52.0000	21754.00	7250.00	14504.00	15	6	30	85	0.352941176470588	0.643033478948275	0.64342123534405	false	false	false
aeb21122-5ad2-4e41-9ae7-3c422f7d39b0	2026-09-28 12:41	2026-09-28 12:41	2026-09-28 12:41	XOM	XOM261120P00160000	put	160.0000	2026-11-20	6.4500	6.4000	6.6500	162.0000	48375.00	36765.00	11610.00	75	6	1260	3854	0.326933056564608	0.322652454686157	0.322652454686157	true	false	false
1b2d97eb-dfef-4571-9214-bad3982222e4	2026-09-28 12:39	2026-09-28 12:39	2026-09-28 12:39	LEU	LEU270416P00100000	put	100.0000	2027-04-16	10.0000	9.9000	10.6000	142.3500	246000.00	73000.00	159000.00	246	13	504	22	22.9090909090909	0.770392218069672	0.770392218069672	true	false	false
8de3676a-436e-415e-9be1-39719b233b77	2026-09-28 12:39	2026-09-28 12:39	2026-09-28 12:39	LEU	LEU270416P00100000	put	100.0000	2027-04-16	10.1000	10.0000	10.7000	142.3500	48480.00	19190.00	29290.00	48	7	258	22	11.7272727272727	0.774115893389061	0.774115893389061	true	false	false
134089e0-bd32-41f4-9757-8c91eaa86af9	2026-09-28 12:39	2026-09-28 12:39	2026-09-28 12:39	LEU	LEU270416P00100000	put	100.0000	2027-04-16	10.1100	10.0000	10.8000	142.3500	158722.00	37370.00	121352.00	157	38	210	22	9.54545454545454	0.774115893389061	0.774115893389061	true	false	false
da5672f4-4300-4d85-8d45-b0a12bd08b56	2026-09-28 12:38	2026-09-28 12:38	2026-09-28 12:38	OKE	OKE280121C00110000	call	110.0000	2028-01-21	5.1900	4.6000	5.2000	88.6000	51900.00	46180.00	0.00	100	24	100	293	0.341296928327645	0.252277022672237	0.249616968421947	false	false	false
cf44f85e-180d-4106-ab94-bc6af7e74284	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	CLMT	CLMT261016P00055000	put	55.0000	2026-10-16	4.2400	4.2000	4.7000	52.4350	21222.00	0.00	21222.00	50	5	201	1596	0.12593984962406	0.601257556023637	0.601257556023637	false	false	false
474afe32-59f9-4126-9f07-18255a0063c4	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	CVX	CVX261120P00210000	put	210.0000	2026-11-20	11.2000	10.8500	11.2500	206.1700	36960.00	10080.00	26880.00	33	9	42	1075	0.0390697674418605	0.313193025837833	0.313193025837833	true	false	false
1026cc1a-da65-4299-978b-86066d82ee77	2026-09-28 12:33	2026-09-28 12:32	2026-09-28 12:32	APA	APA261016C00040500	call	40.5000	2026-10-16	3.2000	3.1500	3.2000	42.8000	11520.00	11520.00	0.00	36	12	36	30	1.2	0.477634344708672	0.477634344708672	false	false	false	true
33348561-cf80-455b-9ad6-bbdf63eacfd5	2026-09-28 12:31	2026-09-28 12:31	2026-09-28 12:31	MPC	MPC261016C00400000	call	400.0000	2026-10-16	12.8100	12.4000	13.6000	389.0000	19208.00	0.00	19208.00	15	5	93	446	0.208520179372197	0.496462087066801	0.496462087066801	false	false	false
bf302500-51cf-4ba8-b12e-b24ec8c05ade	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	BP	BP270617P00050000	put	50.0000	2027-06-17	7.9000	7.7500	7.9000	44.5900	22120.00	22120.00	0.00	28	6	28	43	0.651162790697674	0.370117982847001	0.370117982847001	false	false	false
00b111b0-ca96-47eb-a38c-548e4a7bb200	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	CVX	CVX261023P00210000	put	210.0000	2026-10-23	7.7500	7.3000	7.7500	206.0300	26350.00	26350.00	0.00	34	7	45	81	0.555555555555556	0.272141800811221	0.272141800811221	false	false	false
edc31630-55d4-4076-8a8a-77a40a5ded0d	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	COP	COP261023C00130000	call	130.0000	2026-10-23	2.7900	2.7600	2.7900	126.5400	77841.00	77841.00	0.00	279	5	279	16	17.4375	0.310988794377986	0.310988794377986	true	false	false
62834825-2ae1-4a25-867b-f3e724f88ad7	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	OXY	OXY261016C00060000	call	60.0000	2026-10-16	0.5700	0.5600	0.5700	56.5300	24292.00	21660.00	2632.00	427	13	530	7719	0.0686617437491903	0.339087842210321	0.339087842210321	false	false	false
55ea6c66-e587-4ca3-9cb7-e2e9b057c18a	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	COP	COP261023C00129000	call	129.0000	2026-10-23	3.2000	3.0500	3.2000	126.5400	76800.00	76800.00	0.00	240	5	240	13	18.4615384615385	0.312936983761988	0.312936983761988	true	false	false
33668c98-f616-4076-ad67-5cf7159bfe31	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	XOM	XOM261023C00170000	call	170.0000	2026-10-23	2.0900	2.0900	2.1200	161.9200	22363.00	0.00	22363.00	107	20	288	522	0.551724137931034	0.289133346799401	0.289133346799401	false	false	false
689b9278-8691-42d5-8d8a-66d02bd6eb50	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	LNG	LNG261009P00280000	put	280.0000	2026-10-09	11.7000	10.7000	11.7000	272.4200	26910.00	26910.00	0.00	23	8	23	5	4.6	0.399678654381646	0.394159103518323	false	false	false	true
c3e0cd13-1f11-4e72-8926-5e19f5875cb2	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	LNG	LNG261009P00277500	put	277.5000	2026-10-09	10.1000	9.2000	10.1000	272.5750	17169.00	17169.00	0.00	17	8	17	0	0	0.398081852746495	0.398623027102883	false	false	false	true
99732e3a-a9a8-4b36-b6b4-39d963b2cd79	2026-09-28 12:23	2026-09-28 12:23	2026-09-28 12:23	SLB	SLB261120C00052500	call	52.5000	2026-11-20	2.6000	2.6000	2.6700	51.3900	39260.00	0.00	39260.00	151	16	173	1636	0.105745721271394	0.378707627199862	0.378707627199862	false	false	false
89f1e0ad-0000-450c-b950-7f748360b378	2026-09-28 12:17	2026-09-28 12:17	2026-09-28 12:17	XOM	XOM261009P00160000	put	160.0000	2026-10-09	2.4000	2.3200	2.4600	162.0100	25397.00	15353.00	5979.00	106	21	261	603	0.432835820895522	0.304138761495703	0.305067096571137	true	false	false
d7dec3dd-6b3b-433c-a49c-e0035a3e6cfb	2026-09-28 12:17	2026-09-28 12:16	2026-09-28 12:16	STNG	STNG261016C00080000	call	80.0000	2026-10-16	5.6000	5.6000	5.8000	84.1100	43680.00	0.00	43680.00	78	12	80	711	0.112517580872011	0.374503889382484	0.41243034871229	false	false	false
b8f5ec93-f055-4528-bfc2-60a8858161f3	2026-09-28 12:17	2026-09-28 12:16	2026-09-28 12:16	STNG	STNG261016C00082500	call	82.5000	2026-10-16	4.0000	3.8000	4.5000	84.1100	18800.00	0.00	18800.00	47	11	55	2968	0.0185309973045822	0.384639521620419	0.411202483899175	false	false	false
9e5ceaa4-a94e-49a6-9c54-9349d05d23e4	2026-09-28 12:17	2026-09-28 12:16	2026-09-28 12:16	TRMD	TRMD261016P00037500	put	37.5000	2026-10-16	2.6000	2.5500	2.6000	35.6300	13000.00	13000.00	0.00	50	7	50	1528	0.0327225130890052	0.475749507009918	0.475749507009918	false	false	false
68ebc4c1-e937-486d-bc0c-006c8f2db3f5	2026-09-28 12:17	2026-09-28 12:16	2026-09-28 12:16	DHT	DHT261016P00024000	put	24.0000	2026-10-16	2.3500	2.3000	2.4500	22.0850	131350.00	125240.00	6110.00	559	32	561	431	1.30162412993039	0.584599309851105	0.584599309851105	false	false	false
b1c9d99a-6606-4e23-8cdb-b35cc4b3dbd9	2026-09-28 12:17	2026-09-28 12:16	2026-09-28 12:16	APA	APA261002P00043000	put	43.0000	2026-10-02	1.0600	0.9600	1.0600	42.7500	14416.00	14416.00	0.00	136	19	136	202	0.673267326732673	0.52515107285214	0.52515107285214	false	false	false