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

0721ef62-3906-496c-ab07-b81240e43ace	2026-09-01 14:42	2026-09-01 14:41	2026-09-01 14:41	CCL	CCL261120C00024000	call	24.0000	2026-11-20	1.7200	1.7000	1.7200	23.3800	49879.00	49879.00	0.00	290	7	418	557	0.750448833034111	0.434406841173513	0.436697180947223	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Consumer Cyclical	30899284125.00	2026-10-05	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-01T18:58:03.753197Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
82376de6-22dd-4760-99f8-27a2c6454f2f	2026-09-01 15:17	2026-09-01 15:17	2026-09-01 15:17	CCL	CCL260918P00024000	put	24.0000	2026-09-18	1.2000	1.1600	1.2000	23.2750	65878.00	62338.00	0.00	550	18	936	34231	0.0273436358856008	0.390037802634142	0.400465121992672	false	false	false	true	false
4bb54242-ddbe-4ff4-8676-4015ef2aeac7	2026-09-01 15:33	2026-09-01 15:33	2026-09-01 15:33	CCL	CCL260918P00022000	put	22.0000	2026-09-18	0.3500	0.3100	0.3500	23.1050	52440.00	51450.00	0.00	1500	43	1646	8955	0.183807928531547	0.39753409702759	0.409770016447849	false	false	false	true	false
de1d39b0-caa8-42b7-b4ab-3753928bfec7	2026-09-01 15:33	2026-09-01 15:33	2026-09-01 15:33	CCL	CCL260918C00024000	call	24.0000	2026-09-18	0.4300	0.4200	0.4600	23.0900	106554.00	0.00	106554.00	2478	6	2789	1011	2.75865479723046	0.389663785297511	0.389663785297511	false	false	false	true	false
76600021-9fb7-4a33-aa71-8d8ac67e31f2	2026-09-01 15:33	2026-09-01 15:33	2026-09-01 15:33	CCL	CCL260904P00023000	put	23.0000	2026-09-04	0.3400	0.3200	0.3500	23.0900	34374.00	34374.00	0.00	1011	6	2247	259	8.67567567567568	0.464051629177871	0.464051629177871	false	false	false	true	false
b5857b6d-4d2c-4dbb-888c-948a88da0422	2026-09-01 15:47	2026-09-01 15:47	2026-09-01 15:47	CCL	CCL261218P00020000	put	20.0000	2026-12-18	0.8800	0.8700	0.9400	23.1850	10990.00	6600.00	4390.00	125	6	7722	7909	0.976356050069541	0.470145068605404	0.468954770691572	false	false	false	true	false
7973b679-47cb-4bd0-95fe-c345cbc2bd60	2026-09-01 15:51	2026-09-01 15:51	2026-09-01 15:51	CCL	CCL270319P00023000	put	23.0000	2027-03-19	2.7800	2.7700	2.8600	23.2150	45036.00	42812.00	2224.00	162	7	289	6670	0.043328335832084	0.461409988495581	0.461409988495581	false	false	false	true	false
8e7dc458-276e-40ab-abbb-7f626f3a9fcb	2026-09-02 11:22	2026-09-02 11:22	2026-09-02 11:22	CCL	CCL260904C00024000	call	24.0000	2026-09-04	0.1600	0.1500	0.1900	23.5805	10384.00	16.00	10368.00	649	18	1328	1492	0.890080428954424	0.46437968862652	0.46437968862652	false	false	false	true	false
a746d4c7-410f-49dd-ae89-ceb08fe31b15	2026-09-02 11:29	2026-09-02 11:29	2026-09-02 11:29	CCL	CCL260918P00024500	put	24.5000	2026-09-18	1.2800	1.2100	1.3400	23.5250	123264.00	123264.00	0.00	963	1	968	251	3.85657370517928	0.358790624545836	0.358790624545836	false	true	false	true	true
53821b82-59b6-4eab-b68a-9b9c8ebe0e6c	2026-09-02 11:45	2026-09-02 11:45	2026-09-02 11:45	CCL	CCL280121C00023000	call	23.0000	2028-01-21	5.4100	5.3000	5.5500	23.5050	18410.00	0.00	18410.00	34	6	105	389	0.269922879177378	0.420993761275479	0.420993761275479	false	false	false	true	false
f6c55794-8a24-4430-8838-4849dcf9c23a	2026-09-02 12:54	2026-09-02 12:54	2026-09-02 12:54	CCL	CCL261120C00025000	call	25.0000	2026-11-20	1.3100	1.2700	1.3100	23.4300	14541.00	14541.00	0.00	111	10	112	686	0.163265306122449	0.428359537861084	0.428359537861084	false	false	false	true	false
2f708154-fa21-4883-a02e-48481e6064c1	2026-09-02 13:05	2026-09-02 13:05	2026-09-02 13:05	CCL	CCL260904P00023500	put	23.5000	2026-09-04	0.3400	0.3000	0.3600	23.4550	28458.00	2958.00	25500.00	837	9	1161	2686	0.432241250930752	0.461015171814113	0.461015171814113	true	false	false	true	false
cb7240f6-e0d5-46b8-b376-f1470297b0ea	2026-09-02 13:49	2026-09-02 13:49	2026-09-02 13:49	CCL	CCL261218C00023000	call	23.0000	2026-12-18	2.6200	2.5500	2.6200	23.5000	10480.00	10480.00	0.00	40	13	46	126	0.365079365079365	0.444888905153717	0.444888905153717	false	false	false	true	false
9e0275dc-583b-4ac4-ae9c-2621b29501a1	2026-09-02 14:17	2026-09-02 14:17	2026-09-02 14:17	CCL	CCL260918P00024000	put	24.0000	2026-09-18	0.9400	0.9400	0.9700	23.5727	10340.00	0.00	10340.00	110	5	286	33952	0.00842365692742696	0.368011041562267	0.368011041562267	false	false	false	true	false
6cb0c1c5-e1e5-49f8-ac94-22261830e63f	2026-09-02 15:12	2026-09-02 15:12	2026-09-02 15:12	CCL	CCL261120P00024000	put	24.0000	2026-11-20	2.0600	2.0100	2.0600	23.5896	16892.00	16892.00	0.00	82	16	155	4154	0.0373134328358209	0.445238944393777	0.445238944393777	false	false	false	true	false
52cd1a12-426d-4b44-b93f-46c6dccc6401	2026-09-02 15:53	2026-09-02 15:53	2026-09-02 15:53	CCL	CCL261016P00022000	put	22.0000	2026-10-16	0.7200	0.7000	0.7300	23.6469	29952.00	29952.00	0.00	416	6	452	4479	0.100915382897968	0.453275990558781	0.453275990558781	false	false	false	true	false
8b400c22-a1b4-4c57-9573-99300c08d326	2026-09-03 10:14	2026-09-03 10:14	2026-09-03 10:14	CCL	CCL280121P00020000	put	20.0000	2028-01-21	2.9100	2.8500	2.9700	23.3250	87009.00	64311.00	0.00	299	84	305	3087	0.0988014253320376	0.497468371720222	0.497468371720222	false	false	false	true	false
bb324c69-e679-48f3-8800-a30dc116900a	2026-09-03 10:17	2026-09-03 10:16	2026-09-03 10:16	CCL	CCL280121P00020000	put	20.0000	2028-01-21	2.8800	2.8300	2.8800	23.3550	43200.00	288.00	0.00	150	29	456	3087	0.147716229348882	0.494928512421761	0.494928512421761	false	false	false	true	false
9f40be90-9264-42b8-aaa5-90a3497a8641	2026-09-03 10:24	2026-09-03 10:24	2026-09-03 10:24	CCL	CCL261016C00025000	call	25.0000	2026-10-16	0.8500	0.8000	0.8600	23.3200	14365.00	12580.00	1785.00	169	11	245	3277	0.0747635032041501	0.456652082625187	0.456652082625187	false	false	false	true	false
df3a945c-6640-4035-b9e3-675aa0d68177	2026-09-03 10:32	2026-09-03 10:31	2026-09-03 10:31	CCL	CCL270617C00030000	call	30.0000	2027-06-17	1.6900	1.5700	1.7600	23.2901	25688.00	13520.00	2028.00	152	42	169	834	0.202637889688249	0.426607702405649	0.426607702405649	false	false	false	true	false
0cce3ba3-3922-4f6f-baaa-9c4e24ead3ae	2026-09-03 11:03	2026-09-03 11:03	2026-09-03 11:03	CCL	CCL261016C00025000	call	25.0000	2026-10-16	0.8200	0.8000	0.8400	23.2900	12300.00	8446.00	1394.00	150	15	445	3277	0.135794934391211	0.44790357012511	0.450323901918876	true	false	false	true	false
f44faff2-354b-44aa-84fc-335a883b187c	2026-09-03 11:24	2026-09-03 11:24	2026-09-03 11:24	CCL	CCL280121C00023000	call	23.0000	2028-01-21	5.2900	5.1000	5.4000	23.3600	15878.00	15878.00	0.00	30	6	35	551	0.0635208711433757	0.419104209320577	0.419104209320577	false	false	false	true	false
449ceaaa-ac66-4622-b332-cc3dfab5bfca	2026-09-03 11:46	2026-09-03 11:46	2026-09-03 11:46	CCL	CCL261120C00024000	call	24.0000	2026-11-20	1.6500	1.6000	1.6500	23.3650	15510.00	15510.00	0.00	94	7	177	1005	0.176119402985075	0.428227070920049	0.428227070920049	true	false	false	true	false
87855d34-d4b1-4023-8565-2dd8ca9af15a	2026-09-03 12:13	2026-09-03 12:13	2026-09-03 12:13	CCL	CCL270319C00024000	call	24.0000	2027-03-19	3.0000	2.8200	3.0000	23.3650	15000.00	15000.00	0.00	50	5	55	95	0.578947368421053	0.446526600598994	0.446526600598994	false	false	false	true	false
e6983be7-66b3-46be-994d-3e3281033fa8	2026-09-03 12:25	2026-09-03 12:25	2026-09-03 12:25	CCL	CCL270115C00025000	call	25.0000	2027-01-15	1.9200	1.8700	1.9200	23.3550	59136.00	59136.00	0.00	308	11	398	4142	0.0960888459681313	0.433823661338978	0.433823661338978	false	false	false	true	false
c343d5e4-01f6-4751-b675-6bb65a88d46d	2026-09-03 12:25	2026-09-03 12:25	2026-09-03 12:25	CCL	CCL261218C00025000	call	25.0000	2026-12-18	1.6000	1.6000	1.6600	23.3550	49563.00	1449.00	48114.00	309	26	328	4266	0.0768870135958744	0.431142906833242	0.42913507928286	false	false	false	true	false
771fcfb3-ad45-48b3-b176-5f219952b96e	2026-09-03 12:50	2026-09-03 12:50	2026-09-03 12:50	CCL	CCL261016C00023000	call	23.0000	2026-10-16	1.6700	1.6700	1.6900	23.3600	78490.00	0.00	78490.00	470	7	1218	275	4.42909090909091	0.450552599175101	0.450552599175101	true	false	false	true	false
4cd22568-45e9-4916-b72d-71a56a9b3a95	2026-09-03 13:48	2026-09-03 13:48	2026-09-03 13:48	CCL	CCL280121C00032000	call	32.0000	2028-01-21	2.5600	2.4400	2.5600	23.3800	25324.00	25324.00	0.00	99	17	99	1081	0.091581868640148	0.425303518513525	0.424361515677624	false	false	false	true	false
f5b20ca1-837d-429b-bbb9-029ee67e998c	2026-09-03 14:13	2026-09-03 14:13	2026-09-03 14:13	CCL	CCL260911C00024000	call	24.0000	2026-09-11	0.2700	0.2600	0.2700	23.3950	13500.00	13500.00	0.00	500	11	869	875	0.993142857142857	0.364576882125531	0.364576882125531	false	false	false	true	false
b7a81068-b934-41c9-b42f-0e052d158e1f	2026-09-03 14:14	2026-09-03 14:13	2026-09-03 14:13	CCL	CCL260911C00024000	call	24.0000	2026-09-11	0.3400	0.2800	0.5100	23.4150	33252.00	9690.00	23562.00	978	8	2782	875	3.17942857142857	0.413613550251187	0.413863414451844	false	false	false	true	false
687fa1dc-52d7-429e-b3a5-1c8d10e039a0	2026-09-03 14:14	2026-09-03 14:13	2026-09-03 14:13	CCL	CCL260911C00024000	call	24.0000	2026-09-11	0.3400	0.2700	0.4600	23.4159	29745.00	29405.00	340.00	884	45	1804	875	2.06171428571429	0.369081959175169	0.42131232443616	true	false	false	true	false
716ad0bb-9d7f-4259-b543-ace76bf50276	2026-09-03 14:53	2026-09-03 14:53	2026-09-03 14:53	CCL	CCL270115C00027000	call	27.0000	2027-01-15	1.3500	1.2800	1.3500	23.4500	20250.00	20250.00	0.00	150	15	158	5966	0.0264834059671472	0.437012581562113	0.437012581562113	false	false	false	true	false
6d48e01e-2934-4625-99dc-cd8f242df39a	2026-09-03 14:54	2026-09-03 14:54	2026-09-03 14:54	CCL	CCL260918P00022000	put	22.0000	2026-09-18	0.2000	0.1800	0.2000	23.4400	20000.00	20000.00	0.00	1000	7	1106	9069	0.121953908920498	0.384334917214581	0.384334917214581	false	false	false	true	false
dc556219-2400-41a1-9b32-858a673add3e	2026-09-03 15:16	2026-09-03 15:16	2026-09-03 15:16	CCL	CCL260911C00024000	call	24.0000	2026-09-11	0.3100	0.3000	0.3100	23.4250	24862.00	24862.00	0.00	802	14	4209	875	4.81028571428571	0.389262057139176	0.387894696242529	false	false	false	true	false
644cb241-e125-4c7e-ba19-115ee02d5d8a	2026-09-03 15:48	2026-09-03 15:48	2026-09-03 15:48	CCL	CCL261120C00024000	call	24.0000	2026-11-20	1.7300	1.7300	1.7500	23.4900	17127.00	0.00	17127.00	99	10	385	1005	0.383084577114428	0.432046386921418	0.432046386921418	true	false	false	true	false
449896ec-73f2-4a81-9b1d-62893b732e66	2026-09-04 09:54	2026-09-04 09:53	2026-09-04 09:53	CCL	CCL261016C00023000	call	23.0000	2026-10-16	1.7400	1.6400	1.8500	23.5150	17400.00	0.00	17400.00	100	9	222	1340	0.165671641791045	0.449239400406368	0.449239400406368	false	false	false	true	false
f7658d55-3943-4c33-9e44-6edbe14e72ce	2026-09-04 11:01	2026-09-04 11:00	2026-09-04 11:00	CCL	CCL270115P00025000	put	25.0000	2027-01-15	3.2000	3.2000	3.2500	23.5550	11520.00	0.00	11520.00	36	9	48	24147	0.0019878245744813	0.45298683613964	0.45298683613964	false	false	false	true	false
a073d74c-60af-456a-9203-1b52c6cdae46	2026-09-04 12:08	2026-09-04 12:08	2026-09-04 12:08	CCL	CCL261120P00024000	put	24.0000	2026-11-20	2.0700	2.0500	2.1100	23.5700	42228.00	2277.00	39951.00	204	10	207	4180	0.0495215311004785	0.450278695672109	0.450278695672109	false	false	false	true	false
cbddabb4-ba6a-4c73-abcc-221a5f4a57c1	2026-09-04 12:23	2026-09-04 12:23	2026-09-04 12:23	CCL	CCL260918P00027000	put	27.0000	2026-09-18	3.4000	3.4000	3.6000	23.6100	23460.00	0.00	23460.00	69	5	131	12109	0.0108183995375341	0.44141000869326	0.425348750083397	true	false	false	true	false
0fd509db-1102-4429-8d76-22f41301b3a3	2026-09-04 12:27	2026-09-04 12:27	2026-09-04 12:27	CCL	CCL261016C00025000	call	25.0000	2026-10-16	0.9300	0.8800	0.9300	23.6200	18600.00	18600.00	0.00	200	12	238	3785	0.0628797886393659	0.450904416632804	0.450904416632804	false	false	false	true	false
b3e07178-daac-4991-8553-ed20f465ea58	2026-09-04 12:30	2026-09-04 12:30	2026-09-04 12:30	CCL	CCL270115C00030000	call	30.0000	2027-01-15	0.7700	0.7400	0.7700	23.5900	34650.00	34650.00	0.00	450	17	573	18649	0.0307255080701378	0.440856455058499	0.440856455058499	false	false	false	true	false
90927797-487b-414a-9f18-8169c725f2fb	2026-09-04 14:34	2026-09-04 14:34	2026-09-04 14:34	CCL	CCL260911C00024000	call	24.0000	2026-09-11	0.2900	0.2700	0.3100	23.5800	62350.00	0.00	62263.00	2150	8	2452	4268	0.574507966260544	0.352957230675795	0.352957230675795	false	false	false	true	false
31cb4722-f636-4fa5-b5ec-44d753482bb6	2026-09-04 15:23	2026-09-04 15:23	2026-09-04 15:23	CCL	CCL260911P00024000	put	24.0000	2026-09-11	0.7300	0.7300	0.7600	23.4900	36500.00	0.00	36500.00	500	14	762	1027	0.741966893865628	0.336142121980206	0.336142121980206	true	false	false	true	false
26d092a6-2632-47d5-95d7-6b12bd5de843	2026-09-04 15:25	2026-09-04 15:25	2026-09-04 15:25	CCL	CCL260911P00024000	put	24.0000	2026-09-11	0.7200	0.7200	0.7600	23.5101	36000.00	0.00	36000.00	500	19	1762	1027	1.71567672833496	0.338872704905958	0.338872704905958	true	false	false	true	false
a6bc2e53-7704-4d3d-a0f3-922633c1bf83	2026-09-08 13:18	2026-09-08 13:17	2026-09-08 13:17	CCL	CCL261016C00024000	call	24.0000	2026-10-16	1.1000	1.1000	1.1600	23.3129	10010.00	0.00	10010.00	91	12	291	1697	0.171479080730701	0.453448755274967	0.453448755274967	false	false	false	true	false
839122a1-d8e1-411a-afce-9cf28df2342b	2026-09-08 14:32	2026-09-08 14:32	2026-09-08 14:32	CCL	CCL261120C00026000	call	26.0000	2026-11-20	0.9800	0.9300	0.9800	23.4850	15190.00	15190.00	0.00	155	6	212	1441	0.147120055517002	0.438216288007312	0.438216288007312	true	false	false	true	false
3656dc07-fbca-4339-9fca-94254792b6fc	2026-09-08 14:32	2026-09-08 14:32	2026-09-08 14:32	CCL	CCL260918C00024000	call	24.0000	2026-09-18	0.4100	0.3900	0.4300	23.4850	16320.00	16278.00	0.00	398	15	946	3560	0.265730337078652	0.407849152218003	0.405467207493939	false	false	false	true	false
8b7bedfb-32af-4c89-a1f6-b9cf17726723	2026-09-08 14:34	2026-09-08 14:34	2026-09-08 14:34	CCL	CCL260918C00024000	call	24.0000	2026-09-18	0.4300	0.4000	0.4400	23.4700	25155.00	9847.00	12470.00	585	20	1550	3560	0.435393258426966	0.416102166564784	0.416102166564784	true	false	false	true	false
bb1d14c1-652c-498b-b934-4e8d62c2477a	2026-09-09 10:24	2026-09-09 10:24	2026-09-09 10:24	CCL	CCL270617C00025000	call	25.0000	2027-06-17	2.8900	2.8500	2.8900	22.0000	25143.00	25143.00	0.00	87	5	211	12248	0.0172273024167211	0.431238831048337	0.431238831048337	false	false	false	true	false
5fc9b652-5cce-41ef-8922-aa40cd334f23	2026-09-09 12:53	2026-09-09 12:52	2026-09-09 12:52	CCL	CCL261016P00021000	put	21.0000	2026-10-16	0.5500	0.5400	0.5600	22.0000	15125.00	14355.00	0.00	275	17	359	1207	0.297431648715824	0.470290792221908	0.470290792221908	false	false	false	true	false