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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×endpoint = /api/option-trades/flow-alerts×ticker = CCJ×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strike

7a8b4f94-cfde-4cc6-956d-f3ee15a5a8c4	2026-09-29 14:19	2026-09-29 14:19	2026-09-29 14:19	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	2.3600	2.2900	2.3900	86.0000	11334.00	9717.00	1617.00	48	15	1940	4441	0.436838549876154	0.491022014517165	0.485424148940308	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Energy	37832589129.00	2026-11-04	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T18:21:06.128896Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
634b773c-7b76-4220-b92f-b690c3658d11	2026-09-29 13:45	2026-09-29 13:45	2026-09-29 13:45	CCJ	CCJ290119C00105000	call	105.0000	2029-01-19	21.7600	20.7000	22.0500	86.6900	67450.00	6535.00	50040.00	31	13	31	3	10.3333333333333	0.470545145767921	0.471056943569813	false	false
397cfb6d-4ba4-4dda-98c0-0d0c0dd87a1b	2026-09-29 10:19	2026-09-29 10:19	2026-09-29 10:19	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	2.3000	2.1600	2.3000	87.6200	13104.00	11959.00	1145.00	57	6	456	4441	0.102679576671921	0.468077874801821	0.468568050516603	false	false
f5048863-af72-4508-8f23-bf02ee21b18c	2026-09-29 10:16	2026-09-29 10:16	2026-09-29 10:16	CCJ	CCJ261120C00090000	call	90.0000	2026-11-20	5.1900	5.0000	5.2000	87.5400	10904.00	9359.00	1545.00	21	8	23	236	0.0974576271186441	0.459337813316233	0.459337813316233	false	false
18150dbb-f7be-4a09-a0ae-3927e91251e9	2026-09-29 10:16	2026-09-29 10:16	2026-09-29 10:16	CCJ	CCJ261023C00088000	call	88.0000	2026-10-23	3.7400	3.4500	3.7500	87.5400	162973.00	132263.00	29230.00	436	34	438	1	438	0.430943328355657	0.430943328355657	false	false
649cc8c5-6a3c-429d-bcee-8e90d39a6625	2026-09-28 14:05	2026-09-28 14:05	2026-09-28 14:05	CCJ	CCJ261016P00082000	put	82.0000	2026-10-16	1.0700	0.9700	1.1100	87.0000	81936.00	80134.00	1802.00	767	64	769	89	8.64044943820225	0.408522882927817	0.40793673002689	true	false
030d2ab5-8c14-4b0e-89cd-d1eaf2ab989f	2026-09-28 11:54	2026-09-28 11:54	2026-09-28 11:54	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	2.0200	2.0000	2.1000	86.7100	39388.00	403.00	38985.00	195	6	1754	5067	0.346161436747582	0.459429849054049	0.459429849054049	false	false
b06ffa10-67fc-4568-bad3-b2abe1430a41	2026-09-28 09:48	2026-09-28 09:48	2026-09-28 09:48	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	2.2700	2.2000	2.2700	86.3500	23815.00	22695.00	1120.00	105	28	247	5067	0.0487467929741464	0.491876178542991	0.489036189732649	false	false
a4a3f9ab-3df1-4322-8b68-32e28b1d3505	2026-09-25 13:03	2026-09-25 13:03	2026-09-25 13:03	CCJ	CCJ270115P00090000	put	90.0000	2027-01-15	8.8500	8.8500	9.1000	88.4300	38941.00	0.00	38941.00	44	6	828	5153	0.160683097224918	0.443692417441711	0.443177860007806	false	false
e509c474-02ea-47b4-a41c-335ede7661a1	2026-09-25 10:04	2026-09-25 10:04	2026-09-25 10:04	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.9700	1.9400	2.0500	88.0000	72084.00	38960.00	196.00	366	14	457	18544	0.024644089732528	0.405369151461026	0.404066568446577	false	false
b60bf833-c403-46ae-b78b-30bc7d019868	2026-09-24 15:42	2026-09-24 15:42	2026-09-24 15:42	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	2.9700	2.7900	2.9700	88.0000	14847.00	14847.00	0.00	50	18	1224	3985	0.307151819322459	0.485303781868173	0.485303781868173	false	false
3938cca7-31d1-4b8b-b8e9-fab6ebf96859	2026-09-24 12:12	2026-09-24 12:12	2026-09-24 12:12	CCJ	CCJ270319P00080000	put	80.0000	2027-03-19	6.1800	6.0000	6.2000	88.0000	19760.00	9920.00	9840.00	32	7	33	338	0.0976331360946746	0.460209459053648	0.457843624499692	false	false
cf3028ec-c834-401c-bffd-8b8def7beca2	2026-09-24 11:32	2026-09-24 11:32	2026-09-24 11:32	CCJ	CCJ261218C00100000	call	100.0000	2026-12-18	4.2000	3.9500	4.2000	88.4550	174714.00	174714.00	0.00	416	41	432	1351	0.319763138415988	0.470060080690104	0.470060080690104	false	false
b8abbd42-6ca4-4023-82c4-536f71a66ab1	2026-09-24 10:18	2026-09-24 10:18	2026-09-24 10:18	CCJ	CCJ261218C00090000	call	90.0000	2026-12-18	7.8500	7.7500	8.0500	89.1050	39226.00	0.00	39226.00	50	6	52	230	0.226086956521739	0.459106470712376	0.459106470712376	false	false
f87f1d77-f28a-45d9-ab55-c4d2c4417477	2026-09-24 10:12	2026-09-24 10:12	2026-09-24 10:12	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	3.3500	3.2000	3.3500	89.1800	41525.00	41525.00	0.00	124	36	527	3985	0.132245922208281	0.49552204449626	0.49552204449626	false	false
381a6443-d7e7-4328-a5b1-a30a01a962bd	2026-09-24 10:11	2026-09-24 10:11	2026-09-24 10:11	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7800	1.9600	89.1200	32846.00	26414.00	6432.00	182	11	2686	13788	0.194807078619089	0.418538393390451	0.418538393390451	true	false
7d769aca-5bf5-4692-8aec-f0d460628959	2026-09-24 10:03	2026-09-24 10:03	2026-09-24 10:03	CCJ	CCJ261002C00092000	call	92.0000	2026-10-02	1.3300	1.3100	1.7100	89.2101	13682.00	665.00	13017.00	103	9	107	50	2.14	0.450410238702926	0.458173509021398	true	false
1507d4b2-9519-4a4b-bf2f-a875811d1b78	2026-09-23 12:05	2026-09-23 12:04	2026-09-23 12:04	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	0.4800	0.4600	0.5100	92.1600	13658.00	13152.00	506.00	285	5	329	21598	0.0152328919344384	0.501947644133716	0.496705983966733	false	false
4e55bbb6-b0f8-4d6c-9d19-95e8df144d0e	2026-09-23 12:02	2026-09-23 12:01	2026-09-23 12:01	CCJ	CCJ270115P00095000	put	95.0000	2027-01-15	10.5100	10.0500	10.5500	92.2500	21025.00	21025.00	0.00	20	6	23	1259	0.0182684670373312	0.473296789506181	0.465985849628241	false	false
f1c68e18-b971-4b74-ba94-86ffd282a4c9	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	CCJ	CCJ260925C00093000	call	93.0000	2026-09-25	1.9000	1.7000	1.9800	92.7825	18996.00	18809.00	187.00	100	5	103	424	0.242924528301887	0.61037079373195	0.584204634197309	false	false
2fc1ed65-fc83-4fc3-91ff-e09fb438e7c7	2026-09-21 15:37	2026-09-21 15:36	2026-09-21 15:36	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	1.7000	1.6000	2.5700	94.2200	187251.00	50932.00	110975.00	1101	51	3115	2213	1.40759150474469	0.533893359678862	0.505748680073398	true	false
c8405ce8-69a5-4571-85fc-0398416d06db	2026-09-21 15:36	2026-09-21 15:36	2026-09-21 15:36	CCJ	CCJ260925C00092000	call	92.0000	2026-09-25	3.1500	2.3500	3.2500	93.6725	103928.00	97628.00	945.00	330	38	376	40	9.4	0.600006889161362	0.564536504054092	true	false
52ab764f-b45d-4062-abba-ac5209baa4b3	2026-09-18 13:34	2026-09-18 13:34	2026-09-18 13:34	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	0.9900	0.7950	1.0400	93.8750	88664.00	60500.00	28164.00	893	46	995	21248	0.046827936746988	0.513164268433658	0.513164268433658	false	false
1526dbd9-3a84-4267-9bf8-de04d0218c35	2026-09-18 13:32	2026-09-18 13:31	2026-09-18 13:31	CCJ	CCJ260925C00091000	call	91.0000	2026-09-25	2.4400	1.9100	2.5700	91.0300	20701.00	15137.00	5564.00	85	7	92	2	46	0.488947665351781	0.41585803819919	true	false	false
220dd33f-629c-43b9-9750-889e3854a525	2026-09-16 14:59	2026-09-16 14:59	2026-09-16 14:59	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.3500	4.2500	4.3500	90.2850	214445.00	213585.00	430.00	493	23	2035	3138	0.648502230720204	0.470553452834647	0.466928215382399	false	false
5e2ac3fe-f5ed-4b8a-8f89-69ae5354af52	2026-09-15 14:12	2026-09-15 14:11	2026-09-15 14:11	CCJ	CCJ261218C00095000	call	95.0000	2026-12-18	7.7400	7.5000	7.8500	91.3300	10835.00	775.00	9290.00	14	5	27	778	0.0347043701799486	0.481772304995114	0.479068139062106	false	false
5df9a52c-a30e-401d-8cac-f1c7968ce8ce	2026-09-11 14:59	2026-09-11 14:59	2026-09-11 14:59	CCJ	CCJ280121P00055000	put	55.0000	2028-01-21	2.7400	2.6500	2.9500	96.6650	41065.00	5620.00	35445.00	150	10	250	35	7.14285714285714	0.494702889912494	0.485481230803968	false	false
8810a883-42ac-4c13-87e6-fe7e54cb7dad	2026-09-11 14:59	2026-09-11 14:59	2026-09-11 14:59	CCJ	CCJ280121P00055000	put	55.0000	2028-01-21	2.7800	2.6500	2.9600	96.7300	27816.00	5620.00	22196.00	100	6	100	35	2.85714285714286	0.495017384441071	0.494446489202869	false	false
7f7c254f-289e-426b-8293-d611502833c3	2026-09-08 09:49	2026-09-08 09:49	2026-09-08 09:49	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	1.3000	1.0200	1.3900	103.4400	63165.00	2077.00	59399.00	486	61	514	9551	0.0538163543084494	0.523207643759834	0.519041227570037	true	false
4d6815cd-a037-4df7-90c6-89f05677717a	2026-09-08 09:39	2026-09-08 09:38	2026-09-08 09:38	CCJ	CCJ260911C00105000	call	105.0000	2026-09-11	1.3300	1.1100	1.3900	102.4300	31933.00	13179.00	18754.00	240	52	298	441	0.675736961451247	0.654078635738574	0.642442011899163	false	false
5af07fc4-2dd7-4f11-9318-1724f359c161	2026-09-02 09:39	2026-09-02 09:39	2026-09-02 09:39	CCJ	CCJ261016P00080000	put	80.0000	2026-10-16	0.6900	0.5800	0.9400	96.1700	752732.00	0.00	752732.00	10880	5	10880	36206	0.300502679113959	0.449557877041064	0.449557877041064	false	false
6987d0fb-a8a3-4031-b649-6fc55e6f3aa9	2026-08-28 15:43	2026-08-28 15:43	2026-08-28 15:43	CCJ	CCJ280121C00130000	call	130.0000	2028-01-21	16.3500	16.3500	17.3500	100.0300	26161.00	0.00	26161.00	16	6	580	879	0.659840728100114	0.505901837776692	0.505901837776692	false	false
a452e041-edac-4d84-9dbd-1792625d3398	2026-08-28 13:58	2026-08-28 13:57	2026-08-28 13:57	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	1.3400	1.3000	1.4700	100.4550	63707.00	11658.00	52049.00	476	40	765	23388	0.0327090815802976	0.455517180237506	0.451056519988421	true	false
2d4e3a25-ca93-4f39-a88c-2f1ee81c1691	2026-08-28 13:04	2026-08-28 13:04	2026-08-28 13:04	CCJ	CCJ280121C00130000	call	130.0000	2028-01-21	16.5200	16.2500	17.6500	100.3300	34685.00	0.00	33030.00	21	11	261	879	0.296928327645051	0.507898795639227	0.503673101734154	true	false
9c020bca-e70c-458a-87e2-6561e33eb4dd	2026-08-28 11:54	2026-08-28 11:54	2026-08-28 11:54	CCJ	CCJ260918C00107000	call	107.0000	2026-09-18	2.1500	1.8400	2.1600	100.0000	64484.00	64484.00	0.00	300	27	372	121	3.07438016528926	0.464062941096807	0.459396558185458	true	false
9080fb29-c7d9-4f99-8d47-c505723fed0f	2026-08-25 13:53	2026-08-25 13:53	2026-08-25 13:53	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	4.3500	4.1500	4.4000	107.5300	86545.00	85675.00	0.00	199	37	1466	24538	0.0597440704213872	0.484186324613281	0.484186324613281	false	false
75aae5c1-8746-443f-9ea8-ffc0616bd695	2026-08-21 10:05	2026-08-21 10:05	2026-08-21 10:05	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.7500	2.5800	2.7700	101.2550	14017.00	13744.00	273.00	51	13	4638	18395	0.252133731992389	0.520088592692439	0.518078833992549	true	false
b3f5f91c-6b97-4e50-b908-702bfd5c692b	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	4.0700	4.0000	4.3000	100.5400	408220.00	309810.00	98410.00	1002	43	1013	5194	0.195032730073161	0.472209555261937	0.471844106288692	false	false
1b99248c-028e-473f-b029-7d70f94c29e5	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	CCJ	CCJ260925C00110000	call	110.0000	2026-09-25	2.6400	2.6200	2.7400	100.5400	87440.00	64660.00	22780.00	331	26	355	19	18.6842105263158	0.474310956907126	0.474310956907126	false	false
6e1c95c1-30e7-4c57-ba02-6c5e91571b5a	2026-08-20 09:50	2026-08-20 09:50	2026-08-20 09:50	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.5000	2.3100	2.6400	95.7609	59714.00	4250.00	55464.00	239	19	858	3963	0.216502649507949	0.458378221294025	0.457563926915315	false	false
d6ab5004-1040-4292-91d5-0186cf280004	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7400	2.7300	3.3000	96.9300	24947.00	0.00	20306.00	91	6	353	478	0.738493723849372	0.449009832499362	0.447470589600532	false	false
b7c6baf0-ad1a-4936-a7ef-0eb5905aafa8	2026-08-18 11:33	2026-08-18 11:33	2026-08-18 11:33	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4400	2.6800	94.4400	614984.00	41749.00	31235.00	2460	54	2476	101	24.5148514851485	0.433495301146297	0.437334468163908	true	false
4f8a18f2-a597-4f4f-9b36-83848de0e393	2026-08-18 10:08	2026-08-18 10:08	2026-08-18 10:08	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	0.9500	0.9500	1.1100	95.3800	10075.00	0.00	10075.00	106	8	226	18645	0.0121212121212121	0.451656189682859	0.444204646413162	false	false