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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 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	price

a333de1c-7c25-4470-a121-ae1a5c0ee52f	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SMH	SMH261016C00605000	call	605.0000	2026-10-16	17.2700	16.8000	17.5500	596.8950	18995.00	10380.00	8615.00	11	9	11	2573	0.00427516517683638	0.332369977232601	0.332369977232601	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	72800221160.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-22T13:36:05.660724Z"}	2026-09-22	2026-09-22 21:15	2026-09-22 21:15
90362bff-8c9b-4aa1-81c2-57812cb27f9e	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SMH	SMH260923C00602500	call	602.5000	2026-09-23	2.1500	1.8600	2.2200	596.8950	14402.00	13327.00	1075.00	67	9	70	204	0.343137254901961	0.349231297058453	0.349231297058453	true	false	false	true	false
6d0ff86d-0d25-43bc-a79c-07c10ff64e7c	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SMH	SMH260923C00605000	call	605.0000	2026-09-23	1.5200	1.3000	1.5300	596.8950	14435.00	14288.00	147.00	95	6	212	406	0.522167487684729	0.352727866919732	0.352727866919732	true	false	false	true	false
2598eb1e-8b21-49b7-a2c5-799141e86219	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SMH	SMH261016C00650000	call	650.0000	2026-10-16	4.4900	4.1500	4.5000	596.8486	12135.00	11245.00	890.00	27	12	32	4376	0.00731261425959781	0.327420919002076	0.328087043392441	true	false	false	true	false
0309790e-1166-4c20-8b2f-82e72a70927a	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SMH	SMH261016C00665000	call	665.0000	2026-10-16	2.7300	2.4800	2.7400	596.8486	19651.00	16379.00	542.00	72	8	78	1094	0.0712979890310786	0.330579984587973	0.330720079002104	true	false	false	true	false
701a1789-65d9-4423-a191-f8d0d083d076	2026-09-22 09:35	2026-09-22 09:35	2026-09-22 09:35	SMH	SMH261002C00550000	call	550.0000	2026-10-02	49.0500	46.9000	49.0500	596.7800	480690.00	480690.00	0.00	98	12	98	336	0.291666666666667	0.385355474660612	0.385355474660612	true	false	false	true	false
79f82d43-94de-44a0-acf1-0bd09a97da00	2026-09-22 09:33	2026-09-22 09:33	2026-09-22 09:33	SMH	SMH270319P00545000	put	545.0000	2027-03-19	33.9100	33.0000	35.0500	595.9000	135624.00	94764.00	40860.00	40	5	40	145	0.275862068965517	0.383284232804868	0.383074560763387	false	false	false	true	false
a92524bc-f27f-4ad2-b9af-836310d509e2	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH261030C00605000	call	605.0000	2026-10-30	23.1000	23.1000	23.7500	594.6071	50820.00	0.00	50820.00	22	7	22	81	0.271604938271605	0.348398264670422	0.348398264670422	true	false	false	true	false
f2608744-dccf-4ece-b3ce-71e7b9462564	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH261002C00600000	call	600.0000	2026-10-02	10.5500	10.5000	10.6000	594.9100	17935.00	0.00	15825.00	17	10	17	2676	0.00635276532137519	0.320752290256148	0.320752290256148	true	false	false	true	false
e26cee02-5843-47ba-a380-c5e1da42e145	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH261002C00597500	call	597.5000	2026-10-02	11.7300	11.6500	12.3000	594.9100	16420.00	8230.00	8190.00	14	10	18	58	0.310344827586207	0.321460175247257	0.321460175247257	true	false	false	true	false
a8513059-3e4b-4ae2-8c54-5f7b67c05054	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH261002C00602500	call	602.5000	2026-10-02	9.5000	9.4500	10.1000	594.9100	14255.00	1910.00	11395.00	15	13	15	233	0.0643776824034335	0.320626123038003	0.320626123038003	true	false	false	true	false
a03e2208-f047-4bc3-a068-54f6ed919b91	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH261002C00600000	call	600.0000	2026-10-02	10.5700	10.5000	10.9000	594.9100	14800.00	7415.00	7385.00	14	6	33	2676	0.0123318385650224	0.320752290256148	0.320752290256148	true	false	false	true	false
68416d4d-bc6a-4da9-8e06-c5535a319f16	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH260922P00592500	put	592.5000	2026-09-22	1.5400	1.5400	1.8500	595.0614	12628.00	0.00	12628.00	82	16	201	125	1.608	0.408858732263158	0.408858732263158	true	false	false	true	false
a9d09ecd-4785-4bf1-995e-c1235fe3f2a8	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH261023C00615000	call	615.0000	2026-10-23	15.4000	15.3500	16.1500	595.1350	20025.00	0.00	20025.00	13	10	13	123	0.105691056910569	0.330436419140146	0.329689527201786	true	false	false	true	false
8176f5fa-9bb8-416b-9d06-e5acc57d4ca0	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH261023C00625000	call	625.0000	2026-10-23	12.0000	12.0000	12.1500	595.1350	34800.00	0.00	34800.00	29	7	30	116	0.258620689655172	0.328873060807484	0.328873060807484	false	false	false	true	false
597680b3-7b08-4429-b97e-d86efb6e0c79	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH261023C00620000	call	620.0000	2026-10-23	13.6300	13.6000	14.3500	595.1350	32710.00	0.00	32710.00	24	11	24	63	0.380952380952381	0.330072086259934	0.329306018165389	true	false	false	true	false
40dcccfb-3497-4303-96c4-b92f446bbdb2	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH260923C00605000	call	605.0000	2026-09-23	1.2900	1.2500	1.5000	595.1350	14576.00	0.00	14576.00	113	17	114	406	0.280788177339901	0.369617497026961	0.367332805957254	false	false	false	true	false
3c64919b-6efb-4f2f-afd6-cca1fad74317	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH260924C00602500	call	602.5000	2026-09-24	2.8900	2.8900	3.3500	594.8950	33819.00	290.00	33529.00	117	10	118	54	2.18518518518519	0.333711007122858	0.333711007122858	true	false	false	true	false
8e87df28-336b-4ebb-966d-2306ec2323db	2026-09-22 09:32	2026-09-22 09:32	2026-09-22 09:32	SMH	SMH261016C00620000	call	620.0000	2026-10-16	11.0000	11.0000	11.5000	595.2000	16500.00	0.00	16500.00	15	6	15	7470	0.00200803212851406	0.331128883232346	0.331128883232346	false	false	false	true	false
e110c86f-48e4-41bc-9d08-0a21d1e016d5	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH260925C00600000	call	600.0000	2026-09-25	5.1000	5.1000	5.5500	595.0800	41310.00	0.00	41310.00	81	10	134	3423	0.0391469471224072	0.334614867070587	0.334036340424027	false	false	false	true	false
75af21b6-ccac-4175-8187-d130beace9f4	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH260924C00600000	call	600.0000	2026-09-24	3.9000	3.5500	4.2500	595.0800	11310.00	0.00	9360.00	29	5	49	37	1.32432432432432	0.339661715215015	0.339661715215015	false	false	false	true	false
2b00d5af-f1d4-4813-8cff-c57e3c5e289a	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH260925C00605000	call	605.0000	2026-09-25	3.4500	3.4500	3.9000	595.0500	23805.00	0.00	23805.00	69	16	80	1318	0.0606980273141123	0.337171226839926	0.337171226839926	false	false	false	true	false
ad1d720c-ed28-4881-bc57-886893def68c	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH260925C00600000	call	600.0000	2026-09-25	5.5000	5.0000	5.6000	595.4700	14295.00	13750.00	545.00	26	8	53	3423	0.0154834940111014	0.345512942908173	0.343136173425463	false	false	false	true	false
7bf2d4ad-6793-4e3f-a9f1-0d2426549971	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH260925C00600000	call	600.0000	2026-09-25	5.5500	4.9000	5.5500	595.4177	13875.00	13875.00	0.00	25	6	27	3423	0.00788781770376862	0.348919769882546	0.348919769882546	false	false	false	true	false
15b582fe-6eb0-4d80-971f-d677a7699dcb	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH261120P00585000	put	585.0000	2026-11-20	28.3300	28.3000	29.3000	594.4200	19830.00	2845.00	16985.00	7	7	7	1559	0.00449005772931366	0.3666775542873	0.368291848690677	true	false	false	true	false
7cf94136-7824-4cd9-b8e5-e0b4f60f5194	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH260925P00587500	put	587.5000	2026-09-25	4.4000	4.4000	4.8500	594.4089	10120.00	0.00	10120.00	23	12	37	355	0.104225352112676	0.347023457768641	0.347023457768641	false	false	false	true	false
fb13b042-dc7b-4d98-b6ca-9607bd6cf908	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH261030P00575000	put	575.0000	2026-10-30	17.6100	17.4500	18.2000	594.3600	17610.00	1765.00	15845.00	10	8	10	9	1.11111111111111	0.361356665233911	0.362058770155422	true	false	false	true	false
aba0cc2b-1935-42ce-9faa-76e1c6b82bc8	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH260925P00590000	put	590.0000	2026-09-25	5.5600	5.5500	6.3000	593.7950	13340.00	565.00	12775.00	24	9	25	376	0.0664893617021277	0.349241004421916	0.344459949117235	true	false	false	true	false
a7d1dcad-9627-44ae-a882-61c0bc53c20b	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH260925P00582500	put	582.5000	2026-09-25	3.3000	3.0500	3.8500	593.7950	16495.00	320.00	16175.00	50	13	50	157	0.318471337579618	0.362693255411877	0.357450013016133	true	false	false	true	false
5dfc9bf8-84ef-47d3-9e05-83d7f9353e67	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH261002P00582500	put	582.5000	2026-10-02	8.0000	7.7500	8.6500	593.7950	11195.00	1590.00	9605.00	14	7	14	56	0.25	0.337538134376429	0.333645096615426	true	false	false	true	false
d7e28567-e77d-499c-b85c-11d700657c51	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH260924P00582500	put	582.5000	2026-09-24	2.5000	2.5000	4.4000	593.6100	50751.00	0.00	50751.00	203	9	203	0	0	0.383871447021351	0.384593294593696	true	false	false	true	false
af65f7a4-c6fa-4fa1-aefa-1938ff581377	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH260923P00575000	put	575.0000	2026-09-23	0.7100	0.5700	0.9500	593.6100	13516.00	5536.00	7980.00	190	17	191	284	0.672535211267606	0.476514800384082	0.480217759633046	true	false	false	true	false
5f4633af-428b-4761-8bf5-96e8eb6ce172	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH261002P00557500	put	557.5000	2026-10-02	2.7500	2.6900	3.1000	593.6100	12375.00	275.00	12100.00	45	9	45	108	0.416666666666667	0.372120626169042	0.372120626169042	true	false	false	true	false
5f2882a3-356e-43e6-b6b8-0237ebc432f0	2026-09-22 09:31	2026-09-22 09:31	2026-09-22 09:31	SMH	SMH260923P00582500	put	582.5000	2026-09-23	1.4700	1.4600	1.9300	593.6100	23022.00	0.00	23022.00	157	7	157	82	1.91463414634146	0.432273539925345	0.433431334807653	true	false	false	true	false
b4dc41a2-8704-49a1-836b-bb83ecb41c83	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SMH	SMH261016P00565000	put	565.0000	2026-10-16	9.2500	9.2500	9.8000	593.7400	19425.00	0.00	3700.00	21	19	203	1423	0.142656359803233	0.354738239776395	0.354738239776395	false	false	false	true	false
0fd63499-2d27-4b48-b67d-4b41666b6f5b	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SMH	SMH261016P00565000	put	565.0000	2026-10-16	9.2000	9.2000	10.9500	593.7700	149040.00	0.00	149040.00	162	40	182	1423	0.127898805340829	0.353900487731567	0.353900487731567	true	false	false	true	false
caaec63c-980b-4a55-b8c7-f9e3f150c6dc	2026-09-22 09:30	2026-09-22 09:30	2026-09-22 09:30	SMH	SMH261120P00480000	put	480.0000	2026-11-20	4.2000	4.1000	4.2000	592.0000	12600.00	6720.00	0.00	30	13	30	1398	0.0214592274678112	0.418927044656608	0.418927044656608	false	false	false	true	false
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
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false
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	false