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:alert_rule = RepeatedHitsAscendingFill×ticker = CDE×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

bf247944-0754-4b52-95e0-cb207ca0cd14	2026-08-17 11:25	2026-08-17 11:25	2026-08-17 11:25	CDE	CDE261120C00020000	call	20.0000	2026-11-20	2.4500	2.4500	2.5000	19.4301	156833.00	0.00	156833.00	640	35	664	9388	0.0707285896889646	0.662038493594998	0.662038493594998	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Basic Materials	20435347760.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T15:40:30.458422Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e10c4953-aa1f-4ddb-9928-3473e268ab09	2026-08-18 10:07	2026-08-18 10:07	2026-08-18 10:07	CDE	CDE261218C00025000	call	25.0000	2026-12-18	1.2400	1.1500	1.2500	18.9001	116750.00	115550.00	0.00	938	22	947	1598	0.59261576971214	0.668238518858927	0.681160315049722	false	false	false	true
bfa35f89-5430-4906-9a25-215bfb60cc5f	2026-08-19 14:18	2026-08-19 14:18	2026-08-19 14:18	CDE	CDE260918C00022500	call	22.5000	2026-09-18	0.7500	0.7500	0.8500	20.5200	22620.00	0.00	22620.00	300	7	3376	11123	0.303515238694597	0.618343334178929	0.628394579557988	false	false	false	true
6d9b2a2f-6bda-4f54-8a41-8e83a95ae838	2026-08-21 09:39	2026-08-21 09:39	2026-08-21 09:39	CDE	CDE270115C00020000	call	20.0000	2027-01-15	4.2400	4.2000	4.4000	21.2200	42400.00	0.00	25200.00	100	5	104	18822	0.0055254489427266	0.657251131614725	0.677328136791422	false	false	false	true
2a882715-76db-4473-b559-c2c8ee53e92c	2026-08-21 10:25	2026-08-21 10:24	2026-08-21 10:24	CDE	CDE261120C00020000	call	20.0000	2026-11-20	3.5000	3.5000	3.6000	21.1650	175004.00	0.00	149454.00	500	61	2150	8866	0.242499436047823	0.682743647923687	0.681929490491051	true	false	false	true
e800fa33-700f-4206-965f-46bd3b94fe07	2026-08-21 15:28	2026-08-21 15:27	2026-08-21 15:27	CDE	CDE260821C00020000	call	20.0000	2026-08-21	1.0600	1.0500	1.2000	21.1250	10578.00	0.00	10578.00	100	5	1618	10445	0.154906653901388	6.49824311075741	6.49824311075741	false	false	false	true
95e78753-1d8f-404a-9bab-a8070a626d95	2026-08-21 15:53	2026-08-21 15:53	2026-08-21 15:53	CDE	CDE260828P00021000	put	21.0000	2026-08-28	0.6500	0.6000	0.7500	21.0750	65050.00	13000.00	52050.00	1000	9	1087	89	12.2134831460674	0.593679107874419	0.606307201407534	false	false	false	true
93724010-3764-49e4-a69c-a8932981b602	2026-08-24 09:58	2026-08-24 09:58	2026-08-24 09:58	CDE	CDE280121C00022500	call	22.5000	2028-01-21	6.2000	6.1000	6.3000	20.5650	173602.00	3720.00	130202.00	280	28	426	2627	0.162162162162162	0.675298767682045	0.675650651347443	false	false	false	true
da55ddf1-1213-46af-bc3c-996469ec99d8	2026-08-25 09:38	2026-08-25 09:37	2026-08-25 09:37	CDE	CDE270917C00020000	call	20.0000	2027-09-17	6.3700	5.9000	6.5000	20.7600	63672.00	63672.00	0.00	100	9	166	6223	0.0266752370239434	0.683704148564846	0.683704148564846	false	false	false	true
1df7f6b2-00ae-461b-8a1a-92e4b603e144	2026-08-27 15:51	2026-08-27 15:51	2026-08-27 15:51	CDE	CDE260918C00023500	call	23.5000	2026-09-18	0.8500	0.8500	0.9500	22.2050	84200.00	0.00	84200.00	990	26	1011	102	9.91176470588235	0.619323672448622	0.619323672448622	false	false	false	true
c76194a4-1bc9-4ae5-ae63-bc584980e134	2026-08-28 12:28	2026-08-28 12:28	2026-08-28 12:28	CDE	CDE270917C00020000	call	20.0000	2027-09-17	6.5300	6.2000	7.0000	21.0850	42476.00	0.00	42476.00	65	10	216	6265	0.0344772545889864	0.686863659944182	0.686863659944182	false	false	false	true
beff35dc-949b-4e2e-a3d1-843f2871057f	2026-08-28 13:47	2026-08-28 13:47	2026-08-28 13:47	CDE	CDE270917C00020000	call	20.0000	2027-09-17	6.5300	6.2000	6.9000	21.0700	65290.00	15766.00	42974.00	100	17	317	6265	0.0505985634477255	0.680401866575694	0.680401866575694	false	false	false	true
20d4f1d0-0693-428c-a30d-6a0c199663e8	2026-09-09 10:30	2026-09-09 10:30	2026-09-09 10:30	CDE	CDE261016C00022500	call	22.5000	2026-10-16	1.3200	1.2500	1.3500	21.0000	92528.00	92398.00	0.00	701	7	728	819	0.888888888888889	0.669599136784468	0.665018303653763	false	false	false	true
67dbc64a-fb6a-4746-9c46-e40d9d9df082	2026-09-09 14:22	2026-09-09 14:22	2026-09-09 14:22	CDE	CDE261218C00020000	call	20.0000	2026-12-18	3.6400	3.6000	3.7000	21.1500	59636.00	0.00	59636.00	164	6	248	2876	0.086230876216968	0.681054919959413	0.683475985527088	false	false	false	true
7d21d23b-7c29-4ba9-930a-8200c62b2b73	2026-09-10 09:56	2026-09-10 09:56	2026-09-10 09:56	CDE	CDE270917C00030000	call	30.0000	2027-09-17	3.1800	3.2000	3.4000	20.5100	63598.00	0.00	63598.00	200	6	200	489	0.408997955010225	0.664575601558152	0.673157195294054	false	false	false	true
9d45dd3d-6bfb-48e5-bb4a-c141677fb4cc	2026-09-16 14:07	2026-09-16 14:07	2026-09-16 14:07	CDE	CDE261120C00020000	call	20.0000	2026-11-20	2.0000	1.9000	2.0000	19.4150	24954.00	24954.00	0.00	125	9	819	9155	0.0894593118514473	0.667774803577985	0.668578994396013	false	false	false	true
3f5cd50c-a783-421b-949d-71a32062a93b	2026-09-17 09:42	2026-09-17 09:42	2026-09-17 09:42	CDE	CDE280121C00025000	call	25.0000	2028-01-21	4.6200	4.4000	4.8000	19.5800	92380.00	0.00	78580.00	200	6	200	9300	0.021505376344086	0.654976921332364	0.659438183260967	false	false	false	true
e5132b2c-c3ae-49bf-8088-74c226da9091	2026-09-17 13:43	2026-09-17 13:43	2026-09-17 13:43	CDE	CDE261016C00020000	call	20.0000	2026-10-16	1.4900	1.4500	1.5500	20.1600	44520.00	24420.00	20100.00	299	13	373	596	0.625838926174497	0.606488142095723	0.615435994360153	false	false	false	true