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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:er_time = premarket×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

d915c779-948d-4e90-9410-634a104be050	2026-10-02 15:12	2026-10-02 15:12	2026-10-02 15:12	MRK	MRK261030P00133000	put	133.0000	2026-10-30	1.6000	1.5600	1.7400	143.9100	12640.00	5120.00	1760.00	79	7	159	5	31.8	0.360788437773133	0.360788437773133	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	Common Stock	Healthcare	356012867363.00	2026-10-29	premarket	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T19:15:21.750665Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
e8e814ca-4f2c-4db6-8312-a030be8cce7b	2026-10-02 15:12	2026-10-02 15:12	2026-10-02 15:12	MRK	MRK261030P00133000	put	133.0000	2026-10-30	1.6000	1.4900	1.6000	143.9100	12640.00	5280.00	0.00	79	5	80	5	16	0.360788437773133	0.360788437773133	false	false	false	true
10fddb63-0026-4b35-833f-c808909ab48a	2026-10-02 14:51	2026-10-02 14:51	2026-10-02 14:51	MRK	MRK261218P00140000	put	140.0000	2026-12-18	6.5500	6.5000	6.5500	143.4400	22270.00	22270.00	0.00	34	12	120	1320	0.0909090909090909	0.33624064746782	0.33624064746782	false	false	false	true
2693279b-26c3-41f3-a071-c9fc4d1349d6	2026-10-02 14:16	2026-10-02 14:15	2026-10-02 14:15	MRK	MRK261218C00150000	call	150.0000	2026-12-18	5.9500	5.8500	6.1500	143.0000	92825.00	600.00	92225.00	156	26	253	1817	0.139240506329114	0.309167853746524	0.31109857401702	false	false	false	true
7c7f2350-e6bd-4ed9-82fe-a16860a08c75	2026-10-02 12:27	2026-10-02 12:27	2026-10-02 12:27	MRK	MRK270917P00130000	put	130.0000	2027-09-17	10.4200	10.0500	10.4500	143.0000	42730.00	26090.00	16640.00	41	11	94	247	0.380566801619433	0.350290030806599	0.351405197607762	true	false	false	true
534fb8b1-22e8-4c51-a0fd-7039b69ad44d	2026-10-02 11:34	2026-10-02 11:33	2026-10-02 11:33	MRK	MRK270416P00145000	put	145.0000	2027-04-16	13.2500	13.2000	13.4000	143.0000	311375.00	18550.00	288850.00	235	24	235	83	2.83132530120482	0.342706431300629	0.342706431300629	false	false	false	true
67371e19-6709-48bf-a90c-272745f3c83e	2026-10-02 11:06	2026-10-02 11:06	2026-10-02 11:06	MRK	MRK261016C00130000	call	130.0000	2026-10-16	13.2500	13.0000	13.2500	142.0000	29150.00	29150.00	0.00	22	7	209	3397	0.0615248748896085	0.327245876842808	0.327245876842808	false	false	false	true
d3c90b4e-6c2e-4138-9b7e-61e2c42c943a	2026-10-02 10:38	2026-10-02 10:38	2026-10-02 10:38	MRK	MRK261120C00170000	call	170.0000	2026-11-20	0.8000	0.8000	0.9600	143.3300	12880.00	0.00	12880.00	161	19	170	2148	0.0791433891992551	0.336229725617073	0.336229725617073	false	false	false	true
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
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
044cbf1b-1e9c-4a1e-9a25-1548c1bc8dcb	2026-10-01 12:22	2026-10-01 12:22	2026-10-01 12:22	MRK	MRK261120C00165000	call	165.0000	2026-11-20	1.4900	1.4600	1.6300	144.0000	14021.00	2548.00	11473.00	94	17	102	2387	0.0427314620863008	0.338759138242414	0.338759138242414	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
a53e9daf-1e2a-458a-89bc-a8dbf1ecf25c	2026-10-01 09:48	2026-10-01 09:47	2026-10-01 09:47	MRK	MRK261120P00140000	put	140.0000	2026-11-20	4.7700	4.7500	5.2000	144.0000	25736.00	8160.00	17576.00	54	7	112	2496	0.0448717948717949	0.345399299399817	0.347907598603904	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
0ddcc97d-2a06-4ba0-bd74-0d7fa95ded66	2026-09-30 12:24	2026-09-30 12:24	2026-09-30 12:24	MRK	MRK261030C00160000	call	160.0000	2026-10-30	1.9500	1.5700	1.9800	146.2500	383771.00	376112.00	6099.00	1970	57	1972	135	14.6074074074074	0.375148682229148	0.374610904592801	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
fcf44402-629f-434a-a598-397fb3325ba8	2026-09-30 11:18	2026-09-30 11:18	2026-09-30 11:18	MRK	MRK261016C00150000	call	150.0000	2026-10-16	2.2500	2.1600	2.3300	146.9200	16872.00	16649.00	223.00	75	10	89	5725	0.0155458515283843	0.280742111791772	0.279040104190829	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
f49dd07a-dacf-4b6e-b33f-518589afeb8d	2026-09-29 15:54	2026-09-29 15:54	2026-09-29 15:54	MRK	MRK261002P00148000	put	148.0000	2026-10-02	1.2000	1.0900	1.2000	149.1600	87219.00	71859.00	0.00	727	56	1514	243	6.23045267489712	0.324240409263864	0.323495964396733	true	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
5c1d9c96-76e5-435a-b4c2-7c823a358284	2026-09-29 13:17	2026-09-29 13:16	2026-09-29 13:16	MRK	MRK270617C00200000	call	200.0000	2027-06-17	3.3400	3.3000	3.7000	148.2050	66820.00	0.00	66820.00	200	5	262	826	0.317191283292978	0.302393308908615	0.30391043418541	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
b0d873c4-7707-4d52-980e-193b33a74418	2026-09-29 10:26	2026-09-29 10:26	2026-09-29 10:26	MRK	MRK261002P00146000	put	146.0000	2026-10-02	1.3600	1.3500	1.3800	146.8050	10040.00	0.00	8660.00	74	15	83	339	0.244837758112094	0.329353663900237	0.329353663900237	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
948dea21-0614-40ee-a00c-b860e8c0b7fa	2026-09-29 10:22	2026-09-29 10:22	2026-09-29 10:22	MRK	MRK261016C00150000	call	150.0000	2026-10-16	2.5000	2.3500	2.5000	147.1600	28470.00	28000.00	470.00	114	5	159	5608	0.0283523537803138	0.284614934691251	0.272379261062999	false	false	false	true
064c6dd5-1ad6-49da-a704-eab52b8999f0	2026-09-21 09:55	2026-09-21 09:55	2026-09-21 09:55	MRK	MRK260925C00147000	call	147.0000	2026-09-25	2.6000	2.2200	2.6700	148.1800	10920.00	10920.00	0.00	42	5	181	303	0.597359735973597	0.310612868624626	0.310612868624626	false	false	false	true