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

2277c2e5-dd25-4026-a47f-7a7ea025b025	2026-09-23 10:40	2026-09-23 10:40	2026-09-23 10:40	SU	SU261120P00070000	put	70.0000	2026-11-20	4.4000	4.4000	4.6000	68.3250	90640.00	0.00	90640.00	206	26	206	545	0.377981651376147	0.343041763734352	0.343041763734352	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	81135455202.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T14:43:13.868883Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
b6b7db38-f44d-4137-ac43-724f1bb1f211	2026-09-23 10:39	2026-09-23 10:39	2026-09-23 10:39	OXY	OXY261218C00070000	call	70.0000	2026-12-18	0.7100	0.7100	0.7900	57.4400	76325.00	0.00	76325.00	1075	23	1096	6040	0.181456953642384	0.347756184797506	0.347756184797506	false	false	false	true
5b5b1239-cf30-4857-957d-97c3afd50cf3	2026-09-23 10:38	2026-09-23 10:37	2026-09-23 10:37	LNG	LNG280121P00290000	put	290.0000	2028-01-21	41.8000	41.8000	44.0000	279.7450	29260.00	0.00	29260.00	7	5	7	19	0.368421052631579	0.359984716874862	0.359984716874862	false	false	false	true
6b3bcd2b-fa0b-46f0-b9a0-63e2c248aefd	2026-09-23 10:37	2026-09-23 10:37	2026-09-23 10:37	SLB	SLB261016P00051000	put	51.0000	2026-10-16	1.3600	1.2900	1.3600	52.0150	24208.00	24208.00	0.00	178	19	178	16	11.125	0.36430935104639	0.36430935104639	false	false	false	true
3b6d2067-570e-4171-97e6-c24849d53814	2026-09-23 10:35	2026-09-23 10:35	2026-09-23 10:35	SHEL	SHEL270115C00100000	call	100.0000	2027-01-15	3.2000	3.2000	3.3000	95.0500	16000.00	0.00	16000.00	50	11	70	3012	0.0232403718459495	0.222309856400635	0.222309856400635	false	false	false	true
0b98833a-3ddf-4b8d-a944-ad87615221e0	2026-09-23 10:34	2026-09-23 10:34	2026-09-23 10:34	COP	COP270115P00120000	put	120.0000	2027-01-15	5.0500	4.9500	5.1000	128.3500	15150.00	3535.00	11615.00	30	5	98	2069	0.0473658772353794	0.334191206371341	0.334191206371341	false	false	false	true
f2e9a8d5-408e-49ff-a750-d5a063c576b2	2026-09-23 10:31	2026-09-23 10:31	2026-09-23 10:31	CCJ	CCJ261009C00094000	call	94.0000	2026-10-09	2.7800	2.7800	2.9600	92.2350	16125.00	279.00	15846.00	58	19	58	74	0.783783783783784	0.45353700645146	0.454846639711527	true	false	false	true
ca963789-b7f6-413e-913a-2c6b77791f60	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	XOM	XOM280121C00165000	call	165.0000	2028-01-21	21.5500	21.1500	21.6500	161.0000	10775.00	10775.00	0.00	5	5	134	856	0.156542056074766	0.249354474651657	0.249354474651657	false	false	false	true
afbe4953-f72b-4ebc-af73-52bfa4fcdc5a	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	WFRD	WFRD270416P00065000	put	65.0000	2027-04-16	2.9000	2.9000	3.5000	84.0000	13052.00	0.00	13052.00	45	13	45	6	7.5	0.462274574433317	0.462274574433317	false	false	false	true
478d3717-bdc8-4f5c-8aad-09b29f472b8b	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	TRMD	TRMD261120P00032500	put	32.5000	2026-11-20	1.8800	0.0000	3.6000	34.0000	10340.00	10340.00	0.00	55	2	56	33	1.6969696969697	0.551718707499727	0.551718707499727	false	true	false	true
3cba5759-e2b8-4f31-83e3-fc2348f0a501	2026-09-23 10:20	2026-09-23 10:20	2026-09-23 10:20	TPL	TPL270115C00440000	call	440.0000	2027-01-15	11.5000	11.3000	13.1000	355.6400	23000.00	0.00	23000.00	20	9	21	24	0.875	0.442701188714371	0.442701188714371	false	false	false	true
22aaddbe-ed1f-4a02-b7e5-93781e0f7624	2026-09-23 10:20	2026-09-23 10:20	2026-09-23 10:20	EQT	EQT261120C00052500	call	52.5000	2026-11-20	2.2000	2.0000	2.3000	51.1800	38280.00	220.00	38060.00	174	23	232	731	0.317373461012312	0.324109253728257	0.324109253728257	false	false	false	true
7c9b1408-e3ed-4ea0-9d3b-e8c817ce20cc	2026-09-23 10:17	2026-09-23 10:17	2026-09-23 10:17	DVN	DVN261016C00047500	call	47.5000	2026-10-16	2.3500	2.2700	2.4100	48.4600	93060.00	93060.00	0.00	396	5	491	11936	0.0411360589812332	0.366525587248723	0.366525587248723	false	false	false	true
2529540e-3ffc-47ff-9040-4eff7b2078cf	2026-09-23 10:15	2026-09-23 10:15	2026-09-23 10:15	OXY	OXY261016C00060000	call	60.0000	2026-10-16	1.0700	1.0700	1.0800	57.6999	22898.00	0.00	11449.00	214	5	319	6623	0.0481654839196739	0.333188498681042	0.333188498681042	false	false	false	true
e6606ffd-992e-4d65-8323-77d71202206c	2026-09-23 10:15	2026-09-23 10:15	2026-09-23 10:15	COP	COP261120P00120000	put	120.0000	2026-11-20	3.1600	3.0500	3.3000	128.1400	59420.00	0.00	59420.00	188	5	217	617	0.351701782820097	0.34021394104633	0.342561258017889	false	false	false	true
3d8ad9ed-cd92-405a-95fe-e6ddf77c33a8	2026-09-23 10:13	2026-09-23 10:12	2026-09-23 10:12	OXY	OXY290119C00070000	call	70.0000	2029-01-19	8.8500	8.0500	9.0500	57.5700	10620.00	7080.00	3540.00	12	8	12	96	0.125	0.310298290251434	0.310298290251434	false	false	false	true
ddb1466f-93ed-4f18-b5b6-0338fc8f4632	2026-09-23 10:11	2026-09-23 10:11	2026-09-23 10:11	WMB	WMB261016P00070000	put	70.0000	2026-10-16	1.1500	1.1000	1.2500	71.0000	58190.00	33005.00	10120.00	506	34	756	4272	0.176966292134831	0.279191843079438	0.279700201527426	false	false	false	true
6637214a-21b3-4f89-b59f-7f295208c87b	2026-09-23 10:10	2026-09-23 10:10	2026-09-23 10:10	XOM	XOM261016C00160000	call	160.0000	2026-10-16	5.5500	5.3000	5.6500	161.2191	28860.00	4440.00	24420.00	52	8	123	5500	0.0223636363636364	0.292410179385592	0.292410179385592	false	false	false	true
7376a0f6-1aaf-44fc-8c46-682220ae2e4d	2026-09-23 10:09	2026-09-23 10:08	2026-09-23 10:08	XOM	XOM260925C00165000	call	165.0000	2026-09-25	0.4300	0.4300	0.5000	160.9600	15910.00	0.00	15910.00	370	41	973	3002	0.324117255163225	0.363573363357255	0.363573363357255	false	false	false	true
c5f50ae7-fe12-4b48-a6fd-bc942af6fb0f	2026-09-23 10:07	2026-09-23 10:07	2026-09-23 10:07	CLMT	CLMT270115C00070000	call	70.0000	2027-01-15	4.0000	4.0000	4.1000	55.0000	20400.00	0.00	20400.00	51	10	71	1161	0.0611541774332472	0.670192503509424	0.670192503509424	false	false	false	true
d7a5e58c-f402-4ea1-a4e9-ff0d0d8bfeab	2026-09-23 10:05	2026-09-23 10:05	2026-09-23 10:05	XOM	XOM261016P00150000	put	150.0000	2026-10-16	1.0000	0.9900	1.0500	161.0000	28700.00	9300.00	19400.00	287	59	435	8970	0.048494983277592	0.300576616207422	0.300576616207422	false	false	false	true
1a88712f-ba1a-45c5-aca5-d9f17c5a5695	2026-09-23 10:03	2026-09-23 10:03	2026-09-23 10:03	DVN	DVN261120C00052500	call	52.5000	2026-11-20	1.3700	1.3700	1.5400	48.3100	49183.00	0.00	49183.00	359	24	369	1583	0.233101705622236	0.363138059361389	0.363138059361389	false	false	false	true
f8a43c23-0bcc-480a-b0a9-79fb2a48f0cf	2026-09-23 10:01	2026-09-23 10:01	2026-09-23 10:01	NUAI	NUAI260925P00006500	put	6.5000	2026-09-25	0.1000	0.0500	0.1000	6.0000	10000.00	10000.00	0.00	1000	10	1008	2173	0.46387482742752	1.24825503391667	1.24825503391667	false	false	false	true
6604513b-fc65-448a-8ce4-6b0832d8c6bb	2026-09-23 10:00	2026-09-23 10:00	2026-09-23 10:00	PBR	PBR280218C00025000	call	25.0000	2028-02-18	2.1500	1.9900	2.1500	21.0000	10965.00	10965.00	0.00	51	51	51	2276	0.0224077328646749	0.289539386906536	0.289539386906536	false	false	false	true
02ad68f5-480c-46a8-b4cc-a126c0993bf7	2026-09-23 09:58	2026-09-23 09:58	2026-09-23 09:58	CVX	CVX261120C00230000	call	230.0000	2026-11-20	1.9600	1.8900	2.0000	205.9200	30186.00	3334.00	26068.00	154	11	162	12361	0.0131057357818947	0.264945392497937	0.264945392497937	true	false	false	true
76955f9b-e4e9-4e94-befb-994de1a1af3e	2026-09-23 09:57	2026-09-23 09:57	2026-09-23 09:57	WES	WES290119C00050000	call	50.0000	2029-01-19	3.4000	1.5000	4.5000	46.3750	34000.00	20400.00	13600.00	100	6	200	0	0	0.0917240109083305	0.0917240109083305	false	false	false	true
3437aa4d-dadb-4b61-bc2c-c90e8438277a	2026-09-23 09:57	2026-09-23 09:56	2026-09-23 09:56	SLB	SLB270219C00050000	call	50.0000	2027-02-19	6.6500	6.5000	6.7000	52.7150	37240.00	18620.00	18620.00	56	5	57	121	0.471074380165289	0.358687713340606	0.358687713340606	false	false	false	true
2012a3a1-8328-4b0a-a0ba-c0d756e1fd33	2026-09-23 09:56	2026-09-23 09:56	2026-09-23 09:56	FRO	FRO261120C00059200	call	59.2000	2026-11-20	0.7000	0.7000	0.9500	47.0100	67910.00	0.00	67910.00	970	38	1073	9340	0.114882226980728	0.503774486481661	0.503774486481661	false	false	false	true
a330e47e-d987-4027-8f02-be7ee3e4173d	2026-09-23 09:56	2026-09-23 09:56	2026-09-23 09:56	PBR	PBR261120C00026000	call	26.0000	2026-11-20	0.5000	0.5000	0.5300	21.3300	10000.00	0.00	10000.00	200	59	200	659	0.303490136570561	0.533797370945592	0.533797370945592	true	false	false	true
f5a60e25-5de4-408f-bf68-a0ede10f112b	2026-09-23 09:54	2026-09-23 09:54	2026-09-23 09:54	CVX	CVX261218C00210000	call	210.0000	2026-12-18	9.0000	9.0000	9.3000	205.8050	107100.00	0.00	107100.00	119	20	128	3816	0.0335429769392034	0.250692212700262	0.250692212700262	true	false	false	true
f52c003a-70cf-4b01-afc8-c8f24b91a6be	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3800	1.3800	1.4500	33.0300	10764.00	0.00	10764.00	78	16	4631	605	7.65454545454545	0.39735782840825	0.39735782840825	false	false	false	true
6d343706-fc3b-49dd-ac36-3c3908b02baf	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	DVN	DVN261016C00048500	call	48.5000	2026-10-16	1.8000	1.8000	1.8700	48.3550	71640.00	0.00	71640.00	398	11	500	13	38.4615384615385	0.374209349815807	0.374209349815807	true	false	false	true
e119a52a-4548-447f-bfa8-89b4c55137e5	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	DVN	DVN261016C00048500	call	48.5000	2026-10-16	1.7500	1.7500	1.8700	48.3160	17850.00	0.00	17850.00	102	7	102	13	7.84615384615385	0.368022895047238	0.368022895047238	true	false	false	true
7696f339-b92a-4cbd-83b9-e6469320ab4c	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3800	1.3800	1.4000	33.0250	255319.00	2641.00	252678.00	1850	38	4263	605	7.04628099173554	0.39735782840825	0.397753157393514	true	false	false	true
67e8e415-aebd-4765-a0a1-7a976b18bee6	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	MPC	MPC261016P00340000	put	340.0000	2026-10-16	2.8500	2.8500	2.9000	396.0200	22515.00	0.00	22515.00	79	13	98	3023	0.0324181276877274	0.525546287927828	0.525546287927828	false	false	false	true
ef6edc63-b6b9-418c-a493-c40e057f2098	2026-09-23 09:52	2026-09-23 09:52	2026-09-23 09:52	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3500	1.3500	1.4500	33.0400	10260.00	0.00	10260.00	76	16	1113	605	1.8396694214876	0.390679853705984	0.390679853705984	false	false	false	true
685e7466-1b28-49a9-b31b-f32b876476df	2026-09-23 09:52	2026-09-23 09:52	2026-09-23 09:52	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3500	1.3500	1.3800	33.0300	14040.00	0.00	14040.00	104	24	1011	605	1.67107438016529	0.391467389947004	0.391467389947004	true	false	false	true
395afb45-affe-45fa-bc25-fa34d6d051a3	2026-09-23 09:51	2026-09-23 09:51	2026-09-23 09:51	HAL	HAL261120C00035000	call	35.0000	2026-11-20	1.3500	1.3500	1.4400	33.0300	73170.00	0.00	5400.00	542	119	544	605	0.899173553719008	0.394220709769058	0.391467389947004	true	false	false	true
27056b2b-d013-4089-b60d-05ad63176624	2026-09-23 09:51	2026-09-23 09:51	2026-09-23 09:51	XOM	XOM270319C00180000	call	180.0000	2027-03-19	6.8500	6.3000	6.8500	161.5700	36300.00	36300.00	0.00	53	5	53	2981	0.0177792687017779	0.275578656097816	0.275578656097816	false	false	false	true
528f5a2b-f0ec-43e7-8d0d-195e6983dbbe	2026-09-23 09:50	2026-09-23 09:50	2026-09-23 09:50	HAL	HAL261218C00037000	call	37.0000	2026-12-18	1.0500	0.9700	1.0700	33.0100	130935.00	130935.00	0.00	1247	6	1247	1407	0.886282871357498	0.363891342798842	0.363891342798842	false	false	false	true
fa0f9c00-6ee5-4e4b-85f5-5b2e52af8f9f	2026-09-23 09:50	2026-09-23 09:50	2026-09-23 09:50	CVX	CVX270617C00250000	call	250.0000	2027-06-17	6.2100	5.3500	6.3500	205.7700	13664.00	12434.00	1230.00	22	7	22	1086	0.0202578268876611	0.251381785302293	0.249269234533618	false	false	false	true
1a1ff582-faad-4a56-ab11-7693f0d4a9d6	2026-09-23 09:50	2026-09-23 09:50	2026-09-23 09:50	SHEL	SHEL270319C00085000	call	85.0000	2027-03-19	12.9000	12.5000	12.9000	94.9800	14190.00	14190.00	0.00	11	5	28	271	0.103321033210332	0.202531236308074	0.202531236308074	false	false	false	true
c5a57c2f-f249-4c9c-b622-6bcaef1037ad	2026-09-23 09:48	2026-09-23 09:48	2026-09-23 09:48	COP	COP261002P00130000	put	130.0000	2026-10-02	4.1000	4.0000	4.6000	127.0000	14350.00	0.00	14350.00	35	9	35	66	0.53030303030303	0.317223122737397	0.317223122737397	false	false	false	true
36019b9b-e4b9-47b7-9d6c-a019d25fe971	2026-09-23 09:46	2026-09-23 09:46	2026-09-23 09:46	SHEL	SHEL270319C00085000	call	85.0000	2027-03-19	12.8000	12.4000	12.8000	94.0000	20480.00	20480.00	0.00	16	5	16	271	0.0590405904059041	0.204667035425454	0.204667035425454	false	false	false	true
965289bc-57a1-4a9a-8870-0524377fc6e9	2026-09-23 09:43	2026-09-23 09:43	2026-09-23 09:43	OXY	OXY260925P00056000	put	56.0000	2026-09-25	0.3400	0.3400	0.4100	56.0000	13465.00	35.00	13430.00	396	49	400	1094	0.36563071297989	0.41629778380927	0.423109801824	false	false	false	true
516c18a7-e4dd-45b2-a8be-8022fd73249c	2026-09-23 09:43	2026-09-23 09:43	2026-09-23 09:43	OXY	OXY260925P00057000	put	57.0000	2026-09-25	0.7500	0.7500	0.9200	56.0000	12750.00	0.00	12750.00	170	17	174	1259	0.138204924543288	0.410209548097516	0.410209548097516	false	false	false	true
3ca0c983-be27-4828-b4f5-2a65839e37cb	2026-09-23 09:43	2026-09-23 09:43	2026-09-23 09:43	ET	ET261016C00021000	call	21.0000	2026-10-16	0.2000	0.1700	0.2100	20.4800	15940.00	15940.00	0.00	797	6	2292	39970	0.0573430072554416	0.188031683854842	0.188031683854842	true	false	false	true
cf5540ba-67f2-4822-a91e-8f50dead5a47	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	LNG	LNG261002C00282500	call	282.5000	2026-10-02	4.2000	3.6000	4.3000	273.0000	33180.00	10920.00	12600.00	79	10	242	0	0	0.420433922677172	0.420639840493268	true	false	false	true
92654d23-daf3-4961-a0aa-ea8bc6a882ef	2026-09-22 15:59	2026-09-22 15:59	2026-09-22 15:59	LNG	LNG261002C00282500	call	282.5000	2026-10-02	4.1000	3.6000	4.4000	273.0000	44280.00	43050.00	820.00	108	14	158	0	0	0.415855368837396	0.415855368837396	true	false	false	true
9616d7a3-d744-4388-82a1-d386faac3f93	2026-09-22 15:57	2026-09-22 15:56	2026-09-22 15:56	VLO	VLO261016P00380000	put	380.0000	2026-10-16	22.0000	20.7000	22.0000	376.8000	13200.00	13200.00	0.00	6	6	865	796	1.08668341708543	0.540419858525296	0.540419858525296	false	false	false	true