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.

375,978 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts375,978 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×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	expiry

6cc8b490-6f17-47a3-8ce1-a104a33fb2ae	2026-09-23 15:59	2026-09-23 15:59	2026-09-23 15:59	SMH	SMH260923C00560000	call	560.0000	2026-09-23	40.4000	39.4000	41.2000	600.0000	129280.00	36360.00	92920.00	32	7	74	1290	0.0573643410852713	35.2749678248985	34.7659749289255	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	73983691780.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500}	2026-09-23	2026-09-23 21:15	2026-09-23 21:15
dba6f84f-9c87-4d18-86dc-8b8b840ea432	2026-09-23 15:59	2026-09-23 15:58	2026-09-23 15:58	SMH	SMH260925P00595000	put	595.0000	2026-09-25	3.4500	3.3000	3.4500	600.0000	38293.00	38293.00	0.00	111	25	1239	717	1.72803347280335	0.331191697754521	0.331191697754521	false	false	false	true
0b710d8c-bec7-4db8-8eb6-2055a4b4ea15	2026-09-23 15:59	2026-09-23 15:58	2026-09-23 15:58	SMH	SMH260925C00612500	call	612.5000	2026-09-25	1.5900	1.4200	1.6100	600.0000	31005.00	29097.00	1908.00	195	36	377	769	0.490247074122237	0.315055394033968	0.315055394033968	false	false	false
2899bae0-d209-4e50-a92b-33705724f37a	2026-09-23 15:57	2026-09-23 15:57	2026-09-23 15:57	SMH	SMH261030C00635000	call	635.0000	2026-10-30	13.6500	13.2500	13.9500	599.9500	66885.00	8190.00	27300.00	49	6	83	146	0.568493150684932	0.342669700899418	0.342669700899418	true	false	false
f8d44944-0d2c-41d6-8a63-8817d89082e3	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SMH	SMH261120C00635000	call	635.0000	2026-11-20	21.6000	21.6000	22.1500	599.6300	41045.00	2165.00	38880.00	19	10	57	1410	0.0404255319148936	0.358421430785361	0.358421430785361	true	false	false
2983f61e-886f-4246-b71a-6d12fefde949	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SMH	SMH261120C00655000	call	655.0000	2026-11-20	15.4500	15.4500	15.5000	599.6300	30900.00	0.00	30900.00	20	7	43	377	0.114058355437666	0.355293774273591	0.355293774273591	false	false	false	true
224660c1-e8c2-4b41-93d0-caa34005695a	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SMH	SMH261120C00630000	call	630.0000	2026-11-20	23.4000	23.4000	24.0000	599.6300	70200.00	0.00	70200.00	30	12	40	357	0.112044817927171	0.359359770724205	0.359359770724205	false	false	false	true
e65d77e4-75d7-4035-943c-5931cadd3f12	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SMH	SMH261030C00630000	call	630.0000	2026-10-30	15.3000	15.3000	15.3500	599.7250	42840.00	0.00	42840.00	28	5	109	98	1.11224489795918	0.345411971770941	0.345411971770941	true	false	false	true
c5dd43df-2224-4b90-a1fe-82efc30f5ba2	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SMH	SMH261030C00610000	call	610.0000	2026-10-30	23.2500	23.2000	24.8500	599.7500	248775.00	11625.00	237150.00	107	17	128	83	1.5421686746988	0.35168266939109	0.351525972031479	false	false	false
c48c8e25-2f2a-4b18-a767-4a63f2d6e531	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SMH	SMH261030P00580000	put	580.0000	2026-10-30	17.4000	17.3500	18.5000	599.7500	107880.00	13920.00	92220.00	62	9	90	12	7.5	0.36180332053906	0.361927141847273	true	false	false	true
ad275b33-483b-4af4-a3f4-7ebd76d24e6f	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SMH	SMH261030C00615000	call	615.0000	2026-10-30	21.0500	21.0500	22.6000	599.7250	199980.00	2110.00	197870.00	95	19	109	146	0.746575342465753	0.35010844238449	0.35010844238449	true	false	false
5980a5be-d855-40ac-b9d7-6841f28778a0	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SMH	SMH261030P00577500	put	577.5000	2026-10-30	16.5500	16.5500	17.5500	599.7200	59580.00	0.00	59580.00	36	7	56	11	5.09090909090909	0.363427174376018	0.363402997636777	true	false	false	true
5719d54a-8057-4745-a28d-0c21895875d7	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SMH	SMH261030C00620000	call	620.0000	2026-10-30	18.9500	18.9500	20.5500	599.7250	72010.00	0.00	72010.00	38	6	70	205	0.341463414634146	0.347959036487756	0.347959036487756	false	false	false	true
5208a0e9-a364-47ca-b645-d3836aab00ca	2026-09-23 15:56	2026-09-23 15:56	2026-09-23 15:56	SMH	SMH261030C00625000	call	625.0000	2026-10-30	17.1000	17.1000	17.7000	599.7500	244530.00	0.00	244530.00	143	21	201	163	1.23312883435583	0.347280433165651	0.347147456645311	true	false	false
58109fb4-53f7-40f1-a043-71ef3b0acfd6	2026-09-23 15:55	2026-09-23 15:55	2026-09-23 15:55	SMH	SMH270115P00510000	put	510.0000	2027-01-15	15.2000	15.0500	15.2000	600.0000	41040.00	41040.00	0.00	27	5	109	513	0.212475633528265	0.401511251913573	0.401511251913573	false	false	false	true
be0755c7-18db-4ff1-9693-1533d1737d41	2026-09-23 15:43	2026-09-23 15:43	2026-09-23 15:43	SMH	SMH261016P00575000	put	575.0000	2026-10-16	10.1000	10.1000	10.2000	600.0000	102010.00	0.00	102010.00	101	5	311	720	0.431944444444444	0.35293833822331	0.35293833822331	true	false	false	true
1ee7f120-0d7c-40a1-8bb9-2d271e68bdfd	2026-09-23 15:43	2026-09-23 15:43	2026-09-23 15:43	SMH	SMH261120C00620000	call	620.0000	2026-11-20	27.9000	27.9000	28.4500	600.0000	86490.00	0.00	86490.00	31	8	86	1307	0.0657995409334353	0.364869853526201	0.364869853526201	false	false	false
5d997831-6ef7-4468-8077-2b58e6daddad	2026-09-23 15:43	2026-09-23 15:42	2026-09-23 15:42	SMH	SMH261016P00595000	put	595.0000	2026-10-16	17.1500	17.1500	17.5000	600.0000	15435.00	0.00	15435.00	9	8	400	425	0.941176470588235	0.341057500997193	0.341057500997193	false	false	false	true
4ea84c8b-b6a5-4f64-9db1-19281e9c787c	2026-09-23 15:40	2026-09-23 15:40	2026-09-23 15:40	SMH	SMH260930C00605000	call	605.0000	2026-09-30	8.1000	7.5500	8.1000	601.0400	153900.00	153900.00	0.00	190	5	2289	70	32.7	0.292790175990337	0.292790175990337	true	false	false	true
928efa6c-48e3-4ca1-9783-9855107f3c01	2026-09-23 15:36	2026-09-23 15:36	2026-09-23 15:36	SMH	SMH260930C00605000	call	605.0000	2026-09-30	7.9000	7.5000	7.9000	600.5234	158000.00	158000.00	0.00	200	5	2079	70	29.7	0.293730191726857	0.293730191726857	false	false	false	true
5f4eabd8-9948-4dfa-adc6-61f4b96685e1	2026-09-23 15:28	2026-09-23 15:28	2026-09-23 15:28	SMH	SMH261016P00560000	put	560.0000	2026-10-16	6.5500	6.5000	6.5500	599.0000	32750.00	32750.00	0.00	50	5	799	4784	0.167015050167224	0.363764897631051	0.363764897631051	false	false	false	true
47be8405-e9af-4310-9b66-1c65a151592f	2026-09-23 15:28	2026-09-23 15:28	2026-09-23 15:28	SMH	SMH261016P00560000	put	560.0000	2026-10-16	6.5500	6.5000	6.6500	600.0000	41920.00	37335.00	1965.00	64	16	749	4784	0.156563545150502	0.364003832692902	0.364003832692902	false	false	false	true
8961718f-0106-4cd3-82ed-a68b449fa143	2026-09-23 15:27	2026-09-23 15:27	2026-09-23 15:27	SMH	SMH270115P00595000	put	595.0000	2027-01-15	43.5500	43.3500	44.0000	599.0000	39195.00	0.00	39195.00	9	5	121	1148	0.105400696864111	0.375688836333005	0.375688836333005	false	false	false	true
df70289e-765e-4682-9a21-57f2d114dbd2	2026-09-23 15:24	2026-09-23 15:24	2026-09-23 15:24	SMH	SMH270115P00605000	put	605.0000	2027-01-15	48.4000	48.4000	48.9000	599.7900	48402.00	0.00	48402.00	10	5	11	193	0.0569948186528497	0.373636362942716	0.37388123114501	false	false	false	true
d40eb1c5-95bc-44c3-976a-fcf045eece96	2026-09-23 15:24	2026-09-23 15:24	2026-09-23 15:24	SMH	SMH270115P00590000	put	590.0000	2027-01-15	41.2800	41.2500	42.1000	599.7900	41280.00	8280.00	33000.00	10	5	18	669	0.0269058295964126	0.376600345829876	0.37675555287161	false	false	false	true
9a88d3e6-0a2f-43ce-a063-050c5b14eb77	2026-09-23 15:21	2026-09-23 15:21	2026-09-23 15:21	SMH	SMH261002C00600000	call	600.0000	2026-10-02	12.6000	12.3000	12.6000	600.0000	252000.00	252000.00	0.00	200	7	721	2646	0.272486772486772	0.327551204903522	0.327551204903522	false	false	false
ac12c15f-490b-4cd7-af38-02de10a3a1de	2026-09-23 15:21	2026-09-23 15:21	2026-09-23 15:21	SMH	SMH270115C00600000	call	600.0000	2027-01-15	52.5000	51.5000	53.0000	599.8500	693000.00	21000.00	672000.00	132	19	2185	2967	0.736434108527132	0.365733966672596	0.365733966672596	false	false	false
97d9dab4-e165-4d6a-8fe4-66d173c64f9c	2026-09-23 15:19	2026-09-23 15:19	2026-09-23 15:19	SMH	SMH261002P00590000	put	590.0000	2026-10-02	7.9000	7.9000	8.4000	599.8500	26070.00	0.00	26070.00	33	5	762	312	2.44230769230769	0.333559236612039	0.333559236612039	true	false	false	true
877f9e7d-9be6-4810-ac1e-c901d9bcf144	2026-09-23 15:17	2026-09-23 15:17	2026-09-23 15:17	SMH	SMH261016P00625000	put	625.0000	2026-10-16	34.6500	34.6000	35.1000	599.2000	72765.00	41580.00	31185.00	21	5	22	247	0.0890688259109312	0.331184780804543	0.331184780804543	false	false	false
9e6d2ce9-8935-41a0-bf1c-8fc898ff1f56	2026-09-23 15:17	2026-09-23 15:17	2026-09-23 15:17	SMH	SMH261002P00595000	put	595.0000	2026-10-02	10.0000	9.2500	10.2000	599.2700	37000.00	36000.00	1000.00	37	12	182	126	1.44444444444444	0.328308522847345	0.328308522847345	true	false	false	true
7247b607-8c34-410b-a669-620339601d5b	2026-09-23 15:12	2026-09-23 15:12	2026-09-23 15:12	SMH	SMH261023C00610000	call	610.0000	2026-10-23	19.5500	18.8000	19.9500	599.9500	35190.00	29325.00	5865.00	18	6	32	153	0.209150326797386	0.338304044775239	0.338304044775239	false	false	false
30ae8551-98e0-41a7-b129-70d9b43763ab	2026-09-23 15:11	2026-09-23 15:11	2026-09-23 15:11	SMH	SMH261218P00540000	put	540.0000	2026-12-18	17.9000	17.5000	18.6000	600.1300	23270.00	0.00	23270.00	13	5	170	5168	0.0328947368421053	0.391451710062385	0.391451710062385	false	false	false	true
b8b5f0ce-4ec8-4753-b692-ff954c348ba9	2026-09-23 15:09	2026-09-23 15:09	2026-09-23 15:09	SMH	SMH260925P00592500	put	592.5000	2026-09-25	2.5900	2.4000	2.5900	600.5189	17352.00	17352.00	0.00	67	10	809	230	3.51739130434783	0.327718784633343	0.327718784633343	true	false	false	true
56723491-b211-4892-ba1c-97757ad46d83	2026-09-23 15:07	2026-09-23 15:07	2026-09-23 15:07	SMH	SMH260925C00605000	call	605.0000	2026-09-25	3.5500	3.3500	3.5500	600.5500	33015.00	33015.00	0.00	93	9	1980	1115	1.77578475336323	0.307140239773635	0.305570497384519	true	false	false	true
50e51d9d-7b66-47d1-998e-1c419bfd5c1e	2026-09-23 15:07	2026-09-23 15:07	2026-09-23 15:07	SMH	SMH261218C00580000	call	580.0000	2026-12-18	57.0000	56.0000	57.0000	600.6000	108300.00	108300.00	0.00	19	10	123	979	0.125638406537283	0.374952314026822	0.374952314026822	false	false	false
b73a3967-90ba-4c72-a0a7-f94ce2c8d18b	2026-09-23 15:05	2026-09-23 15:05	2026-09-23 15:05	SMH	SMH261218C00800000	call	800.0000	2026-12-18	2.9100	2.7500	2.9100	599.6400	43650.00	43650.00	0.00	150	41	1653	2323	0.711579853637538	0.362033324279811	0.362033324279811	false	false	false
f6247e86-2000-43a7-a079-614a05db3de1	2026-09-23 15:03	2026-09-23 15:03	2026-09-23 15:03	SMH	SMH261030C00630000	call	630.0000	2026-10-30	15.5900	15.2000	16.0000	599.7900	32745.00	1545.00	31200.00	21	7	81	98	0.826530612244898	0.349272817591029	0.34717924529417	true	false	false	true
9e00d623-2515-46f9-a0f8-10dc9e87eff7	2026-09-23 14:56	2026-09-23 14:56	2026-09-23 14:56	SMH	SMH261002P00577500	put	577.5000	2026-10-02	4.4000	4.4000	4.4500	600.1350	22000.00	0.00	22000.00	50	14	172	106	1.62264150943396	0.346994802303859	0.346994802303859	false	false	false	true
3e3abd33-f9a0-45a2-a415-9efafb7d09b7	2026-09-23 14:56	2026-09-23 14:55	2026-09-23 14:55	SMH	SMH261218P00580000	put	580.0000	2026-12-18	31.1500	30.4500	31.1500	600.0800	224280.00	224280.00	0.00	72	30	502	718	0.6991643454039	0.376909272683924	0.376909272683924	false	false	false	true
1d202baa-6a9d-4f8e-8f42-921085d5bc7e	2026-09-23 14:52	2026-09-23 14:52	2026-09-23 14:52	SMH	SMH270917P00520000	put	520.0000	2027-09-17	43.4900	42.3500	45.0000	599.9799	587115.00	0.00	587115.00	135	2	135	27	5	0.394980946907285	0.394980946907285	false	true	false	true
2ee1eff5-c538-4002-902b-bd3ae5b8c769	2026-09-23 14:52	2026-09-23 14:52	2026-09-23 14:52	SMH	SMH261218P00540000	put	540.0000	2026-12-18	17.8500	17.6500	17.8500	600.0400	21420.00	21420.00	0.00	12	6	157	5168	0.0303792569659443	0.390661984998543	0.390661984998543	false	false	false	true
41c16249-977d-4547-849c-5455c3a5fa3e	2026-09-23 14:52	2026-09-23 14:52	2026-09-23 14:52	SMH	SMH261120P00550000	put	550.0000	2026-11-20	14.7900	14.7500	15.1500	600.2400	199665.00	0.00	199665.00	135	2	285	3332	0.0855342136854742	0.388748147575347	0.388748147575347	false	true	false
f9e0592e-3db3-4682-a4d5-f873c64c881e	2026-09-23 14:52	2026-09-23 14:51	2026-09-23 14:51	SMH	SMH261218C00580000	call	580.0000	2026-12-18	56.8000	55.9000	56.8000	600.2100	181760.00	170400.00	0.00	32	10	87	979	0.0888661899897855	0.375371899501794	0.375371899501794	true	false	false
4a6ca3a5-bcc2-4115-b3d2-980016abfbbf	2026-09-23 14:49	2026-09-23 14:49	2026-09-23 14:49	SMH	SMH261002C00630000	call	630.0000	2026-10-02	2.8400	2.7000	2.8400	600.0750	12779.00	12779.00	0.00	45	7	188	1091	0.172318973418882	0.320326159336573	0.320326159336573	true	false	false	true
bff2852f-39a8-4976-9431-667d10be98b0	2026-09-23 14:42	2026-09-23 14:42	2026-09-23 14:42	SMH	SMH261218P00540000	put	540.0000	2026-12-18	17.9500	17.6000	17.9500	599.7600	71800.00	71800.00	0.00	40	22	119	5168	0.0230263157894737	0.391017887564472	0.391017887564472	false	false	false
a1e64126-f0af-4f27-bd26-4ea1fc08f292	2026-09-23 14:42	2026-09-23 14:42	2026-09-23 14:42	SMH	SMH261218P00540000	put	540.0000	2026-12-18	17.9400	17.9500	18.2500	599.7600	14355.00	0.00	1790.00	8	6	127	5168	0.0245743034055728	0.391017887564472	0.391017887564472	true	false	false	true
39c348ea-4bf1-4600-813f-569af07d3696	2026-09-23 14:41	2026-09-23 14:41	2026-09-23 14:41	SMH	SMH261218P00540000	put	540.0000	2026-12-18	17.9500	17.6000	18.1250	599.5000	43080.00	43080.00	0.00	24	9	77	5168	0.0148993808049536	0.390325221537267	0.390325221537267	false	false	false	true
c793ab94-b936-464e-b036-f6c5ea83df48	2026-09-23 14:34	2026-09-23 14:34	2026-09-23 14:34	SMH	SMH261218C00580000	call	580.0000	2026-12-18	56.6000	55.5000	57.3000	599.9400	50940.00	50940.00	0.00	9	8	55	979	0.0561797752808989	0.375099896376337	0.375099896376337	false	false	false	true
ac18a23d-8e24-4c1e-a5f1-66badb39a455	2026-09-23 14:33	2026-09-23 14:32	2026-09-23 14:32	SMH	SMH261218P00580000	put	580.0000	2026-12-18	31.2500	30.4000	31.2500	599.7250	109375.00	109375.00	0.00	35	7	430	718	0.598885793871866	0.376621509669456	0.376621509669456	false	false	false	true
011b7240-f89f-47e6-8ad0-40fec1dec7cd	2026-09-23 14:27	2026-09-23 14:27	2026-09-23 14:27	SMH	SMH270115P00550000	put	550.0000	2027-01-15	25.8000	25.3000	26.3000	600.0400	77400.00	54180.00	10320.00	30	7	37	4239	0.00872847369662656	0.387602927829559	0.387602927829559	false	false	false