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 = 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

0aca0698-eb4c-4a88-bdc4-3b6990eeefb6	2026-09-03 11:52	2026-09-03 11:52	2026-09-03 11:52	PFE	PFE260904C00026500	call	26.5000	2026-09-04	2.2300	2.1900	2.2500	28.7150	69799.00	2230.00	55973.00	313	9	334	1641	0.203534430225472	0.800962356117256	0.800962356117256	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	157994951887.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-03T16:03:37.205690Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
10f68f74-f4d6-49bc-a644-5672d1561ea3	2026-09-03 09:39	2026-09-03 09:39	2026-09-03 09:39	PFE	PFE270115C00029000	call	29.0000	2027-01-15	1.7000	1.6100	1.7000	28.9050	74800.00	74800.00	0.00	440	7	505	13875	0.0363963963963964	0.220471854131537	0.220471854131537	false	false	false	true
a916e6c0-da54-4c18-806e-81aca324d589	2026-09-03 09:30	2026-09-03 09:30	2026-09-03 09:30	PFE	PFE261218C00030000	call	30.0000	2026-12-18	0.8100	0.7600	1.3800	29.0700	85843.00	44665.00	41178.00	1057	8	1057	30808	0.0343092703193976	0.170521111453877	0.225421211593035	false	false	false	true
1628a4e3-4ee8-4738-9e7d-d61198b5d6b0	2026-09-02 12:32	2026-09-02 12:31	2026-09-02 12:31	PFE	PFE270319C00027000	call	27.0000	2027-03-19	3.1000	3.0000	3.1500	28.8800	99200.00	29760.00	69440.00	320	10	454	8037	0.0564887395794451	0.192396890098403	0.191247285290455	false	false	false	true
ecd76673-31fc-4a77-921f-6c8ec76423c8	2026-09-02 10:01	2026-09-02 10:01	2026-09-02 10:01	PFE	PFE270115C00025000	call	25.0000	2027-01-15	4.5000	4.4000	4.5500	29.0000	53550.00	53550.00	0.00	119	6	217	28703	0.00756018534647946	0.199130284748208	0.199130284748208	false	false	false	true
27ef976c-985e-4d80-9134-4dc22b8af895	2026-09-02 09:56	2026-09-02 09:56	2026-09-02 09:56	PFE	PFE260918P00028000	put	28.0000	2026-09-18	0.2200	0.1900	0.2200	28.9900	58344.00	58344.00	0.00	2652	61	12853	53354	0.240900401094576	0.253062359650765	0.253062359650765	false	false	false	true
bf01176a-e035-4eb8-9e14-205699cde3bb	2026-09-01 09:32	2026-09-01 09:32	2026-09-01 09:32	PFE	PFE261009C00030000	call	30.0000	2026-10-09	0.5000	0.3500	0.5500	29.0150	59700.00	300.00	59400.00	1194	5	1194	124	9.62903225806452	0.234135701745089	0.228524116713993	false	false	false	true
5280b782-e5ef-4a1d-ac37-44f0c3ecc467	2026-08-31 14:55	2026-08-31 14:54	2026-08-31 14:54	PFE	PFE261120P00028000	put	28.0000	2026-11-20	1.1000	1.0800	1.1000	28.6050	254540.00	253550.00	0.00	2314	42	2544	688	3.69767441860465	0.280593867047918	0.280593867047918	false	false	false	true	false
2824bad2-b548-4993-8839-4965b46faeb4	2026-08-31 12:54	2026-08-31 12:54	2026-08-31 12:54	PFE	PFE260925C00027500	call	27.5000	2026-09-25	1.2100	1.1400	1.2900	28.3650	60942.00	246.00	60696.00	502	34	510	1295	0.393822393822394	0.188424217224176	0.229961911826637	true	false	false	true
c0f7a0b8-0e2b-417b-bbd9-b20b66653379	2026-08-31 12:15	2026-08-31 12:15	2026-08-31 12:15	PFE	PFE260925P00028500	put	28.5000	2026-09-25	0.7200	0.6800	0.7200	28.3150	72288.00	72288.00	0.00	1004	29	1015	30	33.8333333333333	0.224023600630496	0.224023600630496	false	false	false	true	false
6f6a6211-b146-40a3-8e79-23e3b7e137e8	2026-08-31 10:23	2026-08-31 10:23	2026-08-31 10:23	PFE	PFE260904C00028500	call	28.5000	2026-09-04	0.1500	0.1500	0.1600	28.1650	59970.00	0.00	59970.00	3998	7	8274	2597	3.18598382749326	0.238914031247619	0.238914031247619	false	false	false	true
c550fc85-0fee-4ea8-9de8-8f420bb23629	2026-08-27 12:19	2026-08-27 12:19	2026-08-27 12:19	PFE	PFE261120C00027000	call	27.0000	2026-11-20	2.0200	2.0100	2.0700	28.1414	173316.00	39390.00	116554.00	858	12	1031	12904	0.0798977061376317	0.228130286734371	0.228130286734371	false	false	false	true
a795ab95-2f5b-4707-9d28-16f28a182d44	2026-08-27 10:26	2026-08-27 10:26	2026-08-27 10:26	PFE	PFE260918C00029000	call	29.0000	2026-09-18	0.2500	0.2300	0.2600	27.9100	51282.00	50282.00	1000.00	2040	95	2500	35705	0.0700182047332306	0.2292908347266	0.232504740348756	false	false	false	true
eff2d474-63ca-4fcc-9445-4caa46c41fc2	2026-08-27 09:56	2026-08-27 09:56	2026-08-27 09:56	PFE	PFE260918P00028000	put	28.0000	2026-09-18	0.6400	0.5800	0.6500	27.8700	193856.00	193536.00	0.00	3029	34	3083	7840	0.393239795918367	0.223786857464679	0.221936965308928	false	false	false	true
28c5f375-aa8d-48d2-8845-c73a8585a201	2026-08-25 15:50	2026-08-25 15:50	2026-08-25 15:50	PFE	PFE261016P00026000	put	26.0000	2026-10-16	0.1700	0.1700	0.2000	28.4900	66827.00	0.00	66827.00	3931	41	4188	6409	0.653456077391169	0.236023769946944	0.236023769946944	true	false	false	true	false
b876af15-92a0-4f3e-83c8-a978703ea025	2026-08-25 12:31	2026-08-25 12:31	2026-08-25 12:31	PFE	PFE261218C00029000	call	29.0000	2026-12-18	1.3200	1.3200	1.3500	28.4300	58740.00	0.00	58740.00	445	22	670	17107	0.0391652539895949	0.223184043288271	0.223184043288271	false	false	false	true
f9621d87-4550-4938-b184-23289e7a1c81	2026-08-25 11:31	2026-08-25 11:31	2026-08-25 11:31	PFE	PFE280121P00032000	put	32.0000	2028-01-21	5.5500	5.5000	5.6500	28.5250	209235.00	175380.00	33855.00	377	14	426	457	0.932166301969365	0.340487301766042	0.340487301766042	false	false	false	true
5c62e22c-4916-4ca8-9d41-2a6e48dbfb66	2026-08-25 11:31	2026-08-25 11:31	2026-08-25 11:31	PFE	PFE280121P00030000	put	30.0000	2028-01-21	4.3000	4.1500	4.3500	28.5250	65780.00	48580.00	0.00	153	24	153	7136	0.0214405829596413	0.331750365103973	0.331750365103973	true	false	false	true	false
e63ec715-ba75-41c4-b844-648e4a7d45e0	2026-08-25 10:28	2026-08-25 10:28	2026-08-25 10:28	PFE	PFE261016P00028000	put	28.0000	2026-10-16	0.7500	0.7200	0.7800	28.2500	56250.00	27750.00	28500.00	750	35	912	1087	0.83900643974241	0.221902481981665	0.221902481981665	false	false	false	true
462717f6-48a1-43ea-a6b4-0846a07a71f9	2026-08-25 10:11	2026-08-25 10:10	2026-08-25 10:10	PFE	PFE260918P00028500	put	28.5000	2026-09-18	0.8200	0.7600	0.8200	28.0700	57646.00	57646.00	0.00	703	10	705	0	0	0.215990725053157	0.215990725053157	false	false	false	true	false
a7206263-5fb7-460b-bf81-9f6d98b82fea	2026-08-24 15:31	2026-08-24 15:31	2026-08-24 15:31	PFE	PFE261218P00026000	put	26.0000	2026-12-18	0.7200	0.7200	0.7500	28.0050	162792.00	0.00	162792.00	2261	26	2293	5077	0.451644672050423	0.269570508933115	0.269570508933115	false	false	false	true
47ee1bad-6abf-4aac-9241-ce7ef0feff0a	2026-08-24 14:18	2026-08-24 14:17	2026-08-24 14:17	PFE	PFE261218C00029000	call	29.0000	2026-12-18	1.0900	1.0900	1.1400	28.0350	106290.00	1650.00	104640.00	975	50	1257	16013	0.0784987197901705	0.215491005414099	0.215491005414099	false	false	false	true
a600d160-c79a-49bd-981f-d120cd1f3800	2026-08-24 11:23	2026-08-24 11:23	2026-08-24 11:23	PFE	PFE260918C00028500	call	28.5000	2026-09-18	0.4000	0.4000	0.4200	27.8650	70360.00	0.00	70360.00	1759	29	2158	0	0	0.217490715030117	0.218453430554579	false	false	false	true	false
cfb9daaa-252b-4196-b7f4-96f7bab81886	2026-08-21 15:14	2026-08-21 15:14	2026-08-21 15:14	PFE	PFE261218P00027000	put	27.0000	2026-12-18	1.1400	1.1400	1.2000	27.9620	69198.00	0.00	69198.00	607	24	1187	9755	0.121681189133778	0.275617163600325	0.275617163600325	false	false	false	true	false
d39ba730-77cb-427f-9716-f5459d707f25	2026-08-21 14:13	2026-08-21 14:13	2026-08-21 14:13	PFE	PFE261218C00027000	call	27.0000	2026-12-18	2.1200	2.1200	2.1500	27.0000	209038.00	1278.00	207760.00	986	30	1333	26296	0.0506921204745969	0.219248125409875	0.219248125409875	false	false	false	true
314b7b32-7b8c-46f9-8c35-cc50e7ddd58f	2026-08-21 10:15	2026-08-21 10:15	2026-08-21 10:15	PFE	PFE260918P00027000	put	27.0000	2026-09-18	0.2500	0.0000	0.0000	28.2950	520605.00	520605.00	0.00	21000	50	22718	53028	0.428415176887682	0	0	true	true	false	true	false
3be666ca-5998-43b3-9c39-aa6e9a063ddc	2026-08-21 10:03	2026-08-21 10:03	2026-08-21 10:03	PFE	PFE260821C00025500	call	25.5000	2026-08-21	2.6600	2.5100	2.7400	28.1550	412566.00	19152.00	142310.00	1551	20	1578	6817	0.231480123221358	1.65983948500441	1.65983948500441	false	false	false	true
bcd98a25-ffe9-433a-ac76-37df78849d2e	2026-08-20 15:52	2026-08-20 15:51	2026-08-20 15:51	PFE	PFE270319C00031000	call	31.0000	2027-03-19	0.9200	0.9100	1.0100	27.8650	56188.00	0.00	56188.00	610	6	1507	928	1.6239224137931	0.21601993707456	0.21601993707456	false	false	false	true	false
0088fabb-1c39-4b01-8ec6-cbaf085d2e6d	2026-08-20 10:44	2026-08-20 10:44	2026-08-20 10:44	PFE	PFE260821C00025000	call	25.0000	2026-08-21	2.6400	2.6400	2.7100	27.6750	66000.00	0.00	66000.00	250	6	842	20071	0.0419510736884062	1.17072943295651	1.17072943295651	false	false	false	true
db3d2640-ead1-4648-b5cb-de01802f703f	2026-08-20 10:42	2026-08-20 10:42	2026-08-20 10:42	PFE	PFE270617P00025000	put	25.0000	2027-06-17	1.3700	1.1300	1.3700	27.6695	160975.00	160975.00	0.00	1175	12	1196	18251	0.0655306558544737	0.296142036848584	0.296142036848584	false	false	false	true
66b23a64-3653-4f3b-9e92-3102fd217a24	2026-08-20 09:33	2026-08-20 09:33	2026-08-20 09:33	PFE	PFE260821C00027000	call	27.0000	2026-08-21	0.9100	0.9100	1.0100	27.8880	67158.00	0.00	67158.00	738	8	797	40009	0.0199205178834762	0.422949860386401	0.422949860386401	false	false	false	true
cdedc3e9-235d-4381-90fa-61da2b0b8185	2026-08-19 15:00	2026-08-19 15:00	2026-08-19 15:00	PFE	PFE261120P00026000	put	26.0000	2026-11-20	0.5200	0.5100	0.5400	28.3100	132184.00	936.00	130468.00	2542	38	2641	3356	0.786948748510131	0.268208532653837	0.268208532653837	false	false	false	true
34a31123-501c-4eaf-8315-179deaab0489	2026-08-19 13:15	2026-08-19 13:14	2026-08-19 13:14	PFE	PFE260918C00028000	call	28.0000	2026-09-18	0.8800	0.8500	0.8800	28.1600	56232.00	56232.00	0.00	639	37	16611	71464	0.232438710399642	0.233971820779846	0.233971820779846	false	false	false	true
60611420-8f79-4351-83ab-774d32e5aaf3	2026-08-19 12:45	2026-08-19 12:45	2026-08-19 12:45	PFE	PFE260918P00027000	put	27.0000	2026-09-18	0.3200	0.0000	0.0000	28.0280	530673.00	530673.00	0.00	16588	18	17993	6247	2.88026252601249	0	0	true	true	false	true	false
e067fa4a-d373-400b-a1f9-a61c4274c9af	2026-08-19 10:24	2026-08-19 10:24	2026-08-19 10:24	PFE	PFE270319C00032000	call	32.0000	2027-03-19	0.8400	0.7600	0.8400	28.3650	166152.00	166152.00	0.00	1978	22	3016	2661	1.13340849304773	0.216450264661211	0.216450264661211	false	false	false	true
7e19e17e-26f6-4c32-8c89-b995f038557e	2026-08-19 10:20	2026-08-19 10:20	2026-08-19 10:20	PFE	PFE280121C00025000	call	25.0000	2028-01-21	5.0000	4.8000	5.0000	28.3350	232000.00	232000.00	0.00	464	8	571	19197	0.0297442308694067	0.128000141143335	0.128000141143335	false	false	false	true
f86632ee-cb61-4ede-aa25-07dc79e7e255	2026-08-19 10:11	2026-08-19 10:10	2026-08-19 10:10	PFE	PFE260918C00029000	call	29.0000	2026-09-18	0.4900	0.4600	0.5000	28.3250	55027.00	55027.00	0.00	1123	57	5327	26328	0.202332117897296	0.229316151108916	0.228066319268337	false	false	false	true
79833db8-7460-430d-8471-72cd92022646	2026-08-19 09:55	2026-08-19 09:55	2026-08-19 09:55	PFE	PFE260918C00029000	call	29.0000	2026-09-18	0.4400	0.3900	0.4500	28.2550	50204.00	38456.00	11748.00	1141	22	3192	26328	0.121239744758432	0.220491736934645	0.220491736934645	true	false	false	true
eeaa62cb-f93d-4de3-9af4-5192b3d1a4a5	2026-08-19 09:55	2026-08-19 09:54	2026-08-19 09:54	PFE	PFE270115C00033000	call	33.0000	2027-01-15	0.3800	0.2800	0.3800	28.2900	103624.00	103624.00	0.00	2727	31	2753	273	10.0842490842491	0.222652003581241	0.22056667692798	true	false	false	true
6e8e317b-13e7-4733-be93-695340af23da	2026-08-19 09:54	2026-08-19 09:53	2026-08-19 09:54	PFE	PFE261120C00029000	call	29.0000	2026-11-20	1.0100	0.8300	1.0200	28.2143	126135.00	125934.00	201.00	1253	30	1409	3942	0.357432775240994	0.217179810503562	0.217179810503562	true	false	false	true
a0a11e17-a18a-463f-94b4-e20816cab427	2026-08-19 09:48	2026-08-19 09:48	2026-08-19 09:48	PFE	PFE261016C00028000	call	28.0000	2026-10-16	1.0300	1.0200	1.0800	28.0400	77044.00	17716.00	32651.00	748	33	8570	12833	0.667809553494896	0.208271064517111	0.207484516772097	true	false	false	true
6af73e25-c9cf-4f2a-82ad-16518919cebd	2026-08-19 09:47	2026-08-19 09:47	2026-08-19 09:47	PFE	PFE261016C00028000	call	28.0000	2026-10-16	1.0300	1.0000	1.0300	28.0300	98757.00	96717.00	2040.00	959	44	6619	12833	0.515779630639757	0.209354393878452	0.208732192972429	false	false	false	true
b79bf30e-8aa6-40e5-9d08-7b68f165ac81	2026-08-18 12:38	2026-08-18 12:38	2026-08-18 12:38	PFE	PFE261120C00028000	call	28.0000	2026-11-20	0.9200	0.9100	0.9200	27.2900	72772.00	72772.00	0.00	791	32	1565	6232	0.25112323491656	0.201634117245203	0.201634117245203	false	false	false	true
cbb0df81-7124-46dd-90f8-f7aaed4f971d	2026-08-18 12:14	2026-08-18 12:14	2026-08-18 12:14	PFE	PFE280121C00025000	call	25.0000	2028-01-21	4.1500	4.1500	4.2500	27.2450	145250.00	0.00	145250.00	350	10	355	19559	0.0181502121785367	0.140795554911522	0.140795554911522	false	false	false	true
23d13c6a-9cab-4bbc-ae72-2179a5a531d9	2026-08-18 10:56	2026-08-18 10:56	2026-08-18 10:56	PFE	PFE261218P00024000	put	24.0000	2026-12-18	0.3600	0.3500	0.3800	27.2150	86724.00	7308.00	79416.00	2409	65	2444	3082	0.792991563919533	0.258430978208488	0.258430978208488	false	false	false	true
1531bad2-87d8-4a2c-9619-06adf2988a73	2026-08-18 09:53	2026-08-18 09:53	2026-08-18 09:53	PFE	PFE260821C00025000	call	25.0000	2026-08-21	2.3200	2.2700	2.3200	27.3250	116000.00	116000.00	0.00	500	6	1031	19626	0.0525323550392337	0.420534495986209	0.420534495986209	true	false	false	true
e4b81601-25b3-4e0b-8fa4-1c5d34afd1ba	2026-08-18 09:49	2026-08-18 09:49	2026-08-18 09:49	PFE	PFE261218C00027000	call	27.0000	2026-12-18	1.6000	1.5500	1.6500	27.0000	56000.00	52800.00	160.00	350	35	367	26098	0.0140623802590237	0.197856518861702	0.197856518861702	false	false	false	true
2ff8352b-7000-46e9-a277-566ea6a7fe16	2026-08-18 09:41	2026-08-18 09:41	2026-08-18 09:41	PFE	PFE260821C00025000	call	25.0000	2026-08-21	2.2400	2.1400	2.3000	27.0000	112000.00	84000.00	13888.00	500	6	508	19626	0.0258840313869357	0.259494032149553	0.259494032149553	true	false	false	true
f89879a6-6438-4f4d-b335-242d990229dc	2026-08-17 11:31	2026-08-17 11:31	2026-08-17 11:31	PFE	PFE270319P00024000	put	24.0000	2027-03-19	0.8200	0.7700	0.8300	26.9800	101434.00	101352.00	82.00	1237	25	2164	3769	0.574157601485805	0.278604119426283	0.278604119426283	true	false	false	true
f0bebcfe-803b-4354-813b-8c49b5b47e38	2026-08-17 11:22	2026-08-17 11:22	2026-08-17 11:22	PFE	PFE270319P00025000	put	25.0000	2027-03-19	1.1400	1.1000	1.1500	26.9450	95418.00	95418.00	0.00	837	17	1177	8086	0.145560227553797	0.277772845439412	0.277569529616667	false	false	false	true	false