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

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	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-31T16:39:59.140702Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
ad504839-5d0d-4eaf-ab54-940eee393daa	2026-08-27 15:10	2026-08-27 15:09	2026-08-27 15:09	CCL	CCL270319C00030000	call	30.0000	2027-03-19	1.8800	1.5200	1.8800	25.0400	28161.00	20868.00	7293.00	150	8	154	1226	0.125611745513866	0.450734754472942	0.450734754472942	false	false	false	true
951b0267-148f-4b29-a6ee-6c95fd460e0a	2026-08-27 14:31	2026-08-27 14:31	2026-08-27 14:31	CCL	CCL270115C00027000	call	27.0000	2027-01-15	2.0500	1.9500	2.0800	25.0650	10455.00	10455.00	0.00	51	5	61	5073	0.0120244431302977	0.430218993210295	0.430218993210295	false	false	false	true
ae72067b-326f-4a86-8b96-3edfd9b9a636	2026-08-27 13:13	2026-08-27 13:13	2026-08-27 13:13	CCL	CCL261218C00030000	call	30.0000	2026-12-18	0.9500	0.9400	1.0100	25.2450	62998.00	0.00	62998.00	660	6	692	9448	0.0732430143945809	0.426275648140945	0.426275648140945	false	false	false	true
cf46ce14-99af-410d-813f-2cf3f5e9c320	2026-08-27 12:33	2026-08-27 12:32	2026-08-27 12:32	CCL	CCL270617P00020000	put	20.0000	2027-06-17	1.5500	1.5500	1.6800	25.2950	21700.00	0.00	21700.00	140	5	426	1964	0.216904276985743	0.482191096885269	0.482191096885269	false	false	false	true
703ed332-0c13-4f53-adba-999d5b521c51	2026-08-27 12:32	2026-08-27 12:32	2026-08-27 12:32	CCL	CCL270617P00020000	put	20.0000	2027-06-17	1.5500	1.5500	1.6900	25.3001	21700.00	0.00	21700.00	140	5	286	1964	0.145621181262729	0.482352243133504	0.482352243133504	false	false	false	true
7a1a69cd-80a0-41cb-ad5b-0a7e7edb64cb	2026-08-27 12:32	2026-08-27 12:32	2026-08-27 12:32	CCL	CCL270617P00020000	put	20.0000	2027-06-17	1.5500	1.5400	1.6900	25.3000	21080.00	0.00	21080.00	136	7	146	1964	0.0743380855397149	0.482349084002936	0.482349084002936	false	false	false	true
9d2e1ec1-49d6-4384-a162-60c06a9e4c27	2026-08-26 14:44	2026-08-26 14:44	2026-08-26 14:44	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.9300	0.9600	25.7601	18905.00	11780.00	7125.00	199	10	9196	10925	0.841739130434783	0.434491272881996	0.434485524547482	true	false	false	true
21e9458c-a20a-4ccd-8a16-4cba2b8f763b	2026-08-26 14:44	2026-08-26 14:44	2026-08-26 14:44	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.9300	0.9600	25.7650	53485.00	39235.00	14250.00	563	26	8997	10925	0.823524027459954	0.434203861946652	0.434203861946652	true	false	false	true
49d39cf8-52d0-4b9a-aaba-7d77bb25fca1	2026-08-26 14:41	2026-08-26 14:41	2026-08-26 14:41	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.8900	0.9600	25.7600	21090.00	5700.00	15390.00	222	11	8359	10925	0.76512585812357	0.434491272881996	0.434491272881996	false	false	false	true
3d705530-0215-4034-ad5f-901f533a7060	2026-08-26 14:41	2026-08-26 14:41	2026-08-26 14:41	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.9300	0.9600	25.7550	33915.00	14535.00	9785.00	357	22	8122	10925	0.743432494279176	0.434778695657908	0.434778695657908	true	false	false	true
7fbe2ae1-eac0-447d-8ace-dc4b9da37447	2026-08-26 14:34	2026-08-26 14:34	2026-08-26 14:34	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.9500	0.9600	25.7850	13965.00	0.00	13965.00	147	10	6647	10925	0.608421052631579	0.433054335222749	0.433054335222749	false	false	false	true
06ba81f6-8637-4d96-ac7a-156d8e037842	2026-08-26 14:31	2026-08-26 14:31	2026-08-26 14:31	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.9300	0.9600	25.7650	10830.00	8930.00	1900.00	114	7	6353	10925	0.581510297482838	0.434203861946652	0.434203861946652	true	false	false	true
3bfd8c24-2fcb-41b3-8575-dbc35c0f5e42	2026-08-26 14:29	2026-08-26 14:29	2026-08-26 14:29	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.9000	0.9600	25.7750	11875.00	2375.00	9500.00	125	6	5964	10925	0.545903890160183	0.433629075320211	0.433629075320211	false	false	false	true
3492281c-6322-4685-9bb7-86ca77494a28	2026-08-26 14:28	2026-08-26 14:28	2026-08-26 14:28	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.8900	0.9700	25.7750	18715.00	18715.00	0.00	197	15	5775	10925	0.528604118993135	0.433629075320211	0.433629075320211	true	false	false	true
155a59d6-669a-4a34-8f25-be30f45f106a	2026-08-26 14:25	2026-08-26 14:25	2026-08-26 14:25	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.8900	0.9600	25.7800	15580.00	9025.00	6555.00	164	14	5553	10925	0.508283752860412	0.433341699490155	0.433341699490155	true	false	false	true
3f1c7efe-4770-4dfb-aac6-7a8b97e34b50	2026-08-26 14:25	2026-08-26 14:25	2026-08-26 14:25	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.8900	0.9600	25.7800	17195.00	17195.00	0.00	181	20	5230	10925	0.478718535469108	0.433341699490155	0.433341699490155	true	false	false	true
39c7449b-e324-491e-b122-1a7a3084017d	2026-08-26 14:25	2026-08-26 14:25	2026-08-26 14:25	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.8900	0.9600	25.7800	15105.00	13205.00	1900.00	159	12	5389	10925	0.493272311212815	0.433341699490155	0.433341699490155	true	false	false	true
ba310bb0-0a0d-4cae-a7b9-8afce44234e9	2026-08-26 14:25	2026-08-26 14:25	2026-08-26 14:25	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.8900	0.9700	25.7950	25365.00	14250.00	1995.00	267	15	4993	10925	0.457025171624714	0.432479641096947	0.432479641096947	true	false	false	true
40aece82-f0b3-4a2c-8e37-c6822fefc298	2026-08-26 14:22	2026-08-26 14:22	2026-08-26 14:22	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9500	0.9200	0.9600	25.7950	18141.00	15006.00	3135.00	191	33	4209	10925	0.385263157894737	0.433629075320211	0.432479641096947	true	false	false	true
9f31f455-425d-493f-a808-585aa1ea83d6	2026-08-26 14:08	2026-08-26 14:08	2026-08-26 14:08	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9200	0.8700	0.9500	25.7450	276000.00	276000.00	0.00	3000	40	4000	10925	0.366132723112128	0.428824566778929	0.429104167875097	true	false	false	true
5c10dd94-cb85-416b-8a48-ce912ef32fec	2026-08-26 13:51	2026-08-26 13:51	2026-08-26 13:51	CCL	CCL261218C00031000	call	31.0000	2026-12-18	0.9000	0.8400	0.9000	25.7200	90000.00	90000.00	0.00	1000	11	1000	10925	0.091533180778032	0.426899431496432	0.426331563205833	true	false	false	true
d9826116-e9bb-480c-a95a-5410384ee791	2026-08-26 11:04	2026-08-26 11:04	2026-08-26 11:04	CCL	CCL260828C00025500	call	25.5000	2026-08-28	0.5300	0.5000	0.5700	25.7850	39379.00	0.00	39379.00	743	9	831	239	3.47698744769874	0.484354894141233	0.484354894141233	false	false	false	true
09de4b38-a747-41fd-91e4-5bda7f4a1e5e	2026-08-25 15:58	2026-08-25 15:58	2026-08-25 15:58	CCL	CCL260828C00026500	call	26.5000	2026-08-28	0.2600	0.2200	0.2700	26.0850	10452.00	8944.00	1508.00	402	23	2244	1446	1.55186721991701	0.455808385296791	0.455808385296791	false	false	false	true
ebe3cdf2-42bc-4b84-bc07-f37667dcba05	2026-08-25 15:56	2026-08-25 15:56	2026-08-25 15:56	CCL	CCL261016C00028000	call	28.0000	2026-10-16	0.9400	0.8700	0.9400	25.9200	11750.00	11750.00	0.00	125	5	469	1925	0.243636363636364	0.429649759351082	0.429649759351082	false	false	false	true
2b42190c-22d4-4b9d-a287-6d26efd5cebe	2026-08-25 11:54	2026-08-25 11:54	2026-08-25 11:54	CCL	CCL261120C00029000	call	29.0000	2026-11-20	1.1700	1.1400	1.1700	26.0150	25389.00	25389.00	0.00	217	15	220	720	0.305555555555556	0.427946748938614	0.427946748938614	false	false	false	true
c5279a22-4cc1-4f74-81d4-f93c56fe5535	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.0250	43500.00	23925.00	0.00	100	6	1602	2522	0.635210150674068	0.457096086418902	0.457096086418902	false	false	false	true
d297d65c-03d4-4e95-a4f0-2fc9e6b2ef75	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	35670.00	30450.00	0.00	82	5	1284	2522	0.509119746233148	0.456152338690167	0.456152338690167	false	false	false	true