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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 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	pricenumeric

8df520bc-5a6d-4c93-bff3-a61e87b90aa3	2026-08-27 15:29	2026-08-27 15:29	2026-08-27 15:29	CCL	CCL261218P00024000	put	24.0000	2026-12-18	1.9100	1.8900	1.9300	24.0000	22920.00	0.00	0.00	120	7	146	828	0.176328502415459	0.463588227834888	0.463588227834888	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-08-27T19:35:44.109119Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
298d8840-9584-449e-9792-df65fc30c70a	2026-08-27 15:32	2026-08-27 15:31	2026-08-27 15:31	CCL	CCL260911C00025000	call	25.0000	2026-09-11	0.7700	0.7200	0.7900	24.0000	38500.00	38500.00	0.00	500	5	524	51	10.2745098039216	0.380503787600129	0.380503787600129	false	false	false	true	false
2d3d45c9-d08c-4475-a767-679d705791e6	2026-08-27 15:32	2026-08-27 15:31	2026-08-27 15:31	CCL	CCL261016C00028000	call	28.0000	2026-10-16	0.6400	0.6200	0.6400	24.0000	19648.00	19648.00	0.00	307	10	547	2126	0.257290686735654	0.438639574017099	0.438639574017099	false	false	false	true	false
d7959320-4b8e-490a-9179-34a793a840a4	2026-08-28 10:36	2026-08-28 10:35	2026-08-28 10:35	CCL	CCL270115P00022000	put	22.0000	2027-01-15	1.2800	1.2800	1.3400	25.0850	11550.00	0.00	11550.00	90	6	427	10190	0.0419038272816487	0.460181736758121	0.458185732417486	false	false	false	true	false
c426d7d4-7370-4227-b352-e7bae65d3c9b	2026-08-28 11:41	2026-08-28 11:40	2026-08-28 11:40	CCL	CCL261120C00026000	call	26.0000	2026-11-20	1.6900	1.6600	1.7000	24.0000	30927.00	30927.00	0.00	183	21	295	964	0.306016597510373	0.424251949014247	0.424251949014247	false	false	false	true	false
9dcf4c06-4442-48b6-b249-92836f74de0c	2026-08-28 12:20	2026-08-28 12:20	2026-08-28 12:20	CCL	CCL261218C00030000	call	30.0000	2026-12-18	0.8800	0.8200	0.8900	24.9150	58080.00	58080.00	0.00	660	6	691	10058	0.0687015311195069	0.430950296322487	0.430950296322487	false	false	false	true	false
390119a2-4d17-437c-875a-1330e5d7946a	2026-08-28 13:29	2026-08-28 13:29	2026-08-28 13:29	CCL	CCL261120P00025000	put	25.0000	2026-11-20	2.0700	2.0400	2.0700	24.7550	55062.00	55062.00	0.00	266	34	291	16946	0.0171721940280892	0.434841923670123	0.434841923670123	false	false	false	true	false
2bb9c9ca-faa5-4611-8798-e3496d6865d2	2026-08-28 13:42	2026-08-28 13:41	2026-08-28 13:41	CCL	CCL270319C00030000	call	30.0000	2027-03-19	1.6100	1.5000	1.7000	24.7950	80421.00	80421.00	0.00	499	5	507	1372	0.369533527696793	0.430626607708454	0.430626607708454	false	false	false	true	false
8ee1d940-5393-4345-a420-a2be34245513	2026-08-28 14:03	2026-08-28 14:03	2026-08-28 14:03	CCL	CCL261016C00028000	call	28.0000	2026-10-16	0.5600	0.5400	0.5600	24.8850	10640.00	10640.00	0.00	190	12	296	2380	0.12436974789916	0.424707541141887	0.424707541141887	false	false	false	true	false
07143e52-a0e5-40fa-9a3a-688bda6c312e	2026-08-28 15:29	2026-08-28 15:29	2026-08-28 15:29	CCL	CCL260828P00028500	put	28.5000	2026-08-28	3.5200	3.5000	3.6000	24.9350	13730.00	2485.00	11245.00	39	5	120	91	1.31868131868132	10.1616991665112	10.1616991665112	false	false	false	true	false
c012b8cb-8734-4fa6-9847-93256dc41628	2026-08-28 15:38	2026-08-28 15:37	2026-08-28 15:37	CCL	CCL260828P00027500	put	27.5000	2026-08-28	2.6500	2.3900	2.7400	24.8450	12720.00	6095.00	6625.00	48	7	129	203	0.635467980295567	2.11932689333131	11.7816385440361	false	false	false	true	false
4eb4811d-1f91-4f32-bd4c-6434616a8d03	2026-08-31 09:45	2026-08-31 09:45	2026-08-31 09:45	CCL	CCL271217C00035000	call	35.0000	2027-12-17	1.9900	1.9800	1.9900	24.0850	24476.00	24278.00	198.00	123	5	202	1390	0.145323741007194	0.417379520284764	0.416375955498092	true	false	false	true	false
f81f537a-faa7-439b-872f-fb8915c52d66	2026-08-31 09:55	2026-08-31 09:54	2026-08-31 09:54	CCL	CCL270115P00024000	put	24.0000	2027-01-15	2.3600	2.3100	2.3700	24.1800	28320.00	28320.00	0.00	120	7	155	1145	0.135371179039301	0.449913732009163	0.449913732009163	false	false	false	true	false
77e174b2-9ae4-4621-967a-003d9500edc3	2026-08-31 10:31	2026-08-31 10:31	2026-08-31 10:31	CCL	CCL270115P00021000	put	21.0000	2027-01-15	1.1300	1.1300	1.1900	24.1350	11752.00	0.00	11752.00	104	5	209	693	0.301587301587302	0.455665360854993	0.455665360854993	false	false	false	true	false
687e9bdd-409f-4f64-b47c-7f6e76ea17fe	2026-08-31 10:31	2026-08-31 10:31	2026-08-31 10:31	CCL	CCL270115P00021000	put	21.0000	2027-01-15	1.1300	1.1300	1.1900	24.1400	23504.00	0.00	23504.00	208	19	417	693	0.601731601731602	0.456454557633398	0.455928559286223	false	false	false	true	false
65d22305-6c80-4d9d-9de3-f95322e54467	2026-08-31 11:13	2026-08-31 11:13	2026-08-31 11:13	CCL	CCL261218C00032000	call	32.0000	2026-12-18	0.3900	0.3900	0.4300	24.1550	19461.00	0.00	19461.00	499	16	668	4471	0.149407291433684	0.425422926847542	0.425422926847542	false	false	false	true	false
456c1ebc-cde7-4c68-b466-65b7319ba5fd	2026-08-31 11:17	2026-08-31 11:17	2026-08-31 11:17	CCL	CCL261120P00025000	put	25.0000	2026-11-20	2.3400	2.3000	2.3700	24.1700	35100.00	3744.00	31356.00	150	7	202	16830	0.0120023767082591	0.439456112807673	0.439456112807673	false	false	false	true	false
852e17c5-96da-40f8-bb02-97cb8c9e2d08	2026-08-31 11:18	2026-08-31 11:17	2026-08-31 11:17	CCL	CCL261218P00020000	put	20.0000	2026-12-18	0.6700	0.6600	0.7100	24.1732	20971.00	6901.00	4020.00	313	37	343	7440	0.0461021505376344	0.463886970099655	0.463886970099655	false	false	false	true	false
51eb542b-aa1a-447d-8577-46c973dd93cf	2026-08-31 11:18	2026-08-31 11:18	2026-08-31 11:18	CCL	CCL261218P00020000	put	20.0000	2026-12-18	0.6700	0.6700	0.7100	24.1750	10251.00	0.00	10251.00	153	27	496	7440	0.0666666666666667	0.463980162189405	0.463980162189405	false	false	false	true	false
20d2e56e-d6d0-41d7-8133-be0786cefa8f	2026-08-31 11:20	2026-08-31 11:20	2026-08-31 11:20	CCL	CCL261218P00023000	put	23.0000	2026-12-18	1.6300	1.6300	1.6800	24.1469	70905.00	0.00	70905.00	435	42	457	592	0.771959459459459	0.445068050403167	0.445068050403167	false	false	false	true	false
39bad80c-e00c-4451-b24e-df4c6c4b3f46	2026-08-31 11:55	2026-08-31 11:55	2026-08-31 11:55	CCL	CCL260918P00024500	put	24.5000	2026-09-18	0.9800	0.9800	1.0400	24.0622	11270.00	0.00	11270.00	115	10	130	153	0.849673202614379	0.357678399822361	0.357678399822361	true	false	false	true	false
82a7de11-212f-48bb-b172-ce4734c9da3c	2026-08-31 12:02	2026-08-31 12:02	2026-08-31 12:02	CCL	CCL261120C00027000	call	27.0000	2026-11-20	0.9600	0.9400	0.9700	24.1050	27744.00	27744.00	0.00	289	16	334	1925	0.173506493506493	0.423217024498539	0.423217024498539	false	false	false	true	false
4467ff03-5fc7-4478-87e3-588df8d9bc0a	2026-08-31 12:35	2026-08-31 12:34	2026-08-31 12:34	CCL	CCL280121P00015000	put	15.0000	2028-01-21	1.1500	1.1300	1.2000	24.0650	11500.00	0.00	11500.00	100	7	301	3006	0.100133067198935	0.516825607644463	0.516825607644463	false	false	false	true	false
fab30102-4621-4520-9ec6-ca3bff5a046b	2026-08-31 12:35	2026-08-31 12:35	2026-08-31 12:35	CCL	CCL280121P00015000	put	15.0000	2028-01-21	1.1500	1.1300	1.2000	24.0698	11500.00	0.00	11500.00	100	7	401	3006	0.133399866932801	0.516926803791544	0.516926803791544	false	false	false	true	false
c34c4e1d-104b-49fd-883b-6cfe764d8747	2026-08-31 12:35	2026-08-31 12:35	2026-08-31 12:35	CCL	CCL280121P00015000	put	15.0000	2028-01-21	1.1500	1.1300	1.2000	24.0650	11510.00	0.00	11510.00	100	6	501	3006	0.166666666666667	0.516825607644463	0.51859317527721	false	false	false	true	false
8a8ba438-6430-479b-a323-7e8517c7f94f	2026-08-31 12:36	2026-08-31 12:36	2026-08-31 12:36	CCL	CCL280121P00015000	put	15.0000	2028-01-21	1.1500	1.1300	1.2000	24.0650	11500.00	0.00	11500.00	100	5	901	3006	0.299733865602129	0.516825607644463	0.516825607644463	false	false	false	true	false
216bc21c-b147-471c-a0e6-f18b5569fdaf	2026-08-31 12:36	2026-08-31 12:36	2026-08-31 12:36	CCL	CCL280121P00015000	put	15.0000	2028-01-21	1.1500	1.1300	1.2000	24.0750	11530.00	0.00	11530.00	100	6	1001	3006	0.333000665335995	0.518804166517348	0.518804166517348	false	false	false	true	false
36112199-84c2-4052-8c93-b6bc38466d1e	2026-08-31 12:37	2026-08-31 12:36	2026-08-31 12:36	CCL	CCL280121P00015000	put	15.0000	2028-01-21	1.1500	1.1300	1.2000	24.0797	11500.00	0.00	11500.00	100	5	1101	3006	0.36626746506986	0.517135423312319	0.517135423312319	false	false	false	true	false
8a86e20c-31a9-4577-82e3-43c1fad2ab84	2026-08-31 12:37	2026-08-31 12:37	2026-08-31 12:37	CCL	CCL280121P00015000	put	15.0000	2028-01-21	1.1500	1.1300	1.2000	24.0850	11530.00	0.00	11530.00	100	6	1201	3006	0.399534264803726	0.5190150236307	0.5190150236307	false	false	false	true	false
428eeeeb-27a5-4e1b-b105-566b970df373	2026-08-31 13:11	2026-08-31 13:11	2026-08-31 13:11	CCL	CCL261120C00025000	call	25.0000	2026-11-20	1.6000	1.5700	1.6000	24.0450	11840.00	11840.00	0.00	74	17	218	432	0.50462962962963	0.42517875959186	0.42517875959186	false	false	false	true	false
33531ea0-506c-47e7-a3b7-3695a3bffacc	2026-08-31 13:38	2026-08-31 13:38	2026-08-31 13:38	CCL	CCL261016P00023000	put	23.0000	2026-10-16	0.9400	0.9300	0.9600	24.0000	10810.00	1410.00	9400.00	115	9	435	2808	0.15491452991453	0.430420507342265	0.430420507342265	false	false	false	true	false
8a592059-9777-4236-a7a5-71737847734a	2026-08-31 13:39	2026-08-31 13:39	2026-08-31 13:39	CCL	CCL261016P00023000	put	23.0000	2026-10-16	0.9400	0.9200	0.9400	24.0100	24158.00	24158.00	0.00	257	14	692	2808	0.246438746438746	0.431527466812775	0.431527466812775	false	false	false	true	false
32d22dec-ba19-4561-9297-4c1dc4ceb339	2026-08-31 15:20	2026-08-31 15:20	2026-08-31 15:20	CCL	CCL270115C00030000	call	30.0000	2027-01-15	0.8400	0.8000	0.8400	23.9250	42000.00	42000.00	0.00	500	29	1043	8976	0.116198752228164	0.43100498917044	0.43100498917044	false	false	false	true	false
acd49443-63dc-4b3e-a03a-5b0da4b0e312	2026-08-31 15:21	2026-08-31 15:21	2026-08-31 15:21	CCL	CCL270115C00030000	call	30.0000	2027-01-15	0.8400	0.8000	0.8400	23.9300	23016.00	23016.00	0.00	274	16	1367	8976	0.152295008912656	0.43100498917044	0.430735553955385	false	false	false	true	false
81b61e3c-aa88-46da-9314-56aac8a435d7	2026-08-31 15:23	2026-08-31 15:23	2026-08-31 15:23	CCL	CCL270115C00030000	call	30.0000	2027-01-15	0.8500	0.8400	0.8500	23.9450	14960.00	14960.00	0.00	176	6	2532	8976	0.282085561497326	0.432058347129506	0.432058347129506	false	false	false	true	false
598ba1ae-d4f0-4a94-b5d1-80ece69fec4f	2026-08-31 15:23	2026-08-31 15:23	2026-08-31 15:23	CCL	CCL270115C00030000	call	30.0000	2027-01-15	0.8500	0.8400	0.8500	23.9450	48790.00	48790.00	0.00	574	24	2356	8976	0.262477718360071	0.432058347129506	0.432058347129506	false	false	false	true	false
ff086a02-490b-4c57-92ff-f9701a7d2c09	2026-08-31 15:24	2026-08-31 15:24	2026-08-31 15:24	CCL	CCL270115C00030000	call	30.0000	2027-01-15	0.8500	0.8400	0.8500	23.9550	63750.00	63750.00	0.00	750	22	3282	8976	0.365641711229947	0.431518195445127	0.431518195445127	false	false	false	true	false
206a3f2c-f738-473c-807f-e1fe63f46838	2026-08-31 15:26	2026-08-31 15:25	2026-08-31 15:25	CCL	CCL270115C00030000	call	30.0000	2027-01-15	0.8600	0.8400	0.8600	23.9900	64500.00	64500.00	0.00	750	50	4032	8976	0.449197860962567	0.43201691438469	0.43174626926714	false	false	false	true	false
7de9b993-ebcf-4ca7-a9a7-70615dfa3221	2026-08-31 15:31	2026-08-31 15:31	2026-08-31 15:31	CCL	CCL280121C00025000	call	25.0000	2028-01-21	4.8300	4.7000	4.9500	23.9450	34746.00	34746.00	0.00	72	6	134	2143	0.0625291647223518	0.41786839787262	0.416945242080616	false	false	false	true	false
dc59df8b-cbf9-4388-a3b4-fd9dfd44d080	2026-08-31 15:40	2026-08-31 15:40	2026-08-31 15:40	CCL	CCL270115C00030000	call	30.0000	2027-01-15	0.8400	0.8300	0.8500	23.9300	37800.00	37716.00	0.00	450	35	4604	8976	0.512923351158645	0.43100498917044	0.430735553955385	false	false	false	true	false
223da36c-5d55-447e-87be-b0ff21173bc2	2026-08-31 15:41	2026-08-31 15:40	2026-08-31 15:40	CCL	CCL270115C00030000	call	30.0000	2027-01-15	0.8400	0.8300	0.8500	23.9250	33012.00	27888.00	5040.00	393	16	5447	8976	0.60684046345811	0.43100498917044	0.43100498917044	false	false	false	true	false
6d887818-a50f-4551-8593-0fb1f10b981e	2026-08-31 15:42	2026-08-31 15:42	2026-08-31 15:42	CCL	CCL270115C00030000	call	30.0000	2027-01-15	0.8500	0.8400	0.8500	23.9500	38250.00	38250.00	0.00	450	23	5897	8976	0.656974153297683	0.431788260066435	0.431788260066435	false	false	false	true	false
371eee28-cc54-4c80-99d5-16a93360d12e	2026-08-31 15:55	2026-08-31 15:55	2026-08-31 15:55	CCL	CCL260904P00024500	put	24.5000	2026-09-04	0.7700	0.4500	0.9700	23.9750	20251.00	6391.00	10164.00	263	5	515	856	0.601635514018692	0.462850784678613	0.462850784678613	false	false	false	true	false
8feda758-1981-4f03-a915-78847f8262df	2026-09-01 11:23	2026-09-01 11:22	2026-09-01 11:22	CCL	CCL260925P00023000	put	23.0000	2026-09-25	0.6000	0.5800	0.6000	23.6450	12000.00	12000.00	0.00	200	7	206	176	1.17045454545455	0.381304878756349	0.381304878756349	false	false	false	true	false
449c1a36-231d-4b87-85fe-e40305a369bb	2026-09-01 11:34	2026-09-01 11:34	2026-09-01 11:34	CCL	CCL261120C00026000	call	26.0000	2026-11-20	1.0800	1.0500	1.0800	23.6950	32832.00	32832.00	0.00	304	7	306	1172	0.261092150170648	0.422323439504737	0.422323439504737	false	false	false	true	false
d379730a-b8f7-438c-81d9-8203f42ab880	2026-09-01 12:29	2026-09-01 12:29	2026-09-01 12:29	CCL	CCL261218P00020000	put	20.0000	2026-12-18	0.8100	0.7500	0.8100	23.4750	16362.00	16362.00	0.00	202	14	335	7909	0.0423568086989506	0.467161099580887	0.467161099580887	false	false	false	true	false
b72ce351-651d-4c2d-a517-e44826144977	2026-09-01 12:53	2026-09-01 12:53	2026-09-01 12:53	CCL	CCL270115C00030000	call	30.0000	2027-01-15	0.7500	0.7000	0.7500	23.4600	33750.00	33750.00	0.00	450	17	1155	14520	0.0795454545454545	0.439360392412377	0.439360392412377	false	false	false	true	false
0d75f4a7-1b2f-4f92-8690-55c9438dfe9c	2026-09-01 13:07	2026-09-01 13:07	2026-09-01 13:07	CCL	CCL261016P00022000	put	22.0000	2026-10-16	0.7800	0.7700	0.7900	23.4300	98358.00	98202.00	0.00	1261	21	1435	4599	0.312024353120244	0.446533914966574	0.447063313326817	false	false	false	true	false
e19155a1-a84b-4f28-885a-d42a39ce74f4	2026-09-01 13:20	2026-09-01 13:20	2026-09-01 13:20	CCL	CCL260918C00025000	call	25.0000	2026-09-18	0.2500	0.2400	0.2800	23.4222	112350.00	25.00	112300.00	4494	56	4794	4304	1.11384758364312	0.377340792186302	0.380171648661057	false	false	false	true	false
92baf9a3-521a-4dc6-92af-17f4704e89e7	2026-09-01 13:44	2026-09-01 13:44	2026-09-01 13:44	CCL	CCL260911P00023000	put	23.0000	2026-09-11	0.3900	0.3400	0.4000	23.4250	28665.00	28587.00	78.00	735	39	786	225	3.49333333333333	0.383441523523231	0.383441523523231	true	false	false	true	false