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:source = uw_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	expirydate

b306cd6c-d710-4e16-81ee-2a5f64738e4d	2026-09-21 16:13	2026-09-21 16:13	2026-09-21 16:13	SMH	SMH261016P00595000	put	595.0000	2026-10-16	20.1100	18.9000	20.4500	595.0000	30164.00	30164.00	0.00	15	8	255	215	1.18604651162791	0.349692496091634	0.337909518727161	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	74084243802.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-21	2026-09-21 21:15	2026-09-21 21:15
a207db36-0599-44fc-a0c6-a3f0cccc965e	2026-09-21 16:02	2026-09-21 16:01	2026-09-21 16:01	SMH	SMH260925C00600000	call	600.0000	2026-09-25	6.1000	6.0500	6.5500	595.0000	122098.00	0.00	122098.00	200	6	5665	1333	4.24981245311328	0.316556468206447	0.316556468206447	false	false	false	true
46c89bee-1c3c-4021-b9bb-eaf5b8c857ac	2026-09-21 15:55	2026-09-21 15:55	2026-09-21 15:55	SMH	SMH261002C00627500	call	627.5000	2026-10-02	3.8300	3.6000	3.8500	597.0000	47100.00	46720.00	380.00	123	18	439	0	0	0.328455654850271	0.326761310044501	false	false	false	true
242899fd-d011-453d-adda-be2114d47804	2026-09-21 15:55	2026-09-21 15:55	2026-09-21 15:55	SMH	SMH261002C00610000	call	610.0000	2026-10-02	8.3000	8.0500	8.3000	597.0000	283030.00	283030.00	0.00	341	7	1180	440	2.68181818181818	0.323765665208878	0.323765665208878	true	false	false	true
2eb5ac02-4e19-44a0-a30a-a60f26c7d653	2026-09-21 15:53	2026-09-21 15:52	2026-09-21 15:52	SMH	SMH261005C00610000	call	610.0000	2026-10-05	9.5000	9.1500	9.8500	597.0000	13300.00	9500.00	3800.00	14	7	95	0	0	0.311800463118063	0.311800463118063	false	false	false	true
54a0e15a-94bd-4a1a-a178-019d68bc5ff2	2026-09-21 15:52	2026-09-21 15:52	2026-09-21 15:52	SMH	SMH260925C00612500	call	612.5000	2026-09-25	2.9300	2.8200	2.9300	597.3950	43950.00	43950.00	0.00	150	14	3971	36	110.305555555556	0.329821771018221	0.329821771018221	false	false	false	true
20109ef8-99e7-4f30-bef5-a0b25333b3d1	2026-09-21 15:51	2026-09-21 15:51	2026-09-21 15:51	SMH	SMH261016P00585000	put	585.0000	2026-10-16	14.9500	14.7500	15.2500	597.0400	104650.00	58305.00	46345.00	70	9	440	1218	0.361247947454844	0.341983848710737	0.341983848710737	false	false	false	true
94d23bdc-2320-4822-b297-a258072b6a30	2026-09-21 15:49	2026-09-21 15:49	2026-09-21 15:49	SMH	SMH260923C00602500	call	602.5000	2026-09-23	3.1000	3.1000	3.3500	597.0000	17670.00	0.00	17670.00	57	14	344	4	86	0.300238399445157	0.300238399445157	false	false	false	true
50785685-7b9f-447b-a001-5c2b00b6db60	2026-09-21 15:48	2026-09-21 15:48	2026-09-21 15:48	SMH	SMH261016P00570000	put	570.0000	2026-10-16	10.0000	9.8000	10.0000	597.0000	19000.00	19000.00	0.00	19	6	358	1256	0.285031847133758	0.351662206597677	0.351662206597677	false	false	false	true
6ed549da-64bd-47e9-841f-9ed4c4283fb3	2026-09-21 15:48	2026-09-21 15:48	2026-09-21 15:48	SMH	SMH261009P00560000	put	560.0000	2026-10-09	5.0500	4.8000	5.0500	597.0000	10100.00	10100.00	0.00	20	7	1176	37	31.7837837837838	0.355119301068479	0.355119301068479	false	false	false	true
60001846-9b0d-4e4c-9c34-446e88368c8a	2026-09-21 15:47	2026-09-21 15:47	2026-09-21 15:47	SMH	SMH270617C00600000	call	600.0000	2027-06-17	81.9300	81.9000	84.0500	597.0000	286740.00	8280.00	278460.00	35	9	45	2031	0.0221565731166913	0.364682716407632	0.364682716407632	false	false	false	true
888ec619-d735-44e3-a7d7-1500af0e53b7	2026-09-21 15:46	2026-09-21 15:46	2026-09-21 15:46	SMH	SMH260925P00595000	put	595.0000	2026-09-25	6.9000	6.6000	6.9000	597.0000	12420.00	12420.00	0.00	18	7	463	54	8.57407407407407	0.329617644829339	0.328725429322814	false	false	false	true
a8462b6d-7668-42ac-b5a5-5ae4604b28d9	2026-09-21 15:46	2026-09-21 15:46	2026-09-21 15:46	SMH	SMH260921C00597500	call	597.5000	2026-09-21	0.5000	0.5000	0.7400	597.6300	30700.00	0.00	30700.00	614	45	7527	8	940.875	0.358746973431591	0.358746973431591	false	false	false	true
ec07b81a-cd02-4e5d-beec-00c5fbf4455a	2026-09-21 15:45	2026-09-21 15:45	2026-09-21 15:45	SMH	SMH261002C00610000	call	610.0000	2026-10-02	8.6500	8.6500	9.0500	597.7400	52765.00	0.00	52765.00	61	12	839	440	1.90681818181818	0.326570593535401	0.326570593535401	true	false	false	true
c1bece05-f3bb-421e-87e5-e808c478749b	2026-09-21 15:45	2026-09-21 15:45	2026-09-21 15:45	SMH	SMH261002C00607500	call	607.5000	2026-10-02	9.6000	9.6000	10.0000	597.7400	21120.00	0.00	21120.00	22	6	174	34	5.11764705882353	0.327154533317011	0.327154533317011	false	false	false	true
170089ed-02df-4d01-80d1-c8efb3cdc588	2026-09-21 15:44	2026-09-21 15:44	2026-09-21 15:44	SMH	SMH260925P00595000	put	595.0000	2026-09-25	6.7500	6.5000	6.7500	597.8200	17550.00	17550.00	0.00	26	10	444	54	8.22222222222222	0.330609443527008	0.329202172012341	false	false	false	true
3c47e8c3-7ccb-4b38-990e-fd2c1b0ad6e5	2026-09-21 15:44	2026-09-21 15:44	2026-09-21 15:44	SMH	SMH260925P00597500	put	597.5000	2026-09-25	7.9000	7.7500	7.9000	597.9050	14220.00	14220.00	0.00	18	10	139	6	23.1666666666667	0.329716559524441	0.329716559524441	false	false	false	true
460ee5de-9a31-4424-a3ad-69f7f0d9e2d1	2026-09-21 15:44	2026-09-21 15:44	2026-09-21 15:44	SMH	SMH260925P00595000	put	595.0000	2026-09-25	6.7000	6.4000	6.7000	597.9100	26800.00	26800.00	0.00	40	15	416	54	7.7037037037037	0.329279487179319	0.328753188913381	false	false	false	true
cbfcc859-b04a-4256-866a-da57f0768898	2026-09-21 15:44	2026-09-21 15:43	2026-09-21 15:43	SMH	SMH260928P00440000	put	440.0000	2026-09-28	0.0500	0.0400	0.0500	597.9400	11055.00	11055.00	0.00	2211	52	5216	5	1043.2	0.805054934217661	0.805054934217661	false	false	false	true
300a4540-adec-4463-9499-885ba99fc3fa	2026-09-21 15:44	2026-09-21 15:43	2026-09-21 15:43	SMH	SMH261120C00620000	call	620.0000	2026-11-20	27.4100	27.1500	27.8000	597.9400	27406.00	0.00	27406.00	10	6	235	1373	0.17115804806992	0.363372903208094	0.363372903208094	false	false	false	true
742fa83b-08d1-42c0-b44f-e8daa55ca06c	2026-09-21 15:42	2026-09-21 15:42	2026-09-21 15:42	SMH	SMH260922P00580000	put	580.0000	2026-09-22	0.3600	0.3200	0.3600	598.0500	55224.00	55224.00	0.00	1534	30	1891	11	171.909090909091	0.393246345338993	0.393246345338993	false	false	false	true
9ae45ad6-b0cc-45ca-bc15-5bed1369fc5f	2026-09-21 15:42	2026-09-21 15:42	2026-09-21 15:42	SMH	SMH261023P00577500	put	577.5000	2026-10-23	14.6000	13.9500	14.6500	598.0500	33575.00	33575.00	0.00	23	5	40	2	20	0.350099884885207	0.350099884885207	true	false	false	true	false
5db83688-4d9a-4b31-b808-3ed1160e2aff	2026-09-21 15:42	2026-09-21 15:42	2026-09-21 15:42	SMH	SMH261016P00600000	put	600.0000	2026-10-16	21.5000	21.1500	21.5500	598.0300	144050.00	144050.00	0.00	67	15	648	2359	0.274692666384061	0.341616742888141	0.341616742888141	false	false	false	true
d6ea0442-dd44-4183-8e23-65654fe59f63	2026-09-21 15:42	2026-09-21 15:42	2026-09-21 15:42	SMH	SMH261023P00575000	put	575.0000	2026-10-23	13.7500	12.9500	13.7500	598.1300	15125.00	15125.00	0.00	11	6	49	3	16.3333333333333	0.351499400839995	0.351499400839995	false	false	false	true
c270dde5-bbaa-419c-8dda-120107bad7d8	2026-09-21 15:42	2026-09-21 15:42	2026-09-21 15:42	SMH	SMH261016P00600000	put	600.0000	2026-10-16	21.4400	21.0000	21.5000	598.0700	510220.00	431145.00	64060.00	238	23	557	2359	0.236116998728275	0.341126043872339	0.341126043872339	false	false	false	true
21d894c7-4824-419e-9ed0-5de5abdf8dd3	2026-09-21 15:42	2026-09-21 15:42	2026-09-21 15:42	SMH	SMH261023P00577500	put	577.5000	2026-10-23	14.6000	13.9500	14.6000	598.1300	18980.00	18980.00	0.00	13	8	17	2	8.5	0.350515799731172	0.350515799731172	false	false	false	true
ca44f824-9add-463c-a97c-d3f1c393ddba	2026-09-21 15:41	2026-09-21 15:41	2026-09-21 15:41	SMH	SMH261009P00587500	put	587.5000	2026-10-09	12.2000	11.8500	12.2000	598.1100	18300.00	18300.00	0.00	15	5	46	1	46	0.332727226840372	0.332727226840372	false	false	false	true
afff635d-39ef-492a-ad1b-41d523bce64e	2026-09-21 15:41	2026-09-21 15:40	2026-09-21 15:40	SMH	SMH260925P00595000	put	595.0000	2026-09-25	6.4500	6.1500	6.4500	598.3000	58042.00	58042.00	0.00	90	23	375	54	6.94444444444444	0.325369202095045	0.325369202095045	true	false	false	true
feed5495-450d-4159-bac8-f37636e1bed8	2026-09-21 15:41	2026-09-21 15:40	2026-09-21 15:40	SMH	SMH260925C00615000	call	615.0000	2026-09-25	2.4500	2.2700	2.4500	598.2500	11760.00	11760.00	0.00	48	14	446	238	1.87394957983193	0.323092134080759	0.323092134080759	false	false	false	true
8c806fd4-9e88-4821-8fc9-9dfaea4a60f9	2026-09-21 15:41	2026-09-21 15:40	2026-09-21 15:40	SMH	SMH260925C00600000	call	600.0000	2026-09-25	7.4000	7.1500	7.4000	598.2900	20720.00	20720.00	0.00	28	8	4861	1333	3.64666166541635	0.324720890264323	0.323954532683953	false	false	false	true
65250e5d-f3ed-40ed-96da-5cfb04c77f52	2026-09-21 15:40	2026-09-21 15:40	2026-09-21 15:40	SMH	SMH261002C00615000	call	615.0000	2026-10-02	7.1000	7.0000	7.4500	598.3100	17750.00	710.00	17040.00	25	8	246	1727	0.142443543717429	0.32433822896126	0.32433822896126	false	false	false	true
174104ae-5e4f-452c-85e0-b66f441d17d7	2026-09-21 15:40	2026-09-21 15:40	2026-09-21 15:40	SMH	SMH261030C00625000	call	625.0000	2026-10-30	17.6000	17.6000	17.9500	598.3100	35200.00	0.00	35200.00	20	7	99	36	2.75	0.351575220394001	0.351575220394001	true	false	false	true
4f981262-0a7f-4bfd-b502-5d96ff70a519	2026-09-21 15:40	2026-09-21 15:40	2026-09-21 15:40	SMH	SMH261016C00620000	call	620.0000	2026-10-16	12.9500	12.9500	13.0000	598.5800	27200.00	1300.00	25900.00	21	13	1929	6648	0.290162454873646	0.336765500911852	0.336765500911852	false	false	false	true
f8ce8ac2-4fba-4579-8b50-7da52c1d7938	2026-09-21 15:39	2026-09-21 15:39	2026-09-21 15:39	SMH	SMH261005C00605000	call	605.0000	2026-10-05	12.0200	11.2000	13.1500	598.4150	18030.00	7230.00	10800.00	15	6	29	0	0	0.311990051763179	0.313164774201354	false	false	false	true
5b2364ea-d430-4bf1-9788-547ee548d197	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	SMH	SMH261002C00630000	call	630.0000	2026-10-02	3.5000	3.4500	3.7000	598.3001	10500.00	4550.00	5950.00	30	9	212	954	0.222222222222222	0.32446415244162	0.32446415244162	false	false	false	true
d6b022b1-c652-46b9-afb4-d0b0c92c2fc5	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	SMH	SMH261002C00630000	call	630.0000	2026-10-02	3.5000	3.4500	3.8000	598.3200	11900.00	700.00	11200.00	34	8	146	954	0.153039832285115	0.324600447473737	0.324329202618576	false	false	false	true
8be0eba0-75d8-46ea-931d-7d6405468d85	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	SMH	SMH260925P00595000	put	595.0000	2026-09-25	6.6500	6.1000	6.6500	598.2900	60515.00	60515.00	0.00	91	6	283	54	5.24074074074074	0.333346271394021	0.333346271394021	false	false	false	true
ec630453-37b9-4f2e-ba4c-ddf1648b56ad	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	SMH	SMH270219C00700000	call	700.0000	2027-02-19	22.9500	21.7500	23.6500	598.1600	25250.00	20670.00	4580.00	11	6	157	240	0.654166666666667	0.346481009420522	0.346108907753692	false	false	false	true
8b39767b-e40c-4596-b060-1be155e7b5e1	2026-09-21 15:38	2026-09-21 15:38	2026-09-21 15:38	SMH	SMH260928C00630000	call	630.0000	2026-09-28	1.0400	0.8200	1.0800	598.0000	14771.00	14771.00	0.00	142	17	146	5	29.2	0.280898882646458	0.283697072909858	true	false	false	true
cb0f22a9-4cef-4612-a975-23055a620a7d	2026-09-21 15:37	2026-09-21 15:37	2026-09-21 15:37	SMH	SMH261030C00567500	call	567.5000	2026-10-30	47.5100	45.3500	47.8000	597.9400	114020.00	114020.00	0.00	24	12	27	52	0.519230769230769	0.369797307971062	0.372744825620529	true	false	false	true
80181a57-3555-4fd7-9111-282a65209990	2026-09-21 15:37	2026-09-21 15:37	2026-09-21 15:37	SMH	SMH261002P00580000	put	580.0000	2026-10-02	6.5500	6.5000	6.8000	597.8300	60915.00	12445.00	38645.00	93	8	680	16	42.5	0.34086554649851	0.34086554649851	false	false	false	true
95ace901-f8b7-4bdb-bb6d-8026ce84d16e	2026-09-21 15:37	2026-09-21 15:37	2026-09-21 15:37	SMH	SMH261016C00615000	call	615.0000	2026-10-16	14.6500	14.3000	14.6500	597.8300	254907.00	254907.00	0.00	174	30	1618	15170	0.106657877389585	0.340451299534507	0.340451299534507	true	false	false	true
b170bb4b-a64c-43d4-9895-3ff62222b4e9	2026-09-21 15:37	2026-09-21 15:37	2026-09-21 15:37	SMH	SMH261016C00615000	call	615.0000	2026-10-16	14.4500	14.4500	14.5500	597.7500	20230.00	0.00	20230.00	14	7	1424	15170	0.0938694792353329	0.337682040062007	0.337682040062007	false	false	false	true
fda425c3-0c86-4f61-8a70-b529c5338b46	2026-09-21 15:37	2026-09-21 15:37	2026-09-21 15:37	SMH	SMH261016C00615000	call	615.0000	2026-10-16	14.3500	14.3500	14.5500	597.7500	37310.00	0.00	37310.00	26	7	1410	15170	0.0929466051417271	0.336029777454468	0.336029777454468	false	false	false	true
ac2b34b3-57f0-4bb7-9083-7d6f0d96292f	2026-09-21 15:37	2026-09-21 15:37	2026-09-21 15:37	SMH	SMH261120P00605000	put	605.0000	2026-11-20	36.9100	36.8000	37.0000	597.7500	77520.00	14780.00	59045.00	21	9	84	96	0.875	0.364817323788511	0.364817323788511	true	false	false	true
818f7dc2-61bb-424d-beb4-a15c4b2f7eaf	2026-09-21 15:37	2026-09-21 15:37	2026-09-21 15:37	SMH	SMH261009C00595000	call	595.0000	2026-10-09	19.4000	17.9000	19.4500	597.6800	46560.00	44620.00	0.00	24	7	401	333	1.2042042042042	0.330939327851535	0.329946441562685	true	false	false	true
48b47b0e-6c17-43e6-aac0-1db3f9a00ff8	2026-09-21 15:36	2026-09-21 15:36	2026-09-21 15:36	SMH	SMH261016P00500000	put	500.0000	2026-10-16	1.4000	1.4000	1.4700	597.5400	49840.00	0.00	49840.00	356	22	4148	12699	0.326639892904953	0.42999175179397	0.42999175179397	false	false	false	true
3b41390d-c466-4428-8309-90b017e5b1c0	2026-09-21 15:36	2026-09-21 15:36	2026-09-21 15:36	SMH	SMH261120C00685000	call	685.0000	2026-11-20	9.2300	9.1000	9.2500	597.3600	53530.00	53530.00	0.00	58	5	67	158	0.424050632911392	0.356773625494619	0.356773625494619	true	false	false	true
93f0ac80-a279-4661-862e-5123db65a20c	2026-09-21 15:34	2026-09-21 15:33	2026-09-21 15:33	SMH	SMH261120P00515000	put	515.0000	2026-11-20	8.2500	8.2500	8.5500	597.2900	22275.00	0.00	22275.00	27	6	1240	1470	0.843537414965986	0.402555844105225	0.402555844105225	true	false	false	true
1ffb7cff-6cb1-4141-8631-9a19d7db6183	2026-09-21 15:33	2026-09-21 15:33	2026-09-21 15:33	SMH	SMH261005C00615000	call	615.0000	2026-10-05	7.5300	7.2500	7.6500	597.0000	12795.00	3770.00	4525.00	17	6	47	0	0	0.305287376442944	0.304108530438006	false	false	false	true