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×ticker = ZTS×

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

9b1341ff-9f49-4110-8a35-0fff1f4709c0	2026-08-19 14:57	2026-08-19 14:57	2026-08-19 14:57	ZTS	ZTS260918P00075000	put	75.0000	2026-09-18	2.0000	1.9500	2.0000	77.1800	32200.00	32200.00	0.00	161	14	939	2375	0.395368421052632	0.352737655277441	0.351872572100368	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	30442182759.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-19T19:07:34.318493Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
e3758f0a-1a91-48a4-9903-5b3e5eaf0445	2026-08-19 14:42	2026-08-19 14:42	2026-08-19 14:42	ZTS	ZTS270319C00090000	call	90.0000	2027-03-19	5.1000	5.0000	5.1000	77.2050	10710.00	10710.00	0.00	21	7	216	2313	0.0933852140077821	0.381055995625484	0.381055995625484	false	false	false	true
b57979a7-2505-4d02-b52c-ba41ae4dc2ea	2026-08-19 14:41	2026-08-19 14:41	2026-08-19 14:41	ZTS	ZTS270319C00090000	call	90.0000	2027-03-19	5.1000	5.0000	5.1000	77.1900	10710.00	10710.00	0.00	21	7	195	2313	0.0843060959792477	0.381310857731794	0.381310857731794	false	false	false	true
320db874-1832-4cbb-8045-0133cb150d3a	2026-08-19 14:39	2026-08-19 14:39	2026-08-19 14:39	ZTS	ZTS270319C00090000	call	90.0000	2027-03-19	5.1000	5.0000	5.1000	77.2200	42840.00	42840.00	0.00	84	31	159	2313	0.0687418936446174	0.380801134681793	0.380801134681793	false	false	false	true
434b4aae-0afa-4348-a621-16d6b7505320	2026-08-19 11:42	2026-08-19 11:41	2026-08-19 11:41	ZTS	ZTS270115C00090000	call	90.0000	2027-01-15	3.2000	3.2000	3.6000	76.6600	12800.00	0.00	12800.00	40	8	137	1191	0.115029387069689	0.369011750499504	0.369011750499504	false	false	false	true
591c1da4-6f82-4881-a62b-05b7f22a4a2d	2026-08-19 10:19	2026-08-19 10:19	2026-08-19 10:19	ZTS	ZTS260918C00080000	call	80.0000	2026-09-18	2.1000	2.0500	2.1000	77.4100	11548.00	11548.00	0.00	55	23	320	2156	0.148423005565863	0.348722917312632	0.348722917312632	false	false	false	true
5dcf2bad-4877-4d06-be59-fd63e9db4532	2026-08-19 10:16	2026-08-19 10:16	2026-08-19 10:16	ZTS	ZTS261218P00060000	put	60.0000	2026-12-18	0.9500	0.8500	0.9500	77.0200	28500.00	28500.00	0.00	300	11	330	748	0.441176470588235	0.39633547772923	0.39633547772923	false	false	false	true
fbef3e85-ec5f-4193-ad5f-0d6d8d84dbbf	2026-08-19 09:36	2026-08-19 09:36	2026-08-19 09:36	ZTS	ZTS280121C00100000	call	100.0000	2028-01-21	7.7000	7.7000	8.4000	76.0000	80851.00	0.00	80851.00	105	6	136	571	0.238178633975482	0.376897448901394	0.376897448901394	false	false	false	true
1964400b-c129-430c-b095-f2a4ce7213b8	2026-08-18 15:01	2026-08-18 15:01	2026-08-18 15:01	ZTS	ZTS261218P00065000	put	65.0000	2026-12-18	2.4500	2.4000	2.4500	74.3700	11025.00	11025.00	0.00	45	6	81	1317	0.061503416856492	0.394840390370376	0.394840390370376	false	false	false	true
f3aa84cd-02c5-46fc-9847-6dd19d3c040f	2026-08-18 14:40	2026-08-18 14:40	2026-08-18 14:40	ZTS	ZTS270617P00075000	put	75.0000	2027-06-17	10.3000	9.9000	10.8000	74.2250	52530.00	46350.00	6180.00	51	7	103	148	0.695945945945946	0.419314922774156	0.419314922774156	false	false	false	true
a614b6d5-5d74-4fc7-a173-59237ad0f8c1	2026-08-17 14:35	2026-08-17 14:35	2026-08-17 14:35	ZTS	ZTS270617C00100000	call	100.0000	2027-06-17	3.4000	3.0000	3.6000	72.5650	29920.00	3400.00	24480.00	88	6	97	56	1.73214285714286	0.385261205325496	0.385261205325496	false	false	false	true
a3f11342-6020-46ba-97c5-a35682b6b714	2026-08-17 11:28	2026-08-17 11:28	2026-08-17 11:28	ZTS	ZTS280121C00075000	call	75.0000	2028-01-21	13.2000	13.2000	14.2000	71.8700	47520.00	0.00	47520.00	36	5	77	36561	0.00210606930882635	0.373231080951631	0.373231080951631	false	false	false	true
0a8b30f8-6ce6-43b2-9959-3e8e457a9c76	2026-08-17 10:13	2026-08-17 10:13	2026-08-17 10:13	ZTS	ZTS260918P00070000	put	70.0000	2026-09-18	1.9500	1.8500	2.0000	71.5500	39580.00	38995.00	585.00	203	22	352	3627	0.0970499035015164	0.330944927421676	0.329652823615348	false	false	false	true
b80d6483-92de-414f-bf77-91fba9e59a27	2026-08-17 10:04	2026-08-17 10:04	2026-08-17 10:04	ZTS	ZTS261016C00070000	call	70.0000	2026-10-16	4.5000	4.5000	4.9000	71.2000	90000.00	0.00	90000.00	200	5	244	237	1.0295358649789	0.31846706781066	0.31846706781066	false	false	false	true