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 = CCL×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	price

3f49b880-6fb8-4224-bc8a-559669925ed5	2026-09-09 12:59	2026-09-09 12:59	2026-09-09 12:59	CCL	CCL261016P00021000	put	21.0000	2026-10-16	0.5600	0.5500	0.5700	22.0000	17080.00	16800.00	0.00	305	10	729	1207	0.603976801988401	0.471901167897174	0.471358472159572	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	30899284125.00	2026-10-05	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
dfac9910-b5a1-468b-88d3-5faa7fee34f3	2026-09-09 14:09	2026-09-09 14:09	2026-09-09 14:09	CCL	CCL261120C00024000	call	24.0000	2026-11-20	1.3700	1.3500	1.3800	22.8577	18495.00	18495.00	0.00	135	25	256	1634	0.156670746634027	0.438046156115565	0.438046156115565	false	false	false	true	false
e1dcfc46-b45f-42df-92aa-92b1461410f7	2026-09-09 14:25	2026-09-09 14:25	2026-09-09 14:25	CCL	CCL261016C00026000	call	26.0000	2026-10-16	0.3900	0.3800	0.4000	22.8650	19500.00	0.00	16380.00	500	17	641	1370	0.467883211678832	0.459478537427737	0.459478537427737	false	false	false	true	false
8993878a-2ebf-4c14-9875-18413c60cc63	2026-09-09 14:49	2026-09-09 14:49	2026-09-09 14:49	CCL	CCL261218C00022000	call	22.0000	2026-12-18	2.6000	2.5200	2.6100	22.7450	39000.00	36920.00	2080.00	150	30	206	1111	0.185418541854185	0.447206831983918	0.446522588764457	false	false	false	true	false
7c76c70c-0f6c-4d5f-b4fb-a5b69c77349e	2026-09-09 15:22	2026-09-09 15:22	2026-09-09 15:22	CCL	CCL261120P00021000	put	21.0000	2026-11-20	1.0000	0.9800	1.0000	22.7500	24850.00	19900.00	0.00	249	27	386	3464	0.111431870669746	0.463549792358205	0.466402363597967	false	false	false	true	false
118c0777-e557-420d-b58f-e2e48749456a	2026-09-09 15:24	2026-09-09 15:24	2026-09-09 15:24	CCL	CCL260918C00025000	call	25.0000	2026-09-18	0.0600	0.0600	0.0700	22.7450	15522.00	0.00	15522.00	2587	28	2847	9426	0.302036919159771	0.429330836561732	0.429330836561732	false	false	false	true	false
55b91440-0067-49b2-b9a7-0bc80eb70dfb	2026-09-10 09:49	2026-09-10 09:49	2026-09-10 09:49	CCL	CCL260918C00023000	call	23.0000	2026-09-18	0.4400	0.4100	0.4700	22.6850	10648.00	132.00	220.00	242	42	541	1113	0.48607367475292	0.427136234392619	0.427136234392619	false	false	false	true	false
043b3f31-fcce-4738-bc32-1859d0a8f4fb	2026-09-10 09:50	2026-09-10 09:50	2026-09-10 09:50	CCL	CCL260918C00023000	call	23.0000	2026-09-18	0.4300	0.4000	0.4400	22.6650	11825.00	10621.00	989.00	275	33	915	1113	0.822102425876011	0.424591418356746	0.426048217715839	false	false	false	true	false
423b4491-f75f-44a0-9d5e-2f41127b20f0	2026-09-10 10:33	2026-09-10 10:33	2026-09-10 10:33	CCL	CCL280121C00023000	call	23.0000	2028-01-21	4.9000	4.7500	4.9500	22.6550	14700.00	14700.00	0.00	30	9	145	976	0.148565573770492	0.428773577243659	0.428773577243659	false	false	false	true	false
f8907dec-b891-4cfe-bfac-715ecc28ab66	2026-09-10 10:41	2026-09-10 10:41	2026-09-10 10:41	CCL	CCL280121C00023000	call	23.0000	2028-01-21	4.9500	4.8000	4.9500	22.7400	14850.00	14850.00	0.00	30	6	236	976	0.241803278688525	0.428376474945498	0.428376474945498	false	false	false	true	false
8a3f2a2b-a759-4ad4-99eb-714e65aa8642	2026-09-10 10:47	2026-09-10 10:47	2026-09-10 10:47	CCL	CCL280121C00023000	call	23.0000	2028-01-21	4.9000	4.7500	4.9000	22.6350	19600.00	19600.00	0.00	40	10	306	976	0.313524590163934	0.43004517240408	0.43004517240408	false	false	false	true	false
5f42fbad-197d-4d2c-8464-bf820304c5a3	2026-09-10 11:18	2026-09-10 11:18	2026-09-10 11:18	CCL	CCL261016P00023000	put	23.0000	2026-10-16	1.4500	1.4250	1.4700	22.6350	41010.00	146.00	40864.00	283	35	321	3215	0.0998444790046656	0.457663787644986	0.454137234915055	true	false	false	true	false
5ecfcf9f-9312-4f14-8895-c3b7b4466c14	2026-09-10 11:31	2026-09-10 11:31	2026-09-10 11:31	CCL	CCL261218C00023000	call	23.0000	2026-12-18	2.0000	1.9500	2.0600	22.5750	40000.00	32800.00	7200.00	200	14	526	5498	0.0956711531465988	0.446169963531409	0.446169963531409	true	false	false	true	false
dd7750e7-2abe-4c40-a814-cdfdcdc793ba	2026-09-10 11:32	2026-09-10 11:32	2026-09-10 11:32	CCL	CCL261218C00023000	call	23.0000	2026-12-18	2.0000	1.9500	2.0100	22.5550	18600.00	16600.00	2000.00	93	6	629	5498	0.114405238268461	0.447305949116175	0.448441023336069	false	false	false	true	false
ac6203fc-9745-4547-a8fc-f34a35449d51	2026-09-10 11:32	2026-09-10 11:32	2026-09-10 11:32	CCL	CCL261218C00023000	call	23.0000	2026-12-18	2.0000	1.9500	2.0100	22.5550	36800.00	36600.00	200.00	184	23	813	5498	0.147871953437614	0.448441023336069	0.448441023336069	false	false	false	true	false
403ec736-6875-4512-aa8d-1da4d5906bde	2026-09-10 11:42	2026-09-10 11:41	2026-09-10 11:41	CCL	CCL261218C00023000	call	23.0000	2026-12-18	1.9800	1.9500	2.0200	22.5300	19800.00	17622.00	2178.00	100	5	984	5498	0.178974172426337	0.446991371910237	0.446991371910237	false	false	false	true	false
c26ddb42-87df-46bf-b563-d6f9a95ff071	2026-09-10 11:44	2026-09-10 11:43	2026-09-10 11:43	CCL	CCL261120P00024000	put	24.0000	2026-11-20	2.5800	2.5800	2.6100	22.5150	10320.00	0.00	10320.00	40	6	63	4255	0.0148061104582844	0.454617175985288	0.454617175985288	false	false	false	true	false
180fc844-f63b-4a0d-b4ce-22b1816763e7	2026-09-10 11:48	2026-09-10 11:48	2026-09-10 11:48	CCL	CCL261016P00023000	put	23.0000	2026-10-16	1.5100	1.4900	1.5100	22.5050	13288.00	13288.00	0.00	88	8	414	3215	0.128771384136858	0.455263178249092	0.455263178249092	true	false	false	true	false
8a6a89ff-3b19-4a6a-8680-933900981b0a	2026-09-10 11:57	2026-09-10 11:57	2026-09-10 11:57	CCL	CCL270416C00025000	call	25.0000	2027-04-16	2.2500	2.1500	2.2500	22.3850	11250.00	9450.00	0.00	50	6	51	587	0.0868824531516184	0.4437389615561	0.4437389615561	false	false	false	true	false
d87fd602-9be2-464d-aa80-3b8f50c0c93c	2026-09-10 13:51	2026-09-10 13:51	2026-09-10 13:51	CCL	CCL260918P00022500	put	22.5000	2026-09-18	0.6300	0.5900	0.6400	22.3250	15750.00	3150.00	3150.00	250	5	312	0	0	0.414426340164426	0.414426340164426	false	false	false	true	false
60fd9209-f8d9-471e-9f60-98dabd77f3b8	2026-09-10 13:51	2026-09-10 13:51	2026-09-10 13:51	CCL	CCL260918P00022500	put	22.5000	2026-09-18	0.6300	0.5900	0.6300	22.3250	15750.00	15750.00	0.00	250	18	562	0	0	0.414426340164426	0.414426340164426	false	false	false	true	false
e2976bbd-b93f-4dc2-9d59-6ce550895cc9	2026-09-11 09:37	2026-09-11 09:37	2026-09-11 09:37	CCL	CCL270115C00023000	call	23.0000	2027-01-15	2.5200	2.5200	2.6000	22.0000	23184.00	0.00	15876.00	92	24	108	838	0.128878281622912	0.447212538546815	0.447212538546815	false	false	false	true	false
8b20bed6-e520-4c62-8003-781840349e7b	2026-09-11 10:21	2026-09-11 10:21	2026-09-11 10:21	CCL	CCL270115C00025000	call	25.0000	2027-01-15	1.6400	1.6300	1.6500	22.8150	10332.00	3936.00	4920.00	63	6	76	4495	0.0169076751946607	0.444237265526992	0.444237265526992	false	false	false	true	false
6825a461-2223-4571-b627-1d93c4bc5c2a	2026-09-11 10:42	2026-09-11 10:42	2026-09-11 10:42	CCL	CCL261016C00025000	call	25.0000	2026-10-16	0.5500	0.5300	0.5500	22.8350	27280.00	27280.00	0.00	496	29	1008	5059	0.199248863411741	0.453679096861959	0.45428090226845	false	false	false	true	false
df9d548c-33d8-4868-9dd0-6189de89306b	2026-09-11 11:15	2026-09-11 11:15	2026-09-11 11:15	CCL	CCL261016C00025000	call	25.0000	2026-10-16	0.5500	0.5300	0.5500	22.8500	25410.00	25410.00	0.00	462	8	1561	5059	0.308559003755683	0.452475144611728	0.452475144611728	false	false	false	true	false
56524e06-ec12-41d5-b85e-d8cc6ae28a1a	2026-09-11 11:40	2026-09-11 11:40	2026-09-11 11:40	CCL	CCL280121P00025000	put	25.0000	2028-01-21	5.6500	5.4500	5.7000	22.9250	41810.00	565.00	41245.00	74	6	77	13956	0.00551734021209516	0.484386953370789	0.484386953370789	false	false	false	true	false
28b9c914-5041-41cc-9fb6-7ab7116afafa	2026-09-11 11:45	2026-09-11 11:45	2026-09-11 11:45	CCL	CCL261218C00023000	call	23.0000	2026-12-18	2.1900	2.1700	2.2300	22.9399	14235.00	0.00	14235.00	65	5	625	7054	0.0886022115111993	0.44408747109064	0.44408747109064	false	false	false	true	false
b4563c60-f952-4d48-8429-0ba6b8413794	2026-09-11 12:04	2026-09-11 12:04	2026-09-11 12:04	CCL	CCL261218C00023000	call	23.0000	2026-12-18	2.1600	2.1600	2.2000	22.9398	21600.00	0.00	21600.00	100	6	1126	7054	0.159625744258577	0.437700451920531	0.437700451920531	false	false	false	true	false
5b5d20ed-156f-4359-ac71-0055b5bbe2e1	2026-09-11 12:57	2026-09-11 12:57	2026-09-11 12:57	CCL	CCL270115P00022000	put	22.0000	2027-01-15	1.8800	1.8800	1.9000	22.9000	11656.00	0.00	11656.00	62	8	70	11085	0.0063148398737032	0.464464706586681	0.464464706586681	false	false	false	true	false
7a0c9be7-915f-410d-9ed0-aae97f9f8053	2026-09-11 13:52	2026-09-11 13:51	2026-09-11 13:51	CCL	CCL270115P00021000	put	21.0000	2027-01-15	1.4600	1.4500	1.4900	22.8750	24382.00	0.00	24382.00	167	7	188	1244	0.15112540192926	0.466757901499099	0.466757901499099	false	false	false	true	false
2fc62082-73ba-4394-b22a-dd7fd8b4215d	2026-09-11 14:32	2026-09-11 14:31	2026-09-11 14:31	CCL	CCL261218P00021000	put	21.0000	2026-12-18	1.2300	1.2200	1.2600	22.8350	16359.00	123.00	16236.00	133	18	185	223	0.829596412556054	0.468192640370593	0.468192640370593	false	false	false	true	false
3468a589-d80e-40cb-916e-bc262cd89391	2026-09-11 14:52	2026-09-11 14:52	2026-09-11 14:52	CCL	CCL270115P00020000	put	20.0000	2027-01-15	1.1100	1.1100	1.1300	22.8150	22200.00	0.00	22200.00	200	16	451	19540	0.0230808597748209	0.468902861654991	0.468902861654991	false	false	false	true	false
3a4ae0ad-5601-49b1-9f00-f69c8a59dd87	2026-09-11 15:52	2026-09-11 15:52	2026-09-11 15:52	CCL	CCL260925C00024500	call	24.5000	2026-09-25	0.1500	0.1500	0.1700	22.7900	12375.00	0.00	12375.00	825	17	922	13	70.9230769230769	0.371360279991786	0.371360279991786	false	false	false	true	false
a4fc7256-60df-489e-9402-be8f2f2def54	2026-09-14 09:33	2026-09-14 09:32	2026-09-14 09:32	CCL	CCL261016C00022000	call	22.0000	2026-10-16	1.6100	1.0800	1.7400	22.4700	10954.00	8644.00	2310.00	68	21	68	194	0.350515463917526	0.52007800797459	0.475990531263644	true	false	false	true	false
908f357f-197f-477c-b9ac-b0f340dbbfee	2026-09-14 10:18	2026-09-14 10:18	2026-09-14 10:18	CCL	CCL270115C00025000	call	25.0000	2027-01-15	1.4500	1.4400	1.4700	22.0000	10730.00	3770.00	5945.00	74	10	81	4664	0.0173670668953688	0.44018000773675	0.44018000773675	true	false	false	true	false
16ed96c8-e283-4ff6-bd20-723b6fb90fa5	2026-09-14 11:01	2026-09-14 11:00	2026-09-14 11:00	CCL	CCL270115P00020000	put	20.0000	2027-01-15	1.2100	1.2100	1.2500	22.3500	18878.00	0.00	18878.00	156	15	208	19769	0.0105215235975517	0.471520189958378	0.471520189958378	true	false	false	true	false
07dd6efb-dcfa-4a6c-873e-4b87114a7e08	2026-09-14 11:01	2026-09-14 11:01	2026-09-14 11:01	CCL	CCL261218C00025000	call	25.0000	2026-12-18	1.1400	1.1100	1.1500	22.3502	11400.00	1140.00	9120.00	100	6	291	4709	0.0617965597791463	0.444092223880546	0.444092223880546	false	false	false	true	false
a35845ee-3d3d-48ef-948e-a473494fd433	2026-09-14 11:02	2026-09-14 11:02	2026-09-14 11:02	CCL	CCL261218C00025000	call	25.0000	2026-12-18	1.1400	1.1000	1.1500	22.3400	22800.00	6840.00	6840.00	200	12	491	4709	0.104268422170312	0.444967731268168	0.444967731268168	false	false	false	true	false
9e6d4d73-c173-42de-848b-daecf5a755de	2026-09-14 11:39	2026-09-14 11:39	2026-09-14 11:39	CCL	CCL270115C00023000	call	23.0000	2027-01-15	2.2800	2.2600	2.2800	22.5850	22800.00	22800.00	0.00	100	13	150	977	0.15353121801433	0.445482093588904	0.445482093588904	false	false	false	true	false
9fe3a424-5f31-462f-b10c-2972bad050e4	2026-09-14 11:47	2026-09-14 11:47	2026-09-14 11:47	CCL	CCL261002C00024500	call	24.5000	2026-10-02	0.3900	0.3500	0.3900	22.6250	35100.00	35100.00	0.00	900	52	1001	0	0	0.510334213783715	0.510334213783715	false	false	false	true	false
bf9270b8-2a4e-4420-93ee-8eb600373283	2026-09-14 12:01	2026-09-14 12:01	2026-09-14 12:01	CCL	CCL261120C00024000	call	24.0000	2026-11-20	1.2000	1.1600	1.2000	22.6450	26880.00	26880.00	0.00	224	8	328	1904	0.172268907563025	0.435041904370396	0.435041904370396	false	false	false	true	false
ca0ace8c-ae1a-47e1-bc36-54c40c3d6efb	2026-09-14 12:38	2026-09-14 12:38	2026-09-14 12:38	CCL	CCL260918C00023000	call	23.0000	2026-09-18	0.2700	0.2500	0.2700	22.6150	11205.00	11205.00	0.00	415	20	1660	2572	0.645412130637636	0.453561818465143	0.453561818465143	false	false	false	true	false
01086c3f-ad68-4c93-a0da-c831fd91dc24	2026-09-14 12:49	2026-09-14 12:48	2026-09-14 12:48	CCL	CCL260918C00023000	call	23.0000	2026-09-18	0.3100	0.2900	0.3100	22.7299	23064.00	23064.00	0.00	744	33	3248	2572	1.26283048211509	0.4478892758374	0.4478892758374	false	false	false	true	false
4e1aeab1-e210-4ef2-a3d6-b55e4623da7d	2026-09-14 12:50	2026-09-14 12:50	2026-09-14 12:50	CCL	CCL270115C00029000	call	29.0000	2027-01-15	0.6500	0.6500	0.6800	22.7450	13000.00	0.00	13000.00	200	6	207	345	0.6	0.438769731852076	0.438769731852076	false	false	false	true	false
65d8dae8-7795-4622-af00-06762b67a2ff	2026-09-14 13:28	2026-09-14 13:28	2026-09-14 13:28	CCL	CCL270115C00025000	call	25.0000	2027-01-15	1.4800	1.4800	1.5100	22.5450	22496.00	0.00	22496.00	152	14	338	4664	0.0724699828473413	0.438445144505578	0.438445144505578	false	false	false	true	false
7d8a2114-d97f-43f7-9e17-a7643e183a14	2026-09-14 14:51	2026-09-14 14:51	2026-09-14 14:51	CCL	CCL261016C00023000	call	23.0000	2026-10-16	1.1000	1.0700	1.1000	22.6150	10339.00	10339.00	0.00	94	11	706	2017	0.350024789291026	0.46455111943128	0.463636512315049	true	false	false	true	false
2f2eb94c-bc14-4621-814f-135385d82c16	2026-09-14 14:53	2026-09-14 14:53	2026-09-14 14:53	CCL	CCL270115C00025000	call	25.0000	2027-01-15	1.5200	1.5100	1.5400	22.6350	24320.00	6688.00	8664.00	160	33	511	4664	0.109562607204117	0.438973831903333	0.438973831903333	true	false	false	true	false
2787c661-9908-4300-87f1-262daf87257c	2026-09-15 09:46	2026-09-15 09:46	2026-09-15 09:46	CCL	CCL261218P00021000	put	21.0000	2026-12-18	1.3700	1.1900	1.4100	22.4200	44436.00	40900.00	3536.00	325	56	325	618	0.52588996763754	0.479857252312291	0.47703355197246	true	false	false	true	false
a7487e68-3dd9-443f-9fb4-89c42687a269	2026-09-15 10:02	2026-09-15 10:02	2026-09-15 10:02	CCL	CCL270115C00023000	call	23.0000	2027-01-15	2.0800	2.0200	2.0800	22.2700	29744.00	10400.00	0.00	143	9	166	1212	0.136963696369637	0.440945387085457	0.440945387085457	false	false	false	true	false
99454987-26a3-45d5-92c7-e162740ec5e5	2026-09-15 10:02	2026-09-15 10:02	2026-09-15 10:02	CCL	CCL270115C00023000	call	23.0000	2027-01-15	2.0500	2.0300	2.1000	22.2550	32185.00	2255.00	3280.00	157	18	323	1212	0.266501650165016	0.436619534916385	0.436619534916385	false	false	false	true	false