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×source = uw_flow_alerts×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	expiry

78624e70-67a0-4e29-b326-6291338c2937	2026-09-25 15:26	2026-09-25 15:26	2026-09-25 15:26	COF	COF261023C00205000	call	205.0000	2026-10-23	6.3000	6.0000	6.5000	200.7300	257040.00	56070.00	200970.00	408	13	586	41	14.2926829268293	0.357092063759486	0.357092063759486	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Financial Services	122819664167.00	2026-10-20	postmarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:30:11.536652Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
d063c52b-a510-427b-9905-50b824c7bd84	2026-09-25 14:48	2026-09-25 14:48	2026-09-25 14:48	COF	COF261023P00200000	put	200.0000	2026-10-23	7.1000	6.8000	7.3000	200.0000	144840.00	71000.00	73840.00	204	27	204	184	1.10869565217391	0.353767156786654	0.353767156786654	false	false	false	true
c53bcef3-c871-4757-bd86-c50fd3e23220	2026-09-25 14:48	2026-09-25 14:48	2026-09-25 14:48	COF	COF261023C00205000	call	205.0000	2026-10-23	6.2000	6.1000	6.5000	200.0000	91140.00	24800.00	65720.00	147	11	157	41	3.82926829268293	0.349695866095326	0.349695866095326	true	false	false	true
f692b081-66d7-4da2-8ba1-4edc725ae41b	2026-09-25 14:33	2026-09-25 14:33	2026-09-25 14:33	COF	COF260925C00200000	call	200.0000	2026-09-25	1.2000	1.0500	1.2000	201.1100	11520.00	8040.00	0.00	96	23	788	1357	0.58069270449521	0.414653016400404	0.425204445005505	false	false	false	true
95e6b587-d7cd-42c9-a540-cec9fe1db6dc	2026-09-25 14:33	2026-09-25 14:33	2026-09-25 14:33	COF	COF260925C00200000	call	200.0000	2026-09-25	1.2500	1.1500	1.2500	201.1600	10250.00	2250.00	0.00	82	20	692	1357	0.509948415622697	0.436926874597662	0.436926874597662	false	false	false	true
9d65cc71-639a-42f7-ba22-fed988eb5dd4	2026-09-25 14:24	2026-09-25 14:24	2026-09-25 14:24	COF	COF261016P00195000	put	195.0000	2026-10-16	2.9000	2.8500	2.9000	201.2600	22330.00	4060.00	0.00	77	26	179	490	0.36530612244898	0.297387326448772	0.297387326448772	false	false	false	true
49ac51c1-98b8-4f14-ae6c-fe3a83066918	2026-09-25 14:24	2026-09-25 14:24	2026-09-25 14:24	COF	COF261016P00195000	put	195.0000	2026-10-16	2.9500	2.8500	2.9500	201.2500	12685.00	9735.00	0.00	43	17	98	490	0.2	0.300161525684459	0.300161525684459	false	false	false	true
3e6245d0-8ec1-4e09-9122-e04b7b98a37d	2026-09-25 14:24	2026-09-25 14:24	2026-09-25 14:24	COF	COF261016P00195000	put	195.0000	2026-10-16	3.0000	2.9250	3.0500	201.2300	13200.00	600.00	11400.00	44	14	55	490	0.112244897959184	0.302746899566588	0.302746899566588	false	false	false	true
d212763b-c87c-4bc1-967e-9fdfc211c55f	2026-09-25 13:35	2026-09-25 13:35	2026-09-25 13:35	COF	COF261023P00205000	put	205.0000	2026-10-23	10.0000	9.6000	10.4000	199.0000	121000.00	120000.00	1000.00	121	31	121	25	4.84	0.338662567495482	0.338662567495482	false	false	false	true
f1b8b7bc-7570-4509-83e7-75c7049b69b2	2026-09-25 10:53	2026-09-25 10:53	2026-09-25 10:53	COF	COF261009C00207500	call	207.5000	2026-10-09	1.0500	1.0500	1.2500	196.0000	14810.00	0.00	14810.00	141	34	146	3	48.6666666666667	0.287020158357569	0.291937024987119	false	false	false	true
633a5fc6-5cfd-415a-a800-f2ac6b2022c9	2026-09-25 10:43	2026-09-25 10:43	2026-09-25 10:43	COF	COF261016C00210000	call	210.0000	2026-10-16	1.5000	1.3000	1.5000	197.0500	16500.00	13650.00	0.00	110	5	128	10623	0.0120493269321284	0.292517913506698	0.292517913506698	false	false	false
b4ce9706-08c5-493c-86ec-e5e32c7b2d0f	2026-09-25 10:37	2026-09-25 10:37	2026-09-25 10:37	COF	COF261002P00195000	put	195.0000	2026-10-02	2.4000	2.3500	2.7500	196.9550	17040.00	0.00	17040.00	71	17	72	138	0.521739130434783	0.309334789415221	0.309334789415221	false	false	false	true
f96df248-f9c2-46a5-882b-fb7c859f9ebf	2026-09-25 10:06	2026-09-25 10:06	2026-09-25 10:06	COF	COF261218C00210000	call	210.0000	2026-12-18	6.5000	6.3000	6.7000	195.5900	10400.00	650.00	9100.00	16	5	16	534	0.0299625468164794	0.302198026095223	0.302198026095223	false	false	false	true
93ca2b3e-833e-40aa-ae27-569b21a8a682	2026-09-25 09:57	2026-09-25 09:57	2026-09-25 09:57	COF	COF261002C00200000	call	200.0000	2026-10-02	2.0000	1.8500	2.5000	196.6900	51805.00	0.00	51805.00	259	41	261	2534	0.102999210734017	0.305293452809695	0.305293452809695	false	false	false
963bb749-c4a6-4aa3-8c1e-42f9f98e6325	2026-09-24 12:37	2026-09-24 12:37	2026-09-24 12:37	COF	COF261002C00200000	call	200.0000	2026-10-02	2.1000	1.7000	2.1500	195.9300	210000.00	84840.00	90300.00	1000	154	1001	28	35.75	0.326156300115883	0.31905583551672	true	false	false	true
1ee3fe25-e1ce-4f55-a09e-776a0775ccdd	2026-09-24 12:15	2026-09-24 12:15	2026-09-24 12:15	COF	COF261218C00210000	call	210.0000	2026-12-18	6.5000	6.2000	6.6000	195.4250	11050.00	9750.00	1300.00	17	7	23	550	0.0418181818181818	0.302873467412209	0.302105856443843	true	false	false	true
e10aa5f6-e85a-4868-abf1-b4c94b08d0b0	2026-09-24 10:29	2026-09-24 10:29	2026-09-24 10:29	COF	COF260925P00195000	put	195.0000	2026-09-25	1.4500	1.4500	1.9000	195.4200	23495.00	0.00	23495.00	162	38	171	208	0.822115384615385	0.407590727862016	0.407590727862016	false	false	false	true
17cae0d5-d897-4a7b-9ef0-6050d24c9bab	2026-09-23 15:45	2026-09-23 15:45	2026-09-23 15:45	COF	COF270917C00230000	call	230.0000	2027-09-17	15.0000	14.8000	15.2000	196.0000	573000.00	423000.00	0.00	382	27	384	55	6.98181818181818	0.307429997974631	0.307429997974631	false	false	false
f154aeb8-bc85-4851-97f1-cdeb910bf09b	2026-09-23 15:35	2026-09-23 15:35	2026-09-23 15:35	COF	COF260925C00200000	call	200.0000	2026-09-25	0.7500	0.5500	1.0500	196.1200	19767.00	17742.00	2025.00	264	6	1294	169	7.65680473372781	0.366629604601628	0.366629604601628	false	false	false
d03d8302-0d05-44e8-99f8-22b68b7bf392	2026-09-23 15:34	2026-09-23 15:34	2026-09-23 15:34	COF	COF270617C00210000	call	210.0000	2027-06-17	17.1000	17.1000	17.8000	196.2400	27360.00	0.00	27360.00	16	5	183	324	0.564814814814815	0.300693867419496	0.300693867419496	false	false	false
71d56aef-f832-4ff7-8162-7eb666e4595b	2026-09-23 15:33	2026-09-23 15:33	2026-09-23 15:33	COF	COF261002C00202500	call	202.5000	2026-10-02	1.6000	1.6000	1.7500	196.3300	40000.00	0.00	40000.00	250	10	1296	14	92.5714285714286	0.310474191856375	0.310474191856375	false	false	false	true
1800b429-b176-496c-81dd-9c21ece2ee59	2026-09-23 15:32	2026-09-23 15:32	2026-09-23 15:32	COF	COF261120P00185000	put	185.0000	2026-11-20	5.1000	5.0000	5.1000	196.2650	67320.00	67320.00	0.00	132	19	643	43	14.953488372093	0.335769861031572	0.335769861031572	true	false	false	true
b263227b-7f5f-4acf-a361-4274a6a8d138	2026-09-23 11:51	2026-09-23 11:51	2026-09-23 11:51	COF	COF260925C00200000	call	200.0000	2026-09-25	1.7500	1.6000	1.8500	198.0000	14525.00	2800.00	11725.00	83	8	1012	169	5.98816568047337	0.37985718156058	0.37985718156058	true	false	false	true
32e8fd26-f375-4330-993e-79f751d89a22	2026-09-23 11:51	2026-09-23 11:51	2026-09-23 11:51	COF	COF261120P00185000	put	185.0000	2026-11-20	4.4000	4.3000	4.8000	198.0000	58960.00	29480.00	4400.00	134	23	506	43	11.7674418604651	0.334213182997954	0.334213182997954	false	false	false	true
660a3941-04bc-4e73-8eea-5952e1536379	2026-09-23 11:50	2026-09-23 11:50	2026-09-23 11:50	COF	COF261120P00185000	put	185.0000	2026-11-20	4.5000	4.4000	4.5000	198.0000	13500.00	13500.00	0.00	30	10	357	43	8.30232558139535	0.337105160375629	0.337105160375629	false	false	false	true
fb9d8c90-20aa-454e-8a97-4f39aa528081	2026-09-23 11:50	2026-09-23 11:50	2026-09-23 11:50	COF	COF261120P00185000	put	185.0000	2026-11-20	4.5000	4.4000	4.5000	198.0000	115640.00	115200.00	440.00	257	65	261	43	6.06976744186047	0.336750496922741	0.337105160375629	true	false	false	true
a6273f54-c830-4a1b-99df-ce85048130b7	2026-09-23 11:50	2026-09-23 11:50	2026-09-23 11:50	COF	COF261120P00185000	put	185.0000	2026-11-20	4.5000	4.4000	4.5000	198.0000	24300.00	24300.00	0.00	54	11	315	43	7.32558139534884	0.337105160375629	0.337105160375629	false	false	false	true
81ca09d6-ecc5-4966-9416-cd9a38838595	2026-09-23 11:50	2026-09-23 11:50	2026-09-23 11:50	COF	COF260925C00200000	call	200.0000	2026-09-25	1.7500	1.5000	1.8000	198.0000	38150.00	7350.00	25900.00	218	27	929	169	5.49704142011834	0.397084883330567	0.397084883330567	true	false	false
ab093cf4-f12c-461b-896b-4b407d920b6f	2026-09-23 11:50	2026-09-23 11:50	2026-09-23 11:50	COF	COF261002C00202500	call	202.5000	2026-10-02	2.3500	2.2000	2.4000	198.0000	31255.00	6110.00	25145.00	133	11	286	14	20.4285714285714	0.309305981418421	0.309305981418421	true	false	false	true
6682012a-ef4e-4e11-abe1-c85b06f3d04e	2026-09-23 11:50	2026-09-23 11:50	2026-09-23 11:50	COF	COF260925C00200000	call	200.0000	2026-09-25	1.5000	1.3500	1.6500	198.0000	43800.00	17100.00	16650.00	292	39	419	169	2.4792899408284	0.376305661415006	0.376305661415006	true	false	false
198683f8-eaf8-43b4-8aec-fa16ba2a6c83	2026-09-23 11:50	2026-09-23 11:50	2026-09-23 11:50	COF	COF260925C00200000	call	200.0000	2026-09-25	1.5000	1.5000	1.6500	198.0000	33900.00	0.00	33900.00	226	18	645	169	3.81656804733728	0.376305661415006	0.376305661415006	false	false	false	true
3edf6e46-d2be-464b-ac9e-4d18f1f48e2e	2026-09-23 11:50	2026-09-23 11:50	2026-09-23 11:50	COF	COF260925C00200000	call	200.0000	2026-09-25	1.3500	1.3500	1.6500	198.0000	15525.00	0.00	15525.00	115	16	127	169	0.751479289940828	0.358098464761856	0.358098464761856	false	false	false	true
24c2d945-051a-4aa5-9058-701668306242	2026-09-23 11:21	2026-09-23 11:21	2026-09-23 11:21	COF	COF270115C00240000	call	240.0000	2027-01-15	2.5000	2.3000	2.5500	197.3400	29750.00	10000.00	19750.00	119	8	393	2310	0.17012987012987	0.298448613714326	0.298448613714326	false	false	false
5426db19-0e6f-4eac-82e0-0e828055c8d2	2026-09-23 11:15	2026-09-23 11:15	2026-09-23 11:15	COF	COF270115C00240000	call	240.0000	2027-01-15	2.5000	2.3000	2.5500	197.1200	35500.00	14500.00	21000.00	142	12	199	2310	0.0861471861471862	0.299749784776732	0.299749784776732	false	false	false
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
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
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
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