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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 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

8bc1c8bf-bca9-4059-b3a0-70f1d10bfe16	2026-09-29 11:26	2026-09-29 11:26	2026-09-29 11:26	SMH	SMH261009P00597500	put	597.5000	2026-10-09	8.7900	7.8000	8.8500	607.8800	14945.00	13200.00	1745.00	17	9	108	230	0.469565217391304	0.342325607537913	0.342325607537913	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	73526349819.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T15:29:51.337369Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
1124e3fa-4581-4124-a681-4e4858ccf31f	2026-09-29 11:26	2026-09-29 11:26	2026-09-29 11:26	SMH	SMH261009P00582500	put	582.5000	2026-10-09	4.7000	4.4500	4.8000	607.8800	17395.00	8935.00	8460.00	37	15	41	138	0.297101449275362	0.357509185204498	0.357509185204498	true	false	false	true
62a7cea9-37a1-4813-a5c6-5af62cae9899	2026-09-29 11:26	2026-09-29 11:26	2026-09-29 11:26	SMH	SMH261016C00605000	call	605.0000	2026-10-16	20.1000	20.0500	20.6000	608.0000	40200.00	6030.00	34170.00	20	10	75	2316	0.0323834196891192	0.343836349348172	0.343836349348172	false	false	false	true
e58158af-7eed-46c4-9fb6-4dff3ee6494e	2026-09-29 11:22	2026-09-29 11:22	2026-09-29 11:22	SMH	SMH261120P00430000	put	430.0000	2026-11-20	1.3700	1.3100	1.3800	609.2000	32332.00	12741.00	4795.00	236	40	1778	2014	0.882820258192651	0.517622952449665	0.517622952449665	true	false	false	true
8f2b315f-12cd-491c-bb25-9cf554284602	2026-09-29 11:22	2026-09-29 11:22	2026-09-29 11:22	SMH	SMH261120P00430000	put	430.0000	2026-11-20	1.3700	1.2900	1.3800	609.1400	39182.00	32606.00	6576.00	286	39	1542	2014	0.765640516385303	0.517509242848985	0.517509242848985	true	false	false	true
fa78e957-71fc-4d0e-bcaf-9ce23672482e	2026-09-29 11:22	2026-09-29 11:22	2026-09-29 11:22	SMH	SMH261120P00430000	put	430.0000	2026-11-20	1.3600	1.3100	1.3700	609.1400	39032.00	37672.00	1224.00	287	29	1256	2014	0.623634558093347	0.516830593574914	0.516830593574914	false	false	false	true
3aa8660d-87b9-4942-a98e-0b1f02e95d5c	2026-09-29 11:22	2026-09-29 11:22	2026-09-29 11:22	SMH	SMH261120P00430000	put	430.0000	2026-11-20	1.3600	1.3100	1.3700	609.0950	38080.00	136.00	37944.00	280	20	969	2014	0.481132075471698	0.516735904633781	0.516745374050787	false	false	false	true
2d51f40c-e2f0-4b23-85b2-7f578f4ef622	2026-09-29 11:22	2026-09-29 11:21	2026-09-29 11:21	SMH	SMH261120P00430000	put	430.0000	2026-11-20	1.3500	1.2900	1.3700	609.0350	29547.00	1620.00	27927.00	219	21	587	2014	0.291459781529295	0.51595031407501	0.51595031407501	false	false	false	true
6cb7dd72-767a-44de-8af1-b2635bbe2e39	2026-09-29 11:21	2026-09-29 11:21	2026-09-29 11:21	SMH	SMH261002C00630000	call	630.0000	2026-10-02	1.9000	1.8200	2.0200	608.8100	19000.00	0.00	19000.00	100	9	482	1307	0.368783473603673	0.384769412414888	0.384769412414888	false	false	false	true
32acf943-330d-4e31-b331-aa284c7293bc	2026-09-29 11:21	2026-09-29 11:21	2026-09-29 11:21	SMH	SMH261120P00430000	put	430.0000	2026-11-20	1.3400	1.3000	1.3700	608.9100	47711.00	3223.00	17018.00	356	21	366	2014	0.181727904667329	0.515029523070083	0.515029523070083	false	false	false	true
305c2663-1398-4c22-9e6a-1cc440a7087d	2026-09-29 11:20	2026-09-29 11:20	2026-09-29 11:20	SMH	SMH261002C00610000	call	610.0000	2026-10-02	8.1500	7.8500	8.3000	609.2100	14670.00	12225.00	2445.00	18	5	348	2114	0.164616840113529	0.382902918420894	0.382902918420894	false	false	false	true
90c9a1f9-4ab8-4d9a-b8ad-282b67468cc1	2026-09-29 11:19	2026-09-29 11:19	2026-09-29 11:19	SMH	SMH261016P00612500	put	612.5000	2026-10-16	18.6000	17.4000	18.8000	609.5700	39060.00	37200.00	1860.00	21	10	26	17	1.52941176470588	0.336773715812442	0.336773715812442	false	false	false	true
89107434-45a6-49b2-8280-736ff5db8936	2026-09-29 11:19	2026-09-29 11:19	2026-09-29 11:19	SMH	SMH261016P00610000	put	610.0000	2026-10-16	17.3500	16.8000	17.4000	609.5700	38165.00	36430.00	0.00	22	10	108	330	0.327272727272727	0.337645994807638	0.337645994807638	false	false	false	true
2df07898-7016-4efa-a552-4936552d5daf	2026-09-29 11:19	2026-09-29 11:18	2026-09-29 11:18	SMH	SMH261016P00600000	put	600.0000	2026-10-16	12.9000	12.2500	13.0000	609.6050	19350.00	18060.00	1290.00	15	6	213	6386	0.0333542123394926	0.341330017107679	0.341330017107679	true	false	false	true
df1faebf-379e-44eb-978e-f76d5f4486d0	2026-09-29 11:14	2026-09-29 11:14	2026-09-29 11:14	SMH	SMH261009C00630000	call	630.0000	2026-10-09	6.0500	5.8000	6.0500	610.7350	15125.00	15125.00	0.00	25	9	146	968	0.150826446280992	0.325566235936351	0.325566235936351	false	false	false	true
c58fa3b7-830d-4d5d-a69d-94f027b624e3	2026-09-29 11:14	2026-09-29 11:14	2026-09-29 11:14	SMH	SMH261016C00630000	call	630.0000	2026-10-16	9.9500	9.6000	9.9500	610.7252	13930.00	13930.00	0.00	14	6	163	9282	0.017560870502047	0.328618168411296	0.328618168411296	false	false	false	true
457800e2-aa9b-4550-8500-c47c553f78e2	2026-09-29 11:13	2026-09-29 11:13	2026-09-29 11:13	SMH	SMH260929P00612500	put	612.5000	2026-09-29	3.7100	3.0500	3.7500	610.4400	18560.00	4500.00	14060.00	50	5	484	2	242	0.456394410238945	0.456394410238945	false	false	false	true
00837942-53bf-40b2-8ded-de15c7fb7e59	2026-09-29 11:10	2026-09-29 11:10	2026-09-29 11:10	SMH	SMH261016P00600000	put	600.0000	2026-10-16	12.5000	12.5000	12.8500	610.0000	25000.00	0.00	25000.00	20	12	163	6386	0.0255245850297526	0.341474364014834	0.341474364014834	false	false	false	true
d36a49ae-6f95-42b1-85b0-9ac90a0ef207	2026-09-29 11:09	2026-09-29 11:09	2026-09-29 11:09	SMH	SMH261001C00630000	call	630.0000	2026-10-01	1.3300	1.3300	1.5200	610.0000	13965.00	0.00	13965.00	105	23	291	10	29.1	0.397553207717117	0.397553207717117	false	false	false	true
d1748f01-6177-4128-b7be-f7268d9875a7	2026-09-29 11:09	2026-09-29 11:09	2026-09-29 11:09	SMH	SMH260930C00625000	call	625.0000	2026-09-30	0.9100	0.9100	1.0600	610.0000	50142.00	0.00	50051.00	551	48	841	195	4.31282051282051	0.403033631490453	0.405157237585179	true	false	false	true
5af0a99f-5586-4067-8999-e52476056abc	2026-09-29 11:05	2026-09-29 11:05	2026-09-29 11:05	SMH	SMH261002C00607500	call	607.5000	2026-10-02	10.9000	10.5500	11.0000	611.3950	17440.00	8720.00	7630.00	16	7	29	272	0.106617647058824	0.394715306660528	0.394715306660528	false	false	false	true
2eeb1d60-7ba8-43a3-bbee-e5e52eaf3daa	2026-09-29 11:05	2026-09-29 11:05	2026-09-29 11:05	SMH	SMH261030C00622500	call	622.5000	2026-10-30	20.8500	20.8000	21.3500	611.4500	41700.00	0.00	41700.00	20	6	32	236	0.135593220338983	0.349568904942542	0.349568904942542	true	false	false	true
d1ab3219-15eb-4927-8760-df7a305f587e	2026-09-29 10:59	2026-09-29 10:59	2026-09-29 10:59	SMH	SMH261120P00560000	put	560.0000	2026-11-20	13.6500	13.6500	13.9500	612.2200	178815.00	0.00	178815.00	131	18	262	5976	0.0438420348058902	0.393312348757635	0.393312348757635	true	false	false	true
d1cf3b6f-e4cc-4d62-b854-6a9d5cd44236	2026-09-29 10:57	2026-09-29 10:57	2026-09-29 10:57	SMH	SMH261009C00615000	call	615.0000	2026-10-09	12.8500	12.3000	12.8500	613.0000	14135.00	14135.00	0.00	11	5	245	1547	0.158371040723982	0.332632614363015	0.332632614363015	false	false	false	true
8d6eb81e-c748-4dac-8bb4-21df94f14650	2026-09-29 10:56	2026-09-29 10:56	2026-09-29 10:56	SMH	SMH261016P00580000	put	580.0000	2026-10-16	6.3000	6.2000	6.8500	612.0000	15120.00	630.00	14490.00	24	6	398	1646	0.24179829890644	0.360044952181494	0.360044952181494	false	false	false	true
b1d48b0a-183f-4429-8889-3ee3b9c00e1a	2026-09-29 10:56	2026-09-29 10:56	2026-09-29 10:56	SMH	SMH261030P00552500	put	552.5000	2026-10-30	6.3000	6.3000	6.6000	612.0000	17010.00	0.00	17010.00	27	6	27	43	0.627906976744186	0.393217493573314	0.393217493573314	false	false	false	true
147c636c-4b62-4950-b400-3c693347c005	2026-09-29 10:43	2026-09-29 10:43	2026-09-29 10:43	SMH	SMH261030P00615000	put	615.0000	2026-10-30	25.9500	25.2500	26.2500	611.6350	51900.00	46710.00	5190.00	20	10	20	3	6.66666666666667	0.356416894667532	0.356416894667532	true	false	false	true
a982cd12-f972-47cc-9289-12ea85e71bc8	2026-09-29 10:42	2026-09-29 10:42	2026-09-29 10:42	SMH	SMH261023P00605000	put	605.0000	2026-10-23	17.3900	16.6500	17.4000	611.7850	15650.00	15650.00	0.00	9	7	11	18	0.611111111111111	0.343335281351003	0.342520060762853	true	false	false	true
a8dcb163-180e-4af7-8963-f1a41294572c	2026-09-29 10:32	2026-09-29 10:32	2026-09-29 10:32	SMH	SMH261002C00615000	call	615.0000	2026-10-02	7.3500	7.3500	7.6000	611.9600	10290.00	0.00	10290.00	14	5	339	1995	0.169924812030075	0.390378422061219	0.391932503361164	true	false	false	true
d53d8017-2754-4772-9ef7-92621ab1b717	2026-09-29 10:32	2026-09-29 10:32	2026-09-29 10:32	SMH	SMH261002C00615000	call	615.0000	2026-10-02	7.5500	7.4000	7.6000	612.4500	46810.00	46055.00	755.00	62	8	208	1995	0.104260651629073	0.390786892906285	0.390786892906285	false	false	false	true
387e3512-6174-4ae5-95b9-86301629e707	2026-09-29 10:32	2026-09-29 10:32	2026-09-29 10:32	SMH	SMH261016C00625000	call	625.0000	2026-10-16	12.3000	12.2500	12.5500	612.2600	25837.00	1230.00	24607.00	21	8	250	11856	0.0210863697705803	0.328522610765358	0.328522610765358	false	false	false	true
44e94db2-6bc6-470c-a9d7-c8297b906833	2026-09-29 10:32	2026-09-29 10:31	2026-09-29 10:31	SMH	SMH261016C00625000	call	625.0000	2026-10-16	12.2500	12.2500	12.4500	612.3100	15925.00	0.00	15925.00	13	5	116	11856	0.00978407557354926	0.327150244442748	0.327150244442748	false	false	false	true
9faedfb2-8b21-481f-b5f4-a117ebd360ea	2026-09-29 10:31	2026-09-29 10:31	2026-09-29 10:31	SMH	SMH261016C00625000	call	625.0000	2026-10-16	12.2500	12.0000	12.4500	612.1400	89425.00	19600.00	69825.00	73	6	83	11856	0.00700067476383266	0.328504907807232	0.328504907807232	false	false	false	true
73ede977-a07c-4e88-883c-23b62287d55b	2026-09-29 10:31	2026-09-29 10:31	2026-09-29 10:31	SMH	SMH261120C00650000	call	650.0000	2026-11-20	19.6800	19.0000	19.7500	612.1900	23615.00	13790.00	9825.00	12	5	28	5469	0.00511976595355641	0.359319360856535	0.358746548938607	true	false	false	true
cd139f48-de7f-4a0e-8241-826553d8d6fa	2026-09-29 10:26	2026-09-29 10:26	2026-09-29 10:26	SMH	SMH261023C00617500	call	617.5000	2026-10-23	19.0500	18.5000	19.1500	611.5000	17145.00	15240.00	1905.00	9	6	23	71	0.323943661971831	0.33715419330901	0.33715419330901	true	false	false	true
925346a6-0bfd-4d68-a1bc-7090f62d7269	2026-09-29 10:26	2026-09-29 10:25	2026-09-29 10:25	SMH	SMH261016C00615000	call	615.0000	2026-10-16	16.4500	15.9000	16.4500	611.2900	32900.00	32900.00	0.00	20	10	250	13857	0.0180414231074547	0.335636173547259	0.335636173547259	false	false	false	true
6850f502-9a4e-4a0c-88d8-b72a7fc18f1b	2026-09-29 10:19	2026-09-29 10:19	2026-09-29 10:19	SMH	SMH260930C00630000	call	630.0000	2026-09-30	0.5800	0.4800	0.5800	610.7629	38048.00	38048.00	0.00	656	47	698	164	4.25609756097561	0.436360251815424	0.43717760812652	false	false	false	true
b91ab44f-7e52-47be-8f27-7fac48759c90	2026-09-29 10:19	2026-09-29 10:19	2026-09-29 10:19	SMH	SMH270617P00400000	put	400.0000	2027-06-17	9.9500	9.9500	11.3000	610.7800	70645.00	0.00	70645.00	71	8	74	1364	0.0542521994134897	0.445712058575768	0.445712058575768	false	false	false	true
7e5a7ac2-93a6-4b0a-8556-a00ae79ff5db	2026-09-29 10:16	2026-09-29 10:16	2026-09-29 10:16	SMH	SMH261016C00612500	call	612.5000	2026-10-16	16.5000	15.6000	16.5000	608.8025	250800.00	250800.00	0.00	152	9	190	229	0.829694323144105	0.337890535822647	0.337890535822647	false	false	false	true
0d41dcb5-7411-4a56-bc37-4ba721118c52	2026-09-29 10:16	2026-09-29 10:16	2026-09-29 10:16	SMH	SMH260929C00607500	call	607.5000	2026-09-29	3.4000	2.7800	3.4000	608.8025	40800.00	40800.00	0.00	120	18	221	266	0.830827067669173	0.433773655097509	0.433773655097509	true	false	false	true
bf953547-47f1-45da-9c1a-add8d2e91119	2026-09-29 10:14	2026-09-29 10:14	2026-09-29 10:14	SMH	SMH261016P00577500	put	577.5000	2026-10-16	6.3500	6.3500	6.5500	608.9100	51435.00	0.00	51435.00	81	5	85	190	0.447368421052632	0.35600698394594	0.35600698394594	true	false	false	true
bcb25e8d-be0c-437c-a9b9-c211e51dbbf6	2026-09-29 10:14	2026-09-29 10:14	2026-09-29 10:14	SMH	SMH261030P00577500	put	577.5000	2026-10-30	11.9000	11.8500	12.4000	608.9600	80930.00	2380.00	74965.00	68	24	68	63	1.07936507936508	0.365903906319481	0.365300404245036	true	false	false	true
9ff3a306-af1b-4eb9-a3af-63d17f2cc013	2026-09-29 10:14	2026-09-29 10:14	2026-09-29 10:14	SMH	SMH261002P00595000	put	595.0000	2026-10-02	3.4500	3.4500	3.7000	608.8400	13110.00	0.00	13110.00	38	11	52	451	0.11529933481153	0.40120881411224	0.40120881411224	true	false	false	true
bb97e5e2-2c0a-484e-a753-4a687775d2e7	2026-09-29 10:14	2026-09-29 10:14	2026-09-29 10:14	SMH	SMH261030P00595000	put	595.0000	2026-10-30	17.7500	17.6500	18.4500	608.7500	14200.00	1775.00	12425.00	8	8	17	51	0.333333333333333	0.356404613909581	0.356404613909581	true	false	false	true
60bbc9d6-e683-41de-9a2b-0127531f2354	2026-09-29 10:13	2026-09-29 10:13	2026-09-29 10:13	SMH	SMH270617C00720000	call	720.0000	2027-06-17	42.4000	42.4000	43.3000	608.5600	21200.00	0.00	4240.00	5	5	5	113	0.0442477876106195	0.359670360626382	0.359670360626382	false	false	false	true
6ee12925-ba79-4baf-b051-995dad30ec5d	2026-09-29 10:13	2026-09-29 10:13	2026-09-29 10:13	SMH	SMH260930P00597500	put	597.5000	2026-09-30	1.5700	1.5300	1.7700	608.0000	17111.00	154.00	16957.00	109	21	146	160	0.9125	0.430562217415271	0.430562217415271	true	false	false	true
15327b04-c7b2-45ff-b8e9-b54dd515c203	2026-09-29 10:13	2026-09-29 10:13	2026-09-29 10:13	SMH	SMH261001P00597500	put	597.5000	2026-10-01	3.1000	3.1000	3.4000	608.0000	16430.00	0.00	16430.00	53	7	144	14	10.2857142857143	0.415740401421327	0.415740401421327	false	false	false	true
f3ca2639-8cee-4701-abbe-63105fed2879	2026-09-29 10:11	2026-09-29 10:11	2026-09-29 10:11	SMH	SMH261016C00617500	call	617.5000	2026-10-16	13.9300	13.8500	14.4000	608.0000	23680.00	8390.00	15290.00	17	8	21	230	0.091304347826087	0.329657630719046	0.329657630719046	true	false	false	true
b9434a4e-82c9-4fbd-9aca-ec8ce4ced361	2026-09-29 10:11	2026-09-29 10:11	2026-09-29 10:11	SMH	SMH261106C00625000	call	625.0000	2026-11-06	21.9000	21.1000	22.5500	608.0000	24090.00	4380.00	19710.00	11	5	16	15	1.06666666666667	0.354071384535749	0.354071384535749	true	false	false	true
0cc0ec9c-4a88-4e19-9cd3-56f45b941b4f	2026-09-29 10:10	2026-09-29 10:10	2026-09-29 10:10	SMH	SMH261009C00615000	call	615.0000	2026-10-09	10.7000	10.7000	11.2000	608.0000	135890.00	0.00	135890.00	127	19	187	1547	0.120879120879121	0.325248200781039	0.326818804056186	true	false	false	true