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:alert_rule = RepeatedHitsDescendingFill×endpoint = /api/option-trades/flow-alerts×ticker = IYR×

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

a7605abd-f67d-4ab7-b381-4146139e49c1	2026-10-01 10:58	2026-10-01 10:57	2026-10-01 10:57	IYR	IYR261009P00093000	put	93.0000	2026-10-09	0.6000	0.4000	0.6500	94.0500	28136.00	28136.00	0.00	469	40	492	14	35.1428571428571	0.194209004959051	0.194209004959051	true	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	ETF	—	4635050038.00	—	—	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-01T15:00:28.156843Z"}	2026-10-01	2026-10-01 21:15	2026-10-01 21:15
2f783a09-527c-455e-ac31-6c862f1c0873	2026-09-17 15:53	2026-09-17 15:53	2026-09-17 15:53	IYR	IYR261016C00100000	call	100.0000	2026-10-16	1.1000	1.1000	1.4500	98.0000	49783.00	0.00	49783.00	451	58	625	134	4.66417910447761	0.129035495706913	0.127210765767943	false	false
9d7d1ab5-172a-46f0-93f1-db413afb36b2	2026-09-10 15:15	2026-09-10 15:15	2026-09-10 15:15	IYR	IYR270115P00097000	put	97.0000	2027-01-15	2.6000	2.5500	2.6000	99.9050	54293.00	52751.00	1542.00	209	29	209	1754	0.119156214367161	0.189120919926881	0.189120919926881	true	false
4483b1e9-ed48-4bab-8a41-122f8344b610	2026-09-10 10:41	2026-09-10 10:41	2026-09-10 10:41	IYR	IYR260918P00102000	put	102.0000	2026-09-18	1.9400	1.9000	2.1000	100.9700	29143.00	0.00	29143.00	150	28	203	4979	0.0407712392046596	0.243555977300318	0.229720467126537	false	false
66adccea-190b-41f7-a8fe-e11295863226	2026-09-08 15:14	2026-09-08 15:14	2026-09-08 15:14	IYR	IYR260911C00103000	call	103.0000	2026-09-11	0.3500	0.2500	0.4000	102.4100	13980.00	12580.00	1365.00	400	49	417	30	13.9	0.158125342258082	0.158125342258082	false	false
21ae9dd3-e9a5-428a-8243-53e5b156e4b9	2026-08-28 10:24	2026-08-28 10:24	2026-08-28 10:24	IYR	IYR261016P00104000	put	104.0000	2026-10-16	2.2100	2.0000	2.4000	103.8950	44146.00	1760.00	16426.00	200	19	250	296	0.844594594594595	0.160155037340104	0.158831544097306	false	false