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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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

e05fc410-c2bd-4c57-bba4-7a8cbef7a105	2026-09-15 10:17	2026-09-15 10:17	2026-09-15 10:17	CCJ	CCJ261002C00102000	call	102.0000	2026-10-02	0.9100	0.8900	1.0300	92.2000	23114.00	182.00	22932.00	254	8	259	19	13.6315789473684	0.480851852685394	0.480851852685394	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-15T14:18:51.832385Z"}	2026-09-15	2026-09-15 21:15	2026-09-15 21:15
051fd999-7240-4021-8e2b-cb93957644a3	2026-09-14 15:26	2026-09-14 15:26	2026-09-14 15:26	CCJ	CCJ261016P00080000	put	80.0000	2026-10-16	0.6600	0.6600	0.6700	93.4200	12804.00	0.00	12804.00	194	16	3789	47207	0.0802635202406423	0.449863653059848	0.450051439028129	true	false	false	true
5df34d41-1a18-4435-bb69-9d8dbf9801ed	2026-09-14 11:47	2026-09-14 11:47	2026-09-14 11:47	CCJ	CCJ260925C00100000	call	100.0000	2026-09-25	1.0000	1.0000	1.0900	93.1601	20500.00	0.00	20500.00	205	5	408	179	2.27932960893855	0.499728114028592	0.499728114028592	false	false	false	true
59a4d909-ce4e-4ff7-a1cb-ebb902a6da91	2026-09-14 11:46	2026-09-14 11:46	2026-09-14 11:46	CCJ	CCJ260925C00100000	call	100.0000	2026-09-25	1.0000	1.0000	1.1000	93.1635	10600.00	0.00	10600.00	106	5	181	179	1.01117318435754	0.49957077631241	0.49957077631241	false	false	false	true
4837aa5d-25e6-4e34-bc50-e7d41c8aae83	2026-09-14 10:03	2026-09-14 10:03	2026-09-14 10:03	CCJ	CCJ260925P00085000	put	85.0000	2026-09-25	0.6000	0.4200	0.6000	92.2800	19800.00	19800.00	0.00	330	22	334	1303	0.256331542594014	0.476294535781961	0.476294535781961	false	false	false	true
e8ea771f-6fbb-4517-a8c6-33f16da2cfaf	2026-09-14 09:55	2026-09-14 09:55	2026-09-14 09:55	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.8500	4.0000	92.2680	85200.00	85200.00	0.00	213	7	3006	21	143.142857142857	0.481777383327186	0.481777383327186	false	false	false	true
337e9309-e19c-43fa-ae60-363007332d14	2026-09-14 09:53	2026-09-14 09:53	2026-09-14 09:53	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.8500	4.2500	92.3400	95200.00	20000.00	19200.00	238	28	2788	21	132.761904761905	0.483337816948606	0.483337816948606	false	false	false	true
c04167e7-0acb-4808-a559-760022f65038	2026-09-14 09:48	2026-09-14 09:48	2026-09-14 09:48	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.8500	4.0000	92.5100	27600.00	27600.00	0.00	69	11	2399	21	114.238095238095	0.48700684602153	0.48700684602153	false	false	false	true
3f6a2fcf-394f-4ded-8867-32627f552052	2026-09-14 09:44	2026-09-14 09:43	2026-09-14 09:43	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.8000	4.1250	92.0000	86400.00	86400.00	0.00	216	8	2309	21	109.952380952381	0.477684432341748	0.477684432341748	false	false	false	true
f2c3040b-e11d-421c-8568-84446d18f14e	2026-09-14 09:43	2026-09-14 09:43	2026-09-14 09:43	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.8500	4.0000	92.0000	85600.00	85600.00	0.00	214	26	2093	21	99.6666666666667	0.483337816948606	0.483337816948606	false	false	false	true
3890a1e5-b744-42f9-8473-eba748c9612a	2026-09-14 09:42	2026-09-14 09:42	2026-09-14 09:42	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.9000	4.3000	92.0000	353200.00	271600.00	8000.00	883	64	1813	21	86.3333333333333	0.478884624477212	0.481712280717458	false	false	false	true
06ad8afd-d2b3-4f59-9777-4b1a9c0aa73c	2026-09-14 09:39	2026-09-14 09:39	2026-09-14 09:39	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.9500	4.0000	92.0000	241200.00	29600.00	0.00	603	22	930	21	44.2857142857143	0.486791612183432	0.486791612183432	false	false	false	true
ef3b9664-d939-46b1-a98d-beadc5b2b0ea	2026-09-14 09:39	2026-09-14 09:39	2026-09-14 09:39	CCJ	CCJ261120P00085000	put	85.0000	2026-11-20	4.0000	3.7500	4.0000	92.0000	43200.00	43200.00	0.00	108	12	327	21	15.5714285714286	0.487060642998154	0.487060642998154	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
0cdaec06-056b-4af0-aeda-6576b0a55bc8	2026-08-31 12:25	2026-08-31 12:25	2026-08-31 12:25	CCJ	CCJ261218P00100000	put	100.0000	2026-12-18	10.6500	10.6500	10.9500	97.8900	35145.00	0.00	35145.00	33	9	33	1892	0.0174418604651163	0.475746264633617	0.475746264633617	false	false	false	true
7506495d-94cb-47b7-b9ec-512592b4603c	2026-08-28 15:58	2026-08-28 15:57	2026-08-28 15:57	CCJ	CCJ260918P00100000	put	100.0000	2026-09-18	4.0000	4.0000	4.0500	100.1100	80000.00	0.00	80000.00	200	6	656	4709	0.139307708643024	0.435418028393493	0.435418028393493	false	false	false	true