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

023a01c1-1ba2-4804-9849-8ff25194b30c	2026-08-20 10:01	2026-08-20 10:01	2026-08-20 10:01	CCL	CCL270115P00023000	put	23.0000	2027-01-15	1.5000	1.4900	1.5000	25.8950	27600.00	27600.00	0.00	184	5	353	1326	0.266214177978884	0.462570338192095	0.462570338192095	true	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-20T14:05:52.049536Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
d76077b5-b2c4-4804-bf48-5f311c1e3a77	2026-08-19 15:37	2026-08-19 15:37	2026-08-19 15:37	CCL	CCL270115C00030000	call	30.0000	2027-01-15	1.8800	1.8600	1.9300	26.8000	36631.00	11520.00	25111.00	195	5	264	7847	0.0336434306104244	0.424373907685331	0.432473077099132	true	false	false	true
d95ea27b-3d53-4957-acb7-25681b583eb9	2026-08-19 14:43	2026-08-19 14:43	2026-08-19 14:43	CCL	CCL261016P00026000	put	26.0000	2026-10-16	1.3200	1.3100	1.3500	26.9050	36168.00	396.00	33660.00	274	32	389	1306	0.297856049004594	0.430116411284598	0.430116411284598	false	false	false	true
0803b6f4-3117-4eac-81d3-b3d0534631e9	2026-08-19 13:24	2026-08-19 13:24	2026-08-19 13:24	CCL	CCL261218C00030000	call	30.0000	2026-12-18	1.6500	1.6500	1.7200	27.0300	56595.00	0.00	56595.00	343	9	357	9229	0.0386824141293748	0.424063282346756	0.424063282346756	false	false	false	true
7d7529ec-e7ec-4450-b9f1-b4fe38bc57ff	2026-08-19 12:14	2026-08-19 12:13	2026-08-19 12:13	CCL	CCL261016P00026000	put	26.0000	2026-10-16	1.2500	1.2000	1.2600	27.2850	10374.00	10374.00	0.00	83	26	111	1306	0.0849923430321593	0.446670666184552	0.444179402973343	true	false	false	true
446aa38e-17dd-49da-b00f-f5e1899efabf	2026-08-19 10:56	2026-08-19 10:55	2026-08-19 10:55	CCL	CCL261120C00025000	call	25.0000	2026-11-20	3.9500	3.9500	4.1000	27.5400	39896.00	0.00	39896.00	101	7	102	126	0.80952380952381	0.436747255921269	0.436747255921269	false	false	false	true
f109235f-d9e7-46ea-9561-8f70c045257d	2026-08-19 10:27	2026-08-19 10:26	2026-08-19 10:26	CCL	CCL261120P00026000	put	26.0000	2026-11-20	1.6200	1.6200	1.6700	27.4900	24948.00	0.00	24948.00	154	12	169	927	0.182308522114347	0.447416048479096	0.447416048479096	false	false	false	true
52ffc342-f57b-45c5-beea-a282802eeb41	2026-08-18 15:26	2026-08-18 15:26	2026-08-18 15:26	CCL	CCL260918P00027000	put	27.0000	2026-09-18	1.0400	1.0200	1.0700	27.3150	10608.00	3120.00	7488.00	102	6	229	12010	0.019067443796836	0.390647571722585	0.390647571722585	false	false	false	true
53045619-e173-4f84-9cf1-f593da8eecb4	2026-08-18 14:56	2026-08-18 14:56	2026-08-18 14:56	CCL	CCL270617C00030000	call	30.0000	2027-06-17	3.5000	3.4000	3.5000	27.3381	23800.00	23800.00	0.00	68	8	94	424	0.221698113207547	0.421491465000743	0.421403379982117	false	false	false	true
51daa9c2-4934-4789-9f90-552d63dbb0eb	2026-08-18 14:54	2026-08-18 14:54	2026-08-18 14:54	CCL	CCL261016P00028000	put	28.0000	2026-10-16	2.1600	2.1600	2.2300	27.3150	192888.00	0.00	192888.00	893	30	1093	1268	0.86198738170347	0.428519559656058	0.428519559656058	false	false	false	true
7b7cac1e-fdf9-4b51-b5aa-ce1f149b0414	2026-08-18 13:30	2026-08-18 13:30	2026-08-18 13:30	CCL	CCL260918C00029000	call	29.0000	2026-09-18	0.6100	0.5800	0.6500	27.3050	42212.00	0.00	42212.00	692	50	872	5938	0.146850791512294	0.383119064561125	0.383119064561125	false	false	false	true
c596d263-af68-4a98-baa9-8d8920c0c82e	2026-08-18 11:57	2026-08-18 11:57	2026-08-18 11:57	CCL	CCL260918C00027000	call	27.0000	2026-09-18	1.5500	1.5500	1.5900	27.4750	97030.00	0.00	97030.00	626	44	635	2752	0.230741279069767	0.395172974730385	0.395172974730385	false	false	false	true
b9ace420-5470-4e6f-b589-2adb66add9b5	2026-08-18 10:53	2026-08-18 10:53	2026-08-18 10:53	CCL	CCL260918C00028000	call	28.0000	2026-09-18	1.0900	1.0900	1.1100	27.5050	10246.00	0.00	10246.00	94	16	111	8425	0.0131750741839763	0.398207563774949	0.398207563774949	false	false	false	true
c9036cc5-d551-412a-84b3-b38a56379994	2026-08-18 10:28	2026-08-18 10:28	2026-08-18 10:28	CCL	CCL261016P00024000	put	24.0000	2026-10-16	0.6300	0.5500	0.6300	27.4600	18900.00	18900.00	0.00	300	8	301	3518	0.0855599772598067	0.467490359794993	0.467490359794993	false	false	false	true
2e639742-fbc3-44cc-b337-15bcc95b29fd	2026-08-18 10:04	2026-08-18 10:04	2026-08-18 10:04	CCL	CCL260918P00028000	put	28.0000	2026-09-18	1.5100	1.3800	1.5100	27.4101	820229.00	820080.00	149.00	5432	67	5438	9554	0.569185681389994	0.397320060716831	0.387207635082202	true	false	false	true
2aa93d8c-3130-4675-9725-a64d45362f48	2026-08-17 15:41	2026-08-17 15:41	2026-08-17 15:41	CCL	CCL261120C00027000	call	27.0000	2026-11-20	2.8900	2.8900	3.0500	27.7500	15317.00	0.00	15317.00	53	6	55	649	0.0847457627118644	0.423679267238306	0.423679267238306	false	false	false	true
a7b367ff-7c7b-4ee5-bfd0-781ff4022cf9	2026-08-17 12:38	2026-08-17 12:38	2026-08-17 12:38	CCL	CCL260918C00028000	call	28.0000	2026-09-18	1.1900	1.1900	1.2400	27.7900	11912.00	0.00	11912.00	100	6	405	8048	0.0503230616302187	0.37941402922976	0.382460895861571	false	false	false	true
6718faf9-8c17-4cda-891e-66f17cfd6d32	2026-08-17 12:09	2026-08-17 12:09	2026-08-17 12:09	CCL	CCL261016C00028000	call	28.0000	2026-10-16	1.9200	1.9150	1.9500	27.7650	18048.00	0.00	18048.00	94	12	171	1683	0.101604278074866	0.434285843244244	0.434285843244244	false	false	false	true
f237d779-c940-427b-84e4-cdcf16db205a	2026-08-17 11:05	2026-08-17 11:05	2026-08-17 11:05	CCL	CCL260918C00028000	call	28.0000	2026-09-18	1.2000	1.1900	1.2100	27.8250	11880.00	4200.00	7560.00	99	14	262	8048	0.0325546719681909	0.377027066184206	0.377027066184206	false	false	false	true
5b29cfee-83da-490a-95f7-eccc82dd047e	2026-08-17 10:41	2026-08-17 10:41	2026-08-17 10:41	CCL	CCL261218C00031000	call	31.0000	2026-12-18	1.6500	1.6200	1.6500	27.8450	11385.00	11385.00	0.00	69	12	308	10592	0.0290785498489426	0.416894224169456	0.416894224169456	false	false	false	true
944e493a-fb95-4cd9-b2eb-ae6cbc17d9fe	2026-08-17 10:36	2026-08-17 10:36	2026-08-17 10:36	CCL	CCL261218C00031000	call	31.0000	2026-12-18	1.6500	1.6000	1.6500	27.8200	22770.00	22770.00	0.00	138	33	216	10592	0.020392749244713	0.419113073327019	0.418479226895279	false	false	false	true
0d4ffa17-57b9-4072-933e-907dbe924b67	2026-08-17 09:31	2026-08-17 09:31	2026-08-17 09:31	CCL	CCL260918P00027000	put	27.0000	2026-09-18	0.8600	0.8100	0.9000	27.8000	11524.00	11524.00	0.00	134	5	301	11690	0.025748502994012	0.389860616268709	0.3886781893922	false	false	false	true
e411742f-cdff-4531-979a-b77b8edd82b1	2026-08-17 09:31	2026-08-17 09:31	2026-08-17 09:31	CCL	CCL260918P00027000	put	27.0000	2026-09-18	0.8600	0.7600	0.8600	27.8250	13415.00	13415.00	0.00	156	6	156	11690	0.0133447390932421	0.391040653986343	0.391629782464308	true	false	false	true