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×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
3046f13f-e710-40df-8bfa-59c4886a87f5	2026-08-17 10:55	2026-08-17 10:55	2026-08-17 10:55	MRK	MRK261120C00150000	call	150.0000	2026-11-20	3.0500	0.0000	0.0000	136.1600	2452158.00	0.00	2452158.00	8037	31	8049	58	138.775862068966	0	0	true	true	false	true	false
2f33dec0-c45b-4efd-94c4-4053d9ebf34d	2026-08-17 10:55	2026-08-17 10:55	2026-08-17 10:55	MRK	MRK261120C00150000	call	150.0000	2026-11-20	3.1000	3.1000	3.3500	136.1800	56078.00	0.00	56078.00	181	30	193	58	3.32758620689655	0.265770274902066	0.268735748620032	true	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
9ffa26f6-3efb-4800-aa28-df900093e9fd	2026-08-18 09:45	2026-08-18 09:45	2026-08-18 09:45	MRK	MRK261016C00130000	call	130.0000	2026-10-16	10.5300	10.5000	10.7500	137.0000	91571.00	0.00	91571.00	87	12	104	4011	0.0259286960857641	0.24023279869114	0.24023279869114	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
5bdc1dbc-7346-4c4b-86fc-c8055f35ad84	2026-08-18 15:35	2026-08-18 15:35	2026-08-18 15:35	MRK	MRK260918P00135000	put	135.0000	2026-09-18	3.9000	3.9000	4.1000	135.5550	81530.00	0.00	81530.00	209	31	289	685	0.421897810218978	0.278904288480103	0.278904288480103	false	false	false	true
cf4d6d17-ef5b-45c2-8370-9735e03154e9	2026-08-19 09:30	2026-08-19 09:30	2026-08-19 09:30	MRK	MRK260918C00140000	call	140.0000	2026-09-18	9.3700	8.0000	20.0000	147.4700	247315.00	154515.00	66845.00	264	16	265	13469	0.0196748088202539	0.20030643686313	0.292413380732536	true	false	false	true
ca7a1aa1-a6f8-435f-9f11-e80509ac15da	2026-08-19 09:30	2026-08-19 09:30	2026-08-19 09:30	MRK	MRK260918C00140000	call	140.0000	2026-09-18	10.0200	9.9000	11.4500	148.5800	54124.00	50000.00	4124.00	54	8	381	13469	0.0282871779642141	0.268013728882731	0.268013728882731	false	false	false	true
db23081d-f501-45cc-9997-d256171ba0c7	2026-08-19 09:33	2026-08-19 09:33	2026-08-19 09:33	MRK	MRK270115C00165000	call	165.0000	2027-01-15	4.6800	3.7000	5.0000	145.8550	172188.00	171718.00	470.00	368	30	382	115	3.32173913043478	0.276646100584363	0.283440483089022	true	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
135ae344-cefb-4d57-afe1-08725cbbf94d	2026-08-19 09:35	2026-08-19 09:35	2026-08-19 09:35	MRK	MRK270617C00170000	call	170.0000	2027-06-17	8.7700	7.1500	8.8000	147.2500	320884.00	320884.00	0.00	366	35	366	56	6.53571428571429	0.278872553562714	0.283185857116916	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
200942ed-1ba3-4b17-8160-790d372e7de4	2026-08-19 09:50	2026-08-19 09:50	2026-08-19 09:50	MRK	MRK270319C00180000	call	180.0000	2027-03-19	5.1500	4.3500	5.1500	148.6450	148300.00	148300.00	0.00	288	17	303	50	6.06	0.299980193786402	0.305323574268554	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
6d905a01-fc6a-4127-87ff-e8f9bc2eb5f3	2026-08-19 10:15	2026-08-19 10:15	2026-08-19 10:15	MRK	MRK261120P00135000	put	135.0000	2026-11-20	3.5900	2.4000	3.6500	151.2150	360465.00	93350.00	267115.00	1005	26	1006	101	9.96039603960396	0.343568529917667	0.350307747184405	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
0c4e5707-491a-49f1-8167-5a16d154a69f	2026-08-19 10:24	2026-08-19 10:24	2026-08-19 10:24	MRK	MRK260918C00145000	call	145.0000	2026-09-18	8.4500	7.8500	8.8500	150.0600	739785.00	466830.00	272955.00	876	21	7407	17261	0.429117664098256	0.317969886558462	0.330572983425997	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
10a9b62a-d951-4461-897c-4ad2659e029f	2026-08-19 10:41	2026-08-19 10:40	2026-08-19 10:40	MRK	MRK270319C00180000	call	180.0000	2027-03-19	5.9000	5.4000	5.9000	149.8650	474229.00	473644.00	585.00	804	44	1125	50	22.5	0.315822918193809	0.315860213716828	true	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
06a368a5-92fc-473e-8c5d-109a80ba3868	2026-08-19 11:09	2026-08-19 11:09	2026-08-19 11:09	MRK	MRK260918P00145000	put	145.0000	2026-09-18	3.4500	3.4000	3.5000	149.5700	118700.00	60900.00	57800.00	344	5	492	3	164	0.336626420570245	0.336626420570245	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