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 = RepeatedHitsDescendingFill×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

32e6e477-103d-4b9a-91a8-92af5c98a625	2026-09-24 12:30	2026-09-24 12:30	2026-09-24 12:30	SMH	SMH261002C00622500	call	622.5000	2026-10-02	3.1000	2.8700	3.1000	597.0800	37176.00	37176.00	0.00	120	25	206	102	2.01960784313725	0.319648948061901	0.319648948061901	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	74239177442.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T16:32:14.615877Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
ec7c3bcc-bd58-4c3e-841a-7749bd930a30	2026-09-24 12:21	2026-09-24 12:21	2026-09-24 12:21	SMH	SMH260928C00607500	call	607.5000	2026-09-28	2.5800	2.5700	2.7800	597.8650	13669.00	0.00	13669.00	53	5	139	15	9.26666666666667	0.245480492181579	0.244525255834773	true	false	false	true
78422eb0-f45c-456c-a93e-8c5c82e2deda	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	SMH	SMH261009P00590000	put	590.0000	2026-10-09	11.3000	10.7000	11.3500	598.0000	22605.00	15855.00	6750.00	20	14	161	58	2.77586206896552	0.323769084446836	0.322925031399943	true	false	false	true
19ad9364-df0f-46e6-bfaa-d4fb1b368eae	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	SMH	SMH261016C00630000	call	630.0000	2026-10-16	8.0600	7.8500	8.2500	598.0000	12090.00	7290.00	4800.00	15	9	1437	8566	0.167756245622227	0.326969062310342	0.324170752382562	true	false	false	true
0c3e0dbe-8746-48ef-94ee-d7a48265b11f	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	SMH	SMH261016C00630000	call	630.0000	2026-10-16	8.0900	7.8000	8.1000	598.0000	129514.00	127139.00	2375.00	160	39	1422	8566	0.166005136586505	0.326969062310342	0.323943947125862	true	false	false	true
410a19a8-3704-4332-9855-b844c1655c39	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	SMH	SMH261009C00592500	call	592.5000	2026-10-09	19.1300	17.4000	19.9000	598.5800	17215.00	9580.00	7635.00	9	7	15	106	0.141509433962264	0.321510372586624	0.318339276267009	true	false	false	true
77cc7038-846f-4e04-b5e4-493ea3227a1f	2026-09-24 12:18	2026-09-24 12:18	2026-09-24 12:18	SMH	SMH260924C00597500	call	597.5000	2026-09-24	2.4500	2.0700	2.5200	598.2900	10540.00	5458.00	5082.00	43	7	1234	132	9.34848484848485	0.421370686306491	0.40691158987442	true	false	false	true
66895b47-30a0-4b24-bbd3-b0a290256fa9	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	SMH	SMH261001C00615000	call	615.0000	2026-10-01	3.3900	2.5600	3.5500	595.0000	16270.00	8160.00	8110.00	48	12	48	20	2.4	0.303400330649466	0.303400330649466	true	false	false	true
855e3ae9-4fc6-49d1-b490-49ce4296baf0	2026-09-24 12:16	2026-09-24 12:16	2026-09-24 12:16	SMH	SMH260924C00595000	call	595.0000	2026-09-24	2.2400	2.1200	2.2400	595.0000	11870.00	11870.00	0.00	53	35	1136	108	10.5185185185185	0.374615431487471	0.374615431487471	true	false	false	true
86efb05d-a0c9-4e21-93ce-6c7960f9a3d9	2026-09-24 12:06	2026-09-24 12:06	2026-09-24 12:06	SMH	SMH261120P00450000	put	450.0000	2026-11-20	2.5200	2.4000	2.5200	592.5400	147161.00	146910.00	0.00	584	59	1913	2673	0.715675271230827	0.463143132649684	0.463143132649684	true	false	false	true
29192043-04c3-462b-95b1-34ff1302d8f0	2026-09-24 11:18	2026-09-24 11:18	2026-09-24 11:18	SMH	SMH260925C00600000	call	600.0000	2026-09-25	1.1500	1.1400	1.3100	591.2000	61288.00	0.00	60604.00	533	52	920	2841	0.323829637451602	0.331939952125099	0.330790231249324	true	false	false	true
64fca9ff-6d97-4b0d-8af1-7276b850d70d	2026-09-24 11:12	2026-09-24 11:12	2026-09-24 11:12	SMH	SMH261016C00670000	call	670.0000	2026-10-16	1.4000	1.3300	1.5200	591.0000	13859.00	4768.00	9091.00	99	21	121	1751	0.0691033695031411	0.32812000572655	0.327080789819106	true	false	false	true
31d82f07-13f3-4f68-8ba4-9a505480b652	2026-09-24 09:42	2026-09-24 09:42	2026-09-24 09:42	SMH	SMH260925P00587500	put	587.5000	2026-09-25	2.5600	2.5600	2.8600	592.4500	17669.00	0.00	17669.00	69	7	108	972	0.111111111111111	0.377774171270701	0.376883602311018	true	false	false	true
f97a91f2-c0e0-4745-96c3-ebd3756496ae	2026-09-24 09:38	2026-09-24 09:38	2026-09-24 09:38	SMH	SMH261009C00602500	call	602.5000	2026-10-09	11.3700	10.8500	11.4500	592.2300	20465.00	13650.00	6815.00	18	6	18	0	0	0.32332046209171	0.322254374950401	true	false	false	true
efbc3d9a-5ad1-4a9d-9de8-10da39ae7456	2026-09-24 09:37	2026-09-24 09:37	2026-09-24 09:37	SMH	SMH261016C00630000	call	630.0000	2026-10-16	6.1500	6.1000	6.5500	591.3700	183157.00	32487.00	150670.00	298	14	406	8566	0.0473966845668924	0.327987995559263	0.321933409055863	true	false	false	true
d0702fd2-e3c5-46e1-bd59-d504910166de	2026-09-24 09:36	2026-09-24 09:36	2026-09-24 09:36	SMH	SMH260925C00597500	call	597.5000	2026-09-25	2.5700	2.3100	2.8400	592.2800	16421.00	10102.00	6319.00	64	6	157	1884	0.0833333333333333	0.381437384111409	0.377895794943323	true	false	false	true
2383d933-6c3d-4f8c-8d40-76afbf64d602	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SMH	SMH261016C00625000	call	625.0000	2026-10-16	10.8600	10.3500	10.9000	599.7200	276835.00	217435.00	59400.00	255	43	616	12659	0.0486610316770677	0.336914678294827	0.335097875875747	true	false	false	true
d855fa82-a2fd-426c-af9c-aff035aafd68	2026-09-23 15:43	2026-09-23 15:43	2026-09-23 15:43	SMH	SMH261016C00585000	call	585.0000	2026-10-16	30.0000	29.5000	30.5000	600.0000	128980.00	66000.00	62980.00	43	9	61	4140	0.0147342995169082	0.348587011839954	0.348587011839954	false	false	false	true
386e0c59-f819-418d-9701-ac5a862802d5	2026-09-23 15:20	2026-09-23 15:20	2026-09-23 15:20	SMH	SMH270319C00895000	call	895.0000	2027-03-19	4.9900	4.1500	5.0000	599.8400	49937.00	49937.00	0.00	100	20	100	86	1.16279069767442	0.357892844047868	0.357892844047868	false	false	false	true
bad9f36b-77ed-4ce3-b005-135bb87adffa	2026-09-23 15:20	2026-09-23 15:20	2026-09-23 15:20	SMH	SMH270115C00710000	call	710.0000	2027-01-15	15.7500	15.0500	15.7500	599.8700	2923180.00	2923180.00	0.00	1856	62	1856	535	3.46915887850467	0.353793129761828	0.353606762282632	true	false	false	true
6e10513c-45cf-421b-8cd8-7af431161b1a	2026-09-23 14:49	2026-09-23 14:49	2026-09-23 14:49	SMH	SMH261002C00625000	call	625.0000	2026-10-02	3.8000	3.6000	3.8000	600.0750	356046.00	356046.00	0.00	937	58	1137	237	4.79746835443038	0.321446287693891	0.321446287693891	false	false	false	true
a3abf0df-3928-4b8f-b79b-a1645d1306a9	2026-09-23 14:16	2026-09-23 14:16	2026-09-23 14:16	SMH	SMH261002C00602500	call	602.5000	2026-10-02	11.5000	11.1000	11.5500	600.0800	31040.00	29895.00	1145.00	27	20	196	225	0.871111111111111	0.329226813470696	0.329226813470696	true	false	false	true
730b0479-ecd4-4647-b6e6-701b72be4465	2026-09-23 14:03	2026-09-23 14:03	2026-09-23 14:03	SMH	SMH261016C00610000	call	610.0000	2026-10-16	16.1000	16.0000	16.5000	599.4000	120741.00	0.00	120741.00	75	11	389	3922	0.0991840897501275	0.336183061740438	0.334333393431374	true	false	false	true
b3d3998f-f625-4e8f-a7fa-057c12777aa8	2026-09-23 13:31	2026-09-23 13:31	2026-09-23 13:31	SMH	SMH270319P00500000	put	500.0000	2027-03-19	21.3600	21.0000	21.5000	596.0000	42721.00	40586.00	0.00	20	5	48	1788	0.0268456375838926	0.402345273434281	0.402172925696947	false	false	false	true
616348b9-f6df-4f51-8b6c-ad416992e568	2026-09-23 13:29	2026-09-23 13:29	2026-09-23 13:29	SMH	SMH261030P00600000	put	600.0000	2026-10-30	27.5400	27.0500	27.8500	596.0000	66105.00	63360.00	2745.00	24	10	90	77	1.16883116883117	0.357963036209374	0.356642286344107	true	false	false	true
a3ddaa74-eb82-42f7-ab90-2a5909334b01	2026-09-23 13:03	2026-09-23 13:03	2026-09-23 13:03	SMH	SMH261002P00585000	put	585.0000	2026-10-02	7.9300	7.0000	8.0000	594.8900	19825.00	10340.00	9485.00	25	13	67	970	0.0690721649484536	0.339610356395163	0.338178839835212	true	false	false	true
89df205d-d9ae-4710-bea2-850f71920e19	2026-09-23 13:02	2026-09-23 13:02	2026-09-23 13:02	SMH	SMH261002P00582500	put	582.5000	2026-10-02	6.9000	6.2500	6.9500	595.6100	14480.00	13795.00	685.00	21	9	97	101	0.96039603960396	0.340964114857602	0.339473376826714	true	false	false	true
ec753f29-9dea-4bac-85ee-8e209d3b2458	2026-09-23 13:02	2026-09-23 13:02	2026-09-23 13:02	SMH	SMH261016P00587500	put	587.5000	2026-10-16	15.8900	15.0000	15.9500	595.9800	12710.00	6355.00	3175.00	8	8	95	1690	0.0562130177514793	0.346327357910417	0.346327357910417	true	false	false	true
19e1b2e3-616c-4324-8fa0-39d6bdeece6c	2026-09-23 12:51	2026-09-23 12:51	2026-09-23 12:51	SMH	SMH261002P00570000	put	570.0000	2026-10-02	3.9500	3.7000	4.0000	595.6100	80146.00	79756.00	390.00	203	43	588	13471	0.0436493207631208	0.358378896611543	0.356490065912902	false	false	false	true
df52830d-a1da-45f6-841f-2939cf7ff46e	2026-09-23 12:50	2026-09-23 12:50	2026-09-23 12:50	SMH	SMH260930P00595000	put	595.0000	2026-09-30	9.2800	8.5000	9.3000	596.0500	14855.00	13010.00	1845.00	16	7	46	47	0.978723404255319	0.30509710585336	0.30357376040222	false	false	false	true
bf4c0861-320d-402e-8689-57f8a4279e75	2026-09-23 12:32	2026-09-23 12:32	2026-09-23 12:32	SMH	SMH261120C00615000	call	615.0000	2026-11-20	28.5800	28.0500	28.6000	598.3200	25725.00	22875.00	2850.00	9	9	22	309	0.0711974110032362	0.359906438693961	0.359906438693961	true	false	false	true
3f577b7a-8584-4bd1-a9cb-632453646e25	2026-09-23 10:54	2026-09-23 10:54	2026-09-23 10:54	SMH	SMH260924C00610000	call	610.0000	2026-09-24	1.1000	0.9700	1.1300	600.0000	24011.00	12763.00	9120.00	218	13	1148	2808	0.408831908831909	0.344716359556656	0.344716359556656	true	false	false	true
106dfb91-660e-4907-a940-6502a718cff1	2026-09-23 10:53	2026-09-23 10:53	2026-09-23 10:53	SMH	SMH260924C00597500	call	597.5000	2026-09-24	5.2000	4.5000	5.2000	598.8300	29615.00	28590.00	1025.00	57	11	66	27	2.44444444444444	0.357724114127992	0.353689189124824	false	false	false	true
017ab7b6-a8f0-41a5-888e-40e50afa18d3	2026-09-23 10:51	2026-09-23 10:50	2026-09-23 10:50	SMH	SMH260925C00597500	call	597.5000	2026-09-25	5.5900	5.4500	5.7000	596.4650	60413.00	48093.00	12320.00	108	10	344	1844	0.186550976138829	0.342752264794644	0.342183910943553	false	false	false	true
5ee16b19-87a0-4d89-aa69-56be74051917	2026-09-23 10:50	2026-09-23 10:50	2026-09-23 10:50	SMH	SMH260925C00597500	call	597.5000	2026-09-25	5.7000	5.4500	5.8500	596.6500	109993.00	75228.00	34765.00	193	15	236	1844	0.127982646420824	0.342161507676436	0.340510342052504	false	false	false	true
c9bf0617-d9db-4257-ac28-dab174f502c9	2026-09-23 10:37	2026-09-23 10:37	2026-09-23 10:37	SMH	SMH260928C00600000	call	600.0000	2026-09-28	6.3300	6.1000	6.7000	597.3900	10760.00	5080.00	5680.00	17	8	33	996	0.0331325301204819	0.266090992682896	0.260681769896766	true	false	false	true
53426553-d49a-40dd-922e-ce75aaebc229	2026-09-23 10:25	2026-09-23 10:25	2026-09-23 10:25	SMH	SMH261009P00585000	put	585.0000	2026-10-09	11.0400	10.8000	11.4750	595.0000	17660.00	3310.00	14350.00	16	5	28	311	0.090032154340836	0.329716125215457	0.330078548173601	true	false	false	true
30887160-fc4b-4713-a820-5caaa139108c	2026-09-23 10:13	2026-09-23 10:13	2026-09-23 10:13	SMH	SMH261009C00615000	call	615.0000	2026-10-09	8.9000	8.5000	8.9000	596.0000	190446.00	190446.00	0.00	214	17	238	1233	0.193025141930251	0.318942196498551	0.318942196498551	false	false	false	true
e2afbf39-b903-40e4-afde-25c89256a3d5	2026-09-23 10:13	2026-09-23 10:13	2026-09-23 10:13	SMH	SMH261006P00592500	put	592.5000	2026-10-06	11.5000	8.8000	11.5000	596.4600	25290.00	22995.00	1145.00	22	10	62	0	0	0.307821370004741	0.307820391472812	true	false	false	true
91c0468b-5e13-483c-bbaf-720302a4becf	2026-09-23 10:03	2026-09-23 10:03	2026-09-23 10:03	SMH	SMH261030P00600000	put	600.0000	2026-10-30	24.7900	24.4500	24.9500	600.1100	111555.00	79380.00	32175.00	45	10	48	77	0.623376623376623	0.344978572753531	0.342343062950678	false	false	false	true
8ff8a419-c29b-48dc-a0ea-14f52dc3cd7d	2026-09-23 10:03	2026-09-23 10:03	2026-09-23 10:03	SMH	SMH261030P00597500	put	597.5000	2026-10-30	23.6100	23.1000	23.7500	600.1100	99150.00	49645.00	49505.00	42	7	42	2	21	0.345525951602514	0.342879029279274	true	false	false	true
ed7a658d-0e24-4ca8-b791-47d129de7c34	2026-09-23 09:59	2026-09-23 09:59	2026-09-23 09:59	SMH	SMH261120C00565000	call	565.0000	2026-11-20	57.4600	56.8500	57.5000	599.9300	63210.00	57495.00	5715.00	11	5	11	645	0.0170542635658915	0.378017705178099	0.373821144552931	true	false	false	true
fc7e8ecd-6a02-4c37-b574-724db81b8b5c	2026-09-23 09:53	2026-09-23 09:53	2026-09-23 09:53	SMH	SMH261016P00582500	put	582.5000	2026-10-16	12.1700	12.1000	12.5500	598.7550	10955.00	3655.00	7300.00	9	8	10	291	0.0343642611683849	0.335430352235016	0.334527363473446	true	false	false	true
1019ebe4-350a-4479-8989-02e3574ab2f9	2026-09-23 09:49	2026-09-23 09:49	2026-09-23 09:49	SMH	SMH261016C00630000	call	630.0000	2026-10-16	9.1000	8.7500	9.1000	599.9500	27285.00	26385.00	900.00	30	9	87	8221	0.0105826541783238	0.329045599935415	0.329045599935415	true	false	false	true
6bf4c818-16d1-4b92-9fcc-c18e170c7b3d	2026-09-23 09:47	2026-09-23 09:47	2026-09-23 09:47	SMH	SMH261006P00592500	put	592.5000	2026-10-06	10.3500	8.6000	10.8500	599.0000	41380.00	20780.00	20600.00	40	10	40	0	0	0.312100053412951	0.308669208229426	true	false	false	true
00ed1458-6c1b-4e34-b075-1aaca1d854d5	2026-09-22 15:38	2026-09-22 15:38	2026-09-22 15:38	SMH	SMH260930C00612500	call	612.5000	2026-09-30	8.4700	7.7500	8.5500	607.2600	15250.00	11880.00	3370.00	18	10	20	0	0	0.297665338374361	0.296919098185129	true	false	false	true
ed882bb8-a837-4c1b-bbdb-3897b840b7f2	2026-09-22 15:35	2026-09-22 15:35	2026-09-22 15:35	SMH	SMH261120P00560000	put	560.0000	2026-11-20	16.0000	15.8000	16.0500	606.9800	655948.00	211153.00	23995.00	410	24	1478	1625	0.909538461538462	0.38416504510964	0.38408285934513	true	false	false	true
9ca93a63-fd50-4611-aa4a-7ae7d8355d88	2026-09-22 15:25	2026-09-22 15:25	2026-09-22 15:25	SMH	SMH261023C00630000	call	630.0000	2026-10-23	14.5900	14.1500	14.6000	606.0700	17513.00	17513.00	0.00	12	5	69	37	1.86486486486486	0.333653725471402	0.333271282749874	true	false	false	true
713e345c-d1d6-45c0-8d95-246dc7943138	2026-09-22 15:22	2026-09-22 15:22	2026-09-22 15:22	SMH	SMH270219C00710000	call	710.0000	2027-02-19	23.3300	21.9500	23.5500	606.2600	27995.00	13965.00	14030.00	12	5	13	185	0.0702702702702703	0.349145103108423	0.349513315349305	false	false	false	true
20c2b42f-65d9-4956-b56b-1df41fe2286f	2026-09-22 15:07	2026-09-22 15:07	2026-09-22 15:07	SMH	SMH270115C00675000	call	675.0000	2027-01-15	25.4000	24.8500	25.7000	606.0000	50794.00	50794.00	0.00	20	6	3296	955	3.45130890052356	0.350145270459504	0.350145270459504	false	false	false	true