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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 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

a1d8829c-635d-4f89-9125-15cc3bbb64fd	2026-09-23 15:24	2026-09-23 15:24	2026-09-23 15:24	CCL	CCL261023P00023000	put	23.0000	2026-10-23	1.8000	1.7900	1.8400	21.8650	27000.00	2700.00	24300.00	150	11	263	366	0.718579234972678	0.467354552675952	0.467354552675952	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Consumer Cyclical	29858350794.00	2026-09-29	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:25:57.460829Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
cd028e31-c480-41f5-a301-eac6448f3547	2026-09-23 14:55	2026-09-23 14:55	2026-09-23 14:55	CCL	CCL261218P00019000	put	19.0000	2026-12-18	0.7500	0.7400	0.7600	21.8150	15000.00	10125.00	0.00	200	5	316	308	1.02597402597403	0.480315962045592	0.480315962045592	false	false	false	true
cea32fa1-a06e-45dd-8e47-45b9762409de	2026-09-23 14:55	2026-09-23 14:55	2026-09-23 14:55	CCL	CCL261218P00020000	put	20.0000	2026-12-18	1.0800	1.0600	1.0800	21.8190	18792.00	18792.00	0.00	174	27	3290	12668	0.259709504262709	0.478205624865782	0.478205624865782	false	false	false	true
58b245df-35cb-4c88-9b39-5c0770e02fd8	2026-09-23 14:08	2026-09-23 14:08	2026-09-23 14:08	CCL	CCL261120C00020000	call	20.0000	2026-11-20	2.8200	2.6600	2.8200	21.8650	11272.00	9024.00	2248.00	40	6	194	2217	0.0875056382498872	0.493109814911479	0.493109814911479	false	false	false	true
46cddcf2-ae51-4b3c-80a8-7bb669400b57	2026-09-23 13:48	2026-09-23 13:48	2026-09-23 13:48	CCL	CCL261002C00023000	call	23.0000	2026-10-02	0.4600	0.4600	0.4800	21.0000	22862.00	0.00	22862.00	497	26	1435	2946	0.487101154107264	0.647057193101458	0.647057193101458	false	false	false	true
4c0ea9ef-b7b8-4a1e-a8b3-035a9458f7bc	2026-09-23 11:58	2026-09-23 11:58	2026-09-23 11:58	CCL	CCL270617P00020000	put	20.0000	2027-06-17	2.2500	2.2500	2.3400	21.9300	17776.00	0.00	17776.00	79	22	229	2737	0.0836682499086591	0.485339788931876	0.483819548527129	false	false	false	true
013553f9-9a15-4328-968d-c4ad98e045e3	2026-09-23 11:58	2026-09-23 11:58	2026-09-23 11:58	CCL	CCL270617P00020000	put	20.0000	2027-06-17	2.2600	2.2500	2.3600	21.9400	11528.00	229.00	11299.00	51	22	101	2737	0.0369017172086226	0.48428419063401	0.490364168637875	false	false	false	true
a37222db-65cd-4f3f-aeb5-6886ebacecec	2026-09-23 11:47	2026-09-23 11:46	2026-09-23 11:46	CCL	CCL261218C00021000	call	21.0000	2026-12-18	2.4300	2.4100	2.4900	21.0000	12150.00	0.00	12150.00	50	5	162	76	2.13157894736842	0.449463754561152	0.449463754561152	false	false	false	true
f2ba937f-70fe-404e-95b4-e83e07715b6a	2026-09-23 11:36	2026-09-23 11:36	2026-09-23 11:36	CCL	CCL270319P00020000	put	20.0000	2027-03-19	1.7400	1.7400	1.8400	21.9100	17400.00	0.00	17400.00	100	10	212	2992	0.070855614973262	0.479168948748016	0.478882247604757	false	false	false	true
5b55626e-f866-4faf-9a26-edcae96a7993	2026-09-23 11:06	2026-09-23 11:06	2026-09-23 11:06	CCL	CCL261023C00027000	call	27.0000	2026-10-23	0.1200	0.1100	0.1500	21.8950	12672.00	12.00	12660.00	1056	25	1097	40	27.425	0.503303097364563	0.503303097364563	false	false	false	true
b1118f2f-1f93-472f-9d58-ef9b164aac2d	2026-09-23 10:49	2026-09-23 10:49	2026-09-23 10:49	CCL	CCL261016P00021000	put	21.0000	2026-10-16	0.6900	0.6900	0.7300	21.7750	16560.00	0.00	16560.00	240	17	494	2081	0.237385872176838	0.492321228577565	0.492321228577565	false	false	false	true
746df8a1-8328-400d-a032-fc1ab5d60a67	2026-09-23 10:47	2026-09-23 10:47	2026-09-23 10:47	CCL	CCL261218P00020000	put	20.0000	2026-12-18	1.1300	1.1000	1.1300	21.7450	24840.00	22600.00	2240.00	220	23	2991	12668	0.236106725607831	0.485760399566587	0.483048806277159	false	false	false	true
d40fcd72-b277-44b0-9eaa-78ff60da893e	2026-09-23 10:35	2026-09-23 10:35	2026-09-23 10:35	CCL	CCL261218P00022000	put	22.0000	2026-12-18	2.0400	2.0300	2.0700	21.7450	20395.00	0.00	15065.00	100	6	105	19965	0.00525920360631104	0.47789701324659	0.482674712604704	false	false	false	true
d2f84c88-8fe1-4979-93ce-cb065dcc0bd2	2026-09-22 15:34	2026-09-22 15:34	2026-09-22 15:34	CCL	CCL270115C00025000	call	25.0000	2027-01-15	1.3700	1.3200	1.3700	22.2750	14796.00	14796.00	0.00	108	15	459	4897	0.0937308556258934	0.453850190143383	0.453850190143383	false	false	false	true
9688cb89-0734-4b8a-98a4-db022f49ff16	2026-09-22 15:34	2026-09-22 15:34	2026-09-22 15:34	CCL	CCL270115C00025000	call	25.0000	2027-01-15	1.3500	1.3200	1.3500	22.2550	11070.00	11070.00	0.00	82	19	351	4897	0.0716765366550949	0.451313041983042	0.451313041983042	false	false	false	true
7237f8b1-b21e-4d6a-978e-8da86479694a	2026-09-22 15:25	2026-09-22 15:25	2026-09-22 15:25	CCL	CCL261218C00024000	call	24.0000	2026-12-18	1.3700	1.3000	1.3800	22.2900	35960.00	7639.00	28321.00	263	10	1264	2916	0.433470507544582	0.451316148441895	0.449476611828426	false	false	false	true
57538655-b041-44dc-ac47-a02ff79d96d9	2026-09-22 15:25	2026-09-22 15:25	2026-09-22 15:25	CCL	CCL261218C00024000	call	24.0000	2026-12-18	1.3700	1.2900	1.3800	22.2950	16440.00	274.00	1233.00	120	8	745	2916	0.255486968449931	0.451316148441895	0.451316148441895	true	false	false	true
d887d5b1-cc4b-4d6b-830e-9c667491f6ac	2026-09-22 15:24	2026-09-22 15:24	2026-09-22 15:24	CCL	CCL261218C00024000	call	24.0000	2026-12-18	1.3700	1.2900	1.3700	22.2900	13562.00	13562.00	0.00	99	6	590	2916	0.202331961591221	0.449476611828426	0.451817944651965	false	false	false	true
1ae828d1-a92c-4659-be70-e3f8aa2c5179	2026-09-22 15:24	2026-09-22 15:24	2026-09-22 15:24	CCL	CCL261218C00024000	call	24.0000	2026-12-18	1.3700	1.3300	1.3700	22.2950	15344.00	15344.00	0.00	112	5	392	2916	0.13443072702332	0.451316148441895	0.451316148441895	false	false	false	true
5caa7c84-9b3e-4f6b-820c-95c74c5dc236	2026-09-22 15:24	2026-09-22 15:24	2026-09-22 15:24	CCL	CCL261218C00024000	call	24.0000	2026-12-18	1.3700	1.3200	1.3700	22.2900	15478.00	15478.00	0.00	113	9	274	2916	0.0939643347050754	0.447134388850488	0.451817944651965	false	false	false	true
31458a0d-44f0-4e7c-8f1a-e8c709df03f1	2026-09-22 15:21	2026-09-22 15:21	2026-09-22 15:21	CCL	CCL260925C00022000	call	22.0000	2026-09-25	0.4700	0.4000	0.5100	22.1600	29375.00	29375.00	0.00	625	12	1162	1253	0.927374301675978	0.476698230852486	0.476698230852486	true	false	false	true
e36913f0-d813-402d-94da-cf5ec8c5f929	2026-09-22 15:15	2026-09-22 15:15	2026-09-22 15:15	CCL	CCL261120C00025000	call	25.0000	2026-11-20	0.7000	0.6500	0.7000	22.1850	24290.00	24290.00	0.00	347	14	556	1290	0.431007751937985	0.45400384969315	0.45400384969315	false	false	false	true
d7524d4d-a900-4ba2-84de-4f5a60f1e530	2026-09-22 15:03	2026-09-22 15:02	2026-09-22 15:02	CCL	CCL261016C00023000	call	23.0000	2026-10-16	0.8200	0.7900	0.8200	22.2950	16400.00	1886.00	0.00	200	22	2278	8119	0.280576425668186	0.481360268913749	0.481360268913749	false	false	false	true
4d7f0653-c6c0-4fc7-bbea-54aff090dcbc	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	CCL	CCL261120C00021000	call	21.0000	2026-11-20	2.6400	2.5000	2.6400	22.6050	83688.00	83688.00	0.00	317	14	340	288	1.18055555555556	0.46598928653269	0.46598928653269	false	false	false	true
1fba175e-8f7a-4886-8ae2-8f6253e07d7e	2026-09-22 13:52	2026-09-22 13:52	2026-09-22 13:52	CCL	CCL261120C00022500	call	22.5000	2026-11-20	1.7800	1.7200	1.7800	22.6050	81700.00	81346.00	354.00	459	14	845	1543	0.547634478289047	0.458326146991332	0.455535484952654	false	false	false	true
29beecb0-ddb1-4815-9338-64fa7d514f6f	2026-09-22 13:45	2026-09-22 13:45	2026-09-22 13:45	CCL	CCL261009C00022500	call	22.5000	2026-10-09	1.1100	1.0600	1.1100	22.5850	11100.00	11100.00	0.00	100	9	411	887	0.463359639233371	0.539512850970891	0.539512850970891	true	false	false	true
0e095630-ca09-42c9-96cd-3c297d07a4f7	2026-09-22 12:25	2026-09-22 12:25	2026-09-22 12:25	CCL	CCL280121C00030000	call	30.0000	2028-01-21	2.6500	2.6000	2.7300	22.5799	13235.00	0.00	13235.00	50	6	520	6210	0.0837359098228663	0.428670139470197	0.428670139470197	false	false	false	true
5d59a1f4-21be-4e1d-beac-53bfd479072f	2026-09-22 12:24	2026-09-22 12:24	2026-09-22 12:24	CCL	CCL270115P00020000	put	20.0000	2027-01-15	1.0700	1.0700	1.1100	22.5800	27392.00	0.00	27392.00	256	7	315	20930	0.0150501672240803	0.467993932301301	0.467993932301301	false	false	false	true
1aa9541c-d76c-4478-8494-a05898368379	2026-09-22 10:00	2026-09-22 09:59	2026-09-22 09:59	CCL	CCL270917C00030000	call	30.0000	2027-09-17	2.0800	1.8800	2.2700	22.0000	20752.00	10816.00	9936.00	100	6	100	768	0.130208333333333	0.433313815190976	0.433313815190976	false	false	false	true
ff6bd8e3-7500-41c9-9ba4-a63b8ea34fd3	2026-09-22 09:49	2026-09-22 09:48	2026-09-22 09:48	CCL	CCL260925C00023000	call	23.0000	2026-09-25	0.4400	0.4400	0.4800	23.0750	10912.00	0.00	10912.00	248	34	1286	4464	0.288082437275986	0.470501801489397	0.477055257420082	false	false	false	true
1d906319-28c4-4829-9bc2-401503a4374b	2026-09-22 09:42	2026-09-22 09:42	2026-09-22 09:42	CCL	CCL260925C00023000	call	23.0000	2026-09-25	0.5200	0.5100	0.5600	23.2100	12792.00	780.00	7904.00	246	44	961	4464	0.215277777777778	0.481090828317024	0.481090828317024	false	false	false	true
3886e5ea-27b1-4680-9de8-e9670ab18707	2026-09-22 09:39	2026-09-22 09:38	2026-09-22 09:38	CCL	CCL261016C00023000	call	23.0000	2026-10-16	1.3500	1.3100	1.3500	23.2750	14985.00	14985.00	0.00	111	13	872	8119	0.10740238945683	0.497416189662759	0.497416189662759	true	false	false	true
532ba662-33cf-40de-a771-c53f18734c17	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	CCL	CCL261016C00023000	call	23.0000	2026-10-16	1.3500	1.2300	1.3500	23.2000	27000.00	27000.00	0.00	200	11	559	8119	0.0688508436999631	0.515490812804502	0.515490812804502	false	false	false	true
3fcb3ee5-67c6-409a-a40f-97e177097417	2026-09-21 15:12	2026-09-21 15:12	2026-09-21 15:12	CCL	CCL261218P00022000	put	22.0000	2026-12-18	1.7100	1.7100	1.7600	22.4000	10602.00	0.00	10602.00	62	9	383	19684	0.0194574273521642	0.464158939113962	0.464158939113962	false	false	false	true
b6510ba7-0d51-4525-864e-d925a2b37366	2026-09-21 15:09	2026-09-21 15:09	2026-09-21 15:09	CCL	CCL270115P00020000	put	20.0000	2027-01-15	1.1400	1.1400	1.1500	22.3850	18468.00	0.00	18468.00	162	13	296	20784	0.0142417244033872	0.470444441228908	0.470444441228908	false	false	false	true
e6116112-32b4-48e8-8143-550893ea238f	2026-09-21 12:30	2026-09-21 12:30	2026-09-21 12:30	CCL	CCL280121C00032000	call	32.0000	2028-01-21	2.2000	2.0000	2.2000	22.0000	750135.00	750135.00	0.00	3410	14	3415	1150	2.9695652173913	0.435756964695964	0.432192341235711	true	false	false	true
941b10e1-f98c-4497-807c-0b0171759b54	2026-09-21 10:51	2026-09-21 10:51	2026-09-21 10:51	CCL	CCL261120C00022500	call	22.5000	2026-11-20	1.5200	1.5100	1.5700	22.2200	15200.00	9120.00	1520.00	100	7	340	1208	0.281456953642384	0.43992724855116	0.43992724855116	false	false	false	true
3ad3d861-4b99-4b20-9719-bffcbc79b02c	2026-09-21 10:30	2026-09-21 10:30	2026-09-21 10:30	CCL	CCL260925P00022500	put	22.5000	2026-09-25	0.5400	0.5400	0.5700	22.2050	10826.00	0.00	10826.00	200	9	2213	448	4.93973214285714	0.411135627883187	0.41892747163808	false	false	false	true
17107687-1f18-4185-87db-18ed3fa923b0	2026-09-18 15:59	2026-09-18 15:59	2026-09-18 15:59	CCL	CCL261120C00020000	call	20.0000	2026-11-20	2.7100	2.7100	2.9500	21.0000	27101.00	0.00	27101.00	100	6	1249	1509	0.827700463883366	0.445376472819664	0.448684932465435	false	false	false	true
1b9a6d05-c545-4457-b483-68fb101fac54	2026-09-18 15:52	2026-09-18 15:52	2026-09-18 15:52	CCL	CCL261016C00023000	call	23.0000	2026-10-16	0.7200	0.6800	0.7400	21.0000	62866.00	33264.00	27658.00	874	71	1434	7169	0.200027897893709	0.466700052077183	0.474522549830849	true	false	false	true
c1ab3495-8908-4f71-a049-2b48e2a3df99	2026-09-18 15:51	2026-09-18 15:51	2026-09-18 15:51	CCL	CCL260918P00022000	put	22.0000	2026-09-18	0.1500	0.1400	0.1500	21.0000	17130.00	17130.00	0.00	1142	18	9517	6930	1.37330447330447	2.03804706701763	2.03804706701763	true	false	false	true
07d8037d-c78c-4e49-8dc1-ccca00383c0a	2026-09-18 15:34	2026-09-18 15:34	2026-09-18 15:34	CCL	CCL260918P00023000	put	23.0000	2026-09-18	1.1400	1.0600	1.1400	21.8900	11400.00	11400.00	0.00	100	6	1076	14202	0.0757639769046613	5.07413971637477	5.07413971637477	false	false	false	true
bb1a6230-add8-48fe-8735-dd1d0f52ec7a	2026-09-18 15:08	2026-09-18 15:08	2026-09-18 15:08	CCL	CCL261002P00022500	put	22.5000	2026-10-02	1.2200	1.2200	1.2500	21.9050	48800.00	0.00	48800.00	400	18	446	152	2.93421052631579	0.526208370304634	0.526208370304634	true	false	false	true
5876ff23-19e0-4254-9b0b-0fa88fb389ab	2026-09-18 15:08	2026-09-18 15:07	2026-09-18 15:07	CCL	CCL260918P00023000	put	23.0000	2026-09-18	1.1000	1.0200	1.1000	21.9150	20790.00	20790.00	0.00	189	22	931	14202	0.0655541473031967	3.00498219395563	3.00498219395563	true	false	false	true
66866f18-bf0d-4c11-aa07-29766a5beea6	2026-09-18 13:30	2026-09-18 13:29	2026-09-18 13:29	CCL	CCL261016P00020000	put	20.0000	2026-10-16	0.3800	0.3600	0.3800	21.9401	13338.00	13338.00	0.00	351	28	655	3730	0.175603217158177	0.478089445575747	0.477496097957058	true	false	false	true
cf476934-c791-401d-b784-f92fd0995224	2026-09-18 12:54	2026-09-18 12:54	2026-09-18 12:54	CCL	CCL270115P00020000	put	20.0000	2027-01-15	1.2700	1.2500	1.3100	22.0000	25019.00	2413.00	22606.00	197	12	265	20155	0.0131481022078889	0.469269896192371	0.469950135667191	false	false	false	true
0d92ebe5-a445-4005-99a2-4d9f2fd70ed2	2026-09-18 11:39	2026-09-18 11:38	2026-09-18 11:38	CCL	CCL261120P00024000	put	24.0000	2026-11-20	2.8400	2.7600	2.9000	21.9550	33512.00	852.00	32660.00	118	15	120	4259	0.0281756280817093	0.459000366759255	0.459000366759255	false	false	false	true
4cbc30d0-c066-417a-a1b7-02e872ad3da3	2026-09-18 11:03	2026-09-18 11:03	2026-09-18 11:03	CCL	CCL260925P00021500	put	21.5000	2026-09-25	0.2700	0.2600	0.2900	21.9550	12204.00	0.00	12204.00	452	6	729	227	3.21145374449339	0.390446480812773	0.390446480812773	false	false	false	true
75d86dc0-a3c3-44fc-ad60-b58ab8eb872d	2026-09-18 10:18	2026-09-18 10:17	2026-09-18 10:17	CCL	CCL280121C00023000	call	23.0000	2028-01-21	4.4000	4.3000	4.4500	21.9100	13200.00	10560.00	2640.00	30	8	70	1335	0.052434456928839	0.426360048122444	0.426360048122444	false	false	false	true
013a1e48-07f8-40b3-9007-c0f6c7f99187	2026-09-18 10:02	2026-09-18 10:02	2026-09-18 10:02	CCL	CCL260918P00022000	put	22.0000	2026-09-18	0.2200	0.2200	0.2700	21.8950	73289.00	0.00	73289.00	3329	46	4015	6930	0.579365079365079	0.846640977542918	0.711570160510961	true	false	false	true