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.

326,449 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts326,449 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×ticker = RY×sorted by created_at ↑×

iduuid	created_at ↑timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expiry

fcdbd316-066b-4525-835d-5f590e8d61b5	2026-08-18 11:29	2026-08-18 11:29	2026-08-18 11:29	RY	RY261016C00220000	call	220.0000	2026-10-16	4.2000	4.0000	4.7000	212.9150	85320.00	5890.00	79430.00	203	23	261	439	0.594533029612756	0.192127164366458	0.193003496690791	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Financial Services	287354345944.00	2026-12-02	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-18T15:49:10.773359Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
cae230f3-be75-4d15-a5a0-91ec77158310	2026-08-27 10:22	2026-08-27 10:21	2026-08-27 10:21	RY	RY270115P00195000	put	195.0000	2027-01-15	7.2000	5.7000	8.5000	202.6500	180740.00	36730.00	90010.00	251	14	251	312	0.80448717948718	0.239554842845379	0.242485638842413	false	false	false	true
9e100b12-d86d-4c67-800e-f3d8d707e1dc	2026-09-02 09:59	2026-09-02 09:59	2026-09-02 09:59	RY	RY270115C00220000	call	220.0000	2027-01-15	5.8000	4.2000	6.2000	205.3000	71361.00	58000.00	13361.00	123	6	123	1874	0.0656350053361793	0.206398117028425	0.206613105985984	false	false	false	true
d78198fb-5448-423c-a5f5-c24732927c76	2026-09-03 14:16	2026-09-03 14:15	2026-09-03 14:15	RY	RY270115C00200000	call	200.0000	2027-01-15	19.0100	19.0000	19.2000	211.7500	95026.00	3826.00	91200.00	50	13	72	1853	0.0388559093362115	0.202663357777898	0.205784270246053	false	false	false	true