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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active: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	expirydate	price

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	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-21T13:43:10.748747Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
b3f5f91c-6b97-4e50-b908-702bfd5c692b	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	4.0700	4.0000	4.3000	100.5400	408220.00	309810.00	98410.00	1002	43	1013	5194	0.195032730073161	0.472209555261937	0.471844106288692	false	false	false	true	false
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	false
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	false
1b99248c-028e-473f-b029-7d70f94c29e5	2026-08-21 09:41	2026-08-21 09:41	2026-08-21 09:41	CCJ	CCJ260925C00110000	call	110.0000	2026-09-25	2.6400	2.6200	2.7400	100.5400	87440.00	64660.00	22780.00	331	26	355	19	18.6842105263158	0.474310956907126	0.474310956907126	false	false	false	true	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
27539c58-c06c-4169-aa98-3bceddc959a0	2026-08-21 09:50	2026-08-21 09:50	2026-08-21 09:50	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.4500	2.2000	2.5400	101.2300	36237.00	12442.00	12795.00	148	28	1543	18395	0.0838814895351998	0.487501453387239	0.49556018590606	true	false	false	true	false
1f8cd92a-1597-40d3-b6f9-1c43976fd07d	2026-08-21 09:51	2026-08-21 09:51	2026-08-21 09:51	CCJ	CCJ260828C00102000	call	102.0000	2026-08-28	2.6500	1.4800	2.8200	101.5500	16666.00	15905.00	761.00	63	16	72	160	0.45	0.50855499268398	0.484674159782163	true	false	false	true	false
05ba5f6f-ad18-434a-b481-1ed932a9fdab	2026-08-21 09:51	2026-08-21 09:51	2026-08-21 09:51	CCJ	CCJ260828C00104000	call	104.0000	2026-08-28	1.8600	1.3700	2.0100	101.5500	21976.00	14710.00	7266.00	118	16	122	241	0.506224066390041	0.515899005758841	0.511761265210566	true	false	false	true	false
5c858d17-aaf3-447b-944b-070cf97902c0	2026-08-21 09:58	2026-08-21 09:58	2026-08-21 09:58	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.9000	2.6000	3.0500	102.0500	39156.00	35093.00	4063.00	135	22	4582	18395	0.249089426474585	0.513120160435934	0.512506192134915	false	false	false	true	false
75aae5c1-8746-443f-9ea8-ffc0616bd695	2026-08-21 10:05	2026-08-21 10:05	2026-08-21 10:05	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	2.7500	2.5800	2.7700	101.2550	14017.00	13744.00	273.00	51	13	4638	18395	0.252133731992389	0.520088592692439	0.518078833992549	true	false	false	true	false
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	false
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	false
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	false
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	false
d83a85cd-9add-4285-9ac4-9aabee869d8d	2026-08-21 10:32	2026-08-21 10:32	2026-08-21 10:32	CCJ	CCJ270115C00100000	call	100.0000	2027-01-15	13.4000	13.0000	14.7000	100.2800	1340000.00	0.00	1340000.00	1000	2	1004	1257	0.798727128082737	0.497059177477769	0.497059177477769	false	true	true	false	false
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	false
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	false
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	false
e82ceafc-8ee4-4497-b60d-9707be7ee816	2026-08-21 14:07	2026-08-21 14:07	2026-08-21 14:07	CCJ	CCJ280121C00110000	call	110.0000	2028-01-21	21.9600	21.6500	24.1500	100.0000	217380.00	0.00	217380.00	99	6	101	597	0.169179229480737	0.478292618198641	0.5014271276548	false	false	false	true	false
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	false
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	false
c4c3d807-49bb-4e8d-9afa-308a1cfff7d8	2026-08-21 15:54	2026-08-21 15:54	2026-08-21 15:54	CCJ	CCJ260918C00125000	call	125.0000	2026-09-18	0.6400	0.4000	0.7600	102.6200	96000.00	96000.00	0.00	1500	1	1523	1584	0.961489898989899	0.514845313962971	0.514845313962971	false	true	false	true	false
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	false
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	false
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	false
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	false
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	false
eaabece1-94bd-4bdc-934c-c18d012808bd	2026-08-24 10:08	2026-08-24 10:08	2026-08-24 10:08	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	2.2600	2.2000	2.2700	101.4000	11275.00	5650.00	1575.00	50	38	82	11590	0.00707506471095772	0.475946157445127	0.478215266063508	false	false	false	true	false
b8a628a7-02e7-4cb7-929d-91771ed82a56	2026-08-24 10:10	2026-08-24 10:10	2026-08-24 10:10	CCJ	CCJ260918P00095000	put	95.0000	2026-09-18	2.1200	2.0800	2.3400	101.8200	21600.00	4663.00	9957.00	102	93	219	11590	0.0188955996548749	0.470391075888759	0.476173275135884	true	false	false	true	false
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	false
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
1afc9f9c-a096-4873-bd62-f7e3dbdfb27b	2026-08-24 11:21	2026-08-24 11:21	2026-08-24 11:21	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.3400	1.3400	1.4500	101.8650	11256.00	0.00	11256.00	84	7	107	4359	0.0245469144299151	0.477820130775802	0.477820130775802	false	false	false	true	false
c87e750f-3c75-4005-bab1-36329447e44d	2026-08-24 14:53	2026-08-24 14:53	2026-08-24 14:53	CCJ	CCJ261218P00085000	put	85.0000	2026-12-18	3.7000	3.5000	3.7000	102.4450	77329.00	77329.00	0.00	209	30	265	2459	0.107767385115901	0.501557294092495	0.501557294092495	true	false	false	true	false
401afd32-7127-4d11-b6ba-d9285dadbe1b	2026-08-25 09:33	2026-08-25 09:33	2026-08-25 09:33	CCJ	CCJ260904C00108000	call	108.0000	2026-09-04	2.6400	1.4000	2.6400	105.3300	10031.00	10031.00	0.00	38	17	38	70	0.542857142857143	0.537454978793986	0.537454978793986	true	false	false	true	false
99267b42-2290-40cc-b232-0afe6518e8d1	2026-08-25 10:51	2026-08-25 10:51	2026-08-25 10:51	CCJ	CCJ261218C00130000	call	130.0000	2026-12-18	4.9000	4.9000	5.0000	106.4450	93590.00	0.00	29400.00	191	42	202	1709	0.118197776477472	0.499208908343958	0.499208908343958	false	false	false	true	false
21400169-2964-4f3e-87b4-ac6962fd1416	2026-08-25 10:54	2026-08-25 10:54	2026-08-25 10:54	CCJ	CCJ261218C00130000	call	130.0000	2026-12-18	4.9000	4.9000	5.0000	106.5300	10780.00	0.00	10780.00	22	20	224	1709	0.131070801638385	0.49798550136193	0.49798550136193	false	false	false	true	false
ae6d35ea-ebae-4ec4-ad63-d58cb3366f35	2026-08-25 12:09	2026-08-25 12:09	2026-08-25 12:09	CCJ	CCJ261016C00120000	call	120.0000	2026-10-16	3.5500	3.4000	3.6000	106.8150	19170.00	19170.00	0.00	54	6	1457	382	3.81413612565445	0.492551666712391	0.492551666712391	false	false	false	true	false
37421597-91e5-4393-92fc-1df9a69339a3	2026-08-25 12:40	2026-08-25 12:40	2026-08-25 12:40	CCJ	CCJ260918C00100000	call	100.0000	2026-09-18	9.5000	9.2500	9.5000	107.0000	11400.00	11400.00	0.00	12	9	89	8214	0.0108351594838081	0.480197655764021	0.480197655764021	true	false	false	true	false
381dfdad-dd2d-4483-a450-a561daae4410	2026-08-25 12:50	2026-08-25 12:50	2026-08-25 12:50	CCJ	CCJ280121C00130000	call	130.0000	2028-01-21	20.1000	19.2000	20.1000	107.3500	200995.00	200995.00	0.00	100	5	201	779	0.258023106546855	0.504641508638624	0.504221835236321	false	false	false	true	false
163963dc-1663-4d8d-a9b6-2a2866b0e044	2026-08-25 13:26	2026-08-25 13:26	2026-08-25 13:26	CCJ	CCJ261016C00120000	call	120.0000	2026-10-16	3.8500	3.7500	3.8500	107.7000	15015.00	15015.00	0.00	39	6	1550	382	4.05759162303665	0.494005693199483	0.494005693199483	false	false	false	true	false