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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×sector = Healthcare×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	expiry

774b6e1d-f075-45a3-87ef-773b7e9216c9	2026-10-01 15:36	2026-10-01 15:36	2026-10-01 15:36	MRK	MRK261218P00135000	put	135.0000	2026-12-18	4.8500	4.6500	4.9000	143.3500	26190.00	485.00	25705.00	54	9	131	1140	0.114912280701754	0.345495023376562	0.345495023376562	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	354803953261.00	2026-10-29	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T19:36:48.028615Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
0859c9ce-4337-42f4-9409-6fbb832e57c6	2026-10-01 13:01	2026-10-01 13:01	2026-10-01 13:01	MRK	MRK270416P00135000	put	135.0000	2027-04-16	8.7000	8.7000	8.8500	143.8300	43500.00	0.00	43500.00	50	10	59	82	0.719512195121951	0.345871857449008	0.345871857449008	false	false	false	true
fef1ccb3-73cc-47d5-a269-8a80306f57b8	2026-10-01 11:47	2026-10-01 11:47	2026-10-01 11:47	MRK	MRK270617P00130000	put	130.0000	2027-06-17	8.1500	8.1500	8.2500	144.0000	17115.00	0.00	17115.00	21	7	376	792	0.474747474747475	0.349303830419705	0.349303830419705	false	false	false	true
94e67b5b-bcdc-4d28-acbd-b99eed180f5e	2026-10-01 10:12	2026-10-01 10:12	2026-10-01 10:12	MRK	MRK261218C00170000	call	170.0000	2026-12-18	1.9000	1.7800	2.0100	144.6700	10642.00	3040.00	7602.00	56	8	56	13527	0.0041398684113255	0.325078241893554	0.326240826014369	false	false	false	true
91037e20-14cb-4ec0-b330-432919bc04c2	2026-10-01 09:50	2026-10-01 09:50	2026-10-01 09:50	MRK	MRK261016C00155000	call	155.0000	2026-10-16	0.5100	0.5100	0.6600	144.5800	35139.00	0.00	35139.00	689	42	701	6682	0.104908709967076	0.285146888984031	0.285146888984031	false	false	false	true
66f3bfd4-ece9-4c86-adb6-671a0c689670	2026-09-30 16:00	2026-09-30 15:59	2026-09-30 15:59	MRK	MRK261218C00160000	call	160.0000	2026-12-18	3.9500	3.9500	4.2000	145.0000	14615.00	0.00	14615.00	37	6	52	1694	0.0306965761511216	0.320615018201486	0.320615018201486	true	false	false	true
07e6587e-89ad-4b46-b52e-853ed2c150b7	2026-09-30 12:30	2026-09-30 12:30	2026-09-30 12:30	MRK	MRK261030C00160000	call	160.0000	2026-10-30	1.9900	1.7600	1.9900	146.4600	39800.00	39800.00	0.00	200	21	2225	135	16.4814814814815	0.373992188084836	0.373992188084836	true	false	false	true
3faded9f-f0d9-4e40-a589-5b322b4f9857	2026-09-30 11:25	2026-09-30 11:24	2026-09-30 11:24	MRK	MRK271217P00135000	put	135.0000	2027-12-17	12.7500	12.5500	13.1500	147.4000	11475.00	1275.00	10200.00	9	7	9	98	0.0918367346938776	0.356506616842041	0.356506616842041	false	false	false	true
f13b1484-9fe5-4087-8824-d8db14d83702	2026-09-29 15:56	2026-09-29 15:56	2026-09-29 15:56	MRK	MRK261120P00155000	put	155.0000	2026-11-20	10.4000	10.1500	10.6500	149.1550	90460.00	89420.00	0.00	87	12	87	335	0.259701492537313	0.337123048365868	0.337123048365868	false	false	false	true
e2620528-e739-47e0-b987-2aae3ca15ef5	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	MRK	MRK261016C00145000	call	145.0000	2026-10-16	6.1500	6.1000	6.6500	149.0800	55355.00	620.00	54735.00	90	9	114	2347	0.0485726459309757	0.281391921157931	0.285839184072035	false	false	false	true
d9029b05-7d4a-498b-8641-0ac7e1ec2e6a	2026-09-29 15:53	2026-09-29 15:53	2026-09-29 15:53	MRK	MRK261002P00148000	put	148.0000	2026-10-02	1.2000	1.0400	1.2500	149.0800	92040.00	10080.00	5760.00	767	59	781	243	3.21399176954733	0.3175065677659	0.3175065677659	true	false	false	true
e93c3852-7dcf-44dc-988d-befc9f0ec4e4	2026-09-29 14:47	2026-09-29 14:47	2026-09-29 14:47	MRK	MRK280121C00195000	call	195.0000	2028-01-21	9.6000	9.3000	9.6000	148.8100	24000.00	24000.00	0.00	25	5	26	252	0.103174603174603	0.301527398854639	0.301527398854639	false	false	false	true
b7053f9b-cb31-4988-9438-b9fd9549c557	2026-09-29 14:46	2026-09-29 14:46	2026-09-29 14:46	MRK	MRK261016P00150000	put	150.0000	2026-10-16	4.0000	3.9000	4.0000	148.8450	18000.00	18000.00	0.00	45	9	63	1742	0.0361653272101033	0.275968365388779	0.275968365388779	false	false	false	true
4ede3ee4-f314-4510-a75c-39be5c4b4471	2026-09-29 13:10	2026-09-29 13:10	2026-09-29 13:10	MRK	MRK280121C00185000	call	185.0000	2028-01-21	11.4500	11.1500	11.5000	148.3300	45800.00	42365.00	1145.00	40	18	76	21	3.61904761904762	0.297636941789881	0.298405591024825	true	false	false	true
d038b966-f7ee-461e-bf5e-bc809dffb2bd	2026-09-29 12:52	2026-09-29 12:52	2026-09-29 12:52	MRK	MRK280121C00185000	call	185.0000	2028-01-21	11.4000	11.1000	11.4000	148.3050	37620.00	37620.00	0.00	33	10	36	21	1.71428571428571	0.297016398485239	0.297016398485239	false	false	false	true
2f611fc5-45f9-4290-b9b9-9b7dfad23e24	2026-09-29 10:26	2026-09-29 10:26	2026-09-29 10:26	MRK	MRK261002P00143000	put	143.0000	2026-10-02	0.5100	0.5000	0.5300	146.8050	14007.00	3657.00	10350.00	276	23	277	1302	0.212749615975422	0.34553088991614	0.34553088991614	false	false	false	true
126fa752-cf49-4626-a125-9985a22330ab	2026-09-29 10:23	2026-09-29 10:22	2026-09-29 10:22	MRK	MRK261016C00150000	call	150.0000	2026-10-16	2.4000	2.3200	2.4000	146.8201	77760.00	77760.00	0.00	324	6	508	5608	0.0905848787446505	0.287412990161998	0.287412990161998	false	false	false	true
fbdd8216-b1be-43bd-9d24-a6cefd47fbb8	2026-09-28 12:41	2026-09-28 12:41	2026-09-28 12:41	MRK	MRK270917P00150000	put	150.0000	2027-09-17	17.6500	17.3500	17.6500	148.0000	40595.00	40595.00	0.00	23	8	49	105	0.466666666666667	0.350235819264411	0.350235819264411	false	false	false	true
625c8cbb-bf92-4dbb-84b5-3734a7e8466c	2026-09-28 12:06	2026-09-28 12:06	2026-09-28 12:06	MRK	MRK261030C00140000	call	140.0000	2026-10-30	11.8500	11.8500	12.0000	148.6600	21330.00	0.00	16590.00	18	9	18	703	0.0256045519203414	0.365498133494309	0.365498133494309	false	false	false	true
ce3ee045-b455-4cef-8d9f-535306c51e29	2026-09-28 10:06	2026-09-28 10:06	2026-09-28 10:06	MRK	MRK261009C00155000	call	155.0000	2026-10-09	0.9300	0.9300	1.1600	148.3700	40735.00	94.00	40641.00	438	38	438	632	0.693037974683544	0.301046649368657	0.301046649368657	false	false	false	true
088885af-92b2-4307-92e3-1be4e4dc9354	2026-09-25 15:35	2026-09-25 15:35	2026-09-25 15:35	MRK	MRK261002C00152500	call	152.5000	2026-10-02	0.9300	0.9100	0.9600	148.6200	14786.00	13392.00	1302.00	159	31	337	339	0.994100294985251	0.282898837156799	0.282306496060298	false	false	false	true
bbe0aed7-b86a-41f6-a4a9-6123edeeba10	2026-09-25 15:35	2026-09-25 15:35	2026-09-25 15:35	MRK	MRK261016C00155000	call	155.0000	2026-10-16	1.6800	1.6500	1.7400	148.6350	14784.00	12936.00	1848.00	88	6	1469	7008	0.209617579908676	0.274639389796981	0.274639389796981	false	false	false	true
62132bd3-c8dc-4bfb-b14e-e670eac6d770	2026-09-25 15:34	2026-09-25 15:34	2026-09-25 15:34	MRK	MRK261016C00155000	call	155.0000	2026-10-16	1.6800	1.6500	1.7100	148.6050	10920.00	8904.00	0.00	65	8	1358	7008	0.193778538812785	0.275345306254426	0.275345306254426	false	false	false	true
aeca7ff2-da6f-4455-99a3-97b3f54985c4	2026-09-25 15:33	2026-09-25 15:33	2026-09-25 15:33	MRK	MRK261002C00148000	call	148.0000	2026-10-02	2.5100	2.5100	2.8100	148.6325	14809.00	0.00	14809.00	59	6	175	319	0.54858934169279	0.258342087118133	0.258342087118133	false	false	false	true
e1e4df1d-e8b2-41d8-98af-4009a3b5040b	2026-09-25 15:31	2026-09-25 15:31	2026-09-25 15:31	MRK	MRK261120C00155000	call	155.0000	2026-11-20	5.4500	5.3000	5.4500	148.6300	76300.00	76300.00	0.00	140	5	291	1865	0.156032171581769	0.332167786278716	0.332167786278716	false	false	false	true
e673ba2b-5b6f-478e-8fe2-7ae66eef900c	2026-09-25 15:28	2026-09-25 15:28	2026-09-25 15:28	MRK	MRK261016C00150000	call	150.0000	2026-10-16	3.3500	3.3000	3.3500	148.3750	33500.00	33500.00	0.00	100	18	265	5495	0.0482256596906278	0.277539017845487	0.277539017845487	false	false	false	true
614abecb-d85e-409c-8791-87fde8708b6c	2026-09-25 15:28	2026-09-25 15:28	2026-09-25 15:28	MRK	MRK261016C00150000	call	150.0000	2026-10-16	3.3500	3.3000	3.4500	148.4450	33500.00	1005.00	4020.00	100	7	165	5495	0.0300272975432211	0.275079493748607	0.275246851101765	false	false	false	true
7cce058b-a99a-4826-bb10-c282d2a7cff2	2026-09-25 12:54	2026-09-25 12:54	2026-09-25 12:54	MRK	MRK270617C00160000	call	160.0000	2027-06-17	12.3500	12.1000	12.4500	147.6701	30875.00	1235.00	29640.00	25	6	28	1053	0.0265906932573599	0.305825064521543	0.305825064521543	true	false	false	true
a8e2cc64-95d4-4f86-81af-8f553a663d41	2026-09-25 11:05	2026-09-25 11:05	2026-09-25 11:05	MRK	MRK261023C00160000	call	160.0000	2026-10-23	1.0400	1.0100	1.2400	148.7700	78208.00	0.00	78208.00	752	7	760	110	6.90909090909091	0.265409705656254	0.265409705656254	false	true	false	true
8092a5e4-af48-4396-ac14-1f3c177c264d	2026-09-24 15:36	2026-09-24 15:36	2026-09-24 15:36	MRK	MRK261002C00150000	call	150.0000	2026-10-02	2.1700	2.1700	2.3000	148.7300	81376.00	218.00	81158.00	375	36	1017	409	2.48655256723716	0.306371653837509	0.306371653837509	false	false	false	true
64ac856e-572c-4af3-9cb4-27384cdf99ee	2026-09-24 15:36	2026-09-24 15:36	2026-09-24 15:36	MRK	MRK261002C00149000	call	149.0000	2026-10-02	2.6500	2.6500	2.8500	148.7300	16165.00	0.00	16165.00	61	12	194	219	0.885844748858447	0.309445918258597	0.309445918258597	false	false	false	true
0ad61e39-f99a-43bc-984e-76ad405a45e8	2026-09-24 15:25	2026-09-24 15:25	2026-09-24 15:25	MRK	MRK261016C00150000	call	150.0000	2026-10-16	3.7500	3.6500	3.8000	148.7600	67125.00	62625.00	0.00	179	26	422	5389	0.0783076637595101	0.28576856194522	0.28576856194522	true	false	false	true
b688cfcf-a34f-4e6c-9f10-471fd5867efb	2026-09-24 15:09	2026-09-24 15:09	2026-09-24 15:09	MRK	MRK261120C00160000	call	160.0000	2026-11-20	3.9500	3.9000	3.9500	148.9700	15800.00	15800.00	0.00	40	7	90	3531	0.0254885301614274	0.328890366272095	0.328890366272095	false	false	false	true
fd978035-3052-4cd5-95df-c929a56fcd11	2026-09-24 14:56	2026-09-24 14:56	2026-09-24 14:56	MRK	MRK261009C00157500	call	157.5000	2026-10-09	0.8000	0.7900	0.8200	148.8150	22134.00	9020.00	13114.00	276	19	313	1074	0.291433891992551	0.287048803190941	0.287048803190941	false	false	false	true
2823ad31-c0ad-4ae7-b11d-468cbf9cfe41	2026-09-24 14:56	2026-09-24 14:56	2026-09-24 14:56	MRK	MRK261009C00155000	call	155.0000	2026-10-09	1.3000	1.2900	1.5200	148.8336	16566.00	7920.00	8646.00	127	15	159	532	0.298872180451128	0.286724439311415	0.286230113679362	false	false	false	true
6208406f-7bbc-41a5-b267-d3c57b3fae45	2026-09-24 14:56	2026-09-24 14:55	2026-09-24 14:55	MRK	MRK261002C00150000	call	150.0000	2026-10-02	2.3300	1.8800	2.3300	148.7950	139800.00	139800.00	0.00	600	33	636	409	1.55501222493888	0.321423294791311	0.321423294791311	false	false	false	true
3f945af9-52a5-4ba5-9187-cf7d6d6c6e0b	2026-09-24 14:56	2026-09-24 14:55	2026-09-24 14:55	MRK	MRK261002C00148000	call	148.0000	2026-10-02	3.3500	3.0000	3.3500	148.8200	35175.00	35175.00	0.00	105	8	195	202	0.965346534653465	0.325337573516725	0.325337573516725	false	false	false	true
e864e67f-9dfd-4e3e-8c4f-bf6b6e3b310d	2026-09-24 14:45	2026-09-24 14:45	2026-09-24 14:45	MRK	MRK270115C00145000	call	145.0000	2027-01-15	12.8000	12.8000	13.1000	148.0000	69120.00	0.00	69120.00	54	13	291	2811	0.103521878335112	0.299789577117074	0.299789577117074	false	false	false	true
79724166-c5e1-4d60-92ed-1ed85517ad90	2026-09-24 14:44	2026-09-24 14:44	2026-09-24 14:44	MRK	MRK280121P00150000	put	150.0000	2028-01-21	19.5000	18.9500	19.5000	148.0000	97500.00	97500.00	0.00	50	5	60	69	0.869565217391304	0.353937722969492	0.353937722969492	false	false	false	true
c27e659e-91fb-4b85-9e59-567c2a2cb89c	2026-09-24 14:42	2026-09-24 14:42	2026-09-24 14:42	MRK	MRK261016C00152500	call	152.5000	2026-10-16	2.6400	2.6100	2.8400	148.0000	28776.00	28512.00	264.00	109	21	124	339	0.365781710914454	0.276391072471974	0.275145630060734	false	false	false	true
0761784f-074b-44d1-9dff-4897141501a4	2026-09-24 14:42	2026-09-24 14:42	2026-09-24 14:42	MRK	MRK261016C00150000	call	150.0000	2026-10-16	3.7000	3.6500	3.7000	148.0000	40330.00	40330.00	0.00	109	24	198	5389	0.0367415104843199	0.279356662360545	0.279356662360545	false	false	false	true
fd97842d-bdfd-4b11-b0b5-5b8a7a0a2a90	2026-09-24 14:42	2026-09-24 14:42	2026-09-24 14:42	MRK	MRK261002P00150000	put	150.0000	2026-10-02	3.3000	2.8500	3.3000	148.8400	11220.00	11220.00	0.00	34	10	47	65	0.723076923076923	0.312350041109048	0.312350041109048	false	false	false	true
dfdb6e6e-d079-4fff-a898-e06a4a5368ac	2026-09-24 14:42	2026-09-24 14:42	2026-09-24 14:42	MRK	MRK261002C00148000	call	148.0000	2026-10-02	3.3000	2.8600	3.3000	148.8400	22440.00	22440.00	0.00	68	14	90	202	0.445544554455446	0.31827825254046	0.31827825254046	false	false	false	true
c48412ee-1f3a-4add-aa62-6f99d84d29bd	2026-09-24 14:41	2026-09-24 14:41	2026-09-24 14:41	MRK	MRK261002C00149000	call	149.0000	2026-10-02	2.7200	2.2900	2.7200	148.8400	26928.00	26928.00	0.00	99	16	133	219	0.607305936073059	0.311100244267598	0.311100244267598	false	false	false	true
f716ce94-d927-40f9-b3bf-8770d68fabad	2026-09-24 14:34	2026-09-24 14:34	2026-09-24 14:34	MRK	MRK261030C00140000	call	140.0000	2026-10-30	12.2000	12.2000	12.5000	148.9550	41480.00	0.00	41480.00	34	10	421	303	1.38943894389439	0.350925164776111	0.350925164776111	false	false	false	true
37f850da-0db4-41c0-8c00-3fda85e724aa	2026-09-24 13:42	2026-09-24 13:42	2026-09-24 13:42	MRK	MRK270115C00145000	call	145.0000	2027-01-15	12.5000	12.5000	12.7000	148.4400	55000.00	0.00	55000.00	44	12	237	2811	0.0843116328708645	0.296578158225218	0.296578158225218	false	false	false	true
87ee8562-6883-494a-bf3a-39db43d61310	2026-09-24 13:20	2026-09-24 13:19	2026-09-24 13:19	MRK	MRK270115C00145000	call	145.0000	2027-01-15	12.3500	12.3500	13.0500	148.1550	46930.00	0.00	46930.00	38	5	181	2811	0.0643898968338669	0.29730727440941	0.297404949451824	false	false	false	true
4c8b0de8-23e9-4ad2-aca1-4904dd781880	2026-09-24 13:17	2026-09-24 13:17	2026-09-24 13:17	MRK	MRK270617C00150000	call	150.0000	2027-06-17	17.3600	15.8000	17.4500	148.4950	1215200.00	1215200.00	0.00	700	2	700	767	0.91264667535854	0.313542514280309	0.313542514280309	false	true	false	true
1def53af-1ce7-4396-a5e5-34d882b44a6d	2026-09-24 13:07	2026-09-24 13:07	2026-09-24 13:07	MRK	MRK261218P00130000	put	130.0000	2026-12-18	2.4900	2.4900	2.5300	148.2900	13695.00	0.00	13695.00	55	7	55	1441	0.0381679389312977	0.342952218316949	0.342952218316949	false	false	false	true
14086c7a-8bde-476e-bea4-257613d67671	2026-09-24 12:54	2026-09-24 12:53	2026-09-24 12:53	MRK	MRK280121P00120000	put	120.0000	2028-01-21	7.8000	7.1500	8.2000	148.0000	78000.00	12480.00	42120.00	100	7	100	722	0.138504155124654	0.356037225692452	0.356037225692452	false	false	false	true