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:source = uw_flow_alerts×ticker = CLF×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

be959f22-bed5-45e1-b63d-23886213e071	2026-09-14 11:32	2026-09-14 11:32	2026-09-14 11:32	CLF	CLF260918P00013000	put	13.0000	2026-09-18	1.2800	1.2700	1.4000	11.7400	25600.00	0.00	25600.00	200	10	3016	10621	0.283965728274174	0.653049843036925	0.653049843036925	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Basic Materials	6646791548.00	2026-10-19	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-14T15:39:52.032222Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
7407393c-482e-43b7-87e8-6d7253f04184	2026-09-14 11:32	2026-09-14 11:32	2026-09-14 11:32	CLF	CLF260918P00013000	put	13.0000	2026-09-18	1.3100	1.2500	1.4000	11.7150	26200.00	6419.00	19781.00	200	6	2816	10621	0.265135109688353	0.691986741088599	0.691986741088599	true	false	false	true
ae5cc0b6-e4d8-43b2-a61c-05dc01722c5f	2026-09-14 11:31	2026-09-14 11:31	2026-09-14 11:31	CLF	CLF260918P00013000	put	13.0000	2026-09-18	1.3100	1.3100	1.4100	11.7100	26224.00	0.00	26224.00	200	9	2216	10621	0.208643253930892	0.720280426019799	0.720280426019799	false	false	false	true
a61e56be-3ce8-4254-b72c-63f6cf2a54e5	2026-09-14 11:07	2026-09-14 11:07	2026-09-14 11:07	CLF	CLF260918P00013000	put	13.0000	2026-09-18	1.2700	1.1500	1.2700	11.7700	76200.00	76200.00	0.00	600	9	1016	10621	0.0956595424159684	0.739458649059623	0.739458649059623	false	false	false	true
3c0cb06d-e699-4f64-909a-a63221f18767	2026-09-14 11:05	2026-09-14 11:05	2026-09-14 11:05	CLF	CLF260918P00013000	put	13.0000	2026-09-18	1.3100	1.2400	1.4400	11.6975	26288.00	0.00	26288.00	200	6	416	10621	0.0391676866585067	0.655999221081036	0.655999221081036	false	false	false	true
7db578ff-40aa-481d-b93a-38f99649a71a	2026-09-11 13:06	2026-09-11 13:06	2026-09-11 13:06	CLF	CLF261218C00013000	call	13.0000	2026-12-18	1.3000	1.2800	1.3000	12.1850	19500.00	19500.00	0.00	150	6	182	7007	0.025974025974026	0.626427194551575	0.626427194551575	false	false	false	true
cfae550f-1c76-475f-890e-e3c6cce977db	2026-09-11 12:41	2026-09-11 12:40	2026-09-11 12:40	CLF	CLF261030C00012500	call	12.5000	2026-10-30	1.0000	0.8600	1.0000	12.1200	10000.00	10000.00	0.00	100	9	100	0	0	0.642192581947217	0.642192581947217	false	false	false	true	false
b49b8a64-89b5-4938-8fc7-77ed599b6ded	2026-09-11 09:40	2026-09-11 09:40	2026-09-11 09:40	CLF	CLF261120C00014000	call	14.0000	2026-11-20	0.6400	0.5800	0.6500	11.7900	17076.00	17076.00	0.00	266	10	291	973	0.299075025693731	0.658111915871152	0.652790740399247	false	false	false	true
00a7011f-1923-4611-8e73-cfd41a222928	2026-09-10 13:07	2026-09-10 13:06	2026-09-10 13:06	CLF	CLF260918C00012000	call	12.0000	2026-09-18	0.2900	0.2900	0.3200	11.7400	19836.00	0.00	19836.00	684	10	1131	20444	0.0553218548229309	0.574900354497957	0.574900354497957	false	false	false	true
0bcd63b6-6675-4948-8e9b-7d70fe5169f8	2026-09-10 11:45	2026-09-10 11:45	2026-09-10 11:45	CLF	CLF261218C00015000	call	15.0000	2026-12-18	0.6400	0.6400	0.6600	11.8950	11136.00	0.00	11136.00	174	23	254	9128	0.0278264680105171	0.628451230096208	0.628451230096208	false	false	false	true
f41991b2-870b-4195-b159-992c1780f94e	2026-09-10 11:14	2026-09-10 11:14	2026-09-10 11:14	CLF	CLF260911C00011000	call	11.0000	2026-09-11	0.9900	0.9600	1.0900	11.9800	19701.00	15147.00	4554.00	199	7	640	624	1.02564102564103	0.928738645224519	0.928738645224519	false	false	false	true
7f438607-69af-476a-9cf4-b4c0cfec9382	2026-09-10 10:47	2026-09-10 10:47	2026-09-10 10:47	CLF	CLF260911C00011000	call	11.0000	2026-09-11	1.0300	0.8400	1.0800	12.0250	44290.00	5150.00	36565.00	430	17	440	624	0.705128205128205	0.835994600508616	0.835994600508616	false	false	false	true
2d71e2fd-227b-4189-b81d-c1a0f47f97b7	2026-09-10 10:14	2026-09-10 10:14	2026-09-10 10:14	CLF	CLF261016C00013000	call	13.0000	2026-10-16	0.4500	0.4500	0.4700	11.7450	72540.00	0.00	72540.00	1612	24	1639	12555	0.130545599362804	0.603718930416289	0.603718930416289	false	false	false	true
293a4233-765f-498f-a240-763f21e047f4	2026-09-10 10:01	2026-09-10 10:01	2026-09-10 10:01	CLF	CLF270319C00015000	call	15.0000	2027-03-19	1.2000	1.2000	1.2300	11.8300	228000.00	0.00	228000.00	1900	15	2000	4647	0.430385194749301	0.624981780415778	0.624981780415778	true	false	false	true
6e2e46cf-189f-4bce-876f-b3b9dd733536	2026-09-10 10:01	2026-09-10 10:01	2026-09-10 10:01	CLF	CLF270319C00015000	call	15.0000	2027-03-19	1.2000	1.1400	1.2000	11.8340	10080.00	5760.00	0.00	84	5	84	4647	0.0180761781794706	0.62449646273543	0.62449646273543	false	false	false	true
c64d3988-3ed9-4b9b-9ec4-2aedeb7ea431	2026-09-09 15:13	2026-09-09 15:12	2026-09-09 15:12	CLF	CLF261120C00014000	call	14.0000	2026-11-20	0.7500	0.7400	0.7600	12.1150	14720.00	14720.00	0.00	195	10	274	544	0.503676470588235	0.641506442844562	0.64643455176439	false	false	false	true
54ab1762-c8e2-4036-af3b-2bbf7b92425a	2026-09-09 12:07	2026-09-09 12:07	2026-09-09 12:07	CLF	CLF260918P00011000	put	11.0000	2026-09-18	0.0900	0.0900	0.1000	12.2300	27252.00	0.00	27252.00	3028	23	3079	3926	0.784258787570046	0.650292817713613	0.650292817713613	false	false	false	true
1f12d188-8ce1-41ec-9e7d-4a3c43be8b72	2026-09-04 13:13	2026-09-04 13:12	2026-09-04 13:12	CLF	CLF261016P00014000	put	14.0000	2026-10-16	2.0000	1.9700	2.0800	12.4250	17200.00	3400.00	3200.00	86	6	125	608	0.205592105263158	0.606989580505529	0.606989580505529	false	false	false	true
6e919d18-56c7-4c52-bbb7-123aaa1c8d89	2026-09-04 12:11	2026-09-04 12:11	2026-09-04 12:11	CLF	CLF261016P00012000	put	12.0000	2026-10-16	0.7500	0.7500	0.7700	12.4150	21907.00	152.00	21755.00	292	10	310	1231	0.25182778229082	0.593521698410063	0.587309778037836	false	false	false	true
5f1bf510-083e-48f3-aa20-4940f1f79f60	2026-09-04 10:53	2026-09-04 10:53	2026-09-04 10:53	CLF	CLF260918C00011000	call	11.0000	2026-09-18	1.4900	1.4900	1.4900	12.3550	33823.00	0.00	0.00	227	7	690	7024	0.0982346241457859	0.609303220342153	0.609303220342153	false	false	false	true
22acd299-effb-4416-85c5-0eb883bf4c39	2026-09-04 10:50	2026-09-04 10:50	2026-09-04 10:50	CLF	CLF260918C00011000	call	11.0000	2026-09-18	1.4800	1.3700	1.4800	12.3300	59200.00	29452.00	0.00	400	5	463	7024	0.0659168564920273	0.628839872558374	0.628839872558374	false	false	false	true
016ea3ac-b31d-409a-a1a9-83852e299830	2026-09-03 14:36	2026-09-03 14:36	2026-09-03 14:36	CLF	CLF270115C00012000	call	12.0000	2027-01-15	2.0100	2.0100	2.0600	12.2850	10653.00	0.00	10653.00	53	6	143	7566	0.0189003436426117	0.611150769510831	0.611150769510831	false	false	false	true
034af352-125d-4e14-ae21-5c2f4ce60242	2026-09-03 12:02	2026-09-03 12:02	2026-09-03 12:02	CLF	CLF261120C00013000	call	13.0000	2026-11-20	1.2400	1.2100	1.2400	12.3600	13392.00	13392.00	0.00	108	5	655	921	0.711183496199783	0.642666676495968	0.642666676495968	false	false	false	true
c1c4c49e-4ea2-4ad1-ada6-cf5bc203aeaf	2026-09-03 12:02	2026-09-03 12:02	2026-09-03 12:02	CLF	CLF261120C00013000	call	13.0000	2026-11-20	1.2300	1.2100	1.2300	12.3400	14145.00	14145.00	0.00	115	14	361	921	0.391965255157438	0.642681009466852	0.642681009466852	false	false	false	true
c808c806-1e43-400e-b1e6-6450dd3bd8a2	2026-09-03 11:43	2026-09-03 11:43	2026-09-03 11:43	CLF	CLF261120P00012000	put	12.0000	2026-11-20	1.2200	1.2000	1.2200	12.3650	12200.00	12200.00	0.00	100	5	222	523	0.424474187380497	0.646332549890931	0.646332549890931	false	false	false	true
9955e479-015d-4ed7-b2dd-f9e9565df66c	2026-09-03 10:35	2026-09-03 10:35	2026-09-03 10:35	CLF	CLF260918C00013000	call	13.0000	2026-09-18	0.3100	0.2800	0.3100	12.2850	12400.00	12400.00	0.00	400	5	861	16453	0.0523308819060354	0.581688988580944	0.581688988580944	false	false	false	true
c13ba17b-b56a-40ff-b9f2-adfa4b1d3b9e	2026-09-02 15:29	2026-09-02 15:28	2026-09-02 15:28	CLF	CLF261016C00012000	call	12.0000	2026-10-16	1.2500	1.2400	1.2600	12.3950	10000.00	6250.00	2500.00	80	8	326	5955	0.0547439126784215	0.599391261958603	0.599391261958603	false	false	false	true
52c6e3ef-f543-4ac2-b731-57482b53a492	2026-09-02 14:55	2026-09-02 14:55	2026-09-02 14:55	CLF	CLF261218C00013000	call	13.0000	2026-12-18	1.4600	1.4100	1.4800	12.2950	29284.00	17908.00	0.00	200	9	627	6931	0.0904631366325206	0.645311918489809	0.630234939150934	false	false	false	true
12f8034f-8987-419c-bffe-377e83c2ece8	2026-09-02 11:21	2026-09-02 11:21	2026-09-02 11:21	CLF	CLF260904C00011500	call	11.5000	2026-09-04	0.7100	0.5800	0.8500	12.1550	11360.00	0.00	11360.00	160	5	387	1930	0.200518134715026	0.697967884456304	0.740808929529152	false	false	false	true
f61d0217-3966-4dec-b3c2-8a0032afc3b1	2026-09-02 10:35	2026-09-02 10:35	2026-09-02 10:35	CLF	CLF261120C00015000	call	15.0000	2026-11-20	0.6400	0.6100	0.6500	12.3450	15364.00	1512.00	63.00	241	5	241	899	0.268075639599555	0.630908552414671	0.635817703182098	false	false	false	true
81efd47d-2785-4420-85ff-886ae8effbe8	2026-09-02 10:13	2026-09-02 10:13	2026-09-02 10:13	CLF	CLF261218C00013000	call	13.0000	2026-12-18	1.4300	1.4300	1.4500	12.2900	14300.00	0.00	14300.00	100	14	118	6931	0.0170249603231857	0.627438125514002	0.627438125514002	false	false	false	true
62704384-2b2e-43e7-a987-f57de9c17a58	2026-09-02 10:09	2026-09-02 10:09	2026-09-02 10:09	CLF	CLF260918P00011000	put	11.0000	2026-09-18	0.1900	0.1700	0.2300	12.2405	19000.00	0.00	19000.00	1000	5	1011	5138	0.196769170883612	0.649692319697091	0.649692319697091	false	false	false	true
a3ba77a3-4dc1-48d7-8420-02e8a47ac458	2026-09-02 10:08	2026-09-02 10:08	2026-09-02 10:08	CLF	CLF261002C00013500	call	13.5000	2026-10-02	0.3600	0.2600	0.5900	12.2100	18120.00	0.00	18120.00	500	5	502	347	1.44668587896254	0.581862413115355	0.581862413115355	false	false	false	true
e67dae98-e2f7-42eb-becf-e87be75c6b91	2026-09-02 09:43	2026-09-02 09:43	2026-09-02 09:43	CLF	CLF261016C00013000	call	13.0000	2026-10-16	0.6200	0.5600	0.6200	11.9150	12958.00	12958.00	0.00	209	9	215	11485	0.0187200696560731	0.613749669490727	0.613749669490727	false	false	false	true
f5678c67-4ee7-44c3-9da9-64d9dee62978	2026-09-01 14:27	2026-09-01 14:27	2026-09-01 14:27	CLF	CLF260904C00012000	call	12.0000	2026-09-04	0.1200	0.1200	0.1400	11.6400	18000.00	0.00	18000.00	1500	9	2494	2612	0.954823889739663	0.608960451140932	0.608960451140932	false	false	false	true
5062af57-aeb5-4481-b514-42b7d3ed7765	2026-09-01 09:58	2026-09-01 09:58	2026-09-01 09:58	CLF	CLF261218C00012000	call	12.0000	2026-12-18	1.2700	1.2700	1.3900	11.3600	19050.00	0.00	19050.00	150	7	278	2250	0.123555555555556	0.600859818723906	0.600859818723906	false	false	false	true
c3f04b0d-ed87-40d8-b99d-e4acf9273c6c	2026-08-31 13:32	2026-08-31 13:32	2026-08-31 13:32	CLF	CLF271217C00022000	call	22.0000	2027-12-17	1.3300	1.2400	1.3300	11.5900	13167.00	13167.00	0.00	99	5	112	144	0.777777777777778	0.645868452616039	0.645868452616039	false	false	false	true
c394e43c-4217-4016-b94a-11bae0c29517	2026-08-28 11:13	2026-08-28 11:13	2026-08-28 11:13	CLF	CLF270617P00008000	put	8.0000	2027-06-17	0.8200	0.8200	0.8800	11.6450	30176.00	0.00	30176.00	368	28	1842	16632	0.110750360750361	0.664771706131054	0.664771706131054	true	false	false	true
330b3e30-453f-454b-924b-194de9dc7d89	2026-08-28 11:13	2026-08-28 11:13	2026-08-28 11:13	CLF	CLF270617P00008000	put	8.0000	2027-06-17	0.8100	0.0000	0.0000	11.6450	1172276.00	0.00	1172276.00	14468	29	15942	16632	0.958513708513709	0	0	true	true	false	true	false
5ec4c58e-5323-4f50-9d82-c4b2b5edf5a3	2026-08-27 11:53	2026-08-27 11:53	2026-08-27 11:53	CLF	CLF261002P00012000	put	12.0000	2026-10-02	0.9800	0.9800	1.0700	11.7250	15974.00	0.00	15974.00	163	22	163	44	3.70454545454545	0.580591338504839	0.580591338504839	false	false	false	true
dc7b1015-a31c-4162-8d58-c33b95185ca4	2026-08-27 10:38	2026-08-27 10:38	2026-08-27 10:38	CLF	CLF261016C00012000	call	12.0000	2026-10-16	0.9700	0.9500	0.9900	11.7500	19400.00	8536.00	5044.00	200	7	421	5682	0.0740936290038719	0.609602544072709	0.608112395874429	false	false	false	true
5e79f285-0539-4304-b483-fe855f573f97	2026-08-27 10:20	2026-08-27 10:20	2026-08-27 10:20	CLF	CLF260911P00011000	put	11.0000	2026-09-11	0.2400	0.2300	0.3200	11.7550	38208.00	24.00	38184.00	1592	35	1592	420	3.79047619047619	0.585155171035629	0.588553762132125	true	false	false	true
4caa9fa4-5f16-4bc0-8a92-41842853f116	2026-08-27 09:58	2026-08-27 09:58	2026-08-27 09:58	CLF	CLF270115P00013000	put	13.0000	2027-01-15	2.5500	2.3500	2.5900	11.6200	11491.00	10980.00	511.00	45	8	45	1727	0.0260567458019687	0.631944302075323	0.635419262741327	false	false	false	true
3c7017e8-21f1-498f-9468-26b5d87174f0	2026-08-26 15:21	2026-08-26 15:21	2026-08-26 15:21	CLF	CLF260918C00012000	call	12.0000	2026-09-18	0.5200	0.5200	0.5600	11.6050	10296.00	0.00	10296.00	198	10	491	20322	0.0241610077748253	0.58311688816767	0.58311688816767	false	false	false	true
97466a90-1709-4ca3-b40f-9dad8bae498b	2026-08-26 12:14	2026-08-26 12:14	2026-08-26 12:14	CLF	CLF261002P00011000	put	11.0000	2026-10-02	0.6000	0.6000	0.6500	11.5750	84300.00	0.00	84300.00	1405	7	1405	21	66.9047619047619	0.611999829326063	0.611999829326063	false	false	false	true
8be45a66-a898-4fb7-8dc9-aa8daf365caf	2026-08-25 12:36	2026-08-25 12:36	2026-08-25 12:36	CLF	CLF270115C00025000	call	25.0000	2027-01-15	0.1300	0.1000	0.1300	11.4150	38597.00	38597.00	0.00	2969	32	3050	14201	0.21477360749243	0.715916077273666	0.715916077273666	true	false	false	true
0f1ca7a0-550e-4397-8432-12959527757f	2026-08-25 12:14	2026-08-25 12:14	2026-08-25 12:14	CLF	CLF261218C00017000	call	17.0000	2026-12-18	0.4100	0.4000	0.4100	11.4100	41082.00	41082.00	0.00	1002	19	1021	4447	0.22959298403418	0.673452939076849	0.671773911796783	true	false	false	true
6923391f-d8da-4292-a131-774ba7a3b8f5	2026-08-25 10:55	2026-08-25 10:55	2026-08-25 10:55	CLF	CLF280121P00012000	put	12.0000	2028-01-21	3.5500	3.5000	3.5500	11.3600	23075.00	23075.00	0.00	65	6	194	3256	0.0595823095823096	0.685298728592306	0.685298728592306	false	false	false	true
2e8eeb41-dcee-472b-b796-5ec1c3d2983d	2026-08-25 09:47	2026-08-25 09:47	2026-08-25 09:47	CLF	CLF260918C00012000	call	12.0000	2026-09-18	0.5100	0.5100	0.5500	11.3800	62781.00	0.00	62781.00	1231	21	1232	18921	0.0651128375878653	0.645010287229818	0.645010287229818	false	false	false	true
fb8900c3-6b5d-44bb-8665-67a454e5a129	2026-08-24 14:08	2026-08-24 14:08	2026-08-24 14:08	CLF	CLF271217C00012000	call	12.0000	2027-12-17	3.2500	3.2500	3.4000	11.2750	46151.00	0.00	46151.00	142	5	369	2376	0.15530303030303	0.649871121965874	0.649871121965874	false	false	false	true