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.

281,039 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts281,039 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active: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	pricenumeric

cfd0971e-be9a-4383-826b-f308328e5aaa	2026-09-21 12:57	2026-09-21 12:56	2026-09-21 12:56	SMH	SMH261218P00570000	put	570.0000	2026-12-18	29.1100	28.6500	29.2000	593.0800	81505.00	58315.00	23190.00	28	12	5667	3297	1.71883530482257	0.368924172908737	0.369384143914101	true	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	ETF	—	74084243802.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-21T17:02:00.389820Z"}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
2105768f-0c8c-40b7-a8bd-eba9c5ef3335	2026-09-21 12:56	2026-09-21 12:55	2026-09-21 12:55	SMH	SMH261009C00590000	call	590.0000	2026-10-09	19.4500	18.4000	19.5500	593.0000	25290.00	21395.00	1950.00	13	10	92	72	1.27777777777778	0.329668397466891	0.330628620193153	true	false	false	true	false
d5371fd1-eb67-4c36-85e2-0ba1036707f5	2026-09-21 12:53	2026-09-21 12:53	2026-09-21 12:53	SMH	SMH260921C00595000	call	595.0000	2026-09-21	0.6700	0.6700	0.8600	592.0000	65995.00	0.00	65995.00	985	51	2573	33	77.969696969697	0.346649098417989	0.347021464100535	false	false	false	true	false
394ed1cf-5bec-4b6d-a9ea-323469695847	2026-09-21 12:50	2026-09-21 12:49	2026-09-21 12:49	SMH	SMH260921P00590000	put	590.0000	2026-09-21	0.8100	0.6400	0.9100	592.7500	16127.00	4131.00	11996.00	200	11	945	0	0	0.415368706273828	0.418019539080285	false	false	false	true	false
90c6cb1c-4561-4354-8200-d4cdb58e075b	2026-09-21 12:48	2026-09-21 12:48	2026-09-21 12:48	SMH	SMH261016C00600000	call	600.0000	2026-10-16	18.1500	18.0500	18.1500	592.8600	10890.00	10890.00	0.00	6	5	2809	11983	0.234415421847617	0.334410845953285	0.334410845953285	true	false	false	true	false
7592b67f-8d13-42d2-a8fb-118ce8bce4dc	2026-09-21 12:48	2026-09-21 12:48	2026-09-21 12:48	SMH	SMH260925C00610000	call	610.0000	2026-09-25	2.2100	2.1300	2.2200	592.9100	11492.00	11492.00	0.00	52	5	2548	338	7.53846153846154	0.316660115915698	0.316370258149816	false	false	false	true	false
cc3ce66d-1e73-4bc5-980f-6b104c4c0326	2026-09-21 12:45	2026-09-21 12:45	2026-09-21 12:45	SMH	SMH260922P00590000	put	590.0000	2026-09-22	2.9200	2.8000	2.9200	592.6500	71832.00	71832.00	0.00	246	9	1590	0	0	0.334993986679745	0.334993986679745	false	false	false	true	false
fd9ceb91-02c4-493b-93df-2c5f3115037f	2026-09-21 12:43	2026-09-21 12:43	2026-09-21 12:43	SMH	SMH270115P00595000	put	595.0000	2027-01-15	45.2600	45.2000	45.6000	592.8000	31680.00	18105.00	13575.00	7	6	129	187	0.689839572192513	0.363005718492181	0.363005718492181	false	false	false	true	false
81ae86a3-1f3b-4317-9e78-295cf9eb8662	2026-09-21 12:43	2026-09-21 12:43	2026-09-21 12:43	SMH	SMH270617P00600000	put	600.0000	2027-06-17	69.7000	68.7000	70.0000	592.6400	216070.00	209100.00	6970.00	31	7	31	621	0.0499194847020934	0.377562194404243	0.377562194404243	false	false	false	true	false
45f0f127-b45f-40a2-8f48-0ef332d7a35e	2026-09-21 12:42	2026-09-21 12:42	2026-09-21 12:42	SMH	SMH261016P00535000	put	535.0000	2026-10-16	3.9500	3.9000	4.0500	592.7500	20145.00	1580.00	18565.00	51	6	909	13288	0.0684075857916917	0.373567024154693	0.373567024154693	false	false	false	true	false
c9cc062b-ae37-4364-9929-a47a65a31b2a	2026-09-21 12:41	2026-09-21 12:41	2026-09-21 12:41	SMH	SMH260921C00595000	call	595.0000	2026-09-21	0.7600	0.7300	0.7600	592.6800	11704.00	11704.00	0.00	154	16	1542	33	46.7272727272727	0.361610731860564	0.361610731860564	false	false	false	true	false
f00402a5-39a9-4003-9f99-f8381c7f198a	2026-09-21 12:40	2026-09-21 12:40	2026-09-21 12:40	SMH	SMH261016P00530000	put	530.0000	2026-10-16	3.5000	3.4000	3.5000	592.4700	13299.00	13299.00	0.00	38	12	349	8161	0.0427643671118735	0.381017331136309	0.381017331136309	false	false	false	true	false
e7222212-c7c5-48e8-972a-59204b833021	2026-09-21 12:39	2026-09-21 12:39	2026-09-21 12:39	SMH	SMH261030C00620000	call	620.0000	2026-10-30	16.6500	16.3500	17.1000	592.5090	13320.00	0.00	13320.00	8	5	129	73	1.76712328767123	0.345907938609357	0.345907938609357	true	false	false	true	false
73a63eca-328b-4983-afc5-83a0f2062b59	2026-09-21 12:38	2026-09-21 12:38	2026-09-21 12:38	SMH	SMH261030P00575000	put	575.0000	2026-10-30	18.3000	17.7000	18.3000	592.7400	10980.00	10980.00	0.00	6	6	8	0	0	0.358735975555614	0.358735975555614	false	false	false	true	false
ab5b47e7-0b6a-4cdf-bf47-ef3ab371f889	2026-09-21 12:36	2026-09-21 12:36	2026-09-21 12:36	SMH	SMH260921C00595000	call	595.0000	2026-09-21	0.6800	0.6800	0.7800	593.0050	28220.00	0.00	28220.00	415	10	1254	33	38	0.313821576504133	0.313821576504133	false	false	false	true	false
356ae692-a309-40f1-b947-1fe953573afa	2026-09-21 12:36	2026-09-21 12:36	2026-09-21 12:36	SMH	SMH261016C00630000	call	630.0000	2026-10-16	8.0000	7.7000	8.0000	593.1700	199916.00	199916.00	0.00	250	20	3674	2157	1.70329160871581	0.330543514183332	0.330543514183332	true	false	false	true	false
6c97c0dc-515a-40ba-97ac-2652b4d3123e	2026-09-21 12:35	2026-09-21 12:35	2026-09-21 12:35	SMH	SMH261016C00650000	call	650.0000	2026-10-16	4.2000	4.1500	4.3000	593.3000	33600.00	30240.00	3360.00	80	12	1477	3377	0.437370447142434	0.328724433884152	0.328724433884152	true	false	false	true	false
a5102095-c1c3-4816-84cc-a0fc0f03947a	2026-09-21 12:34	2026-09-21 12:34	2026-09-21 12:34	SMH	SMH261016C00650000	call	650.0000	2026-10-16	4.1900	4.1000	4.2000	593.1000	21804.00	21804.00	0.00	52	8	1385	3377	0.410127331951436	0.32957498234131	0.32957498234131	true	false	false	true	false
29f68af6-edd1-4588-a95e-3f435022e494	2026-09-21 12:33	2026-09-21 12:33	2026-09-21 12:33	SMH	SMH261016C00640000	call	640.0000	2026-10-16	5.8300	5.7000	5.9000	593.1800	20391.00	20391.00	0.00	35	5	318	2270	0.140088105726872	0.32888006570891	0.32888006570891	false	false	false	true	false
84ba45bb-6143-469b-b66f-7d4710c96bc9	2026-09-21 12:33	2026-09-21 12:33	2026-09-21 12:33	SMH	SMH260930C00595000	call	595.0000	2026-09-30	10.6000	10.5000	10.9000	593.1800	10600.00	6360.00	2120.00	10	5	90	139	0.647482014388489	0.301332589343979	0.301332589343979	false	false	false	true	false
2828b382-f721-4206-8649-4b75cf548d5c	2026-09-21 12:33	2026-09-21 12:33	2026-09-21 12:33	SMH	SMH261002C00567500	call	567.5000	2026-10-02	30.8500	29.4000	31.3000	593.1800	15425.00	9235.00	6190.00	5	5	9	200	0.045	0.328386550728263	0.350201021741467	false	false	false	true	false
446639a2-4553-4055-af17-f407d85e20aa	2026-09-21 12:33	2026-09-21 12:33	2026-09-21 12:33	SMH	SMH261016P00535000	put	535.0000	2026-10-16	3.9000	3.9000	4.2000	593.3000	19110.00	0.00	19110.00	49	11	754	13288	0.056742925948224	0.374214499277062	0.374214499277062	false	false	false	true	false
1bd221f9-8c88-4de6-945c-bc4a07e72a5f	2026-09-21 12:31	2026-09-21 12:31	2026-09-21 12:31	SMH	SMH261023P00510000	put	510.0000	2026-10-23	3.0500	3.0500	3.2000	592.0000	16170.00	0.00	16170.00	53	14	67	99	0.676767676767677	0.403042419012706	0.402688299963019	false	false	false	true	false
b005abf5-150e-472a-b9a3-3922a8a55ee7	2026-09-21 12:31	2026-09-21 12:30	2026-09-21 12:30	SMH	SMH261016P00535000	put	535.0000	2026-10-16	4.0000	3.9500	4.1000	592.0000	14800.00	3600.00	10800.00	37	10	691	13288	0.052001806140879	0.3741112378118	0.3741112378118	false	false	false	true	false
0e11c08e-0d5d-4983-9998-6662b09cabd9	2026-09-21 12:29	2026-09-21 12:29	2026-09-21 12:29	SMH	SMH261016P00535000	put	535.0000	2026-10-16	4.0600	4.0000	4.1500	592.2600	20279.00	7290.00	12989.00	50	5	629	13288	0.0473359422034919	0.374643250378608	0.374643250378608	false	false	false	true	false
4caea48a-cb25-477a-ac27-6526b8e463c3	2026-09-21 12:27	2026-09-21 12:27	2026-09-21 12:27	SMH	SMH261016P00535000	put	535.0000	2026-10-16	4.0500	4.0500	4.3000	592.1500	19849.00	0.00	19849.00	49	14	574	13288	0.0431968693558098	0.37420425153406	0.37420425153406	false	false	false	true	false
0d833ca8-f82f-46cc-a022-efee4f69f82e	2026-09-21 12:27	2026-09-21 12:27	2026-09-21 12:27	SMH	SMH270115P00590000	put	590.0000	2027-01-15	43.0100	42.9500	43.2500	592.1500	25805.00	4305.00	21500.00	6	5	15	588	0.0255102040816327	0.363059428173278	0.363441420348576	false	false	false	true	false
2b848fec-900c-49b5-a0d3-b3328d7d2117	2026-09-21 12:25	2026-09-21 12:25	2026-09-21 12:25	SMH	SMH261002P00590000	put	590.0000	2026-10-02	12.0000	12.0000	12.5000	591.8944	31200.00	0.00	31200.00	26	13	103	26	3.96153846153846	0.324214390193683	0.324214390193683	false	false	false	true	false
b59fd07b-e242-486e-a121-9e47d6a2168d	2026-09-21 12:25	2026-09-21 12:24	2026-09-21 12:24	SMH	SMH261023C00700000	call	700.0000	2026-10-23	1.5300	1.4100	1.5300	591.7700	23103.00	23103.00	0.00	151	13	166	337	0.492581602373887	0.346833707335073	0.346833707335073	true	false	false	true	false
5ecdd869-0c90-4887-afd1-d3f5e62902a5	2026-09-21 12:25	2026-09-21 12:24	2026-09-21 12:24	SMH	SMH261016P00535000	put	535.0000	2026-10-16	4.1000	4.0500	4.1500	591.8300	20090.00	8610.00	11480.00	49	7	510	13288	0.0383804936785069	0.374422395816023	0.374422395816023	false	false	false	true	false
68857ee5-1748-4230-9545-a2bd21da13f9	2026-09-21 12:24	2026-09-21 12:23	2026-09-21 12:23	SMH	SMH261023C00675000	call	675.0000	2026-10-23	2.9200	2.7500	2.9200	591.6600	34745.00	34455.00	290.00	119	22	124	22	5.63636363636364	0.335827982425592	0.335827982425592	true	false	false	true	false
391036ad-2d5e-4ae1-a7a0-07bac83f1357	2026-09-21 12:24	2026-09-21 12:23	2026-09-21 12:23	SMH	SMH261030C00650000	call	650.0000	2026-10-30	8.3500	8.0500	8.3500	591.6600	17535.00	17535.00	0.00	21	5	28	12	2.33333333333333	0.34322693727494	0.34322693727494	false	false	false	true	false
e1f53acb-3317-4be9-bfde-a16004123e7b	2026-09-21 12:23	2026-09-21 12:23	2026-09-21 12:23	SMH	SMH261002P00585000	put	585.0000	2026-10-02	10.0000	10.0000	10.3000	591.5899	51002.00	0.00	51002.00	51	24	855	33	25.9090909090909	0.327382464484501	0.327382464484501	false	false	false	true	false
ad5b8d02-b060-418c-af51-3f822c1b3911	2026-09-21 12:23	2026-09-21 12:22	2026-09-21 12:22	SMH	SMH261002C00587500	call	587.5000	2026-10-02	16.0500	15.8000	16.2500	591.5600	14444.00	9629.00	4815.00	9	7	22	126	0.174603174603175	0.331767452204302	0.331767452204302	false	false	false	true	false
c4bdee13-e311-4e26-a025-a169a9bf2fd6	2026-09-21 12:21	2026-09-21 12:21	2026-09-21 12:21	SMH	SMH261002P00585000	put	585.0000	2026-10-02	10.2500	10.1000	10.2500	591.3500	775925.00	775925.00	0.00	757	9	804	33	24.3636363636364	0.331227947047589	0.331227947047589	false	false	false	true	false
1fa930ae-ee15-40d9-948e-d6ea8ea0191c	2026-09-21 12:16	2026-09-21 12:16	2026-09-21 12:16	SMH	SMH261016P00535000	put	535.0000	2026-10-16	4.1500	4.1500	4.2500	591.4400	20335.00	0.00	20335.00	49	9	395	13288	0.0297260686333534	0.374345142307108	0.374345142307108	false	false	false	true	false
9e302637-0c5e-4280-ae68-6f2abd901d4e	2026-09-21 12:11	2026-09-21 12:11	2026-09-21 12:11	SMH	SMH261120C00605000	call	605.0000	2026-11-20	30.0700	29.4500	30.1000	591.5000	18040.00	18040.00	0.00	6	5	24	724	0.0331491712707182	0.358202598232145	0.359248495349017	false	false	false	true	false
47f52a9f-b35a-4b1f-9d39-37793c1257f3	2026-09-21 12:11	2026-09-21 12:11	2026-09-21 12:11	SMH	SMH261120C00615000	call	615.0000	2026-11-20	25.8500	25.3000	25.9750	591.5000	51700.00	49115.00	2585.00	20	9	31	232	0.133620689655172	0.356954248647366	0.356954248647366	true	false	false	true	false
38f72578-db4f-4378-a456-70b5863bfaa7	2026-09-21 12:11	2026-09-21 12:11	2026-09-21 12:11	SMH	SMH260928P00542500	put	542.5000	2026-09-28	0.6000	0.6000	0.7000	591.4200	37260.00	0.00	37260.00	621	21	625	1	625	0.379085429318133	0.379085429318133	false	false	false	true	false
956aa416-1767-45ae-a425-dcd244591b8c	2026-09-21 12:11	2026-09-21 12:11	2026-09-21 12:11	SMH	SMH260921C00595000	call	595.0000	2026-09-21	0.2500	0.1600	0.2500	591.2800	10425.00	10075.00	0.00	417	40	651	33	19.7272727272727	0.279382159749987	0.279382159749987	true	false	false	true	false
4a2c2971-579f-4c0d-9a28-5556a68eb080	2026-09-21 12:11	2026-09-21 12:10	2026-09-21 12:10	SMH	SMH261016C00600000	call	600.0000	2026-10-16	17.1900	16.8000	17.2500	591.3000	56743.00	42998.00	13745.00	33	21	2649	11983	0.221063172828173	0.330616305881999	0.330866457296339	true	false	false	true	false
66984333-f96b-473d-8d09-afc577f82b03	2026-09-21 12:07	2026-09-21 12:07	2026-09-21 12:07	SMH	SMH260925C00605000	call	605.0000	2026-09-25	2.8700	2.6600	2.9300	591.1000	89464.00	89181.00	283.00	312	16	577	658	0.876899696048632	0.313130601266592	0.313640645585834	true	false	false	true	false
c4381676-d56c-4e3c-bf68-4c123f917032	2026-09-21 12:03	2026-09-21 12:03	2026-09-21 12:03	SMH	SMH260922C00597500	call	597.5000	2026-09-22	1.3700	1.2100	1.3800	590.5700	30823.00	24385.00	273.00	225	17	674	0	0	0.311424055020242	0.312209815962616	true	false	false	true	false
cfaa9656-8707-4ee5-b20f-1cdc1c0283ef	2026-09-21 12:03	2026-09-21 12:03	2026-09-21 12:03	SMH	SMH261120P00500000	put	500.0000	2026-11-20	6.9000	6.8500	7.1500	590.5250	13110.00	1380.00	11730.00	19	10	190	5134	0.037008180755746	0.409810447683403	0.409810447683403	true	false	false	true	false
eddb61c8-517c-4d45-b10b-e32f729ad82b	2026-09-21 12:02	2026-09-21 12:02	2026-09-21 12:02	SMH	SMH261009C00625000	call	625.0000	2026-10-09	5.4400	5.4500	5.7000	590.2500	22310.00	1100.00	21210.00	41	14	70	196	0.357142857142857	0.321497816034821	0.322751940246853	true	false	false	true	false
eb24ce31-259d-4206-9ace-89f5837b85ee	2026-09-21 12:02	2026-09-21 12:02	2026-09-21 12:02	SMH	SMH261009C00615000	call	615.0000	2026-10-09	7.8000	7.8000	7.8500	590.2500	35889.00	0.00	35889.00	46	8	79	55	1.43636363636364	0.319767811700786	0.319767811700786	true	false	false	true	false
8e717784-631a-4b80-ae93-7bb64a4506bb	2026-09-21 12:02	2026-09-21 12:02	2026-09-21 12:02	SMH	SMH261009C00610000	call	610.0000	2026-10-09	9.3500	9.3500	9.8500	590.2500	135591.00	0.00	135591.00	145	7	188	113	1.66371681415929	0.32101817971159	0.32101817971159	true	false	false	true	false
7ddb62fc-1c9d-49ae-8062-1806f3023959	2026-09-21 12:02	2026-09-21 12:02	2026-09-21 12:02	SMH	SMH261002C00617500	call	617.5000	2026-10-02	4.1100	4.1000	4.2500	590.2500	92779.00	0.00	92779.00	226	20	253	0	0	0.320224523171363	0.320224523171363	true	false	false	true	false
34068699-d912-4394-b35e-379b5826b159	2026-09-21 12:02	2026-09-21 12:02	2026-09-21 12:02	SMH	SMH261002C00610000	call	610.0000	2026-10-02	5.8000	5.7500	6.1500	590.2500	54519.00	579.00	53940.00	94	29	757	440	1.72045454545455	0.317495747075125	0.317211465464984	true	false	false	true	false
ccf09cee-805d-45f7-b10d-4a84dfc1b284	2026-09-21 12:02	2026-09-21 12:02	2026-09-21 12:02	SMH	SMH261016C00625000	call	625.0000	2026-10-16	8.2700	8.2000	8.3000	590.2900	119133.00	102633.00	0.00	144	15	5828	10142	0.574640110431867	0.327735776730857	0.32696228142579	false	false	false	true	false