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:option_symbol = CCJ261120C00100000×ticker = CCJ×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

4d4ac4f6-db07-4653-946c-9246d8719574	2026-09-11 12:20	2026-09-11 12:20	2026-09-11 12:20	CCJ	CCJ261120C00100000	call	100.0000	2026-11-20	7.4500	7.2500	7.7500	97.1100	312919.00	750.00	312169.00	420	48	423	6	70.5	0.49624977925332	0.499196941541934	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Energy	40610811028.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-11T16:54:27.741510Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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