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:alert_rule = RepeatedHits×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

30fc66a7-1629-4276-9c03-14bc66e2d426	2026-09-22 15:41	2026-09-22 15:41	2026-09-22 15:41	PFE	PFE260925C00028000	call	28.0000	2026-09-25	0.1900	0.1800	0.1900	27.9250	38855.00	38855.00	0.00	2045	33	4577	6950	0.658561151079137	0.218940850391115	0.218940850391115	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	159191883341.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T19:45:09.843958Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
494e6eb1-fcc8-442d-93b6-ddf7e8c614a3	2026-09-22 13:43	2026-09-22 13:43	2026-09-22 13:43	PFE	PFE260925P00028000	put	28.0000	2026-09-25	0.2700	0.2700	0.2900	27.8650	11664.00	0.00	11664.00	432	43	1805	1408	1.28196022727273	0.198803910134328	0.198803910134328	false	false	false	true
9ff18811-3629-4a8d-a3ba-a11616f5be22	2026-09-22 13:43	2026-09-22 13:42	2026-09-22 13:42	PFE	PFE260925P00028000	put	28.0000	2026-09-25	0.2800	0.2800	0.3000	27.8550	12320.00	0.00	12320.00	440	37	1252	1408	0.889204545454545	0.202917985652398	0.202917985652398	false	false	false	true
47b6f48d-e92e-4027-b81c-055c07ea583e	2026-09-22 12:53	2026-09-22 12:53	2026-09-22 12:53	PFE	PFE270115P00023000	put	23.0000	2027-01-15	0.1900	0.1800	0.1900	27.8450	18981.00	18981.00	0.00	999	12	2002	48685	0.0411214953271028	0.284574473386412	0.284574473386412	false	false	false	true
a083dff7-17ef-4cd6-9608-10af97741f6f	2026-09-22 12:51	2026-09-22 12:51	2026-09-22 12:51	PFE	PFE261218C00028000	call	28.0000	2026-12-18	1.1900	1.1900	1.2100	27.8350	17017.00	0.00	16660.00	143	19	340	13910	0.0244428468727534	0.209526839802991	0.209526839802991	true	false	false	true
97bd1110-a56d-484e-874f-9e09fcc63a48	2026-09-22 12:33	2026-09-22 12:33	2026-09-22 12:33	PFE	PFE261218C00028000	call	28.0000	2026-12-18	1.1900	1.1800	1.2200	27.8320	12733.00	0.00	12733.00	107	22	195	13910	0.014018691588785	0.209824584279516	0.209824584279516	true	false	false	true
2b27200a-a034-4e08-90fc-1329b4c2a68d	2026-09-22 12:26	2026-09-22 12:26	2026-09-22 12:26	PFE	PFE261016P00027000	put	27.0000	2026-10-16	0.2700	0.2600	0.2700	27.8050	26433.00	26433.00	0.00	979	25	1272	12405	0.102539298669891	0.218066347638582	0.218066347638582	false	false	false	true
ab25c405-f4b9-43e9-b25d-3b6ec001d2e4	2026-09-22 12:12	2026-09-22 12:12	2026-09-22 12:12	PFE	PFE270319C00031000	call	31.0000	2027-03-19	0.7300	0.7100	0.7800	27.7950	22119.00	73.00	21973.00	303	5	308	2674	0.115183246073298	0.212222169039568	0.212222169039568	true	false	false	true
9e08a7d2-4240-494e-abe2-5baa18223af5	2026-09-22 11:44	2026-09-22 11:43	2026-09-22 11:43	PFE	PFE261218C00029000	call	29.0000	2026-12-18	0.8000	0.7700	0.8000	27.8400	12560.00	12560.00	0.00	157	13	1271	21152	0.060088880484115	0.215422869697129	0.215422869697129	false	false	false	true
da36a011-b877-49b3-8565-0294c9a594f2	2026-09-22 11:41	2026-09-22 11:41	2026-09-22 11:41	PFE	PFE261218C00032000	call	32.0000	2026-12-18	0.2100	0.2100	0.2200	27.8300	22596.00	0.00	22596.00	1076	23	1323	9332	0.14177025289327	0.231734538375255	0.231734538375255	false	false	false	true
b1900fb7-739c-4226-8032-ba02cc5a87df	2026-09-22 11:23	2026-09-22 11:22	2026-09-22 11:22	PFE	PFE270319P00027000	put	27.0000	2027-03-19	1.4900	1.4600	1.4900	27.0000	11324.00	11324.00	0.00	76	6	163	9066	0.0179792631811163	0.286371733150909	0.286371733150909	false	false	false	true
3f6ba367-6a76-40fc-b887-5451abefd51a	2026-09-22 11:20	2026-09-22 11:20	2026-09-22 11:20	PFE	PFE270319P00027000	put	27.0000	2027-03-19	1.4900	1.4600	1.4900	27.9550	11324.00	11324.00	0.00	76	9	87	9066	0.00959629384513567	0.285885712527494	0.285885712527494	false	false	false	true
b4eff00f-ac31-4dfa-b4e3-6c86fcfff1fa	2026-09-22 11:14	2026-09-22 11:13	2026-09-22 11:13	PFE	PFE270115C00030000	call	30.0000	2027-01-15	0.7200	0.7000	0.7200	27.9500	10512.00	10512.00	0.00	146	9	650	65364	0.00994431185361973	0.216256551764853	0.216256551764853	false	false	false	true
e7a14b3a-ad7a-425e-be57-83813f3f5823	2026-09-22 10:54	2026-09-22 10:53	2026-09-22 10:53	PFE	PFE261218C00030000	call	30.0000	2026-12-18	0.5100	0.4700	0.5100	27.8950	10200.00	10200.00	0.00	200	5	266	33381	0.00796860489500015	0.214871872590148	0.214871872590148	false	false	false	true
d298e56b-3416-4cfa-8677-a8635aec6e24	2026-09-22 10:51	2026-09-22 10:51	2026-09-22 10:51	PFE	PFE270319P00025000	put	25.0000	2027-03-19	0.7600	0.7300	0.7900	27.8900	14060.00	12236.00	1824.00	185	7	289	10802	0.0267543047583781	0.278094372404753	0.278094372404753	false	false	false	true
93de3d1f-0b46-4bff-9a48-25dcc9be86a1	2026-09-22 10:19	2026-09-22 10:19	2026-09-22 10:19	PFE	PFE261218C00029000	call	29.0000	2026-12-18	0.7300	0.7100	0.7300	27.7450	13067.00	73.00	0.00	179	38	736	21152	0.0347957639939486	0.209238304501392	0.209238304501392	false	false	false	true
53e6e645-d5ac-47c1-ad6d-783ac7d0179a	2026-09-22 10:18	2026-09-22 10:17	2026-09-22 10:17	PFE	PFE261016C00028000	call	28.0000	2026-10-16	0.5100	0.5000	0.5100	27.7200	86496.00	86496.00	0.00	1696	5	9099	27255	0.333847000550358	0.213631768478007	0.213631768478007	false	false	false	true
7ea97012-748e-4794-af3e-3ecd3f04c420	2026-09-22 10:10	2026-09-22 10:09	2026-09-22 10:09	PFE	PFE261218C00029000	call	29.0000	2026-12-18	0.7200	0.6900	0.7200	27.6950	14472.00	144.00	0.00	201	54	203	21152	0.00959720121028744	0.211028143549852	0.211028143549852	false	false	false	true
15094580-af1a-4d9b-9c8e-585b34cd9614	2026-09-22 10:06	2026-09-22 10:06	2026-09-22 10:06	PFE	PFE261016C00028000	call	28.0000	2026-10-16	0.5000	0.4900	0.5300	27.6950	348850.00	1100.00	347750.00	6977	10	7295	27255	0.267657310585214	0.214107713842423	0.214107713842423	false	false	false	true
24589e50-de42-4a59-9455-be58e5e44e93	2026-09-22 09:53	2026-09-22 09:53	2026-09-22 09:53	PFE	PFE290119C00025000	call	25.0000	2029-01-19	5.2400	5.0000	7.5000	27.7350	22548.00	20973.00	1575.00	43	6	43	515	0.083495145631068	0.285231018226931	0.233497198887545	false	false	false	true
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
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
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
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