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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 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

8d1e6890-6370-45fc-a2a3-587cb412e1c6	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00640000	call	640.0000	2026-11-20	21.4500	21.4500	22.0500	606.0000	358215.00	0.00	358215.00	167	20	224	877	0.255416191562144	0.352670407890783	0.352712906230274	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	74129314174.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:03:13.684497Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
16dbb86b-65b5-4c65-a2b3-fdec1d1e19a9	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00630000	call	630.0000	2026-11-20	25.2000	25.2000	25.9000	606.0000	123480.00	0.00	123480.00	49	13	58	578	0.100346020761246	0.354421709293595	0.354235005464215	false	false	false	true
13c401c1-833a-4696-9ab5-19cc61bc2cf6	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261218P00585000	put	585.0000	2026-12-18	30.1000	30.1000	30.1500	606.0000	192642.00	0.00	189632.00	64	19	65	2063	0.0315075133301018	0.37307951467584	0.373213053169386	false	false	false	true
1855ff86-04b5-4e7e-a14c-6890c88e8f58	2026-09-25 14:55	2026-09-25 14:55	2026-09-25 14:55	SMH	SMH260925C00597500	call	597.5000	2026-09-25	8.9000	7.6000	10.2000	606.0000	97912.00	21360.00	73882.00	110	14	171	1983	0.086232980332829	1.06763748859816	1.61510933054682	false	false	false	true
bfdaa997-ac50-437f-9035-d9cd490fa640	2026-09-25 14:42	2026-09-25 14:42	2026-09-25 14:42	SMH	SMH260928P00590000	put	590.0000	2026-09-28	0.5300	0.5300	0.5800	606.7200	11077.00	0.00	11077.00	209	21	862	65	13.2615384615385	0.233028542239492	0.233028542239492	false	false	false	true
04ab3950-d8c5-449b-a830-1a7f13435ac7	2026-09-25 14:42	2026-09-25 14:42	2026-09-25 14:42	SMH	SMH260928P00587500	put	587.5000	2026-09-28	0.4000	0.4000	0.4700	606.7200	18360.00	0.00	18360.00	459	54	731	196	3.72959183673469	0.242059666236785	0.242059666236785	false	false	false	true
6fd39a17-d8f9-403b-846a-252260544a9b	2026-09-25 14:42	2026-09-25 14:42	2026-09-25 14:42	SMH	SMH261002P00597500	put	597.5000	2026-10-02	6.2500	6.2500	6.3500	606.6700	13750.00	0.00	13750.00	22	14	384	75	5.12	0.311615811019884	0.311615811019884	true	false	false	true
3fcc6966-4cbd-4029-94bf-5d4c55eb0518	2026-09-25 14:42	2026-09-25 14:42	2026-09-25 14:42	SMH	SMH261002P00597500	put	597.5000	2026-10-02	6.2500	6.2500	6.3500	606.6700	13750.00	0.00	13750.00	22	8	347	75	4.62666666666667	0.311615811019884	0.311615811019884	true	false	false	true
a8cb25c7-7e96-4dab-9f5a-035f0e6de334	2026-09-25 14:40	2026-09-25 14:39	2026-09-25 14:39	SMH	SMH261120C00650000	call	650.0000	2026-11-20	18.4900	18.2500	19.0500	606.4800	12940.00	1840.00	11100.00	7	5	1418	5823	0.243517087411987	0.354906039956438	0.353770252543927	false	false	false	true
195cfff3-7a30-4fb8-a50d-f8e77b00e9f8	2026-09-25 14:37	2026-09-25 14:37	2026-09-25 14:37	SMH	SMH261009C00610000	call	610.0000	2026-10-09	13.5500	13.5500	13.9500	607.1350	73170.00	0.00	73170.00	54	21	205	477	0.429769392033543	0.305092849958462	0.305092849958462	true	false	false	true
977417c4-96fe-45dc-ae7e-0f08d755c3ec	2026-09-25 14:31	2026-09-25 14:31	2026-09-25 14:31	SMH	SMH260928P00590000	put	590.0000	2026-09-28	0.5200	0.5200	0.5900	607.4258	16900.00	0.00	16900.00	325	29	631	65	9.70769230769231	0.238927496719351	0.238927496719351	false	false	false	true
6d2e161a-e3da-4c0a-8cee-11a035c7f8ba	2026-09-25 14:31	2026-09-25 14:31	2026-09-25 14:31	SMH	SMH261030P00567500	put	567.5000	2026-10-30	10.5500	10.5500	10.7000	607.3250	34825.00	0.00	34825.00	33	12	35	67	0.522388059701492	0.365351526839203	0.365351526839203	true	false	false	true
500f6974-affe-4014-8d26-5cb8209e6cae	2026-09-25 14:31	2026-09-25 14:31	2026-09-25 14:31	SMH	SMH261016P00600000	put	600.0000	2026-10-16	14.7000	14.2000	15.1500	607.3900	51445.00	1465.00	49980.00	35	8	913	6175	0.147854251012146	0.325074721177681	0.324337285694075	true	false	false	true
e0796802-254b-4e08-8ac8-b35cb966cdfb	2026-09-25 14:16	2026-09-25 14:16	2026-09-25 14:16	SMH	SMH260928P00600000	put	600.0000	2026-09-28	1.6900	1.6900	1.7700	608.0100	62530.00	0.00	62530.00	370	51	823	49	16.7959183673469	0.216145560367603	0.2150266444783	false	false	false	true
fce79fcf-cf7e-4da7-a1d7-462cbf10f3be	2026-09-25 14:13	2026-09-25 14:13	2026-09-25 14:13	SMH	SMH261030C00655000	call	655.0000	2026-10-30	9.5500	9.3500	9.6000	607.9200	21965.00	21965.00	0.00	23	5	87	311	0.279742765273312	0.333530977242362	0.333530977242362	true	false	false	true
79ec8fa9-5e44-40aa-aae0-bc29b829c911	2026-09-25 14:11	2026-09-25 14:11	2026-09-25 14:11	SMH	SMH261218P00550000	put	550.0000	2026-12-18	18.6000	18.6000	19.0000	607.4649	50220.00	0.00	50220.00	27	9	118	2531	0.0466218885815883	0.389934543747717	0.389934543747717	true	false	false	true
9a1d995e-4fdd-4393-a09d-521106fc9341	2026-09-25 14:03	2026-09-25 14:03	2026-09-25 14:03	SMH	SMH261120C00650000	call	650.0000	2026-11-20	19.0500	18.7500	19.0500	607.0000	34290.00	34290.00	0.00	18	5	1411	5823	0.242314957925468	0.357448095927338	0.357448095927338	false	false	false	true
a78fd9b7-0738-48e9-ab10-b748c8d3e5b0	2026-09-25 13:58	2026-09-25 13:58	2026-09-25 13:58	SMH	SMH261016P00590000	put	590.0000	2026-10-16	11.1000	10.8500	11.5000	607.6000	35520.00	0.00	34410.00	32	19	368	4776	0.0770519262981574	0.333855721108555	0.333855721108555	true	false	false	true
d52e3e91-9cbb-4d0c-8e56-ec1de706290e	2026-09-25 13:58	2026-09-25 13:58	2026-09-25 13:58	SMH	SMH261120C00720000	call	720.0000	2026-11-20	5.4500	5.4500	5.6500	607.5600	24525.00	0.00	24525.00	45	10	47	705	0.0666666666666667	0.35589911992479	0.35589911992479	false	false	false	true
809fe4cd-406a-4356-ad85-de91f6ff2ac2	2026-09-25 13:56	2026-09-25 13:56	2026-09-25 13:56	SMH	SMH260928C00625000	call	625.0000	2026-09-28	0.4000	0.4000	0.4500	607.4450	22440.00	0.00	22440.00	561	54	819	20	40.95	0.215167187598816	0.215167187598816	false	false	false	true
055fbc0d-079e-4f76-baa1-e2b580af3ac2	2026-09-25 13:51	2026-09-25 13:51	2026-09-25 13:51	SMH	SMH261023C00622500	call	622.5000	2026-10-23	16.2500	16.2500	16.7000	607.7400	19500.00	0.00	19500.00	12	9	36	22	1.63636363636364	0.325514404421843	0.325514404421843	false	false	false	true
ed477197-86cb-4aa2-b687-5b8efd83be8e	2026-09-25 13:39	2026-09-25 13:38	2026-09-25 13:38	SMH	SMH261002C00600000	call	600.0000	2026-10-02	15.0000	14.4000	15.3000	607.0000	15000.00	9000.00	6000.00	10	5	367	2608	0.140720858895706	0.320903695106564	0.320903695106564	false	false	false	true
275bac22-c59e-46c2-af70-af6d75660d15	2026-09-25 13:34	2026-09-25 13:34	2026-09-25 13:34	SMH	SMH261002P00602500	put	602.5000	2026-10-02	8.1000	7.7000	8.1000	607.0000	28350.00	28350.00	0.00	35	8	939	105	8.94285714285714	0.319285823971294	0.319285823971294	false	false	false	true
0dfc700f-4dde-43af-8148-dccd6d045e69	2026-09-25 13:34	2026-09-25 13:34	2026-09-25 13:34	SMH	SMH261002P00610000	put	610.0000	2026-10-02	11.6000	11.4500	11.6000	607.0000	37120.00	37120.00	0.00	32	16	54	22	2.45454545454545	0.316111355003044	0.316111355003044	true	false	false	true
0826f863-eb52-4ab3-802e-a827c946dfb5	2026-09-25 13:34	2026-09-25 13:34	2026-09-25 13:34	SMH	SMH261002P00607500	put	607.5000	2026-10-02	10.3000	9.9500	10.3500	607.0000	62830.00	61800.00	0.00	61	11	171	37	4.62162162162162	0.31595763510223	0.31595763510223	false	false	false	true
010956f6-9ae2-480c-aacb-f65f7bdd0cda	2026-09-25 13:34	2026-09-25 13:34	2026-09-25 13:34	SMH	SMH261002P00605000	put	605.0000	2026-10-02	9.1500	8.8000	9.2000	607.0000	29280.00	28365.00	915.00	32	8	304	127	2.39370078740157	0.317497065150015	0.317497065150015	false	false	false	true
47d0f385-71c9-4bd8-b3af-506887127e2f	2026-09-25 13:33	2026-09-25 13:33	2026-09-25 13:33	SMH	SMH260928P00512500	put	512.5000	2026-09-28	0.0500	0.0100	0.2400	607.0000	55494.00	0.00	55494.00	12332	2	15037	22	683.5	0.702060908281748	0.702060908281748	false	true	false	true
dea489c6-f79b-48b3-ab68-5b5a06de1d00	2026-09-25 13:26	2026-09-25 13:26	2026-09-25 13:26	SMH	SMH261002P00415000	put	415.0000	2026-10-02	0.0600	0.0200	0.0600	608.0000	82500.00	82500.00	0.00	15000	2	15181	132	115.007575757576	0.982937808024101	0.982937808024101	false	true	false	true
2593aea9-e5c5-4f84-aba5-02ccb5e20985	2026-09-25 13:26	2026-09-25 13:26	2026-09-25 13:26	SMH	SMH261030C00640000	call	640.0000	2026-10-30	14.0500	14.0000	14.2500	608.0000	30910.00	0.00	30910.00	22	6	108	84	1.28571428571429	0.340517118435233	0.340517118435233	false	false	false	true
3e7ae415-2aa8-43a9-914d-3c5680b392a2	2026-09-25 13:20	2026-09-25 13:20	2026-09-25 13:20	SMH	SMH261023C00635000	call	635.0000	2026-10-23	12.0500	12.0500	12.2500	608.0000	14460.00	0.00	14460.00	12	6	81	154	0.525974025974026	0.326046831792959	0.326046831792959	false	false	false	true
833eb2ee-874d-42e0-bb07-3a0d87d5910e	2026-09-25 13:18	2026-09-25 13:18	2026-09-25 13:18	SMH	SMH261030C00635000	call	635.0000	2026-10-30	15.8000	15.8000	16.2500	608.0000	48980.00	0.00	48980.00	31	9	42	232	0.181034482758621	0.34009013492454	0.34009013492454	false	false	false	true
46977138-7afb-45d6-a624-20906ce994bb	2026-09-25 13:17	2026-09-25 13:17	2026-09-25 13:17	SMH	SMH261030P00565000	put	565.0000	2026-10-30	10.1500	10.1500	10.6000	608.0000	20300.00	0.00	20300.00	20	6	34	87	0.390804597701149	0.374831032968808	0.374831032968808	false	false	false	true
c6c9c88f-9e9a-465b-ab7b-9d7e40073ff3	2026-09-25 13:13	2026-09-25 13:13	2026-09-25 13:13	SMH	SMH261009C00612500	call	612.5000	2026-10-09	13.5500	13.1500	13.5500	608.0000	16260.00	16260.00	0.00	12	7	167	21	7.95238095238095	0.316297138807072	0.316297138807072	true	false	false	true
62965302-75cf-40f8-80e9-f172f74a8e75	2026-09-25 13:13	2026-09-25 13:13	2026-09-25 13:13	SMH	SMH261218C00670000	call	670.0000	2026-12-18	21.4500	21.2500	21.4500	608.2950	17160.00	17160.00	0.00	8	8	140	571	0.245183887915937	0.358961898963076	0.358961898963076	false	false	false	true
4543a765-7ba0-4964-ba46-0d4b080b4722	2026-09-25 13:13	2026-09-25 13:13	2026-09-25 13:13	SMH	SMH261218C00670000	call	670.0000	2026-12-18	21.4500	21.2500	21.9000	608.2950	19305.00	12870.00	6435.00	9	9	132	571	0.231173380035026	0.358961898963076	0.358961898963076	false	false	false	true
ccb32f88-b740-4965-83cc-292ad1ab65eb	2026-09-25 13:09	2026-09-25 13:09	2026-09-25 13:09	SMH	SMH261016C00622500	call	622.5000	2026-10-16	13.5000	13.1500	14.0000	608.3800	35110.00	33750.00	1360.00	26	5	108	81	1.33333333333333	0.326134648071007	0.327895956075875	true	false	false	true
5cb90a2f-5b96-4bbd-8711-ed59558fac8a	2026-09-25 13:09	2026-09-25 13:09	2026-09-25 13:09	SMH	SMH261030C00655000	call	655.0000	2026-10-30	9.9000	9.5500	10.0500	608.1325	24750.00	23765.00	985.00	25	9	34	311	0.109324758842444	0.338280439198182	0.339085640945249	true	false	false	true
388ec09f-7911-4036-9a3c-b17790b8ba69	2026-09-25 12:58	2026-09-25 12:58	2026-09-25 12:58	SMH	SMH261023C00622500	call	622.5000	2026-10-23	16.2500	16.2500	16.7000	607.2100	17875.00	0.00	17875.00	11	5	24	22	1.09090909090909	0.328927732200493	0.328927732200493	false	false	false	true
36da36b0-24ce-4afb-99d1-3e2db629d3c2	2026-09-25 12:49	2026-09-25 12:49	2026-09-25 12:49	SMH	SMH261001P00600000	put	600.0000	2026-10-01	6.1500	4.8500	6.5000	607.5800	92250.00	12915.00	79335.00	150	14	151	20	7.55	0.311493897957525	0.311493897957525	false	false	false	true
08c2febd-0454-4c47-8a04-8e777f9b8e19	2026-09-25 12:48	2026-09-25 12:48	2026-09-25 12:48	SMH	SMH260928C00610000	call	610.0000	2026-09-28	3.7000	3.7000	4.0000	607.9700	23680.00	0.00	23680.00	64	21	525	235	2.23404255319149	0.206894700021998	0.206894700021998	true	false	false	true
e3e4cd94-ef2f-410a-946d-6da3976e862b	2026-09-25 12:38	2026-09-25 12:38	2026-09-25 12:38	SMH	SMH261030P00605000	put	605.0000	2026-10-30	23.7500	23.1500	24.5500	608.0700	40375.00	35625.00	2375.00	17	5	29	13	2.23076923076923	0.353270559686925	0.353270559686925	false	false	false	true
16fa5d08-1364-4523-ae8e-dc5c8e7f5483	2026-09-25 12:37	2026-09-25 12:37	2026-09-25 12:37	SMH	SMH261030P00562500	put	562.5000	2026-10-30	9.7000	9.6500	10.3500	608.1800	45590.00	0.00	45590.00	47	13	47	32	1.46875	0.377438820474364	0.376549472104836	true	false	false	true
af897533-c8bf-4236-a0a8-18aa6b5c7991	2026-09-25 12:29	2026-09-25 12:29	2026-09-25 12:29	SMH	SMH260928P00592500	put	592.5000	2026-09-28	0.7800	0.7800	0.8800	608.0000	12714.00	0.00	12714.00	163	24	293	105	2.79047619047619	0.249465343752202	0.249465343752202	false	false	false	true
042b042f-9d7f-45d1-b530-d6f3472f0d08	2026-09-25 12:29	2026-09-25 12:29	2026-09-25 12:29	SMH	SMH260928P00595000	put	595.0000	2026-09-28	1.0400	1.0400	1.1500	608.0000	33280.00	0.00	33280.00	320	28	452	29	15.5862068965517	0.242629157659218	0.242629157659218	false	false	false	true
cb159327-63c5-44d8-a4b6-14291ed30aa5	2026-09-25 12:24	2026-09-25 12:24	2026-09-25 12:24	SMH	SMH260929P00592500	put	592.5000	2026-09-29	1.9700	1.9700	2.1200	607.0800	10047.00	0.00	10047.00	51	12	127	21	6.04761904761905	0.281000440313955	0.281000440313955	true	false	false	true
207e3f3b-1685-4ea6-bc87-0c51d9bff413	2026-09-25 12:24	2026-09-25 12:24	2026-09-25 12:24	SMH	SMH261002P00602500	put	602.5000	2026-10-02	8.5000	8.4500	9.1500	607.0800	18700.00	850.00	17000.00	22	7	899	105	8.56190476190476	0.324436879076174	0.324436879076174	true	false	false	true
a1a390e3-bba3-4abd-a418-295d4b338454	2026-09-25 12:21	2026-09-25 12:21	2026-09-25 12:21	SMH	SMH261002P00600000	put	600.0000	2026-10-02	7.4500	6.9500	7.4500	607.1900	76717.00	76717.00	0.00	103	16	301	264	1.14015151515152	0.325492716037395	0.324868297383067	false	false	false	true
881360c7-51ec-47d3-9c14-e688161f5482	2026-09-25 12:21	2026-09-25 12:21	2026-09-25 12:21	SMH	SMH261002P00602500	put	602.5000	2026-10-02	8.4500	8.0000	8.5000	607.1900	84495.00	73515.00	10980.00	100	15	877	105	8.35238095238095	0.324310209233031	0.324310209233031	false	false	false	true
2020bd91-770c-4fdb-bd63-6c7cbe880a5d	2026-09-25 12:21	2026-09-25 12:21	2026-09-25 12:21	SMH	SMH261002P00597500	put	597.5000	2026-10-02	6.6000	6.2000	6.6000	607.1900	120780.00	120780.00	0.00	183	25	309	75	4.12	0.328707584480082	0.328707584480082	false	false	false	true
e4967f46-2115-4de7-9d12-075d24ef81c1	2026-09-25 12:20	2026-09-25 12:20	2026-09-25 12:20	SMH	SMH261002C00617500	call	617.5000	2026-10-02	6.6500	6.6500	7.0000	607.0000	15960.00	0.00	15960.00	24	8	115	336	0.342261904761905	0.313212520051	0.313212520051	false	false	false	true