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 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts728,802 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsAscendingFill×sector = Real Estate×ticker = FRMI×

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

3785beca-c89e-4654-96c0-8c67bc559c41	2026-10-02 11:47	2026-10-02 11:47	2026-10-02 11:47	FRMI	FRMI280121C00010000	call	10.0000	2028-01-21	0.8500	0.8500	0.9500	4.0000	17070.00	0.00	17070.00	200	13	241	12044	0.0200099634672866	0.994979170990484	0.994979170990484	false	false	false	true	false	RepeatedHitsAscendingFill	a0979b52-28e4-4585-8f22-881faad2dd8e	1	Common Stock	Real Estate	2581083412.00	2026-11-09	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-10-02T15:48:51.376292Z"}	2026-10-02	2026-10-02 21:15	2026-10-02 21:15
4a9ddcab-b5f4-4337-83fd-4666a7350868	2026-09-30 11:17	2026-09-30 11:17	2026-09-30 11:17	FRMI	FRMI261002C00004500	call	4.5000	2026-10-02	0.1800	0.1000	0.1500	4.3650	33570.00	0.00	0.00	1828	15	6149	759	8.10144927536232	1.67383020970607	2.00040736934621	false	false	false
a629eb2b-790e-428b-872e-9a9f6cdf6261	2026-09-28 15:42	2026-09-28 15:42	2026-09-28 15:42	FRMI	FRMI261120C00010000	call	10.0000	2026-11-20	0.0800	0.0500	0.1000	4.2400	13588.00	13504.00	84.00	1700	6	1716	22581	0.075993091537133	1.36516332051962	1.36516332051962	false	false	false
0303bdfc-0655-4e0c-b428-bd510a222f93	2026-09-15 14:51	2026-09-15 14:51	2026-09-15 14:51	FRMI	FRMI261120C00006000	call	6.0000	2026-11-20	0.5300	0.5000	0.5500	4.7050	13104.00	13104.00	0.00	245	6	954	10011	0.0952951753071621	1.16457153463856	1.16457153463856	false	false	false
14905f21-4e1d-4cac-b500-48c2c6ea7aa5	2026-09-08 12:02	2026-09-08 12:01	2026-09-08 12:01	FRMI	FRMI261016C00005000	call	5.0000	2026-10-16	1.1600	1.1500	1.3000	5.7900	18025.00	0.00	18025.00	155	7	263	915	0.287431693989071	0.970681710625158	1.03601433585135	false	false	false
1e9113e8-3e49-4f87-a1b9-7167447ee5cd	2026-09-02 11:25	2026-09-02 11:25	2026-09-02 11:25	FRMI	FRMI280121C00022000	call	22.0000	2028-01-21	0.5500	0.5500	0.6000	4.5350	52703.00	58.00	52645.00	958	33	960	11603	0.0827372231319486	1.04578928754831	1.04578928754831	true	false	false
993b7a18-c942-43b4-ba0c-f7e7a5f3cacb	2026-09-01 15:52	2026-09-01 15:52	2026-09-01 15:52	FRMI	FRMI261002P00004500	put	4.5000	2026-10-02	0.4500	0.4000	0.5000	4.6150	24918.00	3228.00	9000.00	556	11	1445	316	4.57278481012658	0.932710473709865	0.971084165777245	false	false	false
c5bd4fc9-fe73-4323-baca-67c6108fe22c	2026-08-27 14:41	2026-08-27 14:41	2026-08-27 14:41	FRMI	FRMI270219C00010000	call	10.0000	2027-02-19	0.7700	0.7000	0.8000	5.4600	77289.00	77289.00	0.00	1000	35	1017	752	1.35239361702128	1.1479002363209	1.18269283511126	true	false	false
80fc95cf-32f7-46a7-8204-5cfed0b101d3	2026-08-25 10:10	2026-08-25 10:10	2026-08-25 10:10	FRMI	FRMI261016C00007000	call	7.0000	2026-10-16	0.5100	0.5000	0.6500	5.7200	20213.00	0.00	20213.00	400	9	424	3885	0.109137709137709	1.0562351175405	1.07067003819261	false	false	false
221c0985-341d-4918-ba8d-9c86b632535d	2026-08-19 13:15	2026-08-19 13:15	2026-08-19 13:15	FRMI	FRMI280121C00020000	call	20.0000	2028-01-21	1.1300	1.0500	1.1500	5.6800	11282.00	11282.00	0.00	100	6	304	2832	0.107344632768362	1.08190759331043	1.08190759331043	false	false	false