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 = CDE×

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

f857b62e-60c0-4753-b32a-e239416539bc	2026-09-03 13:10	2026-09-03 13:10	2026-09-03 13:10	CDE	CDE260904C00021500	call	21.5000	2026-09-04	0.4500	0.4500	0.7000	21.7050	22500.00	0.00	22500.00	500	8	1605	783	2.04980842911877	0.745517319124219	0.745517319124219	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Basic Materials	20435347760.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T17:30:37.600118Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
62910f15-9f36-4b0b-8a52-b378387bf1e7	2026-09-02 15:57	2026-09-02 15:57	2026-09-02 15:57	CDE	CDE261218C00022500	call	22.5000	2026-12-18	2.7000	2.7000	2.8500	21.4350	13500.00	0.00	13500.00	50	10	59	2363	0.0249682606855692	0.657703552724826	0.657703552724826	false	false	false	true	false
f8ce7265-6c63-46ed-98a9-0888a305b829	2026-09-02 15:49	2026-09-02 15:49	2026-09-02 15:49	CDE	CDE261120C00020000	call	20.0000	2026-11-20	3.4000	3.4000	3.5000	21.3900	113560.00	0.00	113560.00	334	11	397	8295	0.0478601567209162	0.668277935969731	0.668277935969731	false	false	false	true	false
bf96d7d0-10e2-4f81-be35-b92b58a83499	2026-09-02 14:22	2026-09-02 14:21	2026-09-02 14:21	CDE	CDE260904C00020500	call	20.5000	2026-09-04	1.0600	0.9000	1.0500	21.3615	36937.00	36937.00	0.00	350	5	351	645	0.544186046511628	0.834351283765644	0.813972734100245	false	false	false	true	false
59cb430b-6807-4bad-b3f6-9a6212e40e47	2026-09-02 13:21	2026-09-02 13:21	2026-09-02 13:21	CDE	CDE260918P00020000	put	20.0000	2026-09-18	0.6000	0.5500	0.6000	21.1800	50940.00	50940.00	0.00	849	24	990	3629	0.272802424910444	0.64206882063956	0.64206882063956	false	false	false	true	false
42724439-87db-4d8c-9070-62cf5f5f1a49	2026-09-02 13:06	2026-09-02 13:06	2026-09-02 13:06	CDE	CDE261218C00040000	call	40.0000	2026-12-18	0.3000	0.2500	0.3500	21.2750	23850.00	23670.00	30.00	795	18	797	5251	0.15178061321653	0.739221022664496	0.739221022664496	false	false	false	true	false
8ac3a6c0-efa2-4381-b4b0-fad16e45ab9b	2026-09-02 12:21	2026-09-02 12:21	2026-09-02 12:21	CDE	CDE261120C00022500	call	22.5000	2026-11-20	2.1000	2.1000	2.2000	21.0850	12600.00	0.00	12600.00	60	5	126	7930	0.0158890290037831	0.665299811677332	0.665299811677332	false	false	false	true	false
fa97e86c-230b-4099-895a-bcc21c29c2c0	2026-09-02 12:03	2026-09-02 12:03	2026-09-02 12:03	CDE	CDE261120C00022500	call	22.5000	2026-11-20	2.1500	2.1500	2.2000	21.1100	13330.00	0.00	13330.00	62	6	64	7930	0.00807061790668348	0.674938817158809	0.674938817158809	false	false	false	true	false
415aec64-71f0-47a5-9c86-3a67699ddca6	2026-09-02 10:13	2026-09-02 10:13	2026-09-02 10:13	CDE	CDE260904C00021000	call	21.0000	2026-09-04	0.6800	0.6000	0.8000	21.2700	17000.00	0.00	17000.00	250	6	268	1420	0.188732394366197	0.851896573758426	0.851896573758426	false	false	false	true	false
aa455ec0-e91e-4af9-81c7-b45fa532ee06	2026-09-02 09:59	2026-09-02 09:59	2026-09-02 09:59	CDE	CDE261120C00030000	call	30.0000	2026-11-20	0.6000	0.5000	0.6000	21.1200	12960.00	9480.00	0.00	216	7	216	4691	0.0460456192709444	0.696015767513981	0.696015767513981	false	false	false	true	false
37e4b682-6fb6-4130-8afa-e98dcca1ca14	2026-09-01 14:12	2026-09-01 14:12	2026-09-01 14:12	CDE	CDE260918P00020000	put	20.0000	2026-09-18	0.8500	0.8000	0.9000	20.4400	74885.00	0.00	74800.00	881	6	1231	2563	0.480296527506828	0.616313143266491	0.616313143266491	true	false	false	true	false
4ee74680-9a6b-4811-94ac-0aed82871ec4	2026-09-01 14:11	2026-09-01 14:10	2026-09-01 14:10	CDE	CDE261016P00020000	put	20.0000	2026-10-16	1.5000	1.4500	1.5500	20.4450	151950.00	900.00	151050.00	1013	8	1458	550	2.65090909090909	0.622997879724868	0.622997879724868	true	false	false	true	false
7be2fa38-8f39-4514-95d2-bd6abfe33743	2026-09-01 13:38	2026-09-01 13:38	2026-09-01 13:38	CDE	CDE270115C00025000	call	25.0000	2027-01-15	2.0000	2.0000	2.0500	20.6224	100000.00	0.00	100000.00	500	11	514	18854	0.0272621194441498	0.672584856421516	0.672584856421516	false	false	false	true	false
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	false
cd80c249-c98d-40e2-ba98-b61540cdd0fc	2026-08-28 12:42	2026-08-28 12:41	2026-08-28 12:41	CDE	CDE260918P00021000	put	21.0000	2026-09-18	1.2500	1.2500	1.3500	20.9350	125000.00	0.00	125000.00	1000	14	1046	134	7.80597014925373	0.61950042700127	0.61950042700127	true	false	false	true	false
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	false
e12feec2-215a-4a96-8406-77e8514b06d4	2026-08-28 10:08	2026-08-28 10:08	2026-08-28 10:08	CDE	CDE260918C00025000	call	25.0000	2026-09-18	0.3500	0.3000	0.4000	21.7350	24232.00	0.00	6732.00	698	5	1208	7703	0.15682201739582	0.633194268685186	0.633194268685186	false	false	false	true	false
2467e526-adf2-4609-9969-719273bb00de	2026-08-28 09:38	2026-08-28 09:37	2026-08-28 09:37	CDE	CDE261218C00025000	call	25.0000	2026-12-18	2.4000	2.3000	2.4000	22.1700	11760.00	240.00	0.00	49	16	51	3109	0.0164039884207141	0.684948848118605	0.684948848118605	false	false	false	true	false
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	false
01d528d9-bdf3-4811-8e82-88a51dfc2b86	2026-08-27 15:31	2026-08-27 15:31	2026-08-27 15:31	CDE	CDE261218P00020000	put	20.0000	2026-12-18	2.1000	2.1000	2.1500	22.0000	21000.00	0.00	21000.00	100	18	122	1930	0.0632124352331606	0.685150642630682	0.685150642630682	false	false	false	true	false
ebec864e-b647-4385-b3fa-b0d78c42b9b5	2026-08-27 15:12	2026-08-27 15:12	2026-08-27 15:12	CDE	CDE260918C00022500	call	22.5000	2026-09-18	1.2500	1.2500	1.3000	22.1790	18750.00	0.00	18750.00	150	5	568	13929	0.0407782324646421	0.632345110417216	0.632345110417216	false	false	false	true	false
ecb0e42c-1720-4e3f-a99f-6d6922e50fb7	2026-08-27 13:30	2026-08-27 13:30	2026-08-27 13:30	CDE	CDE280121C00030000	call	30.0000	2028-01-21	5.3000	5.1000	5.5000	22.1650	10600.00	9010.00	0.00	20	6	45	9064	0.00496469549867608	0.692666361257942	0.692666361257942	false	false	false	true	false
1ab29e49-222d-40be-90fa-ac1ec4f28874	2026-08-27 11:59	2026-08-27 11:59	2026-08-27 11:59	CDE	CDE270319C00030000	call	30.0000	2027-03-19	2.4000	2.3000	2.4000	22.0750	84480.00	84480.00	0.00	352	7	801	727	1.10178817056396	0.697280525419695	0.697280525419695	false	false	false	true	false
7bbb7c67-0ce4-4792-8e47-67d6cbe31075	2026-08-27 11:43	2026-08-27 11:42	2026-08-27 11:42	CDE	CDE260828P00021500	put	21.5000	2026-08-28	0.2000	0.2000	0.2500	21.9850	23770.00	0.00	23770.00	1188	45	1235	199	6.20603015075377	0.874475973759063	0.874475973759063	false	false	false	true	false
00945ac2-0497-4d34-ba67-a94fd0b628d5	2026-08-27 10:05	2026-08-27 10:05	2026-08-27 10:05	CDE	CDE261016C00025000	call	25.0000	2026-10-16	1.1500	1.0500	1.1500	21.8265	18630.00	18630.00	0.00	162	21	199	595	0.334453781512605	0.689440577502854	0.689440577502854	false	false	false	true	false
ebea9bcc-5987-461a-9f8e-d15a8f480180	2026-08-26 14:42	2026-08-26 14:42	2026-08-26 14:42	CDE	CDE270115P00017500	put	17.5000	2027-01-15	1.6000	1.5000	1.6000	21.4250	157646.00	157646.00	0.00	986	38	1090	3458	0.315211104684789	0.689594666953579	0.689594666953579	true	false	false	true	false
c4b47453-d8be-430d-ba39-feac191f1b37	2026-08-26 14:42	2026-08-26 14:42	2026-08-26 14:42	CDE	CDE270115P00017500	put	17.5000	2027-01-15	1.6000	1.5000	1.6500	21.4250	50240.00	50240.00	0.00	314	6	1404	3458	0.406015037593985	0.689594666953579	0.689594666953579	true	false	false	true	false
c1ddbcb7-c3ba-4221-9795-fcd9fd536db4	2026-08-26 13:12	2026-08-26 13:12	2026-08-26 13:12	CDE	CDE261120P00022500	put	22.5000	2026-11-20	3.4000	3.3000	3.4000	21.4500	20740.00	20740.00	0.00	61	17	68	558	0.121863799283154	0.701722339981583	0.701722339981583	false	false	false	true	false
b946a939-bf33-4f4e-a6a5-fcb43010520b	2026-08-26 10:46	2026-08-26 10:46	2026-08-26 10:46	CDE	CDE270617C00030000	call	30.0000	2027-06-17	3.0000	3.0000	3.2000	21.4550	30000.00	0.00	30000.00	100	6	110	293	0.37542662116041	0.684081147254815	0.684081147254815	false	false	false	true	false
e5eb2851-2157-4cf5-8493-5418c70a30a6	2026-08-25 12:06	2026-08-25 12:05	2026-08-25 12:05	CDE	CDE270219C00025000	call	25.0000	2027-02-19	2.9500	2.8500	3.0000	21.1999	12980.00	7965.00	5015.00	44	7	233	294	0.792517006802721	0.701133370771516	0.701133370771516	false	false	false	true	false
00e9e938-76e5-4acd-bdc4-6168c3224dea	2026-08-25 12:06	2026-08-25 12:05	2026-08-25 12:05	CDE	CDE270219C00025000	call	25.0000	2027-02-19	2.9500	2.8500	3.0000	21.1939	12685.00	5900.00	6785.00	43	11	189	294	0.642857142857143	0.701620750432009	0.701620750432009	false	false	false	true	false
3154a7cc-5bd1-48dc-a94c-eb2f96cedcc8	2026-08-25 10:46	2026-08-25 10:46	2026-08-25 10:46	CDE	CDE270617C00030000	call	30.0000	2027-06-17	2.8000	2.8000	2.9500	21.0500	21000.00	0.00	21000.00	75	8	121	195	0.620512820512821	0.678626944007827	0.678626944007827	false	false	false	true	false
9fe479b2-71fe-4c8e-a6d8-868a6c703bc2	2026-08-25 10:46	2026-08-25 10:46	2026-08-25 10:46	CDE	CDE261120C00030000	call	30.0000	2026-11-20	0.8000	0.7000	0.8500	21.0399	77280.00	76880.00	400.00	966	41	970	4726	0.20524756665256	0.737039593988378	0.737039593988378	false	false	false	true	false
5a1d6ce4-7e13-4b28-8515-30c06ee6c12e	2026-08-25 10:46	2026-08-25 10:46	2026-08-25 10:46	CDE	CDE270617C00030000	call	30.0000	2027-06-17	2.8000	2.8000	2.9500	21.0350	10360.00	0.00	10360.00	37	7	46	195	0.235897435897436	0.679465970535914	0.679465970535914	false	false	false	true	false
90ead7c9-8177-4602-994f-868b78d550c5	2026-08-25 10:09	2026-08-25 10:09	2026-08-25 10:09	CDE	CDE261016C00025000	call	25.0000	2026-10-16	0.8500	0.7500	0.9000	20.8410	31950.00	31950.00	0.00	376	28	383	157	2.43949044585987	0.680662118304912	0.680662118304912	false	false	false	true	false
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	false
80b62a6f-36bf-47d2-83d7-32066bd35585	2026-08-24 15:52	2026-08-24 15:52	2026-08-24 15:52	CDE	CDE280121C00030000	call	30.0000	2028-01-21	4.7000	4.5000	4.7000	20.9600	469850.00	469850.00	0.00	1000	17	1003	7585	0.132234673698088	0.694333446101662	0.691047489411098	false	false	false	true	false
24cc2ae2-346b-458c-b137-c87fc5cce9fa	2026-08-24 14:50	2026-08-24 14:50	2026-08-24 14:50	CDE	CDE261120P00022500	put	22.5000	2026-11-20	3.8000	3.7000	3.8000	20.6950	184659.00	184659.00	0.00	486	42	489	210	2.32857142857143	0.700518205719661	0.700518205719661	false	false	false	true	false
01feee56-63a4-491d-b98d-acb2e631fef2	2026-08-24 14:38	2026-08-24 14:38	2026-08-24 14:38	CDE	CDE260918P00020500	put	20.5000	2026-09-18	1.2500	1.2000	1.2500	20.7450	12125.00	12125.00	0.00	97	18	101	0	0	0.64908239606088	0.64908239606088	true	false	false	true	false
ea44c2c9-70bb-42ae-a878-5d3e5028d32d	2026-08-24 11:22	2026-08-24 11:21	2026-08-24 11:21	CDE	CDE280121P00020000	put	20.0000	2028-01-21	5.3000	5.2000	5.4000	20.6200	13250.00	0.00	1590.00	25	18	31	1026	0.0302144249512671	0.675941980115497	0.675941980115497	false	false	false	true	false
bd96c156-0a7e-4a14-97d3-2ae847da3c3c	2026-08-24 11:18	2026-08-24 11:18	2026-08-24 11:18	CDE	CDE280121C00022500	call	22.5000	2028-01-21	6.2000	6.0000	6.2000	20.6450	14260.00	3720.00	0.00	23	18	499	2627	0.189950513894176	0.670027728669238	0.670027728669238	false	false	false	true	false
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	false
c661c7d1-dba7-41f2-9894-70affe433d34	2026-08-24 09:32	2026-08-24 09:32	2026-08-24 09:32	CDE	CDE280121C00022500	call	22.5000	2028-01-21	6.6000	6.4000	6.6000	21.2000	35640.00	660.00	0.00	54	17	134	2627	0.0510087552341073	0.674339203844658	0.674339203844658	false	false	false	true	false
98d51e91-4c25-49a4-818b-dd5e6b076ecc	2026-08-24 09:31	2026-08-24 09:31	2026-08-24 09:31	CDE	CDE280121C00022500	call	22.5000	2028-01-21	6.7000	6.4000	7.0000	21.3915	13400.00	670.00	670.00	20	18	20	2627	0.00761324704986677	0.671550966109101	0.671550966109101	false	false	false	true	false
5ef62920-4adf-420a-936c-905337c556dd	2026-08-24 09:30	2026-08-24 09:30	2026-08-24 09:30	CDE	CDE261218C00030000	call	30.0000	2026-12-18	1.1000	1.0500	1.3000	21.2900	11000.00	0.00	11000.00	100	9	100	3115	0.0321027287319422	0.699633740778876	0.699633740778876	false	false	false	true	false
d7f7ae5a-f506-4791-81e1-fbd645c2f2ce	2026-08-21 15:59	2026-08-21 15:59	2026-08-21 15:59	CDE	CDE260828C00021000	call	21.0000	2026-08-28	0.7600	0.7000	0.8500	20.9900	16188.00	0.00	16188.00	213	11	1382	719	1.9221140472879	0.646649846742808	0.65339111480603	false	false	false	true	false
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	false
aeb2f1bb-4688-4f46-b2aa-6f99904834e8	2026-08-21 15:50	2026-08-21 15:50	2026-08-21 15:50	CDE	CDE261218P00020000	put	20.0000	2026-12-18	2.4500	2.4500	2.6000	21.1250	48277.00	0.00	48277.00	197	5	450	1572	0.286259541984733	0.672379135731149	0.667932748651037	false	false	false	true	false
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	false
792bc86f-48b7-4e72-bb62-1231a48a6d21	2026-08-21 14:02	2026-08-21 14:02	2026-08-21 14:02	CDE	CDE260821C00019000	call	19.0000	2026-08-21	2.2000	2.1000	2.2000	21.2059	33000.00	33000.00	0.00	150	15	839	3853	0.217752400726706	1.71317727522276	1.71317727522276	false	false	false	true	false