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.

658,639 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts658,639 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

5368ef22-1f14-4029-89cd-a4210170ef78	2026-09-29 10:10	2026-09-29 10:09	2026-09-29 10:09	SMH	SMH261012C00680000	call	680.0000	2026-10-12	0.7400	0.7400	2.9700	608.7200	21165.00	0.00	21165.00	286	13	288	0	0	0.339288898128496	0.339288898128496	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	73526349819.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-29T14:10:17.656675Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
e62677dd-c2a1-4915-a5ae-837758f43cbc	2026-09-29 10:03	2026-09-29 10:03	2026-09-29 10:03	SMH	SMH260929P00607500	put	607.5000	2026-09-29	1.6700	1.5000	1.7200	609.5400	10020.00	668.00	9352.00	60	6	575	169	3.40236686390533	0.406435397589961	0.406435397589961	false	false	false	true
7ec6208c-8478-4fc4-bfeb-d1f9844b839c	2026-09-29 10:03	2026-09-29 10:02	2026-09-29 10:02	SMH	SMH261016C00630000	call	630.0000	2026-10-16	9.5000	9.1000	9.5000	609.3000	30400.00	30400.00	0.00	32	10	108	9282	0.0116354234001293	0.33153053034196	0.329550315378794	false	false	false	true
e22c2e2c-006d-4370-a337-282fdad0adc6	2026-09-29 10:02	2026-09-29 10:01	2026-09-29 10:01	SMH	SMH261002P00602500	put	602.5000	2026-10-02	5.4500	5.1000	5.5000	609.7300	11990.00	11990.00	0.00	22	7	22	864	0.025462962962963	0.395255959212777	0.395255959212777	false	false	false	true
4688114e-713e-4b10-9390-df4ee351ffa3	2026-09-29 09:57	2026-09-29 09:57	2026-09-29 09:57	SMH	SMH270115C00600000	call	600.0000	2027-01-15	57.0000	57.0000	57.5000	609.0000	171000.00	0.00	5700.00	30	19	31	4152	0.00746628131021195	0.368754988119384	0.368754988119384	false	false	false	true
a77e4e70-ca5a-41a3-8291-6aa55e76e930	2026-09-29 09:56	2026-09-29 09:55	2026-09-29 09:55	SMH	SMH261016C00612500	call	612.5000	2026-10-16	16.7000	16.0500	16.7000	609.6900	20040.00	20040.00	0.00	12	5	20	229	0.0873362445414847	0.333319719142503	0.333319719142503	false	false	false	true
a483b4da-7a95-4c36-96d8-0571ff303ba1	2026-09-29 09:53	2026-09-29 09:53	2026-09-29 09:53	SMH	SMH261016P00595000	put	595.0000	2026-10-16	11.2500	10.9000	11.3500	609.1250	10122.00	10122.00	0.00	9	7	29	830	0.0349397590361446	0.344687927874414	0.344073487164535	false	false	false	true
d131fec4-a8b5-4792-a0a9-00f35a2e38fd	2026-09-29 09:52	2026-09-29 09:52	2026-09-29 09:52	SMH	SMH261005C00630000	call	630.0000	2026-10-05	3.0000	2.3700	3.5000	609.2125	63904.00	63599.00	305.00	213	41	215	51	4.2156862745098	0.318023840937997	0.318023840937997	true	false	false	true
6852f203-3c6d-46f1-af39-ce126218fca1	2026-09-29 09:52	2026-09-29 09:52	2026-09-29 09:52	SMH	SMH261005C00607500	call	607.5000	2026-10-05	11.0100	9.2000	11.4500	609.2125	16515.00	16515.00	0.00	15	12	15	27	0.555555555555556	0.318480190292171	0.324933980210407	true	false	false	true
f07ef2b1-0eaf-4097-bdfe-dcf19c19ed01	2026-09-29 09:52	2026-09-29 09:52	2026-09-29 09:52	SMH	SMH261016C00610000	call	610.0000	2026-10-16	17.5500	17.0000	17.5500	609.0800	215865.00	215865.00	0.00	123	11	324	4285	0.0756126021003501	0.333435216700052	0.332635479153623	false	false	false	true
2fb412c5-1a8d-44dc-90c9-9814f2535259	2026-09-29 09:50	2026-09-29 09:50	2026-09-29 09:50	SMH	SMH261016C00580000	call	580.0000	2026-10-16	36.1500	35.2000	37.1500	607.7500	28920.00	3615.00	7230.00	8	6	27	3634	0.00742982938910292	0.356661417304044	0.356661417304044	false	false	false	true
20e1f0dc-e8e7-420c-909c-e5ee4dee5767	2026-09-29 09:46	2026-09-29 09:46	2026-09-29 09:46	SMH	SMH261001P00592500	put	592.5000	2026-10-01	2.1800	2.1800	2.3900	607.9900	13734.00	0.00	13734.00	63	14	63	13	4.84615384615385	0.426435292140015	0.426435292140015	false	false	false	true
27aa14aa-7f4d-4d89-a3a8-97187231f640	2026-09-29 09:43	2026-09-29 09:43	2026-09-29 09:43	SMH	SMH261023C00655000	call	655.0000	2026-10-23	5.7000	5.7000	6.0500	607.8200	12540.00	0.00	12540.00	22	7	22	947	0.0232312565997888	0.326881564664522	0.326881564664522	false	false	false	true
e45d8bdc-2c09-46b0-8900-2911004485a9	2026-09-29 09:43	2026-09-29 09:43	2026-09-29 09:43	SMH	SMH261023C00650000	call	650.0000	2026-10-23	6.7000	6.6500	6.7000	607.5050	12060.00	12060.00	0.00	18	5	18	302	0.0596026490066225	0.328900675363409	0.328900675363409	false	false	false	true
6a6cf137-1fdf-48ed-ba50-67bc95c825d9	2026-09-29 09:43	2026-09-29 09:42	2026-09-29 09:42	SMH	SMH261016P00580000	put	580.0000	2026-10-16	7.5500	6.9500	7.5500	606.5900	13585.00	13585.00	0.00	18	8	57	1646	0.034629404617254	0.355342346379797	0.355342346379797	true	false	false	true
1f77d11e-a839-472a-b2a2-6bdfcc79bf82	2026-09-29 09:43	2026-09-29 09:42	2026-09-29 09:42	SMH	SMH261106P00612500	put	612.5000	2026-11-06	30.0000	29.1000	30.0000	606.5900	39000.00	39000.00	0.00	13	12	13	0	0	0.362343393846587	0.362343393846587	true	false	false	true
655b4902-5928-45dd-9fed-2d31043b2757	2026-09-29 09:42	2026-09-29 09:42	2026-09-29 09:42	SMH	SMH261009P00592500	put	592.5000	2026-10-09	7.4500	6.9500	7.5000	606.3300	17135.00	9685.00	7450.00	23	5	33	702	0.047008547008547	0.34060842930685	0.34060842930685	true	false	false	true
47974878-f7ad-46c7-bd2c-7b4e4ee67193	2026-09-29 09:42	2026-09-29 09:42	2026-09-29 09:42	SMH	SMH261009P00595000	put	595.0000	2026-10-09	8.2500	7.7500	8.3000	606.3300	11550.00	7425.00	4125.00	14	6	54	72	0.75	0.338067242813157	0.338067242813157	true	false	false	true
778c99dd-a8bf-4520-a0e6-65ab785b2b54	2026-09-29 09:40	2026-09-29 09:40	2026-09-29 09:40	SMH	SMH261016C00630000	call	630.0000	2026-10-16	8.5000	8.2500	8.8000	607.3950	14450.00	3400.00	11050.00	17	5	23	9282	0.00247791424262012	0.321813997285164	0.321813997285164	false	false	false	true
dee8afaa-0132-4ff9-942f-852f9dc0bf64	2026-09-29 09:37	2026-09-29 09:37	2026-09-29 09:37	SMH	SMH260930C00622500	call	622.5000	2026-09-30	0.9000	0.7200	0.9200	606.8400	19260.00	16559.00	2610.00	214	23	299	51	5.86274509803922	0.430088317976984	0.431555491721471	false	false	false	true
764a769e-132c-46cd-9342-51b9f8ff335f	2026-09-29 09:37	2026-09-29 09:37	2026-09-29 09:37	SMH	SMH261218C00600000	call	600.0000	2026-12-18	48.0000	46.5500	49.0500	606.7100	72000.00	57600.00	14400.00	15	5	15	2341	0.00640751815463477	0.370947430777983	0.370947430777983	false	false	false	true
14ac294a-dcdc-496f-966c-c2dfb12928f9	2026-09-29 09:37	2026-09-29 09:37	2026-09-29 09:37	SMH	SMH260930C00620000	call	620.0000	2026-09-30	1.2200	0.9900	1.4300	606.8400	11834.00	7320.00	610.00	97	16	109	419	0.260143198090692	0.424102369179084	0.424102369179084	true	false	false	true
e8c01db4-6a21-489a-8f69-efc02fcb06cb	2026-09-29 09:36	2026-09-29 09:36	2026-09-29 09:36	SMH	SMH261002P00567500	put	567.5000	2026-10-02	0.7800	0.7000	0.8100	605.2800	12246.00	7722.00	4368.00	157	20	774	575	1.34608695652174	0.485735257111645	0.481893706840563	false	false	false	true
b6254910-16ed-48bf-9694-ca7a7e880a34	2026-09-29 09:36	2026-09-29 09:36	2026-09-29 09:36	SMH	SMH261002P00577500	put	577.5000	2026-10-02	1.4100	1.2400	1.4100	605.2800	13112.00	13112.00	0.00	93	16	94	383	0.245430809399478	0.449048107031334	0.444614770496646	true	false	false	true
4a3aa8a4-841b-4a63-a324-1f910129e323	2026-09-29 09:35	2026-09-29 09:35	2026-09-29 09:35	SMH	SMH260929P00605000	put	605.0000	2026-09-29	2.6100	2.3600	2.7800	605.6936	30796.00	27130.00	3666.00	118	5	180	152	1.18421052631579	0.458643368279995	0.464399963342434	true	false	false	true
e4e3b195-e674-4db1-9d0a-9398ff581999	2026-09-29 09:35	2026-09-29 09:35	2026-09-29 09:35	SMH	SMH261002P00565000	put	565.0000	2026-10-02	0.6100	0.5500	0.6200	606.0400	11332.00	11332.00	0.00	185	11	198	636	0.311320754716981	0.487611983793864	0.489287764932724	false	false	false	true
af6cae96-da8c-4055-80b2-382f78d36aa5	2026-09-29 09:35	2026-09-29 09:35	2026-09-29 09:35	SMH	SMH261002P00570000	put	570.0000	2026-10-02	0.8100	0.7400	0.8600	606.0400	11016.00	10206.00	810.00	136	5	189	13808	0.0136877172653534	0.467617093927781	0.467617093927781	true	false	false	true
0f998203-11e4-48e9-a0c1-f903425bbff3	2026-09-29 09:35	2026-09-29 09:35	2026-09-29 09:35	SMH	SMH261002P00560000	put	560.0000	2026-10-02	0.5000	0.4900	0.5000	606.0400	14000.00	14000.00	0.00	280	14	311	991	0.313824419778002	0.515391264819275	0.515391264819275	false	false	false	true
25a02b7f-bd50-4f2e-97cb-6c0b457d031f	2026-09-29 09:35	2026-09-29 09:35	2026-09-29 09:35	SMH	SMH261016P00607500	put	607.5000	2026-10-16	17.2000	16.4500	17.2000	606.2500	39560.00	39560.00	0.00	23	5	25	364	0.0686813186813187	0.328529362464143	0.328529362464143	false	false	false	true
3a9455ab-fdb4-4404-b096-881b3c1831c7	2026-09-29 09:35	2026-09-29 09:35	2026-09-29 09:35	SMH	SMH261016P00582500	put	582.5000	2026-10-16	7.8500	7.5000	7.9000	606.2500	17265.00	3140.00	14125.00	22	5	45	250	0.18	0.343293691215826	0.343293691215826	true	false	false	true
93d5009a-3ed8-4627-8de3-f7877e3cdceb	2026-09-29 09:32	2026-09-29 09:32	2026-09-29 09:32	SMH	SMH260929P00607500	put	607.5000	2026-09-29	2.2000	2.0100	2.9000	608.9900	35267.00	11109.00	24158.00	160	29	167	169	0.988165680473373	0.426881962064234	0.417114184217524	true	false	false	true
49e8ed8b-8b5c-4d11-a2f2-b92ceb3c7663	2026-09-29 09:32	2026-09-29 09:32	2026-09-29 09:32	SMH	SMH261120P00585000	put	585.0000	2026-11-20	21.4600	21.4500	22.3000	608.5100	17165.00	0.00	17165.00	8	6	14	3134	0.00446713465220166	0.371127597350883	0.371127597350883	true	false	false	true
896ada07-4bc5-4b81-bd11-40c46d500a34	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261009C00615000	call	615.0000	2026-10-09	9.9000	9.9000	10.0000	608.4500	40590.00	0.00	40590.00	41	6	47	1547	0.0303813833225598	0.312586322814268	0.312586322814268	false	false	false	true
22a56622-1458-4eb5-b1bd-424a0506ef9a	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261009C00620000	call	620.0000	2026-10-09	7.9500	7.9000	8.3000	608.4500	16695.00	0.00	16695.00	21	8	34	783	0.0434227330779055	0.312020736951995	0.312020736951995	false	false	false	true
0f9e0c23-ed5e-4c3f-a213-2e8a818a6d49	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261009C00622500	call	622.5000	2026-10-09	7.0500	7.0500	7.1500	608.4500	30315.00	0.00	30315.00	43	6	43	283	0.151943462897526	0.310774920788925	0.310774920788925	false	false	false	true
09ceed8e-59c3-44e1-9e29-034f202d53be	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261009C00625000	call	625.0000	2026-10-09	6.3000	6.2500	6.8000	608.4500	13230.00	630.00	11970.00	21	8	23	770	0.0298701298701299	0.311668159696316	0.311668159696316	true	false	false	true
348aeedd-76b0-4915-ae0c-7c0662d8c4df	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261009C00620000	call	620.0000	2026-10-09	8.0000	7.9500	8.5500	608.7050	10395.00	800.00	9595.00	13	5	13	783	0.016602809706258	0.310815215240841	0.309509679905915	true	false	false	true
c3886084-6c3c-4dfa-b424-47404d0969a9	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261009P00602500	put	602.5000	2026-10-09	9.7000	9.6000	10.6000	608.8999	19405.00	9705.00	8730.00	20	6	40	62	0.645161290322581	0.323424774671644	0.324706028690081	true	false	false	true
f6e9666a-aed0-4e38-8b37-f3ceca8d9409	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261001P00605000	put	605.0000	2026-10-01	5.3500	5.3500	6.0500	608.5400	31565.00	0.00	31565.00	59	8	60	58	1.03448275862069	0.392658449507632	0.392658449507632	true	false	false	true
3848227d-c0ac-40ea-8b84-cbfa92c0cfa1	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261001P00597500	put	597.5000	2026-10-01	3.0000	3.0000	3.5000	608.6700	21600.00	0.00	21600.00	72	23	73	14	5.21428571428571	0.407716088613925	0.410046644263303	false	false	false	true
fda6e398-d2c5-4750-b236-1c66ac60573a	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261002C00617500	call	617.5000	2026-10-02	4.5500	4.4000	5.1500	607.8210	13645.00	1375.00	11820.00	30	14	30	388	0.077319587628866	0.377385434291406	0.381706653761715	true	false	false	true
cb0e7b7a-f541-4420-815f-6b8c42ef7a9a	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261002C00620000	call	620.0000	2026-10-02	3.9900	3.8000	4.0500	607.8210	38660.00	0.00	38660.00	97	15	108	2550	0.0423529411764706	0.388257361177248	0.381786966819589	true	false	false	true
9959158a-d00b-4260-a4c1-e8f62899052e	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH260930C00650000	call	650.0000	2026-09-30	0.3000	0.2700	0.4500	608.0800	16350.00	30.00	16320.00	545	9	569	15	37.9333333333333	0.693807256417148	0.693807256417148	true	false	false	true
6175e111-0423-41f9-b196-af67d19a7dfb	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261023C00625000	call	625.0000	2026-10-23	13.4000	13.0000	14.3500	607.8800	30815.00	1330.00	28140.00	23	9	23	235	0.0978723404255319	0.320804111582483	0.319138496299169	false	false	false	true
2c01aed2-fa7f-4792-9733-b769b1db7c59	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH260929P00600000	put	600.0000	2026-09-29	0.8400	0.8400	0.9700	607.8210	17304.00	0.00	17304.00	206	5	218	186	1.17204301075269	0.522311987302461	0.522311987302461	false	false	false	true
007541a2-6fbf-46bc-b3db-37b7f54bc59b	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261009P00525000	put	525.0000	2026-10-09	0.5300	0.5300	0.6200	607.8800	12402.00	0.00	12402.00	234	6	235	261	0.900383141762452	0.477639996699206	0.476773984531391	false	false	false	true
8d23ff5b-4dac-46dd-9de7-4f7373cf1ef3	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261002P00530000	put	530.0000	2026-10-02	0.3100	0.3100	0.4300	607.9200	11160.00	0.00	11160.00	360	13	401	15299	0.0262108634551278	0.750551939193105	0.750551939193105	true	false	false	true
9e557203-a24d-4bfc-99e5-635256456a41	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH261002P00567500	put	567.5000	2026-10-02	0.7300	0.6700	0.9300	608.2400	45041.00	72.00	44969.00	617	8	617	575	1.07304347826087	0.501962917267566	0.500438147891641	true	false	false	true
84964c1a-a792-4f0d-9f5f-c061ae46f8ab	2026-09-29 09:31	2026-09-29 09:31	2026-09-29 09:31	SMH	SMH260930P00587500	put	587.5000	2026-09-30	0.7800	0.7400	1.0200	607.9500	15256.00	5580.00	7604.00	196	9	376	70	5.37142857142857	0.51031621689183	0.50848060246779	true	false	false	true
ade57780-01ff-47f7-8933-1fa01d02ce43	2026-09-28 15:59	2026-09-28 15:58	2026-09-28 15:58	SMH	SMH261023P00582500	put	582.5000	2026-10-23	12.8000	12.4500	13.2000	600.0000	24325.00	0.00	24325.00	19	5	113	69	1.63768115942029	0.344535487571264	0.344535487571264	false	false	false	true