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.

523,327 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts523,327 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

3b7cf23f-1f68-4f75-b24c-9973d9f21900	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	SMH	SMH261023C00630000	call	630.0000	2026-10-23	8.9000	8.6000	8.9000	597.6550	42720.00	42720.00	0.00	48	12	58	262	0.221374045801527	0.323656068229527	0.323656068229527	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-28T14:15:56.070001Z"}	2026-09-28	2026-09-28 21:15	2026-09-28 21:15
f06a25eb-1ecd-4feb-8f60-dba2be30e13c	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	SMH	SMH261016C00600000	call	600.0000	2026-10-16	16.7000	16.2000	16.7500	597.5500	36744.00	36744.00	0.00	22	11	211	12539	0.0168274982055985	0.32691097227254	0.327666582671225	true	false	false	true
d3b4b672-1483-41e5-9199-bada03499928	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	SMH	SMH261016C00605000	call	605.0000	2026-10-16	14.3500	14.1000	14.3500	597.6150	40180.00	40180.00	0.00	28	11	40	1902	0.0210304942166141	0.324484286582533	0.324484286582533	false	false	false	true
afe0fdb2-8c5c-4320-b6fc-e591ca77cac1	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	SMH	SMH261016C00600000	call	600.0000	2026-10-16	16.7500	16.2500	16.7500	597.6150	108875.00	108875.00	0.00	65	15	276	12539	0.0220113246670388	0.327237537913959	0.327237537913959	false	false	false	true
76a93eaa-1454-42a8-a450-6119cdaaec74	2026-09-28 10:15	2026-09-28 10:15	2026-09-28 10:15	SMH	SMH261016C00602500	call	602.5000	2026-10-16	15.5000	15.0500	15.5000	597.6150	55800.00	55800.00	0.00	36	15	36	25	1.44	0.325454827953325	0.325454827953325	false	false	false	true
8ff0eec0-14c3-4371-9642-a85be1b77cf0	2026-09-28 10:14	2026-09-28 10:14	2026-09-28 10:14	SMH	SMH261016P00550000	put	550.0000	2026-10-16	3.8000	3.7000	4.0000	597.0750	51672.00	50912.00	760.00	136	24	420	8299	0.0506085070490421	0.371894115189624	0.371894115189624	true	false	false	true
2b8a9cdf-bbe9-4ef0-b7ab-156101800286	2026-09-28 10:14	2026-09-28 10:14	2026-09-28 10:14	SMH	SMH260929C00602500	call	602.5000	2026-09-29	2.1800	2.1700	2.5300	597.3600	122078.00	0.00	121644.00	560	39	588	262	2.24427480916031	0.338709653234966	0.338709653234966	true	false	false	true
21a1c6d2-3b99-4f02-98d2-2886cf7f6cbe	2026-09-28 10:14	2026-09-28 10:14	2026-09-28 10:14	SMH	SMH260929C00605000	call	605.0000	2026-09-29	1.4600	1.4600	1.7500	597.3600	32560.00	0.00	32560.00	223	32	235	90	2.61111111111111	0.335049740104571	0.335049740104571	false	false	false	true
657129de-c557-4748-b1a8-947cf2ca492c	2026-09-28 10:14	2026-09-28 10:14	2026-09-28 10:14	SMH	SMH261016P00510000	put	510.0000	2026-10-16	1.0600	0.9800	1.1800	597.4850	15264.00	14840.00	424.00	144	23	154	4057	0.0379590830663052	0.433893663323699	0.433893663323699	false	false	false	true
ca81ce30-c3da-488b-aaac-283d4cc87aa5	2026-09-28 10:12	2026-09-28 10:12	2026-09-28 10:12	SMH	SMH261005P00595000	put	595.0000	2026-10-05	8.8000	6.3000	8.8000	597.3290	46635.00	45755.00	0.00	53	26	53	59	0.898305084745763	0.307820471654454	0.307820471654454	true	false	false	true
a1487a15-113c-47bf-970d-b3dd8a36a069	2026-09-28 10:11	2026-09-28 10:11	2026-09-28 10:11	SMH	SMH261120C00610000	call	610.0000	2026-11-20	29.1000	29.1000	29.9000	598.3500	14550.00	0.00	14550.00	5	5	34	819	0.0415140415140415	0.359793881300781	0.359793881300781	false	false	false	true
102a6f28-cf90-41ae-976a-c249d3455560	2026-09-28 10:11	2026-09-28 10:11	2026-09-28 10:11	SMH	SMH261023P00617500	put	617.5000	2026-10-23	30.5000	27.9500	30.5000	598.4700	24400.00	24400.00	0.00	8	8	8	3	2.66666666666667	0.326591998300159	0.326591998300159	false	false	false	true
a580d6fa-40ff-4964-afcf-7a12410d2db5	2026-09-28 10:11	2026-09-28 10:11	2026-09-28 10:11	SMH	SMH260928P00600000	put	600.0000	2026-09-28	2.9800	2.6700	2.9900	598.7500	14916.00	14916.00	0.00	50	7	369	647	0.57032457496136	0.376790464199796	0.376790464199796	false	false	false	true
a9119f9d-70ba-4ad9-8fc2-5c3d665dfb2a	2026-09-28 10:11	2026-09-28 10:11	2026-09-28 10:11	SMH	SMH261005P00597500	put	597.5000	2026-10-05	9.3500	7.6500	9.3500	598.5000	22435.00	22435.00	0.00	24	14	24	4	6	0.304773686673474	0.304773686673474	true	false	false	true
d5456397-6824-444f-afd8-7821b7069a56	2026-09-28 10:11	2026-09-28 10:10	2026-09-28 10:10	SMH	SMH261016P00605000	put	605.0000	2026-10-16	19.8500	19.2000	19.8500	598.6800	45655.00	45655.00	0.00	23	11	54	282	0.191489361702128	0.322435588776795	0.322435588776795	true	false	false	true
cbe2866e-e000-4d42-ab86-8e86fe60bc3d	2026-09-28 10:11	2026-09-28 10:10	2026-09-28 10:10	SMH	SMH261016P00565000	put	565.0000	2026-10-16	5.7500	5.4500	5.8000	598.5800	15513.00	14938.00	575.00	27	7	40	2164	0.0184842883548983	0.350966857847756	0.350418898038234	true	false	false	true
98edd584-7760-40ef-8993-bb8f74703e43	2026-09-28 10:11	2026-09-28 10:10	2026-09-28 10:10	SMH	SMH261016P00585000	put	585.0000	2026-10-16	11.0500	11.0000	11.0500	598.5800	89505.00	89505.00	0.00	81	11	114	3304	0.0345036319612591	0.333770065642457	0.333054295734195	false	false	false	true
8342295b-10fe-4390-83d1-9a63483c7ee0	2026-09-28 10:11	2026-09-28 10:10	2026-09-28 10:10	SMH	SMH261016P00567500	put	567.5000	2026-10-16	6.2500	5.9500	6.3000	598.5800	25000.00	24375.00	625.00	40	15	40	69	0.579710144927536	0.348390859568877	0.347826463346607	true	false	false	true
1aa27670-7c73-489b-b991-fe0c1dcf374d	2026-09-28 10:11	2026-09-28 10:10	2026-09-28 10:10	SMH	SMH261009P00597500	put	597.5000	2026-10-09	12.3500	11.8500	12.4000	598.6800	55575.00	35815.00	19760.00	45	10	73	222	0.328828828828829	0.320884542092545	0.320884542092545	true	false	false	true
a0ed4ae3-a932-4ae8-8d55-fbae55153def	2026-09-28 10:10	2026-09-28 10:10	2026-09-28 10:10	SMH	SMH261001P00595000	put	595.0000	2026-10-01	6.1500	4.4500	6.1500	598.9200	37515.00	37515.00	0.00	61	21	61	24	2.54166666666667	0.372534031810037	0.372534031810037	false	false	false	true
097afd1a-6eec-4acf-82ea-2e6cd467375c	2026-09-28 10:10	2026-09-28 10:10	2026-09-28 10:10	SMH	SMH261009P00580000	put	580.0000	2026-10-09	5.9500	5.5500	6.0000	598.9550	13080.00	1785.00	11295.00	22	5	43	101	0.425742574257426	0.332804480696455	0.332804480696455	true	false	false	true
f486cbe8-88db-4687-a204-b061cccee71d	2026-09-28 10:08	2026-09-28 10:08	2026-09-28 10:08	SMH	SMH260929C00612500	call	612.5000	2026-09-29	0.6700	0.6700	0.8000	600.1250	38659.00	0.00	38659.00	577	48	633	292	2.16780821917808	0.338074388226495	0.338074388226495	false	false	false	true
3c474baa-659b-4fc0-b628-50583f5d2fc9	2026-09-28 10:08	2026-09-28 10:08	2026-09-28 10:08	SMH	SMH260929C00615000	call	615.0000	2026-09-29	0.4500	0.4500	0.5600	600.1250	12307.00	1012.00	11295.00	273	30	276	138	2	0.34521655603096	0.34521655603096	false	false	false	true
3c28e7d1-da04-4816-9d52-43e1d1f105ef	2026-09-28 10:06	2026-09-28 10:06	2026-09-28 10:06	SMH	SMH261120P00500000	put	500.0000	2026-11-20	5.1500	4.8500	5.3500	599.7400	13905.00	13390.00	515.00	27	12	256	5307	0.0482381759939702	0.419955168212032	0.419955168212032	false	false	false	true
d0347e80-a163-442e-825a-8223140fa5a8	2026-09-28 10:02	2026-09-28 10:02	2026-09-28 10:02	SMH	SMH261016C00612500	call	612.5000	2026-10-16	12.6000	12.6000	13.0500	601.4100	23940.00	0.00	23940.00	19	7	19	236	0.0805084745762712	0.31809661924663	0.31809661924663	false	false	false	true
584265ac-65ea-489b-84f4-a0d8665be50a	2026-09-28 09:56	2026-09-28 09:56	2026-09-28 09:56	SMH	SMH261002C00575000	call	575.0000	2026-10-02	28.8500	27.4500	28.8500	601.0000	46160.00	46160.00	0.00	16	9	46	1957	0.0235053653551354	0.416377686606534	0.416377686606534	true	false	false	true
c517c822-1a63-4c75-81e4-f67af5e32174	2026-09-28 09:54	2026-09-28 09:54	2026-09-28 09:54	SMH	SMH270115P00530000	put	530.0000	2027-01-15	18.8500	18.4500	18.8500	601.6900	205465.00	205465.00	0.00	109	5	1179	3989	0.295562797693658	0.395150583503813	0.395150583503813	true	false	false	true
3a89ed3a-2d18-4550-9937-e0c70028420e	2026-09-28 09:50	2026-09-28 09:50	2026-09-28 09:50	SMH	SMH261218C00640000	call	640.0000	2026-12-18	27.1000	27.0000	27.1000	601.5500	271000.00	271000.00	0.00	100	5	206	301	0.684385382059801	0.356356997713975	0.356356997713975	true	false	false	true
f6c76202-de59-4aaa-b234-5acffd65aaa5	2026-09-28 09:49	2026-09-28 09:49	2026-09-28 09:49	SMH	SMH261009C00610000	call	610.0000	2026-10-09	10.4000	10.0500	10.8500	602.1100	16640.00	1040.00	15600.00	16	11	38	471	0.0806794055201698	0.326114596760258	0.326114596760258	true	false	false	true
dff87c9b-09a2-4932-a2ea-6271797ab6d3	2026-09-28 09:47	2026-09-28 09:47	2026-09-28 09:47	SMH	SMH261009C00605000	call	605.0000	2026-10-09	12.9000	12.4500	12.9000	602.0250	21930.00	21930.00	0.00	17	8	24	269	0.0892193308550186	0.334986017396111	0.334986017396111	false	false	false	true
073b14f8-92c3-4d10-808d-2ae065f0404a	2026-09-28 09:47	2026-09-28 09:47	2026-09-28 09:47	SMH	SMH261023P00587500	put	587.5000	2026-10-23	14.3500	14.1500	15.4000	601.7800	33000.00	1440.00	31560.00	23	10	48	72	0.666666666666667	0.34494274721272	0.343070256808643	true	false	false	true
2a13e14e-7a26-4244-a1f2-5cd69341b45c	2026-09-28 09:46	2026-09-28 09:46	2026-09-28 09:46	SMH	SMH261016P00560000	put	560.0000	2026-10-16	4.8000	4.6500	4.9500	601.2589	24000.00	12000.00	12000.00	50	7	69	5333	0.0129383086442903	0.367841791346944	0.367841791346944	false	false	false	true
dd0f7600-24cf-498f-9bad-081cece78d30	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SMH	SMH261009P00585000	put	585.0000	2026-10-09	7.2500	6.8500	7.3000	601.4750	21025.00	15265.00	5760.00	29	6	42	361	0.116343490304709	0.346437573817106	0.347805438955726	true	false	false	true
a9515e28-0bca-4f08-bdd0-ac5fb4bf9afa	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SMH	SMH261023P00587500	put	587.5000	2026-10-23	14.5000	13.9000	14.8000	601.1300	36255.00	33350.00	1460.00	25	8	25	72	0.347222222222222	0.344497172536525	0.344934798493212	true	false	false	true
31773db4-6e77-4f5a-9d71-129c43c79cc2	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SMH	SMH261009P00587500	put	587.5000	2026-10-09	8.0000	7.6000	8.0500	601.4750	15200.00	12810.00	2390.00	19	9	45	476	0.0945378151260504	0.343912688928962	0.345236904425369	true	false	false	true
162c86f7-b43b-4ebf-acd6-5a67949f11d5	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SMH	SMH261023P00580000	put	580.0000	2026-10-23	11.9000	11.4000	12.0000	601.3300	35695.00	33320.00	2375.00	30	8	44	82	0.536585365853659	0.348354478002043	0.34924453349374	true	false	false	true
0469ffb1-50bd-4b80-a952-9715f24f38e6	2026-09-28 09:45	2026-09-28 09:45	2026-09-28 09:45	SMH	SMH261009P00557500	put	557.5000	2026-10-09	2.3500	2.1500	2.3500	601.4750	43631.00	36641.00	0.00	186	6	186	69	2.69565217391304	0.382994057104004	0.383482981106176	false	false	false	true
9ec4fccd-3c4b-43b2-918b-0ccf76f2d338	2026-09-28 09:44	2026-09-28 09:44	2026-09-28 09:44	SMH	SMH261005C00617500	call	617.5000	2026-10-05	4.5500	3.8500	6.6000	601.6700	21835.00	0.00	21835.00	48	8	48	45	1.06666666666667	0.311540717014103	0.308010013174863	false	false	false	true
8d4b3b6c-4f5c-4a87-b89e-9a435b738cb1	2026-09-28 09:42	2026-09-28 09:42	2026-09-28 09:42	SMH	SMH261016P00550000	put	550.0000	2026-10-16	3.2500	3.0500	3.2500	602.9400	75075.00	75075.00	0.00	231	41	246	8299	0.0296421255572961	0.380111209213594	0.380111209213594	true	false	false	true
0351b081-8c4a-4e3a-b74d-49d84ae60378	2026-09-28 09:39	2026-09-28 09:39	2026-09-28 09:39	SMH	SMH261005C00645000	call	645.0000	2026-10-05	1.1000	0.8300	1.4000	603.6400	11221.00	110.00	11111.00	102	9	105	2	52.5	0.340147148223254	0.340147148223254	false	false	false	true
a29e5524-9531-4536-afbc-a34112519465	2026-09-28 09:38	2026-09-28 09:37	2026-09-28 09:37	SMH	SMH270115C00610000	call	610.0000	2027-01-15	48.2000	47.8500	50.0000	604.2725	612135.00	77115.00	535020.00	127	23	140	1561	0.0896860986547085	0.35908090150261	0.358698808463369	true	false	false	true
2de75bd1-89c6-4248-84f6-78e1f0cbd448	2026-09-28 09:37	2026-09-28 09:37	2026-09-28 09:37	SMH	SMH270115C00650000	call	650.0000	2027-01-15	31.3500	31.3500	33.7000	604.0000	1122335.00	0.00	1122335.00	358	40	358	8101	0.0441920750524627	0.353002201384754	0.353002201384754	false	false	false	true
dd27378f-5d92-417b-a2ef-a53076c13673	2026-09-28 09:36	2026-09-28 09:35	2026-09-28 09:35	SMH	SMH261120P00500000	put	500.0000	2026-11-20	5.0000	4.9500	5.0000	603.7700	10000.00	10000.00	0.00	20	9	92	5307	0.0173355944978331	0.426378789994505	0.426378789994505	true	false	false	true
a635043d-96d3-4103-88e4-0598eb16848b	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	SMH	SMH261016P00585000	put	585.0000	2026-10-16	9.5000	8.8000	9.5000	605.0700	15200.00	15200.00	0.00	16	6	28	3304	0.00847457627118644	0.345293258025956	0.345293258025956	false	false	false	true
8a96059d-706a-4838-8b73-e84fdd6b34a8	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	SMH	SMH261030C00675000	call	675.0000	2026-10-30	5.0000	5.0000	5.4500	605.2200	11000.00	0.00	11000.00	22	6	22	537	0.0409683426443203	0.342707004326955	0.342707004326955	false	false	false	true
2fba6797-7e70-46af-b651-ece06825d9ef	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	SMH	SMH261016C00600000	call	600.0000	2026-10-16	21.5000	21.5000	22.0000	605.6500	36550.00	0.00	36550.00	17	9	57	12539	0.0045458170508015	0.335012723346651	0.335012723346651	false	false	false	true
c61a93c4-a2e7-410f-82ee-9abaf07212bb	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	SMH	SMH261120C00645000	call	645.0000	2026-11-20	19.1000	18.9000	20.0500	605.8900	11460.00	1905.00	9555.00	6	6	6	281	0.0213523131672598	0.357208932526626	0.356632389461016	true	false	false	true
b12c58bb-f964-4d14-b627-ed750f6e86ab	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	SMH	SMH261106C00635000	call	635.0000	2026-11-06	16.9800	16.7000	17.8000	605.8900	16980.00	1675.00	15305.00	10	10	10	11	0.909090909090909	0.349693990101117	0.3463677262995	true	false	false	true
9bec671a-d334-487e-acf7-4c9ee3a0addb	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	SMH	SMH261030C00645000	call	645.0000	2026-10-30	10.9000	10.9000	11.5000	605.9100	20710.00	0.00	20710.00	19	6	19	51	0.372549019607843	0.340658508846521	0.340658508846521	false	false	false	true
e4013a61-5453-4dfd-893f-6c0b3b56fca6	2026-09-28 09:34	2026-09-28 09:34	2026-09-28 09:34	SMH	SMH261009C00620000	call	620.0000	2026-10-09	8.5500	8.5500	9.3500	606.6850	23945.00	0.00	23945.00	28	23	60	770	0.0779220779220779	0.327524433654301	0.328409370855922	true	false	false	true