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

4150c2e5-1912-44fa-8a65-b5de64f8c9b9	2026-08-20 14:16	2026-08-20 14:15	2026-08-20 14:15	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4000	2.5800	94.1100	84034.00	82784.00	1250.00	336	19	1114	2581	0.431615652847733	0.437654618490477	0.43852123702627	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	40610811028.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
49d905cd-fa11-43a4-baf3-e5bee5f8bc01	2026-08-20 14:02	2026-08-20 14:02	2026-08-20 14:02	COP	COP260918P00135000	put	135.0000	2026-09-18	4.7000	4.7000	4.8500	134.3250	140555.00	0.00	140555.00	299	50	651	90	7.23333333333333	0.301879364426809	0.301879364426809	false	false	false	true
4c9be4fe-b87d-4e58-a516-9bf2e32036d3	2026-08-20 13:20	2026-08-20 13:20	2026-08-20 13:20	VLO	VLO260918P00330000	put	330.0000	2026-09-18	9.2100	9.1000	9.7000	344.7150	85660.00	50600.00	35060.00	93	16	1463	1332	1.09834834834835	0.418137717363143	0.418137717363143	true	false	false	true
e1aec518-899d-4c57-995f-c22492423f7b	2026-08-20 13:01	2026-08-20 13:01	2026-08-20 13:01	VAL	VAL271217P00060000	put	60.0000	2027-12-17	6.5000	4.7000	6.5000	88.4450	13642.00	13642.00	0.00	21	9	81	21	3.85714285714286	0.559525690196763	0.561165363454178	false	false	false	true
98f2e146-3394-4881-97dc-3fe1ef7b97e1	2026-08-20 12:42	2026-08-20 12:41	2026-08-20 12:41	XOM	XOM261002C00170000	call	170.0000	2026-10-02	5.7200	5.3000	5.9000	167.5100	114354.00	114354.00	0.00	200	7	208	116	1.79310344827586	0.283691399482895	0.283691399482895	false	false	false	true
3662ac57-774c-4918-839f-e843b8953c93	2026-08-20 12:35	2026-08-20 12:35	2026-08-20 12:35	VET	VET261218C00017500	call	17.5000	2026-12-18	0.2800	0.2500	0.3000	12.8710	19700.00	19700.00	0.00	700	21	2901	414	7.00724637681159	0.47100660644413	0.481590462451535	false	false	false	true
937ff91b-3318-4eef-8621-3fa1fea4a06f	2026-08-20 12:06	2026-08-20 12:05	2026-08-20 12:05	KMI	KMI270917C00028000	call	28.0000	2027-09-17	5.1000	5.1000	5.6000	31.4900	52048.00	0.00	52048.00	102	9	102	0	0	0.153031942998477	0.154246808862977	true	false	false	true
29cb086c-d049-4043-8732-4dcfe4b74270	2026-08-20 12:05	2026-08-20 12:04	2026-08-20 12:04	COP	COP270115P00155000	put	155.0000	2027-01-15	22.9500	22.6500	22.9500	135.7550	190477.00	190477.00	0.00	83	15	86	1	86	0.35074511977167	0.352006300285055	true	false	false	true
0a2d3363-6fd1-491b-9432-a2534dd92f31	2026-08-20 10:11	2026-08-20 10:11	2026-08-20 10:11	COP	COP261120C00145000	call	145.0000	2026-11-20	4.9100	4.7000	5.0500	134.8000	84045.00	82085.00	490.00	171	38	172	238	0.722689075630252	0.30847197176351	0.31042680223679	true	false	false	true
a5e17c8e-066a-4ca4-be9a-65560221b2e9	2026-08-20 10:04	2026-08-20 10:04	2026-08-20 10:04	SHEL	SHEL260821C00094000	call	94.0000	2026-08-21	0.8000	0.7500	0.9000	94.4450	86734.00	46160.00	40254.00	1084	65	2784	10730	0.259459459459459	0.260080634121993	0.275797287077755	false	false	false	true
d8a2cc3a-78eb-407e-a28e-4b96e3a26b57	2026-08-20 09:55	2026-08-20 09:55	2026-08-20 09:55	PBF	PBF260918P00057500	put	57.5000	2026-09-18	0.7000	0.7000	0.8000	73.9750	18842.00	0.00	18842.00	269	38	270	138	1.95652173913043	0.732613632517141	0.732613632517141	false	false	false	true
4e7b96c1-6ba5-4831-98fe-0bdd3d51c196	2026-08-20 09:50	2026-08-20 09:50	2026-08-20 09:50	OXY	OXY261218C00060000	call	60.0000	2026-12-18	5.9500	5.6000	5.9500	61.9800	95198.00	95198.00	0.00	160	5	545	4498	0.121164962205425	0.319694480549716	0.319694480549716	false	false	false	true
ee3c83bf-f3f9-42e4-aae9-32cc0d00a0c5	2026-08-20 09:47	2026-08-20 09:47	2026-08-20 09:47	SOC	SOC261016P00005000	put	5.0000	2026-10-16	0.8100	0.8100	0.9000	5.0700	40650.00	0.00	40650.00	500	9	513	835	0.61437125748503	1.08340499673007	1.13261154938028	false	false	false	true
5fd81cf3-35a4-43c4-801c-38c60cbe871e	2026-08-20 09:47	2026-08-20 09:47	2026-08-20 09:47	OXY	OXY261016C00060000	call	60.0000	2026-10-16	4.1000	4.0500	4.3500	61.8400	78303.00	41000.00	37303.00	191	15	443	5482	0.0808099233856257	0.292939290252519	0.303127799689539	false	false	false	true
4f9f661a-788e-4570-b491-0d93a071e1c5	2026-08-19 15:42	2026-08-19 15:42	2026-08-19 15:42	NUAI	NUAI270115C00010000	call	10.0000	2027-01-15	0.9600	0.9500	1.1500	5.3350	15532.00	0.00	15532.00	162	11	334	4184	0.0798279158699809	1.43837622752683	1.45338336803029	true	false	false	true
c8c99c2e-5e96-4c1e-95d2-ccb0d83c84e4	2026-08-19 15:36	2026-08-19 15:36	2026-08-19 15:36	CLMT	CLMT270115C00060000	call	60.0000	2027-01-15	4.3000	4.3000	4.6000	48.9400	54626.00	0.00	54626.00	127	21	234	575	0.40695652173913	0.616335749642167	0.617169254511569	false	false	false	true
6a7fdfaf-c153-43d1-bace-32ee83d1b146	2026-08-19 15:32	2026-08-19 15:32	2026-08-19 15:32	XOM	XOM261120P00165000	put	165.0000	2026-11-20	8.8500	8.8000	9.0000	165.1450	484126.00	6195.00	477931.00	547	59	609	121	5.03305785123967	0.293773849684036	0.293773849684036	false	false	false	true
4d757a8f-f604-418b-91a2-95c89125b564	2026-08-19 15:21	2026-08-19 15:21	2026-08-19 15:21	SHEL	SHEL261016P00087500	put	87.5000	2026-10-16	1.1500	1.1500	1.2500	92.9900	102720.00	0.00	102720.00	893	43	1048	1301	0.805534204458109	0.232839300850319	0.232839300850319	false	false	false	true
7276a4f9-32b3-4aba-991b-ba6b692c0228	2026-08-19 15:06	2026-08-19 15:05	2026-08-19 15:05	COP	COP261016P00130000	put	130.0000	2026-10-16	5.3500	5.3500	5.5000	130.7850	116644.00	0.00	116644.00	218	43	244	32	7.625	0.295413393763264	0.295413393763264	false	false	false	true
4ae2fb20-cc22-4481-b677-ef77336950b7	2026-08-19 14:25	2026-08-19 14:25	2026-08-19 14:25	XOM	XOM261218P00165000	put	165.0000	2026-12-18	9.7500	9.7500	9.9000	165.7800	446562.00	0.00	446562.00	458	66	541	367	1.47411444141689	0.295770115246592	0.295770115246592	false	false	false	true
9ef9cd6e-af0c-4109-acff-dc521c464e5a	2026-08-19 14:06	2026-08-19 14:06	2026-08-19 14:06	UEC	UEC260918C00012000	call	12.0000	2026-09-18	0.6200	0.6100	0.6300	11.3850	15162.00	6730.00	62.00	244	25	332	2329	0.142550450837269	0.661048811957116	0.659327385209228	true	false	false	true
2df6dfc9-4c36-4304-a305-bcfcb7fc6144	2026-08-19 14:04	2026-08-19 14:04	2026-08-19 14:04	PR	PR261016C00025000	call	25.0000	2026-10-16	0.7000	0.6500	0.7500	23.0001	18826.00	420.00	18406.00	268	24	32056	4632	6.92055267702936	0.378871639710036	0.378871639710036	true	false	false	true
ab863489-d1fe-4c37-a0fd-8839fadea736	2026-08-19 13:49	2026-08-19 13:49	2026-08-19 13:49	SOC	SOC260918P00005000	put	5.0000	2026-09-18	0.7300	0.7000	0.7300	4.7450	118002.00	117092.00	910.00	1617	9	1621	700	2.31571428571429	1.03254558055924	1.03254558055924	false	false	false	true
0529ea6b-cf03-4ff5-ab7d-d9d4277c3e8e	2026-08-19 13:40	2026-08-19 13:40	2026-08-19 13:40	SM	SM260918C00040000	call	40.0000	2026-09-18	0.9500	0.8000	0.9500	36.5750	33652.00	33652.00	0.00	356	10	770	135	5.7037037037037	0.503322935781338	0.50880476890291	true	false	false	true
019d14f8-339f-4452-8515-22e53de8bf29	2026-08-19 13:33	2026-08-19 13:33	2026-08-19 13:33	XOM	XOM270617C00180000	call	180.0000	2027-06-17	12.4000	12.4000	12.6500	166.1500	212101.00	1250.00	210851.00	171	14	319	1103	0.28921124206709	0.261188607804194	0.261854099778502	false	false	false	true
16c0e9fb-9c81-4df9-b051-2820be27824e	2026-08-19 13:05	2026-08-19 13:05	2026-08-19 13:05	PR	PR261016C00025000	call	25.0000	2026-10-16	0.7000	0.7000	0.7500	23.0550	14084.00	0.00	14084.00	200	11	17948	4632	3.87478411053541	0.3733957045073	0.3733957045073	false	false	false	true
4cfb9635-dd94-40f0-a59d-8725bc7d2e8e	2026-08-19 13:01	2026-08-19 13:01	2026-08-19 13:01	PR	PR261016C00025000	call	25.0000	2026-10-16	0.7000	0.6500	0.7500	23.1300	14992.00	14852.00	0.00	215	9	14418	4632	3.11269430051813	0.361439218704308	0.365891858101958	false	false	false	true
5b1e3d1e-f348-4ad3-b812-6f70d088d0a3	2026-08-19 12:57	2026-08-19 12:56	2026-08-19 12:56	PR	PR261016C00025000	call	25.0000	2026-10-16	0.6000	0.5500	0.6000	22.8350	23502.00	23331.00	171.00	392	12	9228	4632	1.99222797927461	0.361178239892285	0.364317866366798	false	false	false	true
92dea54a-75fd-4664-8548-d73cdb15fce7	2026-08-19 12:10	2026-08-19 12:09	2026-08-19 12:09	NXE	NXE260918C00011000	call	11.0000	2026-09-18	0.5000	0.5000	0.5500	10.4400	78071.00	0.00	78071.00	1560	66	7356	14676	0.501226492232216	0.588978692004387	0.599752741359531	false	false	false	true
1b66b9f3-7b7f-43fa-b024-d99fe2d8f604	2026-08-19 12:05	2026-08-19 12:05	2026-08-19 12:05	HAL	HAL261016C00036000	call	36.0000	2026-10-16	1.5600	1.5200	1.5600	35.0950	35879.00	35724.00	155.00	230	17	266	1940	0.137113402061856	0.332692643928179	0.334490038911496	false	false	false	true
007a6f73-f952-4ba8-9ab8-7a5206287920	2026-08-19 12:04	2026-08-19 12:04	2026-08-19 12:04	DNN	DNN270115C00004500	call	4.5000	2027-01-15	0.3500	0.2000	0.3500	3.2088	104768.00	104768.00	0.00	3000	5	3013	10036	0.300219210840972	0.834030422027669	0.859807921472331	false	false	false	true
822c20cf-ae56-4c19-8e62-c089a8cdaac6	2026-08-19 11:29	2026-08-19 11:29	2026-08-19 11:29	OII	OII270115C00055000	call	55.0000	2027-01-15	6.0000	6.0000	6.4000	53.4400	176482.00	4880.00	171602.00	294	44	337	933	0.361200428724544	0.463850711602624	0.463850711602624	true	false	false	true
e100b1ea-779d-476a-acb6-1f13bbd87908	2026-08-19 11:28	2026-08-19 11:28	2026-08-19 11:28	XOM	XOM261016P00170000	put	170.0000	2026-10-16	8.3000	8.3000	8.6000	167.3800	789459.00	0.00	789459.00	951	49	976	154	6.33766233766234	0.27973205076674	0.27973205076674	false	false	false	true
f56a82bf-02ee-4b44-b3ca-d084d7e7874b	2026-08-19 11:15	2026-08-19 11:15	2026-08-19 11:15	VLO	VLO260918C00350000	call	350.0000	2026-09-18	17.2300	17.2000	18.1000	349.2750	101630.00	0.00	101630.00	59	23	95	1406	0.0675675675675676	0.426518690590337	0.429028059515841	true	false	false	true
ac8c9f8d-28b8-4e98-a111-88cc0347764c	2026-08-19 10:38	2026-08-19 10:37	2026-08-19 10:37	CVX	CVX270115C00200000	call	200.0000	2027-01-15	18.3200	18.0000	18.5500	207.0900	54968.00	54968.00	0.00	30	8	43	6441	0.00667598199037417	0.24277232300639	0.24277232300639	false	false	false	true
57432003-b06c-43c4-8642-666e3bc73d95	2026-08-19 10:11	2026-08-19 10:11	2026-08-19 10:11	CVX	CVX270115C00230000	call	230.0000	2027-01-15	6.3700	5.8000	6.4500	207.4200	63731.00	63731.00	0.00	100	14	100	2677	0.0373552484124019	0.248858699678458	0.248858699678458	false	false	false	true
85ed40b0-e4dc-4282-8aa3-7459835218cb	2026-08-19 10:10	2026-08-19 10:09	2026-08-19 10:09	SM	SM260821C00035000	call	35.0000	2026-08-21	1.2400	1.1500	1.5000	35.9250	12436.00	0.00	8311.00	100	5	397	3335	0.11904047976012	0.643525395967214	0.654622007593514	false	false	false	true
fc8db3b9-e80e-4bcb-841d-95188f6b3c44	2026-08-19 10:06	2026-08-19 10:06	2026-08-19 10:06	VLO	VLO260911P00310000	put	310.0000	2026-09-11	3.2300	1.4500	4.2000	345.2300	198345.00	198345.00	0.00	615	5	615	104	5.91346153846154	0.448646842233357	0.451106748485726	false	false	false	true
ac32cc12-65a5-4cdc-8f14-668714e23b57	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	OBE	OBE260918C00012500	call	12.5000	2026-09-18	0.7000	0.5500	0.7000	11.7450	10748.00	10748.00	0.00	154	9	300	2066	0.145208131655373	0.714951265070879	0.737195040689482	false	false	false	true
8d9bac4b-3eff-4919-9445-8853af5ad63d	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	OBE	OBE260918C00012500	call	12.5000	2026-09-18	0.7000	0.5500	0.7000	11.7200	10212.00	10212.00	0.00	146	7	146	2066	0.0706679574056147	0.714951265070879	0.745326250621551	false	false	false	true
c7aa6a6b-9053-4730-a290-d626394778e8	2026-08-18 15:15	2026-08-18 15:15	2026-08-18 15:15	SUN	SUN261218C00080000	call	80.0000	2026-12-18	3.1800	3.1000	3.5000	76.7800	25408.00	14368.00	960.00	80	10	171	658	0.259878419452888	0.230999791419231	0.231570172253164	false	false	false	true
32cbc59f-aa72-4407-a473-bba25879ca7c	2026-08-18 15:06	2026-08-18 15:06	2026-08-18 15:06	WES	WES270219P00050000	put	50.0000	2027-02-19	3.3000	3.2000	3.4000	49.7700	66050.00	0.00	56480.00	200	10	300	300	1	0.261698121414504	0.263034900280931	false	false	false	true
289e0f65-62ec-4cf1-bdd2-2f3c731d35f1	2026-08-18 14:53	2026-08-18 14:53	2026-08-18 14:53	NUAI	NUAI260821P00004500	put	4.5000	2026-08-21	0.1000	0.0500	0.1000	5.1350	14898.00	14898.00	0.00	1500	11	1577	7913	0.199292303803867	1.78136501135537	1.78136501135537	false	false	false	true
49128069-028c-4942-bdef-7b59405a29c9	2026-08-18 14:35	2026-08-18 14:34	2026-08-18 14:34	FANG	FANG260918P00190000	put	190.0000	2026-09-18	1.8300	1.5500	1.9000	209.9800	210339.00	210339.00	0.00	1150	7	1179	497	2.37223340040241	0.355385928316493	0.355385928316493	false	false	false	true
bc1e1f46-295e-4969-a2d7-b91b8766b71b	2026-08-18 14:32	2026-08-18 14:32	2026-08-18 14:32	ET	ET270115C00023000	call	23.0000	2027-01-15	0.4800	0.4300	0.4800	21.3975	90014.00	90014.00	0.00	1878	33	2062	28074	0.0734487426088195	0.171402204853004	0.173261549608997	true	false	false	true
e400e7c5-6f9a-459e-8e7d-67e743f6df1d	2026-08-18 14:17	2026-08-18 14:17	2026-08-18 14:17	BP	BP261218C00045000	call	45.0000	2026-12-18	2.3600	2.3000	2.3700	43.4150	200448.00	197432.00	3016.00	850	5	17002	2183	7.78836463582226	0.27569435172866	0.27569435172866	false	false	false	true
e86cffd2-940c-4922-87a0-1fda2278e419	2026-08-18 14:02	2026-08-18 14:02	2026-08-18 14:02	DINO	DINO260918C00100000	call	100.0000	2026-09-18	3.3000	3.3000	3.5000	95.3600	217160.00	0.00	217160.00	658	41	735	3625	0.202758620689655	0.456774019881281	0.456774019881281	false	false	false	true
e0f30529-23c0-4c9e-bb0f-008881a2a5bc	2026-08-18 13:59	2026-08-18 13:59	2026-08-18 13:59	XOM	XOM261120C00175000	call	175.0000	2026-11-20	6.0500	5.9500	6.0500	165.0753	120385.00	120385.00	0.00	199	5	225	1777	0.126617895329207	0.279999378535087	0.279999378535087	false	false	false	true
e24f6b57-9014-4bba-bcc8-ff09c729572e	2026-08-18 13:52	2026-08-18 13:52	2026-08-18 13:52	PBF	PBF260821C00070000	call	70.0000	2026-08-21	5.0200	4.9000	5.4000	74.5700	150597.00	22500.00	128097.00	300	10	305	6311	0.0483283156393598	0.742493817622134	0.788104598172524	false	false	false	true
e85a4867-e6bb-43de-bedc-3be9d916816b	2026-08-18 13:50	2026-08-18 13:50	2026-08-18 13:50	CVX	CVX261016C00220000	call	220.0000	2026-10-16	3.1000	3.0000	3.2000	204.9764	271598.00	4960.00	266638.00	876	64	1072	3367	0.318384318384318	0.24057454804575	0.241005325710931	false	false	false	true