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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = unknown×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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	357369811764.00	2026-10-29	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-10T17:02:16.286608Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
49466a27-1c8a-4753-8a8e-3755e2775268	2026-09-09 15:33	2026-09-09 15:32	2026-09-09 15:32	MRK	MRK261120C00155000	call	155.0000	2026-11-20	5.9000	5.8500	6.2000	147.8900	54310.00	3570.00	50740.00	92	29	131	610	0.214754098360656	0.319500886537992	0.321449158243001	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	false
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	false
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	false
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
f4abc8fe-ce35-486a-8a57-6722a45b5ac1	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.7000	10.9500	150.4400	295340.00	0.00	295340.00	276	28	428	1174	0.364565587734242	0.300257426644819	0.300257426644819	true	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
502013f0-8e75-44bb-990b-70aec8f47ce3	2026-09-04 15:19	2026-09-04 15:19	2026-09-04 15:19	MRK	MRK270319C00185000	call	185.0000	2027-03-19	4.6000	4.4000	4.6000	150.2400	55192.00	55192.00	0.00	120	19	139	1404	0.099002849002849	0.317619462171329	0.317619462171329	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	false
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
81427ac6-df77-4c15-8917-e52a1950bc35	2026-09-03 13:55	2026-09-03 13:55	2026-09-03 13:55	MRK	MRK270617P00140000	put	140.0000	2027-06-17	10.7700	10.3000	10.8500	151.7550	256340.00	256340.00	0.00	238	12	238	132	1.8030303030303	0.344256233600555	0.344891854790701	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
9d2b0671-a2f6-4665-b4ea-436deafa415e	2026-08-31 12:38	2026-08-31 12:37	2026-08-31 12:37	MRK	MRK261120C00160000	call	160.0000	2026-11-20	4.4500	4.4000	4.6000	147.9290	58720.00	0.00	49920.00	132	7	1751	773	2.26520051746442	0.303220980499849	0.305964879929253	false	false	false	true
9fc63904-8433-48c4-bcd2-5c1edb305993	2026-08-31 11:44	2026-08-31 11:44	2026-08-31 11:44	MRK	MRK261120C00160000	call	160.0000	2026-11-20	4.5300	4.5000	4.6000	147.9500	81566.00	54101.00	27465.00	180	22	1404	773	1.81630012936611	0.308813110785697	0.308813110785697	false	false	false	true
43f9446c-3f23-4bf3-bec4-935bae0cd533	2026-08-31 11:28	2026-08-31 11:28	2026-08-31 11:28	MRK	MRK261120C00160000	call	160.0000	2026-11-20	4.3500	4.3500	4.5000	147.8800	70917.00	0.00	70917.00	163	15	1217	773	1.57438551099612	0.301906241616019	0.301906241616019	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	false
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	false
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	false
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
8d783f43-e142-409b-b23e-ea0f46fc816a	2026-08-25 10:02	2026-08-25 10:02	2026-08-25 10:02	MRK	MRK261016P00150000	put	150.0000	2026-10-16	5.2000	5.0000	5.2000	153.5600	84232.00	84232.00	0.00	162	25	169	1269	0.13317572892041	0.314946478466708	0.314946478466708	false	false	false	true	false
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
79141bfc-948d-4397-b94e-f2448705e6c1	2026-08-24 14:21	2026-08-24 14:21	2026-08-24 14:21	MRK	MRK260828C00152500	call	152.5000	2026-08-28	1.2400	1.2100	1.3600	150.5200	52369.00	5996.00	46373.00	422	11	645	568	1.13556338028169	0.32699921477781	0.323611304194669	false	false	false	true
8e959c65-b033-418a-a0fd-0e1721ca490d	2026-08-24 13:19	2026-08-24 13:19	2026-08-24 13:19	MRK	MRK260918C00150000	call	150.0000	2026-09-18	4.9500	4.6000	5.0000	151.3000	892957.00	890982.00	1975.00	1804	53	1871	4700	0.398085106382979	0.262274721603656	0.25781008502923	true	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	false
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
ac05cd25-99a4-49fa-8a7c-abebd99b3298	2026-08-24 12:40	2026-08-24 12:40	2026-08-24 12:40	MRK	MRK260918C00155000	call	155.0000	2026-09-18	2.2000	2.1900	2.4000	150.5100	79356.00	20606.00	45110.00	360	33	1739	1360	1.27867647058824	0.244230581159747	0.245431282235526	true	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
840050c9-de2e-4eec-af55-ccc984c4bc7f	2026-08-24 12:37	2026-08-24 12:36	2026-08-24 12:36	MRK	MRK260918C00165000	call	165.0000	2026-09-18	0.6000	0.5700	0.7800	150.8000	88089.00	580.00	84716.00	1477	109	1675	28213	0.0593697940665651	0.270875209706296	0.270170635063808	true	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	false
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	false