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:alert_rule = RepeatedHits×ticker = COF×

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

e011ed19-ed56-46dc-ace8-90e3c134680c	2026-09-22 13:55	2026-09-22 13:55	2026-09-22 13:55	COF	COF270617P00210000	put	210.0000	2027-06-17	23.9000	23.9000	24.3000	202.0100	45410.00	0.00	45410.00	19	7	54	591	0.0913705583756345	0.337183891876386	0.337183891876386	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	123034383860.00	2026-10-20	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T17:57:38.128984Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
74613875-0247-4733-8f21-9d163f2fdb58	2026-09-22 13:08	2026-09-22 13:08	2026-09-22 13:08	COF	COF290119C00220000	call	220.0000	2029-01-19	39.4000	39.3500	41.0000	201.0500	19700.00	0.00	19700.00	5	5	5	0	0	0.310778450914295	0.310778450914295	false	false	false	true
641b5178-f3fb-4e2e-be8c-e7487c9c4b9e	2026-09-22 10:46	2026-09-22 10:46	2026-09-22 10:46	COF	COF261009P00195000	put	195.0000	2026-10-09	2.5000	2.3500	2.5000	201.6299	13250.00	13250.00	0.00	53	12	55	31	1.7741935483871	0.309270770630455	0.309270770630455	false	false	false	true
503a7ec7-1dca-41b9-bfc4-4791fce8c0a7	2026-09-22 10:44	2026-09-22 10:44	2026-09-22 10:44	COF	COF261016P00197500	put	197.5000	2026-10-16	3.9000	3.7000	3.9000	201.9950	28470.00	28470.00	0.00	73	30	92	12	7.66666666666667	0.297958551739366	0.297958551739366	false	false	false	true
b358a191-f6e8-4d0d-947f-f2ee8efd7cc5	2026-09-22 10:18	2026-09-22 10:18	2026-09-22 10:18	COF	COF260925P00202500	put	202.5000	2026-09-25	2.1500	0.9500	2.1500	202.9300	21500.00	21500.00	0.00	100	6	326	84	3.88095238095238	0.326010601012852	0.326010601012852	false	false	false	true
73dac2b0-dc09-4ecc-9bd9-fea56f5b444c	2026-09-22 10:17	2026-09-22 10:16	2026-09-22 10:16	COF	COF260925P00202500	put	202.5000	2026-09-25	2.0500	0.9500	2.0500	203.1250	25625.00	25625.00	0.00	125	5	226	84	2.69047619047619	0.324454665769061	0.324454665769061	false	false	false	true
6a23b4c8-3511-4643-9a11-9659f3965130	2026-09-21 14:46	2026-09-21 14:46	2026-09-21 14:46	COF	COF261120C00210000	call	210.0000	2026-11-20	9.1000	9.0000	9.3000	205.3000	33670.00	0.00	29120.00	37	8	54	68	0.794117647058823	0.318169016591194	0.318816425162937	false	false	false	true
438b113a-a2ec-4025-9e9c-2a24331bc354	2026-09-21 14:24	2026-09-21 14:24	2026-09-21 14:24	COF	COF270917C00250000	call	250.0000	2027-09-17	13.2000	13.0000	13.3000	205.0600	17160.00	5280.00	11880.00	13	6	20	28	0.714285714285714	0.307138783359738	0.307138783359738	false	false	false	true
52af20e5-e2bc-48cb-a9c7-8827e2fc88fb	2026-09-21 10:02	2026-09-21 10:02	2026-09-21 10:02	COF	COF261016C00230000	call	230.0000	2026-10-16	0.3500	0.3000	0.4000	203.1500	14665.00	0.00	14490.00	419	25	429	1769	0.242509892594686	0.284971095995284	0.284971095995284	false	false	false	true
b5448436-09e2-4eb1-84e6-f3ce792fad6a	2026-09-18 15:20	2026-09-18 15:20	2026-09-18 15:20	COF	COF261016P00200000	put	200.0000	2026-10-16	5.1000	4.9000	5.1000	201.9010	54570.00	54570.00	0.00	107	14	225	544	0.413602941176471	0.282727272098676	0.282727272098676	false	false	false	true
b1348bca-0765-4ace-8cad-4b16c89df358	2026-09-18 14:22	2026-09-18 14:22	2026-09-18 14:22	COF	COF261016C00210000	call	210.0000	2026-10-16	3.3000	3.1000	3.3000	202.1700	127050.00	127050.00	0.00	385	29	505	249	2.0281124497992	0.27520911589697	0.27520911589697	false	false	false	true
f60b3c5a-1ccd-4b62-83f2-6d6c8f14ab37	2026-09-17 13:07	2026-09-17 13:07	2026-09-17 13:07	COF	COF261218P00210000	put	210.0000	2026-12-18	15.4500	15.2000	15.5000	203.9600	71070.00	71070.00	0.00	46	5	111	850	0.130588235294118	0.32683205471877	0.32683205471877	false	false	false	true
1bde1c73-1afa-4467-b7b9-75fbf9812463	2026-09-17 12:53	2026-09-17 12:53	2026-09-17 12:53	COF	COF270115P00195000	put	195.0000	2027-01-15	9.6000	9.4000	9.6000	204.1500	117120.00	16320.00	0.00	122	36	122	1299	0.0939183987682833	0.325861621669291	0.326416663415082	false	false	false	true
dae941ea-c05f-4d91-8c35-2fb1c476fd41	2026-09-17 10:51	2026-09-17 10:50	2026-09-17 10:50	COF	COF261218C00220000	call	220.0000	2026-12-18	7.2000	7.0000	7.2000	203.7900	56160.00	56160.00	0.00	78	5	96	868	0.110599078341014	0.307788921702054	0.307788921702054	true	false	false	true
b8cf3489-a905-4c71-8d12-fc684de603c4	2026-09-16 12:17	2026-09-16 12:17	2026-09-16 12:17	COF	COF260925C00200000	call	200.0000	2026-09-25	8.4000	8.3000	9.3000	206.8300	83160.00	0.00	78960.00	99	18	100	2	50	0.308562630516095	0.308562630516095	false	false	false	true
5ed3d803-16ef-4369-b867-db7e637e09f5	2026-09-15 12:07	2026-09-15 12:07	2026-09-15 12:07	COF	COF280121C00290000	call	290.0000	2028-01-21	10.2000	9.4000	10.2500	203.7400	51000.00	51000.00	0.00	50	10	50	154	0.324675324675325	0.312497958854124	0.312497958854124	false	false	false	true
87cbd137-438e-4a0d-b677-d77e5194eec1	2026-09-11 14:10	2026-09-11 14:10	2026-09-11 14:10	COF	COF270617P00195000	put	195.0000	2027-06-17	15.3000	15.0000	15.3000	208.0650	97920.00	97920.00	0.00	64	16	154	1099	0.140127388535032	0.337234016892386	0.337234016892386	false	false	false	true
277aeb57-1aff-4548-bfd2-15db41022090	2026-09-11 14:10	2026-09-11 14:10	2026-09-11 14:10	COF	COF270617P00195000	put	195.0000	2027-06-17	15.3000	15.0000	15.3000	208.0900	119339.00	119339.00	0.00	78	17	90	1099	0.0818926296633303	0.337357679959658	0.337357679959658	false	false	false	true
1a6461fa-efdd-4f91-921a-f1ba494cbc6c	2026-09-11 10:38	2026-09-11 10:38	2026-09-11 10:38	COF	COF270115P00195000	put	195.0000	2027-01-15	8.9000	8.8000	9.2000	206.8650	145080.00	0.00	145080.00	163	25	414	973	0.425488180883864	0.32035542443073	0.32035542443073	true	false	false	true
d85d4205-efd2-4484-aae2-4e6a50072ea1	2026-09-11 10:03	2026-09-11 10:03	2026-09-11 10:03	COF	COF270115P00195000	put	195.0000	2027-01-15	7.8000	7.2000	9.0000	208.8200	195020.00	780.00	7040.00	250	74	250	973	0.25693730729702	0.308686594286666	0.311044726273355	false	false	false	true
19e6b845-9e97-43c5-9ffe-f08793c0a6de	2026-09-10 14:32	2026-09-10 14:32	2026-09-10 14:32	COF	COF260918P00205000	put	205.0000	2026-09-18	3.2000	3.2000	3.3000	206.3500	80000.00	0.00	80000.00	250	7	258	530	0.486792452830189	0.322287154998828	0.322287154998828	false	false	false	true
979377f7-2f5e-4a8a-89e0-74187b8c1afa	2026-09-10 12:39	2026-09-10 12:38	2026-09-10 12:38	COF	COF261016P00200000	put	200.0000	2026-10-16	4.3000	4.1000	4.4000	207.0000	51170.00	46870.00	4300.00	119	37	196	303	0.646864686468647	0.2982308022613	0.2982308022613	false	false	false	true
c49bae82-9450-46b7-b4bb-362a3e201187	2026-09-09 09:32	2026-09-09 09:32	2026-09-09 09:32	COF	COF270319C00250000	call	250.0000	2027-03-19	7.7000	7.6000	7.7000	211.7700	170940.00	170940.00	0.00	222	12	1546	2501	0.618152738904438	0.304475098182977	0.304475098182977	false	false	false	true
7433172a-74eb-4d75-9292-d70456a25f32	2026-09-09 09:32	2026-09-09 09:32	2026-09-09 09:32	COF	COF270319C00250000	call	250.0000	2027-03-19	7.7000	7.6000	7.7000	211.7700	83930.00	83930.00	0.00	109	6	1655	2501	0.661735305877649	0.304475098182977	0.304475098182977	false	false	false	true
1c5db515-0cd3-4f40-9cc5-10ba3927fa1e	2026-09-09 09:32	2026-09-09 09:32	2026-09-09 09:32	COF	COF270319C00250000	call	250.0000	2027-03-19	7.7000	7.6000	7.7000	212.0000	154000.00	154000.00	0.00	200	16	1302	2501	0.520591763294682	0.303196224285518	0.303196224285518	true	false	false	true
e3792e7d-bcca-4322-8e27-0954bb9a7a62	2026-09-09 09:32	2026-09-09 09:32	2026-09-09 09:32	COF	COF270319C00250000	call	250.0000	2027-03-19	7.9000	7.5000	7.9000	212.5950	168270.00	168270.00	0.00	213	19	1102	2501	0.4406237504998	0.303646822513417	0.303646822513417	false	false	false	true
cdee5628-8ba8-45a9-9bda-e62101c7e818	2026-09-09 09:32	2026-09-09 09:32	2026-09-09 09:32	COF	COF270319C00250000	call	250.0000	2027-03-19	7.8000	7.4000	7.8000	212.5950	347100.00	111540.00	0.00	445	19	889	2501	0.355457816873251	0.301769647073005	0.301769647073005	false	false	false	true
1ec507e8-a337-4a1f-a1eb-5077e93666ef	2026-09-04 12:14	2026-09-04 12:13	2026-09-04 12:13	COF	COF270319P00180000	put	180.0000	2027-03-19	5.3000	5.3000	5.4000	220.5900	79500.00	0.00	79500.00	150	7	405	252	1.60714285714286	0.351302223039844	0.351302223039844	false	false	false	true
1d591e61-42ba-4bb9-9e1a-3e2c72fefc43	2026-09-03 09:55	2026-09-03 09:55	2026-09-03 09:55	COF	COF270115C00250000	call	250.0000	2027-01-15	6.4000	6.4000	6.8000	219.3100	70400.00	0.00	70400.00	110	19	112	2000	0.056	0.294235130013263	0.294235130013263	false	false	false	true
607ac4f4-7895-49de-b0af-f79c8d34cdf6	2026-09-02 15:34	2026-09-02 15:34	2026-09-02 15:34	COF	COF260918C00220000	call	220.0000	2026-09-18	4.2000	3.8000	4.3000	217.2650	54600.00	53340.00	0.00	130	12	888	3019	0.294137131500497	0.290550328824502	0.290427410355207	true	false	false	true
e27eea76-1e9f-45b5-a3f5-1361c039f91b	2026-09-02 12:08	2026-09-02 12:08	2026-09-02 12:08	COF	COF270319C00250000	call	250.0000	2027-03-19	9.2000	8.9000	9.3000	216.7400	156400.00	145360.00	9200.00	170	17	175	2325	0.0752688172043011	0.297180580065584	0.297180580065584	true	false	false	true
d6e8a6e7-0326-42de-9344-556f4147d740	2026-09-02 10:58	2026-09-02 10:58	2026-09-02 10:58	COF	COF261016C00230000	call	230.0000	2026-10-16	5.0000	4.2000	5.3000	220.4700	110000.00	75000.00	35000.00	220	23	454	173	2.6242774566474	0.275554962938521	0.275554962938521	false	false	false	true
e8fc4a05-6a6b-456e-abfb-c0b7728606f3	2026-09-02 10:51	2026-09-02 10:51	2026-09-02 10:51	COF	COF261016C00220000	call	220.0000	2026-10-16	9.0000	9.0000	9.2000	220.1000	67500.00	0.00	61200.00	75	20	156	56	2.78571428571429	0.277113842851843	0.277113842851843	false	false	false	true
ab81d44e-2eaf-428b-847c-83c5a6aae706	2026-09-02 10:51	2026-09-02 10:51	2026-09-02 10:51	COF	COF261009P00225000	put	225.0000	2026-10-09	9.9000	9.6000	9.9000	220.1000	63360.00	63360.00	0.00	64	6	64	0	0	0.274002181114544	0.274002181114544	false	false	false	true
5bec6347-940b-4803-b7db-d4af2c88969d	2026-09-01 10:39	2026-09-01 10:38	2026-09-01 10:38	COF	COF270917P00210000	put	210.0000	2027-09-17	22.1000	22.1000	22.6000	214.3100	88400.00	0.00	88400.00	40	5	100	2	50	0.328039841513046	0.328039841513046	false	false	false	true
4d843151-8133-4abd-b07f-9eb4865bf511	2026-08-31 15:57	2026-08-31 15:57	2026-08-31 15:57	COF	COF261218C00220000	call	220.0000	2026-12-18	12.8000	12.6000	12.8000	214.7400	92160.00	92160.00	0.00	72	5	156	839	0.185935637663886	0.299703748980515	0.299703748980515	false	false	false	true
04ebc851-b034-4dcc-aff2-68e8579a36dd	2026-08-28 11:21	2026-08-28 11:21	2026-08-28 11:21	COF	COF281215C00220000	call	220.0000	2028-12-15	50.1000	47.9000	50.1000	218.8900	50100.00	50100.00	0.00	10	5	10	57	0.175438596491228	0.328137831894778	0.328137831894778	false	false	false	true
9e50a20e-4f34-4fc5-bbe7-3e4d9167935b	2026-08-27 15:27	2026-08-27 15:27	2026-08-27 15:27	COF	COF270115P00220000	put	220.0000	2027-01-15	16.7000	16.7000	17.0000	216.0000	115230.00	0.00	115230.00	69	9	78	1376	0.0566860465116279	0.307093114950259	0.307093114950259	false	false	false	true
1abedeca-8aac-4aa4-a990-7d07c2309750	2026-08-27 11:38	2026-08-27 11:38	2026-08-27 11:38	COF	COF270319P00195000	put	195.0000	2027-03-19	9.5000	9.3000	9.6000	217.6800	165299.00	165299.00	0.00	174	7	401	167	2.40119760479042	0.333025270749477	0.333025270749477	false	false	false	true
55d3a769-ecad-4e1e-9f74-37f558143360	2026-08-27 11:30	2026-08-27 11:30	2026-08-27 11:30	COF	COF270319P00195000	put	195.0000	2027-03-19	9.5000	9.3000	9.7000	217.4500	159600.00	114950.00	0.00	168	11	168	167	1.0059880239521	0.331899885891733	0.331899885891733	false	false	false	true
59879cfd-0f36-4a53-b9cb-5085ed6a2c8e	2026-08-26 15:42	2026-08-26 15:42	2026-08-26 15:42	COF	COF270115C00220000	call	220.0000	2027-01-15	16.8000	16.7000	17.1000	217.9900	168000.00	1680.00	5040.00	100	12	604	2845	0.212302284710018	0.298506162884476	0.298506162884476	false	false	false	true
7296f6ea-d7b3-438f-a8d8-4f6128db3259	2026-08-26 15:40	2026-08-26 15:40	2026-08-26 15:40	COF	COF270115C00220000	call	220.0000	2027-01-15	16.8000	16.8000	17.1000	218.0000	168000.00	0.00	1680.00	100	12	504	2845	0.177152899824253	0.298403898251338	0.298403898251338	false	false	false	true
56ddb4b0-968e-444a-b7ad-31650ea33811	2026-08-26 15:38	2026-08-26 15:38	2026-08-26 15:38	COF	COF270115C00220000	call	220.0000	2027-01-15	16.8000	16.6000	17.1000	218.0650	168000.00	157920.00	10080.00	100	10	404	2845	0.142003514938489	0.297738815134352	0.297738815134352	false	false	false	true
5d0b3c85-d4e5-4dbb-b8f5-047553db6672	2026-08-26 15:23	2026-08-26 15:23	2026-08-26 15:23	COF	COF270115C00220000	call	220.0000	2027-01-15	16.7000	16.5000	16.7000	217.7800	153640.00	140280.00	0.00	92	9	203	2845	0.0713532513181019	0.298791336271624	0.298791336271624	false	false	false	true
c5af5862-0f7e-4d4e-80cb-9db22ade66b0	2026-08-26 15:21	2026-08-26 15:21	2026-08-26 15:21	COF	COF270115C00220000	call	220.0000	2027-01-15	16.5000	15.7000	17.1000	217.9000	165000.00	1650.00	146850.00	100	10	104	2845	0.0365553602811951	0.293850421325799	0.293850421325799	false	false	false	true
0d22d3bb-1c81-453f-8754-6704a60e9913	2026-08-26 11:16	2026-08-26 11:16	2026-08-26 11:16	COF	COF261218P00220000	put	220.0000	2026-12-18	16.0000	15.9000	16.4000	215.8700	291200.00	0.00	291200.00	182	34	197	460	0.428260869565217	0.31623276583859	0.31623276583859	false	false	false	true
9295b083-5af1-4446-a663-dc7a303f630a	2026-08-24 10:54	2026-08-24 10:54	2026-08-24 10:54	COF	COF270115P00220000	put	220.0000	2027-01-15	15.5000	15.5000	15.8000	219.7700	62000.00	0.00	62000.00	40	5	90	1317	0.0683371298405467	0.312160165759061	0.312160165759061	false	false	false	true
bf70b9fa-f864-4bdc-a857-5343f99acfed	2026-08-24 10:43	2026-08-24 10:43	2026-08-24 10:43	COF	COF270115C00220000	call	220.0000	2027-01-15	18.7000	18.6000	19.1000	220.4300	155210.00	9350.00	11220.00	83	14	316	2375	0.133052631578947	0.305731572571897	0.305731572571897	false	false	false	true
c2ae7e9e-396a-472d-ad0f-f73482c83c8b	2026-08-21 10:58	2026-08-21 10:58	2026-08-21 10:58	COF	COF270115C00220000	call	220.0000	2027-01-15	18.2000	16.9000	18.2000	219.1500	169260.00	169260.00	0.00	93	5	101	2245	0.044988864142539	0.306201206941202	0.306201206941202	false	false	false	true
796396e8-bf61-4bfe-9a83-e74e8c428211	2026-08-21 10:37	2026-08-21 10:36	2026-08-21 10:36	COF	COF260918P00210000	put	210.0000	2026-09-18	3.1000	3.1000	3.6000	217.4200	66650.00	0.00	66650.00	215	39	554	1308	0.423547400611621	0.268136589249219	0.268136589249219	true	false	false	true