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.

728,802 rows

Sources in this table

uw_flow_alerts728,802 rows

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:option_symbol = SMH261002P00592500×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate

9ecaf8ec-c475-4ba9-9354-82408c8a2102	2026-09-29 12:53	2026-09-29 12:53	2026-09-29 12:53	SMH	SMH261002P00592500	put	592.5000	2026-10-02	2.9800	2.7800	2.9800	606.7800	85228.00	85228.00	0.00	286	7	955	842	1.13420427553444	0.382001337756231	0.382001337756231	false	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-29T16:54:42.907148Z"}	2026-09-29	2026-09-29 21:15	2026-09-29 21:15
ccbcdc7b-3e89-48a2-b53b-61cd6390bc59	2026-09-29 12:38	2026-09-29 12:38	2026-09-29 12:38	SMH	SMH261002P00592500	put	592.5000	2026-10-02	2.5900	2.5500	2.7800	608.0000	15020.00	256.00	14764.00	58	28	667	842	0.792161520190024	0.381819500121738	0.379944478446591	true	false	false	true	false
4d8fc0b7-8ed8-4e91-a2a3-4da4f763dae8	2026-09-28 15:00	2026-09-28 15:00	2026-09-28 15:00	SMH	SMH261002P00592500	put	592.5000	2026-10-02	5.2500	5.0000	5.2500	601.4300	13125.00	13125.00	0.00	25	8	353	770	0.458441558441558	0.365856998001455	0.365856998001455	false	false	false	true	false
b2d2fe7b-f12c-418b-bbcf-115576e4ef85	2026-09-28 09:31	2026-09-28 09:31	2026-09-28 09:31	SMH	SMH261002P00592500	put	592.5000	2026-10-02	4.6500	4.6500	5.2500	604.9600	26520.00	475.00	26045.00	57	8	57	770	0.074025974025974	0.391975098243044	0.393215466221881	true	false	false	true	false
b124b2fd-4112-4a8c-b183-618597be3146	2026-09-25 11:45	2026-09-25 11:45	2026-09-25 11:45	SMH	SMH261002P00592500	put	592.5000	2026-10-02	6.1000	5.5500	6.1000	603.1000	52460.00	52460.00	0.00	86	13	206	643	0.320373250388802	0.325173150631526	0.325173150631526	false	false	false	true	false
607805f2-7fa3-4427-9fd3-8873cbd8a735	2026-09-25 11:40	2026-09-25 11:40	2026-09-25 11:40	SMH	SMH261002P00592500	put	592.5000	2026-10-02	5.8500	5.8500	6.1500	603.0000	15795.00	0.00	15795.00	27	5	119	643	0.1850699844479	0.323518125614209	0.323518125614209	false	false	false	true	false
1c93253f-0a46-442f-b48c-9b410b5fd79c	2026-09-25 10:13	2026-09-25 10:13	2026-09-25 10:13	SMH	SMH261002P00592500	put	592.5000	2026-10-02	5.3000	4.9500	5.3000	607.1600	20140.00	20140.00	0.00	38	8	58	643	0.0902021772939347	0.340673913681724	0.340673913681724	false	false	false	true	false
4e96f51e-ec75-4404-9bfa-b9068ad83723	2026-09-23 12:50	2026-09-23 12:50	2026-09-23 12:50	SMH	SMH261002P00592500	put	592.5000	2026-10-02	10.3000	9.5500	10.3000	596.2850	19570.00	19570.00	0.00	19	10	358	119	3.00840336134454	0.332139056617159	0.332139056617159	true	false	false	true	false
bc251497-8ade-4b0f-a6bd-da3ef05bc92d	2026-09-22 09:55	2026-09-22 09:55	2026-09-22 09:55	SMH	SMH261002P00592500	put	592.5000	2026-10-02	9.8000	9.4500	9.8000	598.9700	17640.00	17640.00	0.00	18	7	49	68	0.720588235294118	0.332249844199311	0.331934745207557	false	false	false	true	false
1e27bcf6-b326-4183-a155-9c72e5d5eeb0	2026-09-22 09:51	2026-09-22 09:51	2026-09-22 09:51	SMH	SMH261002P00592500	put	592.5000	2026-10-02	9.9500	9.9000	10.3000	598.2300	17910.00	0.00	16915.00	18	5	20	68	0.294117647058824	0.327998863449957	0.327998863449957	false	false	false	true	false
bb574b85-02df-4fc8-b6a3-70f88091f0ef	2026-09-21 14:31	2026-09-21 14:31	2026-09-21 14:31	SMH	SMH261002P00592500	put	592.5000	2026-10-02	12.2000	12.2000	12.5500	594.0000	45140.00	0.00	45140.00	37	6	55	11	5	0.333060184541091	0.333060184541091	false	false	false	true	false