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:alert_rule = RepeatedHits×ticker = MRK×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

1f48e483-e61c-4d73-b5a1-9332343b7a49	2026-08-17 10:45	2026-08-17 10:45	2026-08-17 10:45	MRK	MRK280121P00135000	put	135.0000	2028-01-21	16.9500	16.1500	16.9500	136.3100	50850.00	50850.00	0.00	30	6	31	47	0.659574468085106	0.33975707895615	0.33975707895615	false	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-08-17T14:59:17.821734Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
336b8b2e-dfa7-4534-ab99-9ad83626b35c	2026-08-17 10:48	2026-08-17 10:48	2026-08-17 10:48	MRK	MRK280121P00135000	put	135.0000	2028-01-21	16.8500	16.1500	16.8500	136.2700	64030.00	64030.00	0.00	38	9	115	47	2.4468085106383	0.337874400898139	0.337874400898139	false	false	false	true
cce4f620-b923-444c-8b22-db061f79de09	2026-08-17 10:48	2026-08-17 10:48	2026-08-17 10:48	MRK	MRK280121P00135000	put	135.0000	2028-01-21	16.8500	16.1500	16.8500	136.2600	82565.00	82565.00	0.00	49	15	202	47	4.29787234042553	0.337815918850008	0.337815918850008	false	false	false	true
2e70b020-3d82-4210-ba7c-6cd6848848e6	2026-08-17 10:48	2026-08-17 10:48	2026-08-17 10:48	MRK	MRK280121P00135000	put	135.0000	2028-01-21	16.8500	16.1500	16.8500	136.2700	64030.00	64030.00	0.00	38	9	153	47	3.25531914893617	0.337874400898139	0.337874400898139	false	false	false	true
14ffd5ce-ac24-45a3-a531-e11c88eec7db	2026-08-17 11:31	2026-08-17 11:31	2026-08-17 11:31	MRK	MRK260918C00140000	call	140.0000	2026-09-18	2.3600	2.1900	2.3600	136.0300	82364.00	82364.00	0.00	349	33	590	13168	0.0448055893074119	0.237315686536329	0.237315686536329	false	false	false	true
e52b822a-fb0b-43c3-927a-1db920c117e8	2026-08-17 11:52	2026-08-17 11:51	2026-08-17 11:51	MRK	MRK270115C00120000	call	120.0000	2027-01-15	20.2500	20.1000	20.7000	136.2400	74925.00	46575.00	28350.00	37	10	139	5743	0.0242033780254223	0.249400730826662	0.249400730826662	false	false	false	true
142488fa-deed-41a3-a9ec-190c854f0d16	2026-08-17 11:58	2026-08-17 11:57	2026-08-17 11:57	MRK	MRK270319P00110000	put	110.0000	2027-03-19	2.8500	2.8500	2.9100	136.4600	52155.00	0.00	52155.00	183	6	305	1871	0.163014430785676	0.331630451406344	0.331630451406344	false	false	false	true
a2c7972a-c765-4fbf-b014-8e4343266d0b	2026-08-17 13:24	2026-08-17 13:23	2026-08-17 13:23	MRK	MRK261002C00120000	call	120.0000	2026-10-02	17.0500	17.0500	18.2500	136.3800	85250.00	0.00	85250.00	50	20	55	0	0	0.195681439834431	0.195681439834431	true	false	false	true
e33757ba-7325-4c56-912b-fca4d064efaa	2026-08-17 15:00	2026-08-17 14:59	2026-08-17 14:59	MRK	MRK260821P00135000	put	135.0000	2026-08-21	1.3300	1.2100	1.3300	135.4300	57057.00	57057.00	0.00	429	33	901	170	5.3	0.276497020100676	0.276497020100676	false	false	false	true
746c34a2-5f0b-41b3-90c3-0d88a1ac01f6	2026-08-18 11:27	2026-08-18 11:27	2026-08-18 11:27	MRK	MRK260821P00137000	put	137.0000	2026-08-21	1.8200	1.6600	1.8200	136.2000	112294.00	112294.00	0.00	617	19	618	521	1.18618042226488	0.285257951603745	0.285257951603745	false	false	false	true
4b157f97-8b35-4ab5-8fa9-a40053de5b59	2026-08-18 14:58	2026-08-18 14:58	2026-08-18 14:58	MRK	MRK271217C00135000	call	135.0000	2027-12-17	19.7000	19.7000	19.7000	135.4400	242310.00	0.00	0.00	123	13	130	182	0.714285714285714	0.257099169809508	0.257099169809508	false	false	false	true
506c7d20-2dab-4773-9960-ccc75fc72258	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	MRK	MRK260821C00135000	call	135.0000	2026-08-21	11.9000	10.3500	11.9000	146.7500	60690.00	60690.00	0.00	51	7	107	7510	0.0142476697736352	0.660096915054488	0.660096915054488	true	false	false	true
fcc373ec-cd17-4a06-9cfe-c744d0f195d4	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	MRK	MRK260828C00150000	call	150.0000	2026-08-28	2.3600	1.7800	2.3600	147.2550	54000.00	43660.00	0.00	229	5	483	5	96.6	0.377210775617683	0.377210775617683	false	false	false	true
6b8fde57-9fbc-4cc7-882b-7c948f30c094	2026-08-19 09:39	2026-08-19 09:39	2026-08-19 09:39	MRK	MRK260821C00140000	call	140.0000	2026-08-21	9.1000	7.6500	9.4000	149.0250	74620.00	4550.00	70070.00	82	16	424	6262	0.0677099968061322	0.435769841802285	0.435769841802285	false	false	false	true
f02d0cd2-be19-4b61-9d13-a9fe3f033511	2026-08-19 09:46	2026-08-19 09:46	2026-08-19 09:46	MRK	MRK260821C00135000	call	135.0000	2026-08-21	12.1000	12.1000	13.8500	148.0100	121000.00	0.00	121000.00	100	20	273	7510	0.0363515312916112	1.13223866421136	1.13223866421136	false	false	false	true
74e7cce8-f292-4698-b5a3-291f88314d43	2026-08-19 09:49	2026-08-19 09:49	2026-08-19 09:49	MRK	MRK270617C00170000	call	170.0000	2027-06-17	9.5000	8.5000	9.7500	148.6800	398045.00	397095.00	950.00	419	5	870	56	15.5357142857143	0.286361977963999	0.285942401660386	false	false	false	true
baeb09b8-771f-4197-bb0f-0065dff654c1	2026-08-19 09:51	2026-08-19 09:51	2026-08-19 09:51	MRK	MRK260918C00145000	call	145.0000	2026-09-18	7.4000	7.4000	7.7000	149.1400	125060.00	0.00	125060.00	169	13	686	17261	0.0397427727246394	0.283336572245184	0.283336572245184	false	false	false	true
193cd1ce-ef22-4c1c-9495-4bdfeafc8384	2026-08-19 09:52	2026-08-19 09:51	2026-08-19 09:51	MRK	MRK260918C00145000	call	145.0000	2026-09-18	7.4000	7.4000	7.6000	149.1000	139120.00	0.00	139120.00	188	16	1290	17261	0.0747349516250507	0.282482283109929	0.285038819953614	false	false	false	true
15775ef4-95af-494e-a280-f5e993e03604	2026-08-19 09:52	2026-08-19 09:52	2026-08-19 09:52	MRK	MRK260918C00145000	call	145.0000	2026-09-18	7.4000	7.4000	7.5500	149.0700	648240.00	0.00	500240.00	876	43	2247	17261	0.130177857598053	0.28631005969131	0.28631005969131	false	false	false	true
e73e52ac-aeab-4d75-ba47-a997d2607798	2026-08-19 09:56	2026-08-19 09:56	2026-08-19 09:56	MRK	MRK260918C00145000	call	145.0000	2026-09-18	8.5000	8.5000	8.9000	150.5099	405450.00	0.00	405450.00	477	41	2785	17261	0.161346387810671	0.294144221180952	0.294144221180952	false	false	false	true
6ec69366-02c6-4c27-9686-545adba8ed02	2026-08-19 09:57	2026-08-19 09:57	2026-08-19 09:57	MRK	MRK260918C00145000	call	145.0000	2026-09-18	8.5000	8.5000	8.9000	150.3700	214200.00	0.00	214200.00	252	21	3053	17261	0.176872718845953	0.297379042636768	0.30058706240723	false	false	false	true
45a0f2f5-4289-481a-8eba-0ab9b50895ea	2026-08-19 09:57	2026-08-19 09:57	2026-08-19 09:57	MRK	MRK260918C00145000	call	145.0000	2026-09-18	8.5000	8.5000	8.8500	150.2400	51000.00	0.00	51000.00	60	5	3125	17261	0.18104397195991	0.306465768659069	0.306465768659069	true	false	false	true
af352750-a512-4520-9ca9-dc88333562e3	2026-08-19 09:59	2026-08-19 09:59	2026-08-19 09:59	MRK	MRK260918C00145000	call	145.0000	2026-09-18	8.5000	8.5000	8.8500	149.9300	453050.00	0.00	453050.00	533	53	3826	17261	0.221655755749957	0.320107673595182	0.320107673595182	false	false	false	true
ff6f3ff4-7b66-479a-b84f-f993beb5305f	2026-08-19 09:59	2026-08-19 09:59	2026-08-19 09:59	MRK	MRK260918C00145000	call	145.0000	2026-09-18	8.5000	8.5000	8.6000	149.9100	124100.00	0.00	124100.00	146	13	4043	17261	0.234227449162853	0.312799242940569	0.320971053173959	false	false	false	true
36fe9a9b-3004-445a-807a-309546928e3d	2026-08-19 10:03	2026-08-19 10:03	2026-08-19 10:03	MRK	MRK260918C00145000	call	145.0000	2026-09-18	8.2500	8.2500	8.7000	149.6450	487575.00	0.00	487575.00	591	44	4791	17261	0.277562134291177	0.316289826764849	0.316289826764849	false	false	false	true
e9a5493e-a3a2-451d-8767-534f8274f112	2026-08-19 10:06	2026-08-19 10:06	2026-08-19 10:06	MRK	MRK270617C00170000	call	170.0000	2027-06-17	10.2000	8.9500	10.8000	150.0100	181560.00	23460.00	142800.00	178	9	1676	56	29.9285714285714	0.288986219348571	0.288986219348571	false	false	false	true
d23a26cb-1df3-4ee8-a7d4-b8238f2b7641	2026-08-19 10:08	2026-08-19 10:08	2026-08-19 10:08	MRK	MRK260828C00150000	call	150.0000	2026-08-28	4.5000	4.2000	4.5000	151.2100	79650.00	79650.00	0.00	177	5	1144	5	228.8	0.401640118150719	0.401640118150719	false	false	false	true
0522a23c-e06e-492d-8971-1541ebf3243f	2026-08-19 10:09	2026-08-19 10:09	2026-08-19 10:09	MRK	MRK260918C00140000	call	140.0000	2026-09-18	13.1000	12.5000	13.1000	151.3050	120520.00	120520.00	0.00	92	13	1325	13469	0.0983740441012696	0.317662789297597	0.317662789297597	false	false	false	true
7f4c785f-bd2c-410f-9f4f-e8a14afcc25f	2026-08-19 10:10	2026-08-19 10:10	2026-08-19 10:10	MRK	MRK260821C00150000	call	150.0000	2026-08-21	3.6000	3.3500	4.0000	151.4000	270725.00	136805.00	116640.00	752	40	4613	926	4.98164146868251	0.650114628710306	0.635366442584856	true	false	false	true
b317b8d3-b28e-4c11-9ed1-1f46a2f63641	2026-08-19 10:19	2026-08-19 10:19	2026-08-19 10:19	MRK	MRK260918C00145000	call	145.0000	2026-09-18	8.5000	8.5000	8.6500	150.2600	86700.00	0.00	86700.00	102	6	5067	17261	0.293551937894676	0.305567807049615	0.305567807049615	true	false	false	true
b2e3a952-b070-4e65-a1ee-3189ee05f360	2026-08-19 10:24	2026-08-19 10:24	2026-08-19 10:24	MRK	MRK260918C00145000	call	145.0000	2026-09-18	8.5000	8.5000	8.6000	150.2200	528705.00	855.00	527850.00	622	28	6135	17261	0.355425525751695	0.30736145029894	0.30736145029894	false	false	false	true
c0367565-e072-4e0c-af52-01fe369f203e	2026-08-19 10:24	2026-08-19 10:24	2026-08-19 10:24	MRK	MRK260918C00145000	call	145.0000	2026-09-18	8.5000	8.5000	8.8500	150.0900	75650.00	0.00	75650.00	89	5	6247	17261	0.361914141706738	0.313129547703638	0.313129547703638	false	false	false	true
e9af3d66-56d8-4b03-854d-ffd571ce2250	2026-08-19 10:25	2026-08-19 10:25	2026-08-19 10:25	MRK	MRK260918C00145000	call	145.0000	2026-09-18	8.5000	8.5000	8.8000	149.8700	328100.00	0.00	328100.00	386	7	7795	17261	0.451596083656799	0.322692110902094	0.322692110902094	false	false	false	true
f45b0d3d-08b0-4d23-851c-c92d830d7bdd	2026-08-19 11:09	2026-08-19 11:09	2026-08-19 11:09	MRK	MRK261218C00180000	call	180.0000	2026-12-18	3.2000	2.9100	3.2000	149.5150	67520.00	24640.00	0.00	211	10	232	111	2.09009009009009	0.33575541836917	0.33575541836917	false	false	false	true
10bc0e7d-d7d5-418b-ad32-aa801c6d72db	2026-08-19 11:09	2026-08-19 11:09	2026-08-19 11:09	MRK	MRK261218C00180000	call	180.0000	2026-12-18	3.1000	2.9500	3.1000	149.5400	56730.00	25420.00	0.00	183	29	433	111	3.9009009009009	0.331867221847659	0.3315288784831	false	false	false	true
38f97de3-8f52-4d1b-9dd0-3aff03082403	2026-08-19 11:09	2026-08-19 11:09	2026-08-19 11:09	MRK	MRK261016P00150000	put	150.0000	2026-10-16	7.5500	7.0500	7.6500	149.5700	71725.00	3020.00	68705.00	95	21	1044	8	130.5	0.328115622245784	0.328115622245784	false	false	false	true
b7b574b7-c075-48c5-84dd-ecfdb1614a27	2026-08-19 11:13	2026-08-19 11:13	2026-08-19 11:13	MRK	MRK261120C00165000	call	165.0000	2026-11-20	5.0500	5.0500	5.3000	150.1400	76255.00	0.00	76255.00	151	5	628	1	628	0.328433510234122	0.328433510234122	false	false	false	true
709560df-77e6-4c2b-859d-d88c274036f3	2026-08-19 11:17	2026-08-19 11:17	2026-08-19 11:17	MRK	MRK280121P00125000	put	125.0000	2028-01-21	9.3500	8.0500	9.3500	150.4900	67320.00	67320.00	0.00	72	7	72	219	0.328767123287671	0.347753436176871	0.347753436176871	false	false	false	true
1f8f8cb6-537d-4ede-b558-58711442a20e	2026-08-19 11:20	2026-08-19 11:20	2026-08-19 11:20	MRK	MRK260918C00155000	call	155.0000	2026-09-18	3.8000	3.6000	3.8000	150.3845	151998.00	151998.00	0.00	400	36	851	338	2.51775147928994	0.322868085343536	0.322868085343536	true	false	false	true
22bef615-53cb-4a4a-9cc0-654237d95770	2026-08-19 12:00	2026-08-19 12:00	2026-08-19 12:00	MRK	MRK260821C00139000	call	139.0000	2026-08-21	11.0000	11.0000	12.3500	149.8600	106700.00	0.00	106700.00	97	11	1235	1642	0.752131546894032	0.59351803953972	0.59351803953972	false	false	false	true
a1b217e6-078f-4bc5-91fa-f7a04421c9b1	2026-08-19 12:43	2026-08-19 12:43	2026-08-19 12:43	MRK	MRK260918P00145000	put	145.0000	2026-09-18	3.5400	3.4500	3.5500	149.5900	68950.00	50400.00	18550.00	195	13	930	3	310	0.337062077299176	0.337062077299176	false	false	false	true
9ed2f191-3fb4-4e5f-ae35-448b213d86ac	2026-08-19 14:22	2026-08-19 14:22	2026-08-19 14:22	MRK	MRK261120P00135000	put	135.0000	2026-11-20	3.6500	3.6000	3.7500	151.8000	68985.00	0.00	68985.00	189	8	8612	101	85.2673267326733	0.357933518840933	0.358173015828224	false	false	false	true
53d08a6a-f1f1-43da-ad23-4a6ec694970a	2026-08-19 14:24	2026-08-19 14:24	2026-08-19 14:24	MRK	MRK260925C00141000	call	141.0000	2026-09-25	13.1500	11.7500	13.1500	152.0400	64435.00	64435.00	0.00	49	9	171	3	57	0.298057970262381	0.298057970262381	false	false	false	true
ded2d12c-08bb-4090-ad12-17a9ea9fa8d7	2026-08-19 14:24	2026-08-19 14:24	2026-08-19 14:24	MRK	MRK270319C00130000	call	130.0000	2027-03-19	28.5000	27.9000	29.1000	151.8650	105450.00	0.00	31350.00	37	6	42	528	0.0795454545454545	0.291101549723402	0.291101549723402	false	false	false	true
9f9f3b9a-7363-42d8-9f4b-1fc89711d278	2026-08-19 14:36	2026-08-19 14:36	2026-08-19 14:36	MRK	MRK261120P00135000	put	135.0000	2026-11-20	3.6500	3.6000	3.9000	152.4300	51460.00	19345.00	15690.00	141	17	9117	101	90.2673267326733	0.364173169513311	0.361915105740741	false	false	false	true
ed9ac45e-e8bd-4dcd-9ecb-fc5e3a955cc8	2026-08-19 14:56	2026-08-19 14:56	2026-08-19 14:56	MRK	MRK261016C00165000	call	165.0000	2026-10-16	3.4500	3.2500	3.4500	152.4150	77970.00	77970.00	0.00	226	38	503	51	9.86274509803922	0.315674186919197	0.315674186919197	false	false	false	true
75f5d6d8-6f80-477e-a36c-c4d135e3d5d9	2026-08-19 15:26	2026-08-19 15:26	2026-08-19 15:26	MRK	MRK260821P00155000	put	155.0000	2026-08-21	3.8500	3.5500	3.8500	153.0850	56160.00	56160.00	0.00	146	13	467	0	0	0.617552981886533	0.617552981886533	false	false	false	true
fd7baf56-bf82-4b9f-87c3-7c22bc815a88	2026-08-19 15:39	2026-08-19 15:39	2026-08-19 15:39	MRK	MRK260821C00155000	call	155.0000	2026-08-21	1.4900	1.3700	1.4900	152.2400	120243.00	120243.00	0.00	807	5	15029	565	26.6	0.580323091485594	0.580323091485594	false	false	false	true
1578d687-fa4c-4157-b66d-8b17e425db43	2026-08-19 15:50	2026-08-19 15:50	2026-08-19 15:50	MRK	MRK261120C00135000	call	135.0000	2026-11-20	21.1000	21.1000	22.4000	151.9200	78070.00	0.00	78070.00	37	7	49	38	1.28947368421053	0.32249383781325	0.32249383781325	false	false	false	true
f7f29649-5e1b-4fb1-897a-36f50ac56972	2026-08-20 09:33	2026-08-20 09:32	2026-08-20 09:32	MRK	MRK260918C00150000	call	150.0000	2026-09-18	5.2900	5.2500	6.5500	149.2500	67180.00	535.00	66645.00	127	24	162	4352	0.0372242647058824	0.311900850185435	0.321495380804609	true	false	false	true