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:sector = Consumer Cyclical×ticker = CCL×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

c0b11a5b-2e10-4e92-8a59-a55d42f651bd	2026-08-25 10:13	2026-08-25 10:13	2026-08-25 10:13	CCL	CCL270319P00028000	put	28.0000	2027-03-19	4.3500	4.3000	4.4500	26.0100	43500.00	26535.00	9570.00	100	5	1202	2522	0.476605868358446	0.456152338690167	0.456152338690167	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	30899284125.00	2026-10-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-25T14:28:24.156188Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
bd82ac22-17f5-43c5-82c0-d343bf751a1b	2026-08-25 10:13	2026-08-25 10:13	2026-08-25 10:13	CCL	CCL270319P00028000	put	28.0000	2027-03-19	4.3500	4.3000	4.4000	26.0100	43500.00	33930.00	0.00	100	5	1402	2522	0.555908009516257	0.456152338690167	0.456152338690167	false	false	false	true
21132193-b3b7-4dd7-9f56-ab8910600508	2026-08-25 10:13	2026-08-25 10:13	2026-08-25 10:13	CCL	CCL270319P00028000	put	28.0000	2027-03-19	4.3500	4.3000	4.3500	26.0100	43500.00	20880.00	0.00	100	6	1102	2522	0.43695479777954	0.456152338690167	0.456152338690167	false	false	false	true
f81d7415-68c5-4199-a541-ed83d3f56fb2	2026-08-25 10:13	2026-08-25 10:13	2026-08-25 10:13	CCL	CCL270319P00028000	put	28.0000	2027-03-19	4.3500	4.2000	4.3500	26.0300	38280.00	18270.00	0.00	88	5	590	2522	0.233941316415543	0.457410161688818	0.457410161688818	false	false	false	true
bac67920-989c-4a9d-97f9-a372a151ec99	2026-08-25 10:12	2026-08-25 10:12	2026-08-25 10:12	CCL	CCL270319P00028000	put	28.0000	2027-03-19	4.3500	4.1000	4.5000	26.0400	28710.00	9570.00	6090.00	66	5	67	2522	0.0265662172878668	0.458037554740868	0.458037554740868	false	false	false	true
3eeeea91-1f6e-4ee0-9028-37d8c6aced9b	2026-08-24 15:45	2026-08-24 15:45	2026-08-24 15:45	CCL	CCL261120C00022500	call	22.5000	2026-11-20	4.3500	4.3500	4.4500	25.8550	10440.00	0.00	10440.00	24	8	198	127	1.55905511811024	0.448089282635729	0.448089282635729	false	false	false	true
4d8972ec-9a58-4702-b8a1-2a68d5e31aea	2026-08-24 15:03	2026-08-24 15:02	2026-08-24 15:02	CCL	CCL270115P00023000	put	23.0000	2027-01-15	1.5000	1.4500	1.5100	25.8200	16650.00	16650.00	0.00	111	9	1260	1839	0.685154975530179	0.464527098567484	0.464527098567484	false	false	false	true
b6a580c9-81cd-4b2c-9392-3e13bb95320d	2026-08-24 15:02	2026-08-24 15:01	2026-08-24 15:01	CCL	CCL270115P00024000	put	24.0000	2027-01-15	1.8800	1.8400	1.9100	25.8100	16920.00	13160.00	3760.00	90	15	169	914	0.184901531728665	0.4600989719644	0.4600989719644	false	false	false	true
9c91ad54-4166-4c96-bb90-642250fbf08f	2026-08-24 14:58	2026-08-24 14:58	2026-08-24 14:58	CCL	CCL270115P00023000	put	23.0000	2027-01-15	1.5000	1.4900	1.5100	25.8300	10500.00	300.00	3600.00	70	7	982	1839	0.533985861881457	0.465035679952038	0.465035679952038	false	false	false	true
1b812ecc-61ae-4da4-a8d8-30f0f129661e	2026-08-24 14:39	2026-08-24 14:39	2026-08-24 14:39	CCL	CCL261120C00027000	call	27.0000	2026-11-20	1.7800	1.7200	1.7800	25.8150	61944.00	61944.00	0.00	348	23	681	1061	0.641847313854854	0.431202846274324	0.431202846274324	false	false	false	true
9dad2884-f3b5-4f22-91b8-376d021a74e4	2026-08-24 12:19	2026-08-24 12:19	2026-08-24 12:19	CCL	CCL270319P00025000	put	25.0000	2027-03-19	2.8700	2.8600	2.9100	25.7100	207788.00	2296.00	199752.00	724	30	1810	2656	0.681475903614458	0.463129925802596	0.463129925802596	true	false	false	true
f6fcf1cc-5c51-4e9c-a16e-72d323acd5ac	2026-08-24 12:15	2026-08-24 12:15	2026-08-24 12:15	CCL	CCL260828P00026000	put	26.0000	2026-08-28	0.6100	0.6100	0.6400	25.7000	11041.00	0.00	11041.00	181	25	490	528	0.928030303030303	0.417629641031964	0.417629641031964	false	false	false	true
e548ada4-a151-4766-97f1-638dd2c04161	2026-08-24 12:15	2026-08-24 12:15	2026-08-24 12:15	CCL	CCL270319P00025000	put	25.0000	2027-03-19	2.8700	2.8700	2.9200	25.7000	82943.00	0.00	82943.00	289	5	891	2656	0.33546686746988	0.462619406266095	0.462619406266095	true	false	false	true
4fceff46-6f81-4ef0-9e1e-ed06d674867c	2026-08-24 12:15	2026-08-24 12:15	2026-08-24 12:15	CCL	CCL270319P00025000	put	25.0000	2027-03-19	2.8700	2.8700	2.9200	25.7000	156989.00	0.00	156989.00	547	31	602	2656	0.226656626506024	0.462619406266095	0.462619406266095	true	false	false	true
ce54593a-8092-4a68-908c-2c421892a052	2026-08-24 12:11	2026-08-24 12:11	2026-08-24 12:11	CCL	CCL271217P00023000	put	23.0000	2027-12-17	3.5500	3.4000	3.6500	25.7000	18105.00	12070.00	6035.00	51	9	52	1800	0.0288888888888889	0.495145911863476	0.495145911863476	false	false	false	true
4b1c3536-0033-4bba-a437-90e5010222af	2026-08-24 11:14	2026-08-24 11:14	2026-08-24 11:14	CCL	CCL260828C00026000	call	26.0000	2026-08-28	0.3800	0.3500	0.3800	25.7700	13870.00	13870.00	0.00	365	20	800	2662	0.300525920360631	0.44570053538264	0.44570053538264	false	false	false	true
5b877700-df30-4f41-abde-0b1a39d6756c	2026-08-24 10:25	2026-08-24 10:25	2026-08-24 10:25	CCL	CCL270115P00023000	put	23.0000	2027-01-15	1.4700	1.4200	1.4800	25.8300	12479.00	12332.00	0.00	85	5	801	1839	0.435562805872757	0.458968829137964	0.457640661046452	false	false	false	true
3f046c7b-5247-4278-8d61-fb0f70d98d7e	2026-08-24 09:57	2026-08-24 09:57	2026-08-24 09:57	CCL	CCL260918C00031000	call	31.0000	2026-09-18	0.0700	0.0700	0.0800	26.0900	17191.00	216.00	16975.00	2452	30	2488	3091	0.804917502426399	0.403734723021542	0.405584853744655	false	false	false	true
c8b986d0-e265-4f8d-8ec5-fca153fe0c7f	2026-08-21 15:49	2026-08-21 15:49	2026-08-21 15:49	CCL	CCL260828P00027500	put	27.5000	2026-08-28	1.7600	1.6200	1.7600	25.8100	88000.00	88000.00	0.00	500	11	511	420	1.21666666666667	0.393523338355043	0.393523338355043	false	false	false	true
50eb915d-87fd-4512-b1c8-84de16cecd8b	2026-08-21 15:43	2026-08-21 15:43	2026-08-21 15:43	CCL	CCL260828C00027000	call	27.0000	2026-08-28	0.1500	0.1300	0.1600	25.8400	13425.00	12735.00	0.00	895	12	1457	179	8.13966480446927	0.370335285939823	0.369324538948654	false	false	false	true
a594ebd8-92bb-45c1-83a7-f285e2302bc0	2026-08-21 14:03	2026-08-21 14:03	2026-08-21 14:03	CCL	CCL270115P00020000	put	20.0000	2027-01-15	0.7600	0.7100	0.7700	25.0000	25916.00	25916.00	0.00	341	19	1566	14006	0.111809224618021	0.489876458173217	0.489876458173217	false	false	false	true
15afde9d-64a9-4e13-8e9f-a96d4bcd3ae2	2026-08-21 12:18	2026-08-21 12:17	2026-08-21 12:17	CCL	CCL261120C00026000	call	26.0000	2026-11-20	2.1500	2.1500	2.2800	25.6330	10965.00	0.00	10965.00	51	11	289	214	1.35046728971963	0.432258434411544	0.432258434411544	false	false	false	true
f9674fdb-3ed0-40d0-ad61-2e4b5f9951f7	2026-08-21 11:17	2026-08-21 11:17	2026-08-21 11:17	CCL	CCL261120C00026000	call	26.0000	2026-11-20	2.1200	2.1200	2.2600	25.5700	22473.00	213.00	22260.00	106	13	116	214	0.542056074766355	0.432955007768333	0.432955007768333	false	false	false	true
44470d5b-f9ac-40f8-9048-2ab0c3be274a	2026-08-21 10:59	2026-08-21 10:59	2026-08-21 10:59	CCL	CCL260918C00025000	call	25.0000	2026-09-18	1.6100	1.6100	1.6500	25.7550	74865.00	0.00	74865.00	465	5	854	3050	0.28	0.410598625393441	0.410598625393441	true	false	false	true
ee85da75-ce98-427e-827a-ce79a85f5fe5	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	CCL	CCL270115P00022000	put	22.0000	2027-01-15	1.2200	1.2200	1.3200	25.7400	11224.00	0.00	11224.00	92	9	194	9919	0.019558423228148	0.469914545344988	0.469914545344988	false	false	false	true
258e508c-7269-4254-97a5-85fb99fcf71f	2026-08-21 10:51	2026-08-21 10:51	2026-08-21 10:51	CCL	CCL270319P00023000	put	23.0000	2027-03-19	2.0200	2.0100	2.1500	25.7400	10309.00	0.00	10309.00	51	16	51	6080	0.00838815789473684	0.469746009097692	0.469962346240331	true	false	false	true
e9d0b7b8-ca78-485c-8140-a2caba387923	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	CCL	CCL270319C00030000	call	30.0000	2027-03-19	1.8100	1.8100	2.0300	25.3300	18281.00	0.00	18281.00	101	5	659	980	0.672448979591837	0.417749553019905	0.417749553019905	false	false	false	true
23f21c96-f948-4b28-bdbb-e1a2fc4b8058	2026-08-20 15:54	2026-08-20 15:54	2026-08-20 15:54	CCL	CCL270319C00030000	call	30.0000	2027-03-19	1.8900	1.7500	2.0300	25.3250	95009.00	94635.00	374.00	502	45	556	980	0.56734693877551	0.430237657442661	0.430237657442661	true	false	false	true
0bf020d5-904d-479b-8746-cc2f056d9cb9	2026-08-20 15:24	2026-08-20 15:24	2026-08-20 15:24	CCL	CCL270617C00030000	call	30.0000	2027-06-17	2.5000	2.5000	2.5900	25.4078	50000.00	0.00	50000.00	200	6	204	529	0.385633270321361	0.414289961257286	0.414289961257286	false	false	false	true
71fe9198-44d9-4650-891f-6ae7a920a725	2026-08-20 15:17	2026-08-20 15:17	2026-08-20 15:17	CCL	CCL260918P00027000	put	27.0000	2026-09-18	2.2200	2.1100	2.2200	25.2750	17093.00	17093.00	0.00	77	5	1041	12314	0.0845379243137892	0.418330861966094	0.41438597336422	false	false	false	true
c1b33f02-3a66-4a11-8860-12f142dc4e2e	2026-08-20 15:12	2026-08-20 15:11	2026-08-20 15:11	CCL	CCL260918P00027000	put	27.0000	2026-09-18	2.1700	2.1300	2.1800	25.2650	18870.00	18006.00	0.00	87	21	964	12314	0.0782848789995128	0.391690872636847	0.395711924101512	false	false	false	true
2d43a0b6-622f-4d38-b695-3b8d86bfa8b0	2026-08-20 15:01	2026-08-20 15:01	2026-08-20 15:01	CCL	CCL260918P00027000	put	27.0000	2026-09-18	2.2400	2.1600	2.2400	25.2000	19040.00	19040.00	0.00	85	5	789	12314	0.0640734123761572	0.405650874689226	0.405650874689226	false	false	false	true
6b5b68c5-550a-4e54-9ee5-adf69ea77c4b	2026-08-20 14:51	2026-08-20 14:51	2026-08-20 14:51	CCL	CCL260918P00027000	put	27.0000	2026-09-18	2.1300	2.0700	2.1300	25.3497	16827.00	16827.00	0.00	79	12	618	12314	0.0501867792756212	0.402985680511256	0.402985680511256	false	false	false	true
16ae40a1-7ab5-4f41-8904-b5229a27c304	2026-08-20 14:39	2026-08-20 14:39	2026-08-20 14:39	CCL	CCL260904P00028500	put	28.5000	2026-09-04	3.0700	2.8400	3.2000	25.4450	11666.00	10131.00	1535.00	38	7	39	11	3.54545454545455	0.368283515725549	0.368283515725549	false	false	false	true
7cc226b8-c71f-4710-a41b-64c726e80ed2	2026-08-20 14:30	2026-08-20 14:30	2026-08-20 14:30	CCL	CCL260918P00027000	put	27.0000	2026-09-18	2.0200	1.9000	2.0200	25.4800	17170.00	17170.00	0.00	85	14	287	12314	0.0233068052623031	0.394457995263858	0.394457995263858	false	false	false	true
6e6e9aba-1cf3-40a1-89f4-c67d31a19f7e	2026-08-20 14:17	2026-08-20 14:17	2026-08-20 14:17	CCL	CCL261016C00033000	call	33.0000	2026-10-16	0.1700	0.1600	0.1700	25.5050	10302.00	9095.00	0.00	606	23	665	1106	0.60126582278481	0.442792122053327	0.442792122053327	true	false	false	true
5c6ac3a4-b700-4acb-abb2-3d41e05de7d0	2026-08-20 13:57	2026-08-20 13:57	2026-08-20 13:57	CCL	CCL261016C00034000	call	34.0000	2026-10-16	0.1500	0.1000	0.1500	25.5750	13084.00	12559.00	0.00	882	18	883	1168	0.755993150684932	0.463673584496615	0.449497965450121	false	false	false	true
d4655903-be52-4bfa-acf0-3e54d48d6676	2026-08-20 12:37	2026-08-20 12:37	2026-08-20 12:37	CCL	CCL260828C00026000	call	26.0000	2026-08-28	0.4800	0.4500	0.5900	25.7150	13104.00	2832.00	9504.00	273	15	1255	610	2.05737704918033	0.393929159597578	0.3948124845508	true	false	false	true
1f32f207-613b-4b1d-ab16-79404ea8c761	2026-08-20 12:37	2026-08-20 12:37	2026-08-20 12:37	CCL	CCL260828C00026000	call	26.0000	2026-08-28	0.4700	0.4500	0.4700	25.6901	18659.00	18659.00	0.00	397	16	882	610	1.44590163934426	0.39543428619563	0.39543428619563	false	false	false	true
090c2900-9559-49de-90b1-0e0cc01c8696	2026-08-20 12:32	2026-08-20 12:31	2026-08-20 12:31	CCL	CCL270115C00027000	call	27.0000	2027-01-15	2.4000	2.3800	2.4300	25.6456	109440.00	99600.00	9840.00	456	23	928	3483	0.266436979615274	0.429450695677665	0.429450695677665	true	false	false	true
2b990a3d-14fa-48b4-87cc-74b05719fa42	2026-08-20 11:35	2026-08-20 11:35	2026-08-20 11:35	CCL	CCL261120C00022500	call	22.5000	2026-11-20	4.2500	4.2500	4.4000	25.6850	37400.00	0.00	37400.00	88	5	92	12	7.66666666666667	0.444890202941163	0.444890202941163	false	false	false	true
54f79b64-1fde-4f76-a4ba-d836306d8f55	2026-08-20 11:16	2026-08-20 11:16	2026-08-20 11:16	CCL	CCL270319C00032000	call	32.0000	2027-03-19	1.5600	1.5000	1.5600	25.8100	74042.00	40872.00	18135.00	476	19	1985	4070	0.487714987714988	0.426400591739532	0.42453120628595	false	false	false	true
ca068d6d-bdc4-48b7-bd94-9acf5803119c	2026-08-20 11:16	2026-08-20 11:15	2026-08-20 11:15	CCL	CCL270319C00032000	call	32.0000	2027-03-19	1.5400	1.5400	1.5600	25.8050	44814.00	0.00	44814.00	291	17	1473	4070	0.361916461916462	0.423360436433736	0.423360436433736	false	false	false	true
d75e29a9-57c3-497b-b060-a1c603340636	2026-08-20 11:16	2026-08-20 11:15	2026-08-20 11:15	CCL	CCL270319C00032000	call	32.0000	2027-03-19	1.5600	1.5500	1.7100	25.8000	76725.00	0.00	15885.00	492	19	1182	4070	0.29041769041769	0.426400591739532	0.424997712170172	false	false	false	true
d3c871b1-aee3-492c-8218-a7f659f8aea9	2026-08-20 11:15	2026-08-20 11:15	2026-08-20 11:15	CCL	CCL270319C00032000	call	32.0000	2027-03-19	1.5400	1.5300	1.7300	25.7900	45412.00	0.00	9684.00	295	19	640	4070	0.157248157248157	0.424059115966276	0.422652403921459	false	false	false	true
4ed2339e-8f21-4d0e-b375-044bdec61c3f	2026-08-20 11:15	2026-08-20 11:15	2026-08-20 11:15	CCL	CCL270319C00032000	call	32.0000	2027-03-19	1.5200	1.5200	1.7400	25.7850	50920.00	0.00	2888.00	335	17	345	4070	0.0847665847665848	0.421476281028771	0.421476281028771	false	false	false	true
77732aef-3709-4bdd-93ad-76528f75948f	2026-08-20 11:09	2026-08-20 11:09	2026-08-20 11:09	CCL	CCL280121C00025000	call	25.0000	2028-01-21	6.1000	6.0000	6.1000	25.7775	12200.00	12200.00	0.00	20	6	26	2023	0.0128521997034108	0.42303031026609	0.42303031026609	false	false	false	true
c0b54762-0112-4d14-83e3-17c1b150d499	2026-08-20 10:35	2026-08-20 10:34	2026-08-20 10:34	CCL	CCL260918P00025000	put	25.0000	2026-09-18	0.7200	0.7200	0.7400	25.8700	10656.00	0.00	10656.00	148	9	725	11160	0.0649641577060932	0.395950006289957	0.395950006289957	true	false	false	true
0aa5e4e9-b81c-487b-899e-7d169424e43b	2026-08-20 10:22	2026-08-20 10:22	2026-08-20 10:22	CCL	CCL270115P00025000	put	25.0000	2027-01-15	2.3300	2.2500	2.3800	25.9350	28659.00	28426.00	233.00	123	13	123	24175	0.00508790072388831	0.460979127778737	0.460979127778737	false	false	false	true
1b96721a-ef5b-46c3-8524-483b67c4f45c	2026-08-20 10:02	2026-08-20 10:01	2026-08-20 10:01	CCL	CCL270115P00023000	put	23.0000	2027-01-15	1.4900	1.4900	1.5200	25.9250	11175.00	0.00	11175.00	75	6	547	1326	0.412518853695324	0.461987588397445	0.46223567904423	false	false	false	true