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.

231,528 rowsexport restricted — no row in this table may be redistributed

Sources in this table

uw_flow_alerts231,528 rowsrestricted — hover for the licence

created_at (ET days)to

column equals (exact text)

sort

chart against created_at

reset

active:alert_rule = RepeatedHitsDescendingFill×ticker = ALGN×

iduuid	created_at ↓timestamp with time zone	start_timetimestamp with time zone	end_timetimestamp with time zone	tickertext	option_symboltext	option_typetext	strikenumeric	expirydate	pricenumeric	bidnumeric	asknumeric	underlying_pricenumeric	total_premiumnumeric	total_ask_side_premnumeric	total_bid_side_premnumeric	total_sizebigint	trade_countinteger	volumebigint	open_interestbigint	volume_oi_rationumeric	iv_startnumeric	iv_endnumeric	has_sweepboolean	has_floorboolean	has_multilegboolean	has_singlelegboolean	all_opening_tradesboolean	alert_ruletext	rule_iduuid	expiry_countinteger	issue_typetext	sectortext	marketcapnumeric	next_earnings_datedate	er_timetext	missing_periscopeboolean	sourcetext	endpointtext	request_paramsjsonb	as_ofdate	vintage_tstimestamp with time zone	retrieved_attimestamp with time zone
c0ad8faf-60a3-45f6-8003-ec376abcb0f4	2026-09-09 12:50	2026-09-09 12:50	2026-09-09 12:50	ALGN	ALGN261218P00130000	put	130.0000	2026-12-18	4.9400	4.4000	8.3000	152.0000	14833.00	0.00	14833.00	30	6	77	59	1.30508474576271	0.471104524281614	0.471104524281614	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Healthcare	10869097356.00	2026-11-04	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
348858c2-7f22-49c7-8602-a30575caae51	2026-09-09 12:50	2026-09-09 12:50	2026-09-09 12:50	ALGN	ALGN261218P00130000	put	130.0000	2026-12-18	4.9900	4.4000	5.2000	152.0000	18966.00	18966.00	0.00	38	12	38	59	0.644067796610169	0.472470978934312	0.472470978934312	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Healthcare	10869097356.00	2026-11-04	unknown	true	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-09T17:13:29.226295Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
910cf565-ec72-4f67-9746-14480d6a24c0	2026-09-02 15:48	2026-09-02 15:48	2026-09-02 15:48	ALGN	ALGN261016C00180000	call	180.0000	2026-10-16	2.1500	1.4500	2.1500	157.8350	21497.00	21497.00	0.00	100	33	206	71	2.90140845070423	0.390832235242197	0.390832235242197	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Healthcare	10869097356.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-09-02T19:59:06.148248Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45
55e4022e-1b6b-49e0-8936-97d645893573	2026-08-20 14:38	2026-08-20 14:38	2026-08-20 14:38	ALGN	ALGN270115P00150000	put	150.0000	2027-01-15	12.4500	11.1000	12.5000	158.3200	13700.00	13700.00	0.00	11	5	11	373	0.0294906166219839	0.447539499526214	0.447539499526214	false	false	false	true	false	RepeatedHitsDescendingFill	5ce5ec11-087c-4c00-b164-08106b015856	1	Common Stock	Healthcare	10869097356.00	2026-11-04	unknown	—	uw_flow_alerts	/api/option-trades/flow-alerts	{"limit":500,"older_than":"2026-08-20T18:45:57.711481Z"}	2026-09-15	2026-09-15 08:45	2026-09-15 08:45