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:endpoint = /api/option-trades/flow-alerts×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

76a24375-d1ec-4e59-9d95-403f3582add8	2026-08-17 10:46	2026-08-17 10:46	2026-08-17 10:46	CDE	CDE270917C00025000	call	25.0000	2027-09-17	3.8000	3.5000	4.0000	19.3750	14820.00	3800.00	11020.00	39	6	249	880	0.282954545454545	0.658018882981046	0.658018882981046	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-08-17T14:59:17.821734Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
da5cef3b-a11c-4f1a-ac6d-4f8c0c9fff1b	2026-08-17 11:43	2026-08-17 11:43	2026-08-17 11:43	CDE	CDE261120C00020000	call	20.0000	2026-11-20	2.5000	2.4500	2.5000	19.4703	26000.00	26000.00	0.00	104	5	768	9388	0.0818065615679591	0.669165885877809	0.669165885877809	false	false	false
d8b34ed8-33cf-4d6f-b6f0-b934d80da7c5	2026-08-17 13:22	2026-08-17 13:22	2026-08-17 13:22	CDE	CDE260911C00019000	call	19.0000	2026-09-11	1.5000	1.4500	1.5000	19.5100	10500.00	10500.00	0.00	70	20	81	2634	0.030751708428246	0.598162869006252	0.598162869006252	false	false	false
44d46902-2522-4666-a7f1-f7986543167e	2026-08-17 13:45	2026-08-17 13:44	2026-08-17 13:44	CDE	CDE261120C00020000	call	20.0000	2026-11-20	2.5000	2.4500	2.5500	19.0000	21250.00	0.00	20750.00	85	7	922	9388	0.0982104814657009	0.662230255267464	0.662230255267464	false	false	false
b82285c8-f263-47ac-8287-df2d15bd0040	2026-08-17 14:30	2026-08-17 14:30	2026-08-17 14:30	CDE	CDE260821C00019000	call	19.0000	2026-08-21	0.7500	0.7000	0.7500	19.4409	37500.00	4575.00	0.00	500	20	2089	5013	0.41671653700379	0.615026509187055	0.615026509187055	false	false	false
323f0697-ce26-481a-bbbc-3fb023f26f3c	2026-08-18 09:32	2026-08-18 09:32	2026-08-18 09:32	CDE	CDE270617C00020000	call	20.0000	2027-06-17	4.4000	4.1000	4.6000	18.9410	10560.00	440.00	440.00	24	24	24	112	0.214285714285714	0.671418311525516	0.671418311525516	true	false	false
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
ce3af83c-fb69-4cf0-b2bf-3defa246286d	2026-08-18 11:00	2026-08-18 10:59	2026-08-18 10:59	CDE	CDE270115P00020000	put	20.0000	2027-01-15	3.8000	3.7000	3.9000	18.6200	14820.00	0.00	7600.00	39	5	49	4781	0.0102489019033675	0.667553643522271	0.667553643522271	false	false	false
bc5b2623-7b6c-468b-af0f-758c11644708	2026-08-18 12:53	2026-08-18 12:53	2026-08-18 12:53	CDE	CDE261120C00020000	call	20.0000	2026-11-20	2.1500	2.1000	2.2000	18.8300	16125.00	0.00	11180.00	75	8	204	9570	0.0213166144200627	0.669923729414264	0.669923729414264	false	false	false
231546cb-ec90-4a06-8c94-d4a8587ea1c4	2026-08-19 10:24	2026-08-19 10:24	2026-08-19 10:24	CDE	CDE260918C00022500	call	22.5000	2026-09-18	0.7500	0.7000	0.8000	20.4380	84355.00	83455.00	900.00	1125	31	1389	11123	0.12487638227097	0.632046530351027	0.632046530351027	false	false	false
bbbf0faf-c310-4ad4-bf91-33e2491d2a48	2026-08-19 10:52	2026-08-19 10:52	2026-08-19 10:52	CDE	CDE280121P00017500	put	17.5000	2028-01-21	3.7000	3.7000	4.3000	20.8750	12950.00	0.00	12950.00	35	5	45	526	0.0855513307984791	0.651226154145669	0.651226154145669	false	false	false
23f44cb7-7f91-4896-a24c-32e512cde38f	2026-08-19 11:00	2026-08-19 11:00	2026-08-19 11:00	CDE	CDE260828C00021000	call	21.0000	2026-08-28	0.8400	0.8000	0.9000	20.8850	42949.00	33344.00	7650.00	510	19	866	1043	0.830297219558965	0.684302313649164	0.684302313649164	false	false	false
70121f97-d3c5-4822-aead-0f40ab70d6ed	2026-08-19 11:53	2026-08-19 11:53	2026-08-19 11:53	CDE	CDE261120C00020000	call	20.0000	2026-11-20	3.5000	3.5000	3.7000	21.1750	92400.00	0.00	92400.00	264	8	366	9663	0.0378764358894753	0.672405752864407	0.672405752864407	false	false	false
8eca17b3-6a6b-4e7f-b2a7-90e903442826	2026-08-19 11:53	2026-08-19 11:53	2026-08-19 11:53	CDE	CDE261120C00020000	call	20.0000	2026-11-20	3.5000	3.5000	3.6000	21.1600	222600.00	0.00	222600.00	636	5	1002	9663	0.10369450481217	0.674824379609883	0.674824379609883	true	false	false
051600b3-657a-4ae6-be97-d36af9fe1c3b	2026-08-19 12:06	2026-08-19 12:06	2026-08-19 12:06	CDE	CDE261120C00030000	call	30.0000	2026-11-20	0.8000	0.8000	0.8500	21.1650	10400.00	0.00	10400.00	130	9	351	4394	0.0798816568047337	0.70337297548155	0.70337297548155	false	false	false
20b00945-4f6d-473e-87be-dca79d80b9b0	2026-08-19 12:19	2026-08-19 12:19	2026-08-19 12:19	CDE	CDE260918C00022500	call	22.5000	2026-09-18	1.0500	1.0000	1.0500	21.1750	12180.00	12180.00	0.00	116	9	2300	11123	0.206778746740987	0.642666427171032	0.642666427171032	false	false	false
dcf0296a-2f63-479b-990e-6fc2e1ae06d8	2026-08-19 12:37	2026-08-19 12:37	2026-08-19 12:37	CDE	CDE270115C00020000	call	20.0000	2027-01-15	4.1000	4.0000	4.1000	20.9950	22960.00	22960.00	0.00	56	5	246	18663	0.0131811605851149	0.661494299605202	0.661494299605202	false	false	false
cd739a71-742c-4a83-9803-d78e248e16fc	2026-08-19 12:52	2026-08-19 12:52	2026-08-19 12:52	CDE	CDE260918C00022500	call	22.5000	2026-09-18	0.9000	0.9000	0.9500	20.8650	19440.00	0.00	19440.00	216	8	2809	11123	0.252539782432797	0.630888186666715	0.630888186666715	false	false	false
b32f3392-1cd0-4c34-bbee-4d6b9a20ba32	2026-08-19 14:03	2026-08-19 14:03	2026-08-19 14:03	CDE	CDE260828C00023000	call	23.0000	2026-08-28	0.2500	0.2000	0.2500	20.7750	11250.00	11250.00	0.00	450	9	625	461	1.35574837310195	0.718197512220397	0.718197512220397	false	false	false
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
b84a6e44-e940-4041-9930-380de97f7b04	2026-08-20 09:48	2026-08-20 09:48	2026-08-20 09:48	CDE	CDE260918P00022500	put	22.5000	2026-09-18	2.4000	2.2000	2.4000	21.0950	11980.00	11980.00	0.00	50	5	54	1896	0.0284810126582278	0.67351718021092	0.6518449308252	false	false	false
ccb3beea-cad9-4a0c-bcfc-38c061f1a438	2026-08-20 09:56	2026-08-20 09:56	2026-08-20 09:56	CDE	CDE261120P00020000	put	20.0000	2026-11-20	2.2000	2.2000	2.2500	20.9200	10780.00	0.00	10780.00	49	11	54	2643	0.0204313280363224	0.670504678775097	0.670504678775097	false	false	false
0fdb04ae-e2c3-4e5f-826f-3e42e0cca1f9	2026-08-20 10:47	2026-08-20 10:46	2026-08-20 10:46	CDE	CDE270115C00040000	call	40.0000	2027-01-15	0.4500	0.4500	0.5500	21.0950	16875.00	0.00	16875.00	375	9	550	10652	0.0516334960570785	0.695048108850247	0.695048108850247	false	false	false
1a9f9faa-c136-43e3-a792-a790f1b4f365	2026-08-20 10:53	2026-08-20 10:53	2026-08-20 10:53	CDE	CDE260821C00020000	call	20.0000	2026-08-21	1.2500	1.2000	1.2500	21.2150	12500.00	12500.00	0.00	100	5	421	11008	0.0382449127906977	0.812783392850953	0.812783392850953	false	false	false
b11fa135-a8b6-4c21-bfa8-f091aa25a3ad	2026-08-20 10:53	2026-08-20 10:53	2026-08-20 10:53	CDE	CDE260821C00021000	call	21.0000	2026-08-21	0.5000	0.4500	0.5000	21.2400	48800.00	48800.00	0.00	976	22	1066	986	1.08113590263692	0.830571701750456	0.830571701750456	false	false	false
aca2e27d-0dcf-4851-8637-a99a866f3668	2026-08-20 10:59	2026-08-20 10:59	2026-08-20 10:59	CDE	CDE260925C00020000	call	20.0000	2026-09-25	2.2500	2.1000	2.2500	21.2900	112500.00	5175.00	0.00	500	32	500	583	0.857632933104631	0.569385195986451	0.569385195986451	false	false	false
407f44aa-284d-488a-a92a-20e08cad55c3	2026-08-20 11:15	2026-08-20 11:14	2026-08-20 11:14	CDE	CDE260918C00022500	call	22.5000	2026-09-18	1.1500	1.1500	1.2000	21.5180	17250.00	0.00	17250.00	150	8	527	10896	0.0483663729809104	0.634244557894554	0.634244557894554	false	false	false
8c57a628-53ed-4324-ab5d-a9e8f1e96c58	2026-08-20 13:05	2026-08-20 13:05	2026-08-20 13:05	CDE	CDE280121C00030000	call	30.0000	2028-01-21	4.8000	4.6000	4.8000	21.2000	431520.00	431520.00	0.00	899	13	2905	3461	0.8393527882115	0.689019409436768	0.689019409436768	false	false	false
b03981aa-105f-4def-b713-b6a986530f7f	2026-08-20 13:23	2026-08-20 13:23	2026-08-20 13:23	CDE	CDE261120C00030000	call	30.0000	2026-11-20	0.8500	0.8000	0.9000	21.2300	65694.00	65269.00	0.00	773	56	839	4503	0.18632023095714	0.718525056053677	0.718525056053677	false	false	false
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
8597f1ea-10c0-4266-bd24-ffcaa5f7e97e	2026-08-21 09:52	2026-08-21 09:52	2026-08-21 09:52	CDE	CDE260821C00019000	call	19.0000	2026-08-21	2.2000	2.2000	2.2500	21.1850	33880.00	0.00	33880.00	154	8	252	3853	0.065403581624708	2.21588540610061	2.21588540610061	false	false	false
6bf92bd9-2cbd-4230-b248-31d30ac766cf	2026-08-21 09:52	2026-08-21 09:52	2026-08-21 09:52	CDE	CDE260821C00019000	call	19.0000	2026-08-21	2.2000	2.2000	2.2500	21.2000	13420.00	0.00	13420.00	61	7	389	3853	0.100960290682585	2.85456551810156	2.85456551810156	false	false	false
db6a8f9b-31e0-4faf-9d8d-4951112a3dab	2026-08-21 09:52	2026-08-21 09:52	2026-08-21 09:52	CDE	CDE260821C00019000	call	19.0000	2026-08-21	2.2000	2.2000	2.2500	21.1950	16280.00	0.00	16280.00	74	9	467	3853	0.121204256423566	1.8600483405392	1.8600483405392	false	false	false
53791b56-92ef-4b35-8e11-d3d42374b21c	2026-08-21 10:21	2026-08-21 10:20	2026-08-21 10:20	CDE	CDE280121C00030000	call	30.0000	2028-01-21	4.8000	4.5000	4.8000	21.1150	240000.00	240000.00	0.00	500	24	1123	6503	0.172689527910195	0.694195607426251	0.694195607426251	true	false	false
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
0ce36228-2369-4ac2-9b19-9faa9637e5d0	2026-08-21 10:50	2026-08-21 10:49	2026-08-21 10:49	CDE	CDE261218C00030000	call	30.0000	2026-12-18	1.1500	1.0500	1.1500	21.1300	18400.00	18400.00	0.00	160	13	179	3112	0.0575192802056555	0.713771737913371	0.713771737913371	false	false	false
373543d5-305a-4a3a-a0ad-dbd0768eb477	2026-08-21 12:36	2026-08-21 12:36	2026-08-21 12:36	CDE	CDE261120C00030000	call	30.0000	2026-11-20	0.9000	0.8000	1.0000	21.4350	53990.00	49400.00	4500.00	600	43	863	5151	0.167540283440109	0.724155855798204	0.723441553207173	false	false	false
8c21bc0f-9c61-4a65-ac30-3f16b9bfc328	2026-08-21 12:43	2026-08-21 12:42	2026-08-21 12:42	CDE	CDE261218C00022500	call	22.5000	2026-12-18	2.9900	2.9500	3.1000	21.4600	149500.00	0.00	149500.00	500	2	1641	4218	0.389046941678521	0.68076773184358	0.68076773184358	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
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
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
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
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
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
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
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
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
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
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