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: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

78987379-f438-45ec-9c6d-ddd3c90cca60	2026-08-26 09:48	2026-08-26 09:48	2026-08-26 09:48	CCJ	CCJ261016C00125000	call	125.0000	2026-10-16	3.9000	3.6000	4.0500	111.5000	27300.00	26520.00	780.00	70	22	234	486	0.481481481481481	0.507204930533874	0.506353647432253	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-26T14:00:25.587411Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
3e4dadc1-2cf6-4e8c-a39b-c420eaf45187	2026-08-26 09:48	2026-08-26 09:48	2026-08-26 09:48	CCJ	CCJ261016C00125000	call	125.0000	2026-10-16	3.8500	3.6000	3.8500	111.4500	55055.00	55055.00	0.00	143	23	164	486	0.337448559670782	0.504034890835661	0.504034890835661	false	false	false	true
19e32aed-f447-4ff2-b8f6-d8bce50e938a	2026-08-26 09:48	2026-08-26 09:48	2026-08-26 09:48	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	0.6000	0.5600	0.6000	111.3300	16440.00	14460.00	0.00	274	17	1185	4387	0.270116252564395	0.507228380255656	0.507228380255656	true	false	false	true
e7f965c1-9218-4aa3-956e-a15491e7057e	2026-08-26 09:47	2026-08-26 09:47	2026-08-26 09:47	CCJ	CCJ260918C00115000	call	115.0000	2026-09-18	4.0000	3.9000	4.1500	111.0000	53600.00	51200.00	2400.00	134	20	194	2051	0.0945880058508045	0.50330446520842	0.501952568368993	false	false	false	true
23a46ea6-1b96-4a9f-bf76-57eb18310c69	2026-08-26 09:47	2026-08-26 09:47	2026-08-26 09:47	CCJ	CCJ260918C00120000	call	120.0000	2026-09-18	2.4400	2.4300	2.4600	111.0000	25905.00	12054.00	13851.00	106	12	137	1638	0.0836385836385836	0.504250495988368	0.503174243878212	false	false	false	true
2924fdf3-b757-4121-b962-2462067e67cd	2026-08-26 09:46	2026-08-26 09:46	2026-08-26 09:46	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	0.6000	0.6000	0.7900	110.6950	24060.00	0.00	24060.00	401	6	412	4387	0.093913836334625	0.49947570782833	0.49947570782833	false	false	false	true
b908b061-05a6-4627-9719-f3b244042b78	2026-08-26 09:32	2026-08-26 09:32	2026-08-26 09:32	CCJ	CCJ260918C00100000	call	100.0000	2026-09-18	11.5500	11.2000	12.0000	109.5800	18480.00	17325.00	1155.00	16	16	22	8168	0.00269343780607248	0.500747709122172	0.500747709122172	true	false	false	true
82f6037d-6769-48d1-a82d-5c6ecb511afa	2026-08-25 14:27	2026-08-25 14:27	2026-08-25 14:27	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	4.3000	4.3000	4.4500	107.0000	16340.00	0.00	16340.00	38	8	1676	24538	0.0683022251202217	0.477097782250648	0.477097782250648	false	false	false	true
efc61a37-f520-4e4f-a824-f33e45a4c7ac	2026-08-25 14:20	2026-08-25 14:20	2026-08-25 14:20	CCJ	CCJ280121C00150000	call	150.0000	2028-01-21	15.7500	15.1500	15.8000	107.0000	58275.00	56700.00	1575.00	37	10	235	666	0.352852852852853	0.51270491627208	0.51270491627208	true	false	false	true
170c5860-20bd-4fb7-8fb6-0e5c12e7a1db	2026-08-25 13:55	2026-08-25 13:55	2026-08-25 13:55	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	4.4000	4.3500	4.5000	107.7200	22440.00	0.00	22440.00	51	6	1622	24538	0.0661015567690928	0.480732822493239	0.480732822493239	false	false	false	true
94164d55-7b0f-4760-88da-85e9bff1bb54	2026-08-25 13:53	2026-08-25 13:53	2026-08-25 13:53	CCJ	CCJ260918C00120000	call	120.0000	2026-09-18	1.5400	1.4300	1.5500	107.6300	13859.00	13859.00	0.00	90	5	189	1625	0.116307692307692	0.485322077422645	0.484078156231173	false	false	false	true
9080fb29-c7d9-4f99-8d47-c505723fed0f	2026-08-25 13:53	2026-08-25 13:53	2026-08-25 13:53	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	4.3500	4.1500	4.4000	107.5300	86545.00	85675.00	0.00	199	37	1466	24538	0.0597440704213872	0.484186324613281	0.484186324613281	false	false	false	true
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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