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:alert_rule = RepeatedHits×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

17106424-5393-4e06-9454-612630a6a2f3	2026-08-24 10:49	2026-08-24 10:49	2026-08-24 10:49	CCJ	CCJ270115C00120000	call	120.0000	2027-01-15	7.5500	7.4500	7.6000	102.9250	15100.00	10570.00	0.00	20	18	31	2056	0.0150778210116732	0.502907186343794	0.502907186343794	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Energy	40610811028.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-24T14:50:32.665351Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d273f4dc-f667-4451-acd5-e49e882d3d5c	2026-08-24 10:41	2026-08-24 10:41	2026-08-24 10:41	CCJ	CCJ280121C00150000	call	150.0000	2028-01-21	13.8500	13.0500	13.8500	103.6200	22160.00	22160.00	0.00	16	5	27	661	0.0408472012102874	0.508919568710512	0.508919568710512	false	false	false	true
88cb3a3c-c94b-4d9b-96fd-740900e77bf4	2026-08-24 09:30	2026-08-24 09:30	2026-08-24 09:30	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	3.1500	3.1000	3.1500	103.5550	11340.00	11340.00	0.00	36	12	296	24523	0.0120703013497533	0.513284240432761	0.513284240432761	true	false	false	true
d66aa5a4-e069-4876-8764-bacbf3dac136	2026-08-24 09:30	2026-08-24 09:30	2026-08-24 09:30	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	3.0500	2.8900	3.1000	103.3600	21075.00	3080.00	915.00	69	17	197	24523	0.00803327488480202	0.510234660573917	0.515210102583529	false	false	false	true
be4d5059-a48f-47fa-b62a-f76a6423064c	2026-08-24 09:30	2026-08-24 09:30	2026-08-24 09:30	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	3.1000	3.0000	3.1000	103.3600	19530.00	3720.00	0.00	63	15	260	24523	0.0106022917261346	0.515210102583529	0.515210102583529	false	false	false	true
ff78bc02-76db-4366-9d2f-9807b2a721a1	2026-08-24 09:30	2026-08-24 09:30	2026-08-24 09:30	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	3.0000	2.9800	3.0000	103.3600	17700.00	2400.00	0.00	59	17	124	24523	0.00505647759246422	0.505249731461403	0.505249731461403	false	false	false	true
9e2dfae0-d6a3-4ac0-a72d-ede7df9b99f3	2026-08-24 09:30	2026-08-24 09:30	2026-08-24 09:30	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.9900	2.7700	3.1000	103.2850	19142.00	18837.00	305.00	64	16	65	24523	0.00265057293153366	0.506868601143305	0.51286244229771	false	false	false	true
09f26d68-58f2-4a48-a503-8f558100a907	2026-08-21 15:22	2026-08-21 15:22	2026-08-21 15:22	CCJ	CCJ260821C00095000	call	95.0000	2026-08-21	6.7500	6.7500	7.2500	101.7400	12825.00	0.00	12825.00	19	9	705	1027	0.686465433300876	3.46957058576467	3.46957058576467	false	false	false	true
afb79009-27ef-48e4-bb43-17929916439f	2026-08-21 14:39	2026-08-21 14:39	2026-08-21 14:39	CCJ	CCJ270115C00195000	call	195.0000	2027-01-15	0.5500	0.3100	0.5500	101.1000	13750.00	13750.00	0.00	250	8	255	245	1.04081632653061	0.537823929825597	0.537823929825597	false	false	false	true
530c7199-2124-40c1-85f5-0efe214df7ac	2026-08-21 12:28	2026-08-21 12:28	2026-08-21 12:28	CCJ	CCJ260904C00100000	call	100.0000	2026-09-04	4.4000	4.3000	4.4000	100.7050	11000.00	11000.00	0.00	25	12	196	297	0.65993265993266	0.505650603731855	0.505650603731855	true	false	false	true
b6d1fa5b-a910-4d2f-baf3-b99a3932d4e7	2026-08-21 12:06	2026-08-21 12:06	2026-08-21 12:06	CCJ	CCJ261218C00130000	call	130.0000	2026-12-18	3.5500	3.3000	3.5500	100.3200	24850.00	24850.00	0.00	70	9	88	326	0.269938650306748	0.50531555186544	0.50531555186544	false	false	false	true
1b43f748-6bc6-4aa7-97db-50d380cbe242	2026-08-21 11:02	2026-08-21 11:02	2026-08-21 11:02	CCJ	CCJ261218C00110000	call	110.0000	2026-12-18	7.7000	7.6000	8.1000	99.4900	38500.00	5390.00	2310.00	50	17	141	1822	0.0773874862788145	0.495653441775941	0.495653441775941	false	false	false	true
85543125-0cfb-4932-a426-95993e595910	2026-08-21 10:17	2026-08-21 10:17	2026-08-21 10:17	CCJ	CCJ261218C00110000	call	110.0000	2026-12-18	8.1500	8.1000	8.4500	100.6100	20375.00	1630.00	11410.00	25	18	91	1822	0.0499451152579583	0.493728117639931	0.493728117639931	true	false	false	true
72788d37-1c34-4e8d-bb02-a1f1889c1f89	2026-08-21 10:17	2026-08-21 10:17	2026-08-21 10:17	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	2.8500	2.7500	3.1000	100.5850	14250.00	6270.00	3135.00	50	14	19106	20970	0.911111111111111	0.488953184324859	0.488953184324859	false	false	false	true
d77c4729-54d4-46e7-80d4-8deaa4aa2a9d	2026-08-21 10:15	2026-08-21 10:15	2026-08-21 10:15	CCJ	CCJ261218C00110000	call	110.0000	2026-12-18	8.1000	7.9000	8.1000	100.2000	17820.00	1620.00	0.00	22	6	62	1822	0.0340285400658617	0.499593145540979	0.499593145540979	false	false	false	true
db360b61-d325-45e7-8194-039e2b5ffd56	2026-08-21 10:12	2026-08-21 10:12	2026-08-21 10:12	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	2.6800	2.6000	2.8500	101.0900	27603.00	2680.00	1875.00	103	21	19046	20970	0.90824988078207	0.48693384359208	0.48693384359208	true	false	false	true
cd108daf-3780-49bb-b913-0b8b57f62b51	2026-08-21 09:50	2026-08-21 09:50	2026-08-21 09:50	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	8.5000	7.3500	8.6000	101.4239	23795.00	23795.00	0.00	28	9	57	483	0.118012422360248	0.475798817158957	0.472580093037456	false	false	false	true
2f57d7db-3b1d-4ca3-9154-e53284e193b1	2026-08-21 09:49	2026-08-21 09:49	2026-08-21 09:49	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	11.1500	11.0500	11.4000	101.1500	74705.00	0.00	74705.00	67	6	771	1987	0.388022143935581	3.0221912135085	3.0221912135085	false	false	false	true
1443aa06-99e5-4430-a5ed-d344781ff9b0	2026-08-21 09:49	2026-08-21 09:49	2026-08-21 09:49	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	11.1500	11.1500	11.4000	101.1500	111500.00	0.00	111500.00	100	6	704	1987	0.354302969300453	3.02212293310951	3.02212293310951	false	false	false	true
6a877b50-bdac-46e9-ad49-46aa6f6441e3	2026-08-21 09:49	2026-08-21 09:49	2026-08-21 09:49	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	10.9000	10.9000	11.0000	100.8250	107910.00	0.00	33790.00	99	6	604	1987	0.303975842979366	2.30764531780449	2.30764531780449	false	false	false	true
c151f21d-e8f1-4279-9e92-5edfcfae8cfc	2026-08-21 09:49	2026-08-21 09:49	2026-08-21 09:49	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	10.9500	10.9500	11.2000	100.9300	37230.00	0.00	37230.00	34	6	452	1987	0.227478610971314	1.87894615251612	1.87894615251612	false	false	false	true
70494cf4-f604-4e3f-b9ab-10090e30aeaf	2026-08-21 09:49	2026-08-21 09:48	2026-08-21 09:48	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	10.9500	10.9500	11.2000	100.9300	72270.00	0.00	59130.00	66	5	418	1987	0.210367388022144	2.12516712430207	1.87877140815953	false	false	false	true
642e8122-5370-4bda-980b-bf7f15f5b4fe	2026-08-21 09:48	2026-08-21 09:48	2026-08-21 09:48	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	10.8500	10.8500	11.2000	100.8300	71610.00	0.00	71610.00	66	5	318	1987	0.160040261701057	1.86444008293537	1.86444008293537	false	false	false	true
d330ac6c-8187-488c-a337-f1792472fb43	2026-08-21 09:48	2026-08-21 09:48	2026-08-21 09:48	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	10.7500	10.6500	10.9000	100.7100	90300.00	16125.00	12900.00	84	7	252	1987	0.126824358329139	2.05425856400956	2.05425856400956	false	false	false	true
433e2e04-1d36-4c09-aec5-991ab7d54a1d	2026-08-21 09:48	2026-08-21 09:48	2026-08-21 09:48	CCJ	CCJ260821C00090000	call	90.0000	2026-08-21	10.6000	10.6000	11.0500	100.5600	106000.00	0.00	19080.00	100	6	119	1987	0.0598892803220936	2.031030483363	2.031030483363	false	false	false	true
ef781de8-285c-4e6f-bed2-b09f98322bc8	2026-08-21 09:42	2026-08-21 09:41	2026-08-21 09:41	CCJ	CCJ261016P00100000	put	100.0000	2026-10-16	6.7500	6.0000	6.7500	100.5201	77625.00	77625.00	0.00	115	17	117	128	0.9140625	0.467105487855452	0.467105487855452	true	false	false	true
a517f42c-fc7e-47dd-8e64-2057c8c23bcc	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.1000	2.0700	2.1100	100.5250	15330.00	13020.00	2310.00	73	8	1218	18395	0.0662136450122316	0.475037449396623	0.475037449396623	false	false	false	true
878dd73d-5aff-44f7-aa82-7fb0d0ea16a2	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	CCJ	CCJ260904P00109000	put	109.0000	2026-09-04	9.5500	9.5000	9.6000	100.5250	53470.00	27695.00	6675.00	56	13	61	6	10.1666666666667	0.504841210661261	0.504841210661261	false	false	false	true
81ec72d5-5e8e-4879-8165-f954ade61155	2026-08-21 09:40	2026-08-21 09:40	2026-08-21 09:40	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.0100	1.7200	2.0700	100.6310	30397.00	17444.00	12953.00	151	22	1107	18395	0.0601793965751563	0.46652035261784	0.467597667312204	true	false	false	true
30fc7c0e-b7f1-498d-bd76-a04a6d45e586	2026-08-21 09:40	2026-08-21 09:40	2026-08-21 09:40	CCJ	CCJ260918C00100000	call	100.0000	2026-09-18	5.6200	5.0500	5.9000	100.6900	20235.00	17360.00	2875.00	36	9	62	8050	0.00770186335403727	0.460453070099431	0.474068801235272	true	false	false	true
b8304444-454a-4306-8bd1-85625db55661	2026-08-21 09:40	2026-08-21 09:40	2026-08-21 09:40	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.0000	1.7200	2.0250	100.7200	120754.00	113448.00	7306.00	604	50	941	18395	0.0511552052188095	0.464079398618718	0.459584748325682	true	false	false	true
31f1e009-376e-4d0b-8007-a12a8659ebf3	2026-08-21 09:30	2026-08-21 09:30	2026-08-21 09:30	CCJ	CCJ260828C00100000	call	100.0000	2026-08-28	1.6100	1.6100	1.7000	97.6800	24633.00	0.00	17710.00	153	40	158	243	0.650205761316872	0.472626581452062	0.472626581452062	false	false	false	true
d626c8b1-49cb-42d0-a3b6-4b832aff025f	2026-08-20 14:16	2026-08-20 14:16	2026-08-20 14:16	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4300	2.5000	94.1200	75500.00	75500.00	0.00	302	7	1759	2581	0.681518791166215	0.437861775425708	0.437861775425708	false	false	false	true
3066d561-2992-48da-ab12-533c7d45af74	2026-08-20 14:16	2026-08-20 14:16	2026-08-20 14:16	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4100	2.5800	94.1300	85750.00	85750.00	0.00	343	6	1457	2581	0.564509879891515	0.438068866491866	0.438068866491866	false	false	false	true
8e60968b-bd8e-4986-841d-cb5513401f0f	2026-08-20 14:13	2026-08-20 14:13	2026-08-20 14:13	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4000	2.5000	94.2350	72500.00	72500.00	0.00	290	6	408	2581	0.158078264238667	0.440239361986013	0.440239361986013	false	false	false	true
3722e263-a572-4ade-823b-131c799e1586	2026-08-20 14:13	2026-08-20 14:13	2026-08-20 14:13	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4000	2.5300	94.2350	92500.00	89000.00	3500.00	370	6	778	2581	0.301433552886478	0.440239361986013	0.440239361986013	false	false	false	true
9b0e81c0-79fc-4bc9-94fc-cf58772793f8	2026-08-20 13:17	2026-08-20 13:17	2026-08-20 13:17	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	4.6500	4.4500	4.6500	94.8500	16275.00	16275.00	0.00	35	5	157	20929	0.00750155286922452	0.442826035049384	0.442826035049384	false	false	false	true
a3bcf4e1-9fa9-48f7-8807-0dc811dacae1	2026-08-20 10:54	2026-08-20 10:54	2026-08-20 10:54	CCJ	CCJ261218C00100000	call	100.0000	2026-12-18	9.1000	9.1000	9.3500	95.9550	60060.00	0.00	60060.00	66	14	68	1165	0.0583690987124464	0.469851587165426	0.469851587165426	false	false	false	true
960292f9-c3fd-4012-affc-6e5d0952d47c	2026-08-20 09:50	2026-08-20 09:50	2026-08-20 09:50	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.5000	2.5000	2.6100	95.6800	45250.00	0.00	1250.00	181	6	1039	3963	0.262175119858693	0.460093241511084	0.460093241511084	false	false	false	true
7997f4fb-8fd0-4573-8b69-360e1de3d935	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.5000	2.5000	2.6500	95.8200	58250.00	0.00	58250.00	233	6	440	3963	0.111026999747666	0.457125223123071	0.457125223123071	false	false	false	true
42b1ac60-a761-4f59-b2b0-c6adcf2e5dd7	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.5000	2.3100	2.7900	95.9500	50499.00	249.00	50250.00	202	12	205	3963	0.0517284885187989	0.452884124050038	0.453557914150019	false	false	false	true
b91bbdd5-ade5-4d52-bead-49d12c105fab	2026-08-19 15:21	2026-08-19 15:21	2026-08-19 15:21	CCJ	CCJ260918C00095000	call	95.0000	2026-09-18	6.6000	6.4500	6.6000	97.9300	21780.00	21780.00	0.00	33	7	217	2248	0.0965302491103203	0.437583173068998	0.437583173068998	false	false	false	true
74283c9c-9c17-48ae-8dc6-a7482181724f	2026-08-19 14:17	2026-08-19 14:17	2026-08-19 14:17	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8700	96.9450	21725.00	0.00	21725.00	79	5	3821	478	7.99372384937239	0.448687008324504	0.448687008324504	false	false	false	true
deec9bf4-561e-4615-b8ee-6abc72617760	2026-08-19 14:15	2026-08-19 14:15	2026-08-19 14:15	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8400	96.9000	107525.00	0.00	107525.00	391	6	3742	478	7.82845188284519	0.449655440972182	0.449655440972182	false	false	false	true
63828646-309a-4804-b77e-549e12216724	2026-08-19 14:15	2026-08-19 14:15	2026-08-19 14:15	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8400	96.8600	59400.00	0.00	59400.00	216	5	3345	478	6.9979079497908	0.450516170672088	0.450516170672088	false	false	false	true
14a8e1e7-76b6-4309-bc52-e15707db61d7	2026-08-19 14:12	2026-08-19 14:12	2026-08-19 14:12	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.9000	96.9650	17050.00	0.00	17050.00	62	5	3073	478	6.42887029288703	0.448256555201398	0.448256555201398	false	false	false	true
7e261312-88c8-4671-94d1-3869cf527b58	2026-08-19 13:30	2026-08-19 13:30	2026-08-19 13:30	CCJ	CCJ260918C00105000	call	105.0000	2026-09-18	2.1900	2.0900	2.1900	97.0700	26280.00	26280.00	0.00	120	19	261	1588	0.164357682619647	0.444172671864705	0.444172671864705	false	false	false	true
6091d0f8-db8c-486f-85e8-e1d50c188471	2026-08-19 13:12	2026-08-19 13:12	2026-08-19 13:12	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8600	97.0000	105325.00	0.00	105325.00	383	6	2990	478	6.25523012552301	0.447503204155438	0.447503204155438	false	false	false	true
8043c9de-9c76-4d72-b063-42188cc3260e	2026-08-19 13:10	2026-08-19 13:09	2026-08-19 13:09	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8300	96.9656	55275.00	0.00	55275.00	201	6	2607	478	5.45397489539749	0.448243641236783	0.448243641236783	false	false	false	true
0b064a5a-6eb8-498d-88c3-a906a7cd38ec	2026-08-19 13:09	2026-08-19 13:09	2026-08-19 13:09	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.7500	2.7500	2.8400	96.9200	37675.00	0.00	23650.00	137	10	2361	478	4.93933054393305	0.449225041207947	0.449225041207947	false	false	false	true