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: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	strikenumeric	expiry

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	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Energy	39539584402.00	2026-11-04	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T19:43:34.515012Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
83488e47-1277-41b2-b3b8-37111c17606a	2026-09-24 15:37	2026-09-24 15:37	2026-09-24 15:37	CCJ	CCJ261120C00120000	call	120.0000	2026-11-20	0.7500	0.5000	0.7500	88.0000	22500.00	22500.00	0.00	300	14	1032	2032	0.507874015748031	0.53573361608072	0.53573361608072	false	false	false	true
fa898b2e-00fc-4280-89ab-1f9ab3886edf	2026-09-24 14:58	2026-09-24 14:58	2026-09-24 14:58	CCJ	CCJ260925C00091000	call	91.0000	2026-09-25	0.2000	0.2000	0.3000	88.4000	15280.00	0.00	15280.00	764	41	822	67	12.2686567164179	0.537650809488105	0.537650809488105	false	false	false	true
67efae2d-08c3-4bba-b872-fa350a18cbed	2026-09-24 13:01	2026-09-24 13:01	2026-09-24 13:01	CCJ	CCJ270319P00075000	put	75.0000	2027-03-19	4.4100	4.0500	4.5500	89.2250	50715.00	50715.00	0.00	115	2	116	184	0.630434782608696	0.469723163786678	0.469723163786678	false	true	false	true
451f95c2-4c3f-4fa7-8965-7c382e0fb3c3	2026-09-24 13:00	2026-09-24 12:59	2026-09-24 12:59	CCJ	CCJ280121P00070000	put	70.0000	2028-01-21	7.1500	7.1000	7.3000	89.3400	15015.00	14300.00	715.00	21	6	812	403	2.01488833746898	0.46818845126236	0.46818845126236	false	false	false	true
f2b27182-7faa-4330-a627-1f048256899b	2026-09-24 12:50	2026-09-24 12:50	2026-09-24 12:50	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	3.4500	3.2000	3.4500	89.5400	17250.00	17250.00	0.00	50	15	1149	3985	0.288331242158093	0.494098670505194	0.494098670505194	false	false	false	true
0f7dcad5-38da-4bae-93cb-fcdae40a7855	2026-09-24 12:50	2026-09-24 12:49	2026-09-24 12:49	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	3.4000	3.2000	3.4000	89.5400	17000.00	17000.00	0.00	50	9	1099	3985	0.275784190715182	0.490200181547919	0.490200181547919	false	false	false	true
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	false	true
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	false	true
f66ded56-83e2-4e10-8b8f-d99e14b5c8f5	2026-09-24 10:22	2026-09-24 10:22	2026-09-24 10:22	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7500	1.8600	88.9600	18000.00	15120.00	2880.00	100	9	4932	13788	0.357702349869452	0.410927651042477	0.410927651042477	true	false	false	true
ef572128-bc25-4b8f-9037-6746e2ebc51d	2026-09-24 10:22	2026-09-24 10:22	2026-09-24 10:22	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7500	1.8500	88.9350	25920.00	21060.00	4320.00	144	18	4719	13788	0.342254134029591	0.409940077036462	0.409940077036462	true	false	false	true
9ab99bf9-22ab-4e3e-9122-c34df7b46cfb	2026-09-24 10:22	2026-09-24 10:22	2026-09-24 10:22	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7500	1.8000	88.9350	16740.00	16740.00	0.00	93	5	4571	13788	0.33152016246011	0.409940077036462	0.409940077036462	false	false	false	true
6543d8d9-bddd-4cbc-b4ae-fc59fe0ddc4b	2026-09-24 10:21	2026-09-24 10:21	2026-09-24 10:21	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7500	1.8700	89.0100	15120.00	12600.00	2520.00	84	5	4345	13788	0.315129097766173	0.412898659141481	0.412898659141481	false	false	false	true
9b3082ca-46c5-4ef0-8a5f-c1c7e64cf056	2026-09-24 10:21	2026-09-24 10:20	2026-09-24 10:20	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7900	1.8000	89.0000	10620.00	10620.00	0.00	59	5	4206	13788	0.305047867711053	0.412504897082638	0.412504897082638	false	false	false	true
81668d3c-518a-477e-8793-9fa0b2937301	2026-09-24 10:20	2026-09-24 10:20	2026-09-24 10:20	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7700	1.9500	89.1149	26280.00	25200.00	1080.00	146	8	4089	13788	0.296562228024369	0.417016121215348	0.417016121215348	true	false	false	true
9f4b830e-18ed-4ef8-af91-bf8084aa2959	2026-09-24 10:20	2026-09-24 10:19	2026-09-24 10:19	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7500	1.8500	89.0775	45540.00	10620.00	31320.00	253	23	3699	13788	0.268276762402089	0.415550851711901	0.415550851711901	true	false	false	true
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	false	true
c098365d-d421-4e33-bc98-2211c4f44578	2026-09-24 10:16	2026-09-24 10:15	2026-09-24 10:15	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7000	1.8500	89.0800	21600.00	20340.00	1260.00	120	9	3340	13788	0.242239628662605	0.41564889140562	0.41564889140562	false	false	false	true
38cdb932-5b5f-4a32-8b9e-22ceb38a88c2	2026-09-24 10:15	2026-09-24 10:15	2026-09-24 10:15	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.6900	1.8500	89.1000	18000.00	11340.00	0.00	100	18	3218	13788	0.233391354801276	0.41643272430578	0.41643272430578	false	false	false	true
17b92c66-2729-4bc5-9de8-13ed72a6dde1	2026-09-24 10:13	2026-09-24 10:13	2026-09-24 10:13	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7400	1.8000	89.1600	14220.00	14220.00	0.00	79	5	3066	13788	0.22236727589208	0.41877908278945	0.41877908278945	true	false	false	true
e278ba59-c886-4534-a48b-eab10ef3eb5c	2026-09-24 10:12	2026-09-24 10:12	2026-09-24 10:12	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7500	1.9000	89.1600	27737.00	27377.00	360.00	154	7	2979	13788	0.216057441253264	0.419949392452041	0.420103134407521	true	false	false	true
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	false	true
9cb19591-b5ec-4252-9120-81246634f603	2026-09-24 10:12	2026-09-24 10:12	2026-09-24 10:12	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8000	1.7800	1.8000	89.2200	10800.00	10800.00	0.00	60	5	2796	13788	0.202785030461271	0.421117804696029	0.421117804696029	false	false	false	true
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	false	true
d4e896bb-1474-450d-9a27-d9a643a37d27	2026-09-24 10:11	2026-09-24 10:11	2026-09-24 10:11	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.8500	1.7900	1.8500	89.1000	11470.00	11470.00	0.00	62	6	2422	13788	0.175659994197853	0.423033279953437	0.423033279953437	false	false	false	true
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	false	true
2ce13927-9b28-418d-b069-dd6e7e8a8ee3	2026-09-24 09:41	2026-09-24 09:41	2026-09-24 09:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6100	1.5900	1.6900	90.0300	11592.00	9660.00	1932.00	72	5	2068	13788	0.149985494633014	0.426036664997892	0.426036664997892	true	false	false	true
08b76fcf-669d-438a-b593-0986e5c7b06b	2026-09-24 09:41	2026-09-24 09:41	2026-09-24 09:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.5700	1.6700	90.0300	31231.00	23711.00	7520.00	195	14	1881	13788	0.136422976501305	0.424657308638253	0.426036664997892	true	false	false	true
e8c0efa8-1e71-4491-a8b3-605ba1cdc3de	2026-09-24 09:41	2026-09-24 09:41	2026-09-24 09:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.4400	1.7900	89.9900	48086.00	6082.00	42004.00	300	22	1686	13788	0.122280243690165	0.438812548810411	0.423190519695039	true	false	false	true
54abc708-2d3c-4dfc-9aed-546414d69e72	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.5200	1.6000	90.2000	18080.00	18080.00	0.00	113	7	1282	13788	0.0929794023788802	0.430859688274142	0.430859688274142	false	false	false	true
d6854a42-cd0e-4bbb-8aac-617e6e50fc02	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6500	1.6000	1.7100	89.9500	12375.00	9735.00	2640.00	75	12	967	13788	0.0701334493762692	0.428588399716794	0.428588399716794	true	false	false	true
7a8e5018-2a65-4445-bc50-0f74ed36364f	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6500	1.5000	1.6600	90.0700	15652.00	15652.00	0.00	95	10	831	13788	0.0602697998259356	0.431636015952358	0.434384871415288	false	false	false	true
7fbb3e27-d5e0-435c-981d-2cafa072835a	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.5000	1.6400	90.3600	17600.00	16000.00	640.00	110	16	705	13788	0.0511314186248912	0.436651680858952	0.436651680858952	true	false	false	true
b8c56a26-0000-4a02-a900-e91fb02abaf3	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.5000	1.6000	90.2650	18080.00	18080.00	0.00	113	7	595	13788	0.0431534667827096	0.433217938228747	0.433217938228747	false	false	false	true
ee8f134a-fb34-42e1-a965-84222b7abf69	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.4900	1.6000	90.4699	10080.00	10080.00	0.00	63	5	481	13788	0.0348854076008123	0.440605117889087	0.440605117889087	false	false	false	true
9f8b0f52-4c63-497a-8d93-9b8199d7affd	2026-09-24 09:34	2026-09-24 09:34	2026-09-24 09:34	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.4900	1.6000	90.4699	10240.00	10240.00	0.00	64	8	418	13788	0.0303162170002901	0.440605117889087	0.440605117889087	false	false	false	true
67ffa7e0-af93-479c-ac17-24e6f685add4	2026-09-24 09:33	2026-09-24 09:33	2026-09-24 09:33	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6000	1.4900	1.6800	90.4699	18575.00	12174.00	6081.00	116	24	353	13788	0.0256019727299101	0.440605117889087	0.439207715958662	true	false	false	true
c1c05817-0fda-4406-af37-b8c5e185058f	2026-09-23 15:42	2026-09-23 15:42	2026-09-23 15:42	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.0000	4.0000	4.1000	91.3200	10400.00	0.00	10400.00	26	12	873	3093	0.282250242483026	0.484261555229801	0.484261555229801	false	false	false	true
3b411c5e-d2f0-4d11-9bdc-cee252661c49	2026-09-23 15:19	2026-09-23 15:19	2026-09-23 15:19	CCJ	CCJ280121P00095000	put	95.0000	2028-01-21	18.5000	18.2500	18.9000	91.4201	12950.00	5550.00	5550.00	7	6	246	328	0.75	0.477146618984504	0.477146618984504	true	false	false	true
848e6d45-7554-4d0b-86dc-ffd7844ec824	2026-09-23 14:23	2026-09-23 14:23	2026-09-23 14:23	CCJ	CCJ270617P00080000	put	80.0000	2027-06-17	7.3500	7.3500	7.6500	91.0000	26460.00	0.00	26460.00	36	10	160	124	1.29032258064516	0.463363369210051	0.463363369210051	false	false	false	true
3d76ff48-5465-4520-8329-55bdfe591a63	2026-09-23 14:22	2026-09-23 14:22	2026-09-23 14:22	CCJ	CCJ270617P00080000	put	80.0000	2027-06-17	7.4000	7.4000	7.4500	91.0000	11840.00	0.00	11840.00	16	7	34	124	0.274193548387097	0.464888821567086	0.464888821567086	false	false	false	true
ddac5961-1c8f-4dd1-8efe-b6ac78636248	2026-09-23 12:27	2026-09-23 12:27	2026-09-23 12:27	CCJ	CCJ261016P00090000	put	90.0000	2026-10-16	2.9000	2.8300	2.9700	92.0900	13050.00	0.00	12760.00	45	6	1286	3014	0.426675514266755	0.433994800933427	0.433994800933427	false	false	false	true
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	false	true
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	false	true
c7596626-cab7-4104-9f7d-66fe019e3c37	2026-09-23 11:47	2026-09-23 11:47	2026-09-23 11:47	CCJ	CCJ260925C00094000	call	94.0000	2026-09-25	0.9100	0.9100	1.1300	92.0000	16745.00	0.00	16745.00	184	39	247	238	1.03781512605042	0.545202112427417	0.551552083868532	false	false	false	true
9464f835-0443-4ca0-8df9-d35039959c93	2026-09-23 11:39	2026-09-23 11:39	2026-09-23 11:39	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.5000	4.5000	4.6500	92.4450	13500.00	0.00	13500.00	30	13	321	3093	0.103782735208535	0.489468861918442	0.489468861918442	false	false	false	true
0e8eb1ec-796d-4cfd-9be3-f3ad00c25941	2026-09-23 11:06	2026-09-23 11:06	2026-09-23 11:06	CCJ	CCJ260925C00093000	call	93.0000	2026-09-25	1.2700	1.2700	1.5500	92.3950	11938.00	0.00	11938.00	94	21	106	463	0.228941684665227	0.56442613971757	0.56442613971757	false	false	false	true
f2e9a8d5-408e-49ff-a750-d5a063c576b2	2026-09-23 10:31	2026-09-23 10:31	2026-09-23 10:31	CCJ	CCJ261009C00094000	call	94.0000	2026-10-09	2.7800	2.7800	2.9600	92.2350	16125.00	279.00	15846.00	58	19	58	74	0.783783783783784	0.45353700645146	0.454846639711527	true	false	false	true
fd847af3-7005-4b48-b996-803145f6a5f5	2026-09-22 14:11	2026-09-22 14:10	2026-09-22 14:10	CCJ	CCJ261016P00092000	put	92.0000	2026-10-16	2.9300	2.7200	2.9300	95.0500	45122.00	45122.00	0.00	154	29	154	11	14	0.458645877412527	0.458645877412527	false	false	false	true
2d2394fb-10c0-4884-a302-7b64ce8be371	2026-09-22 13:57	2026-09-22 13:57	2026-09-22 13:57	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.8000	5.4000	5.8000	94.8200	14500.00	14500.00	0.00	25	7	394	2693	0.146305235796509	0.505334879430964	0.505334879430964	false	false	false	true