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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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 = SMH×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

7c1a4c1e-1dd2-415e-b1d0-9e17525718e1	2026-09-28 11:03	2026-09-28 11:03	2026-09-28 11:03	SMH	SMH261002P00582500	put	582.5000	2026-10-02	4.7000	4.5500	4.8000	594.4100	11280.00	1880.00	9400.00	24	6	196	268	0.73134328358209	0.389928716824059	0.389928716824059	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	74601951093.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-28T15:04:58.148934Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
42e7e03a-0633-4122-9356-4873bce274d2	2026-09-28 10:59	2026-09-28 10:59	2026-09-28 10:59	SMH	SMH260930C00600000	call	600.0000	2026-09-30	3.7000	3.7000	4.1500	593.7300	12950.00	0.00	12950.00	35	8	92	449	0.204899777282851	0.357401590708176	0.357401590708176	false	false	false	true
f5319bff-2d0e-469e-9d28-73b211e241c3	2026-09-28 10:59	2026-09-28 10:59	2026-09-28 10:59	SMH	SMH260929C00600000	call	600.0000	2026-09-29	2.1000	2.1000	2.3600	593.7300	12600.00	0.00	12600.00	60	17	73	52	1.40384615384615	0.357418661182556	0.364614734331994	false	false	false	true
31cc9db2-c800-4186-8ac8-8c19da921ab8	2026-09-28 10:59	2026-09-28 10:59	2026-09-28 10:59	SMH	SMH260929C00597500	call	597.5000	2026-09-29	2.9400	2.9300	3.3000	593.9900	15288.00	0.00	15288.00	52	16	58	19	3.05263157894737	0.357867585917907	0.357867585917907	false	false	false	true
6562bbaa-0eac-4e1e-b096-cd89c57b39c3	2026-09-28 10:58	2026-09-28 10:58	2026-09-28 10:58	SMH	SMH261023P00547500	put	547.5000	2026-10-23	5.6500	5.4500	5.9500	594.3300	12430.00	565.00	11865.00	22	6	22	373	0.0589812332439678	0.366721725803965	0.366721725803965	true	false	false	true
5665f538-b37a-489a-927a-b2703cd864ce	2026-09-28 10:57	2026-09-28 10:57	2026-09-28 10:57	SMH	SMH261030P00580000	put	580.0000	2026-10-30	17.2400	17.1000	18.2000	594.2550	36210.00	0.00	36210.00	21	5	51	93	0.548387096774194	0.355232081216252	0.352983578001895	true	false	false	true
f431d791-4a0e-43d0-9a67-330e941c4d0a	2026-09-28 10:57	2026-09-28 10:57	2026-09-28 10:57	SMH	SMH261002P00590000	put	590.0000	2026-10-02	7.1500	7.0500	7.5500	594.2550	34330.00	8590.00	25740.00	48	12	123	1103	0.111514052583862	0.372696512724384	0.373467020639358	true	false	false	true
b4645b34-82ae-471d-93fe-8deb95d32739	2026-09-28 10:57	2026-09-28 10:57	2026-09-28 10:57	SMH	SMH261005P00597500	put	597.5000	2026-10-05	11.7900	11.5000	13.8000	594.2550	14150.00	6990.00	7160.00	12	5	36	4	9	0.316049761339116	0.306877645073559	true	false	false	true
9f625086-8020-420b-83cc-91dee1938af2	2026-09-28 10:56	2026-09-28 10:56	2026-09-28 10:56	SMH	SMH261016P00575000	put	575.0000	2026-10-16	9.5000	9.5000	9.9000	593.8400	98800.00	0.00	98800.00	104	7	156	987	0.158054711246201	0.342876408877059	0.342876408877059	false	false	false	true
ad2b8338-aeee-48b1-bf38-2e715b717e32	2026-09-28 10:56	2026-09-28 10:56	2026-09-28 10:56	SMH	SMH261002P00580000	put	580.0000	2026-10-02	4.3000	4.3000	4.5500	593.6001	10328.00	0.00	10328.00	24	10	497	1324	0.375377643504532	0.395678722055316	0.395678722055316	true	false	false	true
375fc015-14d1-45fd-9de7-29186206c8bb	2026-09-28 10:55	2026-09-28 10:55	2026-09-28 10:55	SMH	SMH261016P00560000	put	560.0000	2026-10-16	6.1000	6.0000	6.1000	593.2400	36580.00	36580.00	0.00	60	6	296	5333	0.0555034689668104	0.36064727980487	0.36064727980487	false	false	false	true
88cb10fd-3e0e-45a5-b181-8de6b3906458	2026-09-28 10:51	2026-09-28 10:51	2026-09-28 10:51	SMH	SMH261002P00575000	put	575.0000	2026-10-02	3.4000	3.3000	3.4000	593.2850	13940.00	13940.00	0.00	41	12	231	1353	0.170731707317073	0.412903451267727	0.412903451267727	false	false	false	true
07281be6-0d8b-48ca-8964-967dbd66b5c7	2026-09-28 10:48	2026-09-28 10:48	2026-09-28 10:48	SMH	SMH261016C00630000	call	630.0000	2026-10-16	5.0000	4.7000	5.0000	592.0000	10500.00	10500.00	0.00	21	6	1188	8388	0.141630901287554	0.321959388662238	0.321959388662238	false	false	false	true
07c01e26-8f77-4d12-8fd1-b724db98a1fb	2026-09-28 10:48	2026-09-28 10:48	2026-09-28 10:48	SMH	SMH260928P00592500	put	592.5000	2026-09-28	2.5900	2.3200	2.5900	592.0000	25900.00	25900.00	0.00	100	6	502	323	1.55417956656347	0.427163309107309	0.427163309107309	false	false	false	true
a9c0efd7-bf08-4180-b01d-20b5cd1bf11e	2026-09-28 10:47	2026-09-28 10:47	2026-09-28 10:47	SMH	SMH261002P00550000	put	550.0000	2026-10-02	0.8400	0.8400	0.8800	592.5000	16800.00	0.00	16800.00	200	5	440	897	0.490523968784838	0.477510234976186	0.477510234976186	false	false	false	true
b34a6bd4-65d7-48cc-bb43-2fb51300d90f	2026-09-28 10:46	2026-09-28 10:46	2026-09-28 10:46	SMH	SMH261006P00585000	put	585.0000	2026-10-06	7.2000	4.8500	7.3500	593.0000	37448.00	37448.00	0.00	52	19	185	346	0.534682080924855	0.320444133841888	0.324986388944147	false	false	false	true
f7ed6423-2dc6-4166-b0a3-c0154cec5f43	2026-09-28 10:46	2026-09-28 10:46	2026-09-28 10:46	SMH	SMH261120P00590000	put	590.0000	2026-11-20	29.7000	29.7000	29.7500	594.0000	297000.00	0.00	297000.00	100	11	127	791	0.160556257901391	0.372721053231993	0.372721053231993	false	false	false	true
5886e66b-bb9f-4aab-9568-5a2dcf127472	2026-09-28 10:46	2026-09-28 10:46	2026-09-28 10:46	SMH	SMH261016C00630000	call	630.0000	2026-10-16	5.2000	4.9500	5.2000	594.0000	10920.00	10920.00	0.00	21	7	1164	8388	0.138769670958512	0.319270636379575	0.319270636379575	false	false	false	true
084243c3-8229-40e8-994f-8b0613cbc75b	2026-09-28 10:44	2026-09-28 10:44	2026-09-28 10:44	SMH	SMH261002P00580000	put	580.0000	2026-10-02	3.8500	3.6000	3.8500	594.7800	48509.00	48509.00	0.00	126	18	448	1324	0.338368580060423	0.389129098330509	0.389129098330509	true	false	false	true
c104dc14-35a7-43b3-811b-132fc7e0d960	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	SMH	SMH261009P00562500	put	562.5000	2026-10-09	3.1000	2.5800	3.1000	596.1050	18290.00	18290.00	0.00	59	5	98	66	1.48484848484848	0.351178542594552	0.351178542594552	false	false	false	true
6af63f8e-9c49-4aaa-a9ea-d270261e3d6f	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	SMH	SMH261002P00575000	put	575.0000	2026-10-02	2.5000	2.2200	2.5000	596.1050	29000.00	29000.00	0.00	116	9	153	1353	0.113082039911308	0.394415530476382	0.394415530476382	false	false	false	true
602eb925-7a35-4e92-8f53-e6ed889bf271	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	SMH	SMH261009P00572500	put	572.5000	2026-10-09	4.8500	4.2000	4.8500	596.1050	49955.00	49955.00	0.00	103	11	156	133	1.17293233082707	0.339063904610173	0.339063904610173	false	false	false	true
5026525d-4e30-498a-a8f8-7dc8df91be1e	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	SMH	SMH261005P00585000	put	585.0000	2026-10-05	5.4000	4.5500	5.6000	596.1000	39420.00	39420.00	0.00	73	7	85	179	0.474860335195531	0.311226906161287	0.311172991075045	true	false	false	true
0861d851-963e-484c-9a83-5c7996402b83	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	SMH	SMH261009P00570000	put	570.0000	2026-10-09	4.4000	3.7500	4.4000	596.1050	77000.00	77000.00	0.00	175	8	182	1550	0.11741935483871	0.343848911415383	0.343848911415383	false	false	false	true
040bdb28-40e3-4220-97cf-a19d0bdf6c7b	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	SMH	SMH261006P00585000	put	585.0000	2026-10-06	6.3500	4.0500	6.3500	596.1050	84455.00	84455.00	0.00	133	17	133	346	0.384393063583815	0.321759439221463	0.321759439221463	false	false	false	true
c73bf44a-b5fb-48cc-b769-5ac9d48ae9e3	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	SMH	SMH261002P00580000	put	580.0000	2026-10-02	3.3000	3.1500	3.3000	596.1000	23760.00	23760.00	0.00	72	23	312	1324	0.235649546827795	0.377696924674429	0.377696924674429	false	false	false	true
d9d251e0-98a9-49f0-872b-97d6382adb00	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	SMH	SMH261005P00590000	put	590.0000	2026-10-05	7.0500	5.7000	7.0500	596.2600	23260.00	23260.00	0.00	33	14	94	142	0.661971830985915	0.306942681301425	0.306942681301425	false	false	false	true
25b13de8-f146-460b-a666-4becdd0b7ed4	2026-09-28 10:43	2026-09-28 10:43	2026-09-28 10:43	SMH	SMH261023P00592500	put	592.5000	2026-10-23	17.8000	16.3000	17.8000	596.3700	51620.00	51620.00	0.00	29	16	46	67	0.686567164179104	0.329827263718966	0.329827263718966	true	false	false	true
9b68c975-5ae5-4e2b-b616-3aa992f6b655	2026-09-28 10:38	2026-09-28 10:38	2026-09-28 10:38	SMH	SMH261002P00595000	put	595.0000	2026-10-02	7.4500	6.8500	7.4500	597.4000	47680.00	47680.00	0.00	64	16	136	449	0.302895322939866	0.350189300109249	0.350189300109249	false	false	false	true
2d53b794-42c9-479f-b05f-e45c8e902263	2026-09-28 10:38	2026-09-28 10:38	2026-09-28 10:38	SMH	SMH261002P00597500	put	597.5000	2026-10-02	8.6000	7.9500	8.6000	597.4000	56760.00	56760.00	0.00	66	15	232	380	0.610526315789474	0.348052142684925	0.348052142684925	false	false	false	true
a1480f9c-1ff3-48ab-af31-2ac20e717fb2	2026-09-28 10:38	2026-09-28 10:38	2026-09-28 10:38	SMH	SMH261120P00605000	put	605.0000	2026-11-20	34.9500	34.9000	35.1500	597.6600	115335.00	104850.00	6990.00	33	5	83	1037	0.0800385728061716	0.363346690956427	0.363346690956427	false	false	false	true
2af53083-fcd7-43e7-9c22-0cd9fcea4a80	2026-09-28 10:32	2026-09-28 10:32	2026-09-28 10:32	SMH	SMH261016P00565000	put	565.0000	2026-10-16	5.5500	5.4000	5.6000	598.6700	35520.00	11655.00	9435.00	64	8	350	2164	0.16173752310536	0.345665000362421	0.345665000362421	true	false	false	true
f926f7fd-a4f5-4e0a-b98d-708cc7d3410f	2026-09-28 10:32	2026-09-28 10:32	2026-09-28 10:32	SMH	SMH261120P00550000	put	550.0000	2026-11-20	13.8000	13.6000	13.9000	598.6502	46920.00	27600.00	8280.00	34	6	123	4654	0.0264288783841856	0.386442767842668	0.386442767842668	false	false	false	true
e6b091b2-b053-4515-8586-3f47eed69583	2026-09-28 10:32	2026-09-28 10:32	2026-09-28 10:32	SMH	SMH261120P00550000	put	550.0000	2026-11-20	13.7500	13.7500	14.0000	598.6502	30250.00	0.00	26125.00	22	8	72	4654	0.0154705629565965	0.385745153978496	0.385745153978496	true	false	false	true
6dfd81f8-778e-41b2-b1f4-9ed818656d41	2026-09-28 10:32	2026-09-28 10:32	2026-09-28 10:32	SMH	SMH261120P00550000	put	550.0000	2026-11-20	13.7500	13.3500	14.2000	598.6502	49500.00	2750.00	31625.00	36	5	50	4654	0.0107434464976364	0.385745153978496	0.385745153978496	false	false	false	true
d21c48bc-d7eb-4890-8f36-0ab15f83cf31	2026-09-28 10:31	2026-09-28 10:31	2026-09-28 10:31	SMH	SMH261023P00570000	put	570.0000	2026-10-23	9.2500	8.9000	9.2500	598.0000	37925.00	32375.00	0.00	41	10	49	53	0.924528301886792	0.343695703804542	0.343695703804542	true	false	false	true
32736afa-a53e-4db0-bc2d-b2333e6f8017	2026-09-28 10:31	2026-09-28 10:31	2026-09-28 10:31	SMH	SMH261023P00582500	put	582.5000	2026-10-23	13.0500	12.4000	13.0500	598.0000	23485.00	23485.00	0.00	18	11	82	69	1.18840579710145	0.335592555662335	0.335592555662335	true	false	false	true
265c07b6-d775-4545-b952-062ca7505b25	2026-09-28 10:30	2026-09-28 10:30	2026-09-28 10:30	SMH	SMH260930C00620000	call	620.0000	2026-09-30	0.6600	0.6600	0.6700	598.0000	22440.00	0.00	22440.00	340	46	345	97	3.55670103092783	0.348075552820822	0.348075552820822	false	false	false	true
3b49e1b1-c120-450d-a650-d3a51a8c8300	2026-09-28 10:25	2026-09-28 10:25	2026-09-28 10:25	SMH	SMH260930C00602500	call	602.5000	2026-09-30	4.5000	4.5000	4.8500	599.0000	15750.00	0.00	15750.00	35	12	40	53	0.754716981132076	0.331589050297417	0.331589050297417	true	false	false	true
0882a62b-99b2-4b00-9856-e7862c8bdce3	2026-09-28 10:25	2026-09-28 10:25	2026-09-28 10:25	SMH	SMH260930C00607500	call	607.5000	2026-09-30	2.7400	2.7400	3.0000	599.0000	10960.00	0.00	10960.00	40	16	64	81	0.790123456790123	0.331163437601442	0.331163437601442	true	false	false	true
de75cdaa-7c1a-40bc-a5f6-d14ffa21a242	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	SMH	SMH261016C00612500	call	612.5000	2026-10-16	11.5200	11.4500	11.9500	599.0000	14970.00	5770.00	9200.00	13	9	32	236	0.135593220338983	0.312289316654404	0.312289316654404	true	false	false	true
4b55856b-82ab-42c1-84aa-161785913a0a	2026-09-28 10:24	2026-09-28 10:24	2026-09-28 10:24	SMH	SMH261016C00615000	call	615.0000	2026-10-16	10.5600	10.5000	11.0000	599.0000	31670.00	0.00	30615.00	30	14	57	13866	0.00411077455646906	0.311511691353924	0.311511691353924	true	false	false	true
45169dc6-5ec8-40f2-9fa9-b31fe0fb95f4	2026-09-28 10:22	2026-09-28 10:22	2026-09-28 10:22	SMH	SMH261016P00600000	put	600.0000	2026-10-16	16.5500	16.5000	17.1000	599.6400	11585.00	1655.00	9930.00	7	7	123	6258	0.0196548418024928	0.319614950333988	0.319614950333988	false	false	false	true
33cc4f3a-af42-41dd-b323-c923366eb192	2026-09-28 10:20	2026-09-28 10:20	2026-09-28 10:20	SMH	SMH261016C00630000	call	630.0000	2026-10-16	6.3500	5.9500	6.3500	599.3400	14605.00	14605.00	0.00	23	5	865	8388	0.10312350977587	0.316313870053149	0.316313870053149	false	false	false	true
297193f8-81b9-4a87-b269-3a7a4ad1c76b	2026-09-28 10:20	2026-09-28 10:20	2026-09-28 10:20	SMH	SMH261009P00600000	put	600.0000	2026-10-09	13.1000	13.1000	13.6000	598.8250	34060.00	0.00	34060.00	26	6	104	133	0.781954887218045	0.310400871480695	0.310400871480695	true	false	false	true
fb1575c3-a4e0-43f1-ae43-93bec0eea2c0	2026-09-28 10:18	2026-09-28 10:17	2026-09-28 10:17	SMH	SMH261016P00595000	put	595.0000	2026-10-16	14.9000	14.6000	15.4000	598.7519	19375.00	0.00	19375.00	13	6	185	829	0.223160434258142	0.326723808301759	0.326723808301759	false	false	false	true
d41ad253-f37e-4b03-9f93-92bd7d2f503e	2026-09-28 10:18	2026-09-28 10:17	2026-09-28 10:17	SMH	SMH261009P00607500	put	607.5000	2026-10-09	17.4000	17.4000	19.0000	598.7750	10440.00	0.00	10440.00	6	6	23	5	4.6	0.311913937171904	0.311913937171904	false	false	false	true
d078e2f0-d348-486b-a262-03c8b12eaf91	2026-09-28 10:17	2026-09-28 10:16	2026-09-28 10:16	SMH	SMH261023P00572500	put	572.5000	2026-10-23	10.2500	10.0500	10.7000	598.6150	44080.00	2050.00	42030.00	43	14	43	32	1.34375	0.348964162157846	0.348964162157846	true	false	false	true
c550d2e6-559c-4d3f-b5d9-d6822295edc6	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	SMH	SMH261030P00575000	put	575.0000	2026-10-30	14.4000	14.4000	14.8000	598.0700	50400.00	0.00	50400.00	35	6	39	57	0.684210526315789	0.361708952757551	0.361708952757551	true	false	false	true
94738cc9-2f13-4a9e-a845-dbbc64f0aa85	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	SMH	SMH261016P00550000	put	550.0000	2026-10-16	3.9000	3.7500	3.9000	597.6550	54600.00	54600.00	0.00	140	15	607	8299	0.0731413423304013	0.377982176000022	0.377982176000022	false	false	false	true