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:option_symbol = CCJ280121C00120000×sector = Energy×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	expiry

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	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-17T16:01:56.961018Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
4037cc68-6d51-4036-acde-94d2f319f5df	2026-09-25 11:45	2026-09-25 11:45	2026-09-25 11:45	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.2000	11.2000	11.9000	88.3600	77280.00	0.00	77280.00	69	6	74	1935	0.0382428940568475	0.465834305850774	0.465834305850774	false	false	false	true
9bec442c-e963-4365-952b-cf6cf8e18685	2026-09-25 12:16	2026-09-25 12:16	2026-09-25 12:16	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.3500	11.3500	11.8500	88.9500	78315.00	0.00	78315.00	69	22	429	1935	0.221705426356589	0.463258064590973	0.463258064590973	false	false	false	true
6433a1b8-649e-468f-81aa-41e0ca5eec84	2026-09-25 12:35	2026-09-25 12:35	2026-09-25 12:35	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.2000	11.2000	11.7000	88.5700	86242.00	0.00	86242.00	77	32	660	1935	0.341085271317829	0.463585360988211	0.463585360988211	false	false	false	true
67bcdf2c-301f-4fd6-8d8d-cfb6659d32ce	2026-09-25 12:49	2026-09-25 12:49	2026-09-25 12:49	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0000	11.0000	11.5000	88.1900	88030.00	2220.00	85810.00	80	21	811	1935	0.419121447028424	0.462628180538183	0.465143827540352	false	false	false	true
c2241b61-3d0b-43fd-ba48-224143534c42	2026-09-25 12:56	2026-09-25 12:55	2026-09-25 12:55	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0000	11.0000	11.4000	88.2100	83615.00	1110.00	82505.00	76	12	887	1935	0.458397932816537	0.462414769570323	0.464929802413643	false	false	false	true
2843a08d-447d-4248-a05b-26171acb0c1c	2026-09-25 13:00	2026-09-25 13:00	2026-09-25 13:00	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	10.9500	10.9500	11.4500	88.2550	27385.00	0.00	27385.00	25	11	958	1935	0.495090439276486	0.460677186955142	0.461934718944696	false	false	false	true
b7d124e8-d0dd-4498-8f62-2fc2edddf544	2026-09-25 13:13	2026-09-25 13:13	2026-09-25 13:13	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.1200	11.1000	11.5000	88.0000	87870.00	7840.00	80030.00	79	19	1107	1935	0.572093023255814	0.462631182043857	0.465137804486365	false	false	false	true
4890e266-cd33-455f-bf5b-b0dde4f8730a	2026-09-25 13:24	2026-09-25 13:23	2026-09-25 13:23	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0600	11.0000	11.4000	88.3100	88495.00	7770.00	80725.00	80	21	1270	1935	0.656330749354005	0.461348223096318	0.463860188543935	false	false	false	true
c9329f8b-2ead-45ce-b37b-ac074133e286	2026-09-25 13:28	2026-09-25 13:28	2026-09-25 13:28	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0000	11.0000	11.4000	88.2400	82500.00	0.00	82500.00	75	14	1345	1935	0.695090439276486	0.462094716754276	0.462094716754276	false	false	false	true
1d9cbd03-c905-4608-baf9-b76ecbb6e11e	2026-09-25 13:35	2026-09-25 13:35	2026-09-25 13:35	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	11.0300	11.0000	11.5000	88.0000	61740.00	1105.00	60635.00	56	24	1427	1935	0.737467700258398	0.462361422134017	0.462361422134017	false	false	false	true
e54e2555-419f-4acc-b39f-fa3bde7d848f	2026-09-25 13:39	2026-09-25 13:39	2026-09-25 13:39	CCJ	CCJ280121C00120000	call	120.0000	2028-01-21	10.9500	10.9500	11.4500	88.0000	139097.00	3315.00	135782.00	127	30	1554	1935	0.803100775193798	0.461902554985101	0.464420682844522	false	false	false	true