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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	367065796302.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:35:55.847824Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
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
62b97509-177d-4a38-9f5a-a89eae772743	2026-09-24 12:53	2026-09-24 12:53	2026-09-24 12:53	MRK	MRK270115C00145000	call	145.0000	2027-01-15	12.6000	12.6000	13.3000	148.0000	25200.00	0.00	25200.00	20	5	143	2811	0.0508715759516186	0.297587155611139	0.297587155611139	false	false	false	true
8d12f53e-bc27-4d09-8539-bc0d2bdc94c8	2026-09-24 12:46	2026-09-24 12:46	2026-09-24 12:46	MRK	MRK270115C00145000	call	145.0000	2027-01-15	12.8000	12.8000	13.4500	148.7600	51200.00	0.00	51200.00	40	8	76	2811	0.0270366417644966	0.299789577117074	0.299789577117074	false	false	false	true
fa0858f6-406b-4911-8123-73d17eb2f4cc	2026-09-24 12:46	2026-09-24 12:46	2026-09-24 12:46	MRK	MRK270115C00145000	call	145.0000	2027-01-15	12.8500	12.8500	13.5000	148.7600	42410.00	0.00	42410.00	33	10	36	2811	0.0128068303094984	0.30098402589429	0.301381434974648	false	false	false	true
deb6d9b3-f657-4dc9-875b-9ddcee84da3e	2026-09-24 12:26	2026-09-24 12:26	2026-09-24 12:26	MRK	MRK261030C00140000	call	140.0000	2026-10-30	12.7500	12.7500	12.9000	149.5999	36975.00	0.00	3825.00	29	6	371	303	1.22442244224422	0.355421961116789	0.355421961116789	false	false	false	true
a677c401-e9a8-4d96-bed7-dd801716601e	2026-09-24 12:23	2026-09-24 12:23	2026-09-24 12:23	MRK	MRK261030C00140000	call	140.0000	2026-10-30	12.6000	12.6000	12.7500	149.4300	15120.00	0.00	6300.00	12	6	333	303	1.0990099009901	0.35392936027517	0.35392936027517	false	false	false	true
3c17dec2-7fc3-4f51-962b-f00085c9cccc	2026-09-24 11:00	2026-09-24 10:59	2026-09-24 10:59	MRK	MRK261016P00157500	put	157.5000	2026-10-16	8.7500	8.5500	9.2500	149.7400	35875.00	875.00	35000.00	41	26	42	0	0	0.266834330983195	0.268156480069115	false	false	false	true
fbf7221f-4d23-416c-b81b-cb02215b1672	2026-09-24 10:19	2026-09-24 10:19	2026-09-24 10:19	MRK	MRK260925C00150000	call	150.0000	2026-09-25	2.0600	2.0600	2.3100	151.3675	11537.00	0.00	11537.00	56	17	79	1100	0.0718181818181818	0.396620684116862	0.396620684116862	true	false	false	true
68bdea51-4ccc-408a-a6b5-f7f7589e5130	2026-09-24 10:19	2026-09-24 10:19	2026-09-24 10:19	MRK	MRK260925C00150000	call	150.0000	2026-09-25	2.1000	2.0000	2.2400	151.3675	20160.00	1680.00	13860.00	96	12	175	1100	0.159090909090909	0.410595253873471	0.410595253873471	false	false	false	true
3ce65efb-875b-46a3-b7b4-20a74ad8297e	2026-09-24 10:00	2026-09-24 10:00	2026-09-24 10:00	MRK	MRK270115P00140000	put	140.0000	2027-01-15	5.4500	5.4500	6.8500	150.7900	54500.00	0.00	54500.00	100	12	100	3582	0.0279173646007817	0.330980218050997	0.330980218050997	false	false	false	true
50c7d3e4-3ba9-4e9b-bf68-dae30777700b	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	MRK	MRK261030C00140000	call	140.0000	2026-10-30	13.3000	13.3000	13.5000	150.1600	58520.00	0.00	58520.00	44	22	200	303	0.66006600660066	0.363979995926974	0.363979995926974	false	false	false	true
fe5ab1d3-3376-4a94-8c67-52ae94be2635	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	MRK	MRK261030C00140000	call	140.0000	2026-10-30	13.3000	13.3000	13.5500	150.1600	42560.00	0.00	42560.00	32	13	156	303	0.514851485148515	0.363979995926974	0.363979995926974	false	false	false	true
c4774f78-9fd9-47d8-aa2b-0352453d4099	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	MRK	MRK261030C00140000	call	140.0000	2026-10-30	13.2500	13.2500	13.4500	150.1000	161650.00	0.00	161650.00	122	6	124	303	0.409240924092409	0.363677275510911	0.363677275510911	false	false	false	true
0dbbf371-45df-4f69-b56e-53236c0ee907	2026-09-23 15:50	2026-09-23 15:49	2026-09-23 15:49	MRK	MRK261009C00149000	call	149.0000	2026-10-09	3.3500	2.9700	3.3500	148.3500	10720.00	10720.00	0.00	32	11	463	9	51.4444444444444	0.285518379525744	0.285518379525744	true	false	false	true
84148905-7fd5-4e49-a107-989ce15f669b	2026-09-23 15:27	2026-09-23 15:27	2026-09-23 15:27	MRK	MRK260925C00142000	call	142.0000	2026-09-25	6.0500	5.6500	6.1500	147.0000	25410.00	25410.00	0.00	42	16	149	153	0.973856209150327	0.370919140132997	0.370919140132997	false	false	false	true
bbbc99ec-0d83-4aba-bfa2-2ce1f3436e9c	2026-09-23 13:45	2026-09-23 13:45	2026-09-23 13:45	MRK	MRK260925C00142000	call	142.0000	2026-09-25	6.2000	5.3500	6.2000	148.0000	31000.00	31000.00	0.00	50	9	107	153	0.699346405228758	0.371071366775726	0.371071366775726	false	false	false	true
a34884b5-60b8-42b3-8470-363d6017f491	2026-09-23 13:43	2026-09-23 13:42	2026-09-23 13:42	MRK	MRK261009C00149000	call	149.0000	2026-10-09	2.9900	2.9900	3.1000	147.0000	10465.00	0.00	5681.00	35	10	398	9	44.2222222222222	0.276664585002966	0.276664585002966	false	false	false	true
fd555d8a-d70f-4b39-be71-a23751e7e566	2026-09-23 13:11	2026-09-23 13:11	2026-09-23 13:11	MRK	MRK261016C00155000	call	155.0000	2026-10-16	1.4900	1.4000	1.4900	147.0000	14751.00	14751.00	0.00	99	5	855	6699	0.127630989699955	0.272359140183643	0.272359140183643	false	false	false	true
b5aad4e6-3f44-4fc5-84fc-4624ac48d3ab	2026-09-23 13:11	2026-09-23 13:10	2026-09-23 13:10	MRK	MRK261016C00155000	call	155.0000	2026-10-16	1.4600	1.3300	1.4600	147.3650	29116.00	29116.00	0.00	200	5	746	6699	0.111359904463353	0.271642019519915	0.270793250029541	false	false	false	true
ed820d35-4a8b-43ad-85c9-cadec4485df8	2026-09-23 12:47	2026-09-23 12:47	2026-09-23 12:47	MRK	MRK270115C00165000	call	165.0000	2027-01-15	4.4500	4.3000	4.4500	147.1300	27590.00	27590.00	0.00	62	20	66	1788	0.0369127516778524	0.303903171987258	0.303903171987258	false	false	false	true
e4f4dd73-e1f1-4d3e-b41e-14a30a6e031f	2026-09-23 12:44	2026-09-23 12:44	2026-09-23 12:44	MRK	MRK261030C00140000	call	140.0000	2026-10-30	10.7000	10.0000	11.2000	146.9500	52430.00	1070.00	51360.00	49	8	301	3	100.333333333333	0.342488920038073	0.342488920038073	true	false	false	true