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:alert_rule = RepeatedHits×endpoint = /api/option-trades/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	strike

b32dad4d-ef02-4e8c-b106-4e8941a899f7	2026-09-25 13:45	2026-09-25 13:45	2026-09-25 13:45	CLF	CLF261120C00013000	call	13.0000	2026-11-20	1.0100	1.0100	1.0300	12.3050	18180.00	0.00	18180.00	180	5	284	3052	0.0930537352555701	0.658066787188848	0.658066787188848	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Basic Materials	6949177772.00	2026-10-19	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T17:50:01.932714Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
855d7bb2-7307-42d3-99ac-f1ae05606743	2026-09-25 13:43	2026-09-25 13:42	2026-09-25 13:42	CLF	CLF261002P00014000	put	14.0000	2026-10-02	1.7200	1.7100	1.7800	12.2950	13588.00	1204.00	12384.00	79	14	402	5500	0.0730909090909091	0.564237069349505	0.588429853146384	true	false	false
6aba65b8-1e68-4e9a-a119-5663aea19f14	2026-09-25 12:24	2026-09-25 12:23	2026-09-25 12:23	CLF	CLF261002C00012500	call	12.5000	2026-10-02	0.3100	0.3100	0.3400	12.3250	31000.00	0.00	31000.00	1000	6	1931	1066	1.81144465290807	0.564833169141213	0.564833169141213	false	false	false
a143b791-c49c-4ed9-bced-3050fe979fce	2026-09-25 12:07	2026-09-25 12:07	2026-09-25 12:07	CLF	CLF261016C00013000	call	13.0000	2026-10-16	0.5300	0.5200	0.5300	12.3900	11236.00	11236.00	0.00	212	12	1768	14896	0.118689581095596	0.648723047243214	0.648723047243214	false	false	false
d1a269b2-bb67-434d-86c2-6165d1bbed43	2026-09-25 12:07	2026-09-25 12:06	2026-09-25 12:06	CLF	CLF261016C00013000	call	13.0000	2026-10-16	0.5100	0.4800	0.5100	12.3750	57426.00	57426.00	0.00	1126	34	1245	14896	0.0835794844253491	0.636757991833353	0.636757991833353	false	false	false
fbbab051-676d-47b6-a504-c9df2f174da4	2026-09-25 11:27	2026-09-25 11:27	2026-09-25 11:27	CLF	CLF261016P00012000	put	12.0000	2026-10-16	0.5600	0.5600	0.5800	12.0000	15456.00	0.00	15456.00	276	24	1331	2784	0.47808908045977	0.620530577022905	0.620530577022905	false	false	false
caab6946-7d83-4c28-bf78-82fc90cc5ab8	2026-09-25 10:41	2026-09-25 10:40	2026-09-25 10:40	CLF	CLF270115C00012000	call	12.0000	2027-01-15	1.8900	1.8900	1.9400	12.2830	19089.00	0.00	19089.00	101	26	114	7423	0.015357672100229	0.625919542858379	0.625919542858379	false	false	false
4225d79f-3764-4e05-8ade-17df2445f8b2	2026-09-25 09:30	2026-09-25 09:30	2026-09-25 09:30	CLF	CLF270115C00025000	call	25.0000	2027-01-15	0.1000	0.0600	0.1000	12.3700	15070.00	15070.00	0.00	1507	27	1972	10865	0.181500230096641	0.699789532351965	0.699789532351965	false	false	false
e78b05fa-7343-4baa-a32a-0d8a2860a72b	2026-09-24 15:59	2026-09-24 15:59	2026-09-24 15:59	CLF	CLF261218C00011000	call	11.0000	2026-12-18	2.4100	2.4000	2.4400	12.0000	12050.00	1446.00	10604.00	50	6	1808	1502	1.20372836218375	0.656077668740521	0.656077668740521	true	false	false
0d99ce48-6455-4190-ba67-61caed9a6447	2026-09-24 15:58	2026-09-24 15:58	2026-09-24 15:58	CLF	CLF261218C00013000	call	13.0000	2026-12-18	1.4100	1.4000	1.4200	12.0000	34545.00	34404.00	141.00	245	24	1332	20603	0.0646507790127651	0.646018349146089	0.646018349146089	true	false	false
06d789ca-5bdc-43f4-9ce8-82b6711f33ee	2026-09-24 15:54	2026-09-24 15:54	2026-09-24 15:54	CLF	CLF260925C00012500	call	12.5000	2026-09-25	0.2200	0.2050	0.2350	12.5600	21956.00	21758.00	0.00	998	13	1238	3651	0.339085182141879	0.728278273689573	0.717550005811493	false	false	false
be3c6f68-201b-48d1-9353-df5d30454092	2026-09-24 15:48	2026-09-24 15:48	2026-09-24 15:48	CLF	CLF261218C00011000	call	11.0000	2026-12-18	2.5000	2.5000	2.5200	12.6200	12500.00	0.00	12500.00	50	9	1613	1502	1.07390146471372	0.657372958417425	0.657372958417425	false	false	false
6125ed8b-8237-4c6b-95ec-4e3d81ac9121	2026-09-24 15:20	2026-09-24 15:20	2026-09-24 15:20	CLF	CLF261218C00011000	call	11.0000	2026-12-18	2.5800	2.5700	2.5800	12.0000	23994.00	23994.00	0.00	93	13	878	1502	0.584553928095872	0.667807230981631	0.667807230981631	false	false	false
5ade3ce6-26b9-46b6-bcaf-e302f37bcbee	2026-09-24 15:20	2026-09-24 15:20	2026-09-24 15:20	CLF	CLF261218P00014000	put	14.0000	2026-12-18	2.2600	2.2400	2.2600	12.0000	11978.00	11978.00	0.00	53	13	61	5472	0.0111476608187134	0.637633351291735	0.637633351291735	true	false	false
23a57af3-4398-4f97-be9a-689e9e8f23ea	2026-09-24 15:15	2026-09-24 15:14	2026-09-24 15:14	CLF	CLF261218C00011000	call	11.0000	2026-12-18	2.6000	2.5500	2.6000	12.7400	26000.00	26000.00	0.00	100	7	166	1502	0.11051930758988	0.663133895050132	0.663133895050132	false	false	false
0a4c5cb6-9721-4e38-a30d-c89a1fcf1a5f	2026-09-24 13:48	2026-09-24 13:48	2026-09-24 13:48	CLF	CLF261016C00013500	call	13.5000	2026-10-16	0.5100	0.4900	0.5100	12.0000	12597.00	12597.00	0.00	247	16	1304	6315	0.206492478226445	0.624175129255086	0.624175129255086	false	false	false
614eaaa6-3e0b-4a29-91e8-97455b42936d	2026-09-24 10:06	2026-09-24 10:06	2026-09-24 10:06	CLF	CLF261016C00013500	call	13.5000	2026-10-16	0.4500	0.4100	0.4900	12.6500	22815.00	20925.00	1890.00	507	6	745	6315	0.117973079968329	0.620500727073624	0.620500727073624	false	false	false
7694cae4-ff7d-4878-8c20-4e7aa055a7f5	2026-09-24 09:47	2026-09-24 09:47	2026-09-24 09:47	CLF	CLF261016C00013000	call	13.0000	2026-10-16	0.6500	0.6100	0.6800	12.7006	11180.00	130.00	11050.00	172	26	213	14922	0.0142742259750704	0.61850454451209	0.61850454451209	false	false	false
737c49c1-b2c8-445f-8525-db4ea24c9b66	2026-09-23 14:52	2026-09-23 14:52	2026-09-23 14:52	CLF	CLF261218C00013000	call	13.0000	2026-12-18	1.5000	1.5000	1.5200	12.7150	151200.00	0.00	151200.00	1008	10	2315	19242	0.120309739112358	0.638280958989421	0.639419480983621	false	false	false
46edc1ae-94f3-4d3b-9622-162ed0308aca	2026-09-23 14:12	2026-09-23 14:12	2026-09-23 14:12	CLF	CLF261016C00013500	call	13.5000	2026-10-16	0.5600	0.5400	0.5600	12.8700	22232.00	22176.00	0.00	397	29	1129	399	2.82957393483709	0.625626698998819	0.625626698998819	false	false	false
12579d90-946e-463d-bad3-cbbe9d09480b	2026-09-23 14:12	2026-09-23 14:12	2026-09-23 14:12	CLF	CLF261016C00013500	call	13.5000	2026-10-16	0.5500	0.5300	0.5500	12.8455	27500.00	27500.00	0.00	500	21	732	399	1.83458646616541	0.625750913708757	0.625750913708757	false	false	false
36658d63-6cb1-4163-9542-7dce638730fc	2026-09-23 12:58	2026-09-23 12:58	2026-09-23 12:58	CLF	CLF270617P00008000	put	8.0000	2027-06-17	0.5700	0.5500	0.6200	12.7600	37278.00	22230.00	15048.00	654	11	780	33746	0.0231138505304332	0.661858088128445	0.661858088128445	false	false	false
2211a200-2d11-4a6b-8ae0-afc47a893656	2026-09-23 12:08	2026-09-23 12:08	2026-09-23 12:08	CLF	CLF261218C00013000	call	13.0000	2026-12-18	1.5300	1.5300	1.5500	12.8100	22950.00	0.00	22950.00	150	14	928	19242	0.0482278349443925	0.630338157769017	0.630338157769017	false	false	false
99c775a2-76bc-47a7-8a33-e7f5ca91bb5a	2026-09-23 11:21	2026-09-23 11:21	2026-09-23 11:21	CLF	CLF261218P00014000	put	14.0000	2026-12-18	2.2900	2.2600	2.2900	12.6850	14198.00	14198.00	0.00	62	11	62	5430	0.0114180478821363	0.638471579228527	0.638471579228527	true	false	false
967e513a-623f-4f54-9b27-fe4c15d2597d	2026-09-23 11:21	2026-09-23 11:21	2026-09-23 11:21	CLF	CLF261120P00014000	put	14.0000	2026-11-20	2.0700	1.9600	2.0700	12.6850	73485.00	73485.00	0.00	355	10	355	92	3.85869565217391	0.650997535838554	0.650997535838554	true	false	false
290480a7-e533-43d0-9a8a-624f7f2069ee	2026-09-22 15:03	2026-09-22 15:03	2026-09-22 15:03	CLF	CLF261218C00013000	call	13.0000	2026-12-18	1.4500	1.4200	1.4500	12.5950	87000.00	87000.00	0.00	600	29	13892	7375	1.88366101694915	0.641134632688343	0.641484775023671	false	false	false
75b86868-c43b-48f2-a289-97bcbd0ff0b6	2026-09-22 13:43	2026-09-22 13:43	2026-09-22 13:43	CLF	CLF261030P00010500	put	10.5000	2026-10-30	0.2600	0.2500	0.3000	12.6400	12896.00	1404.00	11492.00	496	6	1102	33	33.3939393939394	0.669376252093075	0.67099833164914	false	false	false
44decee2-2752-4c1a-ab31-6d95eecb84b5	2026-09-22 13:21	2026-09-22 13:21	2026-09-22 13:21	CLF	CLF270115C00013000	call	13.0000	2027-01-15	1.6800	1.6600	1.6800	12.6100	25200.00	25200.00	0.00	150	13	213	3061	0.0695851029075465	0.63047973010692	0.63047973010692	true	false	false
e7ab0656-5ee0-4797-97dc-961b1060e7d6	2026-09-22 12:58	2026-09-22 12:58	2026-09-22 12:58	CLF	CLF261218C00013000	call	13.0000	2026-12-18	1.4400	1.4300	1.4400	12.5850	28944.00	28944.00	0.00	201	6	12832	7375	1.73993220338983	0.639053727304444	0.639577971303303	true	false	false
5d482053-f7f3-47f5-a779-b6c01721a85e	2026-09-22 10:42	2026-09-22 10:42	2026-09-22 10:42	CLF	CLF261218C00013000	call	13.0000	2026-12-18	1.3200	1.3000	1.3200	12.3500	13332.00	13332.00	0.00	101	16	10835	7375	1.46915254237288	0.640641008271015	0.640641008271015	true	false	false
4b3dab0c-0706-4615-a5cd-66143c7b3b92	2026-09-22 10:37	2026-09-22 10:37	2026-09-22 10:37	CLF	CLF261218C00013000	call	13.0000	2026-12-18	1.3900	1.3500	1.3900	12.5000	23352.00	23352.00	0.00	168	20	10623	7375	1.44040677966102	0.63751230730458	0.63751230730458	true	false	false
dc46737e-f0e2-40d8-a1a9-2fd444a941e3	2026-09-22 10:36	2026-09-22 10:36	2026-09-22 10:36	CLF	CLF261218C00013000	call	13.0000	2026-12-18	1.3700	1.3400	1.3800	12.4700	10001.00	9316.00	685.00	73	16	10420	7375	1.4128813559322	0.6357352276262	0.6357352276262	true	false	false
56babc55-8d18-4ceb-bf29-d482515a9680	2026-09-22 10:03	2026-09-22 10:03	2026-09-22 10:03	CLF	CLF261016C00015000	call	15.0000	2026-10-16	0.1200	0.1000	0.1200	12.3650	24000.00	24000.00	0.00	2000	39	2012	11042	0.182213367143633	0.622895597842026	0.617963716934536	false	false	false
ff4d3d4b-5fca-4944-8a7c-3a3350c35ca6	2026-09-21 14:11	2026-09-21 14:11	2026-09-21 14:11	CLF	CLF261030C00013500	call	13.5000	2026-10-30	0.5700	0.5700	0.6100	12.2100	15732.00	0.00	15732.00	276	15	699	1317	0.530751708428246	0.643370672621428	0.644582817119124	false	false	false
df356ad4-7704-4b71-b7bf-252448663885	2026-09-21 13:40	2026-09-21 13:39	2026-09-21 13:39	CLF	CLF260925P00013500	put	13.5000	2026-09-25	1.2600	1.2000	1.3200	12.2650	12600.00	126.00	12474.00	100	23	1602	3603	0.444629475437136	0.645159800266987	0.645159800266987	true	false	false
4fe8eb8a-a654-4966-aba6-a3171ad77b7d	2026-09-21 13:05	2026-09-21 13:05	2026-09-21 13:05	CLF	CLF261016C00015000	call	15.0000	2026-10-16	0.1100	0.1000	0.1100	12.2900	13035.00	13035.00	0.00	1185	17	1617	10696	0.151178010471204	0.604459712015717	0.604459712015717	false	false	false
ad04a173-4bf3-4b22-ab12-fddc56751912	2026-09-21 12:16	2026-09-21 12:16	2026-09-21 12:16	CLF	CLF261016C00014000	call	14.0000	2026-10-16	0.2300	0.2100	0.2400	12.2262	23437.00	22609.00	828.00	1019	20	1129	7352	0.153563656147987	0.603091912115751	0.603091912115751	false	false	false
7bf11aaa-dd29-433d-9c8d-3c5933ec504d	2026-09-21 12:01	2026-09-21 12:01	2026-09-21 12:01	CLF	CLF260925P00013500	put	13.5000	2026-09-25	1.3100	1.3000	1.3700	12.2050	12969.00	131.00	12838.00	99	11	1202	3603	0.33361087982237	0.613556233128645	0.613556233128645	true	false	false
c9f60477-036f-4021-bde2-2a30a5b7da1f	2026-09-21 12:00	2026-09-21 11:59	2026-09-21 11:59	CLF	CLF260925P00013500	put	13.5000	2026-09-25	1.3600	1.3500	1.4100	12.1550	12512.00	136.00	12376.00	92	12	902	3603	0.250346933111296	0.633459117525647	0.633459117525647	true	false	false
7435bb93-f8b4-42d6-9bec-cf7946498541	2026-09-21 11:51	2026-09-21 11:51	2026-09-21 11:51	CLF	CLF260925P00013500	put	13.5000	2026-09-25	1.3500	1.2200	1.4400	12.1650	13500.00	135.00	13365.00	100	18	401	3603	0.111296142103802	0.629480064414155	0.629480064414155	true	false	false
94369db4-9e43-4419-9498-7d057a054c38	2026-09-21 11:27	2026-09-21 11:27	2026-09-21 11:27	CLF	CLF261218P00014000	put	14.0000	2026-12-18	2.5500	2.5300	2.5500	12.2150	10965.00	10965.00	0.00	43	6	63	5397	0.0116731517509728	0.627280125135548	0.627280125135548	false	false	false
94445273-df29-4cb2-a468-c5013b23da72	2026-09-18 15:57	2026-09-18 15:57	2026-09-18 15:57	CLF	CLF260918C00012000	call	12.0000	2026-09-18	0.5400	0.5000	0.5600	12.0000	10746.00	5832.00	918.00	199	8	2183	20773	0.105088335820536	6.29488599867483	6.29488599867483	true	false	false
5ce7f120-fce6-486b-854e-e56ab759342b	2026-09-18 14:30	2026-09-18 14:29	2026-09-18 14:29	CLF	CLF261016C00014000	call	14.0000	2026-10-16	0.2700	0.2600	0.2800	12.3750	16551.00	15903.00	0.00	613	14	1112	6681	0.166442149378836	0.573954287672754	0.573954287672754	false	false	false
d60eb7d1-1615-4238-8994-3d620cac3f55	2026-09-18 11:29	2026-09-18 11:29	2026-09-18 11:29	CLF	CLF261016C00015000	call	15.0000	2026-10-16	0.1600	0.1600	0.1800	12.4800	16000.00	0.00	16000.00	1000	28	1010	9860	0.102434077079108	0.599480264532867	0.601373769301132	true	false	false
d42a9030-1599-4589-8524-6c33e0a22a84	2026-09-17 14:28	2026-09-17 14:28	2026-09-17 14:28	CLF	CLF260925C00014000	call	14.0000	2026-09-25	0.1400	0.1200	0.1400	13.0450	14000.00	14000.00	0.00	1000	26	1298	3748	0.346318036286019	0.586503705447935	0.586503705447935	false	false	false
dedf29f6-c393-4205-b4eb-06dece1b359e	2026-09-17 13:46	2026-09-17 13:46	2026-09-17 13:46	CLF	CLF270319C00015000	call	15.0000	2027-03-19	1.6800	1.6500	1.6800	13.0200	30576.00	30576.00	0.00	182	6	488	7032	0.0693970420932878	0.623397459981351	0.623397459981351	false	false	false
20fce968-df89-4acb-9671-fee3960a9966	2026-09-17 13:43	2026-09-17 13:43	2026-09-17 13:43	CLF	CLF261030C00013500	call	13.5000	2026-10-30	0.9700	0.9700	1.0200	13.0050	27742.00	0.00	27742.00	286	13	408	754	0.541114058355438	0.649191629935313	0.649191629935313	false	false	false
309ab724-8049-449b-b863-3695fe4b1735	2026-09-17 13:29	2026-09-17 13:29	2026-09-17 13:29	CLF	CLF270115P00014000	put	14.0000	2027-01-15	2.3100	2.3100	2.3400	12.9850	140910.00	0.00	140910.00	610	15	613	221	2.7737556561086	0.613877461942288	0.613877461942288	false	false	false
823e1937-7bf8-495a-bb0d-4713b00f7f30	2026-09-17 12:54	2026-09-17 12:54	2026-09-17 12:54	CLF	CLF261016C00015000	call	15.0000	2026-10-16	0.2700	0.2700	0.2800	12.9750	25650.00	0.00	25650.00	950	20	1373	7504	0.18296908315565	0.605721182552355	0.605721182552355	false	false	false
9ac4d54a-dfba-46d8-9fd1-1ea1aab83805	2026-09-17 11:39	2026-09-17 11:38	2026-09-17 11:38	CLF	CLF270319C00015000	call	15.0000	2027-03-19	1.6400	1.6200	1.6600	12.9150	10004.00	164.00	7380.00	61	5	217	7032	0.0308589306029579	0.626157273497078	0.626157273497078	false	false	false