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

fd3ba5c3-195b-4b7a-a53a-98fb8ab018c5	2026-09-03 10:49	2026-09-03 10:49	2026-09-03 10:49	CCJ	CCJ260911C00105000	call	105.0000	2026-09-11	1.1400	1.1000	1.3300	101.1400	11404.00	2070.00	9334.00	100	5	110	200	0.55	0.420045342325261	0.43172493949527	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-03T14:57:35.447301Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
a294da33-cf72-4883-8c33-3deb585c0792	2026-09-03 09:37	2026-09-03 09:37	2026-09-03 09:37	CCJ	CCJ260904C00100000	call	100.0000	2026-09-04	1.8500	1.8500	2.1800	100.6850	13875.00	0.00	13875.00	75	8	219	919	0.238302502720348	0.704631634108189	0.704631634108189	false	false	false	true
c7c13d84-d932-47f5-8d07-66847c438f55	2026-09-03 09:33	2026-09-03 09:33	2026-09-03 09:33	CCJ	CCJ280121C00150000	call	150.0000	2028-01-21	11.5000	10.5500	11.5000	100.0400	11500.00	11500.00	0.00	10	10	10	640	0.015625	0.493442592778648	0.493442592778648	false	false	false	true
8a4a727a-664b-4c8c-8ce0-e769e543e1ec	2026-09-03 09:31	2026-09-03 09:31	2026-09-03 09:31	CCJ	CCJ260911C00100000	call	100.0000	2026-09-11	2.3300	1.6200	2.3300	99.0850	57318.00	57318.00	0.00	246	7	254	760	0.334210526315789	0.463857269851513	0.463857269851513	true	false	false	true
58e943fc-2d1a-4312-bbd9-d50697297b45	2026-09-02 14:42	2026-09-02 14:42	2026-09-02 14:42	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	4.4000	4.4000	4.5500	95.8500	25520.00	0.00	25520.00	58	8	196	686	0.285714285714286	0.448648585813844	0.448648585813844	false	false	false	true
a0f43919-4d6d-46c8-997d-6095f77942ce	2026-09-02 11:30	2026-09-02 11:30	2026-09-02 11:30	CCJ	CCJ261016C00100000	call	100.0000	2026-10-16	4.3000	4.2000	4.3500	95.4700	21500.00	21500.00	0.00	50	5	132	686	0.192419825072886	0.453522737349825	0.453522737349825	false	false	false	true
ec25fd9c-3bcc-44f3-8a67-3260d3958fe8	2026-09-02 10:28	2026-09-02 10:28	2026-09-02 10:28	CCJ	CCJ261016P00100000	put	100.0000	2026-10-16	7.2000	7.2000	7.4500	97.4690	10080.00	0.00	10080.00	14	8	416	351	1.18518518518519	0.448524838280819	0.448524838280819	true	false	false	true
b1b26c03-ec3b-4e3f-a35e-6ed1dd59dbf3	2026-09-02 10:28	2026-09-02 10:28	2026-09-02 10:28	CCJ	CCJ261016P00100000	put	100.0000	2026-10-16	7.2000	7.1000	7.4000	97.5100	50400.00	30240.00	20160.00	70	9	502	351	1.43019943019943	0.450111841587381	0.450111841587381	false	false	false	true
ac0a4130-27ec-4ac0-b2b1-89c6b5944ccd	2026-09-02 10:24	2026-09-02 10:24	2026-09-02 10:24	CCJ	CCJ261016P00100000	put	100.0000	2026-10-16	7.2000	7.0500	7.3500	97.5600	117360.00	109440.00	7920.00	163	24	275	351	0.783475783475784	0.452040306073574	0.452040306073574	false	false	false	true
087bc806-a377-441d-96f2-12ea24774176	2026-09-02 10:22	2026-09-02 10:22	2026-09-02 10:22	CCJ	CCJ261016C00115000	call	115.0000	2026-10-16	1.5600	1.4200	1.6900	97.8600	17940.00	7020.00	0.00	115	7	116	651	0.178187403993856	0.471320065030159	0.471320065030159	false	false	false	true
3037f28e-0250-4064-8556-c80c080962ef	2026-09-02 10:20	2026-09-02 10:20	2026-09-02 10:20	CCJ	CCJ261016C00110000	call	110.0000	2026-10-16	2.3300	2.3300	2.5600	97.7601	170328.00	238.00	170090.00	731	56	746	5478	0.136181087988317	0.455544535304114	0.46539441475005	true	false	false	true
5af07fc4-2dd7-4f11-9318-1724f359c161	2026-09-02 09:39	2026-09-02 09:39	2026-09-02 09:39	CCJ	CCJ261016P00080000	put	80.0000	2026-10-16	0.6900	0.5800	0.9400	96.1700	752732.00	0.00	752732.00	10880	5	10880	36206	0.300502679113959	0.449557877041064	0.449557877041064	false	false	false	true
15949357-60c5-4907-bb77-b4f4d5017b93	2026-09-01 15:29	2026-09-01 15:29	2026-09-01 15:29	CCJ	CCJ270617P00085000	put	85.0000	2027-06-17	9.2000	8.8500	10.0000	96.5500	230000.00	0.00	230000.00	250	1	250	126	1.98412698412698	0.486931004570565	0.486931004570565	false	true	false	true
fc0c6996-0e59-41ed-9198-c0f03de4bb82	2026-09-01 15:06	2026-09-01 15:06	2026-09-01 15:06	CCJ	CCJ260918P00085000	put	85.0000	2026-09-18	0.3400	0.2500	0.3450	96.6500	11526.00	11458.00	34.00	339	43	344	3325	0.103458646616541	0.441442858636838	0.441442858636838	false	false	false	true
2fa45ee3-2c5e-44e0-ad62-8d5f52e53771	2026-09-01 11:54	2026-09-01 11:54	2026-09-01 11:54	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	0.5100	0.4700	0.6500	96.9550	64518.00	564.00	57069.00	1265	60	1933	21812	0.0886209426004034	0.4591065498689	0.4591065498689	true	false	false	true
5f1f4d98-d420-47e4-85ce-b781c3f73fdf	2026-09-01 10:01	2026-09-01 10:01	2026-09-01 10:01	CCJ	CCJ261002P00096000	put	96.0000	2026-10-02	4.8000	4.7000	5.6500	95.9800	19200.00	0.00	19200.00	40	10	40	1	40	0.443665736944834	0.443665736944834	true	false	false	true	false
27acbe93-f4c6-4ce8-9b1b-19e63dbe76bb	2026-08-31 14:48	2026-08-31 14:48	2026-08-31 14:48	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	0.7000	0.6200	0.7000	97.9500	10920.00	10920.00	0.00	156	10	897	22832	0.0392869656622285	0.459621289977943	0.459621289977943	true	false	false	true
0cdaec06-056b-4af0-aeda-6576b0a55bc8	2026-08-31 12:25	2026-08-31 12:25	2026-08-31 12:25	CCJ	CCJ261218P00100000	put	100.0000	2026-12-18	10.6500	10.6500	10.9500	97.8900	35145.00	0.00	35145.00	33	9	33	1892	0.0174418604651163	0.475746264633617	0.475746264633617	false	false	false	true
7506495d-94cb-47b7-b9ec-512592b4603c	2026-08-28 15:58	2026-08-28 15:57	2026-08-28 15:57	CCJ	CCJ260918P00100000	put	100.0000	2026-09-18	4.0000	4.0000	4.0500	100.1100	80000.00	0.00	80000.00	200	6	656	4709	0.139307708643024	0.435418028393493	0.435418028393493	false	false	false	true
63232d6d-a37d-490a-8c0c-50b67868364d	2026-08-28 15:44	2026-08-28 15:43	2026-08-28 15:43	CCJ	CCJ280121C00130000	call	130.0000	2028-01-21	16.4500	16.4500	17.3500	100.1450	47705.00	0.00	47705.00	29	6	614	879	0.698521046643914	0.506628017553873	0.506628017553873	false	false	false	true
6987d0fb-a8a3-4031-b649-6fc55e6f3aa9	2026-08-28 15:43	2026-08-28 15:43	2026-08-28 15:43	CCJ	CCJ280121C00130000	call	130.0000	2028-01-21	16.3500	16.3500	17.3500	100.0300	26161.00	0.00	26161.00	16	6	580	879	0.659840728100114	0.505901837776692	0.505901837776692	false	false	false	true
ece38982-2c80-4cf9-b71a-cedbf68791cb	2026-08-28 15:36	2026-08-28 15:35	2026-08-28 15:35	CCJ	CCJ260904C00100000	call	100.0000	2026-09-04	2.4400	2.3700	2.5300	100.0800	35136.00	244.00	34892.00	144	15	234	160	1.4625	0.427703294746055	0.427703294746055	false	false	false	true
5fd967b5-bd6f-4289-8aaf-cb1b544e78fc	2026-08-28 15:20	2026-08-28 15:20	2026-08-28 15:20	CCJ	CCJ280121C00130000	call	130.0000	2028-01-21	16.6000	16.6000	17.3500	100.3300	16600.00	0.00	16600.00	10	10	555	879	0.631399317406143	0.507898795639227	0.507898795639227	false	false	false	true
6c6d3004-1dda-4c13-b2f5-0a46bda942f3	2026-08-28 15:01	2026-08-28 15:01	2026-08-28 15:01	CCJ	CCJ261218P00095000	put	95.0000	2026-12-18	7.2500	7.2500	7.5000	100.4499	210987.00	0.00	210987.00	291	41	346	1269	0.272655634357762	0.474734151287629	0.476685004839573	false	false	false	true
d44bbc52-fac6-4c10-8cb5-839c9a26969c	2026-08-28 14:44	2026-08-28 14:44	2026-08-28 14:44	CCJ	CCJ260918P00100000	put	100.0000	2026-09-18	4.0000	4.0000	4.1500	100.0250	18800.00	0.00	18800.00	47	6	166	4709	0.0352516457846677	0.431247878233911	0.431247878233911	true	false	false	true
a452e041-edac-4d84-9dbd-1792625d3398	2026-08-28 13:58	2026-08-28 13:57	2026-08-28 13:57	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	1.3400	1.3000	1.4700	100.4550	63707.00	11658.00	52049.00	476	40	765	23388	0.0327090815802976	0.455517180237506	0.451056519988421	true	false	false	true
dafb976f-7493-44ef-ab39-06c72e92ed0a	2026-08-28 13:04	2026-08-28 13:04	2026-08-28 13:04	CCJ	CCJ280121C00130000	call	130.0000	2028-01-21	16.5700	16.5500	17.6500	100.3300	14910.00	1670.00	13240.00	9	9	240	879	0.273037542662116	0.506842445494744	0.510011360957875	false	false	false	true
2d4e3a25-ca93-4f39-a88c-2f1ee81c1691	2026-08-28 13:04	2026-08-28 13:04	2026-08-28 13:04	CCJ	CCJ280121C00130000	call	130.0000	2028-01-21	16.5200	16.2500	17.6500	100.3300	34685.00	0.00	33030.00	21	11	261	879	0.296928327645051	0.507898795639227	0.503673101734154	true	false	false	true
9c020bca-e70c-458a-87e2-6561e33eb4dd	2026-08-28 11:54	2026-08-28 11:54	2026-08-28 11:54	CCJ	CCJ260918C00107000	call	107.0000	2026-09-18	2.1500	1.8400	2.1600	100.0000	64484.00	64484.00	0.00	300	27	372	121	3.07438016528926	0.464062941096807	0.459396558185458	true	false	false	true
49eee1ff-fc4d-4783-8eee-9ba922299f07	2026-08-28 10:55	2026-08-28 10:55	2026-08-28 10:55	CCJ	CCJ260911P00101000	put	101.0000	2026-09-11	3.0000	3.0000	3.4500	101.4800	18000.00	0.00	18000.00	60	9	67	34	1.97058823529412	0.418152378158813	0.418152378158813	true	false	false	true
221c1ef1-4df9-4f41-aede-cb439b69e6a2	2026-08-28 10:53	2026-08-28 10:53	2026-08-28 10:53	CCJ	CCJ261218C00120000	call	120.0000	2026-12-18	5.0000	5.0000	5.2000	101.1600	30000.00	0.00	30000.00	60	10	61	703	0.0867709815078236	0.484564840214935	0.484564840214935	false	false	false	true
afd148fd-aa94-4b3a-a8af-4f2f8acb823b	2026-08-28 10:23	2026-08-28 10:23	2026-08-28 10:23	CCJ	CCJ260918C00095000	call	95.0000	2026-09-18	8.2000	7.9500	8.7500	101.4500	32800.00	13120.00	17220.00	40	7	41	1935	0.0211886304909561	0.42903674168771	0.42903674168771	true	false	false	true
240016ef-b089-48ff-9643-349592572814	2026-08-28 10:13	2026-08-28 10:13	2026-08-28 10:13	CCJ	CCJ260828P00101000	put	101.0000	2026-08-28	0.6200	0.2900	0.8300	101.5650	11579.00	11017.00	252.00	186	31	208	22	9.45454545454546	0.84283685516586	0.8527982587888	true	false	false	true
c63ac38b-c182-447a-b7f4-459ac14ce0f9	2026-08-28 10:12	2026-08-28 10:12	2026-08-28 10:12	CCJ	CCJ261009P00095000	put	95.0000	2026-10-09	2.9900	2.6800	3.3000	101.5800	13767.00	10474.00	3293.00	46	15	66	2	33	0.440288817704048	0.440861668524512	true	false	false	true	false
303c906d-1990-4d10-8783-31e301fe8a7d	2026-08-28 10:10	2026-08-28 10:09	2026-08-28 10:09	CCJ	CCJ261016C00125000	call	125.0000	2026-10-16	1.3600	1.2300	1.4200	102.2680	139672.00	139672.00	0.00	1027	1	1028	1532	0.671018276762402	0.483922445172878	0.483922445172878	false	true	false	true
1cfaaa35-37ff-492b-b6c8-73d217ca900e	2026-08-27 10:56	2026-08-27 10:56	2026-08-27 10:56	CCJ	CCJ270617C00095000	call	95.0000	2027-06-17	25.2200	25.2000	27.4000	105.4900	27742.00	2525.00	25217.00	11	8	12	31	0.387096774193548	0.503555441627636	0.503555441627636	true	false	false	true
f5b9a818-4305-4da0-8610-12ecb9fb8b4e	2026-08-27 10:20	2026-08-27 10:20	2026-08-27 10:20	CCJ	CCJ260828C00107000	call	107.0000	2026-08-28	1.2000	0.9700	1.2700	106.5400	10440.00	1680.00	8760.00	87	6	602	631	0.954041204437401	0.633874269277076	0.633874269277076	true	false	false	true
596fc304-0955-47e5-b600-71380463141f	2026-08-27 10:19	2026-08-27 10:19	2026-08-27 10:19	CCJ	CCJ260828C00107000	call	107.0000	2026-08-28	1.2000	1.0900	1.2800	106.5100	12000.00	2400.00	9600.00	100	5	502	631	0.795562599049128	0.64004721095841	0.64004721095841	false	false	false	true
3dc5f000-f4a3-4764-8a48-babd8fef1c2a	2026-08-27 10:13	2026-08-27 10:13	2026-08-27 10:13	CCJ	CCJ260918C00120000	call	120.0000	2026-09-18	1.1600	1.1600	1.3300	106.4650	10208.00	0.00	10208.00	88	16	94	1750	0.0537142857142857	0.486577651020438	0.486577651020438	true	false	false	true
ff4bfdc2-52c3-43e6-b9c8-b26bfd0de66a	2026-08-27 09:57	2026-08-27 09:57	2026-08-27 09:57	CCJ	CCJ280121C00140000	call	140.0000	2028-01-21	17.9100	16.5500	19.1000	107.4250	358170.00	322750.00	35420.00	200	6	200	416	0.480769230769231	0.510083275954303	0.510083275954303	false	false	false	true
3b15e5b6-b904-4f89-9e84-316a99bb506b	2026-08-26 15:42	2026-08-26 15:42	2026-08-26 15:42	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	4.2500	4.1500	4.2500	108.1100	37825.00	37825.00	0.00	89	6	2150	24377	0.0881978914550601	0.460645021930405	0.460645021930405	false	false	false	true
e7446166-0b45-4ac1-b349-9c749a4726b6	2026-08-26 15:41	2026-08-26 15:41	2026-08-26 15:41	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	4.2500	4.1500	4.2500	108.0450	36125.00	36125.00	0.00	85	5	2061	24377	0.0845469089715716	0.463479655122882	0.463479655122882	false	false	false	true
23b2212e-8510-4b15-acaa-ae903110e3e5	2026-08-26 13:26	2026-08-26 13:26	2026-08-26 13:26	CCJ	CCJ261016C00125000	call	125.0000	2026-10-16	2.5500	2.5100	2.6100	107.5200	39266.00	34170.00	4076.00	154	7	1354	486	2.78600823045267	0.488485678559551	0.485281454558839	false	false	false	true
6b0af1d3-84d6-4517-a75d-4ec55dd13d51	2026-08-26 12:34	2026-08-26 12:34	2026-08-26 12:34	CCJ	CCJ260918C00115000	call	115.0000	2026-09-18	2.5000	2.5000	2.6000	107.5300	37500.00	0.00	37500.00	150	5	484	2051	0.235982447586543	0.480739496485143	0.480739496485143	true	false	false	true
076190aa-0882-4c39-8140-2f51873f7b1b	2026-08-26 12:31	2026-08-26 12:31	2026-08-26 12:31	CCJ	CCJ261016P00090000	put	90.0000	2026-10-16	1.3900	1.3000	1.4400	107.4550	12093.00	11954.00	139.00	87	9	163	556	0.293165467625899	0.477203422865548	0.477203422865548	false	false	false	true
9f3e9e75-78e0-4e15-89ac-8b3a72bfdf42	2026-08-26 11:03	2026-08-26 11:03	2026-08-26 11:03	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	4.0000	3.9500	4.1500	107.3450	40800.00	18400.00	5600.00	102	15	367	24377	0.0150551749600033	0.470158451469162	0.470158451469162	false	false	false	true
122a7978-1bfb-43b2-8e7a-377aa9b2e478	2026-08-26 10:45	2026-08-26 10:45	2026-08-26 10:45	CCJ	CCJ261218C00110000	call	110.0000	2026-12-18	11.6800	11.6500	11.8500	108.3350	19860.00	12870.00	6990.00	17	13	103	1844	0.0558568329718004	0.490031831847239	0.492118378378164	false	false	false	true
bdb98c06-8abd-4d45-b4bc-cb06d1f41605	2026-08-26 10:45	2026-08-26 10:45	2026-08-26 10:45	CCJ	CCJ261218C00110000	call	110.0000	2026-12-18	11.8000	11.6500	11.9500	108.4100	16520.00	15340.00	1180.00	14	7	31	1844	0.0168112798264642	0.494567107162156	0.494567107162156	false	false	false	true
670765c7-e22f-4abf-8622-deb869e4dacd	2026-08-26 10:09	2026-08-26 10:09	2026-08-26 10:09	CCJ	CCJ260828C00110000	call	110.0000	2026-08-28	1.8300	1.8200	2.0200	109.8150	346968.00	1830.00	344589.00	1896	66	2258	1010	2.23564356435644	0.580144153255077	0.58857699230493	false	false	false	true
3d05f82e-c05d-4ff0-bd2b-ae9bfd74105c	2026-08-26 10:04	2026-08-26 10:04	2026-08-26 10:04	CCJ	CCJ260828C00111000	call	111.0000	2026-08-28	1.6000	1.5400	1.9300	110.0400	11040.00	10720.00	320.00	69	6	176	281	0.626334519572954	0.623400213162782	0.623400213162782	false	false	false	true