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×

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

2c52d038-a869-49b1-a0c0-c60fc6618ef8	2026-09-24 12:43	2026-09-24 12:43	2026-09-24 12:43	ZTS	ZTS280121C00070000	call	70.0000	2028-01-21	14.3000	13.8000	16.4000	70.6350	14300.00	11440.00	2860.00	10	5	10	315	0.0317460317460317	0.374662249802565	0.374662249802565	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	29590942139.00	2026-11-03	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T16:45:03.999525Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
f733be8d-62f8-46c3-b0f2-841c77cbd0c9	2026-09-24 12:09	2026-09-24 12:09	2026-09-24 12:09	ZTS	ZTS261016P00070000	put	70.0000	2026-10-16	1.9500	1.8500	1.9500	70.0000	34503.00	34503.00	0.00	177	31	318	3152	0.100888324873096	0.328622359295151	0.328622359295151	true	false	false	true
4cd74920-e83c-4ba1-9bd4-37456b43a734	2026-09-24 11:19	2026-09-24 11:18	2026-09-24 11:18	ZTS	ZTS261218P00070000	put	70.0000	2026-12-18	4.9000	4.6000	5.0000	70.7900	10780.00	5880.00	3920.00	22	8	28	1503	0.0186294078509647	0.416242816941655	0.416242816941655	false	false	false	true
44f0bcef-2a9a-4370-9912-cb768807d169	2026-09-24 10:51	2026-09-24 10:51	2026-09-24 10:51	ZTS	ZTS261120P00065000	put	65.0000	2026-11-20	2.1200	1.9500	2.3000	70.9840	169600.00	68800.00	100800.00	800	2	814	415	1.96144578313253	0.43225117623435	0.43225117623435	false	true	false	true
8a24529e-8c32-4055-a66a-eadac862ef1d	2026-09-22 11:58	2026-09-22 11:58	2026-09-22 11:58	ZTS	ZTS280121C00100000	call	100.0000	2028-01-21	5.1000	5.1000	6.2000	72.0200	24990.00	0.00	24990.00	49	8	65	988	0.0657894736842105	0.351583612393142	0.351583612393142	false	false	false	true
b9af0db6-2601-46a8-9102-ebe9b6c912da	2026-09-22 11:33	2026-09-22 11:33	2026-09-22 11:33	ZTS	ZTS261016C00075000	call	75.0000	2026-10-16	1.7000	1.7000	1.7500	72.0000	10200.00	0.00	9860.00	60	13	278	2707	0.102696712227558	0.358408394229012	0.358408394229012	true	false	false	true
20806da3-ae51-422e-afe6-a454ed57e3ac	2026-09-21 13:32	2026-09-21 13:32	2026-09-21 13:32	ZTS	ZTS261016C00075000	call	75.0000	2026-10-16	1.2500	1.2000	1.2500	71.4850	12375.00	12375.00	0.00	99	25	801	2305	0.347505422993492	0.337222911684515	0.337222911684515	true	false	false	true
6e14ff84-c746-420b-8147-6726e8392853	2026-09-21 13:24	2026-09-21 13:24	2026-09-21 13:24	ZTS	ZTS261120P00065000	put	65.0000	2026-11-20	1.8500	1.8000	1.8500	71.7100	11100.00	555.00	0.00	60	6	141	30	4.7	0.414617242383552	0.414617242383552	false	false	false	true
c2b2f12b-b599-4c17-a563-a815bd5d0c07	2026-09-21 11:22	2026-09-21 11:22	2026-09-21 11:22	ZTS	ZTS261120C00080000	call	80.0000	2026-11-20	1.7500	1.7000	1.9500	71.0800	13825.00	10500.00	1575.00	79	12	643	54	11.9074074074074	0.397316393400749	0.397316393400749	false	false	false	true
1fd678e1-14a8-46b0-a2d2-34114fbab913	2026-09-21 11:05	2026-09-21 11:05	2026-09-21 11:05	ZTS	ZTS261016P00070000	put	70.0000	2026-10-16	1.8000	1.7000	1.8000	71.1399	21955.00	21955.00	0.00	122	21	340	2994	0.113560454241817	0.327195143673278	0.327195143673278	false	false	false	true
45955390-89ef-450b-8eb7-07e34920478b	2026-09-21 10:59	2026-09-21 10:59	2026-09-21 10:59	ZTS	ZTS261016P00080000	put	80.0000	2026-10-16	9.0000	8.6000	9.0000	71.1700	49500.00	49500.00	0.00	55	8	65	755	0.0860927152317881	0.359820452263371	0.359820452263371	false	false	false	true
a6a9deda-1e9c-4af7-b4c6-f08bf4f847e5	2026-09-21 10:13	2026-09-21 10:13	2026-09-21 10:13	ZTS	ZTS280121C00085000	call	85.0000	2028-01-21	8.8000	8.7000	8.8000	70.5450	25520.00	25520.00	0.00	29	5	29	122	0.237704918032787	0.375587584324338	0.375587584324338	false	false	false	true
58ca097d-d612-49a6-be74-3d8b2f0568c4	2026-09-18 11:59	2026-09-18 11:59	2026-09-18 11:59	ZTS	ZTS261120C00085000	call	85.0000	2026-11-20	1.2500	1.2000	1.4500	72.5400	105925.00	14875.00	91050.00	845	18	858	11	78	0.396360559850282	0.40386203868604	false	false	false	true
f207000e-4270-490d-b51a-4baf75c5e9b3	2026-09-18 09:58	2026-09-18 09:58	2026-09-18 09:58	ZTS	ZTS261016C00075000	call	75.0000	2026-10-16	1.6500	1.6500	1.8000	72.3750	29535.00	0.00	29535.00	179	31	188	1379	0.13633067440174	0.32976264540422	0.32976264540422	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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