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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 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×sorted by created_at ↑×

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

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	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-17T14:09:25.911404Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
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
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
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
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
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
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
12e811e6-db91-4b17-b679-f394cb52d495	2026-08-19 15:02	2026-08-19 15:02	2026-08-19 15:02	ZTS	ZTS261218C00095000	call	95.0000	2026-12-18	2.1500	2.0000	2.2000	77.2200	10320.00	9890.00	0.00	48	18	60	115	0.521739130434783	0.398263954494364	0.398263954494364	false	false	false	true
61da4592-3bde-4555-9107-06a76e952cd7	2026-08-19 15:02	2026-08-19 15:02	2026-08-19 15:02	ZTS	ZTS270319C00090000	call	90.0000	2027-03-19	5.2000	5.1000	5.2000	77.2200	55120.00	55120.00	0.00	106	41	333	2313	0.143968871595331	0.385255568448861	0.385255568448861	false	false	false	true
be0177ed-8660-4898-b74b-8c1b2d134b0a	2026-08-20 09:51	2026-08-20 09:51	2026-08-20 09:51	ZTS	ZTS270617C00100000	call	100.0000	2027-06-17	4.4000	4.3000	4.4000	76.0000	32120.00	32120.00	0.00	73	5	192	199	0.964824120603015	0.388521363822403	0.388521363822403	false	false	false	true
e5a1e0f9-d5ec-4d7e-8ccd-3f4308bb48b2	2026-08-20 10:02	2026-08-20 10:02	2026-08-20 10:02	ZTS	ZTS261218C00085000	call	85.0000	2026-12-18	3.9000	3.6000	3.9000	75.4150	15599.00	15599.00	0.00	40	5	44	358	0.122905027932961	0.406682758467847	0.40606811879638	false	false	false	true
8698f761-5a2a-4b55-bf6b-8a85855ac285	2026-08-20 13:46	2026-08-20 13:46	2026-08-20 13:46	ZTS	ZTS270617C00080000	call	80.0000	2027-06-17	9.2000	9.2000	10.3000	75.5100	92000.00	0.00	92000.00	100	6	102	271	0.376383763837638	0.367025440820606	0.367025440820606	false	false	false	true
89b3be16-0ba0-44aa-886b-9b6ce56c38b6	2026-08-21 10:34	2026-08-21 10:34	2026-08-21 10:34	ZTS	ZTS260918C00085000	call	85.0000	2026-09-18	1.0000	0.8000	1.0500	77.8100	22700.00	14200.00	8500.00	227	13	1628	1802	0.903440621531632	0.380965160173874	0.379230882919222	true	false	false	true
a74716d3-d18f-4098-93cb-131de33743b9	2026-08-21 10:34	2026-08-21 10:34	2026-08-21 10:34	ZTS	ZTS260918C00085000	call	85.0000	2026-09-18	1.1000	1.0500	1.1000	77.8100	11000.00	11000.00	0.00	100	19	2501	1802	1.38790233074362	0.394571973225476	0.394571973225476	false	false	false	true
16944668-6fc4-43cf-bc7d-717c2d3b889e	2026-08-21 10:34	2026-08-21 10:34	2026-08-21 10:34	ZTS	ZTS260918C00085000	call	85.0000	2026-09-18	1.1000	1.0500	1.1000	77.8500	11000.00	11000.00	0.00	100	15	2601	1802	1.44339622641509	0.393156347832155	0.393156347832155	false	false	false	true
e8a4a6f3-0f5c-4eeb-8515-03dc445abdb4	2026-08-21 14:43	2026-08-21 14:42	2026-08-21 14:42	ZTS	ZTS261016C00090000	call	90.0000	2026-10-16	1.2500	1.1500	1.2500	77.8200	37375.00	37375.00	0.00	299	31	385	878	0.438496583143508	0.39048204663371	0.39048204663371	false	false	false	true
ca5f8515-8b8b-46c3-94e0-8ec879bc0ff0	2026-08-24 09:36	2026-08-24 09:36	2026-08-24 09:36	ZTS	ZTS260918C00085000	call	85.0000	2026-09-18	0.9000	0.8500	1.0500	77.6400	29977.00	97.00	29880.00	333	15	401	2857	0.140357017850893	0.391225467934048	0.403415769845004	false	false	false	true
b4894519-c9d1-45c4-bfa3-372f97834326	2026-08-24 10:30	2026-08-24 10:30	2026-08-24 10:30	ZTS	ZTS260918P00075000	put	75.0000	2026-09-18	1.7500	1.7500	1.8000	77.2300	19950.00	0.00	19950.00	114	7	285	2648	0.107628398791541	0.352538405690394	0.352538405690394	false	false	false	true
5894330f-7b10-4482-9786-4a7c9259e16c	2026-08-24 13:29	2026-08-24 13:29	2026-08-24 13:29	ZTS	ZTS260918C00080000	call	80.0000	2026-09-18	1.7000	1.7000	1.8000	76.7700	10540.00	0.00	10540.00	62	8	936	2867	0.326473665852808	0.363517371451974	0.363517371451974	false	false	false	true
51c8b624-d90f-4e46-aca1-e76971856be1	2026-08-25 14:27	2026-08-25 14:27	2026-08-25 14:27	ZTS	ZTS261218P00065000	put	65.0000	2026-12-18	2.1000	1.9500	2.1000	77.0000	19530.00	19530.00	0.00	93	13	113	1484	0.0761455525606469	0.421440236842473	0.421440236842473	false	false	false	true
13964c94-50f9-4524-8629-9297c652dc75	2026-08-26 10:04	2026-08-26 10:04	2026-08-26 10:04	ZTS	ZTS261016P00070000	put	70.0000	2026-10-16	1.0500	1.0500	1.1000	78.3200	21000.00	0.00	7980.00	200	8	214	1651	0.12961841308298	0.360669743845419	0.360669743845419	true	false	false	true
8ff3212e-5872-40e6-80f4-7b6523a780d4	2026-08-26 10:33	2026-08-26 10:33	2026-08-26 10:33	ZTS	ZTS261016C00075000	call	75.0000	2026-10-16	6.2000	6.2000	6.4000	78.2300	34100.00	0.00	34100.00	55	17	183	355	0.515492957746479	0.363280635714238	0.363280635714238	false	false	false	true
9328c61f-7818-4473-9d45-a3e44a63a926	2026-08-26 13:20	2026-08-26 13:19	2026-08-26 13:19	ZTS	ZTS270115C00105000	call	105.0000	2027-01-15	1.6000	1.5000	1.6500	78.0900	16160.00	2080.00	14080.00	101	7	111	3424	0.0324182242990654	0.412023454533566	0.412023454533566	false	false	false	true
458c4a0f-18af-4ea9-b92d-973dce421c9f	2026-08-27 10:28	2026-08-27 10:28	2026-08-27 10:28	ZTS	ZTS270115P00070000	put	70.0000	2027-01-15	4.6000	4.6000	4.7000	75.0740	18400.00	0.00	18400.00	40	5	41	1429	0.0286913925822253	0.40779694165754	0.40779694165754	false	false	false	true
6a6261be-e695-41e6-8af1-eb84f891bd55	2026-08-28 12:04	2026-08-28 12:04	2026-08-28 12:04	ZTS	ZTS270319C00090000	call	90.0000	2027-03-19	5.4000	5.1000	5.4000	76.0000	29700.00	29700.00	0.00	55	7	106	2231	0.0475123263110713	0.409726411807292	0.409726411807292	false	false	false	true
80b620c9-7b14-4b2e-b12f-f3e8793395e1	2026-09-01 12:00	2026-09-01 11:59	2026-09-01 11:59	ZTS	ZTS270617C00100000	call	100.0000	2027-06-17	4.7000	4.6000	5.2000	76.9700	15980.00	0.00	15980.00	34	9	42	522	0.0804597701149425	0.39643252200951	0.39643252200951	false	false	false	true
2d25ce0a-fc16-46ca-8463-b7fc0b17dc79	2026-09-03 12:25	2026-09-03 12:24	2026-09-03 12:24	ZTS	ZTS260918P00075000	put	75.0000	2026-09-18	1.7000	1.7000	1.7500	75.7600	68000.00	0.00	68000.00	400	30	533	3583	0.148758024002233	0.34645405868686	0.34645405868686	true	false	false	true
5349835d-f878-4171-9b55-f3de49a0e4d3	2026-09-09 11:01	2026-09-09 11:01	2026-09-09 11:01	ZTS	ZTS261218P00070000	put	70.0000	2026-12-18	4.4000	4.3000	4.6000	73.4500	110440.00	6600.00	59400.00	251	36	256	1039	0.246390760346487	0.422843599526794	0.422843599526794	true	false	false	true
c70f1940-98b7-4311-802f-7e66ff6de5a1	2026-09-09 11:01	2026-09-09 11:01	2026-09-09 11:01	ZTS	ZTS270115P00075000	put	75.0000	2027-01-15	7.5000	7.4000	7.8000	73.4550	21000.00	0.00	21000.00	28	5	31	2815	0.01101243339254	0.41397104014099	0.41397104014099	false	false	false	true
f272f597-a1c6-4874-a819-99d0ed425dc9	2026-09-09 12:44	2026-09-09 12:44	2026-09-09 12:44	ZTS	ZTS261016C00080000	call	80.0000	2026-10-16	1.3000	1.3000	1.4500	73.4100	38220.00	0.00	38220.00	294	33	359	2112	0.169981060606061	0.37071251161115	0.37071251161115	false	false	false	true
fb43892d-f4ac-4295-b343-f5cff19f010d	2026-09-11 13:20	2026-09-11 13:20	2026-09-11 13:20	ZTS	ZTS261218P00075000	put	75.0000	2026-12-18	7.1000	7.1000	7.2000	72.8700	15620.00	0.00	15620.00	22	7	112	970	0.115463917525773	0.423623517491477	0.423623517491477	false	false	false	true
d1c09cd3-0e24-4629-b1fc-18f0c40ede06	2026-09-14 09:44	2026-09-14 09:44	2026-09-14 09:44	ZTS	ZTS261218P00075000	put	75.0000	2026-12-18	6.5000	6.5000	6.9000	74.0000	22100.00	0.00	22100.00	34	9	37	1067	0.0346766635426429	0.432095321403983	0.432095321403983	true	false	false	true
3ab71488-084e-4736-95e4-5738525a9b91	2026-09-14 10:34	2026-09-14 10:34	2026-09-14 10:34	ZTS	ZTS261218P00075000	put	75.0000	2026-12-18	6.6000	6.6000	6.8000	73.8100	10560.00	0.00	10560.00	16	6	63	1067	0.0590440487347704	0.426162771728691	0.426162771728691	false	false	false	true
071973d0-8806-4147-9f8b-62737e62986a	2026-09-14 11:39	2026-09-14 11:39	2026-09-14 11:39	ZTS	ZTS261016P00080000	put	80.0000	2026-10-16	6.7000	6.7000	7.0000	74.2700	53600.00	0.00	28140.00	80	26	80	761	0.105124835742444	0.361284568224229	0.361284568224229	true	false	false	true
757b90c9-80b6-459b-8440-f054b590d136	2026-09-15 11:40	2026-09-15 11:39	2026-09-15 11:39	ZTS	ZTS261218P00075000	put	75.0000	2026-12-18	6.7000	6.7000	6.9000	73.5600	13400.00	0.00	13400.00	20	7	27	1137	0.0237467018469657	0.42715577229619	0.42715577229619	false	false	false	true
a46b738d-ffc2-43c5-b322-48cd8953f631	2026-09-15 13:39	2026-09-15 13:39	2026-09-15 13:39	ZTS	ZTS261218P00075000	put	75.0000	2026-12-18	6.9000	6.9000	7.0000	73.2500	13800.00	0.00	13800.00	20	7	49	1137	0.0430958663148637	0.43068530442376	0.43068530442376	false	false	false	true
85f1d0a3-d5bb-43ce-8340-8034af01efb0	2026-09-15 15:36	2026-09-15 15:36	2026-09-15 15:36	ZTS	ZTS261218P00065000	put	65.0000	2026-12-18	2.4500	2.2500	2.4500	73.2100	28665.00	28665.00	0.00	117	14	178	1936	0.0919421487603306	0.42216967103007	0.42216967103007	false	false	false	true
af048771-ffb6-43fc-b8d0-bdfc9e395991	2026-09-16 10:50	2026-09-16 10:50	2026-09-16 10:50	ZTS	ZTS261218P00075000	put	75.0000	2026-12-18	6.7000	6.7000	6.8000	73.3750	11390.00	0.00	11390.00	17	7	26	1188	0.0218855218855219	0.423237955913285	0.423237955913285	false	false	false	true
1b97f9b5-09d5-46ca-ac25-039cb0aae754	2026-09-16 11:59	2026-09-16 11:58	2026-09-16 11:58	ZTS	ZTS270115C00090000	call	90.0000	2027-01-15	2.2000	1.9000	2.2000	73.6800	10996.00	9016.00	0.00	50	17	52	1523	0.0341431385423506	0.400298458783615	0.400298458783615	true	false	false	true
f2b8eeac-5567-429f-964c-0d18c9248a37	2026-09-16 15:40	2026-09-16 15:40	2026-09-16 15:40	ZTS	ZTS261218C00075000	call	75.0000	2026-12-18	5.3000	5.3000	5.5000	73.1800	48230.00	0.00	48230.00	91	17	99	838	0.118138424821002	0.391311178408129	0.391311178408129	false	false	false	true
91f4a4c3-5115-4cd3-bacf-74bdcb60406b	2026-09-17 10:10	2026-09-17 10:10	2026-09-17 10:10	ZTS	ZTS261016P00070000	put	70.0000	2026-10-16	1.5000	1.5000	1.5500	72.5100	29550.00	0.00	29550.00	197	16	231	2588	0.089258114374034	0.330615683167845	0.330615683167845	false	false	false	true
bd1fb194-489d-49d2-b0bd-194bc5b2cdb0	2026-09-17 12:13	2026-09-17 12:12	2026-09-17 12:12	ZTS	ZTS261016C00080000	call	80.0000	2026-10-16	0.6500	0.6500	0.7000	72.3200	11245.00	0.00	11245.00	173	32	234	2701	0.0866345797852647	0.352985309899052	0.352985309899052	false	false	false	true
f1a71abd-ca8b-4572-b70a-bbc52cbd8ec7	2026-09-17 13:36	2026-09-17 13:36	2026-09-17 13:36	ZTS	ZTS261016C00075000	call	75.0000	2026-10-16	1.8000	1.7500	1.9000	72.4800	21784.00	1620.00	20164.00	121	32	232	1277	0.18167580266249	0.337751160339506	0.337751160339506	false	false	false	true