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:er_time = unknown×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

b7c6baf0-ad1a-4936-a7ef-0eb5905aafa8	2026-08-18 11:33	2026-08-18 11:33	2026-08-18 11:33	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4400	2.6800	94.4400	614984.00	41749.00	31235.00	2460	54	2476	101	24.5148514851485	0.433495301146297	0.437334468163908	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Energy	40610811028.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4f8a18f2-a597-4f4f-9b36-83848de0e393	2026-08-18 10:08	2026-08-18 10:08	2026-08-18 10:08	CCJ	CCJ260918C00110000	call	110.0000	2026-09-18	0.9500	0.9500	1.1100	95.3800	10075.00	0.00	10075.00	106	8	226	18645	0.0121212121212121	0.451656189682859	0.444204646413162	false	false	false	true
6e07bda7-e6d1-4437-b26f-66ca1fdbe795	2026-08-18 10:05	2026-08-18 10:05	2026-08-18 10:05	CCJ	CCJ261218P00080000	put	80.0000	2026-12-18	3.4500	2.9900	3.5000	95.8700	145494.00	145494.00	0.00	422	23	422	1209	0.349048800661704	0.482404605320125	0.484319143763344	false	false	false	true	false
c3512d21-ca42-47de-926e-41735baf2a3b	2026-08-18 10:03	2026-08-18 10:03	2026-08-18 10:03	CCJ	CCJ270115C00100000	call	100.0000	2027-01-15	9.7500	9.7500	11.6500	96.2560	13650.00	0.00	13650.00	14	7	15	1275	0.0117647058823529	0.434659221698439	0.434659221698439	false	false	false	true
d25f9476-e923-410c-86ea-caedaf985f13	2026-08-17 15:31	2026-08-17 15:31	2026-08-17 15:31	CCJ	CCJ270319C00105000	call	105.0000	2027-03-19	12.7500	12.7500	13.9500	98.6002	29325.00	0.00	29325.00	23	5	23	28	0.821428571428571	0.479623898743464	0.479623898743464	false	false	false	true	false
4a9eb8b0-586b-493c-93c8-d4aa5646f8c9	2026-08-17 15:26	2026-08-17 15:26	2026-08-17 15:26	CCJ	CCJ260821C00095000	call	95.0000	2026-08-21	4.5000	4.4000	4.7000	98.8700	76500.00	1800.00	74700.00	170	27	348	1180	0.294915254237288	0.482848097695981	0.482848097695981	false	false	false	true
7679c9d0-6927-4da3-985a-5d156f5c9146	2026-08-17 15:01	2026-08-17 15:01	2026-08-17 15:01	CCJ	CCJ260918P00090000	put	90.0000	2026-09-18	1.6000	1.6000	1.7200	98.8000	11360.00	0.00	11360.00	71	12	314	3598	0.0872707059477487	0.436438511176698	0.436438511176698	false	false	false	true	false
99a863ba-bf24-48b3-8cba-9d936ade891f	2026-08-17 13:20	2026-08-17 13:20	2026-08-17 13:20	CCJ	CCJ260828P00098000	put	98.0000	2026-08-28	2.3400	2.2000	2.3400	99.4050	58734.00	58734.00	0.00	251	9	251	16	15.6875	0.444851841483114	0.444851841483114	false	false	false	true	false
32594aed-7f9b-4416-af7d-d0de6dfe0b1b	2026-08-17 12:14	2026-08-17 12:13	2026-08-17 12:13	CCJ	CCJ260821C00100000	call	100.0000	2026-08-21	2.3000	2.2500	2.3000	100.2450	17000.00	16100.00	900.00	74	6	424	3088	0.137305699481865	0.503251540909064	0.515233162273789	true	false	false	true
1076a050-970c-4e3a-802b-0ba6eaa7d72c	2026-08-17 12:08	2026-08-17 12:08	2026-08-17 12:08	CCJ	CCJ260918P00090000	put	90.0000	2026-09-18	1.3600	1.3600	1.4900	100.2800	16048.00	0.00	16048.00	118	17	230	3598	0.0639244024458032	0.442194423003943	0.442194423003943	false	false	false	true	false
4955a2ec-737a-419e-a4ca-97da5ad205fa	2026-08-17 11:56	2026-08-17 11:56	2026-08-17 11:56	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	19.4500	17.9000	19.4500	100.5800	29175.00	29175.00	0.00	15	5	30	1799	0.0166759310728182	0.502451113442922	0.502451113442922	false	false	false	true
c70addc6-92eb-486f-b013-4e2b9b7e0cad	2026-08-17 11:25	2026-08-17 11:25	2026-08-17 11:25	CCJ	CCJ270115P00100000	put	100.0000	2027-01-15	11.4500	11.0500	11.7000	99.9400	21755.00	1145.00	20610.00	19	5	115	1493	0.0770261219022103	0.48198758634681	0.48198758634681	false	false	false	true