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×sector = Energy×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

e54e2555-419f-4acc-b39f-fa3bde7d848f	2026-09-25 13:39	2026-09-25 13:39	2026-09-25 13:39	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	10.9500	10.9500	11.4500	88.0000	139097.00	3315.00	135782.00	127	30	1554	1935	0.803100775193798	0.461902554985101	0.464420682844522	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	38350784122.00	2026-11-04	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T17:41:26.046305Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
1d9cbd03-c905-4608-baf9-b76ecbb6e11e	2026-09-25 13:35	2026-09-25 13:35	2026-09-25 13:35	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0300	11.0000	11.5000	88.0000	61740.00	1105.00	60635.00	56	24	1427	1935	0.737467700258398	0.462361422134017	0.462361422134017	false	false	false
6026f7df-aa18-42c2-993c-ab6850e2202d	2026-09-25 13:32	2026-09-25 13:31	2026-09-25 13:31	CCJ	CCJ270115P00090000	put	90.0000	2027-01-15	8.9000	8.9000	9.2000	88.3150	32040.00	0.00	32040.00	36	13	1146	5153	0.222394721521444	0.443033461215459	0.443033461215459	false	false	false
c9329f8b-2ead-45ce-b37b-ac074133e286	2026-09-25 13:28	2026-09-25 13:28	2026-09-25 13:28	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0000	11.0000	11.4000	88.2400	82500.00	0.00	82500.00	75	14	1345	1935	0.695090439276486	0.462094716754276	0.462094716754276	false	false	false
b3181770-2fa2-49e2-bbdc-cb42b6dafed2	2026-09-25 13:25	2026-09-25 13:25	2026-09-25 13:25	CCJ	CCJ270115P00090000	put	90.0000	2027-01-15	8.9000	8.9000	9.1000	88.2700	52510.00	0.00	52510.00	59	19	1073	5153	0.20822821657287	0.441965721532518	0.441965721532518	false	false	false
4890e266-cd33-455f-bf5b-b0dde4f8730a	2026-09-25 13:24	2026-09-25 13:23	2026-09-25 13:23	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0600	11.0000	11.4000	88.3100	88495.00	7770.00	80725.00	80	21	1270	1935	0.656330749354005	0.461348223096318	0.463860188543935	false	false	false
b7d124e8-d0dd-4498-8f62-2fc2edddf544	2026-09-25 13:13	2026-09-25 13:13	2026-09-25 13:13	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.1200	11.1000	11.5000	88.0000	87870.00	7840.00	80030.00	79	19	1107	1935	0.572093023255814	0.462631182043857	0.465137804486365	false	false	false
a4a3f9ab-3df1-4322-8b68-32e28b1d3505	2026-09-25 13:03	2026-09-25 13:03	2026-09-25 13:03	CCJ	CCJ270115P00090000	put	90.0000	2027-01-15	8.8500	8.8500	9.1000	88.4300	38941.00	0.00	38941.00	44	6	828	5153	0.160683097224918	0.443692417441711	0.443177860007806	false	false	false
2843a08d-447d-4248-a05b-26171acb0c1c	2026-09-25 13:00	2026-09-25 13:00	2026-09-25 13:00	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	10.9500	10.9500	11.4500	88.2550	27385.00	0.00	27385.00	25	11	958	1935	0.495090439276486	0.460677186955142	0.461934718944696	false	false	false
c2241b61-3d0b-43fd-ba48-224143534c42	2026-09-25 12:56	2026-09-25 12:55	2026-09-25 12:55	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0000	11.0000	11.4000	88.2100	83615.00	1110.00	82505.00	76	12	887	1935	0.458397932816537	0.462414769570323	0.464929802413643	false	false	false
67bcdf2c-301f-4fd6-8d8d-cfb6659d32ce	2026-09-25 12:49	2026-09-25 12:49	2026-09-25 12:49	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0000	11.0000	11.5000	88.1900	88030.00	2220.00	85810.00	80	21	811	1935	0.419121447028424	0.462628180538183	0.465143827540352	false	false	false
6433a1b8-649e-468f-81aa-41e0ca5eec84	2026-09-25 12:35	2026-09-25 12:35	2026-09-25 12:35	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.2000	11.2000	11.7000	88.5700	86242.00	0.00	86242.00	77	32	660	1935	0.341085271317829	0.463585360988211	0.463585360988211	false	false	false
9bec442c-e963-4365-952b-cf6cf8e18685	2026-09-25 12:16	2026-09-25 12:16	2026-09-25 12:16	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.3500	11.3500	11.8500	88.9500	78315.00	0.00	78315.00	69	22	429	1935	0.221705426356589	0.463258064590973	0.463258064590973	false	false	false
09fec6e3-151b-49db-8f44-e2a17ca7e032	2026-09-25 12:09	2026-09-25 12:09	2026-09-25 12:09	CCJ	CCJ280121C00125000	call	125.0000	2028-01-21	10.6000	10.1000	10.6000	89.2000	16960.00	16960.00	0.00	16	16	21	445	0.0471910112359551	0.468739124055569	0.468739124055569	false	false	false
26c89369-7c25-4da2-9f6a-a6a0230b6bf0	2026-09-25 11:58	2026-09-25 11:58	2026-09-25 11:58	CCJ	CCJ261218C00100000	call	100.0000	2026-12-18	4.1500	3.9500	4.1500	88.6100	128235.00	128235.00	0.00	309	20	322	1752	0.1837899543379	0.467777818474758	0.466221835299739	false	false	false
4037cc68-6d51-4036-acde-94d2f319f5df	2026-09-25 11:45	2026-09-25 11:45	2026-09-25 11:45	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.2000	11.2000	11.9000	88.3600	77280.00	0.00	77280.00	69	6	74	1935	0.0382428940568475	0.465834305850774	0.465834305850774	false	false	false
4bc67256-19d5-4996-88a3-38bf0a87cdc0	2026-09-25 10:04	2026-09-25 10:04	2026-09-25 10:04	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.9700	1.8900	2.0300	88.0000	50235.00	50235.00	0.00	255	12	1029	18544	0.0554896462467645	0.405578346787245	0.405578346787245	true	false	false
9a24c823-d634-43d6-985a-9eeed48f4f9c	2026-09-25 10:04	2026-09-25 10:04	2026-09-25 10:04	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.9900	1.8800	1.9900	88.0000	12139.00	12139.00	0.00	61	8	540	18544	0.0291199309749784	0.405369151461026	0.405369151461026	false	false	false
e509c474-02ea-47b4-a41c-335ede7661a1	2026-09-25 10:04	2026-09-25 10:04	2026-09-25 10:04	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.9700	1.9400	2.0500	88.0000	72084.00	38960.00	196.00	366	14	457	18544	0.024644089732528	0.405369151461026	0.404066568446577	false	false	false
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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