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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×ticker = CCJ×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

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	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-17T16:27:21.112559Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
27539c58-c06c-4169-aa98-3bceddc959a0	2026-08-21 09:50	2026-08-21 09:50	2026-08-21 09:50	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.4500	2.2000	2.5400	101.2300	36237.00	12442.00	12795.00	148	28	1543	18395	0.0838814895351998	0.487501453387239	0.49556018590606	true	false	false	true
1f8cd92a-1597-40d3-b6f9-1c43976fd07d	2026-08-21 09:51	2026-08-21 09:51	2026-08-21 09:51	CCJ	CCJ260828C00102000	call	102.0000	2026-08-28	2.6500	1.4800	2.8200	101.5500	16666.00	15905.00	761.00	63	16	72	160	0.45	0.50855499268398	0.484674159782163	true	false	false	true
05ba5f6f-ad18-434a-b481-1ed932a9fdab	2026-08-21 09:51	2026-08-21 09:51	2026-08-21 09:51	CCJ	CCJ260828C00104000	call	104.0000	2026-08-28	1.8600	1.3700	2.0100	101.5500	21976.00	14710.00	7266.00	118	16	122	241	0.506224066390041	0.515899005758841	0.511761265210566	true	false	false	true
5c858d17-aaf3-447b-944b-070cf97902c0	2026-08-21 09:58	2026-08-21 09:58	2026-08-21 09:58	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.9000	2.6000	3.0500	102.0500	39156.00	35093.00	4063.00	135	22	4582	18395	0.249089426474585	0.513120160435934	0.512506192134915	false	false	false	true
e82ceafc-8ee4-4497-b60d-9707be7ee816	2026-08-21 14:07	2026-08-21 14:07	2026-08-21 14:07	CCJ	CCJ280121C00110000	call	110.0000	2028-01-21	21.9600	21.6500	24.1500	100.0000	217380.00	0.00	217380.00	99	6	101	597	0.169179229480737	0.478292618198641	0.5014271276548	false	false	false	true
eaabece1-94bd-4bdc-934c-c18d012808bd	2026-08-24 10:08	2026-08-24 10:08	2026-08-24 10:08	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	2.2600	2.2000	2.2700	101.4000	11275.00	5650.00	1575.00	50	38	82	11590	0.00707506471095772	0.475946157445127	0.478215266063508	false	false	false	true
b8a628a7-02e7-4cb7-929d-91771ed82a56	2026-08-24 10:10	2026-08-24 10:10	2026-08-24 10:10	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	2.1200	2.0800	2.3400	101.8200	21600.00	4663.00	9957.00	102	93	219	11590	0.0188955996548749	0.470391075888759	0.476173275135884	true	false	false	true
122a7978-1bfb-43b2-8e7a-377aa9b2e478	2026-08-26 10:45	2026-08-26 10:45	2026-08-26 10:45	CCJ	CCJ261218C00110000	call	110.0000	2026-12-18	11.6800	11.6500	11.8500	108.3350	19860.00	12870.00	6990.00	17	13	103	1844	0.0558568329718004	0.490031831847239	0.492118378378164	false	false	false	true
ff4bfdc2-52c3-43e6-b9c8-b26bfd0de66a	2026-08-27 09:57	2026-08-27 09:57	2026-08-27 09:57	CCJ	CCJ280121C00140000	call	140.0000	2028-01-21	17.9100	16.5500	19.1000	107.4250	358170.00	322750.00	35420.00	200	6	200	416	0.480769230769231	0.510083275954303	0.510083275954303	false	false	false	true
1cfaaa35-37ff-492b-b6c8-73d217ca900e	2026-08-27 10:56	2026-08-27 10:56	2026-08-27 10:56	CCJ	CCJ270617C00095000	call	95.0000	2027-06-17	25.2200	25.2000	27.4000	105.4900	27742.00	2525.00	25217.00	11	8	12	31	0.387096774193548	0.503555441627636	0.503555441627636	true	false	false	true
c63ac38b-c182-447a-b7f4-459ac14ce0f9	2026-08-28 10:12	2026-08-28 10:12	2026-08-28 10:12	CCJ	CCJ261009P00095000	put	95.0000	2026-10-09	2.9900	2.6800	3.3000	101.5800	13767.00	10474.00	3293.00	46	15	66	2	33	0.440288817704048	0.440861668524512	true	false	false	true
240016ef-b089-48ff-9643-349592572814	2026-08-28 10:13	2026-08-28 10:13	2026-08-28 10:13	CCJ	CCJ260828P00101000	put	101.0000	2026-08-28	0.6200	0.2900	0.8300	101.5650	11579.00	11017.00	252.00	186	31	208	22	9.45454545454546	0.84283685516586	0.8527982587888	true	false	false	true
6c6d3004-1dda-4c13-b2f5-0a46bda942f3	2026-08-28 15:01	2026-08-28 15:01	2026-08-28 15:01	CCJ	CCJ261218P00095000	put	95.0000	2026-12-18	7.2500	7.2500	7.5000	100.4499	210987.00	0.00	210987.00	291	41	346	1269	0.272655634357762	0.474734151287629	0.476685004839573	false	false	false	true
2fa45ee3-2c5e-44e0-ad62-8d5f52e53771	2026-09-01 11:54	2026-09-01 11:54	2026-09-01 11:54	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	0.5100	0.4700	0.6500	96.9550	64518.00	564.00	57069.00	1265	60	1933	21812	0.0886209426004034	0.4591065498689	0.4591065498689	true	false	false	true
fd3ba5c3-195b-4b7a-a53a-98fb8ab018c5	2026-09-03 10:49	2026-09-03 10:49	2026-09-03 10:49	CCJ	CCJ260911C00105000	call	105.0000	2026-09-11	1.1400	1.1000	1.3300	101.1400	11404.00	2070.00	9334.00	100	5	110	200	0.55	0.420045342325261	0.43172493949527	false	false	false	true
7e3d1db7-c9ba-4adc-93ce-05edf7478fd7	2026-09-03 15:55	2026-09-03 15:54	2026-09-03 15:54	CCJ	CCJ280121P00090000	put	90.0000	2028-01-21	14.1400	13.5000	14.3000	100.5490	56578.00	56578.00	0.00	40	16	40	716	0.0558659217877095	0.493382745455659	0.493382745455659	false	false	false	true
81f027cb-0d51-4e59-86d0-d2b8d07636c4	2026-09-03 15:55	2026-09-03 15:55	2026-09-03 15:55	CCJ	CCJ280121P00090000	put	90.0000	2028-01-21	14.2000	13.6000	14.4500	100.4900	56810.00	56810.00	0.00	40	6	91	716	0.127094972067039	0.495232812301544	0.495232812301544	false	false	false	true
3b501fb9-2f79-42d5-9dfa-84f75d2191bb	2026-09-09 11:11	2026-09-09 11:11	2026-09-09 11:11	CCJ	CCJ260918C00107000	call	107.0000	2026-09-18	0.8700	0.7600	1.0500	99.5400	41900.00	911.00	40109.00	481	43	485	526	0.922053231939164	0.510808082616293	0.52513921995246	true	false	false	true
9662faec-157c-4cc4-945f-2e620978094e	2026-09-09 11:12	2026-09-09 11:11	2026-09-09 11:11	CCJ	CCJ260918P00098000	put	98.0000	2026-09-18	2.3600	2.2500	2.4800	99.4000	11818.00	4266.00	7552.00	50	5	50	110	0.454545454545455	0.493336497697552	0.493336497697552	false	false	false	true
bcc75830-55a6-4776-99b8-45ca71d18783	2026-09-11 10:42	2026-09-11 10:42	2026-09-11 10:42	CCJ	CCJ261016C00115000	call	115.0000	2026-10-16	1.1600	1.0100	1.3300	96.8800	15027.00	0.00	7656.00	129	6	136	827	0.164449818621524	0.501075740789011	0.501075740789011	false	false	false	true
4d4ac4f6-db07-4653-946c-9246d8719574	2026-09-11 12:20	2026-09-11 12:20	2026-09-11 12:20	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	7.4500	7.2500	7.7500	97.1100	312919.00	750.00	312169.00	420	48	423	6	70.5	0.49624977925332	0.499196941541934	false	false	false	true
50aa4044-0051-4937-ac51-21091b20aa88	2026-09-14 11:39	2026-09-14 11:39	2026-09-14 11:39	CCJ	CCJ260918C00098000	call	98.0000	2026-09-18	0.6500	0.5300	0.6600	93.3500	18067.00	17287.00	780.00	277	20	589	62	9.5	0.560771574017594	0.564273274355304	true	false	false	true
4ed420c3-9b2e-4fd4-b186-801943537ef3	2026-09-16 10:24	2026-09-16 10:24	2026-09-16 10:24	CCJ	CCJ261218C00105000	call	105.0000	2026-12-18	4.6800	4.6000	4.7000	91.0000	163852.00	163852.00	0.00	350	16	351	1314	0.267123287671233	0.48663982002608	0.486057176565487	false	false	false	true
7f8062b2-fa44-43b3-bba5-1ff2aafa5bc1	2026-09-16 10:24	2026-09-16 10:24	2026-09-16 10:24	CCJ	CCJ261218C00105000	call	105.0000	2026-12-18	4.7000	4.4500	4.8000	91.0000	23015.00	23015.00	0.00	49	9	400	1314	0.30441400304414	0.484973365770225	0.484973365770225	false	false	false	true
b7f7bfbe-4f6a-4f32-a044-d5d28419ae35	2026-09-16 15:30	2026-09-16 15:30	2026-09-16 15:30	CCJ	CCJ290119P00050000	put	50.0000	2029-01-19	4.0100	4.0000	4.6000	89.9900	16830.00	830.00	14000.00	42	13	92	0	0	0.475237456100076	0.486036820335663	false	false	false	true
a3ad5e53-1b70-46e3-bf14-e28e80ef4d62	2026-09-17 11:26	2026-09-17 11:26	2026-09-17 11:26	CCJ	CCJ270617P00085000	put	85.0000	2027-06-17	9.6200	9.6000	10.0500	92.2400	22135.00	1930.00	20205.00	23	13	32	396	0.0808080808080808	0.469783665743809	0.472217296133648	true	false	false	true
46ce1379-ecb3-4171-a64b-1895deab9e71	2026-09-18 12:28	2026-09-18 12:28	2026-09-18 12:28	CCJ	CCJ290119C00120000	call	120.0000	2029-01-19	21.3000	21.0000	23.0000	91.3600	14910.00	6420.00	8490.00	7	5	7	30	0.233333333333333	0.479009257434324	0.486262858638706	false	false	false	true
9bb5562b-f813-4c0b-acdd-1bb79525736a	2026-09-18 13:48	2026-09-18 13:48	2026-09-18 13:48	CCJ	CCJ270319C00100000	call	100.0000	2027-03-19	10.9600	10.3500	12.5500	93.5200	109580.00	0.00	109580.00	100	16	124	406	0.305418719211823	0.483304120259694	0.483304120259694	false	false	false	true
fe4b329e-8777-47c3-8dff-b10dc0c0dd71	2026-09-18 14:33	2026-09-18 14:33	2026-09-18 14:33	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.9300	4.6000	5.0000	92.5200	72991.00	69526.00	0.00	148	15	290	538	0.539033457249071	0.493271234030009	0.496627684515941	false	false	false	true
b2c789d6-ab97-4fce-98a8-2b46c6c1b17f	2026-09-18 14:33	2026-09-18 14:33	2026-09-18 14:33	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	4.6000	5.1000	92.6800	86010.00	63500.00	22005.00	172	53	463	538	0.860594795539034	0.495615540111808	0.495615540111808	true	false	false	true
41190f3d-7508-4e55-9c27-06ad9b04b885	2026-09-18 15:41	2026-09-18 15:41	2026-09-18 15:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6400	1.6000	1.8300	91.6250	22429.00	21609.00	820.00	137	12	1935	10270	0.188412852969815	0.432110839691357	0.433383102390724	false	false	false	true
0101ba7b-fa00-4d75-9455-97b229143910	2026-09-21 14:45	2026-09-21 14:45	2026-09-21 14:45	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	1.4000	1.3700	1.5500	93.5400	22010.00	1402.00	20608.00	157	30	849	2213	0.383642114776322	0.516055076657123	0.513412403913419	false	false	false	true
0ce77100-b1b2-4010-a08e-67530eb0beda	2026-09-21 14:47	2026-09-21 14:46	2026-09-21 14:46	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	1.4200	1.3500	1.5200	93.0000	24830.00	3041.00	21789.00	175	55	1024	2213	0.462720289200181	0.512875107681257	0.520786471932899	true	false	false	true
4a75c2dd-9fb1-4bcc-bff0-1c869151ab06	2026-09-21 15:36	2026-09-21 15:36	2026-09-21 15:36	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	1.4400	1.3400	1.5800	93.7800	118234.00	56126.00	62108.00	821	42	1892	2213	0.854948034342521	0.501946633494684	0.500825697485432	true	false	false	true
e7536794-5aa9-4cff-84dd-5bef274a29db	2026-09-21 15:41	2026-09-21 15:41	2026-09-21 15:41	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	1.7700	1.6500	2.0000	93.9400	13639.00	895.00	12744.00	77	25	3277	2213	1.48079530049706	0.568631485838262	0.568631485838262	true	false	false	true
1e690aa7-a2f3-46ab-b785-d138c4025929	2026-09-22 10:17	2026-09-22 10:17	2026-09-22 10:17	CCJ	CCJ261016C00090000	call	90.0000	2026-10-16	6.2500	6.2500	6.7500	93.4200	87515.00	1890.00	85625.00	140	26	240	530	0.452830188679245	0.445431001217148	0.445431001217148	true	false	false	true