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.

609,118 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts609,118 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/flow-alerts×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

2edb0f69-7ab4-45f4-a33e-ce072684ed6f	2026-09-30 09:32	2026-09-30 09:32	2026-09-30 09:32	SMH	SMH261001C00622500	call	622.5000	2026-10-01	1.6800	0.9800	2.0200	610.7850	10567.00	5851.00	4716.00	63	11	65	21	3.0952380952381	0.438792679148966	0.44463673936199	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	74795493331.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-30T13:33:11.727621Z"}	2026-09-30	2026-09-30 21:15	2026-09-30 21:15
291fccd8-33ff-40eb-897a-2b41173c0009	2026-09-30 09:32	2026-09-30 09:32	2026-09-30 09:32	SMH	SMH261001C00615000	call	615.0000	2026-10-01	3.6500	3.6500	4.3000	610.7800	25915.00	0.00	25915.00	71	11	75	544	0.137867647058824	0.427862273402316	0.428019940206215	true	false	false	true
38ac4b88-64c6-44ce-a479-ca70f197e3b1	2026-09-30 09:32	2026-09-30 09:32	2026-09-30 09:32	SMH	SMH261016C00640000	call	640.0000	2026-10-16	6.7600	6.2000	6.8500	611.7400	82525.00	74425.00	8100.00	122	24	435	4380	0.0993150684931507	0.325150608807504	0.326323631136254	true	false	false	true
605268d5-9ce5-4791-b0bf-b1cc1383577d	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SMH	SMH261016C00640000	call	640.0000	2026-10-16	6.7500	5.8000	6.7500	611.3650	203120.00	202470.00	650.00	301	23	301	4380	0.0687214611872146	0.327553165310695	0.321643659517394	true	false	false	true
57b6311d-3577-409f-b488-0fd91c603d5a	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SMH	SMH260930P00602500	put	602.5000	2026-09-30	1.0000	0.9500	1.3400	609.9250	11139.00	1648.00	9491.00	111	23	121	122	0.991803278688525	0.543303702805894	0.539239921966553	true	false	false	true
0b866585-5f9e-4b83-9d31-7e8b2febd9f7	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SMH	SMH260930P00600000	put	600.0000	2026-09-30	0.6700	0.6550	0.6900	609.9250	10720.00	1809.00	8911.00	160	26	186	304	0.611842105263158	0.566741578250482	0.563147150990973	true	false	false	true
8a1c9460-b5d0-4827-ada0-32d0c3500247	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SMH	SMH261016P00582500	put	582.5000	2026-10-16	6.3100	6.2500	6.8500	610.0299	10090.00	1270.00	8820.00	16	9	16	400	0.04	0.339218088304573	0.339218088304573	true	false	false	true
65cc03cc-6824-42ad-9b16-b890b05ea3b0	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SMH	SMH261016P00567500	put	567.5000	2026-10-16	3.7000	3.6500	4.0500	609.8750	22935.00	0.00	22935.00	62	19	62	117	0.52991452991453	0.356147129340518	0.353693724115106	true	false	false	true
46c46d45-c695-44f3-b23d-68de880ce7f3	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SMH	SMH261002P00600000	put	600.0000	2026-10-02	3.2500	3.2000	3.6000	610.0299	131695.00	325.00	131370.00	405	26	410	561	0.730837789661319	0.404304002768433	0.404304002768433	true	false	false	true
36ba1e9c-3f09-4fe9-98c6-a8a6aee5dcb4	2026-09-30 09:31	2026-09-30 09:31	2026-09-30 09:31	SMH	SMH261016P00585000	put	585.0000	2026-10-16	6.9000	6.8000	7.4500	610.0299	21400.00	6215.00	15185.00	31	7	31	3425	0.00905109489051095	0.337357481250298	0.33857156088105	true	false	false	true
dfd45ac6-57cd-40ef-b893-f11e71450313	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SMH	SMH261016C00630000	call	630.0000	2026-10-16	8.2500	7.8000	8.2500	607.0000	108900.00	108900.00	0.00	132	21	738	9282	0.0795087265675501	0.31705615643135	0.31705615643135	false	false	false	true
4cac59a8-9b79-4982-9e75-296140e2a0c1	2026-09-29 15:58	2026-09-29 15:58	2026-09-29 15:58	SMH	SMH261016C00625000	call	625.0000	2026-10-16	9.8500	9.4000	9.8500	607.0000	62050.00	62050.00	0.00	63	15	1417	11856	0.119517543859649	0.317721285230999	0.317721285230999	true	false	false	true
2ab4d273-56db-4970-bbdf-27f7646abe3e	2026-09-29 15:45	2026-09-29 15:45	2026-09-29 15:45	SMH	SMH261002P00607500	put	607.5000	2026-10-02	7.8000	7.3500	7.8500	606.6395	24960.00	7800.00	17160.00	32	27	316	209	1.51196172248804	0.340104779436547	0.340104779436547	true	false	false	true
cf2c3233-65da-47cc-9154-2364d418034c	2026-09-29 15:43	2026-09-29 15:43	2026-09-29 15:43	SMH	SMH261002C00612500	call	612.5000	2026-10-02	5.2000	5.1500	5.3000	607.1700	18720.00	520.00	18200.00	36	16	388	952	0.407563025210084	0.339457163784669	0.339457163784669	true	false	false	true
ffb0ec3e-ef18-4530-8928-c1f668c0ea99	2026-09-29 15:38	2026-09-29 15:38	2026-09-29 15:38	SMH	SMH261002C00612500	call	612.5000	2026-10-02	5.4000	5.3500	5.7000	607.0000	23220.00	0.00	23220.00	43	22	308	952	0.323529411764706	0.339567589926045	0.339567589926045	true	false	false	true
9776f643-f7e2-43eb-8be8-626b8608f696	2026-09-29 15:34	2026-09-29 15:34	2026-09-29 15:34	SMH	SMH261218P00630000	put	630.0000	2026-12-18	50.7000	49.5000	50.7000	607.3900	35490.00	35490.00	0.00	7	5	27	38	0.710526315789474	0.363965657406653	0.363965657406653	false	false	false	true
b1f7d23b-d298-4708-bceb-a70d85516988	2026-09-29 15:32	2026-09-29 15:32	2026-09-29 15:32	SMH	SMH261009C00612500	call	612.5000	2026-10-09	10.7000	10.4000	10.7500	607.5650	12835.00	8560.00	4275.00	12	7	49	99	0.494949494949495	0.315869355283001	0.315869355283001	false	false	false	true
f000dfa7-7870-4e7f-9ef9-0236219cca18	2026-09-29 15:32	2026-09-29 15:32	2026-09-29 15:32	SMH	SMH261218P00630000	put	630.0000	2026-12-18	50.6500	49.5000	50.7000	607.5300	101300.00	101300.00	0.00	20	10	20	38	0.526315789473684	0.36417865944336	0.36417865944336	false	false	false	true
b1025e5d-ea72-40a3-b990-b5370d26d81b	2026-09-29 15:32	2026-09-29 15:32	2026-09-29 15:32	SMH	SMH261009C00612500	call	612.5000	2026-10-09	10.6000	10.2000	10.6000	607.5000	10600.00	10600.00	0.00	10	5	37	99	0.373737373737374	0.3141061239874	0.3141061239874	false	false	false	true
4fe00c85-bf24-44db-ae9f-3fb0795c2405	2026-09-29 15:30	2026-09-29 15:30	2026-09-29 15:30	SMH	SMH261120C00550000	call	550.0000	2026-11-20	72.7000	72.7000	73.6500	607.4600	123590.00	0.00	123590.00	17	7	50	259	0.193050193050193	0.392607410952003	0.392607410952003	true	false	false	true
2292e5dc-3cdc-4c44-8463-d81dbac5dc4b	2026-09-29 15:28	2026-09-29 15:27	2026-09-29 15:27	SMH	SMH261009C00657500	call	657.5000	2026-10-09	1.0700	1.0700	1.0800	607.0000	20435.00	0.00	20435.00	191	17	191	0	0	0.320532495039163	0.320532495039163	true	false	false	true
0ddf7296-485b-4281-bcac-a8ae2756e1db	2026-09-29 15:28	2026-09-29 15:27	2026-09-29 15:27	SMH	SMH261009C00665000	call	665.0000	2026-10-09	0.7300	0.7300	0.7400	607.0000	15987.00	0.00	15987.00	219	23	226	221	1.02262443438914	0.327744443783369	0.327744443783369	true	false	false	true
9a9470ac-5053-454c-8ed1-4534e0a55ca7	2026-09-29 15:27	2026-09-29 15:27	2026-09-29 15:27	SMH	SMH261002C00647500	call	647.5000	2026-10-02	0.3200	0.3000	0.3900	607.0000	22495.00	33.00	22462.00	703	51	1400	130	10.7692307692308	0.387524197103336	0.383039656883725	false	false	false	true
579a2f44-0dd3-4c7e-b9aa-0d70d289443a	2026-09-29 15:22	2026-09-29 15:22	2026-09-29 15:22	SMH	SMH261016C00615000	call	615.0000	2026-10-16	13.8500	13.8000	14.0500	607.0000	15235.00	0.00	13850.00	11	6	1348	13857	0.0972793533953958	0.318282173311699	0.318282173311699	false	false	false	true
49e3b974-a301-48af-9ba5-f6974c7f9196	2026-09-29 15:22	2026-09-29 15:22	2026-09-29 15:22	SMH	SMH261218P00615000	put	615.0000	2026-12-18	42.5000	41.5500	42.5500	607.0000	195500.00	191250.00	4250.00	46	15	50	820	0.0609756097560976	0.367901795791084	0.367901795791084	false	false	false	true
a2043345-9da6-48a5-93e6-d9d2c02ac758	2026-09-29 15:20	2026-09-29 15:20	2026-09-29 15:20	SMH	SMH261120P00600000	put	600.0000	2026-11-20	28.0000	27.7000	28.3000	607.0000	25200.00	11200.00	2800.00	9	5	176	1403	0.125445473984319	0.367556584732175	0.367556584732175	false	false	false	true
36a7cc07-2154-4e35-b6ab-25573ad7cef2	2026-09-29 15:13	2026-09-29 15:13	2026-09-29 15:13	SMH	SMH261009C00645000	call	645.0000	2026-10-09	2.2000	2.1800	2.2500	607.7100	13205.00	0.00	13205.00	60	9	107	1161	0.0921619293712317	0.317841212598538	0.316491442039845	false	false	false	true
ec2483ef-525a-401d-abc8-72974a907881	2026-09-29 15:10	2026-09-29 15:10	2026-09-29 15:10	SMH	SMH260930P00597500	put	597.5000	2026-09-30	1.0500	0.9500	1.0600	607.9900	58065.00	57960.00	105.00	553	9	3420	160	21.375	0.356291187438907	0.356291187438907	false	false	false	true
70671fee-c752-4714-9b85-2890e847fd48	2026-09-29 15:10	2026-09-29 15:09	2026-09-29 15:09	SMH	SMH261016P00610000	put	610.0000	2026-10-16	17.3000	16.8500	17.3000	608.1200	22490.00	22490.00	0.00	13	11	172	330	0.521212121212121	0.323241663348161	0.323241663348161	true	false	false	true
3e51400a-f83a-4c83-a6e8-e4ec9385153f	2026-09-29 15:10	2026-09-29 15:09	2026-09-29 15:09	SMH	SMH261016P00617500	put	617.5000	2026-10-16	21.3500	20.1000	22.1500	608.1200	21350.00	19215.00	2135.00	10	8	10	32	0.3125	0.321134992896526	0.321134992896526	true	false	false	true
8f04983f-92ec-42e0-a339-0e39c87349fe	2026-09-29 15:07	2026-09-29 15:07	2026-09-29 15:07	SMH	SMH261016C00615000	call	615.0000	2026-10-16	14.3500	14.0500	14.3500	608.4500	684495.00	684495.00	0.00	477	14	846	13857	0.0610521757956268	0.321443889342367	0.321443889342367	true	false	false
2bb8a1c2-67cd-4974-8bb4-8964ffbc65e5	2026-09-29 15:05	2026-09-29 15:04	2026-09-29 15:04	SMH	SMH261002C00647500	call	647.5000	2026-10-02	0.3500	0.3500	0.4400	608.5000	24115.00	0.00	24115.00	689	55	697	130	5.36153846153846	0.387747160609087	0.387747160609087	false	false	false	true
679b0f89-36e5-4ce8-af3f-fc2ee1d58eae	2026-09-29 14:57	2026-09-29 14:57	2026-09-29 14:57	SMH	SMH261002C00620000	call	620.0000	2026-10-02	3.4000	3.2500	3.4000	608.4700	35700.00	35700.00	0.00	105	8	1026	2550	0.402352941176471	0.350610342649027	0.350610342649027	false	false	false	true
1bc429a6-75d8-482d-b214-8a4618801a21	2026-09-29 14:55	2026-09-29 14:55	2026-09-29 14:55	SMH	SMH261001P00577500	put	577.5000	2026-10-01	0.4100	0.3800	0.5200	608.5000	23327.00	0.00	23327.00	569	54	581	15	38.7333333333333	0.435448229829246	0.430089202639333	true	false	false	true
0ccdd973-2fc4-4f56-9dff-9ce8f05f7aad	2026-09-29 14:42	2026-09-29 14:42	2026-09-29 14:42	SMH	SMH261218P00525000	put	525.0000	2026-12-18	11.9000	11.9000	12.0500	608.5500	42840.00	0.00	34510.00	36	5	1739	1024	1.6982421875	0.40146695861727	0.40146695861727	false	false	false	true
dae3415a-309d-41d6-a3e7-7e96eee9e674	2026-09-29 14:41	2026-09-29 14:41	2026-09-29 14:41	SMH	SMH261218P00525000	put	525.0000	2026-12-18	11.9000	11.6000	12.0500	608.5600	27370.00	5950.00	21420.00	23	5	1669	1024	1.6298828125	0.40149085081641	0.40149085081641	false	false	false	true
69923e78-7a1b-4664-aa2d-e1eb1668c9ee	2026-09-29 14:41	2026-09-29 14:41	2026-09-29 14:41	SMH	SMH261218P00525000	put	525.0000	2026-12-18	11.9000	11.8500	12.0500	608.6800	24990.00	4760.00	15470.00	21	5	1645	1024	1.6064453125	0.401777483101034	0.401777483101034	false	false	false	true
9fd718a4-daef-4232-a32c-1409b0e9473c	2026-09-29 14:41	2026-09-29 14:41	2026-09-29 14:41	SMH	SMH261218P00525000	put	525.0000	2026-12-18	11.9000	11.9000	12.1000	608.7707	35700.00	0.00	14280.00	30	5	1624	1024	1.5859375	0.401994038630398	0.401994038630398	false	false	false	true
0fc7f7a1-28d3-4074-ba2f-f4d02091ac4d	2026-09-29 14:41	2026-09-29 14:41	2026-09-29 14:41	SMH	SMH271217P00610000	put	610.0000	2027-12-17	86.8500	85.0000	88.8500	608.7700	138960.00	0.00	138960.00	16	5	16	3	5.33333333333333	0.399150943591516	0.399150943591516	false	false	false	true
030c5ea5-fdab-4c26-9413-e9f3aa8403e1	2026-09-29 14:41	2026-09-29 14:41	2026-09-29 14:41	SMH	SMH261218P00525000	put	525.0000	2026-12-18	11.8500	11.7500	12.3000	608.6750	34365.00	0.00	34365.00	29	6	1552	1024	1.515625	0.401087268398857	0.401087268398857	false	false	false	true
d82cc5c1-85ca-41d6-aa37-4ee8ff9e5b80	2026-09-29 14:41	2026-09-29 14:40	2026-09-29 14:40	SMH	SMH261016P00600000	put	600.0000	2026-10-16	12.4500	12.1000	13.3500	608.0000	18680.00	1250.00	17430.00	15	6	934	6386	0.146257438145944	0.324690978672176	0.325679266303846	true	false	false	true
9cbaad0a-48df-4171-a3d7-06601002add4	2026-09-29 14:41	2026-09-29 14:40	2026-09-29 14:40	SMH	SMH260930C00600000	call	600.0000	2026-09-30	10.1000	8.8000	10.2500	608.0000	101000.00	101000.00	0.00	100	6	161	379	0.424802110817942	0.355840952903651	0.355840952903651	false	false	false	true
084f3b8a-7dff-4660-860f-1876d4301330	2026-09-29 14:23	2026-09-29 14:23	2026-09-29 14:23	SMH	SMH260930P00605000	put	605.0000	2026-09-30	2.8700	2.8700	3.2000	608.0000	10619.00	0.00	10619.00	37	5	192	29	6.62068965517241	0.336746677400938	0.336746677400938	false	false	false	true
d0f67851-b91e-4d7f-a7aa-97dcbb4f4128	2026-09-29 14:18	2026-09-29 14:17	2026-09-29 14:17	SMH	SMH260930C00622500	call	622.5000	2026-09-30	0.5500	0.5400	0.6500	608.0000	34705.00	110.00	34595.00	631	67	1066	51	20.9019607843137	0.351050296278869	0.351050296278869	true	false	false	true
c722faa5-806a-4c02-aaeb-426eefecaeac	2026-09-29 14:16	2026-09-29 14:16	2026-09-29 14:16	SMH	SMH261016C00635000	call	635.0000	2026-10-16	7.3000	7.1000	7.3000	608.0000	46720.00	46720.00	0.00	64	7	331	1996	0.165831663326653	0.320238745756562	0.320238745756562	false	false	false	true
dd0a6ded-6b15-4dd7-b748-0c82d3e61c6b	2026-09-29 14:16	2026-09-29 14:16	2026-09-29 14:16	SMH	SMH261016C00635000	call	635.0000	2026-10-16	7.2500	7.2500	7.3000	608.0000	48575.00	0.00	48575.00	67	5	229	1996	0.114729458917836	0.319634594570214	0.319634594570214	true	false	false	true
29fa5ed3-95f7-4729-a840-5466df83fd10	2026-09-29 14:08	2026-09-29 14:08	2026-09-29 14:08	SMH	SMH261001C00615000	call	615.0000	2026-10-01	3.5000	3.4000	3.8000	607.6750	10501.00	351.00	8400.00	30	18	885	64	13.828125	0.358374657058634	0.358374657058634	true	false	false	true
965f823e-dd07-4470-aee1-f90a7a8f5629	2026-09-29 14:05	2026-09-29 14:04	2026-09-29 14:04	SMH	SMH270115P00540000	put	540.0000	2027-01-15	20.0000	19.5500	20.0000	607.3800	72000.00	72000.00	0.00	36	12	107	1014	0.105522682445759	0.391767598372554	0.391767598372554	false	false	false	true
7028680f-eb8b-4940-9525-9a0a96dd7bc8	2026-09-29 14:02	2026-09-29 14:02	2026-09-29 14:02	SMH	SMH261001C00617500	call	617.5000	2026-10-01	2.6900	2.6300	2.9300	607.1900	13705.00	264.00	13441.00	51	12	154	42	3.66666666666667	0.362810320418781	0.359455313105024	true	false	false	true
7ce6c623-5729-4d62-84aa-f63ee88ebc55	2026-09-29 13:54	2026-09-29 13:53	2026-09-29 13:53	SMH	SMH261218P00525000	put	525.0000	2026-12-18	12.4000	12.3000	12.5500	606.2350	12400.00	4960.00	2480.00	10	5	1498	1024	1.462890625	0.40261153412447	0.40261153412447	false	false	false	true