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:er_time = premarket×ticker = PFE×

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

6c192537-86ea-49c3-b2d9-608ee571a89a	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	PFE	PFE261009C00029000	call	29.0000	2026-10-09	0.3300	0.3100	0.3400	28.6000	14322.00	14322.00	0.00	434	5	2352	1358	1.7319587628866	0.216712876204231	0.216712876204231	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	163409641797.00	2026-11-03	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:54:56.567521Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
79ec5286-92a1-45a2-b4f0-2907bac19674	2026-09-25 15:51	2026-09-25 15:51	2026-09-25 15:51	PFE	PFE261009C00029000	call	29.0000	2026-10-09	0.3300	0.3200	0.3300	28.5950	14586.00	14586.00	0.00	442	10	1918	1358	1.41237113402062	0.217625547924295	0.217625547924295	false	false	false	true
16c3ad72-30aa-420a-86c1-673952ddad1a	2026-09-25 15:42	2026-09-25 15:42	2026-09-25 15:42	PFE	PFE261009C00029000	call	29.0000	2026-10-09	0.3100	0.3100	0.3300	28.0000	16554.00	0.00	1271.00	534	6	1470	1358	1.08247422680412	0.216377990615457	0.216377990615457	false	false	false	true
9d554de8-4f3b-44b4-b520-2ab77c4008de	2026-09-25 15:42	2026-09-25 15:42	2026-09-25 15:42	PFE	PFE261009C00029000	call	29.0000	2026-10-09	0.3000	0.2800	0.3000	28.0000	17070.00	17070.00	0.00	569	25	931	1358	0.685567010309278	0.212549391536589	0.212549391536589	false	false	false	true
78a073ab-6f1b-40b8-91fc-b516eb3fa36b	2026-09-25 13:48	2026-09-25 13:48	2026-09-25 13:48	PFE	PFE261218C00029000	call	29.0000	2026-12-18	0.9800	0.9700	1.0000	28.3850	13622.00	0.00	13622.00	139	6	231	21948	0.0105248769819574	0.208522273281031	0.208522273281031	false	false	false	true
2a9fae89-c590-4783-b7fd-fc7a9899aef2	2026-09-25 12:42	2026-09-25 12:42	2026-09-25 12:42	PFE	PFE261218C00028000	call	28.0000	2026-12-18	1.4400	1.4400	1.4700	28.3650	18864.00	0.00	18864.00	131	15	200	14429	0.0138609744265022	0.203555769854377	0.203555769854377	false	false	false	true
19561412-3938-4720-a0d6-101b3741759b	2026-09-25 10:55	2026-09-25 10:54	2026-09-25 10:54	PFE	PFE261023P00027000	put	27.0000	2026-10-23	0.2200	0.2100	0.2300	28.0000	38808.00	22.00	38786.00	1764	37	1778	505	3.52079207920792	0.224627312694124	0.224627312694124	false	false	false	true
38a45e67-f745-4c99-942d-1c00cc29faf8	2026-09-25 09:55	2026-09-25 09:55	2026-09-25 09:55	PFE	PFE261002P00028500	put	28.5000	2026-10-02	0.5000	0.4900	0.5200	28.2101	10000.00	2000.00	8000.00	200	5	297	455	0.652747252747253	0.223385499480438	0.223385499480438	false	false	false	true
2ad21f6b-042c-42f4-a7c1-8650b1a94f5b	2026-09-24 15:24	2026-09-24 15:24	2026-09-24 15:24	PFE	PFE270115C00029000	call	29.0000	2027-01-15	1.2300	1.1900	1.2300	28.4350	14760.00	14760.00	0.00	120	15	1069	16437	0.065036198819736	0.208387432617497	0.208387432617497	false	false	false	true
1b499ec3-5db1-4f24-8642-364c1eaef1bc	2026-09-24 15:24	2026-09-24 15:24	2026-09-24 15:24	PFE	PFE270115C00028000	call	28.0000	2027-01-15	1.7200	1.6700	1.7300	28.4350	132784.00	131752.00	1032.00	772	44	1050	10413	0.100835494093921	0.205377154558713	0.205377154558713	false	false	false	true
0028d9fa-7ff1-49fc-baa2-77151103366c	2026-09-24 14:52	2026-09-24 14:52	2026-09-24 14:52	PFE	PFE270115C00030000	call	30.0000	2027-01-15	0.8500	0.8300	0.8500	28.4250	24820.00	24820.00	0.00	292	17	5979	66015	0.0905703249261531	0.211103491919629	0.211103491919629	false	false	false	true
807d8cc3-bc76-4f55-9185-83db9ed6ba42	2026-09-24 14:20	2026-09-24 14:20	2026-09-24 14:20	PFE	PFE270115P00028000	put	28.0000	2027-01-15	1.3000	1.2900	1.3000	28.4100	13390.00	13390.00	0.00	103	7	2407	2518	0.955917394757744	0.267327367183789	0.267327367183789	false	false	false	true
4d066e13-0965-46d7-af4e-3facb32ceb07	2026-09-24 13:52	2026-09-24 13:52	2026-09-24 13:52	PFE	PFE270319P00028000	put	28.0000	2027-03-19	1.7200	1.7000	1.7200	28.0000	11180.00	11180.00	0.00	65	7	737	3522	0.209256104486087	0.284865598543068	0.284865598543068	false	false	false	true
8aef80db-f089-42a2-81d6-ac7d172be59e	2026-09-24 13:50	2026-09-24 13:50	2026-09-24 13:50	PFE	PFE260925C00027500	call	27.5000	2026-09-25	0.9900	0.9600	0.9900	28.0000	30789.00	30789.00	0.00	311	13	2066	4642	0.445066781559673	0.456308068019769	0.456308068019769	false	false	false	true
07c3877d-3c59-4e2e-9c6f-81091966cd0a	2026-09-24 13:50	2026-09-24 13:50	2026-09-24 13:50	PFE	PFE260925C00027500	call	27.5000	2026-09-25	0.9800	0.9800	1.0100	28.0000	30184.00	0.00	30184.00	308	9	710	4642	0.152951314088755	0.452781710937809	0.452781710937809	false	false	false	true
cde0886b-7da5-429e-8bbf-278371c77cd1	2026-09-24 13:46	2026-09-24 13:46	2026-09-24 13:46	PFE	PFE270115C00029000	call	29.0000	2027-01-15	1.2400	1.2100	1.2600	28.0000	83576.00	78864.00	4712.00	674	13	945	16437	0.0574922431100566	0.208379687564515	0.208379687564515	false	false	false	true
4d9670c4-851c-4bc1-b929-141f1a1fe5b5	2026-09-24 12:37	2026-09-24 12:37	2026-09-24 12:37	PFE	PFE270115P00028000	put	28.0000	2027-01-15	1.2700	1.2500	1.2700	28.5900	42418.00	42418.00	0.00	334	14	841	2518	0.333995234312947	0.273917760317653	0.273917760317653	false	false	false	true
3807f4fb-a8bc-4038-8b5a-73812134ebe8	2026-09-24 12:06	2026-09-24 12:06	2026-09-24 12:06	PFE	PFE270319P00028000	put	28.0000	2027-03-19	1.7600	1.7500	1.7800	28.4800	21296.00	6336.00	14960.00	121	12	223	3522	0.0633162975582056	0.290917689098309	0.290917689098309	false	false	false	true
a13096ee-d474-4dfe-b823-44a31839b752	2026-09-24 12:04	2026-09-24 12:03	2026-09-24 12:03	PFE	PFE270319C00031000	call	31.0000	2027-03-19	0.9600	0.9600	0.9800	28.4750	11424.00	0.00	11424.00	119	13	253	2812	0.0899715504978663	0.214215892196293	0.214215892196293	false	false	false	true
0445d8d5-441c-4022-961c-c8c376eb4586	2026-09-24 12:02	2026-09-24 12:02	2026-09-24 12:02	PFE	PFE270617C00032000	call	32.0000	2027-06-17	1.1500	1.1500	1.1600	28.4850	15410.00	0.00	15410.00	134	5	250	12314	0.0203020951762222	0.214746729851035	0.214746729851035	false	false	false	true
c3102dda-0589-4910-ab96-ad7ed865387b	2026-09-24 11:57	2026-09-24 11:57	2026-09-24 11:57	PFE	PFE261120P00028000	put	28.0000	2026-11-20	0.9900	0.9800	1.0000	28.5100	58707.00	57717.00	990.00	593	28	1263	3442	0.366937826844858	0.294196809111181	0.294196809111181	false	false	false	true
5b8d1434-db58-4103-a71a-5886a702d448	2026-09-24 11:56	2026-09-24 11:56	2026-09-24 11:56	PFE	PFE261120P00028000	put	28.0000	2026-11-20	0.9900	0.9800	0.9900	28.5100	49500.00	49500.00	0.00	500	7	670	3442	0.194654270772807	0.294196809111181	0.294196809111181	false	false	false	true
4641340f-527a-40de-a779-e62fe43f16d6	2026-09-24 11:44	2026-09-24 11:44	2026-09-24 11:44	PFE	PFE270115C00032000	call	32.0000	2027-01-15	0.4700	0.4700	0.4900	28.5950	10115.00	0.00	9635.00	215	5	781	23545	0.0331705245275005	0.229530108066492	0.227493496633839	true	false	false	true
83274c17-1f3e-445f-aace-b96b9f97ff38	2026-09-24 11:28	2026-09-24 11:27	2026-09-24 11:27	PFE	PFE261218C00029000	call	29.0000	2026-12-18	1.1200	1.0900	1.1300	28.5520	74704.00	74592.00	112.00	667	31	1120	22439	0.049913097731628	0.218024301873564	0.218024301873564	false	false	false	true
365a59fb-b178-4c5c-9048-ab2689091a8c	2026-09-24 11:28	2026-09-24 11:27	2026-09-24 11:27	PFE	PFE261218C00030000	call	30.0000	2026-12-18	0.7500	0.7200	0.7500	28.5520	161325.00	161325.00	0.00	2151	30	2332	33778	0.069039019480135	0.221903913575396	0.221903913575396	false	false	false	true
142d91a0-6515-4e58-8ce8-a5557244e133	2026-09-24 11:15	2026-09-24 11:14	2026-09-24 11:14	PFE	PFE261016C00026000	call	26.0000	2026-10-16	2.8100	2.8100	2.9600	28.6850	19670.00	0.00	19670.00	70	19	285	7039	0.0404887057820713	0.283283295717861	0.283283295717861	true	false	false	true
a9c7aa3b-a1cc-4c14-895c-fb08a31bc19d	2026-09-24 11:11	2026-09-24 11:11	2026-09-24 11:11	PFE	PFE261016C00026000	call	26.0000	2026-10-16	2.8400	2.7800	2.9600	28.0000	28400.00	0.00	28400.00	100	6	180	7039	0.0255718141781503	0.285494571795319	0.285494571795319	true	false	false	true
178865d4-3133-402a-8bf2-f0cccf7d4fd8	2026-09-24 10:45	2026-09-24 10:45	2026-09-24 10:45	PFE	PFE260925P00029000	put	29.0000	2026-09-25	0.3400	0.2800	0.3400	28.7850	68000.00	68000.00	0.00	2000	56	2070	133	15.5639097744361	0.361194180930041	0.361194180930041	false	false	false	true
a77d6a53-82ee-4707-b777-2f62ec4cca9c	2026-09-24 10:37	2026-09-24 10:37	2026-09-24 10:37	PFE	PFE261120C00029000	call	29.0000	2026-11-20	0.9800	0.9800	1.0100	28.7350	10388.00	0.00	10388.00	106	9	531	9384	0.0565856777493606	0.224800271946176	0.224800271946176	true	false	false	true
490fe471-af60-480b-8bb2-2146abcaf7f6	2026-09-24 10:32	2026-09-24 10:32	2026-09-24 10:32	PFE	PFE270115P00026000	put	26.0000	2027-01-15	0.5500	0.5500	0.5700	28.7250	27500.00	0.00	27500.00	500	13	1001	3754	0.266648907831646	0.273923076824579	0.273923076824579	false	false	false	true
f5df8cab-96ba-4516-81c9-4428e7731090	2026-09-24 10:32	2026-09-24 10:32	2026-09-24 10:32	PFE	PFE270319C00040000	call	40.0000	2027-03-19	0.1100	0.0500	0.1100	28.7150	11000.00	11000.00	0.00	1000	14	1101	5567	0.197772588467756	0.262374739850363	0.262374739850363	false	false	false	true
31b4dd60-fc15-474d-bb8f-26a8072d8a92	2026-09-24 10:27	2026-09-24 10:27	2026-09-24 10:27	PFE	PFE280121C00030000	call	30.0000	2028-01-21	2.8100	2.7100	2.8900	28.7550	12645.00	3372.00	7025.00	45	5	204	28568	0.00714085690282834	0.190625053815231	0.190625053815231	true	false	false	true
c72cb077-1714-4e07-a962-04ffd8ad5e59	2026-09-24 10:25	2026-09-24 10:25	2026-09-24 10:25	PFE	PFE270115C00026000	call	26.0000	2027-01-15	3.3000	3.2500	3.4000	28.7700	79200.00	23760.00	31680.00	240	6	246	4510	0.0545454545454545	0.184768632774458	0.184768632774458	false	false	false	true
2787bcda-a789-43d8-b263-9645077782e2	2026-09-24 10:17	2026-09-24 10:17	2026-09-24 10:17	PFE	PFE261002C00029000	call	29.0000	2026-10-02	0.3500	0.3300	0.3500	28.8101	17500.00	17500.00	0.00	500	46	1616	3630	0.445179063360882	0.250384663548993	0.250384663548993	true	false	false	true
749a644e-e684-476a-aef7-fc923dca2a32	2026-09-24 10:17	2026-09-24 10:16	2026-09-24 10:16	PFE	PFE261120C00030000	call	30.0000	2026-11-20	0.6400	0.6300	0.6500	28.8150	32000.00	31808.00	0.00	500	34	2505	14929	0.167794226003081	0.230300223465092	0.230300223465092	true	false	false	true
612d4260-72c7-4ac7-9f0d-486ff5468846	2026-09-24 10:16	2026-09-24 10:16	2026-09-24 10:16	PFE	PFE261016C00030000	call	30.0000	2026-10-16	0.2600	0.2400	0.2800	28.8299	17011.00	16860.00	26.00	661	48	1292	18494	0.0698604952957716	0.228886486965925	0.233207066124017	true	false	false	true
da94fd84-5ed0-4d87-979f-3a018008f791	2026-09-24 09:57	2026-09-24 09:57	2026-09-24 09:57	PFE	PFE261120C00028000	call	28.0000	2026-11-20	1.5000	1.4500	1.5500	28.7250	21300.00	21150.00	0.00	142	5	1091	10660	0.10234521575985	0.220567793083018	0.220567793083018	false	false	false	true
4528ab13-bab8-40eb-9104-27d0b217bb9f	2026-09-24 09:44	2026-09-24 09:44	2026-09-24 09:44	PFE	PFE261016C00029000	call	29.0000	2026-10-16	0.4500	0.4400	0.4600	28.5700	40635.00	0.00	0.00	903	5	2027	29947	0.067686245700738	0.217864902318923	0.217864902318923	false	false	false	true
9b425675-b565-43b6-b9b7-74f3e5f64708	2026-09-24 09:39	2026-09-24 09:39	2026-09-24 09:39	PFE	PFE261016C00029000	call	29.0000	2026-10-16	0.4100	0.4100	0.4500	28.5390	10250.00	0.00	10250.00	250	25	563	29947	0.0187998797876248	0.207873024871633	0.207873024871633	true	false	false	true
2632e31c-206c-43f6-857a-7a751a6eeb9b	2026-09-23 13:56	2026-09-23 13:56	2026-09-23 13:56	PFE	PFE261016C00029000	call	29.0000	2026-10-16	0.3200	0.3100	0.3200	28.1790	31104.00	31104.00	0.00	972	39	2328	27942	0.0833154391238995	0.218321418263627	0.218321418263627	false	false	false	true
130b8844-1e3e-4744-a38c-34744c714529	2026-09-23 12:56	2026-09-23 12:56	2026-09-23 12:56	PFE	PFE270319C00029000	call	29.0000	2027-03-19	1.4100	1.4100	1.4200	28.0450	52875.00	0.00	52875.00	375	14	686	5057	0.135653549535298	0.202229053559618	0.202229053559618	false	false	false	true
a5e90d6e-017b-4513-99c7-abde698f6c21	2026-09-23 12:12	2026-09-23 12:12	2026-09-23 12:12	PFE	PFE261009C00028500	call	28.5000	2026-10-09	0.3300	0.3100	0.3300	28.0600	39831.00	39237.00	0.00	1207	22	1446	2060	0.701941747572816	0.212393554848873	0.212393554848873	false	false	false	true
c707235c-cfe3-4e83-a672-fdd41b26cdad	2026-09-23 11:04	2026-09-23 11:04	2026-09-23 11:04	PFE	PFE261120C00028000	call	28.0000	2026-11-20	1.0100	1.0100	1.0400	27.9250	17473.00	0.00	17473.00	173	7	238	10356	0.0229818462726922	0.215718739863926	0.215718739863926	true	false	false	true
f4b21a46-73a9-4a2f-93a4-ed2689f9be97	2026-09-23 11:01	2026-09-23 11:01	2026-09-23 11:01	PFE	PFE261120C00030000	call	30.0000	2026-11-20	0.3400	0.3300	0.3600	27.9050	90406.00	75514.00	14892.00	2659	40	3185	11852	0.268731015862302	0.22265776613463	0.22265776613463	true	false	false	true