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:sector = Healthcare×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
8f70e465-7bd7-4d67-a215-339029e695c7	2026-08-17 14:47	2026-08-17 14:47	2026-08-17 14:47	ZTS	ZTS260918C00075000	call	75.0000	2026-09-18	1.9700	1.9500	2.1000	72.5200	19083.00	0.00	19083.00	97	9	380	2723	0.139551964744767	0.339544054143095	0.339544054143095	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
90cb7fb1-cfba-4953-9b93-fde38b89da56	2026-08-19 11:20	2026-08-19 11:20	2026-08-19 11:20	ZTS	ZTS270115C00090000	call	90.0000	2027-01-15	3.4100	3.4000	3.7000	76.8800	13624.00	0.00	13624.00	40	5	57	1191	0.0478589420654912	0.377076267395653	0.377076267395653	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
2ef95d31-520e-41c2-a665-e79ffa0516cf	2026-08-19 14:08	2026-08-19 14:07	2026-08-19 14:07	ZTS	ZTS280121C00075000	call	75.0000	2028-01-21	16.5000	16.5000	17.2000	77.2300	94051.00	0.00	94051.00	57	5	158	36546	0.00432331855743447	0.371267716109914	0.370970419610111	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
6042c726-dc48-4418-8f6b-3b2ad06fa8fd	2026-08-19 14:56	2026-08-19 14:56	2026-08-19 14:56	ZTS	ZTS270115C00085000	call	85.0000	2027-01-15	5.1000	4.8000	5.1000	77.1000	20394.00	20394.00	0.00	40	6	61	726	0.0840220385674931	0.388091482284867	0.388091482284867	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
d375649f-2ca2-40c4-9e69-03b66df77b29	2026-08-20 10:56	2026-08-20 10:56	2026-08-20 10:56	ZTS	ZTS270115C00085000	call	85.0000	2027-01-15	4.4800	4.0000	4.6000	75.6107	11201.00	11201.00	0.00	25	5	32	732	0.0437158469945355	0.389073260312008	0.389073260312008	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
cf9d4a89-29f4-47a4-b18a-547d01162e1c	2026-08-21 10:08	2026-08-21 10:08	2026-08-21 10:08	ZTS	ZTS261218C00100000	call	100.0000	2026-12-18	1.5600	1.4000	1.6000	76.9400	16659.00	16504.00	0.00	107	12	122	561	0.2174688057041	0.419624269555525	0.415237712422358	false	false	false	true
19bf0c8e-4acd-47cf-8b45-027ff8458aa0	2026-08-21 10:32	2026-08-21 10:32	2026-08-21 10:32	ZTS	ZTS260918C00085000	call	85.0000	2026-09-18	0.9000	0.7500	0.9000	77.4900	89986.00	89986.00	0.00	1000	69	1202	1802	0.667036625971143	0.378035656006594	0.374315617704681	true	false	false	true
6d69161f-aece-4b70-9775-3030cb4c9e44	2026-08-21 10:33	2026-08-21 10:33	2026-08-21 10:33	ZTS	ZTS260918C00085000	call	85.0000	2026-09-18	0.9500	0.8000	0.9500	77.6200	12442.00	12442.00	0.00	131	31	1333	1802	0.739733629300777	0.377954313200417	0.377923479913228	true	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
93111daa-23aa-43b2-96db-d25de9f3ad3e	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	0.9000	1.1000	77.8360	84679.00	84679.00	0.00	770	52	2399	1802	1.33129855715871	0.393651894677292	0.393651894677292	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
f69d65db-8543-4759-9ae9-6f4e080286e1	2026-08-21 11:45	2026-08-21 11:45	2026-08-21 11:45	ZTS	ZTS270319C00105000	call	105.0000	2027-03-19	2.7700	2.2000	3.1000	77.8000	11088.00	11088.00	0.00	40	11	40	59	0.677966101694915	0.408329387372255	0.408329387372255	false	false	false	true
ba83c724-2d23-4e03-8da5-fcafe66158e0	2026-08-21 13:13	2026-08-21 13:13	2026-08-21 13:13	ZTS	ZTS260918C00085000	call	85.0000	2026-09-18	0.9600	0.9500	1.0500	77.5550	12915.00	0.00	12915.00	135	21	5362	1802	2.97558268590455	0.383329418462117	0.380149536915011	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
81ecd0af-3289-4c62-98d4-bb4a6033911a	2026-08-24 11:08	2026-08-24 11:08	2026-08-24 11:08	ZTS	ZTS280121C00220000	call	220.0000	2028-01-21	1.0400	0.5500	1.0500	77.1500	10375.00	9975.00	0.00	100	29	100	1275	0.0784313725490196	0.44709159412313	0.469565831992128	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
bd7a5c7f-2344-4020-8129-3bf8a91dc74b	2026-08-28 11:47	2026-08-28 11:47	2026-08-28 11:47	ZTS	ZTS270319C00090000	call	90.0000	2027-03-19	5.0700	4.4000	5.6000	76.0000	15198.00	15198.00	0.00	30	14	31	2231	0.0138951142985208	0.398547363732665	0.398547363732665	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
3978e406-afd0-403a-877f-2bc55a5b1137	2026-08-31 14:56	2026-08-31 14:55	2026-08-31 14:55	ZTS	ZTS261218C00090000	call	90.0000	2026-12-18	2.7800	2.7500	2.9000	76.9150	10269.00	0.00	10269.00	37	6	409	657	0.622526636225266	0.404085419695833	0.404085419695833	false	false	false	true
ee509fa4-e136-47fc-bf84-bf8b57b87e03	2026-09-01 10:18	2026-09-01 10:18	2026-09-01 10:18	ZTS	ZTS270115C00090000	call	90.0000	2027-01-15	3.7400	2.5500	3.8000	77.3100	12722.00	12722.00	0.00	34	7	40	1484	0.0269541778975741	0.406790968433855	0.406790968433855	false	false	false	true
1885627d-2ffe-4160-a0f2-cdfa49c01261	2026-09-01 10:22	2026-09-01 10:22	2026-09-01 10:22	ZTS	ZTS280121C00085000	call	85.0000	2028-01-21	12.9000	12.9000	15.4000	77.5550	25790.00	0.00	25790.00	20	7	40	111	0.36036036036036	0.382542513776135	0.383930552891185	true	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