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.

425,429 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts425,429 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHits×ticker = LEGN×

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

265b7a07-f071-44ce-8aee-0efa23683255	2026-09-24 15:13	2026-09-24 15:13	2026-09-24 15:13	LEGN	LEGN270521C00020000	call	20.0000	2027-05-21	3.6100	3.5000	4.5000	18.9600	294436.00	0.00	294436.00	815	5	1270	0	0	0.635856974785338	0.644212725851452	false	false	false	true	false	RepeatedHits	e6b9f0b6-fcd9-44fe-9d1c-f53521c152c3	1	ADR	Healthcare	3412201745.00	2026-11-11	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-24T19:15:33.602136Z"}	2026-09-24	2026-09-24 21:15	2026-09-24 21:15
00a5c3d0-b9e1-493e-a4b3-1e9174855fcc	2026-09-24 15:13	2026-09-24 15:12	2026-09-24 15:12	LEGN	LEGN270521C00020000	call	20.0000	2027-05-21	3.8000	3.8000	5.4000	19.0800	83220.00	0.00	14820.00	219	7	219	0	0	0.645798904802808	0.645798904802808	false	false	false	true
e6231c27-b5d6-4b0b-98af-bcaa312addcf	2026-09-14 10:25	2026-09-14 10:25	2026-09-14 10:25	LEGN	LEGN261218C00022500	call	22.5000	2026-12-18	1.4500	1.4500	2.8000	18.0000	45095.00	0.00	45095.00	311	11	1279	1377	0.92883079157589	0.714503357030357	0.714503357030357	false	false	false	true
d6540c97-17e3-42f9-9a62-2cff0f81d497	2026-09-14 10:25	2026-09-14 10:25	2026-09-14 10:25	LEGN	LEGN261218C00022500	call	22.5000	2026-12-18	1.4500	0.7000	2.8500	18.0000	125860.00	89610.00	25375.00	868	26	968	1377	0.702977487291213	0.727324788335988	0.722087444725522	true	false	false	true
5b09408e-f7aa-4beb-8670-17d735117008	2026-09-02 15:48	2026-09-02 15:48	2026-09-02 15:48	LEGN	LEGN261016C00022500	call	22.5000	2026-10-16	1.5500	1.0000	1.7500	21.5350	11625.00	8835.00	2790.00	75	6	101	180	0.561111111111111	0.64227550084611	0.64227550084611	false	false	false	true
b1cdf01a-ad94-45ab-bb09-4a1a411dc76f	2026-08-25 10:42	2026-08-25 10:42	2026-08-25 10:42	LEGN	LEGN260918C00022500	call	22.5000	2026-09-18	0.8000	0.8000	1.2000	21.5900	20000.00	0.00	20000.00	250	6	470	909	0.517051705170517	0.523511508267387	0.523511508267387	false	false	false	true
bee03677-fe10-49fb-96b8-b8695d9ec15f	2026-08-18 14:44	2026-08-18 14:43	2026-08-18 14:43	LEGN	LEGN280121C00022500	call	22.5000	2028-01-21	5.9400	5.0000	7.7000	21.8100	23760.00	0.00	23760.00	40	5	102	355	0.287323943661972	0.559280462779626	0.559280462779626	false	false	false	true
46c3cd1b-4155-490b-889f-dde7e4a133ad	2026-08-18 14:42	2026-08-18 14:42	2026-08-18 14:42	LEGN	LEGN280121C00022500	call	22.5000	2028-01-21	5.9000	5.3000	6.8000	21.8200	17700.00	3540.00	14160.00	30	5	32	355	0.0901408450704225	0.554484134337584	0.554484134337584	false	false	false	true