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:option_symbol = CCJ261016P00085000×sorted by created_at ↑×

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
8e60968b-bd8e-4986-841d-cb5513401f0f	2026-08-20 14:13	2026-08-20 14:13	2026-08-20 14:13	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4000	2.5000	94.2350	72500.00	72500.00	0.00	290	6	408	2581	0.158078264238667	0.440239361986013	0.440239361986013	false	false	false	true
3722e263-a572-4ade-823b-131c799e1586	2026-08-20 14:13	2026-08-20 14:13	2026-08-20 14:13	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4000	2.5300	94.2350	92500.00	89000.00	3500.00	370	6	778	2581	0.301433552886478	0.440239361986013	0.440239361986013	false	false	false	true
4150c2e5-1912-44fa-8a65-b5de64f8c9b9	2026-08-20 14:16	2026-08-20 14:15	2026-08-20 14:15	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4000	2.5800	94.1100	84034.00	82784.00	1250.00	336	19	1114	2581	0.431615652847733	0.437654618490477	0.43852123702627	false	false	false	true
3066d561-2992-48da-ab12-533c7d45af74	2026-08-20 14:16	2026-08-20 14:16	2026-08-20 14:16	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4100	2.5800	94.1300	85750.00	85750.00	0.00	343	6	1457	2581	0.564509879891515	0.438068866491866	0.438068866491866	false	false	false	true
d626c8b1-49cb-42d0-a3b6-4b832aff025f	2026-08-20 14:16	2026-08-20 14:16	2026-08-20 14:16	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	2.5000	2.4300	2.5000	94.1200	75500.00	75500.00	0.00	302	7	1759	2581	0.681518791166215	0.437861775425708	0.437861775425708	false	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
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
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
b2d7af85-f9ef-42dc-bb63-51fec5cc65d7	2026-09-18 15:37	2026-09-18 15:37	2026-09-18 15:37	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6700	1.5700	1.7500	91.7300	41583.00	13193.00	26720.00	249	12	346	10270	0.0336903602726388	0.44037962931716	0.44037962931716	false	false	false	true
80f6b9e8-c154-41f1-b94a-d36b0d7f3477	2026-09-18 15:38	2026-09-18 15:38	2026-09-18 15:38	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5200	1.6200	91.7600	11340.00	11340.00	0.00	70	6	546	10270	0.0531645569620253	0.434914019935301	0.434914019935301	false	false	false	true
c15b81d6-e629-4dba-95b6-92e70b851a3d	2026-09-18 15:38	2026-09-18 15:38	2026-09-18 15:38	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5400	1.7200	91.8100	19926.00	19764.00	162.00	123	12	773	10270	0.0752677702044791	0.436418501237197	0.436418501237197	true	false	false	true
e60b0607-8676-4a57-90ee-84194091a404	2026-09-18 15:39	2026-09-18 15:38	2026-09-18 15:38	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5300	1.7900	91.8000	17334.00	12798.00	4536.00	107	9	1019	10270	0.0992210321324245	0.436117842115828	0.436117842115828	false	false	false	true
1e0e15c9-4c5a-44f1-85c6-e396de5fe19b	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5200	1.6200	91.8250	12474.00	12474.00	0.00	77	8	1119	10270	0.108958130477118	0.436869268265674	0.436869268265674	false	false	false	true
b2dd325d-f973-475a-b936-c1bb53c1ce0c	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5200	1.6800	91.7750	16848.00	16848.00	0.00	104	7	1253	10270	0.122005842259007	0.435365675929702	0.435365675929702	false	false	false	true
0a0b4843-5d8b-4923-8a8d-1e042b28d033	2026-09-18 15:39	2026-09-18 15:39	2026-09-18 15:39	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5300	1.6200	91.9050	11016.00	11016.00	0.00	68	5	1321	10270	0.128627069133398	0.439268888441084	0.439268888441084	false	false	false	true
0edcf0b5-ba13-4148-bea3-4a10fb316b08	2026-09-18 15:40	2026-09-18 15:40	2026-09-18 15:40	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.5400	1.6200	91.8150	12798.00	12798.00	0.00	79	7	1404	10270	0.136708860759494	0.436568786446802	0.436568786446802	false	false	false	true
65cd45b5-ebc2-483a-bf12-99c45a56175b	2026-09-18 15:41	2026-09-18 15:41	2026-09-18 15:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.6000	1.6500	91.7450	13932.00	12312.00	1620.00	86	9	1618	10270	0.157546251217137	0.434462096049138	0.434462096049138	false	false	false	true
e27d0125-6000-4fef-a9f6-3c4a2abb3769	2026-09-18 15:41	2026-09-18 15:41	2026-09-18 15:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.6000	1.6700	91.7200	12960.00	10368.00	2592.00	80	6	1698	10270	0.165335929892892	0.433708292738482	0.433708292738482	true	false	false	true
41190f3d-7508-4e55-9c27-06ad9b04b885	2026-09-18 15:41	2026-09-18 15:41	2026-09-18 15:41	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6400	1.6000	1.8300	91.6250	22429.00	21609.00	820.00	137	12	1935	10270	0.188412852969815	0.432110839691357	0.433383102390724	false	false	false	true
52f624f5-9a76-487c-8b10-be9caa42f1f3	2026-09-18 15:42	2026-09-18 15:42	2026-09-18 15:42	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.6000	1.7100	91.6800	19602.00	8748.00	9882.00	121	20	2058	10270	0.200389483933788	0.4325006498932	0.4325006498932	false	false	false	true
2f1ecef6-8c43-49e6-964c-13d468344a8d	2026-09-18 15:56	2026-09-18 15:56	2026-09-18 15:56	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.6000	1.6200	91.0000	10530.00	10530.00	0.00	65	5	2200	10270	0.214216163583252	0.434462096049138	0.434462096049138	false	false	false	true
d3910479-0f4a-40eb-85ce-550505725a48	2026-09-18 15:56	2026-09-18 15:56	2026-09-18 15:56	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6200	1.6000	1.6800	91.0000	22518.00	2268.00	20250.00	139	14	2341	10270	0.22794547224927	0.431139748505996	0.430382632988816	false	false	false	true
907b429f-a3cc-430a-ac5d-093c5ebb11fa	2026-09-18 15:56	2026-09-18 15:56	2026-09-18 15:56	CCJ	CCJ261016P00085000	put	85.0000	2026-10-16	1.6300	1.6000	1.6800	91.0000	47433.00	326.00	37816.00	291	14	2704	10270	0.263291139240506	0.432262388397961	0.432262388397961	false	false	false	true