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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×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

17abb6ef-753e-4e08-ad02-083b3850afae	2026-08-18 13:35	2026-08-18 13:35	2026-08-18 13:35	PBF	PBF260821P00070000	put	70.0000	2026-08-21	0.6500	0.4000	0.8500	74.5050	14728.00	6673.00	8055.00	227	24	247	319	0.774294670846395	0.817822983515247	0.848449425728892	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	8344993395.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T17:51:56.571434Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
936c0bdd-5dfe-4b4a-b632-d9b2d595f737	2026-08-18 13:16	2026-08-18 13:15	2026-08-18 13:15	NUAI	NUAI270115C00010000	call	10.0000	2027-01-15	1.0500	0.8500	1.0500	5.2800	16768.00	16768.00	0.00	160	11	505	4200	0.120238095238095	1.50674912240619	1.52596821181616	false	false	false	true
1d4ee3df-628d-4a22-a55a-953b343c46d8	2026-08-18 13:16	2026-08-18 13:15	2026-08-18 13:15	NUAI	NUAI270115C00010000	call	10.0000	2027-01-15	1.0300	0.8500	1.0500	5.2700	23049.00	23049.00	0.00	223	8	311	4200	0.074047619047619	1.511664983889	1.50674912240619	false	false	false	true
22b63728-a080-4276-b97f-f327709b04a1	2026-08-18 13:13	2026-08-18 13:13	2026-08-18 13:13	CCJ	CCJ270115C00100000	call	100.0000	2027-01-15	10.2700	9.8000	10.4000	95.7900	20535.00	19505.00	0.00	20	5	83	1275	0.0650980392156863	0.465014246241276	0.467058880655627	true	false	false	true
b7e00da7-74ab-40f5-85ad-5ba100eb29b2	2026-08-18 11:29	2026-08-18 11:29	2026-08-18 11:29	CVX	CVX261016P00195000	put	195.0000	2026-10-16	4.4500	4.4500	4.6000	204.5400	81494.00	0.00	81494.00	183	21	209	493	0.42393509127789	0.275574832148552	0.275574832148552	true	false	false	true
7b1f61ff-435e-4c50-b994-d2745f1aa0ea	2026-08-18 11:24	2026-08-18 11:24	2026-08-18 11:24	DHT	DHT260918C00020000	call	20.0000	2026-09-18	0.5800	0.5000	0.6500	19.0100	37829.00	21214.00	6935.00	656	43	862	604	1.42715231788079	0.415154046583364	0.416039038592227	true	false	false	true
c33f6a69-03ec-497f-b43f-ba67c37ea387	2026-08-18 10:46	2026-08-18 10:46	2026-08-18 10:46	DINO	DINO270115C00110000	call	110.0000	2027-01-15	6.4600	6.2000	6.6000	94.8600	12916.00	12916.00	0.00	20	9	62	2544	0.0243710691823899	0.46266334993326	0.46266334993326	false	false	false	true
ea54afb7-c01f-462a-9ab0-41a73963bc21	2026-08-18 09:49	2026-08-18 09:49	2026-08-18 09:49	XOM	XOM270617C00170000	call	170.0000	2027-06-17	14.8800	14.8500	15.4500	163.0000	744116.00	0.00	744116.00	500	17	1045	1533	0.681669928245271	0.255708942260054	0.261906392323958	false	false	false	true
8f94bb85-e9ec-4606-b49d-70041c0d6e68	2026-08-18 09:45	2026-08-18 09:45	2026-08-18 09:45	XOM	XOM270617C00170000	call	170.0000	2027-06-17	15.1000	14.8500	15.8500	163.0000	791037.00	35040.00	755997.00	524	24	525	1533	0.342465753424658	0.254999737952273	0.257786360553131	false	false	false	true
7f564710-95b7-4a80-ad60-8b42eae18b52	2026-08-18 09:45	2026-08-18 09:45	2026-08-18 09:45	FANG	FANG261218C00200000	call	200.0000	2026-12-18	21.0900	20.9000	21.1000	207.0000	56950.00	16860.00	0.00	27	9	45	533	0.0844277673545966	0.336751877270135	0.338972641045792	false	false	false	true
1a7a1087-4c1f-4e91-9c11-6934853c963a	2026-08-18 09:33	2026-08-18 09:33	2026-08-18 09:33	LEU	LEU261218P00160000	put	160.0000	2026-12-18	21.9900	20.2000	23.0000	178.0500	21986.00	21986.00	0.00	10	6	10	189	0.0529100529100529	0.808627551337879	0.808627551337879	false	false	false	true
9f3d6e5a-67ac-435a-90cc-b3e50bc7691b	2026-08-17 15:34	2026-08-17 15:33	2026-08-17 15:33	XOM	XOM261016P00160000	put	160.0000	2026-10-16	6.1000	5.9500	6.2000	161.3700	376388.00	31110.00	345278.00	617	58	711	912	0.779605263157895	0.27850396195485	0.278919145752805	false	false	false	true
c5816570-d2e6-4529-b150-4b5c3ff023fe	2026-08-17 15:32	2026-08-17 15:32	2026-08-17 15:32	OKE	OKE260918C00085000	call	85.0000	2026-09-18	11.1000	10.5000	11.1000	95.1100	72131.00	72131.00	0.00	65	6	68	780	0.0871794871794872	0.36273294271015	0.36273294271015	false	false	false	true
4d281c85-146b-4106-a0e6-0416f8f7277f	2026-08-17 15:05	2026-08-17 15:05	2026-08-17 15:05	CVX	CVX261120C00220000	call	220.0000	2026-11-20	4.9000	4.8500	5.0500	203.3800	119568.00	3430.00	103398.00	244	32	393	186	2.11290322580645	0.247119350279055	0.247119350279055	false	false	false	true
fef3dd35-0108-4b4e-9b44-c9903866fcd5	2026-08-17 14:44	2026-08-17 14:43	2026-08-17 14:43	CAPL	CAPL261016C00022500	call	22.5000	2026-10-16	2.1900	1.7000	2.6000	24.1550	10960.00	6680.00	4280.00	50	15	57	211	0.270142180094787	0.26476465255758	0.26476465255758	false	false	false	true
3b5e2d38-32aa-4523-8db8-f3bada44c02e	2026-08-17 14:28	2026-08-17 14:27	2026-08-17 14:27	STNG	STNG261016C00085000	call	85.0000	2026-10-16	3.2900	3.1000	3.3000	80.7250	12516.00	12516.00	0.00	38	8	396	270	1.46666666666667	0.370016842872471	0.370802664164342	false	false	false	true
4dec442e-997d-4728-bf5c-e8619cbcad04	2026-08-17 13:34	2026-08-17 13:34	2026-08-17 13:34	MPC	MPC260918C00320000	call	320.0000	2026-09-18	45.4800	44.0000	45.5000	361.6900	100060.00	100060.00	0.00	22	9	50	576	0.0868055555555556	0.387643174456786	0.387643174456786	false	false	false	true
32594aed-7f9b-4416-af7d-d0de6dfe0b1b	2026-08-17 12:14	2026-08-17 12:13	2026-08-17 12:13	CCJ	CCJ260821C00100000	call	100.0000	2026-08-21	2.3000	2.2500	2.3000	100.2450	17000.00	16100.00	900.00	74	6	424	3088	0.137305699481865	0.503251540909064	0.515233162273789	true	false	false	true
f3928805-45a7-4bb9-a694-b42a0bde80dd	2026-08-17 11:39	2026-08-17 11:39	2026-08-17 11:39	DINO	DINO260821C00095000	call	95.0000	2026-08-21	1.7000	1.7000	1.9000	94.5700	29923.00	0.00	29923.00	176	44	1526	7358	0.207393313400381	0.477310587060071	0.477310587060071	false	false	false	true
081a1057-5ecb-4633-b0e1-3b3678df7e2e	2026-08-17 11:39	2026-08-17 11:39	2026-08-17 11:39	DINO	DINO260821C00095000	call	95.0000	2026-08-21	1.8300	1.8000	2.0000	94.6600	41205.00	26085.00	15120.00	225	26	631	7358	0.085756999184561	0.494123959345563	0.504323751327378	false	false	false	true
c4957e0a-1bcb-4ef5-ba6c-f9f7ce418588	2026-08-17 11:21	2026-08-17 11:21	2026-08-17 11:21	AR	AR261120C00044000	call	44.0000	2026-11-20	0.6800	0.6500	0.8000	36.2300	11242.00	0.00	11242.00	166	22	401	3415	0.117423133235725	0.369560629378853	0.369560629378853	false	false	false	true
412bce28-e19e-4d5f-8ed2-94218c423bcd	2026-08-17 10:49	2026-08-17 10:49	2026-08-17 10:49	NXE	NXE260918C00012000	call	12.0000	2026-09-18	0.5000	0.4000	0.5000	11.0650	49998.00	49998.00	0.00	1000	8	3111	5176	0.601043276661515	0.637203976885816	0.637203976885816	false	false	false	true
d25a0b51-7a07-43b9-95ee-a9e0420fcdde	2026-08-17 10:48	2026-08-17 10:48	2026-08-17 10:48	DNN	DNN270115C00004500	call	4.5000	2027-01-15	0.3500	0.1500	0.3500	3.2350	34600.00	33940.00	660.00	1000	27	1000	9079	0.110144289018614	0.711653129457452	0.841237083709786	false	false	false	true
9ff58202-6043-412e-9052-a5d7221e2bd5	2026-08-17 10:46	2026-08-17 10:46	2026-08-17 10:46	NXE	NXE261120C00011000	call	11.0000	2026-11-20	1.5400	1.4000	1.5500	11.0500	18941.00	18941.00	0.00	123	7	5266	1134	4.64373897707231	0.643933314272883	0.660793214979044	false	false	false	true
b3be51cf-9a30-4616-ba3f-23e72f1a90e6	2026-08-17 10:43	2026-08-17 10:43	2026-08-17 10:43	NXE	NXE260918C00012000	call	12.0000	2026-09-18	0.4500	0.3000	0.4500	10.9212	89949.00	89909.00	40.00	2000	53	2010	5176	0.388330757341577	0.605345094564974	0.647290001315638	true	false	false	true
85460b7e-e979-409d-8b85-ba29cba5beab	2026-08-17 10:24	2026-08-17 10:23	2026-08-17 10:23	NXE	NXE260918C00011000	call	11.0000	2026-09-18	0.6500	0.3500	0.6500	10.5500	22208.00	14928.00	0.00	344	12	361	7852	0.0459755476311768	0.622307414404113	0.662659808434419	true	false	false	true
7ed30da7-ae4e-4653-a60c-08f2701e768a	2026-08-17 10:23	2026-08-17 10:23	2026-08-17 10:23	CVX	CVX270617C00195000	call	195.0000	2027-06-17	22.5100	22.4500	23.3000	201.4750	137295.00	9040.00	126005.00	61	7	173	975	0.177435897435897	0.214890741399778	0.215639437630529	false	false	false	true
4c6638e3-b63a-4e23-bab9-6e8648b55994	2026-08-17 10:01	2026-08-17 10:01	2026-08-17 10:01	WMB	WMB270115C00075000	call	75.0000	2027-01-15	5.6700	4.9000	5.8000	75.0400	1700220.00	453300.00	1246920.00	2996	83	3022	1442	2.09570041608877	0.252548419423905	0.264668265866278	true	false	false	true
3e7e3709-6536-4362-8104-9fcc3454a0f6	2026-08-17 09:50	2026-08-17 09:50	2026-08-17 09:50	DINO	DINO261218C00135000	call	135.0000	2026-12-18	1.8800	1.7500	2.8000	94.7175	14075.00	0.00	14075.00	75	7	75	175	0.428571428571429	0.487288276599216	0.502225896547328	false	false	false	true