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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:source = uw_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	expirydate

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	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	40597747289.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:43:03.886437Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
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
cc78dee7-e525-4ea7-a7d9-40de9c61e352	2026-09-21 10:14	2026-09-21 10:14	2026-09-21 10:14	CCJ	CCJ261002P00094000	put	94.0000	2026-10-02	3.9000	3.8500	4.4500	92.4050	17160.00	0.00	17160.00	44	7	64	29	2.20689655172414	0.481082959794615	0.481082959794615	false	false	false	true
15ff1d07-6377-4397-99d8-4586c613f869	2026-09-21 10:14	2026-09-21 10:14	2026-09-21 10:14	CCJ	CCJ261016P00095000	put	95.0000	2026-10-16	5.7500	5.7500	6.1000	92.4050	41975.00	0.00	41975.00	73	15	74	1028	0.0719844357976654	0.459359363058252	0.459359363058252	false	false	false	true
907b429f-a3cc-430a-ac5d-093c5ebb11fa	2026-09-18 15:56	2026-09-18 15:56	2026-09-18 15:56	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6300	1.6000	1.6800	91.0000	47433.00	326.00	37816.00	291	14	2704	10270	0.263291139240506	0.432262388397961	0.432262388397961	false	false	false	true
d3910479-0f4a-40eb-85ce-550505725a48	2026-09-18 15:56	2026-09-18 15:56	2026-09-18 15:56	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.6000	1.6800	91.0000	22518.00	2268.00	20250.00	139	14	2341	10270	0.22794547224927	0.431139748505996	0.430382632988816	false	false	false	true
2f1ecef6-8c43-49e6-964c-13d468344a8d	2026-09-18 15:56	2026-09-18 15:56	2026-09-18 15:56	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.6000	1.6200	91.0000	10530.00	10530.00	0.00	65	5	2200	10270	0.214216163583252	0.434462096049138	0.434462096049138	false	false	false	true
541d2c32-87f4-40e4-98d5-543485c4c59d	2026-09-18 15:47	2026-09-18 15:47	2026-09-18 15:47	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	1.9500	1.8900	2.0600	91.8100	49530.00	49335.00	195.00	254	7	5419	1825	2.96931506849315	0.465608382779188	0.465608382779188	false	false	false	true
52f624f5-9a76-487c-8b10-be9caa42f1f3	2026-09-18 15:42	2026-09-18 15:42	2026-09-18 15:42	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.6000	1.7100	91.6800	19602.00	8748.00	9882.00	121	20	2058	10270	0.200389483933788	0.4325006498932	0.4325006498932	false	false	false	true
41190f3d-7508-4e55-9c27-06ad9b04b885	2026-09-18 15:41	2026-09-18 15:41	2026-09-18 15:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6400	1.6000	1.8300	91.6250	22429.00	21609.00	820.00	137	12	1935	10270	0.188412852969815	0.432110839691357	0.433383102390724	false	false	false	true
e27d0125-6000-4fef-a9f6-3c4a2abb3769	2026-09-18 15:41	2026-09-18 15:41	2026-09-18 15:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.6000	1.6700	91.7200	12960.00	10368.00	2592.00	80	6	1698	10270	0.165335929892892	0.433708292738482	0.433708292738482	true	false	false	true
65cd45b5-ebc2-483a-bf12-99c45a56175b	2026-09-18 15:41	2026-09-18 15:41	2026-09-18 15:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.6000	1.6500	91.7450	13932.00	12312.00	1620.00	86	9	1618	10270	0.157546251217137	0.434462096049138	0.434462096049138	false	false	false	true
0edcf0b5-ba13-4148-bea3-4a10fb316b08	2026-09-18 15:40	2026-09-18 15:40	2026-09-18 15:40	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5400	1.6200	91.8150	12798.00	12798.00	0.00	79	7	1404	10270	0.136708860759494	0.436568786446802	0.436568786446802	false	false	false	true
0a0b4843-5d8b-4923-8a8d-1e042b28d033	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5300	1.6200	91.9050	11016.00	11016.00	0.00	68	5	1321	10270	0.128627069133398	0.439268888441084	0.439268888441084	false	false	false	true
b2dd325d-f973-475a-b936-c1bb53c1ce0c	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5200	1.6800	91.7750	16848.00	16848.00	0.00	104	7	1253	10270	0.122005842259007	0.435365675929702	0.435365675929702	false	false	false	true
1e0e15c9-4c5a-44f1-85c6-e396de5fe19b	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5200	1.6200	91.8250	12474.00	12474.00	0.00	77	8	1119	10270	0.108958130477118	0.436869268265674	0.436869268265674	false	false	false	true
e60b0607-8676-4a57-90ee-84194091a404	2026-09-18 15:39	2026-09-18 15:38	2026-09-18 15:38	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5300	1.7900	91.8000	17334.00	12798.00	4536.00	107	9	1019	10270	0.0992210321324245	0.436117842115828	0.436117842115828	false	false	false	true
c15b81d6-e629-4dba-95b6-92e70b851a3d	2026-09-18 15:38	2026-09-18 15:38	2026-09-18 15:38	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5400	1.7200	91.8100	19926.00	19764.00	162.00	123	12	773	10270	0.0752677702044791	0.436418501237197	0.436418501237197	true	false	false	true
80f6b9e8-c154-41f1-b94a-d36b0d7f3477	2026-09-18 15:38	2026-09-18 15:38	2026-09-18 15:38	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5200	1.6200	91.7600	11340.00	11340.00	0.00	70	6	546	10270	0.0531645569620253	0.434914019935301	0.434914019935301	false	false	false	true
b2d7af85-f9ef-42dc-bb63-51fec5cc65d7	2026-09-18 15:37	2026-09-18 15:37	2026-09-18 15:37	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6700	1.5700	1.7500	91.7300	41583.00	13193.00	26720.00	249	12	346	10270	0.0336903602726388	0.44037962931716	0.44037962931716	false	false	false	true
204f22b7-2352-4bee-9b42-e156aa3e5178	2026-09-18 15:33	2026-09-18 15:33	2026-09-18 15:33	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	3.0000	3.0000	3.6500	92.0900	63600.00	0.00	1200.00	212	56	829	11830	0.0700760777683855	3.26849014473297	3.26849014473297	true	false	false	true
0606f52e-b442-45a9-a782-b9bd286b673a	2026-09-18 15:28	2026-09-18 15:28	2026-09-18 15:28	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.8000	4.5000	4.8500	92.2400	18240.00	6240.00	960.00	38	17	1393	538	2.58921933085502	0.494109887500259	0.494109887500259	false	false	false	true
fd500a68-edf7-4c74-80d5-567ac9ff067e	2026-09-18 15:16	2026-09-18 15:15	2026-09-18 15:15	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.8000	4.8000	4.9500	92.3350	27840.00	0.00	27840.00	58	12	1313	538	2.44052044609665	0.491547375879406	0.491547375879406	false	false	false	true
a3c89d3b-1d22-47e9-b94d-e6b6182d0ec1	2026-09-18 15:16	2026-09-18 15:15	2026-09-18 15:15	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.8000	4.6500	4.9500	92.2700	20160.00	0.00	17280.00	42	17	1355	538	2.5185873605948	0.493300907873124	0.493300907873124	false	false	false	true
dfcda919-cedd-4d78-b7df-1ca5e04e69fc	2026-09-18 15:00	2026-09-18 15:00	2026-09-18 15:00	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	5.0000	5.1500	92.8400	11000.00	0.00	11000.00	22	18	1204	538	2.23791821561338	0.491242677382684	0.491242677382684	false	false	false	true
a7559733-45d1-46ed-a59a-c3a767c29384	2026-09-18 14:54	2026-09-18 14:54	2026-09-18 14:54	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	5.0000	5.1000	92.8100	39000.00	0.00	5500.00	78	15	1160	538	2.15613382899628	0.492063111600552	0.492063111600552	false	false	false	true
607c485a-d0ae-4079-997a-1cf168f9c6fe	2026-09-18 14:36	2026-09-18 14:36	2026-09-18 14:36	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.1500	5.1500	5.3500	93.0000	174070.00	0.00	174070.00	338	18	1082	538	2.01115241635688	0.497104312588235	0.496828659744621	false	false	false	true
61803a28-6173-4cce-8e15-19343fc5f58d	2026-09-18 14:36	2026-09-18 14:35	2026-09-18 14:35	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.1000	5.1000	5.2000	92.8599	43350.00	0.00	43350.00	85	17	732	538	1.36059479553903	0.4973602606525	0.4973602606525	true	false	false	true
d22dc7d1-4b24-4932-9db9-906e8c233722	2026-09-18 14:35	2026-09-18 14:35	2026-09-18 14:35	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0500	5.0500	5.2000	92.7600	17675.00	0.00	17675.00	35	8	637	538	1.18401486988848	0.496767757358045	0.496767757358045	true	false	false	true
b2c789d6-ab97-4fce-98a8-2b46c6c1b17f	2026-09-18 14:33	2026-09-18 14:33	2026-09-18 14:33	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	5.0000	4.6000	5.1000	92.6800	86010.00	63500.00	22005.00	172	53	463	538	0.860594795539034	0.495615540111808	0.495615540111808	true	false	false	true
fe4b329e-8777-47c3-8dff-b10dc0c0dd71	2026-09-18 14:33	2026-09-18 14:33	2026-09-18 14:33	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.9300	4.6000	5.0000	92.5200	72991.00	69526.00	0.00	148	15	290	538	0.539033457249071	0.493271234030009	0.496627684515941	false	false	false	true
057558f7-7371-409d-94e3-b87f945909c6	2026-09-18 14:33	2026-09-18 14:32	2026-09-18 14:32	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	4.7500	4.7500	4.8000	92.1850	12350.00	0.00	12350.00	26	6	105	538	0.195167286245353	0.492208091653939	0.492208091653939	true	false	false	true
9bb5562b-f813-4c0b-acdd-1bb79525736a	2026-09-18 13:48	2026-09-18 13:48	2026-09-18 13:48	CCJ	CCJ270319C00100000	call	100.0000	2027-03-19	10.9600	10.3500	12.5500	93.5200	109580.00	0.00	109580.00	100	16	124	406	0.305418719211823	0.483304120259694	0.483304120259694	false	false	false	true
7e91152a-c768-44b6-a52f-156bd24d4723	2026-09-18 13:37	2026-09-18 13:37	2026-09-18 13:37	CCJ	CCJ261016C00095000	call	95.0000	2026-10-16	5.5500	4.6500	5.8000	95.5100	14430.00	555.00	13875.00	26	5	97	2459	0.0394469296461976	0.48953595518613	0.48953595518613	false	false	false	true
52ab764f-b45d-4062-abba-ac5209baa4b3	2026-09-18 13:34	2026-09-18 13:34	2026-09-18 13:34	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	0.9900	0.7950	1.0400	93.8750	88664.00	60500.00	28164.00	893	46	995	21248	0.046827936746988	0.513164268433658	0.513164268433658	false	false	false	true