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.

708,051 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts708,051 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

91e8cd5a-21f2-4dca-8ad8-70270619e9c0	2026-09-30 11:20	2026-09-30 11:20	2026-09-30 11:20	SHEL	SHEL280121C00082500	call	82.5000	2028-01-21	18.7000	18.3000	18.9000	95.2500	37400.00	31790.00	5610.00	20	7	20	423	0.0472813238770686	0.151315138374039	0.151315138374039	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Energy	270668146742.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T15:21:43.469361Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
1bf1b0d9-a683-4b9d-8a22-3df35974f4db	2026-09-30 11:20	2026-09-30 11:20	2026-09-30 11:20	CVX	CVX261218P00190000	put	190.0000	2026-12-18	4.5000	4.3500	4.5000	205.4500	10800.00	10800.00	0.00	24	7	37	3034	0.0121951219512195	0.302304382152122	0.302304382152122	false	false	false
764c245d-1a2f-42c2-bb47-806ae22a8c68	2026-09-30 11:20	2026-09-30 11:20	2026-09-30 11:20	SLB	SLB270319C00070000	call	70.0000	2027-03-19	0.6300	0.6200	0.6900	49.2250	31500.00	315.00	28476.00	500	35	5743	7776	0.738554526748971	0.367741316435375	0.367741316435375	true	false	false
4be71234-201b-4945-89bc-bdd85ec73939	2026-09-30 11:20	2026-09-30 11:20	2026-09-30 11:20	SLB	SLB270319C00070000	call	70.0000	2027-03-19	0.6300	0.6200	0.6900	49.2300	24444.00	1260.00	22995.00	388	53	5197	7776	0.668338477366255	0.36738798789159	0.36765297453178	true	false	false
5882b846-a264-4d28-977b-5be6600dc1eb	2026-09-30 11:16	2026-09-30 11:16	2026-09-30 11:16	SLB	SLB270319C00070000	call	70.0000	2027-03-19	0.6400	0.6400	0.6900	49.3150	19456.00	0.00	19456.00	304	21	4038	7776	0.51929012345679	0.367668645856614	0.367668645856614	true	false	false
db14e228-07b1-4e1f-9ace-eb2d541e0b4a	2026-09-30 11:13	2026-09-30 11:13	2026-09-30 11:13	SLB	SLB270319C00070000	call	70.0000	2027-03-19	0.6400	0.6300	0.7000	49.3300	17920.00	0.00	16512.00	280	17	3532	7776	0.454218106995885	0.367403217323513	0.367403217323513	true	false	false
a69cc422-6fc3-445e-a465-7d7d9c28c894	2026-09-30 11:12	2026-09-30 11:12	2026-09-30 11:12	LEU	LEU261016P00155000	put	155.0000	2026-10-16	16.3400	15.7000	16.4000	142.1600	199380.00	85280.00	114100.00	122	18	122	574	0.212543554006969	0.703829658400086	0.703829658400086	false	false	false
a7d0cd8d-90fc-41bb-8f81-888370e1572c	2026-09-30 11:11	2026-09-30 11:11	2026-09-30 11:11	SLB	SLB270319C00070000	call	70.0000	2027-03-19	0.6400	0.6400	0.7000	49.3650	54848.00	0.00	54848.00	857	30	3088	7776	0.397119341563786	0.366784110692211	0.366784110692211	true	false	false
196c54b0-dd4b-45b3-8c77-06ece876af0d	2026-09-30 11:11	2026-09-30 11:10	2026-09-30 11:10	MTDR	MTDR261120C00057500	call	57.5000	2026-11-20	1.2000	1.2000	1.2500	51.5700	33720.00	0.00	33720.00	281	20	1131	102	11.0882352941176	0.403129147686824	0.403129147686824	false	false	false
0a79f3fc-d7ad-4bae-a307-24ed8dd02ca4	2026-09-30 11:10	2026-09-30 11:10	2026-09-30 11:10	XOM	XOM261120C00165000	call	165.0000	2026-11-20	6.3000	6.3000	6.7000	163.0710	18911.00	1270.00	17641.00	30	5	36	3728	0.00965665236051502	0.278234089676575	0.279878988229875	false	false	false
c7366b1d-0288-4d25-ad46-14fc4fc9c822	2026-09-30 11:10	2026-09-30 11:09	2026-09-30 11:09	MTDR	MTDR261120C00057500	call	57.5000	2026-11-20	1.2500	1.1500	1.7000	51.5300	50750.00	4750.00	9125.00	406	15	796	102	7.80392156862745	0.412631574487743	0.412631574487743	false	false	false
6a9b1d0a-ba7f-41bf-8293-b9e6552d5642	2026-09-30 11:08	2026-09-30 11:07	2026-09-30 11:07	PSX	PSX261009C00267500	call	267.5000	2026-10-09	3.3000	3.3000	3.9000	258.5350	43891.00	0.00	43891.00	133	39	134	10	13.4	0.411816576157543	0.411816576157543	false	false	false
97056298-fb35-4bca-9d74-245d61c77fb6	2026-09-30 11:05	2026-09-30 11:05	2026-09-30 11:05	CMBT	CMBT261016P00020000	put	20.0000	2026-10-16	1.6200	1.6000	1.9500	19.0300	16247.00	0.00	16247.00	100	5	801	900	0.89	0.669686370060302	0.689239492840071	true	false	false
7aaa5cdb-95d7-493a-8f5b-095d0ce65696	2026-09-30 11:03	2026-09-30 11:03	2026-09-30 11:03	UUUU	UUUU261120C00011000	call	11.0000	2026-11-20	1.2100	1.2100	1.3100	11.1650	12121.00	0.00	9559.00	100	9	938	784	1.19642857142857	0.664175629281577	0.664175629281577	false	false	false
5297ca3c-2941-49ff-86d9-c6fd310c4e09	2026-09-30 11:01	2026-09-30 11:01	2026-09-30 11:01	UUUU	UUUU270115C00015000	call	15.0000	2027-01-15	0.7000	0.6800	0.7000	11.1750	14350.00	14350.00	0.00	205	22	233	14726	0.0158223550183349	0.728581840457491	0.728581840457491	false	false	false
ba5a00eb-af2c-4bc2-9491-a8d1193d4ce7	2026-09-30 11:00	2026-09-30 11:00	2026-09-30 11:00	SEI	SEI261016C00075000	call	75.0000	2026-10-16	1.8500	1.6500	1.8500	68.2400	44030.00	44030.00	0.00	238	38	332	1130	0.293805309734513	0.735925033100353	0.735925033100353	true	false	false
d6b10778-f715-4f3b-b9b3-c07f437a2446	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	SEI	SEI261016C00075000	call	75.0000	2026-10-16	1.8500	1.6000	1.8500	68.0000	16650.00	1295.00	0.00	90	12	94	1130	0.0831858407079646	0.729278604739336	0.729278604739336	false	false	false
41c25940-ed79-4204-8573-ce6454678430	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	MPC	MPC261016C00400000	call	400.0000	2026-10-16	14.9800	14.5000	15.9000	398.0000	14975.00	4485.00	10490.00	10	5	43	451	0.0953436807095344	0.455434761755593	0.45693661461952	false	false	false
45ba5260-6781-4c38-88e9-601d6b40985c	2026-09-30 10:56	2026-09-30 10:56	2026-09-30 10:56	SHEL	SHEL261016C00095000	call	95.0000	2026-10-16	2.1000	2.1000	2.2500	95.0000	74345.00	0.00	74345.00	354	39	364	7820	0.0465473145780051	0.243318882400017	0.243454653020337	false	false	false
5add0f53-e7e9-4a8a-87aa-bd0bb6a59024	2026-09-30 10:55	2026-09-30 10:55	2026-09-30 10:55	TRMD	TRMD261016C00040000	call	40.0000	2026-10-16	0.7000	0.4000	0.7500	37.0000	27300.00	27300.00	0.00	390	19	1332	3158	0.421785940468651	0.462233561317108	0.462233561317108	true	false	false
a1cd7657-a5fc-44fc-895e-5bd9d8abda49	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	TRMD	TRMD261016C00040000	call	40.0000	2026-10-16	0.7500	0.7000	0.7500	37.0000	26925.00	26925.00	0.00	359	27	910	3158	0.288157061431286	0.477697988122668	0.477697988122668	false	false	false
1a44d49b-1d23-4b8d-84e8-9c27e2b36334	2026-09-30 10:54	2026-09-30 10:54	2026-09-30 10:54	TRMD	TRMD261016C00037500	call	37.5000	2026-10-16	1.6500	1.6500	1.8000	38.0000	14191.00	0.00	14191.00	86	21	143	1880	0.076063829787234	0.428018601396442	0.428018601396442	false	false	false
2d4f2205-34c8-402b-a09b-f4e1ecc1f3c0	2026-09-30 10:51	2026-09-30 10:51	2026-09-30 10:51	EXE	EXE261120P00080000	put	80.0000	2026-11-20	2.3100	2.3000	2.5500	83.0000	13611.00	0.00	13611.00	59	12	763	19899	0.0383436353585607	0.332353181714891	0.33145830494938	false	false	false
355ca63c-2a12-4eeb-a694-0a9fb6382428	2026-09-30 10:51	2026-09-30 10:51	2026-09-30 10:51	DVN	DVN261218P00045000	put	45.0000	2026-12-18	2.3300	2.3300	2.3900	46.0000	11420.00	236.00	11184.00	49	19	62	1133	0.0547219770520741	0.379035985413858	0.375373604596814	false	false	false
5f21dcf1-ecf2-47ce-8835-a0116b956049	2026-09-30 10:50	2026-09-30 10:49	2026-09-30 10:49	COP	COP261120P00120000	put	120.0000	2026-11-20	3.6000	3.5500	3.7500	125.5100	34200.00	1440.00	32760.00	95	20	96	648	0.148148148148148	0.340916769000938	0.340916769000938	true	false	false
04cc26cc-e579-4138-b1e0-e4f48c5d1793	2026-09-30 10:49	2026-09-30 10:49	2026-09-30 10:49	MTDR	MTDR261120C00057500	call	57.5000	2026-11-20	1.2500	1.1000	1.5000	51.4800	44125.00	6375.00	34500.00	353	14	378	102	3.70588235294118	0.414773086099444	0.414773086099444	false	false	false
f373f563-8fd0-4eb4-a60b-138cb20bcc0a	2026-09-30 10:48	2026-09-30 10:48	2026-09-30 10:48	VLO	VLO261016P00350000	put	350.0000	2026-10-16	2.7500	2.5000	3.0000	392.9050	12100.00	0.00	9350.00	44	6	336	2089	0.160842508377214	0.51208380428975	0.51208380428975	false	false	false
d48e4265-4860-42cf-bc0c-f34a3f26d9e8	2026-09-30 10:47	2026-09-30 10:46	2026-09-30 10:46	PAA	PAA261120P00024000	put	24.0000	2026-11-20	1.0500	1.0500	1.1000	23.7000	68145.00	0.00	68145.00	649	9	750	1038	0.722543352601156	0.273023699004572	0.273023699004572	false	false	false
26f95ccf-a1a3-4bde-8449-b0e1fc1f630d	2026-09-30 10:46	2026-09-30 10:45	2026-09-30 10:45	EQT	EQT261009C00050000	call	50.0000	2026-10-09	0.4500	0.4100	0.5000	48.6400	13636.00	46.00	13590.00	303	48	303	47	6.4468085106383	0.313256943791783	0.316999257538986	false	false	false
083c1826-0645-4c5d-ab59-76d93cfa94d0	2026-09-30 10:45	2026-09-30 10:45	2026-09-30 10:45	VLO	VLO261016P00370000	put	370.0000	2026-10-16	6.7000	6.7000	7.3000	392.4800	88440.00	0.00	88440.00	132	37	211	1035	0.203864734299517	0.491210019988924	0.491210019988924	false	false	false
a7ceb492-314a-4eba-b727-8397f4eecd5b	2026-09-30 10:41	2026-09-30 10:41	2026-09-30 10:41	COP	COP261009C00129000	call	129.0000	2026-10-09	1.2200	1.2000	1.4100	125.4950	43556.00	122.00	43188.00	357	33	362	346	1.04624277456647	0.321627655306884	0.323068465265531	false	false	false
bedd3203-178d-4b41-888b-23b06f7f0c58	2026-09-30 10:33	2026-09-30 10:33	2026-09-30 10:33	SLB	SLB270319C00070000	call	70.0000	2027-03-19	0.6700	0.6700	0.7300	49.3900	34505.00	0.00	34505.00	515	22	2196	7776	0.282407407407407	0.370817419782835	0.370817419782835	true	false	false
6eadace9-72ff-4db3-a5ec-b72006a60bfc	2026-09-30 10:33	2026-09-30 10:32	2026-09-30 10:32	UEC	UEC261002C00010000	call	10.0000	2026-10-02	0.1100	0.1000	0.1100	9.6584	13178.00	13178.00	0.00	1198	18	1558	2086	0.746883988494727	0.837149499140928	0.837149499140928	false	false	false
96e30813-05f9-4015-aed1-ce16c8a8beac	2026-09-30 10:32	2026-09-30 10:32	2026-09-30 10:32	SLB	SLB270319C00070000	call	70.0000	2027-03-19	0.6700	0.6500	0.6800	49.4200	37587.00	402.00	37185.00	561	63	1637	7776	0.210519547325103	0.369570001661122	0.370282656561188	true	false	false
20390c93-26df-4e05-90be-8ed28364988f	2026-09-30 10:31	2026-09-30 10:31	2026-09-30 10:31	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	2.6900	2.6100	2.6900	88.4850	15064.00	15064.00	0.00	56	9	165	5208	0.0316820276497696	0.486892664777081	0.486892664777081	false	false	false
830de74d-4094-4fee-9dfc-2667d185137d	2026-09-30 10:27	2026-09-30 10:27	2026-09-30 10:27	PBR	PBR261016C00022000	call	22.0000	2026-10-16	0.5800	0.5800	0.6000	21.0850	27724.00	0.00	27724.00	478	26	574	35055	0.016374269005848	0.531442882182982	0.531442882182982	false	false	false
24add7ad-189a-4474-8afd-424d0f657b78	2026-09-30 10:27	2026-09-30 10:27	2026-09-30 10:27	PBR	PBR261016C00022500	call	22.5000	2026-10-16	0.4300	0.4300	0.4600	21.0850	14147.00	0.00	14147.00	329	18	340	1400	0.242857142857143	0.531543120837155	0.531543120837155	false	false	false
d6a3b842-0a77-4edb-8909-07c5637d9331	2026-09-30 10:24	2026-09-30 10:24	2026-09-30 10:24	EQT	EQT261218C00047500	call	47.5000	2026-12-18	3.7000	3.6000	3.7000	48.7750	12210.00	12210.00	0.00	33	13	33	138	0.239130434782609	0.310761282904254	0.310761282904254	true	false	false
5b39c760-d3c8-4905-8477-1b20d3826a72	2026-09-30 10:24	2026-09-30 10:24	2026-09-30 10:24	MPC	MPC261016C00420000	call	420.0000	2026-10-16	7.0000	6.9000	7.5000	396.0300	25910.00	710.00	25200.00	37	22	71	757	0.0937912813738441	0.470325509377459	0.473799359587404	false	false	false
48cc0ae9-4e7c-4db9-8693-45700cd84461	2026-09-30 10:21	2026-09-30 10:21	2026-09-30 10:21	CCJ	CCJ270115C00095000	call	95.0000	2027-01-15	6.9500	6.6000	6.9500	89.2400	773441.00	772751.00	690.00	1113	55	1118	1478	0.756427604871448	0.459152989124297	0.456551274015311	false	false	false
d80058c0-595e-4325-99bb-6d3588b363e2	2026-09-30 10:21	2026-09-30 10:21	2026-09-30 10:21	EXE	EXE261120C00085000	call	85.0000	2026-11-20	3.4000	3.4000	3.7000	83.5900	26520.00	0.00	26520.00	78	15	179	995	0.179899497487437	0.3065618421074	0.3065618421074	true	false	false
f3fcdcc0-cf33-455f-a0e8-56cd6506a8e8	2026-09-30 10:15	2026-09-30 10:15	2026-09-30 10:15	OXY	OXY261120P00055000	put	55.0000	2026-11-20	2.6600	2.6600	2.9100	54.9400	29260.00	0.00	29260.00	110	23	116	3638	0.0318856514568444	0.341361097218786	0.341361097218786	false	false	false
d47ffa20-18bb-468e-b8d9-ef1659545323	2026-09-30 10:15	2026-09-30 10:15	2026-09-30 10:15	UUUU	UUUU270115P00011000	put	11.0000	2027-01-15	1.4500	1.4200	1.4600	11.4250	83955.00	83085.00	0.00	579	40	599	1415	0.423321554770318	0.717861833774677	0.717861833774677	false	false	false
52ce37d6-241a-42fa-a95c-8018eb049eb3	2026-09-30 10:14	2026-09-30 10:14	2026-09-30 10:14	EXE	EXE261023P00082000	put	82.0000	2026-10-23	1.4000	1.1000	2.0000	83.7000	33616.00	0.00	33616.00	240	11	240	90	2.66666666666667	0.228062174815522	0.278820803016119	false	false	false
5faa45b1-6976-4bc6-a78f-28a2f31daa8f	2026-09-30 10:14	2026-09-30 10:14	2026-09-30 10:14	CLMT	CLMT261120C00060000	call	60.0000	2026-11-20	2.9900	2.7500	3.4000	53.0000	11970.00	0.00	11970.00	40	7	151	1765	0.0855524079320113	0.666456797449764	0.666456797449764	false	false	false
43c681a0-bdf7-4cc7-b8f8-2b1724e88a6d	2026-09-30 10:13	2026-09-30 10:12	2026-09-30 10:12	WMB	WMB261016C00070000	call	70.0000	2026-10-16	0.9000	0.8000	0.9500	68.0000	60660.00	90.00	60570.00	674	25	674	1273	0.529457973291438	0.271616573086768	0.274273373422308	false	false	false
8a12fde9-d4df-49cb-a24a-d6992964de17	2026-09-30 10:12	2026-09-30 10:12	2026-09-30 10:12	DVN	DVN261009C00049000	call	49.0000	2026-10-09	0.3000	0.2700	0.3600	46.0000	22501.00	31.00	22470.00	750	38	758	247	3.06882591093117	0.389831042609493	0.394773454528108	false	false	false
cdaf20b9-9035-4ee1-a311-9120388a938d	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	EXE	EXE261120P00090000	put	90.0000	2026-11-20	8.0000	8.0000	8.6000	83.6900	20000.00	0.00	20000.00	25	5	50	116	0.431034482758621	0.35135180313797	0.35135180313797	false	false	false
775f698e-b337-4f44-bd1c-b5bf72d180b7	2026-09-30 10:11	2026-09-30 10:11	2026-09-30 10:11	EXE	EXE261120P00090000	put	90.0000	2026-11-20	8.0000	8.0000	8.6000	83.6900	20000.00	0.00	17600.00	25	7	25	116	0.21551724137931	0.35135180313797	0.35135180313797	false	false	false
11de3118-84cd-426f-9a5e-49f51dda4137	2026-09-30 10:06	2026-09-30 10:06	2026-09-30 10:06	CCJ	CCJ261002P00090000	put	90.0000	2026-10-02	1.8000	1.8000	2.3700	89.4450	12061.00	0.00	12061.00	67	5	68	1086	0.0626151012891344	0.572825605761327	0.572825605761327	true	false	false