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

d56fc6e8-5be5-4783-9b29-9e9093fd26c2	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SMH	SMH261002P00607500	put	607.5000	2026-10-02	10.4000	10.0000	10.4000	606.6800	11440.00	11440.00	0.00	11	8	273	37	7.37837837837838	0.304924479709451	0.304924479709451	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	74129314174.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:58:21.779683Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
920da23d-950b-4d3a-b556-7333bf9f8be0	2026-09-25 15:56	2026-09-25 15:56	2026-09-25 15:56	SMH	SMH261023C00640000	call	640.0000	2026-10-23	9.6500	9.4500	9.9500	606.9600	17370.00	965.00	16405.00	18	7	99	159	0.622641509433962	0.316325610475924	0.316325610475924	true	false	false	true
f61f916e-46a8-4b51-9131-1d9be4c12c82	2026-09-25 15:55	2026-09-25 15:54	2026-09-25 15:54	SMH	SMH260928C00625000	call	625.0000	2026-09-28	0.3800	0.3100	0.4000	607.5550	11438.00	11400.00	38.00	301	45	1232	20	61.6	0.21153713070625	0.21153713070625	true	false	false	true
46be10be-ceaf-497a-a80f-741624361d2f	2026-09-25 15:53	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00560000	put	560.0000	2026-10-16	4.3000	4.3000	4.3500	607.7000	25800.00	0.00	25800.00	60	6	959	5159	0.185888738127544	0.356920681697595	0.356920681697595	false	false	false	true
71eb73a6-1722-428f-ad13-91c0ebffbd1a	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00560000	put	560.0000	2026-10-16	4.3000	4.3000	4.3500	607.7000	41710.00	0.00	41710.00	97	9	899	5159	0.174258577243652	0.356920681697595	0.356920681697595	false	false	false	true
8cffccac-dd9f-47ef-bcaa-8ea687355547	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00600000	put	600.0000	2026-10-16	14.4000	14.3500	14.4000	607.8500	118080.00	118080.00	0.00	82	6	1286	6175	0.208259109311741	0.323241707105813	0.323241707105813	true	false	false	true
a10a3d2c-9c88-4e1d-bb0e-dfe587220dd2	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00600000	put	600.0000	2026-10-16	14.4000	14.3000	14.5000	607.8350	95040.00	2880.00	2880.00	66	5	1201	6175	0.194493927125506	0.323133862036676	0.323133862036676	false	false	false	true
60d7b114-356b-491a-a0d8-2f95d0adc09e	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00600000	put	600.0000	2026-10-16	14.3500	14.3000	14.3500	607.9310	121975.00	121975.00	0.00	85	6	1135	6175	0.183805668016194	0.322939523736031	0.322939523736031	false	false	false	true
25bd8613-e1a5-4a3a-b37f-b3885b93183e	2026-09-25 15:52	2026-09-25 15:52	2026-09-25 15:52	SMH	SMH261016P00600000	put	600.0000	2026-10-16	14.3500	14.2500	14.5500	607.9300	91840.00	4305.00	4305.00	64	7	1050	6175	0.17004048582996	0.32293234537706	0.32293234537706	false	false	false	true
45bcc2ec-9a25-4d3a-87c4-f7fb4a620890	2026-09-25 15:51	2026-09-25 15:50	2026-09-25 15:50	SMH	SMH260925C00607500	call	607.5000	2026-09-25	0.7500	0.7400	0.7500	607.0000	26625.00	26625.00	0.00	355	11	2562	1110	2.30810810810811	0.706327826410145	0.706327826410145	false	false	false	true
42053db5-3a75-403c-901f-dfafaf95b7a7	2026-09-25 15:51	2026-09-25 15:50	2026-09-25 15:50	SMH	SMH261009P00590000	put	590.0000	2026-10-09	7.6000	6.8500	7.6000	607.0000	19760.00	19760.00	0.00	26	9	115	192	0.598958333333333	0.322532106635049	0.322532106635049	false	false	false	true
a6da1ea7-bc28-465b-8d03-d135a6a5203a	2026-09-25 15:49	2026-09-25 15:49	2026-09-25 15:49	SMH	SMH261009C00612500	call	612.5000	2026-10-09	12.5000	12.0500	12.5000	607.0000	12500.00	12500.00	0.00	10	6	224	21	10.6666666666667	0.305199871531379	0.305199871531379	false	false	false	true
997f58d2-36a6-4163-a0b8-84f4bcb4ca25	2026-09-25 15:48	2026-09-25 15:48	2026-09-25 15:48	SMH	SMH261009P00560000	put	560.0000	2026-10-09	2.3800	2.3800	2.4600	607.0000	29988.00	0.00	29988.00	126	5	246	1648	0.149271844660194	0.356425438296384	0.356425438296384	true	false	false	true
45347a8f-3280-4990-b495-9c7b8d34580f	2026-09-25 15:47	2026-09-25 15:47	2026-09-25 15:47	SMH	SMH261218C00905000	call	905.0000	2026-12-18	0.8400	0.1700	1.5200	607.0000	10920.00	0.00	10920.00	130	24	132	210	0.628571428571429	0.383903960769455	0.383903960769455	true	false	false	true
6b1100a2-4ea6-49c2-9624-4441442c5fb9	2026-09-25 15:45	2026-09-25 15:45	2026-09-25 15:45	SMH	SMH261120C00600000	call	600.0000	2026-11-20	40.0000	38.9000	40.0000	607.0000	120000.00	120000.00	0.00	30	8	113	2643	0.0427544457056375	0.364152153471678	0.364152153471678	false	false	false	true
456989bf-54cb-4593-b8db-e6077e862352	2026-09-25 15:40	2026-09-25 15:40	2026-09-25 15:40	SMH	SMH261023P00597500	put	597.5000	2026-10-23	17.1500	16.8000	17.1500	606.0000	36015.00	36015.00	0.00	21	5	145	43	3.37209302325581	0.331903392472855	0.331903392472855	false	false	false	true
87f47d74-16f3-41ae-85fb-65560a217c2e	2026-09-25 15:38	2026-09-25 15:38	2026-09-25 15:38	SMH	SMH261002P00597500	put	597.5000	2026-10-02	6.3500	6.3500	6.6500	606.0000	17145.00	0.00	17145.00	27	7	441	75	5.88	0.311911133958941	0.311911133958941	true	false	false	true
dba4d1bf-4e4a-41e9-ae43-61239494fb47	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SMH	SMH261002P00595000	put	595.0000	2026-10-02	5.8500	5.8000	5.8500	605.0000	31605.00	31605.00	0.00	54	10	480	178	2.69662921348315	0.316048004325865	0.316048004325865	true	false	false	true
68355b08-03f3-4fe3-b28d-1ac97d76524a	2026-09-25 15:36	2026-09-25 15:36	2026-09-25 15:36	SMH	SMH261002P00587500	put	587.5000	2026-10-02	3.9000	3.8500	3.9000	605.0000	49914.00	49914.00	0.00	128	19	276	952	0.289915966386555	0.325723908863617	0.325723908863617	true	false	false	true
267bcea6-2182-483f-a729-122e2192e508	2026-09-25 15:29	2026-09-25 15:29	2026-09-25 15:29	SMH	SMH261120C00690000	call	690.0000	2026-11-20	9.1500	8.7500	9.1500	606.6000	39332.00	39332.00	0.00	43	14	96	151	0.635761589403974	0.352475611578513	0.352475611578513	false	false	false	true
b7bab5f1-49ee-4f40-90ff-71638754f7a2	2026-09-25 15:27	2026-09-25 15:27	2026-09-25 15:27	SMH	SMH260928C00620000	call	620.0000	2026-09-28	0.6500	0.6500	0.7100	606.6300	16120.00	0.00	16120.00	248	29	568	153	3.71241830065359	0.200517937601192	0.200517937601192	false	false	false	true
a8b51800-8cf8-493a-8cef-859640c85454	2026-09-25 15:27	2026-09-25 15:27	2026-09-25 15:27	SMH	SMH260928C00622500	call	622.5000	2026-09-28	0.4500	0.4500	0.4900	606.6300	25740.00	0.00	25740.00	572	54	858	1	858	0.205528435910934	0.205528435910934	false	false	false	true
f1310d4d-ff98-4840-a063-2323b9437629	2026-09-25 15:25	2026-09-25 15:25	2026-09-25 15:25	SMH	SMH261005C00610000	call	610.0000	2026-10-05	9.9000	8.9500	9.9000	606.7650	39600.00	39600.00	0.00	40	11	43	51	0.843137254901961	0.277364972807565	0.277364972807565	true	false	false	true
f66f007e-fb6d-4789-9f69-d912282e74fb	2026-09-25 15:22	2026-09-25 15:22	2026-09-25 15:22	SMH	SMH261023P00597500	put	597.5000	2026-10-23	17.2000	16.7500	17.2000	606.5608	43000.00	43000.00	0.00	25	5	124	43	2.88372093023256	0.334730769530704	0.334730769530704	true	false	false	true
d9505ce1-45a4-4d9e-95c0-9d1672f1f357	2026-09-25 15:22	2026-09-25 15:22	2026-09-25 15:22	SMH	SMH261009P00597500	put	597.5000	2026-10-09	10.4000	10.3500	10.4000	606.5608	16640.00	16640.00	0.00	16	6	193	104	1.85576923076923	0.316203297623409	0.316203297623409	false	false	false	true
bc7ae530-bc64-45ad-a43d-7ee5197d829e	2026-09-25 15:22	2026-09-25 15:22	2026-09-25 15:22	SMH	SMH261002P00607500	put	607.5000	2026-10-02	10.5000	10.2500	10.5000	606.6200	69300.00	69300.00	0.00	66	13	249	37	6.72972972972973	0.307017576929854	0.307017576929854	true	false	false	true
7909b9c0-e0fd-4cec-a1f1-f5561972f141	2026-09-25 15:22	2026-09-25 15:22	2026-09-25 15:22	SMH	SMH261016P00605000	put	605.0000	2026-10-16	17.3000	17.2500	17.3500	606.6200	48440.00	31140.00	0.00	28	5	185	177	1.04519774011299	0.324214419562122	0.324214419562122	false	false	false	true
19d79d7d-53bf-44cd-b8c2-3069f43f9abe	2026-09-25 15:22	2026-09-25 15:22	2026-09-25 15:22	SMH	SMH261009P00597500	put	597.5000	2026-10-09	10.4000	10.3500	10.4000	606.5608	84240.00	71760.00	0.00	81	9	177	104	1.70192307692308	0.316702729591776	0.316203297623409	false	false	false	true
463fc2ef-3db7-4425-9ead-5df048e61272	2026-09-25 15:16	2026-09-25 15:16	2026-09-25 15:16	SMH	SMH261016C00645000	call	645.0000	2026-10-16	6.1000	5.7500	6.1000	607.0400	122000.00	122000.00	0.00	200	7	442	3134	0.141033822590938	0.318211157108166	0.318211157108166	false	false	false	true
ec48f9f7-6e6b-44c0-b1d1-996c052cb785	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	SMH	SMH261002C00617500	call	617.5000	2026-10-02	5.9000	5.6000	5.9000	606.9600	45430.00	45430.00	0.00	77	7	194	336	0.577380952380952	0.300179972712696	0.300179972712696	false	false	false	true
d8e22f54-5df7-4c95-b47f-9ec6d7d129df	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	SMH	SMH261002C00615000	call	615.0000	2026-10-02	6.8000	6.5000	6.8000	606.9600	34000.00	34000.00	0.00	50	8	775	1780	0.435393258426966	0.300463503133065	0.300463503133065	true	false	false	true
7eca340a-533c-4a7e-946b-17fe8d26b4dc	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	SMH	SMH261023C00605000	call	605.0000	2026-10-23	23.8500	22.7500	23.9000	606.9600	28620.00	19080.00	0.00	12	7	32	109	0.293577981651376	0.32750656295227	0.32750656295227	false	false	false	true
03171549-28b3-43d0-9db8-9db127127b44	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	SMH	SMH261023C00612500	call	612.5000	2026-10-23	20.0100	19.5500	20.1000	606.9600	38010.00	38010.00	0.00	19	6	137	42	3.26190476190476	0.323895329159325	0.325386753588332	true	false	false	true
6bae7a12-99d8-48bc-8d37-96f932f10c77	2026-09-25 15:14	2026-09-25 15:14	2026-09-25 15:14	SMH	SMH261030P00555000	put	555.0000	2026-10-30	8.0000	8.0000	8.1500	606.9000	27200.00	0.00	27200.00	34	5	72	16	4.5	0.374705270836758	0.374705270836758	false	false	false	true
7e318a19-9f25-4084-8a38-83d5c099b72f	2026-09-25 15:10	2026-09-25 15:10	2026-09-25 15:10	SMH	SMH261023C00660000	call	660.0000	2026-10-23	5.3500	5.1500	5.3500	606.0000	23005.00	23005.00	0.00	43	10	324	103	3.14563106796116	0.316964776795396	0.316964776795396	false	false	false	true
8ccc853f-ddec-48bc-84b1-0b26a7f46631	2026-09-25 15:10	2026-09-25 15:10	2026-09-25 15:10	SMH	SMH270319C00875000	call	875.0000	2027-03-19	6.8500	6.5500	6.9000	606.0000	51375.00	50690.00	685.00	75	5	1064	131	8.12213740458015	0.361118849575014	0.361118849575014	false	false	false	true
bdf0db2f-d4d1-4a6e-95b2-fd76a0a4eac5	2026-09-25 15:10	2026-09-25 15:09	2026-09-25 15:09	SMH	SMH270319C00875000	call	875.0000	2027-03-19	6.8500	6.5500	6.8500	606.0000	50690.00	50690.00	0.00	74	9	839	131	6.40458015267176	0.361201219675506	0.361201219675506	false	false	false	true
ea901960-ff4f-4a5e-bcf3-743db75a5824	2026-09-25 15:06	2026-09-25 15:06	2026-09-25 15:06	SMH	SMH261030C00655000	call	655.0000	2026-10-30	9.0500	8.7500	9.0500	606.0000	45250.00	45250.00	0.00	50	12	140	311	0.45016077170418	0.33020420462923	0.33020420462923	true	false	false	true
c235a594-fa0d-48a3-b8f3-1c422bb94ab4	2026-09-25 15:06	2026-09-25 15:06	2026-09-25 15:06	SMH	SMH261030C00650000	call	650.0000	2026-10-30	10.2500	9.9000	10.2500	606.0000	21525.00	21525.00	0.00	21	13	95	369	0.257452574525745	0.330668435270743	0.330204548695223	true	false	false	true
661ea6f4-15fe-498a-ab36-b9df7e0ca538	2026-09-25 15:05	2026-09-25 15:05	2026-09-25 15:05	SMH	SMH261009C00625000	call	625.0000	2026-10-09	7.4500	6.9500	7.5500	606.0000	17880.00	17135.00	745.00	24	5	151	712	0.212078651685393	0.301767594600305	0.301767594600305	true	false	false	true
0e59b1cc-a4d7-46ca-a92a-ae3fbd41c0af	2026-09-25 15:04	2026-09-25 15:04	2026-09-25 15:04	SMH	SMH261030C00630000	call	630.0000	2026-10-30	16.2500	15.7500	16.3500	606.0000	26000.00	24375.00	1625.00	16	7	39	152	0.256578947368421	0.33353762893325	0.33353762893325	false	false	false	true
bd3e579b-4922-4787-b7bc-89d0453650f5	2026-09-25 15:03	2026-09-25 15:03	2026-09-25 15:03	SMH	SMH261009P00577500	put	577.5000	2026-10-09	4.9000	4.5500	4.9000	605.0000	13230.00	13230.00	0.00	27	11	64	46	1.39130434782609	0.330150991488839	0.330150991488839	false	false	false	true
0847dc26-c85f-4930-895f-dc6e17084621	2026-09-25 14:59	2026-09-25 14:59	2026-09-25 14:59	SMH	SMH260929C00612500	call	612.5000	2026-09-29	3.2500	3.1500	3.5000	606.0000	12025.00	325.00	11700.00	37	15	398	5	79.6	0.226317523255511	0.227490022669625	true	false	false	true
cdb23e70-795f-4085-b660-89e25a546e7e	2026-09-25 14:59	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00640000	call	640.0000	2026-11-20	21.4600	21.4500	22.0000	606.0000	12875.00	0.00	12875.00	6	6	230	877	0.262257696693273	0.352498683591284	0.352498683591284	true	false	false	true
629406c3-802b-4b93-972a-d5dadd22edb7	2026-09-25 14:59	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261030C00700000	call	700.0000	2026-10-30	2.8800	2.8800	3.1000	606.0000	12960.00	0.00	12960.00	45	19	292	117	2.4957264957265	0.337764427760374	0.337764427760374	true	false	false	true
e50e098a-1da8-42ab-93ad-67c8df02fb20	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00620000	call	620.0000	2026-11-20	29.5500	29.5000	29.8500	606.0000	115244.00	2954.00	112290.00	39	16	235	1319	0.178165276724792	0.357872472843749	0.357817360006	true	false	false	true
da5b6d7c-2f16-45fb-ab3e-73856b9611b8	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH270115C00620000	call	620.0000	2027-01-15	45.5000	45.5000	45.5500	606.0000	113750.00	0.00	113750.00	25	6	35	1346	0.0260029717682021	0.358372038193534	0.358216068623924	false	false	false	true
d9d5c6b3-10c2-4ed5-92a1-1afd5dbf45f2	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120P00580000	put	580.0000	2026-11-20	21.4000	21.4000	21.9000	606.0000	380928.00	0.00	380928.00	178	22	194	599	0.323873121869783	0.372427711298132	0.372543070310787	false	false	false	true
c6455bff-abee-42d5-be2e-2d5355ca2aaa	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00660000	call	660.0000	2026-11-20	15.3000	15.3000	15.3500	606.0000	185140.00	0.00	185140.00	121	21	152	1155	0.131601731601732	0.350459449127273	0.350495936821762	false	false	false	true
c2a312be-4ba0-4ba5-9c45-2c84260064c9	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00635000	call	635.0000	2026-11-20	23.3100	23.3000	23.9000	606.0000	179458.00	0.00	179458.00	77	12	102	1437	0.0709812108559499	0.353858195328248	0.353902491840208	false	false	false	true