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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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 = MRK×

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

0bf36e47-5958-49b4-a644-b4474047533c	2026-09-11 15:08	2026-09-11 15:08	2026-09-11 15:08	MRK	MRK261120C00160000	call	160.0000	2026-11-20	2.6600	2.6000	2.7100	144.0300	63308.00	1596.00	35112.00	238	43	493	2548	0.193485086342229	0.301049982836566	0.301049982836566	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	357369811764.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-11T19:33:39.972411Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
c0284249-ba5d-45d1-8ff4-403cecbc1226	2026-09-11 12:17	2026-09-11 12:17	2026-09-11 12:17	MRK	MRK260925C00140000	call	140.0000	2026-09-25	5.5500	4.8000	5.5500	144.8700	55500.00	55500.00	0.00	100	6	100	523	0.191204588910134	0.189927640882408	0.189927640882408	false	false	false	true
35d5fb7a-751c-4806-ba29-3e989b5cfa96	2026-09-10 15:05	2026-09-10 15:05	2026-09-10 15:05	MRK	MRK270115C00165000	call	165.0000	2027-01-15	4.2000	4.2000	4.4000	144.8800	60905.00	425.00	60480.00	145	21	405	2053	0.197272284461763	0.301014215375654	0.301014215375654	true	false	false	true
cc16a698-a543-4b5d-8ab1-7aa82c38f049	2026-09-10 12:48	2026-09-10 12:48	2026-09-10 12:48	MRK	MRK270115C00165000	call	165.0000	2027-01-15	4.3000	4.3000	4.5500	144.0000	95890.00	0.00	95890.00	223	14	227	2053	0.110569897710667	0.304941435607971	0.304941435607971	true	false	false	true
62d28833-bced-4a00-99e2-d6c10d7d2131	2026-09-09 13:07	2026-09-09 13:06	2026-09-09 13:06	MRK	MRK261009P00147000	put	147.0000	2026-10-09	4.5500	4.5000	4.9500	147.0000	133315.00	455.00	132860.00	293	42	298	3	99.3333333333333	0.306110887491764	0.306641222903161	false	false	false	true
027f537b-7eb3-41ce-a6bf-da73f3c5c5cf	2026-09-09 11:26	2026-09-09 11:26	2026-09-09 11:26	MRK	MRK280121P00095000	put	95.0000	2028-01-21	3.1500	3.1500	3.3500	147.6000	119700.00	0.00	119700.00	380	32	382	942	0.40552016985138	0.375702186838478	0.375702186838478	false	false	false	true
2ac83672-8adb-4037-9150-b1fc9389011d	2026-09-09 11:24	2026-09-09 11:24	2026-09-09 11:24	MRK	MRK270617P00150000	put	150.0000	2027-06-17	17.3000	16.6500	17.3500	147.5200	64010.00	64010.00	0.00	37	10	67	233	0.28755364806867	0.360489526697969	0.360489526697969	false	false	false	true
56083bcd-aa00-4529-a116-e0d3d9faacb1	2026-09-09 11:13	2026-09-09 11:13	2026-09-09 11:13	MRK	MRK270115C00150000	call	150.0000	2027-01-15	10.4000	10.1000	10.4000	147.5000	255840.00	255840.00	0.00	246	27	259	2892	0.0895573997233748	0.304294157898756	0.304294157898756	false	false	false	true
e108b3a8-1ba0-4342-ad48-11679688e6f4	2026-09-04 15:53	2026-09-04 15:53	2026-09-04 15:53	MRK	MRK261218C00150000	call	150.0000	2026-12-18	10.7000	10.6000	10.7000	150.4800	104860.00	50290.00	0.00	98	6	152	1174	0.129471890971039	0.299541570509209	0.299541570509209	false	false	false	true
7d54aca7-4063-4251-9a07-2518728e0d22	2026-09-04 13:03	2026-09-04 13:03	2026-09-04 13:03	MRK	MRK261016C00155000	call	155.0000	2026-10-16	3.6000	3.5500	3.6000	150.3300	52560.00	52560.00	0.00	146	20	1309	3174	0.412413358538122	0.259842672199651	0.259842672199651	false	false	false	true
4b0e450c-a043-4700-b16d-a26071b00edd	2026-09-04 12:52	2026-09-04 12:52	2026-09-04 12:52	MRK	MRK261016C00155000	call	155.0000	2026-10-16	3.5000	3.5000	3.5500	150.2000	57400.00	0.00	57400.00	164	27	1144	3174	0.360428481411468	0.257388824230642	0.257388824230642	false	false	false	true
3badfc14-5e2e-4d3f-b162-bc464b8dbf8d	2026-09-03 14:43	2026-09-03 14:43	2026-09-03 14:43	MRK	MRK261009C00165000	call	165.0000	2026-10-09	1.2900	1.2800	1.4000	152.0400	59598.00	129.00	59469.00	462	25	475	2	237.5	0.269724474145648	0.269724474145648	false	false	false	true
a713fb08-f7b0-47ce-b7bf-ea8f7ec41874	2026-09-03 13:55	2026-09-03 13:55	2026-09-03 13:55	MRK	MRK270617C00160000	call	160.0000	2027-06-17	14.7000	14.7000	14.9000	151.7550	349860.00	0.00	349860.00	238	6	239	762	0.313648293963255	0.305553672502302	0.305553672502302	false	false	false	true
d81ef097-eb3a-4ff8-8601-b81a98212fc1	2026-09-03 12:37	2026-09-03 12:37	2026-09-03 12:37	MRK	MRK260918P00145000	put	145.0000	2026-09-18	1.2300	1.2300	1.3800	151.2750	57933.00	0.00	57933.00	471	48	477	2740	0.174087591240876	0.299205497738872	0.299205497738872	false	false	false	true
05d5eae2-a61c-4f75-aafe-dd1a510a2e43	2026-09-02 14:44	2026-09-02 14:44	2026-09-02 14:44	MRK	MRK270617P00145000	put	145.0000	2027-06-17	13.1000	12.7500	13.1000	151.1400	62880.00	62880.00	0.00	48	10	51	142	0.359154929577465	0.350241403555271	0.350241403555271	false	false	false	true
bffa3164-a1c2-456d-939f-371dae38337d	2026-09-02 14:43	2026-09-02 14:43	2026-09-02 14:43	MRK	MRK280121C00130000	call	130.0000	2028-01-21	35.3000	34.4500	35.7500	151.1400	120020.00	28240.00	91780.00	34	5	92	606	0.151815181518152	0.269684126784879	0.269684126784879	false	false	false	true
0d662bdd-88d5-4e4f-a819-239fadeb110f	2026-08-31 11:25	2026-08-31 11:25	2026-08-31 11:25	MRK	MRK261120C00160000	call	160.0000	2026-11-20	4.3800	4.3500	4.6000	147.8650	148145.00	98120.00	50025.00	338	12	576	773	0.745148771021992	0.30210478145756	0.30210478145756	false	false	false	true
1b3e4993-282a-4374-86cf-3b29f681fffb	2026-08-28 15:25	2026-08-28 15:25	2026-08-28 15:25	MRK	MRK261218C00155000	call	155.0000	2026-12-18	7.6000	7.3500	7.6000	148.0100	66120.00	66120.00	0.00	87	8	104	3146	0.0330578512396694	0.299856064450517	0.299856064450517	false	false	false	true
1eafcaa9-b1f7-4607-aba3-99b6c36aefa1	2026-08-28 12:04	2026-08-28 12:04	2026-08-28 12:04	MRK	MRK260904C00148000	call	148.0000	2026-09-04	2.0300	1.7400	2.0300	147.0000	219443.00	219443.00	0.00	1081	35	1116	20	55.8	0.258391544478294	0.258391544478294	false	false	false	true
eec0c08a-22f1-46d1-adea-78add2b80202	2026-08-28 10:37	2026-08-28 10:36	2026-08-28 10:36	MRK	MRK260918C00145000	call	145.0000	2026-09-18	5.4000	5.2500	5.6500	148.1150	77760.00	44280.00	16740.00	144	19	152	8873	0.0171306209850107	0.243647155294505	0.243647155294505	false	false	false	true
25be3b2d-5482-4fa6-aa15-9dde3c2f5384	2026-08-27 15:43	2026-08-27 15:43	2026-08-27 15:43	MRK	MRK261218C00155000	call	155.0000	2026-12-18	8.7000	8.4000	8.7500	150.2050	127020.00	126150.00	870.00	146	28	208	3099	0.0671184252984834	0.300460114865376	0.300460114865376	false	false	false	true
9efa8950-3870-46a0-bb2b-051cdce03a24	2026-08-26 12:58	2026-08-26 12:58	2026-08-26 12:58	MRK	MRK261218C00150000	call	150.0000	2026-12-18	13.1000	12.8500	13.3500	153.3950	112660.00	110040.00	2620.00	86	23	101	1056	0.0956439393939394	0.308101098652673	0.308101098652673	false	false	false	true
6907db5f-c863-479e-9806-549c2c6d396c	2026-08-26 10:24	2026-08-26 10:24	2026-08-26 10:24	MRK	MRK260904C00155000	call	155.0000	2026-09-04	2.6000	2.6000	3.0000	154.1100	369720.00	0.00	369720.00	1422	46	1430	194	7.37113402061856	0.305671183193837	0.305671183193837	true	false	false	true
8f0e0ff9-b4d8-4658-aba4-c563a229dc08	2026-08-25 14:10	2026-08-25 14:10	2026-08-25 14:10	MRK	MRK261218C00170000	call	170.0000	2026-12-18	6.9000	6.8000	7.0000	156.0000	57270.00	11040.00	46230.00	83	11	105	591	0.177664974619289	0.322756613131594	0.322756613131594	false	false	false	true
8c9e24e4-9418-4c3d-b1bf-e68d82c84af0	2026-08-25 13:55	2026-08-25 13:55	2026-08-25 13:55	MRK	MRK261120C00175000	call	175.0000	2026-11-20	4.1000	4.1000	4.1500	156.2800	103730.00	0.00	103730.00	253	7	363	229	1.58515283842795	0.327937809742558	0.328157805686017	false	false	false	true
7ce618f3-1980-42bb-b325-078751cb75f1	2026-08-25 13:45	2026-08-25 13:44	2026-08-25 13:44	MRK	MRK261120C00170000	call	170.0000	2026-11-20	5.1000	5.0000	5.2000	155.6000	318750.00	0.00	238680.00	625	8	829	362	2.29005524861878	0.326499793772502	0.325891694493698	false	false	false	true
4a72d3fb-b59b-4cad-a5ca-32d0a8261c0c	2026-08-25 11:41	2026-08-25 11:41	2026-08-25 11:41	MRK	MRK270319C00185000	call	185.0000	2027-03-19	6.1000	6.1000	6.2000	153.7100	53070.00	0.00	53070.00	87	15	530	26	20.3846153846154	0.324044176798516	0.324044176798516	false	false	false	true
de4467b9-a0d7-4897-b5ee-e1cda8c8c690	2026-08-25 11:41	2026-08-25 11:41	2026-08-25 11:41	MRK	MRK270319C00185000	call	185.0000	2027-03-19	6.1000	6.1000	6.5500	153.7100	212290.00	0.00	212290.00	348	17	390	26	15	0.3233807332268	0.324044176798516	false	false	false	true
7ff51dac-59b8-4e31-bfcc-30ccd5ce3d3d	2026-08-25 10:41	2026-08-25 10:41	2026-08-25 10:41	MRK	MRK260918C00165000	call	165.0000	2026-09-18	1.0000	0.8700	1.1200	153.8300	53200.00	50000.00	3200.00	532	6	2328	40417	0.0575995249523715	0.273996409040379	0.273996409040379	true	false	false	true
5e353936-20d9-4a58-bad0-4e170a944bbd	2026-08-24 15:40	2026-08-24 15:40	2026-08-24 15:40	MRK	MRK260918P00145000	put	145.0000	2026-09-18	2.3500	2.1300	2.3500	150.4950	83425.00	83425.00	0.00	355	28	534	1709	0.312463428905793	0.306217284341418	0.306217284341418	false	false	false	true
18c1bd18-900c-4588-b6dd-a1fccef8f72f	2026-08-24 14:38	2026-08-24 14:38	2026-08-24 14:38	MRK	MRK260918C00150000	call	150.0000	2026-09-18	4.7500	4.4000	4.8000	150.7250	423225.00	419900.00	0.00	891	56	2801	4700	0.595957446808511	0.265947254544079	0.265947254544079	false	false	false	true
0566b24f-955e-4892-8114-def8da10f042	2026-08-24 12:56	2026-08-24 12:56	2026-08-24 12:56	MRK	MRK261016C00150000	call	150.0000	2026-10-16	6.7000	6.5000	6.9500	150.7100	106530.00	103850.00	2680.00	159	6	725	2773	0.261449693472773	0.25896789722997	0.25896789722997	false	false	false	true
343020da-a6a6-4acb-8039-3cd993e71de0	2026-08-24 12:54	2026-08-24 12:54	2026-08-24 12:54	MRK	MRK261016C00150000	call	150.0000	2026-10-16	6.7000	6.6500	6.8000	150.7400	117250.00	77050.00	26800.00	175	14	565	2773	0.203750450775334	0.258224241992064	0.258224241992064	false	false	false	true
af56cf0f-277b-4106-97cf-7dd02abc077b	2026-08-24 12:54	2026-08-24 12:54	2026-08-24 12:54	MRK	MRK261016C00150000	call	150.0000	2026-10-16	6.7000	6.3500	6.7000	150.6200	92460.00	92460.00	0.00	138	6	388	2773	0.139920663541291	0.261191501802032	0.261191501802032	false	false	false	true
0319f3e6-a31b-44ae-8310-6097a580519c	2026-08-24 12:53	2026-08-24 12:53	2026-08-24 12:53	MRK	MRK270115C00160000	call	160.0000	2027-01-15	8.4000	8.2000	8.4000	150.6000	94080.00	94080.00	0.00	112	14	234	850	0.275294117647059	0.29924935827297	0.29924935827297	true	false	false	true
148dced7-9de7-4c4f-b0c1-107b9e084785	2026-08-24 12:51	2026-08-24 12:51	2026-08-24 12:51	MRK	MRK261016C00150000	call	150.0000	2026-10-16	6.7000	6.4000	6.7000	150.7100	118590.00	17420.00	0.00	177	6	233	2773	0.0840245221781464	0.25896789722997	0.25896789722997	false	false	false	true
b54e5619-1daa-4c40-a0aa-f05101cedc5b	2026-08-24 12:43	2026-08-24 12:43	2026-08-24 12:43	MRK	MRK260918C00155000	call	155.0000	2026-09-18	2.2300	2.1900	2.2300	150.7250	65116.00	65116.00	0.00	292	15	2117	1360	1.55661764705882	0.242295211637508	0.242295211637508	false	false	false	true
80e6a40f-9c54-4cb8-81b1-c6e565e71279	2026-08-24 12:37	2026-08-24 12:37	2026-08-24 12:37	MRK	MRK260918C00165000	call	165.0000	2026-09-18	0.5700	0.5100	0.6500	150.7350	581685.00	0.00	581685.00	10205	5	12253	28213	0.434303335341864	0.26983264230225	0.26983264230225	false	false	false	true
9721e140-ed7f-4a03-b82a-f60a8a44a5f7	2026-08-24 10:54	2026-08-24 10:54	2026-08-24 10:54	MRK	MRK270115C00160000	call	160.0000	2027-01-15	8.1400	8.0000	8.1500	150.0350	80590.00	80590.00	0.00	99	8	105	850	0.123529411764706	0.299186053531959	0.299186053531959	true	false	false	true
a76475dc-4c22-481e-81d5-873e04fe7b7a	2026-08-24 10:28	2026-08-24 10:28	2026-08-24 10:28	MRK	MRK260828C00150000	call	150.0000	2026-08-28	2.2300	2.0700	2.2300	149.9600	223223.00	223223.00	0.00	1001	38	1130	730	1.54794520547945	0.354321743980831	0.354321743980831	false	false	false	true
100548dd-6b5a-4be7-a2e6-59af3353fc1e	2026-08-24 09:32	2026-08-24 09:32	2026-08-24 09:32	MRK	MRK270115P00140000	put	140.0000	2027-01-15	7.0000	6.4000	7.6000	150.3200	68600.00	51800.00	0.00	98	6	114	2622	0.0434782608695652	0.339972128443928	0.339972128443928	false	false	false	true
3b2e2d93-edfb-46de-b669-edaaf60aa984	2026-08-21 15:14	2026-08-21 15:13	2026-08-21 15:13	MRK	MRK260828C00152500	call	152.5000	2026-08-28	2.6900	2.4200	2.6900	152.7650	118629.00	118629.00	0.00	441	25	637	68	9.36764705882353	0.296295608096059	0.296295608096059	false	false	false	true
d685e278-6819-48fe-af65-24c63bd9550d	2026-08-21 13:22	2026-08-21 13:22	2026-08-21 13:22	MRK	MRK260918C00165000	call	165.0000	2026-09-18	0.9500	0.9400	1.0000	151.6950	445455.00	30020.00	415435.00	4689	71	15732	1979	7.94946942900455	0.280350658298801	0.281676632931152	false	false	false	true
702b4d12-7909-40ad-ac8f-9a44d6e0b29e	2026-08-21 11:30	2026-08-21 11:30	2026-08-21 11:30	MRK	MRK261016P00140000	put	140.0000	2026-10-16	2.2100	2.2100	2.4900	153.4650	113815.00	0.00	113815.00	515	25	570	385	1.48051948051948	0.315701613214276	0.315701613214276	false	false	false	true
4a22727f-664b-495d-9055-45f230eac2e9	2026-08-21 11:30	2026-08-21 11:30	2026-08-21 11:30	MRK	MRK261016C00155000	call	155.0000	2026-10-16	6.5000	6.4500	6.6500	153.4650	143037.00	13000.00	127437.00	220	26	378	695	0.543884892086331	0.283676604505048	0.283676604505048	false	false	false	true
b771fdf7-eb05-4757-8620-b52060bc8a04	2026-08-21 11:07	2026-08-21 11:07	2026-08-21 11:07	MRK	MRK260821C00138000	call	138.0000	2026-08-21	15.7500	15.1500	16.5000	153.7150	53550.00	20475.00	31500.00	34	7	40	826	0.0484261501210654	3.83781211507251	2.05598528449779	false	false	false	true
9b2e5169-5da4-44ae-8c48-104ddd440bc6	2026-08-21 10:24	2026-08-21 10:24	2026-08-21 10:24	MRK	MRK260821C00150000	call	150.0000	2026-08-21	4.1500	4.0500	4.1500	154.1300	70965.00	54365.00	0.00	171	8	604	2322	0.260120585701981	0.531849001282882	0.531849001282882	true	false	false	true
913ca457-3d1c-4757-9ba8-fd73b04415c7	2026-08-21 10:15	2026-08-21 10:15	2026-08-21 10:15	MRK	MRK261016C00165000	call	165.0000	2026-10-16	3.6000	3.1000	3.6000	154.2850	79560.00	79560.00	0.00	221	20	223	678	0.328908554572271	0.301399362655701	0.301399362655701	false	false	false	true
f04f34d0-f522-4363-9cbe-eb60c366fa99	2026-08-21 10:05	2026-08-21 10:05	2026-08-21 10:05	MRK	MRK260821C00130000	call	130.0000	2026-08-21	22.2000	22.2000	22.7000	152.2815	523920.00	0.00	523920.00	236	24	340	4480	0.0758928571428571	4.0174384165337	4.0174384165337	false	false	false	true
245638a4-0983-4e63-a71a-2e2d2981ffa7	2026-08-21 10:04	2026-08-21 10:04	2026-08-21 10:04	MRK	MRK260821C00130000	call	130.0000	2026-08-21	22.2000	22.2000	22.8000	152.2700	206460.00	0.00	206460.00	93	18	104	4480	0.0232142857142857	4.24177002131951	4.24177002131951	true	false	false	true