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 = RepeatedHitsAscendingFill×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	expiry

5c632d73-432d-4263-b73c-345a73dbcafb	2026-09-18 10:02	2026-09-18 10:02	2026-09-18 10:02	SMH	SMH261016P00500000	put	500.0000	2026-10-16	2.8700	2.7600	2.8800	564.1600	306555.00	283181.00	19656.00	1069	41	1138	11181	0.101779805026384	0.364348264503827	0.364348264503827	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	72398225983.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-18T14:08:58.692787Z"}	2026-09-18	2026-09-18 21:15	2026-09-18 21:15
1192db6e-e64b-4162-93b0-2ee383e15a0b	2026-09-17 15:51	2026-09-17 15:51	2026-09-17 15:51	SMH	SMH260928C00560000	call	560.0000	2026-09-28	11.5900	10.9000	11.6000	561.0000	83480.00	78870.00	4610.00	72	19	695	620	1.12096774193548	0.271931026213825	0.27322313974232	true	false	false	true
925bbac9-ed51-4ac0-8df2-b90765e017ef	2026-09-17 15:44	2026-09-17 15:44	2026-09-17 15:44	SMH	SMH261002P00550000	put	550.0000	2026-10-02	9.1000	8.8000	9.1000	560.8000	51865.00	51865.00	0.00	57	5	130	556	0.233812949640288	0.315928917749638	0.316164245910357	false	false	false	true
2fa9ba7d-357e-4582-8dc2-fff4de635e09	2026-09-17 15:44	2026-09-17 15:44	2026-09-17 15:44	SMH	SMH261016P00525000	put	525.0000	2026-10-16	7.2500	7.0000	7.2500	560.8000	52194.00	52194.00	0.00	72	5	479	3209	0.149267684636959	0.341458435891706	0.342096139697272	false	false	false	true
84de6b70-f3f3-4bc0-9ab7-419ddc9a0a2d	2026-09-16 15:01	2026-09-16 15:01	2026-09-16 15:01	SMH	SMH260918C00542500	call	542.5000	2026-09-18	7.8200	7.3500	8.0750	545.1200	108690.00	108690.00	0.00	139	10	253	742	0.340970350404313	0.397602431587854	0.394706569027344	true	false	false	true
c2e8c0b2-2f22-497f-b54f-bd7dc8646fb8	2026-09-16 13:58	2026-09-16 13:58	2026-09-16 13:58	SMH	SMH260918P00530000	put	530.0000	2026-09-18	1.3400	1.2900	1.3600	550.0000	75437.00	40109.00	34656.00	561	39	54429	18946	2.8728491502164	0.47275855932474	0.473884738914995	true	false	false	true
6c281513-afb4-482e-a89a-2d5f842e8df6	2026-09-16 13:57	2026-09-16 13:57	2026-09-16 13:57	SMH	SMH260916C00555000	call	555.0000	2026-09-16	1.3500	1.2500	1.3600	550.0000	57889.00	57755.00	134.00	430	33	2113	111	19.036036036036	0.918186485506991	0.932368119470808	false	false	false	true
c317f949-76e8-4b1c-8b8b-e01e6bd59ea0	2026-09-16 13:55	2026-09-16 13:54	2026-09-16 13:54	SMH	SMH260918P00530000	put	530.0000	2026-09-18	1.4900	1.3200	1.3500	549.0000	2087528.00	2087528.00	0.00	14000	13	49964	18946	2.63717935184208	0.464675487549248	0.475657308572186	true	false	false	true
5555156a-4686-4cd3-8018-373f9ac114cf	2026-09-16 13:54	2026-09-16 13:54	2026-09-16 13:54	SMH	SMH260918P00530000	put	530.0000	2026-09-18	1.3300	1.2800	1.3600	549.0000	403561.00	393988.00	8088.00	3031	49	31658	18946	1.67095956930223	0.458247634866038	0.464983429603279	false	false	false	true
09d9309f-14d0-41dd-9f62-6e89812c1848	2026-09-16 09:31	2026-09-16 09:31	2026-09-16 09:31	SMH	SMH260918C00552500	call	552.5000	2026-09-18	5.1000	5.0000	6.6000	549.8650	51000.00	9845.00	41155.00	100	12	100	300	0.333333333333333	0.382637637946226	0.388861632843722	true	false	false	true
0603a5d8-0ec5-4b19-a18c-6ed1b84adf8a	2026-09-16 09:31	2026-09-16 09:31	2026-09-16 09:31	SMH	SMH260917C00545000	call	545.0000	2026-09-17	8.0000	7.6500	9.5000	549.6700	98425.00	41185.00	57240.00	123	10	123	88	1.39772727272727	0.450923739351111	0.459418119623957	true	false	false	true
a3bc9609-468f-435a-93b1-06c363d2330c	2026-09-15 14:41	2026-09-15 14:41	2026-09-15 14:41	SMH	SMH270319P00510000	put	510.0000	2027-03-19	36.7500	36.1000	36.7500	541.3950	323390.00	319725.00	3665.00	88	8	803	543	1.47882136279926	0.376009128130114	0.376725430807614	false	false	false	true
659a5cbd-b096-4a98-9c46-38d586b5966b	2026-09-15 12:00	2026-09-15 11:59	2026-09-15 11:59	SMH	SMH261016P00545000	put	545.0000	2026-10-16	21.2500	20.8500	21.6500	541.4800	1069039.00	123280.00	922329.00	503	28	3409	6092	0.559586342744583	0.323950203578395	0.325538837604348	true	false	false	true
1cdab5ac-5c44-488b-a821-04fdeef65eef	2026-09-15 11:57	2026-09-15 11:57	2026-09-15 11:57	SMH	SMH261016P00545000	put	545.0000	2026-10-16	20.8500	20.3500	21.3500	542.3200	1042744.00	114675.00	928069.00	500	28	2906	6092	0.477019041365726	0.324143640888949	0.324143640888949	true	false	false	true
ee1f24ac-2124-4a57-a329-57f0bc88e14b	2026-09-15 10:36	2026-09-15 10:36	2026-09-15 10:36	SMH	SMH261016P00545000	put	545.0000	2026-10-16	20.2400	19.6000	20.3500	544.0000	62758.00	60733.00	2025.00	31	5	1300	6092	0.213394615889691	0.327278952866881	0.328229590390552	true	false	false	true
8930b0fd-ee78-4497-ab1b-6b945df9dac4	2026-09-15 10:25	2026-09-15 10:25	2026-09-15 10:25	SMH	SMH260925P00500000	put	500.0000	2026-09-25	1.4200	1.1900	1.4500	544.9700	143005.00	141859.00	858.00	1007	53	1012	2549	0.397018438603374	0.393278170366621	0.393278170366621	true	false	false	true
04c7af25-f0d4-47bf-ada0-b5b0fc6d5b89	2026-09-15 09:37	2026-09-15 09:37	2026-09-15 09:37	SMH	SMH260928C00522500	call	522.5000	2026-09-28	27.5800	27.2000	29.9500	544.6300	427420.00	174720.00	238975.00	155	20	155	0	0	0.321653700884797	0.314102814790248	true	false	false	true
f2a0abab-a77a-4a01-955a-fc06d3c94792	2026-09-15 09:33	2026-09-15 09:32	2026-09-15 09:32	SMH	SMH260918P00540000	put	540.0000	2026-09-18	4.7900	4.7000	5.7000	546.9399	101925.00	26390.00	75055.00	213	36	215	3279	0.0655687709667582	0.394048560864897	0.402158165301062	true	false	false	true
274b6a95-0510-47dd-a325-0838878736f2	2026-09-14 15:57	2026-09-14 15:57	2026-09-14 15:57	SMH	SMH270617C00605000	call	605.0000	2027-06-17	49.6600	48.5000	49.7500	541.0000	576095.00	571135.00	4960.00	116	43	210	64	3.28125	0.356703461055122	0.356485416422876	true	false	false	true
5af9c1f1-9b4a-4094-92b7-8908bb7ab75f	2026-09-14 14:43	2026-09-14 14:43	2026-09-14 14:43	SMH	SMH261016C00575000	call	575.0000	2026-10-16	9.8300	9.6000	9.8500	545.8100	53075.00	31515.00	21560.00	54	5	1413	1087	1.29990800367985	0.312210597925563	0.313080701807914	true	false	false	true
ec737d7f-19e4-481b-8550-c51d582a3c05	2026-09-14 13:49	2026-09-14 13:49	2026-09-14 13:49	SMH	SMH280121C00570000	call	570.0000	2028-01-21	95.1000	93.0000	96.6000	544.8000	104614.00	104614.00	0.00	11	9	14	33	0.424242424242424	0.36232035629198	0.36232035629198	false	false	false	true
e3462c3c-036c-4e72-84b6-a4fa087592c6	2026-09-14 13:49	2026-09-14 13:49	2026-09-14 13:49	SMH	SMH261016C00585000	call	585.0000	2026-10-16	6.7500	6.7500	6.9000	544.8600	942317.00	0.00	942317.00	1396	24	2891	1720	1.68081395348837	0.306417091489977	0.306417091489977	false	false	false	true
4039db92-5bb6-429b-9af6-5c3700184df1	2026-09-14 13:36	2026-09-14 13:35	2026-09-14 13:35	SMH	SMH260925C00567500	call	567.5000	2026-09-25	3.6000	3.5500	3.9000	544.1900	180735.00	365.00	180370.00	502	47	531	38	13.9736842105263	0.300559159284648	0.30232026883746	false	false	false	true
9029bc11-0d5f-476e-97af-5e33188b04b8	2026-09-14 13:12	2026-09-14 13:12	2026-09-14 13:12	SMH	SMH281215P00500000	put	500.0000	2028-12-15	77.0100	77.0000	79.9000	545.3250	107815.00	0.00	107815.00	14	10	18	846	0.0212765957446809	0.404472260477697	0.404842882149464	false	false	false	true
5854f83a-8c6a-4c38-b676-626b415e472b	2026-09-14 12:52	2026-09-14 12:52	2026-09-14 12:52	SMH	SMH261009C00565000	call	565.0000	2026-10-09	10.5600	10.2000	10.6500	545.3000	62285.00	4260.00	58025.00	59	7	646	19	34	0.314809556898355	0.316680616597077	true	false	false	true
7106bb0d-4cd2-4033-8f39-ba719557f69e	2026-09-14 12:03	2026-09-14 12:03	2026-09-14 12:03	SMH	SMH260925C00560000	call	560.0000	2026-09-25	5.3500	5.3500	5.6000	543.1200	304963.00	0.00	304963.00	570	47	1957	281	6.9644128113879	0.306960930408747	0.306960930408747	false	false	false	true
34b600cb-e7c5-418a-a658-e833f555c0e3	2026-09-14 11:53	2026-09-14 11:53	2026-09-14 11:53	SMH	SMH260925C00560000	call	560.0000	2026-09-25	5.7500	5.7500	6.2000	543.9200	591111.00	0.00	591111.00	1028	60	1383	281	4.92170818505338	0.311652172389605	0.311652172389605	false	false	false	true
8799f514-21a4-4435-a913-b5bb9a42100f	2026-09-14 11:47	2026-09-14 11:46	2026-09-14 11:46	SMH	SMH270617C00690000	call	690.0000	2027-06-17	26.5600	25.0500	26.6500	544.4184	310760.00	265690.00	45070.00	117	7	127	82	1.54878048780488	0.344692457161746	0.345606388181846	false	false	false	true
c9db3040-e763-47e5-b306-99afb5aaa50e	2026-09-14 11:31	2026-09-14 11:30	2026-09-14 11:30	SMH	SMH261016C00585000	call	585.0000	2026-10-16	6.7000	6.6500	7.1000	542.4300	903196.00	670.00	902526.00	1348	62	1375	1720	0.799418604651163	0.316892207207515	0.317035120498202	true	false	false	true
98b08c34-92a0-42b4-9e04-f71bcfdb17de	2026-09-14 11:24	2026-09-14 11:24	2026-09-14 11:24	SMH	SMH261016C00600000	call	600.0000	2026-10-16	4.1000	4.1000	4.4000	541.9500	761856.00	435.00	761421.00	1858	63	2099	6588	0.318609593199757	0.318089209949443	0.324441550399973	false	false	false	true
49ada3ff-008b-4f14-a032-f1d0371c963f	2026-09-14 10:57	2026-09-14 10:57	2026-09-14 10:57	SMH	SMH260918C00555000	call	555.0000	2026-09-18	3.4500	3.4000	3.7000	540.7800	643111.00	1750.00	641361.00	1864	51	2049	1156	1.77249134948097	0.38045023395107	0.386376280059538	false	false	false	true
2a72f263-7b93-45ec-b520-cae17bd6a6d2	2026-09-14 10:45	2026-09-14 10:45	2026-09-14 10:45	SMH	SMH261016C00620000	call	620.0000	2026-10-16	2.2900	2.2700	2.4600	542.3100	114743.00	0.00	114743.00	500	11	558	6750	0.0826666666666667	0.325829040100606	0.326921931397284	false	false	false	true
ae332734-7bd6-44ef-b31e-d23fae482698	2026-09-14 10:17	2026-09-14 10:17	2026-09-14 10:17	SMH	SMH261002C00525000	call	525.0000	2026-10-02	29.7600	29.7500	31.8500	544.0000	71415.00	5960.00	65455.00	24	10	40	1	40	0.372851876533574	0.372851876533574	true	false	false	true
274e1695-7f57-4692-aa1c-45bb77a02cc8	2026-09-14 09:32	2026-09-14 09:32	2026-09-14 09:32	SMH	SMH260918P00535000	put	535.0000	2026-09-18	7.6400	6.8500	7.8000	539.6100	70275.00	62050.00	8225.00	92	12	274	3378	0.0811130846654825	0.440524314024287	0.445067965544363	true	false	false	true
02753efe-5416-40ef-ad4a-cd6ce0889de3	2026-09-14 09:32	2026-09-14 09:31	2026-09-14 09:31	SMH	SMH261016P00515000	put	515.0000	2026-10-16	12.6200	11.0000	12.8500	538.4650	306625.00	173260.00	133365.00	243	25	243	1931	0.125841532884516	0.373519738267139	0.37440602138644	true	false	false	true
c2a11380-e9d1-4bdf-851a-8d8a4f427e48	2026-09-11 15:48	2026-09-11 15:48	2026-09-11 15:48	SMH	SMH261016C00620000	call	620.0000	2026-10-16	5.9500	5.9500	6.3000	568.5600	113675.00	1215.00	112460.00	191	33	326	6572	0.0496043822276324	0.306705860339761	0.306705860339761	false	false	false	true
cadf3a98-cbf1-45f0-989c-da184c6e11f8	2026-09-11 15:12	2026-09-11 15:12	2026-09-11 15:12	SMH	SMH260918P00600000	put	600.0000	2026-09-18	31.3000	29.7500	31.8000	569.5000	109535.00	106420.00	3115.00	35	8	49	1033	0.0474346563407551	0.289023328005462	0.299332098285265	false	false	false	true
f47f3110-d993-4685-aed4-1b9ba42934bf	2026-09-11 15:07	2026-09-11 15:07	2026-09-11 15:07	SMH	SMH270319C00585000	call	585.0000	2027-03-19	56.4700	56.4000	58.7500	569.6400	141170.00	0.00	141170.00	25	11	25	80	0.3125	0.354033941417293	0.354033941417293	true	false	false	true
e523537a-da94-4e58-a6fe-813a945b4f46	2026-09-11 15:02	2026-09-11 15:02	2026-09-11 15:02	SMH	SMH261002C00592500	call	592.5000	2026-10-02	8.6900	8.5500	9.5500	570.3500	56474.00	3450.00	53024.00	65	16	105	46	2.28260869565217	0.308026753359641	0.306405005747574	true	false	false	true
b04eb4f4-1308-4b04-9c79-8c7cf552f2bb	2026-09-11 10:15	2026-09-11 10:15	2026-09-11 10:15	SMH	SMH261023C00555000	call	555.0000	2026-10-23	34.6500	32.6000	34.8500	568.7350	128195.00	124745.00	3450.00	37	10	37	3	12.3333333333333	0.338776885218948	0.341501884477701	true	false	false	true
156eb26c-2c26-43ad-b013-89e6c29dd3bc	2026-09-11 10:04	2026-09-11 10:04	2026-09-11 10:04	SMH	SMH260914P00567500	put	567.5000	2026-09-14	4.6300	3.4500	4.8000	567.5100	64305.00	32760.00	25035.00	139	16	274	14	19.5714285714286	0.231244104932814	0.238554599318581	true	false	false	true
6459e19d-bbb8-4f16-8290-8f074479f2d0	2026-09-11 10:00	2026-09-11 09:59	2026-09-11 09:59	SMH	SMH261218P00580000	put	580.0000	2026-12-18	43.3800	43.3500	44.5000	569.8200	177840.00	13035.00	164805.00	41	10	665	1124	0.591637010676157	0.350903328323249	0.35132843284452	false	false	false	true
e608f353-6949-4b77-9b2f-c117df42caf4	2026-09-11 09:59	2026-09-11 09:59	2026-09-11 09:59	SMH	SMH261218P00580000	put	580.0000	2026-12-18	43.7100	43.6500	44.5000	569.0000	87410.00	26250.00	61160.00	20	6	489	1124	0.435053380782918	0.353250334903752	0.353250334903752	false	false	false	true
5c818554-fc8b-4565-accc-baf07173cdad	2026-09-11 09:59	2026-09-11 09:59	2026-09-11 09:59	SMH	SMH261218P00580000	put	580.0000	2026-12-18	43.8000	43.6500	44.5000	569.0000	297860.00	149280.00	148580.00	68	6	436	1124	0.387900355871886	0.353350483750124	0.354626074366459	false	false	false	true
43c09032-7f5e-48ce-9ad4-70a09f0a9a2a	2026-09-11 09:46	2026-09-11 09:46	2026-09-11 09:46	SMH	SMH261218C00520000	call	520.0000	2026-12-18	75.8200	75.7000	78.0000	570.0000	98565.00	45525.00	53040.00	13	5	14	398	0.0351758793969849	0.374809043894355	0.377236173307411	false	false	false	true
ec6068ad-20d6-4c7a-bf82-6855a5c8d88c	2026-09-11 09:44	2026-09-11 09:44	2026-09-11 09:44	SMH	SMH261120C00620000	call	620.0000	2026-11-20	16.9500	15.4500	17.0500	569.3600	54255.00	49165.00	5090.00	32	8	32	1354	0.0236336779911374	0.341112726341204	0.341667418181958	true	false	false	true
028009cc-dd60-4d0e-9052-e67fc8e061fa	2026-09-11 09:37	2026-09-11 09:37	2026-09-11 09:37	SMH	SMH261016P00570000	put	570.0000	2026-10-16	23.9600	23.2500	24.2000	565.7600	64690.00	33590.00	31100.00	27	16	37	756	0.0489417989417989	0.326608917630875	0.326608917630875	true	false	false	true
1ea91540-3857-470d-bbfd-f20606bf307b	2026-09-11 09:36	2026-09-11 09:36	2026-09-11 09:36	SMH	SMH260915C00567500	call	567.5000	2026-09-15	5.0500	5.0000	6.6500	565.0000	56595.00	1045.00	55045.00	112	20	112	5	22.4	0.253025517416899	0.250892634090739	true	false	false	true
93127e2e-f355-48ce-9e51-e648cd05abff	2026-09-10 15:30	2026-09-10 15:30	2026-09-10 15:30	SMH	SMH261002P00552500	put	552.5000	2026-10-02	13.9500	13.9500	15.1500	562.3800	249765.00	15400.00	234365.00	179	33	184	14	13.1428571428571	0.348687917996949	0.349483471566613	true	false	false	true
398fd6fa-8c10-4b95-83d8-367521b9e8ed	2026-09-10 15:24	2026-09-10 15:24	2026-09-10 15:24	SMH	SMH260911P00552500	put	552.5000	2026-09-11	2.0700	2.0700	2.2800	561.7434	57962.00	208.00	57754.00	280	26	391	341	1.1466275659824	0.474354033352569	0.475431307316613	true	false	false	true