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×

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

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	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-31T16:39:59.140702Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	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
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
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
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
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