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 = RepeatedHitsAscendingFill×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	expiry

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	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	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
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
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
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
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
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
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
3ee4d41e-da32-489e-8e8d-86ba572abbee	2026-08-19 12:04	2026-08-19 12:04	2026-08-19 12:04	MRK	MRK261120C00145000	call	145.0000	2026-11-20	12.8500	12.8500	13.3000	149.7200	431780.00	0.00	431780.00	336	36	434	422	1.02843601895735	0.320765597744164	0.320765597744164	false	false	false	true
5e84e2cc-36ef-40c8-b632-0c758588fa97	2026-08-19 13:38	2026-08-19 13:38	2026-08-19 13:38	MRK	MRK270617C00170000	call	170.0000	2027-06-17	11.0500	11.0000	12.5000	150.9000	61885.00	0.00	61885.00	56	5	1844	56	32.9285714285714	0.296948325837682	0.298805187496803	false	false	false	true
61d92688-3ff7-412b-9ff8-e3cd5403dbb0	2026-08-19 15:09	2026-08-19 15:09	2026-08-19 15:09	MRK	MRK260821C00155000	call	155.0000	2026-08-21	1.8200	1.7100	1.8300	152.9600	65337.00	1455.00	63882.00	359	5	11565	565	20.4690265486726	0.590669592720206	0.597566174481732	true	false	false	true
ca69abb9-9c9c-4182-bd65-79d287da094e	2026-08-20 10:02	2026-08-20 10:02	2026-08-20 10:02	MRK	MRK261120P00135000	put	135.0000	2026-11-20	3.9000	3.9000	4.1000	150.3400	184098.00	0.00	184098.00	472	40	580	10845	0.0534808667588751	0.356722821830758	0.356722821830758	false	false	false	true
9a9ae15b-8089-415c-b3c7-f06933583320	2026-08-21 10:19	2026-08-21 10:18	2026-08-21 10:18	MRK	MRK270115C00165000	call	165.0000	2027-01-15	8.9700	8.6000	9.1000	154.1400	288008.00	186208.00	5335.00	321	24	328	1648	0.199029126213592	0.313808498401846	0.315106641358724	true	false	false	true
f78f6bae-7e32-4b4d-8d60-f1bc101207c5	2026-08-21 11:30	2026-08-21 11:30	2026-08-21 11:30	MRK	MRK261016C00160000	call	160.0000	2026-10-16	4.7100	4.7000	4.7500	153.4650	119989.00	0.00	110489.00	255	27	548	1031	0.531522793404462	0.293277982282016	0.293277982282016	false	false	false	true
7f31a3b0-0f2f-4383-8199-9e5d559da0e6	2026-08-21 11:30	2026-08-21 11:30	2026-08-21 11:30	MRK	MRK261016P00155000	put	155.0000	2026-10-16	8.1600	8.1000	8.2000	153.4650	55500.00	5735.00	41565.00	68	9	180	7	25.7142857142857	0.325960171502288	0.325960171502288	false	false	false	true
ac05cd25-99a4-49fa-8a7c-abebd99b3298	2026-08-24 12:40	2026-08-24 12:40	2026-08-24 12:40	MRK	MRK260918C00155000	call	155.0000	2026-09-18	2.2000	2.1900	2.4000	150.5100	79356.00	20606.00	45110.00	360	33	1739	1360	1.27867647058824	0.244230581159747	0.245431282235526	true	false	false	true
43f9446c-3f23-4bf3-bec4-935bae0cd533	2026-08-31 11:28	2026-08-31 11:28	2026-08-31 11:28	MRK	MRK261120C00160000	call	160.0000	2026-11-20	4.3500	4.3500	4.5000	147.8800	70917.00	0.00	70917.00	163	15	1217	773	1.57438551099612	0.301906241616019	0.301906241616019	false	false	false	true
81427ac6-df77-4c15-8917-e52a1950bc35	2026-09-03 13:55	2026-09-03 13:55	2026-09-03 13:55	MRK	MRK270617P00140000	put	140.0000	2027-06-17	10.7700	10.3000	10.8500	151.7550	256340.00	256340.00	0.00	238	12	238	132	1.8030303030303	0.344256233600555	0.344891854790701	false	false	false	true
f4abc8fe-ce35-486a-8a57-6722a45b5ac1	2026-09-04 15:53	2026-09-04 15:53	2026-09-04 15:53	MRK	MRK261218C00150000	call	150.0000	2026-12-18	10.7000	10.7000	10.9500	150.4400	295340.00	0.00	295340.00	276	28	428	1174	0.364565587734242	0.300257426644819	0.300257426644819	true	false	false	true
49466a27-1c8a-4753-8a8e-3755e2775268	2026-09-09 15:33	2026-09-09 15:32	2026-09-09 15:32	MRK	MRK261120C00155000	call	155.0000	2026-11-20	5.9000	5.8500	6.2000	147.8900	54310.00	3570.00	50740.00	92	29	131	610	0.214754098360656	0.319500886537992	0.321449158243001	true	false	false	true
efbceaf1-88a2-475e-bf14-5ea536b2a65e	2026-09-10 12:49	2026-09-10 12:49	2026-09-10 12:49	MRK	MRK261218C00190000	call	190.0000	2026-12-18	0.6900	0.6800	0.7100	144.0000	67143.00	10224.00	52020.00	978	21	980	279	3.51254480286738	0.318871796505059	0.318871796505059	false	false	false	true
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	true
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	true
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	true