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 = RepeatedHitsDescendingFill×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	expiry

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	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Healthcare	30442182759.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-17T19:12:06.484541Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
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
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
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
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
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
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
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
e77522e9-4b63-4101-9c79-a16800344ea0	2026-09-15 11:11	2026-09-15 11:11	2026-09-15 11:11	ZTS	ZTS260918P00075000	put	75.0000	2026-09-18	2.0200	1.8500	2.1000	73.5800	20186.00	20186.00	0.00	100	9	136	3330	0.0408408408408408	0.483069883979861	0.432255190488332	false	false	false	true
c44a616e-0e6f-4a92-8e6e-51c446cb22d6	2026-09-16 15:22	2026-09-16 15:22	2026-09-16 15:22	ZTS	ZTS260918C00070000	call	70.0000	2026-09-18	3.1100	3.0000	3.5000	73.0450	12452.00	0.00	12452.00	40	6	43	244	0.176229508196721	0.385643934058115	0.385643934058115	false	false	false	true
005fb8b7-d1aa-4732-8c90-345cfcce4dca	2026-09-16 15:23	2026-09-16 15:23	2026-09-16 15:23	ZTS	ZTS260918C00070000	call	70.0000	2026-09-18	3.0400	3.0000	3.5000	72.9700	13084.00	0.00	13084.00	43	5	86	244	0.352459016393443	0.38556677308629	0.38556677308629	false	false	false	true
cbc15554-0b4a-4cad-8a61-14f7d6ecd419	2026-09-18 14:13	2026-09-18 14:12	2026-09-18 14:12	ZTS	ZTS261016C00075000	call	75.0000	2026-10-16	1.5600	1.5500	1.8000	72.3300	39051.00	0.00	39051.00	250	7	1046	1379	0.758520667150109	0.321450338083974	0.321450338083974	false	false	false	true
6d460048-de67-433a-a5ad-a2ac76d1b1ee	2026-09-22 11:34	2026-09-22 11:34	2026-09-22 11:34	ZTS	ZTS261016P00070000	put	70.0000	2026-10-16	1.4000	1.2000	1.4000	72.3601	18330.00	18330.00	0.00	131	37	213	3027	0.0703666997026759	0.339150179405813	0.339150179405813	false	false	false	true