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.

474,253 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts474,253 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:endpoint = /api/option-trades/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

661ea6f4-15fe-498a-ab36-b9df7e0ca538	2026-09-25 15:05	2026-09-25 15:05	2026-09-25 15:05	SMH	SMH261009C00625000	call	625.0000	2026-10-09	7.4500	6.9500	7.5500	606.0000	17880.00	17135.00	745.00	24	5	151	712	0.212078651685393	0.301767594600305	0.301767594600305	true	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ETF	—	74129314174.00	—	—	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-25T19:10:45.993353Z"}	2026-09-25	2026-09-25 21:15	2026-09-25 21:15
0e59b1cc-a4d7-46ca-a92a-ae3fbd41c0af	2026-09-25 15:04	2026-09-25 15:04	2026-09-25 15:04	SMH	SMH261030C00630000	call	630.0000	2026-10-30	16.2500	15.7500	16.3500	606.0000	26000.00	24375.00	1625.00	16	7	39	152	0.256578947368421	0.33353762893325	0.33353762893325	false	false	false	true
5af2f032-fd06-429c-8a2d-1f66581e683a	2026-09-25 15:03	2026-09-25 15:03	2026-09-25 15:03	SMH	SMH261002P00585000	put	585.0000	2026-10-02	3.3000	3.2500	3.3000	605.0000	186211.00	171586.00	14625.00	565	47	1172	1275	0.91921568627451	0.327225719032391	0.32747322026281	false	false	false	true
07e482c7-0c3c-4486-8042-41954d349ad9	2026-09-25 15:03	2026-09-25 15:03	2026-09-25 15:03	SMH	SMH261002P00590000	put	590.0000	2026-10-02	4.3400	4.3000	4.3500	605.0000	71566.00	58666.00	12900.00	165	21	574	880	0.652272727272727	0.31982947668623	0.31982947668623	false	false	false	true
012c4697-0194-4dc3-b7ea-73ea2b6d47d9	2026-09-25 15:03	2026-09-25 15:03	2026-09-25 15:03	SMH	SMH261002P00570000	put	570.0000	2026-10-02	1.4300	1.2700	1.4600	605.0000	16034.00	15751.00	283.00	112	30	330	14058	0.0234741784037559	0.354230244371829	0.354424271340369	true	false	false	true
bd3e579b-4922-4787-b7bc-89d0453650f5	2026-09-25 15:03	2026-09-25 15:03	2026-09-25 15:03	SMH	SMH261009P00577500	put	577.5000	2026-10-09	4.9000	4.5500	4.9000	605.0000	13230.00	13230.00	0.00	27	11	64	46	1.39130434782609	0.330150991488839	0.330150991488839	false	false	false	true
0d5563b2-2a89-40e5-80b5-a157eeb7b72c	2026-09-25 15:03	2026-09-25 15:03	2026-09-25 15:03	SMH	SMH261016P00577500	put	577.5000	2026-10-16	7.9000	7.5000	7.9000	605.0000	16580.00	15010.00	1570.00	21	11	60	185	0.324324324324324	0.339236269912707	0.339236269912707	false	false	false	true
0847dc26-c85f-4930-895f-dc6e17084621	2026-09-25 14:59	2026-09-25 14:59	2026-09-25 14:59	SMH	SMH260929C00612500	call	612.5000	2026-09-29	3.2500	3.1500	3.5000	606.0000	12025.00	325.00	11700.00	37	15	398	5	79.6	0.226317523255511	0.227490022669625	true	false	false	true
cdb23e70-795f-4085-b660-89e25a546e7e	2026-09-25 14:59	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00640000	call	640.0000	2026-11-20	21.4600	21.4500	22.0000	606.0000	12875.00	0.00	12875.00	6	6	230	877	0.262257696693273	0.352498683591284	0.352498683591284	true	false	false	true
629406c3-802b-4b93-972a-d5dadd22edb7	2026-09-25 14:59	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261030C00700000	call	700.0000	2026-10-30	2.8800	2.8800	3.1000	606.0000	12960.00	0.00	12960.00	45	19	292	117	2.4957264957265	0.337764427760374	0.337764427760374	true	false	false	true
e50e098a-1da8-42ab-93ad-67c8df02fb20	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00620000	call	620.0000	2026-11-20	29.5500	29.5000	29.8500	606.0000	115244.00	2954.00	112290.00	39	16	235	1319	0.178165276724792	0.357872472843749	0.357817360006	true	false	false	true
da5b6d7c-2f16-45fb-ab3e-73856b9611b8	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH270115C00620000	call	620.0000	2027-01-15	45.5000	45.5000	45.5500	606.0000	113750.00	0.00	113750.00	25	6	35	1346	0.0260029717682021	0.358372038193534	0.358216068623924	false	false	false	true
d9d5c6b3-10c2-4ed5-92a1-1afd5dbf45f2	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120P00580000	put	580.0000	2026-11-20	21.4000	21.4000	21.9000	606.0000	380928.00	0.00	380928.00	178	22	194	599	0.323873121869783	0.372427711298132	0.372543070310787	false	false	false	true
c6455bff-abee-42d5-be2e-2d5355ca2aaa	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00660000	call	660.0000	2026-11-20	15.3000	15.3000	15.3500	606.0000	185140.00	0.00	185140.00	121	21	152	1155	0.131601731601732	0.350459449127273	0.350495936821762	false	false	false	true
c2a312be-4ba0-4ba5-9c45-2c84260064c9	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00635000	call	635.0000	2026-11-20	23.3100	23.3000	23.9000	606.0000	179458.00	0.00	179458.00	77	12	102	1437	0.0709812108559499	0.353858195328248	0.353902491840208	false	false	false	true
8d1e6890-6370-45fc-a2a3-587cb412e1c6	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00640000	call	640.0000	2026-11-20	21.4500	21.4500	22.0500	606.0000	358215.00	0.00	358215.00	167	20	224	877	0.255416191562144	0.352670407890783	0.352712906230274	false	false	false	true
16dbb86b-65b5-4c65-a2b3-fdec1d1e19a9	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261120C00630000	call	630.0000	2026-11-20	25.2000	25.2000	25.9000	606.0000	123480.00	0.00	123480.00	49	13	58	578	0.100346020761246	0.354421709293595	0.354235005464215	false	false	false	true
13c401c1-833a-4696-9ab5-19cc61bc2cf6	2026-09-25 14:58	2026-09-25 14:58	2026-09-25 14:58	SMH	SMH261218P00585000	put	585.0000	2026-12-18	30.1000	30.1000	30.1500	606.0000	192642.00	0.00	189632.00	64	19	65	2063	0.0315075133301018	0.37307951467584	0.373213053169386	false	false	false	true
1855ff86-04b5-4e7e-a14c-6890c88e8f58	2026-09-25 14:55	2026-09-25 14:55	2026-09-25 14:55	SMH	SMH260925C00597500	call	597.5000	2026-09-25	8.9000	7.6000	10.2000	606.0000	97912.00	21360.00	73882.00	110	14	171	1983	0.086232980332829	1.06763748859816	1.61510933054682	false	false	false	true
bfdaa997-ac50-437f-9035-d9cd490fa640	2026-09-25 14:42	2026-09-25 14:42	2026-09-25 14:42	SMH	SMH260928P00590000	put	590.0000	2026-09-28	0.5300	0.5300	0.5800	606.7200	11077.00	0.00	11077.00	209	21	862	65	13.2615384615385	0.233028542239492	0.233028542239492	false	false	false	true
04ab3950-d8c5-449b-a830-1a7f13435ac7	2026-09-25 14:42	2026-09-25 14:42	2026-09-25 14:42	SMH	SMH260928P00587500	put	587.5000	2026-09-28	0.4000	0.4000	0.4700	606.7200	18360.00	0.00	18360.00	459	54	731	196	3.72959183673469	0.242059666236785	0.242059666236785	false	false	false	true
6fd39a17-d8f9-403b-846a-252260544a9b	2026-09-25 14:42	2026-09-25 14:42	2026-09-25 14:42	SMH	SMH261002P00597500	put	597.5000	2026-10-02	6.2500	6.2500	6.3500	606.6700	13750.00	0.00	13750.00	22	14	384	75	5.12	0.311615811019884	0.311615811019884	true	false	false	true
2556abd9-6a42-4bee-bcc7-5cff7e76461b	2026-09-25 14:42	2026-09-25 14:42	2026-09-25 14:42	SMH	SMH261002C00620000	call	620.0000	2026-10-02	5.0900	5.0500	5.1500	606.6700	18340.00	0.00	17830.00	36	7	513	2159	0.237610004631774	0.301643313685887	0.303316882220326	true	false	false	true
3fcc6966-4cbd-4029-94bf-5d4c55eb0518	2026-09-25 14:42	2026-09-25 14:42	2026-09-25 14:42	SMH	SMH261002P00597500	put	597.5000	2026-10-02	6.2500	6.2500	6.3500	606.6700	13750.00	0.00	13750.00	22	8	347	75	4.62666666666667	0.311615811019884	0.311615811019884	true	false	false	true
a8cb25c7-7e96-4dab-9f5a-035f0e6de334	2026-09-25 14:40	2026-09-25 14:39	2026-09-25 14:39	SMH	SMH261120C00650000	call	650.0000	2026-11-20	18.4900	18.2500	19.0500	606.4800	12940.00	1840.00	11100.00	7	5	1418	5823	0.243517087411987	0.354906039956438	0.353770252543927	false	false	false	true
195cfff3-7a30-4fb8-a50d-f8e77b00e9f8	2026-09-25 14:37	2026-09-25 14:37	2026-09-25 14:37	SMH	SMH261009C00610000	call	610.0000	2026-10-09	13.5500	13.5500	13.9500	607.1350	73170.00	0.00	73170.00	54	21	205	477	0.429769392033543	0.305092849958462	0.305092849958462	true	false	false	true
977417c4-96fe-45dc-ae7e-0f08d755c3ec	2026-09-25 14:31	2026-09-25 14:31	2026-09-25 14:31	SMH	SMH260928P00590000	put	590.0000	2026-09-28	0.5200	0.5200	0.5900	607.4258	16900.00	0.00	16900.00	325	29	631	65	9.70769230769231	0.238927496719351	0.238927496719351	false	false	false	true
6d2e161a-e3da-4c0a-8cee-11a035c7f8ba	2026-09-25 14:31	2026-09-25 14:31	2026-09-25 14:31	SMH	SMH261030P00567500	put	567.5000	2026-10-30	10.5500	10.5500	10.7000	607.3250	34825.00	0.00	34825.00	33	12	35	67	0.522388059701492	0.365351526839203	0.365351526839203	true	false	false	true
500f6974-affe-4014-8d26-5cb8209e6cae	2026-09-25 14:31	2026-09-25 14:31	2026-09-25 14:31	SMH	SMH261016P00600000	put	600.0000	2026-10-16	14.7000	14.2000	15.1500	607.3900	51445.00	1465.00	49980.00	35	8	913	6175	0.147854251012146	0.325074721177681	0.324337285694075	true	false	false	true
e0796802-254b-4e08-8ac8-b35cb966cdfb	2026-09-25 14:16	2026-09-25 14:16	2026-09-25 14:16	SMH	SMH260928P00600000	put	600.0000	2026-09-28	1.6900	1.6900	1.7700	608.0100	62530.00	0.00	62530.00	370	51	823	49	16.7959183673469	0.216145560367603	0.2150266444783	false	false	false	true
fce79fcf-cf7e-4da7-a1d7-462cbf10f3be	2026-09-25 14:13	2026-09-25 14:13	2026-09-25 14:13	SMH	SMH261030C00655000	call	655.0000	2026-10-30	9.5500	9.3500	9.6000	607.9200	21965.00	21965.00	0.00	23	5	87	311	0.279742765273312	0.333530977242362	0.333530977242362	true	false	false	true
79ec8fa9-5e44-40aa-aae0-bc29b829c911	2026-09-25 14:11	2026-09-25 14:11	2026-09-25 14:11	SMH	SMH261218P00550000	put	550.0000	2026-12-18	18.6000	18.6000	19.0000	607.4649	50220.00	0.00	50220.00	27	9	118	2531	0.0466218885815883	0.389934543747717	0.389934543747717	true	false	false	true
021c0176-c48c-4b01-9352-49afe49c08ac	2026-09-25 14:11	2026-09-25 14:11	2026-09-25 14:11	SMH	SMH261218P00535000	put	535.0000	2026-12-18	14.9900	14.9500	15.5500	607.4764	32985.00	7525.00	25460.00	22	9	69	416	0.165865384615385	0.398487971989381	0.397291795981621	true	false	false	true
9a1d995e-4fdd-4393-a09d-521106fc9341	2026-09-25 14:03	2026-09-25 14:03	2026-09-25 14:03	SMH	SMH261120C00650000	call	650.0000	2026-11-20	19.0500	18.7500	19.0500	607.0000	34290.00	34290.00	0.00	18	5	1411	5823	0.242314957925468	0.357448095927338	0.357448095927338	false	false	false	true
a78fd9b7-0738-48e9-ab10-b748c8d3e5b0	2026-09-25 13:58	2026-09-25 13:58	2026-09-25 13:58	SMH	SMH261016P00590000	put	590.0000	2026-10-16	11.1000	10.8500	11.5000	607.6000	35520.00	0.00	34410.00	32	19	368	4776	0.0770519262981574	0.333855721108555	0.333855721108555	true	false	false	true
d52e3e91-9cbb-4d0c-8e56-ec1de706290e	2026-09-25 13:58	2026-09-25 13:58	2026-09-25 13:58	SMH	SMH261120C00720000	call	720.0000	2026-11-20	5.4500	5.4500	5.6500	607.5600	24525.00	0.00	24525.00	45	10	47	705	0.0666666666666667	0.35589911992479	0.35589911992479	false	false	false	true
809fe4cd-406a-4356-ad85-de91f6ff2ac2	2026-09-25 13:56	2026-09-25 13:56	2026-09-25 13:56	SMH	SMH260928C00625000	call	625.0000	2026-09-28	0.4000	0.4000	0.4500	607.4450	22440.00	0.00	22440.00	561	54	819	20	40.95	0.215167187598816	0.215167187598816	false	false	false	true
055fbc0d-079e-4f76-baa1-e2b580af3ac2	2026-09-25 13:51	2026-09-25 13:51	2026-09-25 13:51	SMH	SMH261023C00622500	call	622.5000	2026-10-23	16.2500	16.2500	16.7000	607.7400	19500.00	0.00	19500.00	12	9	36	22	1.63636363636364	0.325514404421843	0.325514404421843	false	false	false	true
ed477197-86cb-4aa2-b687-5b8efd83be8e	2026-09-25 13:39	2026-09-25 13:38	2026-09-25 13:38	SMH	SMH261002C00600000	call	600.0000	2026-10-02	15.0000	14.4000	15.3000	607.0000	15000.00	9000.00	6000.00	10	5	367	2608	0.140720858895706	0.320903695106564	0.320903695106564	false	false	false	true
275bac22-c59e-46c2-af70-af6d75660d15	2026-09-25 13:34	2026-09-25 13:34	2026-09-25 13:34	SMH	SMH261002P00602500	put	602.5000	2026-10-02	8.1000	7.7000	8.1000	607.0000	28350.00	28350.00	0.00	35	8	939	105	8.94285714285714	0.319285823971294	0.319285823971294	false	false	false	true
0dfc700f-4dde-43af-8148-dccd6d045e69	2026-09-25 13:34	2026-09-25 13:34	2026-09-25 13:34	SMH	SMH261002P00610000	put	610.0000	2026-10-02	11.6000	11.4500	11.6000	607.0000	37120.00	37120.00	0.00	32	16	54	22	2.45454545454545	0.316111355003044	0.316111355003044	true	false	false	true
0826f863-eb52-4ab3-802e-a827c946dfb5	2026-09-25 13:34	2026-09-25 13:34	2026-09-25 13:34	SMH	SMH261002P00607500	put	607.5000	2026-10-02	10.3000	9.9500	10.3500	607.0000	62830.00	61800.00	0.00	61	11	171	37	4.62162162162162	0.31595763510223	0.31595763510223	false	false	false	true
010956f6-9ae2-480c-aacb-f65f7bdd0cda	2026-09-25 13:34	2026-09-25 13:34	2026-09-25 13:34	SMH	SMH261002P00605000	put	605.0000	2026-10-02	9.1500	8.8000	9.2000	607.0000	29280.00	28365.00	915.00	32	8	304	127	2.39370078740157	0.317497065150015	0.317497065150015	false	false	false	true
47d0f385-71c9-4bd8-b3af-506887127e2f	2026-09-25 13:33	2026-09-25 13:33	2026-09-25 13:33	SMH	SMH260928P00512500	put	512.5000	2026-09-28	0.0500	0.0100	0.2400	607.0000	55494.00	0.00	55494.00	12332	2	15037	22	683.5	0.702060908281748	0.702060908281748	false	true	false	true
dea489c6-f79b-48b3-ab68-5b5a06de1d00	2026-09-25 13:26	2026-09-25 13:26	2026-09-25 13:26	SMH	SMH261002P00415000	put	415.0000	2026-10-02	0.0600	0.0200	0.0600	608.0000	82500.00	82500.00	0.00	15000	2	15181	132	115.007575757576	0.982937808024101	0.982937808024101	false	true	false	true
2593aea9-e5c5-4f84-aba5-02ccb5e20985	2026-09-25 13:26	2026-09-25 13:26	2026-09-25 13:26	SMH	SMH261030C00640000	call	640.0000	2026-10-30	14.0500	14.0000	14.2500	608.0000	30910.00	0.00	30910.00	22	6	108	84	1.28571428571429	0.340517118435233	0.340517118435233	false	false	false	true
3e7ae415-2aa8-43a9-914d-3c5680b392a2	2026-09-25 13:20	2026-09-25 13:20	2026-09-25 13:20	SMH	SMH261023C00635000	call	635.0000	2026-10-23	12.0500	12.0500	12.2500	608.0000	14460.00	0.00	14460.00	12	6	81	154	0.525974025974026	0.326046831792959	0.326046831792959	false	false	false	true
833eb2ee-874d-42e0-bb07-3a0d87d5910e	2026-09-25 13:18	2026-09-25 13:18	2026-09-25 13:18	SMH	SMH261030C00635000	call	635.0000	2026-10-30	15.8000	15.8000	16.2500	608.0000	48980.00	0.00	48980.00	31	9	42	232	0.181034482758621	0.34009013492454	0.34009013492454	false	false	false	true
46977138-7afb-45d6-a624-20906ce994bb	2026-09-25 13:17	2026-09-25 13:17	2026-09-25 13:17	SMH	SMH261030P00565000	put	565.0000	2026-10-30	10.1500	10.1500	10.6000	608.0000	20300.00	0.00	20300.00	20	6	34	87	0.390804597701149	0.374831032968808	0.374831032968808	false	false	false	true
c6c9c88f-9e9a-465b-ab7b-9d7e40073ff3	2026-09-25 13:13	2026-09-25 13:13	2026-09-25 13:13	SMH	SMH261009C00612500	call	612.5000	2026-10-09	13.5500	13.1500	13.5500	608.0000	16260.00	16260.00	0.00	12	7	167	21	7.95238095238095	0.316297138807072	0.316297138807072	true	false	false	true