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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:sector = Healthcare×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	price

746f6eb1-e143-45e3-bc23-50b28d5aa7d2	2026-09-21 15:37	2026-09-21 15:37	2026-09-21 15:37	PFE	PFE270115P00027000	put	27.0000	2027-01-15	1.1600	1.1200	1.1700	27.7750	116115.00	116115.00	0.00	1001	44	7424	29823	0.248935385440767	0.272731715937535	0.271030220595313	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	158108945359.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T19:39:27.785314Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
5fea859b-d239-46f4-91a5-7d7175d16d25	2026-09-21 14:53	2026-09-21 14:53	2026-09-21 14:53	PFE	PFE260925P00028000	put	28.0000	2026-09-25	0.3000	0.2800	0.3000	27.9000	10410.00	10410.00	0.00	347	13	766	681	1.12481644640235	0.217372697827124	0.217372697827124	false	false	false	true
662ce13a-1224-45f6-a24f-91fad9413d9c	2026-09-21 14:19	2026-09-21 14:19	2026-09-21 14:19	PFE	PFE261016P00025000	put	25.0000	2026-10-16	0.0500	0.0300	0.0500	27.9050	25000.00	25000.00	0.00	5000	70	5621	6229	0.902392037245144	0.277630957840995	0.277630957840995	false	false	false	true
86ccc7d2-eb74-42f3-a40d-52b8b11f38e1	2026-09-21 14:11	2026-09-21 14:11	2026-09-21 14:11	PFE	PFE270115C00030000	call	30.0000	2027-01-15	0.6700	0.6600	0.6800	27.8700	18760.00	15209.00	3551.00	280	16	11467	64727	0.177159454323543	0.2111771290447	0.2111771290447	true	false	false	true
7e904cb3-4516-46c1-9843-49f89de508c5	2026-09-21 14:03	2026-09-21 14:03	2026-09-21 14:03	PFE	PFE270319P00027000	put	27.0000	2027-03-19	1.5300	1.5100	1.5400	27.0000	23562.00	20043.00	3519.00	154	6	188	8865	0.0212069937958263	0.283412305750018	0.283412305750018	false	false	false	true
818f2a9a-b19c-4dad-b706-938b2a29248a	2026-09-21 13:54	2026-09-21 13:54	2026-09-21 13:54	PFE	PFE270319C00028000	call	28.0000	2027-03-19	1.6600	1.6500	1.6800	27.7250	21248.00	0.00	2324.00	128	6	305	3340	0.0913173652694611	0.195464865328135	0.195464865328135	false	false	false	true
16092a0a-f72d-4e46-8a60-09211f157941	2026-09-21 12:24	2026-09-21 12:24	2026-09-21 12:24	PFE	PFE270617P00025000	put	25.0000	2027-06-17	1.2500	1.2300	1.2500	27.6200	35125.00	35125.00	0.00	281	12	336	18621	0.018044143708716	0.295897276103822	0.29572880397082	false	false	false	true
e42c4e2c-033d-49ea-84c7-c4bf3ce9a91d	2026-09-21 12:01	2026-09-21 12:01	2026-09-21 12:01	PFE	PFE270319C00029000	call	29.0000	2027-03-19	1.2200	1.2100	1.2300	27.6050	58560.00	1708.00	55144.00	480	9	519	4043	0.128370022260697	0.203064777486876	0.203064777486876	false	false	false	true
2fbb1dd5-3144-4f1f-b142-bcae05c1ba78	2026-09-21 11:53	2026-09-21 11:53	2026-09-21 11:53	PFE	PFE270115P00025000	put	25.0000	2027-01-15	0.5300	0.5200	0.5700	27.6050	10600.00	1696.00	8904.00	200	9	221	65947	0.00335117594431892	0.270138482536968	0.270138482536968	false	false	false	true
b6dcca1c-7f95-4ddc-b441-7e2ac4fea463	2026-09-21 10:59	2026-09-21 10:59	2026-09-21 10:59	PFE	PFE261016C00028500	call	28.5000	2026-10-16	0.2900	0.2900	0.3000	27.6339	41905.00	0.00	41905.00	1445	24	1919	0	0	0.2065165098117	0.2065165098117	false	false	false	true	false
affb7978-d76d-4276-b250-c72de86c35ad	2026-09-21 10:35	2026-09-21 10:35	2026-09-21 10:35	PFE	PFE270115P00027000	put	27.0000	2027-01-15	1.2100	1.1900	1.2200	27.6000	526955.00	522236.00	4719.00	4355	45	4764	29823	0.159742480635751	0.270197109729164	0.270197109729164	false	false	false	true
c41259ce-0cc6-4ca5-a27f-e096073c9662	2026-09-18 13:19	2026-09-18 13:19	2026-09-18 13:19	PFE	PFE270319C00028000	call	28.0000	2027-03-19	1.5900	1.5900	1.6000	27.5000	69801.00	0.00	69801.00	439	19	881	2382	0.369857262804366	0.198769816786941	0.198769816786941	false	false	false	true
757d8913-d151-47f7-9d6c-34235392404c	2026-09-18 11:42	2026-09-18 11:42	2026-09-18 11:42	PFE	PFE270319C00028000	call	28.0000	2027-03-19	1.5800	1.5800	1.6100	27.4635	56090.00	0.00	56090.00	355	33	419	2382	0.175902602854744	0.200016580591604	0.200016580591604	false	false	false	true
160bc559-3481-4fdb-b688-c868a781226f	2026-09-18 10:10	2026-09-18 10:10	2026-09-18 10:10	PFE	PFE261218C00025000	call	25.0000	2026-12-18	2.8500	2.7800	2.9500	27.3750	57000.00	51300.00	5700.00	200	8	201	12824	0.0156737367436057	0.20072808920144	0.20072808920144	false	false	false	true
e82ac539-9816-4447-9d43-fbe4724a5f8f	2026-09-17 11:54	2026-09-17 11:54	2026-09-17 11:54	PFE	PFE261120C00030000	call	30.0000	2026-11-20	0.3800	0.3800	0.4000	27.7626	109136.00	0.00	109136.00	2872	26	2981	7415	0.402022926500337	0.231056129690429	0.231056129690429	false	false	false	true
063a7863-b4e8-44ce-aa20-9df4ee8aa4d2	2026-09-16 15:14	2026-09-16 15:14	2026-09-16 15:14	PFE	PFE271217P00025000	put	25.0000	2027-12-17	1.9300	1.9300	2.0500	27.4000	82218.00	0.00	82218.00	426	17	430	9821	0.043783728744527	0.311020673178454	0.311020673178454	true	false	false	true
4840ac6f-5a7b-4511-8339-a17fb285d829	2026-09-16 09:59	2026-09-16 09:58	2026-09-16 09:58	PFE	PFE260918C00025000	call	25.0000	2026-09-18	2.5500	2.5400	2.5800	27.5450	63750.00	1530.00	34935.00	250	22	253	25707	0.00984167736414206	0.639828905986357	0.783888857629873	false	false	false	true
08163eb3-4b41-4086-9aba-fcc7df1ef591	2026-09-15 14:35	2026-09-15 14:35	2026-09-15 14:35	PFE	PFE280121P00027000	put	27.0000	2028-01-21	3.0000	2.9600	3.0000	27.5450	70200.00	70200.00	0.00	234	6	447	12505	0.0357457017193123	0.328279787888742	0.328279787888742	false	false	false	true
2e245f2e-5db8-4b10-9472-00d5aa83b71f	2026-09-14 15:59	2026-09-14 15:59	2026-09-14 15:59	PFE	PFE270319C00030000	call	30.0000	2027-03-19	1.0800	1.0700	1.0900	27.0000	151416.00	123876.00	14904.00	1402	43	1673	5299	0.315719947159841	0.223194193477479	0.223194193477479	false	false	false	true
f3f85857-fc0d-4399-9b53-24af2d8b9ed6	2026-09-11 13:16	2026-09-11 13:16	2026-09-11 13:16	PFE	PFE261016C00029000	call	29.0000	2026-10-16	0.3200	0.3000	0.3500	27.6100	67509.00	47573.00	19936.00	2125	54	3124	21989	0.142071035517759	0.228164477088908	0.230734394529717	false	false	false	true
dd11f833-24b7-45cb-9c6b-1ad2c1a5680a	2026-09-10 15:06	2026-09-10 15:06	2026-09-10 15:06	PFE	PFE280121P00027000	put	27.0000	2028-01-21	3.0500	2.9700	3.0500	27.4850	73505.00	73505.00	0.00	241	15	291	11782	0.0246986929214055	0.326613774470397	0.326613774470397	false	false	false	true
edf3ef2e-caaa-473e-aa6c-d70adc06c6b3	2026-09-09 14:25	2026-09-09 14:25	2026-09-09 14:25	PFE	PFE261016C00029000	call	29.0000	2026-10-16	0.4900	0.4700	0.5000	27.9300	120050.00	22295.00	97706.00	2450	16	6423	18186	0.353183767733421	0.245912018777562	0.245912018777562	false	false	false	true
94f24055-7c1e-49ff-bc21-9a6df153ed9f	2026-09-09 14:24	2026-09-09 14:23	2026-09-09 14:23	PFE	PFE261016C00029000	call	29.0000	2026-10-16	0.4800	0.4500	0.5000	27.9350	58958.00	56544.00	1646.00	1229	64	3054	18186	0.16793137578357	0.242338932020975	0.242338932020975	false	false	false	true
efacabe1-66e1-4aa8-828d-ddff5338f321	2026-09-08 15:53	2026-09-08 15:53	2026-09-08 15:53	PFE	PFE280121P00030000	put	30.0000	2028-01-21	4.6500	4.4000	4.6500	27.8050	95790.00	95790.00	0.00	206	11	864	7124	0.12128017967434	0.339973445331036	0.339973445331036	false	false	false	true
bffb8e1d-7141-43b0-9407-87df54eff6f2	2026-09-08 14:56	2026-09-08 14:56	2026-09-08 14:56	PFE	PFE280121P00030000	put	30.0000	2028-01-21	4.6000	4.4000	4.6000	27.9000	287960.00	287960.00	0.00	626	10	657	7124	0.0922234699606962	0.339300896894314	0.339300896894314	false	false	false	true
8aadc13d-32bc-428e-99fc-b2329fbfd3dd	2026-09-08 11:24	2026-09-08 11:24	2026-09-08 11:24	PFE	PFE260918C00028000	call	28.0000	2026-09-18	0.3700	0.3400	0.3700	27.8550	70226.00	70226.00	0.00	1898	33	2389	71645	0.0333449647567869	0.230842010757546	0.230842010757546	false	false	false	true
89956f9c-eba9-49e9-a060-6f4d8647ca20	2026-09-08 11:08	2026-09-08 11:08	2026-09-08 11:08	PFE	PFE260918P00028000	put	28.0000	2026-09-18	0.4200	0.4100	0.4500	27.9050	66066.00	51198.00	14868.00	1573	16	61207	74568	0.820821263812896	0.209315363679189	0.209315363679189	false	false	false	true
971f87bd-07e7-49c3-9192-cc804e12fabb	2026-09-08 09:38	2026-09-08 09:38	2026-09-08 09:38	PFE	PFE260918P00028000	put	28.0000	2026-09-18	0.4700	0.4800	0.5300	27.8550	1929444.00	0.00	1929444.00	41000	66	42815	74568	0.574173908378929	0.227598762500243	0.222138529885588	true	false	false	true
55833593-4650-4398-b0b4-7e3013c5c7f0	2026-09-04 12:15	2026-09-04 12:15	2026-09-04 12:15	PFE	PFE270617C00027000	call	27.0000	2027-06-17	3.3000	3.3000	3.4500	28.6250	98010.00	0.00	98010.00	297	22	549	14522	0.0378047100950282	0.184883967650008	0.185776718061077	false	false	false	true
063f4c62-b862-46e8-ba41-7ededbe88fc6	2026-09-04 09:41	2026-09-04 09:41	2026-09-04 09:41	PFE	PFE260904C00026000	call	26.0000	2026-09-04	2.5700	2.5700	2.6600	28.5799	254687.00	0.00	254687.00	991	8	992	3797	0.26125888859626	2.62150515163937	2.62150515163937	false	false	false	true
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
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
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
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
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
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