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:ticker = CCJ×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	price

b2ebcfde-37e8-4a1a-87a2-5f8e1261cbcc	2026-09-14 09:38	2026-09-14 09:38	2026-09-14 09:38	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.5500	4.0000	92.5150	20000.00	20000.00	0.00	50	10	175	21	8.33333333333333	0.487114435383961	0.487114435383961	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	40610811028.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-14T13:38:30.454841Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
34b14d00-6019-4646-b0a0-e95464e54006	2026-09-14 09:37	2026-09-14 09:37	2026-09-14 09:37	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.5500	4.0000	92.6750	25600.00	25600.00	0.00	64	8	117	21	5.57142857142857	0.490547652314724	0.490547652314724	false	false	false	true	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	false	true	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	false	true	false
d65ca670-eddf-4a5a-ab5c-1aa5222e40c3	2026-09-11 13:22	2026-09-11 13:22	2026-09-11 13:22	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	7.4000	7.2000	7.7000	97.1500	41440.00	0.00	41440.00	56	22	479	6	79.8333333333333	0.492118558558356	0.492118558558356	false	false	false	true	false
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	false
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	false
f0ce56f5-06c7-447a-9d4c-b182a9c9e677	2026-09-11 10:30	2026-09-11 10:30	2026-09-11 10:30	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	4.4000	4.4000	4.6000	96.9300	39600.00	0.00	39600.00	90	11	106	848	0.125	0.466054071899998	0.466054071899998	false	false	false	true	false
0bdc51f1-c498-43a5-8c67-047fd11858b2	2026-09-11 09:31	2026-09-11 09:31	2026-09-11 09:31	CCJ	CCJ260911P00097000	put	97.0000	2026-09-11	0.7000	0.3100	0.7200	97.0000	11275.00	11206.00	0.00	161	36	161	182	0.884615384615385	0.84515673628241	0.864442924980231	false	false	false	true	false
33d1446e-8fd3-4b44-b5ca-2734b9f51a02	2026-09-09 14:24	2026-09-09 14:24	2026-09-09 14:24	CCJ	CCJ261009P00090000	put	90.0000	2026-10-09	1.3900	1.2600	1.3900	101.0000	16680.00	16680.00	0.00	120	31	124	14	8.85714285714286	0.477184741761091	0.477184741761091	false	false	false	true	false
07526d39-1a35-4116-9c09-c900b47a2994	2026-09-09 12:47	2026-09-09 12:47	2026-09-09 12:47	CCJ	CCJ261016C00105000	call	105.0000	2026-10-16	5.1500	4.9500	5.2500	101.0000	33990.00	31415.00	2575.00	66	9	293	647	0.452859350850077	0.493823435083246	0.493823435083246	false	false	false	true	false
1377d844-949f-4915-a942-78d75af89a5f	2026-09-09 11:13	2026-09-09 11:13	2026-09-09 11:13	CCJ	CCJ260911C00100000	call	100.0000	2026-09-11	1.5000	1.3100	1.7100	99.6200	13200.00	9000.00	4200.00	88	14	128	736	0.173913043478261	0.567849985424326	0.567849985424326	false	false	false	true	false
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	false
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	false
1458bd06-8a13-4f10-a001-65ff5ba671ad	2026-09-09 10:26	2026-09-09 10:25	2026-09-09 10:25	CCJ	CCJ260911P00101000	put	101.0000	2026-09-11	2.0700	1.8900	2.3100	100.0000	50301.00	0.00	50301.00	243	24	313	616	0.508116883116883	0.555970455351418	0.555970455351418	false	false	false	true	false
e97fb670-df6d-46e7-9ad7-8e48b98e9173	2026-09-08 15:59	2026-09-08 15:59	2026-09-08 15:59	CCJ	CCJ270617P00100000	put	100.0000	2027-06-17	14.6500	14.4500	14.9500	102.0450	14650.00	11720.00	2930.00	10	6	11	128	0.0859375	0.494832520838754	0.494832520838754	false	false	false	true	false
953838c2-6279-4e39-b55c-ca5f45b0f93a	2026-09-08 14:33	2026-09-08 14:32	2026-09-08 14:32	CCJ	CCJ260918C00100000	call	100.0000	2026-09-18	5.6000	5.5500	5.6000	103.6890	22400.00	560.00	0.00	40	18	187	8281	0.022581813790605	0.501483010561906	0.501483010561906	false	false	false	true	false
cc80a0a7-0fa7-4f4e-91ab-097b8de3230f	2026-09-08 10:25	2026-09-08 10:25	2026-09-08 10:25	CCJ	CCJ261016C00120000	call	120.0000	2026-10-16	2.0000	1.8800	2.0000	103.9353	34800.00	34800.00	0.00	174	22	213	947	0.224920802534319	0.50824936364537	0.50824936364537	false	false	false	true	false
8380d0ed-a96e-44b1-85a9-4367dd535041	2026-09-08 10:02	2026-09-08 10:02	2026-09-08 10:02	CCJ	CCJ260918C00102000	call	102.0000	2026-09-18	4.5000	4.1500	4.7000	103.7000	272700.00	233100.00	18900.00	606	56	675	261	2.58620689655172	0.539709591151737	0.519274239550995	true	false	false	true	false
c16b0010-50a6-4630-a6a9-272bd6fa2e5d	2026-09-08 09:53	2026-09-08 09:53	2026-09-08 09:53	CCJ	CCJ260918C00112000	call	112.0000	2026-09-18	1.1000	1.1000	1.1700	103.5350	48840.00	0.00	440.00	444	99	451	1530	0.294771241830065	0.555398025407813	0.555398025407813	true	false	false	true	false
004ec936-f8bb-4695-8319-f55705583d4b	2026-09-08 09:53	2026-09-08 09:53	2026-09-08 09:53	CCJ	CCJ260918C00112000	call	112.0000	2026-09-18	1.1000	1.0900	1.1000	103.4900	19800.00	4950.00	0.00	180	8	631	1530	0.412418300653595	0.557320470874785	0.557320470874785	false	false	false	true	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	false	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	false	true	false
3638c156-f543-403c-b23d-04456dc3a501	2026-09-04 15:58	2026-09-04 15:58	2026-09-04 15:58	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	3.2300	3.1000	3.2500	100.8050	1990003.00	1990003.00	0.00	6161	2	15324	5589	2.74181427804616	0.47166723587977	0.47166723587977	false	true	true	false	false
ded9a344-0f13-4ce7-bb63-411d9614e909	2026-09-04 12:12	2026-09-04 12:12	2026-09-04 12:12	CCJ	CCJ260918C00106000	call	106.0000	2026-09-18	1.6100	1.6100	1.6400	100.7100	16100.00	0.00	8372.00	100	8	934	53	17.622641509434	0.447786851028746	0.447786851028746	false	false	false	true	false
ce6d7d76-72ad-4189-a76f-965df1ce1f51	2026-09-04 12:12	2026-09-04 12:12	2026-09-04 12:12	CCJ	CCJ260918C00106000	call	106.0000	2026-09-18	1.6100	1.5600	1.6600	100.8393	16100.00	3059.00	7728.00	100	6	834	53	15.7358490566038	0.442117143803321	0.442117143803321	false	false	false	true	false
21e9e549-dadb-487d-b5fa-821afc2aeb29	2026-09-04 12:12	2026-09-04 12:12	2026-09-04 12:12	CCJ	CCJ260918C00106000	call	106.0000	2026-09-18	1.6100	1.5800	1.6900	100.8393	16260.00	3059.00	5956.00	101	7	710	53	13.3962264150943	0.442117143803321	0.44066630844596	false	false	false	true	false
7eb52eab-cee8-440e-96d9-f60ce4035a71	2026-09-04 10:15	2026-09-04 10:15	2026-09-04 10:15	CCJ	CCJ260904C00100000	call	100.0000	2026-09-04	1.5000	1.0800	1.5000	101.1000	35250.00	35250.00	0.00	235	12	372	735	0.506122448979592	0.813117142972545	0.813117142972545	true	false	false	true	false
8cb1c1b5-9480-427e-bc07-d939b5bea057	2026-09-04 09:56	2026-09-04 09:56	2026-09-04 09:56	CCJ	CCJ260904C00100000	call	100.0000	2026-09-04	1.2500	1.1000	1.2500	100.8900	11875.00	11875.00	0.00	95	28	116	735	0.157823129251701	0.741204714545691	0.680533810569031	true	false	false	true	false
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	false
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	false
bf4af215-31b9-4f0b-94f9-90b357b4eedc	2026-09-03 14:11	2026-09-03 14:11	2026-09-03 14:11	CCJ	CCJ261016C00095000	call	95.0000	2026-10-16	9.7000	9.0000	9.9000	100.0650	19400.00	3880.00	970.00	20	18	38	1891	0.0200951877313591	0.495149920489246	0.495149920489246	false	false	false	true	false
66335427-be36-4358-a918-b04938a13165	2026-09-03 12:56	2026-09-03 12:56	2026-09-03 12:56	CCJ	CCJ261218C00105000	call	105.0000	2026-12-18	8.7000	8.7000	8.9500	100.3467	36540.00	0.00	36540.00	42	6	94	1220	0.0770491803278689	0.4719275737317	0.4719275737317	false	false	false	true	false
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	false
a294da33-cf72-4883-8c33-3deb585c0792	2026-09-03 09:37	2026-09-03 09:37	2026-09-03 09:37	CCJ	CCJ260904C00100000	call	100.0000	2026-09-04	1.8500	1.8500	2.1800	100.6850	13875.00	0.00	13875.00	75	8	219	919	0.238302502720348	0.704631634108189	0.704631634108189	false	false	false	true	false
c7c13d84-d932-47f5-8d07-66847c438f55	2026-09-03 09:33	2026-09-03 09:33	2026-09-03 09:33	CCJ	CCJ280121C00150000	call	150.0000	2028-01-21	11.5000	10.5500	11.5000	100.0400	11500.00	11500.00	0.00	10	10	10	640	0.015625	0.493442592778648	0.493442592778648	false	false	false	true	false
8a4a727a-664b-4c8c-8ce0-e769e543e1ec	2026-09-03 09:31	2026-09-03 09:31	2026-09-03 09:31	CCJ	CCJ260911C00100000	call	100.0000	2026-09-11	2.3300	1.6200	2.3300	99.0850	57318.00	57318.00	0.00	246	7	254	760	0.334210526315789	0.463857269851513	0.463857269851513	true	false	false	true	false
58e943fc-2d1a-4312-bbd9-d50697297b45	2026-09-02 14:42	2026-09-02 14:42	2026-09-02 14:42	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	4.4000	4.4000	4.5500	95.8500	25520.00	0.00	25520.00	58	8	196	686	0.285714285714286	0.448648585813844	0.448648585813844	false	false	false	true	false
a0f43919-4d6d-46c8-997d-6095f77942ce	2026-09-02 11:30	2026-09-02 11:30	2026-09-02 11:30	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	4.3000	4.2000	4.3500	95.4700	21500.00	21500.00	0.00	50	5	132	686	0.192419825072886	0.453522737349825	0.453522737349825	false	false	false	true	false
ec25fd9c-3bcc-44f3-8a67-3260d3958fe8	2026-09-02 10:28	2026-09-02 10:28	2026-09-02 10:28	CCJ	CCJ261016P00100000	put	100.0000	2026-10-16	7.2000	7.2000	7.4500	97.4690	10080.00	0.00	10080.00	14	8	416	351	1.18518518518519	0.448524838280819	0.448524838280819	true	false	false	true	false
b1b26c03-ec3b-4e3f-a35e-6ed1dd59dbf3	2026-09-02 10:28	2026-09-02 10:28	2026-09-02 10:28	CCJ	CCJ261016P00100000	put	100.0000	2026-10-16	7.2000	7.1000	7.4000	97.5100	50400.00	30240.00	20160.00	70	9	502	351	1.43019943019943	0.450111841587381	0.450111841587381	false	false	false	true	false
ac0a4130-27ec-4ac0-b2b1-89c6b5944ccd	2026-09-02 10:24	2026-09-02 10:24	2026-09-02 10:24	CCJ	CCJ261016P00100000	put	100.0000	2026-10-16	7.2000	7.0500	7.3500	97.5600	117360.00	109440.00	7920.00	163	24	275	351	0.783475783475784	0.452040306073574	0.452040306073574	false	false	false	true	false
087bc806-a377-441d-96f2-12ea24774176	2026-09-02 10:22	2026-09-02 10:22	2026-09-02 10:22	CCJ	CCJ261016C00115000	call	115.0000	2026-10-16	1.5600	1.4200	1.6900	97.8600	17940.00	7020.00	0.00	115	7	116	651	0.178187403993856	0.471320065030159	0.471320065030159	false	false	false	true	false
3037f28e-0250-4064-8556-c80c080962ef	2026-09-02 10:20	2026-09-02 10:20	2026-09-02 10:20	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.3300	2.3300	2.5600	97.7601	170328.00	238.00	170090.00	731	56	746	5478	0.136181087988317	0.455544535304114	0.46539441475005	true	false	false	true	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	false	true	false
15949357-60c5-4907-bb77-b4f4d5017b93	2026-09-01 15:29	2026-09-01 15:29	2026-09-01 15:29	CCJ	CCJ270617P00085000	put	85.0000	2027-06-17	9.2000	8.8500	10.0000	96.5500	230000.00	0.00	230000.00	250	1	250	126	1.98412698412698	0.486931004570565	0.486931004570565	false	true	false	true	true
fc0c6996-0e59-41ed-9198-c0f03de4bb82	2026-09-01 15:06	2026-09-01 15:06	2026-09-01 15:06	CCJ	CCJ260918P00085000	put	85.0000	2026-09-18	0.3400	0.2500	0.3450	96.6500	11526.00	11458.00	34.00	339	43	344	3325	0.103458646616541	0.441442858636838	0.441442858636838	false	false	false	true	false
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	false
5f1f4d98-d420-47e4-85ce-b781c3f73fdf	2026-09-01 10:01	2026-09-01 10:01	2026-09-01 10:01	CCJ	CCJ261002P00096000	put	96.0000	2026-10-02	4.8000	4.7000	5.6500	95.9800	19200.00	0.00	19200.00	40	10	40	1	40	0.443665736944834	0.443665736944834	true	false	false	true	false
27acbe93-f4c6-4ce8-9b1b-19e63dbe76bb	2026-08-31 14:48	2026-08-31 14:48	2026-08-31 14:48	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	0.7000	0.6200	0.7000	97.9500	10920.00	10920.00	0.00	156	10	897	22832	0.0392869656622285	0.459621289977943	0.459621289977943	true	false	false	true	false