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

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	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-28T17:33:20.125658Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
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
5e142aa9-5cfd-4c4d-8e97-f4cd511b72fd	2026-09-28 12:35	2026-09-28 12:35	2026-09-28 12:35	SMH	SMH260928C00600000	call	600.0000	2026-09-28	3.5000	3.3500	3.5000	602.8100	11550.00	11550.00	0.00	33	11	1377	1106	1.24502712477396	0.366956976497261	0.366956976497261	false	false	false	true
df49c9f1-2eae-433d-b7d7-888e45ac1f6f	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	SMH	SMH261009C00620000	call	620.0000	2026-10-09	6.6000	5.7500	6.6000	602.3100	29040.00	29040.00	0.00	44	13	110	770	0.142857142857143	0.316835018842232	0.316835018842232	false	false	false	true
c91b0f9a-96fb-4ba7-aad5-7b04945e9f69	2026-09-28 12:33	2026-09-28 12:33	2026-09-28 12:33	SMH	SMH261009C00617500	call	617.5000	2026-10-09	7.4000	6.5500	7.6000	602.3800	10355.00	8880.00	740.00	14	7	103	136	0.757352941176471	0.317486288112366	0.316860617533469	false	false	false	true
3d76b378-2165-4c0c-8819-8b3aa54fb1a3	2026-09-28 12:30	2026-09-28 12:30	2026-09-28 12:30	SMH	SMH261106P00605000	put	605.0000	2026-11-06	27.6500	26.2000	27.6500	602.0000	22120.00	22120.00	0.00	8	6	12	2	6	0.355773791210905	0.355773791210905	true	false	false	true
739f5b6c-e268-413e-a53d-1339baca9c93	2026-09-28 12:30	2026-09-28 12:29	2026-09-28 12:29	SMH	SMH260928C00600000	call	600.0000	2026-09-28	4.0500	3.8000	4.2500	603.0000	10935.00	10935.00	0.00	27	9	1006	1106	0.909584086799277	0.408185227702479	0.408185227702479	false	false	false	true
ff79c19e-8cfb-4fa4-926e-186c01fa867f	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	SMH	SMH261016C00580000	call	580.0000	2026-10-16	33.1500	31.0000	33.1500	602.7200	566865.00	566865.00	0.00	171	15	210	3500	0.06	0.361049429178406	0.360435418896441	true	false	false	true
95b57610-6f98-4225-b481-9c398840efe7	2026-09-28 12:26	2026-09-28 12:26	2026-09-28 12:26	SMH	SMH261016C00567500	call	567.5000	2026-10-16	42.4500	40.0000	42.4500	602.6800	110370.00	110370.00	0.00	26	6	26	12	2.16666666666667	0.367797950902212	0.367797950902212	false	false	false	true
d011f35e-3082-460e-b6c2-9e414ca6d340	2026-09-28 12:25	2026-09-28 12:25	2026-09-28 12:25	SMH	SMH261016C00600000	call	600.0000	2026-10-16	19.1000	18.3500	19.3500	602.3800	17190.00	17190.00	0.00	9	8	397	12539	0.0316612170029508	0.324343446810319	0.324343446810319	false	false	false	true
942ddc7e-8c5f-4496-b0e7-7303c45cd98d	2026-09-28 12:24	2026-09-28 12:24	2026-09-28 12:24	SMH	SMH270115P00440000	put	440.0000	2027-01-15	5.4500	5.0000	5.8000	601.5100	26705.00	13625.00	13080.00	49	6	79	419	0.18854415274463	0.450884560671458	0.450884560671458	false	false	false	true
0adb6069-1a45-4f51-808f-61a05de2fe92	2026-09-28 12:20	2026-09-28 12:20	2026-09-28 12:20	SMH	SMH261009P00580000	put	580.0000	2026-10-09	5.9000	5.8500	6.8500	600.0200	17700.00	8260.00	9440.00	30	5	118	101	1.16831683168317	0.339688015145307	0.339688015145307	false	false	false	true
2ed415b3-36e8-4d03-ae82-aefaeae35503	2026-09-28 12:17	2026-09-28 12:17	2026-09-28 12:17	SMH	SMH260929P00595000	put	595.0000	2026-09-29	2.1400	1.9900	2.1900	600.0000	31277.00	30626.00	651.00	146	7	386	91	4.24175824175824	0.343046462765389	0.336278465200717	true	false	false	true
dcde99b6-73d8-4e15-a6bd-b5d3bdf21e7f	2026-09-28 12:00	2026-09-28 12:00	2026-09-28 12:00	SMH	SMH261009C00615000	call	615.0000	2026-10-09	6.6500	6.6000	6.8500	597.5100	17290.00	13965.00	3325.00	26	7	64	1538	0.0416124837451235	0.31913335318535	0.31913335318535	true	false	false	true
87b165eb-5e59-4a9f-82f7-42f71c9de5cf	2026-09-28 11:55	2026-09-28 11:55	2026-09-28 11:55	SMH	SMH261009C00585000	call	585.0000	2026-10-09	21.4500	19.4000	21.4500	597.5000	12870.00	12870.00	0.00	6	6	11	90	0.122222222222222	0.338583075301005	0.338583075301005	false	false	false	true
bace874e-5745-411a-9c31-937537672bee	2026-09-28 11:55	2026-09-28 11:55	2026-09-28 11:55	SMH	SMH261002C00622500	call	622.5000	2026-10-02	1.6800	1.5600	1.6900	597.1750	21355.00	6571.00	7392.00	127	5	271	891	0.304152637485971	0.365184029167996	0.365883312105489	false	false	false	true
b7c32a1b-6c26-45ef-8606-526897fed12b	2026-09-28 11:55	2026-09-28 11:55	2026-09-28 11:55	SMH	SMH261009C00575000	call	575.0000	2026-10-09	28.5500	26.3000	28.5500	597.1750	14275.00	14275.00	0.00	5	5	6	60	0.1	0.352483940550622	0.352483940550622	false	false	false	true
7d6bca2c-547e-419b-8d72-0ce37c978143	2026-09-28 11:54	2026-09-28 11:54	2026-09-28 11:54	SMH	SMH261120P00570000	put	570.0000	2026-11-20	20.5000	20.5000	20.9500	596.7450	55355.00	0.00	55355.00	27	8	301	1164	0.258591065292096	0.378804702849535	0.379409733754762	false	false	false	true
04a2be08-036d-402e-b7aa-f09cafe2f7c5	2026-09-28 11:48	2026-09-28 11:48	2026-09-28 11:48	SMH	SMH260929P00575000	put	575.0000	2026-09-29	0.3200	0.3200	0.4000	595.7600	22272.00	0.00	22272.00	696	51	837	298	2.80872483221477	0.429914250836143	0.429914250836143	false	false	false	true
b693eb56-2c07-4337-94eb-83bdbcb47592	2026-09-28 11:47	2026-09-28 11:47	2026-09-28 11:47	SMH	SMH261016P00565000	put	565.0000	2026-10-16	6.5000	6.5000	6.7500	595.7100	27300.00	0.00	27300.00	42	6	845	2164	0.390480591497227	0.353446889015845	0.353446889015845	false	false	false	true
ea01b57f-a2dd-4bee-949e-58bd10ed6d5b	2026-09-28 11:41	2026-09-28 11:41	2026-09-28 11:41	SMH	SMH261016P00562500	put	562.5000	2026-10-16	5.9500	5.7000	5.9500	595.7600	13090.00	13090.00	0.00	22	5	22	131	0.16793893129771	0.355350357576846	0.355350357576846	false	false	false	true
b456b2da-28f9-45b2-8af8-5712b80d221f	2026-09-28 11:41	2026-09-28 11:41	2026-09-28 11:41	SMH	SMH261009P00590000	put	590.0000	2026-10-09	10.5000	9.9000	10.5500	595.9300	24150.00	23100.00	1050.00	23	7	62	254	0.244094488188976	0.330578542910523	0.330578542910523	true	false	false	true
4cfc8d42-da71-4794-b3c6-381035b38d72	2026-09-28 11:39	2026-09-28 11:39	2026-09-28 11:39	SMH	SMH261016P00590000	put	590.0000	2026-10-16	13.7000	13.7000	14.5500	596.8550	49320.00	0.00	49320.00	36	11	404	4913	0.0822308162019133	0.331772186454004	0.331772186454004	true	false	false	true
ab6de4ce-2a0e-4af7-ac3a-4c7ef419b1f0	2026-09-28 11:39	2026-09-28 11:38	2026-09-28 11:38	SMH	SMH261218C00580000	call	580.0000	2026-12-18	52.9500	51.3500	52.9500	596.8300	190620.00	190620.00	0.00	36	12	41	915	0.0448087431693989	0.371705807873133	0.371705807873133	false	false	false	true
20a58d8b-0da5-45f9-a84d-a448c250ff8e	2026-09-28 11:39	2026-09-28 11:38	2026-09-28 11:38	SMH	SMH261218C00580000	call	580.0000	2026-12-18	52.9000	51.3500	52.9500	596.8300	121670.00	121670.00	0.00	23	10	64	915	0.0699453551912568	0.371238850857988	0.371238850857988	false	false	false	true
57ec7c3c-5bdc-4a0c-b16f-60acb595e914	2026-09-28 11:37	2026-09-28 11:37	2026-09-28 11:37	SMH	SMH261016C00610000	call	610.0000	2026-10-16	12.0000	11.7000	12.0000	596.7000	15600.00	15600.00	0.00	13	5	285	4114	0.0692756441419543	0.325525702444853	0.325525702444853	false	false	false	true
73dbd331-22e2-4312-8192-78642f2cc4b0	2026-09-28 11:31	2026-09-28 11:30	2026-09-28 11:30	SMH	SMH261002C00600000	call	600.0000	2026-10-02	7.3000	6.9000	7.3000	595.7800	11680.00	11680.00	0.00	16	6	139	2471	0.056252529340348	0.366204191435835	0.366204191435835	true	false	false	true
bf8aee46-5245-4e2a-97b2-ed07e3d8a8d7	2026-09-28 11:24	2026-09-28 11:24	2026-09-28 11:24	SMH	SMH261002P00587500	put	587.5000	2026-10-02	6.0500	5.9500	6.4000	594.0000	11500.00	1820.00	9680.00	19	8	103	1045	0.0985645933014354	0.373721976337523	0.371592825840418	true	false	false	true
f88e489a-6d0b-4da2-aa1f-451fe36522a8	2026-09-28 11:15	2026-09-28 11:15	2026-09-28 11:15	SMH	SMH261016P00565000	put	565.0000	2026-10-16	6.8000	6.3000	6.8500	594.0000	14285.00	14285.00	0.00	21	7	801	2164	0.370147874306839	0.352052601925666	0.353272807449128	true	false	false	true
5e2df415-aacd-4d0b-af4b-bd66a52f5f6a	2026-09-28 11:15	2026-09-28 11:15	2026-09-28 11:15	SMH	SMH261016P00560000	put	560.0000	2026-10-16	5.8000	5.7500	5.8000	594.0000	34220.00	34220.00	0.00	59	12	355	5333	0.066566660416276	0.35808532395922	0.35808532395922	true	false	false	true
22ba9eb7-dffc-4d92-8818-4f6a188f8271	2026-09-28 11:15	2026-09-28 11:15	2026-09-28 11:15	SMH	SMH261016P00570000	put	570.0000	2026-10-16	8.0000	7.1000	8.0500	594.0000	15205.00	15205.00	0.00	19	7	207	1623	0.127541589648799	0.347228596235214	0.348367485995775	true	false	false	true
166e384a-9975-49a3-91dd-636d14740df4	2026-09-28 11:15	2026-09-28 11:15	2026-09-28 11:15	SMH	SMH261016P00572500	put	572.5000	2026-10-16	8.7000	8.6500	8.7000	594.0000	76560.00	76560.00	0.00	88	19	111	76	1.46052631578947	0.345645744008708	0.345645744008708	true	false	false	true
90b72df2-c500-4473-9b72-e788b4638b1a	2026-09-28 11:12	2026-09-28 11:12	2026-09-28 11:12	SMH	SMH261016C00630000	call	630.0000	2026-10-16	5.4500	5.2000	5.5000	595.2550	21800.00	20165.00	1635.00	40	13	1240	8388	0.147830233667144	0.31867611722038	0.31867611722038	false	false	false	true
9137da39-9408-454d-949d-bcc24fa3eb4d	2026-09-28 11:04	2026-09-28 11:03	2026-09-28 11:03	SMH	SMH261002C00602500	call	602.5000	2026-10-02	5.9400	5.8500	6.0000	594.4100	35664.00	21384.00	13090.00	60	7	92	334	0.275449101796407	0.374022459385871	0.373599198402191	false	false	false	true
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