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:er_time = unknown×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

190983ea-1516-4ffa-ac8a-d2c475ba268d	2026-09-22 14:35	2026-09-22 14:35	2026-09-22 14:35	COF	COF270115P00200000	put	200.0000	2027-01-15	12.2500	12.1000	12.3000	201.7500	11026.00	6146.00	3660.00	9	9	36	1659	0.0216998191681736	0.32273395705647	0.32273395705647	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	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-22T18:36:42.386317Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
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
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	false
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	false
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	false
6039aadc-71b9-4b9e-a430-1330329f2abe	2026-09-22 10:26	2026-09-22 10:26	2026-09-22 10:26	COF	COF261002P00197500	put	197.5000	2026-10-02	1.9600	1.9500	2.0000	202.0000	37900.00	10600.00	27300.00	193	15	193	4	48.25	0.309841769217603	0.309841769217603	false	false	false	true	false
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	false
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	false
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	false
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
cf550e46-cb29-4706-99f7-cfeeea2c2da0	2026-09-21 13:46	2026-09-21 13:46	2026-09-21 13:46	COF	COF261120C00220000	call	220.0000	2026-11-20	5.4000	5.3000	5.7000	205.0000	48020.00	0.00	48020.00	89	10	306	78	3.92307692307692	0.314571150816927	0.311264468976741	false	false	false	true	false
77d078ae-915e-40ec-9e41-8234d7ffc552	2026-09-21 11:55	2026-09-21 11:55	2026-09-21 11:55	COF	COF270115C00230000	call	230.0000	2027-01-15	5.6900	5.6000	5.9000	203.7500	17056.00	0.00	17056.00	30	6	46	2193	0.0209758321933425	0.298142672758419	0.298142672758419	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	false
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	false
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	false
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	false
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
a83031bb-a3dc-42da-a497-be5e1b2f6a48	2026-09-11 15:53	2026-09-11 15:53	2026-09-11 15:53	COF	COF280121P00170000	put	170.0000	2028-01-21	13.0000	11.2000	13.0000	208.6200	194998.00	194998.00	0.00	150	34	151	37	4.08108108108108	0.362819440180897	0.363105530182232	true	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	false
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	false
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	false
4c24b487-4b95-4e64-81e2-2daf51ad0c79	2026-09-09 09:33	2026-09-09 09:32	2026-09-09 09:32	COF	COF270319C00250000	call	250.0000	2027-03-19	7.6200	7.5000	7.7000	212.1100	201040.00	137200.00	0.00	264	40	2002	2501	0.800479808076769	0.300689780390845	0.30258458751406	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
70a71629-dcf0-4e57-9f62-f350fbc2f739	2026-09-09 09:32	2026-09-09 09:32	2026-09-09 09:32	COF	COF270319C00250000	call	250.0000	2027-03-19	7.8200	7.3000	7.9000	212.5950	272880.00	63840.00	0.00	349	23	416	2501	0.166333466613355	0.301769647073005	0.303646822513417	false	false	false	true
6adc32e5-1a32-4748-9429-c6d7cdd54249	2026-09-04 12:14	2026-09-04 12:14	2026-09-04 12:14	COF	COF270319C00260000	call	260.0000	2027-03-19	7.8000	7.5000	7.8000	220.6300	152088.00	152088.00	0.00	195	40	197	482	0.408713692946058	0.294407820280333	0.294407820280333	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	false
f57c6661-1ad4-46b3-a0ff-c44ed9203c4f	2026-09-04 12:13	2026-09-04 12:13	2026-09-04 12:13	COF	COF270319P00180000	put	180.0000	2027-03-19	5.2900	5.0000	5.3000	220.5300	132146.00	132146.00	0.00	250	33	255	252	1.01190476190476	0.347709986039183	0.35105933715143	false	false	false	true	false
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	false
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
770d2f85-1d83-4bb5-b279-f872f5822212	2026-09-02 15:22	2026-09-02 15:22	2026-09-02 15:22	COF	COF260918C00220000	call	220.0000	2026-09-18	3.9000	3.7000	3.9000	216.7400	60446.00	60446.00	0.00	155	27	313	3019	0.103676714143756	0.286355602663203	0.286355602663203	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
1764ecc0-c14f-460b-a198-7cc084ea895c	2026-09-02 11:05	2026-09-02 11:05	2026-09-02 11:05	COF	COF280121P00220000	put	220.0000	2028-01-21	28.1500	27.9000	28.5000	219.5950	84450.00	42450.00	42000.00	30	6	92	57	1.6140350877193	0.340936366219156	0.344026331998517	false	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
795cf46d-6235-486b-a3e1-5354ffd39246	2026-09-02 10:58	2026-09-02 10:58	2026-09-02 10:58	COF	COF260918C00227500	call	227.5000	2026-09-18	2.4000	1.7500	2.4500	220.4700	79190.00	78230.00	960.00	330	47	415	23	18.0434782608696	0.269764475634938	0.269764475634938	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	false
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	false
d2268e1f-60be-4c80-9862-c20e4a96a9ef	2026-09-01 10:42	2026-09-01 10:41	2026-09-01 10:41	COF	COF280121C00300000	call	300.0000	2028-01-21	10.7100	9.8000	10.7000	214.0150	53570.00	53570.00	0.00	50	7	50	496	0.100806451612903	0.307174692365764	0.307174692365764	true	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	false
dae703d2-d56f-49f5-ac2f-4da8a9561398	2026-09-01 10:29	2026-09-01 10:29	2026-09-01 10:29	COF	COF261016P00220000	put	220.0000	2026-10-16	10.5000	10.1000	10.5000	215.2000	149090.00	149090.00	0.00	142	40	142	64	2.21875	0.279442478169158	0.279442478169158	false	false	false	true	false
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