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.

566,287 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts566,287 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

9a8ed6e6-bafb-4d13-a711-ed5be213c515	2026-09-28 15:06	2026-09-28 15:06	2026-09-28 15:06	SMH	SMH261009P00585000	put	585.0000	2026-10-09	6.9500	6.6500	6.9500	600.7425	11120.00	11120.00	0.00	16	7	132	361	0.365650969529086	0.332117722939676	0.332117722939676	false	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-28T19:11:33.715590Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
6087c006-d1c5-4f16-9c97-625dc271076b	2026-09-28 15:06	2026-09-28 15:06	2026-09-28 15:06	SMH	SMH260930P00597500	put	597.5000	2026-09-30	4.6000	4.2500	4.6000	600.7050	36800.00	36800.00	0.00	80	7	281	107	2.62616822429907	0.346218828737115	0.346218828737115	true	false	false	true
5ad9400f-f435-4935-85e2-dde555a8c5a4	2026-09-28 15:06	2026-09-28 15:06	2026-09-28 15:06	SMH	SMH260929P00597500	put	597.5000	2026-09-29	2.7000	2.4500	2.8700	600.5625	10529.00	9990.00	539.00	39	9	364	182	2	0.325765668341242	0.325765668341242	false	false	false	true
79d6c0c5-2df7-4795-b0f9-fbd7c98a5ee1	2026-09-28 15:02	2026-09-28 15:02	2026-09-28 15:02	SMH	SMH261016P00590000	put	590.0000	2026-10-16	12.0000	11.3000	12.2500	601.0600	25195.00	25195.00	0.00	21	13	586	4913	0.119275391817627	0.330939208418463	0.330939208418463	true	false	false	true
4d8fc0b7-8ed8-4e91-a2a3-4da4f763dae8	2026-09-28 15:00	2026-09-28 15:00	2026-09-28 15:00	SMH	SMH261002P00592500	put	592.5000	2026-10-02	5.2500	5.0000	5.2500	601.4300	13125.00	13125.00	0.00	25	8	353	770	0.458441558441558	0.365856998001455	0.365856998001455	false	false	false	true
032841e3-6f86-4fe9-a6ff-8a0b93d501e5	2026-09-28 14:58	2026-09-28 14:58	2026-09-28 14:58	SMH	SMH270115C00600000	call	600.0000	2027-01-15	52.2000	51.9500	52.6000	602.2200	26100.00	0.00	26100.00	5	5	82	4135	0.0198307134220073	0.361981282807706	0.362158670936371	false	false	false	true
feaffe82-1321-4a11-a0d9-72d3e597560a	2026-09-28 14:56	2026-09-28 14:56	2026-09-28 14:56	SMH	SMH261009P00597500	put	597.5000	2026-10-09	10.9000	10.7500	11.3000	601.8800	11990.00	1090.00	10900.00	11	5	137	222	0.617117117117117	0.320415140559679	0.320415140559679	true	false	false	true
b0bdca2b-0dcd-4390-beaf-98b8d254bb12	2026-09-28 14:52	2026-09-28 14:52	2026-09-28 14:52	SMH	SMH261016C00580000	call	580.0000	2026-10-16	31.3500	29.8000	31.3500	601.4450	18810.00	18810.00	0.00	6	5	223	3500	0.0637142857142857	0.340896295189117	0.340896295189117	false	false	false	true
f4504aba-337a-41d9-ac50-31281646f5b2	2026-09-28 14:44	2026-09-28 14:44	2026-09-28 14:44	SMH	SMH261002P00587500	put	587.5000	2026-10-02	4.1500	4.1500	4.3500	600.0000	14525.00	0.00	14525.00	35	7	155	1045	0.148325358851675	0.374523870680497	0.374523870680497	false	false	false	true
72203aa1-af11-4b02-87e3-e1335d81d2b2	2026-09-28 14:44	2026-09-28 14:44	2026-09-28 14:44	SMH	SMH261023C00635000	call	635.0000	2026-10-23	8.2000	7.9500	8.3000	600.0000	23790.00	23790.00	0.00	29	12	224	226	0.991150442477876	0.320299862844372	0.322202191255262	true	false	false	true
c4a1d6c8-b49e-4232-a4d2-870a73ca794e	2026-09-28 14:41	2026-09-28 14:41	2026-09-28 14:41	SMH	SMH260930C00605000	call	605.0000	2026-09-30	3.9500	3.8500	4.0000	600.0000	12640.00	7110.00	4740.00	32	11	472	1114	0.423698384201077	0.337914251439342	0.337914251439342	true	false	false	true
e2dd053d-16cd-4f2a-b205-29c041952a6f	2026-09-28 14:41	2026-09-28 14:41	2026-09-28 14:41	SMH	SMH260930C00605000	call	605.0000	2026-09-30	3.9500	3.9000	4.0500	600.0000	10665.00	0.00	10665.00	27	7	422	1114	0.378815080789946	0.3350896499037	0.3350896499037	false	false	false	true
e113a2e4-630d-4d2c-8154-0bfd949f410c	2026-09-28 14:40	2026-09-28 14:40	2026-09-28 14:40	SMH	SMH261016P00575000	put	575.0000	2026-10-16	7.8000	7.5000	7.8000	599.0000	49920.00	49920.00	0.00	64	9	307	987	0.311043566362715	0.344338153445191	0.344338153445191	false	false	false	true
eb9f7566-da35-4736-8936-f7181490f848	2026-09-28 14:39	2026-09-28 14:39	2026-09-28 14:39	SMH	SMH261002P00597500	put	597.5000	2026-10-02	7.6500	7.3000	7.7000	600.0000	20655.00	19890.00	0.00	27	11	618	380	1.62631578947368	0.360562155337259	0.360562155337259	false	false	false	true
a4cbc16e-9970-427a-bed9-cdc5ba2c7948	2026-09-28 14:32	2026-09-28 14:32	2026-09-28 14:32	SMH	SMH261002P00600000	put	600.0000	2026-10-02	8.5500	8.2000	8.5500	600.5300	21375.00	21375.00	0.00	25	8	313	518	0.604247104247104	0.35680193309881	0.35680193309881	false	false	false	true
54ac51e6-f32b-4e3d-b702-283c68592202	2026-09-28 14:31	2026-09-28 14:31	2026-09-28 14:31	SMH	SMH261023C00605000	call	605.0000	2026-10-23	19.2500	19.2500	19.7500	600.8300	63525.00	0.00	63525.00	33	10	42	122	0.344262295081967	0.325810988718483	0.325810988718483	false	false	false	true
79a32c73-a60f-4078-99b9-d650f47a2924	2026-09-28 14:31	2026-09-28 14:31	2026-09-28 14:31	SMH	SMH261002C00590000	call	590.0000	2026-10-02	15.9000	15.9000	16.8000	601.1400	23850.00	0.00	23850.00	15	9	34	870	0.0390804597701149	0.365326749009146	0.365326749009146	false	false	false	true
3a68b082-9a7b-4523-b95f-99191b6ecd1d	2026-09-28 14:31	2026-09-28 14:31	2026-09-28 14:31	SMH	SMH260930P00572500	put	572.5000	2026-09-30	0.4200	0.4200	0.5300	601.1400	19446.00	0.00	19446.00	463	45	527	32	16.46875	0.414486486699019	0.414486486699019	false	false	false	true
bfbbdd9b-64b1-40c2-8a6d-a68fdfc2afee	2026-09-28 14:29	2026-09-28 14:28	2026-09-28 14:28	SMH	SMH261002P00597500	put	597.5000	2026-10-02	7.1000	7.0500	7.3500	601.0500	15620.00	2840.00	10650.00	22	9	568	380	1.49473684210526	0.354792796761132	0.354792796761132	true	false	false	true
948d17b8-9cf8-45cb-aa84-c01c256f7289	2026-09-28 14:28	2026-09-28 14:28	2026-09-28 14:28	SMH	SMH261002P00597500	put	597.5000	2026-10-02	7.1000	7.1000	7.3500	601.1000	15620.00	0.00	15620.00	22	8	546	380	1.43684210526316	0.355653454442838	0.355653454442838	false	false	false	true
ff9adf58-0c70-420b-9b64-d5db75b9165d	2026-09-28 14:28	2026-09-28 14:27	2026-09-28 14:27	SMH	SMH260930C00605000	call	605.0000	2026-09-30	4.2000	4.2000	4.2500	601.0350	13020.00	0.00	2520.00	31	18	223	1114	0.200179533213645	0.33244791848742	0.33244791848742	true	false	false	true
d449d4fd-f60a-4eed-86cd-3b4872753589	2026-09-28 14:24	2026-09-28 14:24	2026-09-28 14:24	SMH	SMH261009C00605000	call	605.0000	2026-10-09	11.7000	11.6000	12.0500	600.8234	37440.00	1170.00	36270.00	32	11	128	269	0.475836431226766	0.319949051309446	0.319949051309446	false	false	false	true
ca7c54d0-7409-4be5-aae2-2b4729dad4ec	2026-09-28 14:24	2026-09-28 14:24	2026-09-28 14:24	SMH	SMH261016C00617500	call	617.5000	2026-10-16	10.4700	10.4500	10.6500	600.8234	13605.00	4200.00	9405.00	13	5	120	148	0.810810810810811	0.316767763386476	0.316767763386476	false	false	false	true
886c432d-7b61-4c16-8037-0190f9c5ee01	2026-09-28 14:23	2026-09-28 14:23	2026-09-28 14:23	SMH	SMH260930C00600000	call	600.0000	2026-09-30	6.6500	6.6500	7.1500	601.1100	17955.00	0.00	17955.00	27	5	245	449	0.5456570155902	0.337143146924722	0.338819915349938	false	false	false	true
85cd962c-a056-47c6-8aa6-2160f220f5ba	2026-09-28 14:11	2026-09-28 14:11	2026-09-28 14:11	SMH	SMH261023C00602500	call	602.5000	2026-10-23	21.0000	20.2500	21.6000	601.5200	42000.00	42000.00	0.00	20	6	26	5	5.2	0.329184133256564	0.329184133256564	false	false	false	true
af864e0e-5dd9-4a4b-8a82-4534f1ea64dd	2026-09-28 14:09	2026-09-28 14:09	2026-09-28 14:09	SMH	SMH261002P00572500	put	572.5000	2026-10-02	1.5500	1.5100	1.5500	601.0000	13795.00	13795.00	0.00	89	16	469	348	1.34770114942529	0.412753844563544	0.412753844563544	false	false	false	true
d23ca319-a41b-4da3-9f56-b1c41470e167	2026-09-28 14:04	2026-09-28 14:04	2026-09-28 14:04	SMH	SMH261106P00587500	put	587.5000	2026-11-06	20.4000	20.2000	21.0000	601.0000	36715.00	2030.00	34685.00	18	7	29	0	0	0.36182169151386	0.360489178025557	true	false	false	true
5632143e-0221-4d80-8320-ce210b7e9c64	2026-09-28 14:04	2026-09-28 14:04	2026-09-28 14:04	SMH	SMH260930C00612500	call	612.5000	2026-09-30	2.0900	1.9100	2.1400	601.0000	17367.00	16095.00	1272.00	83	8	130	124	1.04838709677419	0.339613839892111	0.338662844937004	true	false	false	true
f408d546-3e06-44f7-af7c-8946e92a432f	2026-09-28 13:57	2026-09-28 13:57	2026-09-28 13:57	SMH	SMH261009C00622500	call	622.5000	2026-10-09	5.6000	5.3000	5.6000	601.4600	11200.00	11200.00	0.00	20	8	65	135	0.481481481481481	0.315570003850784	0.315570003850784	true	false	false	true
58eafe88-9a13-43c6-9dbb-401bfc734174	2026-09-28 13:57	2026-09-28 13:57	2026-09-28 13:57	SMH	SMH261009C00612500	call	612.5000	2026-10-09	8.8000	8.4500	8.9000	601.4800	12325.00	11440.00	885.00	14	5	47	110	0.427272727272727	0.31708321751111	0.318136884324228	true	false	false	true
73d256b6-3467-445f-89e9-7e18fd062ce2	2026-09-28 13:56	2026-09-28 13:56	2026-09-28 13:56	SMH	SMH260929P00585000	put	585.0000	2026-09-29	0.4400	0.4300	0.5100	601.2000	25212.00	44.00	25168.00	573	52	1070	889	1.20359955005624	0.37726856649716	0.37726856649716	false	false	false	true
f20c3f6e-cf00-489c-8101-6f4f73584f22	2026-09-28 13:32	2026-09-28 13:32	2026-09-28 13:32	SMH	SMH261120P00565000	put	565.0000	2026-11-20	17.0500	16.8000	17.6500	601.8650	47740.00	1705.00	46035.00	28	6	87	206	0.422330097087379	0.378213353683757	0.378213353683757	true	false	false	true
0dbcc479-9161-4821-8b7d-45cd7f54dea7	2026-09-28 13:32	2026-09-28 13:32	2026-09-28 13:32	SMH	SMH261002C00612500	call	612.5000	2026-10-02	4.7000	4.4000	4.7000	601.8650	12215.00	12215.00	0.00	26	7	41	969	0.0423116615067079	0.35277191133394	0.35277191133394	false	false	false	true
4a485617-7179-4851-881d-554e45962f88	2026-09-28 13:25	2026-09-28 13:25	2026-09-28 13:25	SMH	SMH260929P00597500	put	597.5000	2026-09-29	2.4500	2.4200	2.7100	601.5600	22784.00	0.00	22784.00	93	18	279	182	1.53296703296703	0.335041055048965	0.333314742127757	true	false	false	true
e95896c9-d086-4196-bedf-d7c82b30d28a	2026-09-28 13:23	2026-09-28 13:23	2026-09-28 13:23	SMH	SMH261016P00590000	put	590.0000	2026-10-16	11.8500	11.4000	11.8500	601.3100	26070.00	26070.00	0.00	22	8	454	4913	0.0924078974150214	0.329825470604717	0.329825470604717	false	false	false	true
94c6dbb7-4b98-4f57-ae36-e980e38390a3	2026-09-28 13:18	2026-09-28 13:18	2026-09-28 13:18	SMH	SMH261023C00625000	call	625.0000	2026-10-23	11.5000	11.3500	12.7000	601.5700	29900.00	1150.00	28750.00	26	8	70	226	0.309734513274336	0.321583832591004	0.321583832591004	true	false	false	true
8e108f05-2d1e-40c3-a268-bc9009ec1a72	2026-09-28 13:14	2026-09-28 13:14	2026-09-28 13:14	SMH	SMH261009P00595000	put	595.0000	2026-10-09	9.6000	9.5500	10.0500	602.8700	12485.00	0.00	12485.00	13	5	54	58	0.931034482758621	0.324804920517225	0.326051163715907	true	false	false	true
f701eb4f-4cc0-4945-af1c-8db34d5769cb	2026-09-28 13:14	2026-09-28 13:13	2026-09-28 13:13	SMH	SMH261030C00665000	call	665.0000	2026-10-30	5.5000	5.5000	5.8000	602.3700	15400.00	0.00	15400.00	28	6	41	374	0.109625668449198	0.332320520948617	0.332320520948617	false	false	false	true
6343acea-587e-440b-ae7a-d725fdaa6032	2026-09-28 13:14	2026-09-28 13:13	2026-09-28 13:13	SMH	SMH261218P00530000	put	530.0000	2026-12-18	13.7000	13.6500	13.7000	602.3700	150700.00	150700.00	0.00	110	7	490	868	0.564516129032258	0.391649712237441	0.391649712237441	true	false	false	true
3fbed722-b13b-4416-b048-ba889a8118e2	2026-09-28 13:14	2026-09-28 13:13	2026-09-28 13:13	SMH	SMH261218P00610000	put	610.0000	2026-12-18	42.0000	41.9500	42.0000	602.3700	222600.00	222600.00	0.00	53	7	82	110	0.745454545454545	0.362337929540308	0.362337929540308	false	false	false	true
3d7ff791-9750-4fba-a039-d0969d166c89	2026-09-28 13:13	2026-09-28 13:13	2026-09-28 13:13	SMH	SMH261120P00530000	put	530.0000	2026-11-20	8.7000	8.7000	9.1500	602.3600	89635.00	0.00	89635.00	103	14	114	8723	0.0130688983148	0.395922210342302	0.395951324486674	true	false	false	true
09dbb547-5f6b-4162-af01-31e1bdd4fbfa	2026-09-28 13:13	2026-09-28 13:13	2026-09-28 13:13	SMH	SMH261218P00530000	put	530.0000	2026-12-18	13.8000	13.8000	14.7500	602.3600	509220.00	0.00	509220.00	369	23	380	868	0.43778801843318	0.392851954135157	0.392877225483185	false	false	false	true
bd36471a-4530-45a4-ad8f-9d8e12cdd23f	2026-09-28 13:12	2026-09-28 13:12	2026-09-28 13:12	SMH	SMH260928C00607500	call	607.5000	2026-09-28	0.3400	0.3100	0.3400	602.7350	10132.00	2006.00	0.00	298	23	4251	1260	3.37380952380952	0.41836051203794	0.41836051203794	true	false	false	true
11dccf3d-4c69-462f-9aa8-f0c435e24156	2026-09-28 13:00	2026-09-28 13:00	2026-09-28 13:00	SMH	SMH260930C00602500	call	602.5000	2026-09-30	4.9500	4.9500	5.3500	600.2250	13865.00	0.00	13865.00	28	13	153	53	2.88679245283019	0.33563544651012	0.33563544651012	false	false	false	true
02af2ee9-0261-4d92-934c-0e684d834558	2026-09-28 12:55	2026-09-28 12:55	2026-09-28 12:55	SMH	SMH261023P00580000	put	580.0000	2026-10-23	11.7500	11.7500	12.1500	600.7600	27025.00	0.00	27025.00	23	7	77	82	0.939024390243902	0.342447436595054	0.342447436595054	true	false	false	true
dd41edc1-5ca2-4824-99a6-a5c6e6030fe8	2026-09-28 12:51	2026-09-28 12:51	2026-09-28 12:51	SMH	SMH261002P00600000	put	600.0000	2026-10-02	8.8500	8.3500	8.8500	600.4100	15930.00	15930.00	0.00	18	5	219	518	0.422779922779923	0.366482930678203	0.366482930678203	false	false	false	true
01c2292d-2b94-49e6-9e7c-7753c7dafb9e	2026-09-28 12:50	2026-09-28 12:50	2026-09-28 12:50	SMH	SMH261016P00600000	put	600.0000	2026-10-16	16.5000	16.0000	16.5500	600.6700	75900.00	41250.00	34650.00	46	5	207	6258	0.0330776605944391	0.327860399690545	0.327860399690545	false	false	false	true
4e3dccd2-f48e-4b48-9f6c-14a7cdffd498	2026-09-28 12:48	2026-09-28 12:48	2026-09-28 12:48	SMH	SMH261002P00597500	put	597.5000	2026-10-02	7.3500	6.7500	7.4000	601.0000	52185.00	51450.00	0.00	71	29	476	380	1.25263157894737	0.371973308389347	0.371973308389347	true	false	false	true
6e291c68-ff75-4ada-b0eb-be2cb2618251	2026-09-28 12:45	2026-09-28 12:45	2026-09-28 12:45	SMH	SMH261002C00620000	call	620.0000	2026-10-02	2.8700	2.6700	2.8800	601.0000	17795.00	17795.00	0.00	62	17	1107	2466	0.448905109489051	0.361016527577857	0.360360145012341	true	false	false	true
e3874c1f-07c6-4826-a4ba-fcfac093552f	2026-09-28 12:36	2026-09-28 12:36	2026-09-28 12:36	SMH	SMH270115C00670000	call	670.0000	2027-01-15	24.5500	23.3000	25.3500	603.4750	245500.00	196400.00	49100.00	100	7	107	1636	0.0654034229828851	0.349382389369434	0.349382389369434	false	false	false	true