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

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	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-09-02T14:46:18.296261Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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