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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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

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	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	365338776155.00	2026-10-29	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-23T19:51:14.662813Z"}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
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
deb31434-fbb4-400c-9413-f113cdaba517	2026-09-23 14:03	2026-09-23 14:02	2026-09-23 14:02	MRK	MRK261016C00165000	call	165.0000	2026-10-16	0.2100	0.2100	0.3800	147.7200	19621.00	867.00	18710.00	918	66	15664	3486	4.49340218014917	0.260590984163475	0.265740366255297	true	false	false
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
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
02817b3f-3c3d-42e0-bb4b-4d6154e6c48f	2026-09-23 13:35	2026-09-23 13:35	2026-09-23 13:35	MRK	MRK261016C00165000	call	165.0000	2026-10-16	0.2100	0.2100	0.2900	147.6700	22260.00	69.00	22191.00	1051	55	13139	3486	3.76907630522088	0.261516323310254	0.263993553315786	true	false	false
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
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
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
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
6334c0d7-e310-47a2-b4c7-10e864d50a01	2026-09-23 12:26	2026-09-23 12:26	2026-09-23 12:26	MRK	MRK260925C00142000	call	142.0000	2026-09-25	5.3000	5.3000	6.7500	147.1550	29170.00	0.00	24930.00	55	14	57	153	0.372549019607843	0.332075901566936	0.332075901566936	true	false	false
c082708f-b5fe-45b1-bdda-3c497ec87b96	2026-09-23 12:03	2026-09-23 12:03	2026-09-23 12:03	MRK	MRK261009C00149000	call	149.0000	2026-10-09	2.5300	2.5200	2.7900	147.1536	27572.00	2610.00	23950.00	109	26	110	9	12.2222222222222	0.261191137754846	0.270633986427484	true	false	false
5600846a-7c93-436c-890d-8c3cc779aa71	2026-09-23 11:58	2026-09-23 11:57	2026-09-23 11:58	MRK	MRK261016C00165000	call	165.0000	2026-10-16	0.2000	0.0000	0.0000	147.3300	232339.00	25.00	232314.00	11557	39	12072	3486	3.46299483648881	0	0	true	true	false
30c4ca45-9e70-491e-8414-49cd372dc9ec	2026-09-23 11:57	2026-09-23 11:57	2026-09-23 11:57	MRK	MRK261016C00165000	call	165.0000	2026-10-16	0.2200	0.2200	0.3000	147.3300	22039.00	74.00	21813.00	999	71	1005	3486	0.28829604130809	0.277191508314826	0.275686916215419	true	false	false
70faafe2-47a4-494a-b2eb-1ce88f2be721	2026-09-23 11:00	2026-09-23 11:00	2026-09-23 11:00	MRK	MRK261016C00160000	call	160.0000	2026-10-16	0.6100	0.6100	0.9400	148.0000	20069.00	0.00	20069.00	329	6	382	2252	0.169626998223801	0.255389029999157	0.255389029999157	false	false	false
6c7d7fbb-e8a8-4698-94ee-e31b0fc1f1a1	2026-09-23 10:57	2026-09-23 10:57	2026-09-23 10:57	MRK	MRK261002C00149000	call	149.0000	2026-10-02	2.0500	1.8800	2.2700	148.0000	10666.00	10254.00	412.00	52	14	217	43	5.04651162790698	0.266796327032235	0.266058136703697	false	false	false
73b1fc47-79c6-4b54-90a8-2088e48ba709	2026-09-23 10:57	2026-09-23 10:56	2026-09-23 10:56	MRK	MRK261002P00145000	put	145.0000	2026-10-02	1.1000	1.0900	1.2700	148.0600	25453.00	7029.00	18424.00	232	14	374	82	4.5609756097561	0.260205612617407	0.260205612617407	false	false	false
53c2a219-3892-4deb-91a1-5532aff2da95	2026-09-23 10:57	2026-09-23 10:56	2026-09-23 10:56	MRK	MRK261002P00144000	put	144.0000	2026-10-02	0.8400	0.8300	0.8600	148.0600	43603.00	18454.00	25149.00	518	27	518	148	3.5	0.262231775668853	0.262231775668853	false	false	false
9c23b945-4ac0-4444-9a7c-49260b2a481f	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	MRK	MRK260925P00148000	put	148.0000	2026-09-25	1.1900	0.7000	1.1900	148.1300	34388.00	34271.00	117.00	289	12	290	529	0.54820415879017	0.290361600163224	0.285780770977155	true	false	false
056cbc77-b15a-4bb1-b4ad-582d7ed11232	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	MRK	MRK261120P00130000	put	130.0000	2026-11-20	1.5500	1.5200	1.5500	148.2600	11005.00	11005.00	0.00	71	25	85	1925	0.0441558441558442	0.343163661029321	0.343163661029321	false	false	false
8d00ca02-4dee-4aae-9a50-cf18ba9e1aa5	2026-09-23 10:42	2026-09-23 10:42	2026-09-23 10:42	MRK	MRK261002P00145000	put	145.0000	2026-10-02	0.8700	0.6800	0.8700	149.3000	10266.00	10266.00	0.00	118	26	120	82	1.46341463414634	0.269688498747838	0.269688498747838	false	false	false
b8bc12d3-ff04-40ae-ae74-5885e06e232b	2026-09-23 10:36	2026-09-23 10:36	2026-09-23 10:36	MRK	MRK261030C00140000	call	140.0000	2026-10-30	12.5500	12.5500	13.0500	149.5200	17570.00	0.00	17570.00	14	7	199	3	66.3333333333333	0.340557852496176	0.340557852496176	true	false	false
a78cf79e-7f23-4480-94a0-f10adf2cf1a8	2026-09-23 10:36	2026-09-23 10:36	2026-09-23 10:36	MRK	MRK261030C00140000	call	140.0000	2026-10-30	12.5500	12.5500	13.0500	149.5200	22590.00	0.00	22590.00	18	8	185	3	61.6666666666667	0.340557852496176	0.340557852496176	false	false	false
9167c650-0a76-421a-aabb-e2ef6e3220ac	2026-09-23 10:36	2026-09-23 10:36	2026-09-23 10:36	MRK	MRK261030C00140000	call	140.0000	2026-10-30	12.5500	12.5500	13.0500	149.5338	15060.00	0.00	15060.00	12	5	163	3	54.3333333333333	0.33985397641599	0.33985397641599	false	false	false
10fe3455-3eb7-4d4f-9bda-e96c9d10725c	2026-09-23 10:30	2026-09-23 10:30	2026-09-23 10:30	MRK	MRK261030C00140000	call	140.0000	2026-10-30	12.9000	12.0500	12.9000	149.6750	194785.00	163830.00	1285.00	151	30	151	3	50.3333333333333	0.356120888256304	0.352794792449393	true	false	false
3694afe1-7b25-46e8-af4a-48cc56e25eca	2026-09-22 15:36	2026-09-22 15:36	2026-09-22 15:36	MRK	MRK261218P00145000	put	145.0000	2026-12-18	5.9500	5.9500	6.1500	151.4959	21420.00	0.00	21420.00	36	12	492	1032	0.476744186046512	0.327100042924671	0.327100042924671	false	false	false
b282d7a6-317e-46e0-83bc-bd654fda1504	2026-09-22 14:17	2026-09-22 14:16	2026-09-22 14:16	MRK	MRK261030P00145000	put	145.0000	2026-10-30	3.2500	3.2500	3.4000	152.0703	26325.00	0.00	26325.00	81	17	81	4	20.25	0.334064841923232	0.334064841923232	false	false	false
0bf9cfc8-570d-41db-a0ef-62686ba7164d	2026-09-22 13:09	2026-09-22 13:09	2026-09-22 13:09	MRK	MRK261218C00150000	call	150.0000	2026-12-18	10.6500	10.6500	11.0500	151.5610	37275.00	0.00	37275.00	35	5	120	1750	0.0685714285714286	0.309866110329975	0.309866110329975	false	false	false
ad578927-bbcd-41e4-a850-4ece13f6b07d	2026-09-22 12:59	2026-09-22 12:59	2026-09-22 12:59	MRK	MRK261218C00150000	call	150.0000	2026-12-18	10.6500	10.6500	11.0500	151.0000	23430.00	0.00	23430.00	22	5	85	1750	0.0485714285714286	0.311426836869418	0.311426836869418	false	false	false
d3aeea7b-eff2-4db3-aaac-0389bab79c12	2026-09-22 12:02	2026-09-22 12:02	2026-09-22 12:02	MRK	MRK260925C00157500	call	157.5000	2026-09-25	0.2600	0.2200	0.3400	152.0500	24414.00	4888.00	19526.00	939	5	4503	3400	1.32441176470588	0.323493542453815	0.323493542453815	false	false	false
4ee80325-ae95-44ab-89aa-8cdbfdcc4a9c	2026-09-22 11:13	2026-09-22 11:13	2026-09-22 11:13	MRK	MRK260925C00152500	call	152.5000	2026-09-25	2.0500	1.9200	2.0600	153.0200	12711.00	12711.00	0.00	62	11	1105	510	2.16666666666667	0.316886151597737	0.318711816291104	true	false	false
75c949dc-b2a6-4e29-ac94-a0338dde1b9e	2026-09-22 11:13	2026-09-22 11:13	2026-09-22 11:13	MRK	MRK260925C00152500	call	152.5000	2026-09-25	2.0400	1.7100	2.0400	152.9900	103020.00	103020.00	0.00	505	7	1014	510	1.98823529411765	0.320123275025926	0.318104644886516	true	false	false
6799feae-5ada-42a1-9b07-af6c5a004d80	2026-09-22 11:12	2026-09-22 11:12	2026-09-22 11:12	MRK	MRK261016C00155000	call	155.0000	2026-10-16	3.5900	3.3000	3.6000	152.9000	107805.00	107805.00	0.00	300	8	409	6307	0.0648485809418107	0.279236062618272	0.279588409222767	false	false	false
f9fa4364-285d-4e82-a98e-b140dac3b5f4	2026-09-22 11:10	2026-09-22 11:10	2026-09-22 11:10	MRK	MRK260925C00157500	call	157.5000	2026-09-25	0.3700	0.3200	0.3700	152.0000	11042.00	11042.00	0.00	300	28	2544	3400	0.748235294117647	0.331094125391092	0.337243820914266	false	false	false
2a7b1e26-4350-431d-a20d-7cf2b5d77ac4	2026-09-22 11:07	2026-09-22 11:07	2026-09-22 11:07	MRK	MRK261218C00170000	call	170.0000	2026-12-18	3.4600	3.4500	3.6500	152.0000	81215.00	0.00	81215.00	235	11	2635	10885	0.242076251722554	0.301548631043204	0.299910382238977	false	false	false
9e0486b0-170f-454c-a3d4-f804eb4c72bc	2026-09-22 11:06	2026-09-22 11:06	2026-09-22 11:06	MRK	MRK261218C00170000	call	170.0000	2026-12-18	3.6000	3.4500	3.6000	152.0000	627480.00	627480.00	0.00	1743	21	1749	10885	0.160679834634819	0.303076156260544	0.303076156260544	true	false	false
4507bba3-a4b1-43e2-9008-19ce58452d59	2026-09-22 11:05	2026-09-22 11:04	2026-09-22 11:04	MRK	MRK260925C00144000	call	144.0000	2026-09-25	8.2100	6.0500	8.6000	152.0600	12312.00	12312.00	0.00	15	5	18	46	0.391304347826087	0.360110494919636	0.360110494919636	false	false	false
d25e1f10-9c22-40ec-90ab-88dacf2f66d2	2026-09-22 10:41	2026-09-22 10:41	2026-09-22 10:41	MRK	MRK261016C00160000	call	160.0000	2026-10-16	1.3000	1.1300	1.3400	151.3900	25739.00	23010.00	2729.00	198	33	242	2028	0.119329388560158	0.262914506855818	0.262914506855818	false	false	false
0ae49b2a-634e-4751-a2c1-af84b845c7b9	2026-09-22 10:38	2026-09-22 10:37	2026-09-22 10:37	MRK	MRK270917C00155000	call	155.0000	2027-09-17	19.1000	17.9500	19.9500	151.3597	13370.00	5730.00	7640.00	7	5	7	21	0.333333333333333	0.296693491119123	0.296693491119123	false	false	false
a199b990-a545-48f2-9da3-10dc388c8b65	2026-09-22 10:31	2026-09-22 10:31	2026-09-22 10:31	MRK	MRK261002C00155000	call	155.0000	2026-10-02	1.1900	0.8800	1.2300	150.7500	40329.00	20231.00	20098.00	339	8	346	488	0.709016393442623	0.275249241306489	0.274070857436629	true	false	false
d51d12dc-e8f8-4e2d-8032-750dddf0b40a	2026-09-22 10:24	2026-09-22 10:24	2026-09-22 10:24	MRK	MRK261218P00145000	put	145.0000	2026-12-18	6.3000	6.3000	6.7000	150.0000	29610.00	0.00	29610.00	47	11	87	1032	0.0843023255813953	0.325737932708709	0.325737932708709	false	false	false
07104bef-415c-4b84-ad61-f9002e6fcc53	2026-09-22 10:10	2026-09-22 10:10	2026-09-22 10:10	MRK	MRK261218P00145000	put	145.0000	2026-12-18	6.7000	6.7000	6.9500	149.3150	22110.00	0.00	22110.00	33	6	40	1032	0.0387596899224806	0.326199453739462	0.326199453739462	false	false	false
12893057-aca6-4207-82fb-b7371059a9bb	2026-09-21 15:29	2026-09-21 15:29	2026-09-21 15:29	MRK	MRK261120C00155000	call	155.0000	2026-11-20	6.0000	6.0000	6.2500	149.9700	115800.00	0.00	115800.00	193	5	807	1059	0.762039660056657	0.318928587721306	0.318928587721306	false	false	false
a302ac9b-37ba-42a0-97a1-3664196365ed	2026-09-21 14:55	2026-09-21 14:55	2026-09-21 14:55	MRK	MRK261016C00150000	call	150.0000	2026-10-16	4.4000	4.3500	4.6000	150.1300	117480.00	19360.00	84920.00	267	51	1749	3909	0.447429009976976	0.264419443729353	0.263735482219027	true	false	false
23909015-af00-4a0e-b874-db5414cb06c2	2026-09-21 14:55	2026-09-21 14:55	2026-09-21 14:55	MRK	MRK261016C00150000	call	150.0000	2026-10-16	4.4000	4.3500	4.6000	150.1500	118800.00	48840.00	69520.00	270	49	2060	3909	0.52698899974418	0.263050489508553	0.263050489508553	true	false	false
197e317a-f68e-4739-885a-43d85cba8c37	2026-09-21 14:55	2026-09-21 14:55	2026-09-21 14:55	MRK	MRK261016C00150000	call	150.0000	2026-10-16	4.4000	4.3500	4.5000	150.1000	44000.00	14080.00	5720.00	100	8	1132	3909	0.289588129956511	0.264761040449548	0.264761040449548	false	false	false
004d40f8-ddc8-42d0-bfda-f4718e5a370f	2026-09-21 14:55	2026-09-21 14:55	2026-09-21 14:55	MRK	MRK261016C00150000	call	150.0000	2026-10-16	4.4000	4.3500	4.6000	150.0750	135520.00	46640.00	76560.00	308	15	1440	3909	0.368380660015349	0.264761040449548	0.265613920594051	true	false	false
554721ed-fa69-4ddd-b678-d9bf5eef8dbd	2026-09-21 14:55	2026-09-21 14:55	2026-09-21 14:55	MRK	MRK261016C00150000	call	150.0000	2026-10-16	4.4500	4.3500	4.5500	150.1100	44500.00	18245.00	5785.00	100	7	973	3909	0.248912765413149	0.267621090859248	0.267621090859248	false	false	false
45eeb791-5fa0-4d28-9073-fe225e917865	2026-09-21 13:54	2026-09-21 13:53	2026-09-21 13:53	MRK	MRK261016C00145000	call	145.0000	2026-10-16	7.1500	6.9500	7.2000	149.4950	51480.00	34320.00	8580.00	72	18	428	2073	0.206464061746261	0.278045143416554	0.278045143416554	true	false	false
8b38ae12-83cc-4d88-9cf2-1714ac2873bc	2026-09-21 13:53	2026-09-21 13:53	2026-09-21 13:53	MRK	MRK261016C00145000	call	145.0000	2026-10-16	7.1000	7.1000	7.1500	149.4799	19880.00	0.00	9230.00	28	7	356	2073	0.171731789676797	0.27517852203982	0.27517852203982	true	false	false