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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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

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	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	39539584402.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T13:37:11.678086Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
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
924ffb0f-2c83-4c3b-a900-02fee93fbcd4	2026-09-22 13:07	2026-09-22 13:07	2026-09-22 13:07	CCJ	CCJ261120C00105000	call	105.0000	2026-11-20	4.0500	4.0500	4.1500	94.6100	160380.00	0.00	160380.00	396	11	635	252	2.51984126984127	0.501376324223197	0.501376324223197	true	false	false	true
873d229d-69d7-42f2-b4d3-f88c0a038f8e	2026-09-22 12:52	2026-09-22 12:52	2026-09-22 12:52	CCJ	CCJ261120C00120000	call	120.0000	2026-11-20	1.4600	1.3800	1.4600	94.6950	22630.00	22630.00	0.00	155	5	195	1030	0.189320388349515	0.51395838033541	0.51395838033541	false	false	false	true
37875adc-91d2-4486-8fd1-4f3421faa40b	2026-09-22 12:51	2026-09-22 12:51	2026-09-22 12:51	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.7000	5.4000	5.7000	94.6800	28500.00	28500.00	0.00	50	9	369	2693	0.137021908652061	0.50285541233437	0.50285541233437	false	false	false	true
25af0a53-2ca9-4fb1-94f9-9fe6894bd7c8	2026-09-22 11:47	2026-09-22 11:47	2026-09-22 11:47	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	2.5900	2.3900	2.5900	94.5399	61642.00	61642.00	0.00	238	26	603	6318	0.0954415954415954	0.47775557126215	0.47775557126215	false	false	false	true
b72ecb39-28fc-48c1-b8de-3504051a76ee	2026-09-22 11:42	2026-09-22 11:41	2026-09-22 11:41	CCJ	CCJ261120C00105000	call	105.0000	2026-11-20	3.9000	3.9000	4.1500	94.3400	39780.00	0.00	39390.00	102	7	234	252	0.928571428571429	0.497367527398761	0.497367527398761	false	false	false	true
e5e21570-d7da-4a35-9c20-767f4d00e37d	2026-09-22 11:17	2026-09-22 11:17	2026-09-22 11:17	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	1.9600	1.6300	1.9700	94.4900	13745.00	4925.00	0.00	70	7	134	1591	0.0842237586423633	0.642572301815001	0.642572301815001	false	false	false	true
15909c5a-03d8-434c-8c7c-b01d296478ac	2026-09-22 10:49	2026-09-22 10:49	2026-09-22 10:49	CCJ	CCJ261120P00075000	put	75.0000	2026-11-20	0.9600	0.8400	0.9600	93.1400	19776.00	19776.00	0.00	206	17	212	25880	0.00819165378670788	0.476793305074587	0.476793305074587	false	false	false	true
964db860-27d2-4544-b0de-53eea9639b44	2026-09-22 10:23	2026-09-22 10:23	2026-09-22 10:23	CCJ	CCJ261030C00094000	call	94.0000	2026-10-30	5.7000	5.2000	5.9500	93.0650	25650.00	1710.00	23940.00	45	6	45	60	0.75	0.496912108006918	0.496912108006918	false	false	false	true
1e690aa7-a2f3-46ab-b785-d138c4025929	2026-09-22 10:17	2026-09-22 10:17	2026-09-22 10:17	CCJ	CCJ261016C00090000	call	90.0000	2026-10-16	6.2500	6.2500	6.7500	93.4200	87515.00	1890.00	85625.00	140	26	240	530	0.452830188679245	0.445431001217148	0.445431001217148	true	false	false	true
234c9e6c-96c8-40c6-bf8e-b82f6917817e	2026-09-22 10:16	2026-09-22 10:16	2026-09-22 10:16	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	5.0000	5.2500	93.4650	25000.00	0.00	25000.00	50	26	296	2693	0.109914593390271	0.491019972007787	0.491019972007787	false	false	false	true
e6c5ecd3-60a9-4834-8122-49342a1f5fc5	2026-09-22 10:13	2026-09-22 10:13	2026-09-22 10:13	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	2.2100	2.1400	2.2800	93.6200	11050.00	0.00	6630.00	50	6	201	6318	0.0318138651471985	0.469829621879543	0.469829621879543	false	false	false	true
e89b5574-7a6e-4615-9579-19aeb4510dfd	2026-09-22 10:00	2026-09-22 10:00	2026-09-22 10:00	CCJ	CCJ260925C00093000	call	93.0000	2026-09-25	1.7400	1.7400	2.0500	92.0000	12354.00	0.00	12354.00	71	22	423	424	0.997641509433962	0.542883744773527	0.542883744773527	false	false	false	true
d66672dc-bba3-47c5-a3fe-5ad96b021c2c	2026-09-22 09:57	2026-09-22 09:57	2026-09-22 09:57	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.8000	4.6000	5.2500	92.7600	49440.00	480.00	48960.00	103	27	236	2693	0.0876346082435945	0.49715713253547	0.49715713253547	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
e7536794-5aa9-4cff-84dd-5bef274a29db	2026-09-21 15:41	2026-09-21 15:41	2026-09-21 15:41	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	1.7700	1.6500	2.0000	93.9400	13639.00	895.00	12744.00	77	25	3277	2213	1.48079530049706	0.568631485838262	0.568631485838262	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
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
9df503ff-e1b3-4b81-b232-02605672308d	2026-09-21 15:36	2026-09-21 15:36	2026-09-21 15:36	CCJ	CCJ261002C00094000	call	94.0000	2026-10-02	3.1500	2.7800	3.1500	93.6725	14175.00	14175.00	0.00	45	8	48	13	3.69230769230769	0.501542083127918	0.501542083127918	true	false	false	true
9265bcd8-8847-4317-b976-c0f6304fa49c	2026-09-21 15:36	2026-09-21 15:36	2026-09-21 15:36	CCJ	CCJ260925C00094000	call	94.0000	2026-09-25	1.9100	1.7300	1.9800	93.6725	29414.00	13943.00	2865.00	154	18	224	127	1.76377952755906	0.54940805683253	0.523315926660693	true	false	false	true
4a75c2dd-9fb1-4bcc-bff0-1c869151ab06	2026-09-21 15:36	2026-09-21 15:36	2026-09-21 15:36	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	1.4400	1.3400	1.5800	93.7800	118234.00	56126.00	62108.00	821	42	1892	2213	0.854948034342521	0.501946633494684	0.500825697485432	true	false	false	true
26d1a95f-abc7-4c78-990d-8cacbe935d93	2026-09-21 15:36	2026-09-21 15:36	2026-09-21 15:36	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.1500	5.0000	5.1500	93.6725	10300.00	10300.00	0.00	20	5	1412	1592	0.886934673366834	0.490894160750946	0.490894160750946	true	false	false	true
dcde129c-7501-4fad-b298-10cade2fa48f	2026-09-21 14:48	2026-09-21 14:48	2026-09-21 14:48	CCJ	CCJ261016C00090000	call	90.0000	2026-10-16	6.6000	6.5000	6.8500	93.0000	26400.00	20460.00	5940.00	40	7	254	462	0.54978354978355	0.456345217411803	0.456345217411803	false	false	false	true
0ce77100-b1b2-4010-a08e-67530eb0beda	2026-09-21 14:47	2026-09-21 14:46	2026-09-21 14:46	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	1.4200	1.3500	1.5200	93.0000	24830.00	3041.00	21789.00	175	55	1024	2213	0.462720289200181	0.512875107681257	0.520786471932899	true	false	false	true
0101ba7b-fa00-4d75-9455-97b229143910	2026-09-21 14:45	2026-09-21 14:45	2026-09-21 14:45	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	1.4000	1.3700	1.5500	93.5400	22010.00	1402.00	20608.00	157	30	849	2213	0.383642114776322	0.516055076657123	0.513412403913419	false	false	false	true
83a80396-8544-4351-990b-cca054901af9	2026-09-21 14:33	2026-09-21 14:33	2026-09-21 14:33	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	4.8500	5.0500	93.3300	35000.00	500.00	22000.00	70	17	1382	1592	0.868090452261307	0.490456097761369	0.490456097761369	false	false	false	true
dc68af0f-1a92-444d-9003-485b9dbc26e1	2026-09-21 14:02	2026-09-21 14:02	2026-09-21 14:02	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	4.7000	5.0000	93.0000	25000.00	5500.00	0.00	50	19	1310	1592	0.82286432160804	0.492707084546955	0.492707084546955	false	false	false	true
b3aabbec-cf49-444a-8da5-32b160511523	2026-09-21 13:53	2026-09-21 13:52	2026-09-21 13:52	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	5.0000	5.0500	93.2550	12500.00	0.00	500.00	25	18	1260	1592	0.791457286432161	0.492566456083381	0.492566456083381	false	false	false	true
6aae1552-fc19-464b-9fc6-e33b22d87520	2026-09-21 13:51	2026-09-21 13:51	2026-09-21 13:51	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	4.7000	5.0500	93.2050	12500.00	6500.00	500.00	25	19	1235	1592	0.775753768844221	0.493972395237312	0.493972395237312	false	false	false	true
ec00b439-a766-405e-8861-817857ca945e	2026-09-21 12:17	2026-09-21 12:16	2026-09-21 12:16	CCJ	CCJ260925C00095000	call	95.0000	2026-09-25	1.1500	1.0300	1.1500	92.6400	43470.00	43470.00	0.00	378	30	464	2213	0.209670131043832	0.538660052898646	0.538660052898646	false	false	false	true
660da6dd-b893-4e99-851e-207363458ccd	2026-09-21 11:17	2026-09-21 11:17	2026-09-21 11:17	CCJ	CCJ270115C00090000	call	90.0000	2027-01-15	11.8000	11.4500	11.8500	92.7200	28320.00	28320.00	0.00	24	5	36	5896	0.00610583446404342	0.477307069789565	0.477307069789565	false	false	false	true
b38056bd-e523-46ba-bf25-43b93d0bb3ad	2026-09-21 10:18	2026-09-21 10:18	2026-09-21 10:18	CCJ	CCJ261120C00095000	call	95.0000	2026-11-20	6.6000	6.3500	6.9000	92.6600	19800.00	7920.00	11880.00	30	6	53	77	0.688311688311688	0.491389654726731	0.491389654726731	false	false	false	true