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 = RepeatedHitsDescendingFill×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

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	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Energy	40610811028.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T14:15:30.654866Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false	true
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	false	true
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	false	true
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	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	false	true
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	false	true
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	false	true
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	false	true
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	false	true
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	false	true
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	false	true
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	false	true
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	false	true
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	false	true
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	false	true
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	false	true
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	false	true
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	false	true
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	true
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	false	true
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	false	true
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	false	true
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	false	true